eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_EXT_BANKACCT_PUB dependencies on IBY_EXT_BANK_ACCOUNTS

Line 1187: lx_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;

1183: l_owner_rowid VARCHAR2(100);
1184: l_count NUMBER;
1185: l_joint_acct_owner_id NUMBER;
1186:
1187: lx_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;
1188: lx_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
1189: l_masked_ba_num iby_ext_bank_accounts.masked_bank_account_num%TYPE;
1190: l_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
1191: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;

Line 1188: lx_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;

1184: l_count NUMBER;
1185: l_joint_acct_owner_id NUMBER;
1186:
1187: lx_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;
1188: lx_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
1189: l_masked_ba_num iby_ext_bank_accounts.masked_bank_account_num%TYPE;
1190: l_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
1191: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1192: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;

Line 1189: l_masked_ba_num iby_ext_bank_accounts.masked_bank_account_num%TYPE;

1185: l_joint_acct_owner_id NUMBER;
1186:
1187: lx_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;
1188: lx_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
1189: l_masked_ba_num iby_ext_bank_accounts.masked_bank_account_num%TYPE;
1190: l_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
1191: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1192: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1193: l_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;

Line 1190: l_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;

1186:
1187: lx_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;
1188: lx_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
1189: l_masked_ba_num iby_ext_bank_accounts.masked_bank_account_num%TYPE;
1190: l_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
1191: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1192: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1193: l_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;
1194: l_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;

Line 1191: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;

1187: lx_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;
1188: lx_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
1189: l_masked_ba_num iby_ext_bank_accounts.masked_bank_account_num%TYPE;
1190: l_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
1191: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1192: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1193: l_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;
1194: l_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;
1195: l_dup_acct_id number;

Line 1192: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;

1188: lx_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
1189: l_masked_ba_num iby_ext_bank_accounts.masked_bank_account_num%TYPE;
1190: l_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
1191: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1192: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1193: l_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;
1194: l_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;
1195: l_dup_acct_id number;
1196: l_dup_start_date date;

Line 1193: l_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;

1189: l_masked_ba_num iby_ext_bank_accounts.masked_bank_account_num%TYPE;
1190: l_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
1191: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1192: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1193: l_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;
1194: l_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;
1195: l_dup_acct_id number;
1196: l_dup_start_date date;
1197: l_dup_end_date date;

Line 1194: l_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;

1190: l_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
1191: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1192: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1193: l_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;
1194: l_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;
1195: l_dup_acct_id number;
1196: l_dup_start_date date;
1197: l_dup_end_date date;
1198: l_bank_account_num_electronic iby_ext_bank_accounts.bank_account_num_electronic%TYPE;

Line 1198: l_bank_account_num_electronic iby_ext_bank_accounts.bank_account_num_electronic%TYPE;

1194: l_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;
1195: l_dup_acct_id number;
1196: l_dup_start_date date;
1197: l_dup_end_date date;
1198: l_bank_account_num_electronic iby_ext_bank_accounts.bank_account_num_electronic%TYPE;
1199: l_party_id ap_suppliers.party_id%TYPE;
1200: l_supplier_name ap_suppliers.vendor_name%TYPE;
1201: l_supplier_number ap_suppliers.segment1%TYPE;
1202:

Line 1441: -- inserting the new account into IBY_EXT_BANK_ACCOUNTS

