197: -- card number
198: -- x_issuer_range => Range of the card number
199: --
200: PROCEDURE Get_CC_Issuer_Range
201: (p_card_number IN iby_creditcard.ccnumber%TYPE,
202: x_card_issuer OUT NOCOPY iby_creditcard_issuers_b.card_issuer_code%TYPE,
203: x_issuer_range OUT NOCOPY iby_cc_issuer_ranges.cc_issuer_range_id%TYPE,
204: x_card_prefix OUT NOCOPY iby_cc_issuer_ranges.card_number_prefix%TYPE,
205: x_digit_check OUT NOCOPY iby_creditcard_issuers_b.digit_check_flag%TYPE
198: -- x_issuer_range => Range of the card number
199: --
200: PROCEDURE Get_CC_Issuer_Range
201: (p_card_number IN iby_creditcard.ccnumber%TYPE,
202: x_card_issuer OUT NOCOPY iby_creditcard_issuers_b.card_issuer_code%TYPE,
203: x_issuer_range OUT NOCOPY iby_cc_issuer_ranges.cc_issuer_range_id%TYPE,
204: x_card_prefix OUT NOCOPY iby_cc_issuer_ranges.card_number_prefix%TYPE,
205: x_digit_check OUT NOCOPY iby_creditcard_issuers_b.digit_check_flag%TYPE
206: );
201: (p_card_number IN iby_creditcard.ccnumber%TYPE,
202: x_card_issuer OUT NOCOPY iby_creditcard_issuers_b.card_issuer_code%TYPE,
203: x_issuer_range OUT NOCOPY iby_cc_issuer_ranges.cc_issuer_range_id%TYPE,
204: x_card_prefix OUT NOCOPY iby_cc_issuer_ranges.card_number_prefix%TYPE,
205: x_digit_check OUT NOCOPY iby_creditcard_issuers_b.digit_check_flag%TYPE
206: );
207:
208: --
209: -- Inline wrapper function for the above
208: --
209: -- Inline wrapper function for the above
210: --
211: FUNCTION Get_CC_Issuer_Range
212: (p_card_number IN iby_creditcard.ccnumber%TYPE)
213: RETURN NUMBER;
214:
215: FUNCTION CheckCCDigits( p_cc_id IN VARCHAR2 ) RETURN NUMBER;
216:
227: -- card number
228: -- x_issuer_range => Range of the card number
229: --
230: PROCEDURE Get_CC_Issuer_Range
231: (p_card_number IN iby_creditcard.ccnumber%TYPE,
232: x_card_issuer OUT NOCOPY iby_creditcard_issuers_b.card_issuer_code%TYPE,
233: x_issuer_range OUT NOCOPY iby_cc_issuer_ranges.cc_issuer_range_id%TYPE,
234: x_card_prefix OUT NOCOPY iby_cc_issuer_ranges.card_number_prefix%TYPE,
235: x_digit_check OUT NOCOPY iby_creditcard_issuers_b.digit_check_flag%TYPE,
228: -- x_issuer_range => Range of the card number
229: --
230: PROCEDURE Get_CC_Issuer_Range
231: (p_card_number IN iby_creditcard.ccnumber%TYPE,
232: x_card_issuer OUT NOCOPY iby_creditcard_issuers_b.card_issuer_code%TYPE,
233: x_issuer_range OUT NOCOPY iby_cc_issuer_ranges.cc_issuer_range_id%TYPE,
234: x_card_prefix OUT NOCOPY iby_cc_issuer_ranges.card_number_prefix%TYPE,
235: x_digit_check OUT NOCOPY iby_creditcard_issuers_b.digit_check_flag%TYPE,
236: p_card_type IN iby_creditcard.card_issuer_code%TYPE
231: (p_card_number IN iby_creditcard.ccnumber%TYPE,
232: x_card_issuer OUT NOCOPY iby_creditcard_issuers_b.card_issuer_code%TYPE,
233: x_issuer_range OUT NOCOPY iby_cc_issuer_ranges.cc_issuer_range_id%TYPE,
234: x_card_prefix OUT NOCOPY iby_cc_issuer_ranges.card_number_prefix%TYPE,
235: x_digit_check OUT NOCOPY iby_creditcard_issuers_b.digit_check_flag%TYPE,
236: p_card_type IN iby_creditcard.card_issuer_code%TYPE
237: );
238:
239:
232: x_card_issuer OUT NOCOPY iby_creditcard_issuers_b.card_issuer_code%TYPE,
233: x_issuer_range OUT NOCOPY iby_cc_issuer_ranges.cc_issuer_range_id%TYPE,
234: x_card_prefix OUT NOCOPY iby_cc_issuer_ranges.card_number_prefix%TYPE,
235: x_digit_check OUT NOCOPY iby_creditcard_issuers_b.digit_check_flag%TYPE,
236: p_card_type IN iby_creditcard.card_issuer_code%TYPE
237: );
238:
239:
240: