[Home] [Help]
PACKAGE: APPS.OKL_PYD_PVT
Source
1 PACKAGE OKL_PYD_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSPYDS.pls 120.3.12010000.2 2009/07/17 23:26:38 sechawla ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKL_PARTY_PAYMENT_DTLS_V Record Spec
7 TYPE ppydv_rec_type IS RECORD (
8 id NUMBER := OKL_API.G_MISS_NUM
9 ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10 ,cpl_id NUMBER := OKL_API.G_MISS_NUM
11 ,vendor_id NUMBER := OKL_API.G_MISS_NUM
12 ,pay_site_id NUMBER := OKL_API.G_MISS_NUM
13 ,payment_term_id NUMBER := OKL_API.G_MISS_NUM
14 ,payment_method_code OKL_PARTY_PAYMENT_DTLS_V.PAYMENT_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
15 ,pay_group_code OKL_PARTY_PAYMENT_DTLS_V.PAY_GROUP_CODE%TYPE := OKL_API.G_MISS_CHAR
16 ,payment_hdr_id OKL_PARTY_PAYMENT_DTLS_V.PAYMENT_HDR_ID%TYPE := OKL_API.G_MISS_NUM
17 ,payment_start_date OKL_PARTY_PAYMENT_DTLS_V.PAYMENT_START_DATE%TYPE := OKL_API.G_MISS_DATE
18 ,payment_frequency OKL_PARTY_PAYMENT_DTLS_V.PAYMENT_FREQUENCY%TYPE := OKL_API.G_MISS_CHAR
19 ,remit_days OKL_PARTY_PAYMENT_DTLS_V.REMIT_DAYS%TYPE := OKL_API.G_MISS_NUM
20 ,disbursement_basis OKL_PARTY_PAYMENT_DTLS_V.DISBURSEMENT_BASIS%TYPE := OKL_API.G_MISS_CHAR
21 ,disbursement_fixed_amount OKL_PARTY_PAYMENT_DTLS_V.DISBURSEMENT_FIXED_AMOUNT%TYPE := OKL_API.G_MISS_NUM
22 ,disbursement_percent OKL_PARTY_PAYMENT_DTLS_V.DISBURSEMENT_PERCENT%TYPE := OKL_API.G_MISS_NUM
23 ,processing_fee_basis OKL_PARTY_PAYMENT_DTLS_V.PROCESSING_FEE_BASIS%TYPE := OKL_API.G_MISS_CHAR
24 ,processing_fee_fixed_amount OKL_PARTY_PAYMENT_DTLS_V.PROCESSING_FEE_FIXED_AMOUNT%TYPE := OKL_API.G_MISS_NUM
25 ,processing_fee_percent OKL_PARTY_PAYMENT_DTLS_V.PROCESSING_FEE_PERCENT%TYPE := OKL_API.G_MISS_NUM
26 --,include_in_yield_flag OKL_PARTY_PAYMENT_DTLS_V.INCLUDE_IN_YIELD_FLAG%TYPE := OKL_API.G_MISS_CHAR
27 --,processing_fee_formula OKL_PARTY_PAYMENT_DTLS_V.PROCESSING_FEE_FORMULA%TYPE := OKL_API.G_MISS_CHAR
28 ,payment_basis OKL_PARTY_PAYMENT_DTLS_V.PAYMENT_BASIS%TYPE := OKL_API.G_MISS_CHAR
29 ,attribute_category OKL_PARTY_PAYMENT_DTLS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
30 ,attribute1 OKL_PARTY_PAYMENT_DTLS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
31 ,attribute2 OKL_PARTY_PAYMENT_DTLS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
32 ,attribute3 OKL_PARTY_PAYMENT_DTLS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
33 ,attribute4 OKL_PARTY_PAYMENT_DTLS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
34 ,attribute5 OKL_PARTY_PAYMENT_DTLS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
35 ,attribute6 OKL_PARTY_PAYMENT_DTLS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
36 ,attribute7 OKL_PARTY_PAYMENT_DTLS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
37 ,attribute8 OKL_PARTY_PAYMENT_DTLS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
38 ,attribute9 OKL_PARTY_PAYMENT_DTLS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
39 ,attribute10 OKL_PARTY_PAYMENT_DTLS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
40 ,attribute11 OKL_PARTY_PAYMENT_DTLS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
41 ,attribute12 OKL_PARTY_PAYMENT_DTLS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
42 ,attribute13 OKL_PARTY_PAYMENT_DTLS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
43 ,attribute14 OKL_PARTY_PAYMENT_DTLS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
44 ,attribute15 OKL_PARTY_PAYMENT_DTLS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
45 ,created_by NUMBER := OKL_API.G_MISS_NUM
46 ,creation_date OKL_PARTY_PAYMENT_DTLS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
47 ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
48 ,last_update_date OKL_PARTY_PAYMENT_DTLS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
49 ,last_update_login NUMBER := OKL_API.G_MISS_NUM
50 ,ORIG_CONTRACT_LINE_ID NUMBER := OKL_API.G_MISS_NUM);
51 G_MISS_ppydv_rec ppydv_rec_type;
52 TYPE ppydv_tbl_type IS TABLE OF ppydv_rec_type
53 INDEX BY BINARY_INTEGER;
54 -- OKL_PARTY_PAYMENT_DTLS Record Spec
55 TYPE ppyd_rec_type IS RECORD (
56 id NUMBER := OKL_API.G_MISS_NUM
57 ,object_version_number NUMBER := OKL_API.G_MISS_NUM
58 ,cpl_id NUMBER := OKL_API.G_MISS_NUM
59 ,vendor_id NUMBER := OKL_API.G_MISS_NUM
60 ,pay_site_id NUMBER := OKL_API.G_MISS_NUM
61 ,payment_term_id NUMBER := OKL_API.G_MISS_NUM
62 ,payment_method_code OKL_PARTY_PAYMENT_DTLS.PAYMENT_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
63 ,pay_group_code OKL_PARTY_PAYMENT_DTLS.PAY_GROUP_CODE%TYPE := OKL_API.G_MISS_CHAR
64 ,payment_hdr_id OKL_PARTY_PAYMENT_DTLS.PAYMENT_HDR_ID%TYPE := OKL_API.G_MISS_NUM
65 ,payment_start_date OKL_PARTY_PAYMENT_DTLS.PAYMENT_START_DATE%TYPE := OKL_API.G_MISS_DATE
66 ,payment_frequency OKL_PARTY_PAYMENT_DTLS.PAYMENT_FREQUENCY%TYPE := OKL_API.G_MISS_CHAR
67 ,remit_days OKL_PARTY_PAYMENT_DTLS.REMIT_DAYS%TYPE := OKL_API.G_MISS_NUM
68 ,disbursement_basis OKL_PARTY_PAYMENT_DTLS.DISBURSEMENT_BASIS%TYPE := OKL_API.G_MISS_CHAR
69 ,disbursement_fixed_amount OKL_PARTY_PAYMENT_DTLS.DISBURSEMENT_FIXED_AMOUNT%TYPE := OKL_API.G_MISS_NUM
70 ,disbursement_percent OKL_PARTY_PAYMENT_DTLS.DISBURSEMENT_PERCENT%TYPE := OKL_API.G_MISS_NUM
71 ,processing_fee_basis OKL_PARTY_PAYMENT_DTLS.PROCESSING_FEE_BASIS%TYPE := OKL_API.G_MISS_CHAR
72 ,processing_fee_fixed_amount OKL_PARTY_PAYMENT_DTLS.PROCESSING_FEE_FIXED_AMOUNT%TYPE := OKL_API.G_MISS_NUM
73 ,processing_fee_percent OKL_PARTY_PAYMENT_DTLS.PROCESSING_FEE_PERCENT%TYPE := OKL_API.G_MISS_NUM
74 --,include_in_yield_flag OKL_PARTY_PAYMENT_DTLS.INCLUDE_IN_YIELD_FLAG%TYPE := OKL_API.G_MISS_CHAR
75 --,processing_fee_formula OKL_PARTY_PAYMENT_DTLS.PROCESSING_FEE_FORMULA%TYPE := OKL_API.G_MISS_CHAR
76 ,payment_basis OKL_PARTY_PAYMENT_DTLS.PAYMENT_BASIS%TYPE := OKL_API.G_MISS_CHAR
77 ,attribute_category OKL_PARTY_PAYMENT_DTLS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
78 ,attribute1 OKL_PARTY_PAYMENT_DTLS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
79 ,attribute2 OKL_PARTY_PAYMENT_DTLS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
80 ,attribute3 OKL_PARTY_PAYMENT_DTLS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
81 ,attribute4 OKL_PARTY_PAYMENT_DTLS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
82 ,attribute5 OKL_PARTY_PAYMENT_DTLS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
83 ,attribute6 OKL_PARTY_PAYMENT_DTLS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
84 ,attribute7 OKL_PARTY_PAYMENT_DTLS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
85 ,attribute8 OKL_PARTY_PAYMENT_DTLS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
86 ,attribute9 OKL_PARTY_PAYMENT_DTLS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
87 ,attribute10 OKL_PARTY_PAYMENT_DTLS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
88 ,attribute11 OKL_PARTY_PAYMENT_DTLS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
89 ,attribute12 OKL_PARTY_PAYMENT_DTLS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
90 ,attribute13 OKL_PARTY_PAYMENT_DTLS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
91 ,attribute14 OKL_PARTY_PAYMENT_DTLS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
92 ,attribute15 OKL_PARTY_PAYMENT_DTLS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
93 ,created_by NUMBER := OKL_API.G_MISS_NUM
94 ,creation_date OKL_PARTY_PAYMENT_DTLS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
95 ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
96 ,last_update_date OKL_PARTY_PAYMENT_DTLS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
97 ,last_update_login NUMBER := OKL_API.G_MISS_NUM
98 ,ORIG_CONTRACT_LINE_ID NUMBER := OKL_API.G_MISS_NUM);
99 G_MISS_ppyd_rec ppyd_rec_type;
100 TYPE ppyd_tbl_type IS TABLE OF ppyd_rec_type
101 INDEX BY BINARY_INTEGER;
102
103 -- OKL_PARTY_PYMT_DTLS_H Record Spec
104 TYPE ppydh_rec_type IS RECORD (
105 id NUMBER := OKL_API.G_MISS_NUM
106 ,object_version_number NUMBER := OKL_API.G_MISS_NUM
107 ,major_version NUMBER := OKL_API.G_MISS_NUM
108 ,cpl_id NUMBER := OKL_API.G_MISS_NUM
109 ,vendor_id NUMBER := OKL_API.G_MISS_NUM
110 ,pay_site_id NUMBER := OKL_API.G_MISS_NUM
111 ,payment_term_id NUMBER := OKL_API.G_MISS_NUM
112 ,payment_method_code OKL_PARTY_PAYMENT_DTLS.PAYMENT_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
113 ,pay_group_code OKL_PARTY_PAYMENT_DTLS.PAY_GROUP_CODE%TYPE := OKL_API.G_MISS_CHAR
114 ,payment_hdr_id OKL_PARTY_PAYMENT_DTLS.PAYMENT_HDR_ID%TYPE := OKL_API.G_MISS_NUM
115 ,payment_start_date OKL_PARTY_PAYMENT_DTLS.PAYMENT_START_DATE%TYPE := OKL_API.G_MISS_DATE
116 ,payment_frequency OKL_PARTY_PAYMENT_DTLS.PAYMENT_FREQUENCY%TYPE := OKL_API.G_MISS_CHAR
117 ,remit_days OKL_PARTY_PAYMENT_DTLS.REMIT_DAYS%TYPE := OKL_API.G_MISS_NUM
118 ,disbursement_basis OKL_PARTY_PAYMENT_DTLS.DISBURSEMENT_BASIS%TYPE := OKL_API.G_MISS_CHAR
119 ,disbursement_fixed_amount OKL_PARTY_PAYMENT_DTLS.DISBURSEMENT_FIXED_AMOUNT%TYPE := OKL_API.G_MISS_NUM
120 ,disbursement_percent OKL_PARTY_PAYMENT_DTLS.DISBURSEMENT_PERCENT%TYPE := OKL_API.G_MISS_NUM
121 ,processing_fee_basis OKL_PARTY_PAYMENT_DTLS.PROCESSING_FEE_BASIS%TYPE := OKL_API.G_MISS_CHAR
122 ,processing_fee_fixed_amount OKL_PARTY_PAYMENT_DTLS.PROCESSING_FEE_FIXED_AMOUNT%TYPE := OKL_API.G_MISS_NUM
123 ,processing_fee_percent OKL_PARTY_PAYMENT_DTLS.PROCESSING_FEE_PERCENT%TYPE := OKL_API.G_MISS_NUM
124 --,include_in_yield_flag OKL_PARTY_PAYMENT_DTLS.INCLUDE_IN_YIELD_FLAG%TYPE := OKL_API.G_MISS_CHAR
125 --,processing_fee_formula OKL_PARTY_PAYMENT_DTLS.PROCESSING_FEE_FORMULA%TYPE := OKL_API.G_MISS_CHAR
126 ,payment_basis OKL_PARTY_PAYMENT_DTLS.PAYMENT_BASIS%TYPE := OKL_API.G_MISS_CHAR
127 ,attribute_category OKL_PARTY_PAYMENT_DTLS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
128 ,attribute1 OKL_PARTY_PAYMENT_DTLS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
129 ,attribute2 OKL_PARTY_PAYMENT_DTLS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
130 ,attribute3 OKL_PARTY_PAYMENT_DTLS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
131 ,attribute4 OKL_PARTY_PAYMENT_DTLS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
132 ,attribute5 OKL_PARTY_PAYMENT_DTLS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
133 ,attribute6 OKL_PARTY_PAYMENT_DTLS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
134 ,attribute7 OKL_PARTY_PAYMENT_DTLS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
135 ,attribute8 OKL_PARTY_PAYMENT_DTLS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
136 ,attribute9 OKL_PARTY_PAYMENT_DTLS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
137 ,attribute10 OKL_PARTY_PAYMENT_DTLS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
138 ,attribute11 OKL_PARTY_PAYMENT_DTLS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
139 ,attribute12 OKL_PARTY_PAYMENT_DTLS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
140 ,attribute13 OKL_PARTY_PAYMENT_DTLS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
141 ,attribute14 OKL_PARTY_PAYMENT_DTLS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
142 ,attribute15 OKL_PARTY_PAYMENT_DTLS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
143 ,created_by NUMBER := OKL_API.G_MISS_NUM
144 ,creation_date OKL_PARTY_PAYMENT_DTLS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
145 ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
146 ,last_update_date OKL_PARTY_PAYMENT_DTLS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
147 ,last_update_login NUMBER := OKL_API.G_MISS_NUM
148 ,ORIG_CONTRACT_LINE_ID NUMBER := OKL_API.G_MISS_NUM );
149 G_MISS_ppydh_rec ppydh_rec_type;
150 TYPE ppydh_tbl_type IS TABLE OF ppydh_rec_type
151 INDEX BY BINARY_INTEGER;
152 ---------------------------------------------------------------------------
153 -- GLOBAL MESSAGE CONSTANTS
154 ---------------------------------------------------------------------------
155 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
156 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
157 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
158 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
159 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
160 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
161 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
162 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
163 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
164 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
165 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
166 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
167 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
168
169 ---------------------------------------------------------------------------
170 -- GLOBAL EXCEPTIONS
171 ---------------------------------------------------------------------------
172 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
173
174 ---------------------------------------------------------------------------
175 -- GLOBAL VARIABLES
176 ---------------------------------------------------------------------------
177 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_PYD_PVT';
178 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
179 ---------------------------------------------------------------------------
180 -- Procedures and Functions
181 ---------------------------------------------------------------------------
182
183 PROCEDURE qc;
184 PROCEDURE change_version;
185 PROCEDURE api_copy;
186 PROCEDURE insert_row(
187 p_api_version IN NUMBER,
188 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
189 x_return_status OUT NOCOPY VARCHAR2,
190 x_msg_count OUT NOCOPY NUMBER,
191 x_msg_data OUT NOCOPY VARCHAR2,
192 p_ppydv_rec IN ppydv_rec_type,
193 x_ppydv_rec OUT NOCOPY ppydv_rec_type);
194 PROCEDURE insert_row(
195 p_api_version IN NUMBER,
196 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
197 x_return_status OUT NOCOPY VARCHAR2,
198 x_msg_count OUT NOCOPY NUMBER,
199 x_msg_data OUT NOCOPY VARCHAR2,
200 p_ppydv_tbl IN ppydv_tbl_type,
201 x_ppydv_tbl OUT NOCOPY ppydv_tbl_type,
202 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
203 PROCEDURE insert_row(
204 p_api_version IN NUMBER,
205 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
206 x_return_status OUT NOCOPY VARCHAR2,
207 x_msg_count OUT NOCOPY NUMBER,
208 x_msg_data OUT NOCOPY VARCHAR2,
209 p_ppydv_tbl IN ppydv_tbl_type,
210 x_ppydv_tbl OUT NOCOPY ppydv_tbl_type);
211 PROCEDURE lock_row(
212 p_api_version IN NUMBER,
213 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
214 x_return_status OUT NOCOPY VARCHAR2,
215 x_msg_count OUT NOCOPY NUMBER,
216 x_msg_data OUT NOCOPY VARCHAR2,
217 p_ppydv_rec IN ppydv_rec_type);
218 PROCEDURE lock_row(
219 p_api_version IN NUMBER,
220 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
221 x_return_status OUT NOCOPY VARCHAR2,
222 x_msg_count OUT NOCOPY NUMBER,
223 x_msg_data OUT NOCOPY VARCHAR2,
224 p_ppydv_tbl IN ppydv_tbl_type,
225 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
226 PROCEDURE lock_row(
227 p_api_version IN NUMBER,
228 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
229 x_return_status OUT NOCOPY VARCHAR2,
230 x_msg_count OUT NOCOPY NUMBER,
231 x_msg_data OUT NOCOPY VARCHAR2,
232 p_ppydv_tbl IN ppydv_tbl_type);
233 PROCEDURE update_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_ppydv_rec IN ppydv_rec_type,
240 x_ppydv_rec OUT NOCOPY ppydv_rec_type);
241 PROCEDURE update_row(
242 p_api_version IN NUMBER,
243 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
244 x_return_status OUT NOCOPY VARCHAR2,
245 x_msg_count OUT NOCOPY NUMBER,
246 x_msg_data OUT NOCOPY VARCHAR2,
247 p_ppydv_tbl IN ppydv_tbl_type,
248 x_ppydv_tbl OUT NOCOPY ppydv_tbl_type,
249 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
250 PROCEDURE update_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,
256 p_ppydv_tbl IN ppydv_tbl_type,
257 x_ppydv_tbl OUT NOCOPY ppydv_tbl_type);
258 PROCEDURE delete_row(
259 p_api_version IN NUMBER,
260 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
261 x_return_status OUT NOCOPY VARCHAR2,
262 x_msg_count OUT NOCOPY NUMBER,
263 x_msg_data OUT NOCOPY VARCHAR2,
264 p_ppydv_rec IN ppydv_rec_type);
265 PROCEDURE delete_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_ppydv_tbl IN ppydv_tbl_type,
272 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
273 PROCEDURE delete_row(
274 p_api_version IN NUMBER,
275 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
276 x_return_status OUT NOCOPY VARCHAR2,
277 x_msg_count OUT NOCOPY NUMBER,
278 x_msg_data OUT NOCOPY VARCHAR2,
279 p_ppydv_tbl IN ppydv_tbl_type);
280 PROCEDURE validate_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_ppydv_rec IN ppydv_rec_type);
287 PROCEDURE validate_row(
288 p_api_version IN NUMBER,
289 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
290 x_return_status OUT NOCOPY VARCHAR2,
291 x_msg_count OUT NOCOPY NUMBER,
292 x_msg_data OUT NOCOPY VARCHAR2,
293 p_ppydv_tbl IN ppydv_tbl_type,
294 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
295 PROCEDURE validate_row(
296 p_api_version IN NUMBER,
297 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
298 x_return_status OUT NOCOPY VARCHAR2,
299 x_msg_count OUT NOCOPY NUMBER,
300 x_msg_data OUT NOCOPY VARCHAR2,
301 p_ppydv_tbl IN ppydv_tbl_type);
302
303 FUNCTION create_version(
304 p_chr_id IN NUMBER,
305 p_major_version IN NUMBER) RETURN VARCHAR2;
306
307 FUNCTION restore_version(
308 p_chr_id IN NUMBER,
309 p_major_version IN NUMBER) RETURN VARCHAR2;
310 END OKL_PYD_PVT;