[Home] [Help]
PACKAGE: APPS.OKL_STREAMS_PVT
Source
1 PACKAGE Okl_Streams_Pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLCSTMS.pls 120.1 2005/05/30 12:26:26 kthiruva noship $ */
3
4 SUBTYPE stmv_rec_type IS Okl_Stm_Pvt.stmv_rec_type;
5 SUBTYPE stmv_tbl_type IS Okl_Stm_Pvt.stmv_tbl_type;
6
7 SUBTYPE selv_rec_type IS Okl_Sel_Pvt.selv_rec_type;
8 SUBTYPE selv_tbl_type IS Okl_Sel_Pvt.selv_tbl_type;
9 ------------------------------------------------------------------------------
10 -- Global Variables
11 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_STREAMS_PVT';
12 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
13 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
14 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
15 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
16 ------------------------------------------------------------------------------
17 --Global Exception
18 ------------------------------------------------------------------------------
19 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
20 ------------------------------------------------------------------------------
21
22 --PROCEDURE ADD_LANGUAGE;
23
24 --Object type procedure for insert
25 PROCEDURE create_streams(
26 p_api_version IN NUMBER
27 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
28 ,x_return_status OUT NOCOPY VARCHAR2
29 ,x_msg_count OUT NOCOPY NUMBER
30 ,x_msg_data OUT NOCOPY VARCHAR2
31 ,p_stmv_rec IN stmv_rec_type
32 ,p_selv_tbl IN selv_tbl_type
33 ,x_stmv_rec OUT NOCOPY stmv_rec_type
34 ,x_selv_tbl OUT NOCOPY selv_tbl_type
35 );
36
37 --Object type procedure for insert(master-table,detail-table)
38 PROCEDURE create_streams(
39 p_api_version IN NUMBER
40 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
41 ,x_return_status OUT NOCOPY VARCHAR2
42 ,x_msg_count OUT NOCOPY NUMBER
43 ,x_msg_data OUT NOCOPY VARCHAR2
44 ,p_stmv_tbl IN stmv_tbl_type
45 ,p_selv_tbl IN selv_tbl_type
46 ,x_stmv_tbl OUT NOCOPY stmv_tbl_type
47 ,x_selv_tbl OUT NOCOPY selv_tbl_type
48 );
49
50 --Added by kthiruva on 12-May-2005
51 --For Streams Performance
52 --Bug 4346646-Start of Changes
53
54 --Object type procedure for insert(master-table,detail-table)
55 PROCEDURE create_streams_perf(
56 p_api_version IN NUMBER
57 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
58 ,x_return_status OUT NOCOPY VARCHAR2
59 ,x_msg_count OUT NOCOPY NUMBER
60 ,x_msg_data OUT NOCOPY VARCHAR2
61 ,p_stmv_tbl IN stmv_tbl_type
62 ,p_selv_tbl IN selv_tbl_type
63 ,x_stmv_tbl OUT NOCOPY stmv_tbl_type
64 ,x_selv_tbl OUT NOCOPY selv_tbl_type
65 );
66 --Bug 4346646-End of Changes
67
68 --Object type procedure for update
69 PROCEDURE update_streams(
70 p_api_version IN NUMBER
71 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
72 ,x_return_status OUT NOCOPY VARCHAR2
73 ,x_msg_count OUT NOCOPY NUMBER
74 ,x_msg_data OUT NOCOPY VARCHAR2
75 ,p_stmv_rec IN stmv_rec_type
76 ,p_selv_tbl IN selv_tbl_type
77 ,x_stmv_rec OUT NOCOPY stmv_rec_type
78 ,x_selv_tbl OUT NOCOPY selv_tbl_type
79 );
80
81 --Object type procedure for validate
82 PROCEDURE validate_streams(
83 p_api_version IN NUMBER
84 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
85 ,x_return_status OUT NOCOPY VARCHAR2
86 ,x_msg_count OUT NOCOPY NUMBER
87 ,x_msg_data OUT NOCOPY VARCHAR2
88 ,p_stmv_rec IN stmv_rec_type
89 ,p_selv_tbl IN selv_tbl_type
90 );
91
92
93
94 PROCEDURE create_streams(
95 p_api_version IN NUMBER,
96 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
97 x_return_status OUT NOCOPY VARCHAR2,
98 x_msg_count OUT NOCOPY NUMBER,
99 x_msg_data OUT NOCOPY VARCHAR2,
100 p_stmv_tbl IN stmv_tbl_type,
101 x_stmv_tbl OUT NOCOPY stmv_tbl_type);
102
103 PROCEDURE create_streams(
104 p_api_version IN NUMBER,
105 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
106 x_return_status OUT NOCOPY VARCHAR2,
107 x_msg_count OUT NOCOPY NUMBER,
108 x_msg_data OUT NOCOPY VARCHAR2,
109 p_stmv_rec IN stmv_rec_type,
110 x_stmv_rec OUT NOCOPY stmv_rec_type);
111
112 PROCEDURE lock_streams(
113 p_api_version IN NUMBER,
114 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
115 x_return_status OUT NOCOPY VARCHAR2,
116 x_msg_count OUT NOCOPY NUMBER,
117
118 x_msg_data OUT NOCOPY VARCHAR2,
119 p_stmv_tbl IN stmv_tbl_type);
120
121 PROCEDURE lock_streams(
122 p_api_version IN NUMBER,
123 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
124 x_return_status OUT NOCOPY VARCHAR2,
125 x_msg_count OUT NOCOPY NUMBER,
126 x_msg_data OUT NOCOPY VARCHAR2,
127 p_stmv_rec IN stmv_rec_type);
128
129 PROCEDURE update_streams(
130 p_api_version IN NUMBER,
131 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
132 x_return_status OUT NOCOPY VARCHAR2,
133 x_msg_count OUT NOCOPY NUMBER,
134 x_msg_data OUT NOCOPY VARCHAR2,
135 p_stmv_tbl IN stmv_tbl_type,
136 x_stmv_tbl OUT NOCOPY stmv_tbl_type);
137
138 PROCEDURE update_streams(
139 p_api_version IN NUMBER,
140 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
141 x_return_status OUT NOCOPY VARCHAR2,
142 x_msg_count OUT NOCOPY NUMBER,
143 x_msg_data OUT NOCOPY VARCHAR2,
144 p_stmv_rec IN stmv_rec_type,
145 x_stmv_rec OUT NOCOPY stmv_rec_type);
146
147 PROCEDURE delete_streams(
148 p_api_version IN NUMBER,
149 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
150 x_return_status OUT NOCOPY VARCHAR2,
151 x_msg_count OUT NOCOPY NUMBER,
152 x_msg_data OUT NOCOPY VARCHAR2,
153 p_stmv_tbl IN stmv_tbl_type);
154
155 PROCEDURE delete_streams(
156 p_api_version IN NUMBER,
157 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
158 x_return_status OUT NOCOPY VARCHAR2,
159 x_msg_count OUT NOCOPY NUMBER,
160 x_msg_data OUT NOCOPY VARCHAR2,
161 p_stmv_rec IN stmv_rec_type);
162
163 PROCEDURE validate_streams(
164 p_api_version IN NUMBER,
165 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
166 x_return_status OUT NOCOPY VARCHAR2,
167 x_msg_count OUT NOCOPY NUMBER,
168 x_msg_data OUT NOCOPY VARCHAR2,
169 p_stmv_tbl IN stmv_tbl_type);
170
171 PROCEDURE validate_streams(
172 p_api_version IN NUMBER,
173 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
174 x_return_status OUT NOCOPY VARCHAR2,
175 x_msg_count OUT NOCOPY NUMBER,
176 x_msg_data OUT NOCOPY VARCHAR2,
177 p_stmv_rec IN stmv_rec_type);
178
179
180 PROCEDURE create_stream_elements(
181 p_api_version IN NUMBER,
182 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
183 x_return_status OUT NOCOPY VARCHAR2,
184 x_msg_count OUT NOCOPY NUMBER,
185 x_msg_data OUT NOCOPY VARCHAR2,
186 p_selv_tbl IN selv_tbl_type,
187 x_selv_tbl OUT NOCOPY selv_tbl_type);
188
189 PROCEDURE create_stream_elements(
190 p_api_version IN NUMBER,
191 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
192 x_return_status OUT NOCOPY VARCHAR2,
193 x_msg_count OUT NOCOPY NUMBER,
194 x_msg_data OUT NOCOPY VARCHAR2,
195 p_selv_rec IN selv_rec_type,
196 x_selv_rec OUT NOCOPY selv_rec_type);
197
198 PROCEDURE lock_stream_elements(
199 p_api_version IN NUMBER,
200 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
201 x_return_status OUT NOCOPY VARCHAR2,
202 x_msg_count OUT NOCOPY NUMBER,
203 x_msg_data OUT NOCOPY VARCHAR2,
204 p_selv_tbl IN selv_tbl_type);
205
206 PROCEDURE lock_stream_elements(
207 p_api_version IN NUMBER,
208 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
209 x_return_status OUT NOCOPY VARCHAR2,
210 x_msg_count OUT NOCOPY NUMBER,
211 x_msg_data OUT NOCOPY VARCHAR2,
212 p_selv_rec IN selv_rec_type);
213
214 PROCEDURE update_stream_elements(
215 p_api_version IN NUMBER,
216 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
217
218 x_return_status OUT NOCOPY VARCHAR2,
219 x_msg_count OUT NOCOPY NUMBER,
220 x_msg_data OUT NOCOPY VARCHAR2,
221 p_selv_tbl IN selv_tbl_type,
222 x_selv_tbl OUT NOCOPY selv_tbl_type);
223
224 PROCEDURE update_stream_elements(
225 p_api_version IN NUMBER,
226 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
227 x_return_status OUT NOCOPY VARCHAR2,
228 x_msg_count OUT NOCOPY NUMBER,
229 x_msg_data OUT NOCOPY VARCHAR2,
230 p_selv_rec IN selv_rec_type,
231 x_selv_rec OUT NOCOPY selv_rec_type);
232
233 PROCEDURE delete_stream_elements(
234 p_api_version IN NUMBER,
235 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
236 x_return_status OUT NOCOPY VARCHAR2,
237 x_msg_count OUT NOCOPY NUMBER,
238 x_msg_data OUT NOCOPY VARCHAR2,
239 p_selv_tbl IN selv_tbl_type);
240
241 PROCEDURE delete_stream_elements(
242 p_api_version IN NUMBER,
243 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
244 x_return_status OUT NOCOPY VARCHAR2,
245 x_msg_count OUT NOCOPY NUMBER,
246 x_msg_data OUT NOCOPY VARCHAR2,
247 p_selv_rec IN selv_rec_type);
248
249 PROCEDURE validate_stream_elements(
250 p_api_version IN NUMBER,
251 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
252 x_return_status OUT NOCOPY VARCHAR2,
253 x_msg_count OUT NOCOPY NUMBER,
254 x_msg_data OUT NOCOPY VARCHAR2,
255 p_selv_tbl IN selv_tbl_type);
256
257 PROCEDURE validate_stream_elements(
258 p_api_version IN NUMBER,
259 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
260 x_return_status OUT NOCOPY VARCHAR2,
261 x_msg_count OUT NOCOPY NUMBER,
262 x_msg_data OUT NOCOPY VARCHAR2,
263 p_selv_rec IN selv_rec_type);
264 PROCEDURE version_stream(
265 p_api_version IN NUMBER,
266 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
267 x_return_status OUT NOCOPY VARCHAR2,
268 x_msg_count OUT NOCOPY NUMBER,
269 x_msg_data OUT NOCOPY VARCHAR2,
270 p_khr_id IN NUMBER,
271 p_major_version IN NUMBER) ;
272
273 END Okl_Streams_Pvt;