[Home] [Help]
PACKAGE: APPS.AR_ARXCCS_XMLP_PKG
Source
1 PACKAGE AR_ARXCCS_XMLP_PKG AS
2 /* $Header: ARXCCSS.pls 120.0 2007/12/27 13:39:29 abraghun noship $ */
3 P_CONC_REQUEST_ID number;
4 P_CUSTOMER_NUMBER_LOW varchar2(30);
5 P_CUSTOMER_NUMBER_HIGH varchar2(30);
6 P_CUSTOMER_NAME_LOW varchar2(50);
7 P_CUSTOMER_NAME_HIGH varchar2(50);
8 P_BUCKET_NAME_LOW varchar2(30);
9 P_BUCKET_NAME_HIGH varchar2(30);
10 P_COLLECTOR_LOW varchar2(30);
11
12 P_COLLECTOR_HIGH varchar2(30);
13 lp_customer_name_low varchar2(800):= ' ';
14 lp_customer_name_high varchar2(800):= ' ';
15 lp_customer_number_low varchar2(800):= ' ';
16 lp_customer_number_high varchar2(800):= ' ';
17 P_COLLECTOR_MAX varchar2(80):= ' ';
18 P_COLLECTOR_MIN varchar2(100):= ' ';
19 lp_coll_name_low varchar2(200):= ' ';
20 lp_coll_name_high varchar2(200):= ' ';
21 P_ATRATE varchar2(1);
22 P_ORG_WHERE_AD varchar2(2000):= ' ';
23 P_ORG_WHERE_PS varchar2(2000):= ' ';
24 P_ORG_WHERE_SU varchar2(2000):= ' ';
25 P_REPORTING_ENTITY_ID number;
26 P_REPORTING_ENTITY_NAME varchar2(240):= ' ';
27 P_REPORTING_LEVEL varchar2(80);
28 P_REPORTING_LEVEL_NAME varchar2(80):= ' ';
29 P_ORG_WHERE_PARAM varchar2(5000):= ' ';
30 C_Contact varchar2(172);
31 C_Phone_Number varchar2(25);
32 c_profile_site_use_id number;
33 c_customer_profile_id number;
34 c_cred_summ_collector varchar2(30);
35 c_cred_summ_exempt_dun varchar2(80);
36 c_cred_summ_terms varchar2(20);
37 c_cred_summ_account_status varchar2(30);
38 c_cred_summ_credit_hold varchar2(80);
39 c_cred_summ_risk_code varchar2(30);
40 c_cred_summ_credit_rating varchar2(30);
41 c_cred_summ_limit_tolerance varchar2(38);
42 c_cred_summ_limit_expire_date varchar2(11);
43 c_last_invoice_days_since varchar2(32767);
44 c_last_invoice_date varchar2(32767);
45 c_last_invoice_converted varchar2(1);
46 c_last_invoice_amount number;
47 c_last_invoice_currency varchar2(15);
48 c_last_invoice_type varchar2(100);
49 c_last_invoice_number varchar2(100);
50 c_last_cm_rel_invoice varchar2(100);
51 c_last_cm_converted varchar2(1);
52 c_last_cm_amount number;
53 c_last_cm_id number;
54 c_last_cm_prev_trx number;
55 c_last_cm_days_since varchar2(32767);
56 c_last_cm_date varchar2(32767);
57 c_last_cm_currency varchar2(20);
58 c_last_cm_type varchar2(100);
59 c_last_cm_number varchar2(100);
60 c_last_guar_days_since varchar2(11);
61 c_last_guar_date varchar2(32767);
62 c_last_guar_converted varchar2(1);
63 c_last_guar_amount number;
64 c_last_guar_currency varchar2(20);
65 c_last_guar_type varchar2(100);
66 c_last_guar_number varchar2(100);
67 c_last_dep_days_since varchar2(11);
68 c_last_dep_date varchar2(11);
69 c_last_dep_converted varchar2(1);
70 c_last_dep_amount number;
71 c_last_dep_currency varchar2(120);
72 c_last_dep_type varchar2(100);
73 c_last_dep_number varchar2(100);
74 c_last_dm_days_since varchar2(11);
75 c_last_dm_date varchar2(11);
76 c_last_dm_converted varchar2(1);
77 c_last_dm_amount number;
78 c_last_dm_currency varchar2(20);
79 c_last_dm_type varchar2(100);
80 c_last_dm_number varchar2(100);
81 c_last_cb_days_since number;
82 c_last_cb_date varchar2(11);
83 c_last_cb_converted varchar2(1);
84 c_last_cb_amount number;
85 c_last_cb_currency varchar2(20);
86 c_last_cb_type varchar2(100);
87 c_last_cb_number varchar2(100);
88 c_last_payment_rel_invoice varchar2(100);
89 c_last_payment_days_since varchar2(32767);
90 c_last_payment_date varchar2(32767);
91 c_last_payment_converted varchar2(1);
92 c_last_payment_amount number;
93 c_last_payment_currency varchar2(20);
94 c_last_payment_type varchar2(100);
95 c_last_payment_number varchar2(100);
96 c_last_adj_days_since varchar2(32767);
97 c_last_adj_date varchar2(32767);
98 c_last_adj_converted varchar2(1);
99 c_last_adj_amount number;
100 c_last_adj_currency varchar2(20);
101 c_last_adj_rel_invoice varchar2(100);
102 c_last_adj_type varchar2(100);
103 c_last_adj_number varchar2(100);
104 c_last_wo_days_since varchar2(32767);
105 c_last_wo_date varchar2(32767);
106 c_last_wo_converted varchar2(1);
107 c_last_wo_amount number;
108 c_last_wo_currency varchar2(20);
109 c_last_wo_rel_invoice varchar2(100);
110 c_last_wo_type varchar2(100);
111 c_last_wo_number varchar2(100);
112 c_last_stmnt_next_trx_date varchar2(32767);
113 c_last_st_date varchar2(32767);
114 c_last_st_type varchar2(100);
115 c_last_st_number varchar2(100);
116 c_last_st_days_since varchar2(32767);
117 c_last_dn_days_since varchar2(32767);
118 c_last_dn_date varchar2(32767);
119 c_last_dn_currency varchar2(20);
120 c_last_dn_amount number;
121 c_last_dn_type varchar2(100);
122 c_last_dn_number varchar2(100);
123 c_last_nsf_currency varchar2(20);
124 c_last_nsf_days_since varchar2(32767);
125 c_last_nsf_date varchar2(32767);
126 c_last_nsf_converted varchar2(1);
127 c_last_nsf_amount number;
128 c_last_nsf_type varchar2(100);
129 c_last_nsf_number varchar2(100);
130 c_last_contact_days_since varchar2(32767);
131 c_last_contact_date varchar2(32767);
132 c_last_contact_amount number;
133 c_last_contact_converted varchar2(1);
134 c_last_contact_currency varchar2(20);
135 c_last_contact_rel_invoice varchar2(100);
136 c_last_contact_number varchar2(100);
137 c_last_hold_days_since varchar2(32767);
138 c_last_hold_date varchar2(32767);
139 c_last_hold_amount number;
140 c_last_hold_number varchar2(100);
141 CP_DEFAULT_FLAG varchar2(1);
142 c_percent_b0 varchar2(32767);
143 c_percent_b1 varchar2(32767);
144 c_percent_b2 varchar2(32767);
145 c_percent_b3 varchar2(32767);
146 c_percent_b4 varchar2(32767);
147 c_percent_b5 varchar2(32767);
148 c_percent_b6 varchar2(32767);
149 c_aging_on_account number:= 0 ;
150 c_aging_unapplied number:= 0 ;
151 c_aging_convert_on_account varchar2(1);
152 c_aging_convert_unapplied varchar2(1);
153 c_aging_credit number;
154 c_aging_convert_credit varchar2(1);
155 c_adjusted_balance number:= 0 ;
156 c_aging_convert_collection varchar2(1);
157 c_aging_in_collection number:= 0 ;
158 c_cust_hist_high_invoice_amt number:= 0 ;
159 c_cust_hist_conv_high_invoice varchar2(1);
160 c_cust_hist_high_invoice_date varchar2(11);
161 c_cust_hist_high_limit_date date;
162 c_ytd_nsf_count number:= 0 ;
163 c_ytd_convert_nsf varchar2(1);
164 c_ytd_nsf_amount number:= 0 ;
165 c_ytd_conv_unearned_discount varchar2(1);
166 c_ytd_unearned_discount_amount number:= 0 ;
167 c_ytd_convert_earned_discount varchar2(1);
168 c_ytd_earned_discount_amount number;
169 c_ytd_on_time_payments_count number:= 0 ;
170 c_ytd_late_payments_count number:= 0 ;
171 c_ytd_average_days_late number:= 0 ;
172 c_ytd_average_payment_days number:= 0 ;
173 c_ytd_finance_charge_count number;
174 c_ytd_convert_finance_charge varchar2(1);
175 c_ytd_finance_charge_amount number:= 0 ;
176 c_ytd_credit_count number:= 0 ;
177 c_ytd_convert_credit varchar2(1);
178 c_ytd_credit_amount number:= 0 ;
179 c_ytd_payment_count number:= 0 ;
180 c_ytd_convert_payment varchar2(1);
181 c_ytd_payment_amount number:= 0 ;
182 c_ytd_sales_count number:= 0 ;
183 c_ytd_convert_sales varchar2(1);
184 c_ytd_sales_amount number:= 0 ;
185 c_ytd_convert_writeoff varchar2(1);
186 c_ytd_writeoff_amount number:= 0 ;
187 CP_limit_currency varchar2(15);
188 CP_related_currencies varchar2(2000);
189 CP_txn_cur varchar2(500);
190 c_cred_summ_convert_limit varchar2(1);
191 c_cred_summ_exceeded number;
192 c_cred_summ_available number;
193 CP_trx_amount number;
194 CP_trx_curr number;
195 CP_limit_curr_amt number;
196 CP_rate number;
197 CP_adjusted_amount number;
198 CP_limit_curr_amt1 number;
199 CP_rate1 number;
200 CP_adjusted_amount1 number;
201 C_cred_summ_exceeded2 number;
202 C_cred_summ_available2 number;
203 C_cred_convert_limit2 varchar2(3);
204 CP_trx_amount2 number;
205 CP_trx_cur2 varchar2(15);
206 C_org_credit_hold varchar2(20);
207 C_org_credit_rating varchar2(20);
208 C_Org_limit_tolerance varchar2(38);
209 C_credit_profile_id number;
210 CP_limit_curr_amt2 number;
211 CP_Rate2 number;
212 CP_adjusted_amount2 number;
213 CP_TRX_AMOUNT1 number;
214 C_CRED_SUMM_AVAILABLE1 number;
215 C_CRED_CONVERT_LIMIT1 varchar2(1);
216 C_CRED_SUMM_EXCEEDED1 number;
217 CP_TRX_CUR1 varchar2(15);
218 DEFAULT_FLAG varchar2(1);
219 LIMIT_CURRENCY varchar2(15);
220 RELATED_CURRENCIES varchar2(200);
221 RP_COMPANY_NAME varchar2(50);
222 RP_REPORT_NAME varchar2(240);
223 RP_DATA_FOUND varchar2(300);
224 RP_DATE_RANGE varchar2(100);
225 RP_BUCKET_DAYS_FROM_0 number;
226 RP_BUCKET_DAYS_FROM_1 number;
227 RP_BUCKET_DAYS_FROM_2 number;
228 RP_BUCKET_DAYS_FROM_3 number;
229 RP_BUCKET_DAYS_FROM_4 number;
230 RP_BUCKET_DAYS_FROM_5 number;
231 RP_BUCKET_DAYS_TO_0 number;
232 RP_BUCKET_DAYS_TO_1 number;
233 RP_BUCKET_DAYS_TO_2 number;
234 RP_BUCKET_DAYS_TO_3 number;
235 RP_BUCKET_DAYS_TO_4 number;
236 RP_BUCKET_DAYS_TO_5 number;
237 RP_BUCKET_LINE_TYPE_0 varchar2(30);
238 RP_BUCKET_LINE_TYPE_1 varchar2(30);
239 RP_BUCKET_LINE_TYPE_2 varchar2(30);
240 RP_BUCKET_LINE_TYPE_3 varchar2(30);
241 RP_BUCKET_LINE_TYPE_4 varchar2(30);
242 RP_BUCKET_LINE_TYPE_5 varchar2(30);
243 RP_BUCKET_TITLE0 varchar2(31);
244 RP_BUCKET_TITLE1 varchar2(31);
245 RP_BUCKET_TITLE2 varchar2(31);
246 RP_BUCKET_TITLE3 varchar2(31);
247 RP_BUCKET_TITLE4 varchar2(31);
248 RP_BUCKET_TITLE5 varchar2(31);
249 RP_BUCKET_CATEGORY varchar2(30);
250 RP_BUCKET_DAYS_FROM_6 number;
251 RP_BUCKET_DAYS_TO_6 number;
252 RP_BUCKET_LINE_TYPE_6 varchar2(30);
253 RP_BUCKET_TITLE6 varchar2(31);
254 C_industry_code varchar2(20);
255 C_sales_title varchar2(20);
256 RP_UNAVAILABLE varchar2(100);
257 RP_YEARS varchar2(100);
258 RP_NONE varchar2(100);
259 RP_NA_UPPER varchar2(100);
260 RP_NO_LIMIT varchar2(100);
261 RP_MESSAGE varchar2(2000);
262 function BeforeReport return boolean ;
263 function AfterReport return boolean ;
264 function report_nameformula(Company_Name in varchar2) return varchar2 ;
265 function c_address_ageformula(address_age in number) return varchar2 ;
266 function c_customer_ageformula(customer_age in number) return varchar2 ;
267 function c_city_state_zipformula(city in varchar2, state in varchar2, postal_code in varchar2) return varchar2 ;
268 --function C_CALC_PERCENTFormula(aging_balance_outstanding in number) return Number ;
269 function C_CALC_PERCENTFormula(aging_balance_outstanding in number,total_cust_b0 in number,total_cust_b1 in number,total_cust_b2 in number,total_cust_b3 in number,total_cust_b4 in number,total_cust_b5 in number,total_cust_b6 in number) return Number;
270 function c_compute_amtformula(functional_currency in varchar2, customer_id in number, site_use_id in number, Currency_Bucket in varchar2, aging_balance_outstanding in number) return number ;
271 function c_high_inv_formulaformula(functional_currency in varchar2, CUSTOMER_ID in number, SITE_USE_ID in number, Currency_Bucket in varchar2) return number ;
272 function c_cust_hist_high_limit_amtform(CUSTOMER_ID_1 in number, site_use_id_1 in number) return number ;
273 --function c_rolling_summary_calcformula(functional_currency in varchar2, customer_id in number, site_use_id --in number, Currency_Bucket in varchar2) return number ;
274 function c_rolling_summary_calcformula(functional_currency in varchar2, customer_id_1 in number, site_use_id in number, Currency_Bucket in varchar2) return number ;
275 function AfterPForm return boolean ;
276 --function c_credit_summaryformula(customer_id in number, site_use_id in number) return number ;
277 function c_credit_summaryformula(customer_id in number, site_use_id_1 in number) return number ;
278
279 --function c_credit_amounts_calcformula(qc_customer in number, qc_site in number) return number ;
280 function c_credit_amounts_calcformula(qc_customer in number,qc_site in number,functional_currency varchar2,currency_credit in varchar2,credit_limit in number) return number;
281 function c_last_invoice_formulaformula(functional_currency in varchar2, CUSTOMER_ID in number, site_use_id in number) return number ;
282 --function c_last_credit_memo_formulaform(CUSTOMER_ID in number, site_use_id in number) return number ;
283 function c_last_credit_memo_formulaform(functional_currency varchar2,CUSTOMER_ID_1 in number, site_use_id_1 in number) return number;
284 function c_guarantee_formulaformula(functional_currency in varchar2, CUSTOMER_ID in number, site_use_id in number) return number ;
285 function c_last_deposit_formulaformula(functional_currency in varchar2, CUSTOMER_ID in number, site_use_id in number) return number ;
286 function c_last_dm_formulaformula(functional_currency in varchar2, CUSTOMER_ID in number, site_use_id in number) return number ;
287 function c_last_cb_formulaformula(functional_currency in varchar2, CUSTOMER_ID in number, site_use_id in number) return number ;
288 function c_last_payment_formulaformula(functional_currency in varchar2, CUSTOMER_ID in number, site_use_id in number) return number ;
289 function c_last_adj_formulaformula(functional_currency in varchar2, CUSTOMER_ID in number, site_use_id in number) return number ;
290 function c_last_writeoff_formulaformula(functional_currency in varchar2, CUSTOMER_ID in number, site_use_id in number) return number ;
291 function c_last_statement_formulaformul(CUSTOMER_ID in number, site_use_id in number) return number ;
292 --function c_last_dn_formulaformula(CUSTOMER_ID in number, site_use_id in number) return number ;
293 function c_last_dn_formulaformula(CUSTOMER_ID_1 in number, site_use_id_1 in number) return number ;
294 function c_last_nsf_formulaformula(functional_currency in varchar2, CUSTOMER_ID in number, site_use_id in number) return number ;
295 --function c_last_contact_formulaformula(functional_currency in varchar2, CUSTOMER_ID in number, site_use_id --in number) return number ;
296 function c_last_contact_formulaformula(functional_currency in varchar2, CUSTOMER_ID_1 in number, site_use_id_1 in number) return number;
297 --function c_last_hold_formulaformula(CUSTOMER_ID in number, site_use_id in number) return number ;
298 function c_last_hold_formulaformula(CUSTOMER_ID_1 in number, site_use_id_1 in number) return number ;
299 function c_data_not_foundformula(customer_name in varchar2) return number ;
300 procedure get_boiler_plates ;
301 procedure get_lookup_meaning(p_lookup_type in varchar2,
302 p_lookup_code in varchar2,
303 p_lookup_meaning in out NOCOPY varchar2)
304 ;
305 function set_display_for_core return boolean ;
306 function set_display_for_gov return boolean ;
307 function sel_contactformula(Address_id in number) return varchar2 ;
308 PROCEDURE Get_Bucket_Data ;
309 function c_currency_lookupformula(site_use_id in number, currency_bucket in varchar2) return number ;
310 function cf_calc_rate_amountformula(trx_cur in varchar2, customer_id in number, site_use_id in number, trx_amount_due in number) return number ;
311 function cf_calc_rate_amount_formula1fo(trx_cur2 in varchar2, customer_id in number, site_use_id in number, trx_amount_due1 in number) return number ;
312 --function c_org_credit_calcformula(customer_id in number, site_use_id in number) return number ;
313 function c_org_credit_calcformula(customer_id in number, site_use_id in number,functional_currency varchar2,Org_Currency_Code varchar2,org_overall_limit number) return number;
314 --function cf_org_calc_amountformula(org_trx_cur in varchar2, customer_id in number, site_use_id in number, --trx_amount_due2 in number) return number ;
315 function cf_org_calc_amountformula(org_trx_cur in varchar2, customer_id in number, site_use_id in number, trx_amount_due2 in number) return number ;
316 --function C_org_profileFormula return Number ;
317 function C_org_profileFormula return Number ;
318 function G_CREDIT_AMOUNTSGroupFilter return boolean ;
319 function G_customer_limitGroupFilter return boolean ;
320 function cf_currency_lookupformula(qc_customer1 in number, currency_credit1 in varchar2, qc_site1 in number, Site_use_id in number) return number ;
321 --function c_credit_amounts_calcformu0114(customer_id in number, site_use_id in number) return number ;
322 function c_credit_amounts_calcformu0114(customer_id in number,site_use_id in number,functional_currency varchar2,Currency_Credit1 varchar2,credit_limit1 number) return number;
323 --function cp_cf_related_currency(p_cust_acct_id number,p_site_use_id number)(p_site_use_id number' --p_cust_acct_id number) return varchar2 ;
324 FUNCTION cp_cf_related_currency(p_cust_acct_id number,p_site_use_id number) RETURN VARCHAR2;
325 Function C_Contact_p return varchar2;
326 Function C_Phone_Number_p return varchar2;
327 Function c_profile_site_use_id_p return number;
328 Function c_customer_profile_id_p return number;
329 Function c_cred_summ_collector_p return varchar2;
330 Function c_cred_summ_exempt_dun_p return varchar2;
331 Function c_cred_summ_terms_p return varchar2;
332 Function c_cred_summ_account_status_p return varchar2;
333 Function c_cred_summ_credit_hold_p return varchar2;
334 Function c_cred_summ_risk_code_p return varchar2;
335 Function c_cred_summ_credit_rating_p return varchar2;
336 Function c_cred_summ_limit_tolerance_p return varchar2;
337 --Function c_cred_summ_limit_expire_date return varchar2;
338 Function c_cred_summ_lt_exp_date_p return varchar2;
339 Function c_last_invoice_days_since_p return varchar2;
340 Function c_last_invoice_date_p return varchar2;
341 Function c_last_invoice_converted_p return varchar2;
342 Function c_last_invoice_amount_p return number;
343 Function c_last_invoice_currency_p return varchar2;
344 Function c_last_invoice_type_p return varchar2;
345 Function c_last_invoice_number_p return varchar2;
346 Function c_last_cm_rel_invoice_p return varchar2;
347 Function c_last_cm_converted_p return varchar2;
348 Function c_last_cm_amount_p return number;
349 Function c_last_cm_id_p return number;
350 Function c_last_cm_prev_trx_p return number;
351 Function c_last_cm_days_since_p return varchar2;
352 Function c_last_cm_date_p return varchar2;
353 Function c_last_cm_currency_p return varchar2;
354 Function c_last_cm_type_p return varchar2;
355 Function c_last_cm_number_p return varchar2;
356 Function c_last_guar_days_since_p return varchar2;
357 Function c_last_guar_date_p return varchar2;
358 Function c_last_guar_converted_p return varchar2;
359 Function c_last_guar_amount_p return number;
360 Function c_last_guar_currency_p return varchar2;
361 Function c_last_guar_type_p return varchar2;
362 Function c_last_guar_number_p return varchar2;
363 Function c_last_dep_days_since_p return varchar2;
364 Function c_last_dep_date_p return varchar2;
365 Function c_last_dep_converted_p return varchar2;
366 Function c_last_dep_amount_p return number;
367 Function c_last_dep_currency_p return varchar2;
368 Function c_last_dep_type_p return varchar2;
369 Function c_last_dep_number_p return varchar2;
370 Function c_last_dm_days_since_p return varchar2;
371 Function c_last_dm_date_p return varchar2;
372 Function c_last_dm_converted_p return varchar2;
373 Function c_last_dm_amount_p return number;
374 Function c_last_dm_currency_p return varchar2;
375 Function c_last_dm_type_p return varchar2;
376 Function c_last_dm_number_p return varchar2;
377 Function c_last_cb_days_since_p return number;
378 Function c_last_cb_date_p return varchar2;
379 Function c_last_cb_converted_p return varchar2;
380 Function c_last_cb_amount_p return number;
381 Function c_last_cb_currency_p return varchar2;
382 Function c_last_cb_type_p return varchar2;
383 Function c_last_cb_number_p return varchar2;
384 Function c_last_payment_rel_invoice_p return varchar2;
385 Function c_last_payment_days_since_p return varchar2;
386 Function c_last_payment_date_p return varchar2;
387 Function c_last_payment_converted_p return varchar2;
388 Function c_last_payment_amount_p return number;
389 Function c_last_payment_currency_p return varchar2;
390 Function c_last_payment_type_p return varchar2;
391 Function c_last_payment_number_p return varchar2;
392 Function c_last_adj_days_since_p return varchar2;
393 Function c_last_adj_date_p return varchar2;
397 Function c_last_adj_rel_invoice_p return varchar2;
394 Function c_last_adj_converted_p return varchar2;
395 Function c_last_adj_amount_p return number;
396 Function c_last_adj_currency_p return varchar2;
398 Function c_last_adj_type_p return varchar2;
399 Function c_last_adj_number_p return varchar2;
400 Function c_last_wo_days_since_p return varchar2;
401 Function c_last_wo_date_p return varchar2;
402 Function c_last_wo_converted_p return varchar2;
403 Function c_last_wo_amount_p return number;
404 Function c_last_wo_currency_p return varchar2;
405 Function c_last_wo_rel_invoice_p return varchar2;
406 Function c_last_wo_type_p return varchar2;
407 Function c_last_wo_number_p return varchar2;
408 Function c_last_stmnt_next_trx_date_p return varchar2;
409 Function c_last_st_date_p return varchar2;
410 Function c_last_st_type_p return varchar2;
411 Function c_last_st_number_p return varchar2;
412 Function c_last_st_days_since_p return varchar2;
413 Function c_last_dn_days_since_p return varchar2;
414 Function c_last_dn_date_p return varchar2;
415 Function c_last_dn_currency_p return varchar2;
416 Function c_last_dn_amount_p return number;
417 Function c_last_dn_type_p return varchar2;
418 Function c_last_dn_number_p return varchar2;
419 Function c_last_nsf_currency_p return varchar2;
420 Function c_last_nsf_days_since_p return varchar2;
421 Function c_last_nsf_date_p return varchar2;
422 Function c_last_nsf_converted_p return varchar2;
423 Function c_last_nsf_amount_p return number;
424 Function c_last_nsf_type_p return varchar2;
425 Function c_last_nsf_number_p return varchar2;
426 Function c_last_contact_days_since_p return varchar2;
427 Function c_last_contact_date_p return varchar2;
428 Function c_last_contact_amount_p return number;
429 Function c_last_contact_converted_p return varchar2;
430 Function c_last_contact_currency_p return varchar2;
431 Function c_last_contact_rel_invoice_p return varchar2;
432 Function c_last_contact_number_p return varchar2;
433 Function c_last_hold_days_since_p return varchar2;
434 Function c_last_hold_date_p return varchar2;
435 Function c_last_hold_amount_p return number;
436 Function c_last_hold_number_p return varchar2;
437 Function CP_DEFAULT_FLAG_p return varchar2;
438 Function c_percent_b0_p return varchar2;
439 Function c_percent_b1_p return varchar2;
440 Function c_percent_b2_p return varchar2;
441 Function c_percent_b3_p return varchar2;
442 Function c_percent_b4_p return varchar2;
443 Function c_percent_b5_p return varchar2;
444 Function c_percent_b6_p return varchar2;
445 Function c_aging_on_account_p return number;
446 Function c_aging_unapplied_p return number;
447 Function c_aging_convert_on_account_p return varchar2;
448 Function c_aging_convert_unapplied_p return varchar2;
449 Function c_aging_credit_p return number;
450 Function c_aging_convert_credit_p return varchar2;
451 Function c_adjusted_balance_p return number;
452 Function c_aging_convert_collection_p return varchar2;
453 Function c_aging_in_collection_p return number;
454 Function c_cust_hist_high_invoice_amt_p return number;
455 --Function c_cust_hist_conv_high_invoice return varchar2;
456 Function c_cust_hist_conv_high_inv_p return varchar2;
457 --Function c_cust_hist_high_invoice_date return varchar2;
458 Function c_cust_hist_high_inv_date_p return varchar2;
459 Function c_cust_hist_high_limit_date_p return date;
460 Function c_ytd_nsf_count_p return number;
461 Function c_ytd_convert_nsf_p return varchar2;
465 --Function c_ytd_convert_earned_discount return varchar2;
462 Function c_ytd_nsf_amount_p return number;
463 Function c_ytd_conv_unearned_discount_p return varchar2;
464 Function c_ytd_unearned_discount_amoun return number;
466 Function c_ytd_convert_earned_dis_p return varchar2;
467 Function c_ytd_earned_discount_amount_p return number;
468 Function c_ytd_on_time_payments_count_p return number;
469 Function c_ytd_late_payments_count_p return number;
470 Function c_ytd_average_days_late_p return number;
471 Function c_ytd_average_payment_days_p return number;
472 Function c_ytd_finance_charge_count_p return number;
473 Function c_ytd_convert_finance_charge_p return varchar2;
474 Function c_ytd_finance_charge_amount_p return number;
475 Function c_ytd_credit_count_p return number;
476 Function c_ytd_convert_credit_p return varchar2;
477 Function c_ytd_credit_amount_p return number;
478 Function c_ytd_payment_count_p return number;
479 Function c_ytd_convert_payment_p return varchar2;
480 Function c_ytd_payment_amount_p return number;
481 Function c_ytd_sales_count_p return number;
482 Function c_ytd_convert_sales_p return varchar2;
483 Function c_ytd_sales_amount_p return number;
484 Function c_ytd_convert_writeoff_p return varchar2;
485 Function c_ytd_writeoff_amount_p return number;
486 Function CP_limit_currency_p return varchar2;
487 Function CP_related_currencies_p return varchar2;
488 Function CP_txn_cur_p return varchar2;
489 Function c_cred_summ_convert_limit_p return varchar2;
490 Function c_cred_summ_exceeded_p return number;
491 Function c_cred_summ_available_p return number;
492 Function CP_trx_amount_p return number;
493 Function CP_trx_curr_p return number;
494 Function CP_limit_curr_amt_p return number;
495 Function CP_rate_p return number;
496 Function CP_adjusted_amount_p return number;
497 Function CP_limit_curr_amt1_p return number;
498 Function CP_rate1_p return number;
499 Function CP_adjusted_amount1_p return number;
500 Function C_cred_summ_exceeded2_p return number;
501 Function C_cred_summ_available2_p return number;
502 Function C_cred_convert_limit2_p return varchar2;
503 Function CP_trx_amount2_p return number;
504 Function CP_trx_cur2_p return varchar2;
505 Function C_org_credit_hold_p return varchar2;
506 Function C_org_credit_rating_p return varchar2;
507 Function C_Org_limit_tolerance_p return varchar2;
508 Function C_credit_profile_id_p return number;
509 Function CP_limit_curr_amt2_p return number;
510 Function CP_Rate2_p return number;
511 Function CP_adjusted_amount2_p return number;
512 Function CP_TRX_AMOUNT1_p return number;
513 Function C_CRED_SUMM_AVAILABLE1_p return number;
514 Function C_CRED_CONVERT_LIMIT1_p return varchar2;
515 Function C_CRED_SUMM_EXCEEDED1_p return number;
516 Function CP_TRX_CUR1_p return varchar2;
517 Function DEFAULT_FLAG_p return varchar2;
518 Function LIMIT_CURRENCY_p return varchar2;
519 Function RELATED_CURRENCIES_p return varchar2;
520 Function RP_COMPANY_NAME_p return varchar2;
521 Function RP_REPORT_NAME_p return varchar2;
522 Function RP_DATA_FOUND_p return varchar2;
523 Function RP_DATE_RANGE_p return varchar2;
524 Function RP_BUCKET_DAYS_FROM_0_p return number;
525 Function RP_BUCKET_DAYS_FROM_1_p return number;
526 Function RP_BUCKET_DAYS_FROM_2_p return number;
527 Function RP_BUCKET_DAYS_FROM_3_p return number;
528 Function RP_BUCKET_DAYS_FROM_4_p return number;
529 Function RP_BUCKET_DAYS_FROM_5_p return number;
530 Function RP_BUCKET_DAYS_TO_0_p return number;
531 Function RP_BUCKET_DAYS_TO_1_p return number;
532 Function RP_BUCKET_DAYS_TO_2_p return number;
533 Function RP_BUCKET_DAYS_TO_3_p return number;
534 Function RP_BUCKET_DAYS_TO_4_p return number;
535 Function RP_BUCKET_DAYS_TO_5_p return number;
539 Function RP_BUCKET_LINE_TYPE_3_p return varchar2;
536 Function RP_BUCKET_LINE_TYPE_0_p return varchar2;
537 Function RP_BUCKET_LINE_TYPE_1_p return varchar2;
538 Function RP_BUCKET_LINE_TYPE_2_p return varchar2;
540 Function RP_BUCKET_LINE_TYPE_4_p return varchar2;
541 Function RP_BUCKET_LINE_TYPE_5_p return varchar2;
542 Function RP_BUCKET_TITLE0_p return varchar2;
543 Function RP_BUCKET_TITLE1_p return varchar2;
544 Function RP_BUCKET_TITLE2_p return varchar2;
545 Function RP_BUCKET_TITLE3_p return varchar2;
546 Function RP_BUCKET_TITLE4_p return varchar2;
547 Function RP_BUCKET_TITLE5_p return varchar2;
548 Function RP_BUCKET_CATEGORY_p return varchar2;
549 Function RP_BUCKET_DAYS_FROM_6_p return number;
550 Function RP_BUCKET_DAYS_TO_6_p return number;
551 Function RP_BUCKET_LINE_TYPE_6_p return varchar2;
552 Function RP_BUCKET_TITLE6_p return varchar2;
553 Function C_industry_code_p return varchar2;
554 Function C_sales_title_p return varchar2;
555 Function RP_UNAVAILABLE_p return varchar2;
556 Function RP_YEARS_p return varchar2;
557 Function RP_NONE_p return varchar2;
558 Function RP_NA_UPPER_p return varchar2;
559 Function RP_NO_LIMIT_p return varchar2;
560 Function RP_MESSAGE_p return varchar2;
561
562 transactions_exist boolean := false;
563 last_txn_profile_id number;
564 txn_currency VARCHAR2(2000);
565 -- default_flag varchar2(1):= 'N';
566 END AR_ARXCCS_XMLP_PKG;
567
568