DBA Data[Home] [Help]

APPS.WMS_PUTAWAY_UTILS dependencies on INV_TRX_UTIL_PUB

Line 7264: l_ret := inv_trx_util_pub.insert_line_trx(

7260:
7261:
7262: -- Pack from lpn into to lpn
7263: IF p_mode = 1 THEN
7264: l_ret := inv_trx_util_pub.insert_line_trx(
7265: p_trx_hdr_id => p_trx_header_id
7266: , p_item_id => '0'
7267: , p_org_id => p_org_id
7268: , p_trx_action_id => inv_globals.g_action_containerpack

Line 7289: l_ret := inv_trx_util_pub.insert_line_trx(

7285:
7286:
7287: -- UnPack to lpn from from lpn
7288: IF p_mode = 2 THEN
7289: l_ret := inv_trx_util_pub.insert_line_trx(
7290: p_trx_hdr_id => p_trx_header_id
7291: , p_item_id => '-1'
7292: , p_org_id => p_org_id
7293: , p_trx_action_id => inv_globals.g_action_containerunpack

Line 7483: l_ret := inv_trx_util_pub.insert_line_trx

7479: debug('Inventory LPN, To lpn is not null, Pack '||p_from_lpn_id|| ' Into ' ||p_to_lpn_id);
7480: END IF;
7481:
7482: IF (l_sub_loc_changed = 'Y') THEN
7483: l_ret := inv_trx_util_pub.insert_line_trx
7484: (
7485: p_trx_hdr_id => l_trx_header_id
7486: , p_item_id => '0'
7487: , p_org_id => p_org_id

Line 9729: l_return_status := inv_trx_util_pub.insert_line_trx

9725:
9726: l_progress := '250';
9727:
9728: IF (l_sub_loc_changed = 'Y') THEN
9729: l_return_status := inv_trx_util_pub.insert_line_trx
9730: (
9731: p_trx_hdr_id => l_hdr_id
9732: , p_item_id => '0'
9733: , p_org_id => l_org_id

Line 9804: l_return_Status := inv_trx_util_pub.insert_line_trx

9800: 'transfer_contents',
9801: 9);
9802: END IF;
9803:
9804: l_return_Status := inv_trx_util_pub.insert_line_trx
9805: (
9806: p_trx_hdr_id => l_hdr_id
9807: , p_item_id => -1
9808: , p_org_id => l_org_id

Line 9871: l_return_status := inv_trx_util_pub.insert_line_trx

9867:
9868: IF (l_debug = 1) THEN
9869: debug('Inserting MMTT...', 'transfer_contents', 9);
9870: END IF;
9871: l_return_status := inv_trx_util_pub.insert_line_trx
9872: (
9873: p_trx_hdr_id => l_hdr_id
9874: , p_item_id => l_wlpnc_rec.inventory_item_id
9875: , p_revision => l_wlpnc_rec.revision

Line 9921: l_return_status := inv_trx_util_pub.insert_lot_trx

9917: debug('MMTT:' || l_txn_tmp_id || 'Inserted', 'transfer_contents', 9);
9918: END IF;
9919:
9920: IF (l_wlpnc_rec.lot_number IS NOT NULL) THEN
9921: l_return_status := inv_trx_util_pub.insert_lot_trx
9922: ( p_trx_tmp_id => l_txn_tmp_id
9923: ,p_user_id => l_user_id
9924: ,p_lot_number => l_wlpnc_rec.lot_number
9925: ,p_trx_qty => l_wlpnc_rec.quantity

Line 9967: l_return_status := inv_trx_util_pub.insert_ser_trx

9963: l_txn_tmp_id := l_ser_trx_id;
9964: END IF;
9965:
9966: FOR i IN 1 .. l_serial_numbers.COUNT LOOP
9967: l_return_status := inv_trx_util_pub.insert_ser_trx
9968: (p_trx_tmp_id => l_txn_tmp_id
9969: ,p_user_id => l_user_id
9970: ,p_fm_ser_num=> l_serial_numbers(i)
9971: ,p_to_ser_num=> l_serial_numbers(i)

Line 14932: inv_trx_util_pub.delete_transaction

14928:
14929: END LOOP;
14930:
14931: l_progress := 130;
14932: inv_trx_util_pub.delete_transaction
14933: ( x_return_status => x_return_status
14934: , x_msg_data => l_x_msg_data
14935: , x_msg_count => l_x_msg_count
14936: , p_transaction_temp_id => l_mmtt_rec.transaction_temp_id