[Home] [Help]
PACKAGE: APPS.OKC_QA_CHECK_LIST_PUB
Source
1 PACKAGE OKC_QA_CHECK_LIST_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKCPQCLS.pls 120.0 2005/05/26 09:28:35 appldev noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL DATASTRUCTURES, needed for Public API's only
6 ---------------------------------------------------------------------------
7
8 -- complex entity object subtype definitions
9 subtype qclv_rec_type is OKC_QA_CHECK_LIST_PVT.qclv_rec_type;
10 subtype qclv_tbl_type is OKC_QA_CHECK_LIST_PVT.qclv_tbl_type;
11 subtype qlpv_rec_type is OKC_QA_CHECK_LIST_PVT.qlpv_rec_type;
12 subtype qlpv_tbl_type is OKC_QA_CHECK_LIST_PVT.qlpv_tbl_type;
13 subtype qppv_rec_type is OKC_QA_CHECK_LIST_PVT.qppv_rec_type;
14 subtype qppv_tbl_type is OKC_QA_CHECK_LIST_PVT.qppv_tbl_type;
15
16 ---------------------------------------------------------------------------
17 -- GLOBAL MESSAGE CONSTANTS
18 ---------------------------------------------------------------------------
19 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
20 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
21 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
22 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
23 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
24 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
25 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
26 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
27 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
28 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
29 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
30 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
31 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
32 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPERCASE_REQUIRED';
33
34 ------------------------------------------------------------------------------------
35 -- GLOBAL EXCEPTION
39 -- GLOBAL VARIABLES
36 ---------------------------------------------------------------------------
37 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
38
40 ---------------------------------------------------------------------------
41 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_QA_CHECK_LIST_PUB';
42 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
43
44 g_qclv_rec qclv_rec_type;
45 g_qlpv_rec qlpv_rec_type;
46 g_qppv_rec qppv_rec_type;
47
48 -- public procedure declarations
49
50 PROCEDURE create_qa_check_list(
51 p_api_version IN NUMBER,
52 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
53 x_return_status OUT NOCOPY VARCHAR2,
54 x_msg_count OUT NOCOPY NUMBER,
55 x_msg_data OUT NOCOPY VARCHAR2,
56 p_qclv_rec IN qclv_rec_type,
57 x_qclv_rec OUT NOCOPY qclv_rec_type);
58
59 PROCEDURE create_qa_check_list(
60 p_api_version IN NUMBER,
61 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2,
65 p_qclv_tbl IN qclv_tbl_type,
66 x_qclv_tbl OUT NOCOPY qclv_tbl_type);
67
68 PROCEDURE update_qa_check_list(
69 p_api_version IN NUMBER,
70 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_msg_count OUT NOCOPY NUMBER,
73 x_msg_data OUT NOCOPY VARCHAR2,
74 p_qclv_rec IN qclv_rec_type,
75 x_qclv_rec OUT NOCOPY qclv_rec_type);
76
77 PROCEDURE update_qa_check_list(
78 p_api_version IN NUMBER,
79 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
80 x_return_status OUT NOCOPY VARCHAR2,
81 x_msg_count OUT NOCOPY NUMBER,
82 x_msg_data OUT NOCOPY VARCHAR2,
83 p_qclv_tbl IN qclv_tbl_type,
84 x_qclv_tbl OUT NOCOPY qclv_tbl_type);
85
86 PROCEDURE delete_qa_check_list(
87 p_api_version IN NUMBER,
88 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
89 x_return_status OUT NOCOPY VARCHAR2,
90 x_msg_count OUT NOCOPY NUMBER,
91 x_msg_data OUT NOCOPY VARCHAR2,
92 p_qclv_rec IN qclv_rec_type);
93
94 PROCEDURE delete_qa_check_list(
95 p_api_version IN NUMBER,
96 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
97 x_return_status OUT NOCOPY VARCHAR2,
98 x_msg_count OUT NOCOPY NUMBER,
99 x_msg_data OUT NOCOPY VARCHAR2,
100 p_qclv_tbl IN qclv_tbl_type);
101
102 PROCEDURE lock_qa_check_list(
103 p_api_version IN NUMBER,
104 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
105 x_return_status OUT NOCOPY VARCHAR2,
106 x_msg_count OUT NOCOPY NUMBER,
107 x_msg_data OUT NOCOPY VARCHAR2,
108 p_qclv_rec IN qclv_rec_type);
109
110 PROCEDURE lock_qa_check_list(
111 p_api_version IN NUMBER,
112 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
113 x_return_status OUT NOCOPY VARCHAR2,
114 x_msg_count OUT NOCOPY NUMBER,
115 x_msg_data OUT NOCOPY VARCHAR2,
116 p_qclv_tbl IN qclv_tbl_type);
117
118 PROCEDURE validate_qa_check_list(
119 p_api_version IN NUMBER,
120 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
121 x_return_status OUT NOCOPY VARCHAR2,
122 x_msg_count OUT NOCOPY NUMBER,
123 x_msg_data OUT NOCOPY VARCHAR2,
124 p_qclv_rec IN qclv_rec_type);
125
126 PROCEDURE validate_qa_check_list(
127 p_api_version IN NUMBER,
128 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
129 x_return_status OUT NOCOPY VARCHAR2,
130 x_msg_count OUT NOCOPY NUMBER,
131 x_msg_data OUT NOCOPY VARCHAR2,
132 p_qclv_tbl IN qclv_tbl_type);
133
134 PROCEDURE create_qa_process(
135 p_api_version IN NUMBER,
136 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
137 x_return_status OUT NOCOPY VARCHAR2,
138 x_msg_count OUT NOCOPY NUMBER,
139 x_msg_data OUT NOCOPY VARCHAR2,
140 p_qlpv_rec IN qlpv_rec_type,
141 x_qlpv_rec OUT NOCOPY qlpv_rec_type);
142
143 PROCEDURE create_qa_process(
144 p_api_version IN NUMBER,
145 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
146 x_return_status OUT NOCOPY VARCHAR2,
147 x_msg_count OUT NOCOPY NUMBER,
148 x_msg_data OUT NOCOPY VARCHAR2,
149 p_qlpv_tbl IN qlpv_tbl_type,
153 p_api_version IN NUMBER,
150 x_qlpv_tbl OUT NOCOPY qlpv_tbl_type);
151
152 PROCEDURE update_qa_process(
154 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_qlpv_rec IN qlpv_rec_type,
159 x_qlpv_rec OUT NOCOPY qlpv_rec_type);
160
161 PROCEDURE update_qa_process(
162 p_api_version IN NUMBER,
163 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
164 x_return_status OUT NOCOPY VARCHAR2,
165 x_msg_count OUT NOCOPY NUMBER,
166 x_msg_data OUT NOCOPY VARCHAR2,
167 p_qlpv_tbl IN qlpv_tbl_type,
168 x_qlpv_tbl OUT NOCOPY qlpv_tbl_type);
169
170 PROCEDURE delete_qa_process(
171 p_api_version IN NUMBER,
172 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
173 x_return_status OUT NOCOPY VARCHAR2,
174 x_msg_count OUT NOCOPY NUMBER,
175 x_msg_data OUT NOCOPY VARCHAR2,
176 p_qlpv_rec IN qlpv_rec_type);
177
178 PROCEDURE delete_qa_process(
179 p_api_version IN NUMBER,
180 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
181 x_return_status OUT NOCOPY VARCHAR2,
182 x_msg_count OUT NOCOPY NUMBER,
183 x_msg_data OUT NOCOPY VARCHAR2,
184 p_qlpv_tbl IN qlpv_tbl_type);
185
186 PROCEDURE lock_qa_process(
187 p_api_version IN NUMBER,
188 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
189 x_return_status OUT NOCOPY VARCHAR2,
190 x_msg_count OUT NOCOPY NUMBER,
191 x_msg_data OUT NOCOPY VARCHAR2,
192 p_qlpv_rec IN qlpv_rec_type);
193
194 PROCEDURE lock_qa_process(
195 p_api_version IN NUMBER,
196 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
197 x_return_status OUT NOCOPY VARCHAR2,
198 x_msg_count OUT NOCOPY NUMBER,
199 x_msg_data OUT NOCOPY VARCHAR2,
200 p_qlpv_tbl IN qlpv_tbl_type);
201
202 PROCEDURE validate_qa_process(
203 p_api_version IN NUMBER,
204 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
205 x_return_status OUT NOCOPY VARCHAR2,
206 x_msg_count OUT NOCOPY NUMBER,
207 x_msg_data OUT NOCOPY VARCHAR2,
208 p_qlpv_rec IN qlpv_rec_type);
209
210 PROCEDURE validate_qa_process(
211 p_api_version IN NUMBER,
212 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
213 x_return_status OUT NOCOPY VARCHAR2,
214 x_msg_count OUT NOCOPY NUMBER,
215 x_msg_data OUT NOCOPY VARCHAR2,
216 p_qlpv_tbl IN qlpv_tbl_type);
217
218 PROCEDURE create_qa_parm(
219 p_api_version IN NUMBER,
220 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
221 x_return_status OUT NOCOPY VARCHAR2,
222 x_msg_count OUT NOCOPY NUMBER,
223 x_msg_data OUT NOCOPY VARCHAR2,
224 p_qppv_rec IN qppv_rec_type,
225 x_qppv_rec OUT NOCOPY qppv_rec_type);
226
227 PROCEDURE create_qa_parm(
228 p_api_version IN NUMBER,
229 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
230 x_return_status OUT NOCOPY VARCHAR2,
231 x_msg_count OUT NOCOPY NUMBER,
232 x_msg_data OUT NOCOPY VARCHAR2,
233 p_qppv_tbl IN qppv_tbl_type,
234 x_qppv_tbl OUT NOCOPY qppv_tbl_type);
235
236 PROCEDURE update_qa_parm(
237 p_api_version IN NUMBER,
238 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
239 x_return_status OUT NOCOPY VARCHAR2,
240 x_msg_count OUT NOCOPY NUMBER,
241 x_msg_data OUT NOCOPY VARCHAR2,
242 p_qppv_rec IN qppv_rec_type,
243 x_qppv_rec OUT NOCOPY qppv_rec_type);
244
245 PROCEDURE update_qa_parm(
246 p_api_version IN NUMBER,
247 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
248 x_return_status OUT NOCOPY VARCHAR2,
249 x_msg_count OUT NOCOPY NUMBER,
250 x_msg_data OUT NOCOPY VARCHAR2,
251 p_qppv_tbl IN qppv_tbl_type,
252 x_qppv_tbl OUT NOCOPY qppv_tbl_type);
253
254 PROCEDURE delete_qa_parm(
255 p_api_version IN NUMBER,
256 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
257 x_return_status OUT NOCOPY VARCHAR2,
258 x_msg_count OUT NOCOPY NUMBER,
259 x_msg_data OUT NOCOPY VARCHAR2,
260 p_qppv_rec IN qppv_rec_type);
261
262 PROCEDURE delete_qa_parm(
263 p_api_version IN NUMBER,
264 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
265 x_return_status OUT NOCOPY VARCHAR2,
266 x_msg_count OUT NOCOPY NUMBER,
267 x_msg_data OUT NOCOPY VARCHAR2,
268 p_qppv_tbl IN qppv_tbl_type);
269
270 PROCEDURE lock_qa_parm(
271 p_api_version IN NUMBER,
272 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
273 x_return_status OUT NOCOPY VARCHAR2,
274 x_msg_count OUT NOCOPY NUMBER,
275 x_msg_data OUT NOCOPY VARCHAR2,
276 p_qppv_rec IN qppv_rec_type);
277
278 PROCEDURE lock_qa_parm(
279 p_api_version IN NUMBER,
280 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
281 x_return_status OUT NOCOPY VARCHAR2,
282 x_msg_count OUT NOCOPY NUMBER,
283 x_msg_data OUT NOCOPY VARCHAR2,
284 p_qppv_tbl IN qppv_tbl_type);
285
286 PROCEDURE validate_qa_parm(
287 p_api_version IN NUMBER,
288 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
289 x_return_status OUT NOCOPY VARCHAR2,
290 x_msg_count OUT NOCOPY NUMBER,
291 x_msg_data OUT NOCOPY VARCHAR2,
292 p_qppv_rec IN qppv_rec_type);
293
294 PROCEDURE validate_qa_parm(
295 p_api_version IN NUMBER,
296 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
297 x_return_status OUT NOCOPY VARCHAR2,
298 x_msg_count OUT NOCOPY NUMBER,
299 x_msg_data OUT NOCOPY VARCHAR2,
300 p_qppv_tbl IN qppv_tbl_type);
301
302 PROCEDURE add_language;
303
304 END OKC_QA_CHECK_LIST_PUB;