[Home] [Help]
147: atu.csi_item_instance_id = p_preceding_item_instance
148: --forecast_sequence = p_preceding_forecast_seq;
149: UNION
150: SELECT atu.unit_effectivity_id unit_effectivity_id, atu.due_date
151: FROM ahl_temp_unit_SR_deferrals atu
152: --WHERE atu.mr_header_id = p_preceding_mr_header_id AND
153: WHERE atu.mr_header_id IN (select mr1.mr_header_id from ahl_mr_headers_b mr1
154: where mr1.title = (select mr2.title from ahl_mr_headers_b mr2
155: where mr2.mr_header_id = p_preceding_mr_header_id)
529: BEGIN
530: SELECT due_date, unit_effectivity_id INTO l_min_due_date, l_min_ue_id
531: FROM (
532: SELECT def.due_date, def.unit_effectivity_id
533: FROM ahl_temp_unit_SR_deferrals def, ahl_mr_headers_b mr1
534: WHERE def.csi_item_instance_id = l_temp_mr_rec.csi_item_instance_id
535: AND def.mr_header_id = mr1.mr_header_id
536: AND mr1.title = (select mr2.title from ahl_mr_headers_b mr2 where mr2.mr_header_id = l_temp_mr_rec.MR_header_id)
537: AND def.due_date IS NOT NULL
2158: orig_mr_header_id,
2159: orig_unit_effectivity_id,
2160: group_match_flag,
2161: counter_id
2162: FROM ahl_temp_unit_SR_deferrals
2163: WHERE orig_unit_effectivity_id IS NULL
2164: ORDER BY csi_item_instance_id, mr_header_id
2165: FOR UPDATE OF unit_effectivity_id;
2166:
2185: orig_csi_item_instance_id,
2186: orig_mr_header_id,
2187: tolerance_flag,
2188: message_code
2189: FROM ahl_temp_unit_SR_deferrals
2190: START WITH parent_csi_item_instance_id = p_csi_item_instance_id
2191: AND parent_mr_header_id = p_mr_header_id
2192: AND orig_csi_item_instance_id = p_csi_item_instance_id
2193: AND orig_mr_header_id = p_mr_header_id
2207: p_orig_csi_item_instance_id IN NUMBER,
2208: p_orig_mr_header_id IN NUMBER,
2209: p_unit_effectivity_id NUMBER) IS
2210: SELECT unit_effectivity_id
2211: FROM ahl_temp_unit_SR_deferrals
2212: WHERE csi_item_instance_id = p_parent_csi_item_instance_id
2213: AND MR_header_id = p_parent_mr_header_id
2214: AND orig_csi_item_instance_id = p_orig_csi_item_instance_id
2215: AND orig_mr_header_id = p_orig_mr_header_id
2609:
2610: l_new_top_ue_id := l_unit_effectivity_id;
2611:
2612: -- update new UE ID for top node.
2613: UPDATE ahl_temp_unit_SR_deferrals
2614: SET unit_effectivity_id = l_new_top_ue_id,
2615: object_type = l_unit_effectivity_rec.object_type
2616: WHERE CURRENT OF ahl_unit_sr_def_csr ;
2617:
2704: X_LAST_UPDATE_DATE => sysdate,
2705: X_LAST_UPDATED_BY => fnd_global.user_id,
2706: X_LAST_UPDATE_LOGIN => fnd_global.login_id );
2707:
2708: UPDATE ahl_temp_unit_SR_deferrals
2709: SET unit_effectivity_id = l_unit_effectivity_id,
2710: object_type = l_unit_effectivity_rec.object_type
2711: WHERE CURRENT OF ahl_temp_csr ;
2712:
3130: BEGIN
3131: SELECT due_date, unit_effectivity_id INTO l_min_due_date, l_min_ue_id
3132: FROM (
3133: SELECT def.due_date, def.unit_effectivity_id
3134: FROM ahl_temp_unit_SR_deferrals def, ahl_mr_headers_b mr1
3135: WHERE def.csi_item_instance_id = l_temp_ue_records(i).csi_item_instance_id
3136: AND def.mr_header_id = mr1.mr_header_id
3137: AND mr1.title = (select mr2.title from ahl_mr_headers_b mr2 where mr2.mr_header_id = l_temp_ue_records(i).MR_header_id)
3138: AND def.due_date IS NOT NULL
3531: BEGIN
3532: SELECT due_date, unit_effectivity_id INTO l_min_due_date, l_min_ue_id
3533: FROM (
3534: SELECT def.due_date, def.unit_effectivity_id
3535: FROM ahl_temp_unit_SR_deferrals def, ahl_mr_headers_b mr1
3536: WHERE def.csi_item_instance_id = l_temp_ue_records(i).csi_item_instance_id
3537: AND def.mr_header_id = mr1.mr_header_id
3538: AND mr1.title = (select mr2.title from ahl_mr_headers_b mr2 where mr2.mr_header_id = l_temp_ue_records(i).MR_header_id)
3539: AND def.due_date IS NOT NULL
3866: temp.due_date,
3867: temp.tolerance_flag,
3868: temp.message_code,
3869: temp.counter_id
3870: from ahl_temp_unit_sr_deferrals temp, ahl_unit_effectivities_b ue
3871: WHERE ue.unit_effectivity_id = temp.unit_effectivity_id and
3872: temp.csi_item_instance_id = c_csi_item_instance_id and
3873: temp.orig_unit_effectivity_id IS NULL and
3874: temp.deferral_effective_on IS NOT NULL