DBA Data[Home] [Help]

APPS.FND_GFM dependencies on FND_PROFILE

Line 114: export_mime := fnd_profile.value('FND_EXPORT_MIME_TYPE');

110: -- purge_on_view is TRUE then exporting
111:
112: if purge_on_view then
113:
114: export_mime := fnd_profile.value('FND_EXPORT_MIME_TYPE');
115:
116: if export_mime = 'text/tab-separated-values' then
117: file_ext := '.tsv';
118: elsif

Line 165: url := fnd_web_config.trail_slash(fnd_profile.value('APPS_FRAMEWORK_AGENT'))||'OA_HTML/fndgfm.jsp?mode=download_blob'||'&'||'fid='||file_id||'&'||'accessid='||access_id;

161: if (modplsql) then
162: url := fnd_web_config.trail_slash(gfm_agent)||'fndgfm/fnd_gfm.get/'||access_id||'/'||file_id||'/'||file_name;
163: else
164: if (authenticate) then
165: url := fnd_web_config.trail_slash(fnd_profile.value('APPS_FRAMEWORK_AGENT'))||'OA_HTML/fndgfm.jsp?mode=download_blob'||'&'||'fid='||file_id||'&'||'accessid='||access_id;
166: else
167: url := fnd_web_config.trail_slash(fnd_profile.value('APPS_FRAMEWORK_AGENT'))||'OA_HTML/fndgfm.jsp?mode=download_blob'||'&'||'fid='||file_id;
168: end if;
169:

Line 167: url := fnd_web_config.trail_slash(fnd_profile.value('APPS_FRAMEWORK_AGENT'))||'OA_HTML/fndgfm.jsp?mode=download_blob'||'&'||'fid='||file_id;

163: else
164: if (authenticate) then
165: url := fnd_web_config.trail_slash(fnd_profile.value('APPS_FRAMEWORK_AGENT'))||'OA_HTML/fndgfm.jsp?mode=download_blob'||'&'||'fid='||file_id||'&'||'accessid='||access_id;
166: else
167: url := fnd_web_config.trail_slash(fnd_profile.value('APPS_FRAMEWORK_AGENT'))||'OA_HTML/fndgfm.jsp?mode=download_blob'||'&'||'fid='||file_id;
168: end if;
169:
170: end if;
171: end if;

Line 200: user_id := fnd_profile.value('USER_ID');

196: sec_grp_id number :=0;
197: begin
198: if (fnd_gfm.getRelease = 12) then
199:
200: user_id := fnd_profile.value('USER_ID');
201: resp_id := fnd_profile.value('RESP_ID');
202: resp_appl_id := fnd_profile.value('RESP_APPL_ID');
203: sec_grp_id := fnd_profile.value('SECURITY_GROUP_ID');
204:

Line 201: resp_id := fnd_profile.value('RESP_ID');

197: begin
198: if (fnd_gfm.getRelease = 12) then
199:
200: user_id := fnd_profile.value('USER_ID');
201: resp_id := fnd_profile.value('RESP_ID');
202: resp_appl_id := fnd_profile.value('RESP_APPL_ID');
203: sec_grp_id := fnd_profile.value('SECURITY_GROUP_ID');
204:
205: params_passed := 'access_id'||access_id;

Line 202: resp_appl_id := fnd_profile.value('RESP_APPL_ID');

198: if (fnd_gfm.getRelease = 12) then
199:
200: user_id := fnd_profile.value('USER_ID');
201: resp_id := fnd_profile.value('RESP_ID');
202: resp_appl_id := fnd_profile.value('RESP_APPL_ID');
203: sec_grp_id := fnd_profile.value('SECURITY_GROUP_ID');
204:
205: params_passed := 'access_id'||access_id;
206:

Line 203: sec_grp_id := fnd_profile.value('SECURITY_GROUP_ID');

199:
200: user_id := fnd_profile.value('USER_ID');
201: resp_id := fnd_profile.value('RESP_ID');
202: resp_appl_id := fnd_profile.value('RESP_APPL_ID');
203: sec_grp_id := fnd_profile.value('SECURITY_GROUP_ID');
204:
205: params_passed := 'access_id'||access_id;
206:
207: begin

Line 381: if fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT') is null then

377:
378: -- bug 3045375, added if to check length of blob.
379: -- bug 4279252. added UPLOAD_FILE_SIZE_LIMIT check.
380:
381: if fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT') is null then
382: ufslim := bloblength;
383: else
384: /* The profile is not limited to being a numeric value. Stripping off any
385: reference to kilobytes. */

Line 387: if (instr(upper(fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT')),'K')>0) then

383: else
384: /* The profile is not limited to being a numeric value. Stripping off any
385: reference to kilobytes. */
386:
387: if (instr(upper(fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT')),'K')>0) then
388: ufslim := substr(fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT'),1,
389: instr(upper(fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT')),'K')-1);
390: else
391: ufslim := fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT');

Line 388: ufslim := substr(fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT'),1,

384: /* The profile is not limited to being a numeric value. Stripping off any
385: reference to kilobytes. */
386:
387: if (instr(upper(fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT')),'K')>0) then
388: ufslim := substr(fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT'),1,
389: instr(upper(fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT')),'K')-1);
390: else
391: ufslim := fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT');
392: end if;

Line 389: instr(upper(fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT')),'K')-1);

385: reference to kilobytes. */
386:
387: if (instr(upper(fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT')),'K')>0) then
388: ufslim := substr(fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT'),1,
389: instr(upper(fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT')),'K')-1);
390: else
391: ufslim := fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT');
392: end if;
393:

Line 391: ufslim := fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT');

387: if (instr(upper(fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT')),'K')>0) then
388: ufslim := substr(fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT'),1,
389: instr(upper(fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT')),'K')-1);
390: else
391: ufslim := fnd_profile.value('UPLOAD_FILE_SIZE_LIMIT');
392: end if;
393:
394: /* Bug 6490050 - profile is defined to be in KB so we need to convert
395: here. Consistent with the fwk code. */

Line 937: fnd_profile.get_specific('FND_NATIVE_CLIENT_ENCODING',fnd_global.user_id,NULL,NULL,nce,bb);

933: cs := substr(ct, eq, semi-eq);
934: end if;
935: end if;
936:
937: fnd_profile.get_specific('FND_NATIVE_CLIENT_ENCODING',fnd_global.user_id,NULL,NULL,nce,bb);
938:
939: if (pn = 'export' and nce is not null) then
940: cs := fnd_gfm.oracle_to_iana(nce);
941: nce := 'american_america.'||nce;