[Home] [Help]
PACKAGE: APPS.OKL_IPY_PVT
Source
1 PACKAGE OKL_IPY_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSIPYS.pls 120.2 2006/11/22 18:22:03 asahoo noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKL_INS_POLICIES_V Record Spec
7 TYPE ipyv_rec_type IS RECORD (
8 id NUMBER := OKC_API.G_MISS_NUM
9 ,ipy_type OKL_INS_POLICIES_V.IPY_TYPE%TYPE := OKC_API.G_MISS_CHAR
10 ,description OKL_INS_POLICIES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
11 ,endorsement OKL_INS_POLICIES_V.ENDORSEMENT%TYPE := OKC_API.G_MISS_CHAR
12 ,sfwt_flag OKL_INS_POLICIES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
13 ,cancellation_comment OKL_INS_POLICIES_V.CANCELLATION_COMMENT%TYPE := OKC_API.G_MISS_CHAR
14 ,comments OKL_INS_POLICIES_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
15 ,name_of_insured OKL_INS_POLICIES_V.NAME_OF_INSURED%TYPE := OKC_API.G_MISS_CHAR
16 ,policy_number OKL_INS_POLICIES_V.POLICY_NUMBER%TYPE := OKC_API.G_MISS_CHAR
17 ,calculated_premium NUMBER := OKC_API.G_MISS_NUM
18 ,premium NUMBER := OKC_API.G_MISS_NUM
19 ,covered_amount NUMBER := OKC_API.G_MISS_NUM
20 ,deductible NUMBER := OKC_API.G_MISS_NUM
21 ,adjustment NUMBER := OKC_API.G_MISS_NUM
22 ,payment_frequency OKL_INS_POLICIES_V.PAYMENT_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
23 ,crx_code OKL_INS_POLICIES_V.CRX_CODE%TYPE := OKC_API.G_MISS_CHAR
24 ,ipf_code OKL_INS_POLICIES_V.IPF_CODE%TYPE := OKC_API.G_MISS_CHAR
25 ,iss_code OKL_INS_POLICIES_V.ISS_CODE%TYPE := OKC_API.G_MISS_CHAR
26 ,ipe_code OKL_INS_POLICIES_V.IPE_CODE%TYPE := OKC_API.G_MISS_CHAR
27 ,date_to OKL_INS_POLICIES_V.DATE_TO%TYPE := OKC_API.G_MISS_DATE
28 ,date_from OKL_INS_POLICIES_V.DATE_FROM%TYPE := OKC_API.G_MISS_DATE
29 ,date_quoted OKL_INS_POLICIES_V.DATE_QUOTED%TYPE := OKC_API.G_MISS_DATE
30 ,date_proof_provided OKL_INS_POLICIES_V.DATE_PROOF_PROVIDED%TYPE := OKC_API.G_MISS_DATE
31 ,date_proof_required OKL_INS_POLICIES_V.DATE_PROOF_REQUIRED%TYPE := OKC_API.G_MISS_DATE
32 ,cancellation_date OKL_INS_POLICIES_V.CANCELLATION_DATE%TYPE := OKC_API.G_MISS_DATE
33 ,date_quote_expiry OKL_INS_POLICIES_V.DATE_QUOTE_EXPIRY%TYPE := OKC_API.G_MISS_DATE
34 ,activation_date OKL_INS_POLICIES_V.ACTIVATION_DATE%TYPE := OKC_API.G_MISS_DATE
35 ,quote_yn OKL_INS_POLICIES_V.QUOTE_YN%TYPE := OKC_API.G_MISS_CHAR
36 ,on_file_yn OKL_INS_POLICIES_V.ON_FILE_YN%TYPE := OKC_API.G_MISS_CHAR
37 ,private_label_yn OKL_INS_POLICIES_V.PRIVATE_LABEL_YN%TYPE := OKC_API.G_MISS_CHAR
38 ,agent_yn OKL_INS_POLICIES_V.AGENT_YN%TYPE := OKC_API.G_MISS_CHAR
39 ,lessor_insured_yn OKL_INS_POLICIES_V.LESSOR_INSURED_YN%TYPE := OKC_API.G_MISS_CHAR
40 ,lessor_payee_yn OKL_INS_POLICIES_V.LESSOR_PAYEE_YN%TYPE := OKC_API.G_MISS_CHAR
41 ,khr_id NUMBER := OKC_API.G_MISS_NUM
42 ,kle_id NUMBER := OKC_API.G_MISS_NUM
43 ,ipt_id NUMBER := OKC_API.G_MISS_NUM
44 ,ipy_id NUMBER := OKC_API.G_MISS_NUM
45 ,int_id NUMBER := OKC_API.G_MISS_NUM
46 ,isu_id NUMBER := OKC_API.G_MISS_NUM
47 ,insurance_factor OKL_INS_POLICIES_V.INSURANCE_FACTOR%TYPE := OKC_API.G_MISS_CHAR
48 ,factor_code OKL_INS_POLICIES_V.FACTOR_CODE%TYPE := OKC_API.G_MISS_CHAR
49 ,factor_value NUMBER := OKC_API.G_MISS_NUM
50 ,agency_number OKL_INS_POLICIES_V.AGENCY_NUMBER%TYPE := OKC_API.G_MISS_CHAR
51 ,agency_site_id NUMBER := OKC_API.G_MISS_NUM
52 ,sales_rep_id NUMBER := OKC_API.G_MISS_NUM
56 ,attribute_category OKL_INS_POLICIES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
53 ,agent_site_id NUMBER := OKC_API.G_MISS_NUM
54 ,adjusted_by_id NUMBER := OKC_API.G_MISS_NUM
55 ,territory_code OKL_INS_POLICIES_V.TERRITORY_CODE%TYPE := OKC_API.G_MISS_CHAR
57 ,attribute1 OKL_INS_POLICIES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
58 ,attribute2 OKL_INS_POLICIES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
59 ,attribute3 OKL_INS_POLICIES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
60 ,attribute4 OKL_INS_POLICIES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
61 ,attribute5 OKL_INS_POLICIES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
62 ,attribute6 OKL_INS_POLICIES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
63 ,attribute7 OKL_INS_POLICIES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
64 ,attribute8 OKL_INS_POLICIES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
65 ,attribute9 OKL_INS_POLICIES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
66 ,attribute10 OKL_INS_POLICIES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
67 ,attribute11 OKL_INS_POLICIES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
68 ,attribute12 OKL_INS_POLICIES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
69 ,attribute13 OKL_INS_POLICIES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
70 ,attribute14 OKL_INS_POLICIES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
71 ,attribute15 OKL_INS_POLICIES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
72 ,program_id NUMBER := OKC_API.G_MISS_NUM
73 ,org_id NUMBER := OKC_API.G_MISS_NUM
74 ,program_update_date OKL_INS_POLICIES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
75 ,program_application_id NUMBER := OKC_API.G_MISS_NUM
76 ,request_id NUMBER := OKC_API.G_MISS_NUM
77 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
78 ,created_by NUMBER := OKC_API.G_MISS_NUM
79 ,creation_date OKL_INS_POLICIES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
80 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
81 ,last_update_date OKL_INS_POLICIES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
82 ,last_update_login NUMBER := OKC_API.G_MISS_NUM
83 -- Bug: 4567777 PAGARG new column for Lease Application Functionality impact
84 ,lease_application_id NUMBER := OKC_API.G_MISS_NUM
85 -- Legal Entity Uptake
86 ,legal_entity_id OKL_INS_POLICIES_V.LEGAL_ENTITY_ID%TYPE := OKC_API.G_MISS_NUM);
87 G_MISS_ipyv_rec ipyv_rec_type;
88 TYPE ipyv_tbl_type IS TABLE OF ipyv_rec_type
89 INDEX BY BINARY_INTEGER;
90 -- OKL_INS_POLICIES_B Record Spec
91 TYPE ipy_rec_type IS RECORD (
92 id NUMBER := OKC_API.G_MISS_NUM
93 ,ipy_type OKL_INS_POLICIES_B.IPY_TYPE%TYPE := OKC_API.G_MISS_CHAR
94 ,name_of_insured OKL_INS_POLICIES_B.NAME_OF_INSURED%TYPE := OKC_API.G_MISS_CHAR
95 ,policy_number OKL_INS_POLICIES_B.POLICY_NUMBER%TYPE := OKC_API.G_MISS_CHAR
96 ,insurance_factor OKL_INS_POLICIES_B.INSURANCE_FACTOR%TYPE := OKC_API.G_MISS_CHAR
97 ,factor_code OKL_INS_POLICIES_B.FACTOR_CODE%TYPE := OKC_API.G_MISS_CHAR
98 ,calculated_premium NUMBER := OKC_API.G_MISS_NUM
99 ,premium NUMBER := OKC_API.G_MISS_NUM
100 ,covered_amount NUMBER := OKC_API.G_MISS_NUM
101 ,deductible NUMBER := OKC_API.G_MISS_NUM
102 ,adjustment NUMBER := OKC_API.G_MISS_NUM
103 ,payment_frequency OKL_INS_POLICIES_B.PAYMENT_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
104 ,crx_code OKL_INS_POLICIES_B.CRX_CODE%TYPE := OKC_API.G_MISS_CHAR
105 ,ipf_code OKL_INS_POLICIES_B.IPF_CODE%TYPE := OKC_API.G_MISS_CHAR
106 ,iss_code OKL_INS_POLICIES_B.ISS_CODE%TYPE := OKC_API.G_MISS_CHAR
107 ,ipe_code OKL_INS_POLICIES_B.IPE_CODE%TYPE := OKC_API.G_MISS_CHAR
108 ,date_to OKL_INS_POLICIES_B.DATE_TO%TYPE := OKC_API.G_MISS_DATE
109 ,date_from OKL_INS_POLICIES_B.DATE_FROM%TYPE := OKC_API.G_MISS_DATE
110 ,date_quoted OKL_INS_POLICIES_B.DATE_QUOTED%TYPE := OKC_API.G_MISS_DATE
111 ,date_proof_provided OKL_INS_POLICIES_B.DATE_PROOF_PROVIDED%TYPE := OKC_API.G_MISS_DATE
112 ,date_proof_required OKL_INS_POLICIES_B.DATE_PROOF_REQUIRED%TYPE := OKC_API.G_MISS_DATE
113 ,cancellation_date OKL_INS_POLICIES_B.CANCELLATION_DATE%TYPE := OKC_API.G_MISS_DATE
114 ,date_quote_expiry OKL_INS_POLICIES_B.DATE_QUOTE_EXPIRY%TYPE := OKC_API.G_MISS_DATE
115 ,activation_date OKL_INS_POLICIES_B.ACTIVATION_DATE%TYPE := OKC_API.G_MISS_DATE
116 ,quote_yn OKL_INS_POLICIES_B.QUOTE_YN%TYPE := OKC_API.G_MISS_CHAR
117 ,on_file_yn OKL_INS_POLICIES_B.ON_FILE_YN%TYPE := OKC_API.G_MISS_CHAR
118 ,private_label_yn OKL_INS_POLICIES_B.PRIVATE_LABEL_YN%TYPE := OKC_API.G_MISS_CHAR
119 ,agent_yn OKL_INS_POLICIES_B.AGENT_YN%TYPE := OKC_API.G_MISS_CHAR
120 ,lessor_insured_yn OKL_INS_POLICIES_B.LESSOR_INSURED_YN%TYPE := OKC_API.G_MISS_CHAR
121 ,lessor_payee_yn OKL_INS_POLICIES_B.LESSOR_PAYEE_YN%TYPE := OKC_API.G_MISS_CHAR
122 ,khr_id NUMBER := OKC_API.G_MISS_NUM
123 ,kle_id NUMBER := OKC_API.G_MISS_NUM
124 ,ipt_id NUMBER := OKC_API.G_MISS_NUM
125 ,ipy_id NUMBER := OKC_API.G_MISS_NUM
126 ,int_id NUMBER := OKC_API.G_MISS_NUM
130 ,agency_site_id NUMBER := OKC_API.G_MISS_NUM
127 ,isu_id NUMBER := OKC_API.G_MISS_NUM
128 ,factor_value NUMBER := OKC_API.G_MISS_NUM
129 ,agency_number OKL_INS_POLICIES_B.AGENCY_NUMBER%TYPE := OKC_API.G_MISS_CHAR
131 ,sales_rep_id NUMBER := OKC_API.G_MISS_NUM
132 ,agent_site_id NUMBER := OKC_API.G_MISS_NUM
133 ,adjusted_by_id NUMBER := OKC_API.G_MISS_NUM
134 ,territory_code OKL_INS_POLICIES_B.TERRITORY_CODE%TYPE := OKC_API.G_MISS_CHAR
135 ,attribute_category OKL_INS_POLICIES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
136 ,attribute1 OKL_INS_POLICIES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
137 ,attribute2 OKL_INS_POLICIES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
138 ,attribute3 OKL_INS_POLICIES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
139 ,attribute4 OKL_INS_POLICIES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
140 ,attribute5 OKL_INS_POLICIES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
141 ,attribute6 OKL_INS_POLICIES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
142 ,attribute7 OKL_INS_POLICIES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
143 ,attribute8 OKL_INS_POLICIES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
144 ,attribute9 OKL_INS_POLICIES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
145 ,attribute10 OKL_INS_POLICIES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
146 ,attribute11 OKL_INS_POLICIES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
147 ,attribute12 OKL_INS_POLICIES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
148 ,attribute13 OKL_INS_POLICIES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
149 ,attribute14 OKL_INS_POLICIES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
150 ,attribute15 OKL_INS_POLICIES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
151 ,program_id NUMBER := OKC_API.G_MISS_NUM
152 ,org_id NUMBER := OKC_API.G_MISS_NUM
153 ,program_update_date OKL_INS_POLICIES_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
154 ,program_application_id NUMBER := OKC_API.G_MISS_NUM
155 ,request_id NUMBER := OKC_API.G_MISS_NUM
156 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
157 ,created_by NUMBER := OKC_API.G_MISS_NUM
158 ,creation_date OKL_INS_POLICIES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
159 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
160 ,last_update_date OKL_INS_POLICIES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
161 ,last_update_login NUMBER := OKC_API.G_MISS_NUM
162 -- Bug: 4567777 PAGARG new column for Lease Application Functionality impact
163 ,lease_application_id NUMBER := OKC_API.G_MISS_NUM
164 -- Legal Entity Uptake
165 ,legal_entity_id OKL_INS_POLICIES_B.LEGAL_ENTITY_ID%TYPE := OKC_API.G_MISS_NUM);
166 G_MISS_ipy_rec ipy_rec_type;
167 TYPE ipy_tbl_type IS TABLE OF ipy_rec_type
168 INDEX BY BINARY_INTEGER;
169 -- OKL_INS_POLICIES_TL Record Spec
170 TYPE okl_ins_policies_tl_rec_type IS RECORD (
171 id NUMBER := OKC_API.G_MISS_NUM
172 ,language OKL_INS_POLICIES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
173 ,source_lang OKL_INS_POLICIES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
174 ,sfwt_flag OKL_INS_POLICIES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
175 ,description OKL_INS_POLICIES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
176 ,endorsement OKL_INS_POLICIES_TL.ENDORSEMENT%TYPE := OKC_API.G_MISS_CHAR
177 ,comments OKL_INS_POLICIES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
178 ,cancellation_comment OKL_INS_POLICIES_TL.CANCELLATION_COMMENT%TYPE := OKC_API.G_MISS_CHAR
179 ,created_by NUMBER := OKC_API.G_MISS_NUM
180 ,creation_date OKL_INS_POLICIES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
181 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
182 ,last_update_date OKL_INS_POLICIES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
183 ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
184 G_MISS_okl_ins_policies_tl_rec okl_ins_policies_tl_rec_type;
185 TYPE okl_ins_policies_tl_tbl_type IS TABLE OF okl_ins_policies_tl_rec_type
186 INDEX BY BINARY_INTEGER;
187 ---------------------------------------------------------------------------
188 -- GLOBAL MESSAGE CONSTANTS
189 ---------------------------------------------------------------------------
190 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
191 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
192 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
193 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
194 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
195 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
196 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
197 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
198 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
199 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
200 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
201 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
205 G_FND_LOOKUP_INS_POLICY_TYPE CONSTANT VARCHAR2(30) := 'OKL_INSURANCE_POLICY_TYPE' ;
202 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
203 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
204 G_FND_LOOKUP_PAYMENT_FREQ CONSTANT VARCHAR2(30) := 'OKL_INS_PAYMENT_FREQUENCY' ;
206 G_FND_LOOKUP_INS_CANCEL_REASON CONSTANT VARCHAR2(30) := 'OKL_INS_CANCEL_REASON' ;
207 G_FND_LOOKUP_INS_STATUS CONSTANT VARCHAR2(30) := 'OKL_INSURANCE_STATUS' ;
208 G_FND_LOOKUP_POLICY_TYPE CONSTANT VARCHAR2(30) := 'OKL_INSURANCE_TYPE' ;
209 ---------------------------------------------------------------------------
210 -- GLOBAL EXCEPTIONS
211 ---------------------------------------------------------------------------
212 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
213 ---------------------------------------------------------------------------
214 -- GLOBAL VARIABLES
215 ---------------------------------------------------------------------------
216 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_IPY_PVT';
217 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKL';
218 ---------------------------------------------------------------------------
219 -- Procedures and Functions
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 OKC_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_ipyv_rec IN ipyv_rec_type,
232 x_ipyv_rec OUT NOCOPY ipyv_rec_type);
233 PROCEDURE insert_row(
234 p_api_version IN NUMBER,
235 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_ipyv_tbl IN ipyv_tbl_type,
240 x_ipyv_tbl OUT NOCOPY ipyv_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 OKC_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_ipyv_tbl IN ipyv_tbl_type,
249 x_ipyv_tbl OUT NOCOPY ipyv_tbl_type);
250 PROCEDURE lock_row(
251 p_api_version IN NUMBER,
252 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
253 x_return_status OUT NOCOPY VARCHAR2,
254 x_msg_count OUT NOCOPY NUMBER,
255 x_msg_data OUT NOCOPY VARCHAR2,
256 p_ipyv_rec IN ipyv_rec_type);
257 PROCEDURE lock_row(
258 p_api_version IN NUMBER,
259 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
260 x_return_status OUT NOCOPY VARCHAR2,
261 x_msg_count OUT NOCOPY NUMBER,
262 x_msg_data OUT NOCOPY VARCHAR2,
263 p_ipyv_tbl IN ipyv_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 OKC_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_ipyv_tbl IN ipyv_tbl_type);
272 PROCEDURE update_row(
273 p_api_version IN NUMBER,
274 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_ipyv_rec IN ipyv_rec_type,
279 x_ipyv_rec OUT NOCOPY ipyv_rec_type);
280 PROCEDURE update_row(
281 p_api_version IN NUMBER,
282 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_ipyv_tbl IN ipyv_tbl_type,
287 x_ipyv_tbl OUT NOCOPY ipyv_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 OKC_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_ipyv_tbl IN ipyv_tbl_type,
296 x_ipyv_tbl OUT NOCOPY ipyv_tbl_type);
297 PROCEDURE delete_row(
298 p_api_version IN NUMBER,
299 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_ipyv_rec IN ipyv_rec_type);
304 PROCEDURE delete_row(
305 p_api_version IN NUMBER,
306 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_ipyv_tbl IN ipyv_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 OKC_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_ipyv_tbl IN ipyv_tbl_type);
319 PROCEDURE validate_row(
320 p_api_version IN NUMBER,
321 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_ipyv_rec IN ipyv_rec_type);
326 PROCEDURE validate_row(
327 p_api_version IN NUMBER,
328 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_ipyv_tbl IN ipyv_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 OKC_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_ipyv_tbl IN ipyv_tbl_type);
341 END OKL_IPY_PVT;