APPS.PA_PERF_EXCP_UTILS dependencies on PA_VARCHAR2_2000_TBL_TYPE

Line 11: , x_indicators out NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE --File.Sql.39 bug 4440895

7: (
8: p_object_type in varchar2
9: , p_object_id in number
10: , p_kpa_codes in SYSTEM.PA_VARCHAR2_30_TBL_TYPE
11: , x_indicators out NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE --File.Sql.39 bug 4440895
12: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
13: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
14: , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
15: , x_ind_meaning out NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE --Added for bug 4064923 --File.Sql.39 bug 4440895

Line 59: x_indicators := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();

55: BEGIN
56:
57: x_return_status := FND_API.G_RET_STS_SUCCESS;
58:
59: x_indicators := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
60: x_ind_meaning := SYSTEM.PA_VARCHAR2_80_TBL_TYPE(); --Added for bug 4064923
61: x_indicators.extend(p_kpa_codes.count);
62: x_ind_meaning.extend(p_kpa_codes.count); --Added for bug 4064923
63: pa_security_pvt.check_user_privilege(x_ret_code => l_return_code,

Line 377: ) return SYSTEM.pa_varchar2_2000_tbl_type

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
380:
381: l_meaning VARCHAR2(80);

Line 386: l_icon_tbl SYSTEM.pa_varchar2_2000_tbl_type;

382: l_icon VARCHAR2(150);
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;

Line 390: l_indicators SYSTEM.pa_varchar2_2000_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
394: SELECT

Line 433: l_indicators := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();

429:
430: END IF;
431:
432:
433: l_indicators := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
434:
435: l_indicators.extend(p_measure_id.count);
436:
437: /* Code added for bug#3894113, starts here */