1437: l_iban_hash1 := iby_security_pkg.Get_Hash(p_ext_bank_acct_rec.iban,'F');
1438: l_iban_hash2 := iby_security_pkg.Get_Hash(p_ext_bank_acct_rec.iban,'T');
1439: END IF;
1440:
1441: -- inserting the new account into IBY_EXT_BANK_ACCOUNTS
1442: INSERT INTO IBY_EXT_BANK_ACCOUNTS
1443: (
1444: EXT_BANK_ACCOUNT_ID,
1445: COUNTRY_CODE,

Line 1442: INSERT INTO IBY_EXT_BANK_ACCOUNTS

1438: l_iban_hash2 := iby_security_pkg.Get_Hash(p_ext_bank_acct_rec.iban,'T');
1439: END IF;
1440:
1441: -- inserting the new account into IBY_EXT_BANK_ACCOUNTS
1442: INSERT INTO IBY_EXT_BANK_ACCOUNTS
1443: (
1444: EXT_BANK_ACCOUNT_ID,
1445: COUNTRY_CODE,
1446: BRANCH_ID,

Line 1511: IBY_EXT_BANK_ACCOUNTS_S.nextval, --EXT_BANK_ACCOUNT_ID,

1507: SECONDARY_ACCOUNT_REFERENCE -- Bug 7408747
1508: )
1509: VALUES
1510: (
1511: IBY_EXT_BANK_ACCOUNTS_S.nextval, --EXT_BANK_ACCOUNT_ID,
1512: p_ext_bank_acct_rec.country_code, --COUNTRY_CODE,
1513: p_ext_bank_acct_rec.branch_id, --BRANCH_ID,
1514: p_ext_bank_acct_rec.bank_id, --BANK_ID,
1515: p_ext_bank_acct_rec.bank_account_num, --BANK_ACCOUNT_NUM,

Line 1578: print_debuginfo('New Row inserted in IBY_EXT_BANK_ACCOUNTS');

1574: p_ext_bank_acct_rec.secondary_account_reference -- Bug 7408747
1575: ) RETURNING EXT_BANK_ACCOUNT_ID INTO x_acct_id;
1576:
1577: IF (SQL%FOUND) THEN
1578: print_debuginfo('New Row inserted in IBY_EXT_BANK_ACCOUNTS');
1579: ELSE
1580: print_debuginfo('Failed to insert in IBY_EXT_BANK_ACCOUNTS');
1581: RAISE fnd_api.g_exc_unexpected_error;
1582: END IF;

Line 1580: print_debuginfo('Failed to insert in IBY_EXT_BANK_ACCOUNTS');

1576:
1577: IF (SQL%FOUND) THEN
1578: print_debuginfo('New Row inserted in IBY_EXT_BANK_ACCOUNTS');
1579: ELSE
1580: print_debuginfo('Failed to insert in IBY_EXT_BANK_ACCOUNTS');
1581: RAISE fnd_api.g_exc_unexpected_error;
1582: END IF;
1583:
1584: -- End of API

Line 1915: l_acct_number iby_ext_bank_accounts.bank_account_num%TYPE;

1911: l_bank_id NUMBER(15);
1912: l_branch_id NUMBER(15);
1913: l_bank_name VARCHAR2(360);
1914: l_branch_number VARCHAR2(30);
1915: l_acct_number iby_ext_bank_accounts.bank_account_num%TYPE;
1916: l_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;
1917: l_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
1918: l_masked_ba_num iby_ext_bank_accounts.masked_bank_account_num%TYPE;
1919: l_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;

Line 1916: l_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;

1912: l_branch_id NUMBER(15);
1913: l_bank_name VARCHAR2(360);
1914: l_branch_number VARCHAR2(30);
1915: l_acct_number iby_ext_bank_accounts.bank_account_num%TYPE;
1916: l_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;
1917: l_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
1918: l_masked_ba_num iby_ext_bank_accounts.masked_bank_account_num%TYPE;
1919: l_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
1920: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;

Line 1917: l_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;

1913: l_bank_name VARCHAR2(360);
1914: l_branch_number VARCHAR2(30);
1915: l_acct_number iby_ext_bank_accounts.bank_account_num%TYPE;
1916: l_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;
1917: l_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
1918: l_masked_ba_num iby_ext_bank_accounts.masked_bank_account_num%TYPE;
1919: l_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
1920: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1921: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;

Line 1918: l_masked_ba_num iby_ext_bank_accounts.masked_bank_account_num%TYPE;

1914: l_branch_number VARCHAR2(30);
1915: l_acct_number iby_ext_bank_accounts.bank_account_num%TYPE;
1916: l_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;
1917: l_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
1918: l_masked_ba_num iby_ext_bank_accounts.masked_bank_account_num%TYPE;
1919: l_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
1920: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1921: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1922: l_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;

Line 1919: l_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;

1915: l_acct_number iby_ext_bank_accounts.bank_account_num%TYPE;
1916: l_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;
1917: l_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
1918: l_masked_ba_num iby_ext_bank_accounts.masked_bank_account_num%TYPE;
1919: l_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
1920: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1921: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1922: l_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;
1923: l_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;

Line 1920: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;

1916: l_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;
1917: l_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
1918: l_masked_ba_num iby_ext_bank_accounts.masked_bank_account_num%TYPE;
1919: l_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
1920: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1921: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1922: l_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;
1923: l_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;
1924: l_iban iby_ext_bank_accounts.iban%TYPE;

Line 1921: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;

1917: l_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
1918: l_masked_ba_num iby_ext_bank_accounts.masked_bank_account_num%TYPE;
1919: l_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
1920: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1921: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1922: l_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;
1923: l_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;
1924: l_iban iby_ext_bank_accounts.iban%TYPE;
1925: l_encrypted iby_ext_bank_accounts.encrypted%TYPE;

Line 1922: l_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;

1918: l_masked_ba_num iby_ext_bank_accounts.masked_bank_account_num%TYPE;
1919: l_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
1920: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1921: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1922: l_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;
1923: l_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;
1924: l_iban iby_ext_bank_accounts.iban%TYPE;
1925: l_encrypted iby_ext_bank_accounts.encrypted%TYPE;
1926: l_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;

Line 1923: l_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;

1919: l_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
1920: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1921: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1922: l_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;
1923: l_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;
1924: l_iban iby_ext_bank_accounts.iban%TYPE;
1925: l_encrypted iby_ext_bank_accounts.encrypted%TYPE;
1926: l_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
1927: l_iban_segment_id iby_ext_bank_accounts.iban_sec_segment_id%TYPE;

Line 1924: l_iban iby_ext_bank_accounts.iban%TYPE;

1920: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1921: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1922: l_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;
1923: l_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;
1924: l_iban iby_ext_bank_accounts.iban%TYPE;
1925: l_encrypted iby_ext_bank_accounts.encrypted%TYPE;
1926: l_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
1927: l_iban_segment_id iby_ext_bank_accounts.iban_sec_segment_id%TYPE;
1928: l_bank_account_num_electronic iby_ext_bank_accounts.bank_account_num_electronic%TYPE;

Line 1925: l_encrypted iby_ext_bank_accounts.encrypted%TYPE;

1921: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1922: l_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;
1923: l_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;
1924: l_iban iby_ext_bank_accounts.iban%TYPE;
1925: l_encrypted iby_ext_bank_accounts.encrypted%TYPE;
1926: l_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
1927: l_iban_segment_id iby_ext_bank_accounts.iban_sec_segment_id%TYPE;
1928: l_bank_account_num_electronic iby_ext_bank_accounts.bank_account_num_electronic%TYPE;
1929: l_old_iban iby_ext_bank_accounts.iban%TYPE;

Line 1926: l_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;

1922: l_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;
1923: l_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;
1924: l_iban iby_ext_bank_accounts.iban%TYPE;
1925: l_encrypted iby_ext_bank_accounts.encrypted%TYPE;
1926: l_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
1927: l_iban_segment_id iby_ext_bank_accounts.iban_sec_segment_id%TYPE;
1928: l_bank_account_num_electronic iby_ext_bank_accounts.bank_account_num_electronic%TYPE;
1929: l_old_iban iby_ext_bank_accounts.iban%TYPE;
1930: l_old_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;

Line 1927: l_iban_segment_id iby_ext_bank_accounts.iban_sec_segment_id%TYPE;

1923: l_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;
1924: l_iban iby_ext_bank_accounts.iban%TYPE;
1925: l_encrypted iby_ext_bank_accounts.encrypted%TYPE;
1926: l_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
1927: l_iban_segment_id iby_ext_bank_accounts.iban_sec_segment_id%TYPE;
1928: l_bank_account_num_electronic iby_ext_bank_accounts.bank_account_num_electronic%TYPE;
1929: l_old_iban iby_ext_bank_accounts.iban%TYPE;
1930: l_old_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
1931: l_old_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;

Line 1928: l_bank_account_num_electronic iby_ext_bank_accounts.bank_account_num_electronic%TYPE;

1924: l_iban iby_ext_bank_accounts.iban%TYPE;
1925: l_encrypted iby_ext_bank_accounts.encrypted%TYPE;
1926: l_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
1927: l_iban_segment_id iby_ext_bank_accounts.iban_sec_segment_id%TYPE;
1928: l_bank_account_num_electronic iby_ext_bank_accounts.bank_account_num_electronic%TYPE;
1929: l_old_iban iby_ext_bank_accounts.iban%TYPE;
1930: l_old_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
1931: l_old_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;
1932: l_old_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;

Line 1929: l_old_iban iby_ext_bank_accounts.iban%TYPE;

1925: l_encrypted iby_ext_bank_accounts.encrypted%TYPE;
1926: l_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
1927: l_iban_segment_id iby_ext_bank_accounts.iban_sec_segment_id%TYPE;
1928: l_bank_account_num_electronic iby_ext_bank_accounts.bank_account_num_electronic%TYPE;
1929: l_old_iban iby_ext_bank_accounts.iban%TYPE;
1930: l_old_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
1931: l_old_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;
1932: l_old_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;
1933: l_dup_acct_id number;

Line 1930: l_old_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;

1926: l_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
1927: l_iban_segment_id iby_ext_bank_accounts.iban_sec_segment_id%TYPE;
1928: l_bank_account_num_electronic iby_ext_bank_accounts.bank_account_num_electronic%TYPE;
1929: l_old_iban iby_ext_bank_accounts.iban%TYPE;
1930: l_old_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
1931: l_old_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;
1932: l_old_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;
1933: l_dup_acct_id number;
1934: l_dup_start_date date;

Line 1931: l_old_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;

1927: l_iban_segment_id iby_ext_bank_accounts.iban_sec_segment_id%TYPE;
1928: l_bank_account_num_electronic iby_ext_bank_accounts.bank_account_num_electronic%TYPE;
1929: l_old_iban iby_ext_bank_accounts.iban%TYPE;
1930: l_old_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
1931: l_old_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;
1932: l_old_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;
1933: l_dup_acct_id number;
1934: l_dup_start_date date;
1935: l_dup_end_date date;

Line 1932: l_old_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;

1928: l_bank_account_num_electronic iby_ext_bank_accounts.bank_account_num_electronic%TYPE;
1929: l_old_iban iby_ext_bank_accounts.iban%TYPE;
1930: l_old_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
1931: l_old_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;
1932: l_old_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;
1933: l_dup_acct_id number;
1934: l_dup_start_date date;
1935: l_dup_end_date date;
1936: l_party_id ap_suppliers.party_id%TYPE;

Line 1955: FROM IBY_EXT_BANK_ACCOUNTS

1951: iban_sec_segment_id,
1952: encrypted,
1953: iban,
1954: masked_iban
1955: FROM IBY_EXT_BANK_ACCOUNTS
1956: WHERE EXT_BANK_ACCOUNT_ID = p_acct_id;
1957:
1958: -- checks if account already exists
1959: -- a duplicate bank account is one with the same account_number and

Line 1971: FROM IBY_EXT_BANK_ACCOUNTS_V

1967: p_bank_id NUMBER,
1968: p_branch_id NUMBER,
1969: p_bank_acct_id NUMBER) IS
1970: SELECT count(*)
1971: FROM IBY_EXT_BANK_ACCOUNTS_V
1972: WHERE
1973: (bank_acct_num_hash1 = p_account_num_hash1)
1974: AND (bank_acct_num_hash2 = p_account_num_hash2)
1975: -- AND (p_currency IS NULL OR CURRENCY_CODE = p_currency)

Line 2365: -- Update Table IBY_EXT_BANK_ACCOUNTS

2361: END IF;
2362:
2363: print_debuginfo('Before Update: using bank account');
2364:
2365: -- Update Table IBY_EXT_BANK_ACCOUNTS
2366: UPDATE IBY_EXT_BANK_ACCOUNTS
2367: SET BANK_ACCOUNT_NUM = nvl(l_acct_number, BANK_ACCOUNT_NUM),
2368: COUNTRY_CODE=p_ext_bank_acct_rec.country_code,
2369: CURRENCY_CODE = p_ext_bank_acct_rec.currency,

Line 2366: UPDATE IBY_EXT_BANK_ACCOUNTS

2362:
2363: print_debuginfo('Before Update: using bank account');
2364:
2365: -- Update Table IBY_EXT_BANK_ACCOUNTS
2366: UPDATE IBY_EXT_BANK_ACCOUNTS
2367: SET BANK_ACCOUNT_NUM = nvl(l_acct_number, BANK_ACCOUNT_NUM),
2368: COUNTRY_CODE=p_ext_bank_acct_rec.country_code,
2369: CURRENCY_CODE = p_ext_bank_acct_rec.currency,
2370: IBAN = l_iban,

Line 2554: FROM IBY_EXT_BANK_ACCOUNTS b

