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_PKG

Line 152: iby_security_pkg.validate_sys_key(p_sec_key,l_keyvalid);

148: l_encrypted_count NUMBER := 0;
149: l_keyvalid VARCHAR2(100) := NULL;
150: BEGIN
151:
152: iby_security_pkg.validate_sys_key(p_sec_key,l_keyvalid);
153:
154: IF (NOT l_keyvalid IS NULL) THEN
155: SELECT count(instrid)
156: INTO l_encrypted_count

Line 168: (p_sec_key IN iby_security_pkg.DES3_KEY_TYPE,

164:
165: END check_key;
166:
167: PROCEDURE encrypt_chname
168: (p_sec_key IN iby_security_pkg.DES3_KEY_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,

Line 179: IBY_SECURITY_PKG.encrypt_chname(p_sec_key,

175: )
176: IS
177: l_dbg_mod VARCHAR2(100) := 'iby.plsql.IBY_CREDITCARD_PKG' || '.' || 'encrypt_chname';
178: BEGIN
179: IBY_SECURITY_PKG.encrypt_chname(p_sec_key,
180: p_chname,
181: p_segment_id,
182: x_segment_id,
183: x_masked_chname,

Line 189: (p_sec_key IN iby_security_pkg.DES3_KEY_TYPE,

185: x_unmask_len);
186: END encrypt_chname;
187:
188: FUNCTION decrypt_chname
189: (p_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
190: p_instrid IN iby_creditcard.instrid%TYPE
191: ) RETURN iby_creditcard.chname%TYPE
192: IS
193: BEGIN

Line 194: RETURN IBY_SECURITY_PKG.decrypt_chname(p_sec_key, p_instrid);

190: p_instrid IN iby_creditcard.instrid%TYPE
191: ) RETURN iby_creditcard.chname%TYPE
192: IS
193: BEGIN
194: RETURN IBY_SECURITY_PKG.decrypt_chname(p_sec_key, p_instrid);
195: END decrypt_chname;
196:
197: -- USE: Saves card information to the credit card history table
198: --

Line 275: x_mask_setting := iby_security_pkg.G_MASK_PREFIX;

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:
277: IF (c_mask_setting%ISOPEN) THEN CLOSE c_mask_setting; END IF;
278:
279: OPEN c_mask_setting;

Line 284: x_mask_setting := iby_security_pkg.G_MASK_PREFIX;

280: FETCH c_mask_setting INTO x_mask_setting, x_unmask_len;
281: CLOSE c_mask_setting;
282:
283: IF (x_mask_setting IS NULL) THEN
284: x_mask_setting := iby_security_pkg.G_MASK_PREFIX;
285: END IF;
286: IF (x_unmask_len IS NULL) THEN
287: x_unmask_len := G_DEF_UNMASK_LENGTH;
288: END IF;

Line 299: RETURN iby_security_pkg.Mask_Data

295: )
296: RETURN iby_creditcard.masked_cc_number%TYPE
297: IS
298: BEGIN
299: RETURN iby_security_pkg.Mask_Data
300: (p_cc_number,p_mask_option,p_unmask_len,G_MASK_CHARACTER);
301: END Mask_Card_Number;
302:
303: --

Line 352: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,

348: p_purpose IN iby_creditcard.card_purpose%TYPE,
349: p_desc IN iby_creditcard.description%TYPE,
350: p_active_flag IN iby_creditcard.active_flag%TYPE,
351: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
352: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
353: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
354: p_attribute1 IN iby_creditcard.attribute1%TYPE,
355: p_attribute2 IN iby_creditcard.attribute2%TYPE,
356: p_attribute3 IN iby_creditcard.attribute3%TYPE,

Line 560: l_cc_hash1 := iby_security_pkg.get_hash(lx_cc_number,'F');

556: l_card_len := LENGTH(lx_cc_number);
557: END IF;
558:
559: Mask_Card_Number(lx_cc_number,lx_masked_number,lx_mask_option,lx_unmask_len);
560: l_cc_hash1 := iby_security_pkg.get_hash(lx_cc_number,'F');
561: -- get hash value for a salted version of the card number
562: l_cc_hash2 := iby_security_pkg.get_hash(lx_cc_number,'T');
563:
564: -- [lmallick]

Line 562: l_cc_hash2 := iby_security_pkg.get_hash(lx_cc_number,'T');

558:
559: Mask_Card_Number(lx_cc_number,lx_masked_number,lx_mask_option,lx_unmask_len);
560: l_cc_hash1 := iby_security_pkg.get_hash(lx_cc_number,'F');
561: -- get hash value for a salted version of the card number
562: l_cc_hash2 := iby_security_pkg.get_hash(lx_cc_number,'T');
563:
564: -- [lmallick]
565: -- do not perform the TCA entity validation here. Instead, trust
566: -- the data passed here

Line 611: iby_security_pkg.validate_sys_key(p_sys_sec_key,l_keyvalid);

607: IF (NOT x_instr_id IS NULL) THEN RETURN; END IF;
608:
609: IF (NOT p_sys_sec_key IS NULL) THEN
610: -- check the system key
611: iby_security_pkg.validate_sys_key(p_sys_sec_key,l_keyvalid);
612:
613: IF (NOT l_keyvalid IS NULL) THEN
614: x_result_code := 'INVALID_SEC_KEY';
615: RETURN;

Line 625: HEXTORAW(IBY_SECURITY_PKG.Encode_Number(lx_cc_compressed,TRUE));

621: lx_unmask_len,lx_cc_compressed,lx_unmasked_digits);
622:
623: IF (NOT lx_cc_compressed IS NULL) THEN
624: l_cc_ciphertext :=
625: HEXTORAW(IBY_SECURITY_PKG.Encode_Number(lx_cc_compressed,TRUE));
626: IBY_SECURITY_PKG.Create_Segment
627: (FND_API.G_FALSE,l_cc_ciphertext,iby_security_pkg.G_ENCODING_NUMERIC,
628: p_sys_sec_key,lx_sec_segment_id);
629: END IF;

