DBA Data[Home] [Help]

APPS.JG_JGZZRDLR_XMLP_PKG dependencies on JG_INFO

Line 544: /*STPROC.INIT('begin JG_INFO.JG_GET_SET_OF_BOOKS_INFO(:SOBID, :COAID, :SOBNAME, :FUNC_CURR, :ERRBUF); end;');

540: ,SOBNAME OUT NOCOPY VARCHAR2
541: ,FUNC_CURR OUT NOCOPY VARCHAR2
542: ,ERRBUF OUT NOCOPY VARCHAR2) IS
543: BEGIN
544: /*STPROC.INIT('begin JG_INFO.JG_GET_SET_OF_BOOKS_INFO(:SOBID, :COAID, :SOBNAME, :FUNC_CURR, :ERRBUF); end;');
545: STPROC.BIND_I(SOBID);
546: STPROC.BIND_O(COAID);
547: STPROC.BIND_O(SOBNAME);
548: STPROC.BIND_O(FUNC_CURR);

Line 559: JG_INFO.JG_GET_SET_OF_BOOKS_INFO(SOBID,COAID,SOBNAME,FUNC_CURR,ERRBUF);

555: STPROC.RETRIEVE(4
556: ,FUNC_CURR);
557: STPROC.RETRIEVE(5
558: ,ERRBUF);*/
559: JG_INFO.JG_GET_SET_OF_BOOKS_INFO(SOBID,COAID,SOBNAME,FUNC_CURR,ERRBUF);
560: END JG_GET_SET_OF_BOOKS_INFO;
561:
562: PROCEDURE JG_GET_BUD_OR_ENC_NAME(ACTUAL_TYPE IN VARCHAR2
563: ,TYPE_ID IN NUMBER

Line 567: /*STPROC.INIT('begin JG_INFO.JG_GET_BUD_OR_ENC_NAME(:ACTUAL_TYPE, :TYPE_ID, :NAME, :ERRBUF); end;');

563: ,TYPE_ID IN NUMBER
564: ,NAME OUT NOCOPY VARCHAR2
565: ,ERRBUF OUT NOCOPY VARCHAR2) IS
566: BEGIN
567: /*STPROC.INIT('begin JG_INFO.JG_GET_BUD_OR_ENC_NAME(:ACTUAL_TYPE, :TYPE_ID, :NAME, :ERRBUF); end;');
568: STPROC.BIND_I(ACTUAL_TYPE);
569: STPROC.BIND_I(TYPE_ID);
570: STPROC.BIND_O(NAME);
571: STPROC.BIND_O(ERRBUF);

Line 585: /*STPROC.INIT('begin JG_INFO.JG_GET_LOOKUP_VALUE(:LMODE, :CODE, :TYPE, :VALUE, :ERRBUF); end;');

581: ,TYPE IN VARCHAR2
582: ,VALUE OUT NOCOPY VARCHAR2
583: ,ERRBUF OUT NOCOPY VARCHAR2) IS
584: BEGIN
585: /*STPROC.INIT('begin JG_INFO.JG_GET_LOOKUP_VALUE(:LMODE, :CODE, :TYPE, :VALUE, :ERRBUF); end;');
586: STPROC.BIND_I(LMODE);
587: STPROC.BIND_I(CODE);
588: STPROC.BIND_I(TYPE);
589: STPROC.BIND_O(VALUE);

Line 604: /*STPROC.INIT('begin JG_INFO.JG_GET_FIRST_PERIOD(:APP_ID, :TSET_OF_BOOKS_ID, :TPERIOD_NAME, :TFIRST_PERIOD, :ERRBUF); end;');

600: ,TPERIOD_NAME IN VARCHAR2
601: ,TFIRST_PERIOD OUT NOCOPY VARCHAR2
602: ,ERRBUF OUT NOCOPY VARCHAR2) IS
603: BEGIN
604: /*STPROC.INIT('begin JG_INFO.JG_GET_FIRST_PERIOD(:APP_ID, :TSET_OF_BOOKS_ID, :TPERIOD_NAME, :TFIRST_PERIOD, :ERRBUF); end;');
605: STPROC.BIND_I(APP_ID);
606: STPROC.BIND_I(TSET_OF_BOOKS_ID);
607: STPROC.BIND_I(TPERIOD_NAME);
608: STPROC.BIND_O(TFIRST_PERIOD);

Line 623: /*STPROC.INIT('begin JG_INFO.JG_GET_FIRST_PERIOD_OF_QUARTER(:APP_ID, :TSET_OF_BOOKS_ID, :TPERIOD_NAME, :TFIRST_PERIOD, :ERRBUF); end;');

619: ,TPERIOD_NAME IN VARCHAR2
620: ,TFIRST_PERIOD OUT NOCOPY VARCHAR2
621: ,ERRBUF OUT NOCOPY VARCHAR2) IS
622: BEGIN
623: /*STPROC.INIT('begin JG_INFO.JG_GET_FIRST_PERIOD_OF_QUARTER(:APP_ID, :TSET_OF_BOOKS_ID, :TPERIOD_NAME, :TFIRST_PERIOD, :ERRBUF); end;');
624: STPROC.BIND_I(APP_ID);
625: STPROC.BIND_I(TSET_OF_BOOKS_ID);
626: STPROC.BIND_I(TPERIOD_NAME);
627: STPROC.BIND_O(TFIRST_PERIOD);

Line 640: /*STPROC.INIT('begin :X0 := JG_INFO.JG_FORMAT_CURR_AMT(:IN_PRECISION, :IN_AMOUNT_DISP); end;');

636: FUNCTION JG_FORMAT_CURR_AMT(IN_PRECISION IN NUMBER
637: ,IN_AMOUNT_DISP IN VARCHAR2) RETURN VARCHAR2 IS
638: X0 VARCHAR2(2000);
639: BEGIN
640: /*STPROC.INIT('begin :X0 := JG_INFO.JG_FORMAT_CURR_AMT(:IN_PRECISION, :IN_AMOUNT_DISP); end;');
641: STPROC.BIND_O(X0);
642: STPROC.BIND_I(IN_PRECISION);
643: STPROC.BIND_I(IN_AMOUNT_DISP);
644: STPROC.EXECUTE;