DBA Data[Home] [Help]

APPS.IBY_CC_VALIDATE dependencies on IBY_CREDITCARD

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

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

Line 202: x_card_issuer OUT NOCOPY iby_creditcard_issuers_b.card_issuer_code%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: );

Line 205: x_digit_check OUT NOCOPY iby_creditcard_issuers_b.digit_check_flag%TYPE

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

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

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:

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

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,

Line 232: x_card_issuer OUT NOCOPY iby_creditcard_issuers_b.card_issuer_code%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

Line 235: x_digit_check OUT NOCOPY iby_creditcard_issuers_b.digit_check_flag%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:

Line 236: p_card_type IN iby_creditcard.card_issuer_code%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:
240: