529: x_aux_msg OUT NOCOPY VARCHAR2
530: );
531:
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,
531:
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
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:
542: FUNCTION Uncompress_CC_Number
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:
542: FUNCTION Uncompress_CC_Number
543: (p_card_number IN iby_creditcard.ccnumber%TYPE,
539: x_unmask_digits OUT NOCOPY iby_creditcard.masked_cc_number%TYPE
540: );
541:
542: FUNCTION Uncompress_CC_Number
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,
540: );
541:
542: FUNCTION Uncompress_CC_Number
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,
542: FUNCTION Uncompress_CC_Number
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: )
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
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,
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
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;
559: )
560: RETURN NUMBER;
561:
562: FUNCTION uncipher_ccnumber
563: (p_cc_number IN iby_creditcard.ccnumber%TYPE,
564: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,
565: p_encrypted IN iby_creditcard.encrypted%TYPE,
566: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
567: p_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
561:
562: FUNCTION uncipher_ccnumber
563: (p_cc_number IN iby_creditcard.ccnumber%TYPE,
564: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,
565: p_encrypted IN iby_creditcard.encrypted%TYPE,
566: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
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,
566: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
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: )
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:
577: PROCEDURE encrypt_chname
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:
577: PROCEDURE encrypt_chname
578: (p_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
579: p_chname IN iby_creditcard.chname%TYPE,
575: RETURN iby_creditcard.ccnumber%TYPE;
576:
577: PROCEDURE encrypt_chname
578: (p_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
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,
578: (p_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
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:
585: );
586:
587: FUNCTION decrypt_chname
588: (p_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
589: p_instrid IN iby_creditcard.instrid%TYPE
590: ) RETURN iby_creditcard.chname%TYPE;
591:
592: PROCEDURE prepare_instr_data
593: (p_commit IN VARCHAR2,
586:
587: FUNCTION decrypt_chname
588: (p_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
589: p_instrid IN iby_creditcard.instrid%TYPE
590: ) RETURN iby_creditcard.chname%TYPE;
591:
592: PROCEDURE prepare_instr_data
593: (p_commit IN VARCHAR2,
594: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
611: p_segment_id IN iby_security_segments.sec_segment_id%TYPE,
612: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,
613: p_card_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
614: p_card_len IN iby_cc_issuer_ranges.card_number_length%TYPE,
615: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE
616: )
617: RETURN iby_trxn_summaries_all.instrnumber%TYPE;
618:
619: PROCEDURE unencrypt_instr_num