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.INV_RCV_STD_INSPECT_APIS dependencies on INV_RCV_INTEGRATION_APIS

Line 139: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;

135: l_serial_temp_id NUMBER;
136: l_lot_status_id NUMBER;
137: l_serial_status_id NUMBER;
138: l_lot_expiration_date DATE;
139: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
140: l_product_txn_id NUMBER;
141: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
142: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
143: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;

Line 141: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;

137: l_serial_status_id NUMBER;
138: l_lot_expiration_date DATE;
139: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
140: l_product_txn_id NUMBER;
141: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
142: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
143: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
144: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
145: l_is_rma NUMBER;

Line 142: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;

138: l_lot_expiration_date DATE;
139: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
140: l_product_txn_id NUMBER;
141: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
142: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
143: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
144: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
145: l_is_rma NUMBER;
146:

Line 143: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;

139: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
140: l_product_txn_id NUMBER;
141: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
142: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
143: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
144: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
145: l_is_rma NUMBER;
146:
147: l_origination_type number;--OPM Convergence

Line 179: inv_rcv_integration_apis.insert_mtli(

175: AND inventory_item_id = p_inventory_item_id
176: AND organization_id = p_organization_id;
177:
178: --Call the insert_mtli API
179: inv_rcv_integration_apis.insert_mtli(
180: p_api_version => 1.0
181: , p_init_msg_lst => l_false
182: , x_return_status => x_return_status
183: , x_msg_count => x_msg_count

Line 250: inv_rcv_integration_apis.insert_msni(

246: l_txn_if_id := l_serial_temp_id;
247: END IF;
248:
249: --Call the insert_msni API
250: inv_rcv_integration_apis.insert_msni(
251: p_api_version => 1.0
252: , p_init_msg_lst => l_false
253: , x_return_status => x_return_status
254: , x_msg_count => x_msg_count

Line 378: l_mo_splt_tb inv_rcv_integration_apis.mo_in_tb_tp;

374: l_rcv_transaction_id NUMBER := p_rcv_transaction_id;
375: l_return_status VARCHAR2 (5);
376: l_msg_count NUMBER;
377: l_msg_data VARCHAR2 (1000);
378: l_mo_splt_tb inv_rcv_integration_apis.mo_in_tb_tp;
379: l_new_mol_id NUMBER;
380: l_progress NUMBER;
381: l_lot_control_code NUMBER;
382: l_serial_control_code NUMBER;

Line 396: := inv_rcv_integration_apis.g_false;

392: l_expiration_action_code VARCHAR2 (32); --OPM Convergence
393: l_expiration_action_date DATE; --OPM Convergence
394: l_hold_date DATE; --OPM Convergence
395: l_false VARCHAR2 (1)
396: := inv_rcv_integration_apis.g_false;
397: l_txn_if_id NUMBER;
398: l_serial_temp_id NUMBER;
399: l_prod_code VARCHAR2 (5)
400: := inv_rcv_integration_apis.g_prod_code;

Line 400: := inv_rcv_integration_apis.g_prod_code;

396: := inv_rcv_integration_apis.g_false;
397: l_txn_if_id NUMBER;
398: l_serial_temp_id NUMBER;
399: l_prod_code VARCHAR2 (5)
400: := inv_rcv_integration_apis.g_prod_code;
401: l_yes VARCHAR2 (1)
402: := inv_rcv_integration_apis.g_yes;
403: l_no VARCHAR2 (1) := inv_rcv_integration_apis.g_no;
404: l_serial_status_id NUMBER;

Line 402: := inv_rcv_integration_apis.g_yes;

398: l_serial_temp_id NUMBER;
399: l_prod_code VARCHAR2 (5)
400: := inv_rcv_integration_apis.g_prod_code;
401: l_yes VARCHAR2 (1)
402: := inv_rcv_integration_apis.g_yes;
403: l_no VARCHAR2 (1) := inv_rcv_integration_apis.g_no;
404: l_serial_status_id NUMBER;
405:
406: TYPE number_tb_tp IS TABLE OF NUMBER

Line 403: l_no VARCHAR2 (1) := inv_rcv_integration_apis.g_no;

399: l_prod_code VARCHAR2 (5)
400: := inv_rcv_integration_apis.g_prod_code;
401: l_yes VARCHAR2 (1)
402: := inv_rcv_integration_apis.g_yes;
403: l_no VARCHAR2 (1) := inv_rcv_integration_apis.g_no;
404: l_serial_status_id NUMBER;
405:
406: TYPE number_tb_tp IS TABLE OF NUMBER
407: INDEX BY BINARY_INTEGER;

Line 448: inv_rcv_integration_apis.split_mo (p_orig_mol_id => l_mol_line_id,

444: 4
445: );
446: END IF;
447:
448: inv_rcv_integration_apis.split_mo (p_orig_mol_id => l_mol_line_id,
449: p_mo_splt_tb => l_mo_splt_tb,
450: x_return_status => l_return_status,
451: x_msg_count => l_msg_count,
452: x_msg_data => l_msg_data

Line 693: inv_rcv_integration_apis.insert_mtli

689: AND inventory_item_id = p_inventory_item_id
690: AND organization_id = p_organization_id;
691:
692: --Call the insert_mtli API
693: inv_rcv_integration_apis.insert_mtli
694: (p_api_version => 1.0,
695: p_init_msg_lst => l_false,
696: x_return_status => x_return_status,
697: x_msg_count => x_msg_count,

Line 770: inv_rcv_integration_apis.insert_msni

766: l_txn_if_id := l_serial_temp_id;
767: END IF;
768:
769: --Call the insert_msni API
770: inv_rcv_integration_apis.insert_msni
771: (p_api_version => 1.0,
772: p_init_msg_lst => l_false,
773: x_return_status => x_return_status,
774: x_msg_count => x_msg_count,

Line 1182: l_mo_splt_tb inv_rcv_integration_apis.mo_in_tb_tp;

1178: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
1179: --New variables for Lot/Serial Support
1180: l_lot_control_code NUMBER;
1181: l_serial_control_code NUMBER;
1182: l_mo_splt_tb inv_rcv_integration_apis.mo_in_tb_tp;
1183: l_txn_qty_to_split NUMBER;
1184: l_primary_qty_to_split NUMBER;
1185: l_new_mol_id NUMBER;
1186: l_split_line_id NUMBER; --for debug

Line 2329: l_mo_splt_tb inv_rcv_integration_apis.mo_in_tb_tp;

2325: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2326: --New variables for Lot/Serial Support
2327: l_lot_control_code NUMBER;
2328: l_serial_control_code NUMBER;
2329: l_mo_splt_tb inv_rcv_integration_apis.mo_in_tb_tp;
2330: l_txn_qty_to_split NUMBER;
2331: l_primary_qty_to_split NUMBER;
2332: l_new_mol_id NUMBER;
2333: l_split_line_id NUMBER; --for debug

Line 2816: inv_rcv_integration_apis.split_mo(

2812: print_debug(' p_orig_mol_id ============> ' || l_mol_line_id, 4);
2813: print_debug(' p_mo_splt_tb(1).prim_qty => ' || l_mo_splt_tb(1).prim_qty, 4);
2814: END IF;
2815:
2816: inv_rcv_integration_apis.split_mo(
2817: p_orig_mol_id => l_mol_line_id
2818: , p_mo_splt_tb => l_mo_splt_tb
2819: , x_return_status => l_return_status
2820: , x_msg_count => l_msg_count