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
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
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;
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
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')||' ';
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
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
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
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;