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.

APPS.JL_JGZZGLTRB_XMLP_PKG dependencies on JG_GL_ACCT_HIER_PKG

Line 180: JG_GL_ACCT_HIER_PKG.POPULATE_ACCT_HIER_TABLE(ACCT_SEG_VALUE_SET_ID

176: AND FS.ID_FLEX_NUM = COA_ID
177: AND FS.ENABLED_FLAG = 'Y';
178: END IF;
179: IF (P_ACCT_LEVEL > 0) THEN
180: JG_GL_ACCT_HIER_PKG.POPULATE_ACCT_HIER_TABLE(ACCT_SEG_VALUE_SET_ID
181: ,P_TOP_PARENT_VALUE);
182: END IF;
183: IF (P_REPORT_TYPE IS NOT NULL) THEN
184: WHERE_DEGREE := 'and EXISTS (select 1' || ' from FND_FLEX_VALUES_VL parent' || ' where parent.flex_value_set_id = ' || TO_CHAR(ACCT_SEG_VALUE_SET_ID) || ' and substr(' || SELECT_ACCT_SEG

Line 265: VAL := JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_VALUE(ACCT_SEG_VALUE_SET_ID

261: VAL VARCHAR2(40);
262: BEGIN
263: /*SRW.REFERENCE(ACCOUNT_SEGMENT_VALUE)*/NULL;
264: /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
265: VAL := JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_VALUE(ACCT_SEG_VALUE_SET_ID
266: ,P_ACCT_LEVEL
267: ,ACCOUNT_SEGMENT_VALUE
268: ,ACCT_VALUE_DESC
269: ,P_ACCT_DELIMITER

Line 280: VAL := JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_VALUE(ACCT_SEG_VALUE_SET_ID

276: VAL VARCHAR2(40);
277: BEGIN
278: /*SRW.REFERENCE(ACCOUNT_SEGMENT_VALUE)*/NULL;
279: /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
280: VAL := JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_VALUE(ACCT_SEG_VALUE_SET_ID
281: ,P_ACCT_LEVEL
282: ,ACCOUNT_SEGMENT_VALUE
283: ,ACCT_VALUE_DESC
284: ,P_ACCT_DELIMITER

Line 295: VAL := JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_VALUE(ACCT_SEG_VALUE_SET_ID

291: VAL VARCHAR2(40);
292: BEGIN
293: /*SRW.REFERENCE(ACCOUNT_SEGMENT_VALUE)*/NULL;
294: /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
295: VAL := JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_VALUE(ACCT_SEG_VALUE_SET_ID
296: ,P_ACCT_LEVEL
297: ,ACCOUNT_SEGMENT_VALUE
298: ,ACCT_VALUE_DESC
299: ,P_ACCT_DELIMITER

Line 310: VAL := JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_VALUE(ACCT_SEG_VALUE_SET_ID

306: VAL VARCHAR2(40);
307: BEGIN
308: /*SRW.REFERENCE(ACCOUNT_SEGMENT_VALUE)*/NULL;
309: /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
310: VAL := JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_VALUE(ACCT_SEG_VALUE_SET_ID
311: ,P_ACCT_LEVEL
312: ,ACCOUNT_SEGMENT_VALUE
313: ,ACCT_VALUE_DESC
314: ,P_ACCT_DELIMITER

Line 325: VAL := JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_VALUE(ACCT_SEG_VALUE_SET_ID

321: VAL VARCHAR2(40);
322: BEGIN
323: /*SRW.REFERENCE(ACCOUNT_SEGMENT_VALUE)*/NULL;
324: /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
325: VAL := JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_VALUE(ACCT_SEG_VALUE_SET_ID
326: ,P_ACCT_LEVEL
327: ,ACCOUNT_SEGMENT_VALUE
328: ,ACCT_VALUE_DESC
329: ,P_ACCT_DELIMITER

Line 340: VAL := JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_VALUE(ACCT_SEG_VALUE_SET_ID

336: VAL VARCHAR2(40);
337: BEGIN
338: /*SRW.REFERENCE(ACCOUNT_SEGMENT_VALUE)*/NULL;
339: /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
340: VAL := JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_VALUE(ACCT_SEG_VALUE_SET_ID
341: ,P_ACCT_LEVEL
342: ,ACCOUNT_SEGMENT_VALUE
343: ,ACCT_VALUE_DESC
344: ,P_ACCT_DELIMITER

Line 355: VAL := JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_VALUE(ACCT_SEG_VALUE_SET_ID

351: VAL VARCHAR2(40);
352: BEGIN
353: /*SRW.REFERENCE(ACCOUNT_SEGMENT_VALUE)*/NULL;
354: /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
355: VAL := JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_VALUE(ACCT_SEG_VALUE_SET_ID
356: ,P_ACCT_LEVEL
357: ,ACCOUNT_SEGMENT_VALUE
358: ,ACCT_VALUE_DESC
359: ,P_ACCT_DELIMITER

Line 370: VAL := JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_VALUE(ACCT_SEG_VALUE_SET_ID

366: VAL VARCHAR2(40);
367: BEGIN
368: /*SRW.REFERENCE(ACCOUNT_SEGMENT_VALUE)*/NULL;
369: /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
370: VAL := JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_VALUE(ACCT_SEG_VALUE_SET_ID
371: ,P_ACCT_LEVEL
372: ,ACCOUNT_SEGMENT_VALUE
373: ,ACCT_VALUE_DESC
374: ,P_ACCT_DELIMITER

Line 385: VAL := JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_VALUE(ACCT_SEG_VALUE_SET_ID

381: VAL VARCHAR2(40);
382: BEGIN
383: /*SRW.REFERENCE(ACCOUNT_SEGMENT_VALUE)*/NULL;
384: /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
385: VAL := JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_VALUE(ACCT_SEG_VALUE_SET_ID
386: ,P_ACCT_LEVEL
387: ,ACCOUNT_SEGMENT_VALUE
388: ,ACCT_VALUE_DESC
389: ,P_ACCT_DELIMITER

Line 400: STR := JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_DESC(ACCT_SEG_VALUE_SET_ID

396: STR VARCHAR2(240);
397: BEGIN
398: /*SRW.REFERENCE(ACCOUNT_SEGMENT_VALUE)*/NULL;
399: /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
400: STR := JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_DESC(ACCT_SEG_VALUE_SET_ID
401: ,P_ACCT_LEVEL
402: ,ACCOUNT_SEGMENT_VALUE
403: ,ACCT_VALUE_DESC
404: ,P_ACCT_DELIMITER

Line 415: STR := JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_DESC(ACCT_SEG_VALUE_SET_ID

411: STR VARCHAR2(240);
412: BEGIN
413: /*SRW.REFERENCE(ACCOUNT_SEGMENT_VALUE)*/NULL;
414: /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
415: STR := JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_DESC(ACCT_SEG_VALUE_SET_ID
416: ,P_ACCT_LEVEL
417: ,ACCOUNT_SEGMENT_VALUE
418: ,ACCT_VALUE_DESC
419: ,P_ACCT_DELIMITER

Line 430: STR := JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_DESC(ACCT_SEG_VALUE_SET_ID

426: STR VARCHAR2(240);
427: BEGIN
428: /*SRW.REFERENCE(ACCOUNT_SEGMENT_VALUE)*/NULL;
429: /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
430: STR := JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_DESC(ACCT_SEG_VALUE_SET_ID
431: ,P_ACCT_LEVEL
432: ,ACCOUNT_SEGMENT_VALUE
433: ,ACCT_VALUE_DESC
434: ,P_ACCT_DELIMITER

Line 445: STR := JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_DESC(ACCT_SEG_VALUE_SET_ID

441: STR VARCHAR2(240);
442: BEGIN
443: /*SRW.REFERENCE(ACCOUNT_SEGMENT_VALUE)*/NULL;
444: /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
445: STR := JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_DESC(ACCT_SEG_VALUE_SET_ID
446: ,P_ACCT_LEVEL
447: ,ACCOUNT_SEGMENT_VALUE
448: ,ACCT_VALUE_DESC
449: ,P_ACCT_DELIMITER

Line 460: STR := JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_DESC(ACCT_SEG_VALUE_SET_ID

456: STR VARCHAR2(240);
457: BEGIN
458: /*SRW.REFERENCE(ACCOUNT_SEGMENT_VALUE)*/NULL;
459: /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
460: STR := JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_DESC(ACCT_SEG_VALUE_SET_ID
461: ,P_ACCT_LEVEL
462: ,ACCOUNT_SEGMENT_VALUE
463: ,ACCT_VALUE_DESC
464: ,P_ACCT_DELIMITER

Line 475: STR := JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_DESC(ACCT_SEG_VALUE_SET_ID

471: STR VARCHAR2(240);
472: BEGIN
473: /*SRW.REFERENCE(ACCOUNT_SEGMENT_VALUE)*/NULL;
474: /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
475: STR := JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_DESC(ACCT_SEG_VALUE_SET_ID
476: ,P_ACCT_LEVEL
477: ,ACCOUNT_SEGMENT_VALUE
478: ,ACCT_VALUE_DESC
479: ,P_ACCT_DELIMITER

Line 490: STR := JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_DESC(ACCT_SEG_VALUE_SET_ID

486: STR VARCHAR2(240);
487: BEGIN
488: /*SRW.REFERENCE(ACCOUNT_SEGMENT_VALUE)*/NULL;
489: /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
490: STR := JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_DESC(ACCT_SEG_VALUE_SET_ID
491: ,P_ACCT_LEVEL
492: ,ACCOUNT_SEGMENT_VALUE
493: ,ACCT_VALUE_DESC
494: ,P_ACCT_DELIMITER

Line 505: STR := JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_DESC(ACCT_SEG_VALUE_SET_ID

501: STR VARCHAR2(240);
502: BEGIN
503: /*SRW.REFERENCE(ACCOUNT_SEGMENT_VALUE)*/NULL;
504: /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
505: STR := JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_DESC(ACCT_SEG_VALUE_SET_ID
506: ,P_ACCT_LEVEL
507: ,ACCOUNT_SEGMENT_VALUE
508: ,ACCT_VALUE_DESC
509: ,P_ACCT_DELIMITER

Line 520: STR := JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_DESC(ACCT_SEG_VALUE_SET_ID

516: STR VARCHAR2(240);
517: BEGIN
518: /*SRW.REFERENCE(ACCOUNT_SEGMENT_VALUE)*/NULL;
519: /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
520: STR := JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_DESC(ACCT_SEG_VALUE_SET_ID
521: ,P_ACCT_LEVEL
522: ,ACCOUNT_SEGMENT_VALUE
523: ,ACCT_VALUE_DESC
524: ,P_ACCT_DELIMITER

Line 648: VAL := JG_GL_ACCT_HIER_PKG.GET_DELIMITED_DETAIL_ACCT(ACCT_SEG_VALUE_SET_ID

644: VAL VARCHAR2(40);
645: BEGIN
646: /*SRW.REFERENCE(ACCOUNT_SEGMENT_VALUE)*/NULL;
647: /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
648: VAL := JG_GL_ACCT_HIER_PKG.GET_DELIMITED_DETAIL_ACCT(ACCT_SEG_VALUE_SET_ID
649: ,P_ACCT_LEVEL
650: ,ACCOUNT_SEGMENT_VALUE
651: ,ACCT_VALUE_DESC
652: ,P_ACCT_DELIMITER);

Line 665: VAL := JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_VALUE(ACCT_SEG_VALUE_SET_ID

661: VAL VARCHAR2(40);
662: BEGIN
663: /*SRW.REFERENCE(ACCOUNT_SEGMENT_VALUE)*/NULL;
664: /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
665: VAL := JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_VALUE(ACCT_SEG_VALUE_SET_ID
666: ,P_ACCT_LEVEL
667: ,ACCOUNT_SEGMENT_VALUE
668: ,ACCT_VALUE_DESC
669: ,P_ACCT_DELIMITER

Line 680: STR := JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_DESC(ACCT_SEG_VALUE_SET_ID

676: STR VARCHAR2(240);
677: BEGIN
678: /*SRW.REFERENCE(ACCOUNT_SEGMENT_VALUE)*/NULL;
679: /*SRW.REFERENCE(ACCT_VALUE_DESC)*/NULL;
680: STR := JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_DESC(ACCT_SEG_VALUE_SET_ID
681: ,P_ACCT_LEVEL
682: ,ACCOUNT_SEGMENT_VALUE
683: ,ACCT_VALUE_DESC
684: ,P_ACCT_DELIMITER