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_JGZZGLJRN_XMLP_PKG

Source


1 PACKAGE JG_JGZZGLJRN_XMLP_PKG AS
2 /* $Header: JGZZGLJRNS.pls 120.2 2007/12/25 16:11:09 npannamp noship $ */
3   P_LEDGER_ID NUMBER;
4 
5   P_ACCESS_SET_ID NUMBER;
6 
7   P_PERIOD_FROM VARCHAR2(16);
8 
9   P_CURRENCY_CODE VARCHAR2(30);
10 
11   P_CONC_REQUEST_ID NUMBER := 0;
12 
13   P_COA_ID NUMBER;
14 
15   P_PERIOD_TO VARCHAR2(16);
16 
17   P_BALANCE_TYPE VARCHAR2(2);
18 
19   P_BUD_ENC_TYPE NUMBER;
20 
21   P_PAGE_NUM_FORMAT VARCHAR2(32767);
22 
23   P_START_DATE VARCHAR2(25);
24 
25   P_END_DATE VARCHAR2(25);
26 
27   P_FIRST_PAGE_NUM NUMBER:=1;
28 
29   P_USER_PARAM_1 VARCHAR2(32767);
30 
31   P_USER_PARAM_2 VARCHAR2(32767);
32 
33   P_USER_PARAM_3 VARCHAR2(32767);
34 
35   P_USER_PARAM_4 VARCHAR2(32767);
36 
37   P_USER_PARAM_5 VARCHAR2(32767);
38 
39   P_ACCT_TO VARCHAR2(200);
40 
41   P_ACCT_FROM VARCHAR2(200);
42 
43   P_STATUS VARCHAR2(32767);
44 
45   P_SOURCE VARCHAR2(100);
46 
47   P_CATEGORY VARCHAR2(100);
48 
49   P_BATCH_NAME VARCHAR2(200);
50 
51   P_DOC_SEQ_NAME NUMBER;
52 
53   P_START_DOC_VALUE NUMBER;
54 
55   P_END_DOC_VALUE NUMBER;
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'' ||
70   SEGMENT9   || ''\n'' || SEGMENT10 || ''\n'' || SEGMENT11 || ''\n'' || SEGMENT12 || ''\n'' || SEGMENT13 || ''\n'' || SEGMENT14 || ''\n'' || SEGMENT15 || ''\n'' || SEGMENT16 || ''\n'' || SEGMENT17 || ''\n'' || SEGMENT18
71   || ''\n''   || SEGMENT19   || ''\n'' || SEGMENT20 || ''\n'' || SEGMENT21 || ''\n'' || SEGMENT22 || ''\n'' || SEGMENT23 || ''\n'' || SEGMENT24 || ''\n'' || SEGMENT25 || ''\n'' || SEGMENT26 || ''\n'' || SEGMENT27 || ''\n''
72   || SEGMENT28 || ''\n'' || SEGMENT29 || ''\n'' || SEGMENT30)';
73 
74   SELECT_ACCT_SEG VARCHAR2(30) := 'cc.segment1';
75 
76   SELECT_BAL_SEG VARCHAR2(30) := 'cc.segment1';
77 
78   TEMP_ACCT_WHERE VARCHAR2(1000);
79 
80   TEMP_LE_NAME VARCHAR2(240);
81 
82   TEMP_TAX_PAYER_ID VARCHAR2(30);
83 
84   TEMP_SERVICE_TYPE VARCHAR2(150);
85 
86   TEMP_ADDR1 VARCHAR2(240);
87 
88   TEMP_ADDR2 VARCHAR2(240);
89 
90   FP_START_DATE DATE;
91 
92   TP_END_DATE DATE;
93 
94   LE_WHERE VARCHAR2(300);
95 
96   SELECT_IC_SEG VARCHAR2(30) := 'cc.segment1';
97 
98   SELECT_MGT_SEG VARCHAR2(30) := 'cc.segment1';
99 
100   SELECT_ST_SEG VARCHAR2(30) := 'cc.segment1';
101 
102   SELECT_LE VARCHAR2(50) := '''NULL''';
103 
104   FROM_LNSV VARCHAR2(50);
105 
106   REP_EXECUTION_DATE VARCHAR2(25);
107 
108   TEMP_ADDR3 VARCHAR2(240);
109 
110   TEMP_TOWN_CITY VARCHAR2(30);
111 
112   TEMP_POSTAL_CODE VARCHAR2(30);
113 
114   TEMP_LE_ID NUMBER := 0;
115 
116   START_DATE_PARAM VARCHAR2(20);
117 
118   END_DATE_PARAM VARCHAR2(20);
119 
120   SELECT_CC_SEG VARCHAR2(30) := 'cc.segment1';
121 
122   PAGE_NUM_FORMAT_PARAM VARCHAR2(20) := 'M of N';
123 
124   CURRENCY_PARAM VARCHAR2(20);
125 
126   PERIOD_TO_PARAM VARCHAR2(20);
127 
128   PERIOD_FROM_PARAM VARCHAR2(20);
129 
130   ACCT_TO_PARAM VARCHAR2(800);
131 
132   ACCT_FROM_PARAM VARCHAR2(800);
133 
134   LEDGER_NAME_PARAM VARCHAR2(30);
135 
136   F_PERIOD_NUM NUMBER := -1;
137 
138   T_PERIOD_NUM NUMBER := -1;
139 
140   BALANCE_TYPE_PARAM VARCHAR2(20);
141 
142   PAGE_NUM_START_PARAM NUMBER := 1;
143 
144   USER_PARAM_1 VARCHAR2(20);
145 
146   USER_PARAM_2 VARCHAR2(20);
147 
148   USER_PARAM_3 VARCHAR2(20);
149 
150   USER_PARAM_4 VARCHAR2(20);
151 
152   USER_PARAM_5 VARCHAR2(20);
153 
154   SELECT_DR VARCHAR2(1000) := '0';
155 
156   SELECT_CR VARCHAR2(1000) := '0';
157 
158   SELECT_BEGIN_BAL VARCHAR2(1000) := '0';
159 
160   ACCT_SEG_VALUE_SET_ID NUMBER;
161 
162   SEG_SECURITY_WHERE VARCHAR2(200):=' ';
163 
164   P_POSTING_STATUS VARCHAR2(200):=' ';
165 
166   P_HEADER_POSTING_STATUS VARCHAR2(1200):=' ';
167 
168   P_BALANCE_TYPE_WHERE VARCHAR2(200):=' ';
169 
170   P_SOURCE_WHERE VARCHAR2(200):=' ';
171 
172   P_CATEGORY_WHERE VARCHAR2(200):=' ';
173 
174   P_BATCH_WHERE VARCHAR2(500);
175 
176   P_DOC_SEQ_WHERE VARCHAR2(500);
177 
178   P_DATE_WHERE VARCHAR2(200):=' ';
179 
180   P_LEDGER_FROM VARCHAR2(100);
181 
182   P_LEDGER_WHERE VARCHAR2(500);
183 
184   TEMP_ENVIRONMENT_CODE VARCHAR2(100);
185 
186   TEMP_LEDGER_ID NUMBER;
187 
188   TEMP_LEGAL_ENTITY_ID NUMBER;
189 
190   JRNL_SOURCE_PARAM VARCHAR2(100);
191 
192   JRNL_CATEGORY_PARAM VARCHAR2(100);
193 
194   BATCH_NAME_PARAM VARCHAR2(100);
195 
196   DOC_SEQ_NAME_PARAM VARCHAR2(30);
197 
198   START_DOC_SEQ_NUM_PARAM NUMBER;
199 
200   END_DOC_SEQ_NUM_PARAM NUMBER;
201 
202   POSTING_STATUS_PARAM VARCHAR2(80);
203 
204   P_PERIOD_INX_HINT VARCHAR2(1500);
205 
206   P_FROM_CLAUSE VARCHAR2(1500) := 'GL_CODE_COMBINATIONS CC,  GL_PERIOD_STATUSES GLP, GL_JE_LINES GLL, GL_JE_HEADERS GLH, GL_LEDGERS LGR, GL_LEDGER_CONFIGURATIONS glc,
207   GL_JE_BATCHES GLBATCH, FUN_SEQ_VERSIONS FSV, FND_DOCUMENT_SEQUENCES DOCSEQ, GL_JE_SOURCES SRC,  GL_JE_CATEGORIES CAT, GL_LOOKUPS look';
208 
209   FUNCTION BEFOREREPORT RETURN BOOLEAN;
210 
211   FUNCTION AFTERREPORT RETURN BOOLEAN;
212 
213   FUNCTION SECONDARY_TRACK_SEGMENT_DESCFO RETURN CHAR;
214 
215   FUNCTION LEGAL_ENTITY_NAMEFORMULA(LEGAL_ENTITY_ID IN NUMBER
216                                    ,LEGAL_ENTITY_NAME IN VARCHAR2) RETURN CHAR;
217 
218   PROCEDURE GET_LE_INFO(V_LE_ID IN NUMBER);
219 
220   FUNCTION LE_ADDRESS_LINE_1FORMULA(LEGAL_ENTITY_ID IN NUMBER
221                                    ,LE_ADDRESS_LINE_1 IN VARCHAR2) RETURN CHAR;
222 
223   FUNCTION LE_ADDRESS_LINE_2FORMULA(LEGAL_ENTITY_ID IN NUMBER
224                                    ,LE_ADDRESS_LINE_2 IN VARCHAR2) RETURN CHAR;
225 
226   FUNCTION LE_ADDRESS_LINE_3FORMULA(LEGAL_ENTITY_ID IN NUMBER
227                                    ,LE_ADDRESS_LINE_3 IN VARCHAR2) RETURN CHAR;
228 
229   FUNCTION LE_CITYFORMULA(LEGAL_ENTITY_ID IN NUMBER
230                          ,LE_CITY IN VARCHAR2) RETURN CHAR;
231 
232   FUNCTION LE_POSTAL_CODEFORMULA(LEGAL_ENTITY_ID IN NUMBER
233                                 ,LE_POSTAL_CODE IN VARCHAR2) RETURN CHAR;
234 
235   FUNCTION LE_REGISTRATION_NUMBERFORMULA(LEGAL_ENTITY_ID IN NUMBER
236                                         ,LE_REGISTRATION_NUMBER IN VARCHAR2) RETURN CHAR;
237 
238   FUNCTION LE_ACTIVITY_CODEFORMULA(LEGAL_ENTITY_ID IN NUMBER
239                                   ,LE_ACTIVITY_CODE IN VARCHAR2) RETURN CHAR;
240 
241   FUNCTION GET_EFF_PERIOD_NUM(ACC_SET_ID IN NUMBER
242                              ,PNAME IN VARCHAR2) RETURN NUMBER;
243 
244   FUNCTION LEGAL_ENTITY_IDFORMULA(LEDGER_ID_V IN NUMBER
245                                  ,ENVIRONMENT_CODE IN VARCHAR2
246                                  ,CONFIGURATION_ID_V IN NUMBER
247                                  ,BALANCING_SEGMENT_VALUE IN VARCHAR2) RETURN NUMBER;
248 
249   FUNCTION CF_LEDGER_NAMEFORMULA(LEDGER_NAME IN VARCHAR2) RETURN CHAR;
250 
251   FUNCTION DATA_ACCESS_SET_NAME_P RETURN VARCHAR2;
252 
253   FUNCTION CHART_OF_ACCOUNTS_ID_P RETURN NUMBER;
254 
255   FUNCTION DAS_WHERE_P RETURN VARCHAR2;
256 
257   FUNCTION CURR_WHERE_JRNL_P RETURN VARCHAR2;
258 
259   FUNCTION PERIOD_WHERE_P RETURN VARCHAR2;
260 
261   FUNCTION ACCT_WHERE_P RETURN VARCHAR2;
262 
263   FUNCTION SELECT_ACCOUNT_P RETURN VARCHAR2;
264 
265   FUNCTION SELECT_ACCT_SEG_P RETURN VARCHAR2;
266 
267   FUNCTION SELECT_BAL_SEG_P RETURN VARCHAR2;
268 
269   FUNCTION TEMP_ACCT_WHERE_P RETURN VARCHAR2;
270 
271   FUNCTION TEMP_LE_NAME_P RETURN VARCHAR2;
272 
273   FUNCTION TEMP_TAX_PAYER_ID_P RETURN VARCHAR2;
274 
275   FUNCTION TEMP_SERVICE_TYPE_P RETURN VARCHAR2;
276 
277   FUNCTION TEMP_ADDR1_P RETURN VARCHAR2;
278 
279   FUNCTION TEMP_ADDR2_P RETURN VARCHAR2;
280 
281   FUNCTION FP_START_DATE_P RETURN DATE;
282 
283   FUNCTION TP_END_DATE_P RETURN DATE;
284 
285   FUNCTION LE_WHERE_P RETURN VARCHAR2;
286 
287   FUNCTION SELECT_IC_SEG_P RETURN VARCHAR2;
288 
289   FUNCTION SELECT_MGT_SEG_P RETURN VARCHAR2;
290 
291   FUNCTION SELECT_ST_SEG_P RETURN VARCHAR2;
292 
293   FUNCTION SELECT_LE_P RETURN VARCHAR2;
294 
295   FUNCTION FROM_LNSV_P RETURN VARCHAR2;
296 
297   FUNCTION REP_EXECUTION_DATE_P RETURN VARCHAR2;
298 
299   FUNCTION TEMP_ADDR3_P RETURN VARCHAR2;
300 
301   FUNCTION TEMP_TOWN_CITY_P RETURN VARCHAR2;
302 
303   FUNCTION TEMP_POSTAL_CODE_P RETURN VARCHAR2;
304 
305   FUNCTION TEMP_LE_ID_P RETURN NUMBER;
306 
307   FUNCTION START_DATE_PARAM_P RETURN VARCHAR2;
308 
309   FUNCTION END_DATE_PARAM_P RETURN VARCHAR2;
310 
311   FUNCTION SELECT_CC_SEG_P RETURN VARCHAR2;
312 
313   FUNCTION PAGE_NUM_FORMAT_PARAM_P RETURN VARCHAR2;
314 
315   FUNCTION CURRENCY_PARAM_P RETURN VARCHAR2;
316 
317   FUNCTION PERIOD_TO_PARAM_P RETURN VARCHAR2;
318 
319   FUNCTION PERIOD_FROM_PARAM_P RETURN VARCHAR2;
320 
321   FUNCTION ACCT_TO_PARAM_P RETURN VARCHAR2;
322 
323   FUNCTION ACCT_FROM_PARAM_P RETURN VARCHAR2;
324 
325   FUNCTION LEDGER_NAME_PARAM_P RETURN VARCHAR2;
326 
327   FUNCTION F_PERIOD_NUM_P RETURN NUMBER;
328 
329   FUNCTION T_PERIOD_NUM_P RETURN NUMBER;
330 
331   FUNCTION BALANCE_TYPE_PARAM_P RETURN VARCHAR2;
332 
333   FUNCTION PAGE_NUM_START_PARAM_P RETURN NUMBER;
334 
335   FUNCTION USER_PARAM_1_P RETURN VARCHAR2;
336 
337   FUNCTION USER_PARAM_2_P RETURN VARCHAR2;
338 
339   FUNCTION USER_PARAM_3_P RETURN VARCHAR2;
340 
341   FUNCTION USER_PARAM_4_P RETURN VARCHAR2;
342 
343   FUNCTION USER_PARAM_5_P RETURN VARCHAR2;
344 
345   FUNCTION SELECT_DR_P RETURN VARCHAR2;
346 
347   FUNCTION SELECT_CR_P RETURN VARCHAR2;
348 
349   FUNCTION SELECT_BEGIN_BAL_P RETURN VARCHAR2;
350 
351   FUNCTION ACCT_SEG_VALUE_SET_ID_P RETURN NUMBER;
352 
353   FUNCTION SEG_SECURITY_WHERE_P RETURN VARCHAR2;
354 
355   FUNCTION P_POSTING_STATUS_P RETURN VARCHAR2;
356 
357   FUNCTION P_HEADER_POSTING_STATUS_P RETURN VARCHAR2;
358 
359   FUNCTION P_BALANCE_TYPE_WHERE_P RETURN VARCHAR2;
360 
361   FUNCTION P_SOURCE_WHERE_P RETURN VARCHAR2;
362 
363   FUNCTION P_CATEGORY_WHERE_P RETURN VARCHAR2;
364 
365   FUNCTION P_BATCH_WHERE_P RETURN VARCHAR2;
366 
367   FUNCTION P_DOC_SEQ_WHERE_P RETURN VARCHAR2;
368 
369   FUNCTION P_DATE_WHERE_P RETURN VARCHAR2;
370 
371   FUNCTION P_LEDGER_FROM_P RETURN VARCHAR2;
372 
373   FUNCTION P_LEDGER_WHERE_P RETURN VARCHAR2;
374 
375   FUNCTION TEMP_ENVIRONMENT_CODE_P RETURN VARCHAR2;
376 
377   FUNCTION TEMP_LEDGER_ID_P RETURN NUMBER;
378 
379   FUNCTION TEMP_LEGAL_ENTITY_ID_P RETURN NUMBER;
380 
381   FUNCTION JRNL_SOURCE_PARAM_P RETURN VARCHAR2;
382 
383   FUNCTION JRNL_CATEGORY_PARAM_P RETURN VARCHAR2;
384 
385   FUNCTION BATCH_NAME_PARAM_P RETURN VARCHAR2;
386 
387   FUNCTION DOC_SEQ_NAME_PARAM_P RETURN VARCHAR2;
388 
389   FUNCTION START_DOC_SEQ_NUM_PARAM_P RETURN NUMBER;
390 
391   FUNCTION END_DOC_SEQ_NUM_PARAM_P RETURN NUMBER;
392 
393   FUNCTION POSTING_STATUS_PARAM_P RETURN VARCHAR2;
394 
395   FUNCTION P_PERIOD_INX_HINT_P RETURN VARCHAR2;
396 
397   FUNCTION P_FROM_CLAUSE_P RETURN VARCHAR2;
398 
399 END JG_JGZZGLJRN_XMLP_PKG;
400 
401