12: IS
13: svc varchar2(254);
14:
15: BEGIN
16: if (fnd_profile.defined('FS_SVC_PREFIX')) then
17: fnd_profile.get('FS_SVC_PREFIX', svc);
18: if (svc is not null) then
19: svc := substr(svc || node, 1, 254);
20: else
13: svc varchar2(254);
14:
15: BEGIN
16: if (fnd_profile.defined('FS_SVC_PREFIX')) then
17: fnd_profile.get('FS_SVC_PREFIX', svc);
18: if (svc is not null) then
19: svc := substr(svc || node, 1, 254);
20: else
21: svc := 'FNDFS_' || node;
54: pos number;
55: svc varchar2(254);
56: BEGIN
57:
58: fnd_profile.get('APPS_WEB_AGENT', base);
59:
60: IF(base IS NULL) THEN
61: RETURN NULL;
62: END IF;
194: temp_date := req_sdate;
195: tz_adjusted := false;
196:
197: if fnd_timezones.timezones_enabled() = 'Y' then
198: client_timezone := fnd_profile.value_specific('CLIENT_TIMEZONE_ID',
199: requested_by, -1, -1, -1, -1);
200: if client_timezone is not null then
201: client_timezone := fnd_timezones.get_code(client_timezone);
202: server_timezone := fnd_timezones.get_server_timezone_code();
395: where request_id = req_id;
396:
397: -- bug453714 ends
398:
399: fnd_profile.get ('CONC_ATTACH_URL', profbuf);
400:
401: if profbuf = 'Y' then
402:
403: fnd_profile.get ('CONC_URL_LIFETIME', profbuf);
399: fnd_profile.get ('CONC_ATTACH_URL', profbuf);
400:
401: if profbuf = 'Y' then
402:
403: fnd_profile.get ('CONC_URL_LIFETIME', profbuf);
404: url_ttl := to_number(profbuf);
405:
406: /* Note, we must set a default value for url_ttl. *
407: * Stored procedure defaults only work for missing args, *
430: end if;
431:
432: -- If this profile option is set, use the Workflow 'sendgroup' API
433: -- to send a notification to all members of the role.
434: fnd_profile.get('CONC_NOTIFY_GROUP', profbuf);
435:
436: begin
437: if profbuf = 'Y' then
438: nid := wf_notification.sendgroup(recip, msgtype, msgname);