APPS.WIP_JSI_DEFAULTER dependencies on WIP_ENTITIES

Line 268: from wip_entities

264: if(wjsi_row.load_type in (wip_constants.resched_job, wip_constants.resched_eam_job)) then
265: if(wjsi_row.wip_entity_id is null) then
266: select wip_entity_id
267: into wjsi_row.wip_entity_id
268: from wip_entities
269: where wip_entity_name = wjsi_row.job_name
270: and organization_id = wjsi_row.organization_id;
271: elsif(wjsi_row.job_name is not null) then
272: WIP_JSI_Utils.record_ignored_column_warning('JOB_NAME');

Line 313: select wip_entities_s.nextval

309: wip_constants.create_eam_job)) then
310: if(wjsi_row.wip_entity_id is not null) then
311: wip_jsi_utils.record_ignored_column_warning('WIP_ENTITY_ID');
312: end if;
313: select wip_entities_s.nextval
314: into wjsi_row.wip_entity_id
315: from dual;
316: else --do minimal validation of wip_entity_id so future defaulting doesn't error
317: select 1

Line 319: from wip_entities

315: from dual;
316: else --do minimal validation of wip_entity_id so future defaulting doesn't error
317: select 1
318: into l_dummy
319: from wip_entities
320: where wip_entity_id = wjsi_row.wip_entity_id
321: and organization_id = wjsi_row.organization_id;
322: end if;
323: exception

Line 945: from wip_entities

941: wip_jsi_utils.record_ignored_column_warning('LOT_NUMBER');
942: elsif(wjsi_row.load_type in (wip_constants.resched_job, wip_constants.resched_eam_job)) then
943: select primary_item_id, wip_entity_name
944: into l_primary_item_id, l_wip_name
945: from wip_entities
946: where wip_entity_id = wjsi_row.wip_entity_id;
947:
948: wjsi_row.lot_number := wip_lot_number_default.lot_number(p_item_id => l_primary_item_id,
949: p_organization_id => wjsi_row.organization_id,

Line 1399: from wip_entities

1395: elsif(wjsi_row.parent_job_name is not null) then
1396: if(wjsi_row.parent_wip_entity_id is null) then
1397: select wip_entity_id
1398: into wjsi_row.parent_wip_entity_id
1399: from wip_entities
1400: where wip_entity_name = wjsi_row.parent_job_name
1401: and organization_id = wjsi_row.organization_id;
1402: else
1403: wip_jsi_utils.record_ignored_column_warning('PARENT_JOB_NAME');