560: end if;
561: end repetitive_schedule_id;
562:
563: procedure kanban_card_id is
564: l_raw_job WIP_Work_Order_Pub.DiscreteJob_Rec_Type ;
565: l_defaulted_job WIP_Work_Order_Pub.DiscreteJob_Rec_Type ;
566: l_raw_sched WIP_Work_Order_Pub.RepSchedule_Rec_Type ;
567: l_defaulted_sched WIP_Work_Order_Pub.RepSchedule_Rec_Type ;
568: begin
561: end repetitive_schedule_id;
562:
563: procedure kanban_card_id is
564: l_raw_job WIP_Work_Order_Pub.DiscreteJob_Rec_Type ;
565: l_defaulted_job WIP_Work_Order_Pub.DiscreteJob_Rec_Type ;
566: l_raw_sched WIP_Work_Order_Pub.RepSchedule_Rec_Type ;
567: l_defaulted_sched WIP_Work_Order_Pub.RepSchedule_Rec_Type ;
568: begin
569: if(wjsi_row.kanban_card_id is null or wip_jsi_utils.validation_level <> wip_constants.inv) then
562:
563: procedure kanban_card_id is
564: l_raw_job WIP_Work_Order_Pub.DiscreteJob_Rec_Type ;
565: l_defaulted_job WIP_Work_Order_Pub.DiscreteJob_Rec_Type ;
566: l_raw_sched WIP_Work_Order_Pub.RepSchedule_Rec_Type ;
567: l_defaulted_sched WIP_Work_Order_Pub.RepSchedule_Rec_Type ;
568: begin
569: if(wjsi_row.kanban_card_id is null or wip_jsi_utils.validation_level <> wip_constants.inv) then
570: return;
563: procedure kanban_card_id is
564: l_raw_job WIP_Work_Order_Pub.DiscreteJob_Rec_Type ;
565: l_defaulted_job WIP_Work_Order_Pub.DiscreteJob_Rec_Type ;
566: l_raw_sched WIP_Work_Order_Pub.RepSchedule_Rec_Type ;
567: l_defaulted_sched WIP_Work_Order_Pub.RepSchedule_Rec_Type ;
568: begin
569: if(wjsi_row.kanban_card_id is null or wip_jsi_utils.validation_level <> wip_constants.inv) then
570: return;
571: end if;
571: end if;
572:
573:
574: if(wjsi_row.load_type = wip_constants.create_job) then
575: l_raw_job := WIP_Work_Order_Pub.G_MISS_DISCRETEJOB_REC ;
576:
577: l_raw_job.organization_id := wjsi_row.organization_id ;
578: l_raw_job.kanban_card_id := wjsi_row.kanban_card_id ;
579: l_raw_job.primary_item_id := nvl(wjsi_row.primary_item_id, l_raw_job.primary_item_id) ;
592: wjsi_row.completion_subinventory := l_defaulted_job.completion_subinventory;
593: wjsi_row.completion_locator_id := l_defaulted_job.completion_locator_id;
594: wjsi_row.start_quantity := l_defaulted_job.start_quantity;
595: elsif(wjsi_row.load_type = wip_constants.create_sched) then
596: l_raw_sched := WIP_Work_Order_Pub.G_MISS_REPSCHEDULE_REC ;
597:
598: l_raw_sched.organization_id := wjsi_row.organization_id ;
599: l_raw_sched.kanban_card_id := wjsi_row.kanban_card_id ;
600: l_raw_sched.line_id := nvl(wjsi_row.line_id, l_raw_sched.line_id) ;