2550: b.BANK_ACCOUNT_NAME_ALT,
2551: b.SHORT_ACCT_NAME,
2552: b.DESCRIPTION,
2553: b.SECONDARY_ACCOUNT_REFERENCE -- Bug 7408747
2554: FROM IBY_EXT_BANK_ACCOUNTS b
2555: WHERE b.EXT_BANK_ACCOUNT_ID = p_bankacct_id;
2556:
2557: CURSOR c_acct_owner IS
2558: SELECT ACCOUNT_OWNER_PARTY_ID

Line 2856: UPDATE IBY_EXT_BANK_ACCOUNTS

2852: RAISE fnd_api.g_exc_error;
2853: END IF;
2854:
2855: -- update bank account dates
2856: UPDATE IBY_EXT_BANK_ACCOUNTS
2857: SET START_DATE = p_start_date, END_DATE = NVL(p_end_date,END_DATE)
2858: WHERE EXT_BANK_ACCOUNT_ID = p_acct_id;
2859:
2860: IF (SQL%NOTFOUND) THEN

Line 2861: print_debuginfo('Warning: No matching Row found in IBY_EXT_BANK_ACCOUNTS');

2857: SET START_DATE = p_start_date, END_DATE = NVL(p_end_date,END_DATE)
2858: WHERE EXT_BANK_ACCOUNT_ID = p_acct_id;
2859:
2860: IF (SQL%NOTFOUND) THEN
2861: print_debuginfo('Warning: No matching Row found in IBY_EXT_BANK_ACCOUNTS');
2862: ELSE
2863: print_debuginfo('Set Ext Bank Account End Date as ' || p_end_date);
2864: END IF;
2865:

Line 2932: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;

2928: x_msg_data OUT NOCOPY VARCHAR2,
2929: x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
2930: ) IS
2931:
2932: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
2933: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
2934:
2935: l_api_name CONSTANT VARCHAR2(30) := 'check_ext_acct_exist';
2936: l_api_version CONSTANT NUMBER := 1.0;

Line 2933: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;

2929: x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
2930: ) IS
2931:
2932: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
2933: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
2934:
2935: l_api_name CONSTANT VARCHAR2(30) := 'check_ext_acct_exist';
2936: l_api_version CONSTANT NUMBER := 1.0;
2937: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.' || l_api_name;

Line 2959: FROM IBY_EXT_BANK_ACCOUNTS

