[Home] [Help]
6848: p_segment_id IN iby_security_segments.sec_segment_id%TYPE,
6849: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,
6850: p_card_prefix IN iby_cc_issuer_ranges.card_number_prefix%TYPE,
6851: p_card_len IN iby_cc_issuer_ranges.card_number_length%TYPE,
6852: p_digit_check IN iby_creditcard_issuers_b.digit_check_flag%TYPE
6853: )
6854: RETURN iby_trxn_summaries_all.instrnumber%TYPE
6855: IS
6856: BEGIN
7132: i.digit_check_flag) ccnum,
7133: instrnum_sec_segment_id
7134: FROM iby_trxn_summaries_all tx,
7135: iby_security_segments seg, iby_sys_security_subkeys k,
7136: iby_cc_issuer_ranges r, iby_creditcard_issuers_b i
7137: WHERE
7138: /*
7139: (NOT instrnumber IS NULL)
7140: AND (DECODE(instrtype, 'PINLESSDEBITCARD','CREDITCARD',