APPS.INV_DETAIL_UTIL_PVT dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 23: TYPE g_msnt_tbl_type IS TABLE OF mtl_serial_numbers_temp%ROWTYPE

19: TYPE g_mmtt_tbl_type IS TABLE OF mtl_material_transactions_temp%ROWTYPE
20: INDEX BY BINARY_INTEGER;
21: TYPE g_mtlt_tbl_type IS TABLE OF mtl_transaction_lots_temp%ROWTYPE
22: INDEX BY BINARY_INTEGER;
23: TYPE g_msnt_tbl_type IS TABLE OF mtl_serial_numbers_temp%ROWTYPE
24: INDEX BY BINARY_INTEGER;
25: --
26:
27: --Cache for function is_sub_loc_lot_trx_allowed

Line 2825: -- insert record into mtl_serial_numbers_temp

2821: end if;
2822: --
2823: END insert_mtlt;
2824: --
2825: -- insert record into mtl_serial_numbers_temp
2826: -- who columns will be derived in the procedure
2827: PROCEDURE insert_msnt
2828: (
2829: x_return_status OUT NOCOPY VARCHAR2

Line 2858: INSERT INTO mtl_serial_numbers_temp

2854: l_today := SYSDATE;
2855: l_user_id := fnd_global.user_id;
2856: l_login_id := fnd_global.login_id;
2857: FOR l_counter IN 1..p_msnt_tbl_size LOOP
2858: INSERT INTO mtl_serial_numbers_temp
2859: (
2860: transaction_temp_id
2861: ,last_update_date
2862: ,last_updated_by

Line 3115: -- is called for each input line in mtl_serial_numbers_temp.

3111: -- initiates the detailing request, so that they would not be used
3112: -- by later detailing.
3113: -- Bug #1267029
3114: -- Changed how mark_serial_number works. Now, this procedure
3115: -- is called for each input line in mtl_serial_numbers_temp.
3116: -- It takes the inventory_item_id, group_mark_id, serial number
3117: -- start, and serial number end. It does not look at all the
3118: -- output process records.
3119: PROCEDURE mark_serial_numbers

Line 3209: -- insert into mtl_material_transactions_temp, mtl_serial_numbers_temp,

3205: x_return_status := fnd_api.g_ret_sts_unexp_error;
3206: END update_detailed_quantities;
3207: --
3208: -- create suggestion records.
3209: -- insert into mtl_material_transactions_temp, mtl_serial_numbers_temp,
3210: -- or mtl_transaction_lots_temp
3211: PROCEDURE process_output
3212: (x_return_status OUT NOCOPY VARCHAR2,
3213: p_request_line_rec IN g_request_line_rec_type,

Line 3304: -- and mtl_transaction_lots_temp and mtl_serial_numbers_temp

3300:
3301: --
3302: -- The following code is commented because
3303: -- the sign for the quantity in mtl_material_transactions_temp
3304: -- and mtl_transaction_lots_temp and mtl_serial_numbers_temp
3305: -- for the suggestion records will be positive always.
3306: -- The reason is that the move order transaction form
3307: -- and api expect the quantity to be positive regardless
3308: -- what transaction (pick/put) it is. The form or the

Line 4058: inv_pp_debug.send_message_to_pipe('# of records inserted to mtl_serial_numbers_temp: '

4054: inv_pp_debug.send_message_to_pipe('# of records inserted to mtl_material_transactions_temp: '
4055: || l_mmtt_tbl_size);
4056: inv_pp_debug.send_message_to_pipe('# of records inserted to mtl_transaction_lots_temp: '
4057: || l_mtlt_tbl_size);
4058: inv_pp_debug.send_message_to_pipe('# of records inserted to mtl_serial_numbers_temp: '
4059: || l_msnt_tbl_size);
4060: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
4061: END IF;
4062: -- end of debugging section