1 PACKAGE OKL_AP_EXTENSION_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLCPXHS.pls 120.1 2007/08/06 13:48:56 prasjain noship $ */
3 SUBTYPE pxhv_rec_type IS okl_pxh_pvt.pxhv_rec_type;
4 SUBTYPE pxhv_tbl_type IS okl_pxh_pvt.pxhv_tbl_type;
5
6 SUBTYPE pxlv_rec_type IS okl_pxl_pvt.pxlv_rec_type;
7 SUBTYPE pxlv_tbl_type IS okl_pxl_pvt.pxlv_tbl_type;
8 -- Start : PRASJAIN : Bug# 6268782
9 SUBTYPE pxh_rec_type IS okl_pxh_pvt.pxh_rec_type;
10 SUBTYPE pxhl_tbl_type IS okl_pxh_pvt.pxhl_tbl_type;
11
12 SUBTYPE pxl_rec_type IS okl_pxl_pvt.pxl_rec_type;
13 SUBTYPE pxll_tbl_type IS okl_pxl_pvt.pxll_tbl_type;
14 -- End : PRASJAIN : Bug# 6268782
15 ------------------------------------------------------------------------------
16 -- Global Variables
17 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AP_EXTENSION_PVT';
18 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
19 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
20 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
21 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
22 ------------------------------------------------------------------------------
23 --Global Exception
24 ------------------------------------------------------------------------------
25 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
26 ------------------------------------------------------------------------------
27
28 --Object type procedure for insert
29 PROCEDURE create_pxh_extension(
30 p_api_version IN NUMBER
31 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
32 ,x_return_status OUT NOCOPY VARCHAR2
33 ,x_msg_count OUT NOCOPY NUMBER
34 ,x_msg_data OUT NOCOPY VARCHAR2
35 ,p_pxhv_rec IN pxhv_rec_type
36 ,p_pxlv_tbl IN pxlv_tbl_type
37 ,x_pxhv_rec OUT NOCOPY pxhv_rec_type
38 ,x_pxlv_tbl OUT NOCOPY pxlv_tbl_type
39 );
40
41 --Object type procedure for update
42 PROCEDURE update_pxh_extension(
43 p_api_version IN NUMBER
44 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
45 ,x_return_status OUT NOCOPY VARCHAR2
46 ,x_msg_count OUT NOCOPY NUMBER
47 ,x_msg_data OUT NOCOPY VARCHAR2
48 ,p_pxhv_rec IN pxhv_rec_type
49 ,p_pxlv_tbl IN pxlv_tbl_type
50 ,x_pxhv_rec OUT NOCOPY pxhv_rec_type
51 ,x_pxlv_tbl OUT NOCOPY pxlv_tbl_type
52 );
53
54 --Object type procedure for validate
55 PROCEDURE validate_pxh_extension(
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_pxhv_rec IN pxhv_rec_type
62 ,p_pxlv_tbl IN pxlv_tbl_type
63 );
64
65
66 --Object type procedure for create
67 PROCEDURE create_pxh_extension(
68 p_api_version IN NUMBER,
69 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
70 x_return_status OUT NOCOPY VARCHAR2,
71 x_msg_count OUT NOCOPY NUMBER,
72 x_msg_data OUT NOCOPY VARCHAR2,
73 p_pxhv_tbl IN pxhv_tbl_type,
74 x_pxhv_tbl OUT NOCOPY pxhv_tbl_type);
75
76 --Object type procedure for create
77 PROCEDURE create_pxh_extension(
78 p_api_version IN NUMBER,
79 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
80 x_return_status OUT NOCOPY VARCHAR2,
81 x_msg_count OUT NOCOPY NUMBER,
82 x_msg_data OUT NOCOPY VARCHAR2,
83 p_pxhv_rec IN pxhv_rec_type,
84 x_pxhv_rec OUT NOCOPY pxhv_rec_type);
85
86 --Object type procedure for lock
87 PROCEDURE lock_pxh_extension(
88 p_api_version IN NUMBER,
89 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
90 x_return_status OUT NOCOPY VARCHAR2,
91 x_msg_count OUT NOCOPY NUMBER,
92 x_msg_data OUT NOCOPY VARCHAR2,
93 p_pxhv_tbl IN pxhv_tbl_type);
94
95 --Object type procedure for lock
96 PROCEDURE lock_pxh_extension(
97 p_api_version IN NUMBER,
98 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
99 x_return_status OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER,
101 x_msg_data OUT NOCOPY VARCHAR2,
102 p_pxhv_rec IN pxhv_rec_type);
103
104 --Object type procedure for update
105 PROCEDURE update_pxh_extension(
106 p_api_version IN NUMBER,
107 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
108 x_return_status OUT NOCOPY VARCHAR2,
109 x_msg_count OUT NOCOPY NUMBER,
110 x_msg_data OUT NOCOPY VARCHAR2,
111 p_pxhv_tbl IN pxhv_tbl_type,
112 x_pxhv_tbl OUT NOCOPY pxhv_tbl_type);
113
114 --Object type procedure for update
115 PROCEDURE update_pxh_extension(
116 p_api_version IN NUMBER,
117 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
118 x_return_status OUT NOCOPY VARCHAR2,
119 x_msg_count OUT NOCOPY NUMBER,
120 x_msg_data OUT NOCOPY VARCHAR2,
121 p_pxhv_rec IN pxhv_rec_type,
122 x_pxhv_rec OUT NOCOPY pxhv_rec_type);
123
124 --Object type procedure for delete
125 PROCEDURE delete_pxh_extension(
126 p_api_version IN NUMBER,
127 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
128 x_return_status OUT NOCOPY VARCHAR2,
129 x_msg_count OUT NOCOPY NUMBER,
130 x_msg_data OUT NOCOPY VARCHAR2,
131 p_pxhv_tbl IN pxhv_tbl_type);
132
133 --Object type procedure for delete
134 PROCEDURE delete_pxh_extension(
135 p_api_version IN NUMBER,
136 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
137 x_return_status OUT NOCOPY VARCHAR2,
138 x_msg_count OUT NOCOPY NUMBER,
139 x_msg_data OUT NOCOPY VARCHAR2,
140 p_pxhv_rec IN pxhv_rec_type);
141
142 --Object type procedure for validate
143 PROCEDURE validate_pxh_extension(
144 p_api_version IN NUMBER,
145 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
146 x_return_status OUT NOCOPY VARCHAR2,
147 x_msg_count OUT NOCOPY NUMBER,
148 x_msg_data OUT NOCOPY VARCHAR2,
149 p_pxhv_tbl IN pxhv_tbl_type);
150
151 --Object type procedure for validate
152 PROCEDURE validate_pxh_extension(
153 p_api_version IN NUMBER,
154 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
155 x_return_status OUT NOCOPY VARCHAR2,
156 x_msg_count OUT NOCOPY NUMBER,
157 x_msg_data OUT NOCOPY VARCHAR2,
158 p_pxhv_rec IN pxhv_rec_type);
159
160 --Object type procedure for create
161 PROCEDURE create_pxl_extension(
162 p_api_version IN NUMBER,
163 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
164 x_return_status OUT NOCOPY VARCHAR2,
165 x_msg_count OUT NOCOPY NUMBER,
166 x_msg_data OUT NOCOPY VARCHAR2,
167 p_pxlv_tbl IN pxlv_tbl_type,
168 x_pxlv_tbl OUT NOCOPY pxlv_tbl_type);
169
170 --Object type procedure for create
171 PROCEDURE create_pxl_extension(
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_pxlv_rec IN pxlv_rec_type,
178 x_pxlv_rec OUT NOCOPY pxlv_rec_type);
179
180 --Object type procedure for lock
181 PROCEDURE lock_pxl_extension(
182 p_api_version IN NUMBER,
183 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
184 x_return_status OUT NOCOPY VARCHAR2,
185 x_msg_count OUT NOCOPY NUMBER,
186 x_msg_data OUT NOCOPY VARCHAR2,
187 p_pxlv_tbl IN pxlv_tbl_type);
188
189 --Object type procedure for lock
190 PROCEDURE lock_pxl_extension(
191 p_api_version IN NUMBER,
192 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
193 x_return_status OUT NOCOPY VARCHAR2,
194 x_msg_count OUT NOCOPY NUMBER,
195 x_msg_data OUT NOCOPY VARCHAR2,
196 p_pxlv_rec IN pxlv_rec_type);
197
198 --Object type procedure for update
199 PROCEDURE update_pxl_extension(
200 p_api_version IN NUMBER,
201 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
202 x_return_status OUT NOCOPY VARCHAR2,
203 x_msg_count OUT NOCOPY NUMBER,
204 x_msg_data OUT NOCOPY VARCHAR2,
205 p_pxlv_tbl IN pxlv_tbl_type,
206 x_pxlv_tbl OUT NOCOPY pxlv_tbl_type);
207
208 --Object type procedure for update
209 PROCEDURE update_pxl_extension(
210 p_api_version IN NUMBER,
211 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
212 x_return_status OUT NOCOPY VARCHAR2,
213 x_msg_count OUT NOCOPY NUMBER,
214 x_msg_data OUT NOCOPY VARCHAR2,
215 p_pxlv_rec IN pxlv_rec_type,
216 x_pxlv_rec OUT NOCOPY pxlv_rec_type);
217
218 --Object type procedure for delete
219 PROCEDURE delete_pxl_extension(
220 p_api_version IN NUMBER,
221 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
222 x_return_status OUT NOCOPY VARCHAR2,
223 x_msg_count OUT NOCOPY NUMBER,
224 x_msg_data OUT NOCOPY VARCHAR2,
225 p_pxlv_tbl IN pxlv_tbl_type);
226
227 --Object type procedure for delete
228 PROCEDURE delete_pxl_extension(
229 p_api_version IN NUMBER,
230 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
231 x_return_status OUT NOCOPY VARCHAR2,
232 x_msg_count OUT NOCOPY NUMBER,
233 x_msg_data OUT NOCOPY VARCHAR2,
234 p_pxlv_rec IN pxlv_rec_type);
235
236 --Object type procedure for validate
237 PROCEDURE validate_pxl_extension(
238 p_api_version IN NUMBER,
239 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
240 x_return_status OUT NOCOPY VARCHAR2,
241 x_msg_count OUT NOCOPY NUMBER,
242 x_msg_data OUT NOCOPY VARCHAR2,
243 p_pxlv_tbl IN pxlv_tbl_type);
244
245 --Object type procedure for validate
246 PROCEDURE validate_pxl_extension(
247 p_api_version IN NUMBER,
248 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
249 x_return_status OUT NOCOPY VARCHAR2,
250 x_msg_count OUT NOCOPY NUMBER,
251 x_msg_data OUT NOCOPY VARCHAR2,
252 p_pxlv_rec IN pxlv_rec_type);
253
254 --Object type procedure for insert
255 --Added for Bug# 6268782 : PRASJAIN
256 PROCEDURE create_pxh_extension(
257 p_api_version IN NUMBER
258 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
259 ,x_return_status OUT NOCOPY VARCHAR2
260 ,x_msg_count OUT NOCOPY NUMBER
261 ,x_msg_data OUT NOCOPY VARCHAR2
262 ,p_pxh_rec IN pxh_rec_type
263 ,p_pxhl_tbl IN pxhl_tbl_type
264 ,x_pxh_rec OUT NOCOPY pxh_rec_type
265 ,x_pxhl_tbl OUT NOCOPY pxhl_tbl_type);
266
267 --Object type procedure for insert
268 --Added for Bug# 6268782 : PRASJAIN
269 PROCEDURE create_pxl_extension(
270 p_api_version IN NUMBER
271 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
272 ,x_return_status OUT NOCOPY VARCHAR2
273 ,x_msg_count OUT NOCOPY NUMBER
274 ,x_msg_data OUT NOCOPY VARCHAR2
275 ,p_pxl_rec IN pxl_rec_type
276 ,p_pxll_tbl IN pxll_tbl_type
277 ,x_pxl_rec OUT NOCOPY pxl_rec_type
278 ,x_pxll_tbl OUT NOCOPY pxll_tbl_type);
279 END OKL_AP_EXTENSION_PVT;