1 PACKAGE OKC_TERMS_UTIL_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCVDUTS.pls 120.9 2007/05/10 06:42:52 ndoddi ship $ */
3
4
5 /*
6 -- PROCEDURE Delete_Doc
7 -- To be used to delete Terms whenever a document is deleted.
8 */
9 PROCEDURE Delete_Doc (
10 x_return_status OUT NOCOPY VARCHAR2,
11 p_doc_type IN VARCHAR2,
12 p_doc_id IN NUMBER );
13
14 /*
15 -- PROCEDURE Delete_Doc_version
16 -- To be used to delete Terms whenever a document is deleted.
17 */
18 PROCEDURE Delete_Doc_version (
19 x_return_status OUT NOCOPY VARCHAR2,
20 p_doc_type IN VARCHAR2,
21 p_doc_id IN NUMBER,
22 p_version_number IN NUMBER );
23
24 /*
25 -- PROCEDURE Mark_Amendment
26 -- This API will be used to mark any article as amended if any of variables have been changed.
27 */
28 PROCEDURE Mark_Amendment (
29 p_api_version IN NUMBER,
30 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
31
32 x_return_status OUT NOCOPY VARCHAR2,
33 x_msg_data OUT NOCOPY VARCHAR2,
34 x_msg_count OUT NOCOPY NUMBER,
35
36 p_doc_type IN VARCHAR2,
37 p_doc_id IN NUMBER,
38 p_variable_code IN VARCHAR2);
39
40 /*
41 -- PROCEDURE Merge_Template_Working_Copy
42 -- To be used to merge a working copy of a template is approved and old copy
43 -- and working copy
44 -- 11.5.10+ changes
45 1. Store the parent template id in a package global variable. This will retrieved
46 and returned by the overaloaded procedure.
47 2. Update the table OKC_TMPL_DRAFT_CLAUSES with the merged/parent template id.
48 */
49 PROCEDURE Merge_Template_Working_Copy (
50 p_api_version IN NUMBER,
51 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
52 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
53
54 x_return_status OUT NOCOPY VARCHAR2,
55 x_msg_data OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57
58 p_template_id IN NUMBER );
59
60 /*
61 -- PROCEDURE Get_System_Variables
62 -- Based on doc type this API will call different integrating API and will
63 -- get values of all variables being used in Terms and Conditions of a document
64 */
65 PROCEDURE Get_System_Variables (
66 p_api_version IN NUMBER,
67 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
68
69 x_return_status OUT NOCOPY VARCHAR2,
70 x_msg_data OUT NOCOPY VARCHAR2,
71 x_msg_count OUT NOCOPY NUMBER,
72
73 p_doc_type IN VARCHAR2,
74 p_doc_id IN NUMBER,
75 p_only_doc_variables IN VARCHAR2 := FND_API.G_TRUE,
76
77 x_sys_var_value_tbl OUT NOCOPY OKC_TERMS_UTIL_GRP.sys_var_value_tbl_type );
78
79 /*
80 -- PROCEDURE Substitute_Var_Value_Globally
81 -- to be called from T and C authoring UI to substitute variable value of any value
82 -- for every occurance of variable on document
83 */
84 PROCEDURE Substitute_Var_Value_Globally (
85 p_api_version IN NUMBER,
86 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
87
88 x_return_status OUT NOCOPY VARCHAR2,
89 x_msg_data OUT NOCOPY VARCHAR2,
90 x_msg_count OUT NOCOPY NUMBER,
91
92 p_doc_type IN VARCHAR2,
93 p_doc_id IN NUMBER,
94 p_variable_code IN VARCHAR2,
95 p_variable_value IN VARCHAR2,
96 p_variable_value_id IN VARCHAR2,
97 p_mode IN VARCHAR2,
98 p_validate_commit IN VARCHAR2 := FND_API.G_TRUE,
99 p_validation_string IN VARCHAR2 := NULL );
100
101 /*
102 -- PROCEDURE Create_Unassigned_Section
103 -- creating un-assigned sections in a document
104 */
105 PROCEDURE Create_Unassigned_Section (
106 p_api_version IN NUMBER,
107 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
108 p_commit IN VARCHAR2 := FND_API.G_FALSE,
109
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_msg_data OUT NOCOPY VARCHAR2,
112 x_msg_count OUT NOCOPY NUMBER,
113
114 p_doc_type IN VARCHAR2,
115 p_doc_id IN NUMBER,
116
117 x_scn_id OUT NOCOPY NUMBER );
118
119 /*
120 -- To Check if document type is valid
121 */
122 FUNCTION is_doc_type_valid(
123 p_doc_type IN VARCHAR2,
124 x_return_status OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 ;
125
126 /*
127 -- FUNCTION Get_Message
128 -- to be used to put tokens in messages code and return translated messaged.
129 -- It will be mainly used by QA API.
130 */
131 FUNCTION Get_Message (
132 p_app_name IN VARCHAR2,
133 p_msg_name IN VARCHAR2,
134 p_token1 IN VARCHAR2 :=NULL,
135 p_token1_value IN VARCHAR2 :=NULL,
136 p_token2 IN VARCHAR2 :=NULL,
137 p_token2_value IN VARCHAR2 :=NULL,
138 p_token3 IN VARCHAR2 :=NULL,
139 p_token3_value IN VARCHAR2 :=NULL,
140 p_token4 IN VARCHAR2 :=NULL,
141 p_token4_value IN VARCHAR2 :=NULL,
142 p_token5 IN VARCHAR2 :=NULL,
143 p_token5_value IN VARCHAR2 :=NULL,
144 p_token6 IN VARCHAR2 :=NULL,
145 p_token6_value IN VARCHAR2 :=NULL,
146 p_token7 IN VARCHAR2 :=NULL,
147 p_token7_value IN VARCHAR2 :=NULL,
148 p_token8 IN VARCHAR2 :=NULL,
149 p_token8_value IN VARCHAR2 :=NULL,
150 p_token9 IN VARCHAR2 :=NULL,
151 p_token9_value IN VARCHAR2 :=NULL,
152 p_token10 IN VARCHAR2 :=NULL,
153 p_token10_value IN VARCHAR2 :=NULL ) RETURN VARCHAR2;
154
155
156 /* This function will be used in view OKS_TERMS_STRUCTURES_V */
157 Function GET_LATEST_ART_VERSION(
158 p_article_id IN NUMBER,
159 p_org_id IN NUMBER,
160 p_eff_date IN DATE) RETURN Varchar2;
161
162 /* This function will be used in view OKS_TERMS_STRUCTURES_V */
163 FUNCTION GET_ALTERNATE_YN (
164 p_article_id IN NUMBER,
165 p_org_id IN NUMBER) RETURN Varchar2;
166
167 FUNCTION Tmpl_Intent_editable (
168 p_template_id IN NUMBER) RETURN Varchar2;
169
170 FUNCTION HAS_ALTERNATES (
171 p_article_id IN NUMBER,
172 p_eff_date IN DATE,
173 p_document_type IN VARCHAR2) RETURN Varchar2;
174
175 FUNCTION Has_Alternates(
176 p_article_id IN NUMBER,
177 p_start_date IN DATE,
178 p_end_date IN DATE,
179 p_org_id IN NUMBER,
180 p_document_type IN VARCHAR2) RETURN Varchar2;
181
182 FUNCTION Has_amendments(
183 p_document_id IN NUMBER,
184 p_document_type IN VARCHAR2,
185 p_document_version IN NUMBER) RETURN Varchar2; -- Fix for bug# 4313546
186
187 FUNCTION get_summary_amend_code(
188 p_existing_summary_code IN VARCHAR2,
189 p_existing_operation_code IN VARCHAR2,
190 p_amend_operation_code IN VARCHAR2 ) return VARCHAR2;
191
192 /* Wraps get_summary_amend_code and replaces G_MISS_CHAR with NULL in return value */
193 FUNCTION get_actual_summary_amend_code(
194 p_existing_summary_code IN VARCHAR2,
195 p_existing_operation_code IN VARCHAR2,
196 p_amend_operation_code IN VARCHAR2 ) return VARCHAR2;
197
198 FUNCTION get_article_version_number(
199 p_art_version_id IN NUMBER) RETURN Varchar2;
200
201 FUNCTION get_section_label(
202 p_scn_id IN NUMBER) RETURN Varchar2;
203
204 -- bug #4059806
205 -- Added function to get default section from article version
206 -- or expert enabled template.
207 FUNCTION GET_SECTION_NAME(
208 p_article_version_id IN NUMBER) RETURN VARCHAR2;
209
210 FUNCTION GET_SECTION_NAME(
211 p_article_version_id IN NUMBER,
212 p_template_id IN NUMBER) RETURN VARCHAR2;
213
214 FUNCTION get_latest_art_version_no(
215 p_article_id IN NUMBER,
216 p_document_type IN VARCHAR2,
217 p_document_id IN NUMBER ) RETURN Varchar2 ;
218
219 FUNCTION get_latest_art_version_id(
220 p_article_id IN NUMBER,
221 p_document_type IN VARCHAR2,
222 p_document_id IN NUMBER ) RETURN NUMBER ;
223
224 FUNCTION Get_latest_tmpl_art_version_id(
225 p_article_id IN NUMBER,
226 p_eff_date IN DATE) RETURN NUMBER;
227
228 /* 11.5.10+ obsolete, added 2 new in params
229 FUNCTION Get_latest_tmpl_art_version_id(
230 p_article_id IN NUMBER,
231 p_start_date IN DATE,
232 p_end_date IN DATE,
233 p_status_code IN VARCHAR2) RETURN NUMBER;
234 */
235 FUNCTION get_article_name(
236 p_article_id IN NUMBER,
237 p_article_version_id IN NUMBER) RETURN Varchar2;
238
239 FUNCTION GET_SECTION_NAME(
240 p_CONTEXT IN VARCHAR2,
241 p_ID IN NUMBER) RETURN VARCHAR2;
242
243 FUNCTION GET_VALUE_SET_VARIABLE_VALUE (
244 p_CONTEXT IN VARCHAR2,
245 p_VALUE_SET_ID IN NUMBER,
246 p_FLEX_VALUE_ID IN VARCHAR2 ) RETURN VARCHAR2;
247
248 PROCEDURE get_latest_article_details(
249 p_article_id IN NUMBER,
250 p_document_type IN VARCHAR2,
251 p_document_id IN NUMBER,
252 x_article_version_id OUT NOCOPY NUMBER,
253 x_article_version_number OUT NOCOPY VARCHAR2,
254 x_local_article_id OUT NOCOPY NUMBER,
255 x_adoption_type OUT NOCOPY VARCHAR2 );
256
257 FUNCTION get_local_article_id(
258 p_article_id IN NUMBER,
259 p_document_type IN VARCHAR2,
260 p_document_id IN NUMBER ) RETURN NUMBER ;
261
262 FUNCTION get_adoption_type(
263 p_article_id IN NUMBER,
264 p_document_type IN VARCHAR2,
265 p_document_id IN NUMBER ) RETURN Varchar2 ;
266
267 FUNCTION get_print_template_name(
268 p_print_template_id IN NUMBER) RETURN VARCHAR2;
269
270 FUNCTION get_current_org_id(
271 p_doc_type IN VARCHAR2,
272 p_doc_id IN NUMBER ) RETURN NUMBER;
273
274 FUNCTION get_template_model_name (
275 p_template_id IN NUMBER,
276 p_template_model_id IN NUMBER) RETURN VARCHAR2;
277
278 FUNCTION get_tmpl_model_published_by(
279 p_template_id IN NUMBER,
280 p_template_model_id IN NUMBER ) RETURN VARCHAR2;
281
282 FUNCTION get_tmpl_model_publish_date(
283 p_template_id IN NUMBER,
284 p_template_model_id IN NUMBER ) RETURN DATE;
285
286 FUNCTION get_chr_id_for_doc_id(
287 p_document_id IN NUMBER ) RETURN NUMBER;
288
289 --Checks if the given function is accessible to the user and returns 'Y' if accessible else 'N'
290 FUNCTION is_Function_Accessible(
291 p_function_name IN VARCHAR2
292 ) RETURN VARCHAR2;
293
294 PROCEDURE get_template_details (
295 p_api_version IN NUMBER,
296 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
297 p_commit IN VARCHAR2 := FND_API.G_FALSE,
298
299 x_return_status OUT NOCOPY VARCHAR2,
300 x_msg_data OUT NOCOPY VARCHAR2,
301 x_msg_count OUT NOCOPY NUMBER,
302
303 p_document_type IN VARCHAR2,
304 p_document_id IN NUMBER,
305
306 p_mode in VARCHAR2,
307 p_eff_date IN DATE,
308 p_org_id IN NUMBER,
309 x_template_exists OUT NOCOPY VARCHAR2,
310 x_template_id OUT NOCOPY NUMBER,
311 x_template_name OUT NOCOPY VARCHAR2,
312 x_enable_expert_button OUT NOCOPY VARCHAR2,
313 x_template_org_id OUT NOCOPY NUMBER,
314 x_doc_numbering_scheme OUT NOCOPY VARCHAR2,
315 x_config_header_id OUT NOCOPY NUMBER,
316 x_config_revision_number OUT NOCOPY NUMBER,
317 x_valid_config_yn OUT NOCOPY VARCHAR2
318 );
319
320 --Checks if the given section is deleted
321 FUNCTION is_section_deleted(
322 p_scn_id IN NUMBER
323 ) RETURN VARCHAR2;
324
325 --Checks if the given article is deleted
326 FUNCTION is_article_deleted(
327 p_cat_id IN NUMBER,
328 p_article_id IN NUMBER
329 ) RETURN VARCHAR2;
330
331 --Checks if the given article has deliverable type variables and the deliverable is amended
332 --To be used by the Printing program
333 FUNCTION deliverable_amendment_exists(
334 p_cat_id IN NUMBER,
335 p_document_id IN NUMBER,
336 p_document_type IN VARCHAR2
337 ) RETURN VARCHAR2;
338
339 /*
340 -- PROCEDURE purge_qa_results
341 -- Called by concurrent program to purge old QA error data.
342 -- Parameter p_num_days is how far in the past to end the purge
343 */
344 PROCEDURE purge_qa_results (
345 errbuf OUT NOCOPY VARCHAR2,
346 retcode OUT NOCOPY VARCHAR2,
347 p_num_days IN NUMBER default 3);
348
349
350 /*
351 -- 11.5.10+
352 -- 2004/8/20 ANJKUMAR: overloaded function with additional params
353 -- p_doc_type and p_doc_id, changes logic only for p_doc_type = 'TEMPLATE'
354 -- looks first in the new table OKC_TMPL_DRAFT_CLAUSES if status is
355 -- DRAFT/REJECTED/PENDING_APPROVAL to get article versions
356 --
357 */
358 FUNCTION get_latest_tmpl_art_version_id(
359 p_article_id IN NUMBER,
360 p_start_date IN DATE,
361 p_end_date IN DATE,
362 p_status_code IN VARCHAR2,
363 p_doc_type IN VARCHAR2 DEFAULT NULL,
364 p_doc_id IN NUMBER DEFAULT NULL) RETURN NUMBER;
365
366 /*
367 --11.5.10+
368 --finds draft clauses to be submitted with template and creates rows in OKC_TMPL_DRAFT_CLAUSES
369 --returns whether there is a draft clause through x_drafts_present
370 */
371 PROCEDURE create_tmpl_clauses_to_submit (
372 p_api_version IN NUMBER,
373 p_init_msg_list IN VARCHAR2,
374 p_template_id IN VARCHAR2,
375 p_template_start_date IN DATE DEFAULT NULL,
376 p_template_end_date IN DATE DEFAULT NULL,
377 p_org_id IN NUMBER,
378 x_drafts_present OUT NOCOPY VARCHAR2,
379 x_return_status OUT NOCOPY VARCHAR2,
380 x_msg_count OUT NOCOPY NUMBER,
381 x_msg_data OUT NOCOPY VARCHAR2
382 );
383
384 /*
385 -- PROCEDURE Merge_Template_Working_Copy 11.5.10+ overloaded version
386 -- To be used to merge a working copy of a template is approved and old copy
387 -- and working copy
388 -- new out parameter x_parent_template_id returns the template id of the merged template
389 */
390 PROCEDURE Merge_Template_Working_Copy (
391 p_api_version IN NUMBER,
392 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
393 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
394
395 x_return_status OUT NOCOPY VARCHAR2,
396 x_msg_data OUT NOCOPY VARCHAR2,
400 x_parent_template_id OUT NOCOPY NUMBER);
397 x_msg_count OUT NOCOPY NUMBER,
398
399 p_template_id IN NUMBER,
401
402 FUNCTION unadopted_art_exist_on_tmpl(
403 p_template_id IN NUMBER,
404 p_org_id IN NUMBER DEFAULT NULL)
405 RETURN VARCHAR2;
406
407
408 -- Record types used by Update Contract Administrator API
409 TYPE doc_ids_tbl IS TABLE OF okc_template_usages.document_id%TYPE NOT NULL
410 INDEX BY PLS_INTEGER;
411
412 TYPE doc_types_tbl IS TABLE OF okc_template_usages.document_type%TYPE NOT NULL
413 INDEX BY PLS_INTEGER;
414
415 TYPE new_con_admin_user_ids_tbl IS TABLE OF okc_template_usages.contract_admin_id%TYPE NOT NULL
416 INDEX BY PLS_INTEGER;
417
418
419 -- Start of comments
420 --API name : update_contract_admin
421 --Type : Private.
422 --Function : API to update Contract Administrator of Blanket Sales
423 -- Agreements, Sales Orders and Sales Quotes
424 --Pre-reqs : None.
425 --Parameters :
426 --IN : p_api_version IN NUMBER Required
427 -- : p_init_msg_list IN VARCHAR2 Optional
428 -- Default = FND_API.G_FALSE
429 -- : p_commit IN VARCHAR2 Optional
430 -- Default = FND_API.G_FALSE
431 -- : p_doc_ids_tbl IN doc_ids_tbl Required
432 -- List of document ids whose Contract Administrator to be changed
433 -- : p_doc_types_tbl IN doc_types_tbl Required
434 -- List of document types whose Contract Administrator to be changed
435 -- : p_new_con_admin_user_ids_tbl IN new_con_admin_user_ids_tbl Required
436 -- List of new Contract Administrator ids
437 --OUT : x_return_status OUT VARCHAR2(1)
438 -- : x_msg_count OUT NUMBER
439 -- : x_msg_data OUT VARCHAR2(2000)
440 --Note :
441 -- End of comments
442 PROCEDURE update_contract_admin(
443 p_api_version IN NUMBER,
444 p_init_msg_list IN VARCHAR2,
445 p_commit IN VARCHAR2,
446 p_doc_ids_tbl IN doc_ids_tbl,
447 p_doc_types_tbl IN doc_types_tbl,
448 p_new_con_admin_user_ids_tbl IN new_con_admin_user_ids_tbl,
449 x_return_status OUT NOCOPY VARCHAR2,
450 x_msg_count OUT NOCOPY NUMBER,
451 x_msg_data OUT NOCOPY VARCHAR2
452 );
453
454
455 -- Start of comments
456 --API name : get_sales_group_con_admin
457 --Type : Private.
458 --Function : API to get Contract Administrator of a business document
459 -- according to Sales Group Assignment
460 --Pre-reqs : None.
461 --Parameters :
462 --IN : p_api_version IN NUMBER Required
463 -- : p_init_msg_list IN VARCHAR2 Optional
464 -- Default = FND_API.G_FALSE
465 -- : p_doc_id IN NUMBER Required
466 -- Id of document whose Contract Administrator is required
467 -- : p_doc_type IN VARCHAR2 Required
468 -- Type of document whose Contract Administrator is required
469 --OUT : x_new_con_admin_user_id OUT NUMBER
470 -- New Contract Administrator id
471 -- : x_return_status OUT VARCHAR2(1)
472 -- : x_msg_count OUT NUMBER
473 -- : x_msg_data OUT VARCHAR2(2000)
474 --Note :
475 -- End of comments
476 PROCEDURE get_sales_group_con_admin(
477 p_api_version IN NUMBER,
478 p_init_msg_list IN VARCHAR2,
479 p_doc_id IN NUMBER,
480 p_doc_type IN VARCHAR2,
481 x_new_con_admin_user_id OUT NOCOPY NUMBER,
482 x_return_status OUT NOCOPY VARCHAR2,
483 x_msg_count OUT NOCOPY NUMBER,
484 x_msg_data OUT NOCOPY VARCHAR2
485 );
486
487 FUNCTION has_uploaded_terms(
488 p_document_type IN VARCHAR2,
489 p_document_id IN NUMBER)
490 RETURN Varchar2;
491
492 FUNCTION is_terms_locked(
493 p_document_type IN VARCHAR2,
494 p_document_id IN NUMBER)
495 RETURN Varchar2;
496
497 FUNCTION get_layout_template_code(
498 p_doc_type IN VARCHAR2,
499 p_doc_type_class IN VARCHAR2,
500 p_doc_id IN NUMBER,
501 p_org_id IN NUMBER)
502 RETURN Varchar2;
503
504 --For R12: MSWord2WaySync
505 PROCEDURE lock_contract(
506 p_api_version IN NUMBER,
507 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
508
509 p_commit IN Varchar2,
510 p_document_type IN VARCHAR2,
511 p_document_id IN NUMBER,
512 x_return_status OUT NOCOPY VARCHAR2,
513 x_msg_data OUT NOCOPY VARCHAR2,
514 x_msg_count OUT NOCOPY NUMBER
515 );
516
517 --For R12: MSWord2WaySync
521
518 PROCEDURE unlock_contract(
519 p_api_version IN NUMBER,
520 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
522 p_commit IN Varchar2,
523 p_document_type IN VARCHAR2,
524 p_document_id IN NUMBER,
525 x_return_status OUT NOCOPY VARCHAR2,
526 x_msg_data OUT NOCOPY VARCHAR2,
527 x_msg_count OUT NOCOPY NUMBER
528 );
529
530 PROCEDURE get_default_contract_admin(
531 p_api_version IN NUMBER,
532 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
533
534 p_document_type IN VARCHAR2,
535 p_document_id IN NUMBER,
536 x_has_default_contract_admin OUT NOCOPY VARCHAR2,
537 x_def_contract_admin_name OUT NOCOPY VARCHAR2,
538 x_def_contract_admin_id OUT NOCOPY NUMBER,
539 x_return_status OUT NOCOPY VARCHAR2,
540 x_msg_data OUT NOCOPY VARCHAR2,
541 x_msg_count OUT NOCOPY NUMBER
542
543 );
544 FUNCTION get_default_contract_admin_id(
545 p_document_type IN VARCHAR2,
546 p_document_id IN NUMBER)
547 RETURN NUMBER;
548
549 FUNCTION get_contract_admin_name(
550 p_contract_admin_id IN NUMBER)
551 RETURN VARCHAR2;
552
553 FUNCTION get_sys_last_upd_date(
554 p_document_type IN VARCHAR2,
555 p_document_id IN NUMBER)
556 RETURN DATE;
557
558 -- Fix for bug# 5235082. Changed parameter from p_article_id to p_id
559 FUNCTION get_revert_art_version_id(
560 p_id IN NUMBER,
561 p_document_type IN VARCHAR2,
562 p_document_id IN NUMBER ) RETURN NUMBER ;
563
564 --For R12.1: User defined variables with procedures
565 PROCEDURE set_udv_with_procedures (
566 p_api_version IN NUMBER,
567 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
568 p_document_type IN VARCHAR2,
569 p_document_id IN NUMBER,
570 p_output_error IN VARCHAR2 := FND_API.G_TRUE,
571 x_return_status OUT NOCOPY VARCHAR2,
572 x_msg_data OUT NOCOPY VARCHAR2,
573 x_msg_count OUT NOCOPY NUMBER
574 );
575
576 PROCEDURE get_udv_with_proc_value (
577 p_document_type IN VARCHAR2,
578 p_document_id IN NUMBER,
579 p_variable_code IN VARCHAR2,
580 p_output_error IN VARCHAR2 := FND_API.G_FALSE,
581 x_variable_value OUT NOCOPY VARCHAR2,
582 x_return_status OUT NOCOPY VARCHAR2,
583 x_msg_data OUT NOCOPY VARCHAR2,
584 x_msg_count OUT NOCOPY NUMBER
585 );
586
587 END OKC_TERMS_UTIL_PVT;