APPS.WF_NOTIFICATION dependencies on FND_PROFILE

Line 1724: apps_fwk_agent := rtrim(fnd_profile.Value('APPS_FRAMEWORK_AGENT'), '/');

1720: -- The URL is a APPS Framework reference and will need
1721: -- the JSP Agent rather than the WEB Agent
1722: value := substr(value, 5);
1723: value := '/' || ltrim(value, '/');
1724: apps_fwk_agent := rtrim(fnd_profile.Value('APPS_FRAMEWORK_AGENT'), '/');
1725: value := apps_fwk_agent || value;
1726: params := instr(value,'?');
1727: if (params <> 0) then
1728: value := value||'&'||'dbc='||fnd_web_config.Database_ID;

Line 8870: url_value := rtrim(fnd_profile.Value('WF_MAIL_WEB_AGENT'), '/');

8866: if (WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
8867: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'BEGIN');
8868: end if;
8869:
8870: url_value := rtrim(fnd_profile.Value('WF_MAIL_WEB_AGENT'), '/');
8871:
8872: if url_value is null then
8873: url_value := rtrim(fnd_profile.Value('APPS_FRAMEWORK_AGENT'), '/');
8874: end if;

Line 8873: url_value := rtrim(fnd_profile.Value('APPS_FRAMEWORK_AGENT'), '/');

8869:
8870: url_value := rtrim(fnd_profile.Value('WF_MAIL_WEB_AGENT'), '/');
8871:
8872: if url_value is null then
8873: url_value := rtrim(fnd_profile.Value('APPS_FRAMEWORK_AGENT'), '/');
8874: end if;
8875:
8876: url_value := url_value || wf_notification.fwk_mailer_page;
8877: url_value := url_value || '&WFRegion=NtfDetail&NtfId=' || to_char(p_nid);

Line 8992: url_value := rtrim(fnd_profile.Value('WF_MAIL_WEB_AGENT'), '/');

8988: if (WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
8989: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'BEGIN');
8990: end if;
8991:
8992: url_value := rtrim(fnd_profile.Value('WF_MAIL_WEB_AGENT'), '/');
8993: if url_value is null then
8994: url_value := rtrim(fnd_profile.Value('APPS_FRAMEWORK_AGENT'), '/');
8995: end if;
8996:

Line 8994: url_value := rtrim(fnd_profile.Value('APPS_FRAMEWORK_AGENT'), '/');

8990: end if;
8991:
8992: url_value := rtrim(fnd_profile.Value('WF_MAIL_WEB_AGENT'), '/');
8993: if url_value is null then
8994: url_value := rtrim(fnd_profile.Value('APPS_FRAMEWORK_AGENT'), '/');
8995: end if;
8996:
8997: url_value := url_value || wf_notification.fwk_mailer_page;
8998: url_value := url_value ||'&WFRegion=NtfSummary&mailerRole=' || p_mailer_role;