[Home] [Help]
PACKAGE: APPS.JE_JEHUIAGE_XMLP_PKG
Source
1 PACKAGE JE_JEHUIAGE_XMLP_PKG AS
2 /* $Header: JEHUIAGES.pls 120.1 2007/12/25 16:55:02 dwkrishn noship $ */
3 P_DEBUG_SWITCH VARCHAR2(1);
4
5 P_CONC_REQUEST_ID NUMBER := 0;
6
7 P_MIN_PRECISION NUMBER;
8
9 P_FLEXDATA VARCHAR2(600);
10
11 P_LEDGER_ID NUMBER;
12
13 P_SORT_OPTION VARCHAR2(32767);
14
15 P_SUMMARY_OPTION VARCHAR2(15);
16
17 P_FORMAT_OPTION VARCHAR2(32767);
18
19 P_AMOUNT_DUE_LOW NUMBER;
20
21 P_AMOUNT_DUE_HIGH NUMBER;
22
23 P_INVOICE_TYPE VARCHAR2(30);
24
25 P_VENDOR_ID VARCHAR2(30);
26
27 P_PERIOD_TYPE VARCHAR2(50);
28
29 P_ORDER_BY VARCHAR2(1000) := 'order by 2,8,10,17,19,23,15';
30
31 P_VENDOR_PREDICATE VARCHAR2(100):=' ';
32
33 P_TRACE_SWITCH VARCHAR2(1);
34
35 P_AMT_DUE_LOW VARCHAR2(40);
36
37 P_AMT_DUE_HIGH VARCHAR2(40);
38
39 P_AMOUNT_PREDICATE VARCHAR2(200);
40
41 SORT_BY_ALTERNATE VARCHAR2(5);
42
43 P_REPORT_TYPE VARCHAR2(32767);
44
45 P_SELECT_CHECK_NUMBER VARCHAR2(200) := 'to_char(c.check_number)';
46
47 P_CHECK_AMOUNT_PREDICATE VARCHAR2(200):=' ';
48
49 P_LEGAL_ENTITY_ID NUMBER;
50
51 P_LEDGER_NAME NUMBER;
52
53 P_LEGAL_ENTITY_NAME NUMBER;
54
55 C_BASE_CURRENCY_CODE VARCHAR2(15);
56
57 C_BASE_PRECISION NUMBER;
58
59 C_BASE_MIN_ACCT_UNIT NUMBER;
60
61 C_BASE_DESCRIPTION VARCHAR2(240);
62
63 C_COMPANY_NAME_HEADER VARCHAR2(50);
64
65 C_REPORT_START_DATE DATE;
66
67 C_NLS_YES VARCHAR2(80);
68
69 C_NLS_NO VARCHAR2(80);
70
71 C_NLS_ALL VARCHAR2(80);
72
73 C_NLS_NO_DATA_EXISTS VARCHAR2(240);
74
75 C_REPORT_RUN_TIME VARCHAR2(8);
76
77 C_CHART_OF_ACCOUNTS_ID NUMBER;
78
79 C_VENDOR_NAME_SELECT VARCHAR2(240);
80
81 C_INVOICE_TYPE_SELECT VARCHAR2(80);
82
83 C_MINDAYS NUMBER;
84
85 C_MAXDAYS NUMBER;
86
87 C_INV_DUE_1_HEAD_1 VARCHAR2(15);
88
89 C_INV_DUE_1_HEAD_2 VARCHAR2(15);
90
91 C_INV_DUE_2_HEAD_1 VARCHAR2(15);
92
93 C_INV_DUE_2_HEAD_2 VARCHAR2(15);
94
95 C_INV_DUE_3_HEAD_1 VARCHAR2(15);
96
97 C_INV_DUE_3_HEAD_2 VARCHAR2(15);
98
99 C_INV_DUE_4_HEAD_1 VARCHAR2(15);
100
101 C_INV_DUE_4_HEAD_2 VARCHAR2(15);
102
103 C_INV_DUE_1_RANGE_FR NUMBER;
104
105 C_INV_DUE_1_RANGE_TO NUMBER;
106
107 C_INV_DUE_2_RANGE_FR NUMBER;
108
109 C_INV_DUE_2_RANGE_TO NUMBER;
110
111 C_INV_DUE_3_RANGE_FR NUMBER;
112
113 C_INV_DUE_3_RANGE_TO NUMBER;
114
115 C_INV_DUE_4_RANGE_FR NUMBER;
116
117 C_INV_DUE_4_RANGE_TO NUMBER;
118
119 C_HEAD_INVOICE_TYPE VARCHAR2(80);
120
121 C_HEAD_SORT_OPTION VARCHAR2(80);
122
123 C_HEAD_VENDOR_NAME VARCHAR2(240);
124
125 C_REP_DATA_CONVERTED VARCHAR2(1);
126
127 C_NLS_END_OF_REPORT VARCHAR2(80);
128
129 C_HEAD_SUMMARY_OPTION VARCHAR2(80);
130
131 C_HEAD_FORMAT_OPTION VARCHAR2(80);
132
133 C_HEAD_LEDGER_NAME VARCHAR2(30);
134
135 C_HEAD_LEGAL_ENTITY_NAME VARCHAR2(80) := ':C_NLS_ALL';
136
137 FUNCTION GET_BASE_CURR_DATA RETURN BOOLEAN;
138
139 FUNCTION CUSTOM_INIT RETURN BOOLEAN;
140
141 FUNCTION GET_COVER_PAGE_VALUES RETURN BOOLEAN;
142
143 FUNCTION GET_NLS_STRINGS RETURN BOOLEAN;
144
145 FUNCTION BEFOREREPORT RETURN BOOLEAN;
146
147 FUNCTION AFTERREPORT RETURN BOOLEAN;
148
149 FUNCTION GET_COMPANY_NAME RETURN BOOLEAN;
150
151 FUNCTION SET_ORDER_BY RETURN BOOLEAN;
152
153 FUNCTION GET_PERIOD_INFO RETURN BOOLEAN;
154
155 FUNCTION C_CONTACT_LINEFORMULA(C_CONTACT_SITE_ID IN NUMBER) RETURN VARCHAR2;
156
157 FUNCTION C_PERCENT_REMAININGFORMULA(C_AMT_DUE_ORIGINAL IN NUMBER
158 ,C_AMT_DUE_REMAINING IN NUMBER) RETURN NUMBER;
159
160 FUNCTION C_INV_DUE_AMT_1FORMULA(C_DAYS_PAST_DUE IN NUMBER
161 ,C_AMT_DUE_REMAINING IN NUMBER) RETURN NUMBER;
162
163 FUNCTION C_INV_DUE_AMT_2FORMULA(C_DAYS_PAST_DUE IN NUMBER
164 ,C_AMT_DUE_REMAINING IN NUMBER) RETURN NUMBER;
165
166 FUNCTION C_INV_DUE_AMT_3FORMULA(C_DAYS_PAST_DUE IN NUMBER
167 ,C_AMT_DUE_REMAINING IN NUMBER) RETURN NUMBER;
168
169 FUNCTION C_INV_DUE_AMT_4FORMULA(C_DAYS_PAST_DUE IN NUMBER
170 ,C_AMT_DUE_REMAINING IN NUMBER) RETURN NUMBER;
171
172 FUNCTION C_PER_V_INV_AMT_1FORMULA(C_SUM_V_INV_AMT_1 IN NUMBER
173 ,C_SUM_V_DUE_REMAINING IN NUMBER) RETURN NUMBER;
174
175 FUNCTION C_PER_V_INV_AMT_2FORMULA(C_SUM_V_INV_AMT_2 IN NUMBER
176 ,C_SUM_V_DUE_REMAINING IN NUMBER) RETURN NUMBER;
177
178 FUNCTION C_PER_V_INV_AMT_3FORMULA(C_SUM_V_INV_AMT_3 IN NUMBER
179 ,C_SUM_V_DUE_REMAINING IN NUMBER) RETURN NUMBER;
180
181 FUNCTION C_PER_V_INV_AMT_4FORMULA(C_SUM_V_INV_AMT_4 IN NUMBER
182 ,C_SUM_V_DUE_REMAINING IN NUMBER) RETURN NUMBER;
183
184 FUNCTION C_CHECK_DATA_CONVERTEDFORMULA(C_DATA_CONVERTED IN VARCHAR2) RETURN NUMBER;
185
186 FUNCTION C_PER_INV_DUE_AMT_1FORMULA(C_SUM_INV_DUE_AMT_1 IN NUMBER
187 ,C_SUM_AMT_REMAINING IN NUMBER) RETURN NUMBER;
188
189 FUNCTION C_PER_INV_DUE_AMT_2FORMULA(C_SUM_INV_DUE_AMT_2 IN NUMBER
190 ,C_SUM_AMT_REMAINING IN NUMBER) RETURN NUMBER;
191
192 FUNCTION C_PER_INV_DUE_AMT_3FORMULA(C_SUM_INV_DUE_AMT_3 IN NUMBER
193 ,C_SUM_AMT_REMAINING IN NUMBER) RETURN NUMBER;
194
195 FUNCTION C_PER_INV_DUE_AMT_4FORMULA(C_SUM_INV_DUE_AMT_4 IN NUMBER
196 ,C_SUM_AMT_REMAINING IN NUMBER) RETURN NUMBER;
197
198 FUNCTION C_PGBRK_DATA_CONVERTEDFORMULA(C_SUM_DATA_CONVERTED IN NUMBER) RETURN VARCHAR2;
199
200 FUNCTION C_V_DATA_CONVERTEDFORMULA(C_SUM_V_DATA_CONVERTED IN NUMBER) RETURN VARCHAR2;
201
202 FUNCTION C_TOT_PER_INV_DUE_1FORMULA(C_TOT_INV_DUE_AMT_1 IN NUMBER
203 ,C_TOT_AMT_REMAINING IN NUMBER) RETURN NUMBER;
204
205 FUNCTION C_TOT_PER_INV_DUE_2FORMULA(C_TOT_INV_DUE_AMT_2 IN NUMBER
206 ,C_TOT_AMT_REMAINING IN NUMBER) RETURN NUMBER;
207
208 FUNCTION C_TOT_PER_INV_DUE_3FORMULA(C_TOT_INV_DUE_AMT_3 IN NUMBER
209 ,C_TOT_AMT_REMAINING IN NUMBER) RETURN NUMBER;
210
211 FUNCTION C_TOT_PER_INV_DUE_4FORMULA(C_TOT_INV_DUE_AMT_4 IN NUMBER
212 ,C_TOT_AMT_REMAINING IN NUMBER) RETURN NUMBER;
213
214 FUNCTION CF_SYSDATEFORMULA RETURN CHAR;
215
216 FUNCTION CF_DUE_DATEFORMULA(C_DUE_DATE IN VARCHAR2) RETURN CHAR;
217
218 FUNCTION CHECK_AP_PROFILE RETURN BOOLEAN;
219
220 PROCEDURE SORT_BY_ALTERNATE_P;
221
222 FUNCTION C_BASE_CURRENCY_CODE_P RETURN VARCHAR2;
223
224 FUNCTION C_BASE_PRECISION_P RETURN NUMBER;
225
226 FUNCTION C_BASE_MIN_ACCT_UNIT_P RETURN NUMBER;
227
228 FUNCTION C_BASE_DESCRIPTION_P RETURN VARCHAR2;
229
230 FUNCTION C_COMPANY_NAME_HEADER_P RETURN VARCHAR2;
231
232 FUNCTION C_REPORT_START_DATE_P RETURN DATE;
233
234 FUNCTION C_NLS_YES_P RETURN VARCHAR2;
235
236 FUNCTION C_NLS_NO_P RETURN VARCHAR2;
237
238 FUNCTION C_NLS_ALL_P RETURN VARCHAR2;
239
240 FUNCTION C_NLS_NO_DATA_EXISTS_P RETURN VARCHAR2;
241
242 FUNCTION C_REPORT_RUN_TIME_P RETURN VARCHAR2;
243
244 FUNCTION C_CHART_OF_ACCOUNTS_ID_P RETURN NUMBER;
245
246 FUNCTION C_VENDOR_NAME_SELECT_P RETURN VARCHAR2;
247
248 FUNCTION C_INVOICE_TYPE_SELECT_P RETURN VARCHAR2;
249
250 FUNCTION C_MINDAYS_P RETURN NUMBER;
251
252 FUNCTION C_MAXDAYS_P RETURN NUMBER;
253
254 FUNCTION C_INV_DUE_1_HEAD_1_P RETURN VARCHAR2;
255
256 FUNCTION C_INV_DUE_1_HEAD_2_P RETURN VARCHAR2;
257
258 FUNCTION C_INV_DUE_2_HEAD_1_P RETURN VARCHAR2;
259
260 FUNCTION C_INV_DUE_2_HEAD_2_P RETURN VARCHAR2;
261
262 FUNCTION C_INV_DUE_3_HEAD_1_P RETURN VARCHAR2;
263
264 FUNCTION C_INV_DUE_3_HEAD_2_P RETURN VARCHAR2;
265
266 FUNCTION C_INV_DUE_4_HEAD_1_P RETURN VARCHAR2;
267
268 FUNCTION C_INV_DUE_4_HEAD_2_P RETURN VARCHAR2;
269
270 FUNCTION C_INV_DUE_1_RANGE_FR_P RETURN NUMBER;
271
272 FUNCTION C_INV_DUE_1_RANGE_TO_P RETURN NUMBER;
273
274 FUNCTION C_INV_DUE_2_RANGE_FR_P RETURN NUMBER;
275
276 FUNCTION C_INV_DUE_2_RANGE_TO_P RETURN NUMBER;
277
278 FUNCTION C_INV_DUE_3_RANGE_FR_P RETURN NUMBER;
279
280 FUNCTION C_INV_DUE_3_RANGE_TO_P RETURN NUMBER;
281
282 FUNCTION C_INV_DUE_4_RANGE_FR_P RETURN NUMBER;
283
284 FUNCTION C_INV_DUE_4_RANGE_TO_P RETURN NUMBER;
285
286 FUNCTION C_HEAD_INVOICE_TYPE_P RETURN VARCHAR2;
287
288 FUNCTION C_HEAD_SORT_OPTION_P RETURN VARCHAR2;
289
290 FUNCTION C_HEAD_VENDOR_NAME_P RETURN VARCHAR2;
291
292 FUNCTION C_REP_DATA_CONVERTED_P RETURN VARCHAR2;
293
294 FUNCTION C_NLS_END_OF_REPORT_P RETURN VARCHAR2;
295
296 FUNCTION C_HEAD_SUMMARY_OPTION_P RETURN VARCHAR2;
297
298 FUNCTION C_HEAD_FORMAT_OPTION_P RETURN VARCHAR2;
299
300 FUNCTION C_HEAD_LEDGER_NAME_P RETURN VARCHAR2;
301
302 FUNCTION C_HEAD_LEGAL_ENTITY_NAME_P RETURN VARCHAR2;
303
304 END JE_JEHUIAGE_XMLP_PKG;
305
306