DBA Data[Home] [Help]

APPS.FND_OAM_EM dependencies on DUAL

Line 102: FROM dual;

98: to_char(processed),
99: to_char(expired),
100: to_char(undeliverable),
101: to_char(errored)
102: FROM dual;
103: return ret;
104:
105: END get_wf_agent_activity;
106:

Line 183: FROM dual;

179: PROFILE_OPT,
180: CONTEXT_FILES_EDITED,
181: INVALID_OBJECTS,
182: LAST_UPDATE_DATE
183: FROM dual;
184:
185: return ret;
186: END get_conf_changed;
187:

Line 242: FROM dual;

238: DISCOVERER_GEN,
239: PHP_GEN,
240: TCF_GEN,
241: LAST_UPDATE_DATE
242: FROM dual;
243:
244:
245: return ret;
246: END get_web_components_status;

Line 288: FROM dual;

284: CRIT_PR_EXCEP,
285: CRIT_TOTAL_UNPR_EXCEP,
286: OPEN_OCC,
287: LAST_UPDATE_DATE
288: FROM dual;
289:
290: return ret;
291:
292: END get_ebiz_int_sys_alerts;

Line 362: FROM dual;

358: multi_org,
359: multi_lingual,
360: multi_currency,
361: products_installed
362: FROM dual;
363:
364: return ret;
365: END get_apps_general_info;
366:

Line 407: FROM dual;

403: OPEN ret FOR
404: SELECT ACTIVE_USERS,
405: SERVICE_PROCS,
406: RUNNING_REQ
407: FROM dual;
408:
409: return ret;
410:
411: END get_ebiz_activity;

Line 447: FROM dual;

443:
444: -- open the cursor to return
445: OPEN ret FOR
446: SELECT to_char(errored_ct),to_char(unsent_ct)
447: FROM dual;
448:
449: return ret;
450: END get_wf_notification;
451:

Line 487: FROM dual;

483:
484: -- open the cursor to return
485: OPEN ret FOR
486: SELECT to_char(status)
487: FROM dual;
488:
489: return ret;
490: END get_ebiz_status;
491: */

Line 591: FROM dual;

587:
588: -- open the cursor to return
589: OPEN ret FOR
590: SELECT frame_agent
591: FROM dual;
592:
593: return ret;
594: END get_apps_framework_agent;
595:

Line 676: FROM dual;

672: to_char(pending_scheduled_ct),
673: to_char(no_manager_ct),
674: to_char(on_hold_ct),
675: to_char(running_ct)
676: FROM dual;
677:
678: return result;
679:
680: END get_rqsts_stats;

Line 822: FROM dual;

818: SELECT to_char(active_count),
819: to_char(deferred_count),
820: to_char(suspended_count),
821: to_char(errored_count)
822: FROM dual;
823: return ret;
824:
825: END get_workitem_metrics;
826: */