1 PACKAGE pn_index_leases_pkg AUTHID CURRENT_USER AS
2 -- $Header: PNTINLES.pls 120.3 2007/01/02 07:45:24 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 PN_INDEX_LEASES
11 | table. They include:
12 | INSERT_ROW - insert a row into PN_INDEX_LEASES.
13 | DELETE_ROW - deletes a row from PN_INDEX_LEASES.
14 | UPDATE_ROW - updates a row from PN_INDEX_LEASES.
15 | LOCKS_ROW - will check if a row has been modified since being queried
16 | by form.
17 |
18 |
19 | HISTORY
20 | 10-APR-01 jbreyes o Created
21 | 15-JUN-01 jbreyes o Added new column BASE_INDEX_LINE_ID
22 | 21-JUN-01 jbreyes o Added new column INDEX_FINDER_MONTHS
23 | 07-AUG-01 psidhu o Added new columns AGGEGATION_FLAG and
24 | GROSS_FLAG
25 | 10-DEC-2001 Mrinal o Added dbdrv command.
26 | 17-Jul-2002 Psidhu o Added currency_code as a parameter to
27 | insert_row, update_row and lock_row.
28 | 09-JUL-02 ftanudja o added x_org_id param in insert_row
29 | for shared serv enh.
30 | 05-AUG-02 psidhu o added x_carry_forward_flag parameter to
31 | insert_row,update_row and lock_row.
32 | 17-MAY-04 vmmehta o added x_retain_initial_flag parameter to
33 | insert_row,update_row and lock_row.
34 | 05-JUL-05 hrodda o overloaded delete_row proc to take PK as parameter
35 | 14-AUG-06 pikhar o Added vr_nbp_flag to insert/update/lock
36 | 09-NOV-06 Prabhakar o Added index_multiplier to insert/update/lock
37 | 08-NOV-06 Prabhakar o Added proration_rule and pn_proration_period_start_date
38 | to insert/update/lock.
39 +===========================================================================*/
40
41
42 ------------------------------------------------------------------------
43 -- PROCEDURE : INSERT_ROW
44 ------------------------------------------------------------------------
45 PROCEDURE insert_row (
46 x_rowid IN OUT NOCOPY VARCHAR2
47 ,x_org_id IN NUMBER DEFAULT NULL
48 ,x_index_lease_id IN OUT NOCOPY NUMBER
49 ,x_lease_id IN NUMBER
50 ,x_index_id IN NUMBER
51 ,x_commencement_date IN DATE
52 ,x_termination_date IN DATE
53 ,x_index_lease_number IN OUT NOCOPY VARCHAR2
54 ,x_last_update_date IN DATE
55 ,x_last_updated_by IN NUMBER
56 ,x_creation_date IN DATE
57 ,x_created_by IN NUMBER
58 ,x_location_id IN NUMBER
59 ,x_term_template_id IN NUMBER
60 ,x_abstracted_by IN NUMBER
61 ,x_assessment_date IN DATE
62 ,x_assessment_interval IN NUMBER
63 ,x_spread_frequency IN VARCHAR2
64 ,x_relationship_default IN VARCHAR2
65 ,x_basis_percent_default IN NUMBER
66 ,x_initial_basis IN NUMBER
67 ,x_base_index IN NUMBER
68 ,x_base_index_line_id IN NUMBER
69 ,x_index_finder_method IN VARCHAR2
70 ,x_index_finder_months IN NUMBER
71 ,x_negative_rent_type IN VARCHAR2
72 ,x_increase_on IN VARCHAR2
73 ,x_basis_type IN VARCHAR2
74 ,x_reference_period IN VARCHAR2
75 ,x_base_year IN DATE
76 ,x_leased_area IN NUMBER
77 ,x_rounding_flag IN VARCHAR2
78 ,x_aggregation_flag IN VARCHAR2
79 ,x_gross_flag IN VARCHAR2
80 ,x_last_update_login IN NUMBER
81 ,x_attribute_category IN VARCHAR2
82 ,x_attribute1 IN VARCHAR2
83 ,x_attribute2 IN VARCHAR2
84 ,x_attribute3 IN VARCHAR2
85 ,x_attribute4 IN VARCHAR2
86 ,x_attribute5 IN VARCHAR2
87 ,x_attribute6 IN VARCHAR2
88 ,x_attribute7 IN VARCHAR2
89 ,x_attribute8 IN VARCHAR2
90 ,x_attribute9 IN VARCHAR2
91 ,x_attribute10 IN VARCHAR2
92 ,x_attribute11 IN VARCHAR2
93 ,x_attribute12 IN VARCHAR2
94 ,x_attribute13 IN VARCHAR2
95 ,x_attribute14 IN VARCHAR2
96 ,x_attribute15 IN VARCHAR2
97 ,x_agreement_category IN VARCHAR2
98 ,x_agreement_attribute1 IN VARCHAR2
99 ,x_agreement_attribute2 IN VARCHAR2
100 ,x_agreement_attribute3 IN VARCHAR2
101 ,x_agreement_attribute4 IN VARCHAR2
102 ,x_agreement_attribute5 IN VARCHAR2
103 ,x_agreement_attribute6 IN VARCHAR2
104 ,x_agreement_attribute7 IN VARCHAR2
105 ,x_agreement_attribute8 IN VARCHAR2
106 ,x_agreement_attribute9 IN VARCHAR2
107 ,x_agreement_attribute10 IN VARCHAR2
108 ,x_agreement_attribute11 IN VARCHAR2
109 ,x_agreement_attribute12 IN VARCHAR2
110 ,x_agreement_attribute13 IN VARCHAR2
111 ,x_agreement_attribute14 IN VARCHAR2
112 ,x_agreement_attribute15 IN VARCHAR2
113 ,x_currency_code IN VARCHAR2
114 ,x_carry_forward_flag IN VARCHAR2
115 ,x_retain_initial_basis_flag IN VARCHAR2 DEFAULT NULL
116 ,x_vr_nbp_flag IN VARCHAR2
117 ,x_index_multiplier IN NUMBER
118 ,x_proration_rule IN VARCHAR2
119 ,x_proration_period_start_date IN DATE);
120
121 ------------------------------------------------------------------------
122 -- PROCEDURE : UPDATE_ROW
123 ------------------------------------------------------------------------
124 PROCEDURE update_row (
125 x_rowid IN VARCHAR2
126 ,x_index_lease_id IN NUMBER
127 ,x_lease_id IN NUMBER
128 ,x_index_id IN NUMBER
129 ,x_commencement_date IN DATE
130 ,x_termination_date IN DATE
131 ,x_index_lease_number IN VARCHAR2
132 ,x_last_update_date IN DATE
133 ,x_last_updated_by IN NUMBER
134 ,x_location_id IN NUMBER
135 ,x_term_template_id IN NUMBER
136 ,x_abstracted_by IN NUMBER
137 ,x_assessment_date IN DATE
138 ,x_assessment_interval IN NUMBER
139 ,x_spread_frequency IN VARCHAR2
140 ,x_relationship_default IN VARCHAR2
141 ,x_basis_percent_default IN NUMBER
142 ,x_initial_basis IN NUMBER
143 ,x_base_index IN NUMBER
144 ,x_base_index_line_id IN NUMBER
145 ,x_index_finder_method IN VARCHAR2
146 ,x_index_finder_months IN NUMBER
147 ,x_negative_rent_type IN VARCHAR2
148 ,x_increase_on IN VARCHAR2
149 ,x_basis_type IN VARCHAR2
150 ,x_reference_period IN VARCHAR2
151 ,x_base_year IN DATE
152 ,x_leased_area IN NUMBER
153 ,x_rounding_flag IN VARCHAR2
154 ,x_aggregation_flag IN VARCHAR2
155 ,x_gross_flag IN VARCHAR2
156 ,x_last_update_login IN NUMBER
157 ,x_attribute_category IN VARCHAR2
158 ,x_attribute1 IN VARCHAR2
159 ,x_attribute2 IN VARCHAR2
160 ,x_attribute3 IN VARCHAR2
161 ,x_attribute4 IN VARCHAR2
162 ,x_attribute5 IN VARCHAR2
163 ,x_attribute6 IN VARCHAR2
164 ,x_attribute7 IN VARCHAR2
165 ,x_attribute8 IN VARCHAR2
166 ,x_attribute9 IN VARCHAR2
167 ,x_attribute10 IN VARCHAR2
168 ,x_attribute11 IN VARCHAR2
169 ,x_attribute12 IN VARCHAR2
170 ,x_attribute13 IN VARCHAR2
171 ,x_attribute14 IN VARCHAR2
172 ,x_attribute15 IN VARCHAR2
173 ,x_agreement_category IN VARCHAR2
174 ,x_agreement_attribute1 IN VARCHAR2
175 ,x_agreement_attribute2 IN VARCHAR2
176 ,x_agreement_attribute3 IN VARCHAR2
177 ,x_agreement_attribute4 IN VARCHAR2
178 ,x_agreement_attribute5 IN VARCHAR2
179 ,x_agreement_attribute6 IN VARCHAR2
180 ,x_agreement_attribute7 IN VARCHAR2
181 ,x_agreement_attribute8 IN VARCHAR2
182 ,x_agreement_attribute9 IN VARCHAR2
183 ,x_agreement_attribute10 IN VARCHAR2
184 ,x_agreement_attribute11 IN VARCHAR2
185 ,x_agreement_attribute12 IN VARCHAR2
186 ,x_agreement_attribute13 IN VARCHAR2
187 ,x_agreement_attribute14 IN VARCHAR2
188 ,x_agreement_attribute15 IN VARCHAR2
189 ,x_currency_code IN VARCHAR2
190 ,x_carry_forward_flag IN VARCHAR2
191 ,x_retain_initial_basis_flag IN VARCHAR2 DEFAULT NULL
192 ,x_vr_nbp_flag IN VARCHAR2
193 ,x_index_multiplier IN NUMBER
194 ,x_proration_rule IN VARCHAR2
195 ,x_proration_period_start_date IN DATE);
196
197 ------------------------------------------------------------------------
198 -- PROCEDURE : LOCK_ROW
199 ------------------------------------------------------------------------
200 PROCEDURE lock_row (
201 x_rowid IN VARCHAR2
202 ,x_index_lease_id IN NUMBER
203 ,x_lease_id IN NUMBER
204 ,x_index_id IN NUMBER
205 ,x_commencement_date IN DATE
206 ,x_termination_date IN DATE
207 ,x_index_lease_number IN VARCHAR2
208 ,x_location_id IN NUMBER
209 ,x_term_template_id IN NUMBER
210 ,x_abstracted_by IN NUMBER
211 ,x_assessment_date IN DATE
212 ,x_assessment_interval IN NUMBER
213 ,x_spread_frequency IN VARCHAR2
214 ,x_relationship_default IN VARCHAR2
215 ,x_basis_percent_default IN NUMBER
216 ,x_initial_basis IN NUMBER
217 ,x_base_index IN NUMBER
218 ,x_base_index_line_id IN NUMBER
219 ,x_index_finder_method IN VARCHAR2
220 ,x_index_finder_months IN NUMBER
221 ,x_negative_rent_type IN VARCHAR2
222 ,x_increase_on IN VARCHAR2
223 ,x_basis_type IN VARCHAR2
224 ,x_reference_period IN VARCHAR2
225 ,x_base_year IN DATE
226 ,x_leased_area IN NUMBER
227 ,x_rounding_flag IN VARCHAR2
228 ,x_aggregation_flag IN VARCHAR2
229 ,x_gross_flag IN VARCHAR2
230 ,x_attribute_category IN VARCHAR2
231 ,x_attribute1 IN VARCHAR2
232 ,x_attribute2 IN VARCHAR2
233 ,x_attribute3 IN VARCHAR2
234 ,x_attribute4 IN VARCHAR2
235 ,x_attribute5 IN VARCHAR2
236 ,x_attribute6 IN VARCHAR2
237 ,x_attribute7 IN VARCHAR2
238 ,x_attribute8 IN VARCHAR2
239 ,x_attribute9 IN VARCHAR2
240 ,x_attribute10 IN VARCHAR2
241 ,x_attribute11 IN VARCHAR2
242 ,x_attribute12 IN VARCHAR2
243 ,x_attribute13 IN VARCHAR2
244 ,x_attribute14 IN VARCHAR2
245 ,x_attribute15 IN VARCHAR2
246 ,x_agreement_category IN VARCHAR2
247 ,x_agreement_attribute1 IN VARCHAR2
248 ,x_agreement_attribute2 IN VARCHAR2
249 ,x_agreement_attribute3 IN VARCHAR2
250 ,x_agreement_attribute4 IN VARCHAR2
251 ,x_agreement_attribute5 IN VARCHAR2
252 ,x_agreement_attribute6 IN VARCHAR2
253 ,x_agreement_attribute7 IN VARCHAR2
254 ,x_agreement_attribute8 IN VARCHAR2
255 ,x_agreement_attribute9 IN VARCHAR2
256 ,x_agreement_attribute10 IN VARCHAR2
257 ,x_agreement_attribute11 IN VARCHAR2
258 ,x_agreement_attribute12 IN VARCHAR2
259 ,x_agreement_attribute13 IN VARCHAR2
260 ,x_agreement_attribute14 IN VARCHAR2
261 ,x_agreement_attribute15 IN VARCHAR2
262 ,x_currency_code IN VARCHAR2
263 ,x_carry_forward_flag IN VARCHAR2
264 ,x_retain_initial_basis_flag IN VARCHAR2 DEFAULT NULL
265 ,x_vr_nbp_flag IN VARCHAR2
266 ,x_index_multiplier IN NUMBER
267 ,x_proration_rule IN VARCHAR2
268 ,x_proration_period_start_date IN DATE);
269
270 ------------------------------------------------------------------------
271 -- PROCEDURE : DELETE_ROW
275
272 ------------------------------------------------------------------------
273 PROCEDURE delete_row (
274 x_rowid IN VARCHAR2);
276 -------------------------------------------------------------------------------
277 -- PROCDURE : delete_row
278 -- INVOKED FROM : delete_row procedure
279 -- PURPOSE : deletes the row
280 -- NOTE : overload delete_row to take PK as IN paramter instead of ROWID
281 -- HISTORY :
282 -- 04-JUL-05 hrodda o Bug 4284035 - Created
283 -------------------------------------------------------------------------------
284 PROCEDURE delete_row (
285 x_index_lease_id IN NUMBER);
286
287
288
289 ------------------------------------------------------------------------
290 -- PROCEDURE : CHECK_UNQ_INDEX_LEASE_NUMBER
291 ------------------------------------------------------------------------
292 PROCEDURE check_unq_index_lease_number (
296 END pn_index_leases_pkg;
293 x_return_status IN OUT NOCOPY VARCHAR2
294 ,x_index_lease_id IN NUMBER
295 ,x_index_lease_number IN VARCHAR2);