APPS.AR_IREC_PAYMENTS dependencies on IBY_CREDITCARD

Line 232: l_card_issuer iby_creditcard_issuers_b.card_issuer_code%TYPE;

228: -- arp_standard.debug('AR_IREC_PAYMENTS.get_credit_card_type()+');
229:
230: -- arp_standard.debug(' p_credit_card_number :' || p_credit_card_number);
231:
232: l_card_issuer iby_creditcard_issuers_b.card_issuer_code%TYPE;
233: l_issuer_range iby_cc_issuer_ranges.cc_issuer_range_id%TYPE;
234: l_card_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;
235: l_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;
236:

Line 235: l_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;

231:
232: l_card_issuer iby_creditcard_issuers_b.card_issuer_code%TYPE;
233: l_issuer_range iby_cc_issuer_ranges.cc_issuer_range_id%TYPE;
234: l_card_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;
235: l_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;
236:
237: CURSOR c_range
238: (ci_card_number IN iby_creditcard.ccnumber%TYPE,
239: ci_card_len IN NUMBER)

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

234: l_card_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;
235: l_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;
236:
237: CURSOR c_range
238: (ci_card_number IN iby_creditcard.ccnumber%TYPE,
239: ci_card_len IN NUMBER)
240: IS
241: SELECT cc_issuer_range_id, r.card_issuer_code,
242: card_number_prefix, NVL(digit_check_flag,'N')

Line 243: FROM iby_cc_issuer_ranges r, iby_creditcard_issuers_b i

239: ci_card_len IN NUMBER)
240: IS
241: SELECT cc_issuer_range_id, r.card_issuer_code,
242: card_number_prefix, NVL(digit_check_flag,'N')
243: FROM iby_cc_issuer_ranges r, iby_creditcard_issuers_b i
244: WHERE (card_number_length = ci_card_len)
245: AND (INSTR(ci_card_number,card_number_prefix) = 1)
246: AND (r.card_issuer_code = i.card_issuer_code);
247: BEGIN

Line 1242: iby_creditcard c,

1238: FROM hz_cust_accounts cust,
1239: hz_party_preferences pp1,
1240: iby_external_payers_all p,
1241: iby_pmt_instr_uses_all u,
1242: iby_creditcard c,
1243: iby_creditcard_issuers_vl i,
1244: hz_parties hzcc,
1245: hz_party_site_uses psu,
1246: hz_party_sites hps,

Line 1243: iby_creditcard_issuers_vl i,

1239: hz_party_preferences pp1,
1240: iby_external_payers_all p,
1241: iby_pmt_instr_uses_all u,
1242: iby_creditcard c,
1243: iby_creditcard_issuers_vl i,
1244: hz_parties hzcc,
1245: hz_party_site_uses psu,
1246: hz_party_sites hps,
1247: hz_locations loc,

Line 1345: iby_creditcard c,

1341: NULL branch_party_id,
1342: NULL object_version_number
1343: FROM
1344: fnd_lookup_values_vl ccunk,
1345: iby_creditcard c,
1346: iby_creditcard_issuers_vl i,
1347: iby_external_payers_all p,
1348: iby_pmt_instr_uses_all u,
1349: hz_parties hzcc,

Line 1346: iby_creditcard_issuers_vl i,

1342: NULL object_version_number
1343: FROM
1344: fnd_lookup_values_vl ccunk,
1345: iby_creditcard c,
1346: iby_creditcard_issuers_vl i,
1347: iby_external_payers_all p,
1348: iby_pmt_instr_uses_all u,
1349: hz_parties hzcc,
1350: hz_cust_accounts cust,

Line 1814: CURSOR cc_cur(instrument_id iby_creditcard.instrid%TYPE) is

1810: FUNCTION is_bank_account_duplicate(p_bank_account_number IN VARCHAR2,
1811: p_routing_number IN VARCHAR2 DEFAULT NULL,
1812: p_account_holder_name IN VARCHAR2) RETURN NUMBER IS
1813:
1814: CURSOR cc_cur(instrument_id iby_creditcard.instrid%TYPE) is
1815: SELECT count(1) ca_exists
1816: FROM IBY_FNDCPT_PAYER_ASSGN_INSTR_V IBY
1817: WHERE IBY.instrument_id = instrument_id
1818: AND IBY.CARD_HOLDER_NAME <> p_account_holder_name;