1 PACKAGE ARP_LOCKBOX_PKG AS
2 /* $Header: ARLBPIMS.pls 120.2 2005/10/30 04:23:51 appldev ship $ */
3 --
4 /* Bugfix 2284014 */
5 PROCEDURE lock_trans_data(
6 p_row_id IN VARCHAR2,
7 p_transmission_record_id IN NUMBER,
8 p_lockbox_number IN VARCHAR2,
9 p_batch_name IN VARCHAR2,
10 p_item_number IN VARCHAR2,
11 p_check_number IN VARCHAR2,
12 p_overflow_sequence IN NUMBER,
13 p_record_type IN VARCHAR2,
14 p_comments IN VARCHAR2,
15 p_origination IN VARCHAR2,
16 p_destination_account IN VARCHAR2,
17 p_deposit_date IN DATE,
18 p_gl_date IN DATE,
19 p_deposit_time IN VARCHAR2,
20 p_currency_code IN VARCHAR2,
21 p_exchange_rate_type IN VARCHAR2,
22 p_exchange_rate IN NUMBER,
23 p_transmission_record_count IN NUMBER,
24 p_transmission_amount IN NUMBER,
25 p_lockbox_batch_count IN NUMBER,
26 p_lockbox_amount IN NUMBER,
27 p_lockbox_record_count IN NUMBER,
28 p_batch_record_count IN NUMBER,
29 p_batch_amount IN NUMBER,
30 p_transferred_receipt_count IN NUMBER,
31 p_transferred_receipt_amount IN NUMBER,
32 p_overflow_indicator IN VARCHAR2,
33 p_receipt_date IN DATE,
34 p_receipt_method IN VARCHAR2,
35 p_receipt_method_id IN NUMBER,
36 p_remittance_amount IN NUMBER,
37 p_customer_number IN VARCHAR2,
38 p_customer_id IN NUMBER,
39 p_bill_to_location IN VARCHAR2,
40 p_customer_site_use_id IN NUMBER,
41 p_transit_routing_number IN VARCHAR2,
42 p_account IN VARCHAR2,
43 p_customer_bank_account_id IN NUMBER,
44 p_amount_applied1 IN NUMBER,
45 p_invoice1 IN VARCHAR2,
46 p_invoice1_installment IN NUMBER,
47 p_invoice1_status IN VARCHAR2,
48 p_amount_applied2 IN NUMBER,
49 p_invoice2 IN VARCHAR2,
50 p_invoice2_installment IN NUMBER,
51 p_invoice2_status IN VARCHAR2,
52 p_amount_applied3 IN NUMBER,
53 p_invoice3 IN VARCHAR2,
54 p_invoice3_installment IN NUMBER,
55 p_invoice3_status IN VARCHAR2,
56 p_amount_applied4 IN NUMBER,
57 p_invoice4 IN VARCHAR2,
58 p_invoice4_installment IN NUMBER,
59 p_invoice4_status IN VARCHAR2,
60 p_amount_applied5 IN NUMBER,
61 p_invoice5 IN VARCHAR2,
62 p_invoice5_installment IN NUMBER,
63 p_invoice5_status IN VARCHAR2,
64 p_amount_applied6 IN NUMBER,
65 p_invoice6 IN VARCHAR2,
66 p_invoice6_installment IN NUMBER,
67 p_invoice6_status IN VARCHAR2,
68 p_amount_applied7 IN NUMBER,
69 p_invoice7 IN VARCHAR2,
70 p_invoice7_installment IN NUMBER,
71 p_invoice7_status IN VARCHAR2,
72 p_amount_applied8 IN NUMBER,
73 p_invoice8 IN VARCHAR2,
74 p_invoice8_installment IN NUMBER,
75 p_invoice8_status IN VARCHAR2,
76 p_attribute1 IN VARCHAR2,
77 p_attribute2 IN VARCHAR2,
78 p_attribute3 IN VARCHAR2,
79 p_attribute4 IN VARCHAR2,
80 p_attribute5 IN VARCHAR2,
81 p_attribute6 IN VARCHAR2,
82 p_attribute7 IN VARCHAR2,
83 p_attribute8 IN VARCHAR2,
84 p_attribute9 IN VARCHAR2,
85 p_attribute10 IN VARCHAR2,
86 p_attribute11 IN VARCHAR2,
87 p_attribute12 IN VARCHAR2,
88 p_attribute13 IN VARCHAR2,
89 p_attribute14 IN VARCHAR2,
90 p_attribute15 IN VARCHAR2,
91 p_status IN VARCHAR2,
92 p_matching1_date IN DATE,
93 p_matching2_date IN DATE,
94 p_matching3_date IN DATE,
95 p_matching4_date IN DATE,
96 p_matching5_date IN DATE,
97 p_matching6_date IN DATE,
98 p_matching7_date IN DATE,
99 p_matching8_date IN DATE,
100 p_amount_applied_from1 IN NUMBER,
101 p_trans_to_receipt_rate1 IN NUMBER,
102 p_invoice_currency_code1 IN VARCHAR2,
103 p_amount_applied_from2 IN NUMBER,
104 p_trans_to_receipt_rate2 IN NUMBER,
105 p_invoice_currency_code2 IN VARCHAR2,
106 p_amount_applied_from3 IN NUMBER,
107 p_trans_to_receipt_rate3 IN NUMBER,
108 p_invoice_currency_code3 IN VARCHAR2,
109 p_amount_applied_from4 IN NUMBER,
110 p_trans_to_receipt_rate4 IN NUMBER,
111 p_invoice_currency_code4 IN VARCHAR2,
112 p_amount_applied_from5 IN NUMBER,
113 p_trans_to_receipt_rate5 IN NUMBER,
114 p_invoice_currency_code5 IN VARCHAR2,
115 p_amount_applied_from6 IN NUMBER,
116 p_trans_to_receipt_rate6 IN NUMBER,
117 p_invoice_currency_code6 IN VARCHAR2,
118 p_amount_applied_from7 IN NUMBER,
119 p_trans_to_receipt_rate7 IN NUMBER,
120 p_invoice_currency_code7 IN VARCHAR2,
121 p_amount_applied_from8 IN NUMBER,
122 p_trans_to_receipt_rate8 IN NUMBER,
123 p_invoice_currency_code8 IN VARCHAR2,
124 p_ussgl_transaction_code IN VARCHAR2,
125 p_ussgl_transaction_code1 IN VARCHAR2,
126 p_ussgl_transaction_code2 IN VARCHAR2,
127 p_ussgl_transaction_code3 IN VARCHAR2,
128 p_ussgl_transaction_code4 IN VARCHAR2,
129 p_ussgl_transaction_code5 IN VARCHAR2,
130 p_ussgl_transaction_code6 IN VARCHAR2,
131 p_ussgl_transaction_code7 IN VARCHAR2,
132 p_ussgl_transaction_code8 IN VARCHAR2
133 );
134 --
135 PROCEDURE update_trans_data(
136 p_transmission_record_id IN NUMBER,
137 p_lockbox_number IN VARCHAR2,
138 p_batch_name IN VARCHAR2,
139 p_item_number IN VARCHAR2,
140 p_check_number IN VARCHAR2,
141 p_overflow_sequence IN NUMBER,
142 p_record_type IN VARCHAR2,
143 p_comments IN VARCHAR2,
144 p_origination IN VARCHAR2,
145 p_destination_account IN VARCHAR2,
146 p_deposit_date IN DATE,
147 p_gl_date IN DATE,
148 p_deposit_time IN VARCHAR2,
149 p_currency_code IN VARCHAR2,
150 p_exchange_rate_type IN VARCHAR2,
151 p_exchange_rate IN NUMBER,
152 p_transmission_record_count IN NUMBER,
153 p_transmission_amount IN NUMBER,
154 p_lockbox_batch_count IN NUMBER,
155 p_lockbox_amount IN NUMBER,
156 p_lockbox_record_count IN NUMBER,
157 p_batch_record_count IN NUMBER,
158 p_batch_amount IN NUMBER,
159 p_transferred_receipt_count IN NUMBER,
160 p_transferred_receipt_amount IN NUMBER,
161 p_overflow_indicator IN VARCHAR2,
162 p_receipt_date IN DATE,
163 p_receipt_method IN VARCHAR2,
164 p_receipt_method_id IN NUMBER,
165 p_remittance_amount IN NUMBER,
166 p_customer_number IN VARCHAR2,
167 p_customer_id IN NUMBER,
168 p_bill_to_location IN VARCHAR2,
169 p_customer_site_use_id IN NUMBER,
170 p_transit_routing_number IN VARCHAR2,
171 p_account IN VARCHAR2,
172 p_customer_bank_account_id IN NUMBER,
173 p_amount_applied1 IN NUMBER,
174 p_invoice1 IN VARCHAR2,
175 p_invoice1_installment IN NUMBER,
176 p_invoice1_status IN VARCHAR2,
177 p_amount_applied2 IN NUMBER,
178 p_invoice2 IN VARCHAR2,
179 p_invoice2_installment IN NUMBER,
180 p_invoice2_status IN VARCHAR2,
181 p_amount_applied3 IN NUMBER,
182 p_invoice3 IN VARCHAR2,
183 p_invoice3_installment IN NUMBER,
184 p_invoice3_status IN VARCHAR2,
185 p_amount_applied4 IN NUMBER,
186 p_invoice4 IN VARCHAR2,
187 p_invoice4_installment IN NUMBER,
188 p_invoice4_status IN VARCHAR2,
189 p_amount_applied5 IN NUMBER,
190 p_invoice5 IN VARCHAR2,
191 p_invoice5_installment IN NUMBER,
192 p_invoice5_status IN VARCHAR2,
193 p_amount_applied6 IN NUMBER,
194 p_invoice6 IN VARCHAR2,
195 p_invoice6_installment IN NUMBER,
196 p_invoice6_status IN VARCHAR2,
197 p_amount_applied7 IN NUMBER,
198 p_invoice7 IN VARCHAR2,
199 p_invoice7_installment IN NUMBER,
200 p_invoice7_status IN VARCHAR2,
201 p_amount_applied8 IN NUMBER,
202 p_invoice8 IN VARCHAR2,
203 p_invoice8_installment IN NUMBER,
204 p_invoice8_status IN VARCHAR2,
205 p_attribute1 IN VARCHAR2,
206 p_attribute2 IN VARCHAR2,
207 p_attribute3 IN VARCHAR2,
208 p_attribute4 IN VARCHAR2,
209 p_attribute5 IN VARCHAR2,
210 p_attribute6 IN VARCHAR2,
211 p_attribute7 IN VARCHAR2,
212 p_attribute8 IN VARCHAR2,
213 p_attribute9 IN VARCHAR2,
214 p_attribute10 IN VARCHAR2,
215 p_attribute11 IN VARCHAR2,
216 p_attribute12 IN VARCHAR2,
217 p_attribute13 IN VARCHAR2,
218 p_attribute14 IN VARCHAR2,
219 p_attribute15 IN VARCHAR2,
220 p_status IN VARCHAR2,
221 p_matching1_date IN DATE,
222 p_matching2_date IN DATE,
223 p_matching3_date IN DATE,
224 p_matching4_date IN DATE,
225 p_matching5_date IN DATE,
226 p_matching6_date IN DATE,
227 p_matching7_date IN DATE,
228 p_matching8_date IN DATE,
229 p_amount_applied_from1 IN NUMBER,
230 p_trans_to_receipt_rate1 IN NUMBER,
231 p_invoice_currency_code1 IN VARCHAR2,
232 p_amount_applied_from2 IN NUMBER,
233 p_trans_to_receipt_rate2 IN NUMBER,
234 p_invoice_currency_code2 IN VARCHAR2,
235 p_amount_applied_from3 IN NUMBER,
236 p_trans_to_receipt_rate3 IN NUMBER,
237 p_invoice_currency_code3 IN VARCHAR2,
238 p_amount_applied_from4 IN NUMBER,
239 p_trans_to_receipt_rate4 IN NUMBER,
240 p_invoice_currency_code4 IN VARCHAR2,
241 p_amount_applied_from5 IN NUMBER,
242 p_trans_to_receipt_rate5 IN NUMBER,
243 p_invoice_currency_code5 IN VARCHAR2,
244 p_amount_applied_from6 IN NUMBER,
245 p_trans_to_receipt_rate6 IN NUMBER,
246 p_invoice_currency_code6 IN VARCHAR2,
247 p_amount_applied_from7 IN NUMBER,
248 p_trans_to_receipt_rate7 IN NUMBER,
249 p_invoice_currency_code7 IN VARCHAR2,
250 p_amount_applied_from8 IN NUMBER,
251 p_trans_to_receipt_rate8 IN NUMBER,
252 p_invoice_currency_code8 IN VARCHAR2,
253 p_ussgl_transaction_code IN VARCHAR2,
254 p_ussgl_transaction_code1 IN VARCHAR2,
255 p_ussgl_transaction_code2 IN VARCHAR2,
256 p_ussgl_transaction_code3 IN VARCHAR2,
257 p_ussgl_transaction_code4 IN VARCHAR2,
258 p_ussgl_transaction_code5 IN VARCHAR2,
259 p_ussgl_transaction_code6 IN VARCHAR2,
260 p_ussgl_transaction_code7 IN VARCHAR2,
261 p_ussgl_transaction_code8 IN VARCHAR2
262 );
263 --
264 PROCEDURE delete_trans_data(
265 p_transmission_record_id IN NUMBER );
266 --
267 FUNCTION get_lb_num(p_transmission_id number,
268 p_batch_name varchar2,
269 p_item_num number)
270 RETURN VARCHAR2;
271 --
272 FUNCTION get_batch_name(p_transmission_id number,
273 p_lockbox_number varchar2,
274 p_item_num number)
275 RETURN VARCHAR2;
276 --
277 END ARP_LOCKBOX_PKG;