Hello. Thanks! Your post was really helpful!
I have a question. In my application there is LOV item with the option 'Search as you type' selected. I have a button (disabled) to add a new entry, I would like this button to be enable when the result of the search returns no value. I've tried with JS and with DA, but I couldn't achieve this behavior. Do you have any idea how can I do that?
How to add a new value to the table if the value is not exist?
Jochen Zehe
Improvement 2: Ability to pass in parameters from the calling page.
Jon Dixon You could use Source Type = "Function Returning SQL" instead of a SQL Query.
return lov.get_emp_list ('P' || :APP_PAGE_ID || '_DEPT_ID');"