[Home] [Help]
PACKAGE BODY: APPS.JG_JGZZGLJRB_XMLP_PKG
Source
1 PACKAGE BODY JG_JGZZGLJRB_XMLP_PKG AS
2 /* $Header: JGZZGLJRBB.pls 120.2.12010000.3 2008/08/04 13:51:01 vgadde ship $ */
3 FUNCTION BEFOREREPORT RETURN BOOLEAN IS
4 L_EXC_LE_ID NUMBER(15);
5 L_ACCTG_CODE VARCHAR2(30);
6 T_ERRORBUFFER VARCHAR2(132);
7 CURSOR LEDGER_ACCTG_CODE IS
8 SELECT
9 C.ACCTG_ENVIRONMENT_CODE
10 FROM
11 GL_LEDGERS L,
12 GL_LEDGER_CONFIGURATIONS C
13 WHERE L.LEDGER_ID = P_LEDGER_ID
14 AND C.CONFIGURATION_ID = L.CONFIGURATION_ID;
15 CURSOR GET_EXC_LE_ID IS
16 SELECT
17 CD.OBJECT_ID
18 FROM
19 GL_LEDGERS L,
20 GL_LEDGER_CONFIG_DETAILS CD
21 WHERE L.LEDGER_ID = P_LEDGER_ID
22 AND CD.CONFIGURATION_ID = L.CONFIGURATION_ID
23 AND CD.OBJECT_TYPE_CODE = 'LEGAL_ENTITY';
24 BEGIN
25 P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
26 CP_START_DATE :=P_START_DATE;
27 CP_END_DATE :=P_END_DATE;
28 /*SRW.USER_EXIT('FND SRWINIT')*/NULL;
29 SELECT
30 TO_CHAR(SYSDATE
31 ,'YYYY-MM-DD') || 'T' || TO_CHAR(SYSDATE
32 ,'HH24:MI:SS')
33 INTO REP_EXECUTION_DATE
34 FROM
35 DUAL;
36 SELECT
37 NAME
38 INTO DATA_ACCESS_SET_NAME
39 FROM
40 GL_ACCESS_SETS
41 WHERE ACCESS_SET_ID = P_ACCESS_SET_ID;
42 SELECT
43 NAME
44 INTO LEDGER_NAME_PARAM
45 FROM
46 GL_LEDGERS
47 WHERE LEDGER_ID = P_LEDGER_ID;
48 OPEN LEDGER_ACCTG_CODE;
49 FETCH LEDGER_ACCTG_CODE
50 INTO L_ACCTG_CODE;
51 CLOSE LEDGER_ACCTG_CODE;
52 IF (L_ACCTG_CODE = 'EXCLUSIVE') THEN
53 OPEN GET_EXC_LE_ID;
54 FETCH GET_EXC_LE_ID
55 INTO L_EXC_LE_ID;
56 CLOSE GET_EXC_LE_ID;
57 SELECT_LE := TO_CHAR(L_EXC_LE_ID);
58 FROM_LNSV := ' ';
59 LE_WHERE := ' ';
60 ELSIF (L_ACCTG_CODE = 'SHARED') THEN
61 SELECT_LE := 'LNSV.LEGAL_ENTITY_ID';
62 FROM_LNSV := 'GL_LEDGER_NORM_SEG_VALS LNSV, ';
63 LE_WHERE := ' AND LNSV.LEDGER_ID (+) = ' || TO_CHAR(P_LEDGER_ID) || ' AND LNSV.SEGMENT_TYPE_CODE (+) = ''B''' || ' AND LNSV.SEGMENT_VALUE (+) = ' || SELECT_BAL_SEG || ' AND LNSV.STATUS_CODE IS NULL';
64 ELSE
65 SELECT_LE := ' ';
66 FROM_LNSV := ' ';
67 LE_WHERE := ' ';
68 END IF;
69 SELECT
70 GLP1.START_DATE,
71 GLP1.EFFECTIVE_PERIOD_NUM,
72 GLP2.END_DATE,
73 GLP2.EFFECTIVE_PERIOD_NUM
74 INTO FP_START_DATE,F_PERIOD_NUM,TP_END_DATE,T_PERIOD_NUM
75 FROM
76 GL_PERIOD_STATUSES GLP1,
77 GL_PERIOD_STATUSES GLP2
78 WHERE GLP1.APPLICATION_ID = 101
79 AND GLP2.APPLICATION_ID = GLP1.APPLICATION_ID
80 AND GLP1.LEDGER_ID = P_LEDGER_ID
81 AND GLP2.LEDGER_ID = GLP1.LEDGER_ID
82 AND GLP1.PERIOD_NAME = P_PERIOD_FROM
83 AND GLP2.PERIOD_NAME = P_PERIOD_TO;
84 IF (CP_START_DATE IS NULL OR CP_END_DATE IS NULL) THEN
85 CP_START_DATE := TO_CHAR(FP_START_DATE);
86 CP_END_DATE := TO_CHAR(TP_END_DATE);
87 END IF;
88 IF (P_PERIOD_FROM = P_PERIOD_TO) THEN
89 PERIOD_WHERE := ' AND GLP.PERIOD_NAME = ''' || P_PERIOD_FROM || '''';
90 ELSE
91 PERIOD_WHERE := ' AND (GLP.EFFECTIVE_PERIOD_NUM BETWEEN ' || F_PERIOD_NUM || ' AND ' || T_PERIOD_NUM || ')';
92 END IF;
93 DAS_WHERE := GL_ACCESS_SET_SECURITY_PKG.GET_SECURITY_CLAUSE(P_ACCESS_SET_ID
94 ,'R'
95 ,'LEDGER_COLUMN'
96 ,'LEDGER_ID'
97 ,'GLP'
98 ,'SEG_COLUMN'
99 ,NULL
100 ,'CC'
101 ,NULL);
102 IF (DAS_WHERE IS NOT NULL) THEN
103 DAS_WHERE := ' AND ' || DAS_WHERE;
104 ELSE
105 DAS_WHERE := ' ';
106 END IF;
107 GL_SECURITY_PKG.INIT_SEGVAL;
108 SEG_SECURITY_WHERE := 'AND GL_SECURITY_PKG.VALIDATE_ACCESS(' || P_LEDGER_ID || ', CC.CODE_COMBINATION_ID) = ''TRUE'' ';
109 IF (P_BALANCE_TYPE = 'A') THEN
110 BUDENC_WHERE_BAL := 'AND 1 = 1';
111 BUDENC_WHERE_JRNL := 'AND 1 = 1';
112 ELSIF (P_BALANCE_TYPE = 'B') THEN
113 BUDENC_WHERE_BAL := 'AND GLBAL.BUDGET_VERSION_ID = ' || TO_CHAR(P_BUD_ENC_TYPE);
114 BUDENC_WHERE_JRNL := 'AND GLH.BUDGET_VERSION_ID = ' || TO_CHAR(P_BUD_ENC_TYPE);
115 ELSE
116 BUDENC_WHERE_BAL := 'AND GLBAL.ENCUMBRANCE_TYPE_ID = ' || TO_CHAR(P_BUD_ENC_TYPE);
117 BUDENC_WHERE_JRNL := 'AND GLH.ENCUMBRANCE_TYPE_ID = ' || TO_CHAR(P_BUD_ENC_TYPE);
118 END IF;
119 IF (P_CURRENCY_TYPE = 'T') THEN
120 BAL_CURRENCY := P_LEDGER_CURRENCY;
121 ELSE
122 BAL_CURRENCY := P_ENTERED_CURRENCY;
123 END IF;
124 CURR_WHERE_BAL := 'AND GLBAL.TRANSLATED_FLAG IS NULL';
125 SELECT_BEGIN_BAL := 'NVL(GLBAL.BEGIN_BALANCE_DR, 0) - NVL(GLBAL.BEGIN_BALANCE_CR, 0)';
126 IF (P_CURRENCY_TYPE = 'E') THEN
127 IF (P_BALANCE_TYPE = 'A') THEN
128 SELECT_BEGIN_BAL := 'DECODE(GLBAL.TRANSLATED_FLAG, ''R'', NVL(GLBAL.BEGIN_BALANCE_DR, 0) - NVL(GLBAL.BEGIN_BALANCE_CR, 0),' || 'NVL(GLBAL.BEGIN_BALANCE_DR_BEQ, 0) - NVL(GLBAL.BEGIN_BALANCE_CR_BEQ, 0))';
129 END IF;
130 CURR_WHERE_BAL := 'AND (GLBAL.TRANSLATED_FLAG = ''R'' OR GLBAL.TRANSLATED_FLAG IS NULL)';
131 END IF;
132 IF (P_CURRENCY_TYPE = 'S') THEN
133 CURR_WHERE_JRNL := 'AND ( GLH.CURRENCY_CODE = ''STAT''' || ' OR GLL.STAT_AMOUNT IS NOT NULL)';
134 SELECT_DR := 'DECODE(GLH.CURRENCY_CODE, ''STAT'',' || 'DECODE(NVL(GLL.STAT_AMOUNT,0),' || '0, GLL.ACCOUNTED_DR,' || 'DECODE(SIGN(NVL(GLL.STAT_AMOUNT,0)),' || '-1, GLL.ACCOUNTED_DR,' || ' 1, (NVL(GLL.ACCOUNTED_DR,0) + '
135 || 'GLL.STAT_AMOUNT),' || 'GLL.ACCOUNTED_DR)),' || 'DECODE(SIGN(NVL(GLL.STAT_AMOUNT,0)),' || '1, NVL(GLL.STAT_AMOUNT,0), ' || 'NULL))';
136 SELECT_CR := 'DECODE(GLH.CURRENCY_CODE, ''STAT'',' || 'DECODE(NVL(GLL.STAT_AMOUNT,0),' || '0, GLL.ACCOUNTED_CR,' || 'DECODE(SIGN(NVL(GLL.STAT_AMOUNT,0)),' || '-1, (NVL(GLL.ACCOUNTED_CR,0) - ' || 'GLL.STAT_AMOUNT),'
137 || ' 1, GLL.ACCOUNTED_CR,' || 'GLL.ACCOUNTED_CR)),' || 'DECODE(SIGN(NVL(GLL.STAT_AMOUNT,0)),' || '-1, (0 - NVL(GLL.STAT_AMOUNT,0)), ' || 'NULL))';
138 ELSIF (P_CURRENCY_TYPE = 'T') THEN
139 CURR_WHERE_JRNL := 'AND GLH.CURRENCY_CODE <> ''STAT''';
140 SELECT_DR := 'NVL(GLL.ACCOUNTED_DR, 0)';
141 SELECT_CR := 'NVL(GLL.ACCOUNTED_CR, 0)';
142 ELSE
143 CURR_WHERE_JRNL := 'AND GLH.CURRENCY_CODE = ''' || P_ENTERED_CURRENCY || '''';
144 SELECT_DR := 'NVL(GLL.ENTERED_DR, 0)';
145 SELECT_CR := 'NVL(GLL.ENTERED_CR, 0)';
146 END IF;
147 /*SRW.REFERENCE(P_COA_ID)*/NULL;
148 IF (P_ACCT_LEVEL IS NOT NULL) THEN
149 SELECT
150 FLEX_VALUE_SET_ID
151 INTO ACCT_SEG_VALUE_SET_ID
152 FROM
153 FND_ID_FLEX_SEGMENTS
154 WHERE APPLICATION_ID = 101
155 AND ID_FLEX_CODE = 'GL#'
156 AND ID_FLEX_NUM = P_COA_ID
157 AND ENABLED_FLAG = 'Y'
158 AND APPLICATION_COLUMN_NAME = SUBSTR(SELECT_ACCT_SEG
159 ,4);
160 JG_GL_ACCT_HIER_PKG.POPULATE_ACCT_HIER_TABLE(ACCT_SEG_VALUE_SET_ID
161 ,P_TOP_LEVEL_PARENT_ACCT);
162 END IF;
163 IF P_ACCT_FROM IS NOT NULL AND P_ACCT_TO IS NOT NULL THEN
164 IF TEMP_ACCT_WHERE IS NOT NULL THEN
165 ACCT_WHERE := 'AND ' || TEMP_ACCT_WHERE;
166 ELSE
167 ACCT_WHERE := ' ';
168 END IF;
169 END IF;
170 CHART_OF_ACCOUNTS_ID := P_COA_ID;
171 CURRENCY_PARAM := P_ENTERED_CURRENCY;
172 LEDGER_CURRENCY := P_LEDGER_CURRENCY;
173 PERIOD_FROM_PARAM := P_PERIOD_FROM;
174 PERIOD_TO_PARAM := P_PERIOD_TO;
175 ACCT_FROM_PARAM := P_ACCT_FROM;
176 ACCT_TO_PARAM := P_ACCT_TO;
177 ACCT_LEVEL_PARAM := P_ACCT_LEVEL;
178 PAGE_NUM_FORMAT_PARAM := P_PAGE_NUM_FORMAT;
179 PAGE_NUM_START_PARAM := P_FIRST_PAGE_NUM;
180 IF (CP_START_DATE IS NULL OR CP_END_DATE IS NULL) THEN
181 START_DATE_PARAM := TO_CHAR(FP_START_DATE
182 ,'YYYY-MM-DD') || 'T' || TO_CHAR(FP_START_DATE
183 ,'HH24:MI:SS');
184 END_DATE_PARAM := TO_CHAR(TP_END_DATE
185 ,'YYYY-MM-DD') || 'T' || TO_CHAR(TP_END_DATE
186 ,'HH24:MI:SS');
187 ELSE
188 START_DATE_PARAM := TO_CHAR(CP_START_DATE
189 ,'YYYY-MM-DD') || 'T' || TO_CHAR(CP_START_DATE
190 ,'HH24:MI:SS');
191 END_DATE_PARAM := TO_CHAR(CP_END_DATE
192 ,'YYYY-MM-DD') || 'T' || TO_CHAR(CP_END_DATE
193 ,'HH24:MI:SS');
194 END IF;
195 USER_PARAM_1 := P_USER_PARAM_1;
196 USER_PARAM_2 := P_USER_PARAM_2;
197 USER_PARAM_3 := P_USER_PARAM_3;
198 USER_PARAM_4 := P_USER_PARAM_4;
199 USER_PARAM_5 := P_USER_PARAM_5;
200 BUDGETNAME_ENCUMBRANCETYPE := P_BUD_ENC_TYPE;
201 SELECT
202 MEANING
203 INTO CURRENCY_TYPE_PARAM
204 FROM
205 GL_LOOKUPS
206 WHERE LOOKUP_TYPE = 'GL_CURRENCY_TYPE'
207 AND LOOKUP_CODE = P_CURRENCY_TYPE;
208 SELECT
209 MEANING
210 INTO BALANCE_TYPE_PARAM
211 FROM
212 GL_LOOKUPS
213 WHERE LOOKUP_TYPE = 'BATCH_TYPE'
214 AND LOOKUP_CODE = P_BALANCE_TYPE;
215 RETURN (TRUE);
216 END BEFOREREPORT;
217
218 FUNCTION AFTERREPORT RETURN BOOLEAN IS
219 BEGIN
220 /*SRW.USER_EXIT('FND SRWEXIT')*/NULL;
221 RETURN (TRUE);
222 END AFTERREPORT;
223
224 FUNCTION LEGAL_ENTITY_NAMEFORMULA(LEGAL_ENTITY_ID IN VARCHAR2
225 ,LEGAL_ENTITY_NAME IN VARCHAR2) RETURN CHAR IS
226 BEGIN
227 /*SRW.REFERENCE(LEGAL_ENTITY_ID)*/NULL;
228 IF (TEMP_LE_ID = LEGAL_ENTITY_ID) THEN
229 RETURN (TEMP_LE_NAME);
230 ELSIF LEGAL_ENTITY_ID IS NOT NULL THEN
231 GET_LE_INFO(LEGAL_ENTITY_ID);
232 RETURN (TEMP_LE_NAME);
233 END IF;
234 RETURN (LEGAL_ENTITY_NAME);
235 END LEGAL_ENTITY_NAMEFORMULA;
236
237 PROCEDURE GET_LE_INFO(V_LE_ID IN NUMBER) IS
238 T_ERRORBUFFER VARCHAR2(132);
239 BEGIN
240 TEMP_LE_ID := V_LE_ID;
241 SELECT
242 NAME,
243 LTRIM(ADDRESS_LINE_1),
244 LTRIM(ADDRESS_LINE_2),
245 LTRIM(ADDRESS_LINE_3),
246 LTRIM(TOWN_OR_CITY),
247 LTRIM(POSTAL_CODE),
248 ACTIVITY_CODE,
249 REGISTRATION_NUMBER
250 INTO TEMP_LE_NAME,TEMP_ADDR1,TEMP_ADDR2,TEMP_ADDR3,TEMP_TOWN_CITY,TEMP_POSTAL_CODE,TEMP_SERVICE_TYPE,TEMP_TAX_PAYER_ID
251 FROM
252 XLE_FIRSTPARTY_INFORMATION_V
253 WHERE LEGAL_ENTITY_ID = V_LE_ID;
254 EXCEPTION
255 WHEN OTHERS THEN
256 T_ERRORBUFFER := SQLERRM;
257 /*SRW.MESSAGE('00'
258 ,T_ERRORBUFFER)*/NULL;
259 /*RAISE SRW.PROGRAM_ABORT*/RAISE_APPLICATION_ERROR(-20101,null);
260 END GET_LE_INFO;
261
262 FUNCTION LE_ADDRESS_LINE_1FORMULA(LEGAL_ENTITY_ID IN VARCHAR2
263 ,LE_ADDRESS_LINE_1 IN VARCHAR2) RETURN CHAR IS
264 BEGIN
265 /*SRW.REFERENCE(LEGAL_ENTITY_ID)*/NULL;
266 IF (TEMP_LE_ID = LEGAL_ENTITY_ID) THEN
267 RETURN (TEMP_ADDR1);
268 ELSIF LEGAL_ENTITY_ID IS NOT NULL THEN
269 GET_LE_INFO(LEGAL_ENTITY_ID);
270 RETURN (TEMP_ADDR1);
271 END IF;
272 RETURN (LE_ADDRESS_LINE_1);
273 END LE_ADDRESS_LINE_1FORMULA;
274
275 FUNCTION LE_ADDRESS_LINE_2FORMULA(LEGAL_ENTITY_ID IN VARCHAR2
276 ,LE_ADDRESS_LINE_2 IN VARCHAR2) RETURN CHAR IS
277 BEGIN
278 /*SRW.REFERENCE(LEGAL_ENTITY_ID)*/NULL;
279 IF (TEMP_LE_ID = LEGAL_ENTITY_ID) THEN
280 RETURN (TEMP_ADDR2);
281 ELSIF LEGAL_ENTITY_ID IS NOT NULL THEN
282 GET_LE_INFO(LEGAL_ENTITY_ID);
283 RETURN (TEMP_ADDR2);
284 END IF;
285 RETURN (LE_ADDRESS_LINE_2);
286 END LE_ADDRESS_LINE_2FORMULA;
287
288 FUNCTION LE_ADDRESS_LINE_3FORMULA(LEGAL_ENTITY_ID IN VARCHAR2
289 ,LE_ADDRESS_LINE_3 IN VARCHAR2) RETURN CHAR IS
290 BEGIN
291 /*SRW.REFERENCE(LEGAL_ENTITY_ID)*/NULL;
292 IF (TEMP_LE_ID = LEGAL_ENTITY_ID) THEN
293 RETURN (TEMP_ADDR3);
294 ELSIF LEGAL_ENTITY_ID IS NOT NULL THEN
295 GET_LE_INFO(LEGAL_ENTITY_ID);
296 RETURN (TEMP_ADDR3);
297 END IF;
298 RETURN (LE_ADDRESS_LINE_3);
299 END LE_ADDRESS_LINE_3FORMULA;
300
301 FUNCTION LE_CITYFORMULA(LEGAL_ENTITY_ID IN VARCHAR2
302 ,LE_CITY IN VARCHAR2) RETURN CHAR IS
303 BEGIN
304 /*SRW.REFERENCE(LEGAL_ENTITY_ID)*/NULL;
305 IF (TEMP_LE_ID = LEGAL_ENTITY_ID) THEN
306 RETURN (TEMP_TOWN_CITY);
307 ELSIF LEGAL_ENTITY_ID IS NOT NULL THEN
308 GET_LE_INFO(LEGAL_ENTITY_ID);
309 RETURN (TEMP_TOWN_CITY);
310 END IF;
311 RETURN (LE_CITY);
312 END LE_CITYFORMULA;
313
314 FUNCTION LE_POSTAL_CODEFORMULA(LEGAL_ENTITY_ID IN VARCHAR2
315 ,LE_POSTAL_CODE IN VARCHAR2) RETURN CHAR IS
316 BEGIN
317 /*SRW.REFERENCE(LEGAL_ENTITY_ID)*/NULL;
318 IF (TEMP_LE_ID = LEGAL_ENTITY_ID) THEN
319 RETURN (TEMP_POSTAL_CODE);
320 ELSIF LEGAL_ENTITY_ID IS NOT NULL THEN
321 GET_LE_INFO(LEGAL_ENTITY_ID);
322 RETURN (TEMP_POSTAL_CODE);
323 END IF;
324 RETURN (LE_POSTAL_CODE);
325 END LE_POSTAL_CODEFORMULA;
326
327 FUNCTION LE_REGISTRATION_NUMBERFORMULA(LEGAL_ENTITY_ID IN VARCHAR2
328 ,LE_REGISTRATION_NUMBER IN VARCHAR2) RETURN CHAR IS
329 BEGIN
330 /*SRW.REFERENCE(LEGAL_ENTITY_ID)*/NULL;
331 IF (TEMP_LE_ID = LEGAL_ENTITY_ID) THEN
332 RETURN (TEMP_TAX_PAYER_ID);
333 ELSIF LEGAL_ENTITY_ID IS NOT NULL THEN
334 GET_LE_INFO(LEGAL_ENTITY_ID);
335 RETURN (TEMP_TAX_PAYER_ID);
336 END IF;
337 RETURN (LE_REGISTRATION_NUMBER);
338 END LE_REGISTRATION_NUMBERFORMULA;
339
340 FUNCTION LE_ACTIVITY_CODEFORMULA(LEGAL_ENTITY_ID IN VARCHAR2
341 ,LE_ACTIVITY_CODE IN VARCHAR2) RETURN CHAR IS
342 BEGIN
343 /*SRW.REFERENCE(LEGAL_ENTITY_ID)*/NULL;
344 IF (TEMP_LE_ID = LEGAL_ENTITY_ID) THEN
345 RETURN (TEMP_SERVICE_TYPE);
346 ELSIF LEGAL_ENTITY_ID IS NOT NULL THEN
347 GET_LE_INFO(LEGAL_ENTITY_ID);
348 RETURN (TEMP_SERVICE_TYPE);
349 END IF;
350 RETURN (LE_ACTIVITY_CODE);
351 END LE_ACTIVITY_CODEFORMULA;
352
353 FUNCTION ACCT_LEVEL1_VALUEFORMULA(ACCT_VALUE IN VARCHAR2
354 ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR IS
355 BEGIN
356 /*SRW.REFERENCE(ACCT_VALUE)*/NULL;
357 /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
358 RETURN (JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_VALUE(ACCT_SEG_VALUE_SET_ID
359 ,P_ACCT_LEVEL
360 ,ACCT_VALUE
361 ,ACCT_VALUE_DESC
362 ,P_ACCT_DELIMITER
363 ,1));
364 END ACCT_LEVEL1_VALUEFORMULA;
365
366 FUNCTION ACCT_LEVEL1_VALUE_DESCFORMULA(ACCT_VALUE IN VARCHAR2
367 ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR IS
368 BEGIN
369 /*SRW.REFERENCE(ACCT_VALUE)*/NULL;
370 /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
371 RETURN (JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_DESC(ACCT_SEG_VALUE_SET_ID
372 ,P_ACCT_LEVEL
373 ,ACCT_VALUE
374 ,ACCT_VALUE_DESC
375 ,P_ACCT_DELIMITER
376 ,1));
377 END ACCT_LEVEL1_VALUE_DESCFORMULA;
378
379 FUNCTION ACCT_LEVEL2_VALUEFORMULA(ACCT_VALUE IN VARCHAR2
380 ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR IS
381 BEGIN
382 /*SRW.REFERENCE(ACCT_VALUE)*/NULL;
383 /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
384 RETURN (JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_VALUE(ACCT_SEG_VALUE_SET_ID
385 ,P_ACCT_LEVEL
386 ,ACCT_VALUE
387 ,ACCT_VALUE_DESC
388 ,P_ACCT_DELIMITER
389 ,2));
390 END ACCT_LEVEL2_VALUEFORMULA;
391
392 FUNCTION ACCT_LEVEL2_VALUE_DESCFORMULA(ACCT_VALUE IN VARCHAR2
393 ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR IS
394 BEGIN
395 /*SRW.REFERENCE(ACCT_VALUE)*/NULL;
396 /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
397 RETURN (JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_DESC(ACCT_SEG_VALUE_SET_ID
398 ,P_ACCT_LEVEL
399 ,ACCT_VALUE
400 ,ACCT_VALUE_DESC
401 ,P_ACCT_DELIMITER
402 ,2));
403 END ACCT_LEVEL2_VALUE_DESCFORMULA;
404
405 FUNCTION ACCT_LEVEL3_VALUEFORMULA(ACCT_VALUE IN VARCHAR2
406 ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR IS
407 BEGIN
408 /*SRW.REFERENCE(ACCT_VALUE)*/NULL;
409 /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
410 RETURN (JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_VALUE(ACCT_SEG_VALUE_SET_ID
411 ,P_ACCT_LEVEL
412 ,ACCT_VALUE
413 ,ACCT_VALUE_DESC
414 ,P_ACCT_DELIMITER
415 ,3));
416 END ACCT_LEVEL3_VALUEFORMULA;
417
418 FUNCTION ACCT_LEVEL3_VALUE_DESCFORMULA(ACCT_VALUE IN VARCHAR2
419 ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR IS
420 BEGIN
421 /*SRW.REFERENCE(ACCT_VALUE)*/NULL;
422 /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
423 RETURN (JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_DESC(ACCT_SEG_VALUE_SET_ID
424 ,P_ACCT_LEVEL
425 ,ACCT_VALUE
426 ,ACCT_VALUE_DESC
427 ,P_ACCT_DELIMITER
428 ,3));
429 END ACCT_LEVEL3_VALUE_DESCFORMULA;
430
431 FUNCTION ACCT_LEVEL4_VALUEFORMULA(ACCT_VALUE IN VARCHAR2
432 ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR IS
433 BEGIN
434 /*SRW.REFERENCE(ACCT_VALUE)*/NULL;
435 /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
436 RETURN (JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_VALUE(ACCT_SEG_VALUE_SET_ID
437 ,P_ACCT_LEVEL
438 ,ACCT_VALUE
439 ,ACCT_VALUE_DESC
440 ,P_ACCT_DELIMITER
441 ,4));
442 END ACCT_LEVEL4_VALUEFORMULA;
443
444 FUNCTION ACCT_LEVEL4_VALUE_DESCFORMULA(ACCT_VALUE IN VARCHAR2
445 ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR IS
446 BEGIN
447 /*SRW.REFERENCE(ACCT_VALUE)*/NULL;
448 /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
449 RETURN (JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_DESC(ACCT_SEG_VALUE_SET_ID
450 ,P_ACCT_LEVEL
451 ,ACCT_VALUE
452 ,ACCT_VALUE_DESC
453 ,P_ACCT_DELIMITER
454 ,4));
455 END ACCT_LEVEL4_VALUE_DESCFORMULA;
456
457 FUNCTION ACCT_LEVEL5_VALUEFORMULA(ACCT_VALUE IN VARCHAR2
458 ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR IS
459 BEGIN
460 /*SRW.REFERENCE(ACCT_VALUE)*/NULL;
461 /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
462 RETURN (JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_VALUE(ACCT_SEG_VALUE_SET_ID
463 ,P_ACCT_LEVEL
464 ,ACCT_VALUE
465 ,ACCT_VALUE_DESC
466 ,P_ACCT_DELIMITER
467 ,5));
468 END ACCT_LEVEL5_VALUEFORMULA;
469
470 FUNCTION ACCT_LEVEL5_VALUE_DESCFORMULA(ACCT_VALUE IN VARCHAR2
471 ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR IS
472 BEGIN
473 /*SRW.REFERENCE(ACCT_VALUE)*/NULL;
474 /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
475 RETURN (JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_DESC(ACCT_SEG_VALUE_SET_ID
476 ,P_ACCT_LEVEL
477 ,ACCT_VALUE
478 ,ACCT_VALUE_DESC
479 ,P_ACCT_DELIMITER
480 ,5));
481 END ACCT_LEVEL5_VALUE_DESCFORMULA;
482
483 FUNCTION ACCT_LEVEL6_VALUEFORMULA(ACCT_VALUE IN VARCHAR2
484 ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR IS
485 BEGIN
486 /*SRW.REFERENCE(ACCT_VALUE)*/NULL;
487 /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
488 RETURN (JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_VALUE(ACCT_SEG_VALUE_SET_ID
489 ,P_ACCT_LEVEL
490 ,ACCT_VALUE
491 ,ACCT_VALUE_DESC
492 ,P_ACCT_DELIMITER
493 ,6));
494 END ACCT_LEVEL6_VALUEFORMULA;
495
496 FUNCTION ACCT_LEVEL6_VALUE_DESCFORMULA(ACCT_VALUE IN VARCHAR2
497 ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR IS
498 BEGIN
499 /*SRW.REFERENCE(ACCT_VALUE)*/NULL;
500 /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
501 RETURN (JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_DESC(ACCT_SEG_VALUE_SET_ID
502 ,P_ACCT_LEVEL
503 ,ACCT_VALUE
504 ,ACCT_VALUE_DESC
505 ,P_ACCT_DELIMITER
506 ,6));
507 END ACCT_LEVEL6_VALUE_DESCFORMULA;
508
509 FUNCTION ACCT_LEVEL7_VALUEFORMULA(ACCT_VALUE IN VARCHAR2
510 ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR IS
511 BEGIN
512 /*SRW.REFERENCE(ACCT_VALUE)*/NULL;
513 /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
514 RETURN (JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_VALUE(ACCT_SEG_VALUE_SET_ID
515 ,P_ACCT_LEVEL
516 ,ACCT_VALUE
517 ,ACCT_VALUE_DESC
518 ,P_ACCT_DELIMITER
519 ,7));
520 END ACCT_LEVEL7_VALUEFORMULA;
521
522 FUNCTION ACCT_LEVEL7_VALUE_DESCFORMULA(ACCT_VALUE IN VARCHAR2
523 ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR IS
524 BEGIN
525 /*SRW.REFERENCE(ACCT_VALUE)*/NULL;
526 /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
527 RETURN (JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_DESC(ACCT_SEG_VALUE_SET_ID
528 ,P_ACCT_LEVEL
529 ,ACCT_VALUE
530 ,ACCT_VALUE_DESC
531 ,P_ACCT_DELIMITER
532 ,7));
533 END ACCT_LEVEL7_VALUE_DESCFORMULA;
534
535 FUNCTION ACCT_LEVEL8_VALUEFORMULA(ACCT_VALUE IN VARCHAR2
536 ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR IS
537 BEGIN
538 /*SRW.REFERENCE(ACCT_VALUE)*/NULL;
539 /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
540 RETURN (JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_VALUE(ACCT_SEG_VALUE_SET_ID
541 ,P_ACCT_LEVEL
542 ,ACCT_VALUE
543 ,ACCT_VALUE_DESC
544 ,P_ACCT_DELIMITER
545 ,8));
546 END ACCT_LEVEL8_VALUEFORMULA;
547
548 FUNCTION ACCT_LEVEL8_VALUE_DESCFORMULA(ACCT_VALUE IN VARCHAR2
549 ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR IS
550 BEGIN
551 /*SRW.REFERENCE(ACCT_VALUE)*/NULL;
552 /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
553 RETURN (JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_DESC(ACCT_SEG_VALUE_SET_ID
554 ,P_ACCT_LEVEL
555 ,ACCT_VALUE
556 ,ACCT_VALUE_DESC
557 ,P_ACCT_DELIMITER
558 ,8));
559 END ACCT_LEVEL8_VALUE_DESCFORMULA;
560
561 FUNCTION ACCT_LEVEL9_VALUEFORMULA(ACCT_VALUE IN VARCHAR2
562 ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR IS
563 BEGIN
564 /*SRW.REFERENCE(ACCT_VALUE)*/NULL;
565 /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
566 RETURN (JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_VALUE(ACCT_SEG_VALUE_SET_ID
567 ,P_ACCT_LEVEL
568 ,ACCT_VALUE
569 ,ACCT_VALUE_DESC
570 ,P_ACCT_DELIMITER
571 ,9));
572 END ACCT_LEVEL9_VALUEFORMULA;
573
574 FUNCTION ACCT_LEVEL9_VALUE_DESCFORMULA(ACCT_VALUE IN VARCHAR2
575 ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR IS
576 BEGIN
577 /*SRW.REFERENCE(ACCT_VALUE)*/NULL;
578 /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
579 RETURN (JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_DESC(ACCT_SEG_VALUE_SET_ID
580 ,P_ACCT_LEVEL
581 ,ACCT_VALUE
582 ,ACCT_VALUE_DESC
583 ,P_ACCT_DELIMITER
584 ,9));
585 END ACCT_LEVEL9_VALUE_DESCFORMULA;
586
587 FUNCTION ACCT_LEVEL10_VALUEFORMULA(ACCT_VALUE IN VARCHAR2
588 ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR IS
589 BEGIN
590 /*SRW.REFERENCE(ACCT_VALUE)*/NULL;
591 /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
592 RETURN (JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_VALUE(ACCT_SEG_VALUE_SET_ID
593 ,P_ACCT_LEVEL
594 ,ACCT_VALUE
595 ,ACCT_VALUE_DESC
596 ,P_ACCT_DELIMITER
597 ,10));
598 END ACCT_LEVEL10_VALUEFORMULA;
599
600 FUNCTION ACCT_LEVEL10_VALUE_DESCFORMULA(ACCT_VALUE IN VARCHAR2
601 ,ACCT_VALUE_DESC IN VARCHAR2) RETURN CHAR IS
602 BEGIN
603 /*SRW.REFERENCE(ACCT_VALUE)*/NULL;
604 /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
605 RETURN (JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_DESC(ACCT_SEG_VALUE_SET_ID
606 ,P_ACCT_LEVEL
607 ,ACCT_VALUE
608 ,ACCT_VALUE_DESC
609 ,P_ACCT_DELIMITER
610 ,10));
611 END ACCT_LEVEL10_VALUE_DESCFORMULA;
612
613 FUNCTION DATA_ACCESS_SET_NAME_P RETURN VARCHAR2 IS
614 BEGIN
615 RETURN DATA_ACCESS_SET_NAME;
616 END DATA_ACCESS_SET_NAME_P;
617
618 FUNCTION CHART_OF_ACCOUNTS_ID_P RETURN NUMBER IS
619 BEGIN
620 RETURN CHART_OF_ACCOUNTS_ID;
621 END CHART_OF_ACCOUNTS_ID_P;
622
623 FUNCTION DAS_WHERE_P RETURN VARCHAR2 IS
624 BEGIN
625 RETURN DAS_WHERE;
626 END DAS_WHERE_P;
627
628 FUNCTION CURR_WHERE_JRNL_P RETURN VARCHAR2 IS
629 BEGIN
630 RETURN CURR_WHERE_JRNL;
631 END CURR_WHERE_JRNL_P;
632
633 FUNCTION PERIOD_WHERE_P RETURN VARCHAR2 IS
634 BEGIN
635 RETURN PERIOD_WHERE;
636 END PERIOD_WHERE_P;
637
638 FUNCTION ACCT_WHERE_P RETURN VARCHAR2 IS
639 BEGIN
640 RETURN ACCT_WHERE;
641 END ACCT_WHERE_P;
642
643 FUNCTION SELECT_ACCOUNT_P RETURN VARCHAR2 IS
644 BEGIN
645 RETURN SELECT_ACCOUNT;
646 END SELECT_ACCOUNT_P;
647
648 FUNCTION SELECT_ACCT_SEG_P RETURN VARCHAR2 IS
649 BEGIN
650 RETURN SELECT_ACCT_SEG;
651 END SELECT_ACCT_SEG_P;
652
653 FUNCTION SELECT_BAL_SEG_P RETURN VARCHAR2 IS
654 BEGIN
655 RETURN SELECT_BAL_SEG;
656 END SELECT_BAL_SEG_P;
657
658 FUNCTION TEMP_ACCT_WHERE_P RETURN VARCHAR2 IS
659 BEGIN
660 RETURN TEMP_ACCT_WHERE;
661 END TEMP_ACCT_WHERE_P;
662
663 FUNCTION TEMP_LE_NAME_P RETURN VARCHAR2 IS
664 BEGIN
665 RETURN TEMP_LE_NAME;
666 END TEMP_LE_NAME_P;
667
668 FUNCTION TEMP_TAX_PAYER_ID_P RETURN VARCHAR2 IS
669 BEGIN
670 RETURN TEMP_TAX_PAYER_ID;
671 END TEMP_TAX_PAYER_ID_P;
672
673 FUNCTION TEMP_SERVICE_TYPE_P RETURN VARCHAR2 IS
674 BEGIN
675 RETURN TEMP_SERVICE_TYPE;
676 END TEMP_SERVICE_TYPE_P;
677
678 FUNCTION TEMP_ADDR1_P RETURN VARCHAR2 IS
679 BEGIN
680 RETURN TEMP_ADDR1;
681 END TEMP_ADDR1_P;
682
683 FUNCTION TEMP_ADDR2_P RETURN VARCHAR2 IS
684 BEGIN
685 RETURN TEMP_ADDR2;
686 END TEMP_ADDR2_P;
687
688 FUNCTION FP_START_DATE_P RETURN DATE IS
689 BEGIN
690 RETURN FP_START_DATE;
691 END FP_START_DATE_P;
692
693 FUNCTION TP_END_DATE_P RETURN DATE IS
694 BEGIN
695 RETURN TP_END_DATE;
696 END TP_END_DATE_P;
697
698 FUNCTION LE_WHERE_P RETURN VARCHAR2 IS
699 BEGIN
700 RETURN LE_WHERE;
701 END LE_WHERE_P;
702
703 FUNCTION SELECT_IC_SEG_P RETURN VARCHAR2 IS
704 BEGIN
705 RETURN SELECT_IC_SEG;
706 END SELECT_IC_SEG_P;
707
708 FUNCTION SELECT_MGT_SEG_P RETURN VARCHAR2 IS
709 BEGIN
710 RETURN SELECT_MGT_SEG;
711 END SELECT_MGT_SEG_P;
712
713 FUNCTION SELECT_ST_SEG_P RETURN VARCHAR2 IS
714 BEGIN
715 RETURN SELECT_ST_SEG;
716 END SELECT_ST_SEG_P;
717
718 FUNCTION SELECT_LE_P RETURN VARCHAR2 IS
719 BEGIN
720 RETURN SELECT_LE;
721 END SELECT_LE_P;
722
723 FUNCTION FROM_LNSV_P RETURN VARCHAR2 IS
724 BEGIN
725 RETURN FROM_LNSV;
726 END FROM_LNSV_P;
727
728 FUNCTION REP_EXECUTION_DATE_P RETURN VARCHAR2 IS
729 BEGIN
730 RETURN REP_EXECUTION_DATE;
731 END REP_EXECUTION_DATE_P;
732
733 FUNCTION TEMP_ADDR3_P RETURN VARCHAR2 IS
734 BEGIN
735 RETURN TEMP_ADDR3;
736 END TEMP_ADDR3_P;
737
738 FUNCTION TEMP_TOWN_CITY_P RETURN VARCHAR2 IS
739 BEGIN
740 RETURN TEMP_TOWN_CITY;
741 END TEMP_TOWN_CITY_P;
742
743 FUNCTION TEMP_POSTAL_CODE_P RETURN VARCHAR2 IS
744 BEGIN
745 RETURN TEMP_POSTAL_CODE;
746 END TEMP_POSTAL_CODE_P;
747
748 FUNCTION TEMP_LE_ID_P RETURN NUMBER IS
749 BEGIN
750 RETURN TEMP_LE_ID;
751 END TEMP_LE_ID_P;
752
753 FUNCTION START_DATE_PARAM_P RETURN VARCHAR2 IS
754 BEGIN
755 RETURN START_DATE_PARAM;
756 END START_DATE_PARAM_P;
757
758 FUNCTION END_DATE_PARAM_P RETURN VARCHAR2 IS
759 BEGIN
760 RETURN END_DATE_PARAM;
761 END END_DATE_PARAM_P;
762
763 FUNCTION SELECT_CC_SEG_P RETURN VARCHAR2 IS
764 BEGIN
765 RETURN SELECT_CC_SEG;
766 END SELECT_CC_SEG_P;
767
768 FUNCTION PAGE_NUM_FORMAT_PARAM_P RETURN VARCHAR2 IS
769 BEGIN
770 RETURN PAGE_NUM_FORMAT_PARAM;
771 END PAGE_NUM_FORMAT_PARAM_P;
772
773 FUNCTION CURRENCY_TYPE_PARAM_P RETURN VARCHAR2 IS
774 BEGIN
775 RETURN CURRENCY_TYPE_PARAM;
776 END CURRENCY_TYPE_PARAM_P;
777
778 FUNCTION CURRENCY_PARAM_P RETURN VARCHAR2 IS
779 BEGIN
780 RETURN CURRENCY_PARAM;
781 END CURRENCY_PARAM_P;
782
783 FUNCTION ACCT_LEVEL_PARAM_P RETURN NUMBER IS
784 BEGIN
785 RETURN ACCT_LEVEL_PARAM;
786 END ACCT_LEVEL_PARAM_P;
787
788 FUNCTION PERIOD_TO_PARAM_P RETURN VARCHAR2 IS
789 BEGIN
790 RETURN PERIOD_TO_PARAM;
791 END PERIOD_TO_PARAM_P;
792
793 FUNCTION PERIOD_FROM_PARAM_P RETURN VARCHAR2 IS
794 BEGIN
795 RETURN PERIOD_FROM_PARAM;
796 END PERIOD_FROM_PARAM_P;
797
798 FUNCTION ACCT_TO_PARAM_P RETURN VARCHAR2 IS
799 BEGIN
800 RETURN ACCT_TO_PARAM;
801 END ACCT_TO_PARAM_P;
802
803 FUNCTION ACCT_FROM_PARAM_P RETURN VARCHAR2 IS
804 BEGIN
805 RETURN ACCT_FROM_PARAM;
806 END ACCT_FROM_PARAM_P;
807
808 FUNCTION LEDGER_CURRENCY_P RETURN VARCHAR2 IS
809 BEGIN
810 RETURN LEDGER_CURRENCY;
811 END LEDGER_CURRENCY_P;
812
813 FUNCTION LEDGER_NAME_PARAM_P RETURN VARCHAR2 IS
814 BEGIN
815 RETURN LEDGER_NAME_PARAM;
816 END LEDGER_NAME_PARAM_P;
817
818 FUNCTION F_PERIOD_NUM_P RETURN NUMBER IS
819 BEGIN
820 RETURN F_PERIOD_NUM;
821 END F_PERIOD_NUM_P;
822
823 FUNCTION T_PERIOD_NUM_P RETURN NUMBER IS
824 BEGIN
825 RETURN T_PERIOD_NUM;
826 END T_PERIOD_NUM_P;
827
828 FUNCTION BALANCE_TYPE_PARAM_P RETURN VARCHAR2 IS
829 BEGIN
830 RETURN BALANCE_TYPE_PARAM;
831 END BALANCE_TYPE_PARAM_P;
832
833 FUNCTION BUDGETNAME_ENCUMBRANCETYPE_P RETURN VARCHAR2 IS
834 BEGIN
835 RETURN BUDGETNAME_ENCUMBRANCETYPE;
836 END BUDGETNAME_ENCUMBRANCETYPE_P;
837
838 FUNCTION PAGE_NUM_START_PARAM_P RETURN NUMBER IS
839 BEGIN
840 RETURN PAGE_NUM_START_PARAM;
841 END PAGE_NUM_START_PARAM_P;
842
843 FUNCTION USER_PARAM_1_P RETURN VARCHAR2 IS
844 BEGIN
845 RETURN USER_PARAM_1;
846 END USER_PARAM_1_P;
847
848 FUNCTION USER_PARAM_2_P RETURN VARCHAR2 IS
849 BEGIN
850 RETURN USER_PARAM_2;
851 END USER_PARAM_2_P;
852
853 FUNCTION USER_PARAM_3_P RETURN VARCHAR2 IS
854 BEGIN
855 RETURN USER_PARAM_3;
856 END USER_PARAM_3_P;
857
858 FUNCTION USER_PARAM_4_P RETURN VARCHAR2 IS
859 BEGIN
860 RETURN USER_PARAM_4;
861 END USER_PARAM_4_P;
862
863 FUNCTION USER_PARAM_5_P RETURN VARCHAR2 IS
864 BEGIN
865 RETURN USER_PARAM_5;
866 END USER_PARAM_5_P;
867
868 FUNCTION CURR_WHERE_BAL_P RETURN VARCHAR2 IS
869 BEGIN
870 RETURN CURR_WHERE_BAL;
871 END CURR_WHERE_BAL_P;
872
873 FUNCTION BUDENC_WHERE_JRNL_P RETURN VARCHAR2 IS
874 BEGIN
875 RETURN BUDENC_WHERE_JRNL;
876 END BUDENC_WHERE_JRNL_P;
877
878 FUNCTION BUDENC_WHERE_BAL_P RETURN VARCHAR2 IS
879 BEGIN
880 RETURN BUDENC_WHERE_BAL;
881 END BUDENC_WHERE_BAL_P;
882
883 FUNCTION BAL_CURRENCY_P RETURN VARCHAR2 IS
884 BEGIN
885 RETURN BAL_CURRENCY;
886 END BAL_CURRENCY_P;
887
888 FUNCTION SELECT_DR_P RETURN VARCHAR2 IS
889 BEGIN
890 RETURN SELECT_DR;
891 END SELECT_DR_P;
892
893 FUNCTION SELECT_CR_P RETURN VARCHAR2 IS
894 BEGIN
895 RETURN SELECT_CR;
896 END SELECT_CR_P;
897
898 FUNCTION SELECT_BEGIN_BAL_P RETURN VARCHAR2 IS
899 BEGIN
900 RETURN SELECT_BEGIN_BAL;
901 END SELECT_BEGIN_BAL_P;
902
903 FUNCTION ACCT_SEG_VALUE_SET_ID_P RETURN NUMBER IS
904 BEGIN
905 RETURN ACCT_SEG_VALUE_SET_ID;
906 END ACCT_SEG_VALUE_SET_ID_P;
907
908 FUNCTION SEG_SECURITY_WHERE_P RETURN VARCHAR2 IS
909 BEGIN
910 RETURN SEG_SECURITY_WHERE;
911 END SEG_SECURITY_WHERE_P;
912
913 END JG_JGZZGLJRB_XMLP_PKG;
914
915
916