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.ZX_ZXAPJAJL_XMLP_PKG

Source


1 PACKAGE ZX_ZXAPJAJL_XMLP_PKG AS
2 /* $Header: ZXAPJAJLS.pls 120.1.12010000.1 2008/07/28 13:27:47 appldev ship $ */
3   P_REPORTING_LEVEL VARCHAR2(15);
4 
5   P_REPORTING_ENTITY_ID VARCHAR2(50);
6 
7   P_BASE_REPORT_NAME VARCHAR2(50);
8 
9   P_REPORT_NAME VARCHAR2(50);
10 
11   P_ACCT_PERIOD_FROM VARCHAR2(15);
12 
13   P_ACCT_PERIOD_TO VARCHAR2(15);
14 
15   P_BATCH_DATE_FROM DATE;
16 
17   P_BATCH_DATE_TO DATE;
18 
19   P_GUI_TYPE VARCHAR2(50);
20 
21   P_GUI_NUMBER_FROM VARCHAR2(32767);
22 
23   P_GUI_NUMBER_TO VARCHAR2(32767);
24 
25   P_CD_NUMBER_FROM VARCHAR2(32767);
26 
27   P_CD_DATE_FROM DATE;
28 
29   P_CD_DATE_TO DATE;
30 
31   P_CD_NUMBER_TO VARCHAR2(32767);
32 
33   P_REPRINT VARCHAR2(1);
34 
35   P_SUPPLIER_ID NUMBER;
36 
37   P_LEDGER_ID NUMBER;
38 
39   P_CONC_REQUEST_ID NUMBER;
40 
41   PROGRAM_WHERE VARCHAR2(40);
42 
43   P_TAX_TYPE_LOW VARCHAR2(32767);
44 
45   P_TAX_CODE_LOW VARCHAR2(32767);
46 
47   P_NON_TAXABLE_TYPE VARCHAR2(25);
48 
49   P_VAT_PERC_TAX_TYPE VARCHAR2(25);
50 
51   P_EXCISE_TAX_TYPE_FROM VARCHAR2(25);
52 
53   P_EXCISE_TAX_TYPE_TO VARCHAR2(25);
54 
55   P_MUNI_TAX_TYPE_FROM VARCHAR2(25);
56 
57   P_MUNI_TAX_TYPE_TO VARCHAR2(25);
58 
59   P_PERC_TAX_TYPE_FROM VARCHAR2(25);
60 
61   P_PERC_TAX_TYPE_TO VARCHAR2(25);
62 
63   P_PROV_TAX_TYPE_FROM VARCHAR2(25);
64 
65   P_PROV_TAX_TYPE_TO VARCHAR2(25);
66 
67   P_EXCLUDING_TRX_LETTER VARCHAR2(25);
68 
69   P_TRX_LETTER_FROM VARCHAR2(40);
70 
71   P_TRX_LETTER_TO VARCHAR2(40);
72 
73   P_STANDARD_VAT_RATE NUMBER;
74 
75   P_PRINT_COMPANY_INFO VARCHAR2(3);
76 
77   P_BATCH_NAME VARCHAR2(50);
78 
79   P_ERROR_MESSAGE VARCHAR2(100);
80 
81   P_VAT_TAX_TYPE VARCHAR2(25);
82 
83   P_DATE4_FORMAT VARCHAR2(32767);
84 
85   LP_GROUP VARCHAR2(40);
86 
87   P_TAX_REGISTER_TYPE VARCHAR2(1000);
88   LP_TAX_REGISTER_TYPE VARCHAR2(1000);
89 
90   P_TAX_REGIME VARCHAR2(30);
91 
92   P_TAX_CODE_HIGH VARCHAR2(32767);
93 
94   P_TAX_TYPE_HIGH VARCHAR2(32767);
95 
96   P_PERIOD_START_DATE NUMBER;
97 
98   P_PERIOD_END_DATE NUMBER;
99 
100   P_REP_CONTEXT_LVL_MNG VARCHAR2(15);
101 
102   P_REP_CONTEXT_ENTITY_NAME VARCHAR2(50);
103 
104   P_FUNCTIONAL_CURRENCY_CODE VARCHAR2(15);
105 
106   P_TAX VARCHAR2(30);
107 
108   P_TAX_JURISDICTION VARCHAR2(30);
109 
110   P_TAX_STATUS_CODE VARCHAR2(30);
111 
112   E NUMBER;
113 
114   P_INCLUDE_AP_DM_TRX_CLASS VARCHAR2(1);
115 
116   P_INCLUDE_AP_CM_TRX_CLASS VARCHAR2(1);
117 
118   P_INCLUDE_AP_PREP_TRX_CLASS VARCHAR2(1);
119 
120   P_INCLUDE_AP_MIX_TRX_CLASS VARCHAR2(1);
121 
122   P_INCLUDE_AP_EXP_TRX_CLASS VARCHAR2(1);
123 
124   P_SUPPLIER_NAME VARCHAR2(50);
125 
126   P_SORT_BY_COUNTRY VARCHAR2(32767);
127 
128   P_SUMMARIZE_REPORT VARCHAR2(32767);
129 
130   P_REPORT_ORDERED_BY VARCHAR2(32767);
131 
132   P_DEBUG_SWITCH VARCHAR2(32767);
133 
134   P_TRACE_SWITCH VARCHAR2(32767);
135 
136   P_TAX_RATE_CODE VARCHAR2(30);
137 
138   P_RESPONSIBILITY_NAME VARCHAR2(40);
139 
140   P_USER_NAME VARCHAR2(40);
141 
142   P_GL_PERIOD_NAME_LOW VARCHAR2(40);
143 
144   P_GL_PERIOD_NAME_HIGH VARCHAR2(40);
145 
146   P_GL_DATE_LOW DATE;
147 
148   P_GL_DATE_HIGH DATE;
149 
150   P_TRX_DATE_LOW DATE;
151 
152   P_TRX_DATE_HIGH DATE;
153 
154   P_INCLUDE_AP_INT_TRX_CLASS VARCHAR2(1);
155 
156   P_INCLUDE_AP_STD_TRX_CLASS VARCHAR2(1);
157 
158   P_INCLUDE_GL_MANUAL_LINES VARCHAR2(1);
159 
160   P_PRODUCT VARCHAR2(4);
161   LP_PRODUCT VARCHAR2(4);
162 
163   P_COMPANY_NAME NUMBER;
164 
165   P_TRX_NUMBER_LOW VARCHAR2(40);
166 
167   P_TRX_NUMBER_HIGH VARCHAR2(40);
168 
169   P_DETAIL_LEVEL VARCHAR2(40);
170 
171   P_ORDER_BY VARCHAR2(40);
172 
173   P_INCLUDE_AR_INV_TRX_CLASS VARCHAR2(1);
174 
175   P_INCLUDE_AR_ADJ_TRX_CLASS VARCHAR2(1);
176 
177   P_ACCOUNTING_STATUS VARCHAR2(40);
178 
179   P_TW_GL_DATE_LOW VARCHAR2(32767);
180 
181   P_TW_GL_DATE_HIGH VARCHAR2(32767);
182 
183   P_TW_TRX_DATE_LOW VARCHAR2(32767);
184 
185   P_TW_TRX_DATE_HIGH VARCHAR2(32767);
186 
187   P_COMPANY_NAME_DESC VARCHAR2(100);
188 
189   P_TW_BATCH_DATE_FROM VARCHAR2(32767);
190 
191   P_TW_BATCH_DATE_TO VARCHAR2(32767);
192 
193   P_LEDGER_CURRENCY VARCHAR2(32767);
194 
195   CP_TRX_ID NUMBER;
196 
197   CP_TRX_ID_ACC NUMBER;
198 
199   CF_TOT_AMOUNT NUMBER;
200 
201   CF_TOT_FUNC_AMT NUMBER;
202 
203   CP_TRX_LINE_ID_ACC NUMBER;
204 
205   CP_TRX_LINE_ID NUMBER;
206 
207   CP_NLS_YES VARCHAR2(20);
208 
209   CP_NLS_NO VARCHAR2(20);
210 
211   CP_REPORTING_ENTITY_NAME VARCHAR2(1000);
212 
213   CP_REPORTING_LEVEL_NAME VARCHAR2(80);
214 
215   CP_NLS_ALL VARCHAR2(20);
216 
217   CP_NLS_VOID VARCHAR2(20);
218 
219   CP_NLS_NA VARCHAR2(20);
220 
221   CP_REPORT_TITLE VARCHAR2(50);
222 
223   CP_NO_DATA_FOUND VARCHAR2(50);
224 
225   CP_END_OF_REPORT VARCHAR2(50);
226 
227   CP_TRL_ROW_COUNT NUMBER;
228 
229   FUNCTION BEFOREREPORT RETURN BOOLEAN;
230 
231   FUNCTION INITIALIZE RETURN BOOLEAN;
232 
233   FUNCTION GET_GL_DATE RETURN BOOLEAN;
234 
235   FUNCTION AFTERREPORT RETURN BOOLEAN;
236 
237   FUNCTION CALL_TRL_ENGINE RETURN BOOLEAN;
238 
239   FUNCTION SET_REPORT_TITLE RETURN BOOLEAN;
240 
241   FUNCTION CF_RESPONSIBILITYFORMULA RETURN CHAR;
242 
243   FUNCTION CF_USER_NAMEFORMULA RETURN CHAR;
244 
245   FUNCTION GET_ROC_DATE(P_DATE IN DATE) RETURN VARCHAR2;
246 
247   FUNCTION CP_TW_BATCH_DATE_FROMFORMULA RETURN CHAR;
248 
249   FUNCTION CP_TW_BATCH_DATE_TOFORMULA RETURN CHAR;
250 
251   FUNCTION CP_TW_GL_DATE_HIGHFORMULA RETURN CHAR;
252 
253   FUNCTION CP_TW_GL_DATE_LOWFORMULA RETURN CHAR;
254 
255   FUNCTION CP_TW_TRX_DATE_HIGHFORMULA RETURN CHAR;
256 
257   FUNCTION CP_TW_TRX_DATE_LOWFORMULA RETURN CHAR;
258 
259   FUNCTION CF_TAXABLE_AMTFORMULA(C_INVOICE_ID IN NUMBER
260                                 ,C_TRANSACTION_LINE IN NUMBER) RETURN NUMBER;
261 
262   FUNCTION CF_TAXABLE_ACC_AMTFORMULA(C_INVOICE_ID IN NUMBER
263                                     ,C_TRANSACTION_LINE IN NUMBER) RETURN NUMBER;
264 
265   FUNCTION CF_SUPPLIER_NAME_DESCFORMULA RETURN CHAR;
266 
267   FUNCTION CF_LEDGER_CURRENCYFORMULA RETURN CHAR;
268 
269   FUNCTION CP_TRX_ID_P RETURN NUMBER;
270 
271   FUNCTION CP_TRX_ID_ACC_P RETURN NUMBER;
272 
273   FUNCTION CF_TOT_AMOUNT_P RETURN NUMBER;
274 
275   FUNCTION CF_TOT_FUNC_AMT_P RETURN NUMBER;
276 
277   FUNCTION CP_TRX_LINE_ID_ACC_P RETURN NUMBER;
278 
279   FUNCTION CP_TRX_LINE_ID_P RETURN NUMBER;
280 
281   FUNCTION CP_NLS_YES_P RETURN VARCHAR2;
282 
283   FUNCTION CP_NLS_NO_P RETURN VARCHAR2;
284 
285   FUNCTION CP_REPORTING_ENTITY_NAME_P RETURN VARCHAR2;
286 
287   FUNCTION CP_REPORTING_LEVEL_NAME_P RETURN VARCHAR2;
288 
289   FUNCTION CP_NLS_ALL_P RETURN VARCHAR2;
290 
291   FUNCTION CP_NLS_VOID_P RETURN VARCHAR2;
292 
293   FUNCTION CP_NLS_NA_P RETURN VARCHAR2;
294 
295   FUNCTION CP_REPORT_TITLE_P RETURN VARCHAR2;
296 
297   FUNCTION CP_NO_DATA_FOUND_P RETURN VARCHAR2;
298 
299   FUNCTION CP_END_OF_REPORT_P RETURN VARCHAR2;
300 
301   FUNCTION CP_TRL_ROW_COUNT_P RETURN NUMBER;
302 
303   FUNCTION GET_DATE_FORMAT RETURN BOOLEAN;
304 
305 END ZX_ZXAPJAJL_XMLP_PKG;
306