2955:
2956: SELECT EXT_BANK_ACCOUNT_ID,
2957: START_DATE,
2958: END_DATE
2959: FROM IBY_EXT_BANK_ACCOUNTS
2960: WHERE (BANK_ACCOUNT_NUM_HASH1= p_account_num_hash1)
2961: AND (BANK_ACCOUNT_NUM_HASH2= p_account_num_hash2)
2962: AND ((p_currency IS NULL and CURRENCY_CODE is NULL) OR (CURRENCY_CODE = p_currency))
2963: AND ((p_bank_id IS NULL AND BANK_ID is NULL) OR (BANK_ID = p_bank_id))

Line 2982: FROM IBY_EXT_BANK_ACCOUNTS

2978:
2979: SELECT EXT_BANK_ACCOUNT_ID,
2980: START_DATE,
2981: END_DATE
2982: FROM IBY_EXT_BANK_ACCOUNTS
2983: WHERE (BANK_ACCOUNT_NUM_HASH1= p_account_num_hash1)
2984: AND (BANK_ACCOUNT_NUM_HASH2= p_account_num_hash2)
2985: AND ((p_currency IS NULL and CURRENCY_CODE is NULL) OR (CURRENCY_CODE = p_currency))
2986: AND ((p_bank_id IS NULL AND BANK_ID is NULL) OR (BANK_ID = p_bank_id))

Line 3006: FROM IBY_EXT_BANK_ACCOUNTS

3002:
3003: SELECT EXT_BANK_ACCOUNT_ID,
3004: START_DATE,
3005: END_DATE
3006: FROM IBY_EXT_BANK_ACCOUNTS
3007: WHERE (BANK_ACCOUNT_NUM_HASH1= p_account_num_hash1)
3008: AND (BANK_ACCOUNT_NUM_HASH2= p_account_num_hash2)
3009: AND ((p_currency IS NULL and CURRENCY_CODE is NULL) OR (CURRENCY_CODE = p_currency))
3010: AND ((p_bank_id IS NULL AND BANK_ID is NULL) OR (BANK_ID = p_bank_id))

Line 4097: lx_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;

4093: END Get_BA_Encrypt_Mode;
4094:
4095: FUNCTION Mask_Bank_Number( p_bank_number IN VARCHAR2 ) RETURN VARCHAR2
4096: IS
4097: lx_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;
4098: lx_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
4099: BEGIN
4100: Get_Mask_Settings(lx_mask_option,lx_unmask_len);
4101: print_debuginfo('The value of lx_mask_option :' ||lx_mask_option);

Line 4098: lx_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;

4094:
4095: FUNCTION Mask_Bank_Number( p_bank_number IN VARCHAR2 ) RETURN VARCHAR2
4096: IS
4097: lx_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;
4098: lx_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
4099: BEGIN
4100: Get_Mask_Settings(lx_mask_option,lx_unmask_len);
4101: print_debuginfo('The value of lx_mask_option :' ||lx_mask_option);
4102: print_debuginfo('The value of lx_unmask_len :'|| lx_unmask_len);

Line 4108: p_mask_option IN iby_ext_bank_accounts.ba_mask_setting%TYPE,

4104: END Mask_Bank_Number;
4105:
4106: FUNCTION Mask_Bank_Number
4107: (p_bank_number IN VARCHAR2,
4108: p_mask_option IN iby_ext_bank_accounts.ba_mask_setting%TYPE,
4109: p_unmask_len IN iby_ext_bank_accounts.ba_unmask_length%TYPE
4110: )
4111: RETURN VARCHAR2
4112: IS

Line 4109: p_unmask_len IN iby_ext_bank_accounts.ba_unmask_length%TYPE

4105:
4106: FUNCTION Mask_Bank_Number
4107: (p_bank_number IN VARCHAR2,
4108: p_mask_option IN iby_ext_bank_accounts.ba_mask_setting%TYPE,
4109: p_unmask_len IN iby_ext_bank_accounts.ba_unmask_length%TYPE
4110: )
4111: RETURN VARCHAR2
4112: IS
4113: BEGIN

Line 4172: p_mask_option IN iby_ext_bank_accounts.ba_mask_setting%TYPE,

4168: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
4169: p_sub_key_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
4170: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,
4171: p_encoding IN iby_security_segments.encoding_scheme%TYPE,
4172: p_mask_option IN iby_ext_bank_accounts.ba_mask_setting%TYPE,
4173: p_unmask_len IN iby_ext_bank_accounts.ba_unmask_length%TYPE
4174: )
4175: RETURN VARCHAR2
4176: IS

Line 4173: p_unmask_len IN iby_ext_bank_accounts.ba_unmask_length%TYPE

4169: p_sub_key_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
4170: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,
4171: p_encoding IN iby_security_segments.encoding_scheme%TYPE,
4172: p_mask_option IN iby_ext_bank_accounts.ba_mask_setting%TYPE,
4173: p_unmask_len IN iby_ext_bank_accounts.ba_unmask_length%TYPE
4174: )
4175: RETURN VARCHAR2
4176: IS
4177: l_sub_key iby_sys_security_subkeys.subkey_cipher_text%TYPE;

Line 4212: lx_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;

4208: (p_commit IN VARCHAR2 := FND_API.G_TRUE,
4209: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE
4210: )
4211: IS
4212: lx_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;
4213: lx_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
4214: l_mode iby_sys_security_options.ext_ba_encryption_mode%TYPE;
4215: lx_key_error VARCHAR2(300);
4216:

Line 4213: lx_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;

4209: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE
4210: )
4211: IS
4212: lx_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;
4213: lx_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
4214: l_mode iby_sys_security_options.ext_ba_encryption_mode%TYPE;
4215: lx_key_error VARCHAR2(300);
4216:
4217: l_ba_num iby_ext_bank_accounts.bank_account_num%TYPE;

Line 4217: l_ba_num iby_ext_bank_accounts.bank_account_num%TYPE;

4213: lx_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
4214: l_mode iby_sys_security_options.ext_ba_encryption_mode%TYPE;
4215: lx_key_error VARCHAR2(300);
4216:
4217: l_ba_num iby_ext_bank_accounts.bank_account_num%TYPE;
4218: l_iban iby_ext_bank_accounts.iban%TYPE;
4219: lx_compress_num iby_ext_bank_accounts.bank_account_num%TYPE;
4220:
4221: lx_ba_unmask_digits iby_ext_bank_accounts.bank_account_num%TYPE;

Line 4218: l_iban iby_ext_bank_accounts.iban%TYPE;

4214: l_mode iby_sys_security_options.ext_ba_encryption_mode%TYPE;
4215: lx_key_error VARCHAR2(300);
4216:
4217: l_ba_num iby_ext_bank_accounts.bank_account_num%TYPE;
4218: l_iban iby_ext_bank_accounts.iban%TYPE;
4219: lx_compress_num iby_ext_bank_accounts.bank_account_num%TYPE;
4220:
4221: lx_ba_unmask_digits iby_ext_bank_accounts.bank_account_num%TYPE;
4222: l_ba_segment iby_security_segments.segment_cipher_text%TYPE;

Line 4219: lx_compress_num iby_ext_bank_accounts.bank_account_num%TYPE;

4215: lx_key_error VARCHAR2(300);
4216:
4217: l_ba_num iby_ext_bank_accounts.bank_account_num%TYPE;
4218: l_iban iby_ext_bank_accounts.iban%TYPE;
4219: lx_compress_num iby_ext_bank_accounts.bank_account_num%TYPE;
4220:
4221: lx_ba_unmask_digits iby_ext_bank_accounts.bank_account_num%TYPE;
4222: l_ba_segment iby_security_segments.segment_cipher_text%TYPE;
4223: lx_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;

Line 4221: lx_ba_unmask_digits iby_ext_bank_accounts.bank_account_num%TYPE;

4217: l_ba_num iby_ext_bank_accounts.bank_account_num%TYPE;
4218: l_iban iby_ext_bank_accounts.iban%TYPE;
4219: lx_compress_num iby_ext_bank_accounts.bank_account_num%TYPE;
4220:
4221: lx_ba_unmask_digits iby_ext_bank_accounts.bank_account_num%TYPE;
4222: l_ba_segment iby_security_segments.segment_cipher_text%TYPE;
4223: lx_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
4224:
4225: lx_iban_unmask_digits iby_ext_bank_accounts.iban%TYPE;

Line 4223: lx_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;

4219: lx_compress_num iby_ext_bank_accounts.bank_account_num%TYPE;
4220:
4221: lx_ba_unmask_digits iby_ext_bank_accounts.bank_account_num%TYPE;
4222: l_ba_segment iby_security_segments.segment_cipher_text%TYPE;
4223: lx_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
4224:
4225: lx_iban_unmask_digits iby_ext_bank_accounts.iban%TYPE;
4226: l_iban_segment iby_security_segments.segment_cipher_text%TYPE;
4227: lx_iban_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;

Line 4225: lx_iban_unmask_digits iby_ext_bank_accounts.iban%TYPE;

4221: lx_ba_unmask_digits iby_ext_bank_accounts.bank_account_num%TYPE;
4222: l_ba_segment iby_security_segments.segment_cipher_text%TYPE;
4223: lx_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
4224:
4225: lx_iban_unmask_digits iby_ext_bank_accounts.iban%TYPE;
4226: l_iban_segment iby_security_segments.segment_cipher_text%TYPE;
4227: lx_iban_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
4228:
4229: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Remask_Accounts';

Line 4227: lx_iban_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;

4223: lx_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
4224:
4225: lx_iban_unmask_digits iby_ext_bank_accounts.iban%TYPE;
4226: l_iban_segment iby_security_segments.segment_cipher_text%TYPE;
4227: lx_iban_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
4228:
4229: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Remask_Accounts';
4230:
4231: CURSOR c_ext_ba

