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_LINES_PKG

Source


1 PACKAGE ARP_RW_ICR_LINES_PKG AUTHID CURRENT_USER AS
2 /* $Header: ARERICLS.pls 115.5 2003/02/28 22:05:56 djancis ship $ */
3 --
4 PROCEDURE insert_row(
5             p_row_id   IN OUT NOCOPY VARCHAR2,
6             p_icr_line_id   IN OUT NOCOPY
7                       ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
8             p_cr_id    IN ar_interim_cash_receipt_lines.cash_receipt_id%TYPE,
9             p_payment_amount IN
10                        ar_interim_cash_receipt_lines.payment_amount%TYPE,
11             p_amount_applied_from IN
12                        ar_interim_cash_receipt_lines.amount_applied_from%TYPE,
13             p_trans_to_receipt_rate IN
14                        ar_interim_cash_receipt_lines.trans_to_receipt_rate%TYPE,
15             p_payment_schedule_id IN
16                         ar_payment_schedules.payment_schedule_id%TYPE,
17             p_customer_trx_id IN
18                    ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
19             p_batch_id IN ar_interim_cash_receipt_lines.batch_id%TYPE,
20             p_sold_to_customer IN
21                    ar_interim_cash_receipt_lines.sold_to_customer%TYPE,
22             p_discount_taken IN
23                    ar_interim_cash_receipt_lines.discount_taken%TYPE,
24             p_due_date IN ar_interim_cash_receipt_lines.due_date%TYPE,
25             p_ussgl_transaction_code IN
26                    ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
27             p_attribute_category IN
28                       ar_interim_cash_receipt_lines.attribute_category%TYPE,
29             p_attribute1 IN ar_interim_cash_receipt_lines.attribute1%TYPE,
30             p_attribute2 IN ar_interim_cash_receipt_lines.attribute2%TYPE,
31             p_attribute3 IN ar_interim_cash_receipt_lines.attribute3%TYPE,
32             p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%TYPE,
33             p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%TYPE,
34             p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%TYPE,
35             p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%TYPE,
36             p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%TYPE,
37             p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%TYPE,
38             p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%TYPE,
39             p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%TYPE,
40             p_attribute12 IN ar_interim_cash_receipt_lines.attribute12%TYPE,
41             p_attribute13 IN ar_interim_cash_receipt_lines.attribute13%TYPE,
42             p_attribute14 IN ar_interim_cash_receipt_lines.attribute14%TYPE,
43             p_attribute15 IN ar_interim_cash_receipt_lines.attribute15%TYPE,
44 	    p_global_attribute_category IN
45   	        ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
46 	    p_global_attribute1 IN
47 		ar_interim_cash_receipt_lines.global_attribute1%TYPE,
48             p_global_attribute2 IN
49                 ar_interim_cash_receipt_lines.global_attribute2%TYPE,
50             p_global_attribute3 IN
51                 ar_interim_cash_receipt_lines.global_attribute3%TYPE,
52             p_global_attribute4 IN
53                 ar_interim_cash_receipt_lines.global_attribute4%TYPE,
54             p_global_attribute5 IN
55                 ar_interim_cash_receipt_lines.global_attribute5%TYPE,
56             p_global_attribute6 IN
57                 ar_interim_cash_receipt_lines.global_attribute6%TYPE,
58             p_global_attribute7 IN
59                 ar_interim_cash_receipt_lines.global_attribute7%TYPE,
60             p_global_attribute8 IN
61                 ar_interim_cash_receipt_lines.global_attribute8%TYPE,
62             p_global_attribute9 IN
63                 ar_interim_cash_receipt_lines.global_attribute9%TYPE,
64             p_global_attribute10 IN
65                 ar_interim_cash_receipt_lines.global_attribute10%TYPE,
66             p_global_attribute11 IN
67                 ar_interim_cash_receipt_lines.global_attribute11%TYPE,
68             p_global_attribute12 IN
69                 ar_interim_cash_receipt_lines.global_attribute12%TYPE,
70             p_global_attribute13 IN
71                 ar_interim_cash_receipt_lines.global_attribute13%TYPE,
72             p_global_attribute14 IN
73                 ar_interim_cash_receipt_lines.global_attribute14%TYPE,
74             p_global_attribute15 IN
75                 ar_interim_cash_receipt_lines.global_attribute15%TYPE,
76             p_global_attribute16 IN
77                 ar_interim_cash_receipt_lines.global_attribute16%TYPE,
78             p_global_attribute17 IN
79                 ar_interim_cash_receipt_lines.global_attribute17%TYPE,
80             p_global_attribute18 IN
81                 ar_interim_cash_receipt_lines.global_attribute18%TYPE,
82             p_global_attribute19 IN
83                 ar_interim_cash_receipt_lines.global_attribute19%TYPE,
84             p_global_attribute20 IN
85                 ar_interim_cash_receipt_lines.global_attribute20%TYPE,
86             p_application_ref_type IN
87                 ar_interim_cash_receipt_lines.application_ref_type%TYPE,
88             p_customer_reference IN
89                 ar_interim_cash_receipt_lines.customer_reference%TYPE,
90             p_customer_reason IN
91                 ar_interim_cash_receipt_lines.customer_reason%TYPE,
92             p_applied_rec_app_id IN
93                 ar_interim_cash_receipt_lines.applied_rec_app_id%TYPE,
94             p_module_name  IN VARCHAR2,
95             p_module_version IN VARCHAR2 );
96 --
97 PROCEDURE update_row(
98             p_row_id   IN VARCHAR2,
99             p_icr_line_id   IN
100                     ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
101             p_cr_id   IN
102                     ar_interim_cash_receipt_lines.cash_receipt_id%TYPE,
103             p_payment_amount IN
104                        ar_interim_cash_receipt_lines.payment_amount%TYPE,
105             p_amount_applied_from IN
106                        ar_interim_cash_receipt_lines.amount_applied_from%TYPE,
107             p_trans_to_receipt_rate IN
108                        ar_interim_cash_receipt_lines.trans_to_receipt_rate%TYPE,
109             p_payment_schedule_id IN
110                         ar_payment_schedules.payment_schedule_id%TYPE,
111             p_customer_trx_id IN
112                    ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
113             p_batch_id IN ar_interim_cash_receipt_lines.batch_id%TYPE,
114             p_sold_to_customer IN
115                    ar_interim_cash_receipt_lines.sold_to_customer%TYPE,
116             p_discount_taken IN
117                    ar_interim_cash_receipt_lines.discount_taken%TYPE,
118             p_due_date IN ar_interim_cash_receipt_lines.due_date%TYPE,
119             p_ussgl_transaction_code IN
120                    ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
121             p_attribute_category IN
122                         ar_interim_cash_receipt_lines.attribute_category%TYPE,
123             p_attribute1 IN ar_interim_cash_receipt_lines.attribute1%TYPE,
124             p_attribute2 IN ar_interim_cash_receipt_lines.attribute2%TYPE,
125             p_attribute3 IN ar_interim_cash_receipt_lines.attribute3%TYPE,
126             p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%TYPE,
127             p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%TYPE,
128             p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%TYPE,
129             p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%TYPE,
130             p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%TYPE,
131             p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%TYPE,
132             p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%TYPE,
133             p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%TYPE,
134             p_attribute12 IN ar_interim_cash_receipt_lines.attribute12%TYPE,
135             p_attribute13 IN ar_interim_cash_receipt_lines.attribute13%TYPE,
136             p_attribute14 IN ar_interim_cash_receipt_lines.attribute14%TYPE,
137             p_attribute15 IN ar_interim_cash_receipt_lines.attribute15%TYPE,
138             p_global_attribute_category IN
139                 ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
140             p_global_attribute1 IN
141                 ar_interim_cash_receipt_lines.global_attribute1%TYPE,
142             p_global_attribute2 IN
143                 ar_interim_cash_receipt_lines.global_attribute2%TYPE,
144             p_global_attribute3 IN
145                 ar_interim_cash_receipt_lines.global_attribute3%TYPE,
146             p_global_attribute4 IN
147                 ar_interim_cash_receipt_lines.global_attribute4%TYPE,
148             p_global_attribute5 IN
149                 ar_interim_cash_receipt_lines.global_attribute5%TYPE,
150             p_global_attribute6 IN
151                 ar_interim_cash_receipt_lines.global_attribute6%TYPE,
152             p_global_attribute7 IN
153                 ar_interim_cash_receipt_lines.global_attribute7%TYPE,
154             p_global_attribute8 IN
155                 ar_interim_cash_receipt_lines.global_attribute8%TYPE,
156             p_global_attribute9 IN
157                 ar_interim_cash_receipt_lines.global_attribute9%TYPE,
158             p_global_attribute10 IN
159                 ar_interim_cash_receipt_lines.global_attribute10%TYPE,
160             p_global_attribute11 IN
161                 ar_interim_cash_receipt_lines.global_attribute11%TYPE,
162             p_global_attribute12 IN
163                 ar_interim_cash_receipt_lines.global_attribute12%TYPE,
164             p_global_attribute13 IN
165                 ar_interim_cash_receipt_lines.global_attribute13%TYPE,
166             p_global_attribute14 IN
167                 ar_interim_cash_receipt_lines.global_attribute14%TYPE,
168             p_global_attribute15 IN
169                 ar_interim_cash_receipt_lines.global_attribute15%TYPE,
170             p_global_attribute16 IN
171                 ar_interim_cash_receipt_lines.global_attribute16%TYPE,
172             p_global_attribute17 IN
173                 ar_interim_cash_receipt_lines.global_attribute17%TYPE,
174             p_global_attribute18 IN
175                 ar_interim_cash_receipt_lines.global_attribute18%TYPE,
176             p_global_attribute19 IN
177                 ar_interim_cash_receipt_lines.global_attribute19%TYPE,
178             p_global_attribute20 IN
179                 ar_interim_cash_receipt_lines.global_attribute20%TYPE,
180             p_application_ref_type IN
181                 ar_interim_cash_receipt_lines.application_ref_type%TYPE,
182             p_customer_reference IN
183                 ar_interim_cash_receipt_lines.customer_reference%TYPE,
184             p_customer_reason IN
185                 ar_interim_cash_receipt_lines.customer_reason%TYPE,
186             p_applied_rec_app_id IN
187                 ar_interim_cash_receipt_lines.applied_rec_app_id%TYPE,
188             p_module_name  IN VARCHAR2,
189             p_module_version IN VARCHAR2 );
190 --
191 PROCEDURE delete_row(
192             p_row_id   IN VARCHAR2,
193             p_icr_id   IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
194             p_icr_line_id   IN
195                     ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
196             p_module_name  IN VARCHAR2,
197             p_module_version IN VARCHAR2 );
198 --
199 PROCEDURE lock_row(
200             p_row_id   VARCHAR2,
201             p_icr_id
202               ar_interim_cash_receipt_lines.cash_receipt_id%TYPE,
203             p_icr_line_id
204               ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
205             p_payment_amount
206               ar_interim_cash_receipt_lines.payment_amount%TYPE,
207             p_payment_schedule_id
208               ar_payment_schedules.payment_schedule_id%TYPE,
209             p_customer_trx_id
210               ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
211             p_batch_id ar_interim_cash_receipt_lines.batch_id%TYPE,
212             p_sold_to_customer
213               ar_interim_cash_receipt_lines.sold_to_customer%TYPE,
214             p_discount_taken
215               ar_interim_cash_receipt_lines.discount_taken%TYPE,
216             p_due_date ar_interim_cash_receipt_lines.due_date%TYPE,
217             p_ussgl_transaction_code
218               ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
219             p_attribute_category
220               ar_interim_cash_receipt_lines.attribute_category%TYPE,
221             p_attribute1 ar_interim_cash_receipt_lines.attribute1%TYPE,
222             p_attribute2 ar_interim_cash_receipt_lines.attribute2%TYPE,
223             p_attribute3 ar_interim_cash_receipt_lines.attribute3%TYPE,
224             p_attribute4 ar_interim_cash_receipt_lines.attribute4%TYPE,
225             p_attribute5 ar_interim_cash_receipt_lines.attribute5%TYPE,
226             p_attribute6 ar_interim_cash_receipt_lines.attribute6%TYPE,
227             p_attribute7 ar_interim_cash_receipt_lines.attribute7%TYPE,
228             p_attribute8 ar_interim_cash_receipt_lines.attribute8%TYPE,
229             p_attribute9 ar_interim_cash_receipt_lines.attribute9%TYPE,
230             p_attribute10 ar_interim_cash_receipt_lines.attribute10%TYPE,
231             p_attribute11 ar_interim_cash_receipt_lines.attribute11%TYPE,
232             p_attribute12 ar_interim_cash_receipt_lines.attribute12%TYPE,
233             p_attribute13 ar_interim_cash_receipt_lines.attribute13%TYPE,
234             p_attribute14 ar_interim_cash_receipt_lines.attribute14%TYPE,
235             p_attribute15 ar_interim_cash_receipt_lines.attribute15%TYPE,
236             p_global_attribute_category IN
237                 ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
238             p_global_attribute1 IN
239                 ar_interim_cash_receipt_lines.global_attribute1%TYPE,
240             p_global_attribute2 IN
241                 ar_interim_cash_receipt_lines.global_attribute2%TYPE,
242             p_global_attribute3 IN
243                 ar_interim_cash_receipt_lines.global_attribute3%TYPE,
244             p_global_attribute4 IN
245                 ar_interim_cash_receipt_lines.global_attribute4%TYPE,
246             p_global_attribute5 IN
247                 ar_interim_cash_receipt_lines.global_attribute5%TYPE,
248             p_global_attribute6 IN
249                 ar_interim_cash_receipt_lines.global_attribute6%TYPE,
250             p_global_attribute7 IN
251                 ar_interim_cash_receipt_lines.global_attribute7%TYPE,
252             p_global_attribute8 IN
253                 ar_interim_cash_receipt_lines.global_attribute8%TYPE,
254             p_global_attribute9 IN
255                 ar_interim_cash_receipt_lines.global_attribute9%TYPE,
256             p_global_attribute10 IN
257                 ar_interim_cash_receipt_lines.global_attribute10%TYPE,
258             p_global_attribute11 IN
259                 ar_interim_cash_receipt_lines.global_attribute11%TYPE,
263                 ar_interim_cash_receipt_lines.global_attribute13%TYPE,
260             p_global_attribute12 IN
261                 ar_interim_cash_receipt_lines.global_attribute12%TYPE,
262             p_global_attribute13 IN
264             p_global_attribute14 IN
265                 ar_interim_cash_receipt_lines.global_attribute14%TYPE,
266             p_global_attribute15 IN
267                 ar_interim_cash_receipt_lines.global_attribute15%TYPE,
268             p_global_attribute16 IN
269                 ar_interim_cash_receipt_lines.global_attribute16%TYPE,
270             p_global_attribute17 IN
271                 ar_interim_cash_receipt_lines.global_attribute17%TYPE,
272             p_global_attribute18 IN
273                 ar_interim_cash_receipt_lines.global_attribute18%TYPE,
274             p_global_attribute19 IN
275                 ar_interim_cash_receipt_lines.global_attribute19%TYPE,
276             p_global_attribute20 IN
277                 ar_interim_cash_receipt_lines.global_attribute20%TYPE
278 );
279 --
280 END ARP_RW_ICR_LINES_PKG;