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 418: -- into AHL_APPLICABLE_INSTANCES

414: -- Start of Comments --
415: -- Procedure name : Map_Instance_To_Positions
416: -- Type : Private
417: -- Function : Writes a list of positions that maps to instance
418: -- into AHL_APPLICABLE_INSTANCES
419: -- Pre-reqs :
420: -- Parameters :
421: --
422: -- Map_Instance_To_Positions Parameters:

Line 544: INSERT INTO AHL_APPLICABLE_INSTANCES (csi_item_instance_id,

540: OPEN get_matching_pos_csr(l_encoded_path, l_path_tbl.COUNT);
541: LOOP
542: FETCH get_matching_pos_csr INTO l_position_id;
543: EXIT WHEN get_matching_pos_csr%NOTFOUND;
544: INSERT INTO AHL_APPLICABLE_INSTANCES (csi_item_instance_id,
545: position_id)
546: VALUES (p_csi_item_instance_id, l_position_id);
547: END LOOP;
548: CLOSE get_matching_pos_csr;

Line 563: INSERT INTO AHL_APPLICABLE_INSTANCES (csi_item_instance_id,

559: OPEN get_matching_pos_csr(l_encoded_path, l_path_tbl.COUNT);
560: LOOP
561: FETCH get_matching_pos_csr INTO l_position_id;
562: EXIT WHEN get_matching_pos_csr%NOTFOUND;
563: INSERT INTO AHL_APPLICABLE_INSTANCES (csi_item_instance_id,
564: position_id)
565: VALUES (p_csi_item_instance_id, l_position_id);
566: END LOOP;
567: CLOSE get_matching_pos_csr;

Line 597: INSERT INTO AHL_APPLICABLE_INSTANCES (csi_item_instance_id,

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

Line 646: --into AHL_APPLICABLE_INSTANCES

642: -- Start of Comments --
643: -- Procedure name : Map_Position_To_Instance
644: -- Type : Private
645: -- Function : Writes a list of instances that maps to position path
646: --into AHL_APPLICABLE_INSTANCES
647: -- Pre-reqs :
648: -- Parameters :
649: --
650: -- Map_Position_To_Instances Parameters:

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

796: fnd_log.string(fnd_log.level_statement,l_full_name,'-- v_Where -2-'||v_Where);
797: END IF;
798:
799: IF (l_top_flag) THEN
800: v_Stmt := 'INSERT INTO AHL_APPLICABLE_INSTANCES '||
801: ' SELECT uch.csi_instance_id ,'|| p_position_id ||
802: ' FROM AHL_UC_HEADER_PATHS_V uch '||
803: ' WHERE uch.position_key = :pos_key'||l_path_tbl.LAST
804: ||' AND uch.csi_instance_id in ( '

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

804: ||' AND uch.csi_instance_id in ( '
805: || v_Select || v_From || v_Where || ' ) ';
806:
807: ELSE
808: v_Stmt := 'INSERT INTO AHL_APPLICABLE_INSTANCES '||
809: ' SELECT csi_ii.subject_id ,'|| p_position_id ||
810: ' FROM ahl_mc_relationships rel, csi_ii_relationships csi_ii '||
811: ' WHERE TO_NUMBER(CSI_II.POSITION_REFERENCE)=REL.RELATIONSHIP_ID '
812: ||' AND REL.position_key = :pos_key'||l_path_tbl.LAST