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_MC_PATH_POSITION_PVT dependencies on AHL_APPLICABLE_INSTANCES

Line 427: -- into AHL_APPLICABLE_INSTANCES

423: -- Start of Comments --
424: -- Procedure name : Map_Instance_To_Positions
425: -- Type : Private
426: -- Function : Writes a list of positions that maps to instance
427: -- into AHL_APPLICABLE_INSTANCES
428: -- Pre-reqs :
429: -- Parameters :
430: --
431: -- Map_Instance_To_Positions Parameters:

Line 576: INSERT INTO AHL_APPLICABLE_INSTANCES (csi_item_instance_id,

572: OPEN get_matching_pos_csr(l_encoded_path, l_path_tbl.COUNT);
573: LOOP
574: FETCH get_matching_pos_csr INTO l_position_id;
575: EXIT WHEN get_matching_pos_csr%NOTFOUND;
576: INSERT INTO AHL_APPLICABLE_INSTANCES (csi_item_instance_id,
577: position_id)
578: VALUES (p_csi_item_instance_id, l_position_id);
579: END LOOP;
580: CLOSE get_matching_pos_csr;

Line 595: INSERT INTO AHL_APPLICABLE_INSTANCES (csi_item_instance_id,

591: OPEN get_matching_pos_csr(l_encoded_path, l_path_tbl.COUNT);
592: LOOP
593: FETCH get_matching_pos_csr INTO l_position_id;
594: EXIT WHEN get_matching_pos_csr%NOTFOUND;
595: INSERT INTO AHL_APPLICABLE_INSTANCES (csi_item_instance_id,
596: position_id)
597: VALUES (p_csi_item_instance_id, l_position_id);
598: END LOOP;
599: CLOSE get_matching_pos_csr;

Line 629: INSERT INTO AHL_APPLICABLE_INSTANCES (csi_item_instance_id,

625: OPEN get_matching_pos_csr(l_encoded_path, l_path_tbl.COUNT);
626: LOOP
627: FETCH get_matching_pos_csr INTO l_position_id;
628: EXIT WHEN get_matching_pos_csr%NOTFOUND;
629: INSERT INTO AHL_APPLICABLE_INSTANCES (csi_item_instance_id,
630: position_id)
631: VALUES (p_csi_item_instance_id, l_position_id);
632: END LOOP;
633: CLOSE get_matching_pos_csr;

Line 653: INSERT INTO AHL_APPLICABLE_INSTANCES (csi_item_instance_id, position_id)

649: OPEN get_matching_pos_csr(l_encoded_path, l_mc_path_tbl.COUNT);
650: LOOP
651: FETCH get_matching_pos_csr INTO l_position_id;
652: EXIT WHEN get_matching_pos_csr%NOTFOUND;
653: INSERT INTO AHL_APPLICABLE_INSTANCES (csi_item_instance_id, position_id)
654: VALUES (p_csi_item_instance_id, l_position_id);
655: END LOOP;
656: CLOSE get_matching_pos_csr;
657: END IF;

Line 700: --into AHL_APPLICABLE_INSTANCES

696: -- Start of Comments --
697: -- Procedure name : Map_Position_To_Instance
698: -- Type : Private
699: -- Function : Writes a list of instances that maps to position path
700: --into AHL_APPLICABLE_INSTANCES
701: -- Pre-reqs :
702: -- Parameters :
703: --
704: -- Map_Position_To_Instances Parameters:

Line 854: v_Stmt := 'INSERT INTO AHL_APPLICABLE_INSTANCES '||

850: fnd_log.string(fnd_log.level_statement,l_full_name,'-- v_Where -2-'||v_Where);
851: END IF;
852:
853: IF (l_top_flag) THEN
854: v_Stmt := 'INSERT INTO AHL_APPLICABLE_INSTANCES '||
855: ' SELECT uch.csi_instance_id ,'|| p_position_id ||
856: ' FROM AHL_UC_HEADER_PATHS_V uch '||
857: ' WHERE uch.position_key = :pos_key'||l_path_tbl.LAST
858: ||' AND uch.csi_instance_id in ( '

Line 862: v_Stmt := 'INSERT INTO AHL_APPLICABLE_INSTANCES '||

858: ||' AND uch.csi_instance_id in ( '
859: || v_Select || v_From || v_Where || ' ) ';
860:
861: ELSE
862: v_Stmt := 'INSERT INTO AHL_APPLICABLE_INSTANCES '||
863: ' SELECT csi_ii.subject_id ,'|| p_position_id ||
864: ' FROM ahl_mc_relationships rel, csi_ii_relationships csi_ii '||
865: ' WHERE TO_NUMBER(CSI_II.POSITION_REFERENCE)=REL.RELATIONSHIP_ID '
866: ||' AND REL.position_key = :pos_key'||l_path_tbl.LAST