98: end if;*/
99: --
100: END insert_mtlt;
101: --
102: -- insert record into mtl_serial_numbers_temp
103: PROCEDURE insert_msnt
104: (
105: x_return_status OUT NOCOPY VARCHAR2
106: ,p_msnt_tbl IN g_msnt_tbl_type
123: SELECT Sysdate INTO l_today FROM dual;
124: l_user_id := fnd_global.user_id;
125: l_login_id := fnd_global.login_id;
126: FOR l_counter IN 1..p_msnt_tbl_size LOOP
127: INSERT INTO mtl_serial_numbers_temp
128: (
129: transaction_temp_id
130: ,last_update_date
131: ,last_updated_by