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.

APPS.CSD_HV_WIP_JOB_PVT dependencies on MTL_TRANSACTIONS_INTERFACE

Line 146: select 'exists' from mtl_transactions_interface where

142: lc_error_process_status CONSTANT NUMBER := 3;
143:
144:
145: Cursor check_txn_int_interface_errors IS
146: select 'exists' from mtl_transactions_interface where
147: transaction_header_id = p_transaction_header_id
148: and process_flag = lc_error_process_status;
149:
150: l_error_exists VARCHAR2(6);

Line 718: p_transactions_interface_rec IN mtl_transactions_interface%ROWTYPE,

714:
715:
716: PROCEDURE insert_transactions_header
717: (
718: p_transactions_interface_rec IN mtl_transactions_interface%ROWTYPE,
719: x_return_status OUT NOCOPY VARCHAR2
720: )
721: IS
722:

Line 726: l_transactions_interface_rec mtl_transactions_interface%ROWTYPE := p_transactions_interface_rec;

722:
723: -- Job Record to hold the Job Details information being inserted
724: -- into wip_job_dtls_interface
725:
726: l_transactions_interface_rec mtl_transactions_interface%ROWTYPE := p_transactions_interface_rec;
727:
728:
729: -- constant used for FND_LOG debug messages
730:

Line 734: -- Constants Used for Inserting into mtl_transactions_interface,

730:
731: lc_mod_name CONSTANT VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.insert_transactions_header.';
732:
733:
734: -- Constants Used for Inserting into mtl_transactions_interface,
735:
736: lc_concurrent_mode CONSTANT NUMBER := 1;
737: lc_yes_process_flag CONSTANT NUMBER := 1;
738:

Line 771: --insert into table mtl_transactions_interface

