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 1806: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;

1802:
1803:
1804: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1805: --table to store all RTId, quantity and original_rti_id for lot/serial splits
1806: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
1807: l_split_lot_serial_ok BOOLEAN; --Return status of lot_serial_split API
1808: l_msni_count NUMBER := 0;
1809:
1810: CURSOR l_curs_rcpt_lots_detail IS -- 13972742

Line 2334: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(

2330: END IF;
2331: END ;
2332: END IF;--IF (l_rcv_rcpt_rec.serial_number_control_code = 6) THEN
2333:
2334: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(
2335: p_api_version => 1.0
2336: , p_init_msg_lst => FND_API.G_FALSE
2337: , x_return_status => l_return_status
2338: , x_msg_count => l_msg_count

Line 2629: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;

2625: OR oel.task_id = p_task_id);
2626:
2627: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2628: --table to store all RTId, quantity and original_rti_id for lot/serial splits
2629: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
2630: l_split_lot_serial_ok BOOLEAN; --Return status of lot_serial_split API
2631: BEGIN
2632: x_status := fnd_api.g_ret_sts_success;
2633:

Line 2966: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(

2962: */
2963: IF ((inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j) AND
2964: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
2965:
2966: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(
2967: p_api_version => 1.0
2968: , p_init_msg_lst => FND_API.G_FALSE
2969: , x_return_status => l_return_status
2970: , x_msg_count => l_msg_count

Line 3458: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;

3454: -- a full scan on po_req_distributions_all which is not good.
3455:
3456: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3457: --table to store all RTId, quantity and original_rti_id for lot/serial splits
3458: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
3459: l_split_lot_serial_ok BOOLEAN; --Return status of lot_serial_split API
3460: l_msni_count NUMBER := 0;
3461: BEGIN
3462: IF (l_debug = 1) THEN

Line 3965: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(

3961: END IF;
3962: END ;
3963: END IF;--IF (l_rcv_rcpt_rec.serial_number_control_code = 6) THEN
3964:
3965: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(
3966: p_api_version => 1.0
3967: , p_init_msg_lst => FND_API.G_FALSE
3968: , x_return_status => l_return_status
3969: , x_msg_count => l_msg_count

Line 4546: inv_rcv_integration_apis.insert_mtli(

4542: END IF;
4543:
4544: --Create MTLI record for the lot and the lot quantity for this content
4545: --Set the flag for the API to populate the lot attributes
4546: inv_rcv_integration_apis.insert_mtli(
4547: p_api_version => 1.0
4548: , p_init_msg_lst => FND_API.G_FALSE
4549: , x_return_status => l_return_status
4550: , x_msg_count => l_msg_count

Line 4598: inv_rcv_integration_apis.insert_msni(

4594: print_debug('create_asn_exp_dd_intf_rec 28.2.1: Before MSNI creation', 4);
4595: END IF;
4596: --For each serial number in the lot create one MSNI record. The
4597: --serial attributes would be populated by the API
4598: inv_rcv_integration_apis.insert_msni(
4599: p_api_version => 1.0
4600: , p_init_msg_lst => FND_API.G_FALSE
4601: , x_return_status => l_return_status
4602: , x_msg_count => l_msg_count

Line 4655: inv_rcv_integration_apis.insert_msni(

4651: --serial attributes would be populated by the API
4652: IF (l_debug = 1) THEN
4653: print_debug('create_asn_exp_dd_intf_rec 28.3.1: Before MSNI creation', 4);
4654: END IF;
4655: inv_rcv_integration_apis.insert_msni(
4656: p_api_version => 1.0
4657: , p_init_msg_lst => FND_API.G_FALSE
4658: , x_return_status => l_return_status
4659: , x_msg_count => l_msg_count

Line 4815: inv_rcv_integration_apis.insert_wlpni(

4811: l_from_org_id := p_organization_id;
4812: END IF;
4813:
4814: -- Nested LPN changes. Insert WLPNI
4815: inv_rcv_integration_apis.insert_wlpni(
4816: p_api_version => 1.0
4817: ,x_return_status => l_return_status
4818: ,x_msg_count => l_msg_count
4819: ,x_msg_data => l_msg_data