eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.AP_APXCCOUT_XMLP_PKG

Source


1 PACKAGE AP_APXCCOUT_XMLP_PKG AS
2 /* $Header: APXCCOUT_SUMMARYS.pls 120.0 2007/12/28 11:11:51 vjaganat noship $ */
3   P_TRACE_SWITCH VARCHAR2(1);
4 
5   P_CONC_REQUEST_ID NUMBER := 0;
6 
7   P_MIN_PRECISION NUMBER;
8 
9   P_SEND_NOTIFICATIONS VARCHAR2(2);
10 
11   P_MIN_AMOUNT NUMBER;
12 
13   P_BILLED_START_DATE DATE;
14 
15   P_BILLED_END_DATE DATE;
16 
17   P_CARD_PROGRAM_ID NUMBER;
18 
19   P_OPERATION_TYPE VARCHAR2(32767);
20 
21   LP_EMPLOYEE_WHERE VARCHAR2(2000);
22 
23   P_STATUS VARCHAR2(1);
24 
25   LP_EMPLOYEE_FROM VARCHAR2(200);
26 
27   LP_SELECT_EMP VARCHAR2(30) := '1';
28 
29   LP_GROUP_BY VARCHAR2(60);
30 
31   LP_SELECT_SUP VARCHAR2(30) := '1';
32 
33   LP_EMPLOYEE_STATUS VARCHAR2(32767) := '''Active''';
34 
35   P_BUCKET1 NUMBER;
36 
37   P_BUCKET2 NUMBER;
38 
39   P_BUCKET3 NUMBER;
40 
41   P_BUCKET4 NUMBER;
42 
43   P_MANAGER NUMBER;
44 
45   P_EMPLOYEE NUMBER;
46 
47   LP_EMP_MGR VARCHAR2(2000);
48 
49   LP_EMP_MGR1 VARCHAR2(2000);
50 
51   LP_SELECT_EMP_NAME VARCHAR2(60) := '''abcdsfkjshdfksdfhksdhfksadfhksdhfksadfsadfksadfksdafh''';
52 
53   P_INCLUDE_DIRECTS VARCHAR2(1);
54 
55   LP_MIN_AMT_WHERE VARCHAR2(200);
56 
57   P_ESC_LEVEL NUMBER;
58 
59   P_GRACE_DAYS NUMBER;
60 
61   LP_INACTIVE_WHERE VARCHAR2(300);
62 
63   CP_UNSUBMITTED NUMBER := 0;
64 
65   CP_REJECTED NUMBER := 0;
66 
67   CP_WITHDRAWN NUMBER := 0;
68 
69   CP_SAVED NUMBER := 0;
70 
71   CP_RETURNED NUMBER := 0;
72 
73   CP_RESOLUTN NUMBER := 0;
74 
75   CP_INVOICED NUMBER := 0;
76 
77   CP_ERROR NUMBER := 0;
78 
79   CP_EMP_APPR NUMBER := 0;
80 
81   CP_MGR_UNAPPROVED NUMBER := 0;
82 
83   CP_AP_UNAPPROVED NUMBER := 0;
84 
85   CP_DISPUTED NUMBER := 0;
86 
87   CP_MASKED_CARD_NUMBER VARCHAR2(20);
88 
89   CP_SUPERVISOR_NAME VARCHAR2(240);
90 
91   CP_EMP_NAME_SUMM VARCHAR2(240);
92 
93   CP_AGE_SUP_NAME VARCHAR2(240);
94 
95   CP_SUP_PEND_BUCKET1 NUMBER;
96 
97   CP_SUP_PEND_BUCKET2 NUMBER;
98 
99   CP_SUP_PEND_BUCKET3 NUMBER;
100 
101   CP_SUP_PEND_BUCKET4 NUMBER;
102 
103   CP_AGE_EMP_NAME VARCHAR2(240);
104 
105   CP_APPR_PEND_BUCKET1 NUMBER := 0;
106 
107   CP_APPR_PEND_BUCKET3 NUMBER := 0;
108 
109   CP_APPR_PEND_BUCKET4 NUMBER := 0;
110 
111   CP_APPR_PEND_BUCKET2 NUMBER := 0;
112 
113   CP_EMP_PEND_BUCKET1 NUMBER := 0;
114 
115   CP_EMP_PEND_BUCKET2 NUMBER := 0;
116 
117   CP_EMP_PEND_BUCKET3 NUMBER := 0;
118 
119   CP_EMP_PEND_BUCKET4 NUMBER := 0;
120 
121   CP_SYS_PEND_BUCKET2 NUMBER := 0;
122 
123   CP_SYS_PEND_BUCKET3 NUMBER := 0;
124 
125   CP_SYS_PEND_BUCKET4 NUMBER := 0;
126 
127   CP_SYS_PEND_BUCKET1 NUMBER := 0;
128 
129   CP_MGR_PEND_BUCKET1 NUMBER := 0;
130 
131   CP_MGR_PEND_BUCKET2 NUMBER := 0;
132 
133   CP_MGR_PEND_BUCKET3 NUMBER := 0;
134 
135   CP_MGR_PEND_BUCKET4 NUMBER := 0;
136 
137   CP_BUCKET1 NUMBER;
138 
139   CP_BUCKET2 NUMBER;
140 
141   CP_BUCKET3 NUMBER;
142 
143   CP_BUCKET4 NUMBER;
144 
145   CP_EMP_PENDING NUMBER;
146 
147   CP_SYS_PENDING NUMBER;
148 
149   CP_MGR_PENDING NUMBER;
150 
151   CP_APPR_PENDING NUMBER;
152 
153   CP_NLS_YES VARCHAR2(80);
154 
155   CP_NLS_NO VARCHAR2(80);
156 
157   CP_NLS_ALL VARCHAR2(80);
158 
159   CP_NLS_NO_DATA_FOUND VARCHAR2(80);
160 
161   CP_NLS_END_OF_REPORT VARCHAR2(80);
162 
163   CP_COMPANY_NAME_HEADER VARCHAR2(80);
164 
165   CP_CHART_OF_ACCOUNTS_ID NUMBER;
166 
167   C_BASE_CURRENCY_CODE VARCHAR2(15);
168 
169   C_BASE_DESCRIPTION VARCHAR2(240);
170 
171   C_BASE_MIN_ACCT_UNIT NUMBER;
172 
173   C_BASE_PRECISION NUMBER;
174 
175   CP_NLS_UNSUBMITTED VARCHAR2(80);
176 
177   CP_NLS_MGR_UNAPPROVED VARCHAR2(80);
178 
179   CP_NLS_AP_UNAPPROVED VARCHAR2(80);
180 
181   CP_NLS_DISPUTED VARCHAR2(80);
182 
183   CP_CARD_PROGRAM_NAME VARCHAR2(80);
184 
185   CP_1 NUMBER;
186 
187   CP_REPORT_TITLE VARCHAR2(200);
188 
189   CP_BUCKET1_NAME VARCHAR2(20);
190 
191   CP_BUCKET2_NAME VARCHAR2(20);
192 
193   CP_BUCKET3_NAME VARCHAR2(20);
194 
195   CP_BUCKET4_NAME VARCHAR2(20);
196 
197   CP_NLS_REJECTED VARCHAR2(80);
198 
199   FUNCTION BEFOREREPORT RETURN BOOLEAN;
200 
201   FUNCTION AFTERREPORT RETURN BOOLEAN;
202 
203   FUNCTION GETNLSSTRINGS RETURN BOOLEAN;
204 
205   FUNCTION CF_REPORT_NUMFORMULA(C_REPORT_HEADER_ID IN NUMBER) RETURN VARCHAR2;
206 
207   FUNCTION GETCOMPANYNAME RETURN BOOLEAN;
208 
209   FUNCTION CF_STATUSFORMULA(C_STATUS IN VARCHAR2
210                            ,C_BILLED_AMOUNT IN NUMBER) RETURN VARCHAR2;
211 
212   FUNCTION CF_CP_CURRENCY_CODEFORMULA(C_CP_CURRENCY_CODE IN VARCHAR2) RETURN VARCHAR2;
213 
214   FUNCTION CF_EMP_CURRENCY_CODEFORMULA(C_EMP_CURRENCY_CODE IN VARCHAR2) RETURN VARCHAR2;
215 
216   FUNCTION GETBASECURRDATA RETURN BOOLEAN;
217 
218   PROCEDURE SENDUNSUBMITTED;
219 
220   PROCEDURE SENDMGRUNAPPROVED;
221 
222   PROCEDURE SENDDISPUTED;
223 
224   FUNCTION GETCARDPROGRAMNAME RETURN BOOLEAN;
225 
226   FUNCTION CF_SUPERVISOR_NAMEFORMULA(SUPERVISOR_ID1 IN NUMBER) RETURN CHAR;
227 
228   FUNCTION CF_AGING_BUCKETSFORMULA(AGE_POSTED_DATE IN DATE
229                                   ,AGING_AMOUNT IN NUMBER) RETURN CHAR;
230 
231   FUNCTION CF_AGING_SUP_NAMEFORMULA(AGE_SUPERVISOR_ID IN NUMBER) RETURN CHAR;
232 
233   FUNCTION CF_AGE_AMP_NAMEFORMULA(AGE_EMPLOYEE_ID IN NUMBER
234                                  ,AGE_EMP_STATUS IN VARCHAR2) RETURN CHAR;
235 
236   FUNCTION CF_EMP_NAME_SUMMFORMULA(EMPLOYEE_ID1 IN NUMBER) RETURN CHAR;
237 
238   FUNCTION CF_PENDING_AMOUNTSFORMULA(AGING_REPORT_STATUS_CODE IN VARCHAR2
239                                     ,AGE_POSTED_DATE IN DATE
240                                     ,AGING_AMOUNT IN NUMBER) RETURN CHAR;
241 
242   FUNCTION CF_AGE_SUP_PEND_BUCKLET1FORMUL(CS_SUP_BUCKET1 IN NUMBER
243                                          ,CS_SUP_BUCKET2 IN NUMBER
244                                          ,CS_SUP_BUCKET3 IN NUMBER
245                                          ,CS_SUP_BUCKET4 IN NUMBER) RETURN CHAR;
246 
247   PROCEDURE SEND1DUNNINGNOTIFICATIONS(P_IN_MIN_BUCKET IN NUMBER
248                                      ,P_IN_MAX_BUCKET IN NUMBER
249                                      ,P_IN_DUNNING_NUMBER IN NUMBER
250                                      ,P_IN_SEND_NOTIFICATIONS IN VARCHAR2
251                                      ,P_IN_ESC_LEVEL IN NUMBER
252                                      ,P_IN_GRACE_DAYS IN NUMBER);
253 
254   FUNCTION AFTERPFORM RETURN BOOLEAN;
255 
256   FUNCTION CF_MASKED_CARD_NUMBERFORMULA(C_CARD_NUMBER IN VARCHAR2) RETURN CHAR;
257 
258   PROCEDURE AP_WEB_START_INACT_PRO(P_CARD_PROGRAM_ID IN NUMBER
259                                   ,P_CC_BILLED_START_DATE IN DATE
260                                   ,P_CC_BILLED_END_DATE IN DATE
261                                   ,P_ERRNUM OUT NOCOPY NUMBER
262                                   ,P_ERRMSG OUT NOCOPY VARCHAR2);
263 
264   FUNCTION CP_UNSUBMITTED_P RETURN NUMBER;
265 
266   FUNCTION CP_REJECTED_P RETURN NUMBER;
267 
268   FUNCTION CP_WITHDRAWN_P RETURN NUMBER;
269 
270   FUNCTION CP_SAVED_P RETURN NUMBER;
271 
272   FUNCTION CP_RETURNED_P RETURN NUMBER;
273 
274   FUNCTION CP_RESOLUTN_P RETURN NUMBER;
275 
276   FUNCTION CP_INVOICED_P RETURN NUMBER;
277 
278   FUNCTION CP_ERROR_P RETURN NUMBER;
279 
280   FUNCTION CP_EMP_APPR_P RETURN NUMBER;
281 
282   FUNCTION CP_MGR_UNAPPROVED_P RETURN NUMBER;
283 
284   FUNCTION CP_AP_UNAPPROVED_P RETURN NUMBER;
285 
286   FUNCTION CP_DISPUTED_P RETURN NUMBER;
287 
288   FUNCTION CP_MASKED_CARD_NUMBER_P RETURN VARCHAR2;
289 
290   FUNCTION CP_SUPERVISOR_NAME_P RETURN VARCHAR2;
291 
292   FUNCTION CP_EMP_NAME_SUMM_P RETURN VARCHAR2;
293 
294   FUNCTION CP_AGE_SUP_NAME_P RETURN VARCHAR2;
295 
296   FUNCTION CP_SUP_PEND_BUCKET1_P RETURN NUMBER;
297 
298   FUNCTION CP_SUP_PEND_BUCKET2_P RETURN NUMBER;
299 
300   FUNCTION CP_SUP_PEND_BUCKET3_P RETURN NUMBER;
301 
302   FUNCTION CP_SUP_PEND_BUCKET4_P RETURN NUMBER;
303 
304   FUNCTION CP_AGE_EMP_NAME_P RETURN VARCHAR2;
305 
306   FUNCTION CP_APPR_PEND_BUCKET1_P RETURN NUMBER;
307 
308   FUNCTION CP_APPR_PEND_BUCKET3_P RETURN NUMBER;
309 
310   FUNCTION CP_APPR_PEND_BUCKET4_P RETURN NUMBER;
311 
312   FUNCTION CP_APPR_PEND_BUCKET2_P RETURN NUMBER;
313 
314   FUNCTION CP_EMP_PEND_BUCKET1_P RETURN NUMBER;
315 
316   FUNCTION CP_EMP_PEND_BUCKET2_P RETURN NUMBER;
317 
318   FUNCTION CP_EMP_PEND_BUCKET3_P RETURN NUMBER;
319 
320   FUNCTION CP_EMP_PEND_BUCKET4_P RETURN NUMBER;
321 
322   FUNCTION CP_SYS_PEND_BUCKET2_P RETURN NUMBER;
323 
324   FUNCTION CP_SYS_PEND_BUCKET3_P RETURN NUMBER;
325 
326   FUNCTION CP_SYS_PEND_BUCKET4_P RETURN NUMBER;
327 
328   FUNCTION CP_SYS_PEND_BUCKET1_P RETURN NUMBER;
329 
330   FUNCTION CP_MGR_PEND_BUCKET1_P RETURN NUMBER;
331 
332   FUNCTION CP_MGR_PEND_BUCKET2_P RETURN NUMBER;
333 
334   FUNCTION CP_MGR_PEND_BUCKET3_P RETURN NUMBER;
335 
336   FUNCTION CP_MGR_PEND_BUCKET4_P RETURN NUMBER;
337 
338   FUNCTION CP_BUCKET1_P RETURN NUMBER;
339 
340   FUNCTION CP_BUCKET2_P RETURN NUMBER;
341 
342   FUNCTION CP_BUCKET3_P RETURN NUMBER;
343 
344   FUNCTION CP_BUCKET4_P RETURN NUMBER;
345 
346   FUNCTION CP_EMP_PENDING_P RETURN NUMBER;
347 
348   FUNCTION CP_SYS_PENDING_P RETURN NUMBER;
349 
350   FUNCTION CP_MGR_PENDING_P RETURN NUMBER;
351 
352   FUNCTION CP_APPR_PENDING_P RETURN NUMBER;
353 
354   FUNCTION CP_NLS_YES_P RETURN VARCHAR2;
355 
356   FUNCTION CP_NLS_NO_P RETURN VARCHAR2;
357 
358   FUNCTION CP_NLS_ALL_P RETURN VARCHAR2;
359 
360   FUNCTION CP_NLS_NO_DATA_FOUND_P RETURN VARCHAR2;
361 
362   FUNCTION CP_NLS_END_OF_REPORT_P RETURN VARCHAR2;
363 
364   FUNCTION CP_COMPANY_NAME_HEADER_P RETURN VARCHAR2;
365 
366   FUNCTION CP_CHART_OF_ACCOUNTS_ID_P RETURN NUMBER;
367 
368   FUNCTION C_BASE_CURRENCY_CODE_P RETURN VARCHAR2;
369 
370   FUNCTION C_BASE_DESCRIPTION_P RETURN VARCHAR2;
371 
372   FUNCTION C_BASE_MIN_ACCT_UNIT_P RETURN NUMBER;
373 
374   FUNCTION C_BASE_PRECISION_P RETURN NUMBER;
375 
376   FUNCTION CP_NLS_UNSUBMITTED_P RETURN VARCHAR2;
377 
378   FUNCTION CP_NLS_MGR_UNAPPROVED_P RETURN VARCHAR2;
379 
380   FUNCTION CP_NLS_AP_UNAPPROVED_P RETURN VARCHAR2;
381 
382   FUNCTION CP_NLS_DISPUTED_P RETURN VARCHAR2;
383 
384   FUNCTION CP_CARD_PROGRAM_NAME_P RETURN VARCHAR2;
385 
386   FUNCTION CP_1_P RETURN NUMBER;
387 
388   FUNCTION CP_REPORT_TITLE_P RETURN VARCHAR2;
389 
390   FUNCTION CP_BUCKET1_NAME_P RETURN VARCHAR2;
391 
392   FUNCTION CP_BUCKET2_NAME_P RETURN VARCHAR2;
393 
394   FUNCTION CP_BUCKET3_NAME_P RETURN VARCHAR2;
395 
396   FUNCTION CP_BUCKET4_NAME_P RETURN VARCHAR2;
397 
398   FUNCTION CP_NLS_REJECTED_P RETURN VARCHAR2;
399 
400   FUNCTION Q_agingFilter RETURN BOOLEAN  ;
401 
402   FUNCTION Q_TRANS_SUMMFilter RETURN BOOLEAN ;
403 
404   FUNCTION Q_TRXNFilter RETURN BOOLEAN ;
405 
406 END AP_APXCCOUT_XMLP_PKG;
407