APPS.IBY_FNDCPT_TRXN_PUB dependencies on IBY_SECURITY_SEGMENTS

Line 1382: DELETE FROM iby_security_segments

1378: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
1379: IF (NOT p_trxn_attribs.Instrument_Security_Code IS NULL) AND
1380: (p_trxn_attribs.Instrument_Security_Code <> FND_API.G_MISS_CHAR)
1381: THEN
1382: DELETE FROM iby_security_segments
1383: WHERE (sec_segment_id = l_segment_id);
1384: END IF;
1385:
1386: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS;

Line 2259: -- IBY_SECURITY_SEGMENTS table.

2255: object_version_number = object_version_number + 1
2256: WHERE trxn_extension_id = p_trxn_extn_id;
2257:
2258: -- Delete the Security Code reference from the
2259: -- IBY_SECURITY_SEGMENTS table.
2260:
2261: UPDATE iby_security_segments
2262: SET segment_cipher_text = RAWTOHEX(fnd_crypto.randombytes(32))
2263: WHERE sec_segment_id = p_segment_id;

Line 2261: UPDATE iby_security_segments

2257:
2258: -- Delete the Security Code reference from the
2259: -- IBY_SECURITY_SEGMENTS table.
2260:
2261: UPDATE iby_security_segments
2262: SET segment_cipher_text = RAWTOHEX(fnd_crypto.randombytes(32))
2263: WHERE sec_segment_id = p_segment_id;
2264: COMMIT;
2265:

Line 2266: DELETE iby_security_segments

2262: SET segment_cipher_text = RAWTOHEX(fnd_crypto.randombytes(32))
2263: WHERE sec_segment_id = p_segment_id;
2264: COMMIT;
2265:
2266: DELETE iby_security_segments
2267: WHERE sec_segment_id = p_segment_id;
2268: COMMIT;
2269:
2270: END IF;

Line 2589: -- DELETE iby_security_segments

2585: -- last_update_login = fnd_global.login_id,
2586: -- object_version_number = object_version_number + 1
2587: -- WHERE trxn_extension_id = p_trxn_entity_id;
2588:
2589: -- DELETE iby_security_segments
2590: -- WHERE sec_segment_id = l_code_segment_id;
2591:
2592: -- As per PABP guidelines, the cvv value should be consumed
2593: -- securely. i.e, first update with a random value, do a commit

Line 4980: FROM iby_fndcpt_tx_extensions x, iby_security_segments s,

4976: IS
4977: SELECT x.trxn_extension_id, x.instr_sec_code_length,
4978: NVL(x.encrypted,'N'), s.segment_cipher_text, k.subkey_cipher_text,
4979: s.sec_segment_id
4980: FROM iby_fndcpt_tx_extensions x, iby_security_segments s,
4981: iby_sys_security_subkeys k
4982: WHERE (NVL(x.encrypted,'N') = 'Y')
4983: AND (NOT instrument_security_code IS NULL)
4984: AND (x.instr_code_sec_segment_id = s.sec_segment_id(+))

Line 5015: DELETE iby_security_segments

5011: last_update_login = fnd_global.login_id,
5012: object_version_number = object_version_number + 1
5013: WHERE trxn_extension_id = c_ext_rec.trxn_extension_id;
5014:
5015: DELETE iby_security_segments
5016: WHERE sec_segment_id = c_ext_rec.sec_segment_id;
5017: END LOOP;
5018:
5019: IF FND_API.To_Boolean(p_commit) THEN

Line 5028: p_sec_code_cipher IN iby_security_segments.segment_cipher_text%TYPE,

5024:
5025: FUNCTION Get_Security_Code
5026: (p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
5027: p_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
5028: p_sec_code_cipher IN iby_security_segments.segment_cipher_text%TYPE,
5029: p_sec_code_len IN iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE
5030: )
5031: RETURN iby_fndcpt_tx_extensions.instrument_security_code%TYPE
5032: IS

Line 5060: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;

5056: RETURN iby_fndcpt_tx_extensions.instrument_security_code%TYPE
5057: IS
5058: l_sec_code iby_fndcpt_tx_extensions.instrument_security_code%TYPE;
5059: l_sec_code_len iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE;
5060: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;
5061: l_subkey_cipher iby_sys_security_subkeys.subkey_cipher_text%TYPE;
5062: l_encrypted iby_fndcpt_tx_extensions.encrypted%TYPE;
5063: lx_err_code VARCHAR2(100);
5064:

Line 5070: FROM iby_fndcpt_tx_extensions x, iby_security_segments s,

5066: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)
5067: IS
5068: SELECT x.instrument_security_code, x.instr_sec_code_length,
5069: NVL(x.encrypted,'N'), s.segment_cipher_text, k.subkey_cipher_text
5070: FROM iby_fndcpt_tx_extensions x, iby_security_segments s,
5071: iby_sys_security_subkeys k
5072: WHERE (trxn_extension_id = ci_extension_id)
5073: AND (x.instr_code_sec_segment_id = s.sec_segment_id(+))
5074: AND (s.sec_subkey_id = k.sec_subkey_id(+));