APPS.CSD_WIP_JOB_PVT dependencies on WIP_ENTITIES

Line 483: -- wip_entities or wip_job_schedule_interface table.

479:
480:
481: -- This procedure checks if the specified Job name exists in the
482: -- specified organization. It checks if it exists in
483: -- wip_entities or wip_job_schedule_interface table.
484: -- If it exists, then an Error status is returned.
485: -- If it does not exist in either of the tables, then
486: -- a Sucess status is returned.
487: -- This procedure is used whenever a job_name is generated, to confirm that

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

502:
503: BEGIN
504:
505:
506: Select count(*) into l_job_count from wip_entities where wip_entity_name = p_job_name and
507: organization_id = p_organization_id ;
508:
509: If l_job_count = 0 Then
510:

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

507: organization_id = p_organization_id ;
508:
509: If l_job_count = 0 Then
510:
511: -- Job does not exist in WIP_entities, check if it is already inserted in the interface table by another
512: -- process and so may be in the process of getting into WIP.
513: -- If it exists, do not want to use this job name, so return Error
514:
515: Select count(*) into l_job_count from wip_job_schedule_interface where job_name = p_job_name and

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

516: organization_id = p_organization_id ;
517:
518: IF l_job_count = 0 THEN
519:
520: -- Generated job name does exist either in the interface or wip_entities table,
521: -- Success is returned
522:
523: x_return_status := FND_API.G_RET_STS_SUCCESS;
524: RETURN;

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

535:
536:
537: ELSE
538:
539: -- Job exists in wip_entities table, hence return Error status
540:
541: x_return_status := FND_API.G_RET_STS_ERROR;
542: RETURN;
543:

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

587: x_return_status => l_return_status ) ;
588:
589: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
590:
591: -- Generated job name does not exist both in the interface and wip_entities table, so exit the loop
592:
593: exit;
594:
595: END IF;

Line 1074: wip_entities we

1070: -- crj.wip_entity_id may be null (until wip_update is done).
1071: select count(*)
1072: into l_num_other_jobs
1073: from csd_repair_job_xref crj,
1074: wip_entities we
1075: where crj.job_name = we.wip_entity_name
1076: and crj.organization_id = we.organization_id
1077: and crj.repair_line_id = p_repair_line_id
1078: and we.wip_entity_id <> l_wip_entity_id;

Line 1158: -- Check if it already exists in WIP_ENTITIES or WIP interface table

1154:
1155: IF l_job_bill_routing_rec.job_name is not NULL then
1156:
1157: -- job name is passed in, validate it for Uniqueness,
1158: -- Check if it already exists in WIP_ENTITIES or WIP interface table
1159:
1160: validate_job_name ( p_job_name => l_job_bill_routing_rec.Job_Name,
1161: p_organization_id => p_job_header_rec.organization_id,
1162: x_return_status => x_return_status ) ;

Line 1167: -- Job name either exists in WIP_ENTITIES or in the interface table for the specified

1163:
1164:
1165: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1166:
1167: -- Job name either exists in WIP_ENTITIES or in the interface table for the specified
1168: -- organization, So raise an error and exit
1169:
1170: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_NAME_EXISTS');
1171: FND_MESSAGE.SET_TOKEN('JOB_NAME', l_job_bill_routing_rec.job_name );

Line 1241: wip_entities we

1237: -- crj.wip_entity_id may be null (until wip_update is done).
1238: select count(*)
1239: into l_num_other_jobs
1240: from csd_repair_job_xref crj,
1241: wip_entities we
1242: where crj.job_name = we.wip_entity_name
1243: and crj.organization_id = we.organization_id
1244: and crj.repair_line_id = p_repair_line_id
1245: and we.wip_entity_id <> l_wip_entity_id;