DBA Data[Home] [Help]

APPS.CSD_INTERNAL_ORDERS_PVT dependencies on MTL_SERIAL_NUMBERS_INTERFACE

Line 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');

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,

Line 299: INSERT INTO mtl_serial_numbers_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,
301: source_line_id, last_update_date, last_updated_by,
302: creation_date, created_by, last_update_login,
303: fm_serial_number,