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_SECURITY_SEGMENTS

Line 2514: DELETE FROM iby_security_segments

2510: print_debuginfo('The value of l_masked_ba_num after masking:'||
2511: l_masked_ba_num);
2512: END IF;
2513: l_encrypted := 'N';
2514: DELETE FROM iby_security_segments
2515: WHERE sec_segment_id = l_ba_segment_id;
2516: end if;
2517: end if;
2518: exception

Line 2564: DELETE FROM iby_security_segments

2560: l_iban_hash2 := iby_security_pkg.Get_Hash(l_iban,'T');
2561: l_masked_iban := Mask_Bank_Number(l_iban,l_mask_option,l_unmask_len);
2562:
2563: l_encrypted := 'N';
2564: DELETE FROM iby_security_segments
2565: WHERE sec_segment_id = l_iban_segment_id;
2566: end if;
2567: end if;
2568: exception

Line 2622: DELETE FROM iby_security_segments

2618: l_encrypted := 'N';
2619: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2620: print_debuginfo('before delete');
2621: END IF;
2622: DELETE FROM iby_security_segments
2623: WHERE sec_segment_id = l_iban_segment_id;
2624: /* Segment_id should be nulled out if there
2625: is any modification to IBAN*/
2626: l_iban_segment_id := null;

Line 2828: DELETE FROM iby_security_segments

2824: print_debuginfo('The value of l_masked_ba_num after masking:'||
2825: l_masked_ba_num);
2826: END IF;
2827: l_encrypted := 'N';
2828: DELETE FROM iby_security_segments
2829: WHERE sec_segment_id = l_ba_segment_id;
2830: /* Electronic Bank Account should also
2831: get updated where Bank Account num is
2832: updated there for segment_id for

Line 2835: DELETE FROM iby_security_segments

2831: get updated where Bank Account num is
2832: updated there for segment_id for
2833: electronic Bank Account should also be
2834: deleted.*/
2835: DELETE FROM iby_security_segments
2836: WHERE sec_segment_id = l_ba_elec_segment_id;
2837: /* Segment_id should be nulled out if
2838: there is any modification BankAccount Num*/
2839: l_ba_segment_id := null;

Line 4999: p_segment_id IN iby_security_segments.sec_segment_id%TYPE,

4995: END Compress_Bank_Number;
4996:
4997: FUNCTION Uncipher_Bank_Number
4998: (p_unmask_digits IN VARCHAR2,
4999: p_segment_id IN iby_security_segments.sec_segment_id%TYPE,
5000: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
5001: p_sub_key_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
5002: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,
5003: p_encoding IN iby_security_segments.encoding_scheme%TYPE,

Line 5002: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,

4998: (p_unmask_digits IN VARCHAR2,
4999: p_segment_id IN iby_security_segments.sec_segment_id%TYPE,
5000: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
5001: p_sub_key_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
5002: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,
5003: p_encoding IN iby_security_segments.encoding_scheme%TYPE,
5004: p_mask_option IN iby_ext_bank_accounts.ba_mask_setting%TYPE,
5005: p_unmask_len IN iby_ext_bank_accounts.ba_unmask_length%TYPE
5006: )

Line 5003: p_encoding IN iby_security_segments.encoding_scheme%TYPE,

4999: p_segment_id IN iby_security_segments.sec_segment_id%TYPE,
5000: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
5001: p_sub_key_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
5002: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,
5003: p_encoding IN iby_security_segments.encoding_scheme%TYPE,
5004: p_mask_option IN iby_ext_bank_accounts.ba_mask_setting%TYPE,
5005: p_unmask_len IN iby_ext_bank_accounts.ba_unmask_length%TYPE
5006: )
5007: RETURN VARCHAR2

Line 5010: l_bank_segment iby_security_segments.segment_cipher_text%TYPE;

5006: )
5007: RETURN VARCHAR2
5008: IS
5009: l_sub_key iby_sys_security_subkeys.subkey_cipher_text%TYPE;
5010: l_bank_segment iby_security_segments.segment_cipher_text%TYPE;
5011: l_bank_num VARCHAR2(200);
5012: BEGIN
5013:
5014: IF (p_segment_id IS NULL) THEN RETURN p_unmask_digits; END IF;

Line 5060: l_ba_segment iby_security_segments.segment_cipher_text%TYPE;

5056: l_iban iby_ext_bank_accounts.iban%TYPE;
5057: lx_compress_num iby_ext_bank_accounts.bank_account_num%TYPE;
5058:
5059: lx_ba_unmask_digits iby_ext_bank_accounts.bank_account_num%TYPE;
5060: l_ba_segment iby_security_segments.segment_cipher_text%TYPE;
5061: lx_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
5062:
5063: lx_iban_unmask_digits iby_ext_bank_accounts.iban%TYPE;
5064: l_iban_segment iby_security_segments.segment_cipher_text%TYPE;

Line 5064: l_iban_segment iby_security_segments.segment_cipher_text%TYPE;

5060: l_ba_segment iby_security_segments.segment_cipher_text%TYPE;
5061: lx_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
5062:
5063: lx_iban_unmask_digits iby_ext_bank_accounts.iban%TYPE;
5064: l_iban_segment iby_security_segments.segment_cipher_text%TYPE;
5065: lx_iban_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
5066:
5067: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Remask_Accounts';
5068:

Line 5083: iby_sys_security_subkeys ibk, iby_security_segments bas,

5079: ibs.segment_cipher_text iban_segment_cipher,
5080: ibs.encoding_scheme iban_encoding,
5081: b.ba_mask_setting, b.ba_unmask_length
5082: FROM iby_ext_bank_accounts b, iby_sys_security_subkeys bak,
5083: iby_sys_security_subkeys ibk, iby_security_segments bas,
5084: iby_security_segments ibs
5085: WHERE
5086: ( (NVL(ba_unmask_length,-1) <> ci_unmask_len) OR
5087: (NVL(ba_mask_setting,' ') <> ci_mask_option) )

Line 5084: iby_security_segments ibs

5080: ibs.encoding_scheme iban_encoding,
5081: b.ba_mask_setting, b.ba_unmask_length
5082: FROM iby_ext_bank_accounts b, iby_sys_security_subkeys bak,
5083: iby_sys_security_subkeys ibk, iby_security_segments bas,
5084: iby_security_segments ibs
5085: WHERE
5086: ( (NVL(ba_unmask_length,-1) <> ci_unmask_len) OR
5087: (NVL(ba_mask_setting,' ') <> ci_mask_option) )
5088: AND (b.ba_num_sec_segment_id = bas.sec_segment_id(+))

Line 5178: DELETE FROM iby_security_segments

5174: iby_security_pkg.G_ENCODING_UTF8_AL32,p_sys_key,
5175: ext_ba_rec.ba_subkey_cipher);
5176: END IF;
5177: ELSE
5178: DELETE FROM iby_security_segments
5179: WHERE sec_segment_id = ext_ba_rec.ba_num_sec_segment_id;
5180: END IF;
5181:
5182: Compress_Bank_Number

Line 5205: DELETE FROM iby_security_segments

5201: iby_security_pkg.G_ENCODING_UTF8_AL32,p_sys_key,
5202: ext_ba_rec.iban_subkey_cipher);
5203: END IF;
5204: ELSE
5205: DELETE FROM iby_security_segments
5206: WHERE sec_segment_id = ext_ba_rec.iban_sec_segment_id;
5207: END IF;
5208:
5209: ELSE

Line 5216: DELETE FROM iby_security_segments

5212:
5213: lx_ba_unmask_digits := l_ba_num;
5214: lx_iban_unmask_digits := l_iban;
5215:
5216: DELETE FROM iby_security_segments
5217: WHERE sec_segment_id = ext_ba_rec.ba_num_sec_segment_id;
5218: DELETE FROM iby_security_segments
5219: WHERE sec_segment_id = ext_ba_rec.iban_sec_segment_id;
5220: END IF;

