1 PACKAGE OKC_TERMS_UTIL_GRP AUTHID CURRENT_USER AS
2 /* $Header: OKCGDUTS.pls 120.2 2005/09/26 15:12:40 vnanjang noship $ */
3
4 G_TMPL_DOC_TYPE CONSTANT VARCHAR2(30) := 'TEMPLATE';
5
6 G_ONLY_STANDARD_ART_EXIST CONSTANT VARCHAR2(30) := 'ONLY_STANDARD';
7 G_NON_STANDARD_ART_EXIST CONSTANT VARCHAR2(30) := 'NON_STANDARD';
8 G_NO_ARTICLE_EXIST CONSTANT VARCHAR2(30) := 'NONE';
9
10 G_ONLY_STANDARD_ART_AMENDED CONSTANT VARCHAR2(30) := 'ONLY_STANDARD';
11 G_NON_STANDARD_ART_AMENDED CONSTANT VARCHAR2(30) := 'NON_STANDARD';
12 G_NO_ARTICLE_AMENDED CONSTANT VARCHAR2(30) := 'NONE';
13 G_PRIMARY_KDOC_AMENDED CONSTANT VARCHAR2(30) := 'PRIMARY_DOCUMENT';
14
15 G_NO_CHANGE CONSTANT VARCHAR2(30) := 'NO_CHANGE';
16 G_ARTICLES_CHANGED CONSTANT VARCHAR2(30) := 'ARTICLES_CHANGED';
17 G_DELIVERABLES_CHANGED CONSTANT VARCHAR2(30) := 'DELIVERABLES_CHANGED';
18 G_ART_AND_DELIV_CHANGED CONSTANT VARCHAR2(30) := 'ALL_CHANGED';
19
20 TYPE template_rec_type IS RECORD (
21 template_name VARCHAR2(240),
22 intent VARCHAR2(1),
23 status_code VARCHAR2(30),
24 start_date DATE,
25 end_date DATE,
26 instruction_text VARCHAR2(2000),
27 description VARCHAR2(2000),
28 global_flag VARCHAR2(1),
29 contract_expert_enabled VARCHAR2(1),
30 org_id NUMBER);
31
32 TYPE doc_rec_type IS RECORD (
33 doc_type VARCHAR2(30),
34 doc_id Number
35 );
36
37 TYPE category_rec_type IS RECORD (
38 category_name Varchar2(2000)
39 );
40
41 TYPE item_rec_type IS RECORD (
42 name Varchar2(2000)
43 );
44
45
46 TYPE var_value_rec_type IS RECORD (
47 Variable_code VARCHAR2(30),
48 Variable_value_id VARCHAR2(2000)
49 );
50
51
52 TYPE var_value_dtl_rec_type IS RECORD (
53 Variable_code VARCHAR2(30),
54 Variable_value VARCHAR2(2000),
55 Variable_value_id VARCHAR2(2000)
56 );
57
58 TYPE sys_var_value_tbl_type IS TABLE OF var_value_rec_type INDEX BY BINARY_INTEGER;
59
60 TYPE variable_code_tbl_type IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
61
62 TYPE category_tbl_type IS TABLE OF category_rec_type INDEX BY BINARY_INTEGER;
63 TYPE item_tbl_type IS TABLE OF item_rec_type INDEX BY BINARY_INTEGER;
64
65 TYPE doc_tbl_type IS TABLE OF doc_rec_type INDEX BY BINARY_INTEGER;
66
67 TYPE variable_value_dtl_tbl IS TABLE of var_value_dtl_rec_type INDEX BY BINARY_INTEGER;
68
69 -- Quoting Team wanted this record defination.
70 TYPE item_tab is table of varchar2(2000) ;
71 TYPE category_tab is table of varchar2(2000) ;
72
73 TYPE item_dtl_tbl IS RECORD (
74 category category_tab,
75 item item_tab
76 );
77 /*
78 -- To be used to delete Terms whenever a document is deleted.
79 */
80 PROCEDURE Delete_Doc (
81 p_api_version IN NUMBER,
82 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
83 p_commit IN VARCHAR2 := FND_API.G_FALSE,
84
85 x_return_status OUT NOCOPY VARCHAR2,
86 x_msg_data OUT NOCOPY VARCHAR2,
87 x_msg_count OUT NOCOPY NUMBER,
88
89 p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,
90 p_validation_string IN VARCHAR2 := NULL,
91 p_doc_type IN VARCHAR2,
92 p_doc_id IN NUMBER
93 );
94
95 /*
96 -- To be used when doing bulk deletes of document.A very PO specific scenario.
97 */
98 PROCEDURE Purge_Doc (
99 p_api_version IN NUMBER,
100 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101 p_commit IN VARCHAR2 := FND_API.G_FALSE,
102
103 x_return_status OUT NOCOPY VARCHAR2,
104 x_msg_data OUT NOCOPY VARCHAR2,
105 x_msg_count OUT NOCOPY NUMBER,
106
107 p_doc_tbl IN doc_tbl_type
108 );
109
110 /*
111 -- To be used in amend flow to mark articles as amended if any of system
112 -- variables used in article has been changed in source document during amendment.
113 */
114 PROCEDURE Mark_Variable_Based_Amendment (
115 p_api_version IN NUMBER,
116 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
117 p_commit IN VARCHAR2 := FND_API.G_FALSE,
118
119 x_return_status OUT NOCOPY VARCHAR2,
120 x_msg_data OUT NOCOPY VARCHAR2,
121 x_msg_count OUT NOCOPY NUMBER,
122
123 p_doc_type IN VARCHAR2,
124 p_doc_id IN NUMBER
125 );
126
127 /*
128 --To be used to find out if a document is using articles.If yes then what type.
129 --Possible return values NONE,ONLY_STANDARD_EXIST ,NON_STANDARD_EXIST .
130 */
131
132 FUNCTION Is_Article_Exist(
133 p_api_version IN NUMBER,
134 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
135
136 x_return_status OUT NOCOPY VARCHAR2,
137 x_msg_data OUT NOCOPY VARCHAR2,
138 x_msg_count OUT NOCOPY NUMBER,
139
140 p_doc_type IN VARCHAR2,
141 p_doc_id IN NUMBER
142 ) RETURN VARCHAR2;
143
144 FUNCTION Is_Article_Exist(
145 p_doc_type IN VARCHAR2,
146 p_doc_id IN NUMBER
147 ) RETURN VARCHAR2;
148
149 /*
150 -- To be used to find out if Terms and deliverable has deviate any deviation as
151 -- compared to template that was used in the document.ocument has used.
152 -- Possible return values NO_CHANGE,ARTICLES_CHANGED,DELIVERABLES_CHANGED,
153 -- ARTICLES_AND_DELIVERABLES_CHANGED
154 */
155 FUNCTION Deviation_From_Standard(
156 p_api_version IN NUMBER,
157 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
158
159 x_return_status OUT NOCOPY VARCHAR2,
160 x_msg_data OUT NOCOPY VARCHAR2,
161 x_msg_count OUT NOCOPY NUMBER,
162
163 p_doc_type IN VARCHAR2,
164 p_doc_id IN NUMBER
165 ) RETURN VARCHAR2;
166
167 FUNCTION Deviation_From_Standard(
168 p_doc_type IN VARCHAR2,
169 p_doc_id IN NUMBER
170 ) RETURN VARCHAR2;
171 /*
172 --To be used to find out if template used in document has expired.Possible return values Y,N.
173 -- Possible return values are
174 -- FND_API.G_TRUE = Template expired
175 -- FND_API.G_FALSE = Template not expired.
176 */
177 FUNCTION Is_Template_Expired(
178 p_api_version IN NUMBER,
179 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
180
181 x_return_status OUT NOCOPY VARCHAR2,
182 x_msg_data OUT NOCOPY VARCHAR2,
183 x_msg_count OUT NOCOPY NUMBER,
184
185 p_doc_type IN VARCHAR2,
186 p_doc_id IN NUMBER
187 ) RETURN VARCHAR2;
188
189 /*
190 --To be used to find out if any deliverable exists on document.If Yes then what
191 -- type.Possible values NONE,ONLY_CONTRACTUAL,ONLY_INTERNAL,CONTRACTUAL_AND_INTERNAL
192 */
193
194 FUNCTION Is_Deliverable_Exist(
195 p_api_version IN NUMBER,
196 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
197
198 x_return_status OUT NOCOPY VARCHAR2,
199 x_msg_data OUT NOCOPY VARCHAR2,
200 x_msg_count OUT NOCOPY NUMBER,
201
202 p_doc_type IN VARCHAR2,
203 p_doc_id IN NUMBER
204 ) RETURN VARCHAR2;
205
206
207 /*
208 --To be used in amend flow to find out if any article is amended.If Yes then what
209 -- type of article is amended.Possible values NO_ARTICLE_AMENDED,ONLY_STANDARD_AMENDED ,NON_STANDARD_AMENDED
210 */
211
212 FUNCTION Is_Article_Amended(
213 p_api_version IN NUMBER,
214 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
215
216 x_return_status OUT NOCOPY VARCHAR2,
217 x_msg_data OUT NOCOPY VARCHAR2,
218 x_msg_count OUT NOCOPY NUMBER,
219
220 p_doc_type IN VARCHAR2,
221 p_doc_id IN NUMBER
222 ) RETURN VARCHAR2;
223
224 /*
225 -- To be used in amend flow to find out if any deliverable is amended.
226 -- If Yes then what type.Possible values
227 -- NONE,ONLY_CONTRACTUAL,ONLY_INTERNAL,CONTRACTUAL_AND_INTERNAL
228 */
229
230 FUNCTION Is_Deliverable_Amended(
231 p_api_version IN NUMBER,
232 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
233
234 x_return_status OUT NOCOPY VARCHAR2,
235 x_msg_data OUT NOCOPY VARCHAR2,
236 x_msg_count OUT NOCOPY NUMBER,
237
238 p_doc_type IN VARCHAR2,
239 p_doc_id IN NUMBER
240 ) RETURN VARCHAR2;
241
242 --This API is deprecated. Use GET_CONTRACT_DETAILS() instead.
243 PROCEDURE Get_Terms_Template(
244 p_api_version IN NUMBER,
245 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
246
247 x_return_status OUT NOCOPY VARCHAR2,
248 x_msg_data OUT NOCOPY VARCHAR2,
249 x_msg_count OUT NOCOPY NUMBER,
250
251 p_doc_type IN VARCHAR2,
252 p_doc_id IN NUMBER,
253 x_template_id OUT NOCOPY NUMBER,
254 x_template_name OUT NOCOPY VARCHAR2
255 );
256
257 /*
258 -- To be used to find out document type when document is of contract family.
259 */
260 FUNCTION Get_Contract_Document_Type(
261 p_api_version IN NUMBER,
262 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
263
264 x_return_status OUT NOCOPY VARCHAR2,
265 x_msg_data OUT NOCOPY VARCHAR2,
266 x_msg_count OUT NOCOPY NUMBER,
267
268 p_chr_id IN NUMBER
269 ) RETURN VARCHAR2;
270
271 PROCEDURE Get_Contract_Document_Type_ID(
272 p_api_version IN NUMBER,
273 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
274
275 x_return_status OUT NOCOPY VARCHAR2,
276 x_msg_data OUT NOCOPY VARCHAR2,
277 x_msg_count OUT NOCOPY NUMBER,
278
279 p_chr_id IN NUMBER,
280 x_doc_id OUT NOCOPY NUMBER,
281 x_doc_type OUT NOCOPY VARCHAR2
282 );
283 /*
284 -- To be used to find out document type when document is of contract family.
285 */
286 PROCEDURE Get_Last_Update_Date(
287 p_api_version IN NUMBER,
288 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
289
290 x_return_status OUT NOCOPY VARCHAR2,
291 x_msg_data OUT NOCOPY VARCHAR2,
292 x_msg_count OUT NOCOPY NUMBER,
293
294 p_doc_type IN VARCHAR2,
295 p_doc_id IN NUMBER,
296
297 x_deliverable_changed_date OUT NOCOPY DATE,
298 x_terms_changed_date OUT NOCOPY DATE
299 );
300
301 FUNCTION Ok_To_Commit (
302 p_api_version IN NUMBER,
303 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
304
305 x_return_status OUT NOCOPY VARCHAR2,
306 x_msg_data OUT NOCOPY VARCHAR2,
307 x_msg_count OUT NOCOPY NUMBER,
308
309 p_tmpl_change IN VARCHAR2 := NULL,
310 p_validation_string IN VARCHAR2 := NULL,
311 p_doc_type IN VARCHAR2,
312 p_doc_id IN NUMBER
313 ) RETURN VARCHAR2;
314
315 FUNCTION is_manual_article_exist(
316 p_api_version IN NUMBER,
317 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
318
319 x_return_status OUT NOCOPY VARCHAR2,
320 x_msg_data OUT NOCOPY VARCHAR2,
321 x_msg_count OUT NOCOPY NUMBER,
322
323 p_doc_type IN VARCHAR2,
324 p_doc_id IN NUMBER
325 ) RETURN VARCHAR2;
326
327 FUNCTION Get_Template_Name(
328 p_api_version IN NUMBER,
329 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
330 p_template_id IN NUMBER,
331
332 x_return_status OUT NOCOPY VARCHAR2,
333 x_msg_data OUT NOCOPY VARCHAR2,
334 x_msg_count OUT NOCOPY NUMBER
335 ) RETURN VARCHAR2;
336
337 --This API is deprecated. Use GET_CONTRACT_DETAILS() instead.
338 Function Get_Terms_Template(
339 p_doc_type IN VARCHAR2,
340 p_doc_id IN NUMBER
341 ) Return varchar2;
342
343 PROCEDURE get_item_dtl_for_expert(
344 p_api_version IN NUMBER,
345 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
346
347 x_return_status OUT NOCOPY VARCHAR2,
348 x_msg_data OUT NOCOPY VARCHAR2,
349 x_msg_count OUT NOCOPY NUMBER,
350
351 p_doc_type IN VARCHAR2,
352 p_doc_id IN NUMBER,
353 x_category_tbl OUT NOCOPY item_tbl_type,
354 x_item_tbl OUT NOCOPY item_tbl_type
355 );
356
357 FUNCTION get_last_signed_revision(
358 p_doc_type IN VARCHAR2,
359 p_doc_id IN NUMBER,
360 p_revision_num IN NUMBER
361 ) RETURN NUMBER;
362
363 Procedure Get_Terms_Template_dtl(
364 p_template_id IN NUMBER,
365 p_template_rec OUT NOCOPY template_rec_type,
366 x_return_status OUT NOCOPY VARCHAR2,
367 x_msg_data OUT NOCOPY VARCHAR2,
368 x_msg_count OUT NOCOPY NUMBER
369 ) ;
370
371 FUNCTION empclob RETURN CLOB;
372 FUNCTION tempblob RETURN BLOB;
373
374 --This API is deprecated. Use GET_CONTRACT_DETAILS_ALL() instead.
375 Procedure Get_Terms_Template_dtl(
376 p_doc_id IN NUMBER,
377 p_doc_type IN VARCHAR,
378 x_template_id OUT NOCOPY NUMBER,
379 x_template_name OUT NOCOPY VARCHAR2,
380 x_template_description OUT NOCOPY VARCHAR2,
381 x_template_instruction OUT NOCOPY VARCHAR2,
382 x_return_status OUT NOCOPY VARCHAR2,
383 x_msg_data OUT NOCOPY VARCHAR2,
384 x_msg_count OUT NOCOPY NUMBER
385 ) ;
386
387 FUNCTION enable_update(
388 p_object_type IN VARCHAR2,
389 p_document_type IN VARCHAR2,
390 p_standard_yn IN VARCHAR2
391 ) RETURN VARCHAR2;
392
393 FUNCTION enable_delete(
394 p_object_type IN VARCHAR2,
395 p_mandatory_yn IN VARCHAR2,
396 p_standard_yn IN VARCHAR2,
397 p_document_type IN VARCHAR2 := NULL
398 ) RETURN VARCHAR2;
399
400 FUNCTION Is_Document_Updatable(
401 p_doc_type IN VARCHAR2,
402 p_doc_id IN NUMBER,
403 p_validation_string IN VARCHAR2
404 ) RETURN VARCHAR2; -- 'T' - updatable, 'F'- non-updatable, 'E' - error or doesn't exist
405
406
407 /* Following API's are added for 11.5.10+ projects*/
408
409
410 FUNCTION Is_Primary_Terms_Doc_Mergeable(
411 p_document_type IN VARCHAR2,
412 p_document_id IN NUMBER
413 ) RETURN VARCHAR2;
414
415 FUNCTION Get_Primary_Terms_Doc_File_Id(
416 p_document_type IN VARCHAR2,
417 p_document_id IN NUMBER
418 ) RETURN NUMBER;
419
420
421 FUNCTION Has_Terms(
422 p_document_type IN VARCHAR2,
423 p_document_id IN NUMBER
424 ) RETURN VARCHAR2;
425
426 Procedure Get_Contract_Details(
427 p_api_version IN NUMBER,
428 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
429
430 x_return_status OUT NOCOPY VARCHAR2,
431 x_msg_data OUT NOCOPY VARCHAR2,
432 x_msg_count OUT NOCOPY NUMBER,
433
434 p_document_type IN VARCHAR2,
435 p_document_id IN NUMBER,
436
437 x_authoring_party OUT NOCOPY VARCHAR2,
438 x_contract_source OUT NOCOPY VARCHAR2,
439 x_template_name OUT NOCOPY VARCHAR2,
440 x_template_description OUT NOCOPY VARCHAR2
441 );
442
443 Procedure Get_Contract_Details_All(
444 p_api_version IN NUMBER,
445 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
446
447 x_return_status OUT NOCOPY VARCHAR2,
448 x_msg_data OUT NOCOPY VARCHAR2,
449 x_msg_count OUT NOCOPY NUMBER,
450
451 p_document_type IN VARCHAR2,
452 p_document_id IN NUMBER,
453 p_document_version IN NUMBER := NULL,
454
455 x_has_terms OUT NOCOPY VARCHAR2,
456 x_authoring_party_code OUT NOCOPY VARCHAR2,
457 x_authoring_party OUT NOCOPY VARCHAR2,
458 x_contract_source_code OUT NOCOPY VARCHAR2,
459 x_contract_source OUT NOCOPY VARCHAR2,
460 x_template_id OUT NOCOPY NUMBER,
461 x_template_name OUT NOCOPY VARCHAR2,
462 x_template_description OUT NOCOPY VARCHAR2,
463 x_template_instruction OUT NOCOPY VARCHAR2,
464 x_has_primary_doc OUT NOCOPY VARCHAR2,
465 x_is_primary_doc_mergeable OUT NOCOPY VARCHAR2,
466 x_primary_doc_file_id OUT NOCOPY VARCHAR2
467
468 );
469
470 FUNCTION Get_Authoring_Party_Code(
471 p_document_type IN VARCHAR2,
472 p_document_id IN NUMBER
473 ) RETURN VARCHAR2;
474
475 FUNCTION Get_Contract_Source_Code(
476 p_document_type IN VARCHAR2,
477 p_document_id IN NUMBER
478 ) RETURN VARCHAR2;
479
480 FUNCTION Has_Valid_Terms(
481 p_document_type IN VARCHAR2,
482 p_document_id IN NUMBER
483 ) RETURN VARCHAR2;
484
485 FUNCTION Is_Terms_Template_Valid(
486 p_api_version IN NUMBER,
487 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
488
489 x_return_status OUT NOCOPY VARCHAR2,
490 x_msg_data OUT NOCOPY VARCHAR2,
491 x_msg_count OUT NOCOPY NUMBER,
492
493 p_template_id IN NUMBER,
494 p_doc_type IN VARCHAR2,
495 p_org_id IN NUMBER,
496 p_valid_date IN DATE DEFAULT SYSDATE
497 ) RETURN VARCHAR2;
498
499 PROCEDURE Get_Contract_Defaults(
500 p_api_version IN NUMBER,
501 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
502
503 x_return_status OUT NOCOPY VARCHAR2,
504 x_msg_data OUT NOCOPY VARCHAR2,
505 x_msg_count OUT NOCOPY NUMBER,
506
507 p_template_id IN VARCHAR2,
508 p_document_type IN VARCHAR2,
509
510 x_authoring_party OUT NOCOPY VARCHAR2,
511 x_contract_source OUT NOCOPY VARCHAR2,
512 x_template_name OUT NOCOPY VARCHAR2,
513 x_template_description OUT NOCOPY VARCHAR2
514 );
515
516 PROCEDURE Get_Default_Template(
517 p_api_version IN NUMBER,
518 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
519
520 x_return_status OUT NOCOPY VARCHAR2,
521 x_msg_data OUT NOCOPY VARCHAR2,
522 x_msg_count OUT NOCOPY NUMBER,
523
524 p_document_type IN VARCHAR2,
525 p_org_id IN NUMBER DEFAULT NULL,
526 p_valid_date IN DATE DEFAULT SYSDATE,
527
528 x_template_id OUT NOCOPY NUMBER,
529 x_template_name OUT NOCOPY VARCHAR2,
530 x_template_description OUT NOCOPY VARCHAR2);
531
532 FUNCTION Auto_Generate_Deviations(
533 p_document_type IN VARCHAR2,
534 p_document_id IN NUMBER
535 ) RETURN VARCHAR2;
536
537
538 FUNCTION Get_Deviations_File_Id(
539 p_document_type IN VARCHAR2,
540 p_document_id IN NUMBER
541 ) RETURN VARCHAR2;
542
543 PROCEDURE Has_Uploaded_Deviations_Doc(
544 p_api_version IN NUMBER,
545 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
546
547 x_return_status OUT NOCOPY VARCHAR2,
548 x_msg_data OUT NOCOPY VARCHAR2,
549 x_msg_count OUT NOCOPY NUMBER,
550
551 p_document_type IN VARCHAR2,
552 p_document_Id IN NUMBER,
553 x_contract_source OUT NOCOPY VARCHAR2,
554 x_has_deviation_report OUT NOCOPY VARCHAR2
555 );
556
557 FUNCTION is_Deviations_enabled(
558 p_document_type IN VARCHAR2,
559 p_document_id IN NUMBER
560 ) RETURN VARCHAR2;
561
562 FUNCTION Contract_Terms_Amended(
563 p_api_version IN NUMBER,
564 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
565
566 x_return_status OUT NOCOPY VARCHAR2,
567 x_msg_data OUT NOCOPY VARCHAR2,
568 x_msg_count OUT NOCOPY NUMBER,
569
570 p_doc_type IN VARCHAR2,
571 p_doc_id IN NUMBER
572 ) RETURN VARCHAR2;
573
574 --For Multi language support
575 PROCEDURE get_translated_template(
576 p_api_version IN NUMBER,
577 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
578
579 p_template_id IN NUMBER,
580 p_language IN VARCHAR2,
581 p_document_type IN VARCHAR2,
582 p_validity_date IN DATE := SYSDATE,
583
584 x_return_status OUT NOCOPY VARCHAR2,
585 x_msg_data OUT NOCOPY VARCHAR2,
586 x_msg_count OUT NOCOPY NUMBER,
587
588 x_template_id OUT NOCOPY NUMBER
589 );
590
591
592 END OKC_TERMS_UTIL_GRP;
[Home] [Help]