DBA Data[Home] [Help]

APPS.WF_DIAGNOSTICS dependencies on WF_DIRECTORY

Line 319: Wf_Directory.GetRoleInfoMail(l_role, l_dname, l_email, l_npref, l_lang, l_terr,

315: -- Begin bug#5529150
316: -- Get role from current cursure
317: l_role := l_ntf_rec.rec_role;
318: -- get Role's preferences
319: Wf_Directory.GetRoleInfoMail(l_role, l_dname, l_email, l_npref, l_lang, l_terr,
320: l_orig_sys, l_orig_id, l_install);
321:
322: -- Set the document type based on the notification preference.
323: if l_npref = 'MAILTEXT' then

Line 401: Wf_Directory.GetRoleInfoMail(l_rec.user_name, l_dname, l_email, l_npref,

397: l_cells(9) := '5%:Installed';
398: i := 9;
399:
400: for l_rec in user_curs loop
401: Wf_Directory.GetRoleInfoMail(l_rec.user_name, l_dname, l_email, l_npref,
402: l_lang, l_terr, l_orig_sys, l_orig_id, l_install);
403: l_cells(i+1) := l_rec.user_name;
404: l_cells(i+2) := l_dname;
405: l_cells(i+3) := l_email;

Line 471: Wf_Directory.GetRoleInfoMail(l_role, l_dname, l_email, l_npref, l_lang, l_terr,

467: INTO l_role
468: FROM wf_notifications
469: WHERE notification_id = p_nid;
470:
471: Wf_Directory.GetRoleInfoMail(l_role, l_dname, l_email, l_npref, l_lang, l_terr,
472: l_orig_sys, l_orig_id, l_install);
473:
474: l_cells(10) := l_role;
475: l_cells(11) := l_dname;

Line 544: Wf_Directory.GetRoleInfoMail(l_rec.user_name, l_dname, l_email, l_npref,

540: l_cells(9) := '5%:Installed';
541: i := 9;
542:
543: for l_rec in user_curs loop
544: Wf_Directory.GetRoleInfoMail(l_rec.user_name, l_dname, l_email, l_npref,
545: l_lang, l_terr, l_orig_sys, l_orig_id, l_install);
546: l_cells(i+1) := l_rec.user_name;
547: l_cells(i+2) := l_dname;
548: l_cells(i+3) := l_email;

Line 616: Wf_Directory.GetRoleInfoMail(p_role, l_dname, l_email, l_npref, l_lang, l_terr,

612: --INTO l_role
613: --FROM wf_roles
614: --WHERE name = p_nid;
615:
616: Wf_Directory.GetRoleInfoMail(p_role, l_dname, l_email, l_npref, l_lang, l_terr,
617: l_orig_sys, l_orig_id, l_install);
618:
619: l_cells(10) := p_role;
620: l_cells(11) := l_dname;

Line 689: Wf_Directory.GetRoleInfoMail(l_role, l_dname, l_email, l_npref, l_lang, l_terr,

685: WHERE notification_id = p_nid;
686:
687: if (l_role is not null) then
688:
689: Wf_Directory.GetRoleInfoMail(l_role, l_dname, l_email, l_npref, l_lang, l_terr,
690: l_orig_sys, l_orig_id, l_install);
691:
692: l_cells(10) := l_role;
693: l_cells(11) := l_dname;

Line 1330: Wf_Directory.GetRoleInfoMail(l_recip_role, l_dname, l_email, l_npref, l_user_lang,

1326: -- the notification
1327: -- 1. Recipient's preference
1328: -- 2. Setting at the language level using #WFM_NLS_XXXXXX attribute
1329: -- 3. Current session language
1330: Wf_Directory.GetRoleInfoMail(l_recip_role, l_dname, l_email, l_npref, l_user_lang,
1331: l_user_terr, l_osys, l_osysid, l_installed);
1332:
1333: l_ntf_lang := l_user_lang;
1334: l_ntf_terr := l_user_terr;

Line 1592: Wf_Directory.GetRoleInfoMail(p_role, l_dname, l_email,

1588: l_ttype := substr(l_summary_param, 1, instr(l_summary_param, ':')-1) ;
1589: l_tname := substr(l_summary_param, instr(l_summary_param, ':')+1) ;
1590:
1591: -- Get Roles' language pref.
1592: Wf_Directory.GetRoleInfoMail(p_role, l_dname, l_email,
1593: l_npref, l_user_lang, l_user_terr,
1594: l_osys, l_osysid, l_installed);
1595: -- get Session lang
1596: Wf_Mail.GetSessionLanguage(l_ses_lang, l_ses_terr, l_ses_codeset);

Line 4188: Wf_Directory.GetRoleInfoMail(p_role, l_dname, l_email,

4184: dbms_lob.WriteAppend(l_value, length(l_head), l_head);
4185:
4186: -- check Role exist in row exist
4187: -- Get_Ntf_Role_Info / or some DIS Apis
4188: Wf_Directory.GetRoleInfoMail(p_role, l_dname, l_email,
4189: l_npref, l_lang, l_terr,
4190: l_orig_sys, l_orig_id, l_install);
4191:
4192: -- check if associated fileds exists for a given role.