[Home] [Help]
1939: */
1940:
1941: CURSOR ahl_unit_effectivities_csr (p_csi_item_instance_id IN NUMBER) IS
1942: WITH II AS (SELECT p_csi_item_instance_id instance_id
1943: FROM DUAL
1944: UNION ALL
1945: SELECT A.SUBJECT_ID INSTANCE_ID
1946: FROM CSI_II_RELATIONSHIPS A
1947: START WITH OBJECT_ID = p_csi_item_instance_id
3185:
3186: -- added to fix bug# 6530920.
3187: -- this is to avoid creation of one child UMP row at the end of the
3188: -- planning window when the child MR and parent MR have the same interval
3189: -- threshold. Next due MR can be individual MR or part of a group MR.
3190: l_next_due_flag := FALSE;
3191:
3192: END IF;
3193: CLOSE ahl_temp_ue_csr1;
3246: /*
3247: -- added to fix bug# 6530920.
3248: -- this is to avoid creation of one child UMP row at the end of the
3249: -- planning window when the child MR and parent MR have the same interval
3250: -- threshold. Next due MR can be individual MR or part of a group MR.
3251: l_next_due_flag := FALSE;
3252: */
3253: END IF;
3254: END IF; -- l_grp_duedate_found.
3301: -- find the corressponding match in l_unit_effectivity_tbl if exists.
3302: IF (l_old_UE_forecast_found = TRUE) AND (l_unit_effectivity_tbl.EXISTS(l_old_UE_forecast_sequence+1))
3303: THEN
3304:
3305: -- loop to find the next individual MR.
3306: LOOP
3307: l_old_UE_forecast_sequence := l_old_UE_forecast_sequence + 1;
3308: IF (l_unit_effectivity_tbl(l_old_UE_forecast_sequence).forecast_sequence is not null) THEN
3309: l_new_unit_effectivity_rec.unit_effectivity_id :=