DBA Data[Home] [Help]

APPS.JG_JGZZARIN_XMLP_PKG dependencies on JG_INFO

Line 856: /*STPROC.INIT('begin JG_INFO.JG_GET_PERIOD_DATES(:APP_ID, :TSET_OF_BOOKS_ID, :TPERIOD_NAME, :TSTART_DATE, :TEND_DATE, :ERRBUF); end;');

852: ,TSTART_DATE OUT NOCOPY DATE
853: ,TEND_DATE OUT NOCOPY DATE
854: ,ERRBUF OUT NOCOPY VARCHAR2) IS
855: BEGIN
856: /*STPROC.INIT('begin JG_INFO.JG_GET_PERIOD_DATES(:APP_ID, :TSET_OF_BOOKS_ID, :TPERIOD_NAME, :TSTART_DATE, :TEND_DATE, :ERRBUF); end;');
857: STPROC.BIND_I(APP_ID);
858: STPROC.BIND_I(TSET_OF_BOOKS_ID);
859: STPROC.BIND_I(TPERIOD_NAME);
860: STPROC.BIND_O(TSTART_DATE);

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

875: ,SOBNAME OUT NOCOPY VARCHAR2
876: ,FUNC_CURR OUT NOCOPY VARCHAR2
877: ,ERRBUF OUT NOCOPY VARCHAR2) IS
878: BEGIN
879: /*STPROC.INIT('begin JG_INFO.JG_GET_SET_OF_BOOKS_INFO(:SOBID, :COAID, :SOBNAME, :FUNC_CURR, :ERRBUF); end;');
880: STPROC.BIND_I(SOBID);
881: STPROC.BIND_O(COAID);
882: STPROC.BIND_O(SOBNAME);
883: STPROC.BIND_O(FUNC_CURR);

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

890: STPROC.RETRIEVE(4
891: ,FUNC_CURR);
892: STPROC.RETRIEVE(5
893: ,ERRBUF);*/
894: JG_INFO.JG_GET_SET_OF_BOOKS_INFO(SOBID, COAID, SOBNAME, FUNC_CURR, ERRBUF);
895: END JG_GET_SET_OF_BOOKS_INFO;
896:
897: PROCEDURE JG_GET_BUD_OR_ENC_NAME(ACTUAL_TYPE IN VARCHAR2
898: ,TYPE_ID IN NUMBER

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

898: ,TYPE_ID IN NUMBER
899: ,NAME OUT NOCOPY VARCHAR2
900: ,ERRBUF OUT NOCOPY VARCHAR2) IS
901: BEGIN
902: /*STPROC.INIT('begin JG_INFO.JG_GET_BUD_OR_ENC_NAME(:ACTUAL_TYPE, :TYPE_ID, :NAME, :ERRBUF); end;');
903: STPROC.BIND_I(ACTUAL_TYPE);
904: STPROC.BIND_I(TYPE_ID);
905: STPROC.BIND_O(NAME);
906: STPROC.BIND_O(ERRBUF);

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

908: STPROC.RETRIEVE(3
909: ,NAME);
910: STPROC.RETRIEVE(4
911: ,ERRBUF);*/
912: JG_INFO.JG_GET_BUD_OR_ENC_NAME(ACTUAL_TYPE, TYPE_ID, NAME, ERRBUF);
913: END JG_GET_BUD_OR_ENC_NAME;
914:
915: PROCEDURE JG_GET_LOOKUP_VALUE(LMODE IN VARCHAR2
916: ,CODE IN VARCHAR2

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

917: ,TYPE IN VARCHAR2
918: ,VALUE OUT NOCOPY VARCHAR2
919: ,ERRBUF OUT NOCOPY VARCHAR2) IS
920: BEGIN
921: /*STPROC.INIT('begin JG_INFO.JG_GET_LOOKUP_VALUE(:LMODE, :CODE, :TYPE, :VALUE, :ERRBUF); end;');
922: STPROC.BIND_I(LMODE);
923: STPROC.BIND_I(CODE);
924: STPROC.BIND_I(TYPE);
925: STPROC.BIND_O(VALUE);

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

928: STPROC.RETRIEVE(4
929: ,VALUE);
930: STPROC.RETRIEVE(5
931: ,ERRBUF);*/
932: JG_INFO.JG_GET_LOOKUP_VALUE(LMODE, CODE, TYPE, VALUE, ERRBUF);
933: END JG_GET_LOOKUP_VALUE;
934:
935: PROCEDURE JG_GET_FIRST_PERIOD(APP_ID IN NUMBER
936: ,TSET_OF_BOOKS_ID IN NUMBER

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

937: ,TPERIOD_NAME IN VARCHAR2
938: ,TFIRST_PERIOD OUT NOCOPY VARCHAR2
939: ,ERRBUF OUT NOCOPY VARCHAR2) IS
940: BEGIN
941: /*STPROC.INIT('begin JG_INFO.JG_GET_FIRST_PERIOD(:APP_ID, :TSET_OF_BOOKS_ID, :TPERIOD_NAME, :TFIRST_PERIOD, :ERRBUF); end;');
942: STPROC.BIND_I(APP_ID);
943: STPROC.BIND_I(TSET_OF_BOOKS_ID);
944: STPROC.BIND_I(TPERIOD_NAME);
945: STPROC.BIND_O(TFIRST_PERIOD);

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

948: STPROC.RETRIEVE(4
949: ,TFIRST_PERIOD);
950: STPROC.RETRIEVE(5
951: ,ERRBUF);*/
952: JG_INFO.JG_GET_FIRST_PERIOD(APP_ID, TSET_OF_BOOKS_ID, TPERIOD_NAME, TFIRST_PERIOD, ERRBUF);
953: END JG_GET_FIRST_PERIOD;
954:
955: PROCEDURE JG_GET_FIRST_PERIOD_OF_QUARTER(APP_ID IN NUMBER
956: ,TSET_OF_BOOKS_ID IN NUMBER

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

957: ,TPERIOD_NAME IN VARCHAR2
958: ,TFIRST_PERIOD OUT NOCOPY VARCHAR2
959: ,ERRBUF OUT NOCOPY VARCHAR2) IS
960: BEGIN
961: /*STPROC.INIT('begin JG_INFO.JG_GET_FIRST_PERIOD_OF_QUARTER(:APP_ID, :TSET_OF_BOOKS_ID, :TPERIOD_NAME, :TFIRST_PERIOD, :ERRBUF); end;');
962: STPROC.BIND_I(APP_ID);
963: STPROC.BIND_I(TSET_OF_BOOKS_ID);
964: STPROC.BIND_I(TPERIOD_NAME);
965: STPROC.BIND_O(TFIRST_PERIOD);

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

968: STPROC.RETRIEVE(4
969: ,TFIRST_PERIOD);
970: STPROC.RETRIEVE(5
971: ,ERRBUF);*/
972: JG_INFO.JG_GET_FIRST_PERIOD_OF_QUARTER(APP_ID, TSET_OF_BOOKS_ID, TPERIOD_NAME, TFIRST_PERIOD, ERRBUF);
973: END JG_GET_FIRST_PERIOD_OF_QUARTER;
974:
975: PROCEDURE JG_GET_CONSOLIDATION_INFO(CONS_ID IN NUMBER
976: ,CONS_NAME OUT NOCOPY VARCHAR2

Line 986: /* STPROC.INIT('begin JG_INFO.JG_GET_CONSOLIDATION_INFO(:CONS_ID, :CONS_NAME, :METHOD, :CURR_CODE, :FROM_SOBID, :TO_SOBID, :DESCRIPTION, :START_DATE, :END_DATE, :ERRBUF); end;');

982: ,START_DATE OUT NOCOPY DATE
983: ,END_DATE OUT NOCOPY DATE
984: ,ERRBUF OUT NOCOPY VARCHAR2) IS
985: BEGIN
986: /* STPROC.INIT('begin JG_INFO.JG_GET_CONSOLIDATION_INFO(:CONS_ID, :CONS_NAME, :METHOD, :CURR_CODE, :FROM_SOBID, :TO_SOBID, :DESCRIPTION, :START_DATE, :END_DATE, :ERRBUF); end;');
987: STPROC.BIND_I(CONS_ID);
988: STPROC.BIND_O(CONS_NAME);
989: STPROC.BIND_O(METHOD);
990: STPROC.BIND_O(CURR_CODE);