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