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

Source


1 PACKAGE JG_JGZZGLJRB_XMLP_PKG AS
2 /* $Header: JGZZGLJRBS.pls 120.2 2007/12/25 16:07:00 npannamp noship $ */
3   P_LEDGER_ID NUMBER;
4 
5   P_ACCESS_SET_ID NUMBER;
6 
7   P_PERIOD_FROM VARCHAR2(16);
8 
9   P_ACCT_FROM VARCHAR2(800);
10 
11   P_ACCT_TO VARCHAR2(800);
12 
13   P_CURRENCY_TYPE VARCHAR2(1);
14 
15   P_ENTERED_CURRENCY VARCHAR2(15);
16 
17   P_CONC_REQUEST_ID NUMBER := 0;
18 
19   P_COA_ID NUMBER;
20 
21   P_PERIOD_TO VARCHAR2(16);
22 
23   P_BALANCE_TYPE VARCHAR2(2);
24 
25   P_BUD_ENC_TYPE NUMBER;
26 
27   P_ACCT_LEVEL NUMBER;
28 
29   P_PAGE_NUM_FORMAT VARCHAR2(32767);
30 
31   P_START_DATE DATE;
32 
33   P_END_DATE DATE;
34 
35   CP_END_DATE DATE;
36 
37   CP_START_DATE DATE;
38 
39   P_LEDGER_CURRENCY VARCHAR2(40);
40 
41   P_FIRST_PAGE_NUM NUMBER;
42 
43   P_USER_PARAM_1 VARCHAR2(32767);
44 
45   P_USER_PARAM_2 VARCHAR2(32767);
46 
47   P_USER_PARAM_3 VARCHAR2(32767);
48 
49   P_USER_PARAM_4 VARCHAR2(32767);
50 
51   P_USER_PARAM_5 VARCHAR2(32767);
52 
53   P_TOP_LEVEL_PARENT_ACCT VARCHAR2(800);
54 
55   P_ACCT_DELIMITER VARCHAR2(1);
56 
57   DATA_ACCESS_SET_NAME VARCHAR2(30);
58 
59   CHART_OF_ACCOUNTS_ID NUMBER;
60 
61   DAS_WHERE VARCHAR2(600);
62 
63   CURR_WHERE_JRNL VARCHAR2(2000);
64 
65   PERIOD_WHERE VARCHAR2(2000);
66 
67   ACCT_WHERE VARCHAR2(1000);
68 
69   SELECT_ACCOUNT VARCHAR2(1000) := '(CC.SEGMENT1 || ''\n'' || SEGMENT2 || ''\n'' || SEGMENT3 || ''\n'' || SEGMENT4 || ''\n'' || SEGMENT5 || ''\n'' || SEGMENT6 || ''\n'' || SEGMENT7 || ''\n'' || SEGMENT8 || ''\n'' || SEGMENT9 || ''\n''
70   || SEGMENT10 || ''\n'' || SEGMENT11 || ''\n'' || SEGMENT12 || ''\n'' || SEGMENT13 || ''\n'' || SEGMENT14 || ''\n'' || SEGMENT15 || ''\n'' || SEGMENT16 || ''\n'' || SEGMENT17 || ''\n'' || SEGMENT18 || ''\n'' || SEGMENT19 || ''\n''
71   || SEGMENT20 || ''\n'' || SEGMENT21 || ''\n'' || SEGMENT22 || ''\n'' || SEGMENT23 || ''\n'' || SEGMENT24 || ''\n'' || SEGMENT25 || ''\n'' || SEGMENT26 || ''\n'' || SEGMENT27 || ''\n'' || SEGMENT28 || ''\n'' || SEGMENT29 || ''\n'' || SEGMENT30)';
72 
73   SELECT_ACCT_SEG VARCHAR2(30) := 'cc.segment1';
74 
75   SELECT_BAL_SEG VARCHAR2(30) := 'cc.segment1';
76 
77   TEMP_ACCT_WHERE VARCHAR2(1000);
78 
79   TEMP_LE_NAME VARCHAR2(240);
80 
81   TEMP_TAX_PAYER_ID VARCHAR2(30);
82 
83   TEMP_SERVICE_TYPE VARCHAR2(150);
84 
85   TEMP_ADDR1 VARCHAR2(240);
86 
87   TEMP_ADDR2 VARCHAR2(240);
88 
89   FP_START_DATE DATE;
90 
91   TP_END_DATE DATE;
92 
93   LE_WHERE VARCHAR2(300);
94 
95   SELECT_IC_SEG VARCHAR2(30) := 'cc.segment1';
96 
97   SELECT_MGT_SEG VARCHAR2(30) := 'cc.segment1';
98 
99   SELECT_ST_SEG VARCHAR2(30) := 'cc.segment1';
100 
101   SELECT_LE VARCHAR2(50) := '''               ''';
102 
103   FROM_LNSV VARCHAR2(50);
104 
105   REP_EXECUTION_DATE VARCHAR2(25);
106 
107   TEMP_ADDR3 VARCHAR2(240);
108 
109   TEMP_TOWN_CITY VARCHAR2(30);
110 
111   TEMP_POSTAL_CODE VARCHAR2(30);
112 
113   TEMP_LE_ID NUMBER := 0;
114 
115   START_DATE_PARAM VARCHAR2(20);
116 
117   END_DATE_PARAM VARCHAR2(20);
118 
119   SELECT_CC_SEG VARCHAR2(30) := 'cc.segment1';
120 
121   PAGE_NUM_FORMAT_PARAM VARCHAR2(20) := 'M of N';
122 
123   CURRENCY_TYPE_PARAM VARCHAR2(20);
124 
125   CURRENCY_PARAM VARCHAR2(20);
126 
127   ACCT_LEVEL_PARAM NUMBER;
128 
129   PERIOD_TO_PARAM VARCHAR2(20);
130 
131   PERIOD_FROM_PARAM VARCHAR2(20);
132 
133   ACCT_TO_PARAM VARCHAR2(800);
134 
135   ACCT_FROM_PARAM VARCHAR2(800);
136 
137   LEDGER_CURRENCY VARCHAR2(15);
138 
139   LEDGER_NAME_PARAM VARCHAR2(30);
140 
141   F_PERIOD_NUM NUMBER := -1;
142 
143   T_PERIOD_NUM NUMBER := -1;
144 
145   BALANCE_TYPE_PARAM VARCHAR2(20);
146 
147   BUDGETNAME_ENCUMBRANCETYPE VARCHAR2(80);
148 
149   PAGE_NUM_START_PARAM NUMBER := 1;
150 
151   USER_PARAM_1 VARCHAR2(20);
152 
153   USER_PARAM_2 VARCHAR2(20);
154 
155   USER_PARAM_3 VARCHAR2(20);
156 
157   USER_PARAM_4 VARCHAR2(20);
158 
159   USER_PARAM_5 VARCHAR2(20);
160 
161   CURR_WHERE_BAL VARCHAR2(2000);
162 
163   BUDENC_WHERE_JRNL VARCHAR2(200);
164 
165   BUDENC_WHERE_BAL VARCHAR2(200);
166 
167   BAL_CURRENCY VARCHAR2(15);
168 
169   SELECT_DR VARCHAR2(1000) := '''1,234,567,890,123,456,789,012,345,678.90''';
170 
171   SELECT_CR VARCHAR2(1000) := '''1,234,567,890,123,456,789,012,345,678.90''';
172 
173   SELECT_BEGIN_BAL VARCHAR2(1000) := '''1,234,567,890,123,456,789,012,345,678.90''';
174 
175   ACCT_SEG_VALUE_SET_ID NUMBER;
176 
177   SEG_SECURITY_WHERE VARCHAR2(200);
178 
179   FUNCTION BEFOREREPORT RETURN BOOLEAN;
180 
181   FUNCTION AFTERREPORT RETURN BOOLEAN;
182 
183   FUNCTION LEGAL_ENTITY_NAMEFORMULA(LEGAL_ENTITY_ID IN VARCHAR2
184                                    ,LEGAL_ENTITY_NAME IN VARCHAR2) RETURN CHAR;
185 
186   PROCEDURE GET_LE_INFO(V_LE_ID IN NUMBER);
187 
188   FUNCTION LE_ADDRESS_LINE_1FORMULA(LEGAL_ENTITY_ID IN VARCHAR2
189                                    ,LE_ADDRESS_LINE_1 IN VARCHAR2) RETURN CHAR;
190 
191   FUNCTION LE_ADDRESS_LINE_2FORMULA(LEGAL_ENTITY_ID IN VARCHAR2
192                                    ,LE_ADDRESS_LINE_2 IN VARCHAR2) RETURN CHAR;
193 
194   FUNCTION LE_ADDRESS_LINE_3FORMULA(LEGAL_ENTITY_ID IN VARCHAR2
195                                    ,LE_ADDRESS_LINE_3 IN VARCHAR2) RETURN CHAR;
196 
197   FUNCTION LE_CITYFORMULA(LEGAL_ENTITY_ID IN VARCHAR2
198                          ,LE_CITY IN VARCHAR2) RETURN CHAR;
199 
200   FUNCTION LE_POSTAL_CODEFORMULA(LEGAL_ENTITY_ID IN VARCHAR2
201                                 ,LE_POSTAL_CODE IN VARCHAR2) RETURN CHAR;
202 
203   FUNCTION LE_REGISTRATION_NUMBERFORMULA(LEGAL_ENTITY_ID IN VARCHAR2
204                                         ,LE_REGISTRATION_NUMBER IN VARCHAR2) RETURN CHAR;
205 
206   FUNCTION LE_ACTIVITY_CODEFORMULA(LEGAL_ENTITY_ID IN VARCHAR2
207                                   ,LE_ACTIVITY_CODE IN VARCHAR2) RETURN CHAR;
208 
209   FUNCTION ACCT_LEVEL1_VALUEFORMULA(ACCT_VALUE IN VARCHAR2
210                                    ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
211 
212   FUNCTION ACCT_LEVEL1_VALUE_DESCFORMULA(ACCT_VALUE IN VARCHAR2
213                                         ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
214 
215   FUNCTION ACCT_LEVEL2_VALUEFORMULA(ACCT_VALUE IN VARCHAR2
216                                    ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
217 
218   FUNCTION ACCT_LEVEL2_VALUE_DESCFORMULA(ACCT_VALUE IN VARCHAR2
219                                         ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
220 
221   FUNCTION ACCT_LEVEL3_VALUEFORMULA(ACCT_VALUE IN VARCHAR2
222                                    ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
223 
224   FUNCTION ACCT_LEVEL3_VALUE_DESCFORMULA(ACCT_VALUE IN VARCHAR2
225                                         ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
226 
227   FUNCTION ACCT_LEVEL4_VALUEFORMULA(ACCT_VALUE IN VARCHAR2
228                                    ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
229 
230   FUNCTION ACCT_LEVEL4_VALUE_DESCFORMULA(ACCT_VALUE IN VARCHAR2
231                                         ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
232 
233   FUNCTION ACCT_LEVEL5_VALUEFORMULA(ACCT_VALUE IN VARCHAR2
234                                    ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
235 
236   FUNCTION ACCT_LEVEL5_VALUE_DESCFORMULA(ACCT_VALUE IN VARCHAR2
237                                         ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
238 
239   FUNCTION ACCT_LEVEL6_VALUEFORMULA(ACCT_VALUE IN VARCHAR2
240                                    ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
241 
242   FUNCTION ACCT_LEVEL6_VALUE_DESCFORMULA(ACCT_VALUE IN VARCHAR2
243                                         ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
244 
245   FUNCTION ACCT_LEVEL7_VALUEFORMULA(ACCT_VALUE IN VARCHAR2
246                                    ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
247 
248   FUNCTION ACCT_LEVEL7_VALUE_DESCFORMULA(ACCT_VALUE IN VARCHAR2
249                                         ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
250 
251   FUNCTION ACCT_LEVEL8_VALUEFORMULA(ACCT_VALUE IN VARCHAR2
252                                    ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
253 
254   FUNCTION ACCT_LEVEL8_VALUE_DESCFORMULA(ACCT_VALUE IN VARCHAR2
255                                         ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
256 
257   FUNCTION ACCT_LEVEL9_VALUEFORMULA(ACCT_VALUE IN VARCHAR2
258                                    ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
259 
260   FUNCTION ACCT_LEVEL9_VALUE_DESCFORMULA(ACCT_VALUE IN VARCHAR2
261                                         ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
262 
263   FUNCTION ACCT_LEVEL10_VALUEFORMULA(ACCT_VALUE IN VARCHAR2
264                                     ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
265 
266   FUNCTION ACCT_LEVEL10_VALUE_DESCFORMULA(ACCT_VALUE IN VARCHAR2
267                                          ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR;
268 
269   FUNCTION DATA_ACCESS_SET_NAME_P RETURN VARCHAR2;
270 
271   FUNCTION CHART_OF_ACCOUNTS_ID_P RETURN NUMBER;
272 
273   FUNCTION DAS_WHERE_P RETURN VARCHAR2;
274 
275   FUNCTION CURR_WHERE_JRNL_P RETURN VARCHAR2;
276 
277   FUNCTION PERIOD_WHERE_P RETURN VARCHAR2;
278 
279   FUNCTION ACCT_WHERE_P RETURN VARCHAR2;
280 
281   FUNCTION SELECT_ACCOUNT_P RETURN VARCHAR2;
282 
283   FUNCTION SELECT_ACCT_SEG_P RETURN VARCHAR2;
284 
285   FUNCTION SELECT_BAL_SEG_P RETURN VARCHAR2;
286 
287   FUNCTION TEMP_ACCT_WHERE_P RETURN VARCHAR2;
288 
289   FUNCTION TEMP_LE_NAME_P RETURN VARCHAR2;
290 
291   FUNCTION TEMP_TAX_PAYER_ID_P RETURN VARCHAR2;
292 
293   FUNCTION TEMP_SERVICE_TYPE_P RETURN VARCHAR2;
294 
295   FUNCTION TEMP_ADDR1_P RETURN VARCHAR2;
296 
297   FUNCTION TEMP_ADDR2_P RETURN VARCHAR2;
298 
299   FUNCTION FP_START_DATE_P RETURN DATE;
300 
301   FUNCTION TP_END_DATE_P RETURN DATE;
302 
303   FUNCTION LE_WHERE_P RETURN VARCHAR2;
304 
305   FUNCTION SELECT_IC_SEG_P RETURN VARCHAR2;
306 
307   FUNCTION SELECT_MGT_SEG_P RETURN VARCHAR2;
308 
309   FUNCTION SELECT_ST_SEG_P RETURN VARCHAR2;
310 
311   FUNCTION SELECT_LE_P RETURN VARCHAR2;
312 
313   FUNCTION FROM_LNSV_P RETURN VARCHAR2;
314 
315   FUNCTION REP_EXECUTION_DATE_P RETURN VARCHAR2;
316 
317   FUNCTION TEMP_ADDR3_P RETURN VARCHAR2;
318 
319   FUNCTION TEMP_TOWN_CITY_P RETURN VARCHAR2;
320 
321   FUNCTION TEMP_POSTAL_CODE_P RETURN VARCHAR2;
322 
323   FUNCTION TEMP_LE_ID_P RETURN NUMBER;
324 
325   FUNCTION START_DATE_PARAM_P RETURN VARCHAR2;
326 
327   FUNCTION END_DATE_PARAM_P RETURN VARCHAR2;
328 
329   FUNCTION SELECT_CC_SEG_P RETURN VARCHAR2;
330 
331   FUNCTION PAGE_NUM_FORMAT_PARAM_P RETURN VARCHAR2;
332 
333   FUNCTION CURRENCY_TYPE_PARAM_P RETURN VARCHAR2;
334 
335   FUNCTION CURRENCY_PARAM_P RETURN VARCHAR2;
336 
337   FUNCTION ACCT_LEVEL_PARAM_P RETURN NUMBER;
338 
339   FUNCTION PERIOD_TO_PARAM_P RETURN VARCHAR2;
340 
341   FUNCTION PERIOD_FROM_PARAM_P RETURN VARCHAR2;
342 
343   FUNCTION ACCT_TO_PARAM_P RETURN VARCHAR2;
344 
345   FUNCTION ACCT_FROM_PARAM_P RETURN VARCHAR2;
346 
347   FUNCTION LEDGER_CURRENCY_P RETURN VARCHAR2;
348 
349   FUNCTION LEDGER_NAME_PARAM_P RETURN VARCHAR2;
350 
351   FUNCTION F_PERIOD_NUM_P RETURN NUMBER;
352 
353   FUNCTION T_PERIOD_NUM_P RETURN NUMBER;
354 
355   FUNCTION BALANCE_TYPE_PARAM_P RETURN VARCHAR2;
356 
357   FUNCTION BUDGETNAME_ENCUMBRANCETYPE_P RETURN VARCHAR2;
358 
359   FUNCTION PAGE_NUM_START_PARAM_P RETURN NUMBER;
360 
361   FUNCTION USER_PARAM_1_P RETURN VARCHAR2;
362 
363   FUNCTION USER_PARAM_2_P RETURN VARCHAR2;
364 
365   FUNCTION USER_PARAM_3_P RETURN VARCHAR2;
366 
367   FUNCTION USER_PARAM_4_P RETURN VARCHAR2;
368 
369   FUNCTION USER_PARAM_5_P RETURN VARCHAR2;
370 
371   FUNCTION CURR_WHERE_BAL_P RETURN VARCHAR2;
372 
373   FUNCTION BUDENC_WHERE_JRNL_P RETURN VARCHAR2;
374 
375   FUNCTION BUDENC_WHERE_BAL_P RETURN VARCHAR2;
376 
377   FUNCTION BAL_CURRENCY_P RETURN VARCHAR2;
378 
379   FUNCTION SELECT_DR_P RETURN VARCHAR2;
380 
381   FUNCTION SELECT_CR_P RETURN VARCHAR2;
382 
383   FUNCTION SELECT_BEGIN_BAL_P RETURN VARCHAR2;
384 
385   FUNCTION ACCT_SEG_VALUE_SET_ID_P RETURN NUMBER;
386 
387   FUNCTION SEG_SECURITY_WHERE_P RETURN VARCHAR2;
388 
389 END JG_JGZZGLJRB_XMLP_PKG;
390 
391 
392