APPS.WIP_JSI_VALIDATOR dependencies on WIP_ENTITIES

Line 502: from wip_discrete_jobs wdj, wip_entities we

498: wdj_row.task_id,
499: wdj_row.completion_subinventory,
500: wdj_row.completion_locator_id,
501: wdj_row.rebuild_item_id
502: from wip_discrete_jobs wdj, wip_entities we
503: where wdj.wip_entity_id = wjsi_row.wip_entity_id
504: and we.wip_entity_id = wjsi_row.wip_entity_id;
505: if(wdj_row.primary_item_id is not null) then
506: populate_item(p_item_id => wdj_row.primary_item_id,

Line 585: from wip_entities

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

Line 618: from wip_entities

614: begin
615: if(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_ns_job, wip_constants.create_eam_job)) then
616: select count(*)
617: into l_count
618: from wip_entities
619: where wip_entity_id = wjsi_row.wip_entity_id;
620: if(l_count > 0) then
621: raise fnd_api.g_exc_unexpected_error;
622: end if;

Line 2457: from wip_entities

2453: if(wjsi_row.load_type = wip_constants.create_eam_job
2454: and wjsi_row.parent_wip_entity_id is not null) then
2455: select 1
2456: into g_dummy
2457: from wip_entities
2458: where wip_entity_id = wjsi_row.parent_wip_entity_id
2459: and entity_type = wip_constants.eam;
2460: end if;
2461: exception