DBA Data[Home] [Help]

APPS.GL_GLXRLTCL_XMLP_PKG dependencies on GL_INFO

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

95: ,TSTART_DATE OUT NOCOPY DATE
96: ,TEND_DATE OUT NOCOPY DATE
97: ,ERRBUF OUT NOCOPY VARCHAR2) IS
98: BEGIN
99: /* STPROC.INIT('begin GL_INFO.GL_GET_PERIOD_DATES(:TSET_OF_BOOKS_ID, :TPERIOD_NAME, :TSTART_DATE, :TEND_DATE, :ERRBUF); end;');
100: STPROC.BIND_I(TSET_OF_BOOKS_ID);
101: STPROC.BIND_I(TPERIOD_NAME);
102: STPROC.BIND_O(TSTART_DATE);
103: STPROC.BIND_O(TEND_DATE);

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

116: ,SOBNAME OUT NOCOPY VARCHAR2
117: ,FUNC_CURR OUT NOCOPY VARCHAR2
118: ,ERRBUF OUT NOCOPY VARCHAR2) IS
119: BEGIN
120: /* STPROC.INIT('begin GL_INFO.GL_GET_LEDGER_INFO(:SOBID, :COAID, :SOBNAME, :FUNC_CURR, :ERRBUF); end;');
121: STPROC.BIND_I(SOBID);
122: STPROC.BIND_O(COAID);
123: STPROC.BIND_O(SOBNAME);
124: STPROC.BIND_O(FUNC_CURR);

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

132: ,FUNC_CURR);
133: STPROC.RETRIEVE(5
134: ,ERRBUF);*/
135:
136: GL_INFO.GL_GET_LEDGER_INFO(SOBID,COAID,SOBNAME,FUNC_CURR,ERRBUF);
137: END GL_GET_LEDGER_INFO;
138:
139: PROCEDURE GL_GET_BUD_OR_ENC_NAME(ACTUAL_TYPE IN VARCHAR2
140: ,TYPE_ID IN NUMBER

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

140: ,TYPE_ID IN NUMBER
141: ,NAME OUT NOCOPY VARCHAR2
142: ,ERRBUF OUT NOCOPY VARCHAR2) IS
143: BEGIN
144: /* STPROC.INIT('begin GL_INFO.GL_GET_BUD_OR_ENC_NAME(:ACTUAL_TYPE, :TYPE_ID, :NAME, :ERRBUF); end;');
145: STPROC.BIND_I(ACTUAL_TYPE);
146: STPROC.BIND_I(TYPE_ID);
147: STPROC.BIND_O(NAME);
148: STPROC.BIND_O(ERRBUF);

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

158: ,TYPE IN VARCHAR2
159: ,VALUE OUT NOCOPY VARCHAR2
160: ,ERRBUF OUT NOCOPY VARCHAR2) IS
161: BEGIN
162: /* STPROC.INIT('begin GL_INFO.GL_GET_LOOKUP_VALUE(:LMODE, :CODE, :TYPE, :VALUE, :ERRBUF); end;');
163: STPROC.BIND_I(LMODE);
164: STPROC.BIND_I(CODE);
165: STPROC.BIND_I(TYPE);
166: STPROC.BIND_O(VALUE);

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

176: ,TPERIOD_NAME IN VARCHAR2
177: ,TFIRST_PERIOD OUT NOCOPY VARCHAR2
178: ,ERRBUF OUT NOCOPY VARCHAR2) IS
179: BEGIN
180: /* STPROC.INIT('begin GL_INFO.GL_GET_FIRST_PERIOD(:TSET_OF_BOOKS_ID, :TPERIOD_NAME, :TFIRST_PERIOD, :ERRBUF); end;');
181: STPROC.BIND_I(TSET_OF_BOOKS_ID);
182: STPROC.BIND_I(TPERIOD_NAME);
183: STPROC.BIND_O(TFIRST_PERIOD);
184: STPROC.BIND_O(ERRBUF);

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

193: ,TPERIOD_NAME IN VARCHAR2
194: ,TFIRST_PERIOD OUT NOCOPY VARCHAR2
195: ,ERRBUF OUT NOCOPY VARCHAR2) IS
196: BEGIN
197: /* STPROC.INIT('begin GL_INFO.GL_GET_FIRST_PERIOD_OF_QUARTER(:TSET_OF_BOOKS_ID, :TPERIOD_NAME, :TFIRST_PERIOD, :ERRBUF); end;');
198: STPROC.BIND_I(TSET_OF_BOOKS_ID);
199: STPROC.BIND_I(TPERIOD_NAME);
200: STPROC.BIND_O(TFIRST_PERIOD);
201: STPROC.BIND_O(ERRBUF);

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

216: ,START_DATE OUT NOCOPY DATE
217: ,END_DATE OUT NOCOPY DATE
218: ,ERRBUF OUT NOCOPY VARCHAR2) IS
219: BEGIN
220: /* 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;');
221: STPROC.BIND_I(CONS_ID);
222: STPROC.BIND_O(CONS_NAME);
223: STPROC.BIND_O(METHOD);
224: STPROC.BIND_O(CURR_CODE);