[Home] [Help]
PACKAGE: APPS.OKL_REP_PVT
Source
1 PACKAGE OKL_REP_PVT AS
2 /* $Header: OKLSREPS.pls 120.0 2007/12/10 17:40:55 dcshanmu noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKL_REPORTS_V Record Spec
7 TYPE repv_rec_type IS RECORD (
8 report_id NUMBER
9 ,name OKL_REPORTS_V.NAME%TYPE
10 ,chart_of_accounts_id OKL_REPORTS_V.CHART_OF_ACCOUNTS_ID%TYPE
11 ,book_classification_code OKL_REPORTS_V.BOOK_CLASSIFICATION_CODE%TYPE
12 ,ledger_id OKL_REPORTS_V.LEDGER_ID%TYPE
13 ,report_category_code OKL_REPORTS_V.REPORT_CATEGORY_CODE%TYPE
14 ,report_type_code OKL_REPORTS_V.REPORT_TYPE_CODE%TYPE
15 ,activity_code OKL_REPORTS_V.ACTIVITY_CODE%TYPE
16 ,status_code OKL_REPORTS_V.STATUS_CODE%TYPE
17 ,description OKL_REPORTS_V.DESCRIPTION%TYPE
18 ,effective_from_date OKL_REPORTS_V.EFFECTIVE_FROM_DATE%TYPE
19 ,effective_to_date OKL_REPORTS_V.EFFECTIVE_TO_DATE%TYPE
20 ,created_by NUMBER
21 ,creation_date OKL_REPORTS_V.CREATION_DATE%TYPE
22 ,last_updated_by NUMBER
23 ,last_update_date OKL_REPORTS_V.LAST_UPDATE_DATE%TYPE
24 ,last_update_login NUMBER
25 ,language OKL_REPORTS_V.LANGUAGE%TYPE
26 ,source_lang OKL_REPORTS_V.SOURCE_LANG%TYPE
27 ,sfwt_flag OKL_REPORTS_V.SFWT_FLAG%TYPE);
28 G_MISS_repv_rec repv_rec_type;
29 TYPE repv_tbl_type IS TABLE OF repv_rec_type
30 INDEX BY BINARY_INTEGER;
31 -- OKL_REPORTS_B Record Spec
32 TYPE rep_rec_type IS RECORD (
33 report_id NUMBER
34 ,name OKL_REPORTS_B.NAME%TYPE
35 ,chart_of_accounts_id OKL_REPORTS_B.CHART_OF_ACCOUNTS_ID%TYPE
36 ,book_classification_code OKL_REPORTS_B.BOOK_CLASSIFICATION_CODE%TYPE
37 ,ledger_id NUMBER
38 ,report_category_code OKL_REPORTS_B.REPORT_CATEGORY_CODE%TYPE
39 ,report_type_code OKL_REPORTS_B.REPORT_TYPE_CODE%TYPE
40 ,effective_from_date OKL_REPORTS_B.EFFECTIVE_FROM_DATE%TYPE
41 ,activity_code OKL_REPORTS_B.ACTIVITY_CODE%TYPE
42 ,status_code OKL_REPORTS_B.STATUS_CODE%TYPE
43 ,effective_to_date OKL_REPORTS_B.EFFECTIVE_TO_DATE%TYPE
44 ,created_by NUMBER
45 ,creation_date OKL_REPORTS_B.CREATION_DATE%TYPE
46 ,last_updated_by NUMBER
47 ,last_update_date OKL_REPORTS_B.LAST_UPDATE_DATE%TYPE
48 ,last_update_login NUMBER);
49 G_MISS_rep_rec rep_rec_type;
50 TYPE rep_tbl_type IS TABLE OF rep_rec_type
51 INDEX BY BINARY_INTEGER;
52 -- OKL_REPORTS_TL Record Spec
53 TYPE okl_reports_tl_rec_type IS RECORD (
54 report_id NUMBER
55 ,language OKL_REPORTS_TL.LANGUAGE%TYPE
56 ,source_lang OKL_REPORTS_TL.SOURCE_LANG%TYPE
57 ,sfwt_flag OKL_REPORTS_TL.SFWT_FLAG%TYPE
58 ,name OKL_REPORTS_TL.NAME%TYPE
59 ,description OKL_REPORTS_TL.DESCRIPTION%TYPE
60 ,created_by NUMBER
61 ,creation_date OKL_REPORTS_TL.CREATION_DATE%TYPE
62 ,last_updated_by NUMBER
63 ,last_update_date OKL_REPORTS_TL.LAST_UPDATE_DATE%TYPE
64 ,last_update_login NUMBER);
65 G_MISS_okl_reports_tl_rec okl_reports_tl_rec_type;
66 TYPE okl_reports_tl_tbl_type IS TABLE OF okl_reports_tl_rec_type
67 INDEX BY BINARY_INTEGER;
68 ---------------------------------------------------------------------------
69 -- GLOBAL MESSAGE CONSTANTS
70 ---------------------------------------------------------------------------
71 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
72 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
73 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
74 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
75 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
76 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
77 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
78 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
79 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
80 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
81 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
82 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
83 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
84 G_COL_ERROR CONSTANT VARCHAR2(30) := 'OKL_COL_ERROR';
85 G_PKG_NAME_TOKEN CONSTANT VARCHAR2(30) := 'PKG_NAME';
86
87 ---------------------------------------------------------------------------
88 -- GLOBAL EXCEPTIONS
89 ---------------------------------------------------------------------------
90 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
91
92 ---------------------------------------------------------------------------
93 -- GLOBAL VARIABLES
94 ---------------------------------------------------------------------------
95 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_REP_PVT';
96 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
97 ---------------------------------------------------------------------------
98 -- Procedures and Functions
99 ---------------------------------------------------------------------------
100
101 PROCEDURE qc;
102 PROCEDURE change_version;
103 PROCEDURE api_copy;
104 PROCEDURE add_language;
105 PROCEDURE insert_row(
106 p_api_version IN NUMBER,
107 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
108 x_return_status OUT NOCOPY VARCHAR2,
109 x_msg_count OUT NOCOPY NUMBER,
110 x_msg_data OUT NOCOPY VARCHAR2,
111 p_repv_rec IN repv_rec_type,
112 x_repv_rec OUT NOCOPY repv_rec_type);
113 PROCEDURE insert_row(
114 p_api_version IN NUMBER,
115 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
116 x_return_status OUT NOCOPY VARCHAR2,
117 x_msg_count OUT NOCOPY NUMBER,
118 x_msg_data OUT NOCOPY VARCHAR2,
119 p_repv_tbl IN repv_tbl_type,
120 x_repv_tbl OUT NOCOPY repv_tbl_type,
121 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
122 PROCEDURE insert_row(
123 p_api_version IN NUMBER,
124 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
125 x_return_status OUT NOCOPY VARCHAR2,
126 x_msg_count OUT NOCOPY NUMBER,
127 x_msg_data OUT NOCOPY VARCHAR2,
128 p_repv_tbl IN repv_tbl_type,
129 x_repv_tbl OUT NOCOPY repv_tbl_type);
130 PROCEDURE lock_row(
131 p_api_version IN NUMBER,
132 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
133 x_return_status OUT NOCOPY VARCHAR2,
134 x_msg_count OUT NOCOPY NUMBER,
135 x_msg_data OUT NOCOPY VARCHAR2,
136 p_repv_rec IN repv_rec_type);
137 PROCEDURE lock_row(
138 p_api_version IN NUMBER,
139 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
140 x_return_status OUT NOCOPY VARCHAR2,
141 x_msg_count OUT NOCOPY NUMBER,
142 x_msg_data OUT NOCOPY VARCHAR2,
143 p_repv_tbl IN repv_tbl_type,
144 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
145 PROCEDURE lock_row(
146 p_api_version IN NUMBER,
147 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
148 x_return_status OUT NOCOPY VARCHAR2,
149 x_msg_count OUT NOCOPY NUMBER,
150 x_msg_data OUT NOCOPY VARCHAR2,
151 p_repv_tbl IN repv_tbl_type);
152 PROCEDURE update_row(
153 p_api_version IN NUMBER,
154 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
155 x_return_status OUT NOCOPY VARCHAR2,
156 x_msg_count OUT NOCOPY NUMBER,
157 x_msg_data OUT NOCOPY VARCHAR2,
158 p_repv_rec IN repv_rec_type,
159 x_repv_rec OUT NOCOPY repv_rec_type);
160 PROCEDURE update_row(
161 p_api_version IN NUMBER,
162 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
163 x_return_status OUT NOCOPY VARCHAR2,
164 x_msg_count OUT NOCOPY NUMBER,
165 x_msg_data OUT NOCOPY VARCHAR2,
166 p_repv_tbl IN repv_tbl_type,
167 x_repv_tbl OUT NOCOPY repv_tbl_type,
168 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
169 PROCEDURE update_row(
170 p_api_version IN NUMBER,
171 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
172 x_return_status OUT NOCOPY VARCHAR2,
173 x_msg_count OUT NOCOPY NUMBER,
174 x_msg_data OUT NOCOPY VARCHAR2,
175 p_repv_tbl IN repv_tbl_type,
176 x_repv_tbl OUT NOCOPY repv_tbl_type);
177 PROCEDURE delete_row(
178 p_api_version IN NUMBER,
179 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
180 x_return_status OUT NOCOPY VARCHAR2,
181 x_msg_count OUT NOCOPY NUMBER,
182 x_msg_data OUT NOCOPY VARCHAR2,
183 p_repv_rec IN repv_rec_type);
184 PROCEDURE delete_row(
185 p_api_version IN NUMBER,
186 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
187 x_return_status OUT NOCOPY VARCHAR2,
188 x_msg_count OUT NOCOPY NUMBER,
189 x_msg_data OUT NOCOPY VARCHAR2,
190 p_repv_tbl IN repv_tbl_type,
191 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
192 PROCEDURE delete_row(
193 p_api_version IN NUMBER,
194 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
195 x_return_status OUT NOCOPY VARCHAR2,
196 x_msg_count OUT NOCOPY NUMBER,
197 x_msg_data OUT NOCOPY VARCHAR2,
198 p_repv_tbl IN repv_tbl_type);
199 PROCEDURE validate_row(
200 p_api_version IN NUMBER,
201 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
202 x_return_status OUT NOCOPY VARCHAR2,
203 x_msg_count OUT NOCOPY NUMBER,
204 x_msg_data OUT NOCOPY VARCHAR2,
205 p_repv_rec IN repv_rec_type);
206 PROCEDURE validate_row(
207 p_api_version IN NUMBER,
208 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
209 x_return_status OUT NOCOPY VARCHAR2,
210 x_msg_count OUT NOCOPY NUMBER,
211 x_msg_data OUT NOCOPY VARCHAR2,
212 p_repv_tbl IN repv_tbl_type,
213 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
214 PROCEDURE validate_row(
215 p_api_version IN NUMBER,
216 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
217 x_return_status OUT NOCOPY VARCHAR2,
218 x_msg_count OUT NOCOPY NUMBER,
219 x_msg_data OUT NOCOPY VARCHAR2,
220 p_repv_tbl IN repv_tbl_type);
221 END OKL_REP_PVT;