DBA Data[Home] [Help]

APPS.AZ_R12_TRANSFORM_CASCADE dependencies on AZ_API_DEPENDENCY_ATTRIBUTES

Line 188: FROM AZ_API_DEPENDENCY_ATTRIBUTES

184: P_REQUIRED_API_CODE);
185: --Introduced to take care of one-many mappings between mapped attributes
186: SELECT REQUIRED_API_ATTRIBUTE, DEPENDANT_API_ATTRIBUTE BULK COLLECT
187: INTO V_REQ_API_MAP_ATTR_NAME_LIST, V_DEP_API_MAP_ATTR_NAME_LIST
188: FROM AZ_API_DEPENDENCY_ATTRIBUTES
189: WHERE REQUIRED_API_CODE = P_REQUIRED_API_CODE
190: AND DEPENDANT_API_CODE = P_DEPENDANT_API_CODE;
191:
192: --Introduced to take care of one-many mappings between mapped attributes

Line 736: FROM AZ_API_DEPENDENCY_ATTRIBUTES

732: BEGIN
733:
734: SELECT REQUIRED_API_ATTRIBUTE, DEPENDANT_API_ATTRIBUTE BULK COLLECT
735: INTO V_REQ_API_ATTR_LIST, V_DEP_API_ATTR_LIST
736: FROM AZ_API_DEPENDENCY_ATTRIBUTES
737: WHERE REQUIRED_API_CODE = P_REQUIRED_API_CODE
738: AND DEPENDANT_API_CODE = P_DEPENDANT_API_CODE;
739:
740: FOR I IN 1 .. V_REQ_API_ATTR_LIST.COUNT LOOP

Line 1024: FROM AZ_API_DEPENDENCY_ATTRIBUTES

1020:
1021: --Introduced to take care of one-many mappings between mapped attributes
1022: SELECT REQUIRED_API_ATTRIBUTE, DEPENDANT_API_ATTRIBUTE BULK COLLECT
1023: INTO V_REQ_API_MAP_ATTR_NAME_LIST, V_DEP_API_MAP_ATTR_NAME_LIST
1024: FROM AZ_API_DEPENDENCY_ATTRIBUTES
1025: WHERE REQUIRED_API_CODE = v_parent_api_code
1026: AND DEPENDANT_API_CODE = v_current_api_code;
1027:
1028: