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 340: l_cc_ciphertext iby_security_segments.segment_cipher_text%TYPE;

336:
337: lx_cc_number iby_creditcard.ccnumber%TYPE;
338: lx_cc_compressed iby_creditcard.ccnumber%TYPE;
339: lx_unmasked_digits iby_creditcard.ccnumber%TYPE;
340: l_cc_ciphertext iby_security_segments.segment_cipher_text%TYPE;
341: l_encrypted iby_creditcard.encrypted%TYPE;
342: lx_masked_number iby_creditcard.masked_cc_number%TYPE;
343: lx_mask_option iby_creditcard.card_mask_setting%TYPE;
344: lx_unmask_len iby_creditcard.card_unmask_length%TYPE;

Line 347: lx_sec_segment_id iby_security_segments.sec_segment_id%TYPE;

343: lx_mask_option iby_creditcard.card_mask_setting%TYPE;
344: lx_unmask_len iby_creditcard.card_unmask_length%TYPE;
345: l_cc_hash1 iby_creditcard.cc_number_hash1%TYPE;
346: l_cc_hash2 iby_creditcard.cc_number_hash2%TYPE;
347: lx_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
348:
349: l_expiry_date iby_creditcard.expirydate%TYPE;
350: l_billing_site hz_party_site_uses.party_site_use_id%TYPE;
351:

Line 353: l_chname_sec_segment_id iby_security_segments.sec_segment_id%TYPE;

349: l_expiry_date iby_creditcard.expirydate%TYPE;
350: l_billing_site hz_party_site_uses.party_site_use_id%TYPE;
351:
352: -- variabled for CHNAME and EXPDATE encryption
353: l_chname_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
354: l_expdate_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
355: l_masked_chname VARCHAR2(100) := NULL;
356: -- l_masked_expdate VARCHAR2(20) := NULL;
357: -- l_encrypted_date_format VARCHAR2(20) := NULL;

Line 354: l_expdate_sec_segment_id iby_security_segments.sec_segment_id%TYPE;

350: l_billing_site hz_party_site_uses.party_site_use_id%TYPE;
351:
352: -- variabled for CHNAME and EXPDATE encryption
353: l_chname_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
354: l_expdate_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
355: l_masked_chname VARCHAR2(100) := NULL;
356: -- l_masked_expdate VARCHAR2(20) := NULL;
357: -- l_encrypted_date_format VARCHAR2(20) := NULL;
358: -- l_chname_length NUMBER;

Line 673: l_chname_sec_segment_id iby_security_segments.sec_segment_id%TYPE;

669: l_billing_site NUMBER;
670: l_expiry_date iby_creditcard.expirydate%TYPE;
671:
672: -- variabled for CHNAME and EXPDATE encryption
673: l_chname_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
674: l_expdate_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
675: l_masked_chname VARCHAR2(100) := NULL;
676:
677: l_msg_count NUMBER;

Line 674: l_expdate_sec_segment_id iby_security_segments.sec_segment_id%TYPE;

670: l_expiry_date iby_creditcard.expirydate%TYPE;
671:
672: -- variabled for CHNAME and EXPDATE encryption
673: l_chname_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
674: l_expdate_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
675: l_masked_chname VARCHAR2(100) := NULL;
676:
677: l_msg_count NUMBER;
678: l_msg_data VARCHAR2(300);

Line 878: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;

874: )
875: RETURN iby_creditcard.ccnumber%TYPE
876: IS
877: l_cc_number iby_creditcard.ccnumber%TYPE;
878: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;
879: l_card_len iby_creditcard.cc_number_length%TYPE;
880: l_encrypted iby_creditcard.encrypted%TYPE;
881: l_cc_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;
882: l_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;

Line 898: FROM iby_creditcard c, iby_security_segments seg,

