[Home] [Help]
PACKAGE: APPS.OKL_TMPT_SET_PVT
Source
1 PACKAGE okl_tmpt_set_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLCAESS.pls 115.2 2002/02/05 11:48:34 pkm ship $ */
3
4 SUBTYPE aesv_rec_type IS okl_aes_pvt.aesv_rec_type;
5 SUBTYPE aesv_tbl_type IS okl_aes_pvt.aesv_tbl_type;
6
7 SUBTYPE avlv_rec_type IS okl_avl_pvt.avlv_rec_type;
8 SUBTYPE avlv_tbl_type IS okl_avl_pvt.avlv_tbl_type;
9
10 SUBTYPE atlv_rec_type IS okl_atl_pvt.atlv_rec_type;
11 SUBTYPE atlv_tbl_type IS okl_atl_pvt.atlv_tbl_type;
12
13 ------------------------------------------------------------------------------
14 -- Global Variables
15 G_PKG_NAME CONSTANT VARCHAR2(200) := 'okl_template';
16 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
17 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
18 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
19 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
20 ------------------------------------------------------------------------------
21 --Global Exception
22 ------------------------------------------------------------------------------
23 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
24 ------------------------------------------------------------------------------
25
26 --Object type procedure for insert
27 PROCEDURE create_tmpt_set(
28 p_api_version IN NUMBER
29 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
30 ,x_return_status OUT NOCOPY VARCHAR2
31 ,x_msg_count OUT NOCOPY NUMBER
32 ,x_msg_data OUT NOCOPY VARCHAR2
33 ,p_aesv_rec IN aesv_rec_type
34 ,p_avlv_tbl IN avlv_tbl_type
35 ,p_atlv_tbl IN atlv_tbl_type
36 ,x_aesv_rec OUT NOCOPY aesv_rec_type
37 ,x_avlv_tbl OUT NOCOPY avlv_tbl_type
38 ,x_atlv_tbl OUT NOCOPY atlv_tbl_type
39 );
40
41 --Object type procedure for update
42 PROCEDURE update_tmpt_set(
43 p_api_version IN NUMBER
44 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
45 ,x_return_status OUT NOCOPY VARCHAR2
46 ,x_msg_count OUT NOCOPY NUMBER
47 ,x_msg_data OUT NOCOPY VARCHAR2
48 ,p_aesv_rec IN aesv_rec_type
49 ,p_avlv_tbl IN avlv_tbl_type
50 ,p_atlv_tbl IN atlv_tbl_type
51 ,x_aesv_rec OUT NOCOPY aesv_rec_type
52 ,x_avlv_tbl OUT NOCOPY avlv_tbl_type
53 ,x_atlv_tbl OUT NOCOPY atlv_tbl_type
54 );
55
56 --Object type procedure for validate
57 PROCEDURE validate_tmpt_set(
58 p_api_version IN NUMBER
59 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
60 ,x_return_status OUT NOCOPY VARCHAR2
61 ,x_msg_count OUT NOCOPY NUMBER
62 ,x_msg_data OUT NOCOPY VARCHAR2
63 ,p_aesv_rec IN aesv_rec_type
64 ,p_avlv_tbl IN avlv_tbl_type
65 ,p_atlv_tbl IN atlv_tbl_type
66 );
67
68
69 PROCEDURE create_tmpt_set(
70 p_api_version IN NUMBER,
71 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
72 x_return_status OUT NOCOPY VARCHAR2,
73 x_msg_count OUT NOCOPY NUMBER,
74 x_msg_data OUT NOCOPY VARCHAR2,
75 p_aesv_tbl IN aesv_tbl_type,
76 x_aesv_tbl OUT NOCOPY aesv_tbl_type);
77
78 PROCEDURE create_tmpt_set(
79 p_api_version IN NUMBER,
80 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_msg_count OUT NOCOPY NUMBER,
83 x_msg_data OUT NOCOPY VARCHAR2,
84 p_aesv_rec IN aesv_rec_type,
85 x_aesv_rec OUT NOCOPY aesv_rec_type);
86
87 PROCEDURE lock_tmpt_set(
88 p_api_version IN NUMBER,
89 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
90 x_return_status OUT NOCOPY VARCHAR2,
91 x_msg_count OUT NOCOPY NUMBER,
92 x_msg_data OUT NOCOPY VARCHAR2,
93 p_aesv_tbl IN aesv_tbl_type);
94
95 PROCEDURE lock_tmpt_set(
96 p_api_version IN NUMBER,
97 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2,
101 p_aesv_rec IN aesv_rec_type);
102
103 PROCEDURE update_tmpt_set(
104 p_api_version IN NUMBER,
105 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
106 x_return_status OUT NOCOPY VARCHAR2,
107 x_msg_count OUT NOCOPY NUMBER,
108 x_msg_data OUT NOCOPY VARCHAR2,
109 p_aesv_tbl IN aesv_tbl_type,
110 x_aesv_tbl OUT NOCOPY aesv_tbl_type);
111
112 PROCEDURE update_tmpt_set(
113 p_api_version IN NUMBER,
114 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
115 x_return_status OUT NOCOPY VARCHAR2,
116 x_msg_count OUT NOCOPY NUMBER,
117 x_msg_data OUT NOCOPY VARCHAR2,
118 p_aesv_rec IN aesv_rec_type,
119 x_aesv_rec OUT NOCOPY aesv_rec_type);
120
121 PROCEDURE delete_tmpt_set(
122 p_api_version IN NUMBER,
123 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
124 x_return_status OUT NOCOPY VARCHAR2,
125 x_msg_count OUT NOCOPY NUMBER,
126 x_msg_data OUT NOCOPY VARCHAR2,
127 p_aesv_tbl IN aesv_tbl_type);
128
129 PROCEDURE delete_tmpt_set(
130 p_api_version IN NUMBER,
131 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
132 x_return_status OUT NOCOPY VARCHAR2,
133 x_msg_count OUT NOCOPY NUMBER,
134 x_msg_data OUT NOCOPY VARCHAR2,
135 p_aesv_rec IN aesv_rec_type);
136
137 PROCEDURE validate_tmpt_set(
138 p_api_version IN NUMBER,
139 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_aesv_tbl IN aesv_tbl_type);
144
145 PROCEDURE validate_tmpt_set(
146 p_api_version IN NUMBER,
147 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_aesv_rec IN aesv_rec_type);
152
153
154 PROCEDURE create_template(
155 p_api_version IN NUMBER,
156 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
157 x_return_status OUT NOCOPY VARCHAR2,
158 x_msg_count OUT NOCOPY NUMBER,
159 x_msg_data OUT NOCOPY VARCHAR2,
160 p_avlv_tbl IN avlv_tbl_type,
161 x_avlv_tbl OUT NOCOPY avlv_tbl_type);
162
163 PROCEDURE create_template(
164 p_api_version IN NUMBER,
165 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
166 x_return_status OUT NOCOPY VARCHAR2,
167 x_msg_count OUT NOCOPY NUMBER,
168 x_msg_data OUT NOCOPY VARCHAR2,
169 p_avlv_rec IN avlv_rec_type,
170 x_avlv_rec OUT NOCOPY avlv_rec_type);
171
172 PROCEDURE lock_template(
173 p_api_version IN NUMBER,
174 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
175 x_return_status OUT NOCOPY VARCHAR2,
176 x_msg_count OUT NOCOPY NUMBER,
177 x_msg_data OUT NOCOPY VARCHAR2,
178 p_avlv_tbl IN avlv_tbl_type);
179
180 PROCEDURE lock_template(
181 p_api_version IN NUMBER,
182 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
183 x_return_status OUT NOCOPY VARCHAR2,
184 x_msg_count OUT NOCOPY NUMBER,
185 x_msg_data OUT NOCOPY VARCHAR2,
186 p_avlv_rec IN avlv_rec_type);
187
188 PROCEDURE update_template(
189 p_api_version IN NUMBER,
190 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
191 x_return_status OUT NOCOPY VARCHAR2,
192 x_msg_count OUT NOCOPY NUMBER,
193 x_msg_data OUT NOCOPY VARCHAR2,
194 p_avlv_tbl IN avlv_tbl_type,
195 x_avlv_tbl OUT NOCOPY avlv_tbl_type);
196
197 PROCEDURE update_template(
198 p_api_version IN NUMBER,
199 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
200 x_return_status OUT NOCOPY VARCHAR2,
201 x_msg_count OUT NOCOPY NUMBER,
202 x_msg_data OUT NOCOPY VARCHAR2,
203 p_avlv_rec IN avlv_rec_type,
204 x_avlv_rec OUT NOCOPY avlv_rec_type);
205
206 PROCEDURE delete_template(
207 p_api_version IN NUMBER,
208 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_avlv_tbl IN avlv_tbl_type);
213
214 PROCEDURE delete_template(
215 p_api_version IN NUMBER,
216 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_avlv_rec IN avlv_rec_type);
221
222 PROCEDURE validate_template(
223 p_api_version IN NUMBER,
224 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
225 x_return_status OUT NOCOPY VARCHAR2,
226 x_msg_count OUT NOCOPY NUMBER,
227 x_msg_data OUT NOCOPY VARCHAR2,
228 p_avlv_tbl IN avlv_tbl_type);
229
230 PROCEDURE validate_template(
231 p_api_version IN NUMBER,
232 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
233 x_return_status OUT NOCOPY VARCHAR2,
234 x_msg_count OUT NOCOPY NUMBER,
235 x_msg_data OUT NOCOPY VARCHAR2,
236 p_avlv_rec IN avlv_rec_type);
237
238
239 PROCEDURE create_tmpt_lines(
240 p_api_version IN NUMBER,
241 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
242 x_return_status OUT NOCOPY VARCHAR2,
243 x_msg_count OUT NOCOPY NUMBER,
244 x_msg_data OUT NOCOPY VARCHAR2,
245 p_atlv_tbl IN atlv_tbl_type,
246 x_atlv_tbl OUT NOCOPY atlv_tbl_type);
247
248 PROCEDURE create_tmpt_lines(
249 p_api_version IN NUMBER,
250 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
251 x_return_status OUT NOCOPY VARCHAR2,
252 x_msg_count OUT NOCOPY NUMBER,
253 x_msg_data OUT NOCOPY VARCHAR2,
254 p_atlv_rec IN atlv_rec_type,
255 x_atlv_rec OUT NOCOPY atlv_rec_type);
256
257 PROCEDURE lock_tmpt_lines(
258 p_api_version IN NUMBER,
259 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
260 x_return_status OUT NOCOPY VARCHAR2,
261 x_msg_count OUT NOCOPY NUMBER,
262 x_msg_data OUT NOCOPY VARCHAR2,
263 p_atlv_tbl IN atlv_tbl_type);
264
265 PROCEDURE lock_tmpt_lines(
266 p_api_version IN NUMBER,
267 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
268 x_return_status OUT NOCOPY VARCHAR2,
269 x_msg_count OUT NOCOPY NUMBER,
270 x_msg_data OUT NOCOPY VARCHAR2,
271 p_atlv_rec IN atlv_rec_type);
272
273 PROCEDURE update_tmpt_lines(
274 p_api_version IN NUMBER,
275 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
276 x_return_status OUT NOCOPY VARCHAR2,
277 x_msg_count OUT NOCOPY NUMBER,
278 x_msg_data OUT NOCOPY VARCHAR2,
279 p_atlv_tbl IN atlv_tbl_type,
280 x_atlv_tbl OUT NOCOPY atlv_tbl_type);
281
282 PROCEDURE update_tmpt_lines(
283 p_api_version IN NUMBER,
284 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
285 x_return_status OUT NOCOPY VARCHAR2,
286 x_msg_count OUT NOCOPY NUMBER,
287 x_msg_data OUT NOCOPY VARCHAR2,
288 p_atlv_rec IN atlv_rec_type,
289 x_atlv_rec OUT NOCOPY atlv_rec_type);
290
291 PROCEDURE delete_tmpt_lines(
292 p_api_version IN NUMBER,
293 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
294 x_return_status OUT NOCOPY VARCHAR2,
295 x_msg_count OUT NOCOPY NUMBER,
296 x_msg_data OUT NOCOPY VARCHAR2,
297 p_atlv_tbl IN atlv_tbl_type);
298
299 PROCEDURE delete_tmpt_lines(
300 p_api_version IN NUMBER,
301 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
302 x_return_status OUT NOCOPY VARCHAR2,
303 x_msg_count OUT NOCOPY NUMBER,
304 x_msg_data OUT NOCOPY VARCHAR2,
305 p_atlv_rec IN atlv_rec_type);
306
307 PROCEDURE validate_tmpt_lines(
308 p_api_version IN NUMBER,
309 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
310 x_return_status OUT NOCOPY VARCHAR2,
311 x_msg_count OUT NOCOPY NUMBER,
312 x_msg_data OUT NOCOPY VARCHAR2,
313 p_atlv_tbl IN atlv_tbl_type);
314
315 PROCEDURE validate_tmpt_lines(
316 p_api_version IN NUMBER,
317 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
318 x_return_status OUT NOCOPY VARCHAR2,
319 x_msg_count OUT NOCOPY NUMBER,
320 x_msg_data OUT NOCOPY VARCHAR2,
321 p_atlv_rec IN atlv_rec_type);
322
323 END okl_tmpt_set_pvt;