DBA Data[Home] [Help]

APPS.JG_JGZZRCAK_XMLP_PKG dependencies on JG_INFO

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

817: ,SOBNAME OUT NOCOPY VARCHAR2
818: ,FUNC_CURR OUT NOCOPY VARCHAR2
819: ,ERRBUF OUT NOCOPY VARCHAR2) IS
820: BEGIN
821: JG_INFO.JG_GET_SET_OF_BOOKS_INFO(SOBID, COAID, SOBNAME, FUNC_CURR, ERRBUF);
822: /*STPROC.INIT('begin JG_INFO.JG_GET_SET_OF_BOOKS_INFO(:SOBID, :COAID, :SOBNAME, :FUNC_CURR, :ERRBUF); end;');
823: STPROC.BIND_I(SOBID);
824: STPROC.BIND_O(COAID);
825: STPROC.BIND_O(SOBNAME);

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

818: ,FUNC_CURR OUT NOCOPY VARCHAR2
819: ,ERRBUF OUT NOCOPY VARCHAR2) IS
820: BEGIN
821: JG_INFO.JG_GET_SET_OF_BOOKS_INFO(SOBID, COAID, SOBNAME, FUNC_CURR, ERRBUF);
822: /*STPROC.INIT('begin JG_INFO.JG_GET_SET_OF_BOOKS_INFO(:SOBID, :COAID, :SOBNAME, :FUNC_CURR, :ERRBUF); end;');
823: STPROC.BIND_I(SOBID);
824: STPROC.BIND_O(COAID);
825: STPROC.BIND_O(SOBNAME);
826: STPROC.BIND_O(FUNC_CURR);

Line 844: JG_INFO.JG_GET_BUD_OR_ENC_NAME(ACTUAL_TYPE, TYPE_ID, NAME, ERRBUF);

840: ,TYPE_ID IN NUMBER
841: ,NAME OUT NOCOPY VARCHAR2
842: ,ERRBUF OUT NOCOPY VARCHAR2) IS
843: BEGIN
844: JG_INFO.JG_GET_BUD_OR_ENC_NAME(ACTUAL_TYPE, TYPE_ID, NAME, ERRBUF);
845: /*STPROC.INIT('begin JG_INFO.JG_GET_BUD_OR_ENC_NAME(:ACTUAL_TYPE, :TYPE_ID, :NAME, :ERRBUF); end;');
846: STPROC.BIND_I(ACTUAL_TYPE);
847: STPROC.BIND_I(TYPE_ID);
848: STPROC.BIND_O(NAME);

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

841: ,NAME OUT NOCOPY VARCHAR2
842: ,ERRBUF OUT NOCOPY VARCHAR2) IS
843: BEGIN
844: JG_INFO.JG_GET_BUD_OR_ENC_NAME(ACTUAL_TYPE, TYPE_ID, NAME, ERRBUF);
845: /*STPROC.INIT('begin JG_INFO.JG_GET_BUD_OR_ENC_NAME(:ACTUAL_TYPE, :TYPE_ID, :NAME, :ERRBUF); end;');
846: STPROC.BIND_I(ACTUAL_TYPE);
847: STPROC.BIND_I(TYPE_ID);
848: STPROC.BIND_O(NAME);
849: STPROC.BIND_O(ERRBUF);

Line 863: JG_INFO.JG_GET_LOOKUP_VALUE(LMODE, CODE, TYPE, VALUE, ERRBUF);

859: ,TYPE IN VARCHAR2
860: ,VALUE OUT NOCOPY VARCHAR2
861: ,ERRBUF OUT NOCOPY VARCHAR2) IS
862: BEGIN
863: JG_INFO.JG_GET_LOOKUP_VALUE(LMODE, CODE, TYPE, VALUE, ERRBUF);
864: /* STPROC.INIT('begin JG_INFO.JG_GET_LOOKUP_VALUE(:LMODE, :CODE, :TYPE, :VALUE, :ERRBUF); end;');
865: STPROC.BIND_I(LMODE);
866: STPROC.BIND_I(CODE);
867: STPROC.BIND_I(TYPE);

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

860: ,VALUE OUT NOCOPY VARCHAR2
861: ,ERRBUF OUT NOCOPY VARCHAR2) IS
862: BEGIN
863: JG_INFO.JG_GET_LOOKUP_VALUE(LMODE, CODE, TYPE, VALUE, ERRBUF);
864: /* STPROC.INIT('begin JG_INFO.JG_GET_LOOKUP_VALUE(:LMODE, :CODE, :TYPE, :VALUE, :ERRBUF); end;');
865: STPROC.BIND_I(LMODE);
866: STPROC.BIND_I(CODE);
867: STPROC.BIND_I(TYPE);
868: STPROC.BIND_O(VALUE);

Line 883: JG_INFO.JG_GET_FIRST_PERIOD(APP_ID, TSET_OF_BOOKS_ID, TPERIOD_NAME, TFIRST_PERIOD, ERRBUF);

879: ,TPERIOD_NAME IN VARCHAR2
880: ,TFIRST_PERIOD OUT NOCOPY VARCHAR2
881: ,ERRBUF OUT NOCOPY VARCHAR2) IS
882: BEGIN
883: JG_INFO.JG_GET_FIRST_PERIOD(APP_ID, TSET_OF_BOOKS_ID, TPERIOD_NAME, TFIRST_PERIOD, ERRBUF);
884: /*STPROC.INIT('begin JG_INFO.JG_GET_FIRST_PERIOD(:APP_ID, :TSET_OF_BOOKS_ID, :TPERIOD_NAME, :TFIRST_PERIOD, :ERRBUF); end;');
885: STPROC.BIND_I(APP_ID);
886: STPROC.BIND_I(TSET_OF_BOOKS_ID);
887: STPROC.BIND_I(TPERIOD_NAME);

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

880: ,TFIRST_PERIOD OUT NOCOPY VARCHAR2
881: ,ERRBUF OUT NOCOPY VARCHAR2) IS
882: BEGIN
883: JG_INFO.JG_GET_FIRST_PERIOD(APP_ID, TSET_OF_BOOKS_ID, TPERIOD_NAME, TFIRST_PERIOD, ERRBUF);
884: /*STPROC.INIT('begin JG_INFO.JG_GET_FIRST_PERIOD(:APP_ID, :TSET_OF_BOOKS_ID, :TPERIOD_NAME, :TFIRST_PERIOD, :ERRBUF); end;');
885: STPROC.BIND_I(APP_ID);
886: STPROC.BIND_I(TSET_OF_BOOKS_ID);
887: STPROC.BIND_I(TPERIOD_NAME);
888: STPROC.BIND_O(TFIRST_PERIOD);

Line 903: JG_INFO.JG_GET_FIRST_PERIOD_OF_QUARTER(APP_ID, TSET_OF_BOOKS_ID, TPERIOD_NAME, TFIRST_PERIOD, ERRBUF);

899: ,TPERIOD_NAME IN VARCHAR2
900: ,TFIRST_PERIOD OUT NOCOPY VARCHAR2
901: ,ERRBUF OUT NOCOPY VARCHAR2) IS
902: BEGIN
903: JG_INFO.JG_GET_FIRST_PERIOD_OF_QUARTER(APP_ID, TSET_OF_BOOKS_ID, TPERIOD_NAME, TFIRST_PERIOD, ERRBUF);
904: /*STPROC.INIT('begin JG_INFO.JG_GET_FIRST_PERIOD_OF_QUARTER(:APP_ID, :TSET_OF_BOOKS_ID, :TPERIOD_NAME, :TFIRST_PERIOD, :ERRBUF); end;');
905: STPROC.BIND_I(APP_ID);
906: STPROC.BIND_I(TSET_OF_BOOKS_ID);
907: STPROC.BIND_I(TPERIOD_NAME);

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

900: ,TFIRST_PERIOD OUT NOCOPY VARCHAR2
901: ,ERRBUF OUT NOCOPY VARCHAR2) IS
902: BEGIN
903: JG_INFO.JG_GET_FIRST_PERIOD_OF_QUARTER(APP_ID, TSET_OF_BOOKS_ID, TPERIOD_NAME, TFIRST_PERIOD, ERRBUF);
904: /*STPROC.INIT('begin JG_INFO.JG_GET_FIRST_PERIOD_OF_QUARTER(:APP_ID, :TSET_OF_BOOKS_ID, :TPERIOD_NAME, :TFIRST_PERIOD, :ERRBUF); end;');
905: STPROC.BIND_I(APP_ID);
906: STPROC.BIND_I(TSET_OF_BOOKS_ID);
907: STPROC.BIND_I(TPERIOD_NAME);
908: STPROC.BIND_O(TFIRST_PERIOD);

Line 921: X0 := JG_INFO.JG_FORMAT_CURR_AMT(IN_PRECISION, IN_AMOUNT_DISP);

917: FUNCTION JG_FORMAT_CURR_AMT(IN_PRECISION IN NUMBER
918: ,IN_AMOUNT_DISP IN VARCHAR2) RETURN VARCHAR2 IS
919: X0 VARCHAR2(2000);
920: BEGIN
921: X0 := JG_INFO.JG_FORMAT_CURR_AMT(IN_PRECISION, IN_AMOUNT_DISP);
922: /*STPROC.INIT('begin :X0 := JG_INFO.JG_FORMAT_CURR_AMT(:IN_PRECISION, :IN_AMOUNT_DISP); end;');
923: STPROC.BIND_O(X0);
924: STPROC.BIND_I(IN_PRECISION);
925: STPROC.BIND_I(IN_AMOUNT_DISP);

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

918: ,IN_AMOUNT_DISP IN VARCHAR2) RETURN VARCHAR2 IS
919: X0 VARCHAR2(2000);
920: BEGIN
921: X0 := JG_INFO.JG_FORMAT_CURR_AMT(IN_PRECISION, IN_AMOUNT_DISP);
922: /*STPROC.INIT('begin :X0 := JG_INFO.JG_FORMAT_CURR_AMT(:IN_PRECISION, :IN_AMOUNT_DISP); end;');
923: STPROC.BIND_O(X0);
924: STPROC.BIND_I(IN_PRECISION);
925: STPROC.BIND_I(IN_AMOUNT_DISP);
926: STPROC.EXECUTE;