[Home] [Help]
292: AND wdd.delivery_detail_id = wsn.delivery_detail_id;
293:
294: -- insert into mtl serial number interface.
295: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
296: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Inserting into mtl_serial_numbers_interface total of '||l_fm_serial_num_tbl.COUNT||' records');
297: END IF;
298: FORALL j in 1 ..l_fm_serial_num_tbl.COUNT
299: INSERT INTO mtl_serial_numbers_interface
300: (transaction_interface_id, source_code,
295: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
296: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Inserting into mtl_serial_numbers_interface total of '||l_fm_serial_num_tbl.COUNT||' records');
297: END IF;
298: FORALL j in 1 ..l_fm_serial_num_tbl.COUNT
299: INSERT INTO mtl_serial_numbers_interface
300: (transaction_interface_id, source_code,
301: source_line_id, last_update_date, last_updated_by,
302: creation_date, created_by, last_update_login,
303: fm_serial_number,