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_METVAL

Line 103: v_is_supported fnd_oam_metval.is_supported%TYPE;

99: -- For use for Dashbaord Collection Program only.
100: --
101: FUNCTION is_collection_enabled (p_metric_short_name varchar2) RETURN boolean
102: IS
103: v_is_supported fnd_oam_metval.is_supported%TYPE;
104: v_collection_enabled_flag fnd_oam_metval.collection_enabled_flag%TYPE;
105: v_retu boolean := TRUE;
106: BEGIN
107: select nvl(is_supported,'Y'), nvl(collection_enabled_flag,'Y')

Line 104: v_collection_enabled_flag fnd_oam_metval.collection_enabled_flag%TYPE;

100: --
101: FUNCTION is_collection_enabled (p_metric_short_name varchar2) RETURN boolean
102: IS
103: v_is_supported fnd_oam_metval.is_supported%TYPE;
104: v_collection_enabled_flag fnd_oam_metval.collection_enabled_flag%TYPE;
105: v_retu boolean := TRUE;
106: BEGIN
107: select nvl(is_supported,'Y'), nvl(collection_enabled_flag,'Y')
108: into v_is_supported, v_collection_enabled_flag

Line 109: from fnd_oam_metval

105: v_retu boolean := TRUE;
106: BEGIN
107: select nvl(is_supported,'Y'), nvl(collection_enabled_flag,'Y')
108: into v_is_supported, v_collection_enabled_flag
109: from fnd_oam_metval
110: where metric_short_name = p_metric_short_name
111: and rownum = 1;
112:
113: if (v_is_supported = 'N' or v_collection_enabled_flag = 'N') then

Line 190: l_metric_type fnd_oam_metval.metric_type%TYPE;

186: --
187: FUNCTION shall_raise_alert(p_metric_short_name varchar2) RETURN boolean
188: IS
189: v_retu boolean := FALSE;
190: l_metric_type fnd_oam_metval.metric_type%TYPE;
191: l_threshold_operator fnd_oam_metval.threshold_operator%TYPE;
192: l_threshold_value fnd_oam_metval.threshold_value%TYPE;
193: l_operator_symbol varchar2(10);
194: BEGIN

Line 191: l_threshold_operator fnd_oam_metval.threshold_operator%TYPE;

187: FUNCTION shall_raise_alert(p_metric_short_name varchar2) RETURN boolean
188: IS
189: v_retu boolean := FALSE;
190: l_metric_type fnd_oam_metval.metric_type%TYPE;
191: l_threshold_operator fnd_oam_metval.threshold_operator%TYPE;
192: l_threshold_value fnd_oam_metval.threshold_value%TYPE;
193: l_operator_symbol varchar2(10);
194: BEGIN
195: --if (is_alert_enabled(p_metric_short_name)) then

Line 192: l_threshold_value fnd_oam_metval.threshold_value%TYPE;

188: IS
189: v_retu boolean := FALSE;
190: l_metric_type fnd_oam_metval.metric_type%TYPE;
191: l_threshold_operator fnd_oam_metval.threshold_operator%TYPE;
192: l_threshold_value fnd_oam_metval.threshold_value%TYPE;
193: l_operator_symbol varchar2(10);
194: BEGIN
195: --if (is_alert_enabled(p_metric_short_name)) then
196: select metric_type, threshold_operator, threshold_value

Line 198: from fnd_oam_metval

