APPS.OE_PAYMENT_DATA_MIGRATION_UTIL dependencies on IBY_EXT_BANK_ACCOUNTS_V

Line 30: p_credit_card_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE

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
31: )
32: RETURN VARCHAR2
33: IS
34: p_stripped_cc_num iby_ext_bank_accounts_v.bank_account_number%TYPE;

Line 34: p_stripped_cc_num iby_ext_bank_accounts_v.bank_account_number%TYPE;

30: p_credit_card_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE
31: )
32: RETURN VARCHAR2
33: IS
34: p_stripped_cc_num iby_ext_bank_accounts_v.bank_account_number%TYPE;
35: BEGIN
36:
37: IF p_credit_card_num IS NOT NULL THEN
38: ARP_EXT_BANK_PKG.strip_white_spaces(p_credit_card_num,p_stripped_cc_num);

Line 52: p_credit_card_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE

48: --6757060 */
49:
50: --6757060 -- modified for the bug 8731962
51: Function Strip_Non_Numeric_Char(
52: p_credit_card_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE
53: )
54: RETURN VARCHAR2
55: IS
56: TYPE character_tab_typ IS TABLE of char(1) INDEX BY BINARY_INTEGER;

Line 59: p_stripped_cc_num iby_ext_bank_accounts_v.bank_account_number%TYPE;

55: IS
56: TYPE character_tab_typ IS TABLE of char(1) INDEX BY BINARY_INTEGER;
57: len_credit_card_num number := 0;
58: l_cc_num_char character_tab_typ;
59: p_stripped_cc_num iby_ext_bank_accounts_v.bank_account_number%TYPE;
60: BEGIN
61:
62: IF p_credit_card_num IS NOT NULL THEN
63: