[Home] [Help]
88: RETURN hz_party_site_uses.party_site_use_id%TYPE;
89:
90:
91: PROCEDURE encrypt_chname
92: (p_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
93: p_chname IN iby_creditcard.chname%TYPE,
94: p_segment_id IN NUMBER,
95: x_segment_id OUT NOCOPY NUMBER,
96: x_masked_chname OUT NOCOPY iby_creditcard.chname%TYPE,
98: x_unmask_len OUT NOCOPY iby_sys_security_options.credit_card_unmask_len%TYPE
99: );
100:
101: FUNCTION decrypt_chname
102: (p_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
103: p_instrid IN iby_creditcard.instrid%TYPE
104: ) RETURN iby_creditcard.chname%TYPE;
105:
106: PROCEDURE Create_Card
123: p_purpose IN iby_creditcard.card_purpose%TYPE,
124: p_desc IN iby_creditcard.description%TYPE,
125: p_active_flag IN iby_creditcard.active_flag%TYPE,
126: p_inactive_date IN iby_creditcard.inactive_date%TYPE,
127: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
128: p_attribute_category IN iby_creditcard.attribute_category%TYPE,
129: p_attribute1 IN iby_creditcard.attribute1%TYPE,
130: p_attribute2 IN iby_creditcard.attribute2%TYPE,
131: p_attribute3 IN iby_creditcard.attribute3%TYPE,
229:
230:
231: PROCEDURE Query_Card
232: (p_card_id IN iby_creditcard.instrid%TYPE,
233: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
234: x_owner_id OUT NOCOPY iby_creditcard.card_owner_id%TYPE,
235: x_holder_name OUT NOCOPY iby_creditcard.chname%TYPE,
236: x_billing_address_id OUT NOCOPY iby_creditcard.addressid%TYPE,
237: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,
260:
261:
262: PROCEDURE Query_Card
263: (p_card_id IN iby_creditcard.instrid%TYPE,
264: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
265: x_owner_id OUT NOCOPY iby_creditcard.card_owner_id%TYPE,
266: x_holder_name OUT NOCOPY iby_creditcard.chname%TYPE,
267: x_billing_address_id OUT NOCOPY iby_creditcard.addressid%TYPE,
268: x_billing_address1 OUT NOCOPY hz_locations.address1%TYPE,
298: -- i_sys_sec_key => the system security key
299: --
300: FUNCTION uncipher_ccnumber
301: (p_instrid IN iby_creditcard.instrid%TYPE,
302: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE
303: )
304: RETURN iby_creditcard.ccnumber%TYPE;
305:
306: --
308: FUNCTION uncipher_ccnumber
309: (p_cc_number IN iby_creditcard.ccnumber%TYPE,
310: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,
311: p_encrypted IN iby_creditcard.encrypted%TYPE,
312: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
313: p_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
314: p_card_len IN iby_cc_issuer_ranges.card_number_length%TYPE,
315: p_cc_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
316: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,
333: -- i_sys_sec_key => the system security key
334: --
335: FUNCTION uncipher_ccnumber_ui_wrp
336: (i_instrid IN iby_creditcard.instrid%TYPE,
337: i_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE)
338: RETURN iby_creditcard.ccnumber%TYPE;
339:
340: --
341: -- USE: Un-encrypts all registered credit card instruments, storing
345: -- p_sys_key => system security key; used to decrypt instruments
346: --
347: PROCEDURE Decrypt_Instruments
348: (p_commit IN VARCHAR2 := FND_API.G_TRUE,
349: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE
350: );
351:
352: --
353: -- USE: Encrypts all registered credit cards
356: -- p_sys_key => system security key; used to encrypt instruments
357: --
358: PROCEDURE Encrypt_Instruments
359: (p_commit IN VARCHAR2 := FND_API.G_TRUE,
360: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE
361: );
362:
363: --
364: -- USE: Updates instrument masks according to new setting
367: -- p_sys_key => system security key; used to encrypt instruments
368: --
369: PROCEDURE Remask_Instruments
370: (p_commit IN VARCHAR2 := FND_API.G_TRUE,
371: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE
372: );
373:
374: -- USE: Compresses a card number into the minimum clear text
375: -- representation
423: -- corresponding security segment_IDs
424: --
425: PROCEDURE Encrypt_Card_Info
426: (p_commit IN VARCHAR2 := FND_API.G_TRUE,
427: p_sys_security_key IN iby_security_pkg.DES3_KEY_TYPE,
428: p_expiry_date IN DATE,
429: p_expSegmentId IN NUMBER,
430: p_chname IN VARCHAR2,
431: p_chnameSegmentId IN NUMBER,
444: --
445: --
446: PROCEDURE Mark_Expired_Cards
447: (p_commit IN VARCHAR2 := FND_API.G_TRUE,
448: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE
449: );
450:
451: --
452: -- USE: Upgrades the previously encrypted credit card records, by
454: --
455: --
456: PROCEDURE Upgrade_Encrypted_Instruments
457: (p_commit IN VARCHAR2 := FND_API.G_TRUE,
458: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE
459: );
460:
461:
462: PROCEDURE Check_CC_Expiry
461:
462: PROCEDURE Check_CC_Expiry
463: (p_instrid IN IBY_CREDITCARD.instrid%TYPE,
464: p_input_date IN DATE,
465: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
466: x_expired OUT NOCOPY VARCHAR2
467: );
468:
469: PROCEDURE Upgrade_Risky_Instruments