Line 626: IBY_SECURITY_PKG.Create_Segment

622:
623: IF (NOT lx_cc_compressed IS NULL) THEN
624: l_cc_ciphertext :=
625: HEXTORAW(IBY_SECURITY_PKG.Encode_Number(lx_cc_compressed,TRUE));
626: IBY_SECURITY_PKG.Create_Segment
627: (FND_API.G_FALSE,l_cc_ciphertext,iby_security_pkg.G_ENCODING_NUMERIC,
628: p_sys_sec_key,lx_sec_segment_id);
629: END IF;
630: lx_cc_number := NVL(lx_unmasked_digits,'0');

Line 627: (FND_API.G_FALSE,l_cc_ciphertext,iby_security_pkg.G_ENCODING_NUMERIC,

623: IF (NOT lx_cc_compressed IS NULL) THEN
624: l_cc_ciphertext :=
625: HEXTORAW(IBY_SECURITY_PKG.Encode_Number(lx_cc_compressed,TRUE));
626: IBY_SECURITY_PKG.Create_Segment
627: (FND_API.G_FALSE,l_cc_ciphertext,iby_security_pkg.G_ENCODING_NUMERIC,
628: p_sys_sec_key,lx_sec_segment_id);
629: END IF;
630: lx_cc_number := NVL(lx_unmasked_digits,'0');
631:

Line 642: -- IBY_SECURITY_PKG.encrypt_field_vals(p_holder_name,

638: --now need to encrypt the supplemental cardholder data
639: --i.e, CHNAME and EXPDATE for now.
640: IF(Other_CC_Attribs_Encrypted = 'Y') THEN
641: -- l_chname_sec_segment_id :=
642: -- IBY_SECURITY_PKG.encrypt_field_vals(p_holder_name,
643: -- p_sys_sec_key,
644: -- null,
645: -- 'N'
646: -- );

Line 649: IBY_SECURITY_PKG.encrypt_date_field(l_expiry_date,

645: -- 'N'
646: -- );
647: l_encrypted := 'A';
648: l_expdate_sec_segment_id :=
649: IBY_SECURITY_PKG.encrypt_date_field(l_expiry_date,
650: p_sys_sec_key,
651: null,
652: 'N'
653: );

Line 731: iby_security_pkg.get_salt_version

727: p_attribute16,p_attribute17, p_attribute18,p_attribute19,p_attribute20,
728: p_attribute21,p_attribute22, p_attribute23,p_attribute24,p_attribute25,
729: p_attribute26,p_attribute27, p_attribute28,p_attribute29,p_attribute30,
730: l_invalid_flag, l_invalidation_reason,
731: iby_security_pkg.get_salt_version
732: );
733:
734: -- Reached upto this point implies that the registration has succeeded
735: -- clear the error codes that might have got assigned to the x_result_code parameter

Line 931: IF (Get_CC_Encrypt_Mode <> IBY_SECURITY_PKG.G_ENCRYPT_MODE_NONE

927:
928: -- Need to encrypt the sensitive data only if the record was
929: -- previously encrypted and of course the encryption mode
930: -- shouldn't be NONE
931: IF (Get_CC_Encrypt_Mode <> IBY_SECURITY_PKG.G_ENCRYPT_MODE_NONE
932: AND l_encrypted = 'A'
933: --AND Other_CC_Attribs_Encrypted = 'Y'
934: ) THEN
935:

Line 1191: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE

1187: END check_card_validity;
1188:
1189: FUNCTION uncipher_ccnumber
1190: (p_instrid IN iby_creditcard.instrid%TYPE,
1191: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE
1192: )
1193: RETURN iby_creditcard.ccnumber%TYPE
1194: IS
1195: l_cc_number iby_creditcard.ccnumber%TYPE;

Line 1247: iby_security_pkg.validate_sys_key(p_sys_sec_key,l_keyvalid);

1243: RETURN l_masked_cc_number;
1244: END IF ;
1245:
1246: IF (l_encrypted = 'Y' OR l_encrypted = 'A') THEN
1247: iby_security_pkg.validate_sys_key(p_sys_sec_key,l_keyvalid);
1248: IF (NOT l_keyvalid IS NULL) THEN
1249: raise_application_error(-20000,'IBY_10008#INSTRID='||p_instrid, FALSE);
1250: END IF;
1251: END IF;

Line 1263: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,

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,
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,

Line 1275: RETURN iby_security_pkg.uncipher_ccnumber

1271: )
1272: RETURN iby_creditcard.ccnumber%TYPE
1273: IS
1274: BEGIN
1275: RETURN iby_security_pkg.uncipher_ccnumber
1276: (p_cc_number,
1277: p_segment_cipher,
1278: p_encrypted,
1279: p_sys_key,

Line 1291: i_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE)

1287: END uncipher_ccnumber;
1288:
1289: FUNCTION uncipher_ccnumber_ui_wrp
1290: (i_instrid IN iby_creditcard.instrid%TYPE,
1291: i_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE)
1292: RETURN iby_creditcard.ccnumber%TYPE
1293: IS
1294: BEGIN
1295: RETURN uncipher_ccnumber(i_instrid, i_sys_sec_key);

Line 1303: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE

1299: END uncipher_ccnumber_ui_wrp;
1300:
1301: PROCEDURE Decrypt_Instruments
1302: (p_commit IN VARCHAR2,
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;

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

1331: BEGIN
1332:
1333: --checking the encryption mode
1334: l_mode := Get_CC_Encrypt_Mode();
1335: IF (NOT (l_mode = iby_security_pkg.G_ENCRYPT_MODE_NONE)) THEN
1336: RETURN;
1337: END IF;
1338:
1339: FOR c_card_rec IN c_card LOOP

Line 1351: l_exp_date := IBY_SECURITY_PKG.decrypt_date_field

1347: c_card_rec.card_unmask_length, c_card_rec.unmask_digits
1348: );
1349:
1350: IF (c_card_rec.expiry_sec_segment_id IS NOT NULL) THEN
1351: l_exp_date := IBY_SECURITY_PKG.decrypt_date_field
1352: (c_card_rec.expiry_sec_segment_id,
1353: p_sys_key
1354: );
1355: ELSE

Line 1399: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE

1395: END Decrypt_Instruments;
1396:
1397: PROCEDURE Encrypt_Instruments
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;

Line 1406: l_subkey iby_security_pkg.DES3_KEY_TYPE;

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;
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

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

1438: BEGIN
1439:
1440: l_mode := Get_CC_Encrypt_Mode();
1441: l_enc_supl_data := Other_CC_Attribs_Encrypted;
1442: IF (l_mode = iby_security_pkg.G_ENCRYPT_MODE_NONE) THEN
1443: RETURN;
1444: END IF;
1445:
1446: check_key(p_sys_key);

Line 1462: HEXTORAW(IBY_SECURITY_PKG.Encode_Number(lx_compress_cc,TRUE));

1458: lx_compress_cc, lx_mask_digits);
1459:
1460: IF (NVL(LENGTH(lx_compress_cc),0) > 0) THEN
1461: l_cc_ciphertext :=
1462: HEXTORAW(IBY_SECURITY_PKG.Encode_Number(lx_compress_cc,TRUE));
1463:
1464: IBY_SECURITY_PKG.Create_Segment
1465: (FND_API.G_FALSE,l_cc_ciphertext,iby_security_pkg.G_ENCODING_NUMERIC,
1466: p_sys_key,l_segment_id);

Line 1464: IBY_SECURITY_PKG.Create_Segment

1460: IF (NVL(LENGTH(lx_compress_cc),0) > 0) THEN
1461: l_cc_ciphertext :=
1462: HEXTORAW(IBY_SECURITY_PKG.Encode_Number(lx_compress_cc,TRUE));
1463:
1464: IBY_SECURITY_PKG.Create_Segment
1465: (FND_API.G_FALSE,l_cc_ciphertext,iby_security_pkg.G_ENCODING_NUMERIC,
1466: p_sys_key,l_segment_id);
1467: ELSE
1468: l_segment_id := -1;

Line 1465: (FND_API.G_FALSE,l_cc_ciphertext,iby_security_pkg.G_ENCODING_NUMERIC,

1461: l_cc_ciphertext :=
1462: HEXTORAW(IBY_SECURITY_PKG.Encode_Number(lx_compress_cc,TRUE));
1463:
1464: IBY_SECURITY_PKG.Create_Segment
1465: (FND_API.G_FALSE,l_cc_ciphertext,iby_security_pkg.G_ENCODING_NUMERIC,
1466: p_sys_key,l_segment_id);
1467: ELSE
1468: l_segment_id := -1;
1469: END IF;

Line 1477: -- IBY_SECURITY_PKG.encrypt_field_vals(c_card_rec.chname,

1473: --i.e, CHNAME and EXPDATE for now.
1474: IF(l_enc_supl_data = 'Y') THEN
1475: l_encrypted := 'A';
1476: --l_chname_sec_segment_id :=
1477: -- IBY_SECURITY_PKG.encrypt_field_vals(c_card_rec.chname,
1478: -- p_sys_key,
1479: -- null,
1480: -- 'N'
1481: -- );

Line 1483: IBY_SECURITY_PKG.encrypt_date_field(c_card_rec.expirydate,

1479: -- null,
1480: -- 'N'
1481: -- );
1482: l_expdate_sec_segment_id :=
1483: IBY_SECURITY_PKG.encrypt_date_field(c_card_rec.expirydate,
1484: p_sys_key,
1485: null,
1486: 'N'
1487: );

Line 1545: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE

1541: END Encrypt_Instruments;
1542:
1543: PROCEDURE Remask_Instruments
1544: (p_commit IN VARCHAR2 := FND_API.G_TRUE,
1545: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE
1546: )
1547: IS
1548: l_cc_number iby_creditcard.ccnumber%TYPE;
1549: lx_compress_cc iby_creditcard.ccnumber%TYPE;

Line 1620: HEXTORAW(IBY_SECURITY_PKG.Encode_Number(lx_compress_cc,TRUE));

1616: -- the mask or card issuer range
1617: --
1618: IF (NVL(LENGTH(lx_compress_cc),0) > 0) THEN
1619: l_cc_ciphertext :=
1620: HEXTORAW(IBY_SECURITY_PKG.Encode_Number(lx_compress_cc,TRUE));
1621: IF (lx_segment_id IS NULL) THEN
1622: IBY_SECURITY_PKG.Create_Segment
1623: (FND_API.G_FALSE,l_cc_ciphertext,
1624: iby_security_pkg.G_ENCODING_NUMERIC,

Line 1622: IBY_SECURITY_PKG.Create_Segment

1618: IF (NVL(LENGTH(lx_compress_cc),0) > 0) THEN
1619: l_cc_ciphertext :=
1620: HEXTORAW(IBY_SECURITY_PKG.Encode_Number(lx_compress_cc,TRUE));
1621: IF (lx_segment_id IS NULL) THEN
1622: IBY_SECURITY_PKG.Create_Segment
1623: (FND_API.G_FALSE,l_cc_ciphertext,
1624: iby_security_pkg.G_ENCODING_NUMERIC,
1625: p_sys_key,lx_segment_id);
1626: ELSE

Line 1624: iby_security_pkg.G_ENCODING_NUMERIC,

1620: HEXTORAW(IBY_SECURITY_PKG.Encode_Number(lx_compress_cc,TRUE));
1621: IF (lx_segment_id IS NULL) THEN
1622: IBY_SECURITY_PKG.Create_Segment
1623: (FND_API.G_FALSE,l_cc_ciphertext,
1624: iby_security_pkg.G_ENCODING_NUMERIC,
1625: p_sys_key,lx_segment_id);
1626: ELSE
1627: IBY_SECURITY_PKG.Update_Segment
1628: (FND_API.G_FALSE,lx_segment_id,l_cc_ciphertext,

Line 1627: IBY_SECURITY_PKG.Update_Segment

1623: (FND_API.G_FALSE,l_cc_ciphertext,
1624: iby_security_pkg.G_ENCODING_NUMERIC,
1625: p_sys_key,lx_segment_id);
1626: ELSE
1627: IBY_SECURITY_PKG.Update_Segment
1628: (FND_API.G_FALSE,lx_segment_id,l_cc_ciphertext,
1629: iby_security_pkg.G_ENCODING_NUMERIC,
1630: p_sys_key,c_card_rec.subkey_cipher_text);
1631: END IF;

Line 1629: iby_security_pkg.G_ENCODING_NUMERIC,

1625: p_sys_key,lx_segment_id);
1626: ELSE
1627: IBY_SECURITY_PKG.Update_Segment
1628: (FND_API.G_FALSE,lx_segment_id,l_cc_ciphertext,
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);

Line 1699: IBY_SECURITY_PKG.Compress_CC_Number(p_card_number,

1695: x_unmask_digits OUT NOCOPY iby_creditcard.masked_cc_number%TYPE
1696: )
1697: IS
1698: BEGIN
1699: IBY_SECURITY_PKG.Compress_CC_Number(p_card_number,
1700: p_prefix,
1701: p_digit_check,
1702: p_mask_setting,
1703: p_unmask_len,

Line 1720: RETURN IBY_SECURITY_PKG.Uncompress_CC_Number(p_card_number,

1716: )
1717: RETURN iby_creditcard.ccnumber%TYPE
1718: IS
1719: BEGIN
1720: RETURN IBY_SECURITY_PKG.Uncompress_CC_Number(p_card_number,
1721: p_card_length,
1722: p_prefix,
1723: p_digit_check,
1724: p_mask_setting,

Line 1739: RETURN IBY_SECURITY_PKG.Get_Compressed_Len(p_card_length,

1735: )
1736: RETURN NUMBER
1737: IS
1738: BEGIN
1739: RETURN IBY_SECURITY_PKG.Get_Compressed_Len(p_card_length,
1740: p_prefix,
1741: p_digit_check,
1742: p_mask_setting,
1743: p_unmask_len);

Line 1748: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,

1744: END Get_Compressed_Len;
1745:
1746: PROCEDURE Query_Card
1747: (p_card_id IN iby_creditcard.instrid%TYPE,
1748: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
1749: x_owner_id OUT NOCOPY iby_creditcard.card_owner_id%TYPE,
1750: x_holder_name OUT NOCOPY iby_creditcard.chname%TYPE,
1751: x_billing_address_id OUT NOCOPY iby_creditcard.addressid%TYPE,
1752: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,

Line 1815: iby_security_pkg.validate_sys_key(p_sys_sec_key,l_err_code);

1811: CLOSE c_creditcard;
1812: END IF;
1813:
1814: IF (NOT p_sys_sec_key IS NULL) THEN
1815: iby_security_pkg.validate_sys_key(p_sys_sec_key,l_err_code);
1816: IF (NOT l_err_code IS NULL) THEN
1817: raise_application_error(-20000, l_err_code, FALSE);
1818: END IF;
1819: END IF;

Line 1848: x_expiry_date := IBY_SECURITY_PKG.decrypt_date_field

1844: IF (nvl(l_encrypted, 'N') = 'A'
1845: AND Other_CC_Attribs_Encrypted = 'Y')
1846: THEN
1847: IF (l_expiry_sec_segment_id IS NOT NULL) THEN
1848: x_expiry_date := IBY_SECURITY_PKG.decrypt_date_field
1849: (l_expiry_sec_segment_id,
1850: p_sys_sec_key
1851: );
1852: END IF;

Line 1876: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,

1872: */
1873:
1874: PROCEDURE Query_Card
1875: (p_card_id IN iby_creditcard.instrid%TYPE,
1876: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
1877: x_owner_id OUT NOCOPY iby_creditcard.card_owner_id%TYPE,
1878: x_holder_name OUT NOCOPY iby_creditcard.chname%TYPE,
1879: x_billing_address_id OUT NOCOPY iby_creditcard.addressid%TYPE,
1880: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,

Line 1944: iby_security_pkg.validate_sys_key(p_sys_sec_key,l_err_code);

1940: CLOSE c_creditcard;
1941: END IF;
1942:
1943: IF (NOT p_sys_sec_key IS NULL) THEN
1944: iby_security_pkg.validate_sys_key(p_sys_sec_key,l_err_code);
1945: IF (NOT l_err_code IS NULL) THEN
1946: raise_application_error(-20000, l_err_code, FALSE);
1947: END IF;
1948: END IF;

Line 1977: x_expiry_date := IBY_SECURITY_PKG.decrypt_date_field

1973: IF (nvl(l_encrypted, 'N') = 'A'
1974: AND Other_CC_Attribs_Encrypted = 'Y')
1975: THEN
1976: IF (l_expiry_sec_segment_id IS NOT NULL) THEN
1977: x_expiry_date := IBY_SECURITY_PKG.decrypt_date_field
1978: (l_expiry_sec_segment_id,
1979: p_sys_sec_key
1980: );
1981: END IF;

Line 1993: p_sys_security_key IN iby_security_pkg.DES3_KEY_TYPE,

1989: END Query_Card;
1990:
1991: PROCEDURE Encrypt_Card_Info
1992: (p_commit IN VARCHAR2 := FND_API.G_TRUE,
1993: p_sys_security_key IN iby_security_pkg.DES3_KEY_TYPE,
1994: p_expiry_date IN DATE,
1995: p_expSegmentId IN NUMBER,
1996: p_chname IN VARCHAR2,
1997: p_chnameSegmentId IN NUMBER,

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

2010:
2011: BEGIN
2012: -- test_debug('Inside Encrypt_Card_Info.. ');
2013: l_mode := Get_CC_Encrypt_Mode;
2014: IF (l_mode = iby_security_pkg.G_ENCRYPT_MODE_NONE) THEN
2015: RETURN;
2016: END IF;
2017: iby_security_pkg.validate_sys_key(p_sys_security_key,x_err_code);
2018: -- test_debug('sysKey valid.. ');

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

2013: l_mode := Get_CC_Encrypt_Mode;
2014: IF (l_mode = iby_security_pkg.G_ENCRYPT_MODE_NONE) THEN
2015: RETURN;
2016: END IF;
2017: iby_security_pkg.validate_sys_key(p_sys_security_key,x_err_code);
2018: -- test_debug('sysKey valid.. ');
2019: IF (NOT x_err_code IS NULL) THEN
2020: RETURN;
2021: END IF;

Line 2024: x_exp_segment_id := IBY_SECURITY_PKG.encrypt_date_field(p_expiry_date,

2020: RETURN;
2021: END IF;
2022:
2023: IF (NOT p_expiry_date IS NULL) THEN
2024: x_exp_segment_id := IBY_SECURITY_PKG.encrypt_date_field(p_expiry_date,
2025: p_sys_security_key,
2026: p_expSegmentId,
2027: 'N'
2028: );

Line 2067: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE

2063: END Encrypt_Card_Info;
2064:
2065: PROCEDURE Mark_Expired_Cards
2066: (p_commit IN VARCHAR2 := FND_API.G_TRUE,
2067: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE
2068: )
2069: IS
2070: l_expiry_date DATE;
2071: l_expired_flag VARCHAR2(1);

Line 2102: l_expiry_date := IBY_SECURITY_PKG.decrypt_date_field

2098: check_key(p_sys_sec_key);
2099: syskey_checked := 'Y';
2100: END IF;
2101:
2102: l_expiry_date := IBY_SECURITY_PKG.decrypt_date_field
2103: (c_card_rec.expiry_sec_segment_id,
2104: p_sys_sec_key
2105: );
2106: ELSE

Line 2143: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE

2139: END Mark_Expired_Cards;
2140:
2141: PROCEDURE Upgrade_Encrypted_Instruments
2142: (p_commit IN VARCHAR2 := FND_API.G_TRUE,
2143: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE
2144: )
2145: IS
2146: l_api_name CONSTANT VARCHAR2(30) := 'Upgrade_Encrypted_Instruments';
2147: l_dbg_mod VARCHAR2(100) := 'IBY_CREDITCARD_PKG' || '.' ||

Line 2184: l_exp_segment_id := IBY_SECURITY_PKG.encrypt_date_field(c_card_rec.expirydate,

2180: check_key(p_sys_sec_key);
2181: no_cc := 0;
2182: FOR c_card_rec IN c_card LOOP
2183: IF(c_card_rec.expirydate IS NOT NULL) THEN
2184: l_exp_segment_id := IBY_SECURITY_PKG.encrypt_date_field(c_card_rec.expirydate,
2185: p_sys_sec_key,
2186: null,
2187: 'N'
2188: );

Line 2242: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,

2238:
2239: PROCEDURE Check_CC_Expiry
2240: (p_instrid IN IBY_CREDITCARD.instrid%TYPE,
2241: p_input_date IN DATE,
2242: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
2243: x_expired OUT NOCOPY VARCHAR2
2244: )
2245: IS
2246: l_exp_sec_segment_id NUMBER;

Line 2260: l_expiry_date := IBY_SECURITY_PKG.decrypt_date_field

2256: END IF;
2257:
2258: IF (l_exp_sec_segment_id IS NOT NULL) THEN
2259: check_key(p_sys_sec_key);
2260: l_expiry_date := IBY_SECURITY_PKG.decrypt_date_field
2261: (l_exp_sec_segment_id,
2262: p_sys_sec_key
2263: );
2264: END IF;

Line 2334: l_cc_hash1 := iby_security_pkg.get_hash

2330: IBY_CC_VALIDATE.c_FillerChars, lx_return_status,
2331: lx_msg_count, lx_msg_data, lx_cc_number
2332: );
2333: -- Get hash values of the credit number
2334: l_cc_hash1 := iby_security_pkg.get_hash
2335: (lx_cc_number,FND_API.G_FALSE);
2336: l_cc_hash2 := iby_security_pkg.get_hash
2337: (lx_cc_number,FND_API.G_TRUE);
2338:

Line 2336: l_cc_hash2 := iby_security_pkg.get_hash

2332: );
2333: -- Get hash values of the credit number
2334: l_cc_hash1 := iby_security_pkg.get_hash
2335: (lx_cc_number,FND_API.G_FALSE);
2336: l_cc_hash2 := iby_security_pkg.get_hash
2337: (lx_cc_number,FND_API.G_TRUE);
2338:
2339: UPDATE iby_irf_risky_instr
2340: SET creditcard_no = NULL,

Line 2353: l_acct_no_hash1 := iby_security_pkg.get_hash

2349: no_cc := no_cc + 1;
2350:
2351: ELSIF (risky_instr_rec.account_no IS NOT NULL) THEN
2352: -- Get the hash values of the account number
2353: l_acct_no_hash1 := iby_security_pkg.get_hash
2354: (risky_instr_rec.account_no,FND_API.G_FALSE);
2355: l_acct_no_hash2 := iby_security_pkg.get_hash
2356: (risky_instr_rec.account_no,FND_API.G_TRUE);
2357:

Line 2355: l_acct_no_hash2 := iby_security_pkg.get_hash

2351: ELSIF (risky_instr_rec.account_no IS NOT NULL) THEN
2352: -- Get the hash values of the account number
2353: l_acct_no_hash1 := iby_security_pkg.get_hash
2354: (risky_instr_rec.account_no,FND_API.G_FALSE);
2355: l_acct_no_hash2 := iby_security_pkg.get_hash
2356: (risky_instr_rec.account_no,FND_API.G_TRUE);
2357:
2358: UPDATE iby_irf_risky_instr
2359: SET account_no = NULL,