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.ARP_RW_ICR_REMIT_PKG dependencies on AR_CASH_REMIT_REFS_ALL

Line 5: P_REMIT_REFERENCE_ID IN ar_cash_remit_refs_all.REMIT_REFERENCE_ID%TYPE,

1: PACKAGE ARP_RW_ICR_REMIT_PKG AUTHID CURRENT_USER AS
2: /* $Header: ARICRRLS.pls 120.0.12010000.2 2009/02/25 16:57:55 mpsingh noship $ */
3: --
4: PROCEDURE insert_row(
5: P_REMIT_REFERENCE_ID IN ar_cash_remit_refs_all.REMIT_REFERENCE_ID%TYPE,
6: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,
7: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
8: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
9: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,

Line 6: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,

2: /* $Header: ARICRRLS.pls 120.0.12010000.2 2009/02/25 16:57:55 mpsingh noship $ */
3: --
4: PROCEDURE insert_row(
5: P_REMIT_REFERENCE_ID IN ar_cash_remit_refs_all.REMIT_REFERENCE_ID%TYPE,
6: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,
7: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
8: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
9: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
10: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,

Line 7: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,

3: --
4: PROCEDURE insert_row(
5: P_REMIT_REFERENCE_ID IN ar_cash_remit_refs_all.REMIT_REFERENCE_ID%TYPE,
6: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,
7: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
8: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
9: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
10: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
11: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,

Line 8: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,

4: PROCEDURE insert_row(
5: P_REMIT_REFERENCE_ID IN ar_cash_remit_refs_all.REMIT_REFERENCE_ID%TYPE,
6: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,
7: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
8: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
9: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
10: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
11: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
12: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,

Line 9: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,

5: P_REMIT_REFERENCE_ID IN ar_cash_remit_refs_all.REMIT_REFERENCE_ID%TYPE,
6: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,
7: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
8: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
9: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
10: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
11: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
12: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
13: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,

Line 10: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,

6: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,
7: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
8: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
9: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
10: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
11: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
12: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
13: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
14: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,

Line 11: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,

7: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
8: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
9: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
10: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
11: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
12: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
13: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
14: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
15: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,

Line 12: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,

8: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
9: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
10: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
11: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
12: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
13: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
14: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
15: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
16: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,

Line 13: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,

9: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
10: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
11: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
12: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
13: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
14: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
15: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
16: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
17: -- P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,

Line 14: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,

10: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
11: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
12: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
13: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
14: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
15: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
16: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
17: -- P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
18: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,

Line 15: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,

11: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
12: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
13: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
14: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
15: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
16: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
17: -- P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
18: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
19: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,

Line 16: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,

12: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
13: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
14: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
15: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
16: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
17: -- P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
18: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
19: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
20: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,

Line 17: -- P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,

13: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
14: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
15: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
16: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
17: -- P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
18: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
19: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
20: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
21: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,

Line 18: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,

14: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
15: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
16: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
17: -- P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
18: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
19: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
20: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
21: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
22: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,

Line 19: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,

15: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
16: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
17: -- P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
18: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
19: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
20: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
21: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
22: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
23: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,

Line 20: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,

16: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
17: -- P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
18: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
19: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
20: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
21: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
22: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
23: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
24: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,

Line 21: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,

17: -- P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
18: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
19: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
20: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
21: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
22: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
23: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
24: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
25: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,

Line 22: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,

18: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
19: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
20: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
21: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
22: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
23: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
24: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
25: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
26: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,

Line 23: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,

19: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
20: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
21: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
22: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
23: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
24: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
25: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
26: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
27: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,

Line 24: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,

20: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
21: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
22: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
23: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
24: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
25: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
26: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
27: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
28: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,

Line 25: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,

21: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
22: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
23: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
24: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
25: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
26: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
27: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
28: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
29: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,

Line 26: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,

22: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
23: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
24: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
25: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
26: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
27: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
28: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
29: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
30: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,

Line 27: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,

23: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
24: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
25: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
26: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
27: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
28: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
29: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
30: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
31: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,

Line 28: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,

24: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
25: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
26: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
27: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
28: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
29: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
30: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
31: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
32: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,

Line 29: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,

25: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
26: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
27: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
28: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
29: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
30: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
31: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
32: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,
33: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,

Line 30: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,

26: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
27: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
28: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
29: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
30: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
31: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
32: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,
33: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,
34: P_REQUEST_ID IN ar_cash_remit_refs_all.REQUEST_ID%TYPE,

Line 31: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,

27: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
28: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
29: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
30: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
31: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
32: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,
33: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,
34: P_REQUEST_ID IN ar_cash_remit_refs_all.REQUEST_ID%TYPE,
35: P_BATCH_ID IN NUMBER DEFAULT NULL

Line 32: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,

28: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
29: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
30: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
31: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
32: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,
33: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,
34: P_REQUEST_ID IN ar_cash_remit_refs_all.REQUEST_ID%TYPE,
35: P_BATCH_ID IN NUMBER DEFAULT NULL
36: );

Line 33: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,

29: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
30: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
31: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
32: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,
33: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,
34: P_REQUEST_ID IN ar_cash_remit_refs_all.REQUEST_ID%TYPE,
35: P_BATCH_ID IN NUMBER DEFAULT NULL
36: );
37: --

Line 34: P_REQUEST_ID IN ar_cash_remit_refs_all.REQUEST_ID%TYPE,

30: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
31: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
32: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,
33: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,
34: P_REQUEST_ID IN ar_cash_remit_refs_all.REQUEST_ID%TYPE,
35: P_BATCH_ID IN NUMBER DEFAULT NULL
36: );
37: --
38: PROCEDURE update_row(

Line 39: P_REMIT_REFERENCE_ID IN ar_cash_remit_refs_all.REMIT_REFERENCE_ID%TYPE,

35: P_BATCH_ID IN NUMBER DEFAULT NULL
36: );
37: --
38: PROCEDURE update_row(
39: P_REMIT_REFERENCE_ID IN ar_cash_remit_refs_all.REMIT_REFERENCE_ID%TYPE,
40: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,
41: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
42: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
43: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,

Line 40: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,

36: );
37: --
38: PROCEDURE update_row(
39: P_REMIT_REFERENCE_ID IN ar_cash_remit_refs_all.REMIT_REFERENCE_ID%TYPE,
40: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,
41: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
42: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
43: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
44: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,

Line 41: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,

37: --
38: PROCEDURE update_row(
39: P_REMIT_REFERENCE_ID IN ar_cash_remit_refs_all.REMIT_REFERENCE_ID%TYPE,
40: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,
41: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
42: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
43: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
44: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
45: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,

Line 42: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,

38: PROCEDURE update_row(
39: P_REMIT_REFERENCE_ID IN ar_cash_remit_refs_all.REMIT_REFERENCE_ID%TYPE,
40: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,
41: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
42: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
43: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
44: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
45: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
46: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,

Line 43: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,

39: P_REMIT_REFERENCE_ID IN ar_cash_remit_refs_all.REMIT_REFERENCE_ID%TYPE,
40: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,
41: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
42: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
43: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
44: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
45: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
46: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
47: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,

Line 44: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,

40: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,
41: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
42: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
43: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
44: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
45: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
46: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
47: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
48: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,

Line 45: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,

41: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
42: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
43: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
44: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
45: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
46: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
47: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
48: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
49: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,

Line 46: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,

42: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
43: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
44: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
45: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
46: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
47: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
48: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
49: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
50: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,

Line 47: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,

43: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
44: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
45: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
46: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
47: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
48: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
49: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
50: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
51: -- P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,

Line 48: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,

44: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
45: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
46: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
47: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
48: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
49: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
50: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
51: -- P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
52: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,

Line 49: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,

45: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
46: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
47: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
48: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
49: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
50: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
51: -- P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
52: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
53: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,

Line 50: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,

46: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
47: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
48: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
49: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
50: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
51: -- P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
52: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
53: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
54: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,

Line 51: -- P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,

47: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
48: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
49: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
50: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
51: -- P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
52: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
53: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
54: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
55: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,

Line 52: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,

48: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
49: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
50: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
51: -- P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
52: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
53: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
54: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
55: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
56: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,

Line 53: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,

49: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
50: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
51: -- P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
52: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
53: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
54: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
55: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
56: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
57: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,

Line 54: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,

50: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
51: -- P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
52: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
53: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
54: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
55: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
56: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
57: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
58: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,

Line 55: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,

51: -- P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
52: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
53: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
54: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
55: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
56: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
57: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
58: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
59: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,

Line 56: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,

52: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
53: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
54: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
55: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
56: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
57: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
58: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
59: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
60: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,

Line 57: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,

53: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
54: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
55: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
56: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
57: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
58: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
59: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
60: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
61: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,

Line 58: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,

54: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
55: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
56: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
57: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
58: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
59: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
60: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
61: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
62: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,

Line 59: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,

55: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
56: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
57: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
58: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
59: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
60: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
61: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
62: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
63: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,

Line 60: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,

56: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
57: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
58: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
59: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
60: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
61: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
62: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
63: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
64: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,

Line 61: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,

57: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
58: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
59: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
60: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
61: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
62: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
63: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
64: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
65: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,

Line 62: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,

58: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
59: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
60: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
61: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
62: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
63: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
64: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
65: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
66: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,

Line 63: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,

59: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
60: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
61: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
62: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
63: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
64: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
65: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
66: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,
67: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,

Line 64: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,

60: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
61: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
62: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
63: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
64: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
65: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
66: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,
67: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,
68: P_REQUEST_ID IN ar_cash_remit_refs_all.REQUEST_ID%TYPE );

Line 65: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,

61: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
62: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
63: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
64: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
65: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
66: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,
67: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,
68: P_REQUEST_ID IN ar_cash_remit_refs_all.REQUEST_ID%TYPE );
69: --

Line 66: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,

62: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
63: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
64: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
65: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
66: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,
67: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,
68: P_REQUEST_ID IN ar_cash_remit_refs_all.REQUEST_ID%TYPE );
69: --
70: PROCEDURE delete_row(

Line 67: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,

63: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
64: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
65: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
66: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,
67: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,
68: P_REQUEST_ID IN ar_cash_remit_refs_all.REQUEST_ID%TYPE );
69: --
70: PROCEDURE delete_row(
71: p_rr_id IN ar_cash_remit_refs_all.remit_reference_id%TYPE

Line 68: P_REQUEST_ID IN ar_cash_remit_refs_all.REQUEST_ID%TYPE );

64: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
65: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
66: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,
67: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,
68: P_REQUEST_ID IN ar_cash_remit_refs_all.REQUEST_ID%TYPE );
69: --
70: PROCEDURE delete_row(
71: p_rr_id IN ar_cash_remit_refs_all.remit_reference_id%TYPE
72: );

