[Home] [Help]
1928: p_purpose IN iby_creditcard.card_purpose%TYPE,
1929: p_desc IN iby_creditcard.description%TYPE,
1930: p_active_flag IN iby_creditcard.active_flag%TYPE,
1931: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
1932: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
1933: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
1934: p_attribute1 IN iby_creditcard.attribute1%TYPE,
1935: p_attribute2 IN iby_creditcard.attribute2%TYPE,
1936: p_attribute3 IN iby_creditcard.attribute3%TYPE,
2191: OPEN c_sec_mode;
2192: FETCH c_sec_mode INTO l_sec_mode;
2193: CLOSE c_sec_mode;
2194:
2195: IF (l_sec_mode = iby_security_pkg.G_ENCRYPT_MODE_INSTANT) THEN
2196:
2197: iby_debug_pub.add('online registration',
2198: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2199:
2887: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2888: RETURN;
2889: END IF;
2890:
2891: l_cc_hash1 := iby_security_pkg.get_hash(lx_cc_number,'F');
2892: l_cc_hash2 := iby_security_pkg.get_hash(lx_cc_number,'T');
2893:
2894: OPEN c_card(l_cc_hash1,l_cc_hash2,p_owner_id);
2895: FETCH c_card INTO l_card_id;
2888: RETURN;
2889: END IF;
2890:
2891: l_cc_hash1 := iby_security_pkg.get_hash(lx_cc_number,'F');
2892: l_cc_hash2 := iby_security_pkg.get_hash(lx_cc_number,'T');
2893:
2894: OPEN c_card(l_cc_hash1,l_cc_hash2,p_owner_id);
2895: FETCH c_card INTO l_card_id;
2896: CLOSE c_card;
3095: iby_cc_validate.StripCC
3096: (1.0, FND_API.G_FALSE, p_number,
3097: lx_return_status, lx_msg_count, lx_msg_data, lx_cc_number
3098: );
3099: RETURN iby_security_pkg.get_hash(lx_cc_number,p_salt);
3100: END Get_Hash;
3101:
3102: FUNCTION Get_Hash(p_number IN VARCHAR2, p_salt IN VARCHAR2, p_site_salt IN VARCHAR2)
3103: RETURN VARCHAR2
3110: iby_cc_validate.StripCC
3111: (1.0, FND_API.G_FALSE, p_number,
3112: lx_return_status, lx_msg_count, lx_msg_data, lx_cc_number
3113: );
3114: RETURN iby_security_pkg.get_hash(lx_cc_number,p_salt,p_site_salt);
3115: END Get_Hash;
3116:
3117: PROCEDURE Get_Trxn_Payer_Attributes
3118: (