[Home] [Help]
PACKAGE: APPS.AP_CHECKS_PKG
Source
1 PACKAGE AP_CHECKS_PKG as
2 /* $Header: apichecs.pls 120.9.12010000.3 2009/01/20 09:23:58 cjain ship $ */
3
4 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5 X_Amount NUMBER,
6 X_Ce_Bank_Acct_Use_Id NUMBER,
7 X_Bank_Account_Name VARCHAR2,
8 X_Check_Date DATE,
9 X_Check_Id NUMBER,
10 X_Check_Number NUMBER,
11 X_Currency_Code VARCHAR2,
12 X_Last_Updated_By NUMBER,
13 X_Last_Update_Date DATE,
14 -- X_Payment_Method_Lookup_Code VARCHAR2,
15 X_Payment_Type_Flag VARCHAR2,
16 X_Address_Line1 VARCHAR2 DEFAULT NULL,
17 X_Address_Line2 VARCHAR2 DEFAULT NULL,
18 X_Address_Line3 VARCHAR2 DEFAULT NULL,
19 X_Checkrun_Name VARCHAR2 DEFAULT NULL,
20 X_Check_Format_Id NUMBER DEFAULT NULL,
21 X_Check_Stock_Id NUMBER DEFAULT NULL,
22 X_City VARCHAR2 DEFAULT NULL,
23 X_Country VARCHAR2 DEFAULT NULL,
24 X_Created_By NUMBER DEFAULT NULL,
25 X_Creation_Date DATE DEFAULT NULL,
26 X_Last_Update_Login NUMBER DEFAULT NULL,
27 X_Status_Lookup_Code VARCHAR2 DEFAULT NULL,
28 X_Vendor_Name VARCHAR2 DEFAULT NULL,
29 X_Vendor_Site_Code VARCHAR2 DEFAULT NULL,
30 X_External_Bank_Account_Id NUMBER,
31 X_Zip VARCHAR2 DEFAULT NULL,
32 X_Bank_Account_Num VARCHAR2 DEFAULT NULL,
33 X_Bank_Account_Type VARCHAR2 DEFAULT NULL,
34 X_Bank_Num VARCHAR2 DEFAULT NULL,
35 X_Check_Voucher_Num NUMBER DEFAULT NULL,
36 X_Cleared_Amount NUMBER DEFAULT NULL,
37 X_Cleared_Date DATE DEFAULT NULL,
38 X_Doc_Category_Code VARCHAR2 DEFAULT NULL,
39 X_Doc_Sequence_Id NUMBER DEFAULT NULL,
40 X_Doc_Sequence_Value NUMBER DEFAULT NULL,
41 X_Province VARCHAR2 DEFAULT NULL,
42 X_Released_Date DATE DEFAULT NULL,
43 X_Released_By NUMBER DEFAULT NULL,
44 X_State VARCHAR2 DEFAULT NULL,
45 X_Stopped_Date DATE DEFAULT NULL,
46 X_Stopped_By NUMBER DEFAULT NULL,
47 X_Void_Date DATE DEFAULT NULL,
48 X_Attribute1 VARCHAR2 DEFAULT NULL,
49 X_Attribute10 VARCHAR2 DEFAULT NULL,
50 X_Attribute11 VARCHAR2 DEFAULT NULL,
51 X_Attribute12 VARCHAR2 DEFAULT NULL,
52 X_Attribute13 VARCHAR2 DEFAULT NULL,
53 X_Attribute14 VARCHAR2 DEFAULT NULL,
54 X_Attribute15 VARCHAR2 DEFAULT NULL,
55 X_Attribute2 VARCHAR2 DEFAULT NULL,
56 X_Attribute3 VARCHAR2 DEFAULT NULL,
57 X_Attribute4 VARCHAR2 DEFAULT NULL,
58 X_Attribute5 VARCHAR2 DEFAULT NULL,
59 X_Attribute6 VARCHAR2 DEFAULT NULL,
60 X_Attribute7 VARCHAR2 DEFAULT NULL,
61 X_Attribute8 VARCHAR2 DEFAULT NULL,
62 X_Attribute9 VARCHAR2 DEFAULT NULL,
63 X_Attribute_Category VARCHAR2 DEFAULT NULL,
64 X_Future_Pay_Due_Date DATE DEFAULT NULL,
65 X_Treasury_Pay_Date DATE DEFAULT NULL,
66 X_Treasury_Pay_Number NUMBER DEFAULT NULL,
67 -- Removed for bug 4277744
68 -- X_Ussgl_Transaction_Code VARCHAR2 DEFAULT NULL,
69 -- X_Ussgl_Trx_Code_Context VARCHAR2 DEFAULT NULL,
70 X_Withholding_Status_Lkup_Code VARCHAR2 DEFAULT NULL,
71 X_Reconciliation_Batch_Id NUMBER DEFAULT NULL,
72 X_Cleared_Base_Amount NUMBER DEFAULT NULL,
73 X_Cleared_Exchange_Rate NUMBER DEFAULT NULL,
74 X_Cleared_Exchange_Date DATE DEFAULT NULL,
75 X_Cleared_Exchange_Rate_Type VARCHAR2 DEFAULT NULL,
76 X_Address_Line4 VARCHAR2 DEFAULT NULL,
77 X_County VARCHAR2 DEFAULT NULL,
78 X_Address_Style VARCHAR2 DEFAULT NULL,
79 X_Org_Id NUMBER DEFAULT NULL,
80 X_Vendor_Id NUMBER,
81 X_Vendor_Site_Id NUMBER,
82 X_Exchange_Rate NUMBER DEFAULT NULL,
83 X_Exchange_Date DATE DEFAULT NULL,
84 X_Exchange_Rate_Type VARCHAR2 DEFAULT NULL,
85 X_Base_Amount NUMBER DEFAULT NULL,
86 X_Checkrun_Id NUMBER DEFAULT NULL,
87 X_global_attribute_category VARCHAR2 DEFAULT NULL,
88 X_global_attribute1 VARCHAR2 DEFAULT NULL,
89 X_global_attribute2 VARCHAR2 DEFAULT NULL,
90 X_global_attribute3 VARCHAR2 DEFAULT NULL,
91 X_global_attribute4 VARCHAR2 DEFAULT NULL,
92 X_global_attribute5 VARCHAR2 DEFAULT NULL,
93 X_global_attribute6 VARCHAR2 DEFAULT NULL,
94 X_global_attribute7 VARCHAR2 DEFAULT NULL,
95 X_global_attribute8 VARCHAR2 DEFAULT NULL,
96 X_global_attribute9 VARCHAR2 DEFAULT NULL,
97 X_global_attribute10 VARCHAR2 DEFAULT NULL,
98 X_global_attribute11 VARCHAR2 DEFAULT NULL,
99 X_global_attribute12 VARCHAR2 DEFAULT NULL,
100 X_global_attribute13 VARCHAR2 DEFAULT NULL,
101 X_global_attribute14 VARCHAR2 DEFAULT NULL,
102 X_global_attribute15 VARCHAR2 DEFAULT NULL,
103 X_global_attribute16 VARCHAR2 DEFAULT NULL,
104 X_global_attribute17 VARCHAR2 DEFAULT NULL,
105 X_global_attribute18 VARCHAR2 DEFAULT NULL,
106 X_global_attribute19 VARCHAR2 DEFAULT NULL,
107 X_global_attribute20 VARCHAR2 DEFAULT NULL,
108 X_transfer_priority VARCHAR2 DEFAULT NULL,
109 X_maturity_exchange_rate_type VARCHAR2 DEFAULT NULL,
110 X_maturity_exchange_date DATE DEFAULT NULL,
111 X_maturity_exchange_rate NUMBER DEFAULT NULL,
112 X_description VARCHAR2 DEFAULT NULL,
113 X_anticipated_value_date DATE DEFAULT NULL,
114 X_actual_value_date DATE DEFAULT NULL,
115 x_payment_method_code VARCHAR2 DEFAULT NULL,
116 x_payment_profile_id NUMBER DEFAULT NULL,
117 x_bank_charge_bearer VARCHAR2 DEFAULT NULL,
118 x_settlement_priority VARCHAR2 DEFAULT NULL,
119 x_payment_document_id NUMBER DEFAULT NULL,
120 x_party_id NUMBER DEFAULT NULL,
121 x_party_site_id NUMBER DEFAULT NULL,
122 x_legal_entity_id NUMBER DEFAULT NULL,
123 x_payment_id NUMBER DEFAULT NULL,
124 X_calling_sequence VARCHAR2,
125 X_Remit_To_Supplier_Name VARCHAR2 DEFAULT NULL,
126 X_Remit_To_Supplier_Id Number DEFAULT NULL,
127 X_Remit_To_Supplier_Site VARCHAR2 DEFAULT NULL,
128 X_Remit_To_Supplier_Site_Id NUMBER DEFAULT NULL,
129 X_Relationship_Id NUMBER DEFAULT NULL,
130 X_paycard_authorization_number VARCHAR2 DEFAULT NULL,
131 X_paycard_reference_id NUMBER DEFAULT NULL
132 );
133
134 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
135 X_Amount NUMBER,
136 X_Ce_Bank_Acct_Use_Id NUMBER,
137 X_Bank_Account_Name VARCHAR2,
138 X_Check_Date DATE,
139 X_Check_Id NUMBER,
140 X_Check_Number NUMBER,
141 X_Currency_Code VARCHAR2,
142 --IBY:SP X_Payment_Method_Lookup_Code VARCHAR2,
143 X_Payment_Type_Flag VARCHAR2,
144 X_Address_Line1 VARCHAR2 DEFAULT NULL,
145 X_Address_Line2 VARCHAR2 DEFAULT NULL,
146 X_Address_Line3 VARCHAR2 DEFAULT NULL,
147 X_Checkrun_Name VARCHAR2 DEFAULT NULL,
148 X_Check_Format_Id NUMBER DEFAULT NULL,
149 X_Check_Stock_Id NUMBER DEFAULT NULL,
150 X_City VARCHAR2 DEFAULT NULL,
151 X_Country VARCHAR2 DEFAULT NULL,
152 X_Status_Lookup_Code VARCHAR2 DEFAULT NULL,
153 X_Vendor_Name VARCHAR2 DEFAULT NULL,
154 X_Vendor_Site_Code VARCHAR2 DEFAULT NULL,
155 X_External_Bank_Account_Id NUMBER,
156 X_Zip VARCHAR2 DEFAULT NULL,
157 X_Bank_Account_Num VARCHAR2 DEFAULT NULL,
158 X_Bank_Account_Type VARCHAR2 DEFAULT NULL,
159 X_Bank_Num VARCHAR2 DEFAULT NULL,
160 X_Check_Voucher_Num NUMBER DEFAULT NULL,
161 X_Cleared_Amount NUMBER DEFAULT NULL,
162 X_Cleared_Date DATE DEFAULT NULL,
163 X_Doc_Category_Code VARCHAR2 DEFAULT NULL,
164 X_Doc_Sequence_Id NUMBER DEFAULT NULL,
165 X_Doc_Sequence_Value NUMBER DEFAULT NULL,
166 X_Province VARCHAR2 DEFAULT NULL,
167 X_Released_Date DATE DEFAULT NULL,
168 X_Released_By NUMBER DEFAULT NULL,
169 X_State VARCHAR2 DEFAULT NULL,
170 X_Stopped_Date DATE DEFAULT NULL,
171 X_Stopped_By NUMBER DEFAULT NULL,
172 X_Void_Date DATE DEFAULT NULL,
173 X_Attribute1 VARCHAR2 DEFAULT NULL,
174 X_Attribute10 VARCHAR2 DEFAULT NULL,
175 X_Attribute11 VARCHAR2 DEFAULT NULL,
176 X_Attribute12 VARCHAR2 DEFAULT NULL,
177 X_Attribute13 VARCHAR2 DEFAULT NULL,
178 X_Attribute14 VARCHAR2 DEFAULT NULL,
179 X_Attribute15 VARCHAR2 DEFAULT NULL,
180 X_Attribute2 VARCHAR2 DEFAULT NULL,
181 X_Attribute3 VARCHAR2 DEFAULT NULL,
182 X_Attribute4 VARCHAR2 DEFAULT NULL,
183 X_Attribute5 VARCHAR2 DEFAULT NULL,
184 X_Attribute6 VARCHAR2 DEFAULT NULL,
185 X_Attribute7 VARCHAR2 DEFAULT NULL,
186 X_Attribute8 VARCHAR2 DEFAULT NULL,
187 X_Attribute9 VARCHAR2 DEFAULT NULL,
188 X_Attribute_Category VARCHAR2 DEFAULT NULL,
189 X_Future_Pay_Due_Date DATE DEFAULT NULL,
190 X_Treasury_Pay_Date DATE DEFAULT NULL,
191 X_Treasury_Pay_Number NUMBER DEFAULT NULL,
192 -- Removed for bug 4277744
193 -- X_Ussgl_Transaction_Code VARCHAR2 DEFAULT NULL,
194 -- X_Ussgl_Trx_Code_Context VARCHAR2 DEFAULT NULL,
198 X_Cleared_Exchange_Rate NUMBER DEFAULT NULL,
195 X_Withholding_Status_Lkup_Code VARCHAR2 DEFAULT NULL,
196 X_Reconciliation_Batch_Id NUMBER DEFAULT NULL,
197 X_Cleared_Base_Amount NUMBER DEFAULT NULL,
199 X_Cleared_Exchange_Date DATE DEFAULT NULL,
200 X_Cleared_Exchange_Rate_Type VARCHAR2 DEFAULT NULL,
201 X_Address_Line4 VARCHAR2 DEFAULT NULL,
202 X_County VARCHAR2 DEFAULT NULL,
203 X_Address_Style VARCHAR2 DEFAULT NULL,
204 X_Org_Id NUMBER DEFAULT NULL,
205 X_Vendor_Id NUMBER,
206 X_Vendor_Site_Id NUMBER,
207 X_Exchange_Rate NUMBER DEFAULT NULL,
208 X_Exchange_Date DATE DEFAULT NULL,
209 X_Exchange_Rate_Type VARCHAR2 DEFAULT NULL,
210 X_Base_Amount NUMBER DEFAULT NULL,
211 X_Checkrun_Id NUMBER DEFAULT NULL,
212 X_global_attribute_category VARCHAR2 DEFAULT NULL,
213 X_global_attribute1 VARCHAR2 DEFAULT NULL,
214 X_global_attribute2 VARCHAR2 DEFAULT NULL,
215 X_global_attribute3 VARCHAR2 DEFAULT NULL,
216 X_global_attribute4 VARCHAR2 DEFAULT NULL,
217 X_global_attribute5 VARCHAR2 DEFAULT NULL,
218 X_global_attribute6 VARCHAR2 DEFAULT NULL,
219 X_global_attribute7 VARCHAR2 DEFAULT NULL,
220 X_global_attribute8 VARCHAR2 DEFAULT NULL,
221 X_global_attribute9 VARCHAR2 DEFAULT NULL,
222 X_global_attribute10 VARCHAR2 DEFAULT NULL,
223 X_global_attribute11 VARCHAR2 DEFAULT NULL,
224 X_global_attribute12 VARCHAR2 DEFAULT NULL,
225 X_global_attribute13 VARCHAR2 DEFAULT NULL,
226 X_global_attribute14 VARCHAR2 DEFAULT NULL,
227 X_global_attribute15 VARCHAR2 DEFAULT NULL,
228 X_global_attribute16 VARCHAR2 DEFAULT NULL,
229 X_global_attribute17 VARCHAR2 DEFAULT NULL,
230 X_global_attribute18 VARCHAR2 DEFAULT NULL,
231 X_global_attribute19 VARCHAR2 DEFAULT NULL,
232 X_global_attribute20 VARCHAR2 DEFAULT NULL,
233 X_transfer_priority VARCHAR2 DEFAULT NULL,
234 X_maturity_exchange_rate_type VARCHAR2 DEFAULT NULL,
235 X_maturity_exchange_date DATE DEFAULT NULL,
236 X_maturity_exchange_rate NUMBER DEFAULT NULL,
237 X_description VARCHAR2 DEFAULT NULL,
238 X_anticipated_value_date DATE DEFAULT NULL,
239 X_actual_value_date DATE DEFAULT NULL,
240 x_payment_method_code VARCHAR2 DEFAULT NULL,
241 x_payment_profile_id NUMBER DEFAULT NULL,
242 x_bank_charge_bearer VARCHAR2 DEFAULT NULL,
243 x_settlement_priority VARCHAR2 DEFAULT NULL,
244 x_payment_document_id NUMBER DEFAULT NULL,
245 x_party_id NUMBER DEFAULT NULL,
246 x_party_site_id NUMBER DEFAULT NULL,
247 x_legal_entity_id NUMBER DEFAULT NULL,
248 x_payment_id NUMBER DEFAULT NULL,
249 X_calling_sequence VARCHAR2,
250 X_Remit_To_Supplier_Name VARCHAR2 DEFAULT NULL,
251 X_Remit_To_Supplier_Id Number DEFAULT NULL,
252 X_Remit_To_Supplier_Site VARCHAR2 DEFAULT NULL,
253 X_Remit_To_Supplier_Site_Id NUMBER DEFAULT NULL,
254 X_Relationship_Id NUMBER DEFAULT NULL,
255 X_paycard_authorization_number VARCHAR2 DEFAULT NULL,
256 X_paycard_reference_id NUMBER DEFAULT NULL
257 );
258
259
260
261 PROCEDURE Update_Row(X_Rowid VARCHAR2,
262 X_Amount NUMBER,
263 X_Ce_Bank_Acct_Use_Id NUMBER,
264 X_Bank_Account_Name VARCHAR2,
265 X_Check_Date DATE,
266 X_Check_Id NUMBER,
267 X_Check_Number NUMBER,
268 X_Currency_Code VARCHAR2,
269 X_Last_Updated_By NUMBER,
270 X_Last_Update_Date DATE,
271 --IBY:SP X_Payment_Method_Lookup_Code VARCHAR2,
272 X_Payment_Type_Flag VARCHAR2,
273 X_Address_Line1 VARCHAR2 DEFAULT NULL,
274 X_Address_Line2 VARCHAR2 DEFAULT NULL,
275 X_Address_Line3 VARCHAR2 DEFAULT NULL,
279 X_City VARCHAR2 DEFAULT NULL,
276 X_Checkrun_Name VARCHAR2 DEFAULT NULL,
277 X_Check_Format_Id NUMBER DEFAULT NULL,
278 X_Check_Stock_Id NUMBER DEFAULT NULL,
280 X_Country VARCHAR2 DEFAULT NULL,
281 X_Last_Update_Login NUMBER DEFAULT NULL,
282 X_Status_Lookup_Code VARCHAR2 DEFAULT NULL,
283 X_Vendor_Name VARCHAR2 DEFAULT NULL,
284 X_Vendor_Site_Code VARCHAR2 DEFAULT NULL,
285 X_External_Bank_Account_Id NUMBER,
286 X_Zip VARCHAR2 DEFAULT NULL,
287 X_Bank_Account_Num VARCHAR2 DEFAULT NULL,
288 X_Bank_Account_Type VARCHAR2 DEFAULT NULL,
289 X_Bank_Num VARCHAR2 DEFAULT NULL,
290 X_Check_Voucher_Num NUMBER DEFAULT NULL,
291 X_Cleared_Amount NUMBER DEFAULT NULL,
292 X_Cleared_Date DATE DEFAULT NULL,
293 X_Doc_Category_Code VARCHAR2 DEFAULT NULL,
294 X_Doc_Sequence_Id NUMBER DEFAULT NULL,
295 X_Doc_Sequence_Value NUMBER DEFAULT NULL,
296 X_Province VARCHAR2 DEFAULT NULL,
297 X_Released_Date DATE DEFAULT NULL,
298 X_Released_By NUMBER DEFAULT NULL,
299 X_State VARCHAR2 DEFAULT NULL,
300 X_Stopped_Date DATE DEFAULT NULL,
301 X_Stopped_By NUMBER DEFAULT NULL,
302 X_Void_Date DATE DEFAULT NULL,
303 X_Attribute1 VARCHAR2 DEFAULT NULL,
304 X_Attribute10 VARCHAR2 DEFAULT NULL,
305 X_Attribute11 VARCHAR2 DEFAULT NULL,
306 X_Attribute12 VARCHAR2 DEFAULT NULL,
307 X_Attribute13 VARCHAR2 DEFAULT NULL,
308 X_Attribute14 VARCHAR2 DEFAULT NULL,
309 X_Attribute15 VARCHAR2 DEFAULT NULL,
310 X_Attribute2 VARCHAR2 DEFAULT NULL,
311 X_Attribute3 VARCHAR2 DEFAULT NULL,
312 X_Attribute4 VARCHAR2 DEFAULT NULL,
313 X_Attribute5 VARCHAR2 DEFAULT NULL,
314 X_Attribute6 VARCHAR2 DEFAULT NULL,
315 X_Attribute7 VARCHAR2 DEFAULT NULL,
316 X_Attribute8 VARCHAR2 DEFAULT NULL,
317 X_Attribute9 VARCHAR2 DEFAULT NULL,
318 X_Attribute_Category VARCHAR2 DEFAULT NULL,
319 X_Future_Pay_Due_Date DATE DEFAULT NULL,
320 X_Treasury_Pay_Date DATE DEFAULT NULL,
321 X_Treasury_Pay_Number NUMBER DEFAULT NULL,
322 -- Removed for bug 4277744
323 -- X_Ussgl_Transaction_Code VARCHAR2 DEFAULT NULL,
324 -- X_Ussgl_Trx_Code_Context VARCHAR2 DEFAULT NULL,
325 X_Withholding_Status_Lkup_Code VARCHAR2 DEFAULT NULL,
326 X_Reconciliation_Batch_Id NUMBER DEFAULT NULL,
327 X_Cleared_Base_Amount NUMBER DEFAULT NULL,
328 X_Cleared_Exchange_Rate NUMBER DEFAULT NULL,
329 X_Cleared_Exchange_Date DATE DEFAULT NULL,
330 X_Cleared_Exchange_Rate_Type VARCHAR2 DEFAULT NULL,
331 X_Address_Line4 VARCHAR2 DEFAULT NULL,
332 X_County VARCHAR2 DEFAULT NULL,
333 X_Address_Style VARCHAR2 DEFAULT NULL,
334 X_Org_Id NUMBER DEFAULT NULL,
335 X_Vendor_Id NUMBER,
336 X_Vendor_Site_Id NUMBER,
337 X_Exchange_Rate NUMBER DEFAULT NULL,
338 X_Exchange_Date DATE DEFAULT NULL,
339 X_Exchange_Rate_Type VARCHAR2 DEFAULT NULL,
340 X_Base_Amount NUMBER DEFAULT NULL,
341 X_Checkrun_Id NUMBER DEFAULT NULL,
342 X_global_attribute_category VARCHAR2 DEFAULT NULL,
343 X_global_attribute1 VARCHAR2 DEFAULT NULL,
344 X_global_attribute2 VARCHAR2 DEFAULT NULL,
345 X_global_attribute3 VARCHAR2 DEFAULT NULL,
346 X_global_attribute4 VARCHAR2 DEFAULT NULL,
347 X_global_attribute5 VARCHAR2 DEFAULT NULL,
348 X_global_attribute6 VARCHAR2 DEFAULT NULL,
349 X_global_attribute7 VARCHAR2 DEFAULT NULL,
350 X_global_attribute8 VARCHAR2 DEFAULT NULL,
354 X_global_attribute12 VARCHAR2 DEFAULT NULL,
351 X_global_attribute9 VARCHAR2 DEFAULT NULL,
352 X_global_attribute10 VARCHAR2 DEFAULT NULL,
353 X_global_attribute11 VARCHAR2 DEFAULT NULL,
355 X_global_attribute13 VARCHAR2 DEFAULT NULL,
356 X_global_attribute14 VARCHAR2 DEFAULT NULL,
357 X_global_attribute15 VARCHAR2 DEFAULT NULL,
358 X_global_attribute16 VARCHAR2 DEFAULT NULL,
359 X_global_attribute17 VARCHAR2 DEFAULT NULL,
360 X_global_attribute18 VARCHAR2 DEFAULT NULL,
361 X_global_attribute19 VARCHAR2 DEFAULT NULL,
362 X_global_attribute20 VARCHAR2 DEFAULT NULL,
363 X_transfer_priority VARCHAR2 DEFAULT NULL,
364 X_maturity_exchange_rate_type VARCHAR2 DEFAULT NULL,
365 X_maturity_exchange_date DATE DEFAULT NULL,
366 X_maturity_exchange_rate NUMBER DEFAULT NULL,
367 X_description VARCHAR2 DEFAULT NULL,
368 X_anticipated_value_date DATE DEFAULT NULL,
369 X_actual_value_date DATE DEFAULT NULL,
370 x_payment_method_code VARCHAR2 DEFAULT NULL,
371 x_payment_profile_id NUMBER DEFAULT NULL,
372 x_bank_charge_bearer VARCHAR2 DEFAULT NULL,
373 x_settlement_priority VARCHAR2 DEFAULT NULL,
374 x_payment_document_id NUMBER DEFAULT NULL,
375 x_party_id NUMBER DEFAULT NULL,
376 x_party_site_id NUMBER DEFAULT NULL,
377 x_legal_entity_id NUMBER DEFAULT NULL,
378 x_payment_id NUMBER DEFAULT NULL,
379 X_calling_sequence VARCHAR2,
380 X_Remit_To_Supplier_Name VARCHAR2 DEFAULT NULL,
381 X_Remit_To_Supplier_Id Number DEFAULT NULL,
382 X_Remit_To_Supplier_Site VARCHAR2 DEFAULT NULL,
383 X_Remit_To_Supplier_Site_Id NUMBER DEFAULT NULL,
384 X_Relationship_Id NUMBER DEFAULT NULL,
385 X_paycard_authorization_number VARCHAR2 DEFAULT NULL,
386 X_paycard_reference_id NUMBER DEFAULT NULL
387 );
388 PROCEDURE Delete_Row(X_Rowid VARCHAR2,
389 X_calling_sequence VARCHAR2);
390
391 FUNCTION get_invoices_paid(l_check_id IN NUMBER)
392 RETURN VARCHAR2;
393
394 PRAGMA RESTRICT_REFERENCES(get_invoices_paid, WNDS, WNPS, RNPS);
395
396 FUNCTION is_maturity_accounted(X_check_id IN NUMBER,
397 X_calling_sequence IN VARCHAR2)
398 return BOOLEAN;
399
400 FUNCTION is_payment_matured(X_check_id IN NUMBER,
401 X_calling_sequence IN VARCHAR2)
402 return BOOLEAN;
403
404 FUNCTION get_posting_status(l_check_id IN NUMBER) RETURN VARCHAR2;
405
406 --Added for Payment Request
407 PROCEDURE Subscribe_To_Payment_Event
408 (P_Event_Type IN VARCHAR2,
409 P_Check_ID IN NUMBER,
410 P_Application_ID IN NUMBER,
411 P_Return_Status OUT NOCOPY VARCHAR2,
412 P_Msg_Count OUT NOCOPY NUMBER,
413 P_Msg_Data OUT NOCOPY VARCHAR2,
414 P_Calling_Sequence IN VARCHAR2);
415
416
417 END AP_CHECKS_PKG;