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.AHL_PRD_BLK_PARTS_CHANGE_PVT dependencies on AHL_CONFIG_COMPONENTS

Line 2560: from AHL_CONFIG_COMPONENTS A1 where root_object_id = -1

2556: X_INSTANCE_TBL OUT NOCOPY INSTANCE_TBL_TYPE) IS
2557:
2558: CURSOR removed_instances_csr IS
2559: select object_id, subject_id, root_object_id
2560: from AHL_CONFIG_COMPONENTS A1 where root_object_id = -1
2561: start with A1.object_id IN (select A2.object_id from AHL_CONFIG_COMPONENTS A2 where not exists(
2562: select 'x' from AHL_CONFIG_COMPONENTS A3 where A3.subject_id = A2.object_id and root_object_id = -1)
2563: )
2564: AND root_object_id = -1

Line 2561: start with A1.object_id IN (select A2.object_id from AHL_CONFIG_COMPONENTS A2 where not exists(

2557:
2558: CURSOR removed_instances_csr IS
2559: select object_id, subject_id, root_object_id
2560: from AHL_CONFIG_COMPONENTS A1 where root_object_id = -1
2561: start with A1.object_id IN (select A2.object_id from AHL_CONFIG_COMPONENTS A2 where not exists(
2562: select 'x' from AHL_CONFIG_COMPONENTS A3 where A3.subject_id = A2.object_id and root_object_id = -1)
2563: )
2564: AND root_object_id = -1
2565: connect by prior subject_id = object_id

Line 2562: select 'x' from AHL_CONFIG_COMPONENTS A3 where A3.subject_id = A2.object_id and root_object_id = -1)

2558: CURSOR removed_instances_csr IS
2559: select object_id, subject_id, root_object_id
2560: from AHL_CONFIG_COMPONENTS A1 where root_object_id = -1
2561: start with A1.object_id IN (select A2.object_id from AHL_CONFIG_COMPONENTS A2 where not exists(
2562: select 'x' from AHL_CONFIG_COMPONENTS A3 where A3.subject_id = A2.object_id and root_object_id = -1)
2563: )
2564: AND root_object_id = -1
2565: connect by prior subject_id = object_id
2566: order by level desc;

Line 2570: from AHL_CONFIG_COMPONENTS A1 where root_object_id = -2

2566: order by level desc;
2567:
2568: CURSOR installed_instances_csr IS
2569: select object_id, subject_id, root_object_id
2570: from AHL_CONFIG_COMPONENTS A1 where root_object_id = -2
2571: start with A1.object_id IN (select A2.object_id from AHL_CONFIG_COMPONENTS A2 where not exists(
2572: select 'x' from AHL_CONFIG_COMPONENTS A3 where A3.subject_id = A2.object_id and root_object_id = -2)
2573: )
2574: AND root_object_id = -2

Line 2571: start with A1.object_id IN (select A2.object_id from AHL_CONFIG_COMPONENTS A2 where not exists(

2567:
2568: CURSOR installed_instances_csr IS
2569: select object_id, subject_id, root_object_id
2570: from AHL_CONFIG_COMPONENTS A1 where root_object_id = -2
2571: start with A1.object_id IN (select A2.object_id from AHL_CONFIG_COMPONENTS A2 where not exists(
2572: select 'x' from AHL_CONFIG_COMPONENTS A3 where A3.subject_id = A2.object_id and root_object_id = -2)
2573: )
2574: AND root_object_id = -2
2575: connect by prior subject_id = object_id

Line 2572: select 'x' from AHL_CONFIG_COMPONENTS A3 where A3.subject_id = A2.object_id and root_object_id = -2)

2568: CURSOR installed_instances_csr IS
2569: select object_id, subject_id, root_object_id
2570: from AHL_CONFIG_COMPONENTS A1 where root_object_id = -2
2571: start with A1.object_id IN (select A2.object_id from AHL_CONFIG_COMPONENTS A2 where not exists(
2572: select 'x' from AHL_CONFIG_COMPONENTS A3 where A3.subject_id = A2.object_id and root_object_id = -2)
2573: )
2574: AND root_object_id = -2
2575: connect by prior subject_id = object_id
2576: order by level asc;

Line 2586: DELETE AHL_CONFIG_COMPONENTS;

2582:
2583: BEGIN
2584: l_has_removed_instances := FALSE;
2585: l_has_installed_instances := FALSE;
2586: DELETE AHL_CONFIG_COMPONENTS;
2587: FOR i IN P_PARTS_REC_TBL.FIRST..P_PARTS_REC_TBL.LAST LOOP
2588: IF(P_PARTS_REC_TBL(i).OPERATION_TYPE = 'D')THEN
2589: l_has_removed_instances := TRUE;
2590: INSERT INTO ahl_config_components (object_id, subject_id, root_object_id)

Line 2590: INSERT INTO ahl_config_components (object_id, subject_id, root_object_id)

2586: DELETE AHL_CONFIG_COMPONENTS;
2587: FOR i IN P_PARTS_REC_TBL.FIRST..P_PARTS_REC_TBL.LAST LOOP
2588: IF(P_PARTS_REC_TBL(i).OPERATION_TYPE = 'D')THEN
2589: l_has_removed_instances := TRUE;
2590: INSERT INTO ahl_config_components (object_id, subject_id, root_object_id)
2591: VALUES (P_PARTS_REC_TBL(i).PARENT_INSTALLED_INSTANCE_NUM,P_PARTS_REC_TBL(i).REMOVED_INSTANCE_NUM,-1);
2592: ELSIF(P_PARTS_REC_TBL(i).OPERATION_TYPE = 'C')THEN
2593: l_has_installed_instances := TRUE;
2594: INSERT INTO ahl_config_components (object_id, subject_id, root_object_id)

Line 2594: INSERT INTO ahl_config_components (object_id, subject_id, root_object_id)

2590: INSERT INTO ahl_config_components (object_id, subject_id, root_object_id)
2591: VALUES (P_PARTS_REC_TBL(i).PARENT_INSTALLED_INSTANCE_NUM,P_PARTS_REC_TBL(i).REMOVED_INSTANCE_NUM,-1);
2592: ELSIF(P_PARTS_REC_TBL(i).OPERATION_TYPE = 'C')THEN
2593: l_has_installed_instances := TRUE;
2594: INSERT INTO ahl_config_components (object_id, subject_id, root_object_id)
2595: VALUES (P_PARTS_REC_TBL(i).PARENT_INSTALLED_INSTANCE_NUM,P_PARTS_REC_TBL(i).INSTALLED_INSTANCE_NUM,-2);
2596: END IF;
2597: END LOOP;
2598: j :=0;