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

Line 632: x_segment_id OUT NOCOPY iby_security_segments.sec_segment_id%TYPE

628: (p_commit IN VARCHAR2,
629: p_segment IN RAW,
630: p_encoding IN VARCHAR2,
631: p_sys_key IN DES3_KEY_TYPE,
632: x_segment_id OUT NOCOPY iby_security_segments.sec_segment_id%TYPE
633: )
634: IS
635: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;
636: lx_subkey_id iby_sys_security_subkeys.sec_subkey_id%TYPE;

Line 635: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;

631: p_sys_key IN DES3_KEY_TYPE,
632: x_segment_id OUT NOCOPY iby_security_segments.sec_segment_id%TYPE
633: )
634: IS
635: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;
636: lx_subkey_id iby_sys_security_subkeys.sec_subkey_id%TYPE;
637: lx_subkey iby_sys_security_subkeys.subkey_cipher_text%TYPE;
638: BEGIN
639:

Line 649: SELECT iby_security_segments_s.NEXTVAL INTO x_segment_id FROM DUAL;

645: (input => p_segment, key => lx_subkey,
646: which => dbms_obfuscation_toolkit.ThreeKeyMode
647: );
648:
649: SELECT iby_security_segments_s.NEXTVAL INTO x_segment_id FROM DUAL;
650: INSERT INTO iby_security_segments
651: (sec_segment_id, segment_cipher_text, sec_subkey_id, encoding_scheme,
652: created_by, creation_date, last_updated_by, last_update_date,
653: last_update_login, object_version_number

Line 650: INSERT INTO iby_security_segments

646: which => dbms_obfuscation_toolkit.ThreeKeyMode
647: );
648:
649: SELECT iby_security_segments_s.NEXTVAL INTO x_segment_id FROM DUAL;
650: INSERT INTO iby_security_segments
651: (sec_segment_id, segment_cipher_text, sec_subkey_id, encoding_scheme,
652: created_by, creation_date, last_updated_by, last_update_date,
653: last_update_login, object_version_number
654: )

Line 668: p_segment_id IN iby_security_segments.sec_segment_id%TYPE,

664: END Create_Segment;
665:
666: PROCEDURE Update_Segment
667: (p_commit IN VARCHAR2,
668: p_segment_id IN iby_security_segments.sec_segment_id%TYPE,
669: p_segment IN RAW,
670: p_encoding IN VARCHAR2,
671: p_sys_key IN DES3_KEY_TYPE,
672: p_subkey_cipher IN DES3_KEY_TYPE

Line 675: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;

671: p_sys_key IN DES3_KEY_TYPE,
672: p_subkey_cipher IN DES3_KEY_TYPE
673: )
674: IS
675: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;
676: l_subkey DES3_KEY_TYPE;
677: BEGIN
678: l_subkey :=
679: DBMS_OBFUSCATION_TOOLKIT.des3decrypt

Line 689: UPDATE iby_security_segments

685: (input => p_segment, key => l_subkey,
686: which => dbms_obfuscation_toolkit.ThreeKeyMode
687: );
688:
689: UPDATE iby_security_segments
690: SET
691: segment_cipher_text = l_segment_cipher,
692: encoding_scheme = NVL(p_encoding,encoding_scheme),
693: last_updated_by = fnd_global.user_id,

Line 929: x_sec_segment_id iby_security_segments.sec_segment_id%TYPE;

925: lx_key_error VARCHAR2(300);
926: lx_compress_val VARCHAR2(2000);
927: lx_unmask_digits VARCHAR2(2000);
928: l_sys_key RAW(24);
929: x_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
930: l_fv_segment iby_security_segments.segment_cipher_text%TYPE;
931: l_subkey_cipher iby_sys_security_subkeys.subkey_cipher_text%TYPE;
932:
933: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.encrypt_field_vals';

Line 930: l_fv_segment iby_security_segments.segment_cipher_text%TYPE;

926: lx_compress_val VARCHAR2(2000);
927: lx_unmask_digits VARCHAR2(2000);
928: l_sys_key RAW(24);
929: x_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
930: l_fv_segment iby_security_segments.segment_cipher_text%TYPE;
931: l_subkey_cipher iby_sys_security_subkeys.subkey_cipher_text%TYPE;
932:
933: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.encrypt_field_vals';
934:

Line 971: , iby_security_segments ss

967: BEGIN
968: SELECT sk.subkey_cipher_text
969: INTO l_subkey_cipher
970: FROM iby_sys_security_subkeys sk
971: , iby_security_segments ss
972: WHERE sk.sec_subkey_id = ss.sec_subkey_id
973: AND ss.sec_segment_id = p_sec_segment_id;
974: END;
975: Update_Segment ( FND_API.G_FALSE

Line 986: DELETE FROM iby_security_segments

982:
983: x_sec_segment_id := p_sec_segment_id;
984: END IF;
985: ELSE
986: DELETE FROM iby_security_segments
987: WHERE sec_segment_id = p_sec_segment_id;
988: END IF;
989:
990: IF ( p_commit = 'Y' ) THEN

Line 1061: (p_segment_id IN iby_security_segments.sec_segment_id%TYPE,

1057:
1058: END encrypt_date_field;
1059:
1060: FUNCTION Uncipher_Field_Value
1061: (p_segment_id IN iby_security_segments.sec_segment_id%TYPE,
1062: p_sys_key IN DES3_KEY_TYPE,
1063: p_sub_key_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
1064: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,
1065: p_encoding IN iby_security_segments.encoding_scheme%TYPE

Line 1064: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,

1060: FUNCTION Uncipher_Field_Value
1061: (p_segment_id IN iby_security_segments.sec_segment_id%TYPE,
1062: p_sys_key IN DES3_KEY_TYPE,
1063: p_sub_key_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
1064: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,
1065: p_encoding IN iby_security_segments.encoding_scheme%TYPE
1066: )
1067: RETURN VARCHAR2
1068: IS

Line 1065: p_encoding IN iby_security_segments.encoding_scheme%TYPE

1061: (p_segment_id IN iby_security_segments.sec_segment_id%TYPE,
1062: p_sys_key IN DES3_KEY_TYPE,
1063: p_sub_key_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
1064: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,
1065: p_encoding IN iby_security_segments.encoding_scheme%TYPE
1066: )
1067: RETURN VARCHAR2
1068: IS
1069: l_sub_key RAW(24);

Line 1070: l_fv_segment iby_security_segments.segment_cipher_text%TYPE;

1066: )
1067: RETURN VARCHAR2
1068: IS
1069: l_sub_key RAW(24);
1070: l_fv_segment iby_security_segments.segment_cipher_text%TYPE;
1071: l_decrypted_value VARCHAR2(2000);
1072: l_db_characterset VARCHAR2(2000);
1073: BEGIN
1074:

Line 1109: l_fv_segment iby_security_segments.segment_cipher_text%TYPE;

1105:
1106: lx_key_error VARCHAR2(300);
1107: l_sys_key RAW(24);
1108: l_subkey_ciphertxt iby_sys_security_subkeys.subkey_cipher_text%TYPE;
1109: l_fv_segment iby_security_segments.segment_cipher_text%TYPE;
1110: l_encoding iby_security_segments.encoding_scheme%TYPE;
1111:
1112: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.decrypt_field_vals';
1113:

Line 1110: l_encoding iby_security_segments.encoding_scheme%TYPE;

1106: lx_key_error VARCHAR2(300);
1107: l_sys_key RAW(24);
1108: l_subkey_ciphertxt iby_sys_security_subkeys.subkey_cipher_text%TYPE;
1109: l_fv_segment iby_security_segments.segment_cipher_text%TYPE;
1110: l_encoding iby_security_segments.encoding_scheme%TYPE;
1111:
1112: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.decrypt_field_vals';
1113:
1114: BEGIN

Line 1133: , iby_security_segments bas

1129: INTO l_subkey_ciphertxt
1130: , l_fv_segment
1131: , l_encoding
1132: FROM iby_sys_security_subkeys bak
1133: , iby_security_segments bas
1134: WHERE bas.sec_subkey_id = bak.sec_subkey_id
1135: AND bas.sec_segment_id = p_sec_segment_id;
1136: END;
1137: