[Home] [Help]
1: PACKAGE BODY CSD_WIP_JOB_PVT AS
2: /* $Header: csdvwjbb.pls 120.13.12010000.2 2008/10/15 20:39:07 swai ship $*/
3: -- Start of Comments
4: -- Package name : CSD_WIP_JOB_PVT
5: -- Purpose : This package submits and creates WIP jobs using WIP Mass Load.
1: PACKAGE BODY CSD_WIP_JOB_PVT AS
2: /* $Header: csdvwjbb.pls 120.13.12010000.2 2008/10/15 20:39:07 swai ship $*/
3: -- Start of Comments
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
20: -- End of Comments
21:
22:
23: -- Define Global Variable --
24: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_WIP_JOB_PVT';
25:
26:
27:
28: -- This procedure accepts job header, bills and routing information and inserts it into
49: -- variables used for FND_LOG debug messages
50:
51: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
52: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
53: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_wip_job_pvt.insert_job_header.';
54:
55:
56: -- Constants Used for Inserting into wip_job_schedule_interface,
57: -- These are the values needed for WIP Mass Load to pick up the records
263: -- variables used for FND_LOG debug messages
264:
265: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
266: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
267: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_wip_job_pvt.insert_job_header.';
268:
269:
270: -- Constants Used for Inserting into wip_job_schedule_interface,
271: -- These are the values needed for WIP Mass Load to pick up the records
866: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
867: l_stat_level NUMBER := FND_LOG.LEVEL_STATEMENT;
868: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
869: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
870: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_wip_job_pvt.submit_jobs.';
871:
872: l_default_ro_item VARCHAR2(1);
873: l_wip_entity_id NUMBER;
874: l_mtl_txn_dtls_tbl CSD_HV_WIP_JOB_PVT.MTL_TXN_DTLS_TBL_TYPE;
1407:
1408: -- Add Unexpected Error to Message List, here SQLERRM is used for
1409: -- getting the error
1410:
1411: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'CSD_WIP_JOB_PVT',
1412: p_procedure_name => 'submit_jobs');
1413: END IF;
1414:
1415: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1484: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1485: l_stat_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1486: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1487: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
1488: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_wip_job_pvt.submit_wip_mass_load_conc.';
1489:
1490:
1491:
1492:
1806:
1807:
1808: -- Constants used for FND_LOG debug messages
1809:
1810: lc_mod_name CONSTANT VARCHAR2(2000) := 'csd.plsql.csd_wip_job_pvt.create_job_from_estimate';
1811:
1812:
1813:
1814: l_user_id NUMBER;
2260: p_rep_line_id IN NUMBER,
2261: p_wip_entity_id IN NUMBER
2262: ) IS
2263:
2264: lc_mod_name VARCHAR2(200) := 'csd.plsql.csd_wip_job_pvt.create_matrl_reqmnt_from_estimates';
2265:
2266: --table type to hold the material requirement line.
2267:
2268: x_mtl_txn_dtls_tab_type CSD_HV_WIP_JOB_PVT.mtl_txn_dtls_tbl_type;
2333: p_count => x_msg_count,
2334: p_data => x_msg_data );
2335: END matrl_reqmnt_from_estms;
2336:
2337: END CSD_WIP_JOB_PVT;