[Home] [Help]
118: from wip_parameters
119: where organization_id = wjsi_row.organization_id;
120:
121: if ( l_serStartOp is not null ) then
122: update wip_discrete_jobs
123: set serialization_start_op = l_serStartOp
124: where wip_entity_id = wjsi_row.wip_entity_id
125: and exists (select 1
126: from mtl_system_items
127: where inventory_item_id = wjsi_row.primary_item_id
128: and organization_id = wjsi_row.organization_id
129: and serial_number_control_code = wip_constants.full_sn);
130: elsif ( l_defaultSer = wip_constants.yes ) then
131: update wip_discrete_jobs
132: set serialization_start_op = (select nvl(min(operation_seq_num), 1)
133: from wip_operations
134: where wip_entity_id = wjsi_row.wip_entity_id)
135: where wip_entity_id = wjsi_row.wip_entity_id
186: l_endDate,
187: l_projectID,
188: l_taskID,
189: g_wdjClassCode
190: from wip_discrete_jobs
191: where wip_entity_id = wjsi_row.wip_entity_id
192: and organization_id = wjsi_row.organization_id;
193:
194: /* fix for bug 16079296, copying the statustype into global variable for further use */
470: procedure createWIPEntity(p_rowid in rowid) is
471: l_request_id number; -- bug 13946971
472: begin
473: l_request_id := fnd_global.conc_request_id ; -- bug 13946971
474: insert into wip_discrete_jobs(
475: wip_entity_id,
476: organization_id,
477: last_update_date,
478: last_updated_by,
725: into l_wipEntityID
726: from wip_job_schedule_interface
727: where rowid = p_rowid;
728:
729: update wip_discrete_jobs wdj
730: set (last_updated_by,
731: last_update_login,
732: request_id,
733: program_application_id,
945:
946: /* fix for bug 16079296 for class_code update */
947: IF (nvl(g_wjsiClassCode,g_wdjClassCode) <> g_wdjClassCode) AND (g_wjsiJobStatus = WIP_CONSTANTS.UNRELEASED or g_wdjJobStatus = WIP_CONSTANTS.UNRELEASED) then
948:
949: UPDATE WIP_DISCRETE_JOBS WDJ
950: SET (WDJ.class_code,
951: WDJ.material_account,
952: material_overhead_account,
953: resource_account,