DBA Data[Home] [Help]

APPS.IBY_SECURITY_PKG dependencies on IBY_CREDITCARD

Line 533: (p_card_number IN iby_creditcard.ccnumber%TYPE,

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,

Line 535: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%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

Line 538: x_compress_num OUT NOCOPY 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:
542: FUNCTION Uncompress_CC_Number

Line 539: x_unmask_digits OUT NOCOPY iby_creditcard.masked_cc_number%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
543: (p_card_number IN iby_creditcard.ccnumber%TYPE,

Line 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,

Line 544: p_card_length IN iby_creditcard.cc_number_length%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,

Line 546: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%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: )

Line 549: p_unmask_digits IN iby_creditcard.masked_cc_number%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

Line 551: RETURN iby_creditcard.ccnumber%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,

Line 554: (p_card_length IN iby_creditcard.cc_number_length%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

Line 556: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%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;

Line 563: (p_cc_number IN iby_creditcard.ccnumber%TYPE,

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,

Line 565: p_encrypted IN iby_creditcard.encrypted%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,

Line 570: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%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: )

Line 573: p_unmask_digits IN iby_creditcard.masked_cc_number%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:
577: PROCEDURE encrypt_chname

Line 575: RETURN iby_creditcard.ccnumber%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
578: (p_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
579: p_chname IN iby_creditcard.chname%TYPE,

Line 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,

Line 582: x_masked_chname OUT NOCOPY iby_creditcard.chname%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:

Line 589: p_instrid IN iby_creditcard.instrid%TYPE

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,

Line 590: ) RETURN iby_creditcard.chname%TYPE;

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,

Line 615: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%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