1 PACKAGE OKC_TERMS_UTIL_GRP AUTHID CURRENT_USER AS
2 /* $Header: OKCGDUTS.pls 120.3.12020000.6 2013/04/12 22:59:53 serukull ship $ */
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 -- Conc Mod Changes Start
94 ,p_retain_lock_terms_yn IN VARCHAR2 := 'N'
95 ,p_retain_lock_xprt_yn IN VARCHAR2 := 'N'
96 ,p_retain_lock_deliverables_yn IN VARCHAR2 := 'N'
97 -- For backward compatability retaining the following param
98 ,p_retain_deliverables_yn IN VARCHAR2 := 'N'
99 -- For backward compatability retaining the above param
100 ,P_RELEASE_LOCKS_YN IN VARCHAR2 := 'N'
101 -- Conc Mod Changes End
102 ,p_retain_exhibits IN VARCHAR2 :='N'
103 );
104
105 /*
106 -- To be used when doing bulk deletes of document.A very PO specific scenario.
107 */
108 PROCEDURE Purge_Doc (
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_tbl IN doc_tbl_type
118 );
119
120 /*
121 -- To be used in amend flow to mark articles as amended if any of system
122 -- variables used in article has been changed in source document during amendment.
123 */
124 PROCEDURE Mark_Variable_Based_Amendment (
125 p_api_version IN NUMBER,
126 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
127 p_commit IN VARCHAR2 := FND_API.G_FALSE,
128
129 x_return_status OUT NOCOPY VARCHAR2,
130 x_msg_data OUT NOCOPY VARCHAR2,
131 x_msg_count OUT NOCOPY NUMBER,
132
133 p_doc_type IN VARCHAR2,
134 p_doc_id IN NUMBER
135 );
136
137 /*
138 --To be used to find out if a document is using articles.If yes then what type.
139 --Possible return values NONE,ONLY_STANDARD_EXIST ,NON_STANDARD_EXIST .
140 */
141
142 FUNCTION Is_Article_Exist(
143 p_api_version IN NUMBER,
144 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145
146 x_return_status OUT NOCOPY VARCHAR2,
147 x_msg_data OUT NOCOPY VARCHAR2,
148 x_msg_count OUT NOCOPY NUMBER,
149
150 p_doc_type IN VARCHAR2,
151 p_doc_id IN NUMBER
152 ) RETURN VARCHAR2;
153
154 FUNCTION Is_Article_Exist(
155 p_doc_type IN VARCHAR2,
156 p_doc_id IN NUMBER
157 ) RETURN VARCHAR2;
158
159 /*
160 -- To be used to find out if Terms and deliverable has deviate any deviation as
161 -- compared to template that was used in the document.ocument has used.
162 -- Possible return values NO_CHANGE,ARTICLES_CHANGED,DELIVERABLES_CHANGED,
163 -- ARTICLES_AND_DELIVERABLES_CHANGED
164 */
165 FUNCTION Deviation_From_Standard(
166 p_api_version IN NUMBER,
167 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
168
169 x_return_status OUT NOCOPY VARCHAR2,
170 x_msg_data OUT NOCOPY VARCHAR2,
171 x_msg_count OUT NOCOPY NUMBER,
172
173 p_doc_type IN VARCHAR2,
174 p_doc_id IN NUMBER
175 ) RETURN VARCHAR2;
176
177 FUNCTION Deviation_From_Standard(
178 p_doc_type IN VARCHAR2,
179 p_doc_id IN NUMBER
180 ) RETURN VARCHAR2;
181 /*
182 --To be used to find out if template used in document has expired.Possible return values Y,N.
183 -- Possible return values are
184 -- FND_API.G_TRUE = Template expired
185 -- FND_API.G_FALSE = Template not expired.
186 */
187 FUNCTION Is_Template_Expired(
188 p_api_version IN NUMBER,
189 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
190
191 x_return_status OUT NOCOPY VARCHAR2,
192 x_msg_data OUT NOCOPY VARCHAR2,
193 x_msg_count OUT NOCOPY NUMBER,
194
195 p_doc_type IN VARCHAR2,
196 p_doc_id IN NUMBER
197 ) RETURN VARCHAR2;
198
199 /*
200 --To be used to find out if any deliverable exists on document.If Yes then what
201 -- type.Possible values NONE,ONLY_CONTRACTUAL,ONLY_INTERNAL,CONTRACTUAL_AND_INTERNAL
202 */
203
204 FUNCTION Is_Deliverable_Exist(
205 p_api_version IN NUMBER,
206 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
207
208 x_return_status OUT NOCOPY VARCHAR2,
209 x_msg_data OUT NOCOPY VARCHAR2,
210 x_msg_count OUT NOCOPY NUMBER,
211
212 p_doc_type IN VARCHAR2,
213 p_doc_id IN NUMBER
214 ) RETURN VARCHAR2;
215
216
217 /*
218 --To be used in amend flow to find out if any article is amended.If Yes then what
219 -- type of article is amended.Possible values NO_ARTICLE_AMENDED,ONLY_STANDARD_AMENDED ,NON_STANDARD_AMENDED
220 */
221
222 FUNCTION Is_Article_Amended(
223 p_api_version IN NUMBER,
224 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
225
226 x_return_status OUT NOCOPY VARCHAR2,
227 x_msg_data OUT NOCOPY VARCHAR2,
228 x_msg_count OUT NOCOPY NUMBER,
229
230 p_doc_type IN VARCHAR2,
231 p_doc_id IN NUMBER
232 ) RETURN VARCHAR2;
233
234 /*
235 -- To be used in amend flow to find out if any deliverable is amended.
236 -- If Yes then what type.Possible values
237 -- NONE,ONLY_CONTRACTUAL,ONLY_INTERNAL,CONTRACTUAL_AND_INTERNAL
238 */
239
240 FUNCTION Is_Deliverable_Amended(
241 p_api_version IN NUMBER,
242 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
243
244 x_return_status OUT NOCOPY VARCHAR2,
245 x_msg_data OUT NOCOPY VARCHAR2,
246 x_msg_count OUT NOCOPY NUMBER,
247
248 p_doc_type IN VARCHAR2,
249 p_doc_id IN NUMBER
250 ) RETURN VARCHAR2;
251
252 --This API is deprecated. Use GET_CONTRACT_DETAILS() instead.
253 PROCEDURE Get_Terms_Template(
254 p_api_version IN NUMBER,
255 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
256
257 x_return_status OUT NOCOPY VARCHAR2,
258 x_msg_data OUT NOCOPY VARCHAR2,
259 x_msg_count OUT NOCOPY NUMBER,
260
261 p_doc_type IN VARCHAR2,
262 p_doc_id IN NUMBER,
263 x_template_id OUT NOCOPY NUMBER,
264 x_template_name OUT NOCOPY VARCHAR2
265 );
266
267 /*
268 -- To be used to find out document type when document is of contract family.
269 */
270 FUNCTION Get_Contract_Document_Type(
271 p_api_version IN NUMBER,
272 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
273
274 x_return_status OUT NOCOPY VARCHAR2,
275 x_msg_data OUT NOCOPY VARCHAR2,
276 x_msg_count OUT NOCOPY NUMBER,
277
278 p_chr_id IN NUMBER
279 ) RETURN VARCHAR2;
280
281 PROCEDURE Get_Contract_Document_Type_ID(
282 p_api_version IN NUMBER,
283 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
284
285 x_return_status OUT NOCOPY VARCHAR2,
286 x_msg_data OUT NOCOPY VARCHAR2,
287 x_msg_count OUT NOCOPY NUMBER,
288
289 p_chr_id IN NUMBER,
290 x_doc_id OUT NOCOPY NUMBER,
291 x_doc_type OUT NOCOPY VARCHAR2
292 );
293 /*
294 -- To be used to find out document type when document is of contract family.
295 */
296 PROCEDURE Get_Last_Update_Date(
297 p_api_version IN NUMBER,
298 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
299
300 x_return_status OUT NOCOPY VARCHAR2,
301 x_msg_data OUT NOCOPY VARCHAR2,
302 x_msg_count OUT NOCOPY NUMBER,
303
304 p_doc_type IN VARCHAR2,
305 p_doc_id IN NUMBER,
306
307 x_deliverable_changed_date OUT NOCOPY DATE,
308 x_terms_changed_date OUT NOCOPY DATE
309 );
310
311 FUNCTION Ok_To_Commit (
312 p_api_version IN NUMBER,
313 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
314
315 x_return_status OUT NOCOPY VARCHAR2,
316 x_msg_data OUT NOCOPY VARCHAR2,
317 x_msg_count OUT NOCOPY NUMBER,
318
319 p_tmpl_change IN VARCHAR2 := NULL,
320 p_validation_string IN VARCHAR2 := NULL,
321 p_doc_type IN VARCHAR2,
322 p_doc_id IN NUMBER
323 ,p_del_commit_mode IN VARCHAR2 DEFAULT NULL
324 ) RETURN VARCHAR2;
325
326 FUNCTION is_manual_article_exist(
327 p_api_version IN NUMBER,
328 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
329
330 x_return_status OUT NOCOPY VARCHAR2,
331 x_msg_data OUT NOCOPY VARCHAR2,
332 x_msg_count OUT NOCOPY NUMBER,
333
334 p_doc_type IN VARCHAR2,
335 p_doc_id IN NUMBER
336 ) RETURN VARCHAR2;
337
338 FUNCTION Get_Template_Name(
339 p_api_version IN NUMBER,
340 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
341 p_template_id IN NUMBER,
342
343 x_return_status OUT NOCOPY VARCHAR2,
344 x_msg_data OUT NOCOPY VARCHAR2,
345 x_msg_count OUT NOCOPY NUMBER
346 ) RETURN VARCHAR2;
347
348 --This API is deprecated. Use GET_CONTRACT_DETAILS() instead.
349 Function Get_Terms_Template(
350 p_doc_type IN VARCHAR2,
351 p_doc_id IN NUMBER
352 ) Return varchar2;
353
354 PROCEDURE get_item_dtl_for_expert(
355 p_api_version IN NUMBER,
356 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
357
358 x_return_status OUT NOCOPY VARCHAR2,
359 x_msg_data OUT NOCOPY VARCHAR2,
360 x_msg_count OUT NOCOPY NUMBER,
361
362 p_doc_type IN VARCHAR2,
363 p_doc_id IN NUMBER,
364 x_category_tbl OUT NOCOPY item_tbl_type,
365 x_item_tbl OUT NOCOPY item_tbl_type
366 );
367
368 FUNCTION get_last_signed_revision(
369 p_doc_type IN VARCHAR2,
370 p_doc_id IN NUMBER,
371 p_revision_num IN NUMBER
372 ) RETURN NUMBER;
373
374 Procedure Get_Terms_Template_dtl(
375 p_template_id IN NUMBER,
376 p_template_rec OUT NOCOPY template_rec_type,
377 x_return_status OUT NOCOPY VARCHAR2,
378 x_msg_data OUT NOCOPY VARCHAR2,
379 x_msg_count OUT NOCOPY NUMBER
380 ) ;
381
382 FUNCTION empclob RETURN CLOB;
383 FUNCTION tempblob RETURN BLOB;
384
385 --This API is deprecated. Use GET_CONTRACT_DETAILS_ALL() instead.
386 Procedure Get_Terms_Template_dtl(
387 p_doc_id IN NUMBER,
388 p_doc_type IN VARCHAR,
389 x_template_id OUT NOCOPY NUMBER,
390 x_template_name OUT NOCOPY VARCHAR2,
391 x_template_description OUT NOCOPY VARCHAR2,
392 x_template_instruction OUT NOCOPY VARCHAR2,
393 x_return_status OUT NOCOPY VARCHAR2,
394 x_msg_data OUT NOCOPY VARCHAR2,
395 x_msg_count OUT NOCOPY NUMBER
396 ) ;
397
398
399 FUNCTION enable_update(
400 p_object_type IN VARCHAR2,
401 p_document_type IN VARCHAR2,
402 p_standard_yn IN VARCHAR2
403 ) RETURN VARCHAR2;
404
405 FUNCTION enable_update(
406 p_object_type IN VARCHAR2,
407 p_document_type IN VARCHAR2,
408 p_standard_yn IN VARCHAR2,
409 p_kart_sec_id in number
410 ) RETURN VARCHAR2;
411
412 /* FUNCTION enable_update(
413 p_object_type IN VARCHAR2,
414 p_document_type IN VARCHAR2,
415 p_standard_yn IN VARCHAR2,
416 p_kart_sec_id in NUMBER,
417 p_lockingEnabledYn IN VARCHAR2
418 ) RETURN VARCHAR2; */
419
420
421
422
423
424
425 FUNCTION enable_delete(
426 p_object_type IN VARCHAR2,
427 p_mandatory_yn IN VARCHAR2,
428 p_standard_yn IN VARCHAR2,
429 p_document_type IN VARCHAR2 := NULL
430 ) RETURN VARCHAR2;
431
432 FUNCTION enable_delete(
433 p_object_type IN VARCHAR2,
434 p_mandatory_yn IN VARCHAR2,
435 p_standard_yn IN VARCHAR2,
436 p_document_type IN VARCHAR2 := NULL ,
437 p_kart_sec_id in number
438 ) RETURN VARCHAR2;
439
440 /* FUNCTION enable_delete(
441 p_object_type IN VARCHAR2,
442 p_mandatory_yn IN VARCHAR2,
443 p_standard_yn IN VARCHAR2,
444 p_document_type IN VARCHAR2 := NULL ,
445 p_kart_sec_id in NUMBER,
446 p_lockingEnabledYn IN VARCHAR2
447 ) RETURN VARCHAR2; */
448
449
450
451 FUNCTION Is_Document_Updatable(
452 p_doc_type IN VARCHAR2,
453 p_doc_id IN NUMBER,
454 p_validation_string IN VARCHAR2
455 ) RETURN VARCHAR2; -- 'T' - updatable, 'F'- non-updatable, 'E' - error or doesn't exist
456
457
458 /* Following API's are added for 11.5.10+ projects*/
459
460
461 FUNCTION Is_Primary_Terms_Doc_Mergeable(
462 p_document_type IN VARCHAR2,
463 p_document_id IN NUMBER
464 ) RETURN VARCHAR2;
465
466 FUNCTION Get_Primary_Terms_Doc_File_Id(
467 p_document_type IN VARCHAR2,
468 p_document_id IN NUMBER
469 ) RETURN NUMBER;
470
471
472 FUNCTION Has_Terms(
473 p_document_type IN VARCHAR2,
474 p_document_id IN NUMBER
475 ) RETURN VARCHAR2;
476
477 Procedure Get_Contract_Details(
478 p_api_version IN NUMBER,
479 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
480
481 x_return_status OUT NOCOPY VARCHAR2,
482 x_msg_data OUT NOCOPY VARCHAR2,
483 x_msg_count OUT NOCOPY NUMBER,
484
485 p_document_type IN VARCHAR2,
486 p_document_id IN NUMBER,
487
488 x_authoring_party OUT NOCOPY VARCHAR2,
489 x_contract_source OUT NOCOPY VARCHAR2,
490 x_template_name OUT NOCOPY VARCHAR2,
491 x_template_description OUT NOCOPY VARCHAR2
492 );
493
494 Procedure Get_Contract_Details_All(
495 p_api_version IN NUMBER,
496 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
497
498 x_return_status OUT NOCOPY VARCHAR2,
499 x_msg_data OUT NOCOPY VARCHAR2,
500 x_msg_count OUT NOCOPY NUMBER,
501
502 p_document_type IN VARCHAR2,
503 p_document_id IN NUMBER,
504 p_document_version IN NUMBER := NULL,
505
506 x_has_terms OUT NOCOPY VARCHAR2,
507 x_authoring_party_code OUT NOCOPY VARCHAR2,
508 x_authoring_party OUT NOCOPY VARCHAR2,
509 x_contract_source_code OUT NOCOPY VARCHAR2,
510 x_contract_source OUT NOCOPY VARCHAR2,
511 x_template_id OUT NOCOPY NUMBER,
512 x_template_name OUT NOCOPY VARCHAR2,
513 x_template_description OUT NOCOPY VARCHAR2,
514 x_template_instruction OUT NOCOPY VARCHAR2,
515 x_has_primary_doc OUT NOCOPY VARCHAR2,
516 x_is_primary_doc_mergeable OUT NOCOPY VARCHAR2,
517 x_primary_doc_file_id OUT NOCOPY VARCHAR2
518
519 );
520
521 FUNCTION Get_Authoring_Party_Code(
522 p_document_type IN VARCHAR2,
523 p_document_id IN NUMBER
524 ) RETURN VARCHAR2;
525
526 FUNCTION Get_Contract_Source_Code(
527 p_document_type IN VARCHAR2,
528 p_document_id IN NUMBER
529 ) RETURN VARCHAR2;
530
531 FUNCTION Has_Valid_Terms(
532 p_document_type IN VARCHAR2,
533 p_document_id IN NUMBER
534 ) RETURN VARCHAR2;
535
536 FUNCTION Is_Terms_Template_Valid(
537 p_api_version IN NUMBER,
538 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
539
540 x_return_status OUT NOCOPY VARCHAR2,
541 x_msg_data OUT NOCOPY VARCHAR2,
542 x_msg_count OUT NOCOPY NUMBER,
543
544 p_template_id IN NUMBER,
545 p_doc_type IN VARCHAR2,
546 p_org_id IN NUMBER,
547 p_valid_date IN DATE DEFAULT SYSDATE
548 ) RETURN VARCHAR2;
549
550 PROCEDURE Get_Contract_Defaults(
551 p_api_version IN NUMBER,
552 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
553
554 x_return_status OUT NOCOPY VARCHAR2,
555 x_msg_data OUT NOCOPY VARCHAR2,
556 x_msg_count OUT NOCOPY NUMBER,
557
558 p_template_id IN VARCHAR2,
559 p_document_type IN VARCHAR2,
560
561 x_authoring_party OUT NOCOPY VARCHAR2,
562 x_contract_source OUT NOCOPY VARCHAR2,
563 x_template_name OUT NOCOPY VARCHAR2,
564 x_template_description OUT NOCOPY VARCHAR2
565 );
566
567 PROCEDURE Get_Default_Template(
568 p_api_version IN NUMBER,
569 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
570
571 x_return_status OUT NOCOPY VARCHAR2,
572 x_msg_data OUT NOCOPY VARCHAR2,
573 x_msg_count OUT NOCOPY NUMBER,
574
575 p_document_type IN VARCHAR2,
576 p_org_id IN NUMBER DEFAULT NULL,
577 p_valid_date IN DATE DEFAULT SYSDATE,
578
579 x_template_id OUT NOCOPY NUMBER,
580 x_template_name OUT NOCOPY VARCHAR2,
581 x_template_description OUT NOCOPY VARCHAR2);
582
583 FUNCTION Auto_Generate_Deviations(
584 p_document_type IN VARCHAR2,
585 p_document_id IN NUMBER
586 ) RETURN VARCHAR2;
587
588
589 FUNCTION Get_Deviations_File_Id(
590 p_document_type IN VARCHAR2,
591 p_document_id IN NUMBER
592 ) RETURN VARCHAR2;
593
594 PROCEDURE Has_Uploaded_Deviations_Doc(
595 p_api_version IN NUMBER,
596 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
597
598 x_return_status OUT NOCOPY VARCHAR2,
599 x_msg_data OUT NOCOPY VARCHAR2,
600 x_msg_count OUT NOCOPY NUMBER,
601
602 p_document_type IN VARCHAR2,
603 p_document_Id IN NUMBER,
604 x_contract_source OUT NOCOPY VARCHAR2,
605 x_has_deviation_report OUT NOCOPY VARCHAR2
606 );
607
608 FUNCTION is_Deviations_enabled(
609 p_document_type IN VARCHAR2,
610 p_document_id IN NUMBER
611 ) RETURN VARCHAR2;
612
613 FUNCTION Contract_Terms_Amended(
614 p_api_version IN NUMBER,
615 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
616
617 x_return_status OUT NOCOPY VARCHAR2,
618 x_msg_data OUT NOCOPY VARCHAR2,
619 x_msg_count OUT NOCOPY NUMBER,
620
621 p_doc_type IN VARCHAR2,
622 p_doc_id IN NUMBER
623 ) RETURN VARCHAR2;
624
625 --For Multi language support
626 PROCEDURE get_translated_template(
627 p_api_version IN NUMBER,
628 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
629
633 p_validity_date IN DATE := SYSDATE,
630 p_template_id IN NUMBER,
631 p_language IN VARCHAR2,
632 p_document_type IN VARCHAR2,
634
635 x_return_status OUT NOCOPY VARCHAR2,
636 x_msg_data OUT NOCOPY VARCHAR2,
637 x_msg_count OUT NOCOPY NUMBER,
638
639 x_template_id OUT NOCOPY NUMBER
640 );
641
642 FUNCTION Has_deliverables(
643 p_document_type IN VARCHAR2,
644 p_document_id IN NUMBER,
645 p_doc_version IN NUMBER DEFAULT NULL
646 ) RETURN VARCHAR2;
647
648
649 END OKC_TERMS_UTIL_GRP;