[Home] [Help]
2427: end Create_Transfer_Order;
2428:
2429: --
2430: -- Launch_MLP() : This program will launch the WIP Mass load program to
2431: -- to upload the data from WIP_JOB_SCHEDULE_INTERFACE
2432: -- table.
2433: --
2434:
2435: Function Launch_MLP(p_group_id IN Number) return BOOLEAN IS
2564:
2565: l_last_unit_completion_date := NULL;
2566: END IF;
2567:
2568: Insert into WIP_JOB_SCHEDULE_INTERFACE
2569: (LAST_UPDATE_DATE,
2570: LAST_UPDATED_BY,
2571: CREATION_DATE,
2572: CREATED_BY,
2675:
2676: /*
2677: begin
2678: select 'Y' into rep_sched_exist
2679: from WIP_JOB_SCHEDULE_INTERFACE
2680: where
2681: primary_item_id = p_kanban_card_rec_tbl(1).inventory_item_id AND
2682: organization_id = p_kanban_card_rec_tbl(1).organization_id AND
2683: line_id = p_kanban_card_rec_tbl(1).wip_line_id AND
2749: /* End of Bug 9437363 */
2750: /* For bug 7721127 Start */
2751: l_last_unit_completion_date := NULL;
2752: END IF;
2753: Insert into WIP_JOB_SCHEDULE_INTERFACE
2754: ( LAST_UPDATE_DATE,
2755: LAST_UPDATED_BY,
2756: CREATION_DATE,
2757: CREATED_BY,
2807: -- End if;
2808:
2809: p_kanban_card_rec_tbl(1).document_type := 6;
2810: if ( rep_sched_exist = 'Y' ) then
2811: Update WIP_JOB_SCHEDULE_INTERFACE
2812: set START_QUANTITY = START_QUANTITY + total_qty ,
2813: -- LAST_UNIT_COMPLETION_DATE = SYSDATE + (p_fixed_lead_time +
2814: -- p_var_lead_time*(START_QUANTITY + total_qty)),
2815: PROCESSING_WORK_DAYS = (START_QUANTITY + total_qty)/ line_rate,