APPS.PA_EXCEPTION_ENGINE_PKG dependencies on PA_PERF_BZ_OBJECT

Line 38: FROM pa_perf_bz_object ppbo, pa_projects_all ppa

34: Get the project_id from interface table based on business event and request_id */
35: CURSOR get_project_id(l_perf_txn_set_id IN VARCHAR2, l_proj_from IN NUMBER,
36: l_proj_to IN NUMBER, l_proj IN NUMBER) IS
37: SELECT DISTINCT object_id
38: FROM pa_perf_bz_object ppbo, pa_projects_all ppa
39: WHERE ppbo.object_type = 'PA_PROJECTS'
40: AND ppbo.perf_txn_set_id = l_perf_txn_set_id
41: AND ppa.segment1 between nvl((select segment1 from pa_projects_all where project_id = l_proj_from),' ') and
42: nvl((select segment1 from pa_projects_all where project_id = l_proj_to),ppa.segment1)

Line 157: FROM pa_perf_bz_object

153: CLOSE get_project_id;
154:
155: SELECT bz_ent_code
156: INTO l_bz_event_code
157: FROM pa_perf_bz_object
158: WHERE perf_txn_set_id = p_perf_txn_set_id
159: and rownum = 1;
160:
161: ELSE

Line 1025: pa_debug.write_file('LOG','No records will be deleted from PA_PERF_BZ_OBJECT since Business Event code is not passed in.');

1021: -- Clean the Interface Table PA_PER_BZ_OBJECT --
1022:
1023: IF p_business_event_code = 'N' THEN
1024: IF P_PA_DEBUG_MODE = 'Y' THEN -- Added for Bug 4324824
1025: pa_debug.write_file('LOG','No records will be deleted from PA_PERF_BZ_OBJECT since Business Event code is not passed in.');
1026: END IF;
1027: ELSE
1028: DELETE from pa_perf_bz_object
1029: WHERE bz_ent_code = p_business_event_code;

Line 1028: DELETE from pa_perf_bz_object

1024: IF P_PA_DEBUG_MODE = 'Y' THEN -- Added for Bug 4324824
1025: pa_debug.write_file('LOG','No records will be deleted from PA_PERF_BZ_OBJECT since Business Event code is not passed in.');
1026: END IF;
1027: ELSE
1028: DELETE from pa_perf_bz_object
1029: WHERE bz_ent_code = p_business_event_code;
1030: IF P_PA_DEBUG_MODE = 'Y' THEN
1031: pa_debug.write_file('LOG','Deleting records from PA_PERF_BZ_OBJECT () with success');
1032: END IF;

Line 1031: pa_debug.write_file('LOG','Deleting records from PA_PERF_BZ_OBJECT () with success');

1027: ELSE
1028: DELETE from pa_perf_bz_object
1029: WHERE bz_ent_code = p_business_event_code;
1030: IF P_PA_DEBUG_MODE = 'Y' THEN
1031: pa_debug.write_file('LOG','Deleting records from PA_PERF_BZ_OBJECT () with success');
1032: END IF;
1033: END IF;
1034:
1035: