[Home] [Help]
195: --warnings are populated in default values as to provide messages to the
196: --user asap
197: if(l_loadType in (wip_constants.create_job, wip_constants.create_ns_job)) then
198: if(p_rtgVal is not null) then
199: update wip_discrete_jobs
200: set serialization_start_op = p_rtgVal
201: where wip_entity_id = l_wipID
202: and exists (select 1
203: from mtl_system_items
205: and organization_id = l_orgID
206: and serial_number_control_code = wip_constants.full_sn);
207:
208: elsif(l_default = wip_constants.yes) then
209: update wip_discrete_jobs
210: set serialization_start_op = (select nvl(min(operation_seq_num), 1)
211: from wip_operations
212: where wip_entity_id = l_wipID)
213: where wip_entity_id = l_wipID
354: wjsi_row.schedule_group_id is null) then
355: begin
356: select schedule_group_id
357: into wjsi_row.schedule_group_id
358: from wip_discrete_jobs
359: where wip_entity_id = wjsi_row.wip_entity_id
360: and organization_id = wjsi_row.organization_id;
361: exception
362: when others then null;
461: elsif(wjsi_row.task_number is not null and wjsi_row.task_id is null) then
462: if(wjsi_row.load_type = wip_constants.resched_job) then
463: select pa.task_id
464: into wjsi_row.task_id
465: from pa_tasks_expend_v pa, wip_discrete_jobs wdj
466: where wdj.wip_entity_id = wjsi_row.wip_entity_id
467: and pa.project_id = nvl(wjsi_row.project_id, wdj.project_id)
468: and pa.task_number = wjsi_row.task_number;
469: else
527: elsif (wjsi_row.load_type in (wip_constants.resched_job, wip_constants.resched_eam_job) and
528: wjsi_row.status_type is null) then
529: select wdj.status_type
530: into wjsi_row.status_type
531: from wip_discrete_jobs wdj
532: where wdj.wip_entity_id = wjsi_row.wip_entity_id
533: and wdj.organization_id = wjsi_row.organization_id;
534: end if;
535: end status_type;
667: select decode(wdj.net_quantity,
668: wdj.start_quantity, wjsi_row.start_quantity,
669: least(wdj.net_quantity, nvl(wjsi_row.start_quantity, wdj.net_quantity)))
670: into wjsi_row.net_quantity
671: from wip_discrete_jobs wdj
672: where wdj.wip_entity_id = wjsi_row.wip_entity_id
673: and wdj.organization_id = wjsi_row.organization_id;
674: elsif(wjsi_row.load_type = wip_constants.create_ns_job) then
675: wjsi_row.net_quantity := 0;
708: else
709: if(wjsi_row.load_type = wip_constants.resched_job) then
710: select overcompletion_tolerance_type, overcompletion_tolerance_value, primary_item_id
711: into l_tolType, l_tolValue, l_primaryItemId
712: from wip_discrete_jobs
713: where wip_entity_id = wjsi_row.wip_entity_id;
714: if(wjsi_row.overcompletion_tolerance_type is not null) then
715: wjsi_row.overcompletion_tolerance_type := l_tolType;
716: end if;
822: if (wjsi_row.load_type in (wip_constants.resched_job, wip_constants.resched_eam_job) and
823: wjsi_row.class_code is NULL) then
824: select class_code
825: into wjsi_row.class_code
826: from wip_discrete_jobs
827: where wip_entity_id = wjsi_row.wip_entity_id
828: and organization_id = wjsi_row.organization_id;
829: end if;
830: end if;
1023: wjsi_row.load_type = wip_constants.resched_job and
1024: wjsi_row.scheduling_method = wip_constants.ml_manual) then
1025: select wdj.scheduled_start_date
1026: into wjsi_row.first_unit_start_date
1027: from wip_discrete_jobs wdj
1028: where wdj.wip_entity_id = wjsi_row.wip_entity_id
1029: and wdj.organization_id = wjsi_row.organization_id
1030: and exists ( select operation_seq_num
1031: from wip_operations wo
1718: wip_jsi_utils.record_ignored_column_warning('MATERIAL_ISSUE_BY_MO');
1719:
1720: select material_issue_by_mo
1721: into wjsi_row.material_issue_by_mo
1722: from wip_discrete_jobs
1723: where wip_entity_id = wjsi_row.wip_entity_id
1724: and organization_id = wjsi_row.organization_id;
1725:
1726: elsif (wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job)) then