[Home] [Help]
PACKAGE: APPS.AR_ARXASR_XMLP_PKG
Source
1 PACKAGE AR_ARXASR_XMLP_PKG AS
2 /* $Header: ARXASRS.pls 120.0 2007/12/27 13:33:46 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_ORDER_BY varchar2(50);
9 P_SET_OF_BOOKS_ID number;
10 P_COLLECTOR_NAME_LOW varchar2(30);
11 P_COLLECTOR_NAME_HIGH varchar2(30);
12 P_START_ACCOUNT_STATUS varchar2(30);
13 P_END_ACCOUNT_STATUS varchar2(30);
14 lp_order_by varchar2(200):=' ';
15 lp_customer_name_low varchar2(500):=' ';
16 lp_customer_name_high varchar2(500):=' ';
17 lp_customer_number_low varchar2(500):=' ';
18 lp_customer_number_high varchar2(500):=' ';
19 lp_collector_name_low varchar2(500):=' ';
20 lp_collector_name_high varchar2(500):=' ';
21 lp_start_account_status1 varchar2(500):=' ';
22 lp_end_account_status1 varchar2(500):=' ';
23 P_CONS_PROFILE_VALUE varchar2(10);
24 LP_QUERY_SHOW_BILL varchar2(1000):=' ';
25 LP_TABLE_SHOW_BILL varchar2(1000):=' ';
26 LP_WHERE_SHOW_BILL varchar2(1000):=' ';
27 p_ca_set_of_books_id number;
28 p_ca_org_id number;
29 p_mrcsobtype varchar2(10);
30 lp_ar_system_parameters varchar2(50):=' ';
31 lp_ar_system_parameters_all varchar2(50):=' ';
32 lp_ar_payment_schedules varchar2(50):=' ';
33 lp_ar_payment_schedules_all varchar2(50):=' ';
34 lp_ar_adjustments varchar2(50):=' ';
35 lp_ar_adjustments_all varchar2(50):=' ';
36 lp_ar_batches varchar2(50):=' ';
37 lp_ar_batches_all varchar2(50):=' ';
38 lp_ar_cash_receipt_history_all varchar2(50):=' ';
39 lp_ar_cash_receipt_history varchar2(50):=' ';
40 lp_ar_cash_receipts varchar2(50):=' ';
41 lp_ar_cash_receipts_all varchar2(50):=' ';
42 lp_ar_distributions varchar2(50):=' ';
43 lp_ar_distributions_all varchar2(50):=' ';
44 lp_ra_customer_trx varchar2(50):=' ';
45 lp_ra_customer_trx_all varchar2(50):=' ';
46 lp_ra_cust_trx_gl_dist varchar2(50):=' ';
47 lp_ra_cust_trx_gl_dist_all varchar2(50):=' ';
48 lp_ra_batches varchar2(50):=' ';
49 lp_ra_batches_all varchar2(50):=' ';
50 lp_ar_misc_cash_dists varchar2(50):=' ';
51 lp_ar_misc_cash_dists_all varchar2(50):=' ';
52 lp_ar_rate_adjustments varchar2(50):=' ';
53 lp_ar_rate_adjustments_all varchar2(50):=' ';
54 lp_ar_receivable_apps varchar2(50):=' ';
55 lp_ar_receivable_apps_all varchar2(50):=' ';
56 LP_START_ACCOUNT_STATUS2 varchar2(500):=' ';
57 LP_END_ACCOUNT_STATUS2 varchar2(500):=' ';
58 RP_COMPANY_NAME varchar2(50);
59 RP_REPORT_NAME varchar2(240);
60 RP_DATA_FOUND varchar2(100);
61 RPD_REPORT_SUMMARY varchar2(17);
62 function BeforeReport return boolean ;
63 function AfterReport return boolean ;
64 function report_nameformula(Company_Name in varchar2) return varchar2 ;
65 function AfterPForm return boolean ;
66 function c_status_summary_labelformula(status in varchar2) return varchar2 ;
67 function c_data_not_foundformula(status in varchar2) return number ;
68 Function RP_COMPANY_NAME_p return varchar2;
69 Function RP_REPORT_NAME_p return varchar2;
70 Function RP_DATA_FOUND_p return varchar2;
71 Function RPD_REPORT_SUMMARY_p return varchar2;
72 END AR_ARXASR_XMLP_PKG;
73