APPS.AHL_SIMULATION_PVT dependencies on AHL_UE_SIMULATIONS

Line 38: FROM AHL_UE_SIMULATIONS

34: -- Cursor for checking lock in ue table
35: CURSOR check_lock_ue_tbl(p_simulation_plan_id NUMBER)
36: IS
37: SELECT 1
38: FROM AHL_UE_SIMULATIONS
39: WHERE simulation_plan_id = p_simulation_plan_id FOR UPDATE;
40:
41: -- Cursor for checking lock in unit assocs table
42: CURSOR check_lock_unit_assoc_tbl(p_simulation_plan_id NUMBER)

Line 126: FROM AHL_UE_SIMULATIONS

122:
123: -- Remove UEs when lock is not there on the records
124: IF (l_locked_rows = 'N') THEN
125: DELETE
126: FROM AHL_UE_SIMULATIONS
127: WHERE simulation_plan_id = p_simulation_plan_id;
128: ELSE
129: ROLLBACK TO Delete_Simulation_Plan;
130: FND_MESSAGE.Set_Name('AHL','AHL_SIM_ROWS_LOCKED');

Line 224: FROM AHL_UE_SIMULATIONS

220: -- Cursor for checking lock in Ue table
221: CURSOR check_lock_ue_tbl(p_simulation_plan_id NUMBER)
222: IS
223: SELECT 1
224: FROM AHL_UE_SIMULATIONS
225: WHERE simulation_plan_id = p_simulation_plan_id FOR UPDATE;
226:
227: -- Cursor for checking lock in Ue table
228: CURSOR check_lock_unit_assoc_tbl(p_simulation_plan_id NUMBER)

Line 484: FROM AHL_UE_SIMULATIONS

480: IF (l_locked_rows = 'N') THEN
481:
482: -- Delete the simulation plan ues
483: DELETE
484: FROM AHL_UE_SIMULATIONS
485: WHERE simulation_plan_id = p_simulation_plan_id;
486:
487: -- Logging
488: IF (l_log_statement >= l_log_current_level) THEN

Line 586: FROM AHL_UE_SIMULATIONS

582: --Lock checking cursor for ue records
583: CURSOR check_lock_ue_tbl(p_simulation_plan_id NUMBER, p_unit_header_id NUMBER)
584: IS
585: SELECT 1
586: FROM AHL_UE_SIMULATIONS
587: WHERE simulation_plan_id = p_simulation_plan_id FOR UPDATE;
588:
589: --Lock checking cursor for unit assocs records
590: CURSOR check_lock_unit_assoc_tbl(p_simulation_plan_id NUMBER, p_unit_header_id NUMBER)

Line 724: FROM AHL_UE_SIMULATIONS

720: -- Remove ue records if no lock is there
721: IF (l_locked_rows = 'N') THEN
722: -- Remove UEs
723: DELETE
724: FROM AHL_UE_SIMULATIONS
725: WHERE unit_config_header_id = l_unit_config_header_id
726: AND simulation_plan_id = l_sim_plan_id;
727: ELSE
728: ROLLBACK TO Remove_Unit_From_Plan;