[Home] [Help]
747: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
748: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
749: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
750: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
751: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
752: p_doc_sequence_value IN NUMBER DEFAULT NULL,
753: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
754: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE DEFAULT NULL,
755: p_called_from IN VARCHAR2 DEFAULT NULL,
1022: ------Multiple Prepayments
1023: l_total_pmt_types NUMBER := 0;
1024: l_credit_pmt_type_count NUMBER := 0;
1025: l_refund_type VARCHAR2(30) := null;
1026: l_payment_type ar_receipt_methods.PAYMENT_TYPE_CODE%TYPE;
1027: l_receipt_id_def_status VARCHAR2(1);
1028: t_bank_account_id NUMBER := null;
1029: t_receipt_method_id NUMBER := null;
1030: l_max_refund_amt NUMBER := 0;
1137: BEGIN
1138: --Check the payment_method
1139: select nvl(rm.payment_channel_code, 'CHECK')
1140: into l_payment_type
1141: from ar_receipt_methods rm , ar_cash_receipts cr
1142: WHERE cr.cash_receipt_id = l_cash_receipt_id
1143: AND cr.receipt_method_id = rm.receipt_method_id;
1144:
1145: -------------Validate the refund amount for payment_set_id-------
1346: as credit_pmt_type_count
1347: INTO l_total_pmt_types, l_credit_pmt_type_count
1348: FROM ar_receivable_applications ra,
1349: ar_cash_receipts cr,
1350: ar_receipt_methods rm
1351: WHERE ra.payment_set_id = l_payment_set_id
1352: AND ra.cash_receipt_id = cr.cash_receipt_id
1353: AND cr.receipt_method_id = rm.receipt_method_id
1354: AND decode(t_bank_account_id,null,1,cr.customer_bank_account_id ) =