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 2858: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;

2854: --Local variables
2855: l_serial_status_id NUMBER;
2856: l_txn_if_id NUMBER := p_txn_if_id;
2857: l_product_txn_id NUMBER := p_product_txn_id;
2858: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
2859: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
2860: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
2861: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
2862: l_return_status VARCHAR2(1);

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

2855: l_serial_status_id NUMBER;
2856: l_txn_if_id NUMBER := p_txn_if_id;
2857: l_product_txn_id NUMBER := p_product_txn_id;
2858: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
2859: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
2860: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
2861: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
2862: l_return_status VARCHAR2(1);
2863: l_msg_count NUMBER;

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

2856: l_txn_if_id NUMBER := p_txn_if_id;
2857: l_product_txn_id NUMBER := p_product_txn_id;
2858: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
2859: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
2860: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
2861: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
2862: l_return_status VARCHAR2(1);
2863: l_msg_count NUMBER;
2864: l_msg_data VARCHAR2(10000);

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

2857: l_product_txn_id NUMBER := p_product_txn_id;
2858: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
2859: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
2860: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
2861: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
2862: l_return_status VARCHAR2(1);
2863: l_msg_count NUMBER;
2864: l_msg_data VARCHAR2(10000);
2865: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 2876: inv_rcv_integration_apis.insert_msni(

2872: WHERE serial_number = p_serial_number
2873: AND inventory_item_id = p_item_id;
2874:
2875: --Call the insert_msni API
2876: inv_rcv_integration_apis.insert_msni(
2877: p_api_version => 1.0
2878: , p_init_msg_lst => l_false
2879: , x_return_status => l_return_status
2880: , x_msg_count => l_msg_count

Line 3044: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;

3040: --Local Variables
3041: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
3042:
3043:
3044: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
3045: l_from_sub VARCHAR2(30);
3046: l_from_locator_id NUMBER;
3047: l_split_lot_serial_ok BOOLEAN;
3048: l_receipt_uom VARCHAR2(25);

Line 3322: inv_rcv_integration_apis.split_mmtt

3318: IF (l_debug = 1) THEN
3319: print_debug('Calling split_mmtt', 1);
3320: END IF;
3321:
3322: inv_rcv_integration_apis.split_mmtt
3323: (p_orig_mmtt_id => p_original_temp_id
3324: ,p_prim_qty_to_splt => l_avail_prim_qty
3325: ,p_prim_uom_code => l_primary_uom_code
3326: ,x_new_mmtt_id => l_mmtt_id_to_insert

Line 3384: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial

3380: IF (l_debug = 1) THEN
3381: print_debug('Before calling the split lot serial', 1);
3382: END IF;
3383:
3384: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial
3385: (p_api_version => 1.0
3386: , p_init_msg_lst => FND_API.G_FALSE
3387: , x_return_status => l_return_status
3388: , x_msg_count => l_msg_count

Line 3744: inv_rcv_integration_apis.split_mmtt

3740: IF (l_debug = 1) THEN
3741: print_debug('Calling split_mmtt', 1);
3742: END IF;
3743:
3744: inv_rcv_integration_apis.split_mmtt
3745: (p_orig_mmtt_id => p_original_temp_id
3746: ,p_prim_qty_to_splt => l_rti_tb(k)(l).quantity
3747: ,p_prim_uom_code => l_primary_uom_code
3748: ,x_new_mmtt_id => l_mmtt_id_to_insert