[Home] [Help]
4: -- Package name : CSD_WIP_JOB_PVT
5: -- Purpose : This package submits and creates WIP jobs using WIP Mass Load.
6: -- Submit_Jobs is the API which uses various helper procedures to
7: -- Submit WIP Mass Load, waits for it to complete successfully, then
8: -- calls WIP_UPDATE API to update CSD_REPAIR_JOB_XREF with the
9: -- newly created wip_entitity_id values.
10: -- Besides these procedure, this package has a helper function
11: -- is_dmf_patchset_level_j which is used by the client application
12: -- to check if the discrete manufacturing patchset level is at 'j' or
1069: -- the RO item as a material. Must compare we.wip_entity_id since
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
1236: -- the RO item as a material. Must compare we.wip_entity_id since
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
1244: and crj.repair_line_id = p_repair_line_id
1245: and we.wip_entity_id <> l_wip_entity_id;
1246: -- More than one bill/route could have been submitted at a time.
1247: -- These jobs are processed all at once before rows are inserted into
1248: -- csd_repair_job_xref. Need to count these jobs as well.
1249: l_num_other_jobs := l_num_other_jobs + rt_ctr - p_x_job_bill_routing_tbl.FIRST;
1250: -- end swai: bug 7477845/7483291
1251:
1252: l_dummy := null;
1431: -- 'Depot Repair WIP Job Submission'. This program is submitted from
1432: -- submit_jobs API.
1433: -- This procedure submits WIP Mass Load, waits for it to complete successfully,
1434: -- then calls the WIP_Update API to associate new records
1435: -- created in csd_repair_job_xref table with corresponding newly
1436: -- created wip_entity_ids.
1437: -- This concurrent program is passed in group_id and repair_line_id as
1438: -- parameters. If repair_line_id is null, then the WIP Update program is
1439: -- run for all the eligible repair orders, otherwise the WIP Update porgram
1591:
1592: -- Call the WIP Update program
1593:
1594: -- When Repair Jobs are submitted to WIP Mass Load, a record is inserted into
1595: -- CSD_REPAIR_JOB_XREF for each combination of repair_line_id and repair Job.
1596: -- Once WIP Mass Load successfully completes, WIP_UPDATE API is called here to update
1597: -- the newly inserted records in CSD_REPAIR_JOB_XREF with the wip_entity_id of the
1598: -- corresponding jobs from WIP.
1599:
1593:
1594: -- When Repair Jobs are submitted to WIP Mass Load, a record is inserted into
1595: -- CSD_REPAIR_JOB_XREF for each combination of repair_line_id and repair Job.
1596: -- Once WIP Mass Load successfully completes, WIP_UPDATE API is called here to update
1597: -- the newly inserted records in CSD_REPAIR_JOB_XREF with the wip_entity_id of the
1598: -- corresponding jobs from WIP.
1599:
1600: -- Here p_upd_job_completion is specified as 'N'
1601: -- so that only the WIP Creation Update program is run, the WIP Completion Update program
2015: ROLLBACK to CREATE_WIP_JOB_PVT ;
2016: RETURN;
2017:
2018: END IF;
2019: -- call procedures to insert a row in csd_repair_job_xref
2020: -- and csd_repair_history tables for the job created.
2021:
2022: L_user_id := fnd_global.user_id;
2023: