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_PKG

Line 6583: p_sys_security_key IN iby_security_pkg.DES3_KEY_TYPE,

6579:
6580:
6581: PROCEDURE Encrypt_Extensions
6582: (p_commit IN VARCHAR2,
6583: p_sys_security_key IN iby_security_pkg.DES3_KEY_TYPE,
6584: x_err_code OUT NOCOPY VARCHAR2
6585: )
6586: IS
6587: l_mode iby_sys_security_options.instr_sec_code_encryption_mode%TYPE;

Line 6590: l_subkey iby_security_pkg.DES3_KEY_TYPE;

6586: IS
6587: l_mode iby_sys_security_options.instr_sec_code_encryption_mode%TYPE;
6588: l_cvv2 VARCHAR2(100);
6589: lx_segment_id iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE;
6590: l_subkey iby_security_pkg.DES3_KEY_TYPE;
6591: l_module CONSTANT VARCHAR2(30) := 'Encrypt_Extensions';
6592: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.' || l_module;
6593: CURSOR c_extensions
6594: IS

Line 6607: IF (l_mode = iby_security_pkg.G_ENCRYPT_MODE_NONE) THEN

6603: IF( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6604: iby_debug_pub.add('Enter',G_LEVEL_PROCEDURE,l_dbg_mod);
6605: END IF;
6606:
6607: IF (l_mode = iby_security_pkg.G_ENCRYPT_MODE_NONE) THEN
6608: RETURN;
6609: END IF;
6610:
6611: iby_security_pkg.validate_sys_key(p_sys_security_key,x_err_code);

Line 6611: iby_security_pkg.validate_sys_key(p_sys_security_key,x_err_code);

6607: IF (l_mode = iby_security_pkg.G_ENCRYPT_MODE_NONE) THEN
6608: RETURN;
6609: END IF;
6610:
6611: iby_security_pkg.validate_sys_key(p_sys_security_key,x_err_code);
6612: IF (NOT x_err_code IS NULL) THEN
6613: RETURN;
6614: END IF;
6615:

Line 6622: IBY_SECURITY_PKG.Encode_CVV(c_ext_rec.instrument_security_code,TRUE);

6618: -- as per the PABP norms. So, use the new Encode_CVV API
6619: -- instead of the previous Encode_Number API.
6620: IF('Y' = IBY_UTILITY_PVT.isNumeric(c_ext_rec.instrument_security_code)) THEN
6621: l_cvv2 :=
6622: IBY_SECURITY_PKG.Encode_CVV(c_ext_rec.instrument_security_code,TRUE);
6623:
6624: IBY_SECURITY_PKG.Create_Segment
6625: (FND_API.G_FALSE,l_cvv2,iby_security_pkg.G_ENCODING_NUMERIC,
6626: p_sys_security_key,lx_segment_id);

Line 6624: IBY_SECURITY_PKG.Create_Segment

6620: IF('Y' = IBY_UTILITY_PVT.isNumeric(c_ext_rec.instrument_security_code)) THEN
6621: l_cvv2 :=
6622: IBY_SECURITY_PKG.Encode_CVV(c_ext_rec.instrument_security_code,TRUE);
6623:
6624: IBY_SECURITY_PKG.Create_Segment
6625: (FND_API.G_FALSE,l_cvv2,iby_security_pkg.G_ENCODING_NUMERIC,
6626: p_sys_security_key,lx_segment_id);
6627:
6628: UPDATE iby_fndcpt_tx_extensions

Line 6625: (FND_API.G_FALSE,l_cvv2,iby_security_pkg.G_ENCODING_NUMERIC,

6621: l_cvv2 :=
6622: IBY_SECURITY_PKG.Encode_CVV(c_ext_rec.instrument_security_code,TRUE);
6623:
6624: IBY_SECURITY_PKG.Create_Segment
6625: (FND_API.G_FALSE,l_cvv2,iby_security_pkg.G_ENCODING_NUMERIC,
6626: p_sys_security_key,lx_segment_id);
6627:
6628: UPDATE iby_fndcpt_tx_extensions
6629: SET

Line 6654: p_sys_security_key IN iby_security_pkg.DES3_KEY_TYPE,

6650: END Encrypt_Extensions;
6651:
6652: PROCEDURE Encrypt_Security_Code
6653: (p_commit IN VARCHAR2 := FND_API.G_TRUE,
6654: p_sys_security_key IN iby_security_pkg.DES3_KEY_TYPE,
6655: p_security_code IN iby_fndcpt_tx_extensions.instrument_security_code%TYPE,
6656: x_segment_id OUT NOCOPY NUMBER,
6657: x_err_code OUT NOCOPY VARCHAR2
6658: )

Line 6663: l_subkey iby_security_pkg.DES3_KEY_TYPE;

6659: IS
6660: l_mode iby_sys_security_options.instr_sec_code_encryption_mode%TYPE;
6661: l_cvv2 VARCHAR2(100);
6662: lx_segment_id iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE;
6663: l_subkey iby_security_pkg.DES3_KEY_TYPE;
6664: l_module CONSTANT VARCHAR2(30) := 'Encrypt_Security_Code';
6665: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.' || l_module;
6666:
6667: BEGIN

Line 6674: IF (l_mode = iby_security_pkg.G_ENCRYPT_MODE_NONE) THEN

6670: END IF;
6671:
6672: -- test_debug('Inside Encrypt_Security_Code.. ');
6673: l_mode := Get_Extension_Encrypt_Mode;
6674: IF (l_mode = iby_security_pkg.G_ENCRYPT_MODE_NONE) THEN
6675: RETURN;
6676: END IF;
6677: iby_security_pkg.validate_sys_key(p_sys_security_key,x_err_code);
6678: -- test_debug('sysKey valid.. ');

Line 6677: iby_security_pkg.validate_sys_key(p_sys_security_key,x_err_code);

6673: l_mode := Get_Extension_Encrypt_Mode;
6674: IF (l_mode = iby_security_pkg.G_ENCRYPT_MODE_NONE) THEN
6675: RETURN;
6676: END IF;
6677: iby_security_pkg.validate_sys_key(p_sys_security_key,x_err_code);
6678: -- test_debug('sysKey valid.. ');
6679: IF (NOT x_err_code IS NULL) THEN
6680: RETURN;
6681: END IF;

Line 6682: l_cvv2 := IBY_SECURITY_PKG.Encode_CVV(p_security_code,TRUE);

6678: -- test_debug('sysKey valid.. ');
6679: IF (NOT x_err_code IS NULL) THEN
6680: RETURN;
6681: END IF;
6682: l_cvv2 := IBY_SECURITY_PKG.Encode_CVV(p_security_code,TRUE);
6683: -- test_debug('encoded cvv: '|| l_cvv2);
6684: IBY_SECURITY_PKG.Create_Segment
6685: (FND_API.G_FALSE,l_cvv2,iby_security_pkg.G_ENCODING_NUMERIC,
6686: p_sys_security_key,lx_segment_id);

Line 6684: IBY_SECURITY_PKG.Create_Segment

6680: RETURN;
6681: END IF;
6682: l_cvv2 := IBY_SECURITY_PKG.Encode_CVV(p_security_code,TRUE);
6683: -- test_debug('encoded cvv: '|| l_cvv2);
6684: IBY_SECURITY_PKG.Create_Segment
6685: (FND_API.G_FALSE,l_cvv2,iby_security_pkg.G_ENCODING_NUMERIC,
6686: p_sys_security_key,lx_segment_id);
6687: -- test_debug('segmentId: '|| lx_segment_id);
6688:

Line 6685: (FND_API.G_FALSE,l_cvv2,iby_security_pkg.G_ENCODING_NUMERIC,

6681: END IF;
6682: l_cvv2 := IBY_SECURITY_PKG.Encode_CVV(p_security_code,TRUE);
6683: -- test_debug('encoded cvv: '|| l_cvv2);
6684: IBY_SECURITY_PKG.Create_Segment
6685: (FND_API.G_FALSE,l_cvv2,iby_security_pkg.G_ENCODING_NUMERIC,
6686: p_sys_security_key,lx_segment_id);
6687: -- test_debug('segmentId: '|| lx_segment_id);
6688:
6689: x_segment_id := lx_segment_id;

Line 6702: p_sys_security_key IN iby_security_pkg.DES3_KEY_TYPE,

6698: END Encrypt_Security_Code;
6699:
6700: PROCEDURE Decrypt_Extensions
6701: (p_commit IN VARCHAR2 := FND_API.G_TRUE,
6702: p_sys_security_key IN iby_security_pkg.DES3_KEY_TYPE,
6703: x_err_code OUT NOCOPY VARCHAR2
6704: )
6705: IS
6706: l_mode iby_sys_security_options.instr_sec_code_encryption_mode%TYPE;

Line 6728: IF (NOT (l_mode = iby_security_pkg.G_ENCRYPT_MODE_NONE)) THEN

6724: iby_debug_pub.add('Enter',G_LEVEL_PROCEDURE,l_dbg_mod);
6725: END IF;
6726:
6727: l_mode := Get_Extension_Encrypt_Mode;
6728: IF (NOT (l_mode = iby_security_pkg.G_ENCRYPT_MODE_NONE)) THEN
6729: RETURN;
6730: END IF;
6731:
6732: iby_security_pkg.validate_sys_key(p_sys_security_key,x_err_code);

Line 6732: iby_security_pkg.validate_sys_key(p_sys_security_key,x_err_code);

6728: IF (NOT (l_mode = iby_security_pkg.G_ENCRYPT_MODE_NONE)) THEN
6729: RETURN;
6730: END IF;
6731:
6732: iby_security_pkg.validate_sys_key(p_sys_security_key,x_err_code);
6733: IF (NOT x_err_code IS NULL) THEN
6734: RETURN;
6735: END IF;
6736:

Line 6767: (p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,

6763:
6764: END Decrypt_Extensions;
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: )

Line 6777: l_subkey iby_security_pkg.DES3_KEY_TYPE;

6773: IS
6774: --Increased the varchar2 size from 30 to 100 since we now
6775: --pad the cvv to 32 bytes of data.
6776: l_sec_code VARCHAR2(100);
6777: l_subkey iby_security_pkg.DES3_KEY_TYPE;
6778: l_module CONSTANT VARCHAR2(30) := 'Get_Security_Code(4)';
6779: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.' || l_module;
6780:
6781: BEGIN

Line 6787: IBY_SECURITY_PKG.Get_Sys_Subkey(p_sys_sec_key,p_subkey_cipher);

6783: iby_debug_pub.add('Enter',G_LEVEL_PROCEDURE,l_dbg_mod);
6784: END IF;
6785:
6786: l_subkey :=
6787: IBY_SECURITY_PKG.Get_Sys_Subkey(p_sys_sec_key,p_subkey_cipher);
6788:
6789: l_sec_code :=
6790: dbms_obfuscation_toolkit.des3decrypt
6791: ( input => p_sec_code_cipher, key => l_subkey,

Line 6795: l_sec_code := IBY_SECURITY_PKG.Decode_Number(l_sec_code,p_sec_code_len,TRUE);

6791: ( input => p_sec_code_cipher, key => l_subkey,
6792: which => dbms_obfuscation_toolkit.ThreeKeyMode
6793: );
6794:
6795: l_sec_code := IBY_SECURITY_PKG.Decode_Number(l_sec_code,p_sec_code_len,TRUE);
6796:
6797: IF( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6798: iby_debug_pub.add('Exit',G_LEVEL_PROCEDURE,l_dbg_mod);
6799: END IF;

Line 6806: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE

6802: END Get_Security_Code;
6803:
6804: FUNCTION Get_Security_Code
6805: (p_trxn_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE,
6806: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE
6807: )
6808: RETURN iby_fndcpt_tx_extensions.instrument_security_code%TYPE
6809: IS
6810: l_sec_code iby_fndcpt_tx_extensions.instrument_security_code%TYPE;

Line 6846: iby_security_pkg.validate_sys_key(p_sys_sec_key,lx_err_code);

6842:
6843: IF (l_encrypted = 'N') THEN
6844: RETURN l_sec_code;
6845: ELSE
6846: iby_security_pkg.validate_sys_key(p_sys_sec_key,lx_err_code);
6847: IF (NOT lx_err_code IS NULL) THEN
6848: raise_application_error(-20000, lx_err_code, FALSE);
6849: RETURN NULL;
6850: END IF;

Line 6864: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE

6860: FUNCTION Get_Security_Code
6861: (
6862: p_segment_id IN iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE,
6863: p_sec_code_len IN iby_fndcpt_tx_extensions.instr_sec_code_length%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;

Line 6894: iby_security_pkg.validate_sys_key(p_sys_sec_key,lx_err_code);

6890: FETCH c_segment
6891: INTO l_segment_cipher, l_subkey_cipher;
6892: CLOSE c_segment;
6893:
6894: iby_security_pkg.validate_sys_key(p_sys_sec_key,lx_err_code);
6895: IF (NOT lx_err_code IS NULL) THEN
6896: raise_application_error(-20000, lx_err_code, FALSE);
6897: RETURN NULL;
6898: END IF;