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 43: p_mmti_rec IN mtl_transactions_interface%ROWTYPE

39: | Created 02-Feb-05 Pawan Kumar
40: |
41: +==========================================================================+ */
42: PROCEDURE create_material_txn (
43: p_mmti_rec IN mtl_transactions_interface%ROWTYPE
44: ,p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl
45: ,p_phantom_trans IN NUMBER DEFAULT 0
46: ,x_return_status OUT NOCOPY VARCHAR2)
47: IS

Line 50: l_mmti_rec mtl_transactions_interface%ROWTYPE;

46: ,x_return_status OUT NOCOPY VARCHAR2)
47: IS
48: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_MATERIAL_TXN';
49: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
50: l_mmti_rec mtl_transactions_interface%ROWTYPE;
51: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
52: m_mmti_rec mtl_transactions_interface%ROWTYPE;
53: m_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
54: x_mmti_rec mtl_transactions_interface%ROWTYPE;

Line 52: m_mmti_rec mtl_transactions_interface%ROWTYPE;

48: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_MATERIAL_TXN';
49: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
50: l_mmti_rec mtl_transactions_interface%ROWTYPE;
51: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
52: m_mmti_rec mtl_transactions_interface%ROWTYPE;
53: m_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
54: x_mmti_rec mtl_transactions_interface%ROWTYPE;
55: x_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
56: l_mat_dtl_rec gme_material_details%ROWTYPE;

Line 54: x_mmti_rec mtl_transactions_interface%ROWTYPE;

50: l_mmti_rec mtl_transactions_interface%ROWTYPE;
51: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
52: m_mmti_rec mtl_transactions_interface%ROWTYPE;
53: m_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
54: x_mmti_rec mtl_transactions_interface%ROWTYPE;
55: x_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
56: l_mat_dtl_rec gme_material_details%ROWTYPE;
57: m_mat_dtl_rec gme_material_details%ROWTYPE;
58: l_ret NUMBER;

Line 301: from mtl_transactions_interface

297:
298:
299: select count(*)
300: into l_cnt_int
301: from mtl_transactions_interface
302: where transaction_header_id= gme_common_pvt.g_transaction_header_id;
303: gme_debug.put_line ( g_pkg_name
304: || '.'
305: || l_api_name

Line 349: FOR get_msgs IN (SELECT error_explanation FROM mtl_transactions_interface

345: ,p_token1_name => 'MESSAGE'
346: ,p_token1_value => l_msg_data);
347: ELSE
348: /* Bug 5256543 Get messages from interface table and put on stack */
349: FOR get_msgs IN (SELECT error_explanation FROM mtl_transactions_interface
350: WHERE transaction_header_id = gme_common_pvt.g_transaction_header_id
351: AND error_explanation IS NOT NULL) LOOP
352: IF (g_debug <= gme_debug.g_log_statement) THEN
353: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'error_explanation is: '||get_msgs.error_explanation);

Line 417: ,p_mmti_rec IN mtl_transactions_interface%ROWTYPE

413: |
414: +==========================================================================+ */
415: PROCEDURE update_material_txn (
416: p_transaction_id IN NUMBER
417: ,p_mmti_rec IN mtl_transactions_interface%ROWTYPE
418: ,p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl
419: ,x_return_status OUT NOCOPY VARCHAR2)
420: IS
421: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_MATERIAL_TXN';

Line 425: l_mmti_rec mtl_transactions_interface%ROWTYPE;

421: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_MATERIAL_TXN';
422: l_transaction_id NUMBER;
423: l_mmt_rec mtl_material_transactions%ROWTYPE;
424: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
425: l_mmti_rec mtl_transactions_interface%ROWTYPE;
426: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
427: l_mat_dtl_rec gme_material_details%ROWTYPE;
428: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
429: create_material_txn_err EXCEPTION;

Line 544: l_mmti_rec mtl_transactions_interface%ROWTYPE;

540: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_MATERIAL_TXN-2';
541: l_transaction_id NUMBER;
542: l_mmt_rec mtl_material_transactions%ROWTYPE;
543: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
544: l_mmti_rec mtl_transactions_interface%ROWTYPE;
545: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
546: l_mat_dtl_rec gme_material_details%ROWTYPE;
547: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
548: create_material_txn_err EXCEPTION;

Line 703: l_mmti_rec mtl_transactions_interface%ROWTYPE;

699: l_transaction_id NUMBER;
700: m_transaction_id NUMBER;
701: l_mmt_rec mtl_material_transactions%ROWTYPE;
702: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
703: l_mmti_rec mtl_transactions_interface%ROWTYPE;
704: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
705: l_mat_dtl_rec gme_material_details%ROWTYPE;
706: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
707: create_material_txn_err EXCEPTION;

Line 1038: p_mmti_rec IN mtl_transactions_interface%ROWTYPE

1034: | Created 02-Feb-05 Pawan Kumar
1035: |
1036: +==========================================================================+ */
1037: PROCEDURE build_txn_inter (
1038: p_mmti_rec IN mtl_transactions_interface%ROWTYPE
1039: ,p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl
1040: ,p_assign_phantom IN NUMBER DEFAULT 0
1041: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
1042: ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl

Line 1041: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE

1037: PROCEDURE build_txn_inter (
1038: p_mmti_rec IN mtl_transactions_interface%ROWTYPE
1039: ,p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl
1040: ,p_assign_phantom IN NUMBER DEFAULT 0
1041: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
1042: ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl
1043: ,x_return_status OUT NOCOPY VARCHAR2)
1044: IS
1045: l_mmti_rec mtl_transactions_interface%ROWTYPE;

Line 1045: l_mmti_rec mtl_transactions_interface%ROWTYPE;

1041: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
1042: ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl
1043: ,x_return_status OUT NOCOPY VARCHAR2)
1044: IS
1045: l_mmti_rec mtl_transactions_interface%ROWTYPE;
1046: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
1047: l_api_name CONSTANT VARCHAR2 (30) := 'BUILD_TXN_INTER';
1048: x_header_id NUMBER;
1049: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;

Line 1231: p_mmti_rec IN mtl_transactions_interface%ROWTYPE

1227: | 13-Sep-05 Namit Singhi - Modified to include insert into transfer_lpn_id.
1228: |
1229: +==========================================================================+ */
1230: PROCEDURE build_txn_inter_hdr (
1231: p_mmti_rec IN mtl_transactions_interface%ROWTYPE
1232: ,p_assign_phantom IN NUMBER DEFAULT 0
1233: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
1234: ,x_return_status OUT NOCOPY VARCHAR2
1235: ,p_insert_hdr IN BOOLEAN DEFAULT TRUE)

Line 1233: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE

1229: +==========================================================================+ */
1230: PROCEDURE build_txn_inter_hdr (
1231: p_mmti_rec IN mtl_transactions_interface%ROWTYPE
1232: ,p_assign_phantom IN NUMBER DEFAULT 0
1233: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
1234: ,x_return_status OUT NOCOPY VARCHAR2
1235: ,p_insert_hdr IN BOOLEAN DEFAULT TRUE)
1236: IS
1237: CURSOR get_location (v_org_id IN NUMBER

Line 1245: l_mmti_rec mtl_transactions_interface%ROWTYPE;

1241: FROM wms_item_locations_kfv
1242: WHERE organization_id = v_org_id
1243: AND subinventory_code = v_sub_inv
1244: AND inventory_location_id (+) = v_loc_id;
1245: l_mmti_rec mtl_transactions_interface%ROWTYPE;
1246: l_api_name CONSTANT VARCHAR2 (30) := 'BUILD_TXN_INTER_hdr';
1247: x_header_id NUMBER;
1248: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
1249: l_item VARCHAR2(100);

Line 1956: | x_mmti_rec mtl_transactions_interface rowtype

Line 1965: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE

1961: +==========================================================================+ */
1962: PROCEDURE construct_mmti (
1963: p_mmt_rec IN mtl_material_transactions%ROWTYPE
1964: ,p_mmln_tbl IN gme_common_pvt.mtl_trans_lots_num_tbl
1965: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
1966: ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl
1967: ,x_return_status OUT NOCOPY VARCHAR2)
1968: IS
1969: l_mmt_rec mtl_material_transactions%ROWTYPE;

Line 1971: l_mmti_rec mtl_transactions_interface%ROWTYPE;

1967: ,x_return_status OUT NOCOPY VARCHAR2)
1968: IS
1969: l_mmt_rec mtl_material_transactions%ROWTYPE;
1970: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
1971: l_mmti_rec mtl_transactions_interface%ROWTYPE;
1972: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
1973: l_api_name CONSTANT VARCHAR2 (30) := 'CONSTRUCT_MMTI';
1974: BEGIN
1975: -- Initially let us assign the return status to success

Line 2260: FROM mtl_transactions_interface

