1 PACKAGE OKC_REP_CONTRACT_PROCESS_PVT AS
2 /* $Header: OKCVREPPROCSS.pls 120.2 2006/05/15 20:40:04 vamuru noship $ */
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_SIGNED CONSTANT VARCHAR2(30) := 'SIGNED';
19 G_STATUS_TERMINATED CONSTANT VARCHAR2(30) := 'TERMINATED';
20 G_STATUS_DRAFT CONSTANT VARCHAR2(30) := 'DRAFT';
21 G_ACTION_SUBMITTED CONSTANT VARCHAR2(30) := 'SUBMITTED';
22 G_ACTION_ABORTED CONSTANT VARCHAR2(30) := 'ABORTED';
23
24 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
25 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
26 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
27
28 G_APPROVAL_ITEM_TYPE CONSTANT VARCHAR2(200) := 'OKCREPMA';
29 G_APPROVAL_PROCESS CONSTANT VARCHAR2(200) := 'REP_CONTRACT_APPROVAL';
30 G_APPLICATION_ID CONSTANT NUMBER := 510;
31
32 -- Required for Contract not found error message
33 G_INVALID_CONTRACT_ID_MSG CONSTANT VARCHAR2(200) := 'OKC_REP_INVALID_CONTRACT_ID';
34 G_CANEL_APPROVAL_ERROR_MSG CONSTANT VARCHAR2(200) := 'OKC_REP_CANCEL_APPROVAL_ERROR';
35
36 G_CONTRACT_ID_TOKEN CONSTANT VARCHAR2(200) := 'CONTRACT_ID';
37 G_CONTRACT_NUM_TOKEN CONSTANT VARCHAR2(200) := 'CONTRACT_NUM';
38
39 G_INTERNAL_ORG CONSTANT VARCHAR2(200) := 'INTERNAL_ORG';
40
41 G_CONTRACT_BOOKMARK_TYPE CONSTANT VARCHAR2(200) := 'CONTRACT';
42
43 -- Contract events - deliverables integration
44 G_CONTRACT_EXPIRE_EVENT CONSTANT VARCHAR2(200) := 'CONTRACT_EXPIRE';
45 G_CONTRACT_EFFECTIVE_EVENT CONSTANT VARCHAR2(200) := 'CONTRACT_EFFECTIVE';
46 G_CONTRACT_TERMINATED_EVENT CONSTANT VARCHAR2(200) := 'CONTRACT_TERMINATED';
47
48 -- Current version number for documents and deliverables
49 G_CURRENT_VERSION CONSTANT NUMBER := -99;
50
51 -- Contracts business events codes TBL Type
52 SUBTYPE EVENT_TBL_TYPE IS OKC_MANAGE_DELIVERABLES_GRP.BUSDOCDATES_TBL_TYPE;
53
54 G_INVALID_CONTRACT_NUMBER_MSG CONSTANT VARCHAR2(200) := 'OKC_REP_INV_CON_NUMBER';
55 ------------------------------------------------------------------------------
56 -- GLOBAL EXCEPTION
57 ------------------------------------------------------------------------------
58 E_Resource_Busy EXCEPTION;
59 PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
60
61 ---------------------------------------------------------------------------
62 -- Procedures and Functions
63 ---------------------------------------------------------------------------
64
65 -- Start of comments
66 --API name : submit_contract_for_approval
67 --Type : Private.
68 --Function : Submits contract for approval
69 --Pre-reqs : None.
70 --Parameters :
71 --IN : p_api_version IN NUMBER Required
72 -- : p_init_msg_list IN VARCHAR2 Optional
73 -- Default = FND_API.G_FALSE
74 -- : p_contract_id IN NUMBER Required
75 -- Contract ID of the contract to be submitted for approval
76 -- : p_contract_version IN NUMBER Required
77 -- Contract Version of the contract to be submitted for approval
78 --OUT : x_return_status OUT VARCHAR2(1)
79 -- : x_msg_count OUT NUMBER
80 -- : x_msg_data OUT VARCHAR2(2000)
81 --Note :
82 -- End of comments
83 PROCEDURE submit_contract_for_approval(
84 p_api_version IN NUMBER,
85 p_init_msg_list IN VARCHAR2,
86 p_contract_id IN NUMBER,
87 p_contract_version IN NUMBER,
88 x_return_status OUT NOCOPY VARCHAR2,
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2
91 );
92
93 -- Start of comments
94 --API name : delete_contacts
95 --Type : Private.
96 --Function : Deletes party contacts of a particular Contract
97 --Pre-reqs : None.
98 --Parameters :
99 --IN : p_api_version IN NUMBER Required
100 -- : p_init_msg_list IN VARCHAR2 Optional
101 -- Default = FND_API.G_FALSE
102 -- : p_commit IN VARCHAR2 Optional
103 -- Default = FND_API.G_FALSE
104 -- : p_contract_id IN NUMBER Required
105 -- Contract ID of the contract whose contacts are to be deleted
106 --OUT : x_return_status OUT VARCHAR2(1)
107 -- : x_msg_count OUT NUMBER
108 -- : x_msg_data OUT VARCHAR2(2000)
109 --Note :
110 -- End of comments
111 PROCEDURE delete_contacts(
112 p_api_version IN NUMBER,
113 p_init_msg_list IN VARCHAR2,
114 p_commit IN VARCHAR2,
115 p_contract_id IN NUMBER,
116 x_msg_data OUT NOCOPY VARCHAR2,
117 x_msg_count OUT NOCOPY NUMBER,
118 x_return_status OUT NOCOPY VARCHAR2);
119
120 -- Start of comments
121 --API name : delete_parties
122 --Type : Private.
123 --Function : Deletes parties of a particular Contract
124 --Pre-reqs : None.
125 --Parameters :
126 --IN : p_api_version IN NUMBER Required
127 -- : p_init_msg_list IN VARCHAR2 Optional
128 -- Default = FND_API.G_FALSE
129 -- : p_commit IN VARCHAR2 Optional
130 -- Default = FND_API.G_FALSE
131 -- : p_contract_id IN NUMBER Required
132 -- Contract ID of the contract whose parties are to be deleted
133 --OUT : x_return_status OUT VARCHAR2(1)
134 -- : x_msg_count OUT NUMBER
135 -- : x_msg_data OUT VARCHAR2(2000)
136 --Note :
137 -- End of comments
138 PROCEDURE delete_parties(
139 p_api_version IN NUMBER,
140 p_init_msg_list IN VARCHAR2,
141 p_commit IN VARCHAR2,
142 p_contract_id IN NUMBER,
143 x_msg_data OUT NOCOPY VARCHAR2,
144 x_msg_count OUT NOCOPY NUMBER,
145 x_return_status OUT NOCOPY VARCHAR2);
146
147
148 -- Start of comments
149 --API name : delete_risks
150 --Type : Private.
151 --Function : Deletes risks of a particular Contract
152 --Pre-reqs : None.
153 --Parameters :
154 --IN : p_api_version IN NUMBER Required
155 -- : p_init_msg_list IN VARCHAR2 Optional
156 -- Default = FND_API.G_FALSE
157 -- : p_commit IN VARCHAR2 Optional
158 -- Default = FND_API.G_FALSE
159 -- : p_contract_id IN NUMBER Required
160 -- Contract ID of the contract whose risks are to be deleted
161 --OUT : x_return_status OUT VARCHAR2(1)
162 -- : x_msg_count OUT NUMBER
163 -- : x_msg_data OUT VARCHAR2(2000)
164 --Note :
165 -- End of comments
166 PROCEDURE delete_risks(
167 p_api_version IN NUMBER,
168 p_init_msg_list IN VARCHAR2,
169 p_commit IN VARCHAR2,
170 p_contract_id IN NUMBER,
171 x_msg_data OUT NOCOPY VARCHAR2,
172 x_msg_count OUT NOCOPY NUMBER,
173 x_return_status OUT NOCOPY VARCHAR2);
174
175 -- Start of comments
176 --API name : delete_related_contracts
177 --Type : Private.
178 --Function : Deletes related contracts of a particular Contract
179 --Pre-reqs : None.
180 --Parameters :
181 --IN : p_api_version IN NUMBER Required
182 -- : p_init_msg_list IN VARCHAR2 Optional
183 -- Default = FND_API.G_FALSE
184 -- : p_commit IN VARCHAR2 Optional
185 -- Default = FND_API.G_FALSE
186 -- : p_contract_id IN NUMBER Required
187 -- Contract ID of the contract whose related contracts are to be deleted
188 --OUT : x_return_status OUT VARCHAR2(1)
189 -- : x_msg_count OUT NUMBER
190 -- : x_msg_data OUT VARCHAR2(2000)
191 --Note :
192 -- End of comments
193 PROCEDURE delete_related_contracts(
194 p_api_version IN NUMBER,
195 p_init_msg_list IN VARCHAR2,
196 p_commit IN VARCHAR2,
197 p_contract_id IN NUMBER,
198 x_msg_data OUT NOCOPY VARCHAR2,
199 x_msg_count OUT NOCOPY NUMBER,
200 x_return_status OUT NOCOPY VARCHAR2);
201
202 -- Start of comments
203 --API name : delete_ACL
204 --Type : Private.
205 --Function : Deletes parties of a particular Contract
206 --Pre-reqs : None.
207 --Parameters :
208 --IN : p_api_version IN NUMBER Required
209 -- : p_init_msg_list IN VARCHAR2 Optional
210 -- Default = FND_API.G_FALSE
211 -- : p_commit IN VARCHAR2 Optional
212 -- Default = FND_API.G_FALSE
213 -- : p_contract_id IN NUMBER Required
214 -- Contract ID of the contract whose ACL is to be deleted
215 --OUT : x_return_status OUT VARCHAR2(1)
216 -- : x_msg_count OUT NUMBER
217 -- : x_msg_data OUT VARCHAR2(2000)
218 --Note :
219 -- End of comments
220 PROCEDURE delete_ACL(
221 p_api_version IN NUMBER,
222 p_init_msg_list IN VARCHAR2,
223 p_commit IN VARCHAR2,
224 p_contract_id IN NUMBER,
225 x_msg_data OUT NOCOPY VARCHAR2,
226 x_msg_count OUT NOCOPY NUMBER,
227 x_return_status OUT NOCOPY VARCHAR2);
228
229
230 -- Start of comments
231 --API name : delete_status_history
232 --Type : Private.
233 --Function : Deletes status history records of a contract version
234 --Pre-reqs : None.
235 --Parameters :
236 --IN : p_api_version IN NUMBER Required
237 -- : p_init_msg_list IN VARCHAR2 Optional
238 -- Default = FND_API.G_FALSE
239 -- : p_commit IN VARCHAR2 Optional
240 -- Default = FND_API.G_FALSE
241 -- : p_contract_id IN NUMBER Required
242 -- Contract ID of the contract whose status history is to be deleted
243 -- : p_contract_version IN NUMBER Required
244 -- Contract version of the contract whose status history is to be deleted
245 --OUT : x_return_status OUT VARCHAR2(1)
246 -- : x_msg_count OUT NUMBER
247 -- : x_msg_data OUT VARCHAR2(2000)
248 --Note :
249 -- End of comments
250 PROCEDURE delete_status_history(
251 p_api_version IN NUMBER,
252 p_init_msg_list IN VARCHAR2,
253 p_commit IN VARCHAR2,
254 p_contract_id IN NUMBER,
255 p_contract_version IN NUMBER,
256 x_msg_data OUT NOCOPY VARCHAR2,
257 x_msg_count OUT NOCOPY NUMBER,
258 x_return_status OUT NOCOPY VARCHAR2);
259
260 -- Start of comments
261 --API name : delete_approval_history
262 --Type : Private.
263 --Function : Deletes contract approval history records of a contract version
264 --Pre-reqs : None.
265 --Parameters :
266 --IN : p_api_version IN NUMBER Required
267 -- : p_init_msg_list IN VARCHAR2 Optional
268 -- Default = FND_API.G_FALSE
269 -- : p_commit IN VARCHAR2 Optional
270 -- Default = FND_API.G_FALSE
271 -- : p_contract_id IN NUMBER Required
272 -- Contract ID of the contract whose approval history is to be deleted
273 -- : p_contract_version IN NUMBER Required
274 -- Contract version of the contract whose approval history is to be deleted
275 --OUT : x_return_status OUT VARCHAR2(1)
276 -- : x_msg_count OUT NUMBER
277 -- : x_msg_data OUT VARCHAR2(2000)
278 --Note :
279 -- End of comments
280 PROCEDURE delete_approval_history(
281 p_api_version IN NUMBER,
282 p_init_msg_list IN VARCHAR2,
283 p_commit IN VARCHAR2,
284 p_contract_id IN NUMBER,
285 p_contract_version IN NUMBER,
286 x_msg_data OUT NOCOPY VARCHAR2,
287 x_msg_count OUT NOCOPY NUMBER,
288 x_return_status OUT NOCOPY VARCHAR2);
289
290 -- Start of comments
291 --API name : delete_bookmarks
292 --Type : Private.
293 --Function : Deletes bookmarks for a given contract
294 --Pre-reqs : None.
295 --Parameters :
296 --IN : p_api_version IN NUMBER Required
297 -- : p_init_msg_list IN VARCHAR2 Optional
298 -- Default = FND_API.G_FALSE
299 -- : p_commit IN VARCHAR2 Optional
300 -- Default = FND_API.G_FALSE
301 -- : p_contract_type IN VARCHAR2 Required
302 -- Contract Type of the contract whose bookmarks are to be deleted
303 -- : p_contract_id IN NUMBER Required
304 -- Contract ID of the contract whose bookmarks are is to be deleted
305 --OUT : x_return_status OUT VARCHAR2(1)
306 -- : x_msg_count OUT NUMBER
307 -- : x_msg_data OUT VARCHAR2(2000)
308 --Note :
309 -- End of comments
310 PROCEDURE delete_bookmarks(
311 p_api_version IN NUMBER,
312 p_init_msg_list IN VARCHAR2,
313 p_commit IN VARCHAR2,
314 p_contract_type IN VARCHAR2,
315 p_contract_id IN NUMBER,
316 x_msg_data OUT NOCOPY VARCHAR2,
317 x_msg_count OUT NOCOPY NUMBER,
318 x_return_status OUT NOCOPY VARCHAR2);
319
320 -- Start of comments
321 --API name : lock_contract_header
322 --Type : Private.
323 --Function : Locks a row in OKC_REP_CONTRACTS_ALL table
324 --Pre-reqs : None.
325 --Parameters :
326 --IN : p_contract_id IN NUMBER Required
327 -- Contract ID of the contract to be locked.
328 -- : p_object_version_number IN NUMBER Required
329 -- Object version number of the contract to be locked
330 --OUT : x_return_status OUT VARCHAR2(1)
331 -- : x_msg_count OUT NUMBER
332 -- : x_msg_data OUT VARCHAR2(2000)
333 --Note :
334 -- End of comments
335 PROCEDURE lock_contract_header(
336 p_contract_id IN NUMBER,
337 p_object_version_number IN NUMBER,
338 x_return_status OUT NOCOPY VARCHAR2
339 );
340
341 -- Start of comments
342 --API name : delete_contract
343 --Type : Private.
344 --Function : Deletes a Contract
345 --Pre-reqs : None.
346 --Parameters :
347 --IN : p_api_version IN NUMBER Required
348 -- : p_init_msg_list IN VARCHAR2 Optional
349 -- Default = FND_API.G_FALSE
350 -- : p_commit IN VARCHAR2 Optional
351 -- Default = FND_API.G_FALSE
352 -- : p_contract_id IN NUMBER Required
353 -- Contract ID of the contract to be deleted
354 --OUT : x_return_status OUT VARCHAR2(1)
355 -- : x_msg_count OUT NUMBER
356 -- : x_msg_data OUT VARCHAR2(2000)
357 --Note :
358 -- End of comments
359 PROCEDURE delete_contract(
360 p_api_version IN NUMBER,
361 p_init_msg_list IN VARCHAR2,
362 p_commit IN VARCHAR2,
363 p_contract_id IN NUMBER,
364 x_msg_data OUT NOCOPY VARCHAR2,
365 x_msg_count OUT NOCOPY NUMBER,
366 x_return_status OUT NOCOPY VARCHAR2);
367
368
369 -- Start of comments
370 --API name : copy_contacts
371 --Type : Private.
372 --Function : Copies party contacts of source contract to target contract
373 --Pre-reqs : None.
374 --Parameters :
375 --IN : p_api_version IN NUMBER Required
376 -- : p_init_msg_list IN VARCHAR2 Optional
377 -- Default = FND_API.G_FALSE
378 -- : p_commit IN VARCHAR2 Optional
379 -- Default = FND_API.G_FALSE
380 -- : p_source_contract_id IN NUMBER Required
381 -- Id of the contract whose contacts are to be copied
382 -- : p_target_contract_id IN NUMBER Required
383 -- Id of the contract to which source contacts are to be copied
384 --OUT : x_return_status OUT VARCHAR2(1)
385 -- : x_msg_count OUT NUMBER
386 -- : x_msg_data OUT VARCHAR2(2000)
387 --Note :
388 -- End of comments
389 PROCEDURE copy_contacts(
390 p_api_version IN NUMBER,
391 p_init_msg_list IN VARCHAR2,
392 p_commit IN VARCHAR2,
393 p_source_contract_id IN NUMBER,
394 p_target_contract_id IN NUMBER,
395 x_msg_data OUT NOCOPY VARCHAR2,
396 x_msg_count OUT NOCOPY NUMBER,
397 x_return_status OUT NOCOPY VARCHAR2);
398
399 -- Start of comments
400 --API name : copy_parties
401 --Type : Private.
402 --Function : Copies parties of source contract to target contract
403 --Pre-reqs : None.
404 --Parameters :
405 --IN : p_api_version IN NUMBER Required
406 -- : p_init_msg_list IN VARCHAR2 Optional
407 -- Default = FND_API.G_FALSE
408 -- : p_commit IN VARCHAR2 Optional
409 -- Default = FND_API.G_FALSE
410 -- : p_source_contract_id IN NUMBER Required
411 -- Id of the contract whose parties are to be copied
412 -- : p_target_contract_id IN NUMBER Required
413 -- Id of the contract to which source parties are to be copied
414 --OUT : x_return_status OUT VARCHAR2(1)
415 -- : x_msg_count OUT NUMBER
416 -- : x_msg_data OUT VARCHAR2(2000)
417 --Note :
418 -- End of comments
419 PROCEDURE copy_parties(
420 p_api_version IN NUMBER,
421 p_init_msg_list IN VARCHAR2,
422 p_commit IN VARCHAR2,
423 p_source_contract_id IN NUMBER,
424 p_target_contract_id IN NUMBER,
425 x_msg_data OUT NOCOPY VARCHAR2,
426 x_msg_count OUT NOCOPY NUMBER,
427 x_return_status OUT NOCOPY VARCHAR2);
428
429
430 -- Start of comments
431 --API name : copy_risks
432 --Type : Private.
433 --Function : Copies risks of source contract to target contract
434 --Pre-reqs : None.
435 --Parameters :
436 --IN : p_api_version IN NUMBER Required
437 -- : p_init_msg_list IN VARCHAR2 Optional
438 -- Default = FND_API.G_FALSE
439 -- : p_commit IN VARCHAR2 Optional
440 -- Default = FND_API.G_FALSE
441 -- : p_source_contract_id IN NUMBER Required
442 -- Id of the contract whose risks are to be copied
443 -- : p_target_contract_id IN NUMBER Required
444 -- Id of the contract to which source contract risks are to be copied
445 --OUT : x_return_status OUT VARCHAR2(1)
446 -- : x_msg_count OUT NUMBER
447 -- : x_msg_data OUT VARCHAR2(2000)
448 --Note :
449 -- End of comments
450 PROCEDURE copy_risks(
451 p_api_version IN NUMBER,
452 p_init_msg_list IN VARCHAR2,
453 p_commit IN VARCHAR2,
454 p_source_contract_id IN NUMBER,
455 p_target_contract_id IN NUMBER,
456 x_msg_data OUT NOCOPY VARCHAR2,
457 x_msg_count OUT NOCOPY NUMBER,
458 x_return_status OUT NOCOPY VARCHAR2);
459
460 -- Start of comments
461 --API name : copy_ACL
462 --Type : Private.
463 --Function : Copies ACL records from source contract to target contract
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_commit IN VARCHAR2 Optional
470 -- Default = FND_API.G_FALSE
471 -- : p_source_contract_id IN NUMBER Required
472 -- Id of the contract whose ACLs are to be copied
473 -- : p_target_contract_id IN NUMBER Required
474 -- Id of the contract to which source contract ACL are to be copied
475 --OUT : 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 copy_ACL(
481 p_api_version IN NUMBER,
482 p_init_msg_list IN VARCHAR2,
483 p_commit IN VARCHAR2,
484 p_source_contract_id IN NUMBER,
485 p_target_contract_id IN NUMBER,
486 x_msg_data OUT NOCOPY VARCHAR2,
487 x_msg_count OUT NOCOPY NUMBER,
488 x_return_status OUT NOCOPY VARCHAR2);
489
490 -- Start of comments
491 --API name : copy_contract_details
492 --Type : Private.
493 --Function : Copies contract details for duplication
494 --Pre-reqs : None.
495 --Parameters :
496 --IN : p_api_version IN NUMBER Required
497 -- : p_init_msg_list IN VARCHAR2 Optional
498 -- Default = FND_API.G_FALSE
499 -- : p_commit IN VARCHAR2 Optional
500 -- Default = FND_API.G_FALSE
501 -- : p_source_contract_id IN NUMBER Required
502 -- Id of the contract whose details are to be copied
503 -- : p_target_contract_id IN NUMBER Required
504 -- Id of the contract to which source contract details are to be copied
505 -- : p_target_contract_number IN VARCHAR2 Required
506 -- Number of the contract to which source contract details are to be copied
507 --OUT : x_return_status OUT VARCHAR2(1)
508 -- : x_msg_count OUT NUMBER
509 -- : x_msg_data OUT VARCHAR2(2000)
510 --Note :
511 -- End of comments
512 PROCEDURE copy_contract_details(
513 p_api_version IN NUMBER,
514 p_init_msg_list IN VARCHAR2,
515 p_commit IN VARCHAR2,
516 p_source_contract_id IN NUMBER,
517 p_target_contract_id IN NUMBER,
518 p_target_contract_number IN VARCHAR2,
519 x_msg_data OUT NOCOPY VARCHAR2,
520 x_msg_count OUT NOCOPY NUMBER,
521 x_return_status OUT NOCOPY VARCHAR2);
522
523
524 -- Start of comments
525 --API name : version_contract_details
526 --Type : Private.
527 --Function : Copies deliverables and documents for versioning
528 --Pre-reqs : None.
529 --Parameters :
530 --IN : p_api_version IN NUMBER Required
531 -- : p_init_msg_list IN VARCHAR2 Optional
532 -- Default = FND_API.G_FALSE
533 -- : p_commit IN VARCHAR2 Optional
534 -- Default = FND_API.G_FALSE
535 -- : p_contract_id IN NUMBER Required
536 -- Id of the contract whose details are to be versioned
537 --OUT : x_return_status OUT VARCHAR2(1)
538 -- : x_msg_count OUT NUMBER
539 -- : x_msg_data OUT VARCHAR2(2000)
540 --Note :
541 -- End of comments
542 PROCEDURE version_contract_details(
543 p_api_version IN NUMBER,
544 p_init_msg_list IN VARCHAR2,
545 p_commit IN VARCHAR2,
546 p_contract_id IN NUMBER,
547 x_msg_data OUT NOCOPY VARCHAR2,
548 x_msg_count OUT NOCOPY NUMBER,
549 x_return_status OUT NOCOPY VARCHAR2);
550
551
552
553
554 -- Start of comments
555 --API name : sign_contract
556 --Type : Private.
557 --Function : Changes contract status to SIGNED and calls delivarables
558 -- API to activate deliverables of that contract
559 --Pre-reqs : None.
560 --Parameters :
561 --IN : p_api_version IN NUMBER Required
562 -- : p_init_msg_list IN VARCHAR2 Optional
563 -- Default = FND_API.G_FALSE
564 -- : p_commit IN VARCHAR2 Optional
565 -- Default = FND_API.G_FALSE
566 -- : p_contract_id IN NUMBER Required
567 -- Id of the contract to be signed
568 --OUT : x_return_status OUT VARCHAR2(1)
569 -- : x_msg_count OUT NUMBER
570 -- : x_msg_data OUT VARCHAR2(2000)
571 --Note :
572 -- End of comments
573 PROCEDURE sign_contract(
574 p_api_version IN NUMBER,
575 p_init_msg_list IN VARCHAR2,
576 p_commit IN VARCHAR2,
577 p_contract_id IN NUMBER,
578 x_msg_data OUT NOCOPY VARCHAR2,
579 x_msg_count OUT NOCOPY NUMBER,
580 x_return_status OUT NOCOPY VARCHAR2);
581
582
583 -- Start of comments
584 --API name : terminate_contract
585 --Type : Private.
586 --Function : Changes contract status to TERMINATED and calls delivarables
587 -- API to cancel deliverables of that contract
588 --Pre-reqs : None.
589 --Parameters :
590 --IN : p_api_version IN NUMBER Required
591 -- : p_init_msg_list IN VARCHAR2 Optional
592 -- Default = FND_API.G_FALSE
593 -- : p_commit IN VARCHAR2 Optional
594 -- Default = FND_API.G_FALSE
595 -- : p_contract_id IN NUMBER Required
596 -- Id of the contract to be terminated
597 -- : p_termination_date IN DATE Required
598 -- Date the contract is terminated
599 --OUT : x_return_status OUT VARCHAR2(1)
600 -- : x_msg_count OUT NUMBER
601 -- : x_msg_data OUT VARCHAR2(2000)
602 --Note :
603 -- End of comments
604 PROCEDURE terminate_contract(
605 p_api_version IN NUMBER,
606 p_init_msg_list IN VARCHAR2,
607 p_commit IN VARCHAR2,
608 p_contract_id IN NUMBER,
609 p_termination_date IN DATE,
610 x_msg_data OUT NOCOPY VARCHAR2,
611 x_msg_count OUT NOCOPY NUMBER,
612 x_return_status OUT NOCOPY VARCHAR2);
613
614 -- Start of comments
615 --API name : repository_notifier
616 --Type : Private.
617 --Function : Sends notifications to contract's contacts if
618 -- the contract is about to expire or expired.
619 --Pre-reqs : None.
620 --Parameters :
621 --IN : p_api_version IN NUMBER Required
622 -- : p_init_msg_list IN VARCHAR2 Optional
623 -- Default = FND_API.G_FALSE
624 -- : p_contract_id IN NUMBER Required
625 -- Id of the contract to be processed
626 -- : p_contract_number IN NUMBER Required
627 -- Number of the contract to be processed
628 -- : p_contract_version IN NUMBER Required
629 -- Version of the contract to be processed
630 --OUT : x_return_status OUT VARCHAR2(1)
631 -- : x_msg_count OUT NUMBER
632 -- : x_msg_data OUT VARCHAR2(2000)
633 --Note :
634 -- End of comments
635 PROCEDURE repository_notifier(
636 p_api_version IN NUMBER,
637 p_init_msg_list IN VARCHAR2,
638 p_contract_id IN NUMBER,
639 p_contract_number IN VARCHAR2,
640 p_contract_version IN NUMBER,
641 p_expired_flag IN VARCHAR2,
642 p_notify_contact_role_id IN NUMBER,
643 x_msg_data OUT NOCOPY VARCHAR2,
644 x_msg_count OUT NOCOPY NUMBER,
645 x_return_status OUT NOCOPY VARCHAR2);
646
647 --API name : cancel_approval
648 --Type : Private.
649 --Function : Aborts the contract approval workflow process.
650 --Pre-reqs : None.
651 --Parameters :
652 --IN : p_api_version IN NUMBER Required
653 -- : p_init_msg_list IN VARCHAR2 Optional
654 -- Default = FND_API.G_FALSE
655 -- : p_contract_id IN NUMBER Required
656 -- Id of the contract to be processed
657 -- : p_contract_version IN NUMBER Required
658 -- Version of the contract to be processed
659 --OUT : x_return_status OUT VARCHAR2(1)
660 -- : x_msg_count OUT NUMBER
661 -- : x_msg_data OUT VARCHAR2(2000)
662 --Note :
663 -- End of comments
664 PROCEDURE cancel_approval(
665 p_api_version IN NUMBER,
666 p_init_msg_list IN VARCHAR2,
667 p_contract_id IN NUMBER,
668 p_contract_version IN NUMBER,
669 x_return_status OUT NOCOPY VARCHAR2,
670 x_msg_count OUT NOCOPY NUMBER,
671 x_msg_data OUT NOCOPY VARCHAR2);
672
673
674 --API name : get_next_contract_number
675 --Type : Private.
676 --Function : Gets next available number to use for a contract number
677 -- using FND Document Sequencing.
678 --Pre-reqs : None.
679 --Parameters :
680 --IN : p_api_version IN NUMBER Required
681 -- : p_init_msg_list IN VARCHAR2 Optional
682 -- Default = FND_API.G_FALSE
683 -- : p_contract_number IN VARCHAR2 Optional
684 -- Number of the contract
685 -- : p_org_id IN NUMBER Required
686 -- Id of the contract organization
687 -- : p_info_only IN VARCHAR2 Optional
688 -- Default = 'N'
689 --OUT : x_contract_number OUT NUMBER
690 -- : x_auto_number_enabled OUT VARCHAR2(1)
691 -- : x_return_status OUT VARCHAR2(1)
692 -- : x_msg_count OUT NUMBER
693 -- : x_msg_data OUT VARCHAR2(2000)
694 --Note :
695 -- End of comments
696 PROCEDURE get_next_contract_number(
697 p_api_version IN NUMBER,
698 p_init_msg_list IN VARCHAR2,
699 p_contract_number IN VARCHAR2 := NULL,
700 p_org_id IN NUMBER,
701 p_info_only IN VARCHAR2,
702 x_contract_number OUT NOCOPY NUMBER,
703 x_auto_number_enabled OUT NOCOPY VARCHAR2,
704 x_return_status OUT NOCOPY VARCHAR2,
705 x_msg_count OUT NOCOPY NUMBER,
706 x_msg_data OUT NOCOPY VARCHAR2);
707 END OKC_REP_CONTRACT_PROCESS_PVT;