Line 5218: DELETE FROM iby_security_segments

5214: lx_iban_unmask_digits := l_iban;
5215:
5216: DELETE FROM iby_security_segments
5217: WHERE sec_segment_id = ext_ba_rec.ba_num_sec_segment_id;
5218: DELETE FROM iby_security_segments
5219: WHERE sec_segment_id = ext_ba_rec.iban_sec_segment_id;
5220: END IF;
5221:
5222: UPDATE iby_ext_bank_accounts

Line 5262: l_ba_segment iby_security_segments.segment_cipher_text%TYPE;

5258:
5259: lx_compress_num iby_ext_bank_accounts.bank_account_num%TYPE;
5260:
5261: lx_ba_unmask_digits iby_ext_bank_accounts.bank_account_num%TYPE;
5262: l_ba_segment iby_security_segments.segment_cipher_text%TYPE;
5263: lx_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
5264:
5265: lx_iban_unmask_digits iby_ext_bank_accounts.iban%TYPE;
5266: l_iban_segment iby_security_segments.segment_cipher_text%TYPE;

Line 5266: l_iban_segment iby_security_segments.segment_cipher_text%TYPE;

5262: l_ba_segment iby_security_segments.segment_cipher_text%TYPE;
5263: lx_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
5264:
5265: lx_iban_unmask_digits iby_ext_bank_accounts.iban%TYPE;
5266: l_iban_segment iby_security_segments.segment_cipher_text%TYPE;
5267: lx_iban_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
5268:
5269: lx_e_ba_unmask_digits iby_ext_bank_accounts.bank_account_num_electronic%TYPE;
5270: l_e_ba_segment iby_security_segments.segment_cipher_text%TYPE;

Line 5270: l_e_ba_segment iby_security_segments.segment_cipher_text%TYPE;

5266: l_iban_segment iby_security_segments.segment_cipher_text%TYPE;
5267: lx_iban_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
5268:
5269: lx_e_ba_unmask_digits iby_ext_bank_accounts.bank_account_num_electronic%TYPE;
5270: l_e_ba_segment iby_security_segments.segment_cipher_text%TYPE;
5271: lx_e_ba_segment_id iby_ext_bank_accounts.ba_num_elec_sec_segment_id%TYPE;
5272:
5273: CURSOR c_ext_ba
5274: IS

Line 5415: iby_security_segments bas, iby_security_segments ibs,

5411: ebs.encoding_scheme e_ba_encoding,
5412: b.ba_mask_setting, b.ba_unmask_length
5413: FROM iby_ext_bank_accounts b, iby_sys_security_subkeys bak,
5414: iby_sys_security_subkeys ebk, iby_sys_security_subkeys ibk,
5415: iby_security_segments bas, iby_security_segments ibs,
5416: iby_security_segments ebs
5417: WHERE
5418: ((NOT ba_num_sec_segment_id IS NULL) OR (NOT iban_sec_segment_id IS NULL))
5419: AND (b.ba_num_sec_segment_id = bas.sec_segment_id(+))

Line 5416: iby_security_segments ebs

5412: b.ba_mask_setting, b.ba_unmask_length
5413: FROM iby_ext_bank_accounts b, iby_sys_security_subkeys bak,
5414: iby_sys_security_subkeys ebk, iby_sys_security_subkeys ibk,
5415: iby_security_segments bas, iby_security_segments ibs,
5416: iby_security_segments ebs
5417: WHERE
5418: ((NOT ba_num_sec_segment_id IS NULL) OR (NOT iban_sec_segment_id IS NULL))
5419: AND (b.ba_num_sec_segment_id = bas.sec_segment_id(+))
5420: AND (bas.sec_subkey_id = bak.sec_subkey_id(+))

Line 5495: DELETE FROM iby_security_segments

5491: last_updated_by = fnd_global.user_id,
5492: last_update_login = fnd_global.login_id
5493: WHERE (ext_bank_account_id = ext_ba_rec.ext_bank_account_id);
5494:
5495: DELETE FROM iby_security_segments
5496: WHERE sec_segment_id = ext_ba_rec.ba_num_sec_segment_id;
5497: DELETE FROM iby_security_segments
5498: WHERE sec_segment_id = ext_ba_rec.iban_sec_segment_id;
5499: DELETE FROM iby_security_segments

