APPS.AHL_MC_MASTERCONFIG_PVT dependencies on AHL_ITEM_GROUPS_B

Line 2112: FROM ahl_item_groups_b igp

2108: p_item_group_id in number
2109: )
2110: IS
2111: SELECT status_code,object_version_number
2112: FROM ahl_item_groups_b igp
2113: WHERE item_group_id = p_item_group_id;
2114:
2115: -- Define cursor get_mc_status to retrieve the old/actual status of expired MCs
2116: CURSOR get_mc_status

Line 2235: UPDATE ahl_item_groups_b

2231: END IF;
2232: RAISE FND_API.G_EXC_ERROR;
2233: ELSE
2234: IF(l_item_group_status = 'REMOVED') THEN
2235: UPDATE ahl_item_groups_b
2236: SET status_code ='COMPLETE',
2237: object_version_number = object_version_number +1
2238: WHERE item_group_id = l_item_group_id;
2239: END IF;

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