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_RULES

Line 311: l_measure_id pa_perf_rules.measure_id%TYPE;

307: p_business_event_code IN VARCHAR2,
308: x_errbuf OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
309: x_retcode OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
310:
311: l_measure_id pa_perf_rules.measure_id%TYPE;
312: l_rule_id pa_perf_object_rules.rule_id%TYPE;
313: l_object_type pa_perf_object_rules.object_type%TYPE;
314: l_period_type pa_perf_rules.period_type%TYPE;
315: l_currency_type pa_perf_rules.currency_type%TYPE;

Line 314: l_period_type pa_perf_rules.period_type%TYPE;

310:
311: l_measure_id pa_perf_rules.measure_id%TYPE;
312: l_rule_id pa_perf_object_rules.rule_id%TYPE;
313: l_object_type pa_perf_object_rules.object_type%TYPE;
314: l_period_type pa_perf_rules.period_type%TYPE;
315: l_currency_type pa_perf_rules.currency_type%TYPE;
316: l_period_name pa_perf_transactions.period_name%TYPE;
317:
318: l_object_list PA_PLSQL_DATATYPES.IdTabTyp;

Line 315: l_currency_type pa_perf_rules.currency_type%TYPE;

311: l_measure_id pa_perf_rules.measure_id%TYPE;
312: l_rule_id pa_perf_object_rules.rule_id%TYPE;
313: l_object_type pa_perf_object_rules.object_type%TYPE;
314: l_period_type pa_perf_rules.period_type%TYPE;
315: l_currency_type pa_perf_rules.currency_type%TYPE;
316: l_period_name pa_perf_transactions.period_name%TYPE;
317:
318: l_object_list PA_PLSQL_DATATYPES.IdTabTyp;
319: l_rule_list PA_PLSQL_DATATYPES.IdTabTyp;

Line 325: l_kpa_code pa_perf_rules.kpa_code%TYPE;

321: l_bz_code_list PA_PLSQL_DATATYPES.Char30TabTyp;
322: l_program_name VARCHAR2(100);
323:
324: l_object_rule_id pa_perf_object_rules.object_rule_id%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;

Line 326: l_precision pa_perf_rules.precision%TYPE;

322: l_program_name VARCHAR2(100);
323:
324: l_object_rule_id pa_perf_object_rules.object_rule_id%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;

Line 327: l_measure_format pa_perf_rules.measure_format%TYPE;

323:
324: l_object_rule_id pa_perf_object_rules.object_rule_id%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;

Line 328: l_rule_type pa_perf_rules.rule_type%TYPE;

324: l_object_rule_id pa_perf_object_rules.object_rule_id%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;

Line 357: FROM pa_perf_object_rules ppor, pa_perf_rules ppr, pa_lookups pl -- Bug 4275320: Added pa_lookups

353:
354: /* Get all the project_id with rule_id and store it in PLSQL table */
355: CURSOR get_proj_rule_id (l_proj_id IN NUMBER) IS
356: SELECT distinct(ppor.object_id)
357: FROM pa_perf_object_rules ppor, pa_perf_rules ppr, pa_lookups pl -- Bug 4275320: Added pa_lookups
358: WHERE ppor.object_id = l_proj_id
359: AND ppor.rule_id is not null
360: AND ppor.object_type = 'PA_PROJECTS'
361: AND ppor.rule_id = ppr.rule_id

Line 370: FROM pa_perf_object_rules ppor, pa_perf_rules ppr, pa_lookups pl -- Bug 4275320: Added pa_lookups

366:
367: /* Get all the rule_id associated with the project_id */
368: CURSOR get_rule_id (l_proj_id IN NUMBER) IS
369: SELECT ppor.rule_id
370: FROM pa_perf_object_rules ppor, pa_perf_rules ppr, pa_lookups pl -- Bug 4275320: Added pa_lookups
371: WHERE ppor.object_id = l_proj_id
372: AND ppor.object_type = 'PA_PROJECTS'
373: AND ppor.rule_id = ppr.rule_id
374: AND ppr.rule_type = 'PERF_RULE'

Line 384: pa_perf_rules ppr

380: CURSOR get_measures (l_proj_id IN NUMBER, l_rule_id IN NUMBER) IS
381: SELECT ppr.measure_id, ppr.period_type,
382: ppr.currency_type, ppor.object_type
383: FROM pa_perf_object_rules ppor,
384: pa_perf_rules ppr
385: WHERE ppor.object_type = 'PA_PROJECTS'
386: AND ppor.object_id = l_proj_id
387: AND ppor.rule_id = l_rule_id
388: AND ppr.rule_id = ppor.rule_id

Line 766: FROM pa_perf_rules ppr,

762: INTO l_measure_value, l_period_name,
763: l_rule_id, l_object_type, l_object_rule_id,
764: l_kpa_code, l_precision, l_currency_type, l_measure_format,
765: l_rule_type
766: FROM pa_perf_rules ppr,
767: pa_perf_object_rules ppor,
768: pa_perf_temp_obj_measure pptom
769: WHERE pptom.object_id = l_object_list(i)
770: AND pptom.object_id = ppor.object_id

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

Line 1414: pa_perf_rules ppr, pa_perf_object_rules ppor

1410: IS
1411: select
1412: ppor.rule_id
1413: from
1414: pa_perf_rules ppr, pa_perf_object_rules ppor
1415: where
1416: ppor.object_type = 'PA_PROJECTS'
1417: AND ppor.object_id = l_proj_id
1418: and ppr.kpa_code = l_kpa_code

Line 1431: pa_perf_rules ppr, pa_perf_object_rules ppor

1427: IS
1428: select Nvl(sum(ppem.weighting), 0),
1429: MIN (ppor.rule_id), COUNT(ppem.perf_txn_id)
1430: from pa_perf_transactions ppem ,
1431: pa_perf_rules ppr, pa_perf_object_rules ppor
1432: where ppem.current_flag = 'Y'
1433: and ppem.perf_txn_obj_type = 'PA_PROJECTS'
1434: and ppem.perf_txn_obj_id = l_proj_id
1435: AND ppor.object_type = 'PA_PROJECTS'

Line 1454: pa_perf_rules ppr, pa_perf_object_rules ppor

1450: select
1451: COUNT(ppem.perf_txn_id),
1452: Nvl(sum(ppem.weighting), 0)
1453: from pa_perf_transactions ppem ,
1454: pa_perf_rules ppr, pa_perf_object_rules ppor
1455: where ppem.current_flag = 'Y'
1456: and ppem.perf_txn_obj_type = 'PA_PROJECTS'
1457: and ppem.perf_txn_obj_id = l_proj_id
1458: AND ppor.object_type = 'PA_PROJECTS'