[Home] [Help]
15: TYPE g_number_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
16: --
17: -- The following types are used to define plsql tables for
18: -- inserting into transaction temporary tables
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
1877: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1878: END IF;
1879: END Get_Serial_Numbers;
1880: --
1881: -- insert record into mtl_material_transactions_temp
1882: -- who columns will be derived in the procedure
1883: PROCEDURE insert_mmtt
1884: (
1885: x_return_status OUT NOCOPY VARCHAR2
1912: l_login_id := fnd_global.login_id;
1913: --
1914: FOR l_counter IN 1..p_mmtt_tbl_size LOOP
1915: print_debug('in insert mmtt '||p_mmtt_tbl(l_counter).transaction_temp_id );
1916: INSERT INTO mtl_material_transactions_temp
1917: (
1918: transaction_header_id ,
1919: transaction_temp_id ,
1920: source_code ,
2617: ,mln.description
2618: ,mln.expiration_action_date
2619: ,mln.expiration_action_code
2620: ,mln.hold_date
2621: FROM mtl_material_transactions_temp mmtt,
2622: mtl_lot_numbers mln
2623: WHERE mmtt.transaction_temp_id = p_mtlt_tbl(l_counter).transaction_temp_id
2624: and mln.inventory_item_id = mmtt.inventory_item_id
2625: and mln.organization_id = mmtt.organization_id
3068: x_return_status := fnd_api.g_ret_sts_unexp_error;
3069: END update_detailed_quantities;
3070: --
3071: -- create suggestion records.
3072: -- insert into mtl_material_transactions_temp, mtl_serial_numbers_temp,
3073: -- or mtl_transaction_lots_temp
3074: PROCEDURE process_output
3075: (x_return_status OUT NOCOPY VARCHAR2,
3076: p_request_line_rec IN g_request_line_rec_type,
3133: g_insert_lot_flag := 0;
3134: g_insert_serial_flag := 0;
3135: --
3136: -- The following code is commented because
3137: -- the sign for the quantity in mtl_material_transactions_temp
3138: -- and mtl_transaction_lots_temp and mtl_serial_numbers_temp
3139: -- for the suggestion records will be positive always.
3140: -- The reason is that the move order transaction form
3141: -- and api expect the quantity to be positive regardless
3631: -- debugging section
3632: -- can be commented ut for final code
3633: IF inv_pp_debug.is_debug_mode THEN
3634: inv_pp_debug.send_message_to_pipe('=================== create output records: ');
3635: inv_pp_debug.send_message_to_pipe('# of records inserted to mtl_material_transactions_temp: '
3636: || l_mmtt_tbl_size);
3637: inv_pp_debug.send_message_to_pipe('# of records inserted to mtl_transaction_lots_temp: '
3638: || l_mtlt_tbl_size);
3639: inv_pp_debug.send_message_to_pipe('# of records inserted to mtl_serial_numbers_temp: '