APPS.IBY_CC_VALIDATE dependencies on IBY_CREDITCARD

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

398:
399: END ValidateCC;
400:
401: PROCEDURE Get_CC_Issuer_Range
402: (p_card_number IN iby_creditcard.ccnumber%TYPE,
403: x_card_issuer OUT NOCOPY iby_creditcard_issuers_b.card_issuer_code%TYPE,
404: x_issuer_range OUT NOCOPY iby_cc_issuer_ranges.cc_issuer_range_id%TYPE,
405: x_card_prefix OUT NOCOPY iby_cc_issuer_ranges.card_number_prefix%TYPE,
406: x_digit_check OUT NOCOPY iby_creditcard_issuers_b.digit_check_flag%TYPE

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

399: END ValidateCC;
400:
401: PROCEDURE Get_CC_Issuer_Range
402: (p_card_number IN iby_creditcard.ccnumber%TYPE,
403: x_card_issuer OUT NOCOPY iby_creditcard_issuers_b.card_issuer_code%TYPE,
404: x_issuer_range OUT NOCOPY iby_cc_issuer_ranges.cc_issuer_range_id%TYPE,
405: x_card_prefix OUT NOCOPY iby_cc_issuer_ranges.card_number_prefix%TYPE,
406: x_digit_check OUT NOCOPY iby_creditcard_issuers_b.digit_check_flag%TYPE
407: )

Line 406: x_digit_check OUT NOCOPY iby_creditcard_issuers_b.digit_check_flag%TYPE

402: (p_card_number IN iby_creditcard.ccnumber%TYPE,
403: x_card_issuer OUT NOCOPY iby_creditcard_issuers_b.card_issuer_code%TYPE,
404: x_issuer_range OUT NOCOPY iby_cc_issuer_ranges.cc_issuer_range_id%TYPE,
405: x_card_prefix OUT NOCOPY iby_cc_issuer_ranges.card_number_prefix%TYPE,
406: x_digit_check OUT NOCOPY iby_creditcard_issuers_b.digit_check_flag%TYPE
407: )
408: IS
409: CURSOR c_range
410: (ci_card_number IN iby_creditcard.ccnumber%TYPE,

Line 410: (ci_card_number IN iby_creditcard.ccnumber%TYPE,

406: x_digit_check OUT NOCOPY iby_creditcard_issuers_b.digit_check_flag%TYPE
407: )
408: IS
409: CURSOR c_range
410: (ci_card_number IN iby_creditcard.ccnumber%TYPE,
411: ci_card_len IN NUMBER)
412: IS
413: SELECT cc_issuer_range_id, r.card_issuer_code,
414: card_number_prefix, NVL(digit_check_flag,'N')

Line 415: FROM iby_cc_issuer_ranges r, iby_creditcard_issuers_b i

411: ci_card_len IN NUMBER)
412: IS
413: SELECT cc_issuer_range_id, r.card_issuer_code,
414: card_number_prefix, NVL(digit_check_flag,'N')
415: FROM iby_cc_issuer_ranges r, iby_creditcard_issuers_b i
416: WHERE (card_number_length = ci_card_len)
417: AND (INSTR(ci_card_number,card_number_prefix) = 1)
418: AND (r.card_issuer_code = i.card_issuer_code);
419: BEGIN

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

431:
432: END Get_CC_Issuer_Range;
433:
434: FUNCTION Get_CC_Issuer_Range
435: (p_card_number IN iby_creditcard.ccnumber%TYPE)
436: RETURN NUMBER
437: IS
438: lx_card_issuer iby_creditcard_issuers_b.card_issuer_code%TYPE;
439: lx_issuer_range iby_cc_issuer_ranges.cc_issuer_range_id%TYPE;

Line 438: lx_card_issuer iby_creditcard_issuers_b.card_issuer_code%TYPE;

434: FUNCTION Get_CC_Issuer_Range
435: (p_card_number IN iby_creditcard.ccnumber%TYPE)
436: RETURN NUMBER
437: IS
438: lx_card_issuer iby_creditcard_issuers_b.card_issuer_code%TYPE;
439: lx_issuer_range iby_cc_issuer_ranges.cc_issuer_range_id%TYPE;
440: lx_card_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;
441: lx_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;
442: BEGIN

Line 441: lx_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;

437: IS
438: lx_card_issuer iby_creditcard_issuers_b.card_issuer_code%TYPE;
439: lx_issuer_range iby_cc_issuer_ranges.cc_issuer_range_id%TYPE;
440: lx_card_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;
441: lx_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;
442: BEGIN
443: Get_CC_Issuer_Range(p_card_number,lx_card_issuer,lx_issuer_range,
444: lx_card_prefix,lx_digit_check);
445: RETURN lx_issuer_range;