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