DBA Data[Home] [Help]

APPS.EDR_ERES_EVENT_PVT dependencies on EDR_INDEXED_XML_UTIL

Line 671: SELECT EDR_INDEXED_XML_UTIL.GET_WF_PARAMS('EDR_AME_TRANSACTION_TYPE',b.guid) into l_ame_txn_type

667: --Fixing this as a part of AME patch.
668: --If there are > 1 subscriptions, and one is enabled query returns >1
669: -- rows. Hence adding two more conditions in where clause
670:
671: SELECT EDR_INDEXED_XML_UTIL.GET_WF_PARAMS('EDR_AME_TRANSACTION_TYPE',b.guid) into l_ame_txn_type
672: from wf_events_vl a,
673: wf_event_subscriptions b
674: WHERE a.guid=b.EVENT_FILTER_GUID
675: and a.name = p_event_name