1 PACKAGE pn_index_rent_periods_pkg AS
2 -- $Header: PNINRPRS.pls 120.5 2007/05/14 06:51:19 hrodda ship $
3
4 -- +================================================================+
5 -- | Copyright (c) 2001 Oracle Corporation
6 -- | Redwood Shores, California, USA
7 -- | All rights reserved.
8 -- +================================================================+
9 -- | Name
10 -- | pn_index_rent_periods_pkg
11 -- |
12 -- | Description
13 -- | This package contains procedures used to maintain index rent periods
14 -- |
15 -- |
16 -- | History
17 -- | 27-MAR-2001 jreyes o Created
18 -- | 22-jul-2001 psidhu o Added procedure PROCESS_PAYMENT_TERM_AMENDMENT.
19 -- |
20 -- | 08-Mar-2002 lkatputu o Added the following lines at the beginning.
21 -- | Added for ARU db drv auto generation
22 -- | 19-JAN-2006 piagrawa o Bug#4931780 - Modified signature of
23 -- | process_main_lease_term_date
24 -- | 03-ARP-2007 Hareesha o Bug # 5960582 Added handle_term_end_dates
25 -- +================================================================+
26
27 PROCEDURE generate_periods_batch (
28 errbuf OUT NOCOPY VARCHAR2
29 ,retcode OUT NOCOPY VARCHAR2
30 ,ip_index_lease_num IN VARCHAR2
31 ,ip_regenerate_yn IN VARCHAR2);
32
33 PROCEDURE generate_periods (
34 ip_index_lease_id IN NUMBER
35 ,op_msg OUT NOCOPY VARCHAR2);
36
37 PROCEDURE print_basis_periods (
38 p_index_lease_id NUMBER);
39
40
41 ------------------------------------------------------------------------
42 -- PROCEDURE : UNDO_PERIODS
43 ------------------------------------------------------------------------
44 PROCEDURE undo_periods (
45 p_index_lease_id IN NUMBER
46 ,p_msg OUT NOCOPY VARCHAR2);
47
48
49 ------------------------------------------------------------------------
50 -- PROCEDURE : process_new_termination_date
51 ------------------------------------------------------------------------
52 PROCEDURE process_new_termination_date (
53 p_index_lease_id IN NUMBER
54 ,p_new_termination_date IN DATE
55 ,p_ignore_approved_terms IN VARCHAR2 --DEFAULT 'N'
56 ,p_msg OUT NOCOPY VARCHAR2);
57
58 ------------------------------------------------------------------------
59 -- PROCEDURE : generate_basis_data_check
60 ------------------------------------------------------------------------
61 PROCEDURE generate_basis_data_check (
62 p_index_lease_id IN NUMBER
63 ,p_msg OUT NOCOPY VARCHAR2);
64
65
66 ------------------------------------------------------------------------
67 -- PROCEDURE : process_main_lease_term_date
68 -- DESCRIPTION: This procedure will be called every time a new termination
69 -- create periods for an index rent
70 -- 18-APR-07 sdmahesh o Bug # 5985779. Enhancement for new profile
71 -- option for lease early termination.
72 -- Added p_term_end_dt
73 ------------------------------------------------------------------------
74 PROCEDURE process_main_lease_term_date (
75 p_lease_id IN NUMBER
76 ,p_new_main_lease_term_date IN DATE
77 ,p_old_main_lease_term_date IN DATE
78 ,p_lease_context IN VARCHAR2
79 ,p_msg OUT NOCOPY VARCHAR2
80 ,p_cutoff_date IN DATE DEFAULT NULL
81 ,p_term_end_dt IN DATE DEFAULT NULL);
82
83 ------------------------------------------------------------------------
84 -- PROCEDURE : DELETE_PERIODS
85 -- DESCRIPTION: This procedure will create periods for an index rent
86 --
87 -- 11-MAY-07 Hareesha o Bug6042299 Added parameter p_new_termination_date
88 ------------------------------------------------------------------------
89 PROCEDURE delete_periods (
90 p_index_lease_id IN NUMBER
91 ,p_index_period_id IN NUMBER
92 ,p_ignore_approved_terms IN VARCHAR2
93 ,p_new_termination_date IN DATE DEFAULT NULL);
94
95 ------------------------------------------------------------------------
96 -- PROCEDURE : process_payment_term_amendment
97 -- DESCRIPTION: This procedure is used by the PNTLEASE form to recalculate index
98 -- rent amount when a payment term is added from the main lease.
99 --
100 ------------------------------------------------------------------------
101
102 PROCEDURE process_payment_term_amendment (
103 p_lease_id IN NUMBER
104 ,p_payment_type_code IN VARCHAR2 --payment_fdr_blk.payment_term_type_code
105 ,p_payment_start_date IN DATE
106 ,p_payment_end_date IN DATE
107 ,p_msg OUT NOCOPY VARCHAR2) ;
108
109 -------------------------------------------------------------------------------
110 -- PROCEDURE handle_MTM_ACT
111 -- DESCRIPTION: This procedure handling of RI terms when lease changes from
112 -- MTM/HLD to ACT and lease is extended.
113 --
114 -------------------------------------------------------------------------------
115 PROCEDURE handle_MTM_ACT (
116 p_lease_id IN NUMBER
117 ,p_extended IN OUT NOCOPY BOOLEAN
118 ,x_return_status OUT NOCOPY VARCHAR2);
119
120
121 -------------------------------------------------------------------------------
122 -- PROCEDURE handle_term_end_dates
123 -- DESCRIPTION: This procedure handles Term-end-dates of RI terms on change of
124 -- agreement termination date.
125 -------------------------------------------------------------------------------
126 PROCEDURE handle_term_date_change (
127 p_index_lease_id IN NUMBER
128 ,p_old_termination_date IN DATE
129 ,p_new_termination_date IN DATE
130 ,p_msg OUT NOCOPY VARCHAR2);
131
132
133 END pn_index_rent_periods_pkg;