1 PACKAGE pnt_payment_terms_pkg AS
2 -- $Header: PNTPYTRS.pls 120.7 2007/05/31 06:33:31 lbala ship $
3
4 tlinfo PN_PAYMENT_TERMS_ALL%ROWTYPE;
5
6 TYPE dist_rec IS RECORD(
7 distribution_id PN_DISTRIBUTIONS.distribution_id%TYPE,
8 account_id PN_DISTRIBUTIONS.account_id%TYPE,
9 account_class PN_DISTRIBUTIONS.account_class%TYPE,
10 percentage PN_DISTRIBUTIONS.percentage%TYPE,
11 line_number PN_DISTRIBUTIONS.line_number%TYPE,
12 attribute_category PN_DISTRIBUTIONS.attribute_category%TYPE,
13 attribute1 PN_DISTRIBUTIONS.attribute1%TYPE,
14 attribute2 PN_DISTRIBUTIONS.attribute2%TYPE,
15 attribute3 PN_DISTRIBUTIONS.attribute3%TYPE,
16 attribute4 PN_DISTRIBUTIONS.attribute4%TYPE,
17 attribute5 PN_DISTRIBUTIONS.attribute5%TYPE,
18 attribute6 PN_DISTRIBUTIONS.attribute6%TYPE,
19 attribute7 PN_DISTRIBUTIONS.attribute7%TYPE,
20 attribute8 PN_DISTRIBUTIONS.attribute8%TYPE,
21 attribute9 PN_DISTRIBUTIONS.attribute9%TYPE,
22 attribute10 PN_DISTRIBUTIONS.attribute10%TYPE,
23 attribute11 PN_DISTRIBUTIONS.attribute11%TYPE,
24 attribute12 PN_DISTRIBUTIONS.attribute12%TYPE,
25 attribute13 PN_DISTRIBUTIONS.attribute13%TYPE,
26 attribute14 PN_DISTRIBUTIONS.attribute14%TYPE,
27 attribute15 PN_DISTRIBUTIONS.attribute15%TYPE,
28 term_template_id PN_DISTRIBUTIONS.term_template_id%TYPE,
29 org_id PN_DISTRIBUTIONS.org_id%TYPE);
30
31 TYPE dist_type IS
32 TABLE OF dist_rec
33 INDEX BY BINARY_INTEGER;
34
35 hist_dist_tab dist_type;
36
37 PROCEDURE INSERT_ROW (
38 x_rowid IN OUT NOCOPY VARCHAR2,
39 x_payment_term_id IN OUT NOCOPY NUMBER,
40 x_payment_purpose_code IN VARCHAR2,
41 x_payment_term_type_code IN VARCHAR2,
42 x_frequency_code IN VARCHAR2,
43 x_lease_id IN NUMBER,
44 x_lease_change_id IN NUMBER,
45 x_start_date IN DATE,
46 x_end_date IN DATE,
47 x_vendor_id IN NUMBER DEFAULT NULL,
48 x_vendor_site_id IN NUMBER DEFAULT NULL,
49 x_customer_id IN NUMBER DEFAULT NULL,
50 x_customer_site_use_id IN NUMBER DEFAULT NULL,
51 x_target_date IN DATE DEFAULT NULL,
52 x_actual_amount IN NUMBER,
53 x_estimated_amount IN NUMBER,
54 x_set_of_books_id IN NUMBER,
55 x_currency_code IN VARCHAR2,
56 x_rate IN NUMBER,
57 x_normalize IN VARCHAR2 DEFAULT NULL,
58 x_location_id IN NUMBER DEFAULT NULL,
59 x_schedule_day IN NUMBER DEFAULT NULL,
60 x_cust_ship_site_id IN NUMBER DEFAULT NULL,
61 x_ap_ar_term_id IN NUMBER DEFAULT NULL,
62 x_cust_trx_type_id IN NUMBER DEFAULT NULL,
63 x_project_id IN NUMBER DEFAULT NULL,
64 x_task_id IN NUMBER DEFAULT NULL,
65 x_organization_id IN NUMBER DEFAULT NULL,
66 x_expenditure_type IN VARCHAR2 DEFAULT NULL,
67 x_expenditure_item_date IN DATE DEFAULT NULL,
68 x_tax_group_id IN NUMBER DEFAULT NULL,
69 x_tax_code_id IN NUMBER DEFAULT NULL,
70 x_tax_classification_code IN VARCHAR2 DEFAULT NULL,
71 x_tax_included IN VARCHAR2 DEFAULT NULL,
72 x_distribution_set_id IN NUMBER DEFAULT NULL,
73 x_inv_rule_id IN NUMBER DEFAULT NULL,
74 x_account_rule_id IN NUMBER DEFAULT NULL,
75 x_salesrep_id IN NUMBER DEFAULT NULL,
76 x_approved_by IN NUMBER DEFAULT NULL,
77 x_status IN VARCHAR2 DEFAULT NULL,
78 x_index_period_id IN NUMBER DEFAULT NULL,
79 x_index_term_indicator IN VARCHAR2 DEFAULT NULL,
80 x_po_header_id IN NUMBER DEFAULT NULL,
81 x_cust_po_number IN VARCHAR2 DEFAULT NULL,
82 x_receipt_method_id IN NUMBER DEFAULT NULL,
83 x_var_rent_inv_id IN NUMBER DEFAULT NULL,
84 x_var_rent_type IN VARCHAR2 DEFAULT NULL,
85 x_period_billrec_id IN NUMBER DEFAULT NULL,
86 x_rec_agr_line_id IN NUMBER DEFAULT NULL,
87 x_amount_type IN VARCHAR2 DEFAULT NULL,
88 x_changed_flag IN VARCHAR2 DEFAULT NULL,
89 x_term_template_id IN NUMBER DEFAULT NULL,
90 x_attribute_category IN VARCHAR2 DEFAULT NULL,
91 x_attribute1 IN VARCHAR2 DEFAULT NULL,
92 x_attribute2 IN VARCHAR2 DEFAULT NULL,
93 x_attribute3 IN VARCHAR2 DEFAULT NULL,
94 x_attribute4 IN VARCHAR2 DEFAULT NULL,
95 x_attribute5 IN VARCHAR2 DEFAULT NULL,
96 x_attribute6 IN VARCHAR2 DEFAULT NULL,
97 x_attribute7 IN VARCHAR2 DEFAULT NULL,
98 x_attribute8 IN VARCHAR2 DEFAULT NULL,
99 x_attribute9 IN VARCHAR2 DEFAULT NULL,
100 x_attribute10 IN VARCHAR2 DEFAULT NULL,
101 x_attribute11 IN VARCHAR2 DEFAULT NULL,
102 x_attribute12 IN VARCHAR2 DEFAULT NULL,
103 x_attribute13 IN VARCHAR2 DEFAULT NULL,
104 x_attribute14 IN VARCHAR2 DEFAULT NULL,
105 x_attribute15 IN VARCHAR2 DEFAULT NULL,
106 x_project_attribute_category IN VARCHAR2 DEFAULT NULL,
107 x_project_attribute1 IN VARCHAR2 DEFAULT NULL,
108 x_project_attribute2 IN VARCHAR2 DEFAULT NULL,
109 x_project_attribute3 IN VARCHAR2 DEFAULT NULL,
110 x_project_attribute4 IN VARCHAR2 DEFAULT NULL,
111 x_project_attribute5 IN VARCHAR2 DEFAULT NULL,
112 x_project_attribute6 IN VARCHAR2 DEFAULT NULL,
113 x_project_attribute7 IN VARCHAR2 DEFAULT NULL,
114 x_project_attribute8 IN VARCHAR2 DEFAULT NULL,
115 x_project_attribute9 IN VARCHAR2 DEFAULT NULL,
116 x_project_attribute10 IN VARCHAR2 DEFAULT NULL,
117 x_project_attribute11 IN VARCHAR2 DEFAULT NULL,
118 x_project_attribute12 IN VARCHAR2 DEFAULT NULL,
119 x_project_attribute13 IN VARCHAR2 DEFAULT NULL,
120 x_project_attribute14 IN VARCHAR2 DEFAULT NULL,
121 x_project_attribute15 IN VARCHAR2 DEFAULT NULL,
122 x_creation_date IN DATE,
123 x_created_by IN NUMBER,
124 x_last_update_date IN DATE,
125 x_last_updated_by IN NUMBER,
126 x_last_update_login IN NUMBER,
127 x_calling_form IN VARCHAR2 DEFAULT 'PNTLEASE',
128 x_org_id IN NUMBER,
129 x_lease_status IN VARCHAR2 DEFAULT 'ACT',
130 x_recoverable_flag IN VARCHAR2 DEFAULT NULL,
131 x_area_type_code IN VARCHAR2 DEFAULT NULL,
132 x_area IN NUMBER DEFAULT NULL,
133 x_grouping_rule_id IN NUMBER DEFAULT NULL,
134 x_term_altered_flag IN VARCHAR2 DEFAULT NULL,
135 x_source_code IN VARCHAR2 DEFAULT NULL,
136 x_term_comments IN VARCHAR2 DEFAULT NULL,
137 x_norm_start_date IN DATE DEFAULT NULL,
138 x_parent_term_id IN NUMBER DEFAULT NULL,
139 x_index_norm_flag IN VARCHAR2 DEFAULT NULL,
140 x_include_in_var_rent IN VARCHAR2 DEFAULT NULL, --03-NOV-2003
141 x_recur_bb_calc_date IN DATE DEFAULT NULL,
142 x_opex_agr_id IN NUMBER DEFAULT NULL,
143 x_opex_recon_id IN NUMBER DEFAULT NULL,
144 x_opex_type IN VARCHAR2 DEFAULT NULL
145 );
146
147 PROCEDURE LOCK_ROW (
148 x_payment_term_id IN NUMBER,
149 x_payment_purpose_code IN VARCHAR2,
150 x_payment_term_type_code IN VARCHAR2,
151 x_frequency_code IN VARCHAR2,
152 x_lease_id IN NUMBER,
153 x_lease_change_id IN NUMBER,
154 x_start_date IN DATE,
155 x_end_date IN DATE,
156 x_vendor_id IN NUMBER DEFAULT NULL,
157 x_vendor_site_id IN NUMBER DEFAULT NULL,
158 x_customer_id IN NUMBER DEFAULT NULL,
159 x_customer_site_use_id IN NUMBER DEFAULT NULL,
160 x_target_date IN DATE,
161 x_actual_amount IN NUMBER,
162 x_estimated_amount IN NUMBER,
163 x_set_of_books_id IN NUMBER,
164 x_currency_code IN VARCHAR2,
165 x_rate IN NUMBER,
166 x_normalize IN VARCHAR2 DEFAULT NULL,
167 x_location_id IN NUMBER DEFAULT NULL,
168 x_schedule_day IN NUMBER DEFAULT NULL,
169 x_cust_ship_site_id IN NUMBER DEFAULT NULL,
170 x_ap_ar_term_id IN NUMBER DEFAULT NULL,
171 x_cust_trx_type_id IN NUMBER DEFAULT NULL,
172 x_project_id IN NUMBER DEFAULT NULL,
173 x_task_id IN NUMBER DEFAULT NULL,
174 x_organization_id IN NUMBER DEFAULT NULL,
175 x_expenditure_type IN VARCHAR2 DEFAULT NULL,
176 x_expenditure_item_date IN DATE DEFAULT NULL,
177 x_tax_group_id IN NUMBER DEFAULT NULL,
178 x_tax_code_id IN NUMBER DEFAULT NULL,
179 x_tax_classification_code IN VARCHAR2 DEFAULT NULL,
180 x_tax_included IN VARCHAR2 DEFAULT NULL,
181 x_distribution_set_id IN NUMBER DEFAULT NULL,
182 x_inv_rule_id IN NUMBER DEFAULT NULL,
183 x_account_rule_id IN NUMBER DEFAULT NULL,
184 x_salesrep_id IN NUMBER DEFAULT NULL,
185 x_approved_by IN NUMBER DEFAULT NULL,
186 x_status IN VARCHAR2 DEFAULT NULL,
187 x_index_period_id IN NUMBER DEFAULT NULL,
188 x_index_term_indicator IN VARCHAR2 DEFAULT NULL,
189 x_po_header_id IN NUMBER DEFAULT NULL,
190 x_cust_po_number IN VARCHAR2 DEFAULT NULL,
191 x_receipt_method_id IN NUMBER DEFAULT NULL,
192 x_var_rent_inv_id IN NUMBER DEFAULT NULL,
193 x_var_rent_type IN VARCHAR2 DEFAULT NULL,
194 x_changed_flag IN VARCHAR2 DEFAULT NULL,
195 x_attribute_category IN VARCHAR2 DEFAULT NULL,
196 x_attribute1 IN VARCHAR2 DEFAULT NULL,
197 x_attribute2 IN VARCHAR2 DEFAULT NULL,
198 x_attribute3 IN VARCHAR2 DEFAULT NULL,
199 x_attribute4 IN VARCHAR2 DEFAULT NULL,
200 x_attribute5 IN VARCHAR2 DEFAULT NULL,
201 x_attribute6 IN VARCHAR2 DEFAULT NULL,
202 x_attribute7 IN VARCHAR2 DEFAULT NULL,
203 x_attribute8 IN VARCHAR2 DEFAULT NULL,
204 x_attribute9 IN VARCHAR2 DEFAULT NULL,
205 x_attribute10 IN VARCHAR2 DEFAULT NULL,
206 x_attribute11 IN VARCHAR2 DEFAULT NULL,
207 x_attribute12 IN VARCHAR2 DEFAULT NULL,
208 x_attribute13 IN VARCHAR2 DEFAULT NULL,
209 x_attribute14 IN VARCHAR2 DEFAULT NULL,
210 x_attribute15 IN VARCHAR2 DEFAULT NULL,
211 x_project_attribute_category IN VARCHAR2 DEFAULT NULL,
212 x_project_attribute1 IN VARCHAR2 DEFAULT NULL,
213 x_project_attribute2 IN VARCHAR2 DEFAULT NULL,
214 x_project_attribute3 IN VARCHAR2 DEFAULT NULL,
215 x_project_attribute4 IN VARCHAR2 DEFAULT NULL,
216 x_project_attribute5 IN VARCHAR2 DEFAULT NULL,
217 x_project_attribute6 IN VARCHAR2 DEFAULT NULL,
218 x_project_attribute7 IN VARCHAR2 DEFAULT NULL,
219 x_project_attribute8 IN VARCHAR2 DEFAULT NULL,
220 x_project_attribute9 IN VARCHAR2 DEFAULT NULL,
221 x_project_attribute10 IN VARCHAR2 DEFAULT NULL,
222 x_project_attribute11 IN VARCHAR2 DEFAULT NULL,
223 x_project_attribute12 IN VARCHAR2 DEFAULT NULL,
224 x_project_attribute13 IN VARCHAR2 DEFAULT NULL,
225 x_project_attribute14 IN VARCHAR2 DEFAULT NULL,
226 x_project_attribute15 IN VARCHAR2 DEFAULT NULL,
227 x_recoverable_flag IN VARCHAR2,
228 x_area_type_code IN VARCHAR2,
229 x_area IN NUMBER,
230 x_grouping_rule_id IN NUMBER DEFAULT NULL,
231 x_term_comments IN VARCHAR2 DEFAULT NULL,
232 x_term_template_id IN NUMBER DEFAULT NULL,
233 x_include_in_var_rent IN VARCHAR2 DEFAULT NULL, --03-NOV-2003
234 x_recur_bb_calc_date IN DATE DEFAULT NULL,
235 x_opex_agr_id IN NUMBER DEFAULT NULL,
236 x_opex_recon_id IN NUMBER DEFAULT NULL,
237 x_opex_type IN VARCHAR2 DEFAULT NULL
238 );
239
240 PROCEDURE UPDATE_ROW (
241 x_payment_term_id IN NUMBER,
242 x_payment_purpose_code IN VARCHAR2,
243 x_payment_term_type_code IN VARCHAR2,
244 x_frequency_code IN VARCHAR2,
245 x_lease_id IN NUMBER,
246 x_lease_change_id IN NUMBER,
247 x_start_date IN DATE,
248 x_end_date IN DATE,
249 x_vendor_id IN NUMBER DEFAULT NULL,
250 x_vendor_site_id IN NUMBER DEFAULT NULL,
251 x_customer_id IN NUMBER DEFAULT NULL,
252 x_customer_site_use_id IN NUMBER DEFAULT NULL,
253 x_target_date IN DATE,
254 x_actual_amount IN NUMBER,
255 x_estimated_amount IN NUMBER,
256 x_set_of_books_id IN NUMBER,
257 x_currency_code IN VARCHAR2,
258 x_rate IN NUMBER,
259 x_normalize IN VARCHAR2 DEFAULT NULL,
260 x_location_id IN NUMBER DEFAULT NULL,
261 x_schedule_day IN NUMBER DEFAULT NULL,
262 x_cust_ship_site_id IN NUMBER DEFAULT NULL,
263 x_ap_ar_term_id IN NUMBER DEFAULT NULL,
264 x_cust_trx_type_id IN NUMBER DEFAULT NULL,
265 x_project_id IN NUMBER DEFAULT NULL,
266 x_task_id IN NUMBER DEFAULT NULL,
267 x_organization_id IN NUMBER DEFAULT NULL,
268 x_expenditure_type IN VARCHAR2 DEFAULT NULL,
269 x_expenditure_item_date IN DATE DEFAULT NULL,
270 x_tax_group_id IN NUMBER DEFAULT NULL,
271 x_tax_code_id IN NUMBER DEFAULT NULL,
272 x_tax_classification_code IN VARCHAR2 DEFAULT NULL,
273 x_tax_included IN VARCHAR2 DEFAULT NULL,
274 x_distribution_set_id IN NUMBER DEFAULT NULL,
275 x_inv_rule_id IN NUMBER DEFAULT NULL,
276 x_account_rule_id IN NUMBER DEFAULT NULL,
277 x_salesrep_id IN NUMBER DEFAULT NULL,
278 x_approved_by IN NUMBER DEFAULT NULL,
279 x_status IN VARCHAR2 DEFAULT NULL,
280 x_index_period_id IN NUMBER DEFAULT NULL,
281 x_index_term_indicator IN VARCHAR2 DEFAULT NULL,
282 x_po_header_id IN NUMBER DEFAULT NULL,
283 x_cust_po_number IN VARCHAR2 DEFAULT NULL,
284 x_receipt_method_id IN NUMBER DEFAULT NULL,
285 x_var_rent_inv_id IN NUMBER DEFAULT NULL,
286 x_var_rent_type IN VARCHAR2 DEFAULT NULL,
287 x_changed_flag IN VARCHAR2 DEFAULT NULL,
288 x_attribute_category IN VARCHAR2 DEFAULT NULL,
289 x_attribute1 IN VARCHAR2 DEFAULT NULL,
290 x_attribute2 IN VARCHAR2 DEFAULT NULL,
291 x_attribute3 IN VARCHAR2 DEFAULT NULL,
292 x_attribute4 IN VARCHAR2 DEFAULT NULL,
293 x_attribute5 IN VARCHAR2 DEFAULT NULL,
294 x_attribute6 IN VARCHAR2 DEFAULT NULL,
295 x_attribute7 IN VARCHAR2 DEFAULT NULL,
296 x_attribute8 IN VARCHAR2 DEFAULT NULL,
297 x_attribute9 IN VARCHAR2 DEFAULT NULL,
298 x_attribute10 IN VARCHAR2 DEFAULT NULL,
299 x_attribute11 IN VARCHAR2 DEFAULT NULL,
300 x_attribute12 IN VARCHAR2 DEFAULT NULL,
301 x_attribute13 IN VARCHAR2 DEFAULT NULL,
302 x_attribute14 IN VARCHAR2 DEFAULT NULL,
303 x_attribute15 IN VARCHAR2 DEFAULT NULL,
304 x_project_attribute_category IN VARCHAR2 DEFAULT NULL,
305 x_project_attribute1 IN VARCHAR2 DEFAULT NULL,
306 x_project_attribute2 IN VARCHAR2 DEFAULT NULL,
307 x_project_attribute3 IN VARCHAR2 DEFAULT NULL,
308 x_project_attribute4 IN VARCHAR2 DEFAULT NULL,
309 x_project_attribute5 IN VARCHAR2 DEFAULT NULL,
310 x_project_attribute6 IN VARCHAR2 DEFAULT NULL,
311 x_project_attribute7 IN VARCHAR2 DEFAULT NULL,
312 x_project_attribute8 IN VARCHAR2 DEFAULT NULL,
313 x_project_attribute9 IN VARCHAR2 DEFAULT NULL,
314 x_project_attribute10 IN VARCHAR2 DEFAULT NULL,
315 x_project_attribute11 IN VARCHAR2 DEFAULT NULL,
316 x_project_attribute12 IN VARCHAR2 DEFAULT NULL,
317 x_project_attribute13 IN VARCHAR2 DEFAULT NULL,
318 x_project_attribute14 IN VARCHAR2 DEFAULT NULL,
319 x_project_attribute15 IN VARCHAR2 DEFAULT NULL,
320 x_last_update_date IN DATE,
321 x_last_updated_by IN NUMBER,
322 x_last_update_login IN NUMBER,
323 x_recoverable_flag IN VARCHAR2,
324 x_area_type_code IN VARCHAR2,
325 x_area IN NUMBER,
326 x_grouping_rule_id IN NUMBER DEFAULT NULL,
327 x_term_altered_flag IN VARCHAR2 DEFAULT NULL,
328 x_source_code IN VARCHAR2 DEFAULT NULL,
329 x_term_comments IN VARCHAR2 DEFAULT NULL,
330 x_term_template_id IN NUMBER DEFAULT NULL,
331 x_include_in_var_rent IN VARCHAR2 DEFAULT NULL,
332 x_recur_bb_calc_date IN DATE DEFAULT NULL,
333 x_opex_agr_id IN NUMBER DEFAULT NULL,
334 x_opex_recon_id IN NUMBER DEFAULT NULL,
335 x_opex_type IN VARCHAR2 DEFAULT NULL
336 );
337
338 PROCEDURE DELETE_ROW (
339 x_payment_term_id IN NUMBER
340 );
341
342 PROCEDURE CHECK_PAYMENT_AMOUNTS
343 (
344 x_return_status IN OUT NOCOPY VARCHAR2
345 ,x_actual_amount IN NUMBER
346 ,x_estimated_amount IN NUMBER
347 );
348
349 PROCEDURE UPDATE_VENDOR_AND_CUST
350 (
351 x_payment_term_id IN NUMBER
352 ,x_vendor_id IN NUMBER
353 ,x_vendor_site_id IN NUMBER
354 ,x_last_update_date IN DATE
355 ,x_last_updated_by IN NUMBER
356 ,x_last_update_login IN NUMBER
357 ,x_customer_id IN NUMBER
358 ,x_customer_site_use_id IN NUMBER
359 ,x_cust_ship_site_id IN NUMBER
360 );
361
362
363 PROCEDURE CHECK_APPROVED_SCHEDULE_EXISTS (
364 x_return_status IN OUT NOCOPY VARCHAR2
365 ,x_lease_id IN NUMBER
366 ,x_start_date IN DATE
367 ,x_end_date IN DATE
368 ,x_schedule_day IN NUMBER
369 );
370
371 PROCEDURE create_hist_corr_upd(p_term_id IN NUMBER,
372 p_dist_changed IN NUMBER,
373 p_hist_dist_tab IN dist_type,
374 p_change_mode IN VARCHAR2,
375 p_eff_str_dt IN DATE,
376 p_eff_end_dt IN DATE);
377
378 FUNCTION return_agreement_number( p_payment_term_id IN NUMBER) RETURN VARCHAR2;
379
380 FUNCTION get_source_module_type( p_payment_term_id IN NUMBER ) RETURN VARCHAR2;
381
382 PROCEDURE MODIFY_ROW ( x_payment_term_id IN NUMBER
383 ,x_var_rent_inv_id IN NUMBER
384 ,x_changed_flag IN VARCHAR2 );
385
386 END pnt_payment_terms_pkg;