APPS.PA_PERF_EXCP_UTILS dependencies on PA_NUM_TBL_TYPE

Line 371: ,p_measure_id in SYSTEM.PA_NUM_TBL_TYPE

367: Function get_measure_indicator_list
368: (
369: p_object_type in varchar2
370: ,p_object_id in number
371: ,p_measure_id in SYSTEM.PA_NUM_TBL_TYPE
372: ,p_period_type in varchar2 DEFAULT NULL
373: ,p_period_name in VARCHAR2 DEFAULT NULL
374: ,p_raw_text_flag in VARCHAR2 DEFAULT 'Y'
375: ,x_perf_txn_id out NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895

Line 375: ,x_perf_txn_id out NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895

371: ,p_measure_id in SYSTEM.PA_NUM_TBL_TYPE
372: ,p_period_type in varchar2 DEFAULT NULL
373: ,p_period_name in VARCHAR2 DEFAULT NULL
374: ,p_raw_text_flag in VARCHAR2 DEFAULT 'Y'
375: ,x_perf_txn_id out NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
376: ,x_excp_meaning out NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE --File.Sql.39 bug 4440895
377: ) return SYSTEM.pa_varchar2_2000_tbl_type
378:
379: IS

Line 387: l_perf_txn_id_tbl SYSTEM.PA_NUM_TBL_TYPE;

383: l_tran_id NUMBER;
384: l_flag VARCHAR2(1);
385: l_meaning_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
386: l_icon_tbl SYSTEM.pa_varchar2_2000_tbl_type;
387: l_perf_txn_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
388: l_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
389: l_meaure_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
390: l_indicators SYSTEM.pa_varchar2_2000_tbl_type;
391:

Line 389: l_meaure_id_tbl SYSTEM.PA_NUM_TBL_TYPE;

385: l_meaning_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
386: l_icon_tbl SYSTEM.pa_varchar2_2000_tbl_type;
387: l_perf_txn_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
388: l_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
389: l_meaure_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
390: l_indicators SYSTEM.pa_varchar2_2000_tbl_type;
391:
392: CURSOR get_indicator (l_measure_id IN NUMBER)
393: IS

Line 439: x_perf_txn_id := SYSTEM.PA_NUM_TBL_TYPE();

435: l_indicators.extend(p_measure_id.count);
436:
437: /* Code added for bug#3894113, starts here */
438:
439: x_perf_txn_id := SYSTEM.PA_NUM_TBL_TYPE();
440: x_perf_txn_id.extend(p_measure_id.count);
441:
442: x_excp_meaning := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
443: x_excp_meaning.extend(p_measure_id.count);