DBA Data[Home] [Help]

APPS.IBY_FNDCPT_TRXN_PUB dependencies on DBMS_RANDOM

Line 2217: SELECT trunc(DBMS_RANDOM.VALUE(1000,9999)) INTO l_random_val FROM dual;

2213: -- If the segment Id is NULL, it implies that the CVV value wasn't encrypted
2214: -- Just securely wipe out the CVV column in this case.
2215:
2216: IF (p_segment_id IS NULL) THEN
2217: SELECT trunc(DBMS_RANDOM.VALUE(1000,9999)) INTO l_random_val FROM dual;
2218: UPDATE iby_fndcpt_tx_extensions
2219: -- Update the sec_code with a randomly generated number
2220: SET instrument_security_code = l_random_val,
2221: --instr_sec_code_length = NULL,