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

Source


1 PACKAGE JL_JGZZGLTRB_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: JGZZGLTRBS.pls 120.2 2008/01/11 07:48:27 abraghun noship $ */
3   P_ACCESS_SET_ID NUMBER;
4 
5   P_LEDGER_ID NUMBER;
6 
7   P_ENTERED_CURRENCY VARCHAR2(15);
8 
9   P_PERIOD_FROM VARCHAR2(15);
10 
11   P_PERIOD_TO VARCHAR2(15);
12 
13   P_ACCT_LEVEL NUMBER;
14 
15   P_KFF_FROM VARCHAR2(800);
16 
17   P_KFF_TO VARCHAR2(800);
18 
19   P_ZERO_BYB VARCHAR2(1);
20 
21   P_ACCT_CLASS VARCHAR2(10);
22 
23   P_PAGE_NUM_FORMAT VARCHAR2(32767);
24 
25   P_REPORT_TYPE VARCHAR2(32767);
26 
27   P_CONC_REQUEST_ID NUMBER;
28 
29   P_CURRENCY_TYPE VARCHAR2(1);
30 
31   P_APPL_NAME VARCHAR2(100);
32 
33   P_LEDGER_CURRENCY VARCHAR2(15);
34 
35   P_TOP_PARENT_VALUE VARCHAR2(25);
36 
37   P_ACCT_DELIMITER VARCHAR2(4);
38 
39   P_USER_P1 VARCHAR2(240);
40 
41   P_USER_P2 VARCHAR2(240);
42 
43   P_USER_P3 VARCHAR2(240);
44 
45   P_USER_P4 VARCHAR2(240);
46 
47   P_USER_P5 VARCHAR2(240);
48 
49   P_USER_P6 VARCHAR2(240);
50 
51   P_USER_P7 VARCHAR2(240);
52 
53   P_USER_P8 VARCHAR2(240);
54 
55   P_USER_P9 VARCHAR2(240);
56 
57   P_USER_P10 VARCHAR2(240);
58 
59   SELECT_ACCT_SEG VARCHAR2(20) := 'segment3';
60 
61   SELECT_BAL_SEG VARCHAR2(20) := 'segment1';
62 
63   SELECT_CC_SEG VARCHAR2(25) := 'segment2';
64 
65   SELECT_IC_SEG VARCHAR2(25) := 'segment4';
66 
67   SELECT_MGT_SEG VARCHAR2(20) := 'NULL';
68 
69   SELECT_ST_SEG VARCHAR2(20) := 'NULL';
70 
71   COA_ID NUMBER;
72 
73   DATA_ACCESS_SET_NAME VARCHAR2(30);
74 
75   PARAM_TOP_PARENT_VALUE VARCHAR2(25);
76 
77   FIRST_PERIOD_ADJ_FLAG VARCHAR2(1);
78 
79   PARAM_CURRENCY VARCHAR2(20);
80 
81   PARAM_LEDGER_NAME VARCHAR2(30);
82 
83   PARAM_PERIOD_FROM VARCHAR2(15);
84 
85   PARAM_PERIOD_TO VARCHAR2(15);
86 
87   PARAM_ACCT_FROM VARCHAR2(800);
88 
89   PARAM_ACCT_TO VARCHAR2(800);
90 
91   FIRST_PERIOD_NAME VARCHAR2(15);
92 
93   SELECT_ACCOUNT VARCHAR2(600) := '(segment1||''\n''||segment2||''\n''||segment3||''\n''||segment4||''\n''||segment5||''\n''||segment6||''\n''||segment7||''\n''||segment8||''\n''
94   ||segment9||''\n''||segment10||''\n''||segment11||''\n''||segment12||''\n''||segment13||''\n''||segment14||''\n''||segment15||''\n''||segment16||''\n''||segment17||''\n''||segment18||
95   ''\n''||segment19||''\n''||segment20||''\n''||segment21||''\n''||segment22||''\n''||segment23||''\n''||segment24||''\n''||segment25||''\n''||segment26||''\n''||segment27||''\n''||segment28||
96   ''\n''||segment29||''\n''||segment30)';
97 
98   WHERE_ACCT_RANGE VARCHAR2(2000) := '1=1';
99 
100   WHERE_PERIOD VARCHAR2(200);
101 
102   PARAM_ZERO_BEGIN_YEAR_BAL VARCHAR2(80);
103 
104   PARAM_ACCT_LEVEL NUMBER;
105 
106   PARAM_ACCT_CLASS VARCHAR2(20);
107 
108   PARAM_REPORT_TYPE VARCHAR2(20);
109 
110   PARAM_PAGE_NUM_FORMAT VARCHAR2(20);
111 
112   PER_FROM_START_DATE DATE;
113 
114   PER_TO_END_DATE DATE;
115 
116   L_PERIOD_SET_NAME VARCHAR2(15);
117 
118   WHERE_ACCT_CLASS VARCHAR2(50);
119 
120   WHERE_TRANSLATED_FLAG VARCHAR2(100);
121 
122   WHERE_DAS VARCHAR2(800);
123 
124   USER_NAME VARCHAR2(100);
125 
126   TEMP_LE_NAME VARCHAR2(240);
127 
128   TEMP_LE_ADDR1 VARCHAR2(240);
129 
130   WHERE_DEGREE VARCHAR2(500);
131 
132   TEMP_LE_SERVICE_TYPE VARCHAR2(150);
133 
134   TEMP_LE_TAX_PAYER_ID VARCHAR2(30);
135 
136   TEMP_LE_CITY VARCHAR2(30);
137 
138   TEMP_LE_POSTAL_CODE VARCHAR2(30);
139 
140   ACCT_SEG_VALUE_SET_ID NUMBER;
141 
142   SELECT_LE VARCHAR2(40) := '0';
143 
144   FROM_LNSV VARCHAR2(50);
145 
146   WHERE_LE VARCHAR2(150);
147 
148   TEMP_LE_ADDR2 VARCHAR2(240);
149 
150   TEMP_LE_ADDR3 VARCHAR2(240);
151 
152   TEMP_LE_ID NUMBER;
153 
154   PARAM_CURRENCY_TYPE VARCHAR2(80);
155 
156   SYS_NAME_VER VARCHAR2(50);
157 
158   REPORT_EXEC_DATE VARCHAR2(30);
159 
160   PARAM_USER_1 VARCHAR2(240);
161 
162   PARAM_USER_2 VARCHAR2(240);
163 
164   PARAM_USER_3 VARCHAR2(240);
165 
166   PARAM_USER_4 VARCHAR2(240);
167 
168   PARAM_USER_5 VARCHAR2(240);
169 
170   PERIOD_FROM_START_DATE VARCHAR2(30);
171 
172   PERIOD_TO_END_DATE VARCHAR2(30);
173 
174   PARAM_USER_6 VARCHAR2(240);
175 
176   PARAM_USER_7 VARCHAR2(240);
177 
178   PARAM_USER_8 VARCHAR2(240);
179 
180   PARAM_USER_9 VARCHAR2(240);
181 
182   PARAM_USER_10 VARCHAR2(240);
183 
184   FUNCTION BEFOREREPORT RETURN BOOLEAN;
185 
186   FUNCTION AFTERREPORT RETURN BOOLEAN;
187 
188   FUNCTION ACCT_LEVEL1_VALUEFORMULA(ACCOUNT_SEGMENT_VALUE IN VARCHAR2
189                                    ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
190 
191   FUNCTION ACCT_LEVEL2_VALUEFORMULA(ACCOUNT_SEGMENT_VALUE IN VARCHAR2
192                                    ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
193 
194   FUNCTION ACCT_LEVEL3_VALUEFORMULA(ACCOUNT_SEGMENT_VALUE IN VARCHAR2
195                                    ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
196 
197   FUNCTION ACCT_LEVEL4_VALUEFORMULA(ACCOUNT_SEGMENT_VALUE IN VARCHAR2
198                                    ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
199 
200   FUNCTION ACCT_LEVEL5_VALUEFORMULA(ACCOUNT_SEGMENT_VALUE IN VARCHAR2
201                                    ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
202 
203   FUNCTION ACCT_LEVEL6_VALUEFORMULA(ACCOUNT_SEGMENT_VALUE IN VARCHAR2
204                                    ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
205 
206   FUNCTION ACCT_LEVEL7_VALUEFORMULA(ACCOUNT_SEGMENT_VALUE IN VARCHAR2
207                                    ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
208 
209   FUNCTION ACCT_LEVEL8_VALUEFORMULA(ACCOUNT_SEGMENT_VALUE IN VARCHAR2
210                                    ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
211 
212   FUNCTION ACCT_LEVEL9_VALUEFORMULA(ACCOUNT_SEGMENT_VALUE IN VARCHAR2
213                                    ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
214 
215   FUNCTION ACCT_LEVEL1_VALUE_DESCFORMULA(ACCOUNT_SEGMENT_VALUE IN VARCHAR2
216                                         ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
217 
218   FUNCTION ACCT_LEVEL2_VALUE_DESCFORMULA(ACCOUNT_SEGMENT_VALUE IN VARCHAR2
219                                         ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
220 
221   FUNCTION ACCT_LEVEL3_VALUE_DESCFORMULA(ACCOUNT_SEGMENT_VALUE IN VARCHAR2
222                                         ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
223 
224   FUNCTION ACCT_LEVEL4_VALUE_DESCFORMULA(ACCOUNT_SEGMENT_VALUE IN VARCHAR2
225                                         ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
226 
227   FUNCTION ACCT_LEVEL5_VALUE_DESCFORMULA(ACCOUNT_SEGMENT_VALUE IN VARCHAR2
228                                         ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
229 
230   FUNCTION ACCT_LEVEL6_VALUE_DESCFORMULA(ACCOUNT_SEGMENT_VALUE IN VARCHAR2
231                                         ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
232 
233   FUNCTION ACCT_LEVEL7_VALUE_DESCFORMULA(ACCOUNT_SEGMENT_VALUE IN VARCHAR2
234                                         ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
235 
236   FUNCTION ACCT_LEVEL8_VALUE_DESCFORMULA(ACCOUNT_SEGMENT_VALUE IN VARCHAR2
237                                         ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
238 
239   FUNCTION ACCT_LEVEL9_VALUE_DESCFORMULA(ACCOUNT_SEGMENT_VALUE IN VARCHAR2
240                                         ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
241 
242   PROCEDURE GET_LE_INFO(CURRENT_LE_ID IN NUMBER);
243 
244   FUNCTION LE_ADDR1FORMULA(LEGAL_ENTITY_ID IN NUMBER
245                           ,LE_ADDR1 IN VARCHAR2) RETURN CHAR;
246 
247   FUNCTION LE_ADDR2FORMULA(LEGAL_ENTITY_ID IN NUMBER
248                           ,LE_ADDR2 IN VARCHAR2) RETURN CHAR;
249 
250   FUNCTION LE_ADDR3FORMULA(LEGAL_ENTITY_ID IN NUMBER
251                           ,LE_ADDR3 IN VARCHAR2) RETURN CHAR;
252 
253   FUNCTION LE_CITYFORMULA(LEGAL_ENTITY_ID IN NUMBER
254                          ,LE_CITY IN VARCHAR2) RETURN CHAR;
255 
256   FUNCTION LE_POSTAL_CODEFORMULA(LEGAL_ENTITY_ID IN NUMBER
257                                 ,LE_POSTAL_CODE IN VARCHAR2) RETURN CHAR;
258 
259   FUNCTION LE_SERVICE_TYPEFORMULA(LEGAL_ENTITY_ID IN NUMBER
260                                  ,LE_SERVICE_TYPE IN VARCHAR2) RETURN CHAR;
261 
262   FUNCTION LE_TAX_PAYER_IDFORMULA(LEGAL_ENTITY_ID IN NUMBER
263                                  ,LE_TAX_PAYER_ID IN VARCHAR2) RETURN CHAR;
264 
265   FUNCTION LE_NAMEFORMULA(LEGAL_ENTITY_ID IN NUMBER
266                          ,LE_NAME IN VARCHAR2) RETURN CHAR;
267 
268   FUNCTION ACCT_VALUEFORMULA(ACCOUNT_SEGMENT_VALUE IN VARCHAR2
269                             ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
270 
271   FUNCTION ACCT_LEVEL10_VALUEFORMULA(ACCOUNT_SEGMENT_VALUE IN VARCHAR2
272                                     ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
273 
274   FUNCTION ACCT_LEVEL10_VALUE_DESCFORMULA(ACCOUNT_SEGMENT_VALUE IN VARCHAR2
275                                          ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
276 
277   FUNCTION BEFOREPFORM RETURN BOOLEAN;
278 
279   FUNCTION SELECT_ACCT_SEG_P RETURN VARCHAR2;
280 
281   FUNCTION SELECT_BAL_SEG_P RETURN VARCHAR2;
282 
283   FUNCTION SELECT_CC_SEG_P RETURN VARCHAR2;
284 
285   FUNCTION SELECT_IC_SEG_P RETURN VARCHAR2;
286 
287   FUNCTION SELECT_MGT_SEG_P RETURN VARCHAR2;
288 
289   FUNCTION SELECT_ST_SEG_P RETURN VARCHAR2;
290 
291   FUNCTION COA_ID_P RETURN NUMBER;
292 
293   FUNCTION DATA_ACCESS_SET_NAME_P RETURN VARCHAR2;
294 
295   FUNCTION PARAM_TOP_PARENT_VALUE_P RETURN VARCHAR2;
296 
297   FUNCTION FIRST_PERIOD_ADJ_FLAG_P RETURN VARCHAR2;
298 
299   FUNCTION PARAM_CURRENCY_P RETURN VARCHAR2;
300 
301   FUNCTION PARAM_LEDGER_NAME_P RETURN VARCHAR2;
302 
303   FUNCTION PARAM_PERIOD_FROM_P RETURN VARCHAR2;
304 
305   FUNCTION PARAM_PERIOD_TO_P RETURN VARCHAR2;
306 
307   FUNCTION PARAM_ACCT_FROM_P RETURN VARCHAR2;
308 
309   FUNCTION PARAM_ACCT_TO_P RETURN VARCHAR2;
310 
311   FUNCTION FIRST_PERIOD_NAME_P RETURN VARCHAR2;
312 
313   FUNCTION SELECT_ACCOUNT_P RETURN VARCHAR2;
314 
315   FUNCTION WHERE_ACCT_RANGE_P RETURN VARCHAR2;
316 
317   FUNCTION WHERE_PERIOD_P RETURN VARCHAR2;
318 
319   FUNCTION PARAM_ZERO_BEGIN_YEAR_BAL_P RETURN VARCHAR2;
320 
321   FUNCTION PARAM_ACCT_LEVEL_P RETURN NUMBER;
322 
323   FUNCTION PARAM_ACCT_CLASS_P RETURN VARCHAR2;
324 
325   FUNCTION PARAM_REPORT_TYPE_P RETURN VARCHAR2;
326 
327   FUNCTION PARAM_PAGE_NUM_FORMAT_P RETURN VARCHAR2;
328 
329   FUNCTION PER_FROM_START_DATE_P RETURN DATE;
330 
331   FUNCTION PER_TO_END_DATE_P RETURN DATE;
332 
333   FUNCTION PERIOD_SET_NAME_P RETURN VARCHAR2;
334 
335   FUNCTION WHERE_ACCT_CLASS_P RETURN VARCHAR2;
336 
337   FUNCTION WHERE_TRANSLATED_FLAG_P RETURN VARCHAR2;
338 
339   FUNCTION WHERE_DAS_P RETURN VARCHAR2;
340 
341   FUNCTION USER_NAME_P RETURN VARCHAR2;
342 
343   FUNCTION TEMP_LE_NAME_P RETURN VARCHAR2;
344 
345   FUNCTION TEMP_LE_ADDR1_P RETURN VARCHAR2;
346 
347   FUNCTION WHERE_DEGREE_P RETURN VARCHAR2;
348 
349   FUNCTION TEMP_LE_SERVICE_TYPE_P RETURN VARCHAR2;
350 
351   FUNCTION TEMP_LE_TAX_PAYER_ID_P RETURN VARCHAR2;
352 
353   FUNCTION TEMP_LE_CITY_P RETURN VARCHAR2;
354 
355   FUNCTION TEMP_LE_POSTAL_CODE_P RETURN VARCHAR2;
356 
357   FUNCTION ACCT_SEG_VALUE_SET_ID_P RETURN NUMBER;
358 
359   FUNCTION SELECT_LE_P RETURN VARCHAR2;
360 
361   FUNCTION FROM_LNSV_P RETURN VARCHAR2;
362 
363   FUNCTION WHERE_LE_P RETURN VARCHAR2;
364 
365   FUNCTION TEMP_LE_ADDR2_P RETURN VARCHAR2;
366 
367   FUNCTION TEMP_LE_ADDR3_P RETURN VARCHAR2;
368 
369   FUNCTION TEMP_LE_ID_P RETURN NUMBER;
370 
371   FUNCTION PARAM_CURRENCY_TYPE_P RETURN VARCHAR2;
372 
373   FUNCTION SYS_NAME_VER_P RETURN VARCHAR2;
374 
375   FUNCTION REPORT_EXEC_DATE_P RETURN VARCHAR2;
376 
377   FUNCTION PARAM_USER_1_P RETURN VARCHAR2;
378 
379   FUNCTION PARAM_USER_2_P RETURN VARCHAR2;
380 
381   FUNCTION PARAM_USER_3_P RETURN VARCHAR2;
382 
383   FUNCTION PARAM_USER_4_P RETURN VARCHAR2;
384 
385   FUNCTION PARAM_USER_5_P RETURN VARCHAR2;
386 
387   FUNCTION PERIOD_FROM_START_DATE_P RETURN VARCHAR2;
388 
389   FUNCTION PERIOD_TO_END_DATE_P RETURN VARCHAR2;
390 
391   FUNCTION PARAM_USER_6_P RETURN VARCHAR2;
392 
393   FUNCTION PARAM_USER_7_P RETURN VARCHAR2;
394 
395   FUNCTION PARAM_USER_8_P RETURN VARCHAR2;
396 
397   FUNCTION PARAM_USER_9_P RETURN VARCHAR2;
398 
399   FUNCTION PARAM_USER_10_P RETURN VARCHAR2;
400 
401 END JL_JGZZGLTRB_XMLP_PKG;
402 
403 
404