[Home] [Help]
PACKAGE BODY: APPS.OKC_QA_CHECK_LIST_PVT
Source
1 PACKAGE BODY OKC_QA_CHECK_LIST_PVT AS
2 /* $Header: OKCCQCLB.pls 120.0 2005/05/25 22:31:22 appldev noship $ */
3
4 l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5
6 PROCEDURE create_qa_check_list(
7 p_api_version IN NUMBER,
8 p_init_msg_list IN VARCHAR2 ,
9 x_return_status OUT NOCOPY VARCHAR2,
10 x_msg_count OUT NOCOPY NUMBER,
11 x_msg_data OUT NOCOPY VARCHAR2,
12 p_qclv_rec IN qclv_rec_type,
13 x_qclv_rec OUT NOCOPY qclv_rec_type)
14 IS
15 BEGIN
16 OKC_QCL_PVT.insert_row(
17 p_api_version => p_api_version,
18 p_init_msg_list => p_init_msg_list,
19 x_return_status => x_return_status,
20 x_msg_count => x_msg_count,
21 x_msg_data => x_msg_data,
22 p_qclv_rec => p_qclv_rec,
23 x_qclv_rec => x_qclv_rec);
24 END create_qa_check_list;
25
26 PROCEDURE update_qa_check_list(
27 p_api_version IN NUMBER,
28 p_init_msg_list IN VARCHAR2 ,
29 x_return_status OUT NOCOPY VARCHAR2,
30 x_msg_count OUT NOCOPY NUMBER,
31 x_msg_data OUT NOCOPY VARCHAR2,
32 p_qclv_rec IN qclv_rec_type,
33 x_qclv_rec OUT NOCOPY qclv_rec_type) IS
34 BEGIN
35 OKC_QCL_PVT.update_row(
36 p_api_version => p_api_version,
37 p_init_msg_list => p_init_msg_list,
38 x_return_status => x_return_status,
39 x_msg_count => x_msg_count,
40 x_msg_data => x_msg_data,
41 p_qclv_rec => p_qclv_rec,
42 x_qclv_rec => x_qclv_rec);
43 END update_qa_check_list;
44
45 PROCEDURE delete_qa_check_list(
46 p_api_version IN NUMBER,
47 p_init_msg_list IN VARCHAR2 ,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2,
51 p_qclv_rec IN qclv_rec_type) IS
52 BEGIN
53 OKC_QCL_PVT.delete_row(
54 p_api_version => p_api_version,
55 p_init_msg_list => p_init_msg_list,
56 x_return_status => x_return_status,
57 x_msg_count => x_msg_count,
58 x_msg_data => x_msg_data,
59 p_qclv_rec => p_qclv_rec);
60 END delete_qa_check_list;
61
62 PROCEDURE lock_qa_check_list(
63 p_api_version IN NUMBER,
64 p_init_msg_list IN VARCHAR2 ,
65 x_return_status OUT NOCOPY VARCHAR2,
66 x_msg_count OUT NOCOPY NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2,
68 p_qclv_rec IN qclv_rec_type) IS
69 BEGIN
70 OKC_QCL_PVT.lock_row(
71 p_api_version => p_api_version,
72 p_init_msg_list => p_init_msg_list,
73 x_return_status => x_return_status,
74 x_msg_count => x_msg_count,
75 x_msg_data => x_msg_data,
76 p_qclv_rec => p_qclv_rec);
77 END lock_qa_check_list;
78
79 PROCEDURE validate_qa_check_list(
80 p_api_version IN NUMBER,
81 p_init_msg_list IN VARCHAR2 ,
82 x_return_status OUT NOCOPY VARCHAR2,
83 x_msg_count OUT NOCOPY NUMBER,
84 x_msg_data OUT NOCOPY VARCHAR2,
85 p_qclv_rec IN qclv_rec_type) IS
86 BEGIN
87 OKC_QCL_PVT.validate_row(
88 p_api_version => p_api_version,
89 p_init_msg_list => p_init_msg_list,
90 x_return_status => x_return_status,
91 x_msg_count => x_msg_count,
92 x_msg_data => x_msg_data,
93 p_qclv_rec => p_qclv_rec);
94 END validate_qa_check_list;
95
96 PROCEDURE create_qa_process(
97 p_api_version IN NUMBER,
98 p_init_msg_list IN VARCHAR2 ,
99 x_return_status OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER,
101 x_msg_data OUT NOCOPY VARCHAR2,
102 p_qlpv_rec IN qlpv_rec_type,
103 x_qlpv_rec OUT NOCOPY qlpv_rec_type)
104 IS
105 BEGIN
106 OKC_QLP_PVT.insert_row(
107 p_api_version => p_api_version,
108 p_init_msg_list => p_init_msg_list,
109 x_return_status => x_return_status,
110 x_msg_count => x_msg_count,
111 x_msg_data => x_msg_data,
112 p_qlpv_rec => p_qlpv_rec,
113 x_qlpv_rec => x_qlpv_rec);
114 END create_qa_process;
115
116 PROCEDURE update_qa_process(
117 p_api_version IN NUMBER,
118 p_init_msg_list IN VARCHAR2 ,
119 x_return_status OUT NOCOPY VARCHAR2,
120 x_msg_count OUT NOCOPY NUMBER,
121 x_msg_data OUT NOCOPY VARCHAR2,
122 p_qlpv_rec IN qlpv_rec_type,
123 x_qlpv_rec OUT NOCOPY qlpv_rec_type) IS
124 BEGIN
125 OKC_QLP_PVT.update_row(
126 p_api_version => p_api_version,
127 p_init_msg_list => p_init_msg_list,
128 x_return_status => x_return_status,
129 x_msg_count => x_msg_count,
130 x_msg_data => x_msg_data,
131 p_qlpv_rec => p_qlpv_rec,
132 x_qlpv_rec => x_qlpv_rec);
133 END update_qa_process;
134
135 PROCEDURE delete_qa_process(
136 p_api_version IN NUMBER,
137 p_init_msg_list IN VARCHAR2 ,
138 x_return_status OUT NOCOPY VARCHAR2,
139 x_msg_count OUT NOCOPY NUMBER,
140 x_msg_data OUT NOCOPY VARCHAR2,
141 p_qlpv_rec IN qlpv_rec_type) IS
142 BEGIN
143 OKC_QLP_PVT.delete_row(
144 p_api_version => p_api_version,
145 p_init_msg_list => p_init_msg_list,
146 x_return_status => x_return_status,
147 x_msg_count => x_msg_count,
148 x_msg_data => x_msg_data,
149 p_qlpv_rec => p_qlpv_rec);
150 END delete_qa_process;
151
152 PROCEDURE lock_qa_process(
153 p_api_version IN NUMBER,
154 p_init_msg_list IN VARCHAR2 ,
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) IS
159 BEGIN
160 OKC_QLP_PVT.lock_row(
161 p_api_version => p_api_version,
162 p_init_msg_list => p_init_msg_list,
163 x_return_status => x_return_status,
164 x_msg_count => x_msg_count,
165 x_msg_data => x_msg_data,
166 p_qlpv_rec => p_qlpv_rec);
167 END lock_qa_process;
168
169 PROCEDURE validate_qa_process(
170 p_api_version IN NUMBER,
171 p_init_msg_list IN VARCHAR2 ,
172 x_return_status OUT NOCOPY VARCHAR2,
173 x_msg_count OUT NOCOPY NUMBER,
174 x_msg_data OUT NOCOPY VARCHAR2,
175 p_qlpv_rec IN qlpv_rec_type) IS
176 BEGIN
177 OKC_QLP_PVT.validate_row(
178 p_api_version => p_api_version,
179 p_init_msg_list => p_init_msg_list,
180 x_return_status => x_return_status,
181 x_msg_count => x_msg_count,
182 x_msg_data => x_msg_data,
183 p_qlpv_rec => p_qlpv_rec);
184 END validate_qa_process;
185
186 PROCEDURE create_qa_parm(
187 p_api_version IN NUMBER,
188 p_init_msg_list IN VARCHAR2 ,
189 x_return_status OUT NOCOPY VARCHAR2,
190 x_msg_count OUT NOCOPY NUMBER,
191 x_msg_data OUT NOCOPY VARCHAR2,
192 p_qppv_rec IN qppv_rec_type,
193 x_qppv_rec OUT NOCOPY qppv_rec_type)
194 IS
195 BEGIN
196 OKC_QPP_PVT.insert_row(
197 p_api_version => p_api_version,
198 p_init_msg_list => p_init_msg_list,
199 x_return_status => x_return_status,
200 x_msg_count => x_msg_count,
201 x_msg_data => x_msg_data,
202 p_qppv_rec => p_qppv_rec,
203 x_qppv_rec => x_qppv_rec);
204 END create_qa_parm;
205
206 PROCEDURE update_qa_parm(
207 p_api_version IN NUMBER,
208 p_init_msg_list IN VARCHAR2 ,
209 x_return_status OUT NOCOPY VARCHAR2,
210 x_msg_count OUT NOCOPY NUMBER,
211 x_msg_data OUT NOCOPY VARCHAR2,
212 p_qppv_rec IN qppv_rec_type,
213 x_qppv_rec OUT NOCOPY qppv_rec_type) IS
214 BEGIN
215 OKC_QPP_PVT.update_row(
216 p_api_version => p_api_version,
217 p_init_msg_list => p_init_msg_list,
218 x_return_status => x_return_status,
219 x_msg_count => x_msg_count,
220 x_msg_data => x_msg_data,
221 p_qppv_rec => p_qppv_rec,
222 x_qppv_rec => x_qppv_rec);
223 END update_qa_parm;
224
225 PROCEDURE delete_qa_parm(
226 p_api_version IN NUMBER,
227 p_init_msg_list IN VARCHAR2 ,
228 x_return_status OUT NOCOPY VARCHAR2,
229 x_msg_count OUT NOCOPY NUMBER,
230 x_msg_data OUT NOCOPY VARCHAR2,
231 p_qppv_rec IN qppv_rec_type) IS
232 BEGIN
233 OKC_QPP_PVT.delete_row(
234 p_api_version => p_api_version,
235 p_init_msg_list => p_init_msg_list,
236 x_return_status => x_return_status,
237 x_msg_count => x_msg_count,
238 x_msg_data => x_msg_data,
239 p_qppv_rec => p_qppv_rec);
240 END delete_qa_parm;
241
242 PROCEDURE lock_qa_parm(
243 p_api_version IN NUMBER,
244 p_init_msg_list IN VARCHAR2 ,
245 x_return_status OUT NOCOPY VARCHAR2,
246 x_msg_count OUT NOCOPY NUMBER,
247 x_msg_data OUT NOCOPY VARCHAR2,
248 p_qppv_rec IN qppv_rec_type) IS
249 BEGIN
250 OKC_QPP_PVT.lock_row(
251 p_api_version => p_api_version,
252 p_init_msg_list => p_init_msg_list,
253 x_return_status => x_return_status,
254 x_msg_count => x_msg_count,
255 x_msg_data => x_msg_data,
256 p_qppv_rec => p_qppv_rec);
257 END lock_qa_parm;
258
259 PROCEDURE validate_qa_parm(
260 p_api_version IN NUMBER,
261 p_init_msg_list IN VARCHAR2 ,
262 x_return_status OUT NOCOPY VARCHAR2,
263 x_msg_count OUT NOCOPY NUMBER,
264 x_msg_data OUT NOCOPY VARCHAR2,
265 p_qppv_rec IN qppv_rec_type) IS
266 BEGIN
267 OKC_QPP_PVT.validate_row(
268 p_api_version => p_api_version,
269 p_init_msg_list => p_init_msg_list,
270 x_return_status => x_return_status,
271 x_msg_count => x_msg_count,
272 x_msg_data => x_msg_data,
273 p_qppv_rec => p_qppv_rec);
274 END validate_qa_parm;
275
276 PROCEDURE add_language IS
277 BEGIN
278 OKC_QCL_PVT.add_language;
279 END add_language;
280
281 END OKC_QA_CHECK_LIST_PVT;