DBA Data[Home] [Help]

APPS.EPS dependencies on EPS

Line 1: PACKAGE BODY EPS AS

1: PACKAGE BODY EPS AS
2: /* $Header: epsuserb.pls 115.2 2002/11/08 19:08:18 dkang ship $ */
3: --
4: -- Get error text
5: --

Line 2: /* $Header: epsuserb.pls 115.2 2002/11/08 19:08:18 dkang ship $ */

1: PACKAGE BODY EPS AS
2: /* $Header: epsuserb.pls 115.2 2002/11/08 19:08:18 dkang ship $ */
3: --
4: -- Get error text
5: --
6: FUNCTION getErrorMsg(status NUMBER)

Line 31: qry9 VARCHAR2) RETURN EPS_express_list_t AS

27: qry5 VARCHAR2,
28: qry6 VARCHAR2,
29: qry7 VARCHAR2,
30: qry8 VARCHAR2,
31: qry9 VARCHAR2) RETURN EPS_express_list_t AS
32: report_id NUMBER := 0;
33: t EPS_express_list_t := EPS_express_list_t();
34: i NUMBER := 1;
35: status NUMBER := 0;

Line 33: t EPS_express_list_t := EPS_express_list_t();

29: qry7 VARCHAR2,
30: qry8 VARCHAR2,
31: qry9 VARCHAR2) RETURN EPS_express_list_t AS
32: report_id NUMBER := 0;
33: t EPS_express_list_t := EPS_express_list_t();
34: i NUMBER := 1;
35: status NUMBER := 0;
36: map VARCHAR2(100) := '';
37: buffer VARCHAR2(4000) := '';

Line 44: SELECT EPS_report_id.NEXTVAL

40: BEGIN
41: --
42: -- Generate a unique id for the query
43: --
44: SELECT EPS_report_id.NEXTVAL
45: INTO report_id
46: FROM DUAL;
47:
48: --

Line 68: obj EPS_express_t := EPS_express_t(NULL,NULL,NULL,NULL,NULL,

64: --
65: DECLARE
66: buffer_size NUMBER := 4000;
67: buffer_ptr NUMBER := 0;
68: obj EPS_express_t := EPS_express_t(NULL,NULL,NULL,NULL,NULL,
69: NULL,NULL,NULL,NULL,NULL,
70: NULL,NULL,NULL,NULL,NULL,
71: NULL,NULL,NULL,NULL,NULL,
72: NULL,NULL,NULL,NULL,NULL,

Line 144: LIBRARY EPS_lib

140: in_express_server IN VARCHAR2,
141: in_qry IN VARCHAR2)
142: RETURN NATURAL AS
143: EXTERNAL
144: LIBRARY EPS_lib
145: NAME "XPPrepare"
146: LANGUAGE C
147: WITH CONTEXT;
148:

Line 197: LIBRARY EPS_lib

193: c38 IN OUT NOCOPY VARCHAR2,
194: c39 IN OUT NOCOPY VARCHAR2)
195: RETURN NATURAL AS
196: EXTERNAL
197: LIBRARY EPS_lib
198: NAME "XPFetch"
199: LANGUAGE C
200: WITH CONTEXT;
201:

Line 214: LIBRARY EPS_lib

210: num_cols OUT NOCOPY NATURAL,
211: num_rows OUT NOCOPY NATURAL)
212: RETURN NATURAL AS
213: EXTERNAL
214: LIBRARY EPS_lib
215: NAME "XPFetchN"
216: LANGUAGE C
217: WITH CONTEXT;
218:

Line 221: -- OCI Callout - xrbGetMessage - Get EPS error message

217: WITH CONTEXT;
218:
219:
220: --
221: -- OCI Callout - xrbGetMessage - Get EPS error message
222: --
223: FUNCTION xrbGetMessage(msgno IN NATURAL,
224: buffer IN OUT NOCOPY VARCHAR2,
225: bufsize IN NATURAL)

Line 228: LIBRARY EPS_lib

224: buffer IN OUT NOCOPY VARCHAR2,
225: bufsize IN NATURAL)
226: RETURN NATURAL AS
227: EXTERNAL
228: LIBRARY EPS_lib
229: NAME "xrbGetMessage"
230: LANGUAGE C ;
231:
232:

Line 239: RETURN EPS_express_t IS

235: buffer_size IN NUMBER,
236: buffer_ptr IN OUT NOCOPY NUMBER,
237: ncols IN NUMBER,
238: nrows IN NUMBER)
239: RETURN EPS_express_t IS
240: t EPS_express_t := EPS_express_t(NULL,NULL,NULL,NULL,NULL,
241: NULL,NULL,NULL,NULL,NULL,
242: NULL,NULL,NULL,NULL,NULL,
243: NULL,NULL,NULL,NULL,NULL,

Line 240: t EPS_express_t := EPS_express_t(NULL,NULL,NULL,NULL,NULL,

236: buffer_ptr IN OUT NOCOPY NUMBER,
237: ncols IN NUMBER,
238: nrows IN NUMBER)
239: RETURN EPS_express_t IS
240: t EPS_express_t := EPS_express_t(NULL,NULL,NULL,NULL,NULL,
241: NULL,NULL,NULL,NULL,NULL,
242: NULL,NULL,NULL,NULL,NULL,
243: NULL,NULL,NULL,NULL,NULL,
244: NULL,NULL,NULL,NULL,NULL,

Line 430: END EPS;

426:
427: RETURN buffer_ptr_new;
428: END;
429:
430: END EPS;