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 AS
2 /* $Header: ARERICRS.pls 120.3 2003/10/23 23:12:46 orashid 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_module_name  IN VARCHAR2,
74          p_module_version IN VARCHAR2 );
75 --
76 --
77 -- Bug fix: 597519  	12/17/97
78 -- Problem: rate information is not being passed to server on commit
79 -- Changes: passing parameters exchange date, exchange rate and
80 --
81 PROCEDURE update_row(
82             p_row_id   IN VARCHAR2,
83             p_cr_id   IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
84             p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
85             p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
86             p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
87             p_amount_applied IN
88                        ar_interim_cash_receipts.amount_applied%TYPE,
89             p_trans_to_receipt_rate IN
90                        ar_interim_cash_receipts.trans_to_receipt_rate%TYPE,
91 	    p_factor_discount_amount IN
92 			ar_interim_cash_receipts.factor_discount_amount%TYPE,
93             p_receipt_method_id IN
94                    ar_interim_cash_receipts.receipt_method_id%TYPE,
95             p_remittance_bank_account_id IN
96                    ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
97             p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
98             p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
99             p_payment_schedule_id IN
100                         ar_payment_schedules.payment_schedule_id%TYPE,
101             p_pay_from_customer IN
102                    ar_interim_cash_receipts.pay_from_customer%TYPE,
103 	    p_customer_bank_account_id IN
104 		   ar_interim_cash_receipts.customer_bank_account_id%TYPE,
105 	    p_customer_bank_branch_id IN
106 		   ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
107             p_site_use_id IN ar_interim_cash_receipts.site_use_id%TYPE,
108             p_ussgl_transaction_code IN
109                    ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
110             p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,
111             p_doc_sequence_value IN
112                            ar_interim_cash_receipts.doc_sequence_value%TYPE,
113 	    p_anticipated_clearing_date IN
114 		   ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
115             p_attribute_category IN
116                            ar_interim_cash_receipts.attribute_category%TYPE,
117             p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,
118             p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,
119             p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
120             p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
121             p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
122             p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
123             p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
124             p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
125             p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
126             p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
127             p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
128             p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
129             p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
130             p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,
131             p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,
132 -- Bug fix: 597519 	12/17/97
133             p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,
134             p_exchange_rate IN ar_interim_cash_receipts.exchange_rate%TYPE,
135             p_exchange_rate_type IN
136                    ar_interim_cash_receipts.exchange_rate_type%TYPE,
137 -- Bug fix 750400       12/24/98
138             p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
139 -- enh 2074220
140             p_application_notes IN ar_interim_cash_receipts.application_notes%TYPE,
141 -- Bug 2707190 additions
142             p_application_ref_type IN ar_interim_cash_receipts.application_ref_type%TYPE,
143             p_customer_reference IN ar_interim_cash_receipts.customer_reference%TYPE,
144             p_customer_reason IN ar_interim_cash_receipts.customer_reason%TYPE,
145             p_module_name  IN VARCHAR2,
146             p_module_version IN VARCHAR2 );
147 PROCEDURE check_unique_receipt(
148             p_row_id IN VARCHAR2,
149             p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
150             p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
151             p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
152             p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
153             p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
154 	    p_factor_discount_amount IN ar_interim_cash_receipts.factor_discount_amount%TYPE,
155             p_module_name  IN VARCHAR2,
156             p_module_version IN VARCHAR2 );
157 --
158 PROCEDURE check_no_lines_exists(
159             p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
160             p_module_name  IN VARCHAR2,
161             p_module_version IN VARCHAR2 );
162 --
163 FUNCTION  lines_exists(
164             p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
165             p_module_name  IN VARCHAR2,
166             p_module_version IN VARCHAR2 ) RETURN BOOLEAN;
167 --
168 PROCEDURE delete_row(
169             p_row_id   IN VARCHAR2,
170             p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
171             p_module_name  IN VARCHAR2,
172             p_module_version IN VARCHAR2 );
173 --
174 PROCEDURE lock_row(
175            p_row_id   VARCHAR2,
176            p_cr_id   ar_interim_cash_receipts.cash_receipt_id%TYPE,
177            p_special_type ar_interim_cash_receipts.special_type%TYPE,
178            p_receipt_number ar_interim_cash_receipts.receipt_number%TYPE,
179            p_currency_code ar_interim_cash_receipts.currency_code%TYPE,
180            p_receipt_amount ar_interim_cash_receipts.amount%TYPE,
181 	   p_factor_discount_amount IN
182 	         ar_interim_cash_receipts.factor_discount_amount%TYPE,
183            p_receipt_method_id
184                    ar_interim_cash_receipts.receipt_method_id%TYPE,
185            p_remittance_bank_account_id
186                   ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
187            p_batch_id ar_interim_cash_receipts.batch_id%TYPE,
188            p_customer_trx_id ar_interim_cash_receipts.customer_trx_id%TYPE,
189            p_payment_schedule_id
190                        ar_payment_schedules.payment_schedule_id%TYPE,
191            p_exchange_date ar_interim_cash_receipts.exchange_date%TYPE,
192            p_exchange_rate ar_interim_cash_receipts.exchange_rate%TYPE,
193            p_exchange_rate_type
194                    ar_interim_cash_receipts.exchange_rate_type%TYPE,
195            p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
196 	   p_anticipated_clearing_date IN
197 		   ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
198            p_pay_from_customer
199                   ar_interim_cash_receipts.pay_from_customer%TYPE,
200 	   p_customer_bank_account_id IN
201 	          ar_interim_cash_receipts.customer_bank_account_id%TYPE,
202 	   p_customer_bank_branch_id IN
203 		   ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
204            p_receipt_date ar_interim_cash_receipts.receipt_date%TYPE,
205            p_site_use_id ar_interim_cash_receipts.site_use_id%TYPE,
206            p_ussgl_transaction_code
207                   ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
208            p_doc_sequence_id ar_interim_cash_receipts.doc_sequence_id%TYPE,
209            p_doc_sequence_value
210                            ar_interim_cash_receipts.doc_sequence_value%TYPE,
211            p_attribute_category
212                            ar_interim_cash_receipts.attribute_category%TYPE,
213            p_attribute1 ar_interim_cash_receipts.attribute1%TYPE,
214            p_attribute2 ar_interim_cash_receipts.attribute2%TYPE,
215            p_attribute3 ar_interim_cash_receipts.attribute3%TYPE,
216            p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,
217            p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,
218            p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,
219            p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,
220            p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,
221            p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,
222            p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,
223            p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,
224            p_attribute12 ar_interim_cash_receipts.attribute12%TYPE,
225            p_attribute13 ar_interim_cash_receipts.attribute13%TYPE,
226            p_attribute14 ar_interim_cash_receipts.attribute14%TYPE,
227            p_attribute15 ar_interim_cash_receipts.attribute15%TYPE);
228 END ARP_RW_ICR_PKG;