DBA Data[Home] [Help]

APPS.JE_JEPTARER_XMLP_PKG dependencies on GL_INFO

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

108: ,TSTART_DATE OUT NOCOPY DATE
109: ,TEND_DATE OUT NOCOPY DATE
110: ,ERRBUF OUT NOCOPY VARCHAR2) IS
111: BEGIN
112: /* STPROC.INIT('begin GL_INFO.GL_GET_PERIOD_DATES(:TSET_OF_BOOKS_ID, :TPERIOD_NAME, :TSTART_DATE, :TEND_DATE, :ERRBUF); end;');
113: STPROC.BIND_I(TSET_OF_BOOKS_ID);
114: STPROC.BIND_I(TPERIOD_NAME);
115: STPROC.BIND_O(TSTART_DATE);
116: STPROC.BIND_O(TEND_DATE);

Line 133: /* STPROC.INIT('begin GL_INFO.GL_GET_LEDGER_INFO(:SOBID, :COAID, :SOBNAME, :FUNC_CURR, :ERRBUF); end;');

129: ,SOBNAME OUT NOCOPY VARCHAR2
130: ,FUNC_CURR OUT NOCOPY VARCHAR2
131: ,ERRBUF OUT NOCOPY VARCHAR2) IS
132: BEGIN
133: /* STPROC.INIT('begin GL_INFO.GL_GET_LEDGER_INFO(:SOBID, :COAID, :SOBNAME, :FUNC_CURR, :ERRBUF); end;');
134: STPROC.BIND_I(SOBID);
135: STPROC.BIND_O(COAID);
136: STPROC.BIND_O(SOBNAME);
137: STPROC.BIND_O(FUNC_CURR);

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

144: STPROC.RETRIEVE(4
145: ,FUNC_CURR);
146: STPROC.RETRIEVE(5
147: ,ERRBUF);*/
148: GL_INFO.GL_GET_LEDGER_INFO(SOBID,COAID,SOBNAME,FUNC_CURR,ERRBUF);
149: END GL_GET_LEDGER_INFO;
150:
151: PROCEDURE GL_GET_BUD_OR_ENC_NAME(ACTUAL_TYPE IN VARCHAR2
152: ,TYPE_ID IN NUMBER

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

152: ,TYPE_ID IN NUMBER
153: ,NAME OUT NOCOPY VARCHAR2
154: ,ERRBUF OUT NOCOPY VARCHAR2) IS
155: BEGIN
156: /* STPROC.INIT('begin GL_INFO.GL_GET_BUD_OR_ENC_NAME(:ACTUAL_TYPE, :TYPE_ID, :NAME, :ERRBUF); end;');
157: STPROC.BIND_I(ACTUAL_TYPE);
158: STPROC.BIND_I(TYPE_ID);
159: STPROC.BIND_O(NAME);
160: STPROC.BIND_O(ERRBUF);

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

170: ,TYPE IN VARCHAR2
171: ,VALUE OUT NOCOPY VARCHAR2
172: ,ERRBUF OUT NOCOPY VARCHAR2) IS
173: BEGIN
174: /* STPROC.INIT('begin GL_INFO.GL_GET_LOOKUP_VALUE(:LMODE, :CODE, :TYPE, :VALUE, :ERRBUF); end;');
175: STPROC.BIND_I(LMODE);
176: STPROC.BIND_I(CODE);
177: STPROC.BIND_I(TYPE);
178: STPROC.BIND_O(VALUE);

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

188: ,TPERIOD_NAME IN VARCHAR2
189: ,TFIRST_PERIOD OUT NOCOPY VARCHAR2
190: ,ERRBUF OUT NOCOPY VARCHAR2) IS
191: BEGIN
192: /* STPROC.INIT('begin GL_INFO.GL_GET_FIRST_PERIOD(:TSET_OF_BOOKS_ID, :TPERIOD_NAME, :TFIRST_PERIOD, :ERRBUF); end;');
193: STPROC.BIND_I(TSET_OF_BOOKS_ID);
194: STPROC.BIND_I(TPERIOD_NAME);
195: STPROC.BIND_O(TFIRST_PERIOD);
196: STPROC.BIND_O(ERRBUF);

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

205: ,TPERIOD_NAME IN VARCHAR2
206: ,TFIRST_PERIOD OUT NOCOPY VARCHAR2
207: ,ERRBUF OUT NOCOPY VARCHAR2) IS
208: BEGIN
209: /* STPROC.INIT('begin GL_INFO.GL_GET_FIRST_PERIOD_OF_QUARTER(:TSET_OF_BOOKS_ID, :TPERIOD_NAME, :TFIRST_PERIOD, :ERRBUF); end;');
210: STPROC.BIND_I(TSET_OF_BOOKS_ID);
211: STPROC.BIND_I(TPERIOD_NAME);
212: STPROC.BIND_O(TFIRST_PERIOD);
213: STPROC.BIND_O(ERRBUF);

Line 232: /* 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;');

228: ,START_DATE OUT NOCOPY DATE
229: ,END_DATE OUT NOCOPY DATE
230: ,ERRBUF OUT NOCOPY VARCHAR2) IS
231: BEGIN
232: /* 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;');
233: STPROC.BIND_I(CONS_ID);
234: STPROC.BIND_O(CONS_NAME);
235: STPROC.BIND_O(METHOD);
236: STPROC.BIND_O(CURR_CODE);