[Home] [Help]
PACKAGE: APPS.OKL_PXH_PVT
Source
1 PACKAGE OKL_PXH_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSPXHS.pls 120.3 2007/12/27 14:23:29 zrehman noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKL_EXT_AP_HEADER_SOURCES_V Record Spec
7 TYPE pxhv_rec_type IS RECORD (
8 header_extension_id NUMBER
9 ,source_id NUMBER
10 ,source_table OKL_EXT_AP_HEADER_SOURCES_V.SOURCE_TABLE%TYPE
11 ,object_version_number NUMBER
12 ,khr_id NUMBER
13 ,try_id NUMBER
14 ,trans_number OKL_EXT_AP_HEADER_SOURCES_V.TRANS_NUMBER%TYPE
15 ,contract_number OKL_EXT_AP_HEADER_SOURCES_V.CONTRACT_NUMBER%TYPE
16 ,customer_name OKL_EXT_AP_HEADER_SOURCES_V.CUSTOMER_NAME%TYPE
17 ,cust_account_number OKL_EXT_AP_HEADER_SOURCES_V.CUST_ACCOUNT_NUMBER%TYPE
18 ,product_name OKL_EXT_AP_HEADER_SOURCES_V.PRODUCT_NAME%TYPE
19 ,book_classification_code OKL_EXT_AP_HEADER_SOURCES_V.BOOK_CLASSIFICATION_CODE%TYPE
20 ,tax_owner_code OKL_EXT_AP_HEADER_SOURCES_V.TAX_OWNER_CODE%TYPE
21 ,int_calc_method_code OKL_EXT_AP_HEADER_SOURCES_V.INT_CALC_METHOD_CODE%TYPE
22 ,rev_rec_method_code OKL_EXT_AP_HEADER_SOURCES_V.REV_REC_METHOD_CODE%TYPE
23 ,scs_code OKL_EXT_AP_HEADER_SOURCES_V.SCS_CODE%TYPE
24 ,converted_number OKL_EXT_AP_HEADER_SOURCES_V.CONVERTED_NUMBER%TYPE
25 ,contract_effective_from OKL_EXT_AP_HEADER_SOURCES_V.CONTRACT_EFFECTIVE_FROM%TYPE
26 ,contract_currency_code OKL_EXT_AP_HEADER_SOURCES_V.CONTRACT_CURRENCY_CODE%TYPE
27 ,sales_rep_name OKL_EXT_AP_HEADER_SOURCES_V.SALES_REP_NAME%TYPE
28 ,po_order_number OKL_EXT_AP_HEADER_SOURCES_V.PO_ORDER_NUMBER%TYPE
29 ,vendor_program_number OKL_EXT_AP_HEADER_SOURCES_V.VENDOR_PROGRAM_NUMBER%TYPE
30 ,assignable_flag OKL_EXT_AP_HEADER_SOURCES_V.ASSIGNABLE_FLAG%TYPE
31 ,converted_account_flag OKL_EXT_AP_HEADER_SOURCES_V.CONVERTED_ACCOUNT_FLAG%TYPE
32 ,accrual_override_flag OKL_EXT_AP_HEADER_SOURCES_V.ACCRUAL_OVERRIDE_FLAG%TYPE
33 ,khr_attribute_category OKL_EXT_AP_HEADER_SOURCES_V.KHR_ATTRIBUTE_CATEGORY%TYPE
34 ,khr_attribute1 OKL_EXT_AP_HEADER_SOURCES_V.KHR_ATTRIBUTE1%TYPE
35 ,khr_attribute2 OKL_EXT_AP_HEADER_SOURCES_V.KHR_ATTRIBUTE2%TYPE
36 ,khr_attribute3 OKL_EXT_AP_HEADER_SOURCES_V.KHR_ATTRIBUTE3%TYPE
37 ,khr_attribute4 OKL_EXT_AP_HEADER_SOURCES_V.KHR_ATTRIBUTE4%TYPE
38 ,khr_attribute5 OKL_EXT_AP_HEADER_SOURCES_V.KHR_ATTRIBUTE5%TYPE
39 ,khr_attribute6 OKL_EXT_AP_HEADER_SOURCES_V.KHR_ATTRIBUTE6%TYPE
40 ,khr_attribute7 OKL_EXT_AP_HEADER_SOURCES_V.KHR_ATTRIBUTE7%TYPE
41 ,khr_attribute8 OKL_EXT_AP_HEADER_SOURCES_V.KHR_ATTRIBUTE8%TYPE
42 ,khr_attribute9 OKL_EXT_AP_HEADER_SOURCES_V.KHR_ATTRIBUTE9%TYPE
43 ,khr_attribute10 OKL_EXT_AP_HEADER_SOURCES_V.KHR_ATTRIBUTE10%TYPE
44 ,khr_attribute11 OKL_EXT_AP_HEADER_SOURCES_V.KHR_ATTRIBUTE11%TYPE
45 ,khr_attribute12 OKL_EXT_AP_HEADER_SOURCES_V.KHR_ATTRIBUTE12%TYPE
46 ,khr_attribute13 OKL_EXT_AP_HEADER_SOURCES_V.KHR_ATTRIBUTE13%TYPE
47 ,khr_attribute14 OKL_EXT_AP_HEADER_SOURCES_V.KHR_ATTRIBUTE14%TYPE
48 ,khr_attribute15 OKL_EXT_AP_HEADER_SOURCES_V.KHR_ATTRIBUTE15%TYPE
49 ,cust_attribute_category OKL_EXT_AP_HEADER_SOURCES_V.CUST_ATTRIBUTE_CATEGORY%TYPE
50 ,cust_attribute1 OKL_EXT_AP_HEADER_SOURCES_V.CUST_ATTRIBUTE1%TYPE
51 ,cust_attribute2 OKL_EXT_AP_HEADER_SOURCES_V.CUST_ATTRIBUTE2%TYPE
52 ,cust_attribute3 OKL_EXT_AP_HEADER_SOURCES_V.CUST_ATTRIBUTE3%TYPE
53 ,cust_attribute4 OKL_EXT_AP_HEADER_SOURCES_V.CUST_ATTRIBUTE4%TYPE
54 ,cust_attribute5 OKL_EXT_AP_HEADER_SOURCES_V.CUST_ATTRIBUTE5%TYPE
55 ,cust_attribute6 OKL_EXT_AP_HEADER_SOURCES_V.CUST_ATTRIBUTE6%TYPE
56 ,cust_attribute7 OKL_EXT_AP_HEADER_SOURCES_V.CUST_ATTRIBUTE7%TYPE
57 ,cust_attribute8 OKL_EXT_AP_HEADER_SOURCES_V.CUST_ATTRIBUTE8%TYPE
58 ,cust_attribute9 OKL_EXT_AP_HEADER_SOURCES_V.CUST_ATTRIBUTE9%TYPE
59 ,cust_attribute10 OKL_EXT_AP_HEADER_SOURCES_V.CUST_ATTRIBUTE10%TYPE
60 ,cust_attribute11 OKL_EXT_AP_HEADER_SOURCES_V.CUST_ATTRIBUTE11%TYPE
61 ,cust_attribute12 OKL_EXT_AP_HEADER_SOURCES_V.CUST_ATTRIBUTE12%TYPE
62 ,cust_attribute13 OKL_EXT_AP_HEADER_SOURCES_V.CUST_ATTRIBUTE13%TYPE
63 ,cust_attribute14 OKL_EXT_AP_HEADER_SOURCES_V.CUST_ATTRIBUTE14%TYPE
64 ,cust_attribute15 OKL_EXT_AP_HEADER_SOURCES_V.CUST_ATTRIBUTE15%TYPE
65 ,rent_ia_contract_number OKL_EXT_AP_HEADER_SOURCES_V.RENT_IA_CONTRACT_NUMBER%TYPE
66 ,rent_ia_product_name OKL_EXT_AP_HEADER_SOURCES_V.RENT_IA_PRODUCT_NAME%TYPE
67 ,rent_ia_accounting_code OKL_EXT_AP_HEADER_SOURCES_V.RENT_IA_ACCOUNTING_CODE%TYPE
68 ,res_ia_contract_number OKL_EXT_AP_HEADER_SOURCES_V.RES_IA_CONTRACT_NUMBER%TYPE
69 ,res_ia_product_name OKL_EXT_AP_HEADER_SOURCES_V.RES_IA_PRODUCT_NAME%TYPE
70 ,res_ia_accounting_code OKL_EXT_AP_HEADER_SOURCES_V.RES_IA_ACCOUNTING_CODE%TYPE
71 ,inv_agrmnt_number OKL_EXT_AP_HEADER_SOURCES_V.INV_AGRMNT_NUMBER%TYPE
72 ,inv_agrmnt_effective_from OKL_EXT_AP_HEADER_SOURCES_V.INV_AGRMNT_EFFECTIVE_FROM%TYPE
73 ,inv_agrmnt_product_name OKL_EXT_AP_HEADER_SOURCES_V.INV_AGRMNT_PRODUCT_NAME%TYPE
74 ,inv_agrmnt_currency_code OKL_EXT_AP_HEADER_SOURCES_V.INV_AGRMNT_CURRENCY_CODE%TYPE
75 ,inv_agrmnt_synd_code OKL_EXT_AP_HEADER_SOURCES_V.INV_AGRMNT_SYND_CODE%TYPE
76 ,inv_agrmnt_pool_number OKL_EXT_AP_HEADER_SOURCES_V.INV_AGRMNT_POOL_NUMBER%TYPE
77 ,contract_status_code OKL_EXT_AP_HEADER_SOURCES_V.CONTRACT_STATUS_CODE%TYPE
78 ,inv_agrmnt_status_code OKL_EXT_AP_HEADER_SOURCES_V.INV_AGRMNT_STATUS_CODE%TYPE
79 ,trx_type_class_code OKL_EXT_AP_HEADER_SOURCES_V.TRX_TYPE_CLASS_CODE%TYPE
80 ,language OKL_EXT_AP_HEADER_SOURCES_V.LANGUAGE%TYPE
81 ,contract_status OKL_EXT_AP_HEADER_SOURCES_V.CONTRACT_STATUS%TYPE
82 ,inv_agrmnt_status OKL_EXT_AP_HEADER_SOURCES_V.INV_AGRMNT_STATUS%TYPE
83 ,transaction_type_name OKL_EXT_AP_HEADER_SOURCES_V.TRANSACTION_TYPE_NAME%TYPE
84 ,created_by NUMBER
85 ,creation_date OKL_EXT_AP_HEADER_SOURCES_V.CREATION_DATE%TYPE
86 ,last_updated_by NUMBER
87 ,last_update_date OKL_EXT_AP_HEADER_SOURCES_V.LAST_UPDATE_DATE%TYPE
88 ,last_update_login NUMBER
89 -- added by zrehman Bug#6707320 for Party Merge impact on Accounting sources tables start
90 ,party_id OKL_EXT_AP_HEADER_SOURCES_V.PARTY_ID%TYPE
91 ,cust_account_id OKL_EXT_AP_HEADER_SOURCES_V.CUST_ACCOUNT_ID%TYPE
92 -- added by zrehman Bug#6707320 for Party Merge impact on Accounting sources tables end
93 );
94 G_MISS_pxhv_rec pxhv_rec_type;
95 TYPE pxhv_tbl_type IS TABLE OF pxhv_rec_type
96 INDEX BY BINARY_INTEGER;
97 -- OKL_EXT_AP_HEADER_SOURCES_B Record Spec
98 TYPE pxh_rec_type IS RECORD (
99 header_extension_id NUMBER
100 ,source_id NUMBER
101 ,source_table OKL_EXT_AP_HEADER_SOURCES_B.SOURCE_TABLE%TYPE
102 ,object_version_number NUMBER
103 ,khr_id NUMBER
104 ,try_id NUMBER
105 ,trans_number OKL_EXT_AP_HEADER_SOURCES_B.TRANS_NUMBER%TYPE
106 ,contract_number OKL_EXT_AP_HEADER_SOURCES_B.CONTRACT_NUMBER%TYPE
107 ,customer_name OKL_EXT_AP_HEADER_SOURCES_B.CUSTOMER_NAME%TYPE
108 ,cust_account_number OKL_EXT_AP_HEADER_SOURCES_B.CUST_ACCOUNT_NUMBER%TYPE
109 ,product_name OKL_EXT_AP_HEADER_SOURCES_B.PRODUCT_NAME%TYPE
110 ,book_classification_code OKL_EXT_AP_HEADER_SOURCES_B.BOOK_CLASSIFICATION_CODE%TYPE
111 ,tax_owner_code OKL_EXT_AP_HEADER_SOURCES_B.TAX_OWNER_CODE%TYPE
112 ,int_calc_method_code OKL_EXT_AP_HEADER_SOURCES_B.INT_CALC_METHOD_CODE%TYPE
113 ,rev_rec_method_code OKL_EXT_AP_HEADER_SOURCES_B.REV_REC_METHOD_CODE%TYPE
114 ,scs_code OKL_EXT_AP_HEADER_SOURCES_B.SCS_CODE%TYPE
115 ,converted_number OKL_EXT_AP_HEADER_SOURCES_B.CONVERTED_NUMBER%TYPE
116 ,contract_effective_from OKL_EXT_AP_HEADER_SOURCES_B.CONTRACT_EFFECTIVE_FROM%TYPE
117 ,contract_currency_code OKL_EXT_AP_HEADER_SOURCES_B.CONTRACT_CURRENCY_CODE%TYPE
118 ,sales_rep_name OKL_EXT_AP_HEADER_SOURCES_B.SALES_REP_NAME%TYPE
119 ,po_order_number OKL_EXT_AP_HEADER_SOURCES_B.PO_ORDER_NUMBER%TYPE
120 ,vendor_program_number OKL_EXT_AP_HEADER_SOURCES_B.VENDOR_PROGRAM_NUMBER%TYPE
121 ,assignable_flag OKL_EXT_AP_HEADER_SOURCES_B.ASSIGNABLE_FLAG%TYPE
122 ,converted_account_flag OKL_EXT_AP_HEADER_SOURCES_B.CONVERTED_ACCOUNT_FLAG%TYPE
123 ,accrual_override_flag OKL_EXT_AP_HEADER_SOURCES_B.ACCRUAL_OVERRIDE_FLAG%TYPE
124 ,khr_attribute_category OKL_EXT_AP_HEADER_SOURCES_B.KHR_ATTRIBUTE_CATEGORY%TYPE
125 ,khr_attribute1 OKL_EXT_AP_HEADER_SOURCES_B.KHR_ATTRIBUTE1%TYPE
126 ,khr_attribute2 OKL_EXT_AP_HEADER_SOURCES_B.KHR_ATTRIBUTE2%TYPE
127 ,khr_attribute3 OKL_EXT_AP_HEADER_SOURCES_B.KHR_ATTRIBUTE3%TYPE
128 ,khr_attribute4 OKL_EXT_AP_HEADER_SOURCES_B.KHR_ATTRIBUTE4%TYPE
129 ,khr_attribute5 OKL_EXT_AP_HEADER_SOURCES_B.KHR_ATTRIBUTE5%TYPE
130 ,khr_attribute6 OKL_EXT_AP_HEADER_SOURCES_B.KHR_ATTRIBUTE6%TYPE
131 ,khr_attribute7 OKL_EXT_AP_HEADER_SOURCES_B.KHR_ATTRIBUTE7%TYPE
132 ,khr_attribute8 OKL_EXT_AP_HEADER_SOURCES_B.KHR_ATTRIBUTE8%TYPE
133 ,khr_attribute9 OKL_EXT_AP_HEADER_SOURCES_B.KHR_ATTRIBUTE9%TYPE
134 ,khr_attribute10 OKL_EXT_AP_HEADER_SOURCES_B.KHR_ATTRIBUTE10%TYPE
135 ,khr_attribute11 OKL_EXT_AP_HEADER_SOURCES_B.KHR_ATTRIBUTE11%TYPE
136 ,khr_attribute12 OKL_EXT_AP_HEADER_SOURCES_B.KHR_ATTRIBUTE12%TYPE
137 ,khr_attribute13 OKL_EXT_AP_HEADER_SOURCES_B.KHR_ATTRIBUTE13%TYPE
138 ,khr_attribute14 OKL_EXT_AP_HEADER_SOURCES_B.KHR_ATTRIBUTE14%TYPE
139 ,khr_attribute15 OKL_EXT_AP_HEADER_SOURCES_B.KHR_ATTRIBUTE15%TYPE
140 ,cust_attribute_category OKL_EXT_AP_HEADER_SOURCES_B.CUST_ATTRIBUTE_CATEGORY%TYPE
141 ,cust_attribute1 OKL_EXT_AP_HEADER_SOURCES_B.CUST_ATTRIBUTE1%TYPE
142 ,cust_attribute2 OKL_EXT_AP_HEADER_SOURCES_B.CUST_ATTRIBUTE2%TYPE
143 ,cust_attribute3 OKL_EXT_AP_HEADER_SOURCES_B.CUST_ATTRIBUTE3%TYPE
144 ,cust_attribute4 OKL_EXT_AP_HEADER_SOURCES_B.CUST_ATTRIBUTE4%TYPE
145 ,cust_attribute5 OKL_EXT_AP_HEADER_SOURCES_B.CUST_ATTRIBUTE5%TYPE
146 ,cust_attribute6 OKL_EXT_AP_HEADER_SOURCES_B.CUST_ATTRIBUTE6%TYPE
147 ,cust_attribute7 OKL_EXT_AP_HEADER_SOURCES_B.CUST_ATTRIBUTE7%TYPE
148 ,cust_attribute8 OKL_EXT_AP_HEADER_SOURCES_B.CUST_ATTRIBUTE8%TYPE
149 ,cust_attribute9 OKL_EXT_AP_HEADER_SOURCES_B.CUST_ATTRIBUTE9%TYPE
150 ,cust_attribute10 OKL_EXT_AP_HEADER_SOURCES_B.CUST_ATTRIBUTE10%TYPE
151 ,cust_attribute11 OKL_EXT_AP_HEADER_SOURCES_B.CUST_ATTRIBUTE11%TYPE
152 ,cust_attribute12 OKL_EXT_AP_HEADER_SOURCES_B.CUST_ATTRIBUTE12%TYPE
153 ,cust_attribute13 OKL_EXT_AP_HEADER_SOURCES_B.CUST_ATTRIBUTE13%TYPE
154 ,cust_attribute14 OKL_EXT_AP_HEADER_SOURCES_B.CUST_ATTRIBUTE14%TYPE
155 ,cust_attribute15 OKL_EXT_AP_HEADER_SOURCES_B.CUST_ATTRIBUTE15%TYPE
156 ,rent_ia_contract_number OKL_EXT_AP_HEADER_SOURCES_B.RENT_IA_CONTRACT_NUMBER%TYPE
157 ,rent_ia_product_name OKL_EXT_AP_HEADER_SOURCES_B.RENT_IA_PRODUCT_NAME%TYPE
158 ,rent_ia_accounting_code OKL_EXT_AP_HEADER_SOURCES_B.RENT_IA_ACCOUNTING_CODE%TYPE
159 ,res_ia_contract_number OKL_EXT_AP_HEADER_SOURCES_B.RES_IA_CONTRACT_NUMBER%TYPE
160 ,res_ia_product_name OKL_EXT_AP_HEADER_SOURCES_B.RES_IA_PRODUCT_NAME%TYPE
161 ,res_ia_accounting_code OKL_EXT_AP_HEADER_SOURCES_B.RES_IA_ACCOUNTING_CODE%TYPE
162 ,inv_agrmnt_number OKL_EXT_AP_HEADER_SOURCES_B.INV_AGRMNT_NUMBER%TYPE
163 ,inv_agrmnt_effective_from OKL_EXT_AP_HEADER_SOURCES_B.INV_AGRMNT_EFFECTIVE_FROM%TYPE
164 ,inv_agrmnt_product_name OKL_EXT_AP_HEADER_SOURCES_B.INV_AGRMNT_PRODUCT_NAME%TYPE
165 ,inv_agrmnt_currency_code OKL_EXT_AP_HEADER_SOURCES_B.INV_AGRMNT_CURRENCY_CODE%TYPE
166 ,inv_agrmnt_synd_code OKL_EXT_AP_HEADER_SOURCES_B.INV_AGRMNT_SYND_CODE%TYPE
167 ,inv_agrmnt_pool_number OKL_EXT_AP_HEADER_SOURCES_B.INV_AGRMNT_POOL_NUMBER%TYPE
168 ,contract_status_code OKL_EXT_AP_HEADER_SOURCES_B.CONTRACT_STATUS_CODE%TYPE
169 ,inv_agrmnt_status_code OKL_EXT_AP_HEADER_SOURCES_B.INV_AGRMNT_STATUS_CODE%TYPE
170 ,trx_type_class_code OKL_EXT_AP_HEADER_SOURCES_B.TRX_TYPE_CLASS_CODE%TYPE
171 ,created_by NUMBER
172 ,creation_date OKL_EXT_AP_HEADER_SOURCES_B.CREATION_DATE%TYPE
173 ,last_updated_by NUMBER
174 ,last_update_date OKL_EXT_AP_HEADER_SOURCES_B.LAST_UPDATE_DATE%TYPE
175 ,last_update_login NUMBER
176 -- added by zrehman Bug#6707320 for Party Merge impact on Accounting sources tables start
177 ,party_id OKL_EXT_AP_HEADER_SOURCES_B.PARTY_ID%TYPE
178 ,cust_account_id OKL_EXT_AP_HEADER_SOURCES_B.CUST_ACCOUNT_ID%TYPE
179 -- added by zrehman Bug#6707320 for Party Merge impact on Accounting sources tables end
180 );
181 G_MISS_pxh_rec pxh_rec_type;
182 TYPE pxh_tbl_type IS TABLE OF pxh_rec_type
183 INDEX BY BINARY_INTEGER;
184 -- OKL_EXT_AP_HEADER_SOURCES_TL Record Spec
185 TYPE pxhl_rec_type IS RECORD (
186 header_extension_id NUMBER
187 ,language OKL_EXT_AP_HEADER_SOURCES_TL.LANGUAGE%TYPE
188 ,source_lang OKL_EXT_AP_HEADER_SOURCES_TL.SOURCE_LANG%TYPE
189 ,sfwt_flag OKL_EXT_AP_HEADER_SOURCES_TL.SFWT_FLAG%TYPE
190 ,contract_status OKL_EXT_AP_HEADER_SOURCES_TL.CONTRACT_STATUS%TYPE
191 ,inv_agrmnt_status OKL_EXT_AP_HEADER_SOURCES_TL.INV_AGRMNT_STATUS%TYPE
192 ,transaction_type_name OKL_EXT_AP_HEADER_SOURCES_TL.TRANSACTION_TYPE_NAME%TYPE
193 ,created_by NUMBER
194 ,creation_date OKL_EXT_AP_HEADER_SOURCES_TL.CREATION_DATE%TYPE
195 ,last_updated_by NUMBER
196 ,last_update_date OKL_EXT_AP_HEADER_SOURCES_TL.LAST_UPDATE_DATE%TYPE
197 ,last_update_login NUMBER);
198 G_MISS_pxhl_rec pxhl_rec_type;
199 TYPE pxhl_tbl_type IS TABLE OF pxhl_rec_type
200 INDEX BY BINARY_INTEGER;
201 ---------------------------------------------------------------------------
202 -- GLOBAL MESSAGE CONSTANTS
203 ---------------------------------------------------------------------------
204 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
205 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
206 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
207 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
208 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
209 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
210 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
211 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
212 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
213 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
214 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
215 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
216 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
217
218 ---------------------------------------------------------------------------
219 -- GLOBAL EXCEPTIONS
220 ---------------------------------------------------------------------------
221 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
222
223 ---------------------------------------------------------------------------
224 -- GLOBAL VARIABLES
225 ---------------------------------------------------------------------------
226 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_PXH_PVT';
227 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
228 ---------------------------------------------------------------------------
229 -- Procedures and Functions
230 ---------------------------------------------------------------------------
231
232 PROCEDURE qc;
233 PROCEDURE change_version;
234 PROCEDURE api_copy;
235 PROCEDURE add_language;
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_pxhv_rec IN pxhv_rec_type,
243 x_pxhv_rec OUT NOCOPY pxhv_rec_type);
244 PROCEDURE insert_row(
245 p_api_version IN NUMBER,
246 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
247 x_return_status OUT NOCOPY VARCHAR2,
248 x_msg_count OUT NOCOPY NUMBER,
249 x_msg_data OUT NOCOPY VARCHAR2,
250 p_pxhv_tbl IN pxhv_tbl_type,
251 x_pxhv_tbl OUT NOCOPY pxhv_tbl_type,
252 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
253 PROCEDURE insert_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_pxhv_tbl IN pxhv_tbl_type,
260 x_pxhv_tbl OUT NOCOPY pxhv_tbl_type);
261 PROCEDURE lock_row(
262 p_api_version IN NUMBER,
263 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
264 x_return_status OUT NOCOPY VARCHAR2,
265 x_msg_count OUT NOCOPY NUMBER,
266 x_msg_data OUT NOCOPY VARCHAR2,
267 p_pxhv_rec IN pxhv_rec_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_pxhv_tbl IN pxhv_tbl_type,
275 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
276 PROCEDURE lock_row(
277 p_api_version IN NUMBER,
278 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
279 x_return_status OUT NOCOPY VARCHAR2,
280 x_msg_count OUT NOCOPY NUMBER,
281 x_msg_data OUT NOCOPY VARCHAR2,
282 p_pxhv_tbl IN pxhv_tbl_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_pxhv_rec IN pxhv_rec_type,
290 x_pxhv_rec OUT NOCOPY pxhv_rec_type);
291 PROCEDURE update_row(
292 p_api_version IN NUMBER,
293 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
294 x_return_status OUT NOCOPY VARCHAR2,
295 x_msg_count OUT NOCOPY NUMBER,
296 x_msg_data OUT NOCOPY VARCHAR2,
297 p_pxhv_tbl IN pxhv_tbl_type,
298 x_pxhv_tbl OUT NOCOPY pxhv_tbl_type,
299 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
300 PROCEDURE update_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_pxhv_tbl IN pxhv_tbl_type,
307 x_pxhv_tbl OUT NOCOPY pxhv_tbl_type);
308 PROCEDURE delete_row(
309 p_api_version IN NUMBER,
310 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
311 x_return_status OUT NOCOPY VARCHAR2,
312 x_msg_count OUT NOCOPY NUMBER,
313 x_msg_data OUT NOCOPY VARCHAR2,
314 p_pxhv_rec IN pxhv_rec_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_pxhv_tbl IN pxhv_tbl_type,
322 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
323 PROCEDURE delete_row(
324 p_api_version IN NUMBER,
325 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
326 x_return_status OUT NOCOPY VARCHAR2,
327 x_msg_count OUT NOCOPY NUMBER,
328 x_msg_data OUT NOCOPY VARCHAR2,
329 p_pxhv_tbl IN pxhv_tbl_type);
330 PROCEDURE validate_row(
331 p_api_version IN NUMBER,
332 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
333 x_return_status OUT NOCOPY VARCHAR2,
334 x_msg_count OUT NOCOPY NUMBER,
335 x_msg_data OUT NOCOPY VARCHAR2,
336 p_pxhv_rec IN pxhv_rec_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_pxhv_tbl IN pxhv_tbl_type,
344 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
345 PROCEDURE validate_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_pxhv_tbl IN pxhv_tbl_type);
352 -- Added for Bug# 6268782 : PRASJAIN
353 PROCEDURE insert_row(
354 p_api_version IN NUMBER,
355 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
356 x_return_status OUT NOCOPY VARCHAR2,
357 x_msg_count OUT NOCOPY NUMBER,
358 x_msg_data OUT NOCOPY VARCHAR2,
359 p_pxh_rec IN pxh_rec_type,
360 p_pxhl_tbl IN pxhl_tbl_type,
361 x_pxh_rec OUT NOCOPY pxh_rec_type,
362 x_pxhl_tbl OUT NOCOPY pxhl_tbl_type);
363 END OKL_PXH_PVT;