[Home] [Help]
PACKAGE: APPS.AP_AC_TABLE_HANDLER_PKG
Source
1 PACKAGE AP_AC_TABLE_HANDLER_PKG AUTHID CURRENT_USER as
2 /* $Header: apachths.pls 120.5.12010000.3 2009/01/20 10:07:18 cjain ship $ */
3
4 PROCEDURE Insert_Row(p_Rowid IN OUT NOCOPY VARCHAR2,
5 p_Amount NUMBER,
6 p_CE_Bank_Acct_Use_Id NUMBER,
7 p_Bank_Account_Name VARCHAR2,
8 p_Check_Date DATE,
9 p_Check_Id NUMBER,
10 p_Check_Number NUMBER,
11 p_Currency_Code VARCHAR2,
12 p_Last_Updated_By NUMBER,
13 p_Last_Update_Date DATE,
14 --IBY:SP p_Payment_Method_Lookup_Code VARCHAR2,
15 p_Payment_Type_Flag VARCHAR2,
16 p_Address_Line1 VARCHAR2 DEFAULT NULL,
17 p_Address_Line2 VARCHAR2 DEFAULT NULL,
18 p_Address_Line3 VARCHAR2 DEFAULT NULL,
19 p_Checkrun_Name VARCHAR2 DEFAULT NULL,
20 p_Check_Format_Id NUMBER DEFAULT NULL,
21 p_Check_Stock_Id NUMBER DEFAULT NULL,
22 p_City VARCHAR2 DEFAULT NULL,
23 p_Country VARCHAR2 DEFAULT NULL,
24 p_Created_By NUMBER DEFAULT NULL,
25 p_Creation_Date DATE DEFAULT NULL,
26 p_Last_Update_Login NUMBER DEFAULT NULL,
27 p_Status_Lookup_Code VARCHAR2 DEFAULT NULL,
28 p_Vendor_Name VARCHAR2 DEFAULT NULL,
29 p_Vendor_Site_Code VARCHAR2 DEFAULT NULL,
30 p_External_Bank_Account_Id NUMBER,
31 p_Zip VARCHAR2 DEFAULT NULL,
32 p_Bank_Account_Num VARCHAR2 DEFAULT NULL,
33 p_Bank_Account_Type VARCHAR2 DEFAULT NULL,
34 p_Bank_Num VARCHAR2 DEFAULT NULL,
35 p_Check_Voucher_Num NUMBER DEFAULT NULL,
36 p_Cleared_Amount NUMBER DEFAULT NULL,
37 p_Cleared_Date DATE DEFAULT NULL,
38 p_Doc_Category_Code VARCHAR2 DEFAULT NULL,
39 p_Doc_Sequence_Id NUMBER DEFAULT NULL,
40 p_Doc_Sequence_Value NUMBER DEFAULT NULL,
41 p_Province VARCHAR2 DEFAULT NULL,
42 p_Released_Date DATE DEFAULT NULL,
43 p_Released_By NUMBER DEFAULT NULL,
44 p_State VARCHAR2 DEFAULT NULL,
45 p_Stopped_Date DATE DEFAULT NULL,
46 p_Stopped_By NUMBER DEFAULT NULL,
47 p_Void_Date DATE DEFAULT NULL,
48 p_Attribute1 VARCHAR2 DEFAULT NULL,
49 p_Attribute10 VARCHAR2 DEFAULT NULL,
50 p_Attribute11 VARCHAR2 DEFAULT NULL,
51 p_Attribute12 VARCHAR2 DEFAULT NULL,
52 p_Attribute13 VARCHAR2 DEFAULT NULL,
53 p_Attribute14 VARCHAR2 DEFAULT NULL,
54 p_Attribute15 VARCHAR2 DEFAULT NULL,
55 p_Attribute2 VARCHAR2 DEFAULT NULL,
56 p_Attribute3 VARCHAR2 DEFAULT NULL,
57 p_Attribute4 VARCHAR2 DEFAULT NULL,
58 p_Attribute5 VARCHAR2 DEFAULT NULL,
59 p_Attribute6 VARCHAR2 DEFAULT NULL,
60 p_Attribute7 VARCHAR2 DEFAULT NULL,
61 p_Attribute8 VARCHAR2 DEFAULT NULL,
62 p_Attribute9 VARCHAR2 DEFAULT NULL,
63 p_Attribute_Category VARCHAR2 DEFAULT NULL,
64 p_Future_Pay_Due_Date DATE DEFAULT NULL,
65 p_Treasury_Pay_Date DATE DEFAULT NULL,
66 p_Treasury_Pay_Number NUMBER DEFAULT NULL,
67 -- Removed for bug 4277744
68 -- p_Ussgl_Transaction_Code VARCHAR2 DEFAULT NULL,
69 -- p_Ussgl_Trx_Code_Context VARCHAR2 DEFAULT NULL,
70 p_Withholding_Status_Lkup_Code VARCHAR2 DEFAULT NULL,
71 p_Reconciliation_Batch_Id NUMBER DEFAULT NULL,
72 p_Cleared_Base_Amount NUMBER DEFAULT NULL,
73 p_Cleared_Exchange_Rate NUMBER DEFAULT NULL,
74 p_Cleared_Exchange_Date DATE DEFAULT NULL,
75 p_Cleared_Exchange_Rate_Type VARCHAR2 DEFAULT NULL,
76 p_Address_Line4 VARCHAR2 DEFAULT NULL,
77 p_County VARCHAR2 DEFAULT NULL,
78 p_Address_Style VARCHAR2 DEFAULT NULL,
79 p_Org_Id NUMBER DEFAULT NULL,
80 p_Vendor_Id NUMBER,
81 p_Vendor_Site_Id NUMBER,
82 p_Exchange_Rate NUMBER DEFAULT NULL,
83 p_Exchange_Date DATE DEFAULT NULL,
84 p_Exchange_Rate_Type VARCHAR2 DEFAULT NULL,
85 p_Base_Amount NUMBER DEFAULT NULL,
86 p_Checkrun_Id NUMBER DEFAULT NULL,
87 p_global_attribute_category VARCHAR2 DEFAULT NULL,
88 p_global_attribute1 VARCHAR2 DEFAULT NULL,
89 p_global_attribute2 VARCHAR2 DEFAULT NULL,
90 p_global_attribute3 VARCHAR2 DEFAULT NULL,
91 p_global_attribute4 VARCHAR2 DEFAULT NULL,
92 p_global_attribute5 VARCHAR2 DEFAULT NULL,
93 p_global_attribute6 VARCHAR2 DEFAULT NULL,
94 p_global_attribute7 VARCHAR2 DEFAULT NULL,
95 p_global_attribute8 VARCHAR2 DEFAULT NULL,
96 p_global_attribute9 VARCHAR2 DEFAULT NULL,
97 p_global_attribute10 VARCHAR2 DEFAULT NULL,
98 p_global_attribute11 VARCHAR2 DEFAULT NULL,
99 p_global_attribute12 VARCHAR2 DEFAULT NULL,
100 p_global_attribute13 VARCHAR2 DEFAULT NULL,
101 p_global_attribute14 VARCHAR2 DEFAULT NULL,
102 p_global_attribute15 VARCHAR2 DEFAULT NULL,
103 p_global_attribute16 VARCHAR2 DEFAULT NULL,
104 p_global_attribute17 VARCHAR2 DEFAULT NULL,
105 p_global_attribute18 VARCHAR2 DEFAULT NULL,
106 p_global_attribute19 VARCHAR2 DEFAULT NULL,
107 p_global_attribute20 VARCHAR2 DEFAULT NULL,
108 p_transfer_priority VARCHAR2 DEFAULT NULL,
109 p_maturity_exchange_rate_type VARCHAR2 DEFAULT NULL,
110 p_maturity_exchange_date DATE DEFAULT NULL,
111 p_maturity_exchange_rate NUMBER DEFAULT NULL,
112 p_description VARCHAR2 DEFAULT NULL,
113 p_anticipated_value_date DATE DEFAULT NULL,
114 p_actual_value_date DATE DEFAULT NULL,
115 p_payment_method_code VARCHAR2 DEFAULT NULL,
116 p_payment_profile_id NUMBER DEFAULT NULL,
117 p_bank_charge_bearer VARCHAR2 DEFAULT NULL,
118 p_settlement_priority VARCHAR2 DEFAULT NULL,
119 p_payment_document_id NUMBER DEFAULT NULL,
120 p_party_id NUMBER DEFAULT NULL,
121 p_party_site_id NUMBER DEFAULT NULL,
122 p_legal_entity_id NUMBER DEFAULT NULL,
123 p_payment_id NUMBER DEFAULT NULL,
124 p_calling_sequence VARCHAR2,
125 p_Remit_To_Supplier_Name VARCHAR2 DEFAULT NULL,
126 p_Remit_To_Supplier_Id Number DEFAULT NULL,
127 p_Remit_To_Supplier_Site VARCHAR2 DEFAULT NULL,
128 p_Remit_To_Supplier_Site_Id NUMBER DEFAULT NULL,
129 p_Relationship_Id NUMBER DEFAULT NULL,
130 P_paycard_authorization_number VARCHAR2 DEFAULT NULL,
131 P_paycard_reference_id number default null
132 );
133
134
135 PROCEDURE Update_Row(p_Rowid VARCHAR2,
136 p_Amount NUMBER,
137 p_CE_Bank_Acct_Use_Id NUMBER,
138 p_Bank_Account_Name VARCHAR2,
139 p_Check_Date DATE,
140 p_Check_Id NUMBER,
141 p_Check_Number NUMBER,
142 p_Currency_Code VARCHAR2,
143 p_Last_Updated_By NUMBER,
144 p_Last_Update_Date DATE,
145 --IBY:SP p_Payment_Method_Lookup_Code VARCHAR2,
146 p_Payment_Type_Flag VARCHAR2,
147 p_Address_Line1 VARCHAR2 DEFAULT NULL,
148 p_Address_Line2 VARCHAR2 DEFAULT NULL,
149 p_Address_Line3 VARCHAR2 DEFAULT NULL,
150 p_Checkrun_Name VARCHAR2 DEFAULT NULL,
151 p_Check_Format_Id NUMBER DEFAULT NULL,
152 p_Check_Stock_Id NUMBER DEFAULT NULL,
153 p_City VARCHAR2 DEFAULT NULL,
154 p_Country VARCHAR2 DEFAULT NULL,
155 p_Last_Update_Login NUMBER DEFAULT NULL,
156 p_Status_Lookup_Code VARCHAR2 DEFAULT NULL,
157 p_Vendor_Name VARCHAR2 DEFAULT NULL,
158 p_Vendor_Site_Code VARCHAR2 DEFAULT NULL,
159 p_External_Bank_Account_Id NUMBER,
160 p_Zip VARCHAR2 DEFAULT NULL,
161 p_Bank_Account_Num VARCHAR2 DEFAULT NULL,
162 p_Bank_Account_Type VARCHAR2 DEFAULT NULL,
163 p_Bank_Num VARCHAR2 DEFAULT NULL,
164 p_Check_Voucher_Num NUMBER DEFAULT NULL,
165 p_Cleared_Amount NUMBER DEFAULT NULL,
166 p_Cleared_Date DATE DEFAULT NULL,
167 p_Doc_Category_Code VARCHAR2 DEFAULT NULL,
168 p_Doc_Sequence_Id NUMBER DEFAULT NULL,
169 p_Doc_Sequence_Value NUMBER DEFAULT NULL,
170 p_Province VARCHAR2 DEFAULT NULL,
171 p_Released_Date DATE DEFAULT NULL,
172 p_Released_By NUMBER DEFAULT NULL,
173 p_State VARCHAR2 DEFAULT NULL,
174 p_Stopped_Date DATE DEFAULT NULL,
175 p_Stopped_By NUMBER DEFAULT NULL,
176 p_Void_Date DATE DEFAULT NULL,
177 p_Attribute1 VARCHAR2 DEFAULT NULL,
178 p_Attribute10 VARCHAR2 DEFAULT NULL,
179 p_Attribute11 VARCHAR2 DEFAULT NULL,
180 p_Attribute12 VARCHAR2 DEFAULT NULL,
181 p_Attribute13 VARCHAR2 DEFAULT NULL,
182 p_Attribute14 VARCHAR2 DEFAULT NULL,
183 p_Attribute15 VARCHAR2 DEFAULT NULL,
184 p_Attribute2 VARCHAR2 DEFAULT NULL,
185 p_Attribute3 VARCHAR2 DEFAULT NULL,
186 p_Attribute4 VARCHAR2 DEFAULT NULL,
187 p_Attribute5 VARCHAR2 DEFAULT NULL,
188 p_Attribute6 VARCHAR2 DEFAULT NULL,
189 p_Attribute7 VARCHAR2 DEFAULT NULL,
190 p_Attribute8 VARCHAR2 DEFAULT NULL,
191 p_Attribute9 VARCHAR2 DEFAULT NULL,
192 p_Attribute_Category VARCHAR2 DEFAULT NULL,
193 p_Future_Pay_Due_Date DATE DEFAULT NULL,
194 p_Treasury_Pay_Date DATE DEFAULT NULL,
195 p_Treasury_Pay_Number NUMBER DEFAULT NULL,
196 -- Removed for bug 4277744
197 -- p_Ussgl_Transaction_Code VARCHAR2 DEFAULT NULL,
198 -- p_Ussgl_Trx_Code_Context VARCHAR2 DEFAULT NULL,
199 p_Withholding_Status_Lkup_Code VARCHAR2 DEFAULT NULL,
200 p_Reconciliation_Batch_Id NUMBER DEFAULT NULL,
201 p_Cleared_Base_Amount NUMBER DEFAULT NULL,
202 p_Cleared_Exchange_Rate NUMBER DEFAULT NULL,
203 p_Cleared_Exchange_Date DATE DEFAULT NULL,
204 p_Cleared_Exchange_Rate_Type VARCHAR2 DEFAULT NULL,
205 p_Address_Line4 VARCHAR2 DEFAULT NULL,
206 p_County VARCHAR2 DEFAULT NULL,
207 p_Address_Style VARCHAR2 DEFAULT NULL,
208 p_Org_Id NUMBER DEFAULT NULL,
209 p_Vendor_Id NUMBER,
210 p_Vendor_Site_Id NUMBER,
211 p_Exchange_Rate NUMBER DEFAULT NULL,
212 p_Exchange_Date DATE DEFAULT NULL,
213 p_Exchange_Rate_Type VARCHAR2 DEFAULT NULL,
214 p_Base_Amount NUMBER DEFAULT NULL,
215 p_Checkrun_Id NUMBER DEFAULT NULL,
216 p_global_attribute_category VARCHAR2 DEFAULT NULL,
217 p_global_attribute1 VARCHAR2 DEFAULT NULL,
218 p_global_attribute2 VARCHAR2 DEFAULT NULL,
219 p_global_attribute3 VARCHAR2 DEFAULT NULL,
220 p_global_attribute4 VARCHAR2 DEFAULT NULL,
221 p_global_attribute5 VARCHAR2 DEFAULT NULL,
222 p_global_attribute6 VARCHAR2 DEFAULT NULL,
223 p_global_attribute7 VARCHAR2 DEFAULT NULL,
224 p_global_attribute8 VARCHAR2 DEFAULT NULL,
225 p_global_attribute9 VARCHAR2 DEFAULT NULL,
226 p_global_attribute10 VARCHAR2 DEFAULT NULL,
227 p_global_attribute11 VARCHAR2 DEFAULT NULL,
228 p_global_attribute12 VARCHAR2 DEFAULT NULL,
229 p_global_attribute13 VARCHAR2 DEFAULT NULL,
230 p_global_attribute14 VARCHAR2 DEFAULT NULL,
231 p_global_attribute15 VARCHAR2 DEFAULT NULL,
232 p_global_attribute16 VARCHAR2 DEFAULT NULL,
233 p_global_attribute17 VARCHAR2 DEFAULT NULL,
234 p_global_attribute18 VARCHAR2 DEFAULT NULL,
235 p_global_attribute19 VARCHAR2 DEFAULT NULL,
236 p_global_attribute20 VARCHAR2 DEFAULT NULL,
237 p_transfer_priority VARCHAR2 DEFAULT NULL,
238 p_maturity_exchange_rate_type VARCHAR2 DEFAULT NULL,
239 p_maturity_exchange_date DATE DEFAULT NULL,
243 p_actual_value_date DATE DEFAULT NULL,
240 p_maturity_exchange_rate NUMBER DEFAULT NULL,
241 p_description VARCHAR2 DEFAULT NULL,
242 p_anticipated_value_date DATE DEFAULT NULL,
244 p_payment_method_code VARCHAR2 DEFAULT NULL,
245 p_payment_profile_id NUMBER DEFAULT NULL,
246 p_bank_charge_bearer VARCHAR2 DEFAULT NULL,
247 p_settlement_priority VARCHAR2 DEFAULT NULL,
248 p_payment_document_id NUMBER DEFAULT NULL,
249 p_party_id NUMBER DEFAULT NULL,
250 p_party_site_id NUMBER DEFAULT NULL,
251 p_legal_entity_id NUMBER DEFAULT NULL,
252 p_payment_id NUMBER DEFAULT NULL,
253 p_calling_sequence VARCHAR2,
254 p_Remit_To_Supplier_Name VARCHAR2 DEFAULT NULL,
255 p_Remit_To_Supplier_Id Number DEFAULT NULL,
256 p_Remit_To_Supplier_Site VARCHAR2 DEFAULT NULL,
257 p_Remit_To_Supplier_Site_Id NUMBER DEFAULT NULL,
258 p_Relationship_Id NUMBER DEFAULT NULL,
259 P_paycard_authorization_number VARCHAR2 DEFAULT NULL,
260 P_paycard_reference_id NUMBER DEFAULT NULL
261 );
262
263 PROCEDURE Delete_Row(p_Rowid VARCHAR2,
264 p_calling_sequence VARCHAR2);
265
266 PROCEDURE Update_Amounts(
267 P_check_id IN NUMBER,
268 P_amount IN NUMBER,
269 P_base_amount IN NUMBER,
270 P_calling_sequence IN VARCHAR2);
271
272 END AP_AC_TABLE_HANDLER_PKG;