[Home] [Help]
1: PACKAGE BODY OE_Payment_Data_Migration_Util AS
2: -- $Header: OEXUPDMB.pls 120.15.12010000.2 2008/08/04 15:04:23 amallik ship $
3: --+=======================================================================+
4: --| Copyright (c) 2000 Oracle Corporation |
5: --| Redwood Shores, CA, USA |
8: --| FILENAME |
9: --| OEXUPDMB.pls |
10: --| |
11: --| DESCRIPTION |
12: --| Package Spec of OE_Payment_Data_Migration_Util |
13: --| This package body contains some utility procedures for handling |
14: --| payment data migration of an closed order to oracle payment. |
15: --| |
16: --| PROCEDURE LIST |
22: --| HISTORY |
23: --| JUN-25-2005 Initial creation |
24: --+=======================================================================+
25:
26: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Payment_Data_Migration_Util';
27:
28: --6757060
29: Function Strip_Non_Numeric_Char(
30: p_credit_card_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE
163: AND uba.acct_site_use_id = su.site_use_id
164: AND uba.payment_function = 'CUSTOMER_PAYMENT'
165: AND uba.instrument_type = 'CREDITCARD'
166: AND ba.bank_account_id = uba.bank_account_id
167: AND ba.bank_account_num = OE_Payment_Data_Migration_Util.Strip_Non_Numeric_Char(ooh.credit_card_number) --6757060
168: AND ba.bank_branch_id = 1
169: AND ba.account_type = 'EXTERNAL'
170: AND ba.bank_account_id = bau.external_bank_account_id
171: AND bau.customer_site_use_id = ooh.invoice_to_org_id
204: AND uba.cust_account_id = cas.cust_account_id
205: AND uba.acct_site_use_id = su.site_use_id
206: AND uba.payment_function = 'CUSTOMER_PAYMENT'
207: AND uba.instrument_type = 'CREDITCARD'
208: AND IBY_CC_SECURITY_PUB.get_segment_id(OE_Payment_Data_Migration_Util.Strip_Non_Numeric_Char(ooh.credit_card_number))
209: = seg.sec_segment_id --6757060
210: AND (seg.cc_number_hash1 = cc.cc_number_hash1
211: AND seg.cc_number_hash2 = cc.cc_number_hash2)
212: AND cc.instrid = uba.instrument_id
250: AND uba.instrument_type = 'CREDITCARD'
251: AND op.payment_type_code = 'CREDIT_CARD'
252: AND op.credit_card_number IS NOT NULL
253: AND ba.bank_account_id = uba.bank_account_id
254: AND ba.bank_account_num = OE_Payment_Data_Migration_Util.Strip_Non_Numeric_Char(op.credit_card_number) --6757060
255: AND ba.bank_branch_id = 1
256: AND ba.account_type = 'EXTERNAL'
257: AND ba.bank_account_id = bau.external_bank_account_id
258: AND bau.customer_site_use_id = ooh.invoice_to_org_id
292: AND uba.payment_function = 'CUSTOMER_PAYMENT'
293: AND uba.instrument_type = 'CREDITCARD'
294: AND op.payment_type_code = 'CREDIT_CARD'
295: AND op.credit_card_number IS NOT NULL
296: AND IBY_CC_SECURITY_PUB.get_segment_id(OE_Payment_Data_Migration_Util.Strip_Non_Numeric_Char(op.credit_card_number))
297: = seg.sec_segment_id --6757060
298: AND (seg.cc_number_hash1 = cc.cc_number_hash1
299: AND seg.cc_number_hash2 = cc.cc_number_hash2)
300: AND cc.instrid = uba.instrument_id
1600:
1601: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Error : '||substr(sqlerrm,1,200));
1602: END Purge_Data_WKR ;
1603:
1604: END OE_Payment_Data_Migration_Util ;