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.GME_TRANSACTIONS_PVT dependencies on MTL_TRANSACTIONS_INTERFACE

Line 18: REM * mtl_transactions_interface table

14: REM *
15: REM *
16: REM * Archana Mundhe Bug 6437252 - LPN support
17: REM * Modified insert_txn_inter_hdr to insert lpn_id , transfer_lpn_id into
18: REM * mtl_transactions_interface table
19: REM * Modiied delete_material_txn to populate lpn_id or transfer_lpn_id
20: REM * into mtl_transactions_interface based on the transaction type
21: REM * Swapna K Bug 7226474
22: REM * Modified build_txn_inter_lot to insert attribute columns into

Line 20: REM * into mtl_transactions_interface based on the transaction type

16: REM * Archana Mundhe Bug 6437252 - LPN support
17: REM * Modified insert_txn_inter_hdr to insert lpn_id , transfer_lpn_id into
18: REM * mtl_transactions_interface table
19: REM * Modiied delete_material_txn to populate lpn_id or transfer_lpn_id
20: REM * into mtl_transactions_interface based on the transaction type
21: REM * Swapna K Bug 7226474
22: REM * Modified build_txn_inter_lot to insert attribute columns into
23: REM * mtl_transactions_interface table
24: REM * Archana Mundhe Bug 7385309

Line 23: REM * mtl_transactions_interface table

19: REM * Modiied delete_material_txn to populate lpn_id or transfer_lpn_id
20: REM * into mtl_transactions_interface based on the transaction type
21: REM * Swapna K Bug 7226474
22: REM * Modified build_txn_inter_lot to insert attribute columns into
23: REM * mtl_transactions_interface table
24: REM * Archana Mundhe Bug 7385309
25: REM * Modified procedure update_material_txn to create the transaction
26: REM * first and then delete.
27:

Line 148: p_mmti_rec IN mtl_transactions_interface%ROWTYPE

144: | Created 02-Feb-05 Pawan Kumar
145: |
146: +==========================================================================+ */
147: PROCEDURE create_material_txn (
148: p_mmti_rec IN mtl_transactions_interface%ROWTYPE
149: ,p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl
150: ,p_phantom_trans IN NUMBER DEFAULT 0
151: ,x_return_status OUT NOCOPY VARCHAR2)
152: IS

Line 155: l_mmti_rec mtl_transactions_interface%ROWTYPE;

151: ,x_return_status OUT NOCOPY VARCHAR2)
152: IS
153: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_MATERIAL_TXN';
154: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
155: l_mmti_rec mtl_transactions_interface%ROWTYPE;
156: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
157: m_mmti_rec mtl_transactions_interface%ROWTYPE;
158: m_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
159: x_mmti_rec mtl_transactions_interface%ROWTYPE;

Line 157: m_mmti_rec mtl_transactions_interface%ROWTYPE;

153: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_MATERIAL_TXN';
154: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
155: l_mmti_rec mtl_transactions_interface%ROWTYPE;
156: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
157: m_mmti_rec mtl_transactions_interface%ROWTYPE;
158: m_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
159: x_mmti_rec mtl_transactions_interface%ROWTYPE;
160: x_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
161: l_mat_dtl_rec gme_material_details%ROWTYPE;

Line 159: x_mmti_rec mtl_transactions_interface%ROWTYPE;

155: l_mmti_rec mtl_transactions_interface%ROWTYPE;
156: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
157: m_mmti_rec mtl_transactions_interface%ROWTYPE;
158: m_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
159: x_mmti_rec mtl_transactions_interface%ROWTYPE;
160: x_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
161: l_mat_dtl_rec gme_material_details%ROWTYPE;
162: m_mat_dtl_rec gme_material_details%ROWTYPE;
163: l_ret NUMBER;

Line 449: from mtl_transactions_interface

445:
446:
447: select count(*)
448: into l_cnt_int
449: from mtl_transactions_interface
450: where transaction_header_id= gme_common_pvt.g_transaction_header_id;
451: gme_debug.put_line ( g_pkg_name
452: || '.'
453: || l_api_name

Line 500: FOR get_msgs IN (SELECT error_explanation FROM mtl_transactions_interface

496: ,p_token1_name => 'MESSAGE'
497: ,p_token1_value => l_msg_data);
498: ELSE
499: /* Bug 5256543 Get messages from interface table and put on stack */
500: FOR get_msgs IN (SELECT error_explanation FROM mtl_transactions_interface
501: WHERE transaction_header_id = gme_common_pvt.g_transaction_header_id
502: AND error_explanation IS NOT NULL) LOOP
503: IF (g_debug <= gme_debug.g_log_statement) THEN
504: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'error_explanation is: '||get_msgs.error_explanation);

Line 662: ,p_mmti_rec IN mtl_transactions_interface%ROWTYPE

658: | update_material_txn is an overloaded function so we need to make same fix here.
659: +==========================================================================+ */
660: PROCEDURE update_material_txn (
661: p_transaction_id IN NUMBER
662: ,p_mmti_rec IN mtl_transactions_interface%ROWTYPE
663: ,p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl
664: ,x_return_status OUT NOCOPY VARCHAR2)
665: IS
666: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_MATERIAL_TXN';

Line 669: l_mmti_rec mtl_transactions_interface%ROWTYPE;

665: IS
666: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_MATERIAL_TXN';
667: l_mmt_rec mtl_material_transactions%ROWTYPE;
668: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
669: l_mmti_rec mtl_transactions_interface%ROWTYPE;
670: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
671: l_mat_dtl_rec gme_material_details%ROWTYPE;
672: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
673:

Line 877: l_mmti_rec mtl_transactions_interface%ROWTYPE;

873: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_MATERIAL_TXN-2';
874: l_transaction_id NUMBER;
875: l_mmt_rec mtl_material_transactions%ROWTYPE;
876: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
877: l_mmti_rec mtl_transactions_interface%ROWTYPE;
878: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
879: l_mat_dtl_rec gme_material_details%ROWTYPE;
880: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
881: create_material_txn_err EXCEPTION;

Line 1119: l_mmti_rec mtl_transactions_interface%ROWTYPE;

1115: l_transaction_id NUMBER;
1116: m_transaction_id NUMBER;
1117: l_mmt_rec mtl_material_transactions%ROWTYPE;
1118: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
1119: l_mmti_rec mtl_transactions_interface%ROWTYPE;
1120: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
1121: l_mat_dtl_rec gme_material_details%ROWTYPE;
1122: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
1123: create_material_txn_err EXCEPTION;

Line 1579: p_mmti_rec IN mtl_transactions_interface%ROWTYPE

1575: | G. Muratore 15-MAY-2012 Bug 14065291
1576: | Initialize secondary_quantity when necessary.
1577: +==========================================================================+ */
1578: PROCEDURE build_txn_inter (
1579: p_mmti_rec IN mtl_transactions_interface%ROWTYPE
1580: ,p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl
1581: ,p_assign_phantom IN NUMBER DEFAULT 0
1582: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
1583: ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl

Line 1582: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE

1578: PROCEDURE build_txn_inter (
1579: p_mmti_rec IN mtl_transactions_interface%ROWTYPE
1580: ,p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl
1581: ,p_assign_phantom IN NUMBER DEFAULT 0
1582: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
1583: ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl
1584: ,x_return_status OUT NOCOPY VARCHAR2)
1585: IS
1586: l_mmti_rec mtl_transactions_interface%ROWTYPE;

Line 1586: l_mmti_rec mtl_transactions_interface%ROWTYPE;

1582: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
1583: ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl
1584: ,x_return_status OUT NOCOPY VARCHAR2)
1585: IS
1586: l_mmti_rec mtl_transactions_interface%ROWTYPE;
1587: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
1588: l_api_name CONSTANT VARCHAR2 (30) := 'BUILD_TXN_INTER';
1589: x_header_id NUMBER;
1590: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;

Line 1879: p_mmti_rec IN mtl_transactions_interface%ROWTYPE

1875: | 13-Sep-05 Namit Singhi - Modified to include insert into transfer_lpn_id.
1876: |
1877: +==========================================================================+ */
1878: PROCEDURE build_txn_inter_hdr (
1879: p_mmti_rec IN mtl_transactions_interface%ROWTYPE
1880: ,p_assign_phantom IN NUMBER DEFAULT 0
1881: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
1882: ,x_return_status OUT NOCOPY VARCHAR2
1883: ,p_insert_hdr IN BOOLEAN DEFAULT TRUE)

Line 1881: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE

1877: +==========================================================================+ */
1878: PROCEDURE build_txn_inter_hdr (
1879: p_mmti_rec IN mtl_transactions_interface%ROWTYPE
1880: ,p_assign_phantom IN NUMBER DEFAULT 0
1881: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
1882: ,x_return_status OUT NOCOPY VARCHAR2
1883: ,p_insert_hdr IN BOOLEAN DEFAULT TRUE)
1884: IS
1885: CURSOR get_location (v_org_id IN NUMBER

Line 1893: l_mmti_rec mtl_transactions_interface%ROWTYPE;

1889: FROM wms_item_locations_kfv
1890: WHERE organization_id = v_org_id
1891: AND subinventory_code = v_sub_inv
1892: AND inventory_location_id (+) = v_loc_id;
1893: l_mmti_rec mtl_transactions_interface%ROWTYPE;
1894: l_api_name CONSTANT VARCHAR2 (30) := 'BUILD_TXN_INTER_hdr';
1895: x_header_id NUMBER;
1896: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
1897: l_item VARCHAR2(100);

Line 2744: | x_mmti_rec mtl_transactions_interface rowtype

Line 2753: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE

2749: +==========================================================================+ */
2750: PROCEDURE construct_mmti (
2751: p_mmt_rec IN mtl_material_transactions%ROWTYPE
2752: ,p_mmln_tbl IN gme_common_pvt.mtl_trans_lots_num_tbl
2753: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
2754: ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl
2755: ,x_return_status OUT NOCOPY VARCHAR2)
2756: IS
2757: l_mmt_rec mtl_material_transactions%ROWTYPE;

Line 2759: l_mmti_rec mtl_transactions_interface%ROWTYPE;

2755: ,x_return_status OUT NOCOPY VARCHAR2)
2756: IS
2757: l_mmt_rec mtl_material_transactions%ROWTYPE;
2758: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
2759: l_mmti_rec mtl_transactions_interface%ROWTYPE;
2760: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
2761: l_api_name CONSTANT VARCHAR2 (30) := 'CONSTRUCT_MMTI';
2762: BEGIN
2763: -- Initially let us assign the return status to success

Line 3108: FROM mtl_transactions_interface

3104: IS
3105: CURSOR cur_get_trans (v_hdr_id NUMBER)
3106: IS
3107: SELECT transaction_interface_id
3108: FROM mtl_transactions_interface
3109: WHERE transaction_header_id = v_hdr_id
3110: AND transaction_source_type_id = gme_common_pvt.g_txn_source_type
3111: AND wip_entity_type = gme_common_pvt.g_wip_entity_type_batch;
3112:

Line 3160: /* update mtl_transactions_interface

3156: || 'Exiting with '
3157: || x_return_status);
3158: END IF;
3159: EXCEPTION
3160: /* update mtl_transactions_interface
3161: set error_code = 'wip_mtlInterfaceProc_pub.processInterface()',
3162: error_explanation = l_errMessage,
3163: process_flag = wip_constants.mti_error
3164: where transaction_header_id = p_txnHdrID; */

Line 3204: p_mmti_rec IN mtl_transactions_interface%ROWTYPE,

