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