[Home] [Help]
PACKAGE: APPS.OKL_FXH_PVT
Source
1 PACKAGE OKL_FXH_PVT AS
2 /* $Header: OKLSFXHS.pls 120.5 2007/12/21 12:48:05 rajnisku noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL DATASTRUCTURES
6 ---------------------------------------------------------------------------
7 -- OKL_EXT_FA_HEADER_SOURCES_V Record Spec
8 TYPE fxhv_rec_type IS RECORD (
9 header_extension_id NUMBER
10 ,source_id NUMBER
11 ,source_table OKL_EXT_FA_HEADER_SOURCES_V.SOURCE_TABLE%TYPE
12 ,object_version_number NUMBER
13 ,trans_number NUMBER
14 ,khr_id NUMBER
15 ,try_id NUMBER
16 ,contract_number OKL_EXT_FA_HEADER_SOURCES_V.CONTRACT_NUMBER%TYPE
17 ,customer_name OKL_EXT_FA_HEADER_SOURCES_V.CUSTOMER_NAME%TYPE
18 ,customer_account_number OKL_EXT_FA_HEADER_SOURCES_V.CUSTOMER_ACCOUNT_NUMBER%TYPE
19 ,book_classification_code OKL_EXT_FA_HEADER_SOURCES_V.BOOK_CLASSIFICATION_CODE%TYPE
20 ,product_name OKL_EXT_FA_HEADER_SOURCES_V.PRODUCT_NAME%TYPE
21 ,tax_owner_code OKL_EXT_FA_HEADER_SOURCES_V.TAX_OWNER_CODE%TYPE
22 ,representation_code OKL_EXT_FA_HEADER_SOURCES_V.REPRESENTATION_CODE%TYPE
23 ,representation_name OKL_EXT_FA_HEADER_SOURCES_V.REPRESENTATION_NAME%TYPE
24 ,rent_ia_contract_number OKL_EXT_FA_HEADER_SOURCES_V.RENT_IA_CONTRACT_NUMBER%TYPE
25 ,res_ia_contract_number OKL_EXT_FA_HEADER_SOURCES_V.RES_IA_CONTRACT_NUMBER%TYPE
26 ,converted_number OKL_EXT_FA_HEADER_SOURCES_V.CONVERTED_NUMBER%TYPE
27 ,contract_effective_from OKL_EXT_FA_HEADER_SOURCES_V.CONTRACT_EFFECTIVE_FROM%TYPE
28 ,contract_currency_code OKL_EXT_FA_HEADER_SOURCES_V.CONTRACT_CURRENCY_CODE%TYPE
29 ,sales_rep_name OKL_EXT_FA_HEADER_SOURCES_V.SALES_REP_NAME%TYPE
30 ,rent_ia_product_name OKL_EXT_FA_HEADER_SOURCES_V.RENT_IA_PRODUCT_NAME%TYPE
31 ,res_ia_product_name OKL_EXT_FA_HEADER_SOURCES_V.RES_IA_PRODUCT_NAME%TYPE
32 ,po_order_number OKL_EXT_FA_HEADER_SOURCES_V.PO_ORDER_NUMBER%TYPE
33 ,vendor_program_number OKL_EXT_FA_HEADER_SOURCES_V.VENDOR_PROGRAM_NUMBER%TYPE
34 ,rent_ia_accounting_code OKL_EXT_FA_HEADER_SOURCES_V.RENT_IA_ACCOUNTING_CODE%TYPE
35 ,res_ia_accounting_code OKL_EXT_FA_HEADER_SOURCES_V.RES_IA_ACCOUNTING_CODE%TYPE
36 ,assignable_flag OKL_EXT_FA_HEADER_SOURCES_V.ASSIGNABLE_FLAG%TYPE
37 ,converted_account_flag OKL_EXT_FA_HEADER_SOURCES_V.CONVERTED_ACCOUNT_FLAG%TYPE
38 ,accrual_override_flag OKL_EXT_FA_HEADER_SOURCES_V.ACCRUAL_OVERRIDE_FLAG%TYPE
39 ,khr_attribute_category OKL_EXT_FA_HEADER_SOURCES_V.KHR_ATTRIBUTE_CATEGORY%TYPE
40 ,khr_attribute1 OKL_EXT_FA_HEADER_SOURCES_V.KHR_ATTRIBUTE1%TYPE
41 ,khr_attribute2 OKL_EXT_FA_HEADER_SOURCES_V.KHR_ATTRIBUTE2%TYPE
42 ,khr_attribute3 OKL_EXT_FA_HEADER_SOURCES_V.KHR_ATTRIBUTE3%TYPE
43 ,khr_attribute4 OKL_EXT_FA_HEADER_SOURCES_V.KHR_ATTRIBUTE4%TYPE
44 ,khr_attribute5 OKL_EXT_FA_HEADER_SOURCES_V.KHR_ATTRIBUTE5%TYPE
45 ,khr_attribute6 OKL_EXT_FA_HEADER_SOURCES_V.KHR_ATTRIBUTE6%TYPE
46 ,khr_attribute7 OKL_EXT_FA_HEADER_SOURCES_V.KHR_ATTRIBUTE7%TYPE
47 ,khr_attribute8 OKL_EXT_FA_HEADER_SOURCES_V.KHR_ATTRIBUTE8%TYPE
48 ,khr_attribute9 OKL_EXT_FA_HEADER_SOURCES_V.KHR_ATTRIBUTE9%TYPE
49 ,khr_attribute10 OKL_EXT_FA_HEADER_SOURCES_V.KHR_ATTRIBUTE10%TYPE
50 ,khr_attribute11 OKL_EXT_FA_HEADER_SOURCES_V.KHR_ATTRIBUTE11%TYPE
51 ,khr_attribute12 OKL_EXT_FA_HEADER_SOURCES_V.KHR_ATTRIBUTE12%TYPE
52 ,khr_attribute13 OKL_EXT_FA_HEADER_SOURCES_V.KHR_ATTRIBUTE13%TYPE
53 ,khr_attribute14 OKL_EXT_FA_HEADER_SOURCES_V.KHR_ATTRIBUTE14%TYPE
54 ,khr_attribute15 OKL_EXT_FA_HEADER_SOURCES_V.KHR_ATTRIBUTE15%TYPE
55 ,cust_attribute_category OKL_EXT_FA_HEADER_SOURCES_V.CUST_ATTRIBUTE_CATEGORY%TYPE
56 ,cust_attribute1 OKL_EXT_FA_HEADER_SOURCES_V.CUST_ATTRIBUTE1%TYPE
57 ,cust_attribute2 OKL_EXT_FA_HEADER_SOURCES_V.CUST_ATTRIBUTE2%TYPE
58 ,cust_attribute3 OKL_EXT_FA_HEADER_SOURCES_V.CUST_ATTRIBUTE3%TYPE
59 ,cust_attribute4 OKL_EXT_FA_HEADER_SOURCES_V.CUST_ATTRIBUTE4%TYPE
60 ,cust_attribute5 OKL_EXT_FA_HEADER_SOURCES_V.CUST_ATTRIBUTE5%TYPE
61 ,cust_attribute6 OKL_EXT_FA_HEADER_SOURCES_V.CUST_ATTRIBUTE6%TYPE
62 ,cust_attribute7 OKL_EXT_FA_HEADER_SOURCES_V.CUST_ATTRIBUTE7%TYPE
63 ,cust_attribute8 OKL_EXT_FA_HEADER_SOURCES_V.CUST_ATTRIBUTE8%TYPE
64 ,cust_attribute9 OKL_EXT_FA_HEADER_SOURCES_V.CUST_ATTRIBUTE9%TYPE
65 ,cust_attribute10 OKL_EXT_FA_HEADER_SOURCES_V.CUST_ATTRIBUTE10%TYPE
66 ,cust_attribute11 OKL_EXT_FA_HEADER_SOURCES_V.CUST_ATTRIBUTE11%TYPE
67 ,cust_attribute12 OKL_EXT_FA_HEADER_SOURCES_V.CUST_ATTRIBUTE12%TYPE
68 ,cust_attribute13 OKL_EXT_FA_HEADER_SOURCES_V.CUST_ATTRIBUTE13%TYPE
69 ,cust_attribute14 OKL_EXT_FA_HEADER_SOURCES_V.CUST_ATTRIBUTE14%TYPE
70 ,cust_attribute15 OKL_EXT_FA_HEADER_SOURCES_V.CUST_ATTRIBUTE15%TYPE
71 ,rev_rec_method_code OKL_EXT_FA_HEADER_SOURCES_V.REV_REC_METHOD_CODE%TYPE
72 ,int_calc_method_code OKL_EXT_FA_HEADER_SOURCES_V.INT_CALC_METHOD_CODE%TYPE
73 ,language OKL_EXT_FA_HEADER_SOURCES_V.LANGUAGE%TYPE
74 ,contract_status OKL_EXT_FA_HEADER_SOURCES_V.CONTRACT_STATUS%TYPE
75 ,transaction_type_name OKL_EXT_FA_HEADER_SOURCES_V.TRANSACTION_TYPE_NAME%TYPE
76 ,created_by NUMBER
77 ,creation_date OKL_EXT_FA_HEADER_SOURCES_V.CREATION_DATE%TYPE
78 ,last_updated_by NUMBER
79 ,last_update_date OKL_EXT_FA_HEADER_SOURCES_V.LAST_UPDATE_DATE%TYPE
80 ,last_update_login NUMBER
81 ,contract_status_code OKL_EXT_FA_HEADER_SOURCES_V.CONTRACT_STATUS_CODE%TYPE
82 ,trx_type_class_code OKL_EXT_FA_HEADER_SOURCES_V.TRX_TYPE_CLASS_CODE%TYPE
83 ,term_quote_accept_date OKL_EXT_FA_HEADER_SOURCES_V.TERM_QUOTE_ACCEPT_DATE%TYPE
84 ,term_quote_num OKL_EXT_FA_HEADER_SOURCES_V.TERM_QUOTE_NUM%TYPE
85 ,term_quote_type_code OKL_EXT_FA_HEADER_SOURCES_V.TERM_QUOTE_TYPE_CODE%TYPE
86 ,repossess_flag OKL_EXT_FA_HEADER_SOURCES_V.REPOSSESS_FLAG%TYPE
87 ,party_id OKL_EXT_FA_HEADER_SOURCES_V.PARTY_ID%TYPE
88 ,cust_account_id OKL_EXT_FA_HEADER_SOURCES_V.CUST_ACCOUNT_ID%TYPE);
89 G_MISS_fxhv_rec fxhv_rec_type;
90 TYPE fxhv_tbl_type IS TABLE OF fxhv_rec_type
91 INDEX BY BINARY_INTEGER;
92 -- OKL_EXT_FA_HEADER_SOURCES_TL Record Spec
93 TYPE fxhl_rec_type IS RECORD (
94 header_extension_id NUMBER
95 ,language OKL_EXT_FA_HEADER_SOURCES_TL.LANGUAGE%TYPE
96 ,source_lang OKL_EXT_FA_HEADER_SOURCES_TL.SOURCE_LANG%TYPE
97 ,sfwt_flag OKL_EXT_FA_HEADER_SOURCES_TL.SFWT_FLAG%TYPE
98 ,contract_status OKL_EXT_FA_HEADER_SOURCES_TL.CONTRACT_STATUS%TYPE
99 ,transaction_type_name OKL_EXT_FA_HEADER_SOURCES_TL.TRANSACTION_TYPE_NAME%TYPE
100 ,created_by NUMBER
101 ,creation_date OKL_EXT_FA_HEADER_SOURCES_TL.CREATION_DATE%TYPE
102 ,last_updated_by NUMBER
103 ,last_update_date OKL_EXT_FA_HEADER_SOURCES_TL.LAST_UPDATE_DATE%TYPE
104 ,last_update_login NUMBER);
105 G_MISS_fxhl_rec fxhl_rec_type;
106 TYPE fxhl_tbl_type IS TABLE OF fxhl_rec_type
107 INDEX BY BINARY_INTEGER;
108 -- OKL_EXT_FA_HEADER_SOURCES_B Record Spec
109 TYPE fxh_rec_type IS RECORD (
110 header_extension_id NUMBER
111 ,source_id NUMBER
112 ,source_table OKL_EXT_FA_HEADER_SOURCES_B.SOURCE_TABLE%TYPE
113 ,object_version_number NUMBER
114 ,trans_number NUMBER
115 ,khr_id NUMBER
116 ,try_id NUMBER
117 ,contract_number OKL_EXT_FA_HEADER_SOURCES_B.CONTRACT_NUMBER%TYPE
118 ,customer_name OKL_EXT_FA_HEADER_SOURCES_B.CUSTOMER_NAME%TYPE
119 ,customer_account_number OKL_EXT_FA_HEADER_SOURCES_B.CUSTOMER_ACCOUNT_NUMBER%TYPE
120 ,book_classification_code OKL_EXT_FA_HEADER_SOURCES_B.BOOK_CLASSIFICATION_CODE%TYPE
121 ,product_name OKL_EXT_FA_HEADER_SOURCES_B.PRODUCT_NAME%TYPE
122 ,tax_owner_code OKL_EXT_FA_HEADER_SOURCES_B.TAX_OWNER_CODE%TYPE
123 ,representation_code OKL_EXT_FA_HEADER_SOURCES_B.REPRESENTATION_CODE%TYPE
124 ,representation_name OKL_EXT_FA_HEADER_SOURCES_B.REPRESENTATION_NAME%TYPE
125 ,rent_ia_contract_number OKL_EXT_FA_HEADER_SOURCES_B.RENT_IA_CONTRACT_NUMBER%TYPE
126 ,res_ia_contract_number OKL_EXT_FA_HEADER_SOURCES_B.RES_IA_CONTRACT_NUMBER%TYPE
127 ,converted_number OKL_EXT_FA_HEADER_SOURCES_B.CONVERTED_NUMBER%TYPE
128 ,contract_effective_from OKL_EXT_FA_HEADER_SOURCES_B.CONTRACT_EFFECTIVE_FROM%TYPE
129 ,contract_currency_code OKL_EXT_FA_HEADER_SOURCES_B.CONTRACT_CURRENCY_CODE%TYPE
130 ,sales_rep_name OKL_EXT_FA_HEADER_SOURCES_B.SALES_REP_NAME%TYPE
131 ,rent_ia_product_name OKL_EXT_FA_HEADER_SOURCES_B.RENT_IA_PRODUCT_NAME%TYPE
132 ,res_ia_product_name OKL_EXT_FA_HEADER_SOURCES_B.RES_IA_PRODUCT_NAME%TYPE
133 ,po_order_number OKL_EXT_FA_HEADER_SOURCES_B.PO_ORDER_NUMBER%TYPE
134 ,vendor_program_number OKL_EXT_FA_HEADER_SOURCES_B.VENDOR_PROGRAM_NUMBER%TYPE
135 ,rent_ia_accounting_code OKL_EXT_FA_HEADER_SOURCES_B.RENT_IA_ACCOUNTING_CODE%TYPE
136 ,res_ia_accounting_code OKL_EXT_FA_HEADER_SOURCES_B.RES_IA_ACCOUNTING_CODE%TYPE
137 ,assignable_flag OKL_EXT_FA_HEADER_SOURCES_B.ASSIGNABLE_FLAG%TYPE
138 ,converted_account_flag OKL_EXT_FA_HEADER_SOURCES_B.CONVERTED_ACCOUNT_FLAG%TYPE
139 ,accrual_override_flag OKL_EXT_FA_HEADER_SOURCES_B.ACCRUAL_OVERRIDE_FLAG%TYPE
140 ,khr_attribute_category OKL_EXT_FA_HEADER_SOURCES_B.KHR_ATTRIBUTE_CATEGORY%TYPE
141 ,khr_attribute1 OKL_EXT_FA_HEADER_SOURCES_B.KHR_ATTRIBUTE1%TYPE
142 ,khr_attribute2 OKL_EXT_FA_HEADER_SOURCES_B.KHR_ATTRIBUTE2%TYPE
143 ,khr_attribute3 OKL_EXT_FA_HEADER_SOURCES_B.KHR_ATTRIBUTE3%TYPE
144 ,khr_attribute4 OKL_EXT_FA_HEADER_SOURCES_B.KHR_ATTRIBUTE4%TYPE
145 ,khr_attribute5 OKL_EXT_FA_HEADER_SOURCES_B.KHR_ATTRIBUTE5%TYPE
146 ,khr_attribute6 OKL_EXT_FA_HEADER_SOURCES_B.KHR_ATTRIBUTE6%TYPE
147 ,khr_attribute7 OKL_EXT_FA_HEADER_SOURCES_B.KHR_ATTRIBUTE7%TYPE
148 ,khr_attribute8 OKL_EXT_FA_HEADER_SOURCES_B.KHR_ATTRIBUTE8%TYPE
149 ,khr_attribute9 OKL_EXT_FA_HEADER_SOURCES_B.KHR_ATTRIBUTE9%TYPE
150 ,khr_attribute10 OKL_EXT_FA_HEADER_SOURCES_B.KHR_ATTRIBUTE10%TYPE
151 ,khr_attribute11 OKL_EXT_FA_HEADER_SOURCES_B.KHR_ATTRIBUTE11%TYPE
152 ,khr_attribute12 OKL_EXT_FA_HEADER_SOURCES_B.KHR_ATTRIBUTE12%TYPE
153 ,khr_attribute13 OKL_EXT_FA_HEADER_SOURCES_B.KHR_ATTRIBUTE13%TYPE
154 ,khr_attribute14 OKL_EXT_FA_HEADER_SOURCES_B.KHR_ATTRIBUTE14%TYPE
155 ,khr_attribute15 OKL_EXT_FA_HEADER_SOURCES_B.KHR_ATTRIBUTE15%TYPE
156 ,cust_attribute_category OKL_EXT_FA_HEADER_SOURCES_B.CUST_ATTRIBUTE_CATEGORY%TYPE
157 ,cust_attribute1 OKL_EXT_FA_HEADER_SOURCES_B.CUST_ATTRIBUTE1%TYPE
158 ,cust_attribute2 OKL_EXT_FA_HEADER_SOURCES_B.CUST_ATTRIBUTE2%TYPE
159 ,cust_attribute3 OKL_EXT_FA_HEADER_SOURCES_B.CUST_ATTRIBUTE3%TYPE
160 ,cust_attribute4 OKL_EXT_FA_HEADER_SOURCES_B.CUST_ATTRIBUTE4%TYPE
161 ,cust_attribute5 OKL_EXT_FA_HEADER_SOURCES_B.CUST_ATTRIBUTE5%TYPE
162 ,cust_attribute6 OKL_EXT_FA_HEADER_SOURCES_B.CUST_ATTRIBUTE6%TYPE
166 ,cust_attribute10 OKL_EXT_FA_HEADER_SOURCES_B.CUST_ATTRIBUTE10%TYPE
163 ,cust_attribute7 OKL_EXT_FA_HEADER_SOURCES_B.CUST_ATTRIBUTE7%TYPE
164 ,cust_attribute8 OKL_EXT_FA_HEADER_SOURCES_B.CUST_ATTRIBUTE8%TYPE
165 ,cust_attribute9 OKL_EXT_FA_HEADER_SOURCES_B.CUST_ATTRIBUTE9%TYPE
167 ,cust_attribute11 OKL_EXT_FA_HEADER_SOURCES_B.CUST_ATTRIBUTE11%TYPE
168 ,cust_attribute12 OKL_EXT_FA_HEADER_SOURCES_B.CUST_ATTRIBUTE12%TYPE
169 ,cust_attribute13 OKL_EXT_FA_HEADER_SOURCES_B.CUST_ATTRIBUTE13%TYPE
170 ,cust_attribute14 OKL_EXT_FA_HEADER_SOURCES_B.CUST_ATTRIBUTE14%TYPE
171 ,cust_attribute15 OKL_EXT_FA_HEADER_SOURCES_B.CUST_ATTRIBUTE15%TYPE
172 ,rev_rec_method_code OKL_EXT_FA_HEADER_SOURCES_B.REV_REC_METHOD_CODE%TYPE
173 ,int_calc_method_code OKL_EXT_FA_HEADER_SOURCES_B.INT_CALC_METHOD_CODE%TYPE
174 ,created_by NUMBER
175 ,creation_date OKL_EXT_FA_HEADER_SOURCES_B.CREATION_DATE%TYPE
176 ,last_updated_by NUMBER
177 ,last_update_date OKL_EXT_FA_HEADER_SOURCES_B.LAST_UPDATE_DATE%TYPE
178 ,last_update_login NUMBER
179 ,contract_status_code OKL_EXT_FA_HEADER_SOURCES_B.CONTRACT_STATUS_CODE%TYPE
180 ,trx_type_class_code OKL_EXT_FA_HEADER_SOURCES_B.TRX_TYPE_CLASS_CODE%TYPE
181 ,term_quote_accept_date OKL_EXT_FA_HEADER_SOURCES_B.TERM_QUOTE_ACCEPT_DATE%TYPE
182 ,term_quote_num OKL_EXT_FA_HEADER_SOURCES_B.TERM_QUOTE_NUM%TYPE
183 ,term_quote_type_code OKL_EXT_FA_HEADER_SOURCES_B.TERM_QUOTE_TYPE_CODE%TYPE
184 ,repossess_flag OKL_EXT_FA_HEADER_SOURCES_B.REPOSSESS_FLAG%TYPE
185 ,party_id OKL_EXT_FA_HEADER_SOURCES_B.PARTY_ID%TYPE
186 ,cust_account_id OKL_EXT_FA_HEADER_SOURCES_B.CUST_ACCOUNT_ID%TYPE);
187 G_MISS_fxh_rec fxh_rec_type;
188 TYPE fxh_tbl_type IS TABLE OF fxh_rec_type
189 INDEX BY BINARY_INTEGER;
190 ---------------------------------------------------------------------------
191 -- GLOBAL MESSAGE CONSTANTS
192 ---------------------------------------------------------------------------
193 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
194 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
195 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
196 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
197 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
198 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
199 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
200 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
201 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
202 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
203 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
204 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
205 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
206
207 ---------------------------------------------------------------------------
208 -- GLOBAL EXCEPTIONS
209 ---------------------------------------------------------------------------
210 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
211
212 ---------------------------------------------------------------------------
213 -- GLOBAL VARIABLES
214 ---------------------------------------------------------------------------
215 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_FXH_PVT';
216 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
217 ---------------------------------------------------------------------------
218 -- Procedures and Functions
219 ---------------------------------------------------------------------------
220
221 PROCEDURE qc;
222 PROCEDURE change_version;
223 PROCEDURE api_copy;
224 PROCEDURE add_language;
225 PROCEDURE insert_row(
226 p_api_version IN NUMBER,
227 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
228 x_return_status OUT NOCOPY VARCHAR2,
229 x_msg_count OUT NOCOPY NUMBER,
230 x_msg_data OUT NOCOPY VARCHAR2,
231 p_fxhv_rec IN fxhv_rec_type,
232 x_fxhv_rec OUT NOCOPY fxhv_rec_type);
233 PROCEDURE insert_row(
234 p_api_version IN NUMBER,
235 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_fxhv_tbl IN fxhv_tbl_type,
240 x_fxhv_tbl OUT NOCOPY fxhv_tbl_type,
241 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
242 PROCEDURE insert_row(
243 p_api_version IN NUMBER,
244 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
245 x_return_status OUT NOCOPY VARCHAR2,
246 x_msg_count OUT NOCOPY NUMBER,
247 x_msg_data OUT NOCOPY VARCHAR2,
248 p_fxhv_tbl IN fxhv_tbl_type,
249 x_fxhv_tbl OUT NOCOPY fxhv_tbl_type);
250 PROCEDURE lock_row(
251 p_api_version IN NUMBER,
252 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
253 x_return_status OUT NOCOPY VARCHAR2,
254 x_msg_count OUT NOCOPY NUMBER,
255 x_msg_data OUT NOCOPY VARCHAR2,
259 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
256 p_fxhv_rec IN fxhv_rec_type);
257 PROCEDURE lock_row(
258 p_api_version IN NUMBER,
260 x_return_status OUT NOCOPY VARCHAR2,
261 x_msg_count OUT NOCOPY NUMBER,
262 x_msg_data OUT NOCOPY VARCHAR2,
263 p_fxhv_tbl IN fxhv_tbl_type,
264 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
265 PROCEDURE lock_row(
266 p_api_version IN NUMBER,
267 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
268 x_return_status OUT NOCOPY VARCHAR2,
269 x_msg_count OUT NOCOPY NUMBER,
270 x_msg_data OUT NOCOPY VARCHAR2,
271 p_fxhv_tbl IN fxhv_tbl_type);
272 PROCEDURE update_row(
273 p_api_version IN NUMBER,
274 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_fxhv_rec IN fxhv_rec_type,
279 x_fxhv_rec OUT NOCOPY fxhv_rec_type);
280 PROCEDURE update_row(
281 p_api_version IN NUMBER,
282 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
283 x_return_status OUT NOCOPY VARCHAR2,
284 x_msg_count OUT NOCOPY NUMBER,
285 x_msg_data OUT NOCOPY VARCHAR2,
286 p_fxhv_tbl IN fxhv_tbl_type,
287 x_fxhv_tbl OUT NOCOPY fxhv_tbl_type,
288 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
289 PROCEDURE update_row(
290 p_api_version IN NUMBER,
291 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
292 x_return_status OUT NOCOPY VARCHAR2,
293 x_msg_count OUT NOCOPY NUMBER,
294 x_msg_data OUT NOCOPY VARCHAR2,
295 p_fxhv_tbl IN fxhv_tbl_type,
296 x_fxhv_tbl OUT NOCOPY fxhv_tbl_type);
297 PROCEDURE delete_row(
298 p_api_version IN NUMBER,
299 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
300 x_return_status OUT NOCOPY VARCHAR2,
301 x_msg_count OUT NOCOPY NUMBER,
302 x_msg_data OUT NOCOPY VARCHAR2,
303 p_fxhv_rec IN fxhv_rec_type);
304 PROCEDURE delete_row(
305 p_api_version IN NUMBER,
306 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
307 x_return_status OUT NOCOPY VARCHAR2,
308 x_msg_count OUT NOCOPY NUMBER,
309 x_msg_data OUT NOCOPY VARCHAR2,
310 p_fxhv_tbl IN fxhv_tbl_type,
311 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
312 PROCEDURE delete_row(
313 p_api_version IN NUMBER,
314 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
315 x_return_status OUT NOCOPY VARCHAR2,
316 x_msg_count OUT NOCOPY NUMBER,
317 x_msg_data OUT NOCOPY VARCHAR2,
318 p_fxhv_tbl IN fxhv_tbl_type);
319 PROCEDURE validate_row(
320 p_api_version IN NUMBER,
321 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
322 x_return_status OUT NOCOPY VARCHAR2,
323 x_msg_count OUT NOCOPY NUMBER,
324 x_msg_data OUT NOCOPY VARCHAR2,
325 p_fxhv_rec IN fxhv_rec_type);
326 PROCEDURE validate_row(
327 p_api_version IN NUMBER,
328 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
329 x_return_status OUT NOCOPY VARCHAR2,
330 x_msg_count OUT NOCOPY NUMBER,
331 x_msg_data OUT NOCOPY VARCHAR2,
332 p_fxhv_tbl IN fxhv_tbl_type,
333 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
334 PROCEDURE validate_row(
335 p_api_version IN NUMBER,
336 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
337 x_return_status OUT NOCOPY VARCHAR2,
338 x_msg_count OUT NOCOPY NUMBER,
339 x_msg_data OUT NOCOPY VARCHAR2,
340 p_fxhv_tbl IN fxhv_tbl_type);
341 -- Added : Bug# 6268782 : PRASJAIN
342 PROCEDURE insert_row(
343 p_api_version IN NUMBER,
344 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
345 x_return_status OUT NOCOPY VARCHAR2,
346 x_msg_count OUT NOCOPY NUMBER,
347 x_msg_data OUT NOCOPY VARCHAR2,
348 p_fxh_rec IN fxh_rec_type,
349 p_fxhl_tbl IN fxhl_tbl_type,
350 x_fxh_rec OUT NOCOPY fxh_rec_type,
351 x_fxhl_tbl OUT NOCOPY fxhl_tbl_type);
352 END OKL_FXH_PVT;
353 --SHOW ERRORS;