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 1275: inv_rcv_integration_apis.insert_wlpni

1271: print_debug(' p_license_plate_number => ');
1272: print_debug(' p_lpn_group_id => '|| l_group_id ||')');
1273: END IF;
1274:
1275: inv_rcv_integration_apis.insert_wlpni
1276: (p_api_version => 1.0
1277: ,x_return_status => x_return_status
1278: ,x_msg_count => x_msg_count
1279: ,x_msg_data => x_msg_data

Line 1379: inv_rcv_integration_apis.insert_wlpni

1375: print_debug(' p_lpn_group_id => ' || l_group_id);
1376: print_debug(' p_parent_lpn_id => ' || l_tmp_mmtt_rec.transfer_lpn_id);
1377: END IF;
1378:
1379: inv_rcv_integration_apis.insert_wlpni
1380: (p_api_version => 1.0
1381: ,x_return_status => x_return_status
1382: ,x_msg_count => x_msg_count
1383: ,x_msg_data => x_msg_data

Line 1537: inv_rcv_integration_apis.insert_wlpni

1533: print_debug(' p_lpn_group_id => ' || l_group_id);
1534: print_debug(' p_parent_lpn_id => )' );
1535: END IF;
1536:
1537: inv_rcv_integration_apis.insert_wlpni
1538: (p_api_version => 1.0
1539: ,x_return_status => x_return_status
1540: ,x_msg_count => x_msg_count
1541: ,x_msg_data => x_msg_data

Line 1672: inv_rcv_integration_apis.insert_wlpni

1668: print_debug(' p_lpn_group_id => ' || l_group_id);
1669: print_debug(' p_parent_lpn_id => ' || l_tmp_mmtt_rec.transfer_lpn_id);
1670: END IF;
1671:
1672: inv_rcv_integration_apis.insert_wlpni
1673: (p_api_version => 1.0
1674: ,x_return_status => x_return_status
1675: ,x_msg_count => x_msg_count
1676: ,x_msg_data => x_msg_data

Line 1813: inv_rcv_integration_apis.split_mo

1809: print_debug(' p_orig_mol_id => ' || l_tmp_mmtt_rec.move_order_line_id);
1810: print_debug(' p_mo_splt_tb(1).prim_qty => ' || l_mo_splt_tb(1).prim_qty);
1811: END IF;
1812:
1813: inv_rcv_integration_apis.split_mo
1814: (p_orig_mol_id => l_tmp_mmtt_rec.move_order_line_id
1815: ,p_mo_splt_tb => l_mo_splt_tb
1816: ,x_return_status => x_return_status
1817: ,x_msg_count => x_msg_count

Line 1978: inv_rcv_integration_apis.split_mo

1974: print_debug(' p_orig_mol_id => ' || l_tmp_mmtt_rec.move_order_line_id);
1975: print_debug(' p_mo_splt_tb(1).prim_qty => ' || l_mo_splt_tb(1).prim_qty);
1976: END IF;
1977:
1978: inv_rcv_integration_apis.split_mo
1979: (p_orig_mol_id => l_tmp_mmtt_rec.move_order_line_id
1980: ,p_mo_splt_tb => l_mo_splt_tb
1981: ,x_return_status => x_return_status
1982: ,x_msg_count => x_msg_count

Line 2161: inv_rcv_integration_apis.split_mo

2157: print_debug(' p_orig_mol_id => ' || l_tmp_mmtt_rec.move_order_line_id);
2158: print_debug(' p_mo_splt_tb(1).prim_qty => ' || l_mo_splt_tb(1).prim_qty);
2159: END IF;
2160:
2161: inv_rcv_integration_apis.split_mo
2162: (p_orig_mol_id => l_tmp_mmtt_rec.move_order_line_id
2163: ,p_mo_splt_tb => l_mo_splt_tb
2164: ,x_return_status => x_return_status
2165: ,x_msg_count => x_msg_count

Line 2589: inv_rcv_integration_apis.split_mo

2585: print_debug(' p_orig_mol_id => ' || l_tmp_mmtt_rec.move_order_line_id);
2586: print_debug(' p_mo_splt_tb(1).prim_qty => ' || l_mo_splt_tb(1).prim_qty);
2587: END IF;
2588:
2589: inv_rcv_integration_apis.split_mo
2590: (p_orig_mol_id => l_tmp_mmtt_rec.move_order_line_id
2591: ,p_mo_splt_tb => l_mo_splt_tb
2592: ,x_return_status => x_return_status
2593: ,x_msg_count => x_msg_count

Line 2751: inv_rcv_integration_apis.split_mo

2747: print_debug('PACK_UNPACK_SPLIT: ('||l_progress||
2748: ') Calling split_mo');
2749: END IF;
2750:
2751: inv_rcv_integration_apis.split_mo
2752: (p_orig_mol_id => l_tmp_mmtt_rec.move_order_line_id
2753: ,p_mo_splt_tb => l_mo_splt_tb
2754: ,x_return_status => x_return_status
2755: ,x_msg_count => x_msg_count