[Home] [Help]
302: i pls_integer;
303: p1 pls_integer;
304: p2 pls_integer;
305: not_empty boolean := true;
306: role_info_tbl wf_directory.wf_local_roles_tbl_type;
307:
308: l_delim varchar2(1);
309: cells tdType;
310: result varchar2(32000);
369: else
370: l_text := to_char(l_numberv, l_format);
371: end if;
372: elsif (l_type = 'ROLE') then
373: Wf_Directory.GetRoleInfo2(l_textv,role_info_tbl);
374: l_text := role_info_tbl(1).display_name;
375: elsif (l_type = 'LOOKUP') then
376: begin
377: select MEANING
564: l_owner varchar2(320);
565: l_begin_date date;
566: i pls_integer;
567: j pls_integer;
568: role_info_tbl wf_directory.wf_local_roles_tbl_type;
569:
570: l_table_direction varchar2(1);
571: l_delim varchar2(1) := ':';
572: cells tdType;
625: i := 0;
626: for histr in hist0c(l_itype, l_ikey, l_actid) loop
627: cells(j) := to_char(histr.notification_id);
628: j := j+1;
629: wf_directory.GetRoleInfo2(histr.assigned_user, role_info_tbl);
630: if (disptype = wf_notification.doc_html) then
631: cells(j) := 'S:'||Wf_Notification.SubstituteSpecialChars(role_info_tbl(1).display_name);
632: else
633: cells(j) := role_info_tbl(1).display_name;
681:
682: for histr in histc(l_itype, l_ikey, l_actid) loop
683: cells(j) := to_char(histr.notification_id);
684: j := j+1;
685: wf_directory.GetRoleInfo2(histr.assigned_user, role_info_tbl);
686: if (disptype = wf_notification.doc_html) then
687: cells(j) := 'S:'||Wf_Notification.SubstituteSpecialChars(role_info_tbl(1).display_name);
688: else
689: cells(j) := role_info_tbl(1).display_name;
747: exception
748: when OTHERS then
749: raise;
750: end;
751: wf_directory.GetRoleInfo2(l_owner_role, role_info_tbl);
752: if (disptype = wf_notification.doc_html) then
753: cells(j) := 'S:'||Wf_Notification.SubstituteSpecialChars(role_info_tbl(1).display_name);
754: else
755: cells(j) := role_info_tbl(1).display_name;
924: l_orig_sys varchar2(30);
925: l_orig_sysid number;
926: l_start pls_integer;
927: l_end pls_integer;
928: l_role_info_tbl wf_directory.wf_local_roles_tbl_type;
929:
930: begin
931: -- Stripping off unwanted info from email
932: l_start := instr(from_email, '<', 1, 1);
944: wf_log_pkg.string(wf_log_pkg.level_statement,
945: 'wf.plsql.WF_NOTIFICATION.GetUserfromEmail',
946: 'Obtaining user name using preferred name '||preferred_name);
947: end if;
948: if WF_DIRECTORY.UserActive(preferred_name) then
949: WF_DIRECTORY.GetRoleInfo2(preferred_name, l_role_info_tbl);
950: if (l_role_info_tbl.COUNT > 0) then
951: if (upper(l_email) = upper(l_role_info_tbl(1).email_address)) then
952: found := TRUE;
945: 'wf.plsql.WF_NOTIFICATION.GetUserfromEmail',
946: 'Obtaining user name using preferred name '||preferred_name);
947: end if;
948: if WF_DIRECTORY.UserActive(preferred_name) then
949: WF_DIRECTORY.GetRoleInfo2(preferred_name, l_role_info_tbl);
950: if (l_role_info_tbl.COUNT > 0) then
951: if (upper(l_email) = upper(l_role_info_tbl(1).email_address)) then
952: found := TRUE;
953: user_name := l_role_info_tbl(1).name;
954: disp_name := l_role_info_tbl(1).display_name;
955: return;
956: end if;
957: end if;
958: --elsif WF_DIRECTORY.RoleActive(preferred_name) then --meaning the preferred_name is a ROLE, not a user
959: else --meaning the preferred_name is a ROLE, not a user
960: begin
961: select NAME
962: into user_name
967: wurav.ROLE_NAME = preferred_name and
968: upper(wlr.EMAIL_ADDRESS)=l_email
969: order by ORIG_SYS_ORDER)
970: where rownum<2;
971: WF_DIRECTORY.GetRoleInfo2(user_name, l_role_info_tbl);
972: if (l_role_info_tbl.COUNT > 0) then
973: if (upper(l_email) = upper(l_role_info_tbl(1).email_address)) then
974: found := TRUE;
975: user_name := l_role_info_tbl(1).name;
993: -- the user name is same as email address
994: user_name := upper(l_email);
995: disp_name := upper(l_email);
996:
997: Wf_Directory.GetInfoFromMail(mailid => l_email,
998: role => l_role,
999: display_name => l_dname,
1000: description => l_desc,
1001: notification_preference => l_npref,
1145: is
1146: atype varchar2(8);
1147: format varchar2(240);
1148: rname varchar2(320);
1149: role_info_tbl wf_directory.wf_local_roles_tbl_type;
1150: l_parameterlist wf_parameter_list_t := wf_parameter_list_t();
1151: l_language varchar2(30);
1152: l_recipient_role varchar2(320);
1153:
1213: if (avalue is null) then
1214: -- Null values are ok
1215: rname := '';
1216: else
1217: Wf_Directory.GetRoleInfo2(avalue, role_info_tbl);
1218: rname := role_info_tbl(1).name;
1219:
1220: -- If not internal name, check for display_name
1221: if (rname is null) then
1272: into l_recipient_role
1273: from WF_NOTIFICATIONS WN
1274: where WN.NOTIFICATION_ID = nid ;
1275:
1276: Wf_Directory.GetRoleInfo2(l_recipient_role, role_info_tbl);
1277: l_language := role_info_tbl(1).language;
1278:
1279: select code into l_language from wf_languages where nls_language = l_language;
1280:
1632: end if;
1633: elsif (not_attr_row.type = 'ROLE') then
1634: -- ROLE type, get display_name of role
1635: begin
1636: -- NOTE: cannot use wf_directory.getroleinfo2 because of the
1637: -- pragma WNPS.
1638: -- Decode into orig_system if necessary for indexes
1639: colon := instr(not_attr_row.text_value, ':');
1640: if (colon = 0) then
1867: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME
1868: and WMA.NAME = WNA.NAME
1869: order by decode(wma.type,'URL',length(WNA.NAME),length(WNA.NAME)+1000) desc;
1870:
1871: role_info_tbl wf_directory.wf_local_roles_tbl_type;
1872:
1873: error_name varchar2(30);
1874: error_stack varchar2(32000);
1875: l_dummy boolean;
2052: value := GetAttrDoc(nid, not_attr_row.name, disptype);
2053: end if;
2054: elsif (not_attr_row.type = 'ROLE') then
2055: -- ROLE type, get display_name of role
2056: Wf_Directory.GetRoleInfo2(not_attr_row.text_value,role_info_tbl);
2057: -- Use code directly if role not found.
2058: value := nvl(role_info_tbl(1).display_name,not_attr_row.text_value);
2059:
2060: -- Retrieve role information
3111:
3112: begin
3113:
3114: -- ROLE type, get display_name of role
3115: wf_directory.getroleinfo (GetMailPreference.role, l_dname,
3116: l_email, mailpref,
3117: l_language, l_territory);
3118:
3119: --
3271: end;
3272: -- Bug 7358225: If the recipient role of the routing rule is inactive then update the user_comment
3273: -- for the notification and return without executing the routing rule
3274: if LENGTH(rulerec.action_argument) > 0 then
3275: if Not Wf_Directory.RoleActive(rulerec.action_argument) then
3276: raise inactive_role;
3277: end if;
3278: end if;
3279: newcomment := rulerec.rule_comment;
3379: if recip in (l_wf_owner, l_from_role) then
3380: Wf_Notification.SetComments(nid, o_recip, recip, rulerec.action,
3381: 'RULE', Wf_Core.Translate('OWNER_ROUTE_FAIL'));
3382: else
3383: Wf_Core.Token('TO_ROLE', WF_Directory.GetRoleDisplayName(recip));
3384: newcomment := substrb(newcomment||
3385: Wf_Core.Translate('AUTOROUTE_FAIL')||
3386: wf_core.newline||errmsg, 1, 4000);
3387: end if;
3713: l_itemtype varchar2(8);
3714: col1 pls_integer;
3715: col2 pls_integer;
3716: l_language varchar2(30);
3717: role_info_tbl wf_directory.wf_local_roles_tbl_type;
3718: l_new_rcpt_role WF_NOTIFICATIONS.RECIPIENT_ROLE%TYPE;
3719:
3720: cursor message_attrs_cursor(msg_type varchar2, msg_name varchar2) is
3721: select NAME, TYPE, SUBTYPE, VALUE_TYPE,
3989:
3990: wf_event.addParameterToList('Q_CORRELATION_ID', sendsingle.msg_type||':'||
3991: sendsingle.msg_name, l_parameterlist);
3992:
3993: Wf_Directory.GetRoleInfo2(sendsingle.role, role_info_tbl);
3994: l_language := role_info_tbl(1).language;
3995:
3996: select code into l_language from wf_languages where nls_language = l_language;
3997:
4092: wf_core.token('NAME', msg_name);
4093: wf_core.raise('WFNTF_MESSAGE');
4094: end;
4095:
4096: Wf_Directory.GetRoleOrigSysInfo(role,rorig_system,rorig_system_id);
4097:
4098: -- if ORIG_SYSTEM is null, there is no data found for this role
4099: if (rorig_system is null) then
4100: wf_core.token('ROLE', role);
4132: AND wc.action_type = 'RESPOND';
4133:
4134: UPDATE wf_comments
4135: SET to_role = role,
4136: to_user = nvl(Wf_Directory.GetRoleDisplayname(role), role)
4137: WHERE notification_id = prev_nid
4138: AND to_role = 'WF_SYSTEM'
4139: AND action_type = 'RESPOND';
4140: end if;
4217:
4218: -- Get the orig system ids for the role.
4219: -- Do this instead of using role_name directly so that indexes on
4220: -- the original tables are used when selecting through the view.
4221: Wf_Directory.GetRoleOrigSysInfo(role,rorig_system,rorig_system_id);
4222:
4223: -- if ORIG_SYSTEM is null, there is no data found for this role
4224: if (rorig_system is null) then
4225: wf_core.token('ROLE', role);
4229: -- Loop through users of role, sending notification to each one.
4230: gid := '';
4231: for user in role_users_curs loop
4232: -- Send Notification to only active users - Bug 7413050
4233: if Wf_Directory.UserActive(user.user_name) then
4234: -- Call SendSingle to complete notification,
4235: nid := SendSingle(user.user_name, msg_type, msg_name, due_date, callback,
4236: context, send_comment, priority, gid);
4237:
4315: l_dummy varchar2(1);
4316:
4317: l_language varchar2(30);
4318: l_recipient_role varchar2(320);
4319: role_info_tbl wf_directory.wf_local_roles_tbl_type;
4320:
4321: -- Bug 3827935
4322: l_charcheck boolean;
4323:
4566: into l_recipient_role
4567: from WF_NOTIFICATIONS WN
4568: where WN.NOTIFICATION_ID = nid;
4569:
4570: Wf_Directory.GetRoleInfo2(l_recipient_role, role_info_tbl);
4571: l_language := role_info_tbl(1).language;
4572:
4573: select code into l_language from wf_languages where nls_language = l_language;
4574:
5141: ncount pls_integer;
5142: l_orig_system varchar2(320);
5143: l_orig_system_id number;
5144: begin
5145: wf_directory.GetRoleOrigSysInfo(WorkCount.username, l_orig_system,
5146: l_orig_system_id);
5147:
5148: select count(1)
5149: into ncount
6078: l_from_user varchar2(360);
6079: l_to_user varchar2(360);
6080: l_subject varchar2(2000);
6081: l_language varchar2(64);
6082: role_info_tbl wf_directory.wf_local_roles_tbl_type;
6083: l_territory varchar2(64);
6084: l_nls_date_format varchar2(64);
6085: l_nls_date_language varchar2(64);
6086: l_nls_calendar varchar2(64);
6099: l_orig_nlsCalendar varchar2(64);
6100: l_logSTMT boolean;
6101: l_logPRCD boolean;
6102: l_sessionUser varchar2(320);
6103: l_sessionUserInfo wf_directory.wf_local_roles_tbl_type;
6104: l_canDefer boolean;
6105: l_module varchar2(100):=g_plsqlName|| 'Denormalize_Notification()';
6106:
6107: begin
6129: , 'l_sessionUser=>'||l_sessionUser||'<');
6130: end if;
6131:
6132: if (l_sessionUser is not null) then
6133: Wf_Directory.GetRoleInfo2(l_sessionUser, l_sessionUserInfo);
6134: l_orig_nlsCalendar := l_sessionUserInfo(1).nls_calendar;
6135: if ( l_logSTMT ) then
6136: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6137: , 'l_sessionUser calendar=>'||l_orig_nlsCalendar||'<');
6145: -- if username is supplied, use the language setting of such user
6146: -- default to Recipient's setting if no valid language is found.
6147: begin
6148: if (username is not null) then
6149: Wf_Directory.GetRoleInfo2(username, role_info_tbl);
6150: l_language := role_info_tbl(1).language;
6151:
6152: -- <7514495> full NLS support
6153: l_territory := role_info_tbl(1).territory;
6206: wf_log_pkg.String(wf_log_pkg.LEVEL_STATEMENT, l_module
6207: , 'Getting '||l_user||'''s (recipient) preferences');
6208: end if;
6209:
6210: Wf_Directory.GetRoleInfo2(l_user, role_info_tbl);
6211: -- in most cases, l_language should be null and we use the language setting
6212: -- of the recipient role.
6213: if (l_language is null) then
6214: l_language := role_info_tbl(1).language;
6312: end if;
6313:
6314: -- We need to make l_from_user consistant with l_from_role.
6315: if (l_from_role is not NULL) then
6316: l_from_user := Wf_Directory.GetRoleDisplayName(l_from_role);
6317: l_from_user := substrb(l_from_user, 1,320);
6318: end if;
6319:
6320:
6557: l_newRole varchar2(2000);
6558: l_sysComment varchar2(320);
6559:
6560: l_language varchar2(30);
6561: role_info_tbl wf_directory.wf_local_roles_tbl_type;
6562:
6563: -- bug 7130745
6564: l_event_name varchar2(240);
6565:
6583: g_context_proxy := null;
6584: g_context_user := myusername;
6585: end if;
6586:
6587: mydispname := Wf_Directory.GetRoleDisplayName(myusername);
6588: g_context_user_comment := updateinfo.comment;
6589:
6590: --Bug 3065814
6591: --Get the callback function
6750: -- already been answered. In both cases, MORE_INFO_ROLE is set to null.
6751: -- Also acquire a row lock, so that we do not let multiple people to
6752: -- answer at the same time.
6753: begin
6754: select MORE_INFO_ROLE,Wf_Directory.GetRoleDisplayName(MORE_INFO_ROLE), RECIPIENT_ROLE,FROM_ROLE
6755: into l_from_role, replyby, recipient_role,l_question_role
6756: from WF_NOTIFICATIONS
6757: where NOTIFICATION_ID = nid
6758: and MORE_INFO_ROLE is not null
6775: --Answering the Question
6776: l_admin_role := WF_CORE.Translate('WF_ADMIN_ROLE');
6777:
6778: if (myusername is not null and l_from_role <> myusername) then
6779: if (not Wf_Directory.IsPerformer(myusername, l_from_role) and not Wf_Directory.IsPerformer(myusername, l_admin_role)) then
6780: wf_core.token('ROLE',myusername);
6781: wf_core.token('MORE_INFO_ROLE', l_from_role);
6782: wf_core.token('NID', to_char(nid));
6783: wf_core.raise('WFNTF_NOT_PARTICIPANTS');
6871: wf_event.addParameterToList('Q_CORRELATION_ID', l_messageType||':'||
6872: l_messageName, l_parameterlist);
6873:
6874:
6875: Wf_Directory.GetRoleInfo2(l_recip_role, role_info_tbl);
6876: l_language := role_info_tbl(1).language;
6877:
6878: select code into l_language from wf_languages where nls_language = l_language;
6879:
6958: l_more_info_role varchar2(320);
6959: l_dummy varchar2(1);
6960:
6961: l_language varchar2(30);
6962: role_info_tbl wf_directory.wf_local_roles_tbl_type;
6963:
6964: l_event_name varchar2(240);
6965:
6966: begin
6981: g_context_proxy := null;
6982: g_context_user := l_session_user;
6983: end if;
6984:
6985: l_session_user_display := Wf_Directory.GetRoleDisplayName(l_session_user);
6986: g_context_user_comment := TransferMoreInfo.p_comment;
6987:
6988: --Get the callback function
6989: SELECT callback, context, recipient_role, original_recipient,
7057: -- If there is a transfer action due to a vacation rule
7058: -- then we set the FROM_ROLE as the user for which there is a
7059: --routing rule
7060: if (p_routing_rule_user is not null) then
7061: l_routing_rule_user_display := Wf_Directory.GetRoleDisplayName(p_routing_rule_user);
7062: update WF_NOTIFICATIONS
7063: set MORE_INFO_ROLE = p_new_user,
7064: FROM_USER = l_routing_rule_user_display,
7065: FROM_ROLE = p_routing_rule_user,
7129: wf_event.addParameterToList('Q_CORRELATION_ID', l_messageType||':'||
7130: l_messageName, l_parameterlist);
7131:
7132:
7133: Wf_Directory.GetRoleInfo2(l_recip_role, role_info_tbl);
7134: l_language := role_info_tbl(1).language;
7135:
7136: select code into l_language from wf_languages where nls_language = l_language;
7137:
7223: wf_core.token('USER',l_recip_role);
7224: wf_core.raise('WFNTF_INVALID_MOREINFO_REQUEST');
7225: else
7226: -- Routing rule defined
7227: wf_core.token('ROLE', WF_Directory.GetRoleDisplayName(l_newRole));
7228: l_sysComment := wf_core.translate('WFNTF_AUTO_RESPONSE_TO_ROLE');
7229:
7230: -- implement the above loop recursively
7231: if (p_count > wf_notification.max_forward) then
7239: end if;
7240: else
7241: if l_ruleAction = 'RESPOND' then -- if there is a vacation rule for Response
7242: l_sysComment := wf_core.translate('WFNTF_AUTO_RESPONSE');
7243: l_more_info_role_display := Wf_Directory.GetRoleDisplayName(l_more_info_role);
7244: -- get mail preference of the user who will respond with more information
7245: l_mail_preference := wf_notification.GetMailPreference (l_recip_role, null, null);
7246:
7247: update WF_NOTIFICATIONS
7402: l_messageType varchar2(8);
7403: l_messageName varchar2(30);
7404: l_groupId number;
7405: l_parameterlist wf_parameter_list_t := wf_parameter_list_t();
7406: role_info_tbl wf_directory.wf_local_roles_tbl_type;
7407: l_username varchar2(320);
7408: l_stat varchar2(8);
7409:
7410: --Bug 3065814
7499: -- question mode
7500: if (username is not null) then
7501:
7502: -- Check if the question is asked to a valid role
7503: -- i. The role should be valid within WF Directory Service.
7504: -- ii. We might also want to check if the user is a participant of the ntf??
7505:
7506: wf_directory.GetRoleInfo2(username, role_info_tbl);
7507: l_username := role_info_tbl(1).name;
7502: -- Check if the question is asked to a valid role
7503: -- i. The role should be valid within WF Directory Service.
7504: -- ii. We might also want to check if the user is a participant of the ntf??
7505:
7506: wf_directory.GetRoleInfo2(username, role_info_tbl);
7507: l_username := role_info_tbl(1).name;
7508:
7509: -- Check if it is a Display Name
7510: if (l_username is NULL) then
7543: wf_core.token('USER',l_recip_role);
7544: wf_core.raise('WFNTF_INVALID_MOREINFO_REQUEST');
7545: else
7546: -- Routing rule defined
7547: wf_core.token('ROLE', WF_Directory.GetRoleDisplayName(l_newRole));
7548: l_sysComment := wf_core.translate('WFNTF_AUTO_RESPONSE_TO_ROLE');
7549: if myusername is not null then
7550: wf_notification.SetComments(nid, username, myusername, 'ANSWER', null, l_sysComment);
7551: else
7674: -- already been answered. In both cases, MORE_INFO_ROLE is set to null.
7675: -- Also acquire a row lock, so that we do not let multiple people to
7676: -- answer at the same time.
7677: begin
7678: select MORE_INFO_ROLE, Wf_Directory.GetRoleDisplayName(MORE_INFO_ROLE),
7679: MESSAGE_TYPE, MESSAGE_NAME, GROUP_ID , from_role
7680: into l_from_role, replyby, l_messageType, l_messageName, l_groupId, l_question_role
7681: from WF_NOTIFICATIONS
7682: where NOTIFICATION_ID = nid
7776: wf_event.AddParameterToList('GROUP_ID', nvl(l_groupId, nid), l_parameterlist);
7777: wf_event.addParameterToList('Q_CORRELATION_ID', l_messageType||':'||
7778: l_messageName, l_parameterlist);
7779:
7780: Wf_Directory.GetRoleInfo2(l_recip_role, role_info_tbl);
7781: l_language := role_info_tbl(1).language;
7782:
7783: select code into l_language from wf_languages where nls_language = l_language;
7784:
7844: l_question_role varchar2(320);
7845: l_dummy varchar2(1);
7846: l_orig_recip_role varchar2(320);
7847: l_language varchar2(30);
7848: role_info_tbl wf_directory.wf_local_roles_tbl_type;
7849:
7850: begin
7851: wf_log_pkg.string(WF_LOG_PKG.LEVEL_UNEXPECTED, 'WF_NOTIFICATION.UpdateInfoGuest',
7852: 'NID: '||to_char(nid));
7856: -- Also acquire a row lock, so that we do not let multiple people to
7857: -- answer at the same time.
7858: begin
7859: select ORIGINAL_RECIPIENT, RECIPIENT_ROLE, MORE_INFO_ROLE,
7860: Wf_Directory.GetRoleDisplayName(MORE_INFO_ROLE),
7861: MESSAGE_TYPE, MESSAGE_NAME, GROUP_ID , from_role, callback, context
7862: into l_orig_recip_role, l_recipient_role, l_from_role,
7863: replyby, l_messageType, l_messageName, l_groupId, l_question_role, cb, context
7864: from WF_NOTIFICATIONS
7935: wf_event.AddParameterToList('GROUP_ID', nvl(l_groupId, nid), l_parameterlist);
7936: wf_event.addParameterToList('Q_CORRELATION_ID', l_messageType||':'||
7937: l_messageName, l_parameterlist);
7938:
7939: Wf_Directory.GetRoleInfo2(l_recipient_role, role_info_tbl);
7940: l_language := role_info_tbl(1).language;
7941:
7942: select code into l_language from wf_languages where nls_language = l_language;
7943:
8109: (select
8110: 99999999 H_SEQUENCE,
8111: IAS.NOTIFICATION_ID H_NOTIFICATION_ID,
8112: IAS.ASSIGNED_USER H_FROM_ROLE,
8113: wf_directory.getRoleDisplayName2(IAS.ASSIGNED_USER) H_FROM_USER,
8114: 'WF_SYSTEM' H_TO_ROLE,
8115: l_wf_system H_TO_USER,
8116: A.RESULT_TYPE H_ACTION_TYPE,
8117: IAS.ACTIVITY_RESULT_CODE H_ACTION,
8137: select
8138: 99999999 H_SEQUENCE,
8139: IAS.NOTIFICATION_ID H_NOTIFICATION_ID,
8140: IAS.ASSIGNED_USER H_FROM_ROLE,
8141: wf_directory.getRoleDisplayName2(IAS.ASSIGNED_USER) H_FROM_USER,
8142: 'WF_SYSTEM' H_TO_ROLE,
8143: l_wf_system H_TO_USER,
8144: A.RESULT_TYPE H_ACTION_TYPE,
8145: IAS.ACTIVITY_RESULT_CODE H_ACTION,
9383: -- Sometimes p_from_role is email address when answering for more info request
9384: if (l_from_role = 'WF_SYSTEM') then
9385: l_from_user := Wf_Core.Translate(l_from_role);
9386: else
9387: l_from_user := nvl(Wf_Directory.GetRoleDisplayName(l_from_role), l_from_role);
9388: end if;
9389: if (p_to_role = 'WF_SYSTEM') then
9390: l_to_user := Wf_Core.Translate(p_to_role);
9391: else
9388: end if;
9389: if (p_to_role = 'WF_SYSTEM') then
9390: l_to_user := Wf_Core.Translate(p_to_role);
9391: else
9392: l_to_user := nvl(Wf_Directory.GetRoleDisplayname(p_to_role), p_to_role);
9393: end if;
9394: l_action := p_action;
9395:
9396: if (l_action in ('DELEGATE','TRANSFER')) then
9476: l_territory varchar2(30);
9477: l_orig_system varchar2(30);
9478: l_orig_system_id number;
9479: l_installed varchar2(1);
9480: role_info_tbl wf_directory.wf_local_roles_tbl_type;
9481:
9482: begin
9483:
9484: begin
9493: end;
9494:
9495: -- Get recipient information using Dir Service API. Select from WF_ROLES
9496: -- may not give the right information
9497: Wf_Directory.GetRoleInfoMail(l_recipient_role, l_display_name, l_email_address,
9498: l_notification_pref, l_language, l_territory,
9499: l_orig_system, l_orig_system_id, l_installed);
9500:
9501: -- Check if the notification is eligible to be e-mailed. We throw specific error
9526: Wf_Event.AddParameterToList('GROUP_ID', l_group_id, l_paramlist);
9527: Wf_Event.AddParameterToList('Q_CORRELATION_ID', l_message_type||':'||
9528: l_message_name, l_paramlist);
9529:
9530: Wf_Directory.GetRoleInfo2(l_recipient_role, role_info_tbl);
9531: l_language := role_info_tbl(1).language;
9532:
9533: select code into l_language from wf_languages where nls_language = l_language;
9534: