[Home] [Help]
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,
260 p_global_attribute12 IN
261 ar_interim_cash_receipt_lines.global_attribute12%TYPE,
262 p_global_attribute13 IN
263 ar_interim_cash_receipt_lines.global_attribute13%TYPE,
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;