APPS.CSD_HV_WIP_JOB_PVT dependencies on WIP_ENTITIES

Line 195: wip_entities we,

191: wjdi.resource_id_new
192: from
193: wip_interface_errors_v wie,
194: wip_job_schedule_interface wjsi,
195: wip_entities we,
196: wip_job_dtls_interface wjdi
197: where wie.interface_id = wjsi.interface_id
198: and we.wip_entity_id = wjsi.wip_entity_id
199: and wjsi.group_id = wjdi.group_id

Line 246: -- wip_entities or wip_job_schedule_interface table.

242: END add_wip_interface_errors;
243:
244: -- This procedure checks if the specified Job name exists in the
245: -- specified organization. It checks if it exists in
246: -- wip_entities or wip_job_schedule_interface table.
247: -- If it exists, then an Error status is returned.
248: -- If it does not exist in either of the tables, then
249: -- a Sucess status is returned.
250: -- This procedure is used whenever a job_name is generated, to confirm that

Line 269: Select count(*) into l_job_count from wip_entities where wip_entity_name = p_job_name and

265:
266: BEGIN
267:
268:
269: Select count(*) into l_job_count from wip_entities where wip_entity_name = p_job_name and
270: organization_id = p_organization_id ;
271:
272: If l_job_count = 0 Then
273:

Line 274: -- Job does not exist in WIP_entities, check if it is already inserted in the interface table by another

270: organization_id = p_organization_id ;
271:
272: If l_job_count = 0 Then
273:
274: -- Job does not exist in WIP_entities, check if it is already inserted in the interface table by another
275: -- process and so may be in the process of getting into WIP.
276: -- If it exists, do not want to use this job name, so return Error
277:
278: Select count(*) into l_job_count from wip_job_schedule_interface where job_name = p_job_name and

Line 283: -- Generated job name does exist either in the interface or wip_entities table,

279: organization_id = p_organization_id ;
280:
281: IF l_job_count = 0 THEN
282:
283: -- Generated job name does exist either in the interface or wip_entities table,
284: -- Success is returned
285:
286: x_return_status := FND_API.G_RET_STS_SUCCESS;
287: RETURN;

Line 302: -- Job exists in wip_entities table, hence return Error status

298:
299:
300: ELSE
301:
302: -- Job exists in wip_entities table, hence return Error status
303:
304: x_return_status := FND_API.G_RET_STS_ERROR;
305: RETURN;
306:

Line 352: -- Generated job name does not exist both in the interface and wip_entities table, so exit the loop

348: x_return_status => l_return_status ) ;
349:
350: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
351:
352: -- Generated job name does not exist both in the interface and wip_entities table, so exit the loop
353:
354: exit;
355:
356: END IF;

Line 5708: wip_entities we

5704: -- crj.wip_entity_id may be null (until wip_update is done).
5705: select count(*)
5706: into l_num_other_jobs
5707: from csd_repair_job_xref crj,
5708: wip_entities we
5709: where crj.job_name = we.wip_entity_name
5710: and crj.organization_id = we.organization_id
5711: and crj.repair_line_id = p_repair_line_id
5712: and we.wip_entity_id <> l_wip_entity_id;

Line 6376: wip_entities we

6372: -- crj.wip_entity_id may be null (until wip_update is done).
6373: select count(*)
6374: into l_num_other_jobs
6375: from csd_repair_job_xref crj,
6376: wip_entities we
6377: where crj.job_name = we.wip_entity_name
6378: and crj.organization_id = we.organization_id
6379: and crj.repair_line_id = p_repair_line_id
6380: and we.wip_entity_id <> l_wip_entity_id;