894: NVL(c.encrypted,'N'), k.subkey_cipher_text, r.card_number_prefix,
895: NVL(i.digit_check_flag,'N'), c.card_mask_setting, c.card_unmask_length,
896: DECODE(encrypted, 'Y',c.ccnumber, NULL),
897: NVL(r.card_number_length,c.cc_number_length)
898: FROM iby_creditcard c, iby_security_segments seg,
899: iby_sys_security_subkeys k, iby_cc_issuer_ranges r,
900: iby_creditcard_issuers_b i
901: WHERE (instrid = ci_instrid)
902: AND (c.cc_num_sec_segment_id = seg.sec_segment_id(+))

Line 936: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,

932: END uncipher_ccnumber;
933:
934: FUNCTION uncipher_ccnumber
935: (p_cc_number IN iby_creditcard.ccnumber%TYPE,
936: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,
937: p_encrypted IN iby_creditcard.encrypted%TYPE,
938: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
939: p_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
940: p_card_len IN iby_cc_issuer_ranges.card_number_length%TYPE,

Line 950: l_segment_raw iby_security_segments.segment_cipher_text%TYPE;

946: )
947: RETURN iby_creditcard.ccnumber%TYPE
948: IS
949: l_sub_key iby_security_pkg.DES3_KEY_TYPE;
950: l_segment_raw iby_security_segments.segment_cipher_text%TYPE;
951: l_cc_number iby_creditcard.ccnumber%TYPE;
952: l_compress_len NUMBER;
953: BEGIN
954: l_cc_number := '';

Line 1020: iby_security_segments seg

1016: c.chname, c.chname_sec_segment_id,
1017: c.expirydate, c.expiry_sec_segment_id
1018: FROM iby_creditcard c, iby_creditcard_issuers_b i,
1019: iby_cc_issuer_ranges r, iby_sys_security_subkeys k,
1020: iby_security_segments seg
1021: WHERE (NVL(c.encrypted,'N') = 'Y')
1022: AND (c.card_issuer_code = i.card_issuer_code(+))
1023: AND (c.cc_issuer_range_id = r.cc_issuer_range_id(+))
1024: AND (c.cc_num_sec_segment_id = seg.sec_segment_id(+))

Line 1075: DELETE iby_security_segments

1071: last_updated_by = fnd_global.user_id,
1072: last_update_login = fnd_global.login_id
1073: WHERE (instrid = c_card_rec.instrid);
1074:
1075: DELETE iby_security_segments
1076: WHERE (sec_segment_id IN (c_card_rec.cc_num_sec_segment_id,
1077: c_card_rec.chname_sec_segment_id,
1078: c_card_rec.expiry_sec_segment_id)
1079: );

Line 1097: l_segment_id iby_security_segments.sec_segment_id%TYPE;

1093: lx_compress_cc iby_creditcard.ccnumber%TYPE;
1094: lx_mask_digits iby_creditcard.masked_cc_number%TYPE;
1095:
1096: l_subkey iby_security_pkg.DES3_KEY_TYPE;
1097: l_segment_id iby_security_segments.sec_segment_id%TYPE;
1098: l_cc_ciphertext iby_security_segments.segment_cipher_text%TYPE;
1099:
1100: -- variabled for CHNAME and EXPDATE encryption
1101: l_chname_sec_segment_id iby_security_segments.sec_segment_id%TYPE;

Line 1098: l_cc_ciphertext iby_security_segments.segment_cipher_text%TYPE;

1094: lx_mask_digits iby_creditcard.masked_cc_number%TYPE;
1095:
1096: l_subkey iby_security_pkg.DES3_KEY_TYPE;
1097: l_segment_id iby_security_segments.sec_segment_id%TYPE;
1098: l_cc_ciphertext iby_security_segments.segment_cipher_text%TYPE;
1099:
1100: -- variabled for CHNAME and EXPDATE encryption
1101: l_chname_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
1102: l_expdate_sec_segment_id iby_security_segments.sec_segment_id%TYPE;

Line 1101: l_chname_sec_segment_id iby_security_segments.sec_segment_id%TYPE;

1097: l_segment_id iby_security_segments.sec_segment_id%TYPE;
1098: l_cc_ciphertext iby_security_segments.segment_cipher_text%TYPE;
1099:
1100: -- variabled for CHNAME and EXPDATE encryption
1101: l_chname_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
1102: l_expdate_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
1103: l_masked_chname VARCHAR2(100) := NULL;
1104: l_exp_date DATE;
1105:

Line 1102: l_expdate_sec_segment_id iby_security_segments.sec_segment_id%TYPE;

1098: l_cc_ciphertext iby_security_segments.segment_cipher_text%TYPE;
1099:
1100: -- variabled for CHNAME and EXPDATE encryption
1101: l_chname_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
1102: l_expdate_sec_segment_id iby_security_segments.sec_segment_id%TYPE;
1103: l_masked_chname VARCHAR2(100) := NULL;
1104: l_exp_date DATE;
1105:
1106:

Line 1113: iby_cc_issuer_ranges r, iby_security_segments seg,

1109: SELECT c.instrid, c.ccnumber, c.cc_issuer_range_id,
1110: k.subkey_cipher_text, r.card_number_prefix, i.digit_check_flag,
1111: c.card_mask_setting, c.card_unmask_length, c.chname, c.expirydate
1112: FROM iby_creditcard c, iby_creditcard_issuers_b i,
1113: iby_cc_issuer_ranges r, iby_security_segments seg,
1114: iby_sys_security_subkeys k
1115: WHERE (NVL(c.encrypted,'N') = 'N')
1116: AND (c.card_issuer_code = i.card_issuer_code(+))
1117: AND (c.cc_issuer_range_id = r.cc_issuer_range_id(+))

Line 1209: l_cc_ciphertext iby_security_segments.segment_cipher_text%TYPE;

1205: lx_compress_cc iby_creditcard.ccnumber%TYPE;
1206: lx_mask_digits iby_creditcard.ccnumber%TYPE;
1207: lx_mask_option iby_creditcard.card_mask_setting%TYPE;
1208: lx_unmask_len iby_creditcard.card_unmask_length%TYPE;
1209: l_cc_ciphertext iby_security_segments.segment_cipher_text%TYPE;
1210: lx_segment_id iby_security_segments.sec_segment_id%TYPE;
1211:
1212: CURSOR c_card
1213: (ci_mask_option iby_creditcard.card_mask_setting%TYPE,

Line 1210: lx_segment_id iby_security_segments.sec_segment_id%TYPE;

1206: lx_mask_digits iby_creditcard.ccnumber%TYPE;
1207: lx_mask_option iby_creditcard.card_mask_setting%TYPE;
1208: lx_unmask_len iby_creditcard.card_unmask_length%TYPE;
1209: l_cc_ciphertext iby_security_segments.segment_cipher_text%TYPE;
1210: lx_segment_id iby_security_segments.sec_segment_id%TYPE;
1211:
1212: CURSOR c_card
1213: (ci_mask_option iby_creditcard.card_mask_setting%TYPE,
1214: ci_unmask_len iby_creditcard.card_unmask_length%TYPE

Line 1225: iby_security_segments seg

1221: c.card_unmask_length, c.ccnumber unmask_digits, seg.sec_segment_id,
1222: LENGTH(c.ccnumber) len
1223: FROM iby_creditcard c, iby_creditcard_issuers_b i,
1224: iby_cc_issuer_ranges r, iby_sys_security_subkeys k,
1225: iby_security_segments seg
1226: WHERE (c.card_issuer_code = i.card_issuer_code(+))
1227: AND (c.cc_issuer_range_id = r.cc_issuer_range_id(+))
1228: AND (c.cc_num_sec_segment_id = seg.sec_segment_id(+))
1229: AND (seg.sec_subkey_id = k.sec_subkey_id(+))

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

1276: iby_security_pkg.G_ENCODING_NUMERIC,
1277: p_sys_key,c_card_rec.subkey_cipher_text);
1278: END IF;
1279: ELSE
1280: DELETE iby_security_segments WHERE (sec_segment_id = lx_segment_id);
1281: END IF;
1282: END IF;
1283:
1284: UPDATE iby_creditcard