[Home] [Help]
8264: -- IF item.update_wip = 1 and NVL(item.start_quantity,0) > 0
8265: IF l_update_wip = 1
8266: THEN
8267:
8268: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_wip_group_id1
8269: FROM DUAL;
8270: group_id1 := l_wip_group_id1; --- set out type value
8271:
8272: --bug 2327582
8276: IF NVL(l_wip_from_cum_qty, 0) > 0
8277: THEN
8278: IF l_wip_start_quantity1 <> 0
8279: THEN
8280: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_wip_group_id2
8281: FROM DUAL;
8282: group_id2 := l_wip_group_id2; --- set out type value
8283: ELSE group_id2 := -1;
8284: END IF;
8491: LOOP
8492: l_wip_job_name2 := wip_name_for_job_rec.wip_entity_name;
8493: l_wip_last_u_compl_date2 := wip_name_for_job_rec.scheduled_completion_date;
8494:
8495: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_wip_header_id
8496: FROM DUAL; --fix bug 5667398 cannot have duplicate header id from same group id
8497: /* Added for Bug2970539, Bug 3076067 */
8498:
8499: --if (l_wip_bom_revision_date2 > today) then -- 3412747
8608: LOOP
8609: l_wip_job_name2 := wip_name_for_lot_rec.wip_entity_name;
8610: l_wip_last_u_compl_date2 := wip_name_for_lot_rec.scheduled_completion_date;
8611:
8612: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_wip_header_id
8613: FROM DUAL; --fix bug 5667398 cannot have duplicate header id from same group id
8614:
8615: /* Added for Bug2970539, Bug 3076067 */
8616:
8728: LOOP
8729: l_wip_job_name2 := wip_name_for_common_rec.wip_entity_name;
8730: l_wip_last_u_compl_date2 := wip_name_for_common_rec.scheduled_completion_date;
8731:
8732: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_wip_header_id
8733: FROM DUAL; --fix bug 5667398 cannot have duplicate header id from same group id
8734:
8735: /* Added for Bug2970539, Bug 3076067 */
8736: