APPS.EDR_UTILITIES dependencies on WF_CORE

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

67: and a.name = p_event
68: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
69: --Bug No 4912782- Start
70: and b.source_type = 'LOCAL'
71: and b.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID')) ;
72: --Bug No 4912782- End
73: l_no_enabled_eres_sub NUMBER;
74: MULTIPLE_ERES_SUBSCRIPTIONS EXCEPTION;
75: BEGIN

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

115: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
116: and b.STATUS = 'ENABLED'
117: --Bug No 4912782- Start
118: and b.source_type = 'LOCAL'
119: and b.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID')) ;
120: --Bug No 4912782- End
121: IF l_no_enabled_eres_sub > 1 THEN
122: RAISE MULTIPLE_ERES_SUBSCRIPTIONS;
123: ELSE

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

128: and a.name = p_event
129: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
130: --Bug No 4912782- Start
131: and b.source_type = 'LOCAL'
132: and b.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID')) ;
133: --Bug No 4912782- End
134: IF l_no_enabled_eres_sub = 0 THEN
135: RAISE NO_DATA_FOUND;
136: ELSE

Line 775: wf_core.context('EDR_NTF_HISTORY', 'History',document_id);

771: document_type:='text/html';
772:
773: exception
774: when OTHERS then
775: wf_core.context('EDR_NTF_HISTORY', 'History',document_id);
776: raise;
777: end EDR_NTF_HISTORY;
778:
779: /* Get the standard WHO columns of a table row */

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

1690: -- and b.STATUS = 'ENABLED'
1691: -- bug 5586151 : End
1692: --Bug No 4912782- Start
1693: and b.source_type = 'LOCAL'
1694: and b.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID')) ;
1695: --Bug No 4912782- End
1696: l_no_enabled_eres_sub NUMBER;
1697:
1698: --The exception object to catch Multiple ERES subscriptions error.

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

1720: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
1721: and b.STATUS = 'ENABLED'
1722: --Bug No 4912782- Start
1723: and b.source_type = 'LOCAL'
1724: and b.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID')) ;
1725: --Bug No 4912782- End
1726:
1727: --If the count is greater than 1 than raise exception.
1728: IF l_no_enabled_eres_sub > 1 THEN