APPS.AR_IREC_PAYMENTS dependencies on AR_SYSTEM_PARAMETERS

Line 519: FROM ar_system_parameters sp,

515:
516: CURSOR payment_method_info_cur IS
517: SELECT rm.receipt_method_id receipt_method_id, rm.payment_channel_code payment_channel_code,
518: rc.creation_status receipt_creation_status
519: FROM ar_system_parameters sp,
520: ar_receipt_classes rc,
521: ar_receipt_methods rm
522: WHERE rm.receipt_method_id = decode(p_payment_instrument, /* J Rautiainen ACH Implementation */
523: 'BANK_ACCOUNT', sp.irec_ba_receipt_method_id, /* J Rautiainen ACH Implementation */

Line 1087: | - a payment method has been defined in AR_SYSTEM_PARAMETERS

1083: |
1084: | - payment button is enabled via function security
1085: | (need to define function)
1086: | - the remaining balance of the payment schedule is > 0
1087: | - a payment method has been defined in AR_SYSTEM_PARAMETERS
1088: | for credit card payments
1089: | - a bank account assignment in the currency of the invoice
1090: | exists and is active.
1091: |

Line 5940: -- verify that Credit Card payment method is set up in AR_SYSTEM_PARAMETERS

5936: end if;
5937:
5938: /* Default behavior, as no Credit Card Payment method is mentioned in the OIR_CC_PMT_METHOD profile */
5939:
5940: -- verify that Credit Card payment method is set up in AR_SYSTEM_PARAMETERS
5941: -- Bug 3886652 - Customer Id and Customer Site Use Id added as params to ARI_CONFIG.save_payment_instrument_info
5942: SELECT /*+ leading(rc) */ count(irec_cc_receipt_method_id)
5943: INTO system_cc_payment_method
5944: FROM ar_system_parameters sp,

Line 5944: FROM ar_system_parameters sp,

5940: -- verify that Credit Card payment method is set up in AR_SYSTEM_PARAMETERS
5941: -- Bug 3886652 - Customer Id and Customer Site Use Id added as params to ARI_CONFIG.save_payment_instrument_info
5942: SELECT /*+ leading(rc) */ count(irec_cc_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,

Line 6127: -- verify that Bank Account payment method is set up in AR_SYSTEM_PARAMETERS

6123: end if;
6124:
6125: /* Default behavior, as no Bank Account Payment method is mentioned in the OIR_BA_PMT_METHOD profile */
6126:
6127: -- verify that Bank Account payment method is set up in AR_SYSTEM_PARAMETERS
6128:
6129: SELECT count(irec_ba_receipt_method_id) /* J Rautiainen ACH Implementation */
6130: INTO system_bank_payment_method
6131: FROM ar_system_parameters sp,

Line 6131: FROM ar_system_parameters sp,

6127: -- verify that Bank Account payment method is set up in AR_SYSTEM_PARAMETERS
6128:
6129: SELECT count(irec_ba_receipt_method_id) /* J Rautiainen ACH Implementation */
6130: INTO system_bank_payment_method
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

Line 6146: -- verify that Bank Account payment method is set up in AR_SYSTEM_PARAMETERS

6142: AND sysdate < nvl(ba.end_date, SYSDATE+1)
6143: AND sysdate between rma.start_date and nvl(rma.end_date, SYSDATE)
6144: AND sysdate between rm.start_date and NVL(rm.end_date, SYSDATE);
6145:
6146: -- verify that Bank Account payment method is set up in AR_SYSTEM_PARAMETERS
6147:
6148: SELECT count ( arm.receipt_method_id )
6149: INTO customer_bank_payment_method
6150: FROM ar_receipt_methods arm,