2256: IS
2257: CURSOR cur_get_trans (v_hdr_id NUMBER)
2258: IS
2259: SELECT transaction_interface_id
2260: FROM mtl_transactions_interface
2261: WHERE transaction_header_id = v_hdr_id
2262: AND transaction_source_type_id = gme_common_pvt.g_txn_source_type
2263: AND wip_entity_type = gme_common_pvt.g_wip_entity_type_batch;
2264:

Line 2312: /* update mtl_transactions_interface

2308: || 'Exiting with '
2309: || x_return_status);
2310: END IF;
2311: EXCEPTION
2312: /* update mtl_transactions_interface
2313: set error_code = 'wip_mtlInterfaceProc_pub.processInterface()',
2314: error_explanation = l_errMessage,
2315: process_flag = wip_constants.mti_error
2316: where transaction_header_id = p_txnHdrID; */

Line 2356: p_mmti_rec IN mtl_transactions_interface%ROWTYPE,

2352: |
2353: +==========================================================================+ */
2354:
2355: PROCEDURE get_returnable_qty (
2356: p_mmti_rec IN mtl_transactions_interface%ROWTYPE,
2357: p_lot_number IN VARCHAR2,
2358: p_lot_control IN NUMBER,
2359: x_available_qty OUT NOCOPY NUMBER,
2360: x_return_status OUT NOCOPY VARCHAR2

Line 2533: FROM mtl_transactions_interface

2529: IS
2530: CURSOR cur_trans_detail (v_trans_inter_id NUMBER)
2531: IS
2532: SELECT *
2533: FROM mtl_transactions_interface
2534: WHERE transaction_interface_id = v_trans_inter_id;
2535:
2536:
2537: CURSOR cur_get_item_rec (v_item_id NUMBER, v_org_id NUMBER)

Line 2556: l_mmti_rec mtl_transactions_interface%ROWTYPE;

2552: FROM mtl_transaction_lots_interface
2553: WHERE transaction_interface_id = v_trans_inter_id
2554: GROUP BY lot_number;
2555:
2556: l_mmti_rec mtl_transactions_interface%ROWTYPE;
2557: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
2558: l_mat_dtl_rec gme_material_details%ROWTYPE;
2559: l_batch_hdr_rec gme_batch_header%ROWTYPE;
2560: l_item_rec mtl_system_items_b%ROWTYPE;

Line 2892: UPDATE mtl_transactions_interface

2888: gme_common_pvt.count_and_get (x_count => x_message_count
2889: ,p_encoded => fnd_api.g_false
2890: ,x_data => x_message_list);
2891:
2892: UPDATE mtl_transactions_interface
2893: SET ERROR_CODE = g_pkg_name || '.' || p_api_name
2894: ,error_explanation = NVL (x_message_list, l_errm)
2895: ,process_flag = 3 -- we can make it a constant in gme common
2896: WHERE transaction_interface_id = l_transaction_interface_id;

Line 3603: FROM mtl_transactions_interface

3599: IS
3600: CURSOR get_error_int
3601: IS
3602: SELECT ERROR_CODE, error_explanation
3603: FROM mtl_transactions_interface
3604: WHERE transaction_header_id =
3605: gme_common_pvt.g_transaction_header_id;
3606:
3607: CURSOR get_error_temp

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

4447: END IF;
4448: RETURN FALSE;
4449: END is_lot_expired;
4450:
4451: PROCEDURE insert_txn_inter_hdr(p_mmti_rec IN mtl_transactions_interface%ROWTYPE,
4452: x_return_status OUT NOCOPY VARCHAR2) IS
4453: l_api_name CONSTANT VARCHAR2 (30) := 'insert_txn_inter_hdr';
4454: BEGIN
4455: IF (NVL (g_debug, 0) IN (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

Line 4459: INSERT INTO mtl_transactions_interface

4455: IF (NVL (g_debug, 0) IN (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4456: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || 'Entering');
4457: END IF;
4458: x_return_status := fnd_api.g_ret_sts_success;
4459: INSERT INTO mtl_transactions_interface
4460: (transaction_interface_id
4461: ,transaction_header_id
4462: ,source_code
4463: ,source_header_id

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

4739: END IF;
4740: END validate_lot_for_ing;
4741:
4742: /* Added for bug 5597385 */
4743: PROCEDURE gmo_pre_process_val(p_mmti_rec IN mtl_transactions_interface%ROWTYPE,
4744: p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl,
4745: p_mode IN VARCHAR2,
4746: x_return_status OUT NOCOPY VARCHAR2) IS
4747: CURSOR cur_get_item_rec (v_item_id NUMBER, v_org_id NUMBER) IS