DBA Data[Home] [Help]

APPS.EDR_ERES_EVENT_PVT dependencies on WF_CORE

Line 29: and b.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID')) ;

25: and UPPER(b.rule_function) = EDR_CONSTANTS_GRP.g_rule_function
26: and b.status = 'ENABLED'
27: --Bug No 4912782- Start
28: and b.source_type = 'LOCAL'
29: and b.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID')) ;
30: --Bug No 4912782- End
31:
32: cursor single_subscription_csr is
33: select b.guid

Line 40: and b.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_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
39: and b.source_type = 'LOCAL'
40: and b.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID')) ;
41: --Bug No 4912782- End
42:
43: BEGIN
44: /*

Line 66: and b.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID')) ;

62: and a.name = p_event_name
63: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
64: --Bug No 4912782- Start
65: and b.source_type = 'LOCAL'
66: and b.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID')) ;
67: --Bug No 4912782- End
68:
69: IF l_no_of_eres_sub > 1 then
70:

Line 89: and b.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID')) ;

85: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
86: and b.STATUS = 'ENABLED'
87: --Bug No 4912782- Start
88: and b.source_type = 'LOCAL'
89: and b.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID')) ;
90: --Bug No 4912782- End
91: IF l_no_enabled_eres_sub > 1 THEN
92: l_guid := null;
93: ELSIF l_no_enabled_eres_sub = 0 THEN

Line 616: and b.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID')) ;

612: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
613: and b.STATUS = 'ENABLED'
614: --Bug No 4912782- Start
615: and b.source_type = 'LOCAL'
616: and b.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID')) ;
617: --Bug No 4912782- End
618:
619: CURSOR CUR_USER_NAME(l_cur_user_id number) is
620: select user_name

Line 680: and b.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID')) ;

676: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
677: and b.STATUS = 'ENABLED'
678: --Bug No 4912782- Start
679: and b.source_type = 'LOCAL'
680: and b.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID')) ;
681: --Bug No 4912782- End
682: --Bug 2674799: end
683:
684: EXCEPTION