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_CREDITCARD

Line 253: lx_card_issuer iby_creditcard_issuers_b.card_issuer_code%TYPE;

249: ) AS
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:

Line 256: lx_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;

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;
260:

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

395:
396: END ValidateCC;
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

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

396: END ValidateCC;
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: )

Line 403: x_digit_check OUT NOCOPY iby_creditcard_issuers_b.digit_check_flag%TYPE

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;
407: l_length NUMBER;

Line 406: l_cc_number iby_creditcard.ccnumber%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;
407: l_length NUMBER;
408: l_DBUG_MOD VARCHAR2(100) :='IBY_CC_VALIDATE.Get_CC_Issuer_Range(5 params)';
409:
410: BEGIN

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

419:
420: END Get_CC_Issuer_Range;
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,

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

420: END Get_CC_Issuer_Range;
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

Line 427: x_digit_check OUT NOCOPY iby_creditcard_issuers_b.digit_check_flag%TYPE,

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
431: l_cc_number iby_creditcard.ccnumber%TYPE;

Line 428: p_card_type IN iby_creditcard.card_issuer_code%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
431: l_cc_number iby_creditcard.ccnumber%TYPE;
432: l_length NUMBER;

Line 431: l_cc_number iby_creditcard.ccnumber%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
431: l_cc_number iby_creditcard.ccnumber%TYPE;
432: l_length NUMBER;
433: l_DBUG_MOD VARCHAR2(100) :='IBY_CC_VALIDATE.Get_CC_Issuer_Range(6 params)';
434:
435: CURSOR c_range

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

432: l_length NUMBER;
433: l_DBUG_MOD VARCHAR2(100) :='IBY_CC_VALIDATE.Get_CC_Issuer_Range(6 params)';
434:
435: CURSOR c_range
436: (ci_card_number IN iby_creditcard.ccnumber%TYPE,
437: ci_card_len IN NUMBER,
438: ci_card_type IN iby_creditcard.card_issuer_code%TYPE)
439: IS
440: SELECT cc_issuer_range_id, r.card_issuer_code,

Line 438: ci_card_type IN iby_creditcard.card_issuer_code%TYPE)

434:
435: CURSOR c_range
436: (ci_card_number IN iby_creditcard.ccnumber%TYPE,
437: ci_card_len IN NUMBER,
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

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 495: (p_card_number IN iby_creditcard.ccnumber%TYPE)

491:
492: END Get_CC_Issuer_Range;
493:
494: FUNCTION Get_CC_Issuer_Range
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;

Line 498: lx_card_issuer iby_creditcard_issuers_b.card_issuer_code%TYPE;

494: FUNCTION Get_CC_Issuer_Range
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

Line 501: lx_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;

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);
505: RETURN lx_issuer_range;