DBA Data[Home] [Help]

APPS.INV_ITEM_CATALOG_ELEM_PUB dependencies on DUAL

Line 447: FROM dual;

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:
450: INV_ITEM_MSG.Add_Message
451: ( p_Msg_Name => l_msg_name

Line 494: FROM dual;

490: --YJAIN
491: --Bug 14068499
492: SELECT mtl_system_items_interface_s.NEXTVAL
493: INTO l_transaction_id
494: FROM dual;
495:
496:
497: INV_ITEM_MSG.Add_Message
498: ( p_Msg_Name => 'INV_CEOI_DUP_ELEM_REC'

Line 538: FROM dual;

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).
541: -- May be changed to 3 or 5, if any errors occur during validation.
542: l_process_flag := 4;