388: INV_ITEM_MSG.Debug(Mctx, 'starting the ICatalogOI loop to convert the item_number');
389:
390: IF p_upload_rec_flag = 1 THEN
391:
392: SELECT mtl_system_items_interface_s.NEXTVAL
393: INTO l_transaction_id
394: FROM dual;
395:
396: FOR icoi_rec1 IN icoi_csr LOOP
479: -- (b) update the duplicate interface records process_flag --
480: ------------------------------------------------------------------------------------------
481: INV_ITEM_MSG.Debug(Mctx, 'starting the main ICatalogOI loop step3');
482:
483: SELECT mtl_system_items_interface_s.NEXTVAL
484: INTO l_transaction_id
485: FROM dual;
486:
487: FOR icoi_rec_dup IN icoi_csr_dup LOOP --{
518: ------------------------------------------------------------------------------------------
519:
520: INV_ITEM_MSG.Debug(Mctx, 'starting the main ICatalogOI loop step4');
521:
522: SELECT mtl_system_items_interface_s.NEXTVAL
523: INTO l_transaction_id
524: FROM dual;
525:
526: FOR icoi_rec IN icoi_csr LOOP --{