DBA Data[Home] [Help]

APPS.EDR_STANDARD dependencies on WF_CORE

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

83: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
84: and b.STATUS = 'ENABLED'
85: --Bug No 4912782- Start
86: and b.source_type = 'LOCAL'
87: and b.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID')) ;
88: --Bug No 4912782- End
89: l_no_enabled_eres_sub NUMBER;
90: MULTIPLE_ERES_SUBSCRIPTIONS EXCEPTION;
91: 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 328: and b.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID')) ;

324: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
325: and b.STATUS = 'ENABLED'
326: --Bug No 4912782- Start
327: and b.source_type = 'LOCAL'
328: and b.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID')) ;
329: --Bug No 4912782- End
330:
331: l_no_enabled_eres_sub NUMBER;
332: MULTIPLE_ERES_SUBSCRIPTIONS EXCEPTION;

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

357: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
358: and b.STATUS = 'ENABLED'
359: --Bug No 4912782- Start
360: and b.source_type = 'LOCAL'
361: and b.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID')) ;
362: --Bug No 4912782- End
363: IF l_no_enabled_eres_sub > 1 THEN
364: RAISE MULTIPLE_ERES_SUBSCRIPTIONS;
365: ELSE

Line 914: Wf_Core.Token('TO_ROLE', WF_Directory.GetRoleDisplayName(l_recipient));

910: IF ruleCurs%NOTFOUND THEN
911: /* No overriding Rule */
912: exit;
913: ELSE
914: Wf_Core.Token('TO_ROLE', WF_Directory.GetRoleDisplayName(l_recipient));
915: Wf_Core.Token('FROM_ROLE', WF_Directory.GetRoleDisplayName(L_original_recipient));
916:
917: IF l_override_mode = 'FORWARD' then
918: L_COMMENTS := Wf_Core.Translate('DELEGATE_AUDIT_MSG')||' ';

Line 915: Wf_Core.Token('FROM_ROLE', WF_Directory.GetRoleDisplayName(L_original_recipient));

911: /* No overriding Rule */
912: exit;
913: ELSE
914: Wf_Core.Token('TO_ROLE', WF_Directory.GetRoleDisplayName(l_recipient));
915: Wf_Core.Token('FROM_ROLE', WF_Directory.GetRoleDisplayName(L_original_recipient));
916:
917: IF l_override_mode = 'FORWARD' then
918: L_COMMENTS := Wf_Core.Translate('DELEGATE_AUDIT_MSG')||' ';
919: ELSIF l_override_mode = 'TRANSFER' then

Line 918: L_COMMENTS := Wf_Core.Translate('DELEGATE_AUDIT_MSG')||' ';

914: Wf_Core.Token('TO_ROLE', WF_Directory.GetRoleDisplayName(l_recipient));
915: Wf_Core.Token('FROM_ROLE', WF_Directory.GetRoleDisplayName(L_original_recipient));
916:
917: IF l_override_mode = 'FORWARD' then
918: L_COMMENTS := Wf_Core.Translate('DELEGATE_AUDIT_MSG')||' ';
919: ELSIF l_override_mode = 'TRANSFER' then
920: L_COMMENTS := Wf_Core.Translate('TRANSFER_AUDIT_MSG')||' ';
921:
922: --Bug 3879150: Start

Line 920: L_COMMENTS := Wf_Core.Translate('TRANSFER_AUDIT_MSG')||' ';

916:
917: IF l_override_mode = 'FORWARD' then
918: L_COMMENTS := Wf_Core.Translate('DELEGATE_AUDIT_MSG')||' ';
919: ELSIF l_override_mode = 'TRANSFER' then
920: L_COMMENTS := Wf_Core.Translate('TRANSFER_AUDIT_MSG')||' ';
921:
922: --Bug 3879150: Start
923: --A NOOP means that there is no transfer of notification.
924: ELSIF l_override_mode = 'NOOP' then

Line 932: final_comments :=final_comments||wf_core.newline||l_comments;

928:
929: ELSE
930: raise BAD_FORWARD;
931: END IF;
932: final_comments :=final_comments||wf_core.newline||l_comments;
933: l_original_recipient := l_recipient;
934: close ruleCurs;
935: END IF;
936: END LOOP;