767: l_transactions_interface_rec.last_updated_by := fnd_global.user_id;
768: l_transactions_interface_rec.last_update_login := fnd_global.login_id;
769:
770:
771: --insert into table mtl_transactions_interface
772: BEGIN
773:
774: INSERT INTO mtl_transactions_interface
775: (last_updated_by,

Line 774: INSERT INTO mtl_transactions_interface

770:
771: --insert into table mtl_transactions_interface
772: BEGIN
773:
774: INSERT INTO mtl_transactions_interface
775: (last_updated_by,
776: last_update_date,
777: last_update_login,
778: created_by,

Line 862: p_transactions_interface_rec IN mtl_transactions_interface%ROWTYPE,

858:
859:
860: PROCEDURE update_transactions_header
861: (
862: p_transactions_interface_rec IN mtl_transactions_interface%ROWTYPE,
863: x_return_status OUT NOCOPY VARCHAR2
864: )
865: IS
866:

Line 889: --update table mtl_transactions_interface

885: x_return_status := FND_API.G_RET_STS_SUCCESS;
886:
887:
888:
889: --update table mtl_transactions_interface
890: BEGIN
891:
892: /* dbms_output.put_line( 'p_transactions_interface_rec.transaction_interface_id is ' ||
893: p_transactions_interface_rec.transaction_interface_id ); */

Line 895: UPDATE mtl_transactions_interface

891:
892: /* dbms_output.put_line( 'p_transactions_interface_rec.transaction_interface_id is ' ||
893: p_transactions_interface_rec.transaction_interface_id ); */
894:
895: UPDATE mtl_transactions_interface
896: SET
897: subinventory_code = p_transactions_interface_rec.subinventory_code,
898: locator_id = p_transactions_interface_rec.locator_id,
899: revision = p_transactions_interface_rec.revision,

Line 967: --insert into table mtl_transactions_interface

963: l_last_updated_by := fnd_global.user_id;
964: l_last_update_login := fnd_global.login_id;
965:
966:
967: --insert into table mtl_transactions_interface
968: BEGIN
969:
970: INSERT INTO mtl_transaction_lots_interface
971: (last_updated_by,

Line 1080: --insert into table mtl_transactions_interface

1076: l_last_updated_by := fnd_global.user_id;
1077: l_last_update_login := fnd_global.login_id;
1078:
1079:
1080: --insert into table mtl_transactions_interface
1081: BEGIN
1082:
1083: INSERT INTO mtl_serial_numbers_interface
1084: ( last_updated_by,

Line 1138: -- Constants Used for Inserting into mtl_transactions_interface,

1134:
1135: lc_mod_name CONSTANT VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.insert_transactions_header.';
1136:
1137:
1138: -- Constants Used for Inserting into mtl_transactions_interface,
1139:
1140: lc_concurrent_mode CONSTANT NUMBER := 1;
1141: lc_yes_process_flag CONSTANT NUMBER := 1;
1142:

Line 1590: -- Constants used for inserting into mtl_transactions_interface

1586: lc_dyn_loc_cntrl CONSTANT NUMBER := 3;
1587: lc_subinv_lv_loc_cntrl CONSTANT NUMBER := 4;
1588: lc_inv_lv_loc_cntrl CONSTANT NUMBER := 5;
1589:
1590: -- Constants used for inserting into mtl_transactions_interface
1591: lc_completion_source_code CONSTANT VARCHAR2(30) := 'WIP Completion';
1592: lc_wip_txn_source_type_id CONSTANT NUMBER := 5;
1593: lc_comp_txn_type CONSTANT NUMBER := 44;
1594: lc_non_std_wip_ent_type CONSTANT NUMBER := 3;

Line 1598: -- Records to hold the mtl_transactions_interface data

1594: lc_non_std_wip_ent_type CONSTANT NUMBER := 3;
1595: lc_dummy_source_line_id CONSTANT NUMBER := -2;
1596: lc_n_final_completion_flag CONSTANT VARCHAR2(1) := 'N' ;
1597:
1598: -- Records to hold the mtl_transactions_interface data
1599: l_transactions_interface_rec mtl_transactions_interface%ROWTYPE;
1600:
1601: l_locator_controlled VARCHAR2(1) := 'F';
1602: l_revision_qty_control_code NUMBER;

Line 1599: l_transactions_interface_rec mtl_transactions_interface%ROWTYPE;

1595: lc_dummy_source_line_id CONSTANT NUMBER := -2;
1596: lc_n_final_completion_flag CONSTANT VARCHAR2(1) := 'N' ;
1597:
1598: -- Records to hold the mtl_transactions_interface data
1599: l_transactions_interface_rec mtl_transactions_interface%ROWTYPE;
1600:
1601: l_locator_controlled VARCHAR2(1) := 'F';
1602: l_revision_qty_control_code NUMBER;
1603: l_transaction_quantity NUMBER;

Line 1864: --insert into table mtl_transactions_interface

1860:
1861: IF ( l_transaction_quantity > 1 ) THEN
1862: l_transactions_interface_rec.transaction_quantity := 1;
1863:
1864: --insert into table mtl_transactions_interface
1865: FOR l_qty_ctr IN 1..l_transaction_quantity
1866: LOOP
1867: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1868: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,

Line 1888: --insert into table mtl_transactions_interface

1884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1885: END IF;
1886: END LOOP;
1887: ELSE -- Quantity = 1
1888: --insert into table mtl_transactions_interface
1889: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1890: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
1891: lc_mod_name||'beforecallinserttxnshdr',
1892: 'Just before calling insert_transactions_header');

Line 1909: --insert into table mtl_transactions_interface

1905: -- -1 identifies rows which are queried up in the details UI
1906: l_transactions_interface_rec.source_line_id := -1;
1907: END IF;
1908:
1909: --insert into table mtl_transactions_interface
1910: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1911: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
1912: lc_mod_name||'beforecallinserttxnshdr',
1913: 'Just before calling insert_transactions_header');

Line 2514: -- Constants used for inserting into mtl_transactions_interface

2510: -- lc_mrp_net_flag CONSTANT NUMBER := 1;
2511: -- 11/7/05
2512: -- lc_push_wip_supply_type CONSTANT NUMBER := 1;
2513:
2514: -- Constants used for inserting into mtl_transactions_interface
2515:
2516: lc_issue_source_code CONSTANT VARCHAR2(30) := 'WIP Issue';
2517: lc_wip_txn_source_type_id CONSTANT NUMBER := 5;
2518: lc_issue_txn_type CONSTANT NUMBER := 35;

Line 2525: -- and mtl_transactions_interface data

2521: lc_n_final_completion_flag CONSTANT VARCHAR2(1) := 'N' ;
2522:
2523:
2524: -- Records to hold the Job header,details
2525: -- and mtl_transactions_interface data
2526:
2527: l_transactions_interface_rec mtl_transactions_interface%ROWTYPE;
2528: l_srl_nmbrs_interface_rec mtl_serial_numbers_interface%ROWTYPE;
2529: l_job_header_rec wip_job_schedule_interface%ROWTYPE;

Line 2527: l_transactions_interface_rec mtl_transactions_interface%ROWTYPE;

2523:
2524: -- Records to hold the Job header,details
2525: -- and mtl_transactions_interface data
2526:
2527: l_transactions_interface_rec mtl_transactions_interface%ROWTYPE;
2528: l_srl_nmbrs_interface_rec mtl_serial_numbers_interface%ROWTYPE;
2529: l_job_header_rec wip_job_schedule_interface%ROWTYPE;
2530: l_job_details_rec wip_job_dtls_interface%ROWTYPE;
2531:

Line 2849: --insert into table mtl_transactions_interface

2845: FOR l_qty_ctr IN 1..abs(p_mtl_txn_dtls_tbl(mtl_ctr).transaction_quantity)
2846: LOOP
2847:
2848:
2849: --insert into table mtl_transactions_interface
2850:
2851: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2852: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
2853: lc_mod_name||'beforecallinserttxnshdr',

Line 2923: --insert into table mtl_transactions_interface

2919: l_transactions_interface_rec.source_line_id := -1;
2920: -- -1 identifies rows which are queried up in the details UI
2921: end if;
2922:
2923: --insert into table mtl_transactions_interface
2924:
2925: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2926: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
2927: lc_mod_name||'beforecallinserttxnshdr',

Line 2956: --insert into table mtl_transactions_interface

2952: -- -1 identifies rows which are queried up in the details UI
2953: END IF;
2954:
2955:
2956: --insert into table mtl_transactions_interface
2957:
2958: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2959: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
2960: lc_mod_name||'beforecallinserttxnshdr',

Line 3499: -- Records to hold mtl_transactions_interface data

3495: lc_full_lot_control CONSTANT NUMBER := 2;
3496: lc_predefined_serial_control CONSTANT NUMBER := 2;
3497: lc_inven_rct_srl_control CONSTANT NUMBER := 5;
3498:
3499: -- Records to hold mtl_transactions_interface data
3500: l_transactions_interface_rec mtl_transactions_interface%ROWTYPE;
3501: l_txn_lots_interface_rec mtl_transaction_lots_interface%ROWTYPE;
3502: l_srl_nmbrs_interface_rec mtl_serial_numbers_interface%ROWTYPE;
3503:

Line 3500: l_transactions_interface_rec mtl_transactions_interface%ROWTYPE;

3496: lc_predefined_serial_control CONSTANT NUMBER := 2;
3497: lc_inven_rct_srl_control CONSTANT NUMBER := 5;
3498:
3499: -- Records to hold mtl_transactions_interface data
3500: l_transactions_interface_rec mtl_transactions_interface%ROWTYPE;
3501: l_txn_lots_interface_rec mtl_transaction_lots_interface%ROWTYPE;
3502: l_srl_nmbrs_interface_rec mtl_serial_numbers_interface%ROWTYPE;
3503:
3504: CURSOR get_mtl_header_id IS

Line 3541: --Update table mtl_transactions_interface

3537: l_transactions_interface_rec.transaction_interface_id := p_mtl_txn_dtls_tbl(mtl_ctr).transaction_interface_id;
3538: l_transactions_interface_rec.source_line_id := p_mtl_txn_dtls_tbl(mtl_ctr).operation_seq_num;
3539: l_transactions_interface_rec.reason_id := p_mtl_txn_dtls_tbl(mtl_ctr).reason_id; -- swai bug 6841113
3540:
3541: --Update table mtl_transactions_interface
3542: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3543: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
3544: lc_mod_name||'beforecallupdtxnhdr',
3545: 'Just before calling update_transactions_header');