APPS.PA_EXCEPTION_ENGINE_PKG dependencies on PA_PERF_BZ_MEASURES

Line 28: l_bz_event_code pa_perf_bz_measures.bz_event_code%TYPE;

24: p_bz_event_code IN VARCHAR2 DEFAULT 'N',
25: p_perf_txn_set_id IN VARCHAR2 DEFAULT 'N') IS
26:
27: l_project_list PA_PLSQL_DATATYPES.IdTabTyp;
28: l_bz_event_code pa_perf_bz_measures.bz_event_code%TYPE;
29: l_perf_txn_set_id pa_perf_transactions.perf_txn_id%TYPE;
30: l_proj NUMBER;
31: l_no_params_err_msg VARCHAR2(2000);
32:

Line 340: l_bz_ent_code pa_perf_bz_measures.bz_event_code%TYPE;

336: l_measure_value NUMBER;
337:
338:
339:
340: l_bz_ent_code pa_perf_bz_measures.bz_event_code%TYPE;
341: l_count NUMBER;
342:
343: l_cursor INTEGER;
344: l_rows INTEGER;

Line 471: --- from pa_perf_bz_measures for the given measure id

467: IF l_measure_id is NULL THEN
468: PA_DEBUG.write_file('LOG', 'Rule ID '||l_rule_list(j)||' has no associated measure id');
469: ELSE
470: --- If bz_ent_code is not passed in, get one bz_ent_code
471: --- from pa_perf_bz_measures for the given measure id
472: IF (p_business_event_code = 'N') THEN
473: SELECT count(*) INTO l_count FROM dual where EXISTS
474: (SELECT bz_event_code
475: FROM pa_perf_bz_measures

Line 475: FROM pa_perf_bz_measures

471: --- from pa_perf_bz_measures for the given measure id
472: IF (p_business_event_code = 'N') THEN
473: SELECT count(*) INTO l_count FROM dual where EXISTS
474: (SELECT bz_event_code
475: FROM pa_perf_bz_measures
476: WHERE measure_id = l_measure_id);
477: IF l_count = 0 THEN
478: --NULL;
479: l_bz_ent_code := null;

Line 483: FROM pa_perf_bz_measures

479: l_bz_ent_code := null;
480: ELSE
481: SELECT bz_event_code
482: INTO l_bz_ent_code
483: FROM pa_perf_bz_measures
484: WHERE measure_id = l_measure_id
485: AND rownum = 1;
486: END IF;
487:

Line 705: FROM pa_perf_bz_measures

701: --WHERE project_id = l_object_list(i) --Modified for Bug3639490
702: WHERE perf_txn_obj_type = 'PA_PROJECTS'
703: AND perf_txn_obj_id = l_object_list(i)
704: AND measure_id in (SELECT measure_id
705: FROM pa_perf_bz_measures
706: WHERE bz_event_code = p_business_event_code)
707: AND current_flag = 'Y');
708: IF l_count = 0 THEN
709: null;

Line 717: FROM pa_perf_bz_measures

713: --WHERE project_id = l_object_list(i) --Modified for bug 3639490
714: WHERE perf_txn_obj_type = 'PA_PROJECTS'
715: AND perf_txn_obj_id = l_object_list(i)
716: AND measure_id in (SELECT measure_id
717: FROM pa_perf_bz_measures
718: WHERE bz_event_code = p_business_event_code)
719: AND current_flag = 'Y';
720: END IF;
721: