522: -- [Author]: lmallick
523: -- The procedure migrates the 11i vaulted system key
524: PROCEDURE Init_App_With_Vaulted_Key
525: (
526: p_wallet_path IN iby_sys_security_options.SYS_KEY_FILE_LOCATION%TYPE,
527: x_sys_key OUT NOCOPY DES3_KEY_TYPE,
528: x_result_msg OUT NOCOPY VARCHAR2,
529: x_aux_msg OUT NOCOPY VARCHAR2
530: );
532: PROCEDURE Compress_CC_Number
533: (p_card_number IN iby_creditcard.ccnumber%TYPE,
534: p_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
535: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,
536: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,
537: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE,
538: x_compress_num OUT NOCOPY iby_creditcard.ccnumber%TYPE,
539: x_unmask_digits OUT NOCOPY iby_creditcard.masked_cc_number%TYPE
540: );
533: (p_card_number IN iby_creditcard.ccnumber%TYPE,
534: p_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
535: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,
536: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,
537: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE,
538: x_compress_num OUT NOCOPY iby_creditcard.ccnumber%TYPE,
539: x_unmask_digits OUT NOCOPY iby_creditcard.masked_cc_number%TYPE
540: );
541:
543: (p_card_number IN iby_creditcard.ccnumber%TYPE,
544: p_card_length IN iby_creditcard.cc_number_length%TYPE,
545: p_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
546: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,
547: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,
548: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE,
549: p_unmask_digits IN iby_creditcard.masked_cc_number%TYPE
550: )
551: RETURN iby_creditcard.ccnumber%TYPE;
544: p_card_length IN iby_creditcard.cc_number_length%TYPE,
545: p_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
546: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,
547: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,
548: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE,
549: p_unmask_digits IN iby_creditcard.masked_cc_number%TYPE
550: )
551: RETURN iby_creditcard.ccnumber%TYPE;
552:
553: FUNCTION Get_Compressed_Len
554: (p_card_length IN iby_creditcard.cc_number_length%TYPE,
555: p_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
556: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,
557: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,
558: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE
559: )
560: RETURN NUMBER;
561:
554: (p_card_length IN iby_creditcard.cc_number_length%TYPE,
555: p_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
556: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,
557: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,
558: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE
559: )
560: RETURN NUMBER;
561:
562: FUNCTION uncipher_ccnumber
567: p_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
568: p_card_len IN iby_cc_issuer_ranges.card_number_length%TYPE,
569: p_cc_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
570: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,
571: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,
572: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE,
573: p_unmask_digits IN iby_creditcard.masked_cc_number%TYPE
574: )
575: RETURN iby_creditcard.ccnumber%TYPE;
568: p_card_len IN iby_cc_issuer_ranges.card_number_length%TYPE,
569: p_cc_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
570: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE,
571: p_mask_setting IN iby_sys_security_options.credit_card_mask_setting%TYPE,
572: p_unmask_len IN iby_sys_security_options.credit_card_unmask_len%TYPE,
573: p_unmask_digits IN iby_creditcard.masked_cc_number%TYPE
574: )
575: RETURN iby_creditcard.ccnumber%TYPE;
576:
579: p_chname IN iby_creditcard.chname%TYPE,
580: p_segment_id IN NUMBER,
581: x_segment_id OUT NOCOPY NUMBER,
582: x_masked_chname OUT NOCOPY iby_creditcard.chname%TYPE,
583: x_mask_setting OUT NOCOPY iby_sys_security_options.credit_card_mask_setting%TYPE,
584: x_unmask_len OUT NOCOPY iby_sys_security_options.credit_card_unmask_len%TYPE
585: );
586:
587: FUNCTION decrypt_chname
580: p_segment_id IN NUMBER,
581: x_segment_id OUT NOCOPY NUMBER,
582: x_masked_chname OUT NOCOPY iby_creditcard.chname%TYPE,
583: x_mask_setting OUT NOCOPY iby_sys_security_options.credit_card_mask_setting%TYPE,
584: x_unmask_len OUT NOCOPY iby_sys_security_options.credit_card_unmask_len%TYPE
585: );
586:
587: FUNCTION decrypt_chname
588: (p_sec_key IN iby_security_pkg.DES3_KEY_TYPE,