eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_OAM_EM dependencies on FND_OAM

Line 1: PACKAGE BODY fnd_oam_em AS

1: PACKAGE BODY fnd_oam_em AS
2: /* $Header: AFOAMEMB.pls 120.1.12000000.4 2007/04/25 22:04:43 ssuprasa ship $ */
3:
4:
5: /* DONE FOR LEVEL 1 */

Line 45: FND_OAM.get_svc_inst_status

41:
42: results(i).srvc_app_name := service_arr_pair.srvc_app_name;
43: results(i).srvc_app_short_name := service_arr_pair.srvc_app_short_name;
44: tmp_svc_message :='';
45: FND_OAM.get_svc_inst_status
46: (service_arr_pair.appl_id,
47: service_arr_pair.conc_queue_id,
48: tmp_target_procs,
49: tmp_actual_procs,

Line 114: fnd_oam_collection.refresh_app_sys_status;

110: /* DONE FOR LEVEL 1*/
111: FUNCTION get_apps_sys_status return oam_cursor_type IS
112: ret oam_cursor_type;
113: BEGIN
114: fnd_oam_collection.refresh_app_sys_status;
115:
116: OPEN ret FOR
117: SELECT foa.metric_short_name,
118: decode(fcq.user_concurrent_queue_name,NULL,'N/A',fcq.user_concurrent_queue_name),

Line 128: FROM fnd_oam_app_sys_status foa,

124: to_char(foa.last_update_date,'yyyy/MM/dd HH:mm:ss') last_update_date,
125: decode(foa.type,NULL,'N/A',foa.type),
126: decode(fcq.manager_type,NULL,'N/A',fcq.manager_type)
127:
128: FROM fnd_oam_app_sys_status foa,
129: fnd_concurrent_queues_vl fcq,
130: FND_OAM_FNDNODES_VL fn,
131: fnd_lookups fl
132: WHERE foa.application_id = fcq.application_id (+)

Line 130: FND_OAM_FNDNODES_VL fn,

126: decode(fcq.manager_type,NULL,'N/A',fcq.manager_type)
127:
128: FROM fnd_oam_app_sys_status foa,
129: fnd_concurrent_queues_vl fcq,
130: FND_OAM_FNDNODES_VL fn,
131: fnd_lookups fl
132: WHERE foa.application_id = fcq.application_id (+)
133: AND foa.concurrent_queue_name = fcq.concurrent_queue_name (+)
134: AND upper(foa.node_name) = upper(fn.node_name (+))

Line 159: FROM fnd_oam_metval fom

155: (
156: SELECT fom.METRIC_SHORT_NAME metric_name,
157: fom.METRIC_VALUE value,
158: to_char(fom.LAST_UPDATE_DATE,'yyyy/MM/dd HH:mm:ss') last_update
159: FROM fnd_oam_metval fom
160: WHERE fom.METRIC_SHORT_NAME in
161: ('PATCHES','PROFILE_OPT','CONTEXT_FILES_EDITED','INVALID_OBJECTS')
162: )
163: LOOP

Line 208: FROM fnd_oam_metval fom

204: (
205: SELECT fom.METRIC_SHORT_NAME metric_name,
206: decode(to_char(fom.status_code),NULL,'NA','2','DOWN','0','UP','1','WARNING','3','NOT_STARTED','NA') value,
207: to_char(fom.LAST_UPDATE_DATE,'yyyy/MM/dd HH:mm:ss') last_update
208: FROM fnd_oam_metval fom
209: WHERE fom.GROUP_ID = 8
210: )
211: LOOP
212: EXIT WHEN SQL%NOTFOUND;

Line 264: FROM fnd_oam_metval fom

260: (
261: SELECT fom.METRIC_SHORT_NAME metric_name,
262: fom.METRIC_VALUE value,
263: to_char(fom.LAST_UPDATE_DATE,'yyyy/MM/dd HH:mm:ss') last_update
264: FROM fnd_oam_metval fom
265: WHERE fom.METRIC_SHORT_NAME in
266: ('CRIT_UNPR_EXCEP','CRIT_PR_EXCEP','CRIT_TOTAL_UNPR_EXCEP','OPEN_OCC')
267: )
268: LOOP

Line 354: SELECT fnd_oam_em.get_apps_level apps_level,

350:
351:
352: -- open the cursor to return
353: OPEN ret FOR
354: SELECT fnd_oam_em.get_apps_level apps_level,
355: oam_root_url,
356: apps_name,
357: apps_version,
358: multi_org,

Line 461: FROM fnd_oam_app_sys_status foa,

457: BEGIN
458:
459: FOR pair_1 IN
460: ( SELECT foa.status_code sta
461: FROM fnd_oam_app_sys_status foa,
462: fnd_concurrent_queues_vl fcq,
463: FND_OAM_FNDNODES_VL fn,
464: fnd_lookups fl
465: WHERE foa.application_id = fcq.application_id (+)

Line 463: FND_OAM_FNDNODES_VL fn,

459: FOR pair_1 IN
460: ( SELECT foa.status_code sta
461: FROM fnd_oam_app_sys_status foa,
462: fnd_concurrent_queues_vl fcq,
463: FND_OAM_FNDNODES_VL fn,
464: fnd_lookups fl
465: WHERE foa.application_id = fcq.application_id (+)
466: AND foa.concurrent_queue_name = fcq.concurrent_queue_name (+)
467: AND upper(foa.node_name) = upper(fn.node_name (+))

Line 705: fnd_oam_em.get_pend_rqsts('I',application_id,concurrent_queue_id) n_c,

701: where cp.session_id = audsid)
702: )
703: )
704: ) a_p,
705: fnd_oam_em.get_pend_rqsts('I',application_id,concurrent_queue_id) n_c,
706: fnd_oam_em.get_pend_rqsts('Q',application_id,concurrent_queue_id) s_c
707:
708: FROM fnd_concurrent_queues_vl CQ,
709: WHERE manager_type = 1

