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_PLSQL_DATATYPES

Line 27: l_project_list PA_PLSQL_DATATYPES.IdTabTyp;

23: p_daysold IN NUMBER DEFAULT NULL,
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);

Line 306: PROCEDURE generate_exception(p_project_list IN PA_PLSQL_DATATYPES.IdTabTyp,

302: -- Procedure generate_exception
303: -- Purpose This procedure will be called by concurrent program.
304: -- Once running, it will generate the performance transactions
305:
306: PROCEDURE generate_exception(p_project_list IN PA_PLSQL_DATATYPES.IdTabTyp,
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:

Line 318: l_object_list PA_PLSQL_DATATYPES.IdTabTyp;

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;
320: l_measure_list PA_PLSQL_DATATYPES.IdTabTyp;
321: l_bz_code_list PA_PLSQL_DATATYPES.Char30TabTyp;
322: l_program_name VARCHAR2(100);

Line 319: l_rule_list PA_PLSQL_DATATYPES.IdTabTyp;

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;
320: l_measure_list PA_PLSQL_DATATYPES.IdTabTyp;
321: l_bz_code_list PA_PLSQL_DATATYPES.Char30TabTyp;
322: l_program_name VARCHAR2(100);
323:

Line 320: l_measure_list PA_PLSQL_DATATYPES.IdTabTyp;

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;
320: l_measure_list PA_PLSQL_DATATYPES.IdTabTyp;
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;

Line 321: l_bz_code_list PA_PLSQL_DATATYPES.Char30TabTyp;

317:
318: l_object_list PA_PLSQL_DATATYPES.IdTabTyp;
319: l_rule_list PA_PLSQL_DATATYPES.IdTabTyp;
320: l_measure_list PA_PLSQL_DATATYPES.IdTabTyp;
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;

Line 1069: p_project_list IN PA_PLSQL_DATATYPES.IdTabTyp,

1065: -- Purpose This procedure will be called by concurrent program.
1066: -- Once running, it will generate the workflow notification for each.
1067:
1068: PROCEDURE generate_notification(
1069: p_project_list IN PA_PLSQL_DATATYPES.IdTabTyp,
1070: x_errbuf OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1071: x_retcode OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
1072:
1073: CURSOR get_page( c_object_id NUMBER)

Line 1082: l_project_list PA_PLSQL_DATATYPES.IdTabTyp;

1078: AND object_type = 'PA_PROJECTS'
1079: AND page_type_code='PPR'
1080: AND generation_method='AUTOMATIC';
1081:
1082: l_project_list PA_PLSQL_DATATYPES.IdTabTyp;
1083: l_msg_count NUMBER := 0;
1084: l_data VARCHAR2(2000);
1085: l_msg_data VARCHAR2(2000);
1086: l_msg_index_out NUMBER;

Line 1185: PROCEDURE purge_transaction( p_project_list IN PA_PLSQL_DATATYPES.IdTabTyp,

1181: -- Procedure purge_transaction
1182: -- Purpose This procedure will call logic to cleanup data in the
1183: -- PA_PERF_TRANSACTIONS table.
1184:
1185: PROCEDURE purge_transaction( p_project_list IN PA_PLSQL_DATATYPES.IdTabTyp,
1186: p_days_old IN NUMBER,
1187: x_errbuf OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1188: x_retcode OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
1189:

Line 1376: PROCEDURE get_kpa_score(p_project_list IN PA_PLSQL_DATATYPES.IdTabTyp,

1372:
1373: -- Procedure get_kpa_score
1374: -- Purpose This procedure will be called by concurrent program.
1375: -- Once running, it will generate the Project KPA Summary.
1376: PROCEDURE get_kpa_score(p_project_list IN PA_PLSQL_DATATYPES.IdTabTyp,
1377: x_errbuf OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1378: x_retcode OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
1379:
1380:

Line 1384: l_kpas PA_PLSQL_DATATYPES.Char30TabTyp ;

1380:
1381: l_summary_table pa_exception_engine_pkg.summary_table;
1382: l_summary_seq NUMBER;
1383: l_summary_det_seq NUMBER;
1384: l_kpas PA_PLSQL_DATATYPES.Char30TabTyp ;
1385: l_score NUMBER;
1386: l_count NUMBER;
1387: l_kpa_rule_id NUMBER;
1388: l_weighting NUMBER;

Line 1399: l_score_list pa_plsql_datatypes.NumTabTyp ;

1395: l_rule_id NUMBER;
1396:
1397: l_counter NUMBER;
1398:
1399: l_score_list pa_plsql_datatypes.NumTabTyp ;
1400: l_count_list PA_PLSQL_DATATYPES.NumTabTyp ;
1401:
1402: CURSOR get_kpas IS
1403: SELECT lookup_code

Line 1400: l_count_list PA_PLSQL_DATATYPES.NumTabTyp ;

1396:
1397: l_counter NUMBER;
1398:
1399: l_score_list pa_plsql_datatypes.NumTabTyp ;
1400: l_count_list PA_PLSQL_DATATYPES.NumTabTyp ;
1401:
1402: CURSOR get_kpas IS
1403: SELECT lookup_code
1404: FROM pa_lookups