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 2145: DELETE FROM iby_security_segments

2141: Mask_Bank_Number(l_acct_number,l_mask_option,l_unmask_len);
2142: print_debuginfo('The value of l_masked_ba_num after masking:'||
2143: l_masked_ba_num);
2144: l_encrypted := 'N';
2145: DELETE FROM iby_security_segments
2146: WHERE sec_segment_id = l_ba_segment_id;
2147: end if;
2148: end if;
2149: exception

Line 2189: DELETE FROM iby_security_segments

2185: l_iban_hash2 := iby_security_pkg.Get_Hash(l_iban,'T');
2186: l_masked_iban := Mask_Bank_Number(l_iban,l_mask_option,l_unmask_len);
2187:
2188: l_encrypted := 'N';
2189: DELETE FROM iby_security_segments
2190: WHERE sec_segment_id = l_iban_segment_id;
2191: end if;
2192: end if;
2193: exception

Line 2230: DELETE FROM iby_security_segments

2226: END IF;
2227:
2228: l_encrypted := 'N';
2229: print_debuginfo('before delete');
2230: DELETE FROM iby_security_segments
2231: WHERE sec_segment_id = l_iban_segment_id;
2232: print_debuginfo('After delete');
2233:
2234: ELSE

Line 4167: p_segment_id IN iby_security_segments.sec_segment_id%TYPE,

4163: END Compress_Bank_Number;
4164:
4165: FUNCTION Uncipher_Bank_Number
4166: (p_unmask_digits IN VARCHAR2,
4167: p_segment_id IN iby_security_segments.sec_segment_id%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,

Line 4170: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,

4166: (p_unmask_digits IN VARCHAR2,
4167: p_segment_id IN iby_security_segments.sec_segment_id%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: )

Line 4171: p_encoding IN iby_security_segments.encoding_scheme%TYPE,

4167: p_segment_id IN iby_security_segments.sec_segment_id%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

Line 4178: l_bank_segment iby_security_segments.segment_cipher_text%TYPE;

4174: )
4175: RETURN VARCHAR2
4176: IS
4177: l_sub_key iby_sys_security_subkeys.subkey_cipher_text%TYPE;
4178: l_bank_segment iby_security_segments.segment_cipher_text%TYPE;
4179: l_bank_num VARCHAR2(200);
4180: BEGIN
4181:
4182: IF (p_segment_id IS NULL) THEN RETURN p_unmask_digits; END IF;

Line 4222: l_ba_segment iby_security_segments.segment_cipher_text%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;
4226: l_iban_segment iby_security_segments.segment_cipher_text%TYPE;

Line 4226: l_iban_segment iby_security_segments.segment_cipher_text%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';
4230:

Line 4245: iby_sys_security_subkeys ibk, iby_security_segments bas,

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
4249: (NVL(ba_mask_setting,' ') <> ci_mask_option) )

Line 4246: iby_security_segments ibs

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
4249: (NVL(ba_mask_setting,' ') <> ci_mask_option) )
4250: AND (b.ba_num_sec_segment_id = bas.sec_segment_id(+))

Line 4340: DELETE FROM iby_security_segments

4336: iby_security_pkg.G_ENCODING_UTF8_AL32,p_sys_key,
4337: ext_ba_rec.ba_subkey_cipher);
4338: END IF;
4339: ELSE
4340: DELETE FROM iby_security_segments
4341: WHERE sec_segment_id = ext_ba_rec.ba_num_sec_segment_id;
4342: END IF;
4343:
4344: Compress_Bank_Number

Line 4367: DELETE FROM iby_security_segments

4363: iby_security_pkg.G_ENCODING_UTF8_AL32,p_sys_key,
4364: ext_ba_rec.iban_subkey_cipher);
4365: END IF;
4366: ELSE
4367: DELETE FROM iby_security_segments
4368: WHERE sec_segment_id = ext_ba_rec.iban_sec_segment_id;
4369: END IF;
4370:
4371: ELSE

Line 4378: DELETE FROM iby_security_segments

4374:
4375: lx_ba_unmask_digits := l_ba_num;
4376: lx_iban_unmask_digits := l_iban;
4377:
4378: DELETE FROM iby_security_segments
4379: WHERE sec_segment_id = ext_ba_rec.ba_num_sec_segment_id;
4380: DELETE FROM iby_security_segments
4381: WHERE sec_segment_id = ext_ba_rec.iban_sec_segment_id;
4382: END IF;

Line 4380: DELETE FROM iby_security_segments

4376: lx_iban_unmask_digits := l_iban;
4377:
4378: DELETE FROM iby_security_segments
4379: WHERE sec_segment_id = ext_ba_rec.ba_num_sec_segment_id;
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

Line 4424: l_ba_segment iby_security_segments.segment_cipher_text%TYPE;

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;
4428: l_iban_segment iby_security_segments.segment_cipher_text%TYPE;

Line 4428: l_iban_segment iby_security_segments.segment_cipher_text%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;
4432: l_e_ba_segment iby_security_segments.segment_cipher_text%TYPE;

Line 4432: l_e_ba_segment iby_security_segments.segment_cipher_text%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
4436: IS

Line 4577: iby_security_segments bas, iby_security_segments ibs,

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
4580: ((NOT ba_num_sec_segment_id IS NULL) OR (NOT iban_sec_segment_id IS NULL))
4581: AND (b.ba_num_sec_segment_id = bas.sec_segment_id(+))

Line 4578: iby_security_segments ebs

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
4580: ((NOT ba_num_sec_segment_id IS NULL) OR (NOT iban_sec_segment_id IS NULL))
4581: AND (b.ba_num_sec_segment_id = bas.sec_segment_id(+))
4582: AND (bas.sec_subkey_id = bak.sec_subkey_id(+))

Line 4657: DELETE FROM iby_security_segments

4653: last_updated_by = fnd_global.user_id,
4654: last_update_login = fnd_global.login_id
4655: WHERE (ext_bank_account_id = ext_ba_rec.ext_bank_account_id);
4656:
4657: DELETE FROM iby_security_segments
4658: WHERE sec_segment_id = ext_ba_rec.ba_num_sec_segment_id;
4659: DELETE FROM iby_security_segments
4660: WHERE sec_segment_id = ext_ba_rec.iban_sec_segment_id;
4661: DELETE FROM iby_security_segments

Line 4659: DELETE FROM iby_security_segments

4655: WHERE (ext_bank_account_id = ext_ba_rec.ext_bank_account_id);
4656:
4657: DELETE FROM iby_security_segments
4658: WHERE sec_segment_id = ext_ba_rec.ba_num_sec_segment_id;
4659: DELETE FROM iby_security_segments
4660: WHERE sec_segment_id = ext_ba_rec.iban_sec_segment_id;
4661: DELETE FROM iby_security_segments
4662: WHERE sec_segment_id = ext_ba_rec.ba_num_elec_sec_segment_id;
4663:

Line 4661: DELETE FROM iby_security_segments

4657: DELETE FROM iby_security_segments
4658: WHERE sec_segment_id = ext_ba_rec.ba_num_sec_segment_id;
4659: DELETE FROM iby_security_segments
4660: WHERE sec_segment_id = ext_ba_rec.iban_sec_segment_id;
4661: DELETE FROM iby_security_segments
4662: WHERE sec_segment_id = ext_ba_rec.ba_num_elec_sec_segment_id;
4663:
4664: END LOOP;
4665: