DBA Data[Home] [Help]

APPS.WMS_PUTAWAY_UTILS dependencies on INV_TRX_UTIL_PUB

Line 6402: l_ret := inv_trx_util_pub.insert_line_trx(

6398:
6399:
6400: -- Pack from lpn into to lpn
6401: IF p_mode = 1 THEN
6402: l_ret := inv_trx_util_pub.insert_line_trx(
6403: p_trx_hdr_id => p_trx_header_id
6404: , p_item_id => '0'
6405: , p_org_id => p_org_id
6406: , p_trx_action_id => inv_globals.g_action_containerpack

Line 6427: l_ret := inv_trx_util_pub.insert_line_trx(

6423:
6424:
6425: -- UnPack to lpn from from lpn
6426: IF p_mode = 2 THEN
6427: l_ret := inv_trx_util_pub.insert_line_trx(
6428: p_trx_hdr_id => p_trx_header_id
6429: , p_item_id => '-1'
6430: , p_org_id => p_org_id
6431: , p_trx_action_id => inv_globals.g_action_containerunpack

Line 6621: l_ret := inv_trx_util_pub.insert_line_trx

6617: debug('Inventory LPN, To lpn is not null, Pack '||p_from_lpn_id|| ' Into ' ||p_to_lpn_id);
6618: END IF;
6619:
6620: IF (l_sub_loc_changed = 'Y') THEN
6621: l_ret := inv_trx_util_pub.insert_line_trx
6622: (
6623: p_trx_hdr_id => l_trx_header_id
6624: , p_item_id => '0'
6625: , p_org_id => p_org_id

Line 8864: l_return_status := inv_trx_util_pub.insert_line_trx

8860:
8861: l_progress := '250';
8862:
8863: IF (l_sub_loc_changed = 'Y') THEN
8864: l_return_status := inv_trx_util_pub.insert_line_trx
8865: (
8866: p_trx_hdr_id => l_hdr_id
8867: , p_item_id => '0'
8868: , p_org_id => l_org_id

Line 8939: l_return_Status := inv_trx_util_pub.insert_line_trx

8935: 'transfer_contents',
8936: 9);
8937: END IF;
8938:
8939: l_return_Status := inv_trx_util_pub.insert_line_trx
8940: (
8941: p_trx_hdr_id => l_hdr_id
8942: , p_item_id => -1
8943: , p_org_id => l_org_id

Line 9006: l_return_status := inv_trx_util_pub.insert_line_trx

9002:
9003: IF (l_debug = 1) THEN
9004: debug('Inserting MMTT...', 'transfer_contents', 9);
9005: END IF;
9006: l_return_status := inv_trx_util_pub.insert_line_trx
9007: (
9008: p_trx_hdr_id => l_hdr_id
9009: , p_item_id => l_wlpnc_rec.inventory_item_id
9010: , p_revision => l_wlpnc_rec.revision

Line 9054: l_return_status := inv_trx_util_pub.insert_lot_trx

9050: debug('MMTT:' || l_txn_tmp_id || 'Inserted', 'transfer_contents', 9);
9051: END IF;
9052:
9053: IF (l_wlpnc_rec.lot_number IS NOT NULL) THEN
9054: l_return_status := inv_trx_util_pub.insert_lot_trx
9055: ( p_trx_tmp_id => l_txn_tmp_id
9056: ,p_user_id => l_user_id
9057: ,p_lot_number => l_wlpnc_rec.lot_number
9058: ,p_trx_qty => l_wlpnc_rec.quantity

Line 9098: l_return_status := inv_trx_util_pub.insert_ser_trx

9094: l_txn_tmp_id := l_ser_trx_id;
9095: END IF;
9096:
9097: FOR i IN 1 .. l_serial_numbers.COUNT LOOP
9098: l_return_status := inv_trx_util_pub.insert_ser_trx
9099: (p_trx_tmp_id => l_txn_tmp_id
9100: ,p_user_id => l_user_id
9101: ,p_fm_ser_num=> l_serial_numbers(i)
9102: ,p_to_ser_num=> l_serial_numbers(i)

Line 12799: inv_trx_util_pub.delete_transaction

12795:
12796: END LOOP;
12797:
12798: l_progress := 130;
12799: inv_trx_util_pub.delete_transaction
12800: ( x_return_status => x_return_status
12801: , x_msg_data => l_x_msg_data
12802: , x_msg_count => l_x_msg_count
12803: , p_transaction_temp_id => l_mmtt_rec.transaction_temp_id