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_UMP_PROCESSUNIT_EXTN_PVT dependencies on AHL_UMP_PROCESSUNIT_PVT

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

72: -- Define Procedures --
73: ------------------------------
74:
75: -- To flush the unit effectivities created in the temporary table (ahl_temp_unit_effectivities)
76: -- by AHL_UMP_PROCESSUNIT_PVT.Process_Unit into ahl_unit_effectivities and ahl_ue_relationships.
77: -- JKJain, NR Analysis and Forecasting
78: PROCEDURE Flush_From_Temp_table (p_config_node_tbl IN AHL_UMP_PROCESSUNIT_PVT.config_node_tbl_type,
79: p_uc_header_id IN NUMBER)
80:

Line 78: PROCEDURE Flush_From_Temp_table (p_config_node_tbl IN AHL_UMP_PROCESSUNIT_PVT.config_node_tbl_type,

74:
75: -- To flush the unit effectivities created in the temporary table (ahl_temp_unit_effectivities)
76: -- by AHL_UMP_PROCESSUNIT_PVT.Process_Unit into ahl_unit_effectivities and ahl_ue_relationships.
77: -- JKJain, NR Analysis and Forecasting
78: PROCEDURE Flush_From_Temp_table (p_config_node_tbl IN AHL_UMP_PROCESSUNIT_PVT.config_node_tbl_type,
79: p_uc_header_id IN NUMBER)
80:
81: IS
82:

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

295: AND NOT EXISTS (SELECT 'x'
296: FROM ahl_ue_relationships
297: WHERE related_ue_id = ue.unit_effectivity_id);
298: -- FOR UPDATE OF message_code NOWAIT;
299: -- UMP rows are already locked by ahl_ump_processunit_pvt.lock_effectivity
300: -- proc.
301:
302: -- Cursor to get all decendents for a UE.
303: CURSOR decendent_csr (p_unit_effectivity_id IN NUMBER) IS

Line 518: l_fleet_header_id := AHL_UMP_ProcessUnit_PVT.get_fleet_from_unit_asso(G_UC_HEADER_ID,l_temp_individual_mr_rec.due_date,null);

514: l_fleet_header_id := null;
515: IF(l_temp_individual_mr_rec.fleet_header_id IS NOT NULL) THEN
516: l_temp_mr_rec.fleet_header_id := l_temp_individual_mr_rec.fleet_header_id;
517: ELSIF (G_UC_HEADER_ID IS NOT NULL) THEN
518: l_fleet_header_id := AHL_UMP_ProcessUnit_PVT.get_fleet_from_unit_asso(G_UC_HEADER_ID,l_temp_individual_mr_rec.due_date,null);
519: IF(l_fleet_header_id IS NULL) THEN
520: -- Check if Fleet Association exists with earliest due date.
521: l_fleet_header_id := AHL_UMP_ProcessUnit_PVT.get_fleet_from_unit_asso(G_UC_HEADER_ID,l_temp_individual_mr_rec.earliest_due_date,null);
522: END IF;

Line 521: l_fleet_header_id := AHL_UMP_ProcessUnit_PVT.get_fleet_from_unit_asso(G_UC_HEADER_ID,l_temp_individual_mr_rec.earliest_due_date,null);

517: ELSIF (G_UC_HEADER_ID IS NOT NULL) THEN
518: l_fleet_header_id := AHL_UMP_ProcessUnit_PVT.get_fleet_from_unit_asso(G_UC_HEADER_ID,l_temp_individual_mr_rec.due_date,null);
519: IF(l_fleet_header_id IS NULL) THEN
520: -- Check if Fleet Association exists with earliest due date.
521: l_fleet_header_id := AHL_UMP_ProcessUnit_PVT.get_fleet_from_unit_asso(G_UC_HEADER_ID,l_temp_individual_mr_rec.earliest_due_date,null);
522: END IF;
523: l_temp_mr_rec.fleet_header_id := l_fleet_header_id;
524: END IF;
525: -- fix for bug#9078331

Line 2324: l_fleet_header_id := AHL_UMP_ProcessUnit_PVT.get_fleet_from_unit_asso(G_UC_HEADER_ID,unit_sr_def_rec.due_date,null);

2320:
2321: -- JKJain, NR Analysis and Forecasting
2322: l_fleet_header_id := null;
2323: IF (G_UC_HEADER_ID IS NOT NULL) THEN
2324: l_fleet_header_id := AHL_UMP_ProcessUnit_PVT.get_fleet_from_unit_asso(G_UC_HEADER_ID,unit_sr_def_rec.due_date,null);
2325: l_unit_effectivity_rec.fleet_header_id := l_fleet_header_id;
2326: END IF;
2327: IF (unit_sr_def_rec.group_match_flag = 'Y') THEN
2328: IF G_DEBUG = 'Y' THEN

Line 3781: PROCEDURE Flush_To_Sim_Ue_Table(p_config_node_tbl IN AHL_UMP_PROCESSUNIT_PVT.config_node_tbl_type,

3777:
3778: END Flush_Chain_Effectivities;
3779:
3780: -- JKJain, NR Analysis and Forecasting
3781: PROCEDURE Flush_To_Sim_Ue_Table(p_config_node_tbl IN AHL_UMP_PROCESSUNIT_PVT.config_node_tbl_type,
3782: p_simulation_plan_id IN NUMBER,
3783: p_uc_header_id IN NUMBER) IS
3784:
3785: -- Select all the simulation UEs for the given sim plan.

Line 3949: l_fleet_header_id := AHL_UMP_ProcessUnit_PVT.get_fleet_from_unit_asso(G_UC_HEADER_ID,l_temp_individual_mr_rec.due_date,G_SIMULATION_PLAN_ID);

3945: l_temp_sim_ue_rec.csi_item_instance_id := l_temp_individual_mr_rec.csi_item_instance_id;
3946: IF(l_temp_individual_mr_rec.fleet_header_id IS NOT NULL) THEN
3947: l_temp_sim_ue_rec.fleet_header_id := l_temp_individual_mr_rec.fleet_header_id;
3948: ELSE
3949: l_fleet_header_id := AHL_UMP_ProcessUnit_PVT.get_fleet_from_unit_asso(G_UC_HEADER_ID,l_temp_individual_mr_rec.due_date,G_SIMULATION_PLAN_ID);
3950: IF(l_fleet_header_id IS NULL) THEN
3951: -- Check if Fleet Association exists with earliest due date.
3952: l_fleet_header_id := AHL_UMP_ProcessUnit_PVT.get_fleet_from_unit_asso(G_UC_HEADER_ID,l_temp_individual_mr_rec.earliest_due_date,G_SIMULATION_PLAN_ID);
3953: END IF;

Line 3952: l_fleet_header_id := AHL_UMP_ProcessUnit_PVT.get_fleet_from_unit_asso(G_UC_HEADER_ID,l_temp_individual_mr_rec.earliest_due_date,G_SIMULATION_PLAN_ID);

3948: ELSE
3949: l_fleet_header_id := AHL_UMP_ProcessUnit_PVT.get_fleet_from_unit_asso(G_UC_HEADER_ID,l_temp_individual_mr_rec.due_date,G_SIMULATION_PLAN_ID);
3950: IF(l_fleet_header_id IS NULL) THEN
3951: -- Check if Fleet Association exists with earliest due date.
3952: l_fleet_header_id := AHL_UMP_ProcessUnit_PVT.get_fleet_from_unit_asso(G_UC_HEADER_ID,l_temp_individual_mr_rec.earliest_due_date,G_SIMULATION_PLAN_ID);
3953: END IF;
3954: l_temp_sim_ue_rec.fleet_header_id := l_fleet_header_id;
3955: END IF;
3956: l_temp_sim_ue_rec.mr_header_id := l_temp_individual_mr_rec.mr_header_id;