[Home] [Help]
PACKAGE: APPS.AP_AI_TABLE_HANDLER_PKG
Source
1 PACKAGE AP_AI_TABLE_HANDLER_PKG AUTHID CURRENT_USER as
2 /* $Header: apainths.pls 120.15.12010000.5 2009/09/22 11:01:03 baole ship $ */
3
4 PROCEDURE Insert_Row(
5 p_Rowid IN OUT NOCOPY VARCHAR2,
6 p_Invoice_Id IN OUT NOCOPY NUMBER,
7 p_Last_Update_Date DATE,
8 p_Last_Updated_By NUMBER,
9 p_Vendor_Id NUMBER,
10 p_Invoice_Num VARCHAR2,
11 p_Invoice_Amount NUMBER,
12 p_Vendor_Site_Id NUMBER,
13 p_Amount_Paid NUMBER,
14 p_Discount_Amount_Taken NUMBER,
15 p_Invoice_Date DATE,
16 p_Source VARCHAR2,
17 p_Invoice_Type_Lookup_Code VARCHAR2,
18 p_Description VARCHAR2,
19 p_Batch_Id NUMBER,
20 p_Amt_Applicable_To_Discount NUMBER,
21 p_Terms_Id NUMBER,
22 p_Terms_Date DATE,
23 p_Goods_Received_Date DATE,
24 p_Invoice_Received_Date DATE,
25 p_Voucher_Num VARCHAR2,
26 p_Approved_Amount NUMBER,
27 p_Approval_Status VARCHAR2,
28 p_Approval_Description VARCHAR2,
29 p_Pay_Group_Lookup_Code VARCHAR2,
30 p_Set_Of_Books_Id NUMBER,
31 p_Accts_Pay_CCId NUMBER,
32 p_Recurring_Payment_Id NUMBER,
33 p_Invoice_Currency_Code VARCHAR2,
34 p_Payment_Currency_Code VARCHAR2,
35 p_Exchange_Rate NUMBER,
36 p_Payment_Amount_Total NUMBER,
37 p_Payment_Status_Flag VARCHAR2,
38 p_Posting_Status VARCHAR2,
39 p_Authorized_By VARCHAR2,
40 p_Attribute_Category VARCHAR2,
41 p_Attribute1 VARCHAR2,
42 p_Attribute2 VARCHAR2,
43 p_Attribute3 VARCHAR2,
44 p_Attribute4 VARCHAR2,
45 p_Attribute5 VARCHAR2,
46 p_Creation_Date DATE,
47 p_Created_By NUMBER,
48 p_Vendor_Prepay_Amount NUMBER,
49 p_Base_Amount NUMBER,
50 p_Exchange_Rate_Type VARCHAR2,
51 p_Exchange_Date DATE,
52 p_Payment_Cross_Rate NUMBER,
53 p_Payment_Cross_Rate_Type VARCHAR2,
54 p_Payment_Cross_Rate_Date Date,
55 p_Pay_Curr_Invoice_Amount NUMBER,
56 p_Last_Update_Login NUMBER,
57 p_Original_Prepayment_Amount NUMBER,
58 p_Earliest_Settlement_Date DATE,
59 p_Attribute11 VARCHAR2,
60 p_Attribute12 VARCHAR2,
61 p_Attribute13 VARCHAR2,
62 p_Attribute14 VARCHAR2,
63 p_Attribute6 VARCHAR2,
64 p_Attribute7 VARCHAR2,
65 p_Attribute8 VARCHAR2,
66 p_Attribute9 VARCHAR2,
67 p_Attribute10 VARCHAR2,
68 p_Attribute15 VARCHAR2,
69 p_Cancelled_Date DATE,
70 p_Cancelled_By NUMBER,
71 p_Cancelled_Amount NUMBER,
72 p_Temp_Cancelled_Amount NUMBER,
73 p_Exclusive_Payment_Flag VARCHAR2,
74 p_Po_Header_Id NUMBER,
75 p_Doc_Sequence_Id NUMBER,
76 p_Doc_Sequence_Value NUMBER,
77 p_Doc_Category_Code VARCHAR2,
78 p_Expenditure_Item_Date DATE,
79 p_Expenditure_Organization_Id NUMBER,
80 p_Expenditure_Type VARCHAR2,
81 p_Pa_Default_Dist_Ccid NUMBER,
82 p_Pa_Quantity NUMBER,
83 p_Project_Id NUMBER,
84 p_Task_Id NUMBER,
85 p_Awt_Flag VARCHAR2,
86 p_Awt_Group_Id NUMBER,
87 p_Pay_Awt_Group_Id NUMBER, --bug6639866
88 p_Reference_1 VARCHAR2,
89 p_Reference_2 VARCHAR2,
90 p_Org_Id NUMBER,
91 p_global_attribute_category VARCHAR2 DEFAULT NULL,
92 p_global_attribute1 VARCHAR2 DEFAULT NULL,
93 p_global_attribute2 VARCHAR2 DEFAULT NULL,
94 p_global_attribute3 VARCHAR2 DEFAULT NULL,
95 p_global_attribute4 VARCHAR2 DEFAULT NULL,
96 p_global_attribute5 VARCHAR2 DEFAULT NULL,
97 p_global_attribute6 VARCHAR2 DEFAULT NULL,
98 p_global_attribute7 VARCHAR2 DEFAULT NULL,
99 p_global_attribute8 VARCHAR2 DEFAULT NULL,
100 p_global_attribute9 VARCHAR2 DEFAULT NULL,
101 p_global_attribute10 VARCHAR2 DEFAULT NULL,
102 p_global_attribute11 VARCHAR2 DEFAULT NULL,
103 p_global_attribute12 VARCHAR2 DEFAULT NULL,
104 p_global_attribute13 VARCHAR2 DEFAULT NULL,
105 p_global_attribute14 VARCHAR2 DEFAULT NULL,
106 p_global_attribute15 VARCHAR2 DEFAULT NULL,
107 p_global_attribute16 VARCHAR2 DEFAULT NULL,
108 p_global_attribute17 VARCHAR2 DEFAULT NULL,
109 p_global_attribute18 VARCHAR2 DEFAULT NULL,
110 p_global_attribute19 VARCHAR2 DEFAULT NULL,
111 p_global_attribute20 VARCHAR2 DEFAULT NULL,
112 p_calling_sequence IN VARCHAR2,
113 p_gl_date DATE,
114 p_Award_Id NUMBER,
115 p_approval_iteration NUMBER,
116 p_approval_ready_flag VARCHAR2 DEFAULT 'Y',
117 p_wfapproval_status VARCHAR2 DEFAULT 'NOT REQUIRED',
118 p_paid_on_behalf_employee_id NUMBER DEFAULT NULL,
119 p_amt_due_employee NUMBER DEFAULT NULL,
120 p_amt_due_ccard_company NUMBER DEFAULT NULL,
121 p_requester_id NUMBER DEFAULT NULL,
122 -- Invoice Lines Project Stage 1
123 p_quick_credit VARCHAR2 DEFAULT NULL,
124 p_credited_invoice_id NUMBER DEFAULT NULL,
125 p_distribution_set_id NUMBER DEFAULT NULL,
126 --Etax: Invwkb
127 p_force_revalidation_flag VARCHAR2 DEFAULT NULL,
128 p_control_amount NUMBER DEFAULT NULL,
129 p_tax_related_invoice_id NUMBER DEFAULT NULL,
130 p_trx_business_category VARCHAR2 DEFAULT NULL,
131 p_user_defined_fisc_class VARCHAR2 DEFAULT NULL,
132 p_taxation_country VARCHAR2 DEFAULT NULL,
133 p_document_sub_type VARCHAR2 DEFAULT NULL,
134 p_supplier_tax_invoice_number VARCHAR2 DEFAULT NULL,
135 p_supplier_tax_invoice_date DATE DEFAULT NULL,
136 p_supplier_tax_exchange_rate NUMBER DEFAULT NULL,
137 p_tax_invoice_recording_date DATE DEFAULT NULL,
138 p_tax_invoice_internal_seq VARCHAR2 DEFAULT NULL, -- bug 8912305: modify
139 p_legal_entity_id NUMBER DEFAULT NULL,
140 p_quick_po_header_id NUMBER DEFAULT NULL,
141 P_PAYMENT_METHOD_CODE varchar2 ,
142 P_PAYMENT_REASON_CODE varchar2 default null,
143 P_PAYMENT_REASON_COMMENTS varchar2 default null,
144 P_UNIQUE_REMITTANCE_IDENTIFIER varchar2 default null,
145 P_URI_CHECK_DIGIT varchar2 default null,
146 P_BANK_CHARGE_BEARER varchar2 default null,
147 P_DELIVERY_CHANNEL_CODE varchar2 default null,
148 P_SETTLEMENT_PRIORITY varchar2 default null,
149 p_net_of_retainage_flag varchar2 default null,
150 p_release_amount_net_of_tax number default null,
151 p_port_of_entry_code varchar2 default null,
152 p_external_bank_account_id number default null,
153 p_party_id number default null,
154 p_party_site_id number default null,
155 /* bug 4931755. Exclude Tax and Freight From Discount */
156 p_disc_is_inv_less_tax_flag varchar2 default null,
157 p_exclude_freight_from_disc varchar2 default null,
158 /* Bug 5087834 */
159 p_remit_msg1 varchar2 default null,
160 p_remit_msg2 varchar2 default null,
161 p_remit_msg3 varchar2 default null,
162 p_cust_registration_number varchar2 default null,
163 /* Third Party Payments*/
164 p_remit_to_supplier_name varchar2 default null,
165 p_remit_to_supplier_id number default null,
166 p_remit_to_supplier_site varchar2 default null,
167 p_remit_to_supplier_site_id number default null,
168 p_relationship_id number default null,
169 /* Bug 7831073 */
170 p_original_invoice_amount number default null,
171 p_dispute_reason varchar2 default null
172 );
173
174 PROCEDURE Update_Row(
175 p_Rowid VARCHAR2,
176 p_Invoice_Id NUMBER,
177 p_Last_Update_Date DATE,
178 p_Last_Updated_By NUMBER,
179 p_Vendor_Id NUMBER,
180 p_Invoice_Num VARCHAR2,
181 p_Invoice_Amount NUMBER,
182 p_Vendor_Site_Id NUMBER,
183 p_Amount_Paid NUMBER,
184 p_Discount_Amount_Taken NUMBER,
185 p_Invoice_Date DATE,
186 p_Source VARCHAR2,
187 p_Invoice_Type_Lookup_Code VARCHAR2,
188 p_Description VARCHAR2,
189 p_Batch_Id NUMBER,
190 p_Amt_Applicable_To_Discount NUMBER,
191 p_Terms_Id NUMBER,
192 p_Terms_Date DATE,
193 p_Goods_Received_Date DATE,
194 p_Invoice_Received_Date DATE,
195 p_Voucher_Num VARCHAR2,
196 p_Approved_Amount NUMBER,
197 p_Approval_Status VARCHAR2,
198 p_Approval_Description VARCHAR2,
199 p_Pay_Group_Lookup_Code VARCHAR2,
200 p_Set_Of_Books_Id NUMBER,
201 p_Accts_Pay_CCId NUMBER,
202 p_Recurring_Payment_Id NUMBER,
203 p_Invoice_Currency_Code VARCHAR2,
204 p_Payment_Currency_Code VARCHAR2,
205 p_Exchange_Rate NUMBER,
206 p_Payment_Amount_Total NUMBER,
207 p_Payment_Status_Flag VARCHAR2,
208 p_Posting_Status VARCHAR2,
209 p_Authorized_By VARCHAR2,
210 p_Attribute_Category VARCHAR2,
211 p_Attribute1 VARCHAR2,
212 p_Attribute2 VARCHAR2,
213 p_Attribute3 VARCHAR2,
214 p_Attribute4 VARCHAR2,
215 p_Attribute5 VARCHAR2,
216 p_Vendor_Prepay_Amount NUMBER,
217 p_Base_Amount NUMBER,
218 p_Exchange_Rate_Type VARCHAR2,
219 p_Exchange_Date DATE,
220 p_Payment_Cross_Rate NUMBER,
221 p_Payment_Cross_Rate_Type VARCHAR2,
222 p_Payment_Cross_Rate_Date DATE,
223 p_Pay_Curr_Invoice_Amount NUMBER,
224 p_Last_Update_Login NUMBER,
225 p_Original_Prepayment_Amount NUMBER,
226 p_Earliest_Settlement_Date DATE,
227 p_Attribute11 VARCHAR2,
228 p_Attribute12 VARCHAR2,
229 p_Attribute13 VARCHAR2,
230 p_Attribute14 VARCHAR2,
231 p_Attribute6 VARCHAR2,
232 p_Attribute7 VARCHAR2,
233 p_Attribute8 VARCHAR2,
234 p_Attribute9 VARCHAR2,
235 p_Attribute10 VARCHAR2,
236 p_Attribute15 VARCHAR2,
237 p_Cancelled_Date DATE,
238 p_Cancelled_By NUMBER,
239 p_Cancelled_Amount NUMBER,
240 p_Temp_Cancelled_Amount NUMBER,
241 p_Exclusive_Payment_Flag VARCHAR2,
242 p_Po_Header_Id NUMBER,
243 p_Doc_Sequence_Id NUMBER,
244 p_Doc_Sequence_Value NUMBER,
245 p_Doc_Category_Code VARCHAR2,
246 p_Expenditure_Item_Date DATE,
247 p_Expenditure_Organization_Id NUMBER,
248 p_Expenditure_Type VARCHAR2,
249 p_Pa_Default_Dist_Ccid NUMBER,
250 p_Pa_Quantity NUMBER,
251 p_Project_Id NUMBER,
252 p_Task_Id NUMBER,
253 p_Awt_Flag VARCHAR2,
254 p_Awt_Group_Id NUMBER,
255 p_Pay_Awt_Group_Id NUMBER,--bug6639866
256 p_Reference_1 VARCHAR2,
257 p_Reference_2 VARCHAR2,
258 p_Org_Id NUMBER,
259 p_global_attribute_category VARCHAR2 DEFAULT NULL,
260 p_global_attribute1 VARCHAR2 DEFAULT NULL,
261 p_global_attribute2 VARCHAR2 DEFAULT NULL,
262 p_global_attribute3 VARCHAR2 DEFAULT NULL,
263 p_global_attribute4 VARCHAR2 DEFAULT NULL,
264 p_global_attribute5 VARCHAR2 DEFAULT NULL,
265 p_global_attribute6 VARCHAR2 DEFAULT NULL,
266 p_global_attribute7 VARCHAR2 DEFAULT NULL,
267 p_global_attribute8 VARCHAR2 DEFAULT NULL,
268 p_global_attribute9 VARCHAR2 DEFAULT NULL,
269 p_global_attribute10 VARCHAR2 DEFAULT NULL,
270 p_global_attribute11 VARCHAR2 DEFAULT NULL,
274 p_global_attribute15 VARCHAR2 DEFAULT NULL,
271 p_global_attribute12 VARCHAR2 DEFAULT NULL,
272 p_global_attribute13 VARCHAR2 DEFAULT NULL,
273 p_global_attribute14 VARCHAR2 DEFAULT NULL,
275 p_global_attribute16 VARCHAR2 DEFAULT NULL,
276 p_global_attribute17 VARCHAR2 DEFAULT NULL,
277 p_global_attribute18 VARCHAR2 DEFAULT NULL,
278 p_global_attribute19 VARCHAR2 DEFAULT NULL,
279 p_global_attribute20 VARCHAR2 DEFAULT NULL,
280 p_calling_sequence IN VARCHAR2,
281 p_gl_date DATE,
282 p_Award_Id NUMBER,
283 p_approval_iteration NUMBER,
284 p_approval_ready_flag VARCHAR2 DEFAULT 'Y',
285 p_wfapproval_status VARCHAR2 DEFAULT 'NOT REQUIRED',
286 p_requester_id NUMBER DEFAULT NULL,
287 -- Invoice Lines Project Stage 1
288 p_quick_credit VARCHAR2 DEFAULT NULL,
289 p_credited_invoice_id NUMBER DEFAULT NULL,
290 p_distribution_set_id NUMBER DEFAULT NULL,
291 --ETAX: Invwkb
292 p_force_revalidation_flag VARCHAR2 DEFAULT NULL,
293 p_control_amount NUMBER DEFAULT NULL,
294 p_tax_related_invoice_id NUMBER DEFAULT NULL,
295 p_trx_business_category VARCHAR2 DEFAULT NULL,
296 p_user_defined_fisc_class VARCHAR2 DEFAULT NULL,
297 p_taxation_country VARCHAR2 DEFAULT NULL,
298 p_document_sub_type VARCHAR2 DEFAULT NULL,
299 p_supplier_tax_invoice_number VARCHAR2 DEFAULT NULL,
300 p_supplier_tax_invoice_date DATE DEFAULT NULL,
301 p_supplier_tax_exchange_rate NUMBER DEFAULT NULL,
302 p_tax_invoice_recording_date DATE DEFAULT NULL,
303 p_tax_invoice_internal_seq VARCHAR2 DEFAULT NULL, -- bug 8912305: modify
304 p_quick_po_header_id NUMBER DEFAULT NULL,
305 P_PAYMENT_METHOD_CODE varchar2 ,
306 P_PAYMENT_REASON_CODE varchar2 default null,
307 P_PAYMENT_REASON_COMMENTS varchar2 default null,
308 P_UNIQUE_REMITTANCE_IDENTIFIER varchar2 default null,
309 P_URI_CHECK_DIGIT varchar2 default null,
310 P_BANK_CHARGE_BEARER varchar2 default null,
311 P_DELIVERY_CHANNEL_CODE varchar2 default null,
312 P_SETTLEMENT_PRIORITY varchar2 default null,
313 p_net_of_retainage_flag varchar2 default null,
314 p_release_amount_net_of_tax number default null,
315 p_port_of_entry_code varchar2 default null,
316 p_external_bank_account_id number default null,
317 p_party_id number default null,
318 p_party_site_id number default null,
319 /* bug 4931755 . Exclude Tax and Freight From Discount */
320 p_disc_is_inv_less_tax_flag varchar2 default null,
321 p_exclude_freight_from_disc varchar2 default null,
322 -- Bug 5087834
323 p_remit_msg1 varchar2 default null,
324 p_remit_msg2 varchar2 default null,
325 p_remit_msg3 varchar2 default null,
326 /* Third Party Payments*/
327 p_remit_to_supplier_name varchar2 default null,
328 p_remit_to_supplier_id number default null,
329 p_remit_to_supplier_site varchar2 default null,
330 p_remit_to_supplier_site_id number default null,
331 p_relationship_id number default null,
332 /* Bug 7831073 */
333 p_original_invoice_amount number default null,
334 p_dispute_reason varchar2 default null
335 );
336
337 PROCEDURE Delete_Row(
338 p_Rowid VARCHAR2,
339 p_calling_sequence IN VARCHAR2);
340
341
342 END AP_AI_TABLE_HANDLER_PKG;