Line 706: fnd_oam_em.get_pend_rqsts('Q',application_id,concurrent_queue_id) s_c

702: )
703: )
704: ) a_p,
705: fnd_oam_em.get_pend_rqsts('I',application_id,concurrent_queue_id) n_c,
706: fnd_oam_em.get_pend_rqsts('Q',application_id,concurrent_queue_id) s_c
707:
708: FROM fnd_concurrent_queues_vl CQ,
709: WHERE manager_type = 1
710: ORDER BY decode(CQ.control_code, 'X',2,'E',2,1), user_concurrent_queue_name

Line 870: FROM fnd_oam_metval_vl fsm,

866: to_char(fsmg.sequence),
867: fsmg.metric_group_display_name
868:
869:
870: FROM fnd_oam_metval_vl fsm,
871: fnd_oam_met_grps_vl fsmg,
872: FND_OAM_FNDNODES_VL fn
873: WHERE fsm.group_id = fsmg.metric_group_id
874: AND upper(fsm.node_name) = upper(fn.node_name (+))

Line 871: fnd_oam_met_grps_vl fsmg,

867: fsmg.metric_group_display_name
868:
869:
870: FROM fnd_oam_metval_vl fsm,
871: fnd_oam_met_grps_vl fsmg,
872: FND_OAM_FNDNODES_VL fn
873: WHERE fsm.group_id = fsmg.metric_group_id
874: AND upper(fsm.node_name) = upper(fn.node_name (+))
875: ORDER BY fsmg.sequence, fsm.sequence;

Line 872: FND_OAM_FNDNODES_VL fn

868:
869:
870: FROM fnd_oam_metval_vl fsm,
871: fnd_oam_met_grps_vl fsmg,
872: FND_OAM_FNDNODES_VL fn
873: WHERE fsm.group_id = fsmg.metric_group_id
874: AND upper(fsm.node_name) = upper(fn.node_name (+))
875: ORDER BY fsmg.sequence, fsm.sequence;
876:

Line 945: END fnd_oam_em;

941: END get_icm_statusV;
942: */
943:
944:
945: END fnd_oam_em;