APPS.FND_OAM_COLLECTION dependencies on FND_PROFILE

Line 362: from fnd_profile_options po,

358: -- web server url to construct the url to ping for servlet agent.
359: begin
360: select pov.profile_option_value
361: into v_url
362: from fnd_profile_options po,
363: fnd_profile_option_values pov
364: where po.profile_option_name = 'APPS_SERVLET_AGENT'
365: and pov.application_id = po.application_id
366: and pov.profile_option_id = po.profile_option_id

Line 363: fnd_profile_option_values pov

359: begin
360: select pov.profile_option_value
361: into v_url
362: from fnd_profile_options po,
363: fnd_profile_option_values pov
364: where po.profile_option_name = 'APPS_SERVLET_AGENT'
365: and pov.application_id = po.application_id
366: and pov.profile_option_id = po.profile_option_id
367: and pov.level_id = 10001;

Line 401: v_url := fnd_profile.value('ICX_DISCOVERER_VIEWER_LAUNCHER');

397: --v_url := fnd_web_config.web_server;
398: --if v_url is not null then
399: -- v_url := v_url || 'servlets/discoservlet';
400: --end if;
401: v_url := fnd_profile.value('ICX_DISCOVERER_VIEWER_LAUNCHER');
402: elsif agent = PHP then
403: v_url := fnd_web_config.jsp_agent;
404: if v_url is not null then
405: v_url := v_url || 'US/ICXINDEX.htm';

Line 416: from fnd_profile_options po,

412: v_server varchar(100);
413: begin
414: select pov.profile_option_value
415: into v_launcher
416: from fnd_profile_options po,
417: fnd_profile_option_values pov
418: where po.profile_option_name = 'ICX_REPORT_LAUNCHER'
419: and pov.application_id = po.application_id
420: and pov.profile_option_id = po.profile_option_id

Line 417: fnd_profile_option_values pov

413: begin
414: select pov.profile_option_value
415: into v_launcher
416: from fnd_profile_options po,
417: fnd_profile_option_values pov
418: where po.profile_option_name = 'ICX_REPORT_LAUNCHER'
419: and pov.application_id = po.application_id
420: and pov.profile_option_id = po.profile_option_id
421: and pov.level_id = 10001;

Line 425: from fnd_profile_options po,

421: and pov.level_id = 10001;
422:
423: select pov.profile_option_value
424: into v_server
425: from fnd_profile_options po,
426: fnd_profile_option_values pov
427: where po.profile_option_name = 'ICX_REPORT_SERVER'
428: and pov.application_id = po.application_id
429: and pov.profile_option_id = po.profile_option_id

Line 426: fnd_profile_option_values pov

422:
423: select pov.profile_option_value
424: into v_server
425: from fnd_profile_options po,
426: fnd_profile_option_values pov
427: where po.profile_option_name = 'ICX_REPORT_SERVER'
428: and pov.application_id = po.application_id
429: and pov.profile_option_id = po.profile_option_id
430: and pov.level_id = 10001;

Line 450: from fnd_profile_options po,

446: v_launcher varchar(1000);
447: begin
448: select pov.profile_option_value
449: into v_launcher
450: from fnd_profile_options po,
451: fnd_profile_option_values pov
452: where po.profile_option_name = 'ICX_FORMS_LAUNCHER'
453: and pov.application_id = po.application_id
454: and pov.profile_option_id = po.profile_option_id

Line 451: fnd_profile_option_values pov

447: begin
448: select pov.profile_option_value
449: into v_launcher
450: from fnd_profile_options po,
451: fnd_profile_option_values pov
452: where po.profile_option_name = 'ICX_FORMS_LAUNCHER'
453: and pov.application_id = po.application_id
454: and pov.profile_option_id = po.profile_option_id
455: and pov.level_id = 10001;

Line 1561: from fnd_profile_options ovl,

1557:
1558: if (is_collection_enabled('PROFILE_OPT')) then
1559: -- get the number of profile options changed in last 24 hours
1560: select count(*) into ct_profile_options
1561: from fnd_profile_options ovl,
1562: fnd_profile_option_values v
1563: where ovl.start_date_active <= SYSDATE
1564: and (nvl(ovl.end_date_active, SYSDATE) >= SYSDATE)
1565: and (v.level_id = 10001 and v.level_value = 0)

Line 1562: fnd_profile_option_values v

1558: if (is_collection_enabled('PROFILE_OPT')) then
1559: -- get the number of profile options changed in last 24 hours
1560: select count(*) into ct_profile_options
1561: from fnd_profile_options ovl,
1562: fnd_profile_option_values v
1563: where ovl.start_date_active <= SYSDATE
1564: and (nvl(ovl.end_date_active, SYSDATE) >= SYSDATE)
1565: and (v.level_id = 10001 and v.level_value = 0)
1566: and ovl.profile_option_id = v.profile_option_id