eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_DEPENDENCY_UTIL dependencies on ASO_DEPENDENCY_MAPPINGS

Line 457: /* Get min(TRIGGER_ATTRIBUTE_ID) from ASO_DEPENDENCY_MAPPINGS */

453:
454: l_min_attr_id NUMBER;
455: BEGIN
456:
457: /* Get min(TRIGGER_ATTRIBUTE_ID) from ASO_DEPENDENCY_MAPPINGS */
458:
459: OPEN get_min_attr_id;
460: FETCH get_min_attr_id INTO l_min_attr_id;
461: CLOSE get_min_attr_id;

Line 476: FROM aso_dependency_mappings

472: IS
473:
474: CURSOR get_dep_attr_num IS
475: SELECT count(distinct dependent_attribute_id)
476: FROM aso_dependency_mappings
477: WHERE database_object_name = p_database_object_name;
478:
479: l_dep_attr_count NUMBER;
480:

Line 483: /* Get distinct(DEPENDENT_ATTRIBUTE_ID) from ASO_DEPENDENCY_MAPPINGS */

479: l_dep_attr_count NUMBER;
480:
481: BEGIN
482:
483: /* Get distinct(DEPENDENT_ATTRIBUTE_ID) from ASO_DEPENDENCY_MAPPINGS */
484:
485: OPEN get_dep_attr_num;
486: FETCH get_dep_attr_num INTO l_dep_attr_count;
487: CLOSE get_dep_attr_num;

Line 508: FROM ASO_DEPENDENCY_MAPPINGS a,oe_ak_obj_attr_ext b

504: l_dep_attr_tbl Number_Tbl_Type;
505:
506: CURSOR c_trigger_attributes IS
507: SELECT DISTINCT a.trigger_attribute_id,b.attribute_code
508: FROM ASO_DEPENDENCY_MAPPINGS a,oe_ak_obj_attr_ext b
509: WHERE a.trigger_attribute_id = b.attribute_id
510: AND a.database_object_name = p_database_object_name;
511:
512: CURSOR c_dependent_attributes(lc_trigger_attribute_id NUMBER) IS

Line 514: FROM ASO_DEPENDENCY_MAPPINGS a,oe_ak_obj_attr_ext b

510: AND a.database_object_name = p_database_object_name;
511:
512: CURSOR c_dependent_attributes(lc_trigger_attribute_id NUMBER) IS
513: SELECT a.dependent_attribute_id,b.attribute_code
514: FROM ASO_DEPENDENCY_MAPPINGS a,oe_ak_obj_attr_ext b
515: WHERE a.dependent_attribute_id = b.attribute_id
516: AND a.trigger_attribute_id = lc_trigger_attribute_id
517: AND a.enabled_flag = 'Y';
518: BEGIN

Line 625: FROM oe_ak_obj_attr_ext a, ASO_DEPENDENCY_MAPPINGS b, ak_object_attributes c

621: l_dependent_code VARCHAR2(30);
622:
623: CURSOR c_trigger_attribute IS
624: SELECT DISTINCT a.attribute_code, a.attribute_id, c.column_name
625: FROM oe_ak_obj_attr_ext a, ASO_DEPENDENCY_MAPPINGS b, ak_object_attributes c
626: WHERE b.TRIGGER_ATTRIBUTE_ID = a.attribute_id
627: AND a.attribute_application_id = G_APPLICATION_ID
628: AND a.database_object_name = p_database_object_name
629: AND b.enabled_flag = 'Y'

Line 636: FROM oe_ak_obj_attr_ext a, ASO_DEPENDENCY_MAPPINGS b, ak_object_attributes c

632: AND a.attribute_application_id = c.attribute_application_id;
633:
634: CURSOR c_all_trigger_attribute IS
635: SELECT DISTINCT a.attribute_code, a.attribute_id, c.column_name
636: FROM oe_ak_obj_attr_ext a, ASO_DEPENDENCY_MAPPINGS b, ak_object_attributes c
637: WHERE b.TRIGGER_ATTRIBUTE_ID = a.attribute_id
638: AND a.attribute_application_id = G_APPLICATION_ID
639: AND a.database_object_name = p_database_object_name
640: AND a.database_object_name = c.database_object_name