[Home] [Help]
1: PACKAGE BODY OE_Payment_Data_Migration_Util AS
2: -- $Header: OEXUPDMB.pls 120.15.12010000.3 2009/08/14 06:05:36 msundara 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
202: AND uba.acct_site_use_id = su.site_use_id
203: AND uba.payment_function = 'CUSTOMER_PAYMENT'
204: AND uba.instrument_type = 'CREDITCARD'
205: AND ba.bank_account_id = uba.bank_account_id
206: AND ba.bank_account_num = OE_Payment_Data_Migration_Util.Strip_Non_Numeric_Char(ooh.credit_card_number) --6757060
207: AND ba.bank_branch_id = 1
208: AND ba.account_type = 'EXTERNAL'
209: AND ba.bank_account_id = bau.external_bank_account_id
210: AND bau.customer_site_use_id = ooh.invoice_to_org_id
243: AND uba.cust_account_id = cas.cust_account_id
244: AND uba.acct_site_use_id = su.site_use_id
245: AND uba.payment_function = 'CUSTOMER_PAYMENT'
246: AND uba.instrument_type = 'CREDITCARD'
247: AND IBY_CC_SECURITY_PUB.get_segment_id(OE_Payment_Data_Migration_Util.Strip_Non_Numeric_Char(ooh.credit_card_number))
248: = seg.sec_segment_id --6757060
249: AND (seg.cc_number_hash1 = cc.cc_number_hash1
250: AND seg.cc_number_hash2 = cc.cc_number_hash2)
251: AND cc.instrid = uba.instrument_id
289: AND uba.instrument_type = 'CREDITCARD'
290: AND op.payment_type_code = 'CREDIT_CARD'
291: AND op.credit_card_number IS NOT NULL
292: AND ba.bank_account_id = uba.bank_account_id
293: AND ba.bank_account_num = OE_Payment_Data_Migration_Util.Strip_Non_Numeric_Char(op.credit_card_number) --6757060
294: AND ba.bank_branch_id = 1
295: AND ba.account_type = 'EXTERNAL'
296: AND ba.bank_account_id = bau.external_bank_account_id
297: AND bau.customer_site_use_id = ooh.invoice_to_org_id
331: AND uba.payment_function = 'CUSTOMER_PAYMENT'
332: AND uba.instrument_type = 'CREDITCARD'
333: AND op.payment_type_code = 'CREDIT_CARD'
334: AND op.credit_card_number IS NOT NULL
335: AND IBY_CC_SECURITY_PUB.get_segment_id(OE_Payment_Data_Migration_Util.Strip_Non_Numeric_Char(op.credit_card_number))
336: = seg.sec_segment_id --6757060
337: AND (seg.cc_number_hash1 = cc.cc_number_hash1
338: AND seg.cc_number_hash2 = cc.cc_number_hash2)
339: AND cc.instrid = uba.instrument_id
1639:
1640: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Error : '||substr(sqlerrm,1,200));
1641: END Purge_Data_WKR ;
1642:
1643: END OE_Payment_Data_Migration_Util ;