[Home] [Help]
PACKAGE: APPS.AP_RECURRING_PAYMENTS_PKG
Source
1 PACKAGE AP_RECURRING_PAYMENTS_PKG AUTHID CURRENT_USER AS
2 /* $Header: apircups.pls 120.9 2010/12/20 12:20:33 sbonala ship $ */
3
4
5 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
6 X_Recurring_Payment_Id IN OUT NOCOPY NUMBER,
7 X_Last_Update_Date DATE,
8 X_Last_Updated_By NUMBER,
9 X_Creation_Date DATE,
10 X_Created_By NUMBER,
11 X_Vendor_Id NUMBER,
12 X_Recurring_Pay_Num VARCHAR2,
13 X_Vendor_Site_Id NUMBER,
14 X_Rec_Pay_Period_Type VARCHAR2,
15 X_Num_Of_Periods NUMBER,
16 X_First_Period VARCHAR2,
17 X_First_Period_Num NUMBER,
18 X_Authorized_Total NUMBER,
19 X_Control_Amount NUMBER,
20 X_Distribution_Set_Id NUMBER DEFAULT NULL,
21 X_Terms_Id NUMBER,
22 X_Set_Of_Books_Id NUMBER,
23 X_Amount_Applicable_To_Disc NUMBER,
24 X_Rem_Periods NUMBER DEFAULT NULL,
25 X_Accounting_Date DATE DEFAULT NULL,
26 X_Released_Amount NUMBER DEFAULT NULL,
27 X_Batch_Id NUMBER DEFAULT NULL,
28 X_Accts_Pay_Code_Comb NUMBER DEFAULT NULL,
29 X_Invoice_Currency_Code VARCHAR2,
30 X_Payment_Currency_Code VARCHAR2,
31 X_Pay_Group_Lookup_Code VARCHAR2 DEFAULT NULL,
32 X_Tax_Amount NUMBER DEFAULT NULL,
33 X_Exchange_Rate NUMBER DEFAULT NULL,
34 X_Next_Period VARCHAR2 DEFAULT NULL,
35 X_Next_Payment NUMBER DEFAULT NULL,
36 X_Increment_Percent NUMBER DEFAULT NULL,
37 X_Num_Of_Periods_Rem NUMBER DEFAULT NULL,
38 X_Special_Payment_Amount1 NUMBER DEFAULT NULL,
39 X_Special_Period_Name1 VARCHAR2 DEFAULT NULL,
40 X_Special_Payment_Amount2 NUMBER DEFAULT NULL,
41 X_Special_Period_Name2 VARCHAR2 DEFAULT NULL,
42 X_Description VARCHAR2 DEFAULT NULL,
43 X_Paid_Flag1 VARCHAR2 DEFAULT NULL,
44 X_Paid_Flag2 VARCHAR2 DEFAULT NULL,
45 X_Hold_Lookup_Code VARCHAR2 DEFAULT NULL,
46 X_Hold_Reason VARCHAR2 DEFAULT NULL,
47 X_Approved_By NUMBER DEFAULT NULL,
48 X_Expiry_Date DATE DEFAULT NULL,
49 X_Attribute_Category VARCHAR2 DEFAULT NULL,
50 X_Attribute1 VARCHAR2 DEFAULT NULL,
51 X_Attribute2 VARCHAR2 DEFAULT NULL,
52 X_Attribute3 VARCHAR2 DEFAULT NULL,
53 X_Attribute4 VARCHAR2 DEFAULT NULL,
54 X_Attribute5 VARCHAR2 DEFAULT NULL,
55 X_Exchange_Rate_Type VARCHAR2 DEFAULT NULL,
56 X_Payment_Cross_Rate NUMBER,
57 X_Exchange_Date DATE DEFAULT NULL,
58 X_Last_Update_Login NUMBER DEFAULT NULL,
59 X_Tax_Name VARCHAR2 DEFAULT NULL,
60 X_Attribute11 VARCHAR2 DEFAULT NULL,
61 X_Attribute12 VARCHAR2 DEFAULT NULL,
65 X_Attribute7 VARCHAR2 DEFAULT NULL,
62 X_Attribute13 VARCHAR2 DEFAULT NULL,
63 X_Attribute14 VARCHAR2 DEFAULT NULL,
64 X_Attribute6 VARCHAR2 DEFAULT NULL,
66 X_Attribute8 VARCHAR2 DEFAULT NULL,
67 X_Attribute9 VARCHAR2 DEFAULT NULL,
68 X_Attribute10 VARCHAR2 DEFAULT NULL,
69 X_Attribute15 VARCHAR2 DEFAULT NULL,
70 X_Exclusive_Payment_Flag VARCHAR2 DEFAULT NULL,
71 X_Awt_Group_Id NUMBER DEFAULT NULL,
72 X_Pay_Awt_Group_Id NUMBER DEFAULT NULL,--bug6639866
73 X_Org_Id NUMBER DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID,
74 X_Po_Header_Id NUMBER DEFAULT NULL,
75 X_Po_Line_Id NUMBER DEFAULT NULL,
76 X_Line_Location_Id NUMBER DEFAULT NULL,
77 X_External_Bank_Account_Id NUMBER DEFAULT NULL,
78 X_calling_sequence VARCHAR2,
79 X_Approval_Required_Flag VARCHAR2,
80 -- Removed for bug 4277744
81 -- X_USSGL_Txn_Code VARCHAR2 DEFAULT NULL ,
82 X_Requester_id NUMBER DEFAULT NULL,
83 X_Po_Release_Id NUMBER DEFAULT NULL,
84 X_Item_Description VARCHAR2 DEFAULT NULL,
85 X_Manufacturer VARCHAR2 DEFAULT NULL,
86 X_Model_Number VARCHAR2 DEFAULT NULL,
87 X_Tax_Control_Amount NUMBER DEFAULT NULL,
88 X_Taxation_Country VARCHAR2 DEFAULT NULL,
89 X_Product_Fisc_Class VARCHAR2 DEFAULT NULL,
90 X_User_Defined_Fisc_Class VARCHAR2 DEFAULT NULL,
91 X_Trx_Bus_Category VARCHAR2 DEFAULT NULL,
92 X_Primary_Intended_Use VARCHAR2 DEFAULT NULL,
93 X_Legal_Entity_Id NUMBER DEFAULT NULL,
94 x_PAYMENT_METHOD_CODE varchar2 default null,
95 x_PAYMENT_REASON_CODE varchar2 default null,
96 x_remittance_message1 varchar2 default null,
97 x_remittance_message2 varchar2 default null,
98 x_remittance_message3 varchar2 default null,
99 x_bank_charge_bearer varchar2 default null,
100 x_settlement_priority varchar2 default null,
101 x_payment_reason_comments varchar2 default null,
102 x_delivery_channel_code varchar2 default null,
103 x_first_amount NUMBER, -- 2794958 (2774932)
104 X_REMIT_TO_SUPPLIER_NAME VARCHAR2 DEFAULT NULL,
105 X_REMIT_TO_SUPPLIER_ID NUMBER DEFAULT NULL,
106 X_REMIT_TO_SUPPLIER_SITE VARCHAR2 DEFAULT NULL,
107 X_REMIT_TO_SUPPLIER_SITE_ID NUMBER DEFAULT NULL,
108 X_RELATIONSHIP_ID NUMBER DEFAULT NULL,
109 X_PRODUCT_TYPE VARCHAR2 DEFAULT NULL, --Bug#8640313
110 X_PRODUCT_CATEGORY VARCHAR2 DEFAULT NULL --Bug#8640313
111 );
112
113 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
114 X_Recurring_Payment_Id NUMBER,
115 X_Vendor_Id NUMBER,
116 X_Recurring_Pay_Num VARCHAR2,
117 X_Vendor_Site_Id NUMBER,
118 X_Rec_Pay_Period_Type VARCHAR2,
119 X_Num_Of_Periods NUMBER,
120 X_First_Period VARCHAR2,
121 X_First_Period_Num NUMBER,
122 X_Authorized_Total NUMBER,
123 X_Control_Amount NUMBER,
124 X_Distribution_Set_Id NUMBER,
125 X_Terms_Id NUMBER,
126 X_Set_Of_Books_Id NUMBER,
127 X_Amount_Applicable_To_Disc NUMBER,
128 X_Rem_Periods NUMBER DEFAULT NULL,
129 X_Accounting_Date DATE DEFAULT NULL,
130 X_Released_Amount NUMBER DEFAULT NULL,
131 X_Batch_Id NUMBER DEFAULT NULL,
132 X_Accts_Pay_Code_Comb NUMBER DEFAULT NULL,
133 X_Invoice_Currency_Code VARCHAR2,
134 X_Payment_Currency_Code VARCHAR2,
135 X_Pay_Group_Lookup_Code VARCHAR2 DEFAULT NULL,
136 X_Tax_Amount NUMBER DEFAULT NULL,
137 X_Exchange_Rate NUMBER DEFAULT NULL,
138 X_Next_Period VARCHAR2 DEFAULT NULL,
139 X_Next_Payment NUMBER DEFAULT NULL,
140 X_Increment_Percent NUMBER DEFAULT NULL,
141 X_Num_Of_Periods_Rem NUMBER DEFAULT NULL,
142 X_Special_Payment_Amount1 NUMBER DEFAULT NULL,
143 X_Special_Period_Name1 VARCHAR2 DEFAULT NULL,
144 X_Special_Payment_Amount2 NUMBER DEFAULT NULL,
145 X_Special_Period_Name2 VARCHAR2 DEFAULT NULL,
146 X_Description VARCHAR2 DEFAULT NULL,
150 X_Hold_Reason VARCHAR2 DEFAULT NULL,
147 X_Paid_Flag1 VARCHAR2 DEFAULT NULL,
148 X_Paid_Flag2 VARCHAR2 DEFAULT NULL,
149 X_Hold_Lookup_Code VARCHAR2 DEFAULT NULL,
151 X_Approved_By NUMBER DEFAULT NULL,
152 X_Expiry_Date DATE DEFAULT NULL,
153 X_Attribute_Category VARCHAR2 DEFAULT NULL,
154 X_Attribute1 VARCHAR2 DEFAULT NULL,
155 X_Attribute2 VARCHAR2 DEFAULT NULL,
156 X_Attribute3 VARCHAR2 DEFAULT NULL,
157 X_Attribute4 VARCHAR2 DEFAULT NULL,
158 X_Attribute5 VARCHAR2 DEFAULT NULL,
159 X_Exchange_Rate_Type VARCHAR2 DEFAULT NULL,
160 X_Payment_Cross_Rate NUMBER,
161 X_Exchange_Date DATE DEFAULT NULL,
162 X_Tax_Name VARCHAR2 DEFAULT NULL,
163 X_Attribute11 VARCHAR2 DEFAULT NULL,
164 X_Attribute12 VARCHAR2 DEFAULT NULL,
165 X_Attribute13 VARCHAR2 DEFAULT NULL,
166 X_Attribute14 VARCHAR2 DEFAULT NULL,
167 X_Attribute6 VARCHAR2 DEFAULT NULL,
168 X_Attribute7 VARCHAR2 DEFAULT NULL,
169 X_Attribute8 VARCHAR2 DEFAULT NULL,
170 X_Attribute9 VARCHAR2 DEFAULT NULL,
171 X_Attribute10 VARCHAR2 DEFAULT NULL,
172 X_Attribute15 VARCHAR2 DEFAULT NULL,
173 X_Exclusive_Payment_Flag VARCHAR2 DEFAULT NULL,
174 X_Awt_Group_Id NUMBER DEFAULT NULL,
175 X_Pay_Awt_Group_Id NUMBER DEFAULT NULL,--bug6639866
176 X_Org_Id NUMBER DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID,
177 X_Po_Header_Id NUMBER DEFAULT NULL,
178 X_Po_Line_Id NUMBER DEFAULT NULL,
179 X_Line_Location_Id NUMBER DEFAULT NULL,
180 X_External_Bank_Account_Id NUMBER DEFAULT NULL,
181 X_calling_sequence VARCHAR2,
182 X_Approval_Required_Flag VARCHAR2,
183 -- Removed for bug 4277744
184 -- X_USSGL_Txn_Code VARCHAR2 DEFAULT NULL,
185 X_Requester_id NUMBER DEFAULT NULL,
186 X_Po_Release_Id NUMBER DEFAULT NULL,
187 X_Item_Description VARCHAR2 DEFAULT NULL,
188 X_Manufacturer VARCHAR2 DEFAULT NULL,
189 X_Model_Number VARCHAR2 DEFAULT NULL,
190 X_Tax_Control_Amount NUMBER DEFAULT NULL,
191 X_Taxation_Country VARCHAR2 DEFAULT NULL,
192 X_Product_Fisc_Class VARCHAR2 DEFAULT NULL,
193 X_User_Defined_Fisc_Class VARCHAR2 DEFAULT NULL,
197 x_PAYMENT_METHOD_CODE varchar2 default null,
194 X_Trx_Bus_Category VARCHAR2 DEFAULT NULL,
195 X_Primary_Intended_Use VARCHAR2 DEFAULT NULL,
196 X_Legal_Entity_Id NUMBER DEFAULT NULL,
198 x_PAYMENT_REASON_CODE varchar2 default null,
199 x_remittance_message1 varchar2 default null,
200 x_remittance_message2 varchar2 default null,
201 x_remittance_message3 varchar2 default null,
202 x_bank_charge_bearer varchar2 default null,
203 x_settlement_priority varchar2 default null,
204 x_payment_reason_comments varchar2 default null,
205 x_delivery_channel_code varchar2 default null,
206 x_first_amount NUMBER, -- 2794958 (2774932)
207 X_REMIT_TO_SUPPLIER_NAME VARCHAR2 DEFAULT NULL,
208 X_REMIT_TO_SUPPLIER_ID NUMBER DEFAULT NULL,
209 X_REMIT_TO_SUPPLIER_SITE VARCHAR2 DEFAULT NULL,
210 X_REMIT_TO_SUPPLIER_SITE_ID NUMBER DEFAULT NULL,
211 X_RELATIONSHIP_ID NUMBER DEFAULT NULL,
212 X_PRODUCT_TYPE VARCHAR2 DEFAULT NULL, --Bug#8640313
213 X_PRODUCT_CATEGORY VARCHAR2 DEFAULT NULL --Bug#8640313
214 );
215
219 X_Last_Updated_By NUMBER,
216 PROCEDURE Update_Row(X_Rowid VARCHAR2,
217 X_Recurring_Payment_Id NUMBER,
218 X_Last_Update_Date DATE,
220 X_Vendor_Id NUMBER,
221 X_Recurring_Pay_Num VARCHAR2,
222 X_Vendor_Site_Id NUMBER,
223 X_Rec_Pay_Period_Type VARCHAR2,
224 X_Num_Of_Periods NUMBER,
225 X_First_Period VARCHAR2,
226 X_First_Period_Num NUMBER,
227 X_Authorized_Total NUMBER,
228 X_Control_Amount NUMBER,
229 X_Distribution_Set_Id NUMBER DEFAULT NULL,
230 X_Terms_Id NUMBER,
231 X_Set_Of_Books_Id NUMBER,
232 X_Amount_Applicable_To_Disc NUMBER,
233 X_Rem_Periods NUMBER DEFAULT NULL,
234 X_Accounting_Date DATE DEFAULT NULL,
235 X_Released_Amount NUMBER DEFAULT NULL,
236 X_Batch_Id NUMBER DEFAULT NULL,
237 X_Accts_Pay_Code_Comb NUMBER DEFAULT NULL,
238 X_Invoice_Currency_Code VARCHAR2,
239 X_Payment_Currency_Code VARCHAR2,
240 X_Pay_Group_Lookup_Code VARCHAR2 DEFAULT NULL,
241 X_Tax_Amount NUMBER DEFAULT NULL,
242 X_Exchange_Rate NUMBER DEFAULT NULL,
243 X_Next_Period VARCHAR2 DEFAULT NULL,
244 X_Next_Payment NUMBER DEFAULT NULL,
245 X_Increment_Percent NUMBER DEFAULT NULL,
246 X_Num_Of_Periods_Rem NUMBER DEFAULT NULL,
247 X_Special_Payment_Amount1 NUMBER DEFAULT NULL,
248 X_Special_Period_Name1 VARCHAR2 DEFAULT NULL,
249 X_Special_Payment_Amount2 NUMBER DEFAULT NULL,
250 X_Special_Period_Name2 VARCHAR2 DEFAULT NULL,
251 X_Description VARCHAR2 DEFAULT NULL,
252 X_Paid_Flag1 VARCHAR2 DEFAULT NULL,
253 X_Paid_Flag2 VARCHAR2 DEFAULT NULL,
254 X_Hold_Lookup_Code VARCHAR2 DEFAULT NULL,
255 X_Hold_Reason VARCHAR2 DEFAULT NULL,
256 X_Approved_By NUMBER DEFAULT NULL,
257 X_Expiry_Date DATE DEFAULT NULL,
258 X_Attribute_Category VARCHAR2 DEFAULT NULL,
259 X_Attribute1 VARCHAR2 DEFAULT NULL,
260 X_Attribute2 VARCHAR2 DEFAULT NULL,
261 X_Attribute3 VARCHAR2 DEFAULT NULL,
262 X_Attribute4 VARCHAR2 DEFAULT NULL,
263 X_Attribute5 VARCHAR2 DEFAULT NULL,
264 X_Exchange_Rate_Type VARCHAR2 DEFAULT NULL,
265 X_Payment_Cross_Rate NUMBER,
266 X_Exchange_Date DATE DEFAULT NULL,
267 X_Last_Update_Login NUMBER DEFAULT NULL,
268 X_Tax_Name VARCHAR2 DEFAULT NULL,
269 X_Attribute11 VARCHAR2 DEFAULT NULL,
270 X_Attribute12 VARCHAR2 DEFAULT NULL,
271 X_Attribute13 VARCHAR2 DEFAULT NULL,
272 X_Attribute14 VARCHAR2 DEFAULT NULL,
273 X_Attribute6 VARCHAR2 DEFAULT NULL,
274 X_Attribute7 VARCHAR2 DEFAULT NULL,
275 X_Attribute8 VARCHAR2 DEFAULT NULL,
276 X_Attribute9 VARCHAR2 DEFAULT NULL,
277 X_Attribute10 VARCHAR2 DEFAULT NULL,
278 X_Attribute15 VARCHAR2 DEFAULT NULL,
279 X_Exclusive_Payment_Flag VARCHAR2 DEFAULT NULL,
280 X_Awt_Group_Id NUMBER DEFAULT NULL,
281 X_Pay_Awt_Group_Id NUMBER DEFAULT NULL,--bug6639866
282 X_Org_Id NUMBER DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID,
283 X_Po_Header_Id NUMBER DEFAULT NULL,
284 X_Po_Line_Id NUMBER DEFAULT NULL,
285 X_Line_Location_Id NUMBER DEFAULT NULL,
286 X_External_Bank_Account_Id NUMBER DEFAULT NULL,
287 X_calling_sequence VARCHAR2,
288 X_Approval_Required_Flag VARCHAR2,
292 X_Po_Release_Id NUMBER DEFAULT NULL,
289 -- Removed for bug 4277744
290 -- X_USSGL_Txn_Code VARCHAR2 ,
291 X_Requester_id NUMBER DEFAULT NULL,
293 X_Item_Description VARCHAR2 DEFAULT NULL,
294 X_Manufacturer VARCHAR2 DEFAULT NULL,
295 X_Model_Number VARCHAR2 DEFAULT NULL,
296 X_Tax_Control_Amount NUMBER DEFAULT NULL,
297 X_Taxation_Country VARCHAR2 DEFAULT NULL,
298 X_Product_Fisc_Class VARCHAR2 DEFAULT NULL,
299 X_User_Defined_Fisc_Class VARCHAR2 DEFAULT NULL,
300 X_Trx_Bus_Category VARCHAR2 DEFAULT NULL,
301 X_Primary_Intended_Use VARCHAR2 DEFAULT NULL,
302 X_Legal_Entity_Id NUMBER DEFAULT NULL,
303 x_PAYMENT_METHOD_CODE varchar2 default null,
304 x_PAYMENT_REASON_CODE varchar2 default null,
305 x_remittance_message1 varchar2 default null,
306 x_remittance_message2 varchar2 default null,
307 x_remittance_message3 varchar2 default null,
308 x_bank_charge_bearer varchar2 default null,
309 x_settlement_priority varchar2 default null,
310 x_payment_reason_comments varchar2 default null,
311 x_delivery_channel_code varchar2 default null,
312 x_first_amount NUMBER, -- 2794958 (2774932)
313 X_REMIT_TO_SUPPLIER_NAME VARCHAR2 DEFAULT NULL,
314 X_REMIT_TO_SUPPLIER_ID NUMBER DEFAULT NULL,
315 X_REMIT_TO_SUPPLIER_SITE VARCHAR2 DEFAULT NULL,
316 X_REMIT_TO_SUPPLIER_SITE_ID NUMBER DEFAULT NULL,
317 X_RELATIONSHIP_ID NUMBER DEFAULT NULL,
318 X_PRODUCT_TYPE VARCHAR2 DEFAULT NULL, --Bug#8640313
319 X_PRODUCT_CATEGORY VARCHAR2 DEFAULT NULL --Bug#8640313
320 );
321
322 PROCEDURE Delete_Row(X_Rowid VARCHAR2,
323 X_calling_sequence VARCHAR2);
324
325 END AP_RECURRING_PAYMENTS_PKG;