eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.CSD_WIP_JOB_PVT dependencies on CSD_WIP_JOB_PVT

Line 1: PACKAGE BODY CSD_WIP_JOB_PVT AS

1: PACKAGE BODY CSD_WIP_JOB_PVT AS
2: /* $Header: csdvwjbb.pls 120.20.12020000.4 2013/04/10 01:07:37 takwong 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.

Line 4: -- Package name : CSD_WIP_JOB_PVT

1: PACKAGE BODY CSD_WIP_JOB_PVT AS
2: /* $Header: csdvwjbb.pls 120.20.12020000.4 2013/04/10 01:07:37 takwong 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

Line 24: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_WIP_JOB_PVT';

20: -- End of Comments
21:
22:
23: -- Define Global Variable --
24: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_WIP_JOB_PVT';
25: g_job_prefix VARCHAR2(30) := fnd_profile.value('CSD_DEFAULT_JOB_PREFIX');
26:
27: -- This procedure accepts job header, bills and routing information and inserts it into
28: -- WIP_JOB_SCHEDULE_INTERFACE table. This procedure inserts one record at a time, hence

Line 53: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_wip_job_pvt.insert_job_header.';

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

Line 272: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_wip_job_pvt.insert_job_header.';

268: -- variables used for FND_LOG debug messages
269:
270: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
271: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
272: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_wip_job_pvt.insert_job_header.';
273:
274:
275: -- Constants Used for Inserting into wip_job_schedule_interface,
276: -- These are the values needed for WIP Mass Load to pick up the records

Line 875: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_wip_job_pvt.submit_jobs.';

871: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
872: l_stat_level NUMBER := FND_LOG.LEVEL_STATEMENT;
873: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
874: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
875: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_wip_job_pvt.submit_jobs.';
876:
877: l_default_ro_item VARCHAR2(1);
878: l_wip_entity_id NUMBER;
879: l_mtl_txn_dtls_tbl CSD_HV_WIP_JOB_PVT.MTL_TXN_DTLS_TBL_TYPE;

Line 1463: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'CSD_WIP_JOB_PVT',

1459:
1460: -- Add Unexpected Error to Message List, here SQLERRM is used for
1461: -- getting the error
1462:
1463: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'CSD_WIP_JOB_PVT',
1464: p_procedure_name => 'submit_jobs');
1465: END IF;
1466:
1467: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 1540: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_wip_job_pvt.submit_wip_mass_load_conc.';

1536: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1537: l_stat_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1538: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1539: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
1540: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_wip_job_pvt.submit_wip_mass_load_conc.';
1541: -- subhat, bug#13586864 changes.
1542: l_repair_line_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1543: l_operation_seq_num NUMBER := 0;
1544:

Line 1979: lc_mod_name CONSTANT VARCHAR2(2000) := 'csd.plsql.csd_wip_job_pvt.create_job_from_estimate';

1975:
1976:
1977: -- Constants used for FND_LOG debug messages
1978:
1979: lc_mod_name CONSTANT VARCHAR2(2000) := 'csd.plsql.csd_wip_job_pvt.create_job_from_estimate';
1980:
1981:
1982:
1983: l_user_id NUMBER;

Line 2458: lc_mod_name VARCHAR2(200) := 'csd.plsql.csd_wip_job_pvt.create_matrl_reqmnt_from_estimates';

2454: p_rep_line_id IN NUMBER,
2455: p_wip_entity_id IN NUMBER
2456: ) IS
2457:
2458: lc_mod_name VARCHAR2(200) := 'csd.plsql.csd_wip_job_pvt.create_matrl_reqmnt_from_estimates';
2459:
2460: --table type to hold the material requirement line.
2461:
2462: x_mtl_txn_dtls_tab_type CSD_HV_WIP_JOB_PVT.mtl_txn_dtls_tbl_type;

Line 2564: lc_module_name VARCHAR2(80) := 'csd.plsql.csd_wip_job_pvt.bulk_submit_jobs';

2560: x_request_id OUT NOCOPY NUMBER,
2561: p_scheduling_priority IN NUMBER DEFAULT NULL
2562: )
2563: IS
2564: lc_module_name VARCHAR2(80) := 'csd.plsql.csd_wip_job_pvt.bulk_submit_jobs';
2565: lc_api_version NUMBER := 1.0;
2566: l_job_header_tbl job_header_tbl;
2567: l_job_header_index NUMBER := 1;
2568: l_sc_sql_executed BOOLEAN := FALSE;

Line 2715: CSD_WIP_JOB_PVT.generate_job_name(g_job_prefix,p_inventory_org_id,lx_job_name);

2711: ELSE
2712: l_job_header_tbl(l_job_header_index).net_quantity := 0;
2713: END IF;
2714: -- get the job name.
2715: CSD_WIP_JOB_PVT.generate_job_name(g_job_prefix,p_inventory_org_id,lx_job_name);
2716:
2717: l_job_header_tbl(l_job_header_index).job_name := lx_job_name;
2718: l_job_header_tbl(l_job_header_index).class_code := p_accouting_class;
2719:

Line 2776: CSD_WIP_JOB_PVT.generate_job_name(g_job_prefix,p_inventory_org_id,lx_job_name);

2772: ELSE
2773: l_job_header_tbl(l_job_header_index).net_quantity := 0;
2774: END IF;
2775: -- get the job name.
2776: CSD_WIP_JOB_PVT.generate_job_name(g_job_prefix,p_inventory_org_id,lx_job_name);
2777:
2778: l_job_header_tbl(l_job_header_index).job_name := lx_job_name;
2779: l_job_header_tbl(l_job_header_index).class_code := p_accouting_class;
2780:

Line 2935: END CSD_WIP_JOB_PVT;

2931: END Delete_Completed_Wip_Records;
2932:
2933: --bug#12316893
2934:
2935: END CSD_WIP_JOB_PVT;