[Home] [Help]
PACKAGE: APPS.PN_VAREN_PVT
Source
1 PACKAGE pn_varen_pvt AUTHID CURRENT_USER AS
2 /* $Header: PNVARPVS.pls 120.1 2010/12/15 10:21:23 seevivek noship $ */
3 g_api_version_number CONSTANT NUMBER := 1.0;
4 g_pkg_name CONSTANT VARCHAR2 (30) := 'PN_VAREN_PVT';
5 -- g_module_name CONSTANT VARCHAR2 (2) := 'PN';
6 -- g_debug VARCHAR2 (255) := NVL (fnd_profile.VALUE ('PN_DEBUG_MODE')
7 -- , 'N'
8 -- );
9 g_success CONSTANT NUMBER := 0;
10 g_warning CONSTANT NUMBER := 1;
11 g_error CONSTANT NUMBER := 2;
12 g_rowid VARCHAR2 (18) DEFAULT NULL;
13 g_org_id CONSTANT NUMBER := fnd_profile.VALUE ('ORG_ID');
14 --
15 g_user_id CONSTANT NUMBER := fnd_global.user_id;
16 g_login_id CONSTANT NUMBER := fnd_global.login_id;
17 g_sysdate CONSTANT DATE := SYSDATE;
18 -- Declaring Lookup Type constants
19 g_cumulative_vol CONSTANT VARCHAR2 (30) := 'PN_VAR_CALCULATION_METHOD';
20 g_proration_rule CONSTANT VARCHAR2 (30) := 'PN_VAR_PRORATION_RULE';
21 g_invoice_on CONSTANT VARCHAR2 (30) := 'PN_VAR_INVOICE_ON';
22 g_negative_rent CONSTANT VARCHAR2 (30) := 'PN_VAR_NEGATIVE_RENT';
23 g_rent_type CONSTANT VARCHAR2 (30) := 'PN_VAR_RENT_TYPE';
24 g_payment_purpose CONSTANT VARCHAR2 (30) := 'PN_PAYMENT_PURPOSE_TYPE';
25 g_payment_frequency CONSTANT VARCHAR2 (30) := 'PN_PAYMENT_FREQUENCY_TYPE';
26 g_sales_channel CONSTANT VARCHAR2 (30) := 'PN_SALES_CHANNEL';
27 g_item_category CONSTANT VARCHAR2 (30) := 'PN_ITEM_CATEGORY';
28 g_break_type CONSTANT VARCHAR2 (30) := 'PN_VAR_BREAK_TYPE';
29 g_type_code CONSTANT VARCHAR2 (30) := 'PN_MAX_MIN';
30 g_appl_order CONSTANT VARCHAR2 (30) := 'PN_APPLICATION_ORDER';
31 g_excess_abate_code CONSTANT VARCHAR2 (30) := 'PN_EXCESS_ABATEMENT';
32 g_abate_type_code CONSTANT VARCHAR2 (30) := 'PN_ABATEMENT_TYPE';
33 g_pay_terms_status CONSTANT VARCHAR2 (30) := 'PN_INDEX_PAYMENT_TERM_STATUS';
34 g_breakpoint_type CONSTANT VARCHAR2 (30) := 'PN_VAR_BREAKPOINT_TYPE';
35 -- Declaring Descriptive Flexfield Names constants
36 g_varen_desc_name CONSTANT VARCHAR2 (30) := 'PN_VAR_RENTS';
37 -- Need to change the below desc flex names, when they are created
38 g_var_dates_desc_name CONSTANT VARCHAR2 (30) := 'PN_VAR_RENTS';
39 g_var_line_desc_name CONSTANT VARCHAR2 (30) := 'PN_VAR_RENTS';
40 g_bkhd_desc_name CONSTANT VARCHAR2 (30) := 'PN_VAR_RENTS';
41 g_bkdt_desc_name CONSTANT VARCHAR2 (30) := 'PN_VAR_RENTS';
42 g_const_desc_name CONSTANT VARCHAR2 (30) := 'PN_VAR_RENTS';
43 g_abat_desc_name CONSTANT VARCHAR2 (30) := 'PN_VAR_RENTS';
44 g_var_rent_id pn_var_rents_all.var_rent_id%TYPE := NULL;
45 l_var_rent_id pn_var_rents_all.var_rent_id%TYPE := NULL;
46
47 TYPE var_rent_rec_type IS RECORD (
48 lease_id NUMBER := pn_varen_util.g_pn_miss_num
49 , lease_num VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
50 , lease_name VARCHAR2 (50) := pn_varen_util.g_pn_miss_char
51 , location_id NUMBER := pn_varen_util.g_pn_miss_num
52 , location_code VARCHAR2 (90) := pn_varen_util.g_pn_miss_char
53 , rent_num VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
54 , abstracted_by_user_id NUMBER := pn_varen_util.g_pn_miss_num
55 , abstracted_by_user VARCHAR2 (100) := pn_varen_util.g_pn_miss_char
56 , commencement_date DATE := pn_varen_util.g_pn_miss_date
57 , termination_date DATE := pn_varen_util.g_pn_miss_date
58 , term_template_id NUMBER := pn_varen_util.g_pn_miss_num
59 , term_template_name VARCHAR2 (100) := pn_varen_util.g_pn_miss_char
60 , currency_code VARCHAR2 (15) := pn_varen_util.g_pn_miss_char
61 , proration_days NUMBER := pn_varen_util.g_pn_miss_num
62 , agreement_template_id NUMBER := pn_varen_util.g_pn_miss_num
63 , agreement_template_name VARCHAR2 (100) := pn_varen_util.g_pn_miss_char
64 , cumulative_vol_code VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
65 , cumulative_vol_meaning VARCHAR2 (80) := pn_varen_util.g_pn_miss_char
66 , proration_rule_code VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
67 , proration_rule_meaning VARCHAR2 (80) := pn_varen_util.g_pn_miss_char
68 , invoice_on_code VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
69 , invoice_on_meaning VARCHAR2 (80) := pn_varen_util.g_pn_miss_char
70 , negative_rent_code VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
71 , negative_rent_meaning VARCHAR2 (80) := pn_varen_util.g_pn_miss_char
72 , type_code VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
73 , type_meaning VARCHAR2 (80) := pn_varen_util.g_pn_miss_char
74 , purpose_code VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
75 , purpose_code_meaning VARCHAR2 (80) := pn_varen_util.g_pn_miss_char
76 , use_gl_calendar VARCHAR2 (1) := pn_varen_util.g_pn_miss_char
77 , gl_period_set_name VARCHAR2 (15) := pn_varen_util.g_pn_miss_char
78 , period_type VARCHAR2 (15) := pn_varen_util.g_pn_miss_char
79 , reptg_freq_code VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
80 , reptg_freq_meaning VARCHAR2 (80) := pn_varen_util.g_pn_miss_char
81 , reptg_day_of_month NUMBER := pn_varen_util.g_pn_miss_num
82 , reptg_days_after NUMBER := pn_varen_util.g_pn_miss_num
83 , year_start_date DATE := pn_varen_util.g_pn_miss_date
84 , vrg_reptg_freq_code VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
85 , vrg_reptg_freq_meaning VARCHAR2 (80) := pn_varen_util.g_pn_miss_char
86 , invg_day_of_month NUMBER := pn_varen_util.g_pn_miss_num
87 , invg_days_after NUMBER := pn_varen_util.g_pn_miss_num
88 , comments VARCHAR2 (2000) := pn_varen_util.g_pn_miss_char
89 , invg_freq_code VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
90 , invg_freq_meaning VARCHAR2 (80) := pn_varen_util.g_pn_miss_char
91 , last_update_date DATE := pn_varen_util.g_pn_miss_date
92 , last_updated_by NUMBER := pn_varen_util.g_pn_miss_num
93 , creation_date DATE := pn_varen_util.g_pn_miss_date
94 , created_by NUMBER := pn_varen_util.g_pn_miss_num
95 , last_update_login NUMBER := pn_varen_util.g_pn_miss_num
96 , attribute_category VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
97 , attribute1 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
98 , attribute2 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
99 , attribute3 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
100 , attribute4 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
101 , attribute5 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
102 , attribute6 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
103 , attribute7 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
104 , attribute8 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
105 , attribute9 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
106 , attribute10 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
107 , attribute11 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
108 , attribute12 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
109 , attribute13 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
110 , attribute14 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
111 , attribute15 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
112 , dates_attribute_category VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
113 , dates_attribute1 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
114 , dates_attribute2 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
115 , dates_attribute3 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
116 , dates_attribute4 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
117 , dates_attribute5 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
118 , dates_attribute6 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
119 , dates_attribute7 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
120 , dates_attribute8 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
121 , dates_attribute9 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
122 , dates_attribute10 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
123 , dates_attribute11 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
124 , dates_attribute12 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
125 , dates_attribute13 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
126 , dates_attribute14 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
127 , dates_attribute15 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
128 -- , org_id NUMBER
129 );
130
131 TYPE variable_rent_lines_rec_type IS RECORD (
132 line_default_id NUMBER := pn_varen_util.g_pn_miss_num
133 , line_num NUMBER := pn_varen_util.g_pn_miss_num
134 , var_rent_id NUMBER := pn_varen_util.g_pn_miss_num
135 , var_rent_num VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
136 , sales_channel_code VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
137 , sales_channel_meaning VARCHAR2 (80) := pn_varen_util.g_pn_miss_char
138 , item_category_code VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
139 , item_category_meaning VARCHAR2 (80) := pn_varen_util.g_pn_miss_char
140 , agreement_template_id NUMBER := pn_varen_util.g_pn_miss_num
141 , line_start_date DATE := pn_varen_util.g_pn_miss_date
142 , line_end_date DATE := pn_varen_util.g_pn_miss_date
143 , processed_flag NUMBER := pn_varen_util.g_pn_miss_num
144 , last_update_date DATE := pn_varen_util.g_pn_miss_date
145 , last_updated_by NUMBER := pn_varen_util.g_pn_miss_num
146 , creation_date DATE := pn_varen_util.g_pn_miss_date
147 , created_by NUMBER := pn_varen_util.g_pn_miss_num
148 , last_update_login NUMBER := pn_varen_util.g_pn_miss_num
149 , attribute_category VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
150 , attribute1 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
151 , attribute2 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
152 , attribute3 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
153 , attribute4 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
154 , attribute5 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
155 , attribute6 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
156 , attribute7 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
157 , attribute8 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
158 , attribute9 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
159 , attribute10 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
160 , attribute11 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
161 , attribute12 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
162 , attribute13 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
163 , attribute14 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
164 , attribute15 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
165 );
166
167 TYPE variable_rent_lines_tbl_type IS TABLE OF variable_rent_lines_rec_type
168 INDEX BY BINARY_INTEGER;
169
170 TYPE breakpoint_header_rec_type IS RECORD (
171 bkhd_default_id NUMBER := pn_varen_util.g_pn_miss_num
172 , bkhd_detail_num NUMBER := pn_varen_util.g_pn_miss_num
173 , line_default_id NUMBER := pn_varen_util.g_pn_miss_num
174 , bkhd_start_date DATE := pn_varen_util.g_pn_miss_date
175 , bkhd_end_date DATE := pn_varen_util.g_pn_miss_date
176 , break_type_code VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
177 , break_type_meaning VARCHAR2 (80) := pn_varen_util.g_pn_miss_char
178 , natural_break_rate NUMBER := pn_varen_util.g_pn_miss_num
179 , breakpoint_type_code VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
180 , breakpoint_type_meaning VARCHAR2 (80) := pn_varen_util.g_pn_miss_char
181 , var_rent_id NUMBER := pn_varen_util.g_pn_miss_num
182 , last_update_date DATE := pn_varen_util.g_pn_miss_date
183 , last_updated_by NUMBER := pn_varen_util.g_pn_miss_num
184 , creation_date DATE := pn_varen_util.g_pn_miss_date
185 , created_by NUMBER := pn_varen_util.g_pn_miss_num
186 , last_update_login NUMBER := pn_varen_util.g_pn_miss_num
187 , attribute_category VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
188 , attribute1 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
189 , attribute2 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
190 , attribute3 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
191 , attribute4 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
192 , attribute5 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
193 , attribute6 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
194 , attribute7 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
195 , attribute8 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
196 , attribute9 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
197 , attribute10 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
198 , attribute11 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
199 , attribute12 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
200 , attribute13 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
201 , attribute14 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
202 , attribute15 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
203 --, org_id NUMBER
204 );
205
206 TYPE breakpoint_header_tbl_type IS TABLE OF breakpoint_header_rec_type
207 INDEX BY BINARY_INTEGER;
208
209 TYPE breakpoint_details_rec_type IS RECORD (
210 bkdt_default_id NUMBER := pn_varen_util.g_pn_miss_num
211 , bkdt_detail_num NUMBER := pn_varen_util.g_pn_miss_num
212 , bkhd_default_id NUMBER := pn_varen_util.g_pn_miss_num
213 , bkdt_start_date DATE := pn_varen_util.g_pn_miss_date
214 , bkdt_end_date DATE := pn_varen_util.g_pn_miss_date
215 , period_bkpt_vol_start NUMBER := pn_varen_util.g_pn_miss_num
216 , period_bkpt_vol_end NUMBER := pn_varen_util.g_pn_miss_num
217 , group_bkpt_vol_start NUMBER := pn_varen_util.g_pn_miss_num
218 , group_bkpt_vol_end NUMBER := pn_varen_util.g_pn_miss_num
219 , bkpt_rate NUMBER := pn_varen_util.g_pn_miss_num
220 , annual_basis_amount NUMBER := pn_varen_util.g_pn_miss_num
221 , var_rent_id NUMBER := pn_varen_util.g_pn_miss_num
222 , last_update_date DATE := pn_varen_util.g_pn_miss_date
223 , last_updated_by NUMBER := pn_varen_util.g_pn_miss_num
224 , creation_date DATE := pn_varen_util.g_pn_miss_date
225 , created_by NUMBER := pn_varen_util.g_pn_miss_num
226 , last_update_login NUMBER := pn_varen_util.g_pn_miss_num
227 , attribute_category VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
228 , attribute1 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
229 , attribute2 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
230 , attribute3 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
231 , attribute4 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
232 , attribute5 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
233 , attribute6 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
234 , attribute7 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
235 , attribute8 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
236 , attribute9 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
237 , attribute10 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
238 , attribute11 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
239 , attribute12 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
240 , attribute13 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
241 , attribute14 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
242 , attribute15 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
243 );
244
245 TYPE breakpoint_details_tbl_type IS TABLE OF breakpoint_details_rec_type
246 INDEX BY BINARY_INTEGER;
247
248 TYPE constraints_rec_type IS RECORD (
249 constr_default_id NUMBER := pn_varen_util.g_pn_miss_num
250 , constr_default_num NUMBER := pn_varen_util.g_pn_miss_num
251 , var_rent_id NUMBER := pn_varen_util.g_pn_miss_num
252 , var_rent_num VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
253 , agreement_template_id NUMBER := pn_varen_util.g_pn_miss_num
254 , constr_template_id NUMBER := pn_varen_util.g_pn_miss_num
255 , constr_start_date DATE := pn_varen_util.g_pn_miss_date
256 , constr_end_date DATE := pn_varen_util.g_pn_miss_date
257 , constr_cat_code VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
258 , constr_type_code VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
259 , constr_type_meaning VARCHAR2 (80) := pn_varen_util.g_pn_miss_char
260 , constr_amount NUMBER := pn_varen_util.g_pn_miss_num
261 , last_update_date DATE := pn_varen_util.g_pn_miss_date
262 , last_updated_by NUMBER := pn_varen_util.g_pn_miss_num
263 , creation_date DATE := pn_varen_util.g_pn_miss_date
264 , created_by NUMBER := pn_varen_util.g_pn_miss_num
265 , last_update_login NUMBER := pn_varen_util.g_pn_miss_num
266 , attribute_category VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
267 , attribute1 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
268 , attribute2 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
269 , attribute3 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
270 , attribute4 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
271 , attribute5 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
272 , attribute6 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
273 , attribute7 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
274 , attribute8 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
275 , attribute9 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
276 , attribute10 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
277 , attribute11 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
278 , attribute12 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
279 , attribute13 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
280 , attribute14 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
281 , attribute15 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
282 );
283
284 TYPE constraints_tbl_type IS TABLE OF constraints_rec_type
285 INDEX BY BINARY_INTEGER;
286
287 TYPE allow_abat_rec_type IS RECORD (
288 abatement_id NUMBER := pn_varen_util.g_pn_miss_num
289 , var_rent_id NUMBER := pn_varen_util.g_pn_miss_num
290 , var_rent_num VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
291 , abat_type_code VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
292 , abat_type_meaning VARCHAR2 (80) := pn_varen_util.g_pn_miss_char
293 , abat_start_date DATE := pn_varen_util.g_pn_miss_date
294 , abat_end_date DATE := pn_varen_util.g_pn_miss_date
295 , abat_amount NUMBER := pn_varen_util.g_pn_miss_num
296 , description VARCHAR2 (2000) := pn_varen_util.g_pn_miss_char
297 , comments VARCHAR2 (2000) := pn_varen_util.g_pn_miss_char
298 , last_update_date DATE := pn_varen_util.g_pn_miss_date
299 , last_updated_by NUMBER := pn_varen_util.g_pn_miss_num
300 , creation_date DATE := pn_varen_util.g_pn_miss_date
301 , created_by NUMBER := pn_varen_util.g_pn_miss_num
302 , last_update_login NUMBER := pn_varen_util.g_pn_miss_num
303 , attribute_category VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
304 , attribute1 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
305 , attribute2 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
306 , attribute3 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
307 , attribute4 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
308 , attribute5 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
309 , attribute6 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
310 , attribute7 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
311 , attribute8 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
312 , attribute9 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
313 , attribute10 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
314 , attribute11 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
315 , attribute12 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
316 , attribute13 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
317 , attribute14 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
318 , attribute15 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
319 , org_id NUMBER := pn_varen_util.g_pn_miss_num
320 );
321
322 TYPE allow_abat_tbl_type IS TABLE OF allow_abat_rec_type
323 INDEX BY BINARY_INTEGER;
324
325 TYPE upd_var_rent_rec_type IS RECORD (
326 var_rent_id NUMBER := pn_varen_util.g_pn_miss_num
327 , rent_num VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
328 , var_rent_date_id NUMBER := pn_varen_util.g_pn_miss_num
329 , lease_id NUMBER := pn_varen_util.g_pn_miss_num
330 --, lease_num VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
331 --, lease_name VARCHAR2 (50) := pn_varen_util.g_pn_miss_char
332 ,abstracted_by_user_id NUMBER := pn_varen_util.g_pn_miss_num
333 , abstracted_by_user VARCHAR2 (100) := pn_varen_util.g_pn_miss_char
334 , location_id NUMBER := pn_varen_util.g_pn_miss_num
335 , location_code VARCHAR2 (90) := pn_varen_util.g_pn_miss_char
336 , proration_days NUMBER := pn_varen_util.g_pn_miss_num
337 , invg_term NUMBER := pn_varen_util.g_pn_miss_num
338 , commencement_date DATE := pn_varen_util.g_pn_miss_date
339 , termination_date DATE := pn_varen_util.g_pn_miss_date
340 , term_template_id NUMBER := pn_varen_util.g_pn_miss_num
341 , term_template_name VARCHAR2 (100) := pn_varen_util.g_pn_miss_char
342 , currency_code VARCHAR2 (15) := pn_varen_util.g_pn_miss_char
343 , agreement_template_id NUMBER := pn_varen_util.g_pn_miss_num
344 , agreement_template_name VARCHAR2 (100) := pn_varen_util.g_pn_miss_char
345 , cumulative_vol_code VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
346 , cumulative_vol_meaning VARCHAR2 (80) := pn_varen_util.g_pn_miss_char
347 , proration_rule_code VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
348 , proration_rule_meaning VARCHAR2 (80) := pn_varen_util.g_pn_miss_char
349 , invoice_on_code VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
350 , invoice_on_meaning VARCHAR2 (80) := pn_varen_util.g_pn_miss_char
351 , negative_rent_code VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
352 , negative_rent_meaning VARCHAR2 (80) := pn_varen_util.g_pn_miss_char
353 , type_code VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
354 , type_meaning VARCHAR2 (80) := pn_varen_util.g_pn_miss_char
355 , purpose_code VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
356 , purpose_code_meaning VARCHAR2 (80) := pn_varen_util.g_pn_miss_char
357 , use_gl_calendar VARCHAR2 (1) := pn_varen_util.g_pn_miss_char
358 , gl_period_set_name VARCHAR2 (15) := pn_varen_util.g_pn_miss_char
359 , period_type VARCHAR2 (15) := pn_varen_util.g_pn_miss_char
360 , reptg_freq_code VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
361 , reptg_freq_meaning VARCHAR2 (80) := pn_varen_util.g_pn_miss_char
362 , reptg_day_of_month NUMBER := pn_varen_util.g_pn_miss_num
363 , reptg_days_after NUMBER := pn_varen_util.g_pn_miss_num
364 , year_start_date DATE := pn_varen_util.g_pn_miss_date
365 , vrg_reptg_freq_code VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
366 , vrg_reptg_freq_meaning VARCHAR2 (80) := pn_varen_util.g_pn_miss_char
367 , invg_day_of_month NUMBER := pn_varen_util.g_pn_miss_num
368 , invg_days_after NUMBER := pn_varen_util.g_pn_miss_num
369 , comments VARCHAR2 (2000) := pn_varen_util.g_pn_miss_char
370 , invg_freq_code VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
371 , invg_freq_meaning VARCHAR2 (80) := pn_varen_util.g_pn_miss_char
372 , audit_day_of_month NUMBER := pn_varen_util.g_pn_miss_num
373 , audit_days_after NUMBER := pn_varen_util.g_pn_miss_num
374 , recon_day_of_month NUMBER := pn_varen_util.g_pn_miss_num
375 , recon_days_after NUMBER := pn_varen_util.g_pn_miss_num
376 , last_update_date DATE := pn_varen_util.g_pn_miss_date
377 , last_updated_by NUMBER := pn_varen_util.g_pn_miss_num
378 , creation_date DATE := pn_varen_util.g_pn_miss_date
379 , created_by NUMBER := pn_varen_util.g_pn_miss_num
380 , last_update_login NUMBER := pn_varen_util.g_pn_miss_num
381 , attribute_category VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
382 , attribute1 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
383 , attribute2 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
384 , attribute3 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
385 , attribute4 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
386 , attribute5 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
387 , attribute6 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
388 , attribute7 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
389 , attribute8 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
390 , attribute9 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
391 , attribute10 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
392 , attribute11 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
393 , attribute12 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
394 , attribute13 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
395 , attribute14 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
396 , attribute15 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
397 , dates_attribute_category VARCHAR2 (30) := pn_varen_util.g_pn_miss_char
398 , dates_attribute1 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
399 , dates_attribute2 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
400 , dates_attribute3 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
401 , dates_attribute4 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
402 , dates_attribute5 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
403 , dates_attribute6 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
404 , dates_attribute7 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
405 , dates_attribute8 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
406 , dates_attribute9 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
407 , dates_attribute10 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
408 , dates_attribute11 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
409 , dates_attribute12 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
410 , dates_attribute13 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
411 , dates_attribute14 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
412 , dates_attribute15 VARCHAR2 (150) := pn_varen_util.g_pn_miss_char
413 -- , org_id NUMBER
414 );
415
416 PROCEDURE create_var_rent (
417 p_api_version IN NUMBER
418 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
419 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
420 , p_validate_flag IN VARCHAR2 DEFAULT 'N'
421 , p_var_rent_rec IN OUT NOCOPY pn_varen_pvt.var_rent_rec_type
422 , p_variable_rent_lines_tbl IN OUT NOCOPY pn_varen_pvt.variable_rent_lines_tbl_type
423 , p_breakpoint_header_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_header_tbl_type
424 , p_breakpoint_details_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_details_tbl_type
425 , p_constraints_tbl IN OUT NOCOPY pn_varen_pvt.constraints_tbl_type
426 , p_allow_abat_tbl IN OUT NOCOPY pn_varen_pvt.allow_abat_tbl_type
427 , p_generate_periods IN VARCHAR2 DEFAULT 'N'
428 , p_generate_breakpoints IN VARCHAR2 DEFAULT 'N'
429 , p_generate_constraints IN VARCHAR2 DEFAULT 'N'
430 , x_return_status OUT NOCOPY VARCHAR2
431 , x_msg_count OUT NOCOPY NUMBER
432 , x_msg_data OUT NOCOPY VARCHAR2
433 , x_var_rent_id OUT NOCOPY NUMBER
434 , x_var_rent_num OUT NOCOPY VARCHAR2
435 );
436
437 PROCEDURE generate_periods (
438 p_api_version IN NUMBER
439 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
440 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
441 , p_var_rent_id IN NUMBER
442 , p_var_rent_num IN VARCHAR2
443 , p_org_id IN NUMBER
444 , p_generate_periods IN VARCHAR2 DEFAULT 'N'
445 , x_return_status OUT NOCOPY VARCHAR2
446 , x_msg_count OUT NOCOPY NUMBER
447 , x_msg_data OUT NOCOPY VARCHAR2
448 );
449
450 PROCEDURE undo_periods (
451 p_api_version IN NUMBER
452 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
453 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
454 , p_var_rent_id IN NUMBER
455 , p_var_rent_num IN VARCHAR2
456 , p_org_id IN NUMBER
457 , p_generate_periods IN VARCHAR2 DEFAULT 'N'
458 , x_return_status OUT NOCOPY VARCHAR2
459 , x_msg_count OUT NOCOPY NUMBER
460 , x_msg_data OUT NOCOPY VARCHAR2
461 );
462
463 PROCEDURE generate_breakpoints (
464 p_var_rent_id IN NUMBER
465 , p_org_id IN NUMBER
466 , x_return_status OUT NOCOPY VARCHAR2
467 );
468
469 PROCEDURE generate_constraints (
470 p_var_rent_id IN NUMBER
471 , p_org_id IN NUMBER
472 , x_return_status OUT NOCOPY VARCHAR2
473 );
474
475 PROCEDURE create_bkpt_const_allow_abat (
476 p_api_version IN NUMBER
477 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
478 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
479 , p_validate_flag IN VARCHAR2 DEFAULT 'Y'
480 , p_generate_breakpoints IN VARCHAR2 DEFAULT 'Y'
481 , p_generate_constraints IN VARCHAR2 DEFAULT 'Y'
482 , p_variable_rent_lines_tbl IN OUT NOCOPY variable_rent_lines_tbl_type
483 , p_breakpoint_header_tbl IN OUT NOCOPY breakpoint_header_tbl_type
484 , p_breakpoint_details_tbl IN OUT NOCOPY breakpoint_details_tbl_type
485 , p_constraints_tbl IN OUT NOCOPY constraints_tbl_type
486 , p_allow_abat_tbl IN OUT NOCOPY allow_abat_tbl_type
487 , x_return_status OUT NOCOPY VARCHAR2
488 , x_msg_count OUT NOCOPY NUMBER
489 , x_msg_data OUT NOCOPY VARCHAR2
490 );
491
492 PROCEDURE update_var_rent (
493 p_api_version IN NUMBER
494 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
495 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
496 , p_validate_flag IN VARCHAR2 DEFAULT 'Y'
497 , p_upd_var_rent_rec IN OUT NOCOPY upd_var_rent_rec_type
498 , p_var_rent_lines_tbl IN OUT NOCOPY variable_rent_lines_tbl_type
499 , p_breakpoint_header_tbl IN OUT NOCOPY breakpoint_header_tbl_type
500 , p_breakpoint_details_tbl IN OUT NOCOPY breakpoint_details_tbl_type
501 , p_constraints_tbl IN OUT NOCOPY constraints_tbl_type
502 , p_allow_abat_tbl IN OUT NOCOPY allow_abat_tbl_type
503 , p_undo_periods IN VARCHAR2 DEFAULT 'N'
504 , p_undo_breakpoints IN VARCHAR2 DEFAULT 'N'
505 , p_undo_constraints IN VARCHAR2 DEFAULT 'N'
506 , x_return_status OUT NOCOPY VARCHAR2
507 , x_msg_count OUT NOCOPY NUMBER
508 , x_msg_data OUT NOCOPY VARCHAR2
509 );
510
511 PROCEDURE undo_breakpoints (
512 p_var_rent_id IN NUMBER
513 , x_return_status OUT NOCOPY VARCHAR2
514 );
515
516 PROCEDURE undo_constraints (
517 p_var_rent_id IN NUMBER
518 , x_return_status OUT NOCOPY VARCHAR2
519 );
520 END pn_varen_pvt;