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_COLLECTION dependencies on FND_OAM_APP_SYS_STATUS

Line 285: v_check_sql := 'select 1 from fnd_oam_app_sys_status where ' ||

281: begin
282: -- construct threshold check sql and execute
283: -- bug #4670957 - ilawler
284: -- converted literals to use binds where possible
285: v_check_sql := 'select 1 from fnd_oam_app_sys_status where ' ||
286: 'application_id = :1 and concurrent_queue_name = :2 and ' ||
287: 'status_code IN ' || '('||l_threshold_value||')';
288: --dbms_output.put_line('CHK_SQL: ' || v_check_sql);
289:

Line 603: -- This procedure will insert a row into fnd_oam_app_sys_status

599: -- Name
600: -- insert_app_sys_status_internal
601: -- Purpose
602: -- This procedure is for internal use of this package only!
603: -- This procedure will insert a row into fnd_oam_app_sys_status
604: --
605: -- Input Arguments
606: -- p_metric_short_name varchar2
607: -- p_application_id number

Line 635: insert into fnd_oam_app_sys_status (metric_short_name, application_id,

631: v_userid number;
632: BEGIN
633: v_userid := get_user_id;
634:
635: insert into fnd_oam_app_sys_status (metric_short_name, application_id,
636: concurrent_queue_name, name, type, status_code, node_name, last_updated_by,
637: last_update_date, last_update_login)
638: values
639: (p_metric_short_name,

Line 706: -- fnd_oam_app_sys_status

702: -- This procedure is for internal use of this package only!
703: -- For a given server type, and node name this procedure will insert
704: -- the status information for all the service instances for that
705: -- particular server type running on the given node into
706: -- fnd_oam_app_sys_status
707: --
708: -- Input Arguments
709: -- p_server_type varchar2 - 'C' - Concurrent Processing,
710: -- - 'F' - Forms

Line 909: select status_code from fnd_oam_app_sys_status

905:
906: BEGIN
907: declare
908: cursor server_st is
909: select status_code from fnd_oam_app_sys_status
910: where metric_short_name like p_server || '%';
911: overall_st number := STATUS_NORMAL;
912: found_up boolean := false;
913: found_warning boolean := false;

Line 965: -- fnd_oam_app_sys_status

961: -- This procedure is for internal use of this package only!
962: -- For a given server type, and node name this procedure will insert
963: -- the status information for all the service instances for that
964: -- particular server type running on the given node into
965: -- fnd_oam_app_sys_status
966: --
967: -- Input Arguments
968: -- p_server_type varchar2 - 'C' - Concurrent Processing,
969: -- - 'F' - Forms

Line 1013: select status_code from fnd_oam_app_sys_status where

1009: v_found_inactive_instance boolean := false;
1010: v_count number := 0;
1011:
1012: cursor status_c is
1013: select status_code from fnd_oam_app_sys_status where
1014: upper(node_name) = upper(p_node_name) and (
1015: metric_short_name like p_server_type || '_%');
1016: info_table st_table;
1017: begin

Line 1039: from fnd_oam_app_sys_status

1035: declare
1036: v_host_status number;
1037: begin
1038: select status_code into v_host_status
1039: from fnd_oam_app_sys_status
1040: where upper(node_name) = upper(p_node_name)
1041: and metric_short_name like 'HOST_%'
1042: and rownum = 1; -- we expect only one row per host
1043: register_status_in_table(v_host_status, info_table);

Line 1068: -- updated in the FND_OAM_APP_SYS_STATUS table

1064: -- Purpose
1065: -- Derives the status of the following applications servers using URL
1066: -- pings of the corresponding processes that belong to the server. The status
1067: -- and host information for each of the processes as well as servers are
1068: -- updated in the FND_OAM_APP_SYS_STATUS table
1069: -- 1) Admin - Currently no processes are defined for this server
1070: -- 2) Web - Consists of Apache Web Listener, Apache Jserv
1071: -- 3) Forms - Consists of the forms launcher
1072: -- 4) CP - Consists of the Internal Concurrent Manager, Reports

Line 1098: delete from fnd_oam_app_sys_status;

1094: nvl(support_db, 'N') = 'Y');
1095: BEGIN
1096: -- delete existing app sys status information. We will change this later if we are
1097: -- going to move it to an archive table
1098: delete from fnd_oam_app_sys_status;
1099:
1100: -- now update latest host information
1101: declare
1102: i number := 1;

Line 1231: from fnd_oam_app_sys_status

1227: v_temp number;
1228: v_host_count number;
1229: begin
1230: select 1 into v_temp
1231: from fnd_oam_app_sys_status
1232: where metric_short_name like 'HOST_%'
1233: and node_name = db.host_name;
1234: exception
1235: when no_data_found then

Line 1237: from fnd_oam_app_sys_status

1233: and node_name = db.host_name;
1234: exception
1235: when no_data_found then
1236: select count(*) into v_host_count
1237: from fnd_oam_app_sys_status
1238: where metric_short_name like 'HOST_%'
1239: and node_name is not null;
1240:
1241: insert_app_sys_status_internal(

Line 1250: -- fnd_oam_app_sys_status

1246: v_node_name := db.host_name;
1247: end if;
1248:
1249: -- now insert status Database instance into
1250: -- fnd_oam_app_sys_status
1251: -- we will insert only if an entry for the host on which the
1252: -- db instance lives has already been inserted. This way we
1253: -- will avoid errors during computing rollup in situations where
1254: -- a db instance was living on a node that is not being

Line 1260: from fnd_oam_app_sys_status

1256: declare
1257: v_temp number;
1258: begin
1259: select 1 into v_temp
1260: from fnd_oam_app_sys_status
1261: where metric_short_name like 'HOST_%'
1262: and node_name = v_node_name;
1263:
1264: select count(*) into v_db_count

Line 1265: from fnd_oam_app_sys_status

1261: where metric_short_name like 'HOST_%'
1262: and node_name = v_node_name;
1263:
1264: select count(*) into v_db_count
1265: from fnd_oam_app_sys_status
1266: where metric_short_name like 'DATABASE_INS_%'
1267: and node_name = v_node_name;
1268:
1269: insert_app_sys_status_internal(

Line 1283: select node_name from fnd_oam_app_sys_status

1279: -- DATA SERVER
1280: -- Now compute the rollup for database server status on each node
1281: declare
1282: cursor all_monitored_nodes is
1283: select node_name from fnd_oam_app_sys_status
1284: where metric_short_name like 'HOST_%'
1285: and node_name is not null;
1286: cursor db_instance (p_node varchar2) is
1287: select metric_short_name, status_code

Line 1288: from fnd_oam_app_sys_status

1284: where metric_short_name like 'HOST_%'
1285: and node_name is not null;
1286: cursor db_instance (p_node varchar2) is
1287: select metric_short_name, status_code
1288: from fnd_oam_app_sys_status
1289: where metric_short_name like 'DATABASE_INS_%'
1290: and node_name = p_node;
1291: begin
1292: for nd in all_monitored_nodes loop

Line 1933: from fnd_oam_app_sys_status foa,

1929: select foa.application_id application_id,
1930: foa.concurrent_queue_name concurrent_queue_name,
1931: fcq.concurrent_queue_id concurrent_queue_id,
1932: foa.status_code status_code
1933: from fnd_oam_app_sys_status foa,
1934: fnd_concurrent_queues fcq,
1935: fnd_oam_svci_info fsi
1936: where foa.application_id = fcq.application_id
1937: and foa.concurrent_queue_name = fcq.concurrent_queue_name