APPS.WIP_MASSLOAD_PVT dependencies on WIP_DISCRETE_JOBS

Line 107: update wip_discrete_jobs

103: from wip_parameters
104: where organization_id = wjsi_row.organization_id;
105:
106: if ( l_serStartOp is not null ) then
107: update wip_discrete_jobs
108: set serialization_start_op = l_serStartOp
109: where wip_entity_id = wjsi_row.wip_entity_id
110: and exists (select 1
111: from mtl_system_items

Line 116: update wip_discrete_jobs

112: where inventory_item_id = wjsi_row.primary_item_id
113: and organization_id = wjsi_row.organization_id
114: and serial_number_control_code = wip_constants.full_sn);
115: elsif ( l_defaultSer = wip_constants.yes ) then
116: update wip_discrete_jobs
117: set serialization_start_op = (select nvl(min(operation_seq_num), 1)
118: from wip_operations
119: where wip_entity_id = wjsi_row.wip_entity_id)
120: where wip_entity_id = wjsi_row.wip_entity_id

Line 164: from wip_discrete_jobs

160: l_startDate,
161: l_endDate,
162: l_projectID,
163: l_taskID
164: from wip_discrete_jobs
165: where wip_entity_id = wjsi_row.wip_entity_id
166: and organization_id = wjsi_row.organization_id;
167:
168: if ( wjsi_row.scheduling_method = wip_constants.routing ) then

Line 324: insert into wip_discrete_jobs(

320:
321:
322: procedure createWIPEntity(p_rowid in rowid) is
323: begin
324: insert into wip_discrete_jobs(
325: wip_entity_id,
326: organization_id,
327: last_update_date,
328: last_updated_by,

Line 579: update wip_discrete_jobs wdj

575: into l_wipEntityID
576: from wip_job_schedule_interface
577: where rowid = p_rowid;
578:
579: update wip_discrete_jobs wdj
580: set (last_updated_by,
581: last_update_login,
582: request_id,
583: program_application_id,