3200: | Bug 13853087 - Modified cur_lot_qty query to pass lot_number and organization_id.
3201: +==========================================================================+ */
3202:
3203: PROCEDURE get_returnable_qty (
3204: p_mmti_rec IN mtl_transactions_interface%ROWTYPE,
3205: p_lot_number IN VARCHAR2,
3206: p_lot_control IN NUMBER,
3207: x_available_qty OUT NOCOPY NUMBER,
3208: x_return_status OUT NOCOPY VARCHAR2

Line 3383: FROM mtl_transactions_interface

3379: IS
3380: CURSOR cur_trans_detail (v_trans_inter_id NUMBER)
3381: IS
3382: SELECT *
3383: FROM mtl_transactions_interface
3384: WHERE transaction_interface_id = v_trans_inter_id;
3385:
3386:
3387: CURSOR cur_get_item_rec (v_item_id NUMBER, v_org_id NUMBER)

Line 3406: l_mmti_rec mtl_transactions_interface%ROWTYPE;

3402: FROM mtl_transaction_lots_interface
3403: WHERE transaction_interface_id = v_trans_inter_id
3404: GROUP BY lot_number;
3405:
3406: l_mmti_rec mtl_transactions_interface%ROWTYPE;
3407: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
3408: l_mat_dtl_rec gme_material_details%ROWTYPE;
3409: l_batch_hdr_rec gme_batch_header%ROWTYPE;
3410: l_item_rec mtl_system_items_b%ROWTYPE;

Line 3748: UPDATE mtl_transactions_interface

3744: ,p_encoded => fnd_api.g_false
3745: ,x_data => x_message_list);
3746:
3747: -- Bug 14685438 - limit error string to size of the field.
3748: UPDATE mtl_transactions_interface
3749: SET ERROR_CODE = g_pkg_name || '.' || p_api_name
3750: ,error_explanation = SUBSTR(NVL (x_message_list, l_errm), 1, 240)
3751: ,process_flag = 3 -- we can make it a constant in gme common
3752: WHERE transaction_interface_id = l_transaction_interface_id;

Line 4499: FROM mtl_transactions_interface

4495:
4496: CURSOR get_error_int
4497: IS
4498: SELECT ERROR_CODE, error_explanation
4499: FROM mtl_transactions_interface
4500: WHERE transaction_header_id =gme_common_pvt.g_transaction_header_id
4501: AND error_explanation IS NOT NULL;
4502:
4503: CURSOR get_error_temp

Line 4540: FROM mtl_transactions_interface

4536: WHERE transaction_header_id = p_header_id
4537: AND process_flag = 'Y'
4538: UNION ALL
4539: SELECT COUNT (*) cnt
4540: FROM mtl_transactions_interface
4541: WHERE transaction_header_id = p_header_id
4542: AND process_flag = 1
4543: );
4544:

Line 4618: FROM mtl_Transactions_interface

4614: END LOOP;
4615: ELSE
4616: FOR mti_rec_cur in
4617: (SELECT transaction_interface_id, inventory_item_id, organization_id
4618: FROM mtl_Transactions_interface
4619: WHERE transaction_header_id = p_header_id
4620: AND process_flag = 1) LOOP
4621: UPDATE mtl_transaction_lots_interface mti
4622: SET (grade_code, supplier_lot_number) =

Line 5459: PROCEDURE insert_txn_inter_hdr(p_mmti_rec IN mtl_transactions_interface%ROWTYPE,

5455: END IF;
5456: RETURN FALSE;
5457: END is_lot_expired;
5458:
5459: PROCEDURE insert_txn_inter_hdr(p_mmti_rec IN mtl_transactions_interface%ROWTYPE,
5460: x_return_status OUT NOCOPY VARCHAR2) IS
5461: l_api_name CONSTANT VARCHAR2 (30) := 'insert_txn_inter_hdr';
5462: BEGIN
5463: IF (NVL (g_debug, 0) IN (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

Line 5467: INSERT INTO mtl_transactions_interface

5463: IF (NVL (g_debug, 0) IN (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
5464: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || 'Entering');
5465: END IF;
5466: x_return_status := fnd_api.g_ret_sts_success;
5467: INSERT INTO mtl_transactions_interface
5468: (transaction_interface_id
5469: ,transaction_header_id
5470: ,source_code
5471: ,source_header_id

Line 5789: PROCEDURE gmo_pre_process_val(p_mmti_rec IN mtl_transactions_interface%ROWTYPE,

5785: END IF;
5786: END validate_lot_for_ing;
5787:
5788: /* Added for bug 5597385 */
5789: PROCEDURE gmo_pre_process_val(p_mmti_rec IN mtl_transactions_interface%ROWTYPE,
5790: p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl,
5791: p_mode IN VARCHAR2,
5792: x_return_status OUT NOCOPY VARCHAR2) IS
5793: CURSOR cur_get_item_rec (v_item_id NUMBER, v_org_id NUMBER) IS