Line 71: p_rr_id IN ar_cash_remit_refs_all.remit_reference_id%TYPE

67: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,
68: P_REQUEST_ID IN ar_cash_remit_refs_all.REQUEST_ID%TYPE );
69: --
70: PROCEDURE delete_row(
71: p_rr_id IN ar_cash_remit_refs_all.remit_reference_id%TYPE
72: );
73: --
74: PROCEDURE lock_row(
75: P_REMIT_REFERENCE_ID IN ar_cash_remit_refs_all.REMIT_REFERENCE_ID%TYPE,

Line 75: P_REMIT_REFERENCE_ID IN ar_cash_remit_refs_all.REMIT_REFERENCE_ID%TYPE,

71: p_rr_id IN ar_cash_remit_refs_all.remit_reference_id%TYPE
72: );
73: --
74: PROCEDURE lock_row(
75: P_REMIT_REFERENCE_ID IN ar_cash_remit_refs_all.REMIT_REFERENCE_ID%TYPE,
76: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,
77: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
78: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
79: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,

Line 76: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,

72: );
73: --
74: PROCEDURE lock_row(
75: P_REMIT_REFERENCE_ID IN ar_cash_remit_refs_all.REMIT_REFERENCE_ID%TYPE,
76: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,
77: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
78: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
79: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
80: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,

Line 77: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,

73: --
74: PROCEDURE lock_row(
75: P_REMIT_REFERENCE_ID IN ar_cash_remit_refs_all.REMIT_REFERENCE_ID%TYPE,
76: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,
77: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
78: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
79: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
80: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
81: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,

Line 78: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,

74: PROCEDURE lock_row(
75: P_REMIT_REFERENCE_ID IN ar_cash_remit_refs_all.REMIT_REFERENCE_ID%TYPE,
76: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,
77: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
78: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
79: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
80: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
81: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
82: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,

Line 79: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,

75: P_REMIT_REFERENCE_ID IN ar_cash_remit_refs_all.REMIT_REFERENCE_ID%TYPE,
76: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,
77: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
78: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
79: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
80: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
81: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
82: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
83: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,

Line 80: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,

76: P_AUTOMATCH_SET_ID IN ar_cash_remit_refs_all.AUTOMATCH_SET_ID%TYPE,
77: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
78: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
79: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
80: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
81: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
82: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
83: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
84: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,

Line 81: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,

77: P_CASH_RECEIPT_ID IN ar_cash_remit_refs_all.CASH_RECEIPT_ID%TYPE,
78: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
79: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
80: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
81: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
82: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
83: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
84: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
85: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,

Line 82: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,

78: P_LINE_NUMBER IN ar_cash_remit_refs_all.LINE_NUMBER%TYPE,
79: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
80: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
81: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
82: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
83: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
84: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
85: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
86: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,

Line 83: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,

79: P_REFERENCE_SOURCE IN ar_cash_remit_refs_all.REFERENCE_SOURCE%TYPE,
80: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
81: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
82: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
83: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
84: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
85: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
86: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
87: -- P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,

Line 84: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,

80: P_CUSTOMER_ID IN ar_cash_remit_refs_all.CUSTOMER_ID%TYPE,
81: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
82: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
83: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
84: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
85: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
86: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
87: -- P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
88: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,

Line 85: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,

81: P_CUSTOMER_NUMBER IN ar_cash_remit_refs_all.CUSTOMER_NUMBER%TYPE,
82: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
83: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
84: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
85: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
86: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
87: -- P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
88: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
89: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,

Line 86: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,

82: P_BANK_ACCOUNT_NUMBER IN ar_cash_remit_refs_all.BANK_ACCOUNT_NUMBER%TYPE,
83: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
84: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
85: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
86: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
87: -- P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
88: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
89: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
90: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,

Line 87: -- P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,

83: P_TRANSIT_ROUTING_NUMBER IN ar_cash_remit_refs_all.TRANSIT_ROUTING_NUMBER%TYPE,
84: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
85: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
86: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
87: -- P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
88: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
89: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
90: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
91: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,

Line 88: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,

84: P_INVOICE_REFERENCE IN ar_cash_remit_refs_all.INVOICE_REFERENCE%TYPE,
85: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
86: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
87: -- P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
88: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
89: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
90: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
91: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
92: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,

Line 89: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,

85: P_MATCHING_REFERENCE_DATE IN ar_cash_remit_refs_all.MATCHING_REFERENCE_DATE%TYPE,
86: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
87: -- P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
88: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
89: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
90: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
91: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
92: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
93: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,

Line 90: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,

86: P_RESOLVED_MATCHING_NUMBER IN ar_cash_remit_refs_all.RESOLVED_MATCHING_NUMBER%TYPE,
87: -- P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
88: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
89: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
90: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
91: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
92: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
93: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
94: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,

Line 91: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,

87: -- P_RESOLVED_MATCHING_INSTALLMENT IN ar_cash_remit_refs_all.RESOLVED_MATCHING_INSTALLMENT%TYPE,
88: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
89: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
90: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
91: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
92: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
93: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
94: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
95: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,

Line 92: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,

88: P_RESOLVED_MATCHING_DATE IN ar_cash_remit_refs_all.RESOLVED_MATCHING_DATE%TYPE,
89: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
90: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
91: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
92: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
93: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
94: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
95: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
96: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,

Line 93: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,

89: P_INVOICE_CURRENCY_CODE IN ar_cash_remit_refs_all.INVOICE_CURRENCY_CODE%TYPE,
90: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
91: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
92: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
93: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
94: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
95: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
96: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
97: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,

Line 94: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,

90: P_AMOUNT_APPLIED IN ar_cash_remit_refs_all.AMOUNT_APPLIED%TYPE,
91: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
92: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
93: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
94: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
95: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
96: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
97: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
98: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,

Line 95: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,

91: P_AMOUNT_APPLIED_FROM IN ar_cash_remit_refs_all.AMOUNT_APPLIED_FROM%TYPE,
92: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
93: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
94: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
95: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
96: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
97: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
98: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
99: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,

Line 96: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,

92: P_TRANS_TO_RECEIPT_RATE IN ar_cash_remit_refs_all.TRANS_TO_RECEIPT_RATE%TYPE,
93: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
94: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
95: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
96: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
97: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
98: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
99: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
100: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,

Line 97: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,

93: P_INVOICE_STATUS IN ar_cash_remit_refs_all.INVOICE_STATUS%TYPE,
94: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
95: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
96: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
97: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
98: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
99: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
100: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
101: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,

Line 98: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,

94: P_MATCH_RESOLVED_USING IN ar_cash_remit_refs_all.MATCH_RESOLVED_USING%TYPE,
95: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
96: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
97: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
98: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
99: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
100: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
101: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
102: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,

Line 99: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,

95: P_CUSTOMER_TRX_ID IN ar_cash_remit_refs_all.CUSTOMER_TRX_ID%TYPE,
96: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
97: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
98: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
99: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
100: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
101: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
102: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,
103: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,

Line 100: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,

96: P_PAYMENT_SCHEDULE_ID IN ar_cash_remit_refs_all.PAYMENT_SCHEDULE_ID%TYPE,
97: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
98: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
99: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
100: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
101: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
102: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,
103: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,
104: P_REQUEST_ID IN ar_cash_remit_refs_all.REQUEST_ID%TYPE );

Line 101: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,

97: P_CUSTOMER_REFERENCE IN ar_cash_remit_refs_all.CUSTOMER_REFERENCE%TYPE,
98: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
99: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
100: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
101: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
102: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,
103: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,
104: P_REQUEST_ID IN ar_cash_remit_refs_all.REQUEST_ID%TYPE );
105: END ARP_RW_ICR_REMIT_PKG;

Line 102: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,

98: P_AUTO_APPLIED IN ar_cash_remit_refs_all.AUTO_APPLIED%TYPE,
99: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
100: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
101: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
102: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,
103: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,
104: P_REQUEST_ID IN ar_cash_remit_refs_all.REQUEST_ID%TYPE );
105: END ARP_RW_ICR_REMIT_PKG;

Line 103: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,

99: P_MANUALLY_APPLIED IN ar_cash_remit_refs_all.MANUALLY_APPLIED%TYPE,
100: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
101: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
102: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,
103: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,
104: P_REQUEST_ID IN ar_cash_remit_refs_all.REQUEST_ID%TYPE );
105: END ARP_RW_ICR_REMIT_PKG;

Line 104: P_REQUEST_ID IN ar_cash_remit_refs_all.REQUEST_ID%TYPE );

100: P_INSTALLMENT_NUMBER IN ar_cash_remit_refs_all.INSTALLMENT_NUMBER%TYPE,
101: P_PROGRAM_APPLICATION_ID IN ar_cash_remit_refs_all.PROGRAM_APPLICATION_ID%TYPE,
102: P_PROGRAM_ID IN ar_cash_remit_refs_all.PROGRAM_ID%TYPE,
103: P_PROGRAM_UPDATE_DATE IN ar_cash_remit_refs_all.PROGRAM_UPDATE_DATE%TYPE,
104: P_REQUEST_ID IN ar_cash_remit_refs_all.REQUEST_ID%TYPE );
105: END ARP_RW_ICR_REMIT_PKG;