[Home] [Help]
PACKAGE: APPS.OKL_TEH_PVT
Source
1 PACKAGE OKL_TEH_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSTEHS.pls 120.6 2007/12/21 12:50:10 rajnisku noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKL_TRX_EXTENSION_V Record Spec
7 TYPE tehv_rec_type IS RECORD (
8 header_extension_id NUMBER
9 ,source_id NUMBER
10 ,source_table OKL_TRX_EXTENSION_V.SOURCE_TABLE%TYPE
11 ,object_version_number NUMBER
12 ,language OKL_TRX_EXTENSION_V.LANGUAGE%TYPE
13 ,contract_number OKL_TRX_EXTENSION_V.CONTRACT_NUMBER%TYPE
14 ,inv_agrmnt_number OKL_TRX_EXTENSION_V.INV_AGRMNT_NUMBER%TYPE
15 ,contract_currency_code OKL_TRX_EXTENSION_V.CONTRACT_CURRENCY_CODE%TYPE
16 ,inv_agrmnt_currency_code OKL_TRX_EXTENSION_V.INV_AGRMNT_CURRENCY_CODE%TYPE
17 ,contract_effective_from OKL_TRX_EXTENSION_V.CONTRACT_EFFECTIVE_FROM%TYPE
18 ,inv_agrmnt_effective_from OKL_TRX_EXTENSION_V.INV_AGRMNT_EFFECTIVE_FROM%TYPE
19 ,customer_name OKL_TRX_EXTENSION_V.CUSTOMER_NAME%TYPE
20 ,sales_rep_name OKL_TRX_EXTENSION_V.SALES_REP_NAME%TYPE
21 ,customer_account_number OKL_TRX_EXTENSION_V.CUSTOMER_ACCOUNT_NUMBER%TYPE
22 ,bill_to_address_num NUMBER
23 ,int_calc_method_code OKL_TRX_EXTENSION_V.INT_CALC_METHOD_CODE%TYPE
24 ,rev_rec_method_code OKL_TRX_EXTENSION_V.REV_REC_METHOD_CODE%TYPE
25 ,converted_number OKL_TRX_EXTENSION_V.CONVERTED_NUMBER%TYPE
26 ,assignable_flag OKL_TRX_EXTENSION_V.ASSIGNABLE_FLAG%TYPE
27 ,credit_line_number OKL_TRX_EXTENSION_V.CREDIT_LINE_NUMBER%TYPE
28 ,master_lease_number OKL_TRX_EXTENSION_V.MASTER_LEASE_NUMBER%TYPE
29 ,po_order_number OKL_TRX_EXTENSION_V.PO_ORDER_NUMBER%TYPE
30 ,vendor_program_number OKL_TRX_EXTENSION_V.VENDOR_PROGRAM_NUMBER%TYPE
31 ,ins_policy_type_code OKL_TRX_EXTENSION_V.INS_POLICY_TYPE_CODE%TYPE
32 ,ins_policy_number OKL_TRX_EXTENSION_V.INS_POLICY_NUMBER%TYPE
33 ,term_quote_accept_date OKL_TRX_EXTENSION_V.TERM_QUOTE_ACCEPT_DATE%TYPE
34 ,term_quote_num NUMBER
35 ,term_quote_type_code OKL_TRX_EXTENSION_V.TERM_QUOTE_TYPE_CODE%TYPE
36 ,converted_account_flag OKL_TRX_EXTENSION_V.CONVERTED_ACCOUNT_FLAG%TYPE
37 ,accrual_override_flag OKL_TRX_EXTENSION_V.ACCRUAL_OVERRIDE_FLAG%TYPE
38 ,cust_attribute_category OKL_TRX_EXTENSION_V.CUST_ATTRIBUTE_CATEGORY%TYPE
39 ,cust_attribute1 OKL_TRX_EXTENSION_V.CUST_ATTRIBUTE1%TYPE
40 ,cust_attribute2 OKL_TRX_EXTENSION_V.CUST_ATTRIBUTE2%TYPE
41 ,cust_attribute3 OKL_TRX_EXTENSION_V.CUST_ATTRIBUTE3%TYPE
42 ,cust_attribute4 OKL_TRX_EXTENSION_V.CUST_ATTRIBUTE4%TYPE
43 ,cust_attribute5 OKL_TRX_EXTENSION_V.CUST_ATTRIBUTE5%TYPE
44 ,cust_attribute6 OKL_TRX_EXTENSION_V.CUST_ATTRIBUTE6%TYPE
45 ,cust_attribute7 OKL_TRX_EXTENSION_V.CUST_ATTRIBUTE7%TYPE
46 ,cust_attribute8 OKL_TRX_EXTENSION_V.CUST_ATTRIBUTE8%TYPE
47 ,cust_attribute9 OKL_TRX_EXTENSION_V.CUST_ATTRIBUTE9%TYPE
48 ,cust_attribute10 OKL_TRX_EXTENSION_V.CUST_ATTRIBUTE10%TYPE
49 ,cust_attribute11 OKL_TRX_EXTENSION_V.CUST_ATTRIBUTE11%TYPE
50 ,cust_attribute12 OKL_TRX_EXTENSION_V.CUST_ATTRIBUTE12%TYPE
51 ,cust_attribute13 OKL_TRX_EXTENSION_V.CUST_ATTRIBUTE13%TYPE
52 ,cust_attribute14 OKL_TRX_EXTENSION_V.CUST_ATTRIBUTE14%TYPE
53 ,cust_attribute15 OKL_TRX_EXTENSION_V.CUST_ATTRIBUTE15%TYPE
54 ,rent_ia_contract_number OKL_TRX_EXTENSION_V.RENT_IA_CONTRACT_NUMBER%TYPE
55 ,res_ia_contract_number OKL_TRX_EXTENSION_V.RES_IA_CONTRACT_NUMBER%TYPE
56 ,inv_agrmnt_pool_number OKL_TRX_EXTENSION_V.INV_AGRMNT_POOL_NUMBER%TYPE
57 ,rent_ia_product_name OKL_TRX_EXTENSION_V.RENT_IA_PRODUCT_NAME%TYPE
58 ,res_ia_product_name OKL_TRX_EXTENSION_V.RES_IA_PRODUCT_NAME%TYPE
59 ,rent_ia_accounting_code OKL_TRX_EXTENSION_V.RENT_IA_ACCOUNTING_CODE%TYPE
60 ,res_ia_accounting_code OKL_TRX_EXTENSION_V.RES_IA_ACCOUNTING_CODE%TYPE
61 ,inv_agrmnt_synd_code OKL_TRX_EXTENSION_V.INV_AGRMNT_SYND_CODE%TYPE
62 ,created_by NUMBER
63 ,creation_date OKL_TRX_EXTENSION_V.CREATION_DATE%TYPE
64 ,last_updated_by NUMBER
65 ,last_update_date OKL_TRX_EXTENSION_V.LAST_UPDATE_DATE%TYPE
66 ,last_update_login NUMBER
67 ,contract_status OKL_TRX_EXTENSION_V.CONTRACT_STATUS%TYPE
68 ,inv_agrmnt_status OKL_TRX_EXTENSION_V.INV_AGRMNT_STATUS%TYPE
69 ,chr_operating_unit_name OKL_TRX_EXTENSION_V.CHR_OPERATING_UNIT_NAME%TYPE
70 ,transaction_type_name OKL_TRX_EXTENSION_V.TRANSACTION_TYPE_NAME%TYPE
71 ,contract_status_code OKL_TRX_EXTENSION_V.CONTRACT_STATUS_CODE%TYPE
72 ,inv_agrmnt_status_code OKL_TRX_EXTENSION_V.INV_AGRMNT_STATUS_CODE%TYPE
73 ,trx_type_class_code OKL_TRX_EXTENSION_V.TRX_TYPE_CLASS_CODE%TYPE
74 ,chr_operating_unit_code OKL_TRX_EXTENSION_V.CHR_OPERATING_UNIT_CODE%TYPE
75 ,party_id OKL_TRX_EXTENSION_V.PARTY_ID%TYPE
76 ,cust_account_id OKL_TRX_EXTENSION_V.CUST_ACCOUNT_ID%TYPE
77 ,cust_site_use_id OKL_TRX_EXTENSION_V.CUST_SITE_USE_ID%TYPE );
78 G_MISS_tehv_rec tehv_rec_type;
79 TYPE tehv_tbl_type IS TABLE OF tehv_rec_type
80 INDEX BY BINARY_INTEGER;
81 -- OKL_TRX_EXTENSION_B Record Spec
82 TYPE teh_rec_type IS RECORD (
83 header_extension_id NUMBER
84 ,source_id NUMBER
85 ,source_table OKL_TRX_EXTENSION_B.SOURCE_TABLE%TYPE
86 ,object_version_number NUMBER
87 ,contract_number OKL_TRX_EXTENSION_B.CONTRACT_NUMBER%TYPE
88 ,inv_agrmnt_number OKL_TRX_EXTENSION_B.INV_AGRMNT_NUMBER%TYPE
89 ,contract_currency_code OKL_TRX_EXTENSION_B.CONTRACT_CURRENCY_CODE%TYPE
90 ,inv_agrmnt_currency_code OKL_TRX_EXTENSION_B.INV_AGRMNT_CURRENCY_CODE%TYPE
91 ,contract_effective_from OKL_TRX_EXTENSION_B.CONTRACT_EFFECTIVE_FROM%TYPE
92 ,inv_agrmnt_effective_from OKL_TRX_EXTENSION_B.INV_AGRMNT_EFFECTIVE_FROM%TYPE
93 ,customer_name OKL_TRX_EXTENSION_B.CUSTOMER_NAME%TYPE
94 ,sales_rep_name OKL_TRX_EXTENSION_B.SALES_REP_NAME%TYPE
95 ,customer_account_number OKL_TRX_EXTENSION_B.CUSTOMER_ACCOUNT_NUMBER%TYPE
96 ,bill_to_address_num NUMBER
97 ,int_calc_method_code OKL_TRX_EXTENSION_B.INT_CALC_METHOD_CODE%TYPE
98 ,rev_rec_method_code OKL_TRX_EXTENSION_B.REV_REC_METHOD_CODE%TYPE
99 ,converted_number OKL_TRX_EXTENSION_B.CONVERTED_NUMBER%TYPE
100 ,assignable_flag OKL_TRX_EXTENSION_B.ASSIGNABLE_FLAG%TYPE
101 ,credit_line_number OKL_TRX_EXTENSION_B.CREDIT_LINE_NUMBER%TYPE
102 ,master_lease_number OKL_TRX_EXTENSION_B.MASTER_LEASE_NUMBER%TYPE
103 ,po_order_number OKL_TRX_EXTENSION_B.PO_ORDER_NUMBER%TYPE
104 ,vendor_program_number OKL_TRX_EXTENSION_B.VENDOR_PROGRAM_NUMBER%TYPE
105 ,ins_policy_type_code OKL_TRX_EXTENSION_B.INS_POLICY_TYPE_CODE%TYPE
106 ,ins_policy_number OKL_TRX_EXTENSION_B.INS_POLICY_NUMBER%TYPE
107 ,term_quote_accept_date OKL_TRX_EXTENSION_B.TERM_QUOTE_ACCEPT_DATE%TYPE
108 ,term_quote_num NUMBER
109 ,term_quote_type_code OKL_TRX_EXTENSION_B.TERM_QUOTE_TYPE_CODE%TYPE
110 ,converted_account_flag OKL_TRX_EXTENSION_B.CONVERTED_ACCOUNT_FLAG%TYPE
111 ,accrual_override_flag OKL_TRX_EXTENSION_B.ACCRUAL_OVERRIDE_FLAG%TYPE
112 ,cust_attribute_category OKL_TRX_EXTENSION_B.CUST_ATTRIBUTE_CATEGORY%TYPE
113 ,cust_attribute1 OKL_TRX_EXTENSION_B.CUST_ATTRIBUTE1%TYPE
114 ,cust_attribute2 OKL_TRX_EXTENSION_B.CUST_ATTRIBUTE2%TYPE
115 ,cust_attribute3 OKL_TRX_EXTENSION_B.CUST_ATTRIBUTE3%TYPE
116 ,cust_attribute4 OKL_TRX_EXTENSION_B.CUST_ATTRIBUTE4%TYPE
117 ,cust_attribute5 OKL_TRX_EXTENSION_B.CUST_ATTRIBUTE5%TYPE
118 ,cust_attribute6 OKL_TRX_EXTENSION_B.CUST_ATTRIBUTE6%TYPE
119 ,cust_attribute7 OKL_TRX_EXTENSION_B.CUST_ATTRIBUTE7%TYPE
120 ,cust_attribute8 OKL_TRX_EXTENSION_B.CUST_ATTRIBUTE8%TYPE
121 ,cust_attribute9 OKL_TRX_EXTENSION_B.CUST_ATTRIBUTE9%TYPE
122 ,cust_attribute10 OKL_TRX_EXTENSION_B.CUST_ATTRIBUTE10%TYPE
123 ,cust_attribute11 OKL_TRX_EXTENSION_B.CUST_ATTRIBUTE11%TYPE
124 ,cust_attribute12 OKL_TRX_EXTENSION_B.CUST_ATTRIBUTE12%TYPE
125 ,cust_attribute13 OKL_TRX_EXTENSION_B.CUST_ATTRIBUTE13%TYPE
126 ,cust_attribute14 OKL_TRX_EXTENSION_B.CUST_ATTRIBUTE14%TYPE
127 ,cust_attribute15 OKL_TRX_EXTENSION_B.CUST_ATTRIBUTE15%TYPE
128 ,rent_ia_contract_number OKL_TRX_EXTENSION_B.RENT_IA_CONTRACT_NUMBER%TYPE
129 ,res_ia_contract_number OKL_TRX_EXTENSION_B.RES_IA_CONTRACT_NUMBER%TYPE
130 ,inv_agrmnt_pool_number OKL_TRX_EXTENSION_B.INV_AGRMNT_POOL_NUMBER%TYPE
131 ,rent_ia_product_name OKL_TRX_EXTENSION_B.RENT_IA_PRODUCT_NAME%TYPE
132 ,res_ia_product_name OKL_TRX_EXTENSION_B.RES_IA_PRODUCT_NAME%TYPE
133 ,rent_ia_accounting_code OKL_TRX_EXTENSION_B.RENT_IA_ACCOUNTING_CODE%TYPE
134 ,res_ia_accounting_code OKL_TRX_EXTENSION_B.RES_IA_ACCOUNTING_CODE%TYPE
135 ,inv_agrmnt_synd_code OKL_TRX_EXTENSION_B.INV_AGRMNT_SYND_CODE%TYPE
136 ,created_by NUMBER
137 ,creation_date OKL_TRX_EXTENSION_B.CREATION_DATE%TYPE
138 ,last_updated_by NUMBER
139 ,last_update_date OKL_TRX_EXTENSION_B.LAST_UPDATE_DATE%TYPE
140 ,last_update_login NUMBER
141 ,contract_status_code OKL_TRX_EXTENSION_B.CONTRACT_STATUS_CODE%TYPE
142 ,inv_agrmnt_status_code OKL_TRX_EXTENSION_B.INV_AGRMNT_STATUS_CODE%TYPE
143 ,trx_type_class_code OKL_TRX_EXTENSION_B.TRX_TYPE_CLASS_CODE%TYPE
144 ,chr_operating_unit_code OKL_TRX_EXTENSION_B.CHR_OPERATING_UNIT_CODE%TYPE
145 ,party_id OKL_TRX_EXTENSION_V.PARTY_ID%TYPE
146 ,cust_account_id OKL_TRX_EXTENSION_V.CUST_ACCOUNT_ID%TYPE
147 ,cust_site_use_id OKL_TRX_EXTENSION_V.CUST_SITE_USE_ID%TYPE );
148 G_MISS_teh_rec teh_rec_type;
149 TYPE teh_tbl_type IS TABLE OF teh_rec_type
150 INDEX BY BINARY_INTEGER;
151 -- OKL_TRX_EXTENSION_TL Record Spec
152 TYPE tehl_rec_type IS RECORD (
153 header_extension_id NUMBER
154 ,language OKL_TRX_EXTENSION_TL.LANGUAGE%TYPE
155 ,source_lang OKL_TRX_EXTENSION_TL.SOURCE_LANG%TYPE
156 ,sfwt_flag OKL_TRX_EXTENSION_TL.SFWT_FLAG%TYPE
157 ,contract_status OKL_TRX_EXTENSION_TL.CONTRACT_STATUS%TYPE
158 ,inv_agrmnt_status OKL_TRX_EXTENSION_TL.INV_AGRMNT_STATUS%TYPE
159 ,chr_operating_unit_name OKL_TRX_EXTENSION_TL.CHR_OPERATING_UNIT_NAME%TYPE
160 ,transaction_type_name OKL_TRX_EXTENSION_TL.TRANSACTION_TYPE_NAME%TYPE
161 ,created_by NUMBER
162 ,creation_date OKL_TRX_EXTENSION_TL.CREATION_DATE%TYPE
163 ,last_updated_by NUMBER
164 ,last_update_date OKL_TRX_EXTENSION_TL.LAST_UPDATE_DATE%TYPE
165 ,last_update_login NUMBER);
166 G_MISS_tehl_rec tehl_rec_type;
167 TYPE tehl_tbl_type IS TABLE OF tehl_rec_type
168 INDEX BY BINARY_INTEGER;
169 ---------------------------------------------------------------------------
170 -- GLOBAL MESSAGE CONSTANTS
171 ---------------------------------------------------------------------------
172 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
173 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
174 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
175 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
176 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
177 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
178 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
179 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
180 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
181 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
182 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
183 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
184 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
185
186 ---------------------------------------------------------------------------
187 -- GLOBAL EXCEPTIONS
188 ---------------------------------------------------------------------------
189 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
190
191 ---------------------------------------------------------------------------
192 -- GLOBAL VARIABLES
193 ---------------------------------------------------------------------------
194 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TEH_PVT';
195 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
196 ---------------------------------------------------------------------------
197 -- Procedures and Functions
198 ---------------------------------------------------------------------------
199
200 PROCEDURE qc;
201 PROCEDURE change_version;
202 PROCEDURE api_copy;
203 PROCEDURE add_language;
204 PROCEDURE insert_row(
205 p_api_version IN NUMBER,
206 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
207 x_return_status OUT NOCOPY VARCHAR2,
208 x_msg_count OUT NOCOPY NUMBER,
209 x_msg_data OUT NOCOPY VARCHAR2,
210 p_tehv_rec IN tehv_rec_type,
211 x_tehv_rec OUT NOCOPY tehv_rec_type);
212 PROCEDURE insert_row(
213 p_api_version IN NUMBER,
214 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_tehv_tbl IN tehv_tbl_type,
219 x_tehv_tbl OUT NOCOPY tehv_tbl_type,
220 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
221 PROCEDURE insert_row(
222 p_api_version IN NUMBER,
223 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
224 x_return_status OUT NOCOPY VARCHAR2,
225 x_msg_count OUT NOCOPY NUMBER,
226 x_msg_data OUT NOCOPY VARCHAR2,
227 p_tehv_tbl IN tehv_tbl_type,
228 x_tehv_tbl OUT NOCOPY tehv_tbl_type);
229 PROCEDURE lock_row(
230 p_api_version IN NUMBER,
231 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
232 x_return_status OUT NOCOPY VARCHAR2,
233 x_msg_count OUT NOCOPY NUMBER,
234 x_msg_data OUT NOCOPY VARCHAR2,
235 p_tehv_rec IN tehv_rec_type);
236 PROCEDURE lock_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_tehv_tbl IN tehv_tbl_type,
243 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
244 PROCEDURE lock_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_tehv_tbl IN tehv_tbl_type);
251 PROCEDURE update_row(
252 p_api_version IN NUMBER,
253 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
254 x_return_status OUT NOCOPY VARCHAR2,
255 x_msg_count OUT NOCOPY NUMBER,
256 x_msg_data OUT NOCOPY VARCHAR2,
257 p_tehv_rec IN tehv_rec_type,
258 x_tehv_rec OUT NOCOPY tehv_rec_type);
259 PROCEDURE update_row(
260 p_api_version IN NUMBER,
261 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
262 x_return_status OUT NOCOPY VARCHAR2,
263 x_msg_count OUT NOCOPY NUMBER,
264 x_msg_data OUT NOCOPY VARCHAR2,
265 p_tehv_tbl IN tehv_tbl_type,
266 x_tehv_tbl OUT NOCOPY tehv_tbl_type,
267 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
268 PROCEDURE update_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_tehv_tbl IN tehv_tbl_type,
275 x_tehv_tbl OUT NOCOPY tehv_tbl_type);
276 PROCEDURE delete_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_tehv_rec IN tehv_rec_type);
283 PROCEDURE delete_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_tehv_tbl IN tehv_tbl_type,
290 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
291 PROCEDURE delete_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_tehv_tbl IN tehv_tbl_type);
298 PROCEDURE validate_row(
299 p_api_version IN NUMBER,
300 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
301 x_return_status OUT NOCOPY VARCHAR2,
302 x_msg_count OUT NOCOPY NUMBER,
303 x_msg_data OUT NOCOPY VARCHAR2,
304 p_tehv_rec IN tehv_rec_type);
305 PROCEDURE validate_row(
306 p_api_version IN NUMBER,
307 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
308 x_return_status OUT NOCOPY VARCHAR2,
309 x_msg_count OUT NOCOPY NUMBER,
310 x_msg_data OUT NOCOPY VARCHAR2,
311 p_tehv_tbl IN tehv_tbl_type,
312 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
313 PROCEDURE validate_row(
314 p_api_version IN NUMBER,
315 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
316 x_return_status OUT NOCOPY VARCHAR2,
317 x_msg_count OUT NOCOPY NUMBER,
318 x_msg_data OUT NOCOPY VARCHAR2,
319 p_tehv_tbl IN tehv_tbl_type);
320 -- Added : PRASJAIN : Bug# 6268782
321 PROCEDURE insert_row(
322 p_api_version IN NUMBER,
323 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
324 x_return_status OUT NOCOPY VARCHAR2,
325 x_msg_count OUT NOCOPY NUMBER,
326 x_msg_data OUT NOCOPY VARCHAR2,
327 p_teh_rec IN teh_rec_type,
328 p_tehl_tbl IN tehl_tbl_type,
329 x_teh_rec OUT NOCOPY teh_rec_type,
330 x_tehl_tbl OUT NOCOPY tehl_tbl_type);
331 END OKL_TEH_PVT;