[Home] [Help]
PACKAGE: APPS.PON_EMD_AR_INTEGRATION_GRP
Source
1 PACKAGE pon_emd_ar_integration_grp AUTHID CURRENT_USER AS
2 /* $Header: PONGARIS.pls 120.4.12020000.3 2013/02/09 06:10:53 hvutukur ship $ */
3
4
5 g_fnd_debug CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
6 g_pkg_name CONSTANT VARCHAR2(50) := 'PON_EMD_AR_INTEGRATION_GRP';
7 g_module_prefix CONSTANT VARCHAR2(50) := 'pon.plsql.' || g_pkg_name || '.';
8
9
13 G_EMD_REFUND CONSTANT VARCHAR2(50) := 'EMD_REFUND';
10 --Constants for Transaction_type_codes
11
12 G_EMD_DEPOSIT CONSTANT VARCHAR2(50) := 'EMD_DEPOSIT';
14 G_EMD_FORFEIT CONSTANT VARCHAR2(50) := 'EMD_FORFEIT';
15
16
17 --Constants for Payment_type_codes
18
19 G_CASH CONSTANT VARCHAR2(50) := 'CASH';
20 G_CHECK CONSTANT VARCHAR2(50) := 'CHECK';
21 G_DEMAND_DRAFT CONSTANT VARCHAR2(50) := 'DEMAND_DRAFT';
22 G_CREDIT_CARD CONSTANT VARCHAR2(50) := 'CREDIT_CARD';
23 G_BANK_ACCT_XFER CONSTANT VARCHAR2(50) := 'BANK_ACCT_XFER';
24 G_CORPORATE_EMD CONSTANT VARCHAR2(50) := 'CORPORATE_EMD';
25
26 TYPE DEPOSIT_INFO_IN_RECTYPE IS RECORD
27 ( deposit_date ra_customer_trx.trx_date%type,
28 party_id hz_parties.party_id%type,
29 party_site_id hz_party_sites.party_site_id%type,
30 party_contact_id hz_parties.party_id%TYPE,
31 vendor_id ap_suppliers.vendor_id%type,
32 vendor_site_id ap_supplier_sites.vendor_site_id%type,
33 vendor_name pon_bidding_parties.trading_partner_name%TYPE,
34 vendor_site_name hz_party_sites.party_site_name%TYPE,
35 vendor_contact_name pon_bidding_parties.trading_partner_contact_name%TYPE,
36 customer_id ra_customer_trx.bill_to_customer_id%TYPE,
37 bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%TYPE,
38 deposit_amount NUMBER,
39 deposit_currency pon_emd_transactions.transaction_currency_code%type,
40 exchange_rate_type pon_emd_transactions.exchange_rate_type%type,
41 exchange_date pon_emd_transactions.exchange_date%type,
42 exchange_rate pon_emd_transactions.exchange_rate%type,
43 receipt_method_id ar_receipt_methods.RECEIPT_METHOD_ID%TYPE,
44 customer_bank_account_id ra_customer_trx.customer_bank_account_id%TYPE,
45 org_id NUMBER,
46 auction_header_id pon_auction_headers_all.auction_header_id%TYPE,
47 document_number pon_auction_headers_all.document_number%TYPE,
48 batch_source_id ra_batch_sources.batch_source_id%TYPE,
49 trx_type_id ra_cust_trx_types.cust_trx_type_id%TYPE,
50 memo_line_id NUMBER,
51 paying_location hz_locations.city%TYPE,
52 in_favor_of pon_emd_transactions.in_favor_of%type,
53 cheque_number pon_emd_transactions.cheque_number%type,
54 cash_bearer_name pon_emd_transactions.cash_bearer_name%type,
55 payable_at pon_emd_transactions.payable_at%type,
56 demand_draft_num pon_emd_transactions.demand_draft_num%type,
57 bank_name pon_emd_transactions.bank_name%TYPE,
58 bank_branch_name pon_emd_transactions.bank_branch_name%TYPE,
59 bank_account_num pon_emd_transactions.bank_account_num%TYPE,
60 payment_trxn_extension_id NUMBER,
61 payment_type_code pon_emd_transactions.payment_type_code%TYPE,
62 emd_transaction_id pon_emd_transactions.emd_transaction_id%TYPE,
63 EMD_TRX_GROUP_ID pon_emd_transactions.emd_transaction_group_id%TYPE
64 );
65
66 TYPE DEPOSIT_INFO_OUT_RECTYPE IS RECORD
67 ( deposit_trx_number ra_customer_trx.trx_number%TYPE,
68 deposit_trx_id ra_customer_trx.customer_trx_id%TYPE,
69 deposit_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE
70 );
71
72 TYPE RECEIPT_INFO_IN_RECTYPE IS RECORD
73 ( party_id hz_parties.party_id%type,
74 vendor_site_id ap_supplier_sites.vendor_site_id%type,
75 customer_id ra_customer_trx.bill_to_customer_id%TYPE,
76 party_site_id hz_party_sites.party_site_id%type,
77 vendor_contact_id ap_supplier_contacts.vendor_contact_id%type,
78 exchange_rate_type ra_customer_trx.exchange_rate_type%type,
79 exchange_date ra_customer_trx.exchange_date%type,
80 exchange_rate ra_customer_trx.exchange_rate%type,
81 receipt_method_id ar_receipt_methods.RECEIPT_METHOD_ID%TYPE,
82 receipt_amount ar_cash_receipts.amount%TYPE,
83 receipt_date ar_cash_receipts.receipt_date%TYPE,
84 deposit_date ar_cash_receipts.deposit_date%TYPE,
85 org_id NUMBER
86 );
87
88 TYPE RECEIPT_INFO_OUT_RECTYPE IS RECORD
89 ( receipt_id number
90 );
91
92 TYPE UNAPPLY_INFO_IN_RECTYPE IS RECORD
93 (
94 cash_receipt_id NUMBER,
95 deposit_trx_id ra_customer_trx.customer_trx_id%TYPE,
96 transaction_date DATE,
97 receivable_app_id NUMBER,
98 org_id NUMBER
99 );
100
101
102 TYPE UNAPPLY_INFO_OUT_RECTYPE IS RECORD
103 (
104 receipt_id NUMBER
105 );
106
107
108 TYPE REFUND_INFO_IN_RECTYPE IS RECORD
109 (
110 receipt_num ar_cash_receipts.receipt_number%TYPE,
111 cash_receipt_id NUMBER,
112 amount_applied NUMBER,
113 apply_date ar_receivable_applications.apply_date%TYPE,
114 apply_gl_date ar_receivable_applications.gl_date%TYPE,
115 payment_method_code ap_invoices.payment_method_code%TYPE,
116 applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE,
117 org_id NUMBER
118 );
119
120 TYPE REFUND_INFO_OUT_RECTYPE IS RECORD
121 (
122 application_ref_id ar_receivable_applications.application_ref_id%TYPE,
123 application_ref_type ar_receivable_applications.application_ref_type%TYPE,
124 application_ref_num ar_receivable_applications.application_ref_type%TYPE
125 );
126
127 TYPE FORFEIT_INFO_IN_RECTYPE IS RECORD
128 (
129 trx_type_id ra_cust_trx_types.cust_trx_type_id%TYPE,
133 cust_account_id ra_customer_trx.bill_to_customer_id%TYPE,
130 deposit_trx_id ra_customer_trx.customer_trx_id%TYPE,
131 transaction_currency_code ra_customer_trx.invoice_currency_code%TYPE,
132 transaction_date DATE,
134 cust_acct_site_id HZ_CUST_ACCT_SITES.cust_acct_site_id%TYPE,
135 site_use_id ra_customer_trx.bill_to_site_use_id%TYPE,
136 exchange_rate_type ra_customer_trx.exchange_rate_type%type,
137 exchange_date ra_customer_trx.exchange_date%type,
138 exchange_rate ra_customer_trx.exchange_rate%type,
139 receipt_method_id ar_receipt_methods.receipt_method_id%TYPE,
140 org_id NUMBER,
141 auction_header_id pon_auction_headers_all.auction_header_id%TYPE,
142 document_number pon_auction_headers_all.document_number%TYPE,
143 party_id hz_parties.party_id%type,
144 party_site_id hz_party_sites.party_site_id%type,
145 party_contact_id hz_parties.party_id%TYPE,
146 vendor_id ap_suppliers.vendor_id%type,
147 vendor_site_id ap_supplier_sites.vendor_site_id%type,
148 vendor_name pon_bidding_parties.trading_partner_name%TYPE,
149 vendor_site_name hz_party_sites.party_site_name%TYPE,
150 vendor_contact_name pon_bidding_parties.trading_partner_contact_name%TYPE,
151 amount NUMBER,
152 memo_line_id NUMBER,
153 batch_source_id ra_batch_sources.batch_source_id%TYPE,
154 payment_term_id NUMBER,
155 emd_trx_group_id pon_emd_transactions.emd_transaction_group_id%TYPE,
156 emd_transaction_id pon_emd_transactions.emd_transaction_id%TYPE,
157 trx_count_in_group NUMBER,
158 current_trx_number NUMBER
159 );
160
161 TYPE FORFEIT_INFO_OUT_RECTYPE IS RECORD
162 (
163 inv_trx_number NUMBER,
164 inv_trx_id NUMBER,
165 error_message VARCHAR2(4000)
166 );
167
168
169 TYPE CM_INFO_IN_RECTYPE IS RECORD
170 (
171 customer_trx_id NUMBER,
172 customer_trx_line_id NUMBER,
173 line_amount NUMBER,
174 org_id NUMBER,
175 batch_source_id NUMBER,
176 document_number pon_auction_headers_all.document_number%TYPE,
177 party_id hz_parties.party_id%type,
178 party_site_id hz_party_sites.party_site_id%type,
179 party_contact_id hz_parties.party_id%TYPE,
180 emd_transaction_id pon_emd_transactions.emd_transaction_id%TYPE,
181 emd_trx_group_id pon_emd_transactions.emd_transaction_group_id%TYPE
182 );
183
184 TYPE CM_INFO_OUT_RECTYPE IS RECORD
185 (
186 cm_trx_number NUMBER,
187 cm_customer_trx_id NUMBER,
188 cm_customer_trx_line_id NUMBER
189 );
190
191
192 TYPE PARTY_INFO_IN_RECTYPE IS RECORD
193 (
194 party_id hz_parties.party_id%TYPE,
195 party_name hz_parties.party_name%TYPE,
196 terms_id NUMBER
197 );
198
199 TYPE PARTY_INFO_OUT_RECTYPE IS RECORD
200 (
201 party_id hz_parties.party_id%TYPE,
202 party_NUMBER hz_parties.party_number%TYPE,
203 cust_account_id hz_cust_accounts.cust_account_id%TYPE,
204 account_number hz_cust_accounts.account_number%TYPE
205 );
206
207 TYPE PARTY_SITE_INFO_IN_RECTYPE IS RECORD
208 (
209 party_id hz_parties.party_id%TYPE,
210 party_name hz_parties.party_name%TYPE,
211 party_site_id hz_party_sites.party_site_id%TYPE,
212 cust_account_id hz_cust_accounts.cust_account_id%TYPE,
213 org_id NUMBER,
214 location hz_locations.city%TYPE,
215 terms_id NUMBER
216
217 );
218
219 TYPE PARTY_SITE_INFO_OUT_RECTYPE IS RECORD
220 (
221 cust_acct_site_id HZ_CUST_ACCT_SITES.cust_acct_site_id%TYPE,
222 site_use_id HZ_CUST_SITE_USES.site_use_id%TYPE
223 );
224
225
226 TYPE pon_emd_trx_rec IS RECORD
227 (
228 TRADING_PARTNER_ID PON_BIDDING_PARTIES.TRADING_PARTNER_ID%TYPE,
229 TRADING_PARTNER_CONTACT_ID PON_BIDDING_PARTIES.TRADING_PARTNER_CONTACT_ID%TYPE,
230 TRADING_PARTNER_NAME PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE,
231 TRADING_PARTNER_CONTACT_NAME PON_BIDDING_PARTIES.TRADING_PARTNER_CONTACT_NAME%TYPE,
232 VENDOR_SITE_ID PON_BIDDING_PARTIES.VENDOR_SITE_ID%TYPE,
233 EMD_TRANSACTION_ID PON_EMD_TRANSACTIONS.EMD_TRANSACTION_ID%TYPE,
234 TRANSACTION_TYPE_CODE PON_EMD_TRANSACTIONS.TRANSACTION_TYPE_CODE%TYPE,
235 TRANSACTION_DATE PON_EMD_TRANSACTIONS.TRANSACTION_DATE%TYPE,
236 PAYMENT_TYPE_CODE PON_EMD_TRANSACTIONS.PAYMENT_TYPE_CODE%TYPE,
237 COUNTRY_CODE PON_EMD_TRANSACTIONS.COUNTRY_CODE%TYPE,
238 BANK_NAME PON_EMD_TRANSACTIONS.BANK_NAME%TYPE,
239 BANK_BRANCH_NAME PON_EMD_TRANSACTIONS.BANK_BRANCH_NAME%TYPE,
240 BANK_ACCOUNT_NUM PON_EMD_TRANSACTIONS.BANK_ACCOUNT_NUM%TYPE,
241 BANK_ACCOUNT_CURRENCY PON_EMD_TRANSACTIONS.BANK_ACCOUNT_CURRENCY%TYPE,
242 BANK_GURANTEE_NUMBER PON_EMD_TRANSACTIONS.BANK_GURANTEE_NUMBER%TYPE,
243 IN_FAVOR_OF PON_EMD_TRANSACTIONS.IN_FAVOR_OF%TYPE,
244 CHEQUE_NUMBER PON_EMD_TRANSACTIONS.CHEQUE_NUMBER%TYPE,
245 CASH_BEARER_NAME PON_EMD_TRANSACTIONS.CASH_BEARER_NAME%TYPE,
246 PAYABLE_AT PON_EMD_TRANSACTIONS.PAYABLE_AT%TYPE,
247 DEMAND_DRAFT_NUM PON_EMD_TRANSACTIONS.DEMAND_DRAFT_NUM%TYPE,
248 CREDIT_CARD_NUM PON_EMD_TRANSACTIONS.CREDIT_CARD_NUM%TYPE,
249 NAME_ON_CARD PON_EMD_TRANSACTIONS.NAME_ON_CARD%TYPE,
250 CARD_ISSUER_CODE PON_EMD_TRANSACTIONS.CARD_ISSUER_CODE%TYPE,
251 PURCHASE_CARD_FLAG PON_EMD_TRANSACTIONS.PURCHASE_CARD_FLAG%TYPE,
252 SINGLE_USE_FLAG PON_EMD_TRANSACTIONS.SINGLE_USE_FLAG%TYPE,
253 EXPIRY_DATE PON_EMD_TRANSACTIONS.EXPIRY_DATE%TYPE,
254 TRANSACTION_CURRENCY_CODE PON_EMD_TRANSACTIONS.TRANSACTION_CURRENCY_CODE%TYPE,
255 EXCHANGE_RATE_TYPE PON_EMD_TRANSACTIONS.EXCHANGE_RATE_TYPE%TYPE,
256 EXCHANGE_DATE PON_EMD_TRANSACTIONS.EXCHANGE_DATE%TYPE,
257 EXCHANGE_RATE PON_EMD_TRANSACTIONS.EXCHANGE_RATE%TYPE,
258 AMOUNT PON_EMD_TRANSACTIONS.AMOUNT%TYPE,
259 POSTED_TO_FINANCE PON_EMD_TRANSACTIONS.POSTED_TO_FINANCE%TYPE,
260 PARENT_EMD_TRANSACTION_ID PON_EMD_TRANSACTIONS.PARENT_EMD_TRANSACTION_ID%TYPE,
261 ORG_ID PON_EMD_TRANSACTIONS.ORG_ID%TYPE,
262 AUCTION_HEADER_ID PON_EMD_TRANSACTIONS.AUCTION_HEADER_ID%TYPE,
263 STATUS_LOOKUP_CODE PON_EMD_TRANSACTIONS.STATUS_LOOKUP_CODE%TYPE,
264 DOCUMENT_NUMBER PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE,
265 EMD_ENABLE_FLAG PON_AUCTION_HEADERS_ALL.EMD_ENABLE_FLAG%TYPE,
266 EMD_AMOUNT PON_AUCTION_HEADERS_ALL.EMD_AMOUNT%TYPE,
267 EMD_DUE_DATE PON_AUCTION_HEADERS_ALL.EMD_DUE_DATE%TYPE,
268 EMD_TYPE PON_AUCTION_HEADERS_ALL.EMD_TYPE%TYPE,
269 EMD_GUARANTEE_EXPIRY_DATE PON_AUCTION_HEADERS_ALL.EMD_GUARANTEE_EXPIRY_DATE%TYPE,
270 EMD_ADDITIONAL_INFORMATION PON_AUCTION_HEADERS_ALL.EMD_ADDITIONAL_INFORMATION%TYPE,
271 POST_EMD_TO_FINANCE PON_AUCTION_HEADERS_ALL.POST_EMD_TO_FINANCE%TYPE,
272 VENDOR_ID AP_SUPPLIERS.VENDOR_ID%TYPE,
273 CURRENCY_CODE PON_AUCTION_HEADERS_ALL.CURRENCY_CODE%TYPE,
274 ERROR_MESSAGE PON_EMD_TRANSACTIONS.ERROR_MESSAGE%TYPE,
275 EMD_TRX_GROUP_ID PON_EMD_TRANSACTIONS.EMD_TRANSACTION_GROUP_ID%TYPE
276
277 );
278
279 TYPE pon_emd_trx_info_Tbl_Type IS TABLE OF pon_emd_trx_rec
280 INDEX BY BINARY_INTEGER;
281
282
283
284 CURSOR emd_transactions_info(x_emd_trx_group_id NUMBER,
285 x_auction_header_id NUMBER,
286 x_transaction_type_code VARCHAR2)
287 IS
288 SELECT BP.TRADING_PARTNER_ID,
289 BP.TRADING_PARTNER_CONTACT_ID,
290 BP.TRADING_PARTNER_NAME,
291 BP.TRADING_PARTNER_CONTACT_NAME,
292 BP.VENDOR_SITE_ID,
293 ET.EMD_TRANSACTION_ID,
294 ET.TRANSACTION_TYPE_CODE,
295 ET.TRANSACTION_DATE,
296 ET.PAYMENT_TYPE_CODE,
297 ET.COUNTRY_CODE,
298 ET.BANK_NAME,
299 ET.BANK_BRANCH_NAME,
300 ET.BANK_ACCOUNT_NUM,
301 ET.BANK_ACCOUNT_CURRENCY,
302 ET.BANK_GURANTEE_NUMBER,
303 ET.IN_FAVOR_OF,
304 ET.CHEQUE_NUMBER,
305 ET.CASH_BEARER_NAME,
306 ET.PAYABLE_AT,
307 ET.DEMAND_DRAFT_NUM,
308 ET.CREDIT_CARD_NUM,
309 ET.NAME_ON_CARD,
310 ET.CARD_ISSUER_CODE,
311 ET.PURCHASE_CARD_FLAG,
312 ET.SINGLE_USE_FLAG,
313 ET.EXPIRY_DATE,
314 ET.TRANSACTION_CURRENCY_CODE,
315 ET.EXCHANGE_RATE_TYPE,
316 ET.EXCHANGE_DATE,
317 ET.EXCHANGE_RATE,
318 ET.AMOUNT,
319 ET.POSTED_TO_FINANCE,
320 ET.PARENT_EMD_TRANSACTION_ID,
321 ET.ORG_ID,
322 ET.AUCTION_HEADER_ID,
323 ET.STATUS_LOOKUP_CODE,
324 PUH.DOCUMENT_NUMBER,
325 PUH.EMD_ENABLE_FLAG,
326 PUH.EMD_AMOUNT,
327 PUH.EMD_DUE_DATE,
328 PUH.EMD_TYPE,
329 PUH.EMD_GUARANTEE_EXPIRY_DATE,
330 PUH.EMD_ADDITIONAL_INFORMATION,
331 PUH.POST_EMD_TO_FINANCE,
332 SUP.VENDOR_ID,
333 PUH.CURRENCY_CODE,
334 ET.ERROR_MESSAGE,
335 ET.EMD_TRANSACTION_GROUP_ID
336 FROM PON_EMD_TRANSACTIONS ET,
337 PON_BIDDING_PARTIES BP,
338 PON_AUCTION_HEADERS_ALL PUH,
339 AP_SUPPLIERS sup
340 WHERE ET.AUCTION_HEADER_ID = BP.AUCTION_HEADER_ID
341 AND PUH.AUCTION_HEADER_ID = ET.AUCTION_HEADER_ID
342 AND ET.SUPPLIER_SEQUENCE = BP.SEQUENCE
343 AND Nvl(BP.EXEMPT_FLAG,'N') = 'N'
344 AND Nvl(ET.POSTED_TO_FINANCE,'N') = 'N'
345 AND Nvl(PUH.POST_EMD_TO_FINANCE,'N') = 'Y'
346 AND Nvl(PUH.EMD_ENABLE_FLAG,'N') = 'Y'
347 AND Nvl(ET.DELETE_FLAG,'N') = 'N'
348 AND ET.AUCTION_HEADER_ID = x_auction_header_id
349 AND ET.EMD_TRANSACTION_GROUP_ID = x_emd_trx_group_id
350 AND BP.TRADING_PARTNER_ID = SUP.PARTY_ID
351 AND TRANSACTION_TYPE_CODE = x_transaction_type_code
352 AND ET.STATUS_LOOKUP_CODE NOT IN ('RECEIVED','REFUNDED','FORFEITED');
353
354
355 CURSOR payment_type_info(x_payment_type_code VARCHAR2,
356 x_org_id NUMBER)
357 IS
358 SELECT
359 PAYMENT_TYPE_CODE,
360 RECEIPT_METHOD_ID,
361 REFUND_PAYMENT_METHOD
362 FROM PON_EMD_PAYMENT_TYPES_ALL
363 WHERE PAYMENT_TYPE_CODE = x_payment_type_code
364 AND ORG_ID = x_org_id
365 AND ENABLED_FLAG = 'Y';
366
367
368 CURSOR pon_emd_fin_parameters(x_org_id NUMBER)
369 IS
370 SELECT
371 RA_TRX_TYPE_ID,
372 RA_BATCH_SOURCE_ID,
373 RA_IMPORT_BATCH_SOURCE_ID,
374 MEMO_LINE_ID,
375 MEMO_LINE_INVOICE_ID,
376 EMD_FINANCE_INTEGRATION,
377 PAYMENT_TERMS_ID
378 FROM PON_EMD_FIN_PARAMETERS_ALL
379 WHERE ORG_ID = x_org_id;
380
381
382
383 PROCEDURE create_emd_deposit
384 ( p_api_version IN NUMBER,
385 p_init_msg_list IN VARCHAR2,
386 p_commit IN VARCHAR2,
387 x_return_status OUT NOCOPY VARCHAR2,
388 p_in_rec IN DEPOSIT_INFO_IN_RECTYPE,
389 x_out_rec OUT NOCOPY DEPOSIT_INFO_OUT_RECTYPE);
390
391 PROCEDURE create_emd_receipt_and_apply
392 ( p_api_version IN NUMBER,
393 p_init_msg_list IN VARCHAR2,
394 p_commit IN VARCHAR2,
395 x_return_status OUT NOCOPY VARCHAR2,
396 p_in_rec IN RECEIPT_INFO_IN_RECTYPE,
397 x_out_rec OUT NOCOPY RECEIPT_INFO_OUT_RECTYPE);
398
399 PROCEDURE unapply_emd_receipt
400 ( p_api_version IN NUMBER,
401 p_init_msg_list IN VARCHAR2,
402 p_commit IN VARCHAR2,
403 x_return_status OUT NOCOPY VARCHAR2,
404 p_in_rec IN UNAPPLY_INFO_IN_RECTYPE,
405 x_out_rec OUT NOCOPY UNAPPLY_INFO_OUT_RECTYPE);
406
407 PROCEDURE refund_activity_on_emd_receipt
408 ( p_api_version IN NUMBER,
409 p_init_msg_list IN VARCHAR2,
410 p_commit IN VARCHAR2,
411 x_return_status OUT NOCOPY VARCHAR2,
412 p_in_rec IN REFUND_INFO_IN_RECTYPE,
413 x_out_rec OUT NOCOPY REFUND_INFO_OUT_RECTYPE);
414
415 PROCEDURE create_cm_on_emd_deposit
416 ( p_api_version IN NUMBER,
417 p_init_msg_list IN VARCHAR2,
418 p_commit IN VARCHAR2,
419 x_return_status OUT NOCOPY VARCHAR2,
420 p_in_rec IN CM_INFO_IN_RECTYPE,
421 x_out_rec OUT NOCOPY CM_INFO_OUT_RECTYPE);
422
423
424 PROCEDURE create_cust_account
425 ( p_api_version IN NUMBER,
426 p_init_msg_list IN VARCHAR2,
427 p_commit IN VARCHAR2,
428 x_return_status OUT NOCOPY VARCHAR2,
429 p_in_rec IN PARTY_INFO_IN_RECTYPE,
430 x_out_rec OUT NOCOPY PARTY_INFO_OUT_RECTYPE);
431
432
433 PROCEDURE create_cust_acc_site_and_usage
434 ( p_api_version IN NUMBER,
435 p_init_msg_list IN VARCHAR2,
436 p_commit IN VARCHAR2,
437 x_return_status OUT NOCOPY VARCHAR2,
438 p_in_rec IN PARTY_SITE_INFO_IN_RECTYPE,
439 x_out_rec OUT NOCOPY PARTY_SITE_INFO_OUT_RECTYPE);
440
441
442
443 PROCEDURE get_customer_info
444 ( p_party_id IN NUMBER,
445 p_vendor_site_id IN NUMBER,
446 p_org_id IN NUMBER,
447 p_payment_terms_id IN NUMBER,
448 x_cust_account_id OUT NOCOPY NUMBER,
449 x_cust_acct_site_id OUT NOCOPY NUMBER,
450 x_party_name OUT NOCOPY VARCHAR2,
451 x_party_site_id OUT NOCOPY NUMBER,
452 x_party_site_name OUT NOCOPY VARCHAR2,
453 x_site_use_id OUT NOCOPY NUMBER,
454 x_location OUT NOCOPY VARCHAR2,
455 x_return_status OUT NOCOPY VARCHAR2);
456 /*
457 PROCEDURE get_bank_info(p_cust_account_id IN NUMBER,
458 p_cust_acct_site_id IN NUMBER,
459 p_site_use_id IN NUMBER,
460 p_org_id IN NUMBER,
461 p_party_id IN NUMBER,
462 p_party_site_id IN NUMBER,
463 p_country_code IN VARCHAR2,
464 p_bank_name IN VARCHAR2,
465 p_bank_branch_name IN VARCHAR2,
466 p_bank_account_num IN VARCHAR2,
467 p_accountcurrency IN VARCHAR2,
468 x_bank_id OUT NOCOPY NUMBER,
469 x_branch_id OUT NOCOPY NUMBER,
470 x_acct_id OUT NOCOPY NUMBER,
471 x_account_assignment_id OUT NOCOPY NUMBER,
472 x_return_status OUT NOCOPY VARCHAR2);
473
474
475 PROCEDURE get_credit_card_info(p_cust_account_id IN NUMBER,
476 p_cust_acct_site_id IN NUMBER,
477 p_site_use_id IN NUMBER,
478 p_party_id IN NUMBER,
479 p_party_site_id IN NUMBER,
480 p_org_id IN NUMBER,
481 p_country_code IN VARCHAR2,
482 p_credit_card_num IN VARCHAR2,
483 p_expiry_date IN DATE,
484 p_name_on_card IN VARCHAR2,
485 p_card_issuer_code IN VARCHAR2,
486 p_purchase_card_flag IN VARCHAR2,
487 p_single_use_flag IN VARCHAR2,
488 x_card_assignment_id OUT NOCOPY NUMBER,
489 x_return_status OUT NOCOPY VARCHAR2);
490 */
491 PROCEDURE getTrxInfoFromParentTrx(p_parent_emd_transaction_id IN NUMBER,
492 x_parent_trx_number OUT NOCOPY pon_emd_transactions.CUST_TRX_NUMBER%TYPE,
493 x_parent_trx_id OUT NOCOPY pon_emd_transactions.CUST_TRX_ID%TYPE,
494 x_parent_trx_line_id OUT NOCOPY pon_emd_transactions.CUST_TRX_LINE_ID%TYPE,
495 x_deposit_payment_type_code OUT NOCOPY VARCHAR2,
496 x_org_id OUT NOCOPY NUMBER,
497 x_return_status OUT NOCOPY VARCHAR2);
498
499
500 PROCEDURE getReceiptInfoOfParentTrx(p_parent_trx_id IN NUMBER,
501 p_parent_trx_number IN VARCHAR2,
502 p_org_id IN NUMBER,
503 x_receipt_num OUT NOCOPY VARCHAR2,
504 x_cash_receipt_id OUT NOCOPY NUMBER,
505 x_receivable_app_id OUT NOCOPY NUMBER,
506 x_receipt_status OUT NOCOPY VARCHAR2,
507 x_return_status OUT NOCOPY VARCHAR2);
508
509 PROCEDURE validate_trx_info(p_emd_transaction_rec IN pon_emd_trx_rec,
510 p_transaction_type_code IN VARCHAR2,
511 x_return_status OUT NOCOPY VARCHAR2);
512
513
514 PROCEDURE validate_pon_emd_fin(p_emd_fin_integration IN VARCHAR2,
515 p_ra_trx_type_id IN NUMBER,
516 p_ra_batch_source_id IN NUMBER,
517 p_ra_import_batch_source_id IN NUMBER,
518 p_memo_line_id IN NUMBER,
519 p_memo_line_invoice_id IN NUMBER,
520 p_payment_terms_id IN NUMBER,
521 p_transaction_type_code IN VARCHAR2,
522 p_org_id IN NUMBER,
523 x_return_status OUT NOCOPY VARCHAR2);
524
525 PROCEDURE validate_trx_payment_type_info(p_receipt_method_id IN NUMBER,
526 p_refund_payment_method IN VARCHAR2,
527 p_payment_type_code IN VARCHAR2,
528 p_transaction_type_code IN VARCHAR2,
529 p_org_id IN NUMBER,
530 x_return_status OUT NOCOPY VARCHAR2);
531
532
533 PROCEDURE verify_finance_installation(x_return_status OUT NOCOPY VARCHAR2);
534
535 PROCEDURE post_emd_deposit_transactions(p_api_version IN NUMBER,
536 p_emd_trx_group_id IN NUMBER,
537 p_auction_header_id IN NUMBER,
538 x_process_complete OUT NOCOPY VARCHAR2);
539
540 PROCEDURE post_emd_refund_transactions(p_api_version IN NUMBER,
541 p_emd_trx_group_id IN NUMBER,
542 p_auction_header_id IN NUMBER,
543 x_process_complete OUT NOCOPY VARCHAR2);
544
545 PROCEDURE post_emd_forfeit_transactions(p_api_version IN NUMBER,
546 p_emd_trx_group_id IN NUMBER,
547 p_auction_header_id IN NUMBER,
548 x_process_complete OUT NOCOPY VARCHAR2);
549
550 PROCEDURE process_emd_forfeit_trans ( p_api_version IN NUMBER,
551 p_emd_trx_group_id IN NUMBER,
552 p_auction_header_id IN NUMBER);
553
554 PROCEDURE process_emd_refund_trans ( p_api_version IN NUMBER,
555 p_emd_trx_group_id IN NUMBER,
556 p_auction_header_id IN NUMBER);
557
558
559 PROCEDURE emd_refund_forfeit_conc(errbuf OUT NOCOPY VARCHAR2,
560 retcode OUT NOCOPY VARCHAR2,
561 p_api_version IN NUMBER,
562 p_emd_trx_group_id IN NUMBER,
563 p_auction_header_id IN NUMBER,
564 p_emd_trx_type IN VARCHAR2);
565
566
567
568 PROCEDURE update_emd_trx_error_status(p_emd_transaction_id IN NUMBER,
569 p_msg_data IN VARCHAR2);
570
571 PROCEDURE update_trx_status_lookup_code(p_emd_transaction_id IN NUMBER);
572
573 PROCEDURE insert_and_call_autoinvoice(p_in_rec IN FORFEIT_INFO_IN_RECTYPE,
574 p_in_emd_trx IN pon_emd_trx_info_Tbl_Type,
575 x_return_status OUT NOCOPY VARCHAR2);
576
577
578 PROCEDURE print_log(p_message IN VARCHAR2);
579
580 END PON_EMD_AR_INTEGRATION_GRP;