[Home] [Help]
PACKAGE: APPS.OKL_FA_EXTENSION_PVT
Source
1 PACKAGE OKL_FA_EXTENSION_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLCFXHS.pls 120.1 2007/08/06 13:47:47 prasjain noship $ */
3
4 SUBTYPE fxhv_rec_type IS okl_fxh_pvt.fxhv_rec_type;
5 SUBTYPE fxhv_tbl_type IS okl_fxh_pvt.fxhv_tbl_type;
6
7 SUBTYPE fxlv_rec_type IS okl_fxl_pvt.fxlv_rec_type;
8 SUBTYPE fxlv_tbl_type IS okl_fxl_pvt.fxlv_tbl_type;
9 -- Start : Bug# 6268782 : PRASJAIN
10 SUBTYPE fxh_rec_type IS okl_fxh_pvt.fxh_rec_type;
11 SUBTYPE fxhl_tbl_type IS okl_fxh_pvt.fxhl_tbl_type;
12
13 SUBTYPE fxl_rec_type IS okl_fxl_pvt.fxl_rec_type;
14 SUBTYPE fxll_tbl_type IS okl_fxl_pvt.fxll_tbl_type;
15
16 SUBTYPE fxl_tbl_tbl_type IS okl_fxl_pvt.fxl_tbl_tbl_type;
17 -- End : Bug# 6268782 : PRASJAIN
18 ------------------------------------------------------------------------------
19 -- Global Variables
20 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_FA_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_fxh_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_fxhv_rec IN fxhv_rec_type
39 ,p_fxlv_tbl IN fxlv_tbl_type
40 ,x_fxhv_rec OUT NOCOPY fxhv_rec_type
41 ,x_fxlv_tbl OUT NOCOPY fxlv_tbl_type
42 );
43
44 --Object type procedure for update
45 PROCEDURE update_fxh_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_fxhv_rec IN fxhv_rec_type
52 ,p_fxlv_tbl IN fxlv_tbl_type
53 ,x_fxhv_rec OUT NOCOPY fxhv_rec_type
54 ,x_fxlv_tbl OUT NOCOPY fxlv_tbl_type
55 );
56
57 --Object type procedure for validate
58 PROCEDURE validate_fxh_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_fxhv_rec IN fxhv_rec_type
65 ,p_fxlv_tbl IN fxlv_tbl_type
66 );
67
68
69 --Object type procedure for create
70 PROCEDURE create_fxh_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_fxhv_tbl IN fxhv_tbl_type,
77 x_fxhv_tbl OUT NOCOPY fxhv_tbl_type);
78
79 --Object type procedure for create
80 PROCEDURE create_fxh_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_fxhv_rec IN fxhv_rec_type,
87 x_fxhv_rec OUT NOCOPY fxhv_rec_type);
88
89 --Object type procedure for lock
90 PROCEDURE lock_fxh_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_fxhv_tbl IN fxhv_tbl_type);
97
98 --Object type procedure for lock
99 PROCEDURE lock_fxh_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,
108 PROCEDURE update_fxh_extension(
105 p_fxhv_rec IN fxhv_rec_type);
106
107 --Object type procedure for update
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_fxhv_tbl IN fxhv_tbl_type,
115 x_fxhv_tbl OUT NOCOPY fxhv_tbl_type);
116
117 --Object type procedure for update
118 PROCEDURE update_fxh_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_fxhv_rec IN fxhv_rec_type,
125 x_fxhv_rec OUT NOCOPY fxhv_rec_type);
126
127 --Object type procedure for delete
128 PROCEDURE delete_fxh_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_fxhv_tbl IN fxhv_tbl_type);
135
136 --Object type procedure for delete
137 PROCEDURE delete_fxh_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_fxhv_rec IN fxhv_rec_type);
144
145 --Object type procedure for validate
146 PROCEDURE validate_fxh_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_fxhv_tbl IN fxhv_tbl_type);
153
154 --Object type procedure for validate
155 PROCEDURE validate_fxh_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_fxhv_rec IN fxhv_rec_type);
162
163 --Object type procedure for create
164 PROCEDURE create_fxl_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_fxlv_tbl IN fxlv_tbl_type,
171 x_fxlv_tbl OUT NOCOPY fxlv_tbl_type);
172
173 --Object type procedure for create
174 PROCEDURE create_fxl_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_fxlv_rec IN fxlv_rec_type,
181 x_fxlv_rec OUT NOCOPY fxlv_rec_type);
182
183 --Object type procedure for lock
184 PROCEDURE lock_fxl_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_fxlv_tbl IN fxlv_tbl_type);
191
192 --Object type procedure for lock
193 PROCEDURE lock_fxl_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_fxlv_rec IN fxlv_rec_type);
200
201 --Object type procedure for update
202 PROCEDURE update_fxl_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_fxlv_tbl IN fxlv_tbl_type,
209 x_fxlv_tbl OUT NOCOPY fxlv_tbl_type);
210
211 --Object type procedure for update
212 PROCEDURE update_fxl_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_fxlv_rec IN fxlv_rec_type,
219 x_fxlv_rec OUT NOCOPY fxlv_rec_type);
220
221 --Object type procedure for delete
222 PROCEDURE delete_fxl_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_fxlv_tbl IN fxlv_tbl_type);
229
230 --Object type procedure for delete
231 PROCEDURE delete_fxl_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_fxlv_rec IN fxlv_rec_type);
238
239 --Object type procedure for validate
240 PROCEDURE validate_fxl_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_fxlv_tbl IN fxlv_tbl_type);
247
248 --Object type procedure for validate
249 PROCEDURE validate_fxl_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_fxlv_rec IN fxlv_rec_type);
256 --Object type procedure for validate
257 --Added : Bug# 6268782 : PRASJAIN
258 PROCEDURE create_fxh_extension(
259 p_api_version IN NUMBER
260 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
261 ,x_return_status OUT NOCOPY VARCHAR2
262 ,x_msg_count OUT NOCOPY NUMBER
263 ,x_msg_data OUT NOCOPY VARCHAR2
264 ,p_fxh_rec IN fxh_rec_type
265 ,p_fxhl_tbl IN fxhl_tbl_type
266 ,x_fxh_rec OUT NOCOPY fxh_rec_type
267 ,x_fxhl_tbl OUT NOCOPY fxhl_tbl_type);
268 --Object type procedure for validate
269 --Added : Bug# 6268782 : PRASJAIN
270 PROCEDURE create_fxl_extension(
271 p_api_version IN NUMBER
272 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
273 ,x_return_status OUT NOCOPY VARCHAR2
274 ,x_msg_count OUT NOCOPY NUMBER
275 ,x_msg_data OUT NOCOPY VARCHAR2
276 ,p_fxl_rec IN fxl_rec_type
277 ,p_fxll_tbl IN fxll_tbl_type
278 ,x_fxl_rec OUT NOCOPY fxl_rec_type
279 ,x_fxll_tbl OUT NOCOPY fxll_tbl_type);
280 --Object type procedure for validate
281 --Added : Bug# 6268782 : PRASJAIN
282 PROCEDURE create_fxl_extension(
283 p_api_version IN NUMBER
284 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
285 ,x_return_status OUT NOCOPY VARCHAR2
286 ,x_msg_count OUT NOCOPY NUMBER
287 ,x_msg_data OUT NOCOPY VARCHAR2
288 ,p_fxl_tbl_tbl IN fxl_tbl_tbl_type
289 ,x_fxl_tbl_tbl OUT NOCOPY fxl_tbl_tbl_type);
290 END OKL_FA_EXTENSION_PVT;