APPS.AHL_UMP_PROCESSUNIT_EXTN_PVT dependencies on AHL_UMP_PROCESSUNIT_PVT

Line 41: -- by AHL_UMP_PROCESSUNIT_PVT.Process_Unit into ahl_unit_effectivities and ahl_ue_relationships.

37: -- Define Procedures --
38: ------------------------------
39:
40: -- To flush the unit effectivities created in the temporary table (ahl_temp_unit_effectivities)
41: -- by AHL_UMP_PROCESSUNIT_PVT.Process_Unit into ahl_unit_effectivities and ahl_ue_relationships.
42:
43: PROCEDURE Flush_From_Temp_table (p_config_node_tbl IN AHL_UMP_PROCESSUNIT_PVT.config_node_tbl_type)
44:
45: IS

Line 43: PROCEDURE Flush_From_Temp_table (p_config_node_tbl IN AHL_UMP_PROCESSUNIT_PVT.config_node_tbl_type)

39:
40: -- To flush the unit effectivities created in the temporary table (ahl_temp_unit_effectivities)
41: -- by AHL_UMP_PROCESSUNIT_PVT.Process_Unit into ahl_unit_effectivities and ahl_ue_relationships.
42:
43: PROCEDURE Flush_From_Temp_table (p_config_node_tbl IN AHL_UMP_PROCESSUNIT_PVT.config_node_tbl_type)
44:
45: IS
46:
47: -- get individual MRs for item instance and top group records

Line 234: -- UMP rows are already locked by ahl_ump_processunit_pvt.lock_effectivity

230: AND NOT EXISTS (SELECT 'x'
231: FROM ahl_ue_relationships
232: WHERE related_ue_id = ue.unit_effectivity_id);
233: -- FOR UPDATE OF message_code NOWAIT;
234: -- UMP rows are already locked by ahl_ump_processunit_pvt.lock_effectivity
235: -- proc.
236:
237: -- Cursor to get all decendents for a UE.
238: CURSOR decendent_csr (p_unit_effectivity_id IN NUMBER) IS