1 PACKAGE pn_index_lease_periods_pkg AS
2 -- $Header: PNTINLPS.pls 120.3 2007/03/14 12:57:37 pseeram ship $
3
4 /*============================================================================+
5 | Copyright (c) 2001 Oracle Corporation
6 | Redwood Shores, California, USA
7 | All rights reserved.
8 | DESCRIPTION
9 |
10 | These procedures consist are used a table handlers for the
11 | PN_INDEX_LEASE_PERIODS table.
12 | They include:
13 | INSERT_ROW - insert a row into PN_INDEX_LEASE_PERIODS.
14 | DELETE_ROW - deletes a row from PN_INDEX_LEASE_PERIODS.
15 | UPDATE_ROW - updates a row from PN_INDEX_LEASE_PERIODS.
16 | LOCKS_ROW - will check if a row has been modified since being
17 | queried by form.
18 |
19 |
20 | HISTORY
21 | 21-MAY-2001 jbreyes o Created
22 | 13-DEC-2001 Mrinal o Added dbdrv command.
23 | 09-JUL-2002 ftanudja o added x_org_id param in insert_row for
24 | shared services enh.
25 | 12-Aug-2002 psidhu o Added parameter x_carry_forward_flag to
26 | procedure update_row_calc.
27 | 05-Jul-2005 hrodda o overloaded delete_row proc to take PK as parameter
28 | 09-NOV-2006 Prabhakar o Added index_multiplier to insert/update/lock.
29 +===========================================================================*/
30 /**** SPECIFICATIONS ****/
31 ------------------------------------------------------------------------
32 -- PROCEDURE : INSERT_ROW
33 ------------------------------------------------------------------------
34 PROCEDURE insert_row (
35 x_rowid IN OUT NOCOPY VARCHAR2
36 ,x_org_id IN NUMBER DEFAULT NULL
37 ,x_index_period_id IN OUT NOCOPY NUMBER
38 ,x_index_lease_id IN NUMBER
39 ,x_line_number IN OUT NOCOPY NUMBER
40 ,x_assessment_date IN DATE
41 ,x_last_update_date IN DATE
42 ,x_last_updated_by IN NUMBER
43 ,x_creation_date IN DATE
44 ,x_created_by IN NUMBER
45 ,x_basis_start_date IN DATE
46 ,x_basis_end_date IN DATE
47 ,x_index_finder_date IN DATE
48 ,x_current_index_line_id IN NUMBER
49 ,x_current_index_line_value IN NUMBER
50 ,x_previous_index_line_id IN NUMBER
51 ,x_previous_index_line_value IN NUMBER
52 ,x_current_basis IN NUMBER
53 ,x_relationship IN VARCHAR2
54 ,x_index_percent_change IN NUMBER
55 ,x_basis_percent_change IN NUMBER
56 ,x_unconstraint_rent_due IN NUMBER
57 ,x_constraint_rent_due IN NUMBER
58 ,x_last_update_login IN NUMBER
59 ,x_attribute_category IN VARCHAR2
60 ,x_attribute1 IN VARCHAR2
61 ,x_attribute2 IN VARCHAR2
62 ,x_attribute3 IN VARCHAR2
63 ,x_attribute4 IN VARCHAR2
64 ,x_attribute5 IN VARCHAR2
65 ,x_attribute6 IN VARCHAR2
66 ,x_attribute7 IN VARCHAR2
67 ,x_attribute8 IN VARCHAR2
68 ,x_attribute9 IN VARCHAR2
69 ,x_attribute10 IN VARCHAR2
70 ,x_attribute11 IN VARCHAR2
71 ,x_attribute12 IN VARCHAR2
72 ,x_attribute13 IN VARCHAR2
73 ,x_attribute14 IN VARCHAR2
74 ,x_attribute15 IN VARCHAR2
75 ,x_index_multiplier IN NUMBER);
76
77
78 ------------------------------------------------------------------------
79 -- PROCEDURE : UPDATE_ROW
80 ------------------------------------------------------------------------
81 PROCEDURE update_row (
82 x_rowid IN VARCHAR2
83 ,x_index_period_id IN NUMBER
84 ,x_index_lease_id IN NUMBER
85 ,x_line_number IN NUMBER
86 ,x_assessment_date IN DATE
87 ,x_last_update_date IN DATE
88 ,x_last_updated_by IN NUMBER
89 ,x_basis_start_date IN DATE
90 ,x_basis_end_date IN DATE
91 ,x_index_finder_date IN DATE
92 ,x_current_index_line_id IN NUMBER
93 ,x_current_index_line_value IN NUMBER
94 ,x_previous_index_line_id IN NUMBER
95 ,x_previous_index_line_value IN NUMBER
96 ,x_current_basis IN NUMBER
97 ,x_relationship IN VARCHAR2
98 ,x_index_percent_change IN NUMBER
99 ,x_basis_percent_change IN NUMBER
100 ,x_unconstraint_rent_due IN NUMBER
101 ,x_constraint_rent_due IN NUMBER
102 ,x_last_update_login IN NUMBER
103 ,x_attribute_category IN VARCHAR2
104 ,x_attribute1 IN VARCHAR2
105 ,x_attribute2 IN VARCHAR2
106 ,x_attribute3 IN VARCHAR2
107 ,x_attribute4 IN VARCHAR2
108 ,x_attribute5 IN VARCHAR2
109 ,x_attribute6 IN VARCHAR2
110 ,x_attribute7 IN VARCHAR2
111 ,x_attribute8 IN VARCHAR2
112 ,x_attribute9 IN VARCHAR2
113 ,x_attribute10 IN VARCHAR2
114 ,x_attribute11 IN VARCHAR2
115 ,x_attribute12 IN VARCHAR2
116 ,x_attribute13 IN VARCHAR2
117 ,x_attribute14 IN VARCHAR2
118 ,x_attribute15 IN VARCHAR2
119 ,x_index_multiplier IN NUMBER
120 ,x_constraint_applied_amount IN NUMBER
121 ,x_constraint_applied_percent IN NUMBER);
122
123
124
125
126 ------------------------------------------------------------------------
127 -- PROCEDURE : UPDATE_CALCULATIONS
128 ------------------------------------------------------------------------
129 PROCEDURE update_row_calc (
130 x_rowid IN VARCHAR2
131 ,x_calculate IN VARCHAR2
132 ,x_updated_flag IN VARCHAR2
133 ,x_index_period_id IN NUMBER
134 ,x_index_lease_id IN NUMBER
135 ,x_line_number IN NUMBER
136 ,x_assessment_date IN DATE
137 ,x_last_update_date IN DATE
138 ,x_last_updated_by IN NUMBER
139 ,x_basis_start_date IN DATE
140 ,x_basis_end_date IN DATE
141 ,x_index_finder_date IN DATE
142 ,x_current_index_line_id IN OUT NOCOPY NUMBER
143 ,x_current_index_line_value IN OUT NOCOPY NUMBER
144 ,x_previous_index_line_id IN OUT NOCOPY NUMBER
145 ,x_previous_index_line_value IN OUT NOCOPY NUMBER
146 ,x_current_basis IN OUT NOCOPY NUMBER
147 ,x_relationship IN VARCHAR2
148 ,x_index_percent_change IN OUT NOCOPY NUMBER
149 ,x_basis_percent_change IN NUMBER
150 ,x_unconstraint_rent_due IN OUT NOCOPY NUMBER
151 ,x_constraint_rent_due IN OUT NOCOPY NUMBER
152 ,x_last_update_login IN NUMBER
153 ,x_attribute_category IN VARCHAR2
154 ,x_attribute1 IN VARCHAR2
155 ,x_attribute2 IN VARCHAR2
156 ,x_attribute3 IN VARCHAR2
157 ,x_attribute4 IN VARCHAR2
158 ,x_attribute5 IN VARCHAR2
159 ,x_attribute6 IN VARCHAR2
160 ,x_attribute7 IN VARCHAR2
161 ,x_attribute8 IN VARCHAR2
162 ,x_attribute9 IN VARCHAR2
163 ,x_attribute10 IN VARCHAR2
164 ,x_attribute11 IN VARCHAR2
165 ,x_attribute12 IN VARCHAR2
166 ,x_attribute13 IN VARCHAR2
167 ,x_attribute14 IN VARCHAR2
168 ,x_attribute15 IN VARCHAR2
169 ,x_carry_forward_flag IN VARCHAR2
170 ,x_index_multiplier IN NUMBER
171 ,x_constraint_applied_amount IN NUMBER
172 ,x_constraint_applied_percent IN NUMBER);
173
174
175 ------------------------------------------------------------------------
176 -- PROCEDURE : LOCK_ROW
177 ------------------------------------------------------------------------
178 PROCEDURE lock_row (
179 x_rowid IN VARCHAR2
180 ,x_index_period_id IN NUMBER
181 ,x_index_lease_id IN NUMBER
182 ,x_line_number IN NUMBER
183 ,x_assessment_date IN DATE
184 ,x_basis_start_date IN DATE
185 ,x_basis_end_date IN DATE
186 ,x_index_finder_date IN DATE
187 ,x_current_index_line_id IN NUMBER
188 ,x_current_index_line_value IN NUMBER
189 ,x_previous_index_line_id IN NUMBER
190 ,x_previous_index_line_value IN NUMBER
191 ,x_current_basis IN NUMBER
192 ,x_relationship IN VARCHAR2
193 ,x_index_percent_change IN NUMBER
194 ,x_basis_percent_change IN NUMBER
195 ,x_unconstraint_rent_due IN NUMBER
196 ,x_constraint_rent_due IN NUMBER
197 ,x_attribute_category IN VARCHAR2
198 ,x_attribute1 IN VARCHAR2
199 ,x_attribute2 IN VARCHAR2
200 ,x_attribute3 IN VARCHAR2
201 ,x_attribute4 IN VARCHAR2
202 ,x_attribute5 IN VARCHAR2
203 ,x_attribute6 IN VARCHAR2
204 ,x_attribute7 IN VARCHAR2
205 ,x_attribute8 IN VARCHAR2
206 ,x_attribute9 IN VARCHAR2
207 ,x_attribute10 IN VARCHAR2
208 ,x_attribute11 IN VARCHAR2
209 ,x_attribute12 IN VARCHAR2
210 ,x_attribute13 IN VARCHAR2
211 ,x_attribute14 IN VARCHAR2
212 ,x_attribute15 IN VARCHAR2
213 ,x_index_multiplier IN NUMBER
214 ,x_constraint_applied_amount IN NUMBER
215 ,x_constraint_applied_percent IN NUMBER);
216
217
218 ------------------------------------------------------------------------
219 -- PROCEDURE : DELETE_ROW
220 ------------------------------------------------------------------------
221 PROCEDURE delete_row (x_rowid IN VARCHAR2);
222
223 -------------------------------------------------------------------------------
224 -- PROCDURE : delete_row
225 -- INVOKED FROM : delete_row procedure
226 -- PURPOSE : deletes the row
227 -- NOTE : overloaded this procedure to take PK as In parameter
228 -- HISTORY :
229 -- 04-JUL-05 hrodda o Bug 4284035 - Created
230 -------------------------------------------------------------------------------
231 PROCEDURE delete_row (x_index_period_id IN NUMBER);
232
233
234 END pn_index_lease_periods_pkg;