eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_CC_VALIDATE dependencies on IBY_CC_ISSUER_RANGES

Line 254: lx_range_id iby_cc_issuer_ranges.cc_issuer_range_id%TYPE;

250:
251: v_Length INTEGER;
252: v_DigitsOk BOOLEAN;
253: lx_card_issuer iby_creditcard_issuers_b.card_issuer_code%TYPE;
254: lx_range_id iby_cc_issuer_ranges.cc_issuer_range_id%TYPE;
255: lx_card_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;
256: lx_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;
257:
258: BEGIN

Line 255: lx_card_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;

251: v_Length INTEGER;
252: v_DigitsOk BOOLEAN;
253: lx_card_issuer iby_creditcard_issuers_b.card_issuer_code%TYPE;
254: lx_range_id iby_cc_issuer_ranges.cc_issuer_range_id%TYPE;
255: lx_card_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;
256: lx_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;
257:
258: BEGIN
259: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 401: x_issuer_range OUT NOCOPY iby_cc_issuer_ranges.cc_issuer_range_id%TYPE,

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

Line 402: x_card_prefix OUT NOCOPY iby_cc_issuer_ranges.card_number_prefix%TYPE,

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

Line 425: x_issuer_range OUT NOCOPY iby_cc_issuer_ranges.cc_issuer_range_id%TYPE,

421: --Bug 8581161: FP:8352320
422: PROCEDURE Get_CC_Issuer_Range
423: (p_card_number IN iby_creditcard.ccnumber%TYPE,
424: x_card_issuer OUT NOCOPY iby_creditcard_issuers_b.card_issuer_code%TYPE,
425: x_issuer_range OUT NOCOPY iby_cc_issuer_ranges.cc_issuer_range_id%TYPE,
426: x_card_prefix OUT NOCOPY iby_cc_issuer_ranges.card_number_prefix%TYPE,
427: x_digit_check OUT NOCOPY iby_creditcard_issuers_b.digit_check_flag%TYPE,
428: p_card_type IN iby_creditcard.card_issuer_code%TYPE
429: )

Line 426: x_card_prefix OUT NOCOPY iby_cc_issuer_ranges.card_number_prefix%TYPE,

422: PROCEDURE Get_CC_Issuer_Range
423: (p_card_number IN iby_creditcard.ccnumber%TYPE,
424: x_card_issuer OUT NOCOPY iby_creditcard_issuers_b.card_issuer_code%TYPE,
425: x_issuer_range OUT NOCOPY iby_cc_issuer_ranges.cc_issuer_range_id%TYPE,
426: x_card_prefix OUT NOCOPY iby_cc_issuer_ranges.card_number_prefix%TYPE,
427: x_digit_check OUT NOCOPY iby_creditcard_issuers_b.digit_check_flag%TYPE,
428: p_card_type IN iby_creditcard.card_issuer_code%TYPE
429: )
430: IS

Line 442: FROM iby_cc_issuer_ranges r, iby_creditcard_issuers_b i

438: ci_card_type IN iby_creditcard.card_issuer_code%TYPE)
439: IS
440: SELECT cc_issuer_range_id, r.card_issuer_code,
441: card_number_prefix, NVL(digit_check_flag,'N')
442: FROM iby_cc_issuer_ranges r, iby_creditcard_issuers_b i
443: WHERE (card_number_length = ci_card_len)
444: AND (INSTR(ci_card_number,card_number_prefix) = 1)
445: AND (r.card_issuer_code = i.card_issuer_code)
446: AND r.card_issuer_code = NVL(ci_card_type, r.card_issuer_code)

Line 499: lx_issuer_range iby_cc_issuer_ranges.cc_issuer_range_id%TYPE;

495: (p_card_number IN iby_creditcard.ccnumber%TYPE)
496: RETURN NUMBER
497: IS
498: lx_card_issuer iby_creditcard_issuers_b.card_issuer_code%TYPE;
499: lx_issuer_range iby_cc_issuer_ranges.cc_issuer_range_id%TYPE;
500: lx_card_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;
501: lx_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;
502: BEGIN
503: Get_CC_Issuer_Range(p_card_number,lx_card_issuer,lx_issuer_range,

Line 500: lx_card_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;

496: RETURN NUMBER
497: IS
498: lx_card_issuer iby_creditcard_issuers_b.card_issuer_code%TYPE;
499: lx_issuer_range iby_cc_issuer_ranges.cc_issuer_range_id%TYPE;
500: lx_card_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;
501: lx_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;
502: BEGIN
503: Get_CC_Issuer_Range(p_card_number,lx_card_issuer,lx_issuer_range,
504: lx_card_prefix,lx_digit_check);