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_ZXARRECV_XMLP_PKG

Source


1 PACKAGE ZX_ZXARRECV_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: ZXARRECVS.pls 120.1.12010000.1 2008/07/28 13:27:50 appldev ship $ */
3   P_REPORTING_LEVEL VARCHAR2(15);
4 
5   P_BASE_REPORT_NAME VARCHAR2(32767);
6 
7   P_REPORT_NAME VARCHAR2(32767);
8 
9   P_REPORT_LEVEL VARCHAR2(32767);
10 
11   P_GL_DATE_LOW DATE;
12 
13   P_GL_DATE_HIGH DATE;
14 
15   P_TRX_DATE_LOW DATE;
16 
17   P_TRX_DATE_HIGH DATE;
18 
19   P_TAX_ACCOUNT_FROM NUMBER;
20 
21   P_TAX_ACCOUNT_TO NUMBER;
22 
23   P_VAT_TAX_CATEGORY VARCHAR2(32767);
24 
25   P_SELF_WH_TAX_CATEG VARCHAR2(32767);
26 
27   P_VAT_PERC_TAX_CATEGORY VARCHAR2(32767);
28 
29   P_VAT_ADDIT_TAX_CATEGORY VARCHAR2(32767);
30 
31   P_VAT_NOT_CATEG_TAX_CATEG VARCHAR2(32767);
32 
33   P_VAT_NON_TAXAB_TAX_CATEG VARCHAR2(32767);
34 
35   P_TAX_CATEG_REGIME VARCHAR2(32767);
36 
37   P_MUN_TAX_CATEG_REGIME VARCHAR2(32767);
38 
39   P_EXC_TAX_CATEGORY VARCHAR2(32767);
40 
41   P_TRX_LETTER_FROM VARCHAR2(32767);
42 
43   P_TRX_LETTER_TO VARCHAR2(32767);
44 
45   P_PRINT_COMPANY VARCHAR2(32767);
46 
47   P_LEDGER_ID NUMBER;
48 
49   P_COA_ID NUMBER;
50 
51   P_ORG_ID NUMBER;
52 
53   P_EXC_TAX_CATEGORY_ID NUMBER;
54 
55   P_VAT_ADDIT_TAX_CATEGORY_ID NUMBER;
56 
57   P_VAT_NON_TAXAB_TAX_CATEG_ID NUMBER;
58 
59   P_VAT_NOT_CATEG_TAX_CATEG_ID NUMBER;
60 
61   P_VAT_PERC_TAX_CATEGORY_ID NUMBER;
62 
63   P_VAT_TAX_CATEGORY_ID NUMBER;
64 
65   P_CONC_REQUEST_ID NUMBER;
66 
67   P_ACCT_PERIOD_FROM VARCHAR2(15);
68   LP_ACCT_PERIOD_FROM VARCHAR2(15);
69 
70   P_ACCT_PERIOD_TO VARCHAR2(15);
71   LP_ACCT_PERIOD_TO VARCHAR2(15);
72 
73   P_CUSTOMER_ID NUMBER;
74 
75   P_EXPORT_DATE_FROM DATE;
76 
77   P_EXPORT_DATE_TO DATE;
78 
79   P_EXP_METHOD VARCHAR2(30);
80 
81   P_INCLUDE_REFERENCED_SOURCE VARCHAR2(1);
82 
83   P_ORG_TRX_NUMBER_FROM VARCHAR2(32767);
84 
85   P_ORG_TRX_NUMBER_TO VARCHAR2(32767);
86 
87   P_REPORTING_ENTITY_ID NUMBER;
88 
89   P_TRX_SOURCE_NAME VARCHAR2(40);
90 
91   P_DATE4_FORMAT VARCHAR2(32767);
92 
93   P_TAX_TYPE VARCHAR2(32767);
94 
95   P_TAX_CODE VARCHAR2(32767);
96 
97   P_PRODUCT VARCHAR2(4);
98 
99   P_TAX_REGIME VARCHAR2(32767);
100 
101   P_REP_CONTEXT_LVL_MNG VARCHAR2(15);
102 
103   P_REP_CONTEXT_ENTITY_NAME VARCHAR2(50);
104 
105   P_RESPONSIBILITY_NAME VARCHAR2(40);
106 
107   P_USER_NAME VARCHAR2(40);
108 
109   P_PERIOD_START_DATE DATE;
110 
111   P_PERIOD_END_DATE DATE;
112 
113   P_TAX_RATE_CODE VARCHAR2(40);
114 
115   P_TAX_REGISTER_TYPE VARCHAR2(32767);
116 
117   P_INCLUDE_AR_INV_TRX_CLASS VARCHAR2(1);
118 
119   P_INCLUDE_AR_APPL_TRX_CLASS VARCHAR2(1);
120 
121   P_INCLUDE_AR_ADJ_TRX_CLASS VARCHAR2(1);
122 
123   P_INCLUDE_AR_MISC_TRX_CLASS VARCHAR2(1);
124 
125   P_INCLUDE_AR_BR_TRX_CLASS VARCHAR2(1);
126 
127   P_INCLUDE_GL_MANUAL_LINES VARCHAR2(1);
128 
129   P_COMPANY_NAME NUMBER;
130 
131   P_ACCOUNTING_STATUS VARCHAR2(40);
132 
133   P_DETAIL_LEVEL VARCHAR2(40);
134 
135   P_INCLUDE VARCHAR2(40);
136 
137   P_TW_GL_DATE_FROM DATE;
138 
139   P_TW_GL_DATE_TO DATE;
140 
141   P_TW_TRX_DATE_LOW DATE;
142 
143   P_TW_TRX_DATE_HIGH DATE;
144 
145   P_CUST_NAME VARCHAR2(40);
146 
147   P_ORDER_BY VARCHAR2(40);
148 
149   P_FUNCTIONAL VARCHAR2(40);
150 
151   P_EXPORT_DATE_LOW VARCHAR2(40);
152 
153   P_EXPORT_DATE_HIGH VARCHAR2(40);
154 
155   P_EXPORT_METHOD VARCHAR2(40);
156 
157   P_STATE_LOW VARCHAR2(40);
158 
159   P_STATE_HIGH VARCHAR2(40);
160 
161   P_TW_EXPORT_DATE_LOW VARCHAR2(40);
162 
163   P_TW_EXPORT_DATE_HIGH VARCHAR2(40);
164 
165   P_ADJUSTED_DOC_FROM VARCHAR2(40);
166 
167   P_ADJUSTED_DOC_TO VARCHAR2(40);
168 
169   P_APPLICATION_DATE VARCHAR2(40);
170 
171   P_GL_ACTIVITY_DISPLAY_FLAG VARCHAR2(40);
172 
173   P_FORMAT VARCHAR2(40);
174 
175   P_POSTING_STATUS VARCHAR2(40);
176 
177   P_INCLUDE_DISCOUNTS VARCHAR2(32767);
178 
179   CP_DETAIL_LEVEL_MNG VARCHAR2(200);
180 
181   CP_INCLUDE_TRX_TYPE VARCHAR2(1000);
182 
183   P_INCLUDE_ACCOUNTING_SEGMENTS VARCHAR2(32767);
184 
185   P_TW_GL_DATE_LOW VARCHAR2(200);
186 
187   P_TW_GL_DATE_HIGH VARCHAR2(200);
188 
189   P_COMPANY_NAME_DESC VARCHAR2(200);
190 
191   CF_TOT_FUNC_AMT NUMBER;
192 
193   CF_TOT_AMOUNT NUMBER;
194 
195   CP_TRX_LINE_ID NUMBER;
196 
197   CP_TRX_ID NUMBER;
198 
199   CP_TRX_ID_ACC NUMBER;
200 
201   CP_TRX_LINE_ID_ACC NUMBER;
202 
203   LP_FROM_CLAUSE VARCHAR2(80) := '--';
204 
205   LP_REPORT_WHERE VARCHAR2(300) := '1 = 1';
206 
207   LP_TAX_ACCOUNT VARCHAR2(20) := 'null';
208 
209   LP_EXTENDED_AMOUNT VARCHAR2(20) := 'null';
210 
211   CP_REPORTING_LEVEL_NAME VARCHAR2(20);
212 
213   CP_REPORTING_ENTITY_NAME VARCHAR2(1000);
214 
215   CP_NLS_YES VARCHAR2(80);
216 
217   CP_NLS_NO VARCHAR2(80);
218 
219   CP_REPORT_TITLE VARCHAR2(50);
220 
221   CP_NO_DATA_FOUND VARCHAR2(50);
222 
223   CP_END_OF_REPORT VARCHAR2(50);
224 
225   LP_CM_BATCH_SOURCE_NAME VARCHAR2(100) := 'NULL';
226 
227   LP_CM_TRX_NUMBER VARCHAR2(20) := 'null';
228 
229   LP_VOID VARCHAR2(200) := 'null';
230 
231   LP_MISSING_SEQ_FINAL VARCHAR2(30025);
232 
233   CP_TAX_CATEGORY_DESC VARCHAR2(80);
234 
235   LP_MISSING_SEQ VARCHAR2(30025);
236 
237   LP_MISSING_SEQUENCE_FINAL VARCHAR2(30025);
238 
239   LP_DOC_SEQUENCE_ORDER VARCHAR2(200) := 'null';
240 
241   CP_TRL_ROW_COUNT NUMBER;
242 
243   FUNCTION BEFOREREPORT RETURN BOOLEAN;
244 
245   FUNCTION GET_GL_DATE RETURN BOOLEAN;
246 
247   FUNCTION INITIALIZE RETURN BOOLEAN;
248 
249   FUNCTION CALL_TRL_ENGINE RETURN BOOLEAN;
250 
251   FUNCTION GET_DYNAMIC_CLAUSE RETURN BOOLEAN;
252 
253   FUNCTION AFTERREPORT RETURN BOOLEAN;
254 
255   FUNCTION SET_REPORT_TITLE RETURN BOOLEAN;
256 
257   FUNCTION CF_RESPONSIBILITYFORMULA RETURN CHAR;
258 
259   FUNCTION CF_USER_NAMEFORMULA RETURN CHAR;
260 
261   PROCEDURE PRINT_MISSING_SEQUENCE;
262 
263   FUNCTION VALIDATE_GUI_NUM(TRX_NUMBER IN VARCHAR2
264                            ,TRX_SOURCE IN VARCHAR2) RETURN BOOLEAN;
265 
266   FUNCTION GET_ROC_DATE(P_DATE IN DATE) RETURN VARCHAR2;
267 
268   FUNCTION P_TRX_DATE_HIGHVALIDTRIGGER RETURN BOOLEAN;
269 
270   FUNCTION CP_TW_GL_DATE_FROMFORMULA RETURN CHAR;
271 
272   FUNCTION CP_TW_GL_DATE_TOFORMULA RETURN CHAR;
273 
274   FUNCTION CP_TW_TRX_DATE_LOWFORMULA RETURN CHAR;
275 
276   FUNCTION CP_TW_TRX_DATE_HIGHFORMULA RETURN CHAR;
277 
278   FUNCTION CF_TAXABLE_AMTFORMULA(C_TRANSACTION_ID IN NUMBER
279                                 ,C_TRANSACTION_LINE IN NUMBER) RETURN NUMBER;
280 
281   FUNCTION CF_TAXABLE_ACC_AMTFORMULA(C_TRANSACTION_ID IN NUMBER
282                                     ,C_TRANSACTION_LINE IN NUMBER) RETURN NUMBER;
283 
284   FUNCTION CP_CUSTOMER_NAMEFORMULA RETURN CHAR;
285 
286   FUNCTION CF_TW_EXPORT_DATEFORMULA(C_EXPORT_DATE IN VARCHAR2) RETURN CHAR;
287 
288   FUNCTION CF_LEDGER_CURRENCYFORMULA RETURN CHAR;
289 
290   FUNCTION CF_TOT_FUNC_AMT_P RETURN NUMBER;
291 
292   FUNCTION CF_TOT_AMOUNT_P RETURN NUMBER;
293 
294   FUNCTION CP_TRX_LINE_ID_P RETURN NUMBER;
295 
296   FUNCTION CP_TRX_ID_P RETURN NUMBER;
297 
298   FUNCTION CP_TRX_ID_ACC_P RETURN NUMBER;
299 
300   FUNCTION CP_TRX_LINE_ID_ACC_P RETURN NUMBER;
301 
302   FUNCTION LP_FROM_CLAUSE_P RETURN VARCHAR2;
303 
304   FUNCTION LP_REPORT_WHERE_P RETURN VARCHAR2;
305 
306   FUNCTION LP_TAX_ACCOUNT_P RETURN VARCHAR2;
307 
308   FUNCTION LP_EXTENDED_AMOUNT_P RETURN VARCHAR2;
309 
310   FUNCTION CP_REPORTING_LEVEL_NAME_P RETURN VARCHAR2;
311 
312   FUNCTION CP_REPORTING_ENTITY_NAME_P RETURN VARCHAR2;
313 
314   FUNCTION CP_NLS_YES_P RETURN VARCHAR2;
315 
316   FUNCTION CP_NLS_NO_P RETURN VARCHAR2;
317 
318   FUNCTION CP_REPORT_TITLE_P RETURN VARCHAR2;
319 
320   FUNCTION CP_NO_DATA_FOUND_P RETURN VARCHAR2;
321 
322   FUNCTION CP_END_OF_REPORT_P RETURN VARCHAR2;
323 
324   FUNCTION LP_CM_BATCH_SOURCE_NAME_P RETURN VARCHAR2;
325 
326   FUNCTION LP_CM_TRX_NUMBER_P RETURN VARCHAR2;
327 
328   FUNCTION LP_VOID_P RETURN VARCHAR2;
329 
330   FUNCTION LP_MISSING_SEQ_FINAL_P RETURN VARCHAR2;
331 
332   FUNCTION CP_TAX_CATEGORY_DESC_P RETURN VARCHAR2;
333 
334   FUNCTION LP_MISSING_SEQ_P RETURN VARCHAR2;
335 
336   FUNCTION LP_MISSING_SEQUENCE_FINAL_P RETURN VARCHAR2;
337 
338   FUNCTION LP_DOC_SEQUENCE_ORDER_P RETURN VARCHAR2;
339 
340   FUNCTION CP_TRL_ROW_COUNT_P RETURN NUMBER;
341 
342   TYPE REC_MISSINGGUI IS RECORD (GUI_NUMBER VARCHAR2(10),GUI_TYPE VARCHAR2(2),GUI_TRX_SRC VARCHAR2(100),GUI NUMBER,DIFF NUMBER);
343 
344   TYPE TAB_MISSINGGUI IS TABLE OF REC_MISSINGGUI INDEX BY BINARY_INTEGER;
345 
346   GUI_TABLE TAB_MISSINGGUI;
347 
348   CNT NUMBER := 1;
349 
350   --PROCEDURE POPULATE_DATA;
351 
352   PROCEDURE POPULATE_DATA(C_TRX_BATCH_SOURCE_NAME VARCHAR2, C_BATCH_SOURCES_ATT1 VARCHAR2,
353   C_BATCH_SOURCE_ID NUMBER, C_INVOICE_WORD VARCHAR2, C_INITIAL_TRX_NUM VARCHAR2,
354   C_FINAL_TRX_NUM VARCHAR2, C_EXTRACT_SOURCE_LEDGER VARCHAR2,
355   C_DOCUMENT_SUB_TYPE VARCHAR2, C_TRX_NUMBER VARCHAR2, C_APPLIED_TO_TRX_NUMBER VARCHAR2);
356 
357   PROCEDURE FIND_MISSING_SEQ;
358 
359   FUNCTION GET_DATE_FORMAT RETURN BOOLEAN;
360 
361 END ZX_ZXARRECV_XMLP_PKG;
362