DBA Data[Home] [Help]

APPS.WF_DIAGNOSTICS dependencies on WF_DIRECTORY

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

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

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

471: l_cells(9) := '5%:Installed';
472: i := 9;
473:
474: for l_rec in user_curs loop
475: Wf_Directory.GetRoleInfoMail(l_rec.user_name, l_dname, l_email, l_npref,
476: l_lang, l_terr, l_orig_sys, l_orig_id, l_install);
477: l_cells(i+1) := l_rec.user_name;
478: l_cells(i+2) := l_dname;
479: l_cells(i+3) := l_email;

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

541: INTO l_role
542: FROM wf_notifications
543: WHERE notification_id = p_nid;
544:
545: Wf_Directory.GetRoleInfoMail(l_role, l_dname, l_email, l_npref, l_lang, l_terr,
546: l_orig_sys, l_orig_id, l_install);
547:
548: l_cells(10) := l_role;
549: l_cells(11) := l_dname;

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

614: l_cells(9) := '5%:Installed';
615: i := 9;
616:
617: for l_rec in user_curs loop
618: Wf_Directory.GetRoleInfoMail(l_rec.user_name, l_dname, l_email, l_npref,
619: l_lang, l_terr, l_orig_sys, l_orig_id, l_install);
620: l_cells(i+1) := l_rec.user_name;
621: l_cells(i+2) := l_dname;
622: l_cells(i+3) := l_email;

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

686: --INTO l_role
687: --FROM wf_roles
688: --WHERE name = p_nid;
689:
690: Wf_Directory.GetRoleInfoMail(p_role, l_dname, l_email, l_npref, l_lang, l_terr,
691: l_orig_sys, l_orig_id, l_install);
692:
693: l_cells(10) := p_role;
694: l_cells(11) := l_dname;

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

759: WHERE notification_id = p_nid;
760:
761: if (l_role is not null) then
762:
763: Wf_Directory.GetRoleInfoMail(l_role, l_dname, l_email, l_npref, l_lang, l_terr,
764: l_orig_sys, l_orig_id, l_install);
765:
766: l_cells(10) := l_role;
767: l_cells(11) := l_dname;

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

1504: -- the notification
1505: -- 1. Recipient's preference
1506: -- 2. Setting at the language level using #WFM_NLS_XXXXXX attribute
1507: -- 3. Current session language
1508: Wf_Directory.GetRoleInfoMail(l_recip_role, l_dname, l_email, l_npref, l_user_lang,
1509: l_user_terr, l_osys, l_osysid, l_installed);
1510:
1511: l_ntf_lang := l_user_lang;
1512: l_ntf_terr := l_user_terr;

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

1775: l_ttype := substr(l_summary_param, 1, instr(l_summary_param, ':')-1) ;
1776: l_tname := substr(l_summary_param, instr(l_summary_param, ':')+1) ;
1777:
1778: -- Get Roles' language pref.
1779: Wf_Directory.GetRoleInfoMail(p_role, l_dname, l_email,
1780: l_npref, l_user_lang, l_user_terr,
1781: l_osys, l_osysid, l_installed);
1782: -- get Session lang
1783: Wf_Mail.GetSessionLanguage(l_ses_lang, l_ses_terr, l_ses_codeset);

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

4535: dbms_lob.WriteAppend(l_value, length(l_head), l_head);
4536:
4537: -- check Role exist in row exist
4538: -- Get_Ntf_Role_Info / or some DIS Apis
4539: Wf_Directory.GetRoleInfoMail(p_role, l_dname, l_email,
4540: l_npref, l_lang, l_terr,
4541: l_orig_sys, l_orig_id, l_install);
4542:
4543: -- check if associated fileds exists for a given role.