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_FNDCPT_TRXN_PUB dependencies on IBY_SECURITY_SEGMENTS

Line 1748: DELETE FROM iby_security_segments

1744: IF (NOT p_trxn_attribs.Instrument_Security_Code IS NULL) AND
1745: (p_trxn_attribs.Instrument_Security_Code <> FND_API.G_MISS_CHAR)
1746: THEN
1747: iby_debug_pub.add('deleting l_seg_id_old',G_LEVEL_STATEMENT,l_dbg_mod);
1748: DELETE FROM iby_security_segments
1749: WHERE (sec_segment_id = l_seg_id_old);
1750: END IF;
1751:
1752: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS;

Line 2760: UPDATE iby_security_segments

2756: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2757: iby_debug_pub.add('Updating the security code with random value.',
2758: G_LEVEL_STATEMENT,l_dbg_mod);
2759: END IF;
2760: UPDATE iby_security_segments
2761: SET segment_cipher_text = RAWTOHEX(fnd_crypto.randombytes(32))
2762: WHERE sec_segment_id = p_segment_id;
2763:
2764: COMMIT;

Line 2766: UPDATE iby_security_segments

2762: WHERE sec_segment_id = p_segment_id;
2763:
2764: COMMIT;
2765:
2766: UPDATE iby_security_segments
2767: SET segment_cipher_text = null
2768: WHERE sec_segment_id = p_segment_id;
2769:
2770: -- DELETE iby_security_segments

Line 2770: -- DELETE iby_security_segments

2766: UPDATE iby_security_segments
2767: SET segment_cipher_text = null
2768: WHERE sec_segment_id = p_segment_id;
2769:
2770: -- DELETE iby_security_segments
2771: -- WHERE sec_segment_id = p_segment_id;
2772:
2773: COMMIT;
2774: END IF;

Line 6715: FROM iby_fndcpt_tx_extensions x, iby_security_segments s,

6711: IS
6712: SELECT x.trxn_extension_id, x.instr_sec_code_length,
6713: NVL(x.encrypted,'N'), s.segment_cipher_text, k.subkey_cipher_text,
6714: s.sec_segment_id
6715: FROM iby_fndcpt_tx_extensions x, iby_security_segments s,
6716: iby_sys_security_subkeys k
6717: WHERE (NVL(x.encrypted,'N') = 'Y')
6718: AND (NOT instrument_security_code IS NULL)
6719: AND (x.instr_code_sec_segment_id = s.sec_segment_id(+))

Line 6753: DELETE iby_security_segments

6749: last_update_login = fnd_global.login_id,
6750: object_version_number = object_version_number + 1
6751: WHERE trxn_extension_id = c_ext_rec.trxn_extension_id;
6752:
6753: DELETE iby_security_segments
6754: WHERE sec_segment_id = c_ext_rec.sec_segment_id;
6755: END LOOP;
6756:
6757: IF FND_API.To_Boolean(p_commit) THEN

Line 6769: p_sec_code_cipher IN iby_security_segments.segment_cipher_text%TYPE,

6765:
6766: FUNCTION Get_Security_Code
6767: (p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
6768: p_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
6769: p_sec_code_cipher IN iby_security_segments.segment_cipher_text%TYPE,
6770: p_sec_code_len IN iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE
6771: )
6772: RETURN iby_fndcpt_tx_extensions.instrument_security_code%TYPE
6773: IS

Line 6812: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;

6808: RETURN iby_fndcpt_tx_extensions.instrument_security_code%TYPE
6809: IS
6810: l_sec_code iby_fndcpt_tx_extensions.instrument_security_code%TYPE;
6811: l_sec_code_len iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE;
6812: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;
6813: l_subkey_cipher iby_sys_security_subkeys.subkey_cipher_text%TYPE;
6814: l_encrypted iby_fndcpt_tx_extensions.encrypted%TYPE;
6815: lx_err_code VARCHAR2(100);
6816: l_module CONSTANT VARCHAR2(30) := 'Get_Security_Code(2)';

Line 6824: FROM iby_fndcpt_tx_extensions x, iby_security_segments s,

6820: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)
6821: IS
6822: SELECT x.instrument_security_code, x.instr_sec_code_length,
6823: NVL(x.encrypted,'N'), s.segment_cipher_text, k.subkey_cipher_text
6824: FROM iby_fndcpt_tx_extensions x, iby_security_segments s,
6825: iby_sys_security_subkeys k
6826: WHERE (trxn_extension_id = ci_extension_id)
6827: AND (x.instr_code_sec_segment_id = s.sec_segment_id(+))
6828: AND (s.sec_subkey_id = k.sec_subkey_id(+));

Line 6868: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;

6864: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE
6865: )
6866: RETURN iby_fndcpt_tx_extensions.instrument_security_code%TYPE
6867: IS
6868: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;
6869: l_subkey_cipher iby_sys_security_subkeys.subkey_cipher_text%TYPE;
6870: lx_err_code VARCHAR2(100);
6871: l_module CONSTANT VARCHAR2(30) := 'Get_Security_Code(3)';
6872: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.' || l_module;

Line 6878: FROM iby_security_segments s, iby_sys_security_subkeys k

6874: CURSOR c_segment
6875: (ci_segment_id IN iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE)
6876: IS
6877: SELECT s.segment_cipher_text, k.subkey_cipher_text
6878: FROM iby_security_segments s, iby_sys_security_subkeys k
6879: WHERE (s.sec_segment_id = ci_segment_id)
6880: AND (s.sec_subkey_id = k.sec_subkey_id);
6881:
6882: BEGIN