APPS.WF_NOTIFICATION dependencies on FND_PROFILE

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

1767: -- The URL is a APPS Framework reference and will need
1768: -- the JSP Agent rather than the WEB Agent
1769: value := substr(value, 5);
1770: value := '/' || ltrim(value, '/');
1771: apps_fwk_agent := rtrim(fnd_profile.Value('APPS_FRAMEWORK_AGENT'), '/');
1772: value := apps_fwk_agent || value;
1773: params := instr(value,'?');
1774: if (params <> 0) then
1775: value := value||'&'||'dbc='||fnd_web_config.Database_ID;

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

9117: if (WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
9118: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'BEGIN');
9119: end if;
9120:
9121: url_value := rtrim(fnd_profile.Value('WF_MAIL_WEB_AGENT'), '/');
9122:
9123: if url_value is null then
9124: url_value := rtrim(fnd_profile.Value('APPS_FRAMEWORK_AGENT'), '/');
9125: end if;

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

9120:
9121: url_value := rtrim(fnd_profile.Value('WF_MAIL_WEB_AGENT'), '/');
9122:
9123: if url_value is null then
9124: url_value := rtrim(fnd_profile.Value('APPS_FRAMEWORK_AGENT'), '/');
9125: end if;
9126:
9127: url_value := url_value || wf_notification.fwk_mailer_page;
9128: url_value := url_value || '&WFRegion=NtfDetail&NtfId=' || to_char(p_nid);

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

9239: if (WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
9240: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'BEGIN');
9241: end if;
9242:
9243: url_value := rtrim(fnd_profile.Value('WF_MAIL_WEB_AGENT'), '/');
9244: if url_value is null then
9245: url_value := rtrim(fnd_profile.Value('APPS_FRAMEWORK_AGENT'), '/');
9246: end if;
9247:

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

9241: end if;
9242:
9243: url_value := rtrim(fnd_profile.Value('WF_MAIL_WEB_AGENT'), '/');
9244: if url_value is null then
9245: url_value := rtrim(fnd_profile.Value('APPS_FRAMEWORK_AGENT'), '/');
9246: end if;
9247:
9248: url_value := url_value || wf_notification.fwk_mailer_page;
9249: url_value := url_value ||'&WFRegion=NtfSummary&mailerRole=' || p_mailer_role;