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_CREDITCARD_PKG dependencies on IBY_SYS_SECURITY_OPTIONS

Line 5: enc_supl_data iby_sys_security_options.encrypt_supplemental_card_data%TYPE;

1: PACKAGE BODY iby_creditcard_pkg AS
2: /*$Header: ibyccb.pls 120.84.12020000.2 2013/04/12 15:06:14 dhati ship $*/
3:
4: --Variable to store the supplemental cardholder data encryption flag
5: enc_supl_data iby_sys_security_options.encrypt_supplemental_card_data%TYPE;
6:
7: --
8: -- USE: Gets the credit card encryption mode setting
9: --

Line 11: RETURN iby_sys_security_options.cc_encryption_mode%TYPE

7: --
8: -- USE: Gets the credit card encryption mode setting
9: --
10: FUNCTION Get_CC_Encrypt_Mode
11: RETURN iby_sys_security_options.cc_encryption_mode%TYPE
12: IS
13: l_mode iby_sys_security_options.cc_encryption_mode%TYPE;
14: CURSOR c_encrypt_mode
15: IS

Line 13: l_mode iby_sys_security_options.cc_encryption_mode%TYPE;

9: --
10: FUNCTION Get_CC_Encrypt_Mode
11: RETURN iby_sys_security_options.cc_encryption_mode%TYPE
12: IS
13: l_mode iby_sys_security_options.cc_encryption_mode%TYPE;
14: CURSOR c_encrypt_mode
15: IS
16: SELECT cc_encryption_mode
17: FROM iby_sys_security_options;

Line 17: FROM iby_sys_security_options;

13: l_mode iby_sys_security_options.cc_encryption_mode%TYPE;
14: CURSOR c_encrypt_mode
15: IS
16: SELECT cc_encryption_mode
17: FROM iby_sys_security_options;
18: BEGIN
19: IF (c_encrypt_mode%ISOPEN) THEN CLOSE c_encrypt_mode; END IF;
20:
21: OPEN c_encrypt_mode;

Line 40: FROM iby_sys_security_options;

36:
37: CURSOR c_sec
38: IS
39: SELECT nvl(encrypt_supplemental_card_data, 'N')
40: FROM iby_sys_security_options;
41: BEGIN
42:
43: -- No need to cache the value as it may cause synchronization issues.
44: -- IF (enc_supl_data IS NOT NULL) THEN

Line 173: x_mask_setting OUT NOCOPY iby_sys_security_options.credit_card_mask_setting%TYPE,

169: p_chname IN iby_creditcard.chname%TYPE,
170: p_segment_id IN NUMBER,
171: x_segment_id OUT NOCOPY NUMBER,
172: x_masked_chname OUT NOCOPY iby_creditcard.chname%TYPE,
173: x_mask_setting OUT NOCOPY iby_sys_security_options.credit_card_mask_setting%TYPE,
174: x_unmask_len OUT NOCOPY iby_sys_security_options.credit_card_unmask_len%TYPE
175: )
176: IS
177: l_dbg_mod VARCHAR2(100) := 'iby.plsql.IBY_CREDITCARD_PKG' || '.' || 'encrypt_chname';

Line 174: x_unmask_len OUT NOCOPY iby_sys_security_options.credit_card_unmask_len%TYPE

170: p_segment_id IN NUMBER,
171: x_segment_id OUT NOCOPY NUMBER,
172: x_masked_chname OUT NOCOPY iby_creditcard.chname%TYPE,
173: x_mask_setting OUT NOCOPY iby_sys_security_options.credit_card_mask_setting%TYPE,
174: x_unmask_len OUT NOCOPY iby_sys_security_options.credit_card_unmask_len%TYPE
175: )
176: IS
177: l_dbg_mod VARCHAR2(100) := 'iby.plsql.IBY_CREDITCARD_PKG' || '.' || 'encrypt_chname';
178: BEGIN

Line 264: (x_mask_setting OUT NOCOPY iby_sys_security_options.credit_card_mask_setting%TYPE,

260: --
261: -- USE: Gets credit card mask settings
262: --
263: PROCEDURE Get_Mask_Settings
264: (x_mask_setting OUT NOCOPY iby_sys_security_options.credit_card_mask_setting%TYPE,
265: x_unmask_len OUT NOCOPY iby_sys_security_options.credit_card_unmask_len%TYPE
266: )
267: IS
268:

Line 265: x_unmask_len OUT NOCOPY iby_sys_security_options.credit_card_unmask_len%TYPE

261: -- USE: Gets credit card mask settings
262: --
263: PROCEDURE Get_Mask_Settings
264: (x_mask_setting OUT NOCOPY iby_sys_security_options.credit_card_mask_setting%TYPE,
265: x_unmask_len OUT NOCOPY iby_sys_security_options.credit_card_unmask_len%TYPE
266: )
267: IS
268:
269: CURSOR c_mask_setting

Line 272: FROM iby_sys_security_options;

268:
269: CURSOR c_mask_setting
270: IS
271: SELECT credit_card_mask_setting, credit_card_unmask_len
272: FROM iby_sys_security_options;
273:
274: BEGIN
275: x_mask_setting := iby_security_pkg.G_MASK_PREFIX;
276:

Line 309: x_mask_setting OUT NOCOPY iby_sys_security_options.credit_card_mask_setting%TYPE,

305: --
306: PROCEDURE Mask_Card_Number
307: (p_cc_number IN iby_creditcard.ccnumber%TYPE,
308: x_masked_number OUT NOCOPY iby_creditcard.masked_cc_number%TYPE,
309: x_mask_setting OUT NOCOPY iby_sys_security_options.credit_card_mask_setting%TYPE,
310: x_unmask_len OUT NOCOPY iby_sys_security_options.credit_card_unmask_len%TYPE
311: )
312: IS
313: BEGIN

Line 310: x_unmask_len OUT NOCOPY iby_sys_security_options.credit_card_unmask_len%TYPE

306: PROCEDURE Mask_Card_Number
307: (p_cc_number IN iby_creditcard.ccnumber%TYPE,
308: x_masked_number OUT NOCOPY iby_creditcard.masked_cc_number%TYPE,
309: x_mask_setting OUT NOCOPY iby_sys_security_options.credit_card_mask_setting%TYPE,
310: x_unmask_len OUT NOCOPY iby_sys_security_options.credit_card_unmask_len%TYPE
311: )
312: IS
313: BEGIN
314: Get_Mask_Settings(x_mask_setting,x_unmask_len);

Line 324: lx_unmask_len iby_sys_security_options.credit_card_unmask_len%TYPE;

320: RETURN iby_creditcard.masked_cc_number%TYPE
321: IS
322: lx_mask_option iby_creditcard.card_mask_setting%TYPE;
323: lx_mask_number iby_creditcard.masked_cc_number%TYPE;
324: lx_unmask_len iby_sys_security_options.credit_card_unmask_len%TYPE;
325: BEGIN
326: Mask_Card_Number(p_cc_number,lx_mask_number,lx_mask_option,lx_unmask_len);
327: RETURN lx_mask_number;
328: END Mask_Card_Number;

Line 423: l_chname_mask_setting iby_sys_security_options.credit_card_mask_setting%TYPE;

419: l_chname_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
420: l_expdate_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
421: l_chname VARCHAR2(100);
422: l_masked_chname VARCHAR2(100) := NULL;
423: l_chname_mask_setting iby_sys_security_options.credit_card_mask_setting%TYPE;
424: l_chname_unmask_len iby_sys_security_options.credit_card_unmask_len%TYPE;
425: l_exp_date DATE;
426: l_expired VARCHAR2(1) := NULL;
427:

Line 424: l_chname_unmask_len iby_sys_security_options.credit_card_unmask_len%TYPE;

420: l_expdate_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
421: l_chname VARCHAR2(100);
422: l_masked_chname VARCHAR2(100) := NULL;
423: l_chname_mask_setting iby_sys_security_options.credit_card_mask_setting%TYPE;
424: l_chname_unmask_len iby_sys_security_options.credit_card_unmask_len%TYPE;
425: l_exp_date DATE;
426: l_expired VARCHAR2(1) := NULL;
427:
428: l_subkey iby_sys_security_subkeys.subkey_cipher_text%TYPE;

Line 1268: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,

1264: p_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
1265: p_card_len IN iby_cc_issuer_ranges.card_number_length%TYPE,
1266: p_cc_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
1267: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,
1268: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,
1269: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE,
1270: p_unmask_digits IN iby_creditcard.masked_cc_number%TYPE
1271: )
1272: RETURN iby_creditcard.ccnumber%TYPE

Line 1269: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE,

1265: p_card_len IN iby_cc_issuer_ranges.card_number_length%TYPE,
1266: p_cc_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
1267: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,
1268: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,
1269: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE,
1270: p_unmask_digits IN iby_creditcard.masked_cc_number%TYPE
1271: )
1272: RETURN iby_creditcard.ccnumber%TYPE
1273: IS

Line 1307: l_mode iby_sys_security_options.cc_encryption_mode%TYPE;

1303: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE
1304: )
1305: IS
1306: l_cc_number iby_creditcard.ccnumber%TYPE;
1307: l_mode iby_sys_security_options.cc_encryption_mode%TYPE;
1308: -- variabled for CHNAME and EXPDATE decryption
1309: l_chname VARCHAR2(80);
1310: l_str_exp_date VARCHAR2(20);
1311: l_exp_date DATE;

Line 1402: l_mode iby_sys_security_options.cc_encryption_mode%TYPE;

1398: (p_commit IN VARCHAR2,
1399: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE
1400: )
1401: IS
1402: l_mode iby_sys_security_options.cc_encryption_mode%TYPE;
1403: lx_compress_cc iby_creditcard.ccnumber%TYPE;
1404: lx_mask_digits iby_creditcard.masked_cc_number%TYPE;
1405:
1406: l_subkey iby_security_pkg.DES3_KEY_TYPE;

Line 1692: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,

1688: PROCEDURE Compress_CC_Number
1689: (p_card_number IN iby_creditcard.ccnumber%TYPE,
1690: p_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
1691: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,
1692: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,
1693: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE,
1694: x_compress_num OUT NOCOPY iby_creditcard.ccnumber%TYPE,
1695: x_unmask_digits OUT NOCOPY iby_creditcard.masked_cc_number%TYPE
1696: )

Line 1693: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE,

1689: (p_card_number IN iby_creditcard.ccnumber%TYPE,
1690: p_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
1691: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,
1692: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,
1693: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE,
1694: x_compress_num OUT NOCOPY iby_creditcard.ccnumber%TYPE,
1695: x_unmask_digits OUT NOCOPY iby_creditcard.masked_cc_number%TYPE
1696: )
1697: IS

Line 1713: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,

1709: (p_card_number IN iby_creditcard.ccnumber%TYPE,
1710: p_card_length IN iby_creditcard.cc_number_length%TYPE,
1711: p_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
1712: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,
1713: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,
1714: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE,
1715: p_unmask_digits IN iby_creditcard.masked_cc_number%TYPE
1716: )
1717: RETURN iby_creditcard.ccnumber%TYPE

Line 1714: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE,

1710: p_card_length IN iby_creditcard.cc_number_length%TYPE,
1711: p_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
1712: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,
1713: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,
1714: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE,
1715: p_unmask_digits IN iby_creditcard.masked_cc_number%TYPE
1716: )
1717: RETURN iby_creditcard.ccnumber%TYPE
1718: IS

Line 1733: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,

1729: FUNCTION Get_Compressed_Len
1730: (p_card_length IN iby_creditcard.cc_number_length%TYPE,
1731: p_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
1732: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,
1733: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,
1734: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE
1735: )
1736: RETURN NUMBER
1737: IS

Line 1734: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE

1730: (p_card_length IN iby_creditcard.cc_number_length%TYPE,
1731: p_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
1732: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,
1733: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,
1734: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE
1735: )
1736: RETURN NUMBER
1737: IS
1738: BEGIN

Line 2008: l_mode iby_sys_security_options.instr_sec_code_encryption_mode%TYPE;

2004: x_chnameUnmaskLen OUT NOCOPY NUMBER,
2005: x_err_code OUT NOCOPY VARCHAR2
2006: ) IS
2007:
2008: l_mode iby_sys_security_options.instr_sec_code_encryption_mode%TYPE;
2009: l_chnameSegmentId iby_creditcard.chname_sec_segment_id%type;
2010:
2011: BEGIN
2012: -- test_debug('Inside Encrypt_Card_Info.. ');