[Home] [Help]
1713: p_purpose IN iby_creditcard.card_purpose%TYPE,
1714: p_desc IN iby_creditcard.description%TYPE,
1715: p_active_flag IN iby_creditcard.active_flag%TYPE,
1716: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
1717: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
1718: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
1719: p_attribute1 IN iby_creditcard.attribute1%TYPE,
1720: p_attribute2 IN iby_creditcard.attribute2%TYPE,
1721: p_attribute3 IN iby_creditcard.attribute3%TYPE,
1914: OPEN c_sec_mode;
1915: FETCH c_sec_mode INTO l_sec_mode;
1916: CLOSE c_sec_mode;
1917:
1918: IF (l_sec_mode = iby_security_pkg.G_ENCRYPT_MODE_INSTANT) THEN
1919:
1920: iby_debug_pub.add('online registration',
1921: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1922:
2595: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2596: RETURN;
2597: END IF;
2598:
2599: l_cc_hash1 := iby_security_pkg.get_hash(lx_cc_number,'F');
2600: l_cc_hash2 := iby_security_pkg.get_hash(lx_cc_number,'T');
2601:
2602: OPEN c_card(l_cc_hash1,l_cc_hash2,p_owner_id);
2603: FETCH c_card INTO l_card_id;
2596: RETURN;
2597: END IF;
2598:
2599: l_cc_hash1 := iby_security_pkg.get_hash(lx_cc_number,'F');
2600: l_cc_hash2 := iby_security_pkg.get_hash(lx_cc_number,'T');
2601:
2602: OPEN c_card(l_cc_hash1,l_cc_hash2,p_owner_id);
2603: FETCH c_card INTO l_card_id;
2604: CLOSE c_card;
2803: iby_cc_validate.StripCC
2804: (1.0, FND_API.G_FALSE, p_number,
2805: lx_return_status, lx_msg_count, lx_msg_data, lx_cc_number
2806: );
2807: RETURN iby_security_pkg.get_hash(lx_cc_number,p_salt);
2808: END Get_Hash;
2809:
2810: FUNCTION Get_Hash(p_number IN VARCHAR2, p_salt IN VARCHAR2, p_site_salt IN VARCHAR2)
2811: RETURN VARCHAR2
2818: iby_cc_validate.StripCC
2819: (1.0, FND_API.G_FALSE, p_number,
2820: lx_return_status, lx_msg_count, lx_msg_data, lx_cc_number
2821: );
2822: RETURN iby_security_pkg.get_hash(lx_cc_number,p_salt,p_site_salt);
2823: END Get_Hash;
2824:
2825: PROCEDURE Get_Trxn_Payer_Attributes
2826: (