[Home] [Help]
PACKAGE: APPS.PA_PERF_EXCP_UTILS
Source
1 PACKAGE PA_PERF_EXCP_UTILS AS
2 /* $Header: PAPEUTLS.pls 120.1 2005/08/19 16:40:16 mwasowic noship $ */
3
4 --Merge exception
5 RAISE_MERGE_ERROR EXCEPTION;
6 PRAGMA EXCEPTION_INIT(RAISE_MERGE_ERROR, -501);
7
8 Procedure get_kpa_color_indicator_list
9 (
10 p_object_type in varchar2
11 , p_object_id in number
12 , p_kpa_codes in SYSTEM.PA_VARCHAR2_30_TBL_TYPE
13 , x_indicators out NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE --File.Sql.39 bug 4440895
14 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
15 , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
16 , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
17 , x_ind_meaning out NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE --Added for bug 4064923 --File.Sql.39 bug 4440895
18 ) ;
19
20
21 Procedure get_kpa_name_list
22 (
23 p_kpa_codes in SYSTEM.PA_VARCHAR2_30_TBL_TYPE
24 , x_kpa_names OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE --File.Sql.39 bug 4440895
25 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
26 , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
27 , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
28 );
29
30 Function get_kpa_color_indicator
31 (
32 p_object_type in varchar2
33 ,p_object_id in number
34 , p_kpa_code in varchar2
35 ) return VARCHAR2;
36
37 Function get_measure_indicator
38 (
39 p_object_type in varchar2
40 ,p_object_id in number
41 ,p_measure_id in number
42 ,p_period_type in VARCHAR2 DEFAULT NULL
43 ,p_period_name in VARCHAR2 DEFAULT NULL
44 ,p_raw_text_flag in VARCHAR2 DEFAULT 'Y'
45 ,x_perf_txn_id out NOCOPY NUMBER --File.Sql.39 bug 4440895
46 ,x_excp_meaning out NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
47 ) return VARCHAR2;
48
49
50 Function get_measure_indicator_list
51 (
52 p_object_type in varchar2
53 ,p_object_id in number
54 ,p_measure_id in SYSTEM.PA_NUM_TBL_TYPE
55 ,p_period_type in VARCHAR2 DEFAULT NULL
56 ,p_period_name in VARCHAR2 DEFAULT NULL
57 ,p_raw_text_flag in VARCHAR2 DEFAULT 'Y'
58 ,x_perf_txn_id out NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
59 ,x_excp_meaning out NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE --File.Sql.39 bug 4440895
60 ) return SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
61
62
63 Procedure copy_object_rule_assoc
64 (
65 p_from_object_type in varchar2
66 ,p_from_object_id in number
67 ,p_to_object_type in varchar2
68 ,p_to_object_id in number
69 , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
70 , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
71 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
72 );
73
74
75 Procedure delete_object_exceptions
76 (
77 p_object_type in varchar2
78 ,p_object_id in number
79 , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
80 , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
81 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
82 ) ;
83
84
85 Procedure start_exception_engine
86 (
87 p_project_id in NUMBER DEFAULT NULL
88 ,p_generate_exceptions IN VARCHAR2 DEFAULT 'Y'
89 ,p_generate_scoring IN VARCHAR2 DEFAULT 'Y'
90 ,p_generate_notification IN VARCHAR2 DEFAULT 'N'
91 ,p_purge IN VARCHAR2 DEFAULT 'N'
92 ,p_daysold IN NUMBER DEFAULT NULL
93 ,x_request_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
94 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
95 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
96 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
97 );
98
99
100 end PA_PERF_EXCP_UTILS ;