DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on INV_RCV_INTEGRATION_APIS

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

3142: l_lot_status_id NUMBER;
3143: l_txn_if_id NUMBER := p_txn_if_id;
3144: l_product_txn_id NUMBER := p_product_txn_id;
3145: l_expiration_date DATE;
3146: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
3147: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
3148: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
3149: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
3150: l_return_status VARCHAR2(1);

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

3143: l_txn_if_id NUMBER := p_txn_if_id;
3144: l_product_txn_id NUMBER := p_product_txn_id;
3145: l_expiration_date DATE;
3146: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
3147: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
3148: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
3149: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
3150: l_return_status VARCHAR2(1);
3151: l_msg_count NUMBER;

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

3144: l_product_txn_id NUMBER := p_product_txn_id;
3145: l_expiration_date DATE;
3146: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
3147: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
3148: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
3149: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
3150: l_return_status VARCHAR2(1);
3151: l_msg_count NUMBER;
3152: l_msg_data VARCHAR2(10000);

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

3145: l_expiration_date DATE;
3146: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
3147: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
3148: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
3149: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
3150: l_return_status VARCHAR2(1);
3151: l_msg_count NUMBER;
3152: l_msg_data VARCHAR2(10000);
3153: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 3175: inv_rcv_integration_apis.insert_mtli(

3171: , p_parent_lot_number IN VARCHAR2 DEFAULT NULL--OPM Convergence
3172: , p_reasond_id IN NUMBER DEFAULT NULL--OPM convergence
3173: ); */
3174: --Call the insert_mtli API
3175: inv_rcv_integration_apis.insert_mtli(
3176: p_api_version => 1.0
3177: , p_init_msg_lst => l_false
3178: , x_return_status => l_return_status
3179: , x_msg_count => l_msg_count

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

3227: --Local variables
3228: l_serial_status_id NUMBER;
3229: l_txn_if_id NUMBER := p_txn_if_id;
3230: l_product_txn_id NUMBER := p_product_txn_id;
3231: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
3232: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
3233: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
3234: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
3235: l_return_status VARCHAR2(1);

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

3228: l_serial_status_id NUMBER;
3229: l_txn_if_id NUMBER := p_txn_if_id;
3230: l_product_txn_id NUMBER := p_product_txn_id;
3231: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
3232: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
3233: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
3234: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
3235: l_return_status VARCHAR2(1);
3236: l_msg_count NUMBER;

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

3229: l_txn_if_id NUMBER := p_txn_if_id;
3230: l_product_txn_id NUMBER := p_product_txn_id;
3231: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
3232: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
3233: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
3234: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
3235: l_return_status VARCHAR2(1);
3236: l_msg_count NUMBER;
3237: l_msg_data VARCHAR2(10000);

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

3230: l_product_txn_id NUMBER := p_product_txn_id;
3231: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
3232: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
3233: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
3234: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
3235: l_return_status VARCHAR2(1);
3236: l_msg_count NUMBER;
3237: l_msg_data VARCHAR2(10000);
3238: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 3249: inv_rcv_integration_apis.insert_msni(

3245: WHERE serial_number = p_serial_number
3246: AND inventory_item_id = p_item_id;
3247:
3248: --Call the insert_msni API
3249: inv_rcv_integration_apis.insert_msni(
3250: p_api_version => 1.0
3251: , p_init_msg_lst => l_false
3252: , x_return_status => l_return_status
3253: , x_msg_count => l_msg_count