194: BEGIN
195: --if (is_alert_enabled(p_metric_short_name)) then
196: select metric_type, threshold_operator, threshold_value
197: into l_metric_type, l_threshold_operator, l_threshold_value
198: from fnd_oam_metval
199: where metric_short_name = p_metric_short_name
200: and rownum = 1;
201:
202: if (l_threshold_operator is not null and

Line 224: v_check_sql := 'select 1 from fnd_oam_metval where metric_short_name = :1 and '||

220: -- converted literals to use binds where possible
221: begin
222: if (l_threshold_operator = OPER_I) then
223: --can't bind a list, use string concat
224: v_check_sql := 'select 1 from fnd_oam_metval where metric_short_name = :1 and '||
225: v_value_column||' '||l_operator_symbol ||' '||'('||l_threshold_value||')';
226: execute immediate v_check_sql
227: into v_raise_alert
228: using p_metric_short_name;

Line 231: v_check_sql := 'select 1 from fnd_oam_metval where metric_short_name = :1 and '||

227: into v_raise_alert
228: using p_metric_short_name;
229: else
230: --use bind for =,<,> since they're the majority case.
231: v_check_sql := 'select 1 from fnd_oam_metval where metric_short_name = :1 and '||
232: v_value_column||' '||l_operator_symbol ||' '||':2';
233: execute immediate v_check_sql
234: into v_raise_alert
235: using p_metric_short_name, l_threshold_value;

Line 654: -- This procedure will update a row in fnd_oam_metval for the given

650: -- Name
651: -- update_metric_internal
652: -- Purpose
653: -- This procedure is for internal use of this package only!
654: -- This procedure will update a row in fnd_oam_metval for the given
655: -- metric name.
656: --
657: -- Input Arguments
658: -- p_metric_name varchar2

Line 679: update fnd_oam_metval

675: v_userid number;
676: BEGIN
677: v_userid := get_user_id;
678: if p_status_code >= 0 then
679: update fnd_oam_metval
680: set metric_value = p_value,
681: status_code = p_status_code,
682: last_collected_date = sysdate,
683: last_updated_by = v_userid,

Line 688: update fnd_oam_metval

684: last_update_date = sysdate,
685: last_update_login = 0
686: where metric_short_name = p_metric_name;
687: else
688: update fnd_oam_metval
689: set metric_value = p_value,
690: last_collected_date = sysdate,
691: last_updated_by = v_userid,
692: last_update_date = sysdate,

Line 1472: v_alrt_enabled_flag fnd_oam_metval.alert_enabled_flag%TYPE;

1468: -- FNDOAMCOL execution metric value will be counted only upto
1469: -- the threshold value
1470: if (is_collection_enabled('WFM_WAIT_MSG')) then
1471: declare
1472: v_alrt_enabled_flag fnd_oam_metval.alert_enabled_flag%TYPE;
1473: v_threshold_oper fnd_oam_metval.threshold_operator%TYPE;
1474: v_threshold_val fnd_oam_metval.threshold_value%TYPE;
1475: begin
1476: select nvl(alert_enabled_flag,'Y'),

Line 1473: v_threshold_oper fnd_oam_metval.threshold_operator%TYPE;

1469: -- the threshold value
1470: if (is_collection_enabled('WFM_WAIT_MSG')) then
1471: declare
1472: v_alrt_enabled_flag fnd_oam_metval.alert_enabled_flag%TYPE;
1473: v_threshold_oper fnd_oam_metval.threshold_operator%TYPE;
1474: v_threshold_val fnd_oam_metval.threshold_value%TYPE;
1475: begin
1476: select nvl(alert_enabled_flag,'Y'),
1477: threshold_operator, threshold_value

Line 1474: v_threshold_val fnd_oam_metval.threshold_value%TYPE;

1470: if (is_collection_enabled('WFM_WAIT_MSG')) then
1471: declare
1472: v_alrt_enabled_flag fnd_oam_metval.alert_enabled_flag%TYPE;
1473: v_threshold_oper fnd_oam_metval.threshold_operator%TYPE;
1474: v_threshold_val fnd_oam_metval.threshold_value%TYPE;
1475: begin
1476: select nvl(alert_enabled_flag,'Y'),
1477: threshold_operator, threshold_value
1478: into v_alrt_enabled_flag, v_threshold_oper, v_threshold_val

Line 1479: from fnd_oam_metval

1475: begin
1476: select nvl(alert_enabled_flag,'Y'),
1477: threshold_operator, threshold_value
1478: into v_alrt_enabled_flag, v_threshold_oper, v_threshold_val
1479: from fnd_oam_metval
1480: where metric_short_name = 'WFM_WAIT_MSG';
1481:
1482: if (is_request() and
1483: v_alrt_enabled_flag = 'Y' and

Line 1844: -- updates the FND_OAM_METVAL using an autonomous transaction.

1840: -- refresh_miscellaneous
1841: --
1842: -- Purpose
1843: -- Computes the values for the following indicators and
1844: -- updates the FND_OAM_METVAL using an autonomous transaction.
1845: -- Metrics: PL./SQL Agent, Servlet Agent, JSP Agent, JTF, Discoverer,
1846: -- Personal Home Page, TCF
1847: --
1848: -- Input Arguments

Line 1921: from fnd_oam_metval

1917: IS
1918: cursor c_mets is
1919: select metric_short_name, metric_type, metric_value, status_code,
1920: threshold_operator, threshold_value
1921: from fnd_oam_metval
1922: where nvl(is_supported,'Y') = 'Y'
1923: and nvl(collection_enabled_flag,'Y') = 'Y'
1924: and nvl(alert_enabled_flag, 'N') = 'Y'
1925: and group_id <> 8 and group_id <> 0; -- Disabling Alerting for Web Components and Internal Metrics

Line 2377: v_lng_run_req_count fnd_oam_metval_vl.metric_value%TYPE;

2373: -- Internal API for Alerting for Long Running Requests General
2374: --
2375: PROCEDURE ALERT_LRR_GEN
2376: IS
2377: v_lng_run_req_count fnd_oam_metval_vl.metric_value%TYPE;
2378: v_lng_run_req_alert_enable varchar2(1):='';
2379: v_lng_run_req_tolerance varchar2(10):='';
2380: v_lng_run_req_offset varchar2(10):='';
2381:

Line 2418: from fnd_oam_metval

2414:
2415: BEGIN
2416: select threshold_value, alert_enabled_flag
2417: into v_lng_run_req_count, v_lng_run_req_alert_enable
2418: from fnd_oam_metval
2419: where metric_short_name ='LONG_RUNNING_REQ_COUNT';
2420:
2421: select threshold_value into v_lng_run_req_tolerance
2422: from fnd_oam_metval

Line 2422: from fnd_oam_metval

2418: from fnd_oam_metval
2419: where metric_short_name ='LONG_RUNNING_REQ_COUNT';
2420:
2421: select threshold_value into v_lng_run_req_tolerance
2422: from fnd_oam_metval
2423: where metric_short_name ='LONG_RUNNING_REQ_TOLERANCE';
2424:
2425: select threshold_value into v_lng_run_req_offset
2426: from fnd_oam_metval

Line 2426: from fnd_oam_metval

2422: from fnd_oam_metval
2423: where metric_short_name ='LONG_RUNNING_REQ_TOLERANCE';
2424:
2425: select threshold_value into v_lng_run_req_offset
2426: from fnd_oam_metval
2427: where metric_short_name ='LONG_RUNNING_REQ_OFFSET';
2428:
2429: if(v_lng_run_req_alert_enable ='Y') then
2430: open req_id_list(v_lng_run_req_tolerance,v_lng_run_req_offset);

Line 2522: from fnd_oam_metval

2518:
2519: BEGIN
2520:
2521: select threshold_value into v_spec_long_run_enabled
2522: from fnd_oam_metval
2523: where metric_short_name ='SPECIFIC_LONG_RUNNING_ENABLED';
2524:
2525: if(v_spec_long_run_enabled ='Y') then
2526: --debug('v_spec_long_run_enabled is Y');

Line 2577: v_lng_pend_req_count fnd_oam_metval_vl.metric_value%TYPE;

2573: -- Internal API for Alerting for Long Pending Requests General
2574: --
2575: PROCEDURE ALERT_LPR_GEN
2576: IS
2577: v_lng_pend_req_count fnd_oam_metval_vl.metric_value%TYPE;
2578: v_lng_pend_req_alert_enable varchar2(1):='';
2579: v_lng_pend_req_tolerance varchar2(10):='';
2580:
2581: cursor req_id_list(p_tol varchar2) is

Line 2615: from fnd_oam_metval

2611:
2612: BEGIN
2613: select threshold_value,alert_enabled_flag
2614: into v_lng_pend_req_count,v_lng_pend_req_alert_enable
2615: from fnd_oam_metval
2616: where metric_short_name ='LONG_PENDING_REQ_COUNT';
2617:
2618: select threshold_value
2619: into v_lng_pend_req_tolerance

Line 2620: from fnd_oam_metval

2616: where metric_short_name ='LONG_PENDING_REQ_COUNT';
2617:
2618: select threshold_value
2619: into v_lng_pend_req_tolerance
2620: from fnd_oam_metval
2621: where metric_short_name ='LONG_PENDING_REQ_TOLERANCE';
2622:
2623: if(v_lng_pend_req_alert_enable ='Y') then
2624: open req_id_list(v_lng_pend_req_tolerance);

Line 2704: from fnd_oam_metval

2700: BEGIN
2701:
2702: select threshold_value
2703: into v_spec_long_pend_enabled
2704: from fnd_oam_metval
2705: where metric_short_name ='SPECIFIC_LONG_PENDING_ENABLED';
2706:
2707: if (v_spec_long_pend_enabled ='Y') then
2708: select count(*) into v_spec_cnt