[Home] [Help]
7923: -- IF item.update_wip = 1 and NVL(item.start_quantity,0) > 0
7924: IF l_update_wip = 1
7925: THEN
7926:
7927: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_wip_group_id1
7928: FROM DUAL;
7929: group_id1 := l_wip_group_id1; --- set out type value
7930:
7931: --bug 2327582
7935: IF NVL(l_wip_from_cum_qty, 0) > 0
7936: THEN
7937: IF l_wip_start_quantity1 <> 0
7938: THEN
7939: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_wip_group_id2
7940: FROM DUAL;
7941: group_id2 := l_wip_group_id2; --- set out type value
7942: ELSE group_id2 := -1;
7943: END IF;
8148: LOOP
8149: l_wip_job_name2 := wip_name_for_job_rec.wip_entity_name;
8150: l_wip_last_u_compl_date2 := wip_name_for_job_rec.scheduled_completion_date;
8151:
8152: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_wip_header_id
8153: FROM DUAL; --fix bug 5667398 cannot have duplicate header id from same group id
8154: /* Added for Bug2970539, Bug 3076067 */
8155:
8156: --if (l_wip_bom_revision_date2 > today) then -- 3412747
8264: LOOP
8265: l_wip_job_name2 := wip_name_for_lot_rec.wip_entity_name;
8266: l_wip_last_u_compl_date2 := wip_name_for_lot_rec.scheduled_completion_date;
8267:
8268: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_wip_header_id
8269: FROM DUAL; --fix bug 5667398 cannot have duplicate header id from same group id
8270:
8271: /* Added for Bug2970539, Bug 3076067 */
8272:
8384: LOOP
8385: l_wip_job_name2 := wip_name_for_common_rec.wip_entity_name;
8386: l_wip_last_u_compl_date2 := wip_name_for_common_rec.scheduled_completion_date;
8387:
8388: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_wip_header_id
8389: FROM DUAL; --fix bug 5667398 cannot have duplicate header id from same group id
8390:
8391: /* Added for Bug2970539, Bug 3076067 */
8392: