eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_PREPAYMENTS dependencies on AR_CASH_RECEIPTS

Line 138: FROM ar_cash_receipts cr1

134: WHERE
135: EXISTS
136: (
137: SELECT 1
138: FROM ar_cash_receipts cr1
139: WHERE cr1.cash_receipt_id = p_cash_receipt_id
140: AND cr1.reversal_date is not null
141: );
142: EXCEPTION

Line 177: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,

173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
175: p_commit IN VARCHAR2 := FND_API.G_FALSE,
176: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
177: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
178: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
179: p_receivable_application_id IN ar_receivable_applications.
180: receivable_application_id%TYPE DEFAULT NULL,
181: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,

Line 178: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,

174: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
175: p_commit IN VARCHAR2 := FND_API.G_FALSE,
176: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
177: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
178: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
179: p_receivable_application_id IN ar_receivable_applications.
180: receivable_application_id%TYPE DEFAULT NULL,
181: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
182: p_refund_amount IN ar_receivable_applications.amount_applied%TYPE

Line 721: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,

717: x_msg_count OUT NOCOPY NUMBER,
718: x_msg_data OUT NOCOPY VARCHAR2,
719: -- Receipt info. parameters
720: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
721: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
722: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
723: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
724: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
725: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,

Line 723: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,

719: -- Receipt info. parameters
720: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
721: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
722: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
723: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
724: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
725: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
726: p_amount IN ar_cash_receipts.amount%TYPE,
727: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,

Line 724: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,

720: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
721: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
722: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
723: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
724: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
725: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
726: p_amount IN ar_cash_receipts.amount%TYPE,
727: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
728:

Line 725: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,

721: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
722: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
723: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
724: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
725: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
726: p_amount IN ar_cash_receipts.amount%TYPE,
727: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
728:
729: --Bug 3106245

Line 726: p_amount IN ar_cash_receipts.amount%TYPE,

722: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
723: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
724: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
725: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
726: p_amount IN ar_cash_receipts.amount%TYPE,
727: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
728:
729: --Bug 3106245
730: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,

Line 727: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,

723: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
724: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
725: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
726: p_amount IN ar_cash_receipts.amount%TYPE,
727: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
728:
729: --Bug 3106245
730: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
731:

Line 730: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,

726: p_amount IN ar_cash_receipts.amount%TYPE,
727: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
728:
729: --Bug 3106245
730: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
731:
732: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
733: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
734: p_maturity_date IN DATE DEFAULT NULL,

Line 732: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,

728:
729: --Bug 3106245
730: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
731:
732: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
733: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
734: p_maturity_date IN DATE DEFAULT NULL,
735: p_postmark_date IN DATE DEFAULT NULL,
736: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,

Line 736: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,

732: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
733: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
734: p_maturity_date IN DATE DEFAULT NULL,
735: p_postmark_date IN DATE DEFAULT NULL,
736: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
737: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
738: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
739: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL,
740: p_customer_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE DEFAULT NULL,

Line 739: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL,

735: p_postmark_date IN DATE DEFAULT NULL,
736: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
737: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
738: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
739: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL,
740: p_customer_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
741: p_customer_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
742: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
743: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,

Line 744: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,

740: p_customer_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
741: p_customer_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
742: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
743: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
744: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
745: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
746: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,
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,

Line 745: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,

741: p_customer_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
742: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
743: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
744: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
745: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
746: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,
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,

Line 746: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,

742: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
743: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
744: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
745: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
746: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,
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,

Line 749: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,

745: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
746: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,
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,

Line 750: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,

746: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,
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,

Line 753: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%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,
756: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type
757: DEFAULT ar_receipt_api_pub.attribute_rec_const,

Line 754: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_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,
756: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type
757: DEFAULT ar_receipt_api_pub.attribute_rec_const,
758: -- ******* Global Flexfield parameters *******

Line 763: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,

759: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type
760: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
761: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
762: -- *** Notes Receivable Additional Information ***
763: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
764: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
765: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
766: -- ** OUT NOCOPY variables for Creating receipt
767: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,

Line 764: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,

760: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
761: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
762: -- *** Notes Receivable Additional Information ***
763: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
764: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
765: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
766: -- ** OUT NOCOPY variables for Creating receipt
767: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
768: -- Receipt application parameters

Line 765: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,

761: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
762: -- *** Notes Receivable Additional Information ***
763: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
764: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
765: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
766: -- ** OUT NOCOPY variables for Creating receipt
767: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
768: -- Receipt application parameters
769: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,

Line 767: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,

763: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
764: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
765: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
766: -- ** OUT NOCOPY variables for Creating receipt
767: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
768: -- Receipt application parameters
769: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
770: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
771: p_application_ref_type IN VARCHAR2 DEFAULT NULL,

Line 789: p_payment_server_order_num IN OUT NOCOPY ar_cash_receipts.payment_server_order_num%TYPE,

785: app_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type
786: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
787: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
788: -- processor such as iPayments
789: p_payment_server_order_num IN OUT NOCOPY ar_cash_receipts.payment_server_order_num%TYPE,
790: p_approval_code IN OUT NOCOPY ar_cash_receipts.approval_code%TYPE,
791: --- Bug: 3220078 Change the p_call_payment_processor to TRUE ---
792: p_call_payment_processor IN VARCHAR2 DEFAULT FND_API.G_TRUE,
793:

