eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
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;