Setting up multiple LOVs using a switcher attribute

Enabling LOVs for view object attributes greatly simplifies the effort involved in utilizing list controls in the frontend user interface. LOV-enabling a view object attribute is a straightforward task, done declaratively in JDeveloper. Moreover, the ADF-BC framework allows you to define multiple LOVs for the same attribute. In this case, in order to differentiate among the LOVs, a separate attribute called a LOV switcher is used. The differentiation is usually done based on some data value. The advantage of using this technique is that you can define a single LOV component in your UI page and then vary its contents based on a certain condition, such as the value of the switcher attribute.

This recipe shows how to enable multiple LOVs for a view object attribute and how to use an LOV switcher to switch among the LOVs. For example, depending on the employee's job we will associate a different LOV to an Employees view object transient attribute...