APPS.AHL_UMP_UTIL_PKG dependencies on AHL_APPLICABLE_MR_RELNS

Line 725: DELETE FROM AHL_APPLICABLE_MR_RELNS;

721: --
722: BEGIN
723:
724: -- Initialize temporary table.
725: DELETE FROM AHL_APPLICABLE_MR_RELNS;
726:
727: OPEN ahl_applicable_mrs_csr;
728: LOOP
729: FETCH ahl_applicable_mrs_csr INTO l_mr_header_id,

Line 969: FROM ahl_applicable_mr_relns

965: CURSOR ahl_appl_mrs_csr(p_mr_id IN NUMBER,
966: p_item_instance_id IN NUMBER) IS
967: SELECT level depth_level, mr_header_id, csi_item_instance_id,
968: related_mr_header_id, related_csi_item_instance_id
969: FROM ahl_applicable_mr_relns
970: --WHERE orig_mr_header_id = p_mr_id
971: --AND orig_csi_item_instance_id = p_item_instance_id
972: START WITH mr_header_id = p_mr_id
973: AND csi_item_instance_id = p_item_instance_id

Line 989: FROM ahl_applicable_mr_relns

985: p_related_item_instance_id IN NUMBER,
986: p_orig_mr_id IN NUMBER,
987: p_orig_item_instance_id IN NUMBER) IS
988: SELECT NVL(tree_depth_level, 0)
989: FROM ahl_applicable_mr_relns
990: WHERE orig_mr_header_id = p_orig_mr_id
991: AND orig_csi_item_instance_id = p_orig_item_instance_id
992: AND mr_header_id = p_mr_id
993: AND csi_item_instance_id = p_item_instance_id

Line 1000: FROM ahl_applicable_mr_relns

996: --
997: CURSOR ahl_duplicate_relns_csr(p_mr_id IN NUMBER,
998: p_item_instance_id IN NUMBER) IS
999: SELECT related_mr_header_id, related_csi_item_instance_id
1000: FROM ahl_applicable_mr_relns
1001: WHERE orig_mr_header_id = p_mr_id
1002: AND orig_csi_item_instance_id = p_item_instance_id
1003: GROUP BY related_mr_header_id, related_csi_item_instance_id
1004: HAVING COUNT(*)>1;

Line 1011: FROM ahl_applicable_mr_relns

1007: p_item_instance_id IN NUMBER,
1008: p_orig_mr_id IN NUMBER,
1009: p_orig_item_instance_id IN NUMBER) IS
1010: SELECT mr_header_id, csi_item_instance_id
1011: FROM ahl_applicable_mr_relns
1012: WHERE tree_depth_level = (SELECT max(tree_depth_level)
1013: from ahl_applicable_mr_relns
1014: where orig_mr_header_id = p_orig_mr_id
1015: AND orig_csi_item_instance_id = p_orig_item_instance_id

Line 1013: from ahl_applicable_mr_relns

1009: p_orig_item_instance_id IN NUMBER) IS
1010: SELECT mr_header_id, csi_item_instance_id
1011: FROM ahl_applicable_mr_relns
1012: WHERE tree_depth_level = (SELECT max(tree_depth_level)
1013: from ahl_applicable_mr_relns
1014: where orig_mr_header_id = p_orig_mr_id
1015: AND orig_csi_item_instance_id = p_orig_item_instance_id
1016: AND related_mr_header_id = p_mr_id
1017: AND related_csi_item_instance_id=p_item_instance_id)

Line 1050: DELETE FROM AHL_APPLICABLE_MR_RELNS;

1046: BEGIN
1047:
1048: -- Initialize temporary table.
1049: IF (p_init_temp_table = 'Y') THEN
1050: DELETE FROM AHL_APPLICABLE_MR_RELNS;
1051:
1052: -- Populate config temp table.
1053: -- fix for perf bug# 9434441
1054: Populate_Config_Components (p_top_item_instance_id);

Line 1064: --And populate the ahl_applicable_mr_relns table

1060:
1061:
1062: --dbms_output.put_line(l_orig_mr_id||'::'||l_orig_ii_id);
1063: --Now fetch all relations into l_mr_relns_tbl
1064: --And populate the ahl_applicable_mr_relns table
1065: OPEN ahl_fmp_relationships_csr(l_orig_mr_id);
1066: LOOP
1067: --FETCH ahl_fmp_relationships_csr INTO l_mr_header_id,
1068: -- l_related_mr_header_id,

Line 1112: INSERT INTO AHL_APPLICABLE_MR_RELNS (

1108:
1109: IF (l_related_csi_ii_tbl.count > 0) THEN
1110:
1111: FORALL k IN l_related_csi_ii_tbl.FIRST..l_related_csi_ii_tbl.LAST
1112: INSERT INTO AHL_APPLICABLE_MR_RELNS (
1113: MR_HEADER_ID,
1114: CSI_ITEM_INSTANCE_ID,
1115: RELATED_MR_HEADER_ID,
1116: RELATED_CSI_ITEM_INSTANCE_ID,

Line 1165: UPDATE ahl_applicable_mr_relns

1161:
1162: IF (ahl_get_depth_level_csr%FOUND) THEN
1163: --If depth is greater in rec, update to new depth
1164: IF (l_depth_level < l_appl_mr_relns_rec.depth_level) THEN
1165: UPDATE ahl_applicable_mr_relns
1166: SET tree_depth_level = l_appl_mr_relns_rec.depth_level
1167: WHERE orig_mr_header_id = l_orig_mr_id
1168: AND orig_csi_item_instance_id = l_orig_ii_id
1169: AND mr_header_id = l_appl_mr_relns_rec.mr_header_id

Line 1180: DELETE FROM ahl_applicable_mr_relns

1176: END LOOP;
1177: CLOSE ahl_appl_mrs_csr;
1178:
1179: --Now delete all rows with null depth (unreachable)
1180: DELETE FROM ahl_applicable_mr_relns
1181: WHERE tree_depth_level IS NULL
1182: AND orig_mr_header_id = l_orig_mr_id
1183: AND orig_csi_item_instance_id = l_orig_ii_id;
1184:

Line 1198: DELETE FROM ahl_applicable_mr_relns

1194: l_orig_ii_id);
1195: FETCH ahl_max_depth_reln_csr INTO l_mr_header_id, l_csi_ii_id;
1196: IF (ahl_max_depth_reln_csr%FOUND) THEN
1197: --Delete all rows != edge with maximum depth
1198: DELETE FROM ahl_applicable_mr_relns
1199: WHERE (mr_header_id <> l_mr_header_id
1200: OR csi_item_instance_id <> l_csi_ii_id)
1201: AND orig_mr_header_id = l_orig_mr_id
1202: AND orig_csi_item_instance_id = l_orig_ii_id