Line 4232: (ci_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE,

4228:
4229: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Remask_Accounts';
4230:
4231: CURSOR c_ext_ba
4232: (ci_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE,
4233: ci_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE
4234: )
4235: IS
4236: SELECT b.ext_bank_account_id, b.bank_account_num, b.iban,

Line 4233: ci_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE

4229: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Remask_Accounts';
4230:
4231: CURSOR c_ext_ba
4232: (ci_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE,
4233: ci_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE
4234: )
4235: IS
4236: SELECT b.ext_bank_account_id, b.bank_account_num, b.iban,
4237: b.ba_num_sec_segment_id, bak.subkey_cipher_text ba_subkey_cipher,

Line 4244: FROM iby_ext_bank_accounts b, iby_sys_security_subkeys bak,

4240: b.iban_sec_segment_id, ibk.subkey_cipher_text iban_subkey_cipher,
4241: ibs.segment_cipher_text iban_segment_cipher,
4242: ibs.encoding_scheme iban_encoding,
4243: b.ba_mask_setting, b.ba_unmask_length
4244: FROM iby_ext_bank_accounts b, iby_sys_security_subkeys bak,
4245: iby_sys_security_subkeys ibk, iby_security_segments bas,
4246: iby_security_segments ibs
4247: WHERE
4248: ( (NVL(ba_unmask_length,-1) <> ci_unmask_len) OR

Line 4384: UPDATE iby_ext_bank_accounts

4380: DELETE FROM iby_security_segments
4381: WHERE sec_segment_id = ext_ba_rec.iban_sec_segment_id;
4382: END IF;
4383:
4384: UPDATE iby_ext_bank_accounts
4385: SET
4386: bank_account_num = lx_ba_unmask_digits,
4387: ba_num_sec_segment_id = lx_ba_segment_id,
4388: iban = lx_iban_unmask_digits,

Line 4421: lx_compress_num iby_ext_bank_accounts.bank_account_num%TYPE;

4417: IS
4418: l_mode iby_sys_security_options.ext_ba_encryption_mode%TYPE;
4419: lx_key_error VARCHAR2(300);
4420:
4421: lx_compress_num iby_ext_bank_accounts.bank_account_num%TYPE;
4422:
4423: lx_ba_unmask_digits iby_ext_bank_accounts.bank_account_num%TYPE;
4424: l_ba_segment iby_security_segments.segment_cipher_text%TYPE;
4425: lx_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;

Line 4423: lx_ba_unmask_digits iby_ext_bank_accounts.bank_account_num%TYPE;

4419: lx_key_error VARCHAR2(300);
4420:
4421: lx_compress_num iby_ext_bank_accounts.bank_account_num%TYPE;
4422:
4423: lx_ba_unmask_digits iby_ext_bank_accounts.bank_account_num%TYPE;
4424: l_ba_segment iby_security_segments.segment_cipher_text%TYPE;
4425: lx_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
4426:
4427: lx_iban_unmask_digits iby_ext_bank_accounts.iban%TYPE;

Line 4425: lx_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;

4421: lx_compress_num iby_ext_bank_accounts.bank_account_num%TYPE;
4422:
4423: lx_ba_unmask_digits iby_ext_bank_accounts.bank_account_num%TYPE;
4424: l_ba_segment iby_security_segments.segment_cipher_text%TYPE;
4425: lx_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
4426:
4427: lx_iban_unmask_digits iby_ext_bank_accounts.iban%TYPE;
4428: l_iban_segment iby_security_segments.segment_cipher_text%TYPE;
4429: lx_iban_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;

Line 4427: lx_iban_unmask_digits iby_ext_bank_accounts.iban%TYPE;

4423: lx_ba_unmask_digits iby_ext_bank_accounts.bank_account_num%TYPE;
4424: l_ba_segment iby_security_segments.segment_cipher_text%TYPE;
4425: lx_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
4426:
4427: lx_iban_unmask_digits iby_ext_bank_accounts.iban%TYPE;
4428: l_iban_segment iby_security_segments.segment_cipher_text%TYPE;
4429: lx_iban_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
4430:
4431: lx_e_ba_unmask_digits iby_ext_bank_accounts.bank_account_num_electronic%TYPE;

Line 4429: lx_iban_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;

4425: lx_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
4426:
4427: lx_iban_unmask_digits iby_ext_bank_accounts.iban%TYPE;
4428: l_iban_segment iby_security_segments.segment_cipher_text%TYPE;
4429: lx_iban_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
4430:
4431: lx_e_ba_unmask_digits iby_ext_bank_accounts.bank_account_num_electronic%TYPE;
4432: l_e_ba_segment iby_security_segments.segment_cipher_text%TYPE;
4433: lx_e_ba_segment_id iby_ext_bank_accounts.ba_num_elec_sec_segment_id%TYPE;

Line 4431: lx_e_ba_unmask_digits iby_ext_bank_accounts.bank_account_num_electronic%TYPE;

4427: lx_iban_unmask_digits iby_ext_bank_accounts.iban%TYPE;
4428: l_iban_segment iby_security_segments.segment_cipher_text%TYPE;
4429: lx_iban_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
4430:
4431: lx_e_ba_unmask_digits iby_ext_bank_accounts.bank_account_num_electronic%TYPE;
4432: l_e_ba_segment iby_security_segments.segment_cipher_text%TYPE;
4433: lx_e_ba_segment_id iby_ext_bank_accounts.ba_num_elec_sec_segment_id%TYPE;
4434:
4435: CURSOR c_ext_ba

Line 4433: lx_e_ba_segment_id iby_ext_bank_accounts.ba_num_elec_sec_segment_id%TYPE;

4429: lx_iban_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
4430:
4431: lx_e_ba_unmask_digits iby_ext_bank_accounts.bank_account_num_electronic%TYPE;
4432: l_e_ba_segment iby_security_segments.segment_cipher_text%TYPE;
4433: lx_e_ba_segment_id iby_ext_bank_accounts.ba_num_elec_sec_segment_id%TYPE;
4434:
4435: CURSOR c_ext_ba
4436: IS
4437: SELECT b.ext_bank_account_id, b.bank_account_num, b.iban,

Line 4441: FROM iby_ext_bank_accounts b

4437: SELECT b.ext_bank_account_id, b.bank_account_num, b.iban,
4438: b.ba_num_sec_segment_id, b.iban_sec_segment_id,
4439: b.bank_account_num_electronic, b.ba_num_elec_sec_segment_id,
4440: b.ba_mask_setting, b.ba_unmask_length
4441: FROM iby_ext_bank_accounts b
4442: WHERE (NVL(b.encrypted,'N') = 'N');
4443:
4444: BEGIN
4445:

Line 4529: UPDATE iby_ext_bank_accounts

4525: ELSE
4526: lx_e_ba_unmask_digits := ext_ba_rec.bank_account_num_electronic;
4527: END IF;
4528:
4529: UPDATE iby_ext_bank_accounts
4530: SET
4531: bank_account_num = lx_ba_unmask_digits,
4532: iban = lx_iban_unmask_digits,
4533: ba_num_sec_segment_id = NVL(lx_ba_segment_id,ba_num_sec_segment_id),

Line 4554: l_ba_num iby_ext_bank_accounts.bank_account_num%TYPE;

4550: )
4551: IS
4552: l_mode iby_sys_security_options.ext_ba_encryption_mode%TYPE;
4553: l_subkey iby_sys_security_subkeys.subkey_cipher_text%TYPE;
4554: l_ba_num iby_ext_bank_accounts.bank_account_num%TYPE;
4555: l_iban iby_ext_bank_accounts.iban%TYPE;
4556: l_e_ba iby_ext_bank_accounts.bank_account_num_electronic%TYPE;
4557:
4558: lx_key_error VARCHAR2(300);

Line 4555: l_iban iby_ext_bank_accounts.iban%TYPE;

4551: IS
4552: l_mode iby_sys_security_options.ext_ba_encryption_mode%TYPE;
4553: l_subkey iby_sys_security_subkeys.subkey_cipher_text%TYPE;
4554: l_ba_num iby_ext_bank_accounts.bank_account_num%TYPE;
4555: l_iban iby_ext_bank_accounts.iban%TYPE;
4556: l_e_ba iby_ext_bank_accounts.bank_account_num_electronic%TYPE;
4557:
4558: lx_key_error VARCHAR2(300);
4559:

Line 4556: l_e_ba iby_ext_bank_accounts.bank_account_num_electronic%TYPE;

4552: l_mode iby_sys_security_options.ext_ba_encryption_mode%TYPE;
4553: l_subkey iby_sys_security_subkeys.subkey_cipher_text%TYPE;
4554: l_ba_num iby_ext_bank_accounts.bank_account_num%TYPE;
4555: l_iban iby_ext_bank_accounts.iban%TYPE;
4556: l_e_ba iby_ext_bank_accounts.bank_account_num_electronic%TYPE;
4557:
4558: lx_key_error VARCHAR2(300);
4559:
4560: CURSOR c_ext_ba

Line 4575: FROM iby_ext_bank_accounts b, iby_sys_security_subkeys bak,

4571: ebk.subkey_cipher_text e_ba_subkey_cipher,
4572: ebs.segment_cipher_text e_ba_segment_cipher,
4573: ebs.encoding_scheme e_ba_encoding,
4574: b.ba_mask_setting, b.ba_unmask_length
4575: FROM iby_ext_bank_accounts b, iby_sys_security_subkeys bak,
4576: iby_sys_security_subkeys ebk, iby_sys_security_subkeys ibk,
4577: iby_security_segments bas, iby_security_segments ibs,
4578: iby_security_segments ebs
4579: WHERE

Line 4642: UPDATE iby_ext_bank_accounts

4638: ext_ba_rec.ba_mask_setting,
4639: ext_ba_rec.ba_unmask_length);
4640: END IF;
4641:
4642: UPDATE iby_ext_bank_accounts
4643: SET
4644: bank_account_num = NVL(l_ba_num,bank_account_num),
4645: iban = NVL(l_iban,iban),
4646: bank_account_num_electronic = NVL(l_e_ba,bank_account_num_electronic),