DBA Data[Home] [Help]

APPS.INV_ITEM_CATALOG_ELEM_PUB dependencies on DUAL

Line 394: FROM dual;

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
397:
398: -- Process flag for the current record is initially set to 4 (validation success).

Line 485: FROM dual;

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 --{
488:
489: INV_ITEM_MSG.Add_Message

Line 524: FROM dual;

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 --{
527:
528: -- Process flag for the current record is initially set to 4 (validation success).