1 PACKAGE OKC_REP_CONTRACT_PROCESS_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCVREPPROCSS.pls 120.2.12020000.6 2013/03/15 02:26:01 kkolukul ship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL CONSTANTS
6 ---------------------------------------------------------------------------
7 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_REP_CONTRACT_PROCESS_PVT';
8 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKC';
9 G_MODULE CONSTANT VARCHAR2(250) := 'okc.plsql.'||G_PKG_NAME||'.';
10 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
11 G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
12 G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
13 G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
14 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
15
16 -- Contract Statuses
17 G_STATUS_PENDING_APPROVAL CONSTANT VARCHAR2(30) := 'PENDING_APPROVAL';
18 G_STATUS_PENDING_SIGNATURE CONSTANT VARCHAR2(30) := 'PENDING_SIGNATURE';
19
20 G_STATUS_SIGNED CONSTANT VARCHAR2(30) := 'SIGNED';
21 G_STATUS_TERMINATED CONSTANT VARCHAR2(30) := 'TERMINATED';
22 G_STATUS_DRAFT CONSTANT VARCHAR2(30) := 'DRAFT';
23 G_ACTION_SUBMITTED CONSTANT VARCHAR2(30) := 'SUBMITTED';
24 G_ACTION_ABORTED CONSTANT VARCHAR2(30) := 'ABORTED';
25
26 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
27 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
28 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
29
30 G_APPROVAL_ITEM_TYPE CONSTANT VARCHAR2(200) := 'OKCREPMA';
31 G_APP_ITEM_TYPE_2579 CONSTANT VARCHAR2(200) := 'OKCREPAW';
32
33 G_APPROVAL_PROCESS CONSTANT VARCHAR2(200) := 'REP_CONTRACT_APPROVAL';
34 G_APPLICATION_ID CONSTANT NUMBER := 510;
35
36 G_TRANSACTION_TYPE CONSTANT VARCHAR2(200) := 'OKC_REP_CON_APPROVAL';
37
38 G_SIGNATURE_ITEM_TYPE CONSTANT VARCHAR2(200) := 'OKCREPMS';
39 G_SIGNATURE_PROCESS CONSTANT VARCHAR2(200) := 'REP_CONTRACT_SIGNATURE_PROCESS';
40
41 G_SIG_ITEM_TYPE_2579 CONSTANT VARCHAR2(200) := 'OKCREPSW';
42
43
44 -- Required for Contract not found error message
45 G_INVALID_CONTRACT_ID_MSG CONSTANT VARCHAR2(200) := 'OKC_REP_INVALID_CONTRACT_ID';
46 G_CANEL_APPROVAL_ERROR_MSG CONSTANT VARCHAR2(200) := 'OKC_REP_CANCEL_APPROVAL_ERROR';
47
48 G_CONTRACT_ID_TOKEN CONSTANT VARCHAR2(200) := 'CONTRACT_ID';
49 G_CONTRACT_NUM_TOKEN CONSTANT VARCHAR2(200) := 'CONTRACT_NUM';
50
51 G_INTERNAL_ORG CONSTANT VARCHAR2(200) := 'INTERNAL_ORG';
52
53 G_CONTRACT_BOOKMARK_TYPE CONSTANT VARCHAR2(200) := 'CONTRACT';
54
55 -- Contract events - deliverables integration
56 G_CONTRACT_EXPIRE_EVENT CONSTANT VARCHAR2(200) := 'CONTRACT_EXPIRE';
57 G_CONTRACT_EFFECTIVE_EVENT CONSTANT VARCHAR2(200) := 'CONTRACT_EFFECTIVE';
58 G_CONTRACT_TERMINATED_EVENT CONSTANT VARCHAR2(200) := 'CONTRACT_TERMINATED';
59
60 -- Current version number for documents and deliverables
61 G_CURRENT_VERSION CONSTANT NUMBER := -99;
62
63 -- Contracts business events codes TBL Type
64 SUBTYPE EVENT_TBL_TYPE IS OKC_MANAGE_DELIVERABLES_GRP.BUSDOCDATES_TBL_TYPE;
65
66 G_INVALID_CONTRACT_NUMBER_MSG CONSTANT VARCHAR2(200) := 'OKC_REP_INV_CON_NUMBER';
67 ------------------------------------------------------------------------------
68 -- GLOBAL EXCEPTION
69 ------------------------------------------------------------------------------
70 E_Resource_Busy EXCEPTION;
71 PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
72
73 ---------------------------------------------------------------------------
74 -- Procedures and Functions
75 ---------------------------------------------------------------------------
76
77 -- Start of comments
78 --API name : submit_contract_for_approval
79 --Type : Private.
80 --Function : Submits contract for approval
81 --Pre-reqs : None.
82 --Parameters :
83 --IN : p_api_version IN NUMBER Required
84 -- : p_init_msg_list IN VARCHAR2 Optional
85 -- Default = FND_API.G_FALSE
86 -- : p_contract_id IN NUMBER Required
87 -- Contract ID of the contract to be submitted for approval
88 -- : p_contract_version IN NUMBER Required
89 -- Contract Version of the contract to be submitted for approval
90 --OUT : x_return_status OUT VARCHAR2(1)
91 -- : x_msg_count OUT NUMBER
92 -- : x_msg_data OUT VARCHAR2(2000)
93 --Note :
94 -- End of comments
95 PROCEDURE submit_contract_for_approval(
96 p_api_version IN NUMBER,
97 p_init_msg_list IN VARCHAR2,
98 p_contract_id IN NUMBER,
99 p_contract_version IN NUMBER,
100 x_return_status OUT NOCOPY VARCHAR2,
101 x_msg_count OUT NOCOPY NUMBER,
102 x_msg_data OUT NOCOPY VARCHAR2
103 );
104
105 -- Start of comments
106 --API name : delete_contacts
107 --Type : Private.
108 --Function : Deletes party contacts of a particular Contract
109 --Pre-reqs : None.
110 --Parameters :
111 --IN : p_api_version IN NUMBER Required
112 -- : p_init_msg_list IN VARCHAR2 Optional
113 -- Default = FND_API.G_FALSE
114 -- : p_commit IN VARCHAR2 Optional
115 -- Default = FND_API.G_FALSE
116 -- : p_contract_id IN NUMBER Required
117 -- Contract ID of the contract whose contacts are to be deleted
118 --OUT : x_return_status OUT VARCHAR2(1)
119 -- : x_msg_count OUT NUMBER
120 -- : x_msg_data OUT VARCHAR2(2000)
121 --Note :
122 -- End of comments
123 PROCEDURE delete_contacts(
124 p_api_version IN NUMBER,
125 p_init_msg_list IN VARCHAR2,
126 p_commit IN VARCHAR2,
127 p_contract_id IN NUMBER,
128 x_msg_data OUT NOCOPY VARCHAR2,
129 x_msg_count OUT NOCOPY NUMBER,
130 x_return_status OUT NOCOPY VARCHAR2);
131
132 -- Start of comments
133 --API name : delete_parties
134 --Type : Private.
135 --Function : Deletes parties of a particular Contract
136 --Pre-reqs : None.
137 --Parameters :
138 --IN : p_api_version IN NUMBER Required
139 -- : p_init_msg_list IN VARCHAR2 Optional
140 -- Default = FND_API.G_FALSE
141 -- : p_commit IN VARCHAR2 Optional
142 -- Default = FND_API.G_FALSE
143 -- : p_contract_id IN NUMBER Required
144 -- Contract ID of the contract whose parties are to be deleted
145 --OUT : x_return_status OUT VARCHAR2(1)
146 -- : x_msg_count OUT NUMBER
147 -- : x_msg_data OUT VARCHAR2(2000)
148 --Note :
149 -- End of comments
150 PROCEDURE delete_parties(
151 p_api_version IN NUMBER,
152 p_init_msg_list IN VARCHAR2,
153 p_commit IN VARCHAR2,
154 p_contract_id IN NUMBER,
155 x_msg_data OUT NOCOPY VARCHAR2,
156 x_msg_count OUT NOCOPY NUMBER,
157 x_return_status OUT NOCOPY VARCHAR2);
158
159
160 -- Start of comments
161 --API name : delete_risks
162 --Type : Private.
163 --Function : Deletes risks of a particular Contract
164 --Pre-reqs : None.
165 --Parameters :
166 --IN : p_api_version IN NUMBER Required
167 -- : p_init_msg_list IN VARCHAR2 Optional
168 -- Default = FND_API.G_FALSE
169 -- : p_commit IN VARCHAR2 Optional
170 -- Default = FND_API.G_FALSE
171 -- : p_contract_id IN NUMBER Required
172 -- Contract ID of the contract whose risks are to be deleted
173 --OUT : x_return_status OUT VARCHAR2(1)
174 -- : x_msg_count OUT NUMBER
175 -- : x_msg_data OUT VARCHAR2(2000)
176 --Note :
177 -- End of comments
178 PROCEDURE delete_risks(
179 p_api_version IN NUMBER,
180 p_init_msg_list IN VARCHAR2,
181 p_commit IN VARCHAR2,
182 p_contract_id IN NUMBER,
183 x_msg_data OUT NOCOPY VARCHAR2,
184 x_msg_count OUT NOCOPY NUMBER,
185 x_return_status OUT NOCOPY VARCHAR2);
186
187 -- Start of comments
188 --API name : delete_related_contracts
189 --Type : Private.
190 --Function : Deletes related contracts of a particular Contract
191 --Pre-reqs : None.
192 --Parameters :
193 --IN : p_api_version IN NUMBER Required
194 -- : p_init_msg_list IN VARCHAR2 Optional
195 -- Default = FND_API.G_FALSE
196 -- : p_commit IN VARCHAR2 Optional
197 -- Default = FND_API.G_FALSE
198 -- : p_contract_id IN NUMBER Required
199 -- Contract ID of the contract whose related contracts are to be deleted
200 --OUT : x_return_status OUT VARCHAR2(1)
201 -- : x_msg_count OUT NUMBER
202 -- : x_msg_data OUT VARCHAR2(2000)
203 --Note :
204 -- End of comments
205 PROCEDURE delete_related_contracts(
206 p_api_version IN NUMBER,
207 p_init_msg_list IN VARCHAR2,
208 p_commit IN VARCHAR2,
209 p_contract_id IN NUMBER,
210 x_msg_data OUT NOCOPY VARCHAR2,
211 x_msg_count OUT NOCOPY NUMBER,
212 x_return_status OUT NOCOPY VARCHAR2);
213
214 -- Start of comments
215 --API name : delete_ACL
216 --Type : Private.
217 --Function : Deletes parties of a particular Contract
218 --Pre-reqs : None.
219 --Parameters :
220 --IN : p_api_version IN NUMBER Required
221 -- : p_init_msg_list IN VARCHAR2 Optional
222 -- Default = FND_API.G_FALSE
223 -- : p_commit IN VARCHAR2 Optional
224 -- Default = FND_API.G_FALSE
225 -- : p_contract_id IN NUMBER Required
226 -- Contract ID of the contract whose ACL is to be deleted
227 --OUT : x_return_status OUT VARCHAR2(1)
228 -- : x_msg_count OUT NUMBER
229 -- : x_msg_data OUT VARCHAR2(2000)
230 --Note :
231 -- End of comments
232 PROCEDURE delete_ACL(
233 p_api_version IN NUMBER,
234 p_init_msg_list IN VARCHAR2,
235 p_commit IN VARCHAR2,
236 p_contract_id IN NUMBER,
237 x_msg_data OUT NOCOPY VARCHAR2,
238 x_msg_count OUT NOCOPY NUMBER,
239 x_return_status OUT NOCOPY VARCHAR2);
240
241
242 -- Start of comments
243 --API name : delete_status_history
244 --Type : Private.
245 --Function : Deletes status history records of a contract version
246 --Pre-reqs : None.
247 --Parameters :
248 --IN : p_api_version IN NUMBER Required
249 -- : p_init_msg_list IN VARCHAR2 Optional
250 -- Default = FND_API.G_FALSE
251 -- : p_commit IN VARCHAR2 Optional
252 -- Default = FND_API.G_FALSE
253 -- : p_contract_id IN NUMBER Required
254 -- Contract ID of the contract whose status history is to be deleted
255 -- : p_contract_version IN NUMBER Required
256 -- Contract version of the contract whose status history is to be deleted
257 --OUT : x_return_status OUT VARCHAR2(1)
258 -- : x_msg_count OUT NUMBER
259 -- : x_msg_data OUT VARCHAR2(2000)
260 --Note :
261 -- End of comments
262 PROCEDURE delete_status_history(
263 p_api_version IN NUMBER,
264 p_init_msg_list IN VARCHAR2,
265 p_commit IN VARCHAR2,
266 p_contract_id IN NUMBER,
267 p_contract_version IN NUMBER,
268 x_msg_data OUT NOCOPY VARCHAR2,
269 x_msg_count OUT NOCOPY NUMBER,
270 x_return_status OUT NOCOPY VARCHAR2);
271
272 -- Start of comments
273 --API name : delete_approval_history
274 --Type : Private.
275 --Function : Deletes contract approval history records of a contract version
276 --Pre-reqs : None.
277 --Parameters :
278 --IN : p_api_version IN NUMBER Required
279 -- : p_init_msg_list IN VARCHAR2 Optional
280 -- Default = FND_API.G_FALSE
281 -- : p_commit IN VARCHAR2 Optional
282 -- Default = FND_API.G_FALSE
283 -- : p_contract_id IN NUMBER Required
284 -- Contract ID of the contract whose approval history is to be deleted
285 -- : p_contract_version IN NUMBER Required
286 -- Contract version of the contract whose approval history is to be deleted
287 --OUT : x_return_status OUT VARCHAR2(1)
288 -- : x_msg_count OUT NUMBER
289 -- : x_msg_data OUT VARCHAR2(2000)
290 --Note :
291 -- End of comments
292 PROCEDURE delete_approval_history(
293 p_api_version IN NUMBER,
294 p_init_msg_list IN VARCHAR2,
295 p_commit IN VARCHAR2,
296 p_contract_id IN NUMBER,
297 p_contract_version IN NUMBER,
298 x_msg_data OUT NOCOPY VARCHAR2,
299 x_msg_count OUT NOCOPY NUMBER,
300 x_return_status OUT NOCOPY VARCHAR2);
301
302 -- Start of comments
303 --API name : delete_bookmarks
304 --Type : Private.
305 --Function : Deletes bookmarks for a given contract
306 --Pre-reqs : None.
307 --Parameters :
308 --IN : p_api_version IN NUMBER Required
309 -- : p_init_msg_list IN VARCHAR2 Optional
310 -- Default = FND_API.G_FALSE
311 -- : p_commit IN VARCHAR2 Optional
312 -- Default = FND_API.G_FALSE
313 -- : p_contract_type IN VARCHAR2 Required
314 -- Contract Type of the contract whose bookmarks are to be deleted
315 -- : p_contract_id IN NUMBER Required
316 -- Contract ID of the contract whose bookmarks are is to be deleted
317 --OUT : x_return_status OUT VARCHAR2(1)
318 -- : x_msg_count OUT NUMBER
319 -- : x_msg_data OUT VARCHAR2(2000)
320 --Note :
321 -- End of comments
322 PROCEDURE delete_bookmarks(
323 p_api_version IN NUMBER,
324 p_init_msg_list IN VARCHAR2,
325 p_commit IN VARCHAR2,
326 p_contract_type IN VARCHAR2,
327 p_contract_id IN NUMBER,
328 x_msg_data OUT NOCOPY VARCHAR2,
329 x_msg_count OUT NOCOPY NUMBER,
330 x_return_status OUT NOCOPY VARCHAR2);
331
332 -- Start of comments
333 --API name : lock_contract_header
334 --Type : Private.
335 --Function : Locks a row in OKC_REP_CONTRACTS_ALL table
336 --Pre-reqs : None.
337 --Parameters :
338 --IN : p_contract_id IN NUMBER Required
339 -- Contract ID of the contract to be locked.
340 -- : p_object_version_number IN NUMBER Required
341 -- Object version number of the contract to be locked
342 --OUT : x_return_status OUT VARCHAR2(1)
343 -- : x_msg_count OUT NUMBER
344 -- : x_msg_data OUT VARCHAR2(2000)
345 --Note :
346 -- End of comments
347 PROCEDURE lock_contract_header(
348 p_contract_id IN NUMBER,
349 p_object_version_number IN NUMBER,
350 x_return_status OUT NOCOPY VARCHAR2
351 );
352
353 -- Start of comments
354 --API name : delete_contract
355 --Type : Private.
356 --Function : Deletes a Contract
357 --Pre-reqs : None.
358 --Parameters :
359 --IN : p_api_version IN NUMBER Required
360 -- : p_init_msg_list IN VARCHAR2 Optional
361 -- Default = FND_API.G_FALSE
362 -- : p_commit IN VARCHAR2 Optional
363 -- Default = FND_API.G_FALSE
364 -- : p_contract_id IN NUMBER Required
365 -- Contract ID of the contract to be deleted
366 --OUT : x_return_status OUT VARCHAR2(1)
367 -- : x_msg_count OUT NUMBER
368 -- : x_msg_data OUT VARCHAR2(2000)
369 --Note :
370 -- End of comments
371 PROCEDURE delete_contract(
372 p_api_version IN NUMBER,
373 p_init_msg_list IN VARCHAR2,
374 p_commit IN VARCHAR2,
375 p_contract_id IN NUMBER,
376 x_msg_data OUT NOCOPY VARCHAR2,
377 x_msg_count OUT NOCOPY NUMBER,
378 x_return_status OUT NOCOPY VARCHAR2);
379
380
381 -- Start of comments
382 --API name : copy_contacts
383 --Type : Private.
384 --Function : Copies party contacts of source contract to target contract
385 --Pre-reqs : None.
386 --Parameters :
387 --IN : p_api_version IN NUMBER Required
388 -- : p_init_msg_list IN VARCHAR2 Optional
389 -- Default = FND_API.G_FALSE
390 -- : p_commit IN VARCHAR2 Optional
391 -- Default = FND_API.G_FALSE
392 -- : p_source_contract_id IN NUMBER Required
393 -- Id of the contract whose contacts are to be copied
394 -- : p_target_contract_id IN NUMBER Required
395 -- Id of the contract to which source contacts are to be copied
396 --OUT : x_return_status OUT VARCHAR2(1)
397 -- : x_msg_count OUT NUMBER
398 -- : x_msg_data OUT VARCHAR2(2000)
399 --Note :
400 -- End of comments
401 PROCEDURE copy_contacts(
402 p_api_version IN NUMBER,
403 p_init_msg_list IN VARCHAR2,
404 p_commit IN VARCHAR2,
405 p_source_contract_id IN NUMBER,
406 p_target_contract_id IN NUMBER,
407 x_msg_data OUT NOCOPY VARCHAR2,
408 x_msg_count OUT NOCOPY NUMBER,
409 x_return_status OUT NOCOPY VARCHAR2);
410
411 -- Start of comments
412 --API name : copy_parties
413 --Type : Private.
414 --Function : Copies parties of source contract to target contract
415 --Pre-reqs : None.
416 --Parameters :
417 --IN : p_api_version IN NUMBER Required
418 -- : p_init_msg_list IN VARCHAR2 Optional
419 -- Default = FND_API.G_FALSE
420 -- : p_commit IN VARCHAR2 Optional
421 -- Default = FND_API.G_FALSE
422 -- : p_source_contract_id IN NUMBER Required
423 -- Id of the contract whose parties are to be copied
424 -- : p_target_contract_id IN NUMBER Required
425 -- Id of the contract to which source parties are to be copied
426 --OUT : x_return_status OUT VARCHAR2(1)
427 -- : x_msg_count OUT NUMBER
428 -- : x_msg_data OUT VARCHAR2(2000)
429 --Note :
430 -- End of comments
431 PROCEDURE copy_parties(
432 p_api_version IN NUMBER,
433 p_init_msg_list IN VARCHAR2,
434 p_commit IN VARCHAR2,
435 p_source_contract_id IN NUMBER,
436 p_target_contract_id IN NUMBER,
437 x_msg_data OUT NOCOPY VARCHAR2,
438 x_msg_count OUT NOCOPY NUMBER,
439 x_return_status OUT NOCOPY VARCHAR2);
440
441
442 -- Start of comments
443 --API name : copy_risks
444 --Type : Private.
445 --Function : Copies risks of source contract to target contract
446 --Pre-reqs : None.
447 --Parameters :
448 --IN : p_api_version IN NUMBER Required
449 -- : p_init_msg_list IN VARCHAR2 Optional
450 -- Default = FND_API.G_FALSE
451 -- : p_commit IN VARCHAR2 Optional
452 -- Default = FND_API.G_FALSE
453 -- : p_source_contract_id IN NUMBER Required
454 -- Id of the contract whose risks are to be copied
455 -- : p_target_contract_id IN NUMBER Required
456 -- Id of the contract to which source contract risks are to be copied
457 --OUT : x_return_status OUT VARCHAR2(1)
458 -- : x_msg_count OUT NUMBER
459 -- : x_msg_data OUT VARCHAR2(2000)
460 --Note :
461 -- End of comments
462 PROCEDURE copy_risks(
463 p_api_version IN NUMBER,
464 p_init_msg_list IN VARCHAR2,
465 p_commit IN VARCHAR2,
466 p_source_contract_id IN NUMBER,
467 p_target_contract_id IN NUMBER,
468 x_msg_data OUT NOCOPY VARCHAR2,
469 x_msg_count OUT NOCOPY NUMBER,
470 x_return_status OUT NOCOPY VARCHAR2);
471
472 -- Start of comments
473 --API name : copy_ACL
474 --Type : Private.
475 --Function : Copies ACL records from source contract to target contract
476 --Pre-reqs : None.
477 --Parameters :
478 --IN : p_api_version IN NUMBER Required
479 -- : p_init_msg_list IN VARCHAR2 Optional
480 -- Default = FND_API.G_FALSE
481 -- : p_commit IN VARCHAR2 Optional
482 -- Default = FND_API.G_FALSE
483 -- : p_source_contract_id IN NUMBER Required
484 -- Id of the contract whose ACLs are to be copied
485 -- : p_target_contract_id IN NUMBER Required
486 -- Id of the contract to which source contract ACL are to be copied
487 --OUT : x_return_status OUT VARCHAR2(1)
488 -- : x_msg_count OUT NUMBER
489 -- : x_msg_data OUT VARCHAR2(2000)
490 --Note :
491 -- End of comments
492 PROCEDURE copy_ACL(
493 p_api_version IN NUMBER,
494 p_init_msg_list IN VARCHAR2,
495 p_commit IN VARCHAR2,
496 p_source_contract_id IN NUMBER,
497 p_target_contract_id IN NUMBER,
498 x_msg_data OUT NOCOPY VARCHAR2,
499 x_msg_count OUT NOCOPY NUMBER,
500 x_return_status OUT NOCOPY VARCHAR2);
501
502 -- Start of comments
503 --API name : copy_contract_details
504 --Type : Private.
505 --Function : Copies contract details for duplication
506 --Pre-reqs : None.
507 --Parameters :
508 --IN : p_api_version IN NUMBER Required
509 -- : p_init_msg_list IN VARCHAR2 Optional
510 -- Default = FND_API.G_FALSE
511 -- : p_commit IN VARCHAR2 Optional
512 -- Default = FND_API.G_FALSE
513 -- : p_source_contract_id IN NUMBER Required
514 -- Id of the contract whose details are to be copied
515 -- : p_target_contract_id IN NUMBER Required
516 -- Id of the contract to which source contract details are to be copied
517 -- : p_target_contract_number IN VARCHAR2 Required
518 -- Number of the contract to which source contract details are to be copied
519 --OUT : x_return_status OUT VARCHAR2(1)
520 -- : x_msg_count OUT NUMBER
521 -- : x_msg_data OUT VARCHAR2(2000)
522 --Note :
523 -- End of comments
524 PROCEDURE copy_contract_details(
525 p_api_version IN NUMBER,
526 p_init_msg_list IN VARCHAR2,
527 p_commit IN VARCHAR2,
528 p_source_contract_id IN NUMBER,
529 p_target_contract_id IN NUMBER,
530 p_target_contract_number IN VARCHAR2,
531 x_msg_data OUT NOCOPY VARCHAR2,
532 x_msg_count OUT NOCOPY NUMBER,
533 x_return_status OUT NOCOPY VARCHAR2);
534
535
536 -- Start of comments
537 --API name : version_contract_details
538 --Type : Private.
539 --Function : Copies deliverables and documents for versioning
540 --Pre-reqs : None.
541 --Parameters :
542 --IN : p_api_version IN NUMBER Required
543 -- : p_init_msg_list IN VARCHAR2 Optional
544 -- Default = FND_API.G_FALSE
545 -- : p_commit IN VARCHAR2 Optional
546 -- Default = FND_API.G_FALSE
547 -- : p_contract_id IN NUMBER Required
548 -- Id of the contract whose details are to be versioned
549 --OUT : x_return_status OUT VARCHAR2(1)
550 -- : x_msg_count OUT NUMBER
551 -- : x_msg_data OUT VARCHAR2(2000)
552 --Note :
553 -- End of comments
554 PROCEDURE version_contract_details(
555 p_api_version IN NUMBER,
556 p_init_msg_list IN VARCHAR2,
557 p_commit IN VARCHAR2,
558 p_contract_id IN NUMBER,
559 p_version_from_api IN VARCHAR2 DEFAULT fnd_api.g_false,
560 x_msg_data OUT NOCOPY VARCHAR2,
561 x_msg_count OUT NOCOPY NUMBER,
562 x_return_status OUT NOCOPY VARCHAR2);
563
564
565
566
567 -- Start of comments
568 --API name : sign_contract
569 --Type : Private.
570 --Function : Changes contract status to SIGNED and calls delivarables
571 -- API to activate deliverables of that contract
572 --Pre-reqs : None.
573 --Parameters :
574 --IN : p_api_version IN NUMBER Required
575 -- : p_init_msg_list IN VARCHAR2 Optional
576 -- Default = FND_API.G_FALSE
577 -- : p_commit IN VARCHAR2 Optional
578 -- Default = FND_API.G_FALSE
579 -- : p_contract_id IN NUMBER Required
580 -- Id of the contract to be signed
581 --OUT : x_return_status OUT VARCHAR2(1)
582 -- : x_msg_count OUT NUMBER
583 -- : x_msg_data OUT VARCHAR2(2000)
584 --Note :
585 -- End of comments
586 PROCEDURE sign_contract(
587 p_api_version IN NUMBER,
588 p_init_msg_list IN VARCHAR2,
589 p_commit IN VARCHAR2,
590 p_contract_id IN NUMBER,
591 x_msg_data OUT NOCOPY VARCHAR2,
592 x_msg_count OUT NOCOPY NUMBER,
593 x_return_status OUT NOCOPY VARCHAR2);
594
595 -- Start of comments
596 --API name : Esign_contract
597 --Type : Private.
598 --Function : Launches the E Signature Workflow
599 --Pre-reqs : None.
600 --Parameters :
601 --IN : p_api_version IN NUMBER Required
602 -- : p_init_msg_list IN VARCHAR2 Optional
603 -- Default = FND_API.G_FALSE
604 -- : p_commit IN VARCHAR2 Optional
605 -- Default = FND_API.G_FALSE
606 -- : p_contract_id IN NUMBER Required
607 -- Id of the contract to be signed
608 --OUT : x_return_status OUT VARCHAR2(1)
609 -- : x_msg_count OUT NUMBER
610 -- : x_msg_data OUT VARCHAR2(2000)
611 --Note :
612 -- End of comments
613 PROCEDURE Esign_contract(
614 p_api_version IN NUMBER,
615 p_init_msg_list IN VARCHAR2,
616 p_commit IN VARCHAR2,
617 p_contract_id IN NUMBER,
618 x_msg_data OUT NOCOPY VARCHAR2,
619 x_msg_count OUT NOCOPY NUMBER,
620 x_return_status OUT NOCOPY VARCHAR2);
621
622 -- Start of comments
623 --API name : terminate_contract
624 --Type : Private.
625 --Function : Changes contract status to TERMINATED and calls delivarables
626 -- API to cancel deliverables of that contract
627 --Pre-reqs : None.
628 --Parameters :
629 --IN : p_api_version IN NUMBER Required
630 -- : p_init_msg_list IN VARCHAR2 Optional
631 -- Default = FND_API.G_FALSE
632 -- : p_commit IN VARCHAR2 Optional
633 -- Default = FND_API.G_FALSE
634 -- : p_contract_id IN NUMBER Required
635 -- Id of the contract to be terminated
636 -- : p_termination_date IN DATE Required
637 -- Date the contract is terminated
638 --OUT : x_return_status OUT VARCHAR2(1)
639 -- : x_msg_count OUT NUMBER
640 -- : x_msg_data OUT VARCHAR2(2000)
641 --Note :
642 -- End of comments
643 PROCEDURE terminate_contract(
644 p_api_version IN NUMBER,
645 p_init_msg_list IN VARCHAR2,
646 p_commit IN VARCHAR2,
647 p_contract_id IN NUMBER,
648 p_termination_date IN DATE,
649 x_msg_data OUT NOCOPY VARCHAR2,
650 x_msg_count OUT NOCOPY NUMBER,
651 x_return_status OUT NOCOPY VARCHAR2);
652
653 -- Start of comments
654 --API name : repository_notifier
655 --Type : Private.
656 --Function : Sends notifications to contract's contacts if
657 -- the contract is about to expire or expired.
658 --Pre-reqs : None.
659 --Parameters :
660 --IN : p_api_version IN NUMBER Required
661 -- : p_init_msg_list IN VARCHAR2 Optional
662 -- Default = FND_API.G_FALSE
663 -- : p_contract_id IN NUMBER Required
664 -- Id of the contract to be processed
665 -- : p_contract_number IN NUMBER Required
666 -- Number of the contract to be processed
667 -- : p_contract_version IN NUMBER Required
668 -- Version of the contract to be processed
669 --OUT : x_return_status OUT VARCHAR2(1)
670 -- : x_msg_count OUT NUMBER
671 -- : x_msg_data OUT VARCHAR2(2000)
672 --Note :
673 -- End of comments
674 PROCEDURE repository_notifier(
675 p_api_version IN NUMBER,
676 p_init_msg_list IN VARCHAR2,
677 p_contract_id IN NUMBER,
678 p_contract_number IN VARCHAR2,
679 p_contract_version IN NUMBER,
680 p_expired_flag IN VARCHAR2,
681 p_notify_contact_role_id IN NUMBER,
682 x_msg_data OUT NOCOPY VARCHAR2,
683 x_msg_count OUT NOCOPY NUMBER,
684 x_return_status OUT NOCOPY VARCHAR2);
685
686 --API name : cancel_approval
687 --Type : Private.
688 --Function : Aborts the contract approval workflow process.
689 --Pre-reqs : None.
690 --Parameters :
691 --IN : p_api_version IN NUMBER Required
692 -- : p_init_msg_list IN VARCHAR2 Optional
693 -- Default = FND_API.G_FALSE
694 -- : p_contract_id IN NUMBER Required
695 -- Id of the contract to be processed
696 -- : p_contract_version IN NUMBER Required
697 -- Version of the contract to be processed
698 --OUT : x_return_status OUT VARCHAR2(1)
699 -- : x_msg_count OUT NUMBER
700 -- : x_msg_data OUT VARCHAR2(2000)
701 --Note :
702 -- End of comments
703 PROCEDURE cancel_approval(
704 p_api_version IN NUMBER,
705 p_init_msg_list IN VARCHAR2,
706 p_contract_id IN NUMBER,
707 p_contract_version IN NUMBER,
708 x_return_status OUT NOCOPY VARCHAR2,
709 x_msg_count OUT NOCOPY NUMBER,
710 x_msg_data OUT NOCOPY VARCHAR2);
711
712
713 --API name : get_next_contract_number
714 --Type : Private.
715 --Function : Gets next available number to use for a contract number
716 -- using FND Document Sequencing.
717 --Pre-reqs : None.
718 --Parameters :
719 --IN : p_api_version IN NUMBER Required
720 -- : p_init_msg_list IN VARCHAR2 Optional
721 -- Default = FND_API.G_FALSE
722 -- : p_contract_number IN VARCHAR2 Optional
723 -- Number of the contract
724 -- : p_org_id IN NUMBER Required
725 -- Id of the contract organization
726 -- : p_info_only IN VARCHAR2 Optional
727 -- Default = 'N'
728 --OUT : x_contract_number OUT NUMBER
729 -- : x_auto_number_enabled OUT VARCHAR2(1)
730 -- : x_return_status OUT VARCHAR2(1)
731 -- : x_msg_count OUT NUMBER
732 -- : x_msg_data OUT VARCHAR2(2000)
733 --Note :
734 -- End of comments
735 PROCEDURE get_next_contract_number(
736 p_api_version IN NUMBER,
737 p_init_msg_list IN VARCHAR2,
738 p_contract_number IN VARCHAR2 := NULL,
739 p_org_id IN NUMBER,
740 p_info_only IN VARCHAR2,
741 x_contract_number OUT NOCOPY NUMBER,
742 x_auto_number_enabled OUT NOCOPY VARCHAR2,
743 x_return_status OUT NOCOPY VARCHAR2,
744 x_msg_count OUT NOCOPY NUMBER,
745 x_msg_data OUT NOCOPY VARCHAR2);
746
747 -- Start of comments
748 --API name : delete_uda_attribute_values
749 --Type : Private.
750 --Function : Deletes uda_attribute_values of a contract version
751 --Pre-reqs : None.
752 --Parameters :
753 --IN : p_api_version IN NUMBER Required
754 -- : p_init_msg_list IN VARCHAR2 Optional
755 -- Default = FND_API.G_FALSE
756 -- : p_commit IN VARCHAR2 Optional
757 -- Default = FND_API.G_FALSE
758 -- : p_contract_id IN NUMBER Required
759 -- Contract ID of the contract whose status history is to be deleted
760 -- : p_contract_version IN NUMBER Required
761 -- Contract version of the contract whose status history is to be deleted
762 --OUT : x_return_status OUT VARCHAR2(1)
763 -- : x_msg_count OUT NUMBER
764 -- : x_msg_data OUT VARCHAR2(2000)
765 --Note :
766 -- End of comments
767 PROCEDURE delete_uda_attribute_values(
768 p_api_version IN NUMBER,
769 p_init_msg_list IN VARCHAR2,
770 p_commit IN VARCHAR2,
771 p_contract_id IN NUMBER,
772 --p_contract_version IN NUMBER,
773 x_msg_data OUT NOCOPY VARCHAR2,
774 x_msg_count OUT NOCOPY NUMBER,
775 x_return_status OUT NOCOPY VARCHAR2);
776
777 -- Start of comments
778 --API name : copy_uda_attribute_values
779 --Type : Private.
780 --Function : Copies Uda Attribute Groups values from source contract to target contract
781 --Pre-reqs : None.
782 --Parameters :
783 --IN : p_api_version IN NUMBER Required
784 -- : p_init_msg_list IN VARCHAR2 Optional
785 -- Default = FND_API.G_FALSE
786 -- : p_commit IN VARCHAR2 Optional
787 -- Default = FND_API.G_FALSE
788 -- : p_source_contract_id IN NUMBER Required
789 -- Id of the contract whose UDAs are to be copied
790 -- : p_target_contract_id IN NUMBER Required
791 -- Id of the contract to which source contract UDA's are to be copied
792 --OUT : x_return_status OUT VARCHAR2(1)
793 -- : x_msg_count OUT NUMBER
794 -- : x_msg_data OUT VARCHAR2(2000)
795 --Note :
796 -- End of comments
797 PROCEDURE copy_uda_attribute_values(
798 p_api_version IN NUMBER,
799 p_init_msg_list IN VARCHAR2,
800 p_commit IN VARCHAR2,
801 p_source_contract_id IN NUMBER,
802 p_target_contract_id IN NUMBER,
803 x_msg_data OUT NOCOPY VARCHAR2,
804 x_msg_count OUT NOCOPY NUMBER,
805 x_return_status OUT NOCOPY VARCHAR2);
806
807
808 -- Start of comments
809 --API name : version_uda_attribute_values
810 --Type : Private.
811 --Function : Moves Uda Attribute Groups values from Header ext tables to vers ext tables
812 --Pre-reqs : None.
813 --Parameters :
814 --IN : p_api_version IN NUMBER Required
815 -- : p_init_msg_list IN VARCHAR2 Optional
816 -- Default = FND_API.G_FALSE
817 -- : p_commit IN VARCHAR2 Optional
818 -- Default = FND_API.G_FALSE
819 -- : p_contract_id IN NUMBER Required
820 -- Id of the contract whose UDA's are to be versioned
821 -- : p_contract_version IN NUMBER Required
822 --
823 --OUT : x_return_status OUT VARCHAR2(1)
824 -- : x_msg_count OUT NUMBER
825 -- : x_msg_data OUT VARCHAR2(2000)
826 --Note :
827 -- End of comments
828 PROCEDURE version_uda_attribute_values(
829 p_api_version IN NUMBER,
830 p_init_msg_list IN VARCHAR2,
831 p_commit IN VARCHAR2,
832 p_contract_id IN NUMBER,
833 p_contract_version IN NUMBER,
834 x_msg_data OUT NOCOPY VARCHAR2,
835 x_msg_count OUT NOCOPY NUMBER,
836 x_return_status OUT NOCOPY VARCHAR2);
837
838
839 --Start of comments
840 --call_contract_preview_cp_yn checks whether the cocurrent program for generation of attachment of repository contract can be called or not.
841 --Parameters: p_contract_id NUMBER :contract Id of Repository Contract
842 -- p_contract_type VARCHAR2: contract Type of Repository Contract
843 --Return Paramter: VARCHAR2: Y/N
844 --End of comments
845
846 FUNCTION call_contract_preview_cp_yn (p_contract_id NUMBER,
847 p_contract_type VARCHAR2) RETURN VARCHAR2;
848
849 END OKC_REP_CONTRACT_PROCESS_PVT;