DBA Data[Home] [Help]

APPS.IBY_CC_VALIDATE dependencies on IBY_CREDITCARD

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

191: -- card number
192: -- x_issuer_range => Range of the card number
193: --
194: PROCEDURE Get_CC_Issuer_Range
195: (p_card_number IN iby_creditcard.ccnumber%TYPE,
196: x_card_issuer OUT NOCOPY iby_creditcard_issuers_b.card_issuer_code%TYPE,
197: x_issuer_range OUT NOCOPY iby_cc_issuer_ranges.cc_issuer_range_id%TYPE,
198: x_card_prefix OUT NOCOPY iby_cc_issuer_ranges.card_number_prefix%TYPE,
199: x_digit_check OUT NOCOPY iby_creditcard_issuers_b.digit_check_flag%TYPE

Line 196: x_card_issuer OUT NOCOPY iby_creditcard_issuers_b.card_issuer_code%TYPE,

192: -- x_issuer_range => Range of the card number
193: --
194: PROCEDURE Get_CC_Issuer_Range
195: (p_card_number IN iby_creditcard.ccnumber%TYPE,
196: x_card_issuer OUT NOCOPY iby_creditcard_issuers_b.card_issuer_code%TYPE,
197: x_issuer_range OUT NOCOPY iby_cc_issuer_ranges.cc_issuer_range_id%TYPE,
198: x_card_prefix OUT NOCOPY iby_cc_issuer_ranges.card_number_prefix%TYPE,
199: x_digit_check OUT NOCOPY iby_creditcard_issuers_b.digit_check_flag%TYPE
200: );

Line 199: x_digit_check OUT NOCOPY iby_creditcard_issuers_b.digit_check_flag%TYPE

195: (p_card_number IN iby_creditcard.ccnumber%TYPE,
196: x_card_issuer OUT NOCOPY iby_creditcard_issuers_b.card_issuer_code%TYPE,
197: x_issuer_range OUT NOCOPY iby_cc_issuer_ranges.cc_issuer_range_id%TYPE,
198: x_card_prefix OUT NOCOPY iby_cc_issuer_ranges.card_number_prefix%TYPE,
199: x_digit_check OUT NOCOPY iby_creditcard_issuers_b.digit_check_flag%TYPE
200: );
201:
202: --
203: -- Inline wrapper function for the above

Line 206: (p_card_number IN iby_creditcard.ccnumber%TYPE)

202: --
203: -- Inline wrapper function for the above
204: --
205: FUNCTION Get_CC_Issuer_Range
206: (p_card_number IN iby_creditcard.ccnumber%TYPE)
207: RETURN NUMBER;
208:
209: FUNCTION CheckCCDigits( p_cc_id IN VARCHAR2 ) RETURN NUMBER;
210: