eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EDR_ERES_EVENT_PVT dependencies on WF_EVENTS

Line 22: from wf_events_vl a, wf_event_subscriptions b

18: l_no_of_eres_sub NUMBER;
19:
20: cursor enabled_subscription_csr is
21: select b.guid
22: from wf_events_vl a, wf_event_subscriptions b
23: where a.guid=b.EVENT_FILTER_GUID
24: and a.name = p_event_name
25: and UPPER(b.rule_function) = EDR_CONSTANTS_GRP.g_rule_function
26: and b.status = 'ENABLED'

Line 34: from wf_events_vl a, wf_event_subscriptions b

30: --Bug No 4912782- End
31:
32: cursor single_subscription_csr is
33: select b.guid
34: from wf_events_vl a, wf_event_subscriptions b
35: where a.guid=b.EVENT_FILTER_GUID
36: and a.name = p_event_name
37: and UPPER(b.rule_function) = EDR_CONSTANTS_GRP.g_rule_function
38: --Bug No 4912782- Start

Line 60: wf_events a, wf_event_subscriptions b

56: --
57:
58: select count(*) INTO l_no_of_eres_sub
59: from
60: wf_events a, wf_event_subscriptions b
61: where a.GUID = b.EVENT_FILTER_GUID
62: and a.name = p_event_name
63: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
64: --Bug No 4912782- Start

Line 82: wf_events a, wf_event_subscriptions b

78: --
79: --
80: select count(*) INTO l_no_enabled_eres_sub
81: from
82: wf_events a, wf_event_subscriptions b
83: where a.GUID = b.EVENT_FILTER_GUID
84: and a.name = p_event_name
85: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
86: and b.STATUS = 'ENABLED'

Line 602: FROM FND_APPLICATION A, WF_EVENTS B

598: INVALID_USER_NAME_ERROR EXCEPTION;
599: MULTIPLE_ERES_SUBSCRIPTIONS EXCEPTION;
600: CURSOR CUR_EVENT is
601: SELECT application_id
602: FROM FND_APPLICATION A, WF_EVENTS B
603: WHERE A.APPLICATION_SHORT_NAME = B.OWNER_TAG
604: AND B.NAME=P_EVENT_NAME;
605:
606: CURSOR CUR_SUB is

Line 609: wf_events a, wf_event_subscriptions b

605:
606: CURSOR CUR_SUB is
607: select count(*)
608: from
609: wf_events a, wf_event_subscriptions b
610: where a.GUID = b.EVENT_FILTER_GUID
611: and a.name = p_event_name
612: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
613: and b.STATUS = 'ENABLED'

Line 672: from wf_events_vl a,

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
676: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'