OAF LOV Dependence

Lov Dependences

              MainRN --           Id : MainRN

                                       Region Style : pageLayout

                                       AM Definiton: Add that page location

                                       Windows title & title : same to display the page and load url

             MessageLayoutRN --        Id : MessageLayoutRN

                                                    Region Style : Message Component Layout

• Right click on message layout region and select “Message layout lov input region”
• We have to take two message layout lov input regions
• If you want attribute from out side take one vo and the querry is created to asking the attribute like (select empno from emp where empno = :1).
• Then you take one form value and assign the outside attribute to created form value using view instance and view attribute.
• In the message layout lov input region under one item
• In the item under one region and one lovmappings
• Region using table region wizard and getting the columns in table using vo
• Lovmapping based on columns take love maps 
• Each map lov region item assign the column name
• First map assign return item and criteria item giving to main item name.
• Second and remaing maps only giving to criteria item only.
• In the second message layout lov input region giving to same but the second lovmapping criteria item giving to first item colum based form valu name.

Code for co:

        if("ItemName".equals(pageContext.getLovInputSourceId())){ 

                      am.invokeMethod("xxipGetItems");

                  }

Code for AMIMPL:

    public void xxxGetItems(){

        LOVVOImpl vo = getLOVVO1();

        try{

            vo.clearCache();

            vo.setWhereClause(null);

            vo.setWhereClauseParams(null);

            vo.executeQuery();

        }

        catch(Exception e){

            throw OAException.wrapperException(e);

         }

    }