[Home] [Help]
PACKAGE: APPS.EPS
Source
1 PACKAGE EPS AUTHID CURRENT_USER AS
2 /* $Header: epsusers.pls 115.2 2002/11/08 19:08:01 dkang ship $ */
3
4 --
5 -- Create the Generic object an a list type
6 --
7 /*
8 TYPE EPS_express_t IS RECORD (c0 VARCHAR2(2000),
9 c1 VARCHAR2(2000),
10 c2 VARCHAR2(2000),
11 c3 VARCHAR2(2000),
12 c4 VARCHAR2(2000),
13 c5 VARCHAR2(2000),
14 c6 VARCHAR2(2000),
15 c7 VARCHAR2(2000),
16 c8 VARCHAR2(2000),
17 c9 VARCHAR2(2000),
18 c10 VARCHAR2(2000),
19 c11 VARCHAR2(2000),
20 c12 VARCHAR2(2000),
21 c13 VARCHAR2(2000),
22 c14 VARCHAR2(2000),
23 c15 VARCHAR2(2000),
24 c16 VARCHAR2(2000),
25 c17 VARCHAR2(2000),
26 c18 VARCHAR2(2000),
27 c19 VARCHAR2(2000),
28 c20 VARCHAR2(2000),
29 c21 VARCHAR2(2000),
30 c22 VARCHAR2(2000),
31 c23 VARCHAR2(2000),
32 c24 VARCHAR2(2000),
33 c25 VARCHAR2(2000),
34 c26 VARCHAR2(2000),
35 c27 VARCHAR2(2000),
36 c28 VARCHAR2(2000),
37 c29 VARCHAR2(2000),
38 c30 VARCHAR2(2000),
39 c31 VARCHAR2(2000),
40 c32 VARCHAR2(2000),
41 c33 VARCHAR2(2000),
42 c34 VARCHAR2(2000),
43 c35 VARCHAR2(2000),
44 c36 VARCHAR2(2000),
45 c37 VARCHAR2(2000),
46 c38 VARCHAR2(2000),
47 c39 VARCHAR2(2000));
48
49 TYPE EPS_express_list_t IS TABLE OF EPS_express_t;
50 */
51 --
52 -- Query express
53 --
54 -- Note: PL/SQL functions embedded in a SQL statement cannot update the database.
55 --
56 FUNCTION query (express_server VARCHAR2,
57 qry0 VARCHAR2,
58 qry1 VARCHAR2,
59 qry2 VARCHAR2,
60 qry3 VARCHAR2,
61 qry4 VARCHAR2,
62 qry5 VARCHAR2,
63 qry6 VARCHAR2,
64 qry7 VARCHAR2,
65 qry8 VARCHAR2,
66 qry9 VARCHAR2)
67 RETURN EPS_express_list_t;
68 PRAGMA RESTRICT_REFERENCES (query, WNDS, WNPS);
69
70
71 --
72 -- Returns an error string for an Express DLL callout failure code
73 --
74
75 FUNCTION getErrorMsg(status NUMBER)
76 RETURN VARCHAR2 ;
77 PRAGMA RESTRICT_REFERENCES (getErrorMsg, WNDS, WNPS);
78
79
80
81 --
82 -- Express DLL callout functions
83 --
84 --
85 -- OCI Callout - XPPrepare - Prepare an Express Query
86 --
87 -- Return 0 SUCCESS 1 FAIL
88 --
89 FUNCTION XPPrepare(in_report_id IN NATURAL,
90 in_express_server IN VARCHAR2,
91 in_qry IN VARCHAR2)
92 RETURN NATURAL;
93 PRAGMA RESTRICT_REFERENCES (XPPrepare, WNDS, WNPS);
94
95 --
96 -- OCI Callout - XPFetch - Fetch a row from an Express Query
97 --
98 -- Return 0 SUCCESS 1 FAIL
99 --
100 -- Raises exception 1403 (No data found) when called after last
101 -- row fetched or if first fetch returns no data.
102 --
103 FUNCTION XPFetch(in_report_id NATURAL,
104 c0 IN OUT NOCOPY VARCHAR2,
105 c1 IN OUT NOCOPY VARCHAR2,
106 c2 IN OUT NOCOPY VARCHAR2,
107 c3 IN OUT NOCOPY VARCHAR2,
108 c4 IN OUT NOCOPY VARCHAR2,
109 c5 IN OUT NOCOPY VARCHAR2,
110 c6 IN OUT NOCOPY VARCHAR2,
111 c7 IN OUT NOCOPY VARCHAR2,
112 c8 IN OUT NOCOPY VARCHAR2,
113 c9 IN OUT NOCOPY VARCHAR2,
114 c10 IN OUT NOCOPY VARCHAR2,
115 c11 IN OUT NOCOPY VARCHAR2,
116 c12 IN OUT NOCOPY VARCHAR2,
117 c13 IN OUT NOCOPY VARCHAR2,
118 c14 IN OUT NOCOPY VARCHAR2,
119 c15 IN OUT NOCOPY VARCHAR2,
120 c16 IN OUT NOCOPY VARCHAR2,
121 c17 IN OUT NOCOPY VARCHAR2,
122 c18 IN OUT NOCOPY VARCHAR2,
123 c19 IN OUT NOCOPY VARCHAR2,
124 c20 IN OUT NOCOPY VARCHAR2,
125 c21 IN OUT NOCOPY VARCHAR2,
126 c22 IN OUT NOCOPY VARCHAR2,
127 c23 IN OUT NOCOPY VARCHAR2,
128 c24 IN OUT NOCOPY VARCHAR2,
129 c25 IN OUT NOCOPY VARCHAR2,
130 c26 IN OUT NOCOPY VARCHAR2,
131 c27 IN OUT NOCOPY VARCHAR2,
132 c28 IN OUT NOCOPY VARCHAR2,
133 c29 IN OUT NOCOPY VARCHAR2,
134 c30 IN OUT NOCOPY VARCHAR2,
135 c31 IN OUT NOCOPY VARCHAR2,
136 c32 IN OUT NOCOPY VARCHAR2,
137 c33 IN OUT NOCOPY VARCHAR2,
138 c34 IN OUT NOCOPY VARCHAR2,
139 c35 IN OUT NOCOPY VARCHAR2,
140 c36 IN OUT NOCOPY VARCHAR2,
141 c37 IN OUT NOCOPY VARCHAR2,
142 c38 IN OUT NOCOPY VARCHAR2,
143 c39 IN OUT NOCOPY VARCHAR2)
144 RETURN NATURAL;
145 PRAGMA RESTRICT_REFERENCES (XPFetch, WNDS, WNPS);
146
147
148 --
149 -- OCI Callout - XPFetchN - Fetch multiple rows from an Express Query
150 --
151 -- Return 0 SUCCESS 1 FAIL
152 --
153 -- Raises exception 1403 (No data found) when called after last
154 -- row fetched or if first fetch returns no data.
155 --
156 FUNCTION XPFetchN(in_report_id NATURAL,
157 buffer_size NATURAL,
158 buffer IN OUT NOCOPY VARCHAR2,
159 num_cols OUT NOCOPY NATURAL,
160 num_rows OUT NOCOPY NATURAL)
161 RETURN NATURAL;
162 PRAGMA RESTRICT_REFERENCES (XPFetchN, WNDS, WNPS);
163
164
165 --
166 -- OCI Callout - xrbGetMessage - Get an EPS error message string given
167 -- an error code.
168 --
169 -- Return 1 SUCCESS 0 FAIL
170 --
171 FUNCTION xrbGetMessage(msgno IN NATURAL,
172 buffer IN OUT NOCOPY VARCHAR2,
173 bufsize IN NATURAL)
174 RETURN NATURAL;
175 PRAGMA RESTRICT_REFERENCES (xrbGetMessage, WNDS, WNPS);
176
177
178
179
180 FUNCTION ParseRow(buffer IN OUT NOCOPY VARCHAR2,
181 buffer_size IN NUMBER,
182 buffer_ptr IN OUT NOCOPY NUMBER,
183 ncols IN NUMBER,
184 nrows IN NUMBER)
185 RETURN EPS_express_t;
186 PRAGMA RESTRICT_REFERENCES (ParseRow, WNDS, WNPS);
187
188 FUNCTION ParseCol(buffer IN OUT NOCOPY VARCHAR2,
189 buffer_size IN NUMBER,
190 buffer_ptr IN NUMBER,
191 col_val IN OUT NOCOPY VARCHAR2)
192 RETURN NUMBER;
193 PRAGMA RESTRICT_REFERENCES (ParseCol, WNDS, WNPS);
194 END EPS ;