DBA Data[Home] [Help]

APPS.INV_RCV_STD_TRANSFER_APIS dependencies on INV_RCV_INTEGRATION_APIS

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

2772: l_lot_status_id NUMBER;
2773: l_txn_if_id NUMBER := p_txn_if_id;
2774: l_product_txn_id NUMBER := p_product_txn_id;
2775: l_expiration_date DATE;
2776: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
2777: l_return_status VARCHAR2(1);
2778: l_msg_count NUMBER;
2779: l_msg_data VARCHAR2(10000);
2780: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

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

2866: --Local variables
2867: l_serial_status_id NUMBER;
2868: l_txn_if_id NUMBER := p_txn_if_id;
2869: l_product_txn_id NUMBER := p_product_txn_id;
2870: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
2871: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
2872: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
2873: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
2874: l_return_status VARCHAR2(1);

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

2867: l_serial_status_id NUMBER;
2868: l_txn_if_id NUMBER := p_txn_if_id;
2869: l_product_txn_id NUMBER := p_product_txn_id;
2870: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
2871: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
2872: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
2873: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
2874: l_return_status VARCHAR2(1);
2875: l_msg_count NUMBER;

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

2868: l_txn_if_id NUMBER := p_txn_if_id;
2869: l_product_txn_id NUMBER := p_product_txn_id;
2870: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
2871: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
2872: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
2873: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
2874: l_return_status VARCHAR2(1);
2875: l_msg_count NUMBER;
2876: l_msg_data VARCHAR2(10000);

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

2869: l_product_txn_id NUMBER := p_product_txn_id;
2870: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
2871: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
2872: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
2873: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
2874: l_return_status VARCHAR2(1);
2875: l_msg_count NUMBER;
2876: l_msg_data VARCHAR2(10000);
2877: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 2899: inv_rcv_integration_apis.insert_msni(

2895: END IF;
2896: END;
2897:
2898: --Call the insert_msni API
2899: inv_rcv_integration_apis.insert_msni(
2900: p_api_version => 1.0
2901: , p_init_msg_lst => l_false
2902: , x_return_status => l_return_status
2903: , x_msg_count => l_msg_count

Line 3136: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;

3132: --Local Variables
3133: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
3134:
3135:
3136: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
3137: l_from_sub VARCHAR2(30);
3138: l_from_locator_id NUMBER;
3139: l_split_lot_serial_ok BOOLEAN;
3140: l_receipt_uom VARCHAR2(25);

Line 3416: inv_rcv_integration_apis.split_mmtt

3412: IF (l_debug = 1) THEN
3413: print_debug('Calling split_mmtt', 1);
3414: END IF;
3415:
3416: inv_rcv_integration_apis.split_mmtt
3417: (p_orig_mmtt_id => p_original_temp_id
3418: ,p_prim_qty_to_splt => l_avail_prim_qty
3419: ,p_prim_uom_code => l_primary_uom_code
3420: ,x_new_mmtt_id => l_mmtt_id_to_insert

Line 3478: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial

3474: IF (l_debug = 1) THEN
3475: print_debug('Before calling the split lot serial', 1);
3476: END IF;
3477:
3478: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial
3479: (p_api_version => 1.0
3480: , p_init_msg_lst => FND_API.G_FALSE
3481: , x_return_status => l_return_status
3482: , x_msg_count => l_msg_count

Line 3974: inv_rcv_integration_apis.split_mmtt

3970: IF (l_debug = 1) THEN
3971: print_debug('Calling split_mmtt', 1);
3972: END IF;
3973:
3974: inv_rcv_integration_apis.split_mmtt
3975: (p_orig_mmtt_id => p_original_temp_id
3976: ,p_prim_qty_to_splt => l_rti_tb(k)(l).quantity
3977: ,p_prim_uom_code => l_primary_uom_code
3978: ,x_new_mmtt_id => l_mmtt_id_to_insert