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.
PACKAGE: APPS.ARP_RW_ICR_PKG

Source


1 PACKAGE ARP_RW_ICR_PKG AUTHID CURRENT_USER AS
2 /* $Header: ARERICRS.pls 120.3.12010000.2 2009/02/02 16:47:22 mpsingh ship $ */
3 --
4 PROCEDURE get_applied_amount_total(
5 	    p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
6             p_applied_amount_total OUT NOCOPY ar_interim_cash_receipts.amount%TYPE,
7             p_applied_count_total OUT NOCOPY NUMBER,
8             p_module_name  IN VARCHAR2,
9             p_module_version IN VARCHAR2 );
10 --
11 PROCEDURE insert_row(
12          p_row_id   IN OUT NOCOPY VARCHAR2,
13          p_cr_id   IN OUT NOCOPY ar_interim_cash_receipts.cash_receipt_id%TYPE,
14          p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
15          p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
16          p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,
17          p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
18          p_amount_applied IN
19                     ar_interim_cash_receipts.amount_applied%TYPE,
20          p_trans_to_receipt_rate IN
21                     ar_interim_cash_receipts.trans_to_receipt_rate%TYPE,
22 	 p_factor_discount_amount IN
23 		   ar_interim_cash_receipts.factor_discount_amount%TYPE,
24          p_receipt_method_id IN
25                 ar_interim_cash_receipts.receipt_method_id%TYPE,
26          p_remittance_bank_account_id IN
27                 ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
28          p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
29          p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
30          p_payment_schedule_id IN
31                      ar_payment_schedules.payment_schedule_id%TYPE,
32          p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,
33          p_exchange_rate IN ar_interim_cash_receipts.exchange_rate%TYPE,
34          p_exchange_rate_type IN
35                 ar_interim_cash_receipts.exchange_rate_type%TYPE,
36          p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
37          p_anticipated_clearing_date IN
38 	   ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
39          p_pay_from_customer IN
40                 ar_interim_cash_receipts.pay_from_customer%TYPE,
41 	 p_customer_bank_account_id IN
42 	   ar_interim_cash_receipts.customer_bank_account_id%TYPE,
43 	 p_customer_bank_branch_id  IN
44 	   ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
45          p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
46          p_site_use_id IN ar_interim_cash_receipts.site_use_id%TYPE,
47          p_ussgl_transaction_code IN
48                 ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
49          p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,
50          p_doc_sequence_value IN
51                         ar_interim_cash_receipts.doc_sequence_value%TYPE,
52          p_attribute_category IN
53                         ar_interim_cash_receipts.attribute_category%TYPE,
54          p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,
55          p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,
56          p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
57          p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
58          p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
59          p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
60          p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
61          p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
62          p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
63          p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
64          p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
65          p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
66          p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
67          p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,
68          p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,
69          p_application_notes IN ar_interim_cash_receipts.application_notes%TYPE,
70          p_application_ref_type IN ar_interim_cash_receipts.application_ref_type%TYPE,
71          p_customer_reference IN ar_interim_cash_receipts.customer_reference%TYPE,
72          p_customer_reason IN ar_interim_cash_receipts.customer_reason%TYPE,
73 	 p_automatch_set_id IN ar_interim_cash_receipts.automatch_set_id%TYPE,
74          p_autoapply_flag IN ar_interim_cash_receipts.autoapply_flag%TYPE,
75          p_module_name  IN VARCHAR2,
76          p_module_version IN VARCHAR2 );
77 --
78 --
79 -- Bug fix: 597519  	12/17/97
80 -- Problem: rate information is not being passed to server on commit
81 -- Changes: passing parameters exchange date, exchange rate and
82 --
83 PROCEDURE update_row(
84             p_row_id   IN VARCHAR2,
85             p_cr_id   IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
86             p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
87             p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
88             p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
89             p_amount_applied IN
90                        ar_interim_cash_receipts.amount_applied%TYPE,
91             p_trans_to_receipt_rate IN
92                        ar_interim_cash_receipts.trans_to_receipt_rate%TYPE,
93 	    p_factor_discount_amount IN
94 			ar_interim_cash_receipts.factor_discount_amount%TYPE,
95             p_receipt_method_id IN
96                    ar_interim_cash_receipts.receipt_method_id%TYPE,
97             p_remittance_bank_account_id IN
98                    ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
99             p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
100             p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
101             p_payment_schedule_id IN
102                         ar_payment_schedules.payment_schedule_id%TYPE,
103             p_pay_from_customer IN
104                    ar_interim_cash_receipts.pay_from_customer%TYPE,
105 	    p_customer_bank_account_id IN
106 		   ar_interim_cash_receipts.customer_bank_account_id%TYPE,
107 	    p_customer_bank_branch_id IN
108 		   ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
109             p_site_use_id IN ar_interim_cash_receipts.site_use_id%TYPE,
110             p_ussgl_transaction_code IN
111                    ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
112             p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,
113             p_doc_sequence_value IN
114                            ar_interim_cash_receipts.doc_sequence_value%TYPE,
115 	    p_anticipated_clearing_date IN
116 		   ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
117             p_attribute_category IN
118                            ar_interim_cash_receipts.attribute_category%TYPE,
119             p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,
120             p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,
121             p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
122             p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
123             p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
124             p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
125             p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
126             p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
127             p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
128             p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
129             p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
130             p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
131             p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
132             p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,
133             p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,
134 -- Bug fix: 597519 	12/17/97
135             p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,
136             p_exchange_rate IN ar_interim_cash_receipts.exchange_rate%TYPE,
137             p_exchange_rate_type IN
138                    ar_interim_cash_receipts.exchange_rate_type%TYPE,
139 -- Bug fix 750400       12/24/98
140             p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
141 -- enh 2074220
142             p_application_notes IN ar_interim_cash_receipts.application_notes%TYPE,
143 -- Bug 2707190 additions
144             p_application_ref_type IN ar_interim_cash_receipts.application_ref_type%TYPE,
145             p_customer_reference IN ar_interim_cash_receipts.customer_reference%TYPE,
146             p_customer_reason IN ar_interim_cash_receipts.customer_reason%TYPE,
147 	    p_automatch_set_id IN ar_interim_cash_receipts.automatch_set_id%TYPE,
148             p_autoapply_flag IN ar_interim_cash_receipts.autoapply_flag%TYPE,
149             p_module_name  IN VARCHAR2,
150             p_module_version IN VARCHAR2 );
151 PROCEDURE check_unique_receipt(
152             p_row_id IN VARCHAR2,
153             p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
154             p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
155             p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
156             p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
157             p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
158 	    p_factor_discount_amount IN ar_interim_cash_receipts.factor_discount_amount%TYPE,
159             p_module_name  IN VARCHAR2,
160             p_module_version IN VARCHAR2 );
161 --
162 PROCEDURE check_no_lines_exists(
163             p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
164             p_module_name  IN VARCHAR2,
165             p_module_version IN VARCHAR2 );
166 --
167 FUNCTION  lines_exists(
171 --
168             p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
169             p_module_name  IN VARCHAR2,
170             p_module_version IN VARCHAR2 ) RETURN BOOLEAN;
172 PROCEDURE delete_row(
173             p_row_id   IN VARCHAR2,
174             p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
175             p_module_name  IN VARCHAR2,
176             p_module_version IN VARCHAR2 );
177 --
178 PROCEDURE lock_row(
179            p_row_id   VARCHAR2,
180            p_cr_id   ar_interim_cash_receipts.cash_receipt_id%TYPE,
181            p_special_type ar_interim_cash_receipts.special_type%TYPE,
182            p_receipt_number ar_interim_cash_receipts.receipt_number%TYPE,
183            p_currency_code ar_interim_cash_receipts.currency_code%TYPE,
184            p_receipt_amount ar_interim_cash_receipts.amount%TYPE,
185 	   p_factor_discount_amount IN
186 	         ar_interim_cash_receipts.factor_discount_amount%TYPE,
187            p_receipt_method_id
188                    ar_interim_cash_receipts.receipt_method_id%TYPE,
189            p_remittance_bank_account_id
190                   ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
191            p_batch_id ar_interim_cash_receipts.batch_id%TYPE,
192            p_customer_trx_id ar_interim_cash_receipts.customer_trx_id%TYPE,
193            p_payment_schedule_id
194                        ar_payment_schedules.payment_schedule_id%TYPE,
195            p_exchange_date ar_interim_cash_receipts.exchange_date%TYPE,
196            p_exchange_rate ar_interim_cash_receipts.exchange_rate%TYPE,
197            p_exchange_rate_type
198                    ar_interim_cash_receipts.exchange_rate_type%TYPE,
199            p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
200 	   p_anticipated_clearing_date IN
201 		   ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
202            p_pay_from_customer
203                   ar_interim_cash_receipts.pay_from_customer%TYPE,
204 	   p_customer_bank_account_id IN
205 	          ar_interim_cash_receipts.customer_bank_account_id%TYPE,
206 	   p_customer_bank_branch_id IN
207 		   ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
208            p_receipt_date ar_interim_cash_receipts.receipt_date%TYPE,
209            p_site_use_id ar_interim_cash_receipts.site_use_id%TYPE,
210            p_ussgl_transaction_code
211                   ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
212            p_doc_sequence_id ar_interim_cash_receipts.doc_sequence_id%TYPE,
213            p_doc_sequence_value
214                            ar_interim_cash_receipts.doc_sequence_value%TYPE,
215            p_attribute_category
216                            ar_interim_cash_receipts.attribute_category%TYPE,
217            p_attribute1 ar_interim_cash_receipts.attribute1%TYPE,
218            p_attribute2 ar_interim_cash_receipts.attribute2%TYPE,
219            p_attribute3 ar_interim_cash_receipts.attribute3%TYPE,
220            p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,
221            p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,
222            p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,
223            p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,
224            p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,
225            p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,
226            p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,
227            p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,
228            p_attribute12 ar_interim_cash_receipts.attribute12%TYPE,
229            p_attribute13 ar_interim_cash_receipts.attribute13%TYPE,
230            p_attribute14 ar_interim_cash_receipts.attribute14%TYPE,
231            p_attribute15 ar_interim_cash_receipts.attribute15%TYPE);
232 END ARP_RW_ICR_PKG;