APPS.AR_IREC_PAYMENTS dependencies on AR_SYSTEM_PARAMETERS

Line 512: FROM ar_system_parameters sp,

508:
509: CURSOR payment_method_info_cur IS
510: SELECT rm.receipt_method_id receipt_method_id, rm.payment_channel_code payment_channel_code,
511: rc.creation_status receipt_creation_status
512: FROM ar_system_parameters sp,
513: ar_receipt_classes rc,
514: ar_receipt_methods rm
515: WHERE rm.receipt_method_id = decode(p_payment_instrument, /* J Rautiainen ACH Implementation */
516: 'BANK_ACCOUNT', sp.irec_ba_receipt_method_id, /* J Rautiainen ACH Implementation */

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

1015: |
1016: | - payment button is enabled via function security
1017: | (need to define function)
1018: | - the remaining balance of the payment schedule is > 0
1019: | - a payment method has been defined in AR_SYSTEM_PARAMETERS
1020: | for credit card payments
1021: | - a bank account assignment in the currency of the invoice
1022: | exists and is active.
1023: |

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

5291: end if;
5292:
5293: /* Default behavior, as no Credit Card Payment method is mentioned in the OIR_CC_PMT_METHOD profile */
5294:
5295: -- verify that Credit Card payment method is set up in AR_SYSTEM_PARAMETERS
5296: -- Bug 3886652 - Customer Id and Customer Site Use Id added as params to ARI_CONFIG.save_payment_instrument_info
5297: SELECT /*+ leading(rc) */ count(irec_cc_receipt_method_id)
5298: INTO system_cc_payment_method
5299: FROM ar_system_parameters sp,

Line 5299: FROM ar_system_parameters sp,

5295: -- verify that Credit Card payment method is set up in AR_SYSTEM_PARAMETERS
5296: -- Bug 3886652 - Customer Id and Customer Site Use Id added as params to ARI_CONFIG.save_payment_instrument_info
5297: SELECT /*+ leading(rc) */ count(irec_cc_receipt_method_id)
5298: INTO system_cc_payment_method
5299: FROM ar_system_parameters sp,
5300: ar_receipt_methods rm,
5301: ar_receipt_method_accounts rma,
5302: ce_bank_accounts cba,
5303: ce_bank_acct_uses_ou_v ba,

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

5476: end if;
5477:
5478: /* Default behavior, as no Bank Account Payment method is mentioned in the OIR_BA_PMT_METHOD profile */
5479:
5480: -- verify that Bank Account payment method is set up in AR_SYSTEM_PARAMETERS
5481:
5482: SELECT count(irec_ba_receipt_method_id) /* J Rautiainen ACH Implementation */
5483: INTO system_bank_payment_method
5484: FROM ar_system_parameters sp,

Line 5484: FROM ar_system_parameters sp,

5480: -- verify that Bank Account payment method is set up in AR_SYSTEM_PARAMETERS
5481:
5482: SELECT count(irec_ba_receipt_method_id) /* J Rautiainen ACH Implementation */
5483: INTO system_bank_payment_method
5484: FROM ar_system_parameters sp,
5485: ar_receipt_methods rm,
5486: ar_receipt_method_accounts rma,
5487: ce_bank_acct_uses_ou_v ba,
5488: ce_bank_accounts cba

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

5495: AND sysdate < nvl(ba.end_date, SYSDATE+1)
5496: AND sysdate between rma.start_date and nvl(rma.end_date, SYSDATE)
5497: AND sysdate between rm.start_date and NVL(rm.end_date, SYSDATE);
5498:
5499: -- verify that Bank Account payment method is set up in AR_SYSTEM_PARAMETERS
5500:
5501: SELECT count ( arm.receipt_method_id )
5502: INTO customer_bank_payment_method
5503: FROM ar_receipt_methods arm,