[Home] [Help]
PACKAGE: APPS.OKL_CONTRACT_PUB
Source
1 PACKAGE OKL_CONTRACT_PUB AS
2 /* $Header: OKLPKHRS.pls 120.1 2005/06/29 16:54:47 apaul noship $ */
3
4 subtype khrv_rec_type is OKL_CONTRACT_PVT.khrv_rec_type;
5 subtype khrv_tbl_type is OKL_CONTRACT_PVT.khrv_tbl_type;
6 subtype klev_rec_type is okl_CONTRACT_PVT.klev_rec_type;
7 subtype klev_tbl_type is okl_CONTRACT_PVT.klev_tbl_type;
8 subtype hdr_tbl_type is okl_CONTRACT_PVT.hdr_tbl_type;
9
10 -- GLOBAL VARIABLES
11 -- Global variables for user hooks
12 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CONTRACT_PUB';
13 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
14 g_khrv_rec khrv_rec_type;
15 g_khrv_tbl khrv_tbl_type;
16 g_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
17 g_chrv_tbl okl_okc_migration_pvt.chrv_tbl_type;
18
19 g_klev_rec klev_rec_type;
20 g_klev_tbl klev_tbl_type;
21 g_clev_rec okl_okc_migration_pvt.clev_rec_type;
22 g_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
23
24 g_gvev_rec okl_okc_migration_pvt.gvev_rec_type;
25 g_gvev_tbl okl_okc_migration_pvt.gvev_tbl_type;
26
27 PROCEDURE create_contract_header(
28 p_api_version IN NUMBER,
29 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
34 p_khrv_rec IN khrv_rec_type,
35 x_chrv_rec OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,
36 x_khrv_rec OUT NOCOPY khrv_rec_type);
37
38 PROCEDURE create_contract_header(
39 p_api_version IN NUMBER,
40 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
41 x_return_status OUT NOCOPY VARCHAR2,
42 x_msg_count OUT NOCOPY NUMBER,
43 x_msg_data OUT NOCOPY VARCHAR2,
44 p_chrv_tbl IN okl_okc_migration_pvt.chrv_tbl_type,
45 p_khrv_tbl IN khrv_tbl_type,
46 x_chrv_tbl OUT NOCOPY okl_okc_migration_pvt.chrv_tbl_type,
47 x_khrv_tbl OUT NOCOPY khrv_tbl_type);
48
49 PROCEDURE update_contract_header(
50 p_api_version IN NUMBER,
51 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2,
55 p_restricted_update IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
56 p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
57 p_khrv_rec IN khrv_rec_type,
58 x_chrv_rec OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,
59 x_khrv_rec OUT NOCOPY khrv_rec_type);
60
61 PROCEDURE update_contract_header(
62 p_api_version IN NUMBER,
63 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_msg_data OUT NOCOPY VARCHAR2,
67 p_restricted_update IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
68 p_chrv_tbl IN okl_okc_migration_pvt.chrv_tbl_type,
69 p_khrv_tbl IN khrv_tbl_type,
70 x_chrv_tbl OUT NOCOPY okl_okc_migration_pvt.chrv_tbl_type,
71 x_khrv_tbl OUT NOCOPY khrv_tbl_type);
72
73 PROCEDURE update_contract_header(
74 p_api_version IN NUMBER,
75 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
76 x_return_status OUT NOCOPY VARCHAR2,
77 x_msg_count OUT NOCOPY NUMBER,
78 x_msg_data OUT NOCOPY VARCHAR2,
79 p_restricted_update IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
80 p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
81 p_khrv_rec IN khrv_rec_type,
82 p_edit_mode IN VARCHAR2,
83 x_chrv_rec OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,
84 x_khrv_rec OUT NOCOPY khrv_rec_type);
85
86
87 PROCEDURE delete_contract(
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_contract_id IN okc_k_headers_b.id%TYPE);
94
95 PROCEDURE delete_contract_header(
96 p_api_version IN NUMBER,
97 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
102 p_khrv_rec IN khrv_rec_type);
103
104 PROCEDURE delete_contract_header(
105 p_api_version IN NUMBER,
106 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
107 x_return_status OUT NOCOPY VARCHAR2,
108 x_msg_count OUT NOCOPY NUMBER,
109 x_msg_data OUT NOCOPY VARCHAR2,
110 p_chrv_tbl IN okl_okc_migration_pvt.chrv_tbl_type,
111 p_khrv_tbl IN khrv_tbl_type);
112
113 PROCEDURE lock_contract_header(
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_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
120 p_khrv_rec IN khrv_rec_type);
121
122 PROCEDURE lock_contract_header(
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_chrv_tbl IN okl_okc_migration_pvt.chrv_tbl_type,
129 p_khrv_tbl IN khrv_tbl_type);
130
131 PROCEDURE validate_contract_header(
132 p_api_version IN NUMBER,
133 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
134 x_return_status OUT NOCOPY VARCHAR2,
135 x_msg_count OUT NOCOPY NUMBER,
136 x_msg_data OUT NOCOPY VARCHAR2,
137 p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
138 p_khrv_rec IN khrv_rec_type);
139
140 PROCEDURE validate_contract_header(
141 p_api_version IN NUMBER,
142 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
143 x_return_status OUT NOCOPY VARCHAR2,
144 x_msg_count OUT NOCOPY NUMBER,
145 x_msg_data OUT NOCOPY VARCHAR2,
146 p_chrv_tbl IN okl_okc_migration_pvt.chrv_tbl_type,
147 p_khrv_tbl IN khrv_tbl_type);
148
149 PROCEDURE create_contract_line(
150 p_api_version IN NUMBER,
151 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
152 x_return_status OUT NOCOPY VARCHAR2,
153 x_msg_count OUT NOCOPY NUMBER,
154 x_msg_data OUT NOCOPY VARCHAR2,
155 p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
156 p_klev_rec IN klev_rec_type,
157 x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,
158 x_klev_rec OUT NOCOPY klev_rec_type);
159
160 PROCEDURE create_contract_line(
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_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
167 p_klev_tbl IN klev_tbl_type,
168 x_clev_tbl OUT NOCOPY okl_okc_migration_pvt.clev_tbl_type,
169 x_klev_tbl OUT NOCOPY klev_tbl_type);
170
171 PROCEDURE update_contract_line(
172 p_api_version IN NUMBER,
173 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
174 x_return_status OUT NOCOPY VARCHAR2,
175 x_msg_count OUT NOCOPY NUMBER,
176 x_msg_data OUT NOCOPY VARCHAR2,
177 p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
178 p_klev_rec IN klev_rec_type,
179 x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,
180 x_klev_rec OUT NOCOPY klev_rec_type);
181
182 -----------------------
183 --Bug# 2525554 start
184 -----------------------
185 PROCEDURE update_contract_line(
186 p_api_version IN NUMBER,
187 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
188 x_return_status OUT NOCOPY VARCHAR2,
189 x_msg_count OUT NOCOPY NUMBER,
190 x_msg_data OUT NOCOPY VARCHAR2,
191 p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
192 p_klev_tbl IN klev_tbl_type,
193 x_clev_tbl OUT NOCOPY okl_okc_migration_pvt.clev_tbl_type,
194 x_klev_tbl OUT NOCOPY klev_tbl_type);
195
196 PROCEDURE update_contract_line(
197 p_api_version IN NUMBER,
198 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
199 x_return_status OUT NOCOPY VARCHAR2,
200 x_msg_count OUT NOCOPY NUMBER,
201 x_msg_data OUT NOCOPY VARCHAR2,
202 p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
203 p_klev_rec IN klev_rec_type,
204 p_edit_mode IN VARCHAR2,
205 x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,
206 x_klev_rec OUT NOCOPY klev_rec_type);
207
208 PROCEDURE update_contract_line(
209 p_api_version IN NUMBER,
210 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
211 x_return_status OUT NOCOPY VARCHAR2,
212 x_msg_count OUT NOCOPY NUMBER,
213 x_msg_data OUT NOCOPY VARCHAR2,
214 p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
215 p_klev_tbl IN klev_tbl_type,
216 p_edit_mode IN VARCHAR2,
217 x_clev_tbl OUT NOCOPY okl_okc_migration_pvt.clev_tbl_type,
218 x_klev_tbl OUT NOCOPY klev_tbl_type);
219
220 -----------------------
221 --Bug# 2525554 end
222 -----------------------
223
224 PROCEDURE delete_contract_line(
225 p_api_version IN NUMBER,
226 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
227 x_return_status OUT NOCOPY VARCHAR2,
228 x_msg_count OUT NOCOPY NUMBER,
229 x_msg_data OUT NOCOPY VARCHAR2,
230 p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
231 p_klev_rec IN klev_rec_type);
232
233 PROCEDURE delete_contract_line(
234 p_api_version IN NUMBER,
235 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
236 x_return_status OUT NOCOPY VARCHAR2,
237 x_msg_count OUT NOCOPY NUMBER,
238 x_msg_data OUT NOCOPY VARCHAR2,
239 p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
240 p_klev_tbl IN klev_tbl_type);
241
242 PROCEDURE delete_contract_line(
243 p_api_version IN NUMBER,
244 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
245 x_return_status OUT NOCOPY VARCHAR2,
246 x_msg_count OUT NOCOPY NUMBER,
247 x_msg_data OUT NOCOPY VARCHAR2,
248 p_line_id IN NUMBER);
249
250 PROCEDURE delete_contract_line(
251 p_api_version IN NUMBER,
252 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
253 x_return_status OUT NOCOPY VARCHAR2,
254 x_msg_count OUT NOCOPY NUMBER,
255 x_msg_data OUT NOCOPY VARCHAR2,
256 p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
257 p_klev_rec IN klev_rec_type,
258 p_delete_cascade_yn IN VARCHAR2);
259
260 PROCEDURE delete_contract_line(
261 p_api_version IN NUMBER,
262 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
263 x_return_status OUT NOCOPY VARCHAR2,
264 x_msg_count OUT NOCOPY NUMBER,
265 x_msg_data OUT NOCOPY VARCHAR2,
266 p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
267 p_klev_tbl IN klev_tbl_type,
268 p_delete_cascade_yn IN varchar2);
269
270 PROCEDURE lock_contract_line(
271 p_api_version IN NUMBER,
272 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
277 p_klev_rec IN klev_rec_type);
278
279 PROCEDURE lock_contract_line(
280 p_api_version IN NUMBER,
281 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
282 x_return_status OUT NOCOPY VARCHAR2,
283 x_msg_count OUT NOCOPY NUMBER,
284 x_msg_data OUT NOCOPY VARCHAR2,
285 p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
286 p_klev_tbl IN klev_tbl_type);
287
288 PROCEDURE validate_contract_line(
289 p_api_version IN NUMBER,
290 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
291 x_return_status OUT NOCOPY VARCHAR2,
292 x_msg_count OUT NOCOPY NUMBER,
293 x_msg_data OUT NOCOPY VARCHAR2,
294 p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
295 p_klev_rec IN klev_rec_type);
296
297 PROCEDURE validate_contract_line(
298 p_api_version IN NUMBER,
299 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
300 x_return_status OUT NOCOPY VARCHAR2,
301 x_msg_count OUT NOCOPY NUMBER,
302 x_msg_data OUT NOCOPY VARCHAR2,
303 p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
304 p_klev_tbl IN klev_tbl_type);
305
306 PROCEDURE create_governance(
307 p_api_version IN NUMBER,
308 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
309 x_return_status OUT NOCOPY VARCHAR2,
310 x_msg_count OUT NOCOPY NUMBER,
311 x_msg_data OUT NOCOPY VARCHAR2,
312 p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type,
313 x_gvev_rec OUT NOCOPY okl_okc_migration_pvt.gvev_rec_type);
314
315 PROCEDURE create_governance(
316 p_api_version IN NUMBER,
317 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_gvev_tbl IN okl_okc_migration_pvt.gvev_tbl_type,
322 x_gvev_tbl OUT NOCOPY okl_okc_migration_pvt.gvev_tbl_type);
323
324 PROCEDURE update_governance(
325 p_api_version IN NUMBER,
326 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
327 x_return_status OUT NOCOPY VARCHAR2,
328 x_msg_count OUT NOCOPY NUMBER,
329 x_msg_data OUT NOCOPY VARCHAR2,
330 p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type,
331 x_gvev_rec OUT NOCOPY okl_okc_migration_pvt.gvev_rec_type);
332
333 PROCEDURE update_governance(
334 p_api_version IN NUMBER,
335 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
336 x_return_status OUT NOCOPY VARCHAR2,
337 x_msg_count OUT NOCOPY NUMBER,
338 x_msg_data OUT NOCOPY VARCHAR2,
339 p_gvev_tbl IN okl_okc_migration_pvt.gvev_tbl_type,
340 x_gvev_tbl OUT NOCOPY okl_okc_migration_pvt.gvev_tbl_type);
341
342 PROCEDURE delete_governance(
343 p_api_version IN NUMBER,
344 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
345 x_return_status OUT NOCOPY VARCHAR2,
346 x_msg_count OUT NOCOPY NUMBER,
347 x_msg_data OUT NOCOPY VARCHAR2,
348 p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type);
349
350 PROCEDURE delete_governance(
351 p_api_version IN NUMBER,
352 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
353 x_return_status OUT NOCOPY VARCHAR2,
354 x_msg_count OUT NOCOPY NUMBER,
355 x_msg_data OUT NOCOPY VARCHAR2,
356 p_gvev_tbl IN okl_okc_migration_pvt.gvev_tbl_type);
357
358 PROCEDURE lock_governance(
359 p_api_version IN NUMBER,
360 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
361 x_return_status OUT NOCOPY VARCHAR2,
362 x_msg_count OUT NOCOPY NUMBER,
363 x_msg_data OUT NOCOPY VARCHAR2,
364 p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type);
365
366 PROCEDURE lock_governance(
367 p_api_version IN NUMBER,
368 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
369 x_return_status OUT NOCOPY VARCHAR2,
370 x_msg_count OUT NOCOPY NUMBER,
371 x_msg_data OUT NOCOPY VARCHAR2,
372 p_gvev_tbl IN okl_okc_migration_pvt.gvev_tbl_type);
373
374 PROCEDURE validate_governance(
375 p_api_version IN NUMBER,
376 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
377 x_return_status OUT NOCOPY VARCHAR2,
378 x_msg_count OUT NOCOPY NUMBER,
379 x_msg_data OUT NOCOPY VARCHAR2,
380 p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type);
381
382 PROCEDURE validate_governance(
383 p_api_version IN NUMBER,
384 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
385 x_return_status OUT NOCOPY VARCHAR2,
386 x_msg_count OUT NOCOPY NUMBER,
387 x_msg_data OUT NOCOPY VARCHAR2,
388 p_gvev_tbl IN okl_okc_migration_pvt.gvev_tbl_type);
389
390 Procedure get_contract_header_info(
391 p_api_version IN NUMBER,
392 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
393 x_return_status OUT NOCOPY VARCHAR2,
394 x_msg_count OUT NOCOPY NUMBER,
395 x_msg_data OUT NOCOPY VARCHAR2,
396 p_chr_id IN NUMBER,
397 p_chr_id_old IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
398 p_orgId IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
399 p_custId IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
400 p_invOrgId IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
401 p_oldOKL_STATUS IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,
402 p_oldOKC_STATUS IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,
403 x_hdr_tbl OUT NOCOPY hdr_tbl_type);
404
405 END OKL_CONTRACT_PUB;