[Home] [Help]
531: FROM ar_receipt_methods arm,
532: ra_cust_receipt_methods rcrm,
533: ar_receipt_method_accounts arma,
534: ce_bank_acct_uses_ou_v aba,
535: ce_bank_accounts cba,
536: ar_receipt_classes arc
537: WHERE arm.receipt_method_id = rcrm.receipt_method_id
538: AND arm.receipt_method_id = arma.receipt_method_id
539: AND arm.receipt_class_id = arc.receipt_class_id
630: arc.creation_status receipt_creation_status
631: FROM ar_receipt_methods arm,
632: ar_receipt_method_accounts arma,
633: ce_bank_acct_uses_ou_v aba,
634: ce_bank_accounts cba,
635: ar_receipt_classes arc
636: WHERE arm.payment_channel_code = 'CREDIT_CARD'
637: AND arm.receipt_method_id = NVL( to_number(fnd_profile.VALUE('OIR_CC_PMT_METHOD')), arm.receipt_method_id)
638: AND arm.receipt_method_id = arma.receipt_method_id
651: arc.creation_status receipt_creation_status
652: FROM ar_receipt_methods arm,
653: ar_receipt_method_accounts arma,
654: ce_bank_acct_uses_ou_v aba,
655: ce_bank_accounts cba,
656: ar_receipt_classes arc
657: WHERE NVL(arm.payment_channel_code,'NONE') <> 'CREDIT_CARD'
658: AND arm.receipt_method_id = NVL( to_number(fnd_profile.VALUE('OIR_BA_PMT_METHOD')), arm.receipt_method_id)
659: AND arm.receipt_method_id = arma.receipt_method_id
1225: p_account_type OUT NOCOPY VARCHAR2,
1226: p_expiry_month OUT NOCOPY VARCHAR2,
1227: p_expiry_year OUT NOCOPY VARCHAR2,
1228: p_credit_card_expired OUT NOCOPY VARCHAR2,
1229: p_bank_account_id OUT NOCOPY ce_bank_accounts.bank_account_id%TYPE,
1230: p_bank_branch_id OUT NOCOPY ce_bank_accounts.bank_branch_id%TYPE,
1231: p_account_holder OUT NOCOPY VARCHAR2,
1232: p_card_brand OUT NOCOPY VARCHAR2,
1233: p_cvv_code OUT NOCOPY VARCHAR2,
1226: p_expiry_month OUT NOCOPY VARCHAR2,
1227: p_expiry_year OUT NOCOPY VARCHAR2,
1228: p_credit_card_expired OUT NOCOPY VARCHAR2,
1229: p_bank_account_id OUT NOCOPY ce_bank_accounts.bank_account_id%TYPE,
1230: p_bank_branch_id OUT NOCOPY ce_bank_accounts.bank_branch_id%TYPE,
1231: p_account_holder OUT NOCOPY VARCHAR2,
1232: p_card_brand OUT NOCOPY VARCHAR2,
1233: p_cvv_code OUT NOCOPY VARCHAR2,
1234: p_conc_address OUT NOCOPY VARCHAR2,
1456:
1457:
1458: l_ba_count NUMBER := 0;
1459: l_cc_count NUMBER := 0;
1460: l_result ce_bank_accounts.bank_account_num%TYPE;
1461: l_payment_instrument VARCHAR2(100);
1462:
1463: x_return_status VARCHAR2(100);
1464: x_cvv_use VARCHAR2(100);
4406: l_msg_data VARCHAR2(4000);
4407: x_auth_result IBY_FNDCPT_TRXN_PUB.AuthResult_rec_type;
4408: l_call_payment_processor VARCHAR2(1);
4409: l_response_error_code VARCHAR2(80);
4410: l_bank_branch_id CE_BANK_ACCOUNTS.BANK_BRANCH_ID%TYPE;
4411: l_apply_err_count NUMBER;
4412: p_payment_schedule_id NUMBER;
4413:
4414: l_create_credit_card IBY_FNDCPT_SETUP_PUB.CreditCard_rec_type;
4996: BEGIN
4997: select pr.home_country into l_home_country
4998: from ar_cash_receipts_all cr,
4999: ce_bank_acct_uses bau,
5000: ce_bank_accounts cba,
5001: hz_parties bank,
5002: hz_organization_profiles pr
5003: where cr.cash_receipt_id = p_cash_receipt_id
5004: AND cr.remit_bank_acct_use_id = bau.bank_acct_use_id
5872: arc.creation_status receipt_creation_status
5873: FROM ar_receipt_methods arm,
5874: ar_receipt_method_accounts arma,
5875: ce_bank_acct_uses_ou_v aba,
5876: ce_bank_accounts cba,
5877: ar_receipt_classes arc
5878: WHERE arm.payment_channel_code = 'CREDIT_CARD'
5879: AND arm.receipt_method_id = NVL( to_number(fnd_profile.VALUE('OIR_CC_PMT_METHOD')), arm.receipt_method_id)
5880: AND arm.receipt_method_id = arma.receipt_method_id
5943: INTO system_cc_payment_method
5944: FROM ar_system_parameters sp,
5945: ar_receipt_methods rm,
5946: ar_receipt_method_accounts rma,
5947: ce_bank_accounts cba,
5948: ce_bank_acct_uses_ou_v ba,
5949: ar_receipt_classes rc
5950: WHERE sp.irec_cc_receipt_method_id = rm.receipt_method_id
5951: AND rma.receipt_method_id = rm.receipt_method_id
5973: FROM ar_receipt_methods arm,
5974: ra_cust_receipt_methods rcrm,
5975: ar_receipt_method_accounts arma,
5976: ce_bank_acct_uses_ou_v aba,
5977: ce_bank_accounts cba,
5978: ar_receipt_classes arc
5979: WHERE arm.receipt_method_id = rcrm.receipt_method_id
5980: AND arm.receipt_method_id = arma.receipt_method_id
5981: AND arm.receipt_class_id = arc.receipt_class_id
6061: arc.creation_status receipt_creation_status
6062: FROM ar_receipt_methods arm,
6063: ar_receipt_method_accounts arma,
6064: ce_bank_acct_uses_ou_v aba,
6065: ce_bank_accounts cba,
6066: ar_receipt_classes arc
6067: WHERE NVL(arm.payment_channel_code,'NONE') <> 'CREDIT_CARD'
6068: AND arm.receipt_method_id = NVL( to_number(fnd_profile.VALUE('OIR_BA_PMT_METHOD')), arm.receipt_method_id)
6069: AND arm.receipt_method_id = arma.receipt_method_id
6131: FROM ar_system_parameters sp,
6132: ar_receipt_methods rm,
6133: ar_receipt_method_accounts rma,
6134: ce_bank_acct_uses_ou_v ba,
6135: ce_bank_accounts cba
6136: WHERE sp.irec_ba_receipt_method_id = rm.receipt_method_id
6137: AND rma.receipt_method_id = rm.receipt_method_id
6138: AND rma.remit_bank_acct_use_id = ba.bank_acct_use_id
6139: AND ba.bank_account_id = cba.bank_account_id
6150: FROM ar_receipt_methods arm,
6151: ra_cust_receipt_methods rcrm,
6152: ar_receipt_method_accounts arma,
6153: ce_bank_acct_uses_ou_v aba,
6154: ce_bank_accounts cba,
6155: ar_receipt_classes arc
6156: WHERE arm.receipt_method_id = rcrm.receipt_method_id
6157: AND arm.receipt_method_id = arma.receipt_method_id
6158: AND arm.receipt_class_id = arc.receipt_class_id