APPS.WIP_JSI_VALIDATOR dependencies on WIP_ENTITIES

Line 507: from wip_discrete_jobs wdj, wip_entities we

503: wdj_row.task_id,
504: wdj_row.completion_subinventory,
505: wdj_row.completion_locator_id,
506: wdj_row.rebuild_item_id
507: from wip_discrete_jobs wdj, wip_entities we
508: where wdj.wip_entity_id = wjsi_row.wip_entity_id
509: and we.wip_entity_id = wjsi_row.wip_entity_id;
510: if(wdj_row.primary_item_id is not null) then
511: populate_item(p_item_id => wdj_row.primary_item_id,

Line 590: from wip_entities

586: if(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_ns_job, wip_constants.create_eam_job) and
587: wjsi_row.job_name is not null) then
588: select count(*)
589: into l_count
590: from wip_entities
591: where wip_entity_name = wjsi_row.job_name
592: and organization_id = wjsi_row.organization_id;
593: if(l_count > 0) then
594: raise fnd_api.g_exc_unexpected_error;

Line 623: from wip_entities

619: begin
620: if(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_ns_job, wip_constants.create_eam_job)) then
621: select count(*)
622: into l_count
623: from wip_entities
624: where wip_entity_id = wjsi_row.wip_entity_id;
625: if(l_count > 0) then
626: raise fnd_api.g_exc_unexpected_error;
627: end if;

Line 2462: from wip_entities

2458: if(wjsi_row.load_type = wip_constants.create_eam_job
2459: and wjsi_row.parent_wip_entity_id is not null) then
2460: select 1
2461: into g_dummy
2462: from wip_entities
2463: where wip_entity_id = wjsi_row.parent_wip_entity_id
2464: and entity_type = wip_constants.eam;
2465: end if;
2466: exception