DBA Data[Home] [Help]

APPS.WMS_RCV_PUP_PVT dependencies on INV_RCV_INTEGRATION_APIS

Line 410: inv_rcv_integration_apis.insert_mtli

406: SELECT rcv_transactions_interface_s.NEXTVAL
407: INTO l_intf_id
408: FROM dual;
409:
410: inv_rcv_integration_apis.insert_mtli
411: (p_api_version => 1.0
412: ,x_return_status => x_return_status
413: ,x_msg_count => x_msg_count
414: ,x_msg_data => x_msg_data

Line 528: inv_rcv_integration_apis.insert_msni

524: print_debug('INSERT_LOT_SERIAL: MSNI Exists');
525: END IF;
526:
527: FOR l_msnt_rec IN msnt_recs(l_serial_txn_tmp_id) LOOP
528: inv_rcv_integration_apis.insert_msni
529: (p_api_version => 1.0
530: ,x_return_status => x_return_status
531: ,x_msg_count => x_msg_count
532: ,x_msg_data => x_msg_data

Line 624: inv_rcv_integration_apis.insert_msni

620: INTO l_intf_id
621: FROM dual;
622: END IF;
623:
624: inv_rcv_integration_apis.insert_msni
625: (p_api_version => 1.0
626: ,x_return_status => x_return_status
627: ,x_msg_count => x_msg_count
628: ,x_msg_data => x_msg_data

Line 888: l_mo_lines_tb inv_rcv_integration_apis.mo_in_tb_tp;

884: ,x_msg_count OUT NOCOPY NUMBER
885: ,x_msg_data OUT NOCOPY VARCHAR2
886: )
887: IS
888: l_mo_lines_tb inv_rcv_integration_apis.mo_in_tb_tp;
889: BEGIN
890: pack_unpack_split
891: (p_transaction_temp_id => p_transaction_temp_id
892: ,p_header_id => p_header_id

Line 908: ,x_mo_lines_tb OUT nocopy inv_rcv_integration_apis.mo_in_tb_tp

904: ,p_txn_mode_code IN VARCHAR2 DEFAULT g_default_txn_mode
905: ,x_return_status OUT NOCOPY VARCHAR2
906: ,x_msg_count OUT NOCOPY NUMBER
907: ,x_msg_data OUT NOCOPY VARCHAR2
908: ,x_mo_lines_tb OUT nocopy inv_rcv_integration_apis.mo_in_tb_tp
909: )
910: IS
911: CURSOR mol_cur(l_line_id NUMBER) IS
912: SELECT

Line 1078: l_mo_splt_tb inv_rcv_integration_apis.mo_in_tb_tp;

1074: l_group_id NUMBER := NULL;
1075: l_mol_rec mol_cur%ROWTYPE;
1076: l_old_intf_id NUMBER := NULL;
1077: l_new_intf_id NUMBER := NULL;
1078: l_mo_splt_tb inv_rcv_integration_apis.mo_in_tb_tp;
1079: l_out_mo_splt_tb inv_rcv_integration_apis.mo_in_tb_tp;
1080: l_rti_tb inv_rcv_integration_apis.child_rec_tb_tp;
1081: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1082: l_progress VARCHAR2(10) := '0.0';

Line 1079: l_out_mo_splt_tb inv_rcv_integration_apis.mo_in_tb_tp;

1075: l_mol_rec mol_cur%ROWTYPE;
1076: l_old_intf_id NUMBER := NULL;
1077: l_new_intf_id NUMBER := NULL;
1078: l_mo_splt_tb inv_rcv_integration_apis.mo_in_tb_tp;
1079: l_out_mo_splt_tb inv_rcv_integration_apis.mo_in_tb_tp;
1080: l_rti_tb inv_rcv_integration_apis.child_rec_tb_tp;
1081: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1082: l_progress VARCHAR2(10) := '0.0';
1083: l_call_rm BOOLEAN := FALSE;

Line 1080: l_rti_tb inv_rcv_integration_apis.child_rec_tb_tp;

1076: l_old_intf_id NUMBER := NULL;
1077: l_new_intf_id NUMBER := NULL;
1078: l_mo_splt_tb inv_rcv_integration_apis.mo_in_tb_tp;
1079: l_out_mo_splt_tb inv_rcv_integration_apis.mo_in_tb_tp;
1080: l_rti_tb inv_rcv_integration_apis.child_rec_tb_tp;
1081: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1082: l_progress VARCHAR2(10) := '0.0';
1083: l_call_rm BOOLEAN := FALSE;
1084: l_txn_mode_code VARCHAR2(25);

Line 1235: inv_rcv_integration_apis.insert_wlpni

1231: print_debug(' p_license_plate_number => ');
1232: print_debug(' p_lpn_group_id => '|| l_group_id ||')');
1233: END IF;
1234:
1235: inv_rcv_integration_apis.insert_wlpni
1236: (p_api_version => 1.0
1237: ,x_return_status => x_return_status
1238: ,x_msg_count => x_msg_count
1239: ,x_msg_data => x_msg_data

Line 1339: inv_rcv_integration_apis.insert_wlpni

1335: print_debug(' p_lpn_group_id => ' || l_group_id);
1336: print_debug(' p_parent_lpn_id => ' || l_tmp_mmtt_rec.transfer_lpn_id);
1337: END IF;
1338:
1339: inv_rcv_integration_apis.insert_wlpni
1340: (p_api_version => 1.0
1341: ,x_return_status => x_return_status
1342: ,x_msg_count => x_msg_count
1343: ,x_msg_data => x_msg_data

Line 1497: inv_rcv_integration_apis.insert_wlpni

1493: print_debug(' p_lpn_group_id => ' || l_group_id);
1494: print_debug(' p_parent_lpn_id => )' );
1495: END IF;
1496:
1497: inv_rcv_integration_apis.insert_wlpni
1498: (p_api_version => 1.0
1499: ,x_return_status => x_return_status
1500: ,x_msg_count => x_msg_count
1501: ,x_msg_data => x_msg_data

Line 1632: inv_rcv_integration_apis.insert_wlpni

1628: print_debug(' p_lpn_group_id => ' || l_group_id);
1629: print_debug(' p_parent_lpn_id => ' || l_tmp_mmtt_rec.transfer_lpn_id);
1630: END IF;
1631:
1632: inv_rcv_integration_apis.insert_wlpni
1633: (p_api_version => 1.0
1634: ,x_return_status => x_return_status
1635: ,x_msg_count => x_msg_count
1636: ,x_msg_data => x_msg_data

Line 1773: inv_rcv_integration_apis.split_mo

1769: print_debug(' p_orig_mol_id => ' || l_tmp_mmtt_rec.move_order_line_id);
1770: print_debug(' p_mo_splt_tb(1).prim_qty => ' || l_mo_splt_tb(1).prim_qty);
1771: END IF;
1772:
1773: inv_rcv_integration_apis.split_mo
1774: (p_orig_mol_id => l_tmp_mmtt_rec.move_order_line_id
1775: ,p_mo_splt_tb => l_mo_splt_tb
1776: ,x_return_status => x_return_status
1777: ,x_msg_count => x_msg_count

Line 1937: inv_rcv_integration_apis.split_mo

1933: print_debug(' p_orig_mol_id => ' || l_tmp_mmtt_rec.move_order_line_id);
1934: print_debug(' p_mo_splt_tb(1).prim_qty => ' || l_mo_splt_tb(1).prim_qty);
1935: END IF;
1936:
1937: inv_rcv_integration_apis.split_mo
1938: (p_orig_mol_id => l_tmp_mmtt_rec.move_order_line_id
1939: ,p_mo_splt_tb => l_mo_splt_tb
1940: ,x_return_status => x_return_status
1941: ,x_msg_count => x_msg_count

Line 2119: inv_rcv_integration_apis.split_mo

2115: print_debug(' p_orig_mol_id => ' || l_tmp_mmtt_rec.move_order_line_id);
2116: print_debug(' p_mo_splt_tb(1).prim_qty => ' || l_mo_splt_tb(1).prim_qty);
2117: END IF;
2118:
2119: inv_rcv_integration_apis.split_mo
2120: (p_orig_mol_id => l_tmp_mmtt_rec.move_order_line_id
2121: ,p_mo_splt_tb => l_mo_splt_tb
2122: ,x_return_status => x_return_status
2123: ,x_msg_count => x_msg_count

Line 2545: inv_rcv_integration_apis.split_mo

2541: print_debug(' p_orig_mol_id => ' || l_tmp_mmtt_rec.move_order_line_id);
2542: print_debug(' p_mo_splt_tb(1).prim_qty => ' || l_mo_splt_tb(1).prim_qty);
2543: END IF;
2544:
2545: inv_rcv_integration_apis.split_mo
2546: (p_orig_mol_id => l_tmp_mmtt_rec.move_order_line_id
2547: ,p_mo_splt_tb => l_mo_splt_tb
2548: ,x_return_status => x_return_status
2549: ,x_msg_count => x_msg_count

Line 2706: inv_rcv_integration_apis.split_mo

2702: print_debug('PACK_UNPACK_SPLIT: ('||l_progress||
2703: ') Calling split_mo');
2704: END IF;
2705:
2706: inv_rcv_integration_apis.split_mo
2707: (p_orig_mol_id => l_tmp_mmtt_rec.move_order_line_id
2708: ,p_mo_splt_tb => l_mo_splt_tb
2709: ,x_return_status => x_return_status
2710: ,x_msg_count => x_msg_count