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.PA_EXCEPTION_ENGINE_PKG dependencies on PA_PERF_THRESHOLDS

Line 329: l_thres_from pa_perf_thresholds.from_value%TYPE;

325: l_kpa_code pa_perf_rules.kpa_code%TYPE;
326: l_precision pa_perf_rules.precision%TYPE;
327: l_measure_format pa_perf_rules.measure_format%TYPE;
328: l_rule_type pa_perf_rules.rule_type%TYPE;
329: l_thres_from pa_perf_thresholds.from_value%TYPE;
330: l_thres_to pa_perf_thresholds.to_value%TYPE;
331: l_threshold_id pa_perf_thresholds.threshold_id%TYPE;
332: l_indicator_code pa_perf_thresholds.indicator_code%TYPE;
333: l_weighting pa_perf_thresholds.weighting%TYPE;

Line 330: l_thres_to pa_perf_thresholds.to_value%TYPE;

326: l_precision pa_perf_rules.precision%TYPE;
327: l_measure_format pa_perf_rules.measure_format%TYPE;
328: l_rule_type pa_perf_rules.rule_type%TYPE;
329: l_thres_from pa_perf_thresholds.from_value%TYPE;
330: l_thres_to pa_perf_thresholds.to_value%TYPE;
331: l_threshold_id pa_perf_thresholds.threshold_id%TYPE;
332: l_indicator_code pa_perf_thresholds.indicator_code%TYPE;
333: l_weighting pa_perf_thresholds.weighting%TYPE;
334: l_exception_flag pa_perf_thresholds.exception_flag%TYPE;

Line 331: l_threshold_id pa_perf_thresholds.threshold_id%TYPE;

327: l_measure_format pa_perf_rules.measure_format%TYPE;
328: l_rule_type pa_perf_rules.rule_type%TYPE;
329: l_thres_from pa_perf_thresholds.from_value%TYPE;
330: l_thres_to pa_perf_thresholds.to_value%TYPE;
331: l_threshold_id pa_perf_thresholds.threshold_id%TYPE;
332: l_indicator_code pa_perf_thresholds.indicator_code%TYPE;
333: l_weighting pa_perf_thresholds.weighting%TYPE;
334: l_exception_flag pa_perf_thresholds.exception_flag%TYPE;
335:

Line 332: l_indicator_code pa_perf_thresholds.indicator_code%TYPE;

328: l_rule_type pa_perf_rules.rule_type%TYPE;
329: l_thres_from pa_perf_thresholds.from_value%TYPE;
330: l_thres_to pa_perf_thresholds.to_value%TYPE;
331: l_threshold_id pa_perf_thresholds.threshold_id%TYPE;
332: l_indicator_code pa_perf_thresholds.indicator_code%TYPE;
333: l_weighting pa_perf_thresholds.weighting%TYPE;
334: l_exception_flag pa_perf_thresholds.exception_flag%TYPE;
335:
336: l_measure_value NUMBER;

Line 333: l_weighting pa_perf_thresholds.weighting%TYPE;

329: l_thres_from pa_perf_thresholds.from_value%TYPE;
330: l_thres_to pa_perf_thresholds.to_value%TYPE;
331: l_threshold_id pa_perf_thresholds.threshold_id%TYPE;
332: l_indicator_code pa_perf_thresholds.indicator_code%TYPE;
333: l_weighting pa_perf_thresholds.weighting%TYPE;
334: l_exception_flag pa_perf_thresholds.exception_flag%TYPE;
335:
336: l_measure_value NUMBER;
337:

Line 334: l_exception_flag pa_perf_thresholds.exception_flag%TYPE;

330: l_thres_to pa_perf_thresholds.to_value%TYPE;
331: l_threshold_id pa_perf_thresholds.threshold_id%TYPE;
332: l_indicator_code pa_perf_thresholds.indicator_code%TYPE;
333: l_weighting pa_perf_thresholds.weighting%TYPE;
334: l_exception_flag pa_perf_thresholds.exception_flag%TYPE;
335:
336: l_measure_value NUMBER;
337:
338:

Line 1286: -- PA_PERF_THRESHOLDS table.

1282: END purge_transaction;
1283:
1284: -- Procedure get_threshold
1285: -- Purpose This procedure will return information from
1286: -- PA_PERF_THRESHOLDS table.
1287:
1288: PROCEDURE get_threshold (
1289: p_rule_id IN NUMBER,
1290: p_rule_type IN VARCHAR2,

Line 1320: FROM pa_perf_thresholds pt, pa_perf_rules pr

1316: SELECT COUNT(*) INTO l_count FROM dual WHERE EXISTS
1317: (
1318: SELECT pt.threshold_Id, pt.indicator_code, pt.exception_flag,
1319: pt.weighting, pt.from_value, pt.to_value
1320: FROM pa_perf_thresholds pt, pa_perf_rules pr
1321: WHERE pr.rule_id = NVL(p_rule_id, -99)
1322: AND pr.rule_id = pt.thres_obj_id
1323: AND pt.rule_type = p_rule_type
1324: AND pr.rule_type = pt.rule_type

Line 1336: FROM pa_perf_thresholds pt, pa_perf_rules pr

1332: SELECT pt.threshold_Id, pt.indicator_code, pt.exception_flag,
1333: pt.weighting, pt.from_value, pt.to_value
1334: INTO x_threshold_id, x_indicator_code, x_exception_flag,
1335: x_weighting, x_from_value, x_to_value
1336: FROM pa_perf_thresholds pt, pa_perf_rules pr
1337: WHERE pr.rule_id = NVL(p_rule_id, -99)
1338: AND pr.rule_id = pt.thres_obj_id
1339: AND pt.rule_type = p_rule_type
1340: AND pr.rule_type = pt.rule_type