[Home] [Help]
PACKAGE: APPS.AR_RAXGLR_XMLP_PKG
Source
1 PACKAGE AR_RAXGLR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: RAXGLRS.pls 120.1 2008/01/07 14:53:40 abraghun noship $ */
3 P_CONC_REQUEST_ID NUMBER;
4
5 P_SORT_BY VARCHAR2(50);
6
7 P_START_GL_DATE DATE;
8
9 P_END_GL_DATE DATE;
10
11 P_CURRENCY_CODE VARCHAR2(32767);
12
13 P_MIN_GL_FLEX VARCHAR2(200);
14
15 P_MAX_GL_FLEX VARCHAR2(200);
16
17 P_GL_ACCOUNT_TYPE VARCHAR2(32767);
18
19 P_POSTING_STATUS VARCHAR2(32767);
20
21 P_WHERE_1 VARCHAR2(200) := ' ';
22
23 P_SELECT_1 VARCHAR2(2000);
24
25 P_WHERE_GL_TYPE VARCHAR2(200);
26
27 P_COAID NUMBER;
28
29 ACCT_FLEX_ALL_SEG_SEL VARCHAR2(500);
30
31 ACCT_FLEX_BAL_SEG_SEL VARCHAR2(500);
32
33 ACCT_FLEX_ACCT_SEG_SEL VARCHAR2(500);
34
35 ACCT_FLEX_BAL_SEG_OB VARCHAR2(500);
36
37 P_GLDATE_LOW DATE;
38
39 P_GLDATE_HIGH DATE;
40
41 LP_START_GL_DATE VARCHAR2(500):=' ';
42
43 LP_END_GL_DATE VARCHAR2(500):=' ';
44
45 WHERE_GL_FLEX_CLAUSE VARCHAR2(4000);
46
47 P_CONS_PROFILE_VALUE VARCHAR2(10);
48
49 LP_QUERY_SHOW_BILL VARCHAR2(1000):='trx.trx_number';
50
51 LP_TABLE_SHOW_BILL VARCHAR2(1000):=' ';
52
53 LP_WHERE_SHOW_BILL VARCHAR2(1000):=' ';
54
55 P_CA_SET_OF_BOOKS_ID NUMBER;
56
57 P_CA_ORG_ID NUMBER;
58
59 P_MRCSOBTYPE VARCHAR2(10) := 'P';
60
61 LP_AR_SYSTEM_PARAMETERS VARCHAR2(50) := 'ar_system_parameters';
62
63 LP_AR_SYSTEM_PARAMETERS_ALL VARCHAR2(50) := 'ar_system_parameters_all';
64
65 LP_AR_PAYMENT_SCHEDULES VARCHAR2(50) := 'ar_payment_schedules';
66
67 LP_AR_PAYMENT_SCHEDULES_ALL VARCHAR2(50) := 'ar_payment_schedules_all';
68
69 LP_AR_ADJUSTMENTS VARCHAR2(50) := 'ar_adjustments';
70
71 LP_AR_ADJUSTMENTS_ALL VARCHAR2(50) := 'ar_adjustments_all';
72
73 LP_AR_BATCHES VARCHAR2(50) := 'ar_batches';
74
75 LP_AR_BATCHES_ALL VARCHAR2(50) := 'ar_batches_all';
76
77 LP_AR_CASH_RECEIPT_HISTORY_ALL VARCHAR2(50) := 'ar_cash_receipt_history_all';
78
79 LP_AR_CASH_RECEIPT_HISTORY VARCHAR2(50) := 'ar_cash_receipt_history';
80
81 LP_AR_CASH_RECEIPTS VARCHAR2(50) := 'ar_cash_receipts';
82
83 LP_AR_CASH_RECEIPTS_ALL VARCHAR2(50) := 'ar_cash_receipts_all';
84
85 LP_AR_DISTRIBUTIONS VARCHAR2(50) := 'ar_xla_ard_lines_v';
86
87 LP_AR_DISTRIBUTIONS_ALL VARCHAR2(50) := 'ar_xla_ard_lines_v';
88
89 LP_RA_CUSTOMER_TRX VARCHAR2(50) := 'ra_customer_trx';
90
91 LP_RA_CUSTOMER_TRX_ALL VARCHAR2(50) := 'ra_customer_trx_all';
92
93 LP_RA_CUST_TRX_GL_DIST VARCHAR2(50) := 'AR_XLA_CTLGD_LINES_V';
94
95 LP_RA_CUST_TRX_GL_DIST_ALL VARCHAR2(50) := 'AR_XLA_CTLGD_LINES_V';
96
97 LP_RA_BATCHES VARCHAR2(50) := 'ra_batches';
98
99 LP_RA_BATCHES_ALL VARCHAR2(50) := 'ra_batches_all';
100
101 LP_AR_MISC_CASH_DISTS VARCHAR2(50) := 'AR_MISC_CASH_DISTRIBUTIONS';
102
103 LP_AR_MISC_CASH_DISTS_ALL VARCHAR2(50) := 'AR_MISC_CASH_DISTRIBUTIONS_ALL';
104
105 LP_AR_RATE_ADJUSTMENTS VARCHAR2(50) := 'AR_RATE_ADJUSTMENTS';
106
107 LP_AR_RATE_ADJUSTMENTS_ALL VARCHAR2(50) := 'AR_RATE_ADJUSTMENTS_ALL';
108
109 LP_AR_RECEIVABLE_APPS VARCHAR2(50) := 'AR_RECEIVABLE_APPLICATIONS';
110
111 LP_AR_RECEIVABLE_APPS_ALL VARCHAR2(50) := 'AR_RECEIVABLE_APPLICATIONS_ALL';
112
113 P_REPORTING_ENTITY_ID NUMBER;
114
115 P_REPORTING_ENTITY_NAME VARCHAR2(200);
116
117 P_REPORTING_LEVEL VARCHAR2(30);
118
119 P_REPORTING_LEVEL_NAME VARCHAR2(30);
120
121 P_ORG_WHERE_CUST_ACCT VARCHAR2(2000):=' ';
122
123 P_ORG_WHERE_TRX VARCHAR2(2000):=' ';
124
125 P_ORG_WHERE_PS VARCHAR2(2000):=' ';
126
127 P_ORG_WHERE_CI VARCHAR2(2000):=' ';
128
129 P_ORG_WHERE_GL_DIST VARCHAR2(2000):=' ';
130
131 P_ZERO_ROUND VARCHAR2(1);
132
133 P_CUSTOMER_LOW VARCHAR2(200);
134
135 P_CUSTOMER_HIGH VARCHAR2(200);
136
137 P_CUSTOMER_NUMBER_LOW VARCHAR2(200);
138
139 P_CUSTOMER_NUMBER_HIGH VARCHAR2(200);
140
141 P_TRX_DATE_LOW DATE;
142
143 P_TRX_DATE_HIGH DATE;
144
145 P_TRX_TYPE_LOW VARCHAR2(200);
146
147 P_TRX_TYPE_HIGH VARCHAR2(200);
148
149 P_TRX_NUMBER_LOW VARCHAR2(200);
150
151 P_TRX_NUMBER_HIGH VARCHAR2(200);
152
153 LP_CUSTOMER_LOW VARCHAR2(200):=' ';
154
155 LP_CUSTOMER_HIGH VARCHAR2(200):=' ';
156
157 LP_CUSTOMER_NUMBER_LOW VARCHAR2(200):=' ';
158
159 LP_CUSTOMER_NUMBER_HIGH VARCHAR2(200):=' ';
160
161 LP_TRX_DATE_LOW VARCHAR2(200):=' ';
162
163 LP_TRX_DATE_HIGH VARCHAR2(200):=' ';
164
165 LP_TRX_TYPE_LOW VARCHAR2(200):=' ';
166
167 LP_TRX_TYPE_HIGH VARCHAR2(200):=' ';
168
169 LP_TRX_NUMBER_LOW VARCHAR2(200):=' ';
170
171 LP_TRX_NUMBER_HIGH VARCHAR2(200):=' ';
172
173 LP_ZERO_ROUND VARCHAR2(2000):=' ';
174
175 P_PRG_WHERE_CUST_ACCT VARCHAR2(40);
176
177 P_ORG_WHERE_DIST VARCHAR2(40);
178
179 ACCT_BAL_APROMPT VARCHAR2(80);
180
181 RP_COMPANY_NAME VARCHAR2(50);
182
183 RP_REPORT_NAME VARCHAR2(240);
184
185 RP_DATA_FOUND VARCHAR2(3);
186
187 RP_REPORT_SUBTITLE VARCHAR2(60);
188
189 GSUM_FUNC_CR_AMT VARCHAR2(50);
190
191 GSUM_FUNC_DR_AMT VARCHAR2(50);
192
193 GSUM_CURR_CR_AMT VARCHAR2(50);
194
195 GSUM_CURR_DR_AMT VARCHAR2(50);
196
197 C_CURR_CODE_REV VARCHAR2(32767) := 'USD';
198
199 C_CURR_CODE_TAX VARCHAR2(32767) := 'USD';
200
201 C_CURR_CODE_REC VARCHAR2(32767) := 'USD';
202
203 GSUM_FUNC_CREDIT_AMT NUMBER;
204
205 GSUM_FUNC_DEBIT_AMT NUMBER;
206
207 GSUM_CURR_CREDIT_AMT NUMBER;
208
209 GSUM_CURR_DEBIT_AMT NUMBER;
210
211 RP_MESSAGE VARCHAR2(2000);
212
213 CP_ACC_MESSAGE VARCHAR2(2000);
214
215 FUNCTION AFTERREPORT RETURN BOOLEAN;
216
217 FUNCTION REPORT_NAMEFORMULA(COMPANY_NAME IN VARCHAR2) RETURN VARCHAR2;
218
219 FUNCTION REPORT_SUBTITLEFORMULA RETURN VARCHAR2;
220
221 FUNCTION C_SUM_TEXTFORMULA RETURN VARCHAR2;
222
223 FUNCTION SET_CURR_CODE_REVFORMULA(CURRENCY_CODE_REV IN VARCHAR2) RETURN VARCHAR2;
224
225 FUNCTION SET_CURR_CODE_TAXFORMULA(CURRENCY_CODE_TAX IN VARCHAR2) RETURN VARCHAR2;
226
227 FUNCTION SET_CURR_CODE_RECFORMULA(CURRENCY_CODE_REC IN VARCHAR2) RETURN VARCHAR2;
228
229 FUNCTION TRX_NUMBER_CONSFORMULA(TRX_NUMBER IN VARCHAR2
230 ,CONS_BILLING_NUMBER IN VARCHAR2) RETURN VARCHAR2;
231
232 FUNCTION TRX_NUMBER_TAX_CONSFORMULA(TRX_NUMBER_TAX IN VARCHAR2
233 ,CONS_BILLING_NUMBER_TAX IN VARCHAR2) RETURN VARCHAR2;
234
235 FUNCTION TRX_NUMBER_REC_CONSFORMULA(TRX_NUMBER_REC IN VARCHAR2
236 ,CONS_BILLING_NUMBER_REC IN VARCHAR2) RETURN VARCHAR2;
237
238 FUNCTION AFTERPFORM RETURN BOOLEAN;
239
240 FUNCTION BEFOREREPORT RETURN BOOLEAN;
241
242 FUNCTION C_GL_ACCOUNT_TYPE_MEANINGFORMU RETURN VARCHAR2;
243
244 FUNCTION C_ORDER_BY_MEANINGFORMULA RETURN VARCHAR2;
245
246 FUNCTION C_POSTING_STATUS_MEANINGFORMUL RETURN VARCHAR2;
247
248 FUNCTION ACCT_BAL_APROMPT_P RETURN VARCHAR2;
249
250 FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
251
252 FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
253
254 FUNCTION RP_DATA_FOUND_P RETURN VARCHAR2;
255
256 FUNCTION RP_REPORT_SUBTITLE_P RETURN VARCHAR2;
257
258 FUNCTION GSUM_FUNC_CR_AMT_P RETURN VARCHAR2;
259
260 FUNCTION GSUM_FUNC_DR_AMT_P RETURN VARCHAR2;
261
262 FUNCTION GSUM_CURR_CR_AMT_P RETURN VARCHAR2;
263
264 FUNCTION GSUM_CURR_DR_AMT_P RETURN VARCHAR2;
265
266 FUNCTION C_CURR_CODE_REV_P RETURN VARCHAR2;
267
268 FUNCTION C_CURR_CODE_TAX_P RETURN VARCHAR2;
269
270 FUNCTION C_CURR_CODE_REC_P RETURN VARCHAR2;
271
272 FUNCTION GSUM_FUNC_CREDIT_AMT_P RETURN NUMBER;
273
274 FUNCTION GSUM_FUNC_DEBIT_AMT_P RETURN NUMBER;
275
276 FUNCTION GSUM_CURR_CREDIT_AMT_P RETURN NUMBER;
277
278 FUNCTION GSUM_CURR_DEBIT_AMT_P RETURN NUMBER;
279
280 FUNCTION RP_MESSAGE_P RETURN VARCHAR2;
281
282 FUNCTION CP_ACC_MESSAGE_P RETURN VARCHAR2;
283
284 END AR_RAXGLR_XMLP_PKG;
285