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 1943: l_mo_splt_tb inv_rcv_integration_apis.mo_in_tb_tp;

1939: l_msg_prod VARCHAR2(5);
1940: l_progress VARCHAR2(10);
1941: l_orig_mol_id NUMBER := NULL;
1942: l_new_txn_temp_id NUMBER;
1943: l_mo_splt_tb inv_rcv_integration_apis.mo_in_tb_tp;
1944:
1945: CURSOR l_curs_rcvtxn_detail(v_po_distribution_id NUMBER
1946: , v_rcv_txn_id NUMBER) IS
1947: SELECT rsup.from_organization_id from_organization_id

Line 2163: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;

2159:
2160:
2161: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2162: --table to store all RTId, quantity and original_rti_id for lot/serial splits
2163: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
2164: l_split_lot_serial_ok BOOLEAN; --Return status of lot_serial_split API
2165: l_prim_uom_code VARCHAR2(3);
2166: l_rcvtxn_uom_code VARCHAR2(3);
2167: BEGIN

Line 2522: inv_rcv_integration_apis.split_mo

2518: print_debug(' (p_operation_type => ' || 'DELIVER',4);
2519: print_debug(' (p_txn_header_id => ' || p_original_txn_temp_id,4);
2520: END IF;
2521:
2522: inv_rcv_integration_apis.split_mo
2523: (p_orig_mol_id => l_orig_mol_id,
2524: p_mo_splt_tb => l_mo_splt_tb,
2525: p_operation_type => 'DELIVER',
2526: p_txn_header_id => p_original_txn_temp_id,

Line 2625: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(

2621: END IF;
2622: END ;
2623: END IF;--IF (l_rcv_rcpt_rec.serial_number_control_code = 6) THEN
2624:
2625: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(
2626: p_api_version => 1.0
2627: , p_init_msg_lst => FND_API.G_FALSE
2628: , x_return_status => l_return_status
2629: , x_msg_count => l_msg_count

Line 2728: l_mo_splt_tb inv_rcv_integration_apis.mo_in_tb_tp;

2724: l_msg_prod VARCHAR2(5);
2725: l_progress VARCHAR2(10);
2726: l_orig_mol_id NUMBER := NULL;
2727: l_new_txn_temp_id NUMBER;
2728: l_mo_splt_tb inv_rcv_integration_apis.mo_in_tb_tp;
2729:
2730: CURSOR l_curs_rcvtxn_detail(v_shipment_line_id NUMBER
2731: , v_rcv_txn_id NUMBER) IS
2732: SELECT rsup.from_organization_id from_organization_id

Line 2836: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;

2832: ORDER BY rt.transaction_date DESC;
2833:
2834: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2835: --table to store all RTId, quantity and original_rti_id for lot/serial splits
2836: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
2837: l_split_lot_serial_ok BOOLEAN; --Return status of lot_serial_split API
2838: l_msni_count NUMBER := 0;
2839: l_prim_uom_code VARCHAR2(3);
2840: l_rcvtxn_uom_code VARCHAR2(3);

Line 3215: inv_rcv_integration_apis.split_mo

3211: print_debug(' (p_operation_type => ' || 'DELIVER',4);
3212: print_debug(' (p_txn_header_id => ' || p_original_txn_temp_id,4);
3213: END IF;
3214:
3215: inv_rcv_integration_apis.split_mo
3216: (p_orig_mol_id => l_orig_mol_id,
3217: p_mo_splt_tb => l_mo_splt_tb,
3218: p_operation_type => 'DELIVER',
3219: p_txn_header_id => p_original_txn_temp_id,

Line 3357: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(

3353: END IF;
3354: END ;
3355: END IF;--IF (l_rcv_rcpt_rec.serial_number_control_code = 6) THEN
3356:
3357: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(
3358: p_api_version => 1.0
3359: , p_init_msg_lst => FND_API.G_FALSE
3360: , x_return_status => l_return_status
3361: , x_msg_count => l_msg_count

Line 3459: l_mo_splt_tb inv_rcv_integration_apis.mo_in_tb_tp;

3455: l_msg_prod VARCHAR2(5);
3456: l_progress VARCHAR2(10);
3457: l_orig_mol_id NUMBER := NULL;
3458: l_new_txn_temp_id NUMBER;
3459: l_mo_splt_tb inv_rcv_integration_apis.mo_in_tb_tp;
3460:
3461: CURSOR l_curs_rcvtxn_detail(v_order_line_id NUMBER
3462: , v_rcv_txn_id NUMBER) IS
3463: SELECT rsup.from_organization_id from_organization_id

Line 3567: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;

3563: ORDER BY rt.transaction_date DESC;
3564:
3565: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3566: --table to store all RTId, quantity and original_rti_id for lot/serial splits
3567: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
3568: l_split_lot_serial_ok BOOLEAN; --Return status of lot_serial_split API
3569: l_prim_uom_code VARCHAR2(3);
3570: l_rcvtxn_uom_code VARCHAR2(3);
3571: BEGIN

Line 3856: inv_rcv_integration_apis.split_mo

3852: print_debug(' (p_operation_type => ' || 'DELIVER',4);
3853: print_debug(' (p_txn_header_id => ' || p_original_txn_temp_id,4);
3854: END IF;
3855:
3856: inv_rcv_integration_apis.split_mo
3857: (p_orig_mol_id => l_orig_mol_id,
3858: p_mo_splt_tb => l_mo_splt_tb,
3859: p_operation_type => 'DELIVER',
3860: p_txn_header_id => p_original_txn_temp_id,

Line 3939: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(

3935: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
3936: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
3937: IF (p_lot_control_code > 1 OR p_serial_control_code > 1) THEN
3938:
3939: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(
3940: p_api_version => 1.0
3941: , p_init_msg_lst => FND_API.G_FALSE
3942: , x_return_status => l_return_status
3943: , x_msg_count => l_msg_count

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

5297: l_lot_status_id NUMBER;
5298: l_txn_if_id NUMBER := p_txn_if_id;
5299: l_product_txn_id NUMBER := p_product_txn_id;
5300: l_expiration_date DATE;
5301: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
5302: l_return_status VARCHAR2(1);
5303: l_msg_count NUMBER;
5304: l_msg_data VARCHAR2(10000);
5305: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

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

5379: --Local variables
5380: l_serial_status_id NUMBER;
5381: l_txn_if_id NUMBER := p_txn_if_id;
5382: l_product_txn_id NUMBER := p_product_txn_id;
5383: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
5384: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
5385: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
5386: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
5387: l_return_status VARCHAR2(1);

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

5380: l_serial_status_id NUMBER;
5381: l_txn_if_id NUMBER := p_txn_if_id;
5382: l_product_txn_id NUMBER := p_product_txn_id;
5383: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
5384: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
5385: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
5386: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
5387: l_return_status VARCHAR2(1);
5388: l_msg_count NUMBER;

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

5381: l_txn_if_id NUMBER := p_txn_if_id;
5382: l_product_txn_id NUMBER := p_product_txn_id;
5383: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
5384: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
5385: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
5386: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
5387: l_return_status VARCHAR2(1);
5388: l_msg_count NUMBER;
5389: l_msg_data VARCHAR2(10000);

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

5382: l_product_txn_id NUMBER := p_product_txn_id;
5383: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
5384: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
5385: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
5386: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
5387: l_return_status VARCHAR2(1);
5388: l_msg_count NUMBER;
5389: l_msg_data VARCHAR2(10000);
5390: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 5401: inv_rcv_integration_apis.insert_msni(

5397: WHERE serial_number = p_serial_number
5398: AND inventory_item_id = p_item_id;
5399:
5400: --Call the insert_msni API
5401: inv_rcv_integration_apis.insert_msni(
5402: p_api_version => 1.0
5403: , p_init_msg_lst => l_false
5404: , x_return_status => l_return_status
5405: , x_msg_count => l_msg_count

Line 5574: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;

5570: ;
5571:
5572: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5573: l_remaining_qty NUMBER;
5574: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
5575: l_from_sub VARCHAR2(30);
5576: l_from_locator_id NUMBER;
5577: l_split_lot_serial_ok BOOLEAN;
5578: l_parent_txn_id NUMBER;

Line 5880: inv_rcv_integration_apis.split_mmtt

5876: IF (l_debug = 1) THEN
5877: print_debug('Calling split_mmtt', 1);
5878: END IF;
5879:
5880: inv_rcv_integration_apis.split_mmtt
5881: (p_orig_mmtt_id => p_original_txn_temp_id
5882: ,p_prim_qty_to_splt => l_avail_prim_qty
5883: ,p_prim_uom_code => l_primary_uom_code
5884: ,x_new_mmtt_id => l_mmtt_id_to_insert

Line 5928: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial

5924: l_new_rti_info(2).item_id := p_item_id;
5925: l_new_rti_info(2).uom_code := p_rcvtxn_uom_code;
5926: END IF;
5927:
5928: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial
5929: (p_api_version => 1.0
5930: , p_init_msg_lst => FND_API.G_FALSE
5931: , x_return_status => l_return_status
5932: , x_msg_count => l_msg_count

Line 6325: inv_rcv_integration_apis.split_mmtt

6321: IF (l_debug = 1) THEN
6322: print_debug('Calling split_mmtt', 1);
6323: END IF;
6324:
6325: inv_rcv_integration_apis.split_mmtt
6326: (p_orig_mmtt_id => p_original_txn_temp_id
6327: ,p_prim_qty_to_splt => l_rti_tb(k)(l).quantity
6328: ,p_prim_uom_code => l_primary_uom_code
6329: ,x_new_mmtt_id => l_mmtt_id_to_insert