APPS.AHL_MC_MASTERCONFIG_PVT dependencies on AHL_MC_RELATIONSHIPS

Line 279: -- 9. Select next value from the AHL_MC_RELATIONSHIPS_S sequence

275: 'Header ['||p_x_mc_header_rec.mc_header_id||'] created'
276: );
277: END IF;
278:
279: -- 9. Select next value from the AHL_MC_RELATIONSHIPS_S sequence
280: SELECT ahl_mc_relationships_s.nextval INTO p_x_node_rec.relationship_id FROM dual;
281:
282: -- 10. Set values for p_x_node_rec
283: p_x_node_rec.mc_header_id := p_x_mc_header_rec.mc_header_id;

Line 280: SELECT ahl_mc_relationships_s.nextval INTO p_x_node_rec.relationship_id FROM dual;

276: );
277: END IF;
278:
279: -- 9. Select next value from the AHL_MC_RELATIONSHIPS_S sequence
280: SELECT ahl_mc_relationships_s.nextval INTO p_x_node_rec.relationship_id FROM dual;
281:
282: -- 10. Set values for p_x_node_rec
283: p_x_node_rec.mc_header_id := p_x_mc_header_rec.mc_header_id;
284: p_x_node_rec.parent_relationship_id := null;

Line 863: FROM ahl_mc_relationships

859: p_mc_header_id in number
860: )
861: IS
862: SELECT relationship_id, object_version_number
863: FROM ahl_mc_relationships
864: WHERE mc_header_id = p_mc_header_id AND
865: parent_relationship_id IS NULL;
866:
867: -- Define cursor check_unit_assigned to verify whether there are any units

Line 881: FROM ahl_mc_relationships mcr, ahl_unit_config_headers uch

877: trunc(nvl(active_end_date, G_SYSDATE + 1)) > G_TRUNC_DATE;
878:
879: /*
880: SELECT 'x'
881: FROM ahl_mc_relationships mcr, ahl_unit_config_headers uch
882: WHERE mcr.mc_header_id = p_mc_header_id AND
883: mcr.parent_relationship_id IS NULL AND
884: uch.master_config_id = mcr.relationship_id AND
885: trunc(nvl(uch.active_end_date, G_SYSDATE + 1)) > G_TRUNC_DATE;

Line 1140: UPDATE ahl_mc_relationships

1136: FETCH get_mc_topnode_details INTO l_topnode_rel_id, l_topnode_object_ver_num;
1137: CLOSE get_mc_topnode_details;
1138:
1139: -- 7c. Update the active_end_date of the topnode of the MC with MC_HEADER_ID = p_mc_header_id
1140: UPDATE ahl_mc_relationships
1141: SET active_end_date = G_TRUNC_DATE,
1142: object_version_number = l_topnode_object_ver_num + 1,
1143: last_update_date = G_SYSDATE,
1144: last_updated_by = G_USER_ID,

Line 1642: FROM AHL_MC_RELATIONSHIPS_V

1638: ATTRIBUTE12,
1639: ATTRIBUTE13,
1640: ATTRIBUTE14,
1641: ATTRIBUTE15
1642: FROM AHL_MC_RELATIONSHIPS_V
1643: WHERE MC_HEADER_ID = p_mc_header_id AND
1644: PARENT_RELATIONSHIP_ID IS NULL;
1645:
1646: -- Define cursor check_latest_rev to validate latest revision of MC being used for copying

Line 2089: ahl_mc_relationships mcr

2085: mcr.relationship_id,
2086: mcr.object_version_number,
2087: mcr.item_group_id
2088: FROM ahl_mc_headers_v mch,
2089: ahl_mc_relationships mcr
2090: WHERE mch.mc_header_id = p_mc_header_id AND
2091: mch.mc_header_id = mcr.mc_header_id AND
2092: mcr.parent_relationship_id IS NULL;
2093:

Line 2101: FROM ahl_mc_relationships

2097: p_mc_header_id in number
2098: )
2099: IS
2100: SELECT relationship_id, object_version_number
2101: FROM ahl_mc_relationships
2102: WHERE mc_header_id = p_mc_header_id AND
2103: parent_relationship_id IS NULL;
2104:
2105: -- Define get_topnode_item_group to retrieve the item group details of the top node

Line 2254: UPDATE ahl_mc_relationships

2250: last_update_login = G_LOGIN_ID
2251: WHERE mc_header_id = p_mc_header_id;
2252:
2253: -- 5. Update the topnode of the MC
2254: UPDATE ahl_mc_relationships
2255: SET active_end_date = null,
2256: object_version_number = l_topnode_object_ver_num + 1,
2257: last_update_date = G_SYSDATE,
2258: last_updated_by = G_USER_ID,

Line 2959: FROM ahl_mc_relationships_v

2955: p_mc_header_id IN NUMBER
2956: )
2957: IS
2958: SELECT relationship_id, position_ref_meaning, position_necessity_code
2959: FROM ahl_mc_relationships_v
2960: WHERE mc_header_id = p_mc_header_id;
2961:
2962: -- 2. Define cursor get_node_subconfigs_csr to read details about MCs associated as subconfigs to a MC node
2963: CURSOR get_node_subconfigs_csr

Line 2982: FROM ahl_mc_relationships mcr, ahl_item_groups_b ig

2978: p_relationship_id IN NUMBER
2979: )
2980: IS
2981: SELECT ig.item_group_id, ig.name, ig.type_code, ig.status_code
2982: FROM ahl_mc_relationships mcr, ahl_item_groups_b ig
2983: WHERE mcr.relationship_id = p_relationship_id AND
2984: ig.item_group_id = mcr.item_group_id;
2985:
2986: -- 4. Define local variables