441: l_column_name := 'ITEM_NUMBER';
442: END IF;
443: IF (l_return_status = fnd_api.g_RET_STS_ERROR) THEN
444: --Bug 14068499
445: SELECT mtl_system_items_interface_s.NEXTVAL
446: INTO l_transaction_id
447: FROM dual;
448:
449:
488:
489: FOR icoi_rec_dup IN icoi_csr_dup LOOP --{
490: --YJAIN
491: --Bug 14068499
492: SELECT mtl_system_items_interface_s.NEXTVAL
493: INTO l_transaction_id
494: FROM dual;
495:
496:
532:
533: --YJAIN
534: -- Bug 14068499
535:
536: SELECT mtl_system_items_interface_s.NEXTVAL
537: INTO l_transaction_id
538: FROM dual;
539:
540: -- Process flag for the current record is initially set to 4 (validation success).