Line 790: p_approval_code IN OUT NOCOPY ar_cash_receipts.approval_code%TYPE,

786: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
787: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
788: -- processor such as iPayments
789: p_payment_server_order_num IN OUT NOCOPY ar_cash_receipts.payment_server_order_num%TYPE,
790: p_approval_code IN OUT NOCOPY ar_cash_receipts.approval_code%TYPE,
791: --- Bug: 3220078 Change the p_call_payment_processor to TRUE ---
792: p_call_payment_processor IN VARCHAR2 DEFAULT FND_API.G_TRUE,
793:
794: p_payment_response_error_code OUT NOCOPY VARCHAR2,

Line 799: p_payment_trxn_extension_id IN ar_cash_receipts.payment_trxn_extension_id%TYPE

795: -- OUT NOCOPY parameter for the Application
796: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
797: p_payment_set_id IN OUT NOCOPY NUMBER,
798: p_org_id IN NUMBER DEFAULT NULL,
799: p_payment_trxn_extension_id IN ar_cash_receipts.payment_trxn_extension_id%TYPE
800: ) IS
801:
802: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
803: l_org_id NUMBER;

Line 802: l_receipt_number ar_cash_receipts.receipt_number%TYPE;

798: p_org_id IN NUMBER DEFAULT NULL,
799: p_payment_trxn_extension_id IN ar_cash_receipts.payment_trxn_extension_id%TYPE
800: ) IS
801:
802: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
803: l_org_id NUMBER;
804: l_org_return_status VARCHAR2(1);
805:
806:

Line 966: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,

962: x_msg_count OUT NOCOPY NUMBER,
963: x_msg_data OUT NOCOPY VARCHAR2,
964: p_prepay_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
965: p_number_of_refund_receipts OUT NOCOPY NUMBER,
966: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
967: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
968: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
969: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
970: p_refund_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,

Line 967: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,

963: x_msg_data OUT NOCOPY VARCHAR2,
964: p_prepay_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
965: p_number_of_refund_receipts OUT NOCOPY NUMBER,
966: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
967: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
968: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
969: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
970: p_refund_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
971: p_refund_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,

Line 990: FROM ar_receivable_applications ra , ar_cash_receipts cr

986: c_bank_account_id IN NUMBER) IS
987: SELECT ra.cash_receipt_id,
988: SUM(DECODE(ra.status,'OTHER ACC',DECODE(applied_payment_schedule_id,
989: -7,NVL(nvl(ra.amount_applied_from, ra.amount_applied),0),0),0)) prepayment_amount
990: FROM ar_receivable_applications ra , ar_cash_receipts cr
991: WHERE ra.payment_set_id= c_payment_set_id
992: AND cr.cash_receipt_id = ra.cash_receipt_id
993: AND ra.display = 'Y'
994: AND decode(c_receipt_method_id, null,'1',cr.receipt_method_id ) =

Line 1141: from ar_receipt_methods rm , ar_cash_receipts cr

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-------

Line 1239: from ar_cash_receipts_all cr, ar_receivable_applications ra

1235: /*--------------------------------------
1236: Check if payment set id is valid
1237: ---------------------------------------*/
1238: select count(*) into l_dummy
1239: from ar_cash_receipts_all cr, ar_receivable_applications ra
1240: where ra.payment_set_id= l_payment_set_id
1241: AND cr.cash_receipt_id = ra.cash_receipt_id;
1242:
1243: if l_dummy = 0 then

Line 1266: from ar_cash_receipts_all cr, ar_receivable_applications ra

1262: /*--------------------------------------
1263: Check if t_bank_account_id is valid
1264: ---------------------------------------*/
1265: select count(*) into l_dummy
1266: from ar_cash_receipts_all cr, ar_receivable_applications ra
1267: where ra.payment_set_id= l_payment_set_id
1268: AND cr.cash_receipt_id = ra.cash_receipt_id
1269: and cr.customer_bank_account_id = t_bank_account_id;
1270:

Line 1295: from ar_cash_receipts_all cr, ar_receivable_applications ra

1291: /*--------------------------------------
1292: Check if t_receipt_method_id is valid
1293: ---------------------------------------*/
1294: select count(*) into l_dummy
1295: from ar_cash_receipts_all cr, ar_receivable_applications ra
1296: where ra.payment_set_id= l_payment_set_id
1297: AND cr.cash_receipt_id = ra.cash_receipt_id
1298: and cr.receipt_method_id = t_receipt_method_id;
1299:

Line 1317: FROM ar_receivable_applications ra , ar_cash_receipts cr

1313: SELECT
1314: SUM(DECODE(ra.status,'OTHER ACC',DECODE(applied_payment_schedule_id,
1315: -7,NVL(nvl(ra.amount_applied_from, ra.amount_applied),0),0),0)) max_refund_amt
1316: into l_max_refund_amt
1317: FROM ar_receivable_applications ra , ar_cash_receipts cr
1318: WHERE ra.payment_set_id= l_payment_set_id
1319: AND cr.cash_receipt_id = ra.cash_receipt_id
1320: AND ra.display = 'Y'
1321: AND decode(t_receipt_method_id, null,'1',cr.receipt_method_id ) =

Line 1349: ar_cash_receipts cr,

1345: sum(DECODE(rm.payment_channel_code, 'CREDIT_CARD', 1, 0))
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