DBA Data[Home] [Help]

APPS.JL_JLCOARCR_XMLP_PKG dependencies on GL_INFO

Line 572: STPROC.INIT('begin GL_INFO.GL_GET_PERIOD_DATES(:TSET_OF_BOOKS_ID, :TPERIOD_NAME, :TSTART_DATE, :TEND_DATE, :ERRBUF); end;');

568: ,TSTART_DATE OUT NOCOPY DATE
569: ,TEND_DATE OUT NOCOPY DATE
570: ,ERRBUF OUT NOCOPY VARCHAR2) IS
571: BEGIN
572: STPROC.INIT('begin GL_INFO.GL_GET_PERIOD_DATES(:TSET_OF_BOOKS_ID, :TPERIOD_NAME, :TSTART_DATE, :TEND_DATE, :ERRBUF); end;');
573: STPROC.BIND_I(TSET_OF_BOOKS_ID);
574: STPROC.BIND_I(TPERIOD_NAME);
575: STPROC.BIND_O(TSTART_DATE);
576: STPROC.BIND_O(TEND_DATE);

Line 592: GL_INFO.GL_GET_LEDGER_INFO(SOBID, COAID, SOBNAME, FUNC_CURR, ERRBUF);

588: ,SOBNAME OUT NOCOPY VARCHAR2
589: ,FUNC_CURR OUT NOCOPY VARCHAR2
590: ,ERRBUF OUT NOCOPY VARCHAR2) IS
591: BEGIN
592: GL_INFO.GL_GET_LEDGER_INFO(SOBID, COAID, SOBNAME, FUNC_CURR, ERRBUF);
593: END GL_GET_SET_OF_BOOKS_INFO;
594: /* PROCEDURE GL_GET_BUD_OR_ENC_NAME(ACTUAL_TYPE IN VARCHAR2
595: ,TYPE_ID IN NUMBER
596: ,NAME OUT NOCOPY VARCHAR2

Line 599: STPROC.INIT('begin GL_INFO.GL_GET_BUD_OR_ENC_NAME(:ACTUAL_TYPE, :TYPE_ID, :NAME, :ERRBUF); end;');

595: ,TYPE_ID IN NUMBER
596: ,NAME OUT NOCOPY VARCHAR2
597: ,ERRBUF OUT NOCOPY VARCHAR2) IS
598: BEGIN
599: STPROC.INIT('begin GL_INFO.GL_GET_BUD_OR_ENC_NAME(:ACTUAL_TYPE, :TYPE_ID, :NAME, :ERRBUF); end;');
600: STPROC.BIND_I(ACTUAL_TYPE);
601: STPROC.BIND_I(TYPE_ID);
602: STPROC.BIND_O(NAME);
603: STPROC.BIND_O(ERRBUF);

Line 616: STPROC.INIT('begin GL_INFO.GL_GET_LOOKUP_VALUE(:LMODE, :CODE, :TYPE, :VALUE, :ERRBUF); end;');

612: ,TYPE IN VARCHAR2
613: ,VALUE OUT NOCOPY VARCHAR2
614: ,ERRBUF OUT NOCOPY VARCHAR2) IS
615: BEGIN
616: STPROC.INIT('begin GL_INFO.GL_GET_LOOKUP_VALUE(:LMODE, :CODE, :TYPE, :VALUE, :ERRBUF); end;');
617: STPROC.BIND_I(LMODE);
618: STPROC.BIND_I(CODE);
619: STPROC.BIND_I(TYPE);
620: STPROC.BIND_O(VALUE);

Line 633: STPROC.INIT('begin GL_INFO.GL_GET_FIRST_PERIOD(:TSET_OF_BOOKS_ID, :TPERIOD_NAME, :TFIRST_PERIOD, :ERRBUF); end;');

629: ,TPERIOD_NAME IN VARCHAR2
630: ,TFIRST_PERIOD OUT NOCOPY VARCHAR2
631: ,ERRBUF OUT NOCOPY VARCHAR2) IS
632: BEGIN
633: STPROC.INIT('begin GL_INFO.GL_GET_FIRST_PERIOD(:TSET_OF_BOOKS_ID, :TPERIOD_NAME, :TFIRST_PERIOD, :ERRBUF); end;');
634: STPROC.BIND_I(TSET_OF_BOOKS_ID);
635: STPROC.BIND_I(TPERIOD_NAME);
636: STPROC.BIND_O(TFIRST_PERIOD);
637: STPROC.BIND_O(ERRBUF);

Line 649: STPROC.INIT('begin GL_INFO.GL_GET_FIRST_PERIOD_OF_QUARTER(:TSET_OF_BOOKS_ID, :TPERIOD_NAME, :TFIRST_PERIOD, :ERRBUF); end;');

645: ,TPERIOD_NAME IN VARCHAR2
646: ,TFIRST_PERIOD OUT NOCOPY VARCHAR2
647: ,ERRBUF OUT NOCOPY VARCHAR2) IS
648: BEGIN
649: STPROC.INIT('begin GL_INFO.GL_GET_FIRST_PERIOD_OF_QUARTER(:TSET_OF_BOOKS_ID, :TPERIOD_NAME, :TFIRST_PERIOD, :ERRBUF); end;');
650: STPROC.BIND_I(TSET_OF_BOOKS_ID);
651: STPROC.BIND_I(TPERIOD_NAME);
652: STPROC.BIND_O(TFIRST_PERIOD);
653: STPROC.BIND_O(ERRBUF);

Line 671: STPROC.INIT('begin GL_INFO.GL_GET_CONSOLIDATION_INFO(:CONS_ID, :CONS_NAME, :METHOD, :CURR_CODE, :FROM_SOBID, :TO_SOBID, :DESCRIPTION, :START_DATE, :END_DATE, :ERRBUF); end;');

667: ,START_DATE OUT NOCOPY DATE
668: ,END_DATE OUT NOCOPY DATE
669: ,ERRBUF OUT NOCOPY VARCHAR2) IS
670: BEGIN
671: STPROC.INIT('begin GL_INFO.GL_GET_CONSOLIDATION_INFO(:CONS_ID, :CONS_NAME, :METHOD, :CURR_CODE, :FROM_SOBID, :TO_SOBID, :DESCRIPTION, :START_DATE, :END_DATE, :ERRBUF); end;');
672: STPROC.BIND_I(CONS_ID);
673: STPROC.BIND_O(CONS_NAME);
674: STPROC.BIND_O(METHOD);
675: STPROC.BIND_O(CURR_CODE);