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.

[Home] [Help]

APPS.AHL_UMP_PROCESSUNIT_EXTN_PVT dependencies on AHL_UE_SIMULATIONS

Line 63: PROCEDURE Create_sim_ue_record (p_x_temp_sim_ue_rec IN OUT NOCOPY ahl_ue_simulations%ROWTYPE);

59: PROCEDURE Flush_Loop_Effectivities;
60:
61: PROCEDURE Flush_Chain_Effectivities;
62: -- JKJain, NR Analysis and Forecasting
63: PROCEDURE Create_sim_ue_record (p_x_temp_sim_ue_rec IN OUT NOCOPY ahl_ue_simulations%ROWTYPE);
64: PROCEDURE Create_group_for_sim_ue (p_x_temp_sim_ue_rec IN OUT NOCOPY ahl_ue_simulations%ROWTYPE);
65: PROCEDURE create_simue_from_ue_record (p_unit_effectivity_id IN NUMBER,
66: p_originator_ue_id IN NUMBER,
67: p_parent_ue_id IN NUMBER,

Line 64: PROCEDURE Create_group_for_sim_ue (p_x_temp_sim_ue_rec IN OUT NOCOPY ahl_ue_simulations%ROWTYPE);

60:
61: PROCEDURE Flush_Chain_Effectivities;
62: -- JKJain, NR Analysis and Forecasting
63: PROCEDURE Create_sim_ue_record (p_x_temp_sim_ue_rec IN OUT NOCOPY ahl_ue_simulations%ROWTYPE);
64: PROCEDURE Create_group_for_sim_ue (p_x_temp_sim_ue_rec IN OUT NOCOPY ahl_ue_simulations%ROWTYPE);
65: PROCEDURE create_simue_from_ue_record (p_unit_effectivity_id IN NUMBER,
66: p_originator_ue_id IN NUMBER,
67: p_parent_ue_id IN NUMBER,
68: p_deferral_ue_cols IN Deferral_UE_Cols_Type := NULL,

Line 3788: FROM AHL_UE_SIMULATIONS

3784:
3785: -- Select all the simulation UEs for the given sim plan.
3786: CURSOR get_sim_ue_ids_csr(c_simulation_plan_id NUMBER,c_uc_header_id NUMBER) IS
3787: SELECT SIMULATION_UE_ID
3788: FROM AHL_UE_SIMULATIONS
3789: WHERE SIMULATION_PLAN_ID = c_simulation_plan_id
3790: AND UNIT_CONFIG_HEADER_ID = c_uc_header_id;
3791:
3792: -- get individual MRs for item instance and top group records from temporary table.

Line 3895: l_temp_sim_ue_rec ahl_ue_simulations%ROWTYPE;

3891: AND relationship_code = 'PARENT';
3892:
3893:
3894: l_user_id NUMBER := to_number(fnd_global.USER_ID);
3895: l_temp_sim_ue_rec ahl_ue_simulations%ROWTYPE;
3896: l_temp_individual_mr_rec temp_individual_mrs_csr%ROWTYPE;
3897: l_simulation_ue_id NUMBER;
3898: l_originator_ue_id NUMBER;
3899: l_unit_effectivity_id NUMBER;

Line 3926: DELETE FROM AHL_UE_SIMULATIONS WHERE SIMULATION_PLAN_ID = G_SIMULATION_PLAN_ID AND UNIT_CONFIG_HEADER_ID = G_UC_HEADER_ID;

3922: CLOSE get_sim_ue_ids_csr;
3923: G_SIM_UE_ID_INDEX := 1;
3924:
3925: --Delete all the sim UE's for the given sim plan unit combination.
3926: DELETE FROM AHL_UE_SIMULATIONS WHERE SIMULATION_PLAN_ID = G_SIMULATION_PLAN_ID AND UNIT_CONFIG_HEADER_ID = G_UC_HEADER_ID;
3927:
3928: -- Read temporary table.
3929: FOR temp_individual_mr_rec IN temp_individual_mrs_csr LOOP
3930:

Line 3940: l_temp_sim_ue_rec.simulation_ue_id := AHL_UE_SIMULATIONS_S.NEXtVAL;

3936: IF(G_SIM_UE_ID_TBL.EXISTS(G_SIM_UE_ID_INDEX)) THEN
3937: l_temp_sim_ue_rec.simulation_ue_id := G_SIM_UE_ID_TBL(G_SIM_UE_ID_INDEX);
3938: G_SIM_UE_ID_INDEX := G_SIM_UE_ID_INDEX +1;
3939: ELSE
3940: l_temp_sim_ue_rec.simulation_ue_id := AHL_UE_SIMULATIONS_S.NEXtVAL;
3941: END IF;
3942:
3943: l_temp_sim_ue_rec.simulation_plan_id := G_SIMULATION_PLAN_ID;
3944: l_temp_sim_ue_rec.unit_effectivity_id := null;

Line 4031: UPDATE AHL_UE_SIMULATIONS

4027: -- Check for group mr.
4028: FOR child_nr_up_ue_rec IN ahl_ue_relns_csr(nr_unplanned_ue_rec.unit_effectivity_id) LOOP
4029:
4030: IF (l_index <1)THEN
4031: UPDATE AHL_UE_SIMULATIONS
4032: SET originator_ue_id = l_simulation_ue_id
4033: WHERE simulation_ue_id = l_simulation_ue_id;
4034: l_index := 1;
4035: END IF;

Line 4075: UPDATE AHL_UE_SIMULATIONS

4071: l_index := 0;
4072: -- Check for group mr.
4073: FOR child_deferral_ue_rec IN ahl_ue_relns_csr(deferred_ue_rec.unit_effectivity_id) LOOP
4074: IF (l_index <1)THEN
4075: UPDATE AHL_UE_SIMULATIONS
4076: SET originator_ue_id = l_simulation_ue_id
4077: WHERE simulation_ue_id = l_simulation_ue_id;
4078: l_index := 1;
4079: END IF;

Line 4114: PROCEDURE Create_sim_ue_record (p_x_temp_sim_ue_rec IN OUT NOCOPY ahl_ue_simulations%ROWTYPE)

4110:
4111: END Flush_To_Sim_Ue_Table;
4112:
4113: -- To create ahl_unit_effectivities record.
4114: PROCEDURE Create_sim_ue_record (p_x_temp_sim_ue_rec IN OUT NOCOPY ahl_ue_simulations%ROWTYPE)
4115:
4116: IS
4117:
4118: BEGIN

Line 4126: INSERT INTO AHL_UE_SIMULATIONS (

4122: AHL_DEBUG_PUB.Debug('Start Create Record in Sim UE Table');
4123: END IF;
4124:
4125:
4126: INSERT INTO AHL_UE_SIMULATIONS (
4127: SIMULATION_UE_ID ,
4128: SIMULATION_PLAN_ID ,
4129: CSI_ITEM_INSTANCE_ID ,
4130: MR_HEADER_ID ,

Line 4213: PROCEDURE Create_group_for_sim_ue (p_x_temp_sim_ue_rec IN OUT NOCOPY ahl_ue_simulations%ROWTYPE)

4209: END create_sim_ue_record;
4210:
4211: -- To create decendent records if the MR is a group MR for Simulated UEs
4212:
4213: PROCEDURE Create_group_for_sim_ue (p_x_temp_sim_ue_rec IN OUT NOCOPY ahl_ue_simulations%ROWTYPE)
4214:
4215: IS
4216: -- Read group elements.
4217: CURSOR ahl_temp_grp_csr(p_csi_item_instance_id IN NUMBER,

Line 4276: l_temp_child_rec ahl_ue_simulations%ROWTYPE;

4272:
4273: l_parent_ue_id NUMBER;
4274:
4275:
4276: l_temp_child_rec ahl_ue_simulations%ROWTYPE;
4277:
4278: BEGIN
4279:
4280:

Line 4311: l_temp_child_rec.simulation_ue_id := AHL_UE_SIMULATIONS_S.NEXtVAL;

4307: IF(G_SIM_UE_ID_TBL.EXISTS(G_SIM_UE_ID_INDEX)) THEN
4308: l_temp_child_rec.simulation_ue_id := G_SIM_UE_ID_TBL(G_SIM_UE_ID_INDEX);
4309: G_SIM_UE_ID_INDEX := G_SIM_UE_ID_INDEX +1;
4310: ELSE
4311: l_temp_child_rec.simulation_ue_id := AHL_UE_SIMULATIONS_S.NEXtVAL;
4312: END IF;
4313:
4314: l_temp_child_rec.simulation_plan_id := p_x_temp_sim_ue_rec.simulation_plan_id;
4315: l_temp_child_rec.csi_item_instance_id := l_temp_grp_rec.csi_item_instance_id;

Line 4357: -- Insert into AHL_UE_SIMULATIONS

4353: END IF;
4354: CLOSE ahl_temp_parent_csr;
4355: l_temp_child_rec.parent_ue_id:= l_parent_ue_id;
4356:
4357: -- Insert into AHL_UE_SIMULATIONS
4358: create_sim_ue_record (l_temp_child_rec);
4359:
4360: -- Update ahl_temp_unit_effectivities with the sim unit effectivity id.
4361: UPDATE ahl_temp_unit_effectivities

Line 4417: l_temp_sim_ue_rec ahl_ue_simulations%ROWTYPE;

4413: from ahl_unit_effectivities_b
4414: where unit_effectivity_id = c_unit_effectivity_id;
4415:
4416: l_temp_ue_rec get_ue_details_csr%ROWTYPE;
4417: l_temp_sim_ue_rec ahl_ue_simulations%ROWTYPE;
4418: BEGIN
4419:
4420: IF G_DEBUG = 'Y' THEN
4421: AHL_DEBUG_PUB.Debug('Start Create_simue_from_ue_record');

Line 4433: l_temp_sim_ue_rec.simulation_ue_id := AHL_UE_SIMULATIONS_S.NEXtVAL;

4429: IF(G_SIM_UE_ID_TBL.EXISTS(G_SIM_UE_ID_INDEX)) THEN
4430: l_temp_sim_ue_rec.simulation_ue_id := G_SIM_UE_ID_TBL(G_SIM_UE_ID_INDEX);
4431: G_SIM_UE_ID_INDEX := G_SIM_UE_ID_INDEX +1;
4432: ELSE
4433: l_temp_sim_ue_rec.simulation_ue_id := AHL_UE_SIMULATIONS_S.NEXtVAL;
4434: END IF;
4435: l_temp_sim_ue_rec.simulation_plan_id := G_SIMULATION_PLAN_ID;
4436: l_temp_sim_ue_rec.unit_effectivity_id := p_unit_effectivity_id;
4437: l_temp_sim_ue_rec.csi_item_instance_id := l_temp_ue_rec.csi_item_instance_id;