DBA Data[Home] [Help]

APPS.JG_JGZZGLJRB_XMLP_PKG dependencies on JG_GL_ACCT_HIER_PKG

Line 160: JG_GL_ACCT_HIER_PKG.POPULATE_ACCT_HIER_TABLE(ACCT_SEG_VALUE_SET_ID

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

Line 358: RETURN (JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_VALUE(ACCT_SEG_VALUE_SET_ID

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

Line 371: RETURN (JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_DESC(ACCT_SEG_VALUE_SET_ID

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

Line 384: RETURN (JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_VALUE(ACCT_SEG_VALUE_SET_ID

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

Line 397: RETURN (JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_DESC(ACCT_SEG_VALUE_SET_ID

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

Line 410: RETURN (JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_VALUE(ACCT_SEG_VALUE_SET_ID

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

Line 423: RETURN (JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_DESC(ACCT_SEG_VALUE_SET_ID

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

Line 436: RETURN (JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_VALUE(ACCT_SEG_VALUE_SET_ID

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

Line 449: RETURN (JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_DESC(ACCT_SEG_VALUE_SET_ID

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

Line 462: RETURN (JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_VALUE(ACCT_SEG_VALUE_SET_ID

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

Line 475: RETURN (JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_DESC(ACCT_SEG_VALUE_SET_ID

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

Line 488: RETURN (JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_VALUE(ACCT_SEG_VALUE_SET_ID

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

Line 501: RETURN (JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_DESC(ACCT_SEG_VALUE_SET_ID

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

Line 514: RETURN (JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_VALUE(ACCT_SEG_VALUE_SET_ID

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

Line 527: RETURN (JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_DESC(ACCT_SEG_VALUE_SET_ID

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

Line 540: RETURN (JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_VALUE(ACCT_SEG_VALUE_SET_ID

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

Line 553: RETURN (JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_DESC(ACCT_SEG_VALUE_SET_ID

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

Line 566: RETURN (JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_VALUE(ACCT_SEG_VALUE_SET_ID

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

Line 579: RETURN (JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_DESC(ACCT_SEG_VALUE_SET_ID

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

Line 592: RETURN (JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_VALUE(ACCT_SEG_VALUE_SET_ID

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

Line 605: RETURN (JG_GL_ACCT_HIER_PKG.GET_LEVEL_ACCT_DESC(ACCT_SEG_VALUE_SET_ID

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