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_DELIVER_APIS dependencies on INV_RCV_INTEGRATION_APIS

Line 1909: l_mo_splt_tb inv_rcv_integration_apis.mo_in_tb_tp;

1905: l_msg_prod VARCHAR2(5);
1906: l_progress VARCHAR2(10);
1907: l_orig_mol_id NUMBER := NULL;
1908: l_new_txn_temp_id NUMBER;
1909: l_mo_splt_tb inv_rcv_integration_apis.mo_in_tb_tp;
1910:
1911: CURSOR l_curs_rcvtxn_detail(v_po_distribution_id NUMBER
1912: , v_rcv_txn_id NUMBER) IS
1913: SELECT rsup.from_organization_id from_organization_id

Line 2129: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;

2125:
2126:
2127: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2128: --table to store all RTId, quantity and original_rti_id for lot/serial splits
2129: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
2130: l_split_lot_serial_ok BOOLEAN; --Return status of lot_serial_split API
2131: l_prim_uom_code VARCHAR2(3);
2132: l_rcvtxn_uom_code VARCHAR2(3);
2133: BEGIN

Line 2488: inv_rcv_integration_apis.split_mo

2484: print_debug(' (p_operation_type => ' || 'DELIVER',4);
2485: print_debug(' (p_txn_header_id => ' || p_original_txn_temp_id,4);
2486: END IF;
2487:
2488: inv_rcv_integration_apis.split_mo
2489: (p_orig_mol_id => l_orig_mol_id,
2490: p_mo_splt_tb => l_mo_splt_tb,
2491: p_operation_type => 'DELIVER',
2492: p_txn_header_id => p_original_txn_temp_id,

Line 2591: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(

2587: END IF;
2588: END ;
2589: END IF;--IF (l_rcv_rcpt_rec.serial_number_control_code = 6) THEN
2590:
2591: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(
2592: p_api_version => 1.0
2593: , p_init_msg_lst => FND_API.G_FALSE
2594: , x_return_status => l_return_status
2595: , x_msg_count => l_msg_count

Line 2694: l_mo_splt_tb inv_rcv_integration_apis.mo_in_tb_tp;

2690: l_msg_prod VARCHAR2(5);
2691: l_progress VARCHAR2(10);
2692: l_orig_mol_id NUMBER := NULL;
2693: l_new_txn_temp_id NUMBER;
2694: l_mo_splt_tb inv_rcv_integration_apis.mo_in_tb_tp;
2695:
2696: CURSOR l_curs_rcvtxn_detail(v_shipment_line_id NUMBER
2697: , v_rcv_txn_id NUMBER) IS
2698: SELECT rsup.from_organization_id from_organization_id

Line 2802: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;

2798: ORDER BY rt.transaction_date DESC;
2799:
2800: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2801: --table to store all RTId, quantity and original_rti_id for lot/serial splits
2802: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
2803: l_split_lot_serial_ok BOOLEAN; --Return status of lot_serial_split API
2804: l_msni_count NUMBER := 0;
2805: l_prim_uom_code VARCHAR2(3);
2806: l_rcvtxn_uom_code VARCHAR2(3);

Line 3119: inv_rcv_integration_apis.split_mo

3115: print_debug(' (p_operation_type => ' || 'DELIVER',4);
3116: print_debug(' (p_txn_header_id => ' || p_original_txn_temp_id,4);
3117: END IF;
3118:
3119: inv_rcv_integration_apis.split_mo
3120: (p_orig_mol_id => l_orig_mol_id,
3121: p_mo_splt_tb => l_mo_splt_tb,
3122: p_operation_type => 'DELIVER',
3123: p_txn_header_id => p_original_txn_temp_id,

Line 3261: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(

3257: END IF;
3258: END ;
3259: END IF;--IF (l_rcv_rcpt_rec.serial_number_control_code = 6) THEN
3260:
3261: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(
3262: p_api_version => 1.0
3263: , p_init_msg_lst => FND_API.G_FALSE
3264: , x_return_status => l_return_status
3265: , x_msg_count => l_msg_count

Line 3363: l_mo_splt_tb inv_rcv_integration_apis.mo_in_tb_tp;

3359: l_msg_prod VARCHAR2(5);
3360: l_progress VARCHAR2(10);
3361: l_orig_mol_id NUMBER := NULL;
3362: l_new_txn_temp_id NUMBER;
3363: l_mo_splt_tb inv_rcv_integration_apis.mo_in_tb_tp;
3364:
3365: CURSOR l_curs_rcvtxn_detail(v_order_line_id NUMBER
3366: , v_rcv_txn_id NUMBER) IS
3367: SELECT rsup.from_organization_id from_organization_id

Line 3471: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;

3467: ORDER BY rt.transaction_date DESC;
3468:
3469: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3470: --table to store all RTId, quantity and original_rti_id for lot/serial splits
3471: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
3472: l_split_lot_serial_ok BOOLEAN; --Return status of lot_serial_split API
3473: l_prim_uom_code VARCHAR2(3);
3474: l_rcvtxn_uom_code VARCHAR2(3);
3475: BEGIN

Line 3742: inv_rcv_integration_apis.split_mo

3738: print_debug(' (p_operation_type => ' || 'DELIVER',4);
3739: print_debug(' (p_txn_header_id => ' || p_original_txn_temp_id,4);
3740: END IF;
3741:
3742: inv_rcv_integration_apis.split_mo
3743: (p_orig_mol_id => l_orig_mol_id,
3744: p_mo_splt_tb => l_mo_splt_tb,
3745: p_operation_type => 'DELIVER',
3746: p_txn_header_id => p_original_txn_temp_id,

Line 3825: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(

3821: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
3822: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
3823: IF (p_lot_control_code > 1 OR p_serial_control_code > 1) THEN
3824:
3825: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(
3826: p_api_version => 1.0
3827: , p_init_msg_lst => FND_API.G_FALSE
3828: , x_return_status => l_return_status
3829: , x_msg_count => l_msg_count

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

5175: l_lot_status_id NUMBER;
5176: l_txn_if_id NUMBER := p_txn_if_id;
5177: l_product_txn_id NUMBER := p_product_txn_id;
5178: l_expiration_date DATE;
5179: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
5180: l_return_status VARCHAR2(1);
5181: l_msg_count NUMBER;
5182: l_msg_data VARCHAR2(10000);
5183: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

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

5257: --Local variables
5258: l_serial_status_id NUMBER;
5259: l_txn_if_id NUMBER := p_txn_if_id;
5260: l_product_txn_id NUMBER := p_product_txn_id;
5261: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
5262: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
5263: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
5264: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
5265: l_return_status VARCHAR2(1);

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

5258: l_serial_status_id NUMBER;
5259: l_txn_if_id NUMBER := p_txn_if_id;
5260: l_product_txn_id NUMBER := p_product_txn_id;
5261: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
5262: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
5263: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
5264: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
5265: l_return_status VARCHAR2(1);
5266: l_msg_count NUMBER;

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

5259: l_txn_if_id NUMBER := p_txn_if_id;
5260: l_product_txn_id NUMBER := p_product_txn_id;
5261: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
5262: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
5263: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
5264: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
5265: l_return_status VARCHAR2(1);
5266: l_msg_count NUMBER;
5267: l_msg_data VARCHAR2(10000);

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

5260: l_product_txn_id NUMBER := p_product_txn_id;
5261: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
5262: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
5263: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
5264: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
5265: l_return_status VARCHAR2(1);
5266: l_msg_count NUMBER;
5267: l_msg_data VARCHAR2(10000);
5268: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 5279: inv_rcv_integration_apis.insert_msni(

5275: WHERE serial_number = p_serial_number
5276: AND inventory_item_id = p_item_id;
5277:
5278: --Call the insert_msni API
5279: inv_rcv_integration_apis.insert_msni(
5280: p_api_version => 1.0
5281: , p_init_msg_lst => l_false
5282: , x_return_status => l_return_status
5283: , x_msg_count => l_msg_count

Line 5443: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;

5439: ;
5440:
5441: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5442: l_remaining_qty NUMBER;
5443: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
5444: l_from_sub VARCHAR2(30);
5445: l_from_locator_id NUMBER;
5446: l_split_lot_serial_ok BOOLEAN;
5447: l_parent_txn_id NUMBER;

Line 5745: inv_rcv_integration_apis.split_mmtt

5741: IF (l_debug = 1) THEN
5742: print_debug('Calling split_mmtt', 1);
5743: END IF;
5744:
5745: inv_rcv_integration_apis.split_mmtt
5746: (p_orig_mmtt_id => p_original_txn_temp_id
5747: ,p_prim_qty_to_splt => l_avail_prim_qty
5748: ,p_prim_uom_code => l_primary_uom_code
5749: ,x_new_mmtt_id => l_mmtt_id_to_insert

Line 5793: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial

5789: l_new_rti_info(2).item_id := p_item_id;
5790: l_new_rti_info(2).uom_code := p_rcvtxn_uom_code;
5791: END IF;
5792:
5793: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial
5794: (p_api_version => 1.0
5795: , p_init_msg_lst => FND_API.G_FALSE
5796: , x_return_status => l_return_status
5797: , x_msg_count => l_msg_count

Line 6182: inv_rcv_integration_apis.split_mmtt

6178: IF (l_debug = 1) THEN
6179: print_debug('Calling split_mmtt', 1);
6180: END IF;
6181:
6182: inv_rcv_integration_apis.split_mmtt
6183: (p_orig_mmtt_id => p_original_txn_temp_id
6184: ,p_prim_qty_to_splt => l_rti_tb(k)(l).quantity
6185: ,p_prim_uom_code => l_primary_uom_code
6186: ,x_new_mmtt_id => l_mmtt_id_to_insert