DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on INV_RCV_INTEGRATION_APIS

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

2938: l_lot_status_id NUMBER;
2939: l_txn_if_id NUMBER := p_txn_if_id;
2940: l_product_txn_id NUMBER := p_product_txn_id;
2941: l_expiration_date DATE;
2942: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
2943: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
2944: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
2945: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
2946: l_return_status VARCHAR2(1);

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

2939: l_txn_if_id NUMBER := p_txn_if_id;
2940: l_product_txn_id NUMBER := p_product_txn_id;
2941: l_expiration_date DATE;
2942: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
2943: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
2944: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
2945: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
2946: l_return_status VARCHAR2(1);
2947: l_msg_count NUMBER;

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

2940: l_product_txn_id NUMBER := p_product_txn_id;
2941: l_expiration_date DATE;
2942: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
2943: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
2944: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
2945: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
2946: l_return_status VARCHAR2(1);
2947: l_msg_count NUMBER;
2948: l_msg_data VARCHAR2(10000);

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

2941: l_expiration_date DATE;
2942: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
2943: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
2944: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
2945: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
2946: l_return_status VARCHAR2(1);
2947: l_msg_count NUMBER;
2948: l_msg_data VARCHAR2(10000);
2949: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 2971: inv_rcv_integration_apis.insert_mtli(

2967: , p_parent_lot_number IN VARCHAR2 DEFAULT NULL--OPM Convergence
2968: , p_reasond_id IN NUMBER DEFAULT NULL--OPM convergence
2969: ); */
2970: --Call the insert_mtli API
2971: inv_rcv_integration_apis.insert_mtli(
2972: p_api_version => 1.0
2973: , p_init_msg_lst => l_false
2974: , x_return_status => l_return_status
2975: , x_msg_count => l_msg_count

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

3023: --Local variables
3024: l_serial_status_id NUMBER;
3025: l_txn_if_id NUMBER := p_txn_if_id;
3026: l_product_txn_id NUMBER := p_product_txn_id;
3027: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
3028: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
3029: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
3030: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
3031: l_return_status VARCHAR2(1);

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

3024: l_serial_status_id NUMBER;
3025: l_txn_if_id NUMBER := p_txn_if_id;
3026: l_product_txn_id NUMBER := p_product_txn_id;
3027: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
3028: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
3029: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
3030: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
3031: l_return_status VARCHAR2(1);
3032: l_msg_count NUMBER;

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

3025: l_txn_if_id NUMBER := p_txn_if_id;
3026: l_product_txn_id NUMBER := p_product_txn_id;
3027: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
3028: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
3029: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
3030: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
3031: l_return_status VARCHAR2(1);
3032: l_msg_count NUMBER;
3033: l_msg_data VARCHAR2(10000);

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

3026: l_product_txn_id NUMBER := p_product_txn_id;
3027: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
3028: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
3029: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
3030: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
3031: l_return_status VARCHAR2(1);
3032: l_msg_count NUMBER;
3033: l_msg_data VARCHAR2(10000);
3034: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 3045: inv_rcv_integration_apis.insert_msni(

3041: WHERE serial_number = p_serial_number
3042: AND inventory_item_id = p_item_id;
3043:
3044: --Call the insert_msni API
3045: inv_rcv_integration_apis.insert_msni(
3046: p_api_version => 1.0
3047: , p_init_msg_lst => l_false
3048: , x_return_status => l_return_status
3049: , x_msg_count => l_msg_count