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,
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,
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,
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 );
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,
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,
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,
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 );
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,
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,
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,
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;