DBA Data[Home] [Help]

APPS.JE_JEPTAPER_XMLP_PKG dependencies on GL_INFO

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

120: ,TSTART_DATE OUT NOCOPY DATE
121: ,TEND_DATE OUT NOCOPY DATE
122: ,ERRBUF OUT NOCOPY VARCHAR2) IS
123: BEGIN
124: /* STPROC.INIT('begin GL_INFO.GL_GET_PERIOD_DATES(:TSET_OF_BOOKS_ID, :TPERIOD_NAME, :TSTART_DATE, :TEND_DATE, :ERRBUF); end;');
125: STPROC.BIND_I(TSET_OF_BOOKS_ID);
126: STPROC.BIND_I(TPERIOD_NAME);
127: STPROC.BIND_O(TSTART_DATE);
128: STPROC.BIND_O(TEND_DATE);

Line 137: GL_INFO.GL_GET_PERIOD_DATES(TSET_OF_BOOKS_ID,TPERIOD_NAME,TSTART_DATE,TEND_DATE,ERRBUF);

133: STPROC.RETRIEVE(4
134: ,TEND_DATE);
135: STPROC.RETRIEVE(5
136: ,ERRBUF);*/
137: GL_INFO.GL_GET_PERIOD_DATES(TSET_OF_BOOKS_ID,TPERIOD_NAME,TSTART_DATE,TEND_DATE,ERRBUF);
138: END GL_GET_PERIOD_DATES;
139:
140: PROCEDURE GL_GET_LEDGER_INFO(SOBID IN NUMBER
141: ,COAID OUT NOCOPY NUMBER

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

142: ,SOBNAME OUT NOCOPY VARCHAR2
143: ,FUNC_CURR OUT NOCOPY VARCHAR2
144: ,ERRBUF OUT NOCOPY VARCHAR2) IS
145: BEGIN
146: /* STPROC.INIT('begin GL_INFO.GL_GET_LEDGER_INFO(:SOBID, :COAID, :SOBNAME, :FUNC_CURR, :ERRBUF); end;');
147: STPROC.BIND_I(SOBID);
148: STPROC.BIND_O(COAID);
149: STPROC.BIND_O(SOBNAME);
150: STPROC.BIND_O(FUNC_CURR);

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

157: STPROC.RETRIEVE(4
158: ,FUNC_CURR);
159: STPROC.RETRIEVE(5
160: ,ERRBUF);*/
161: GL_INFO.GL_GET_LEDGER_INFO(SOBID,COAID,SOBNAME,FUNC_CURR,ERRBUF);
162: END GL_GET_LEDGER_INFO;
163:
164: PROCEDURE GL_GET_BUD_OR_ENC_NAME(ACTUAL_TYPE IN VARCHAR2
165: ,TYPE_ID IN NUMBER

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

165: ,TYPE_ID IN NUMBER
166: ,NAME OUT NOCOPY VARCHAR2
167: ,ERRBUF OUT NOCOPY VARCHAR2) IS
168: BEGIN
169: /* STPROC.INIT('begin GL_INFO.GL_GET_BUD_OR_ENC_NAME(:ACTUAL_TYPE, :TYPE_ID, :NAME, :ERRBUF); end;');
170: STPROC.BIND_I(ACTUAL_TYPE);
171: STPROC.BIND_I(TYPE_ID);
172: STPROC.BIND_O(NAME);
173: STPROC.BIND_O(ERRBUF);

Line 179: GL_INFO.GL_GET_BUD_OR_ENC_NAME(ACTUAL_TYPE,TYPE_ID,NAME,ERRBUF);

175: STPROC.RETRIEVE(3
176: ,NAME);
177: STPROC.RETRIEVE(4
178: ,ERRBUF);*/
179: GL_INFO.GL_GET_BUD_OR_ENC_NAME(ACTUAL_TYPE,TYPE_ID,NAME,ERRBUF);
180: END GL_GET_BUD_OR_ENC_NAME;
181:
182: PROCEDURE GL_GET_LOOKUP_VALUE(LMODE IN VARCHAR2
183: ,CODE IN VARCHAR2

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

184: ,TYPE IN VARCHAR2
185: ,VALUE OUT NOCOPY VARCHAR2
186: ,ERRBUF OUT NOCOPY VARCHAR2) IS
187: BEGIN
188: /* STPROC.INIT('begin GL_INFO.GL_GET_LOOKUP_VALUE(:LMODE, :CODE, :TYPE, :VALUE, :ERRBUF); end;');
189: STPROC.BIND_I(LMODE);
190: STPROC.BIND_I(CODE);
191: STPROC.BIND_I(TYPE);
192: STPROC.BIND_O(VALUE);

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

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

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

219: ,TPERIOD_NAME IN VARCHAR2
220: ,TFIRST_PERIOD OUT NOCOPY VARCHAR2
221: ,ERRBUF OUT NOCOPY VARCHAR2) IS
222: BEGIN
223: /* STPROC.INIT('begin GL_INFO.GL_GET_FIRST_PERIOD_OF_QUARTER(:TSET_OF_BOOKS_ID, :TPERIOD_NAME, :TFIRST_PERIOD, :ERRBUF); end;');
224: STPROC.BIND_I(TSET_OF_BOOKS_ID);
225: STPROC.BIND_I(TPERIOD_NAME);
226: STPROC.BIND_O(TFIRST_PERIOD);
227: STPROC.BIND_O(ERRBUF);

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

242: ,START_DATE OUT NOCOPY DATE
243: ,END_DATE OUT NOCOPY DATE
244: ,ERRBUF OUT NOCOPY VARCHAR2) IS
245: BEGIN
246: /* 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;');
247: STPROC.BIND_I(CONS_ID);
248: STPROC.BIND_O(CONS_NAME);
249: STPROC.BIND_O(METHOD);
250: STPROC.BIND_O(CURR_CODE);