[Home] [Help]
PACKAGE: APPS.OKL_TRX_EXTENSION_PVT
Source
1 PACKAGE OKL_TRX_EXTENSION_PVT AUTHID CURRENT_USER AS
2 /*$Header: OKLCTEHS.pls 120.2 2007/08/06 13:50:49 prasjain noship $*/
3
4 SUBTYPE tehv_rec_type IS okl_teh_pvt.tehv_rec_type;
5 SUBTYPE tehv_tbl_type IS okl_teh_pvt.tehv_tbl_type;
6
7 SUBTYPE telv_rec_type IS okl_tel_pvt.telv_rec_type;
8 SUBTYPE telv_tbl_type IS okl_tel_pvt.telv_tbl_type;
9 -- Start : PRASJAIN : Bug# 6268782
10 SUBTYPE teh_rec_type IS okl_teh_pvt.teh_rec_type;
11 SUBTYPE tehl_tbl_type IS okl_teh_pvt.tehl_tbl_type;
12
13 SUBTYPE tel_rec_type IS okl_tel_pvt.tel_rec_type;
14 SUBTYPE tell_tbl_type IS okl_tel_pvt.tell_tbl_type;
15
16 SUBTYPE tel_tbl_tbl_type IS okl_tel_pvt.tel_tbl_tbl_type;
17 -- End : PRASJAIN : Bug# 6268782
18 ------------------------------------------------------------------------------
19 -- Global Variables
20 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TRX_EXTENSION_PVT';
21 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
22 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
23 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
24 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
25 ------------------------------------------------------------------------------
26 --Global Exception
27 ------------------------------------------------------------------------------
28 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
29 ------------------------------------------------------------------------------
30
31 --Object type procedure for insert
32 PROCEDURE create_trx_extension(
33 p_api_version IN NUMBER
34 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
35 ,x_return_status OUT NOCOPY VARCHAR2
36 ,x_msg_count OUT NOCOPY NUMBER
37 ,x_msg_data OUT NOCOPY VARCHAR2
38 ,p_tehv_rec IN tehv_rec_type
39 ,p_telv_tbl IN telv_tbl_type
40 ,x_tehv_rec OUT NOCOPY tehv_rec_type
41 ,x_telv_tbl OUT NOCOPY telv_tbl_type
42 );
43
44 --Object type procedure for update
45 PROCEDURE update_trx_extension(
46 p_api_version IN NUMBER
47 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
48 ,x_return_status OUT NOCOPY VARCHAR2
49 ,x_msg_count OUT NOCOPY NUMBER
50 ,x_msg_data OUT NOCOPY VARCHAR2
51 ,p_tehv_rec IN tehv_rec_type
52 ,p_telv_tbl IN telv_tbl_type
53 ,x_tehv_rec OUT NOCOPY tehv_rec_type
54 ,x_telv_tbl OUT NOCOPY telv_tbl_type
55 );
56
57 --Object type procedure for validate
58 PROCEDURE validate_trx_extension(
59 p_api_version IN NUMBER
60 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
61 ,x_return_status OUT NOCOPY VARCHAR2
62 ,x_msg_count OUT NOCOPY NUMBER
63 ,x_msg_data OUT NOCOPY VARCHAR2
64 ,p_tehv_rec IN tehv_rec_type
65 ,p_telv_tbl IN telv_tbl_type
66 );
67
68
69 --Object type procedure for create
70 PROCEDURE create_trx_extension(
71 p_api_version IN NUMBER,
72 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
73 x_return_status OUT NOCOPY VARCHAR2,
74 x_msg_count OUT NOCOPY NUMBER,
75 x_msg_data OUT NOCOPY VARCHAR2,
76 p_tehv_tbl IN tehv_tbl_type,
77 x_tehv_tbl OUT NOCOPY tehv_tbl_type);
78
79 --Object type procedure for create
80 PROCEDURE create_trx_extension(
81 p_api_version IN NUMBER,
82 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
83 x_return_status OUT NOCOPY VARCHAR2,
84 x_msg_count OUT NOCOPY NUMBER,
85 x_msg_data OUT NOCOPY VARCHAR2,
86 p_tehv_rec IN tehv_rec_type,
87 x_tehv_rec OUT NOCOPY tehv_rec_type);
88
89 --Object type procedure for lock
90 PROCEDURE lock_trx_extension(
91 p_api_version IN NUMBER,
92 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
93 x_return_status OUT NOCOPY VARCHAR2,
94 x_msg_count OUT NOCOPY NUMBER,
95 x_msg_data OUT NOCOPY VARCHAR2,
96 p_tehv_tbl IN tehv_tbl_type);
97
98 --Object type procedure for lock
99 PROCEDURE lock_trx_extension(
100 p_api_version IN NUMBER,
101 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
102 x_return_status OUT NOCOPY VARCHAR2,
103 x_msg_count OUT NOCOPY NUMBER,
104 x_msg_data OUT NOCOPY VARCHAR2,
105 p_tehv_rec IN tehv_rec_type);
106
107 --Object type procedure for update
108 PROCEDURE update_trx_extension(
109 p_api_version IN NUMBER,
110 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
111 x_return_status OUT NOCOPY VARCHAR2,
112 x_msg_count OUT NOCOPY NUMBER,
113 x_msg_data OUT NOCOPY VARCHAR2,
114 p_tehv_tbl IN tehv_tbl_type,
115 x_tehv_tbl OUT NOCOPY tehv_tbl_type);
116
117 --Object type procedure for update
118 PROCEDURE update_trx_extension(
119 p_api_version IN NUMBER,
120 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
121 x_return_status OUT NOCOPY VARCHAR2,
122 x_msg_count OUT NOCOPY NUMBER,
123 x_msg_data OUT NOCOPY VARCHAR2,
124 p_tehv_rec IN tehv_rec_type,
125 x_tehv_rec OUT NOCOPY tehv_rec_type);
126
127 --Object type procedure for delete
128 PROCEDURE delete_trx_extension(
129 p_api_version IN NUMBER,
130 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
131 x_return_status OUT NOCOPY VARCHAR2,
132 x_msg_count OUT NOCOPY NUMBER,
133 x_msg_data OUT NOCOPY VARCHAR2,
134 p_tehv_tbl IN tehv_tbl_type);
135
136 --Object type procedure for delete
137 PROCEDURE delete_trx_extension(
138 p_api_version IN NUMBER,
139 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
140 x_return_status OUT NOCOPY VARCHAR2,
141 x_msg_count OUT NOCOPY NUMBER,
142 x_msg_data OUT NOCOPY VARCHAR2,
143 p_tehv_rec IN tehv_rec_type);
144
145 --Object type procedure for validate
146 PROCEDURE validate_trx_extension(
147 p_api_version IN NUMBER,
148 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
149 x_return_status OUT NOCOPY VARCHAR2,
150 x_msg_count OUT NOCOPY NUMBER,
151 x_msg_data OUT NOCOPY VARCHAR2,
152 p_tehv_tbl IN tehv_tbl_type);
153
154 --Object type procedure for validate
155 PROCEDURE validate_trx_extension(
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_tehv_rec IN tehv_rec_type);
162
163 --Object type procedure for create
164 PROCEDURE create_txl_extension(
165 p_api_version IN NUMBER,
166 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
167 x_return_status OUT NOCOPY VARCHAR2,
168 x_msg_count OUT NOCOPY NUMBER,
169 x_msg_data OUT NOCOPY VARCHAR2,
170 p_telv_tbl IN telv_tbl_type,
171 x_telv_tbl OUT NOCOPY telv_tbl_type);
172
173 --Object type procedure for create
174 PROCEDURE create_txl_extension(
175 p_api_version IN NUMBER,
176 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
177 x_return_status OUT NOCOPY VARCHAR2,
178 x_msg_count OUT NOCOPY NUMBER,
179 x_msg_data OUT NOCOPY VARCHAR2,
180 p_telv_rec IN telv_rec_type,
181 x_telv_rec OUT NOCOPY telv_rec_type);
182
183 --Object type procedure for lock
184 PROCEDURE lock_txl_extension(
185 p_api_version IN NUMBER,
186 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
187 x_return_status OUT NOCOPY VARCHAR2,
188 x_msg_count OUT NOCOPY NUMBER,
189 x_msg_data OUT NOCOPY VARCHAR2,
190 p_telv_tbl IN telv_tbl_type);
191
192 --Object type procedure for lock
193 PROCEDURE lock_txl_extension(
194 p_api_version IN NUMBER,
195 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
196 x_return_status OUT NOCOPY VARCHAR2,
197 x_msg_count OUT NOCOPY NUMBER,
198 x_msg_data OUT NOCOPY VARCHAR2,
199 p_telv_rec IN telv_rec_type);
200
201 --Object type procedure for update
202 PROCEDURE update_txl_extension(
203 p_api_version IN NUMBER,
204 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
205 x_return_status OUT NOCOPY VARCHAR2,
206 x_msg_count OUT NOCOPY NUMBER,
207 x_msg_data OUT NOCOPY VARCHAR2,
208 p_telv_tbl IN telv_tbl_type,
209 x_telv_tbl OUT NOCOPY telv_tbl_type);
210
211 --Object type procedure for update
212 PROCEDURE update_txl_extension(
213 p_api_version IN NUMBER,
214 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
215 x_return_status OUT NOCOPY VARCHAR2,
216 x_msg_count OUT NOCOPY NUMBER,
217 x_msg_data OUT NOCOPY VARCHAR2,
218 p_telv_rec IN telv_rec_type,
219 x_telv_rec OUT NOCOPY telv_rec_type);
220
221 --Object type procedure for delete
222 PROCEDURE delete_txl_extension(
223 p_api_version IN NUMBER,
224 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
225 x_return_status OUT NOCOPY VARCHAR2,
226 x_msg_count OUT NOCOPY NUMBER,
227 x_msg_data OUT NOCOPY VARCHAR2,
228 p_telv_tbl IN telv_tbl_type);
229
230 --Object type procedure for delete
231 PROCEDURE delete_txl_extension(
232 p_api_version IN NUMBER,
233 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
234 x_return_status OUT NOCOPY VARCHAR2,
235 x_msg_count OUT NOCOPY NUMBER,
236 x_msg_data OUT NOCOPY VARCHAR2,
237 p_telv_rec IN telv_rec_type);
238
239 --Object type procedure for validate
240 PROCEDURE validate_txl_extension(
241 p_api_version IN NUMBER,
242 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
243 x_return_status OUT NOCOPY VARCHAR2,
244 x_msg_count OUT NOCOPY NUMBER,
245 x_msg_data OUT NOCOPY VARCHAR2,
246 p_telv_tbl IN telv_tbl_type);
247
248 --Object type procedure for validate
249 PROCEDURE validate_txl_extension(
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_telv_rec IN telv_rec_type);
256
257 --Object type procedure for validate
258 --Added : PRASJAIN : Bug# 6268782
259 PROCEDURE create_trx_extension(
260 p_api_version IN NUMBER
261 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
262 ,x_return_status OUT NOCOPY VARCHAR2
263 ,x_msg_count OUT NOCOPY NUMBER
264 ,x_msg_data OUT NOCOPY VARCHAR2
265 ,p_teh_rec IN teh_rec_type
266 ,p_tehl_tbl IN tehl_tbl_type
267 ,x_teh_rec OUT NOCOPY teh_rec_type
268 ,x_tehl_tbl OUT NOCOPY tehl_tbl_type);
269
270 --Object type procedure for validate
271 --Added : PRASJAIN : Bug# 6268782
272 PROCEDURE create_txl_extension(
273 p_api_version IN NUMBER
274 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
275 ,x_return_status OUT NOCOPY VARCHAR2
276 ,x_msg_count OUT NOCOPY NUMBER
277 ,x_msg_data OUT NOCOPY VARCHAR2
278 ,p_tel_rec IN tel_rec_type
279 ,p_tell_tbl IN tell_tbl_type
280 ,x_tel_rec OUT NOCOPY tel_rec_type
281 ,x_tell_tbl OUT NOCOPY tell_tbl_type);
282
283 --Object type procedure for validate
284 --Added : PRASJAIN : Bug# 6268782
285 PROCEDURE create_txl_extension(
286 p_api_version IN NUMBER
287 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
288 ,x_return_status OUT NOCOPY VARCHAR2
289 ,x_msg_count OUT NOCOPY NUMBER
290 ,x_msg_data OUT NOCOPY VARCHAR2
291 ,p_tel_tbl_tbl IN tel_tbl_tbl_type
292 ,x_tel_tbl_tbl OUT NOCOPY tel_tbl_tbl_type);
293 END OKL_TRX_EXTENSION_PVT;