Line 5497: DELETE FROM iby_security_segments

5493: WHERE (ext_bank_account_id = ext_ba_rec.ext_bank_account_id);
5494:
5495: DELETE FROM iby_security_segments
5496: WHERE sec_segment_id = ext_ba_rec.ba_num_sec_segment_id;
5497: DELETE FROM iby_security_segments
5498: WHERE sec_segment_id = ext_ba_rec.iban_sec_segment_id;
5499: DELETE FROM iby_security_segments
5500: WHERE sec_segment_id = ext_ba_rec.ba_num_elec_sec_segment_id;
5501:

Line 5499: DELETE FROM iby_security_segments

5495: DELETE FROM iby_security_segments
5496: WHERE sec_segment_id = ext_ba_rec.ba_num_sec_segment_id;
5497: DELETE FROM iby_security_segments
5498: WHERE sec_segment_id = ext_ba_rec.iban_sec_segment_id;
5499: DELETE FROM iby_security_segments
5500: WHERE sec_segment_id = ext_ba_rec.ba_num_elec_sec_segment_id;
5501:
5502: END LOOP;
5503:

Line 5629: l_bank_segment iby_security_segments.segment_cipher_text%TYPE;

5625: l_api_name CONSTANT VARCHAR2(30) := 'Uncipher_Bank_Acct_Number';
5626: l_api_version CONSTANT NUMBER := 1.0;
5627: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.' || l_api_name;
5628: l_sub_key iby_sys_security_subkeys.subkey_cipher_text%TYPE;
5629: l_bank_segment iby_security_segments.segment_cipher_text%TYPE;
5630: l_bank_acct_num iby_ext_bank_accounts.bank_account_num%TYPE;
5631: l_segment_id iby_ext_bank_accounts.BA_NUM_SEC_SEGMENT_ID%type;
5632: l_sub_key_cipher iby_sys_security_subkeys.subkey_cipher_text%TYPE;
5633: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;

Line 5633: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;

5629: l_bank_segment iby_security_segments.segment_cipher_text%TYPE;
5630: l_bank_acct_num iby_ext_bank_accounts.bank_account_num%TYPE;
5631: l_segment_id iby_ext_bank_accounts.BA_NUM_SEC_SEGMENT_ID%type;
5632: l_sub_key_cipher iby_sys_security_subkeys.subkey_cipher_text%TYPE;
5633: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;
5634: l_encoding iby_security_segments.encoding_scheme%TYPE;
5635: l_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;
5636: l_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
5637: l_bank_num iby_ext_bank_accounts.bank_account_num%TYPE;

Line 5634: l_encoding iby_security_segments.encoding_scheme%TYPE;

5630: l_bank_acct_num iby_ext_bank_accounts.bank_account_num%TYPE;
5631: l_segment_id iby_ext_bank_accounts.BA_NUM_SEC_SEGMENT_ID%type;
5632: l_sub_key_cipher iby_sys_security_subkeys.subkey_cipher_text%TYPE;
5633: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;
5634: l_encoding iby_security_segments.encoding_scheme%TYPE;
5635: l_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;
5636: l_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
5637: l_bank_num iby_ext_bank_accounts.bank_account_num%TYPE;
5638: l_err_code varchar2(100):=null;

Line 5650: iby_security_segments segments

5646: ba.ba_mask_setting,
5647: ba.ba_unmask_length
5648: FROM iby_ext_bank_accounts ba,
5649: iby_sys_security_subkeys subkeys,
5650: iby_security_segments segments
5651: WHERE ba.ext_bank_account_id = p_ext_bank_account_id
5652: AND ba.ba_num_sec_segment_id = segments.sec_segment_id (+)
5653: AND segments.sec_subkey_id = subkeys.sec_subkey_id(+);
5654: BEGIN