[Home] [Help]
PACKAGE: APPS.OKL_PARTY_PAYMENTS_PVT
Source
1 PACKAGE OKL_PARTY_PAYMENTS_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRPPMS.pls 120.0 2005/11/30 17:17:51 stmathew noship $ */
3
4 subtype pph_rec_type is okl_ldb_pvt.pph_rec_type;
5 subtype pph_tbl_type is okl_ldb_pvt.pph_tbl_type;
6 subtype pphv_rec_type is okl_ldb_pvt.pphv_rec_type;
7 subtype pphv_tbl_type is okl_ldb_pvt.pphv_tbl_type;
8 subtype ppyd_rec_type is okl_pyd_pvt.ppyd_rec_type;
9 subtype ppyd_tbl_type is okl_pyd_pvt.ppyd_tbl_type;
10 subtype ppydv_rec_type is okl_pyd_pvt.ppydv_rec_type;
11 subtype ppydv_tbl_type is okl_pyd_pvt.ppydv_tbl_type;
12 subtype cplv_rec_type IS OKL_OKC_MIGRATION_PVT.cplv_rec_type;
13
14 -- Record type for a denormalized passthru parameter information
15 TYPE passthru_param_rec_type IS RECORD (
16 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
17 ,cle_id NUMBER := OKC_API.G_MISS_NUM
18 ,ppl_id NUMBER := OKC_API.G_MISS_NUM
19 ,passthru_term OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
20 ,passthru_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
21 ,passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
22 ,payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
23 ,payout_basis_formula OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
24 ,effective_from OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE
25 ,effective_to OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE
26 ,payment_dtls_id NUMBER := OKL_API.G_MISS_NUM
27 ,cpl_id NUMBER := OKL_API.G_MISS_NUM
28 ,vendor_id NUMBER := OKL_API.G_MISS_NUM
29 ,pay_site_id NUMBER := OKL_API.G_MISS_NUM
30 ,payment_term_id NUMBER := OKL_API.G_MISS_NUM
31 ,payment_method_code OKL_PARTY_PAYMENT_DTLS_V.PAYMENT_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
32 ,pay_group_code OKL_PARTY_PAYMENT_DTLS_V.PAY_GROUP_CODE%TYPE := OKL_API.G_MISS_CHAR
33 ,payment_hdr_id OKL_PARTY_PAYMENT_DTLS_V.PAYMENT_HDR_ID%TYPE := OKL_API.G_MISS_NUM
34 ,payment_basis OKL_PARTY_PAYMENT_DTLS_V.PAYMENT_BASIS%TYPE := OKL_API.G_MISS_CHAR
35 ,payment_start_date OKL_PARTY_PAYMENT_DTLS_V.PAYMENT_START_DATE%TYPE := OKL_API.G_MISS_DATE
36 ,payment_frequency OKL_PARTY_PAYMENT_DTLS_V.PAYMENT_FREQUENCY%TYPE := OKL_API.G_MISS_CHAR
37 ,remit_days OKL_PARTY_PAYMENT_DTLS_V.REMIT_DAYS%TYPE := OKL_API.G_MISS_NUM
38 ,disbursement_basis OKL_PARTY_PAYMENT_DTLS_V.DISBURSEMENT_BASIS%TYPE := OKL_API.G_MISS_CHAR
39 ,disbursement_fixed_amount OKL_PARTY_PAYMENT_DTLS_V.DISBURSEMENT_FIXED_AMOUNT%TYPE := OKL_API.G_MISS_NUM
40 ,disbursement_percent OKL_PARTY_PAYMENT_DTLS_V.DISBURSEMENT_PERCENT%TYPE := OKL_API.G_MISS_NUM
41 ,processing_fee_basis OKL_PARTY_PAYMENT_DTLS_V.PROCESSING_FEE_BASIS%TYPE := OKL_API.G_MISS_CHAR
42 ,processing_fee_fixed_amount OKL_PARTY_PAYMENT_DTLS_V.PROCESSING_FEE_FIXED_AMOUNT%TYPE := OKL_API.G_MISS_NUM
43 ,processing_fee_percent OKL_PARTY_PAYMENT_DTLS_V.PROCESSING_FEE_PERCENT%TYPE := OKL_API.G_MISS_NUM
44 --,processing_fee_formula OKL_PARTY_PAYMENT_DTLS_V.PROCESSING_FEE_FORMULA%TYPE := OKL_API.G_MISS_CHAR
45 --,include_in_yield_flag OKL_PARTY_PAYMENT_DTLS_V.INCLUDE_IN_YIELD_FLAG%TYPE := OKL_API.G_MISS_CHAR
46 ,attribute_category OKL_PARTY_PAYMENT_DTLS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
47 ,attribute1 OKL_PARTY_PAYMENT_DTLS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
48 ,attribute2 OKL_PARTY_PAYMENT_DTLS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
49 ,attribute3 OKL_PARTY_PAYMENT_DTLS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
50 ,attribute4 OKL_PARTY_PAYMENT_DTLS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
51 ,attribute5 OKL_PARTY_PAYMENT_DTLS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
52 ,attribute6 OKL_PARTY_PAYMENT_DTLS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
53 ,attribute7 OKL_PARTY_PAYMENT_DTLS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
54 ,attribute8 OKL_PARTY_PAYMENT_DTLS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
55 ,attribute9 OKL_PARTY_PAYMENT_DTLS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
56 ,attribute10 OKL_PARTY_PAYMENT_DTLS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
57 ,attribute11 OKL_PARTY_PAYMENT_DTLS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
58 ,attribute12 OKL_PARTY_PAYMENT_DTLS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
59 ,attribute13 OKL_PARTY_PAYMENT_DTLS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
60 ,attribute14 OKL_PARTY_PAYMENT_DTLS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
61 ,attribute15 OKL_PARTY_PAYMENT_DTLS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
62 );
63 G_MISS_passthru_param_rec passthru_param_rec_type;
64 TYPE passthru_param_tbl_type IS TABLE OF passthru_param_rec_type
65 INDEX BY BINARY_INTEGER;
66
67 TYPE evg_cle_rec_type IS RECORD (
68 cle_id NUMBER := OKC_API.G_MISS_NUM
69 ,cpl_id NUMBER := OKC_API.G_MISS_NUM
70 ,cle_start_date OKC_K_LINES_B.START_DATE%TYPE := OKL_API.G_MISS_DATE);
71 TYPE evg_cle_tbl_type IS TABLE OF evg_cle_rec_type INDEX BY BINARY_INTEGER;
72 ---------------------------------------------------------------------------
73 -- GLOBAL MESSAGE CONSTANTS
74 ---------------------------------------------------------------------------
75 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
76 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
77 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
78 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
79 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
80 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
81 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
82 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
83 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
84 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
85 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
86 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
87 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
88
89 ---------------------------------------------------------------------------
90 -- GLOBAL EXCEPTIONS
91 ---------------------------------------------------------------------------
92 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
93
94 ---------------------------------------------------------------------------
95 -- GLOBAL VARIABLES
96 ---------------------------------------------------------------------------
97 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_PARTY_PAYMENTS_PVT';
98 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
99 G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
100
101 ---------------------------------------------------------------------------
102 -- Validations and Others
103 ---------------------------------------------------------------------------
104 PROCEDURE validate_passthru_qa (
105 p_api_version IN NUMBER,
106 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
107 x_return_status OUT NOCOPY VARCHAR2,
108 x_msg_count OUT NOCOPY NUMBER,
109 x_msg_data OUT NOCOPY VARCHAR2,
110 p_chr_id IN NUMBER
111 );
112 PROCEDURE get_passthru_parameters (
113 p_api_version IN NUMBER,
114 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
115 x_return_status OUT NOCOPY VARCHAR2,
116 x_msg_count OUT NOCOPY NUMBER,
117 x_msg_data OUT NOCOPY VARCHAR2,
118 p_chr_id IN NUMBER,
119 p_cle_id IN NUMBER,
120 p_vendor_id IN NUMBER,
121 x_passthru_param_tbl OUT NOCOPY passthru_param_tbl_type
122 );
123 ---------------------------------------------------------------------------
124 -- Procedures and Functions for the header
125 ---------------------------------------------------------------------------
126 PROCEDURE create_party_payment_hdr(
127 p_api_version IN NUMBER,
128 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
129 x_return_status OUT NOCOPY VARCHAR2,
130 x_msg_count OUT NOCOPY NUMBER,
131 x_msg_data OUT NOCOPY VARCHAR2,
132 p_pphv_rec IN pphv_rec_type,
133 x_pphv_rec OUT NOCOPY pphv_rec_type);
134
135 PROCEDURE create_party_payment_hdr(
136 p_api_version IN NUMBER,
137 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
138 x_return_status OUT NOCOPY VARCHAR2,
139 x_msg_count OUT NOCOPY NUMBER,
140 x_msg_data OUT NOCOPY VARCHAR2,
141 p_pphv_tbl IN pphv_tbl_type,
142 x_pphv_tbl OUT NOCOPY pphv_tbl_type);
143
144 PROCEDURE lock_party_payment_hdr(
145 p_api_version IN NUMBER,
146 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
147 x_return_status OUT NOCOPY VARCHAR2,
148 x_msg_count OUT NOCOPY NUMBER,
149 x_msg_data OUT NOCOPY VARCHAR2,
150 p_pphv_rec IN pphv_rec_type);
151
152 PROCEDURE lock_party_payment_hdr(
153 p_api_version IN NUMBER,
154 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
155 x_return_status OUT NOCOPY VARCHAR2,
156 x_msg_count OUT NOCOPY NUMBER,
157 x_msg_data OUT NOCOPY VARCHAR2,
158 p_pphv_tbl IN pphv_tbl_type);
159
160 PROCEDURE update_party_payment_hdr(
161 p_api_version IN NUMBER,
162 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
163 x_return_status OUT NOCOPY VARCHAR2,
164 x_msg_count OUT NOCOPY NUMBER,
165 x_msg_data OUT NOCOPY VARCHAR2,
166 p_pphv_rec IN pphv_rec_type,
167 x_pphv_rec OUT NOCOPY pphv_rec_type);
168
169 PROCEDURE update_party_payment_hdr(
170 p_api_version IN NUMBER,
171 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
172 x_return_status OUT NOCOPY VARCHAR2,
173 x_msg_count OUT NOCOPY NUMBER,
174 x_msg_data OUT NOCOPY VARCHAR2,
175 p_pphv_tbl IN pphv_tbl_type,
176 x_pphv_tbl OUT NOCOPY pphv_tbl_type);
177
178 PROCEDURE delete_party_payment_hdr(
179 p_api_version IN NUMBER,
180 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
181 x_return_status OUT NOCOPY VARCHAR2,
182 x_msg_count OUT NOCOPY NUMBER,
183 x_msg_data OUT NOCOPY VARCHAR2,
184 p_pphv_rec IN pphv_rec_type);
185
186 PROCEDURE delete_party_payment_hdr(
187 p_api_version IN NUMBER,
188 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_pphv_tbl IN pphv_tbl_type);
193
194 PROCEDURE validate_party_payment_hdr(
195 p_api_version IN NUMBER,
196 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_pphv_rec IN pphv_rec_type);
201
202 PROCEDURE validate_party_payment_hdr(
203 p_api_version IN NUMBER,
204 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
205 x_return_status OUT NOCOPY VARCHAR2,
206 x_msg_count OUT NOCOPY NUMBER,
207 x_msg_data OUT NOCOPY VARCHAR2,
208 p_pphv_tbl IN pphv_tbl_type);
209
210
211 ---------------------------------------------------------------------------
212 -- Procedures and Functions for the details
213 ---------------------------------------------------------------------------
214
215 PROCEDURE create_party_payment_dtls(
216 p_api_version IN NUMBER,
217 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_rec IN ppydv_rec_type,
222 x_ppydv_rec OUT NOCOPY ppydv_rec_type);
223
224 PROCEDURE create_party_payment_dtls(
225 p_api_version IN NUMBER,
226 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
227 x_return_status OUT NOCOPY VARCHAR2,
228 x_msg_count OUT NOCOPY NUMBER,
229 x_msg_data OUT NOCOPY VARCHAR2,
230 p_ppydv_tbl IN ppydv_tbl_type,
231 x_ppydv_tbl OUT NOCOPY ppydv_tbl_type);
232
233 PROCEDURE lock_party_payment_dtls(
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_ppydv_rec IN ppydv_rec_type);
240
241 PROCEDURE lock_party_payment_dtls(
242 p_api_version IN NUMBER,
243 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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
249 PROCEDURE update_party_payment_dtls(
250 p_api_version IN NUMBER,
251 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
252 x_return_status OUT NOCOPY VARCHAR2,
253 x_msg_count OUT NOCOPY NUMBER,
254 x_msg_data OUT NOCOPY VARCHAR2,
255 p_ppydv_rec IN ppydv_rec_type,
256 x_ppydv_rec OUT NOCOPY ppydv_rec_type);
257
258 PROCEDURE update_party_payment_dtls(
259 p_api_version IN NUMBER,
260 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_tbl IN ppydv_tbl_type,
265 x_ppydv_tbl OUT NOCOPY ppydv_tbl_type);
266
267 PROCEDURE delete_party_payment_dtls(
268 p_api_version IN NUMBER,
269 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
270 x_return_status OUT NOCOPY VARCHAR2,
271 x_msg_count OUT NOCOPY NUMBER,
272 x_msg_data OUT NOCOPY VARCHAR2,
273 p_ppydv_rec IN ppydv_rec_type);
274
275 PROCEDURE delete_party_payment_dtls(
276 p_api_version IN NUMBER,
277 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
278 x_return_status OUT NOCOPY VARCHAR2,
279 x_msg_count OUT NOCOPY NUMBER,
280 x_msg_data OUT NOCOPY VARCHAR2,
281 p_ppydv_tbl IN ppydv_tbl_type);
282
283 PROCEDURE validate_party_payment_dtls(
284 p_api_version IN NUMBER,
285 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_ppydv_rec IN ppydv_rec_type);
290
291 PROCEDURE validate_party_payment_dtls(
292 p_api_version IN NUMBER,
293 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_ppydv_tbl IN ppydv_tbl_type);
298
299 PROCEDURE create_evgrn_party_roles(
300 p_api_version IN NUMBER,
301 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
302 x_return_status OUT NOCOPY VARCHAR2,
303 x_msg_count OUT NOCOPY NUMBER,
304 x_msg_data OUT NOCOPY VARCHAR2,
305 p_chr_id IN NUMBER,
306 p_vendor_id IN NUMBER,
307 x_cle_tbl OUT NOCOPY evg_cle_tbl_type);
308
309 PROCEDURE create_evgrn_party_roles(
310 p_api_version IN NUMBER,
311 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
312 x_return_status OUT NOCOPY VARCHAR2,
313 x_msg_count OUT NOCOPY NUMBER,
314 x_msg_data OUT NOCOPY VARCHAR2,
315 p_chr_id IN NUMBER,
316 p_vendor_id IN NUMBER,
317 x_cpl_id OUT NOCOPY NUMBER);
318
319
320
321 END OKL_PARTY_PAYMENTS_PVT;