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_SECURITY_SEGMENTS

Line 405: l_cc_ciphertext iby_security_segments.segment_cipher_text%TYPE;

401:
402: lx_cc_number iby_creditcard.ccnumber%TYPE;
403: lx_cc_compressed iby_creditcard.ccnumber%TYPE;
404: lx_unmasked_digits iby_creditcard.ccnumber%TYPE;
405: l_cc_ciphertext iby_security_segments.segment_cipher_text%TYPE;
406: l_encrypted iby_creditcard.encrypted%TYPE;
407: lx_masked_number iby_creditcard.masked_cc_number%TYPE;
408: lx_mask_option iby_creditcard.card_mask_setting%TYPE;
409: lx_unmask_len iby_creditcard.card_unmask_length%TYPE;

Line 412: lx_sec_segment_id iby_security_segments.sec_segment_id%TYPE;

408: lx_mask_option iby_creditcard.card_mask_setting%TYPE;
409: lx_unmask_len iby_creditcard.card_unmask_length%TYPE;
410: l_cc_hash1 iby_creditcard.cc_number_hash1%TYPE;
411: l_cc_hash2 iby_creditcard.cc_number_hash2%TYPE;
412: lx_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
413:
414: l_expiry_date iby_creditcard.expirydate%TYPE;
415:
416: --l_billing_site hz_party_site_uses.party_site_use_id%TYPE;-- will not use this variable any more

Line 419: l_chname_sec_segment_id iby_security_segments.sec_segment_id%TYPE;

415:
416: --l_billing_site hz_party_site_uses.party_site_use_id%TYPE;-- will not use this variable any more
417:
418: -- variabled for CHNAME and EXPDATE encryption
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;

Line 420: l_expdate_sec_segment_id iby_security_segments.sec_segment_id%TYPE;

416: --l_billing_site hz_party_site_uses.party_site_use_id%TYPE;-- will not use this variable any more
417:
418: -- variabled for CHNAME and EXPDATE encryption
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;

Line 805: l_chname_sec_segment_id iby_security_segments.sec_segment_id%TYPE;

801: l_billing_site NUMBER;
802: l_expiry_date iby_creditcard.expirydate%TYPE;
803:
804: -- variabled for CHNAME and EXPDATE encryption
805: l_chname_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
806: l_expdate_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
807: l_chname VARCHAR2(100);
808: l_masked_chname VARCHAR2(100) := NULL;
809: l_expired VARCHAR2(1) := NULL;

Line 806: l_expdate_sec_segment_id iby_security_segments.sec_segment_id%TYPE;

802: l_expiry_date iby_creditcard.expirydate%TYPE;
803:
804: -- variabled for CHNAME and EXPDATE encryption
805: l_chname_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
806: l_expdate_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
807: l_chname VARCHAR2(100);
808: l_masked_chname VARCHAR2(100) := NULL;
809: l_expired VARCHAR2(1) := NULL;
810: l_chname_mask_setting iby_creditcard.chname_mask_setting%TYPE;

Line 1197: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;

1193: RETURN iby_creditcard.ccnumber%TYPE
1194: IS
1195: l_cc_number iby_creditcard.ccnumber%TYPE;
1196: l_masked_cc_number iby_creditcard.masked_cc_number%TYPE;
1197: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;
1198: l_card_len iby_creditcard.cc_number_length%TYPE;
1199: l_encrypted iby_creditcard.encrypted%TYPE;
1200: l_cc_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;
1201: l_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;

Line 1217: FROM iby_creditcard c, iby_security_segments seg,

1213: NVL(c.encrypted,'N'), k.subkey_cipher_text, r.card_number_prefix,
1214: NVL(i.digit_check_flag,'N'), c.card_mask_setting, c.card_unmask_length,
1215: DECODE(encrypted, 'Y',c.ccnumber,'A',c.ccnumber, NULL),
1216: NVL(r.card_number_length,c.cc_number_length)
1217: FROM iby_creditcard c, iby_security_segments seg,
1218: iby_sys_security_subkeys k, iby_cc_issuer_ranges r,
1219: iby_creditcard_issuers_b i
1220: WHERE (instrid = ci_instrid)
1221: AND (c.cc_num_sec_segment_id = seg.sec_segment_id(+))

Line 1261: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,

1257: END uncipher_ccnumber;
1258:
1259: FUNCTION uncipher_ccnumber
1260: (p_cc_number IN iby_creditcard.ccnumber%TYPE,
1261: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,
1262: p_encrypted IN iby_creditcard.encrypted%TYPE,
1263: p_sys_key IN iby_security_pkg.DES3_KEY_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,

Line 1325: iby_security_segments seg

1321: c.chname, c.chname_sec_segment_id,
1322: c.expirydate, c.expiry_sec_segment_id
1323: FROM iby_creditcard c, iby_creditcard_issuers_b i,
1324: iby_cc_issuer_ranges r, iby_sys_security_subkeys k,
1325: iby_security_segments seg
1326: WHERE (NVL(c.encrypted,'N') <> 'N')
1327: AND (c.card_issuer_code = i.card_issuer_code(+))
1328: AND (c.cc_issuer_range_id = r.cc_issuer_range_id(+))
1329: AND (c.cc_num_sec_segment_id = seg.sec_segment_id(+))

Line 1385: DELETE iby_security_segments

1381: last_updated_by = fnd_global.user_id,
1382: last_update_login = fnd_global.login_id
1383: WHERE (instrid = c_card_rec.instrid);
1384:
1385: DELETE iby_security_segments
1386: WHERE (sec_segment_id IN (c_card_rec.cc_num_sec_segment_id,
1387: c_card_rec.chname_sec_segment_id,
1388: c_card_rec.expiry_sec_segment_id)
1389: );

Line 1407: l_segment_id iby_security_segments.sec_segment_id%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;
1407: l_segment_id iby_security_segments.sec_segment_id%TYPE;
1408: l_cc_ciphertext iby_security_segments.segment_cipher_text%TYPE;
1409:
1410: -- variabled for CHNAME and EXPDATE encryption
1411: l_chname_sec_segment_id iby_security_segments.sec_segment_id%TYPE;

Line 1408: l_cc_ciphertext iby_security_segments.segment_cipher_text%TYPE;

1404: lx_mask_digits iby_creditcard.masked_cc_number%TYPE;
1405:
1406: l_subkey iby_security_pkg.DES3_KEY_TYPE;
1407: l_segment_id iby_security_segments.sec_segment_id%TYPE;
1408: l_cc_ciphertext iby_security_segments.segment_cipher_text%TYPE;
1409:
1410: -- variabled for CHNAME and EXPDATE encryption
1411: l_chname_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
1412: l_chname_mask_setting iby_creditcard.chname_mask_setting%TYPE;

Line 1411: l_chname_sec_segment_id iby_security_segments.sec_segment_id%TYPE;

1407: l_segment_id iby_security_segments.sec_segment_id%TYPE;
1408: l_cc_ciphertext iby_security_segments.segment_cipher_text%TYPE;
1409:
1410: -- variabled for CHNAME and EXPDATE encryption
1411: l_chname_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
1412: l_chname_mask_setting iby_creditcard.chname_mask_setting%TYPE;
1413: l_chname_unmask_len iby_creditcard.chname_unmask_length%TYPE;
1414: l_expdate_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
1415: l_masked_chname VARCHAR2(100) := NULL;

Line 1414: l_expdate_sec_segment_id iby_security_segments.sec_segment_id%TYPE;

1410: -- variabled for CHNAME and EXPDATE encryption
1411: l_chname_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
1412: l_chname_mask_setting iby_creditcard.chname_mask_setting%TYPE;
1413: l_chname_unmask_len iby_creditcard.chname_unmask_length%TYPE;
1414: l_expdate_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
1415: l_masked_chname VARCHAR2(100) := NULL;
1416: l_exp_date DATE;
1417:
1418: l_expired_flag VARCHAR2(1);

Line 1431: iby_cc_issuer_ranges r, iby_security_segments seg,

1427: SELECT c.instrid, c.ccnumber, c.cc_issuer_range_id,
1428: k.subkey_cipher_text, r.card_number_prefix, i.digit_check_flag,
1429: c.card_mask_setting, c.card_unmask_length, c.chname, c.expirydate
1430: FROM iby_creditcard c, iby_creditcard_issuers_b i,
1431: iby_cc_issuer_ranges r, iby_security_segments seg,
1432: iby_sys_security_subkeys k
1433: WHERE (NVL(c.encrypted,'N') = 'N')
1434: AND (c.card_issuer_code = i.card_issuer_code(+))
1435: AND (c.cc_issuer_range_id = r.cc_issuer_range_id(+))

Line 1553: l_cc_ciphertext iby_security_segments.segment_cipher_text%TYPE;

1549: lx_compress_cc iby_creditcard.ccnumber%TYPE;
1550: lx_mask_digits iby_creditcard.ccnumber%TYPE;
1551: lx_mask_option iby_creditcard.card_mask_setting%TYPE;
1552: lx_unmask_len iby_creditcard.card_unmask_length%TYPE;
1553: l_cc_ciphertext iby_security_segments.segment_cipher_text%TYPE;
1554: lx_segment_id iby_security_segments.sec_segment_id%TYPE;
1555:
1556: l_chname iby_creditcard.chname%TYPE;
1557: l_masked_chname iby_creditcard.chname%TYPE;

Line 1554: lx_segment_id iby_security_segments.sec_segment_id%TYPE;

1550: lx_mask_digits iby_creditcard.ccnumber%TYPE;
1551: lx_mask_option iby_creditcard.card_mask_setting%TYPE;
1552: lx_unmask_len iby_creditcard.card_unmask_length%TYPE;
1553: l_cc_ciphertext iby_security_segments.segment_cipher_text%TYPE;
1554: lx_segment_id iby_security_segments.sec_segment_id%TYPE;
1555:
1556: l_chname iby_creditcard.chname%TYPE;
1557: l_masked_chname iby_creditcard.chname%TYPE;
1558: l_chname_seg_id iby_creditcard.chname_sec_segment_id%TYPE;

Line 1576: iby_security_segments seg

1572: LENGTH(c.ccnumber) len, c.chname, c.chname_sec_segment_id,
1573: c.chname_mask_setting, c.chname_unmask_length
1574: FROM iby_creditcard c, iby_creditcard_issuers_b i,
1575: iby_cc_issuer_ranges r, iby_sys_security_subkeys k,
1576: iby_security_segments seg
1577: WHERE (c.card_issuer_code = i.card_issuer_code(+))
1578: AND (c.cc_issuer_range_id = r.cc_issuer_range_id(+))
1579: AND (c.cc_num_sec_segment_id = seg.sec_segment_id(+))
1580: AND (seg.sec_subkey_id = k.sec_subkey_id(+))

Line 1633: DELETE iby_security_segments WHERE (sec_segment_id = lx_segment_id);

1629: iby_security_pkg.G_ENCODING_NUMERIC,
1630: p_sys_key,c_card_rec.subkey_cipher_text);
1631: END IF;
1632: ELSE
1633: DELETE iby_security_segments WHERE (sec_segment_id = lx_segment_id);
1634: END IF;
1635:
1636: IF (c_card_rec.encrypted = 'A') THEN
1637: -- Re-encryption of the card holder name will result in encryption