[Home] [Help]
2481: */
2482:
2483: CURSOR ahl_unit_effectivities_csr (p_csi_item_instance_id IN NUMBER, p_appln_usg_code IN VARCHAR2) IS
2484: WITH II AS (SELECT p_csi_item_instance_id instance_id
2485: FROM DUAL
2486: UNION ALL
2487: SELECT A.SUBJECT_ID INSTANCE_ID
2488: FROM CSI_II_RELATIONSHIPS A
2489: START WITH OBJECT_ID = p_csi_item_instance_id
2505:
2506: -- JKJain, NR Analysis and Forecasting
2507: CURSOR ahl_sim_ues_csr (p_csi_item_instance_id IN NUMBER) IS
2508: WITH II AS (SELECT p_csi_item_instance_id instance_id
2509: FROM DUAL
2510: UNION ALL
2511: SELECT A.SUBJECT_ID INSTANCE_ID
2512: FROM CSI_II_RELATIONSHIPS A
2513: START WITH OBJECT_ID = p_csi_item_instance_id
4089:
4090: -- added to fix bug# 6530920.
4091: -- this is to avoid creation of one child UMP row at the end of the
4092: -- planning window when the child MR and parent MR have the same interval
4093: -- threshold. Next due MR can be individual MR or part of a group MR.
4094: l_next_due_flag := FALSE;
4095:
4096: END IF;
4097: CLOSE ahl_temp_ue_csr1;
4151: /*
4152: -- added to fix bug# 6530920.
4153: -- this is to avoid creation of one child UMP row at the end of the
4154: -- planning window when the child MR and parent MR have the same interval
4155: -- threshold. Next due MR can be individual MR or part of a group MR.
4156: l_next_due_flag := FALSE;
4157: */
4158: END IF;
4159: END IF; -- l_grp_duedate_found.
4206: -- find the corressponding match in l_unit_effectivity_tbl if exists.
4207: IF (l_old_UE_forecast_found = TRUE) AND (l_unit_effectivity_tbl.EXISTS(l_old_UE_forecast_sequence+1))
4208: THEN
4209:
4210: -- loop to find the next individual MR.
4211: LOOP
4212: l_old_UE_forecast_sequence := l_old_UE_forecast_sequence + 1;
4213: IF (l_unit_effectivity_tbl(l_old_UE_forecast_sequence).forecast_sequence is not null) THEN
4214: l_new_unit_effectivity_rec.unit_effectivity_id :=