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: -- yvchen: bug 13399147 - cursor to get the errors.

Line 159: FROM mtl_transactions_interface mti

155: -- a user-friendly message that should be shown to
156: -- the user.
157: Cursor get_txn_interface_errors IS
158: SELECT error_explanation --,error_code
159: FROM mtl_transactions_interface mti
160: WHERE transaction_header_id = p_transaction_header_id
161: AND mti.process_flag = lc_error_process_status
162: AND mti.lock_flag = 2;
163:

Line 758: p_transactions_interface_rec IN mtl_transactions_interface%ROWTYPE,

754:
755:
756: PROCEDURE insert_transactions_header
757: (
758: p_transactions_interface_rec IN mtl_transactions_interface%ROWTYPE,
759: x_return_status OUT NOCOPY VARCHAR2
760: )
761: IS
762:

Line 766: l_transactions_interface_rec mtl_transactions_interface%ROWTYPE := p_transactions_interface_rec;

762:
763: -- Job Record to hold the Job Details information being inserted
764: -- into wip_job_dtls_interface
765:
766: l_transactions_interface_rec mtl_transactions_interface%ROWTYPE := p_transactions_interface_rec;
767:
768:
769: -- constant used for FND_LOG debug messages
770:

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

770:
771: lc_mod_name CONSTANT VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.insert_transactions_header.';
772:
773:
774: -- Constants Used for Inserting into mtl_transactions_interface,
775:
776: lc_concurrent_mode CONSTANT NUMBER := 1;
777: lc_yes_process_flag CONSTANT NUMBER := 1;
778:

Line 811: --insert into table mtl_transactions_interface

807: l_transactions_interface_rec.last_updated_by := fnd_global.user_id;
808: l_transactions_interface_rec.last_update_login := fnd_global.login_id;
809:
810:
811: --insert into table mtl_transactions_interface
812: BEGIN
813:
814: INSERT INTO mtl_transactions_interface
815: (last_updated_by,

Line 814: INSERT INTO mtl_transactions_interface

810:
811: --insert into table mtl_transactions_interface
812: BEGIN
813:
814: INSERT INTO mtl_transactions_interface
815: (last_updated_by,
816: last_update_date,
817: last_update_login,
818: created_by,

Line 902: p_transactions_interface_rec IN mtl_transactions_interface%ROWTYPE,

898:
899:
900: PROCEDURE update_transactions_header
901: (
902: p_transactions_interface_rec IN mtl_transactions_interface%ROWTYPE,
903: x_return_status OUT NOCOPY VARCHAR2
904: )
905: IS
906:

Line 929: --update table mtl_transactions_interface

925: x_return_status := FND_API.G_RET_STS_SUCCESS;
926:
927:
928:
929: --update table mtl_transactions_interface
930: BEGIN
931:
932: /* dbms_output.put_line( 'p_transactions_interface_rec.transaction_interface_id is ' ||
933: p_transactions_interface_rec.transaction_interface_id ); */

Line 935: UPDATE mtl_transactions_interface

931:
932: /* dbms_output.put_line( 'p_transactions_interface_rec.transaction_interface_id is ' ||
933: p_transactions_interface_rec.transaction_interface_id ); */
934:
935: UPDATE mtl_transactions_interface
936: SET
937: subinventory_code = p_transactions_interface_rec.subinventory_code,
938: locator_id = p_transactions_interface_rec.locator_id,
939: revision = p_transactions_interface_rec.revision,

Line 1007: --insert into table mtl_transactions_interface

1003: l_last_updated_by := fnd_global.user_id;
1004: l_last_update_login := fnd_global.login_id;
1005:
1006:
1007: --insert into table mtl_transactions_interface
1008: BEGIN
1009:
1010: INSERT INTO mtl_transaction_lots_interface
1011: (last_updated_by,

Line 1120: --insert into table mtl_transactions_interface

1116: l_last_updated_by := fnd_global.user_id;
1117: l_last_update_login := fnd_global.login_id;
1118:
1119:
1120: --insert into table mtl_transactions_interface
1121: BEGIN
1122:
1123: INSERT INTO mtl_serial_numbers_interface
1124: ( last_updated_by,

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

1174:
1175: lc_mod_name CONSTANT VARCHAR2(2000) := 'csd.plsql.csd_hv_wip_job_pvt.insert_transactions_header.';
1176:
1177:
1178: -- Constants Used for Inserting into mtl_transactions_interface,
1179:
1180: lc_concurrent_mode CONSTANT NUMBER := 1;
1181: lc_yes_process_flag CONSTANT NUMBER := 1;
1182:

Line 1789: -- Constants used for inserting into mtl_transactions_interface

1785: lc_dyn_loc_cntrl CONSTANT NUMBER := 3;
1786: lc_subinv_lv_loc_cntrl CONSTANT NUMBER := 4;
1787: lc_inv_lv_loc_cntrl CONSTANT NUMBER := 5;
1788:
1789: -- Constants used for inserting into mtl_transactions_interface
1790: lc_completion_source_code CONSTANT VARCHAR2(30) := 'WIP Completion';
1791: lc_wip_txn_source_type_id CONSTANT NUMBER := 5;
1792: lc_comp_txn_type CONSTANT NUMBER := 44;
1793: lc_non_std_wip_ent_type CONSTANT NUMBER := 3;

Line 1800: -- Records to hold the mtl_transactions_interface data

1796: -- final completion flag will not be constant. Rather will be populated from wip_parameters.
1797: -- swai: bug 14704127 (FP of bug#14264436, subhat)
1798: lc_n_final_completion_flag VARCHAR2(1) := 'N' ;
1799:
1800: -- Records to hold the mtl_transactions_interface data
1801: l_transactions_interface_rec mtl_transactions_interface%ROWTYPE;
1802:
1803: l_locator_controlled VARCHAR2(1) := 'F';
1804: l_revision_qty_control_code NUMBER;

Line 1801: l_transactions_interface_rec mtl_transactions_interface%ROWTYPE;

1797: -- swai: bug 14704127 (FP of bug#14264436, subhat)
1798: lc_n_final_completion_flag VARCHAR2(1) := 'N' ;
1799:
1800: -- Records to hold the mtl_transactions_interface data
1801: l_transactions_interface_rec mtl_transactions_interface%ROWTYPE;
1802:
1803: l_locator_controlled VARCHAR2(1) := 'F';
1804: l_revision_qty_control_code NUMBER;
1805: l_transaction_quantity NUMBER;

Line 2070: --insert into table mtl_transactions_interface

2066:
2067: IF ( l_transaction_quantity > 1 ) THEN
2068: l_transactions_interface_rec.transaction_quantity := 1;
2069:
2070: --insert into table mtl_transactions_interface
2071: FOR l_qty_ctr IN 1..l_transaction_quantity
2072: LOOP
2073: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2074: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,

Line 2116: --insert into table mtl_transactions_interface

2112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2113: END IF;
2114: END LOOP;
2115: ELSE -- Quantity = 1
2116: --insert into table mtl_transactions_interface
2117: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2118: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
2119: lc_mod_name||'beforecallinserttxnshdr',
2120: 'Just before calling insert_transactions_header');

Line 2159: --insert into table mtl_transactions_interface

2155: -- -1 identifies rows which are queried up in the details UI
2156: l_transactions_interface_rec.source_line_id := -1;
2157: END IF;
2158:
2159: --insert into table mtl_transactions_interface
2160: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2161: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
2162: lc_mod_name||'beforecallinserttxnshdr',
2163: 'Just before calling insert_transactions_header');

Line 2313: FROM mtl_transactions_interface

2309: -- get the wip entity ids being processed.
2310: -- swai: bug 13820264, FP of bug#13797285, subhat
2311: SELECT DISTINCT transaction_source_id
2312: BULK COLLECT INTO l_wip_entity_ids
2313: FROM mtl_transactions_interface
2314: WHERE transaction_header_id = p_txn_header_id;
2315:
2316: -- Populate the constant values
2317: l_table := lc_MTI_source_table;

Line 2347: 'delete from mtl_transactions_interface');

2343:
2344: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2345: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
2346: lc_mod_name||'Error',
2347: 'delete from mtl_transactions_interface');
2348: END IF;
2349:
2350: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2351: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,

Line 2356: delete from mtl_transactions_interface where transaction_header_id = p_txn_header_id;

2352: lc_mod_name||'Error',
2353: 'p_txn_header_id :' ||p_txn_header_id );
2354: END IF;
2355:
2356: delete from mtl_transactions_interface where transaction_header_id = p_txn_header_id;
2357: End If;
2358: End if;
2359: --bug#14456229 --14497341
2360:

Line 2852: -- Constants used for inserting into mtl_transactions_interface

2848: -- lc_mrp_net_flag CONSTANT NUMBER := 1;
2849: -- 11/7/05
2850: -- lc_push_wip_supply_type CONSTANT NUMBER := 1;
2851:
2852: -- Constants used for inserting into mtl_transactions_interface
2853:
2854: lc_issue_source_code CONSTANT VARCHAR2(30) := 'WIP Issue';
2855: lc_wip_txn_source_type_id CONSTANT NUMBER := 5;
2856: lc_issue_txn_type CONSTANT NUMBER := 35;

Line 2863: -- and mtl_transactions_interface data

2859: lc_n_final_completion_flag CONSTANT VARCHAR2(1) := 'N' ;
2860:
2861:
2862: -- Records to hold the Job header,details
2863: -- and mtl_transactions_interface data
2864:
2865: l_transactions_interface_rec mtl_transactions_interface%ROWTYPE;
2866: l_srl_nmbrs_interface_rec mtl_serial_numbers_interface%ROWTYPE;
2867: l_job_header_rec wip_job_schedule_interface%ROWTYPE;

Line 2865: l_transactions_interface_rec mtl_transactions_interface%ROWTYPE;

2861:
2862: -- Records to hold the Job header,details
2863: -- and mtl_transactions_interface data
2864:
2865: l_transactions_interface_rec mtl_transactions_interface%ROWTYPE;
2866: l_srl_nmbrs_interface_rec mtl_serial_numbers_interface%ROWTYPE;
2867: l_job_header_rec wip_job_schedule_interface%ROWTYPE;
2868: l_job_details_rec wip_job_dtls_interface%ROWTYPE;
2869:

Line 3206: --insert into table mtl_transactions_interface

3202: FOR l_qty_ctr IN 1..abs(p_mtl_txn_dtls_tbl(mtl_ctr).transaction_quantity)
3203: LOOP
3204:
3205:
3206: --insert into table mtl_transactions_interface
3207:
3208: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3209: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
3210: lc_mod_name||'beforecallinserttxnshdr',

Line 3280: --insert into table mtl_transactions_interface

3276: l_transactions_interface_rec.source_line_id := -1;
3277: -- -1 identifies rows which are queried up in the details UI
3278: end if;
3279:
3280: --insert into table mtl_transactions_interface
3281:
3282: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3283: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
3284: lc_mod_name||'beforecallinserttxnshdr',

Line 3313: --insert into table mtl_transactions_interface

3309: -- -1 identifies rows which are queried up in the details UI
3310: END IF;
3311:
3312:
3313: --insert into table mtl_transactions_interface
3314:
3315: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3316: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
3317: lc_mod_name||'beforecallinserttxnshdr',

Line 3936: -- Records to hold mtl_transactions_interface data

3932: lc_full_lot_control CONSTANT NUMBER := 2;
3933: lc_predefined_serial_control CONSTANT NUMBER := 2;
3934: lc_inven_rct_srl_control CONSTANT NUMBER := 5;
3935:
3936: -- Records to hold mtl_transactions_interface data
3937: l_transactions_interface_rec mtl_transactions_interface%ROWTYPE;
3938: l_txn_lots_interface_rec mtl_transaction_lots_interface%ROWTYPE;
3939: l_srl_nmbrs_interface_rec mtl_serial_numbers_interface%ROWTYPE;
3940:

Line 3937: l_transactions_interface_rec mtl_transactions_interface%ROWTYPE;

3933: lc_predefined_serial_control CONSTANT NUMBER := 2;
3934: lc_inven_rct_srl_control CONSTANT NUMBER := 5;
3935:
3936: -- Records to hold mtl_transactions_interface data
3937: l_transactions_interface_rec mtl_transactions_interface%ROWTYPE;
3938: l_txn_lots_interface_rec mtl_transaction_lots_interface%ROWTYPE;
3939: l_srl_nmbrs_interface_rec mtl_serial_numbers_interface%ROWTYPE;
3940:
3941: CURSOR get_mtl_header_id IS

Line 3978: --Update table mtl_transactions_interface

3974: l_transactions_interface_rec.transaction_interface_id := p_mtl_txn_dtls_tbl(mtl_ctr).transaction_interface_id;
3975: l_transactions_interface_rec.source_line_id := p_mtl_txn_dtls_tbl(mtl_ctr).operation_seq_num;
3976: l_transactions_interface_rec.reason_id := p_mtl_txn_dtls_tbl(mtl_ctr).reason_id; -- swai bug 6841113
3977:
3978: --Update table mtl_transactions_interface
3979: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3980: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
3981: lc_mod_name||'beforecallupdtxnhdr',
3982: 'Just before calling update_transactions_header');