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 4874: p_sys_security_key IN iby_security_pkg.DES3_KEY_TYPE,

4870: END Create_Return;
4871:
4872: PROCEDURE Encrypt_Extensions
4873: (p_commit IN VARCHAR2,
4874: p_sys_security_key IN iby_security_pkg.DES3_KEY_TYPE,
4875: x_err_code OUT NOCOPY VARCHAR2
4876: )
4877: IS
4878: l_mode iby_sys_security_options.instr_sec_code_encryption_mode%TYPE;

Line 4881: l_subkey iby_security_pkg.DES3_KEY_TYPE;

4877: IS
4878: l_mode iby_sys_security_options.instr_sec_code_encryption_mode%TYPE;
4879: l_cvv2 VARCHAR2(100);
4880: lx_segment_id iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE;
4881: l_subkey iby_security_pkg.DES3_KEY_TYPE;
4882:
4883: CURSOR c_extensions
4884: IS
4885: SELECT x.trxn_extension_id, x.instrument_security_code

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

4888: AND (NOT instrument_security_code IS NULL);
4889: BEGIN
4890:
4891: l_mode := Get_Extension_Encrypt_Mode;
4892: IF (l_mode = iby_security_pkg.G_ENCRYPT_MODE_NONE) THEN
4893: RETURN;
4894: END IF;
4895:
4896: iby_security_pkg.validate_sys_key(p_sys_security_key,x_err_code);

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

4892: IF (l_mode = iby_security_pkg.G_ENCRYPT_MODE_NONE) THEN
4893: RETURN;
4894: END IF;
4895:
4896: iby_security_pkg.validate_sys_key(p_sys_security_key,x_err_code);
4897: IF (NOT x_err_code IS NULL) THEN
4898: RETURN;
4899: END IF;
4900:

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

4902: -- The CVV value should be padded upto 32 bytes of data
4903: -- as per the PABP norms. So, use the new Encode_CVV API
4904: -- instead of the previous Encode_Number API.
4905: l_cvv2 :=
4906: IBY_SECURITY_PKG.Encode_CVV(c_ext_rec.instrument_security_code,TRUE);
4907: IBY_SECURITY_PKG.Create_Segment
4908: (FND_API.G_FALSE,l_cvv2,iby_security_pkg.G_ENCODING_NUMERIC,
4909: p_sys_security_key,lx_segment_id);
4910:

Line 4907: IBY_SECURITY_PKG.Create_Segment

4903: -- as per the PABP norms. So, use the new Encode_CVV API
4904: -- instead of the previous Encode_Number API.
4905: l_cvv2 :=
4906: IBY_SECURITY_PKG.Encode_CVV(c_ext_rec.instrument_security_code,TRUE);
4907: IBY_SECURITY_PKG.Create_Segment
4908: (FND_API.G_FALSE,l_cvv2,iby_security_pkg.G_ENCODING_NUMERIC,
4909: p_sys_security_key,lx_segment_id);
4910:
4911: UPDATE iby_fndcpt_tx_extensions

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

4904: -- instead of the previous Encode_Number API.
4905: l_cvv2 :=
4906: IBY_SECURITY_PKG.Encode_CVV(c_ext_rec.instrument_security_code,TRUE);
4907: IBY_SECURITY_PKG.Create_Segment
4908: (FND_API.G_FALSE,l_cvv2,iby_security_pkg.G_ENCODING_NUMERIC,
4909: p_sys_security_key,lx_segment_id);
4910:
4911: UPDATE iby_fndcpt_tx_extensions
4912: SET

Line 4930: p_sys_security_key IN iby_security_pkg.DES3_KEY_TYPE,

4926: END Encrypt_Extensions;
4927:
4928: PROCEDURE Encrypt_Security_Code
4929: (p_commit IN VARCHAR2 := FND_API.G_TRUE,
4930: p_sys_security_key IN iby_security_pkg.DES3_KEY_TYPE,
4931: p_security_code IN iby_fndcpt_tx_extensions.instrument_security_code%TYPE,
4932: x_segment_id OUT NOCOPY NUMBER,
4933: x_err_code OUT NOCOPY VARCHAR2
4934: )

Line 4939: l_subkey iby_security_pkg.DES3_KEY_TYPE;

4935: IS
4936: l_mode iby_sys_security_options.instr_sec_code_encryption_mode%TYPE;
4937: l_cvv2 VARCHAR2(100);
4938: lx_segment_id iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE;
4939: l_subkey iby_security_pkg.DES3_KEY_TYPE;
4940:
4941: BEGIN
4942: -- test_debug('Inside Encrypt_Security_Code.. ');
4943: l_mode := Get_Extension_Encrypt_Mode;

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

4940:
4941: BEGIN
4942: -- test_debug('Inside Encrypt_Security_Code.. ');
4943: l_mode := Get_Extension_Encrypt_Mode;
4944: IF (l_mode = iby_security_pkg.G_ENCRYPT_MODE_NONE) THEN
4945: RETURN;
4946: END IF;
4947: iby_security_pkg.validate_sys_key(p_sys_security_key,x_err_code);
4948: -- test_debug('sysKey valid.. ');

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

4943: l_mode := Get_Extension_Encrypt_Mode;
4944: IF (l_mode = iby_security_pkg.G_ENCRYPT_MODE_NONE) THEN
4945: RETURN;
4946: END IF;
4947: iby_security_pkg.validate_sys_key(p_sys_security_key,x_err_code);
4948: -- test_debug('sysKey valid.. ');
4949: IF (NOT x_err_code IS NULL) THEN
4950: RETURN;
4951: END IF;

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

4948: -- test_debug('sysKey valid.. ');
4949: IF (NOT x_err_code IS NULL) THEN
4950: RETURN;
4951: END IF;
4952: l_cvv2 := IBY_SECURITY_PKG.Encode_CVV(p_security_code,TRUE);
4953: -- test_debug('encoded cvv: '|| l_cvv2);
4954: IBY_SECURITY_PKG.Create_Segment
4955: (FND_API.G_FALSE,l_cvv2,iby_security_pkg.G_ENCODING_NUMERIC,
4956: p_sys_security_key,lx_segment_id);

Line 4954: IBY_SECURITY_PKG.Create_Segment

4950: RETURN;
4951: END IF;
4952: l_cvv2 := IBY_SECURITY_PKG.Encode_CVV(p_security_code,TRUE);
4953: -- test_debug('encoded cvv: '|| l_cvv2);
4954: IBY_SECURITY_PKG.Create_Segment
4955: (FND_API.G_FALSE,l_cvv2,iby_security_pkg.G_ENCODING_NUMERIC,
4956: p_sys_security_key,lx_segment_id);
4957: -- test_debug('segmentId: '|| lx_segment_id);
4958:

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

4951: END IF;
4952: l_cvv2 := IBY_SECURITY_PKG.Encode_CVV(p_security_code,TRUE);
4953: -- test_debug('encoded cvv: '|| l_cvv2);
4954: IBY_SECURITY_PKG.Create_Segment
4955: (FND_API.G_FALSE,l_cvv2,iby_security_pkg.G_ENCODING_NUMERIC,
4956: p_sys_security_key,lx_segment_id);
4957: -- test_debug('segmentId: '|| lx_segment_id);
4958:
4959: x_segment_id := lx_segment_id;

Line 4969: p_sys_security_key IN iby_security_pkg.DES3_KEY_TYPE,

4965: END Encrypt_Security_Code;
4966:
4967: PROCEDURE Decrypt_Extensions
4968: (p_commit IN VARCHAR2 := FND_API.G_TRUE,
4969: p_sys_security_key IN iby_security_pkg.DES3_KEY_TYPE,
4970: x_err_code OUT NOCOPY VARCHAR2
4971: )
4972: IS
4973: l_mode iby_sys_security_options.instr_sec_code_encryption_mode%TYPE;

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

4986:
4987: BEGIN
4988:
4989: l_mode := Get_Extension_Encrypt_Mode;
4990: IF (NOT (l_mode = iby_security_pkg.G_ENCRYPT_MODE_NONE)) THEN
4991: RETURN;
4992: END IF;
4993:
4994: iby_security_pkg.validate_sys_key(p_sys_security_key,x_err_code);

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

4990: IF (NOT (l_mode = iby_security_pkg.G_ENCRYPT_MODE_NONE)) THEN
4991: RETURN;
4992: END IF;
4993:
4994: iby_security_pkg.validate_sys_key(p_sys_security_key,x_err_code);
4995: IF (NOT x_err_code IS NULL) THEN
4996: RETURN;
4997: END IF;
4998:

Line 5026: (p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,

5022:
5023: END Decrypt_Extensions;
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: )

Line 5036: l_subkey iby_security_pkg.DES3_KEY_TYPE;

5032: IS
5033: --Increased the varchar2 size from 30 to 100 since we now
5034: --pad the cvv to 32 bytes of data.
5035: l_sec_code VARCHAR2(100);
5036: l_subkey iby_security_pkg.DES3_KEY_TYPE;
5037: BEGIN
5038: l_subkey :=
5039: IBY_SECURITY_PKG.Get_Sys_Subkey(p_sys_sec_key,p_subkey_cipher);
5040:

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

5035: l_sec_code VARCHAR2(100);
5036: l_subkey iby_security_pkg.DES3_KEY_TYPE;
5037: BEGIN
5038: l_subkey :=
5039: IBY_SECURITY_PKG.Get_Sys_Subkey(p_sys_sec_key,p_subkey_cipher);
5040:
5041: l_sec_code :=
5042: dbms_obfuscation_toolkit.des3decrypt
5043: ( input => p_sec_code_cipher, key => l_subkey,

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

5043: ( input => p_sec_code_cipher, key => l_subkey,
5044: which => dbms_obfuscation_toolkit.ThreeKeyMode
5045: );
5046:
5047: l_sec_code := IBY_SECURITY_PKG.Decode_Number(l_sec_code,p_sec_code_len,TRUE);
5048:
5049: RETURN l_sec_code;
5050: END Get_Security_Code;
5051:

Line 5054: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE

5050: END Get_Security_Code;
5051:
5052: FUNCTION Get_Security_Code
5053: (p_trxn_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE,
5054: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE
5055: )
5056: RETURN iby_fndcpt_tx_extensions.instrument_security_code%TYPE
5057: IS
5058: l_sec_code iby_fndcpt_tx_extensions.instrument_security_code%TYPE;

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

5085:
5086: IF (l_encrypted = 'N') THEN
5087: RETURN l_sec_code;
5088: ELSE
5089: iby_security_pkg.validate_sys_key(p_sys_sec_key,lx_err_code);
5090: IF (NOT lx_err_code IS NULL) THEN
5091: raise_application_error(-20000, lx_err_code, FALSE);
5092: RETURN NULL;
5093: END IF;