DBA Data[Home] [Help]

APPS.INV_RCV_DIR_RCPT_APIS dependencies on INV_RCV_INTEGRATION_APIS

Line 417: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;

413: AND msi.inventory_item_id(+) = pol.item_id;
414:
415: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
416: --table to store all RTId, quantity and original_rti_id for lot/serial splits
417: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
418: l_split_lot_serial_ok BOOLEAN; --Return status of lot_serial_split API
419: BEGIN
420: x_status := fnd_api.g_ret_sts_success;
421:

Line 719: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(

715: l_new_rti_info(1).orig_interface_trx_id := p_transaction_temp_id;
716: l_new_rti_info(1).new_interface_trx_id := g_interface_transaction_id;
717: l_new_rti_info(1).quantity := l_rcv_transaction_rec.transaction_qty;
718:
719: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(
720: p_api_version => 1.0
721: , p_init_msg_lst => FND_API.G_FALSE
722: , x_return_status => l_return_status
723: , x_msg_count => l_msg_count

Line 1041: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;

1037: OR pod.task_id = p_task_id);
1038:
1039: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1040: --table to store all RTId, quantity and original_rti_id for lot/serial splits
1041: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
1042: l_split_lot_serial_ok BOOLEAN; --Return status of lot_serial_split API
1043: l_msni_count NUMBER := 0;
1044: BEGIN
1045: x_status := fnd_api.g_ret_sts_success;

Line 1468: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(

1464: END IF;
1465: END ;
1466: END IF;--IF (l_rcv_rcpt_rec.serial_number_control_code = 6) THEN
1467:
1468: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(
1469: p_api_version => 1.0
1470: , p_init_msg_lst => FND_API.G_FALSE
1471: , x_return_status => l_return_status
1472: , x_msg_count => l_msg_count

Line 1804: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;

1800:
1801:
1802: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1803: --table to store all RTId, quantity and original_rti_id for lot/serial splits
1804: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
1805: l_split_lot_serial_ok BOOLEAN; --Return status of lot_serial_split API
1806: l_msni_count NUMBER := 0;
1807: BEGIN
1808: x_status := fnd_api.g_ret_sts_success;

Line 2250: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(

2246: END IF;
2247: END ;
2248: END IF;--IF (l_rcv_rcpt_rec.serial_number_control_code = 6) THEN
2249:
2250: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(
2251: p_api_version => 1.0
2252: , p_init_msg_lst => FND_API.G_FALSE
2253: , x_return_status => l_return_status
2254: , x_msg_count => l_msg_count

Line 2544: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;

2540: OR oel.task_id = p_task_id);
2541:
2542: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2543: --table to store all RTId, quantity and original_rti_id for lot/serial splits
2544: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
2545: l_split_lot_serial_ok BOOLEAN; --Return status of lot_serial_split API
2546: BEGIN
2547: x_status := fnd_api.g_ret_sts_success;
2548:

Line 2863: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(

2859: */
2860: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
2861: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
2862:
2863: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(
2864: p_api_version => 1.0
2865: , p_init_msg_lst => FND_API.G_FALSE
2866: , x_return_status => l_return_status
2867: , x_msg_count => l_msg_count

Line 3354: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;

3350: -- a full scan on po_req_distributions_all which is not good.
3351:
3352: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3353: --table to store all RTId, quantity and original_rti_id for lot/serial splits
3354: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
3355: l_split_lot_serial_ok BOOLEAN; --Return status of lot_serial_split API
3356: l_msni_count NUMBER := 0;
3357: BEGIN
3358: IF (l_debug = 1) THEN

Line 3825: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(

3821: END IF;
3822: END ;
3823: END IF;--IF (l_rcv_rcpt_rec.serial_number_control_code = 6) THEN
3824:
3825: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(
3826: p_api_version => 1.0
3827: , p_init_msg_lst => FND_API.G_FALSE
3828: , x_return_status => l_return_status
3829: , x_msg_count => l_msg_count

Line 4402: inv_rcv_integration_apis.insert_mtli(

4398: END IF;
4399:
4400: --Create MTLI record for the lot and the lot quantity for this content
4401: --Set the flag for the API to populate the lot attributes
4402: inv_rcv_integration_apis.insert_mtli(
4403: p_api_version => 1.0
4404: , p_init_msg_lst => FND_API.G_FALSE
4405: , x_return_status => l_return_status
4406: , x_msg_count => l_msg_count

Line 4453: inv_rcv_integration_apis.insert_msni(

4449: print_debug('create_asn_exp_dd_intf_rec 28.2.1: Before MSNI creation', 4);
4450: END IF;
4451: --For each serial number in the lot create one MSNI record. The
4452: --serial attributes would be populated by the API
4453: inv_rcv_integration_apis.insert_msni(
4454: p_api_version => 1.0
4455: , p_init_msg_lst => FND_API.G_FALSE
4456: , x_return_status => l_return_status
4457: , x_msg_count => l_msg_count

Line 4510: inv_rcv_integration_apis.insert_msni(

4506: --serial attributes would be populated by the API
4507: IF (l_debug = 1) THEN
4508: print_debug('create_asn_exp_dd_intf_rec 28.3.1: Before MSNI creation', 4);
4509: END IF;
4510: inv_rcv_integration_apis.insert_msni(
4511: p_api_version => 1.0
4512: , p_init_msg_lst => FND_API.G_FALSE
4513: , x_return_status => l_return_status
4514: , x_msg_count => l_msg_count

Line 4670: inv_rcv_integration_apis.insert_wlpni(

4666: l_from_org_id := p_organization_id;
4667: END IF;
4668:
4669: -- Nested LPN changes. Insert WLPNI
4670: inv_rcv_integration_apis.insert_wlpni(
4671: p_api_version => 1.0
4672: ,x_return_status => l_return_status
4673: ,x_msg_count => l_msg_count
4674: ,x_msg_data => l_msg_data