[Home] [Help]
PACKAGE: APPS.AP_RECURRING_PAYMENTS_PKG
Source
1 PACKAGE AP_RECURRING_PAYMENTS_PKG AS
2 /* $Header: apircups.pls 120.7.12010000.2 2008/11/20 14:18:17 dcshanmu 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,
62 X_Attribute13 VARCHAR2 DEFAULT NULL,
63 X_Attribute14 VARCHAR2 DEFAULT NULL,
64 X_Attribute6 VARCHAR2 DEFAULT NULL,
65 X_Attribute7 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 );
110
111 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
112 X_Recurring_Payment_Id NUMBER,
113 X_Vendor_Id NUMBER,
114 X_Recurring_Pay_Num VARCHAR2,
115 X_Vendor_Site_Id NUMBER,
116 X_Rec_Pay_Period_Type VARCHAR2,
117 X_Num_Of_Periods NUMBER,
118 X_First_Period VARCHAR2,
119 X_First_Period_Num NUMBER,
120 X_Authorized_Total NUMBER,
121 X_Control_Amount NUMBER,
122 X_Distribution_Set_Id NUMBER,
123 X_Terms_Id NUMBER,
124 X_Set_Of_Books_Id NUMBER,
125 X_Amount_Applicable_To_Disc NUMBER,
126 X_Rem_Periods NUMBER DEFAULT NULL,
127 X_Accounting_Date DATE DEFAULT NULL,
128 X_Released_Amount NUMBER DEFAULT NULL,
129 X_Batch_Id NUMBER DEFAULT NULL,
130 X_Accts_Pay_Code_Comb NUMBER DEFAULT NULL,
131 X_Invoice_Currency_Code VARCHAR2,
132 X_Payment_Currency_Code VARCHAR2,
133 X_Pay_Group_Lookup_Code VARCHAR2 DEFAULT NULL,
134 X_Tax_Amount NUMBER DEFAULT NULL,
135 X_Exchange_Rate NUMBER DEFAULT NULL,
136 X_Next_Period VARCHAR2 DEFAULT NULL,
137 X_Next_Payment NUMBER DEFAULT NULL,
138 X_Increment_Percent NUMBER DEFAULT NULL,
139 X_Num_Of_Periods_Rem NUMBER DEFAULT NULL,
140 X_Special_Payment_Amount1 NUMBER DEFAULT NULL,
141 X_Special_Period_Name1 VARCHAR2 DEFAULT NULL,
142 X_Special_Payment_Amount2 NUMBER DEFAULT NULL,
143 X_Special_Period_Name2 VARCHAR2 DEFAULT NULL,
144 X_Description VARCHAR2 DEFAULT NULL,
145 X_Paid_Flag1 VARCHAR2 DEFAULT NULL,
146 X_Paid_Flag2 VARCHAR2 DEFAULT NULL,
147 X_Hold_Lookup_Code VARCHAR2 DEFAULT NULL,
148 X_Hold_Reason VARCHAR2 DEFAULT NULL,
149 X_Approved_By NUMBER DEFAULT NULL,
150 X_Expiry_Date DATE DEFAULT NULL,
151 X_Attribute_Category VARCHAR2 DEFAULT NULL,
152 X_Attribute1 VARCHAR2 DEFAULT NULL,
153 X_Attribute2 VARCHAR2 DEFAULT NULL,
154 X_Attribute3 VARCHAR2 DEFAULT NULL,
155 X_Attribute4 VARCHAR2 DEFAULT NULL,
156 X_Attribute5 VARCHAR2 DEFAULT NULL,
157 X_Exchange_Rate_Type VARCHAR2 DEFAULT NULL,
158 X_Payment_Cross_Rate NUMBER,
159 X_Exchange_Date DATE DEFAULT NULL,
160 X_Tax_Name VARCHAR2 DEFAULT NULL,
161 X_Attribute11 VARCHAR2 DEFAULT NULL,
162 X_Attribute12 VARCHAR2 DEFAULT NULL,
163 X_Attribute13 VARCHAR2 DEFAULT NULL,
164 X_Attribute14 VARCHAR2 DEFAULT NULL,
165 X_Attribute6 VARCHAR2 DEFAULT NULL,
166 X_Attribute7 VARCHAR2 DEFAULT NULL,
167 X_Attribute8 VARCHAR2 DEFAULT NULL,
168 X_Attribute9 VARCHAR2 DEFAULT NULL,
169 X_Attribute10 VARCHAR2 DEFAULT NULL,
170 X_Attribute15 VARCHAR2 DEFAULT NULL,
171 X_Exclusive_Payment_Flag VARCHAR2 DEFAULT NULL,
172 X_Awt_Group_Id NUMBER DEFAULT NULL,
173 X_Pay_Awt_Group_Id NUMBER DEFAULT NULL,--bug6639866
174 X_Org_Id NUMBER DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID,
175 X_Po_Header_Id NUMBER DEFAULT NULL,
176 X_Po_Line_Id NUMBER DEFAULT NULL,
177 X_Line_Location_Id NUMBER DEFAULT NULL,
178 X_External_Bank_Account_Id NUMBER DEFAULT NULL,
179 X_calling_sequence VARCHAR2,
180 X_Approval_Required_Flag VARCHAR2,
181 -- Removed for bug 4277744
182 -- X_USSGL_Txn_Code VARCHAR2 DEFAULT NULL,
183 X_Requester_id NUMBER DEFAULT NULL,
184 X_Po_Release_Id NUMBER DEFAULT NULL,
185 X_Item_Description VARCHAR2 DEFAULT NULL,
186 X_Manufacturer VARCHAR2 DEFAULT NULL,
187 X_Model_Number VARCHAR2 DEFAULT NULL,
188 X_Tax_Control_Amount NUMBER DEFAULT NULL,
189 X_Taxation_Country VARCHAR2 DEFAULT NULL,
190 X_Product_Fisc_Class VARCHAR2 DEFAULT NULL,
191 X_User_Defined_Fisc_Class VARCHAR2 DEFAULT NULL,
192 X_Trx_Bus_Category VARCHAR2 DEFAULT NULL,
193 X_Primary_Intended_Use VARCHAR2 DEFAULT NULL,
194 X_Legal_Entity_Id NUMBER DEFAULT NULL,
195 x_PAYMENT_METHOD_CODE varchar2 default null,
196 x_PAYMENT_REASON_CODE varchar2 default null,
197 x_remittance_message1 varchar2 default null,
198 x_remittance_message2 varchar2 default null,
199 x_remittance_message3 varchar2 default null,
200 x_bank_charge_bearer varchar2 default null,
201 x_settlement_priority varchar2 default null,
202 x_payment_reason_comments varchar2 default null,
203 x_delivery_channel_code varchar2 default null,
204 x_first_amount NUMBER, -- 2794958 (2774932)
205 X_REMIT_TO_SUPPLIER_NAME VARCHAR2 DEFAULT NULL,
206 X_REMIT_TO_SUPPLIER_ID NUMBER DEFAULT NULL,
207 X_REMIT_TO_SUPPLIER_SITE VARCHAR2 DEFAULT NULL,
208 X_REMIT_TO_SUPPLIER_SITE_ID NUMBER DEFAULT NULL,
209 X_RELATIONSHIP_ID NUMBER DEFAULT NULL
210 );
211
212 PROCEDURE Update_Row(X_Rowid VARCHAR2,
213 X_Recurring_Payment_Id NUMBER,
214 X_Last_Update_Date DATE,
215 X_Last_Updated_By NUMBER,
216 X_Vendor_Id NUMBER,
217 X_Recurring_Pay_Num VARCHAR2,
218 X_Vendor_Site_Id NUMBER,
219 X_Rec_Pay_Period_Type VARCHAR2,
220 X_Num_Of_Periods NUMBER,
221 X_First_Period VARCHAR2,
222 X_First_Period_Num NUMBER,
223 X_Authorized_Total NUMBER,
224 X_Control_Amount NUMBER,
225 X_Distribution_Set_Id NUMBER DEFAULT NULL,
226 X_Terms_Id NUMBER,
227 X_Set_Of_Books_Id NUMBER,
228 X_Amount_Applicable_To_Disc NUMBER,
229 X_Rem_Periods NUMBER DEFAULT NULL,
230 X_Accounting_Date DATE DEFAULT NULL,
231 X_Released_Amount NUMBER DEFAULT NULL,
232 X_Batch_Id NUMBER DEFAULT NULL,
233 X_Accts_Pay_Code_Comb NUMBER DEFAULT NULL,
234 X_Invoice_Currency_Code VARCHAR2,
235 X_Payment_Currency_Code VARCHAR2,
236 X_Pay_Group_Lookup_Code VARCHAR2 DEFAULT NULL,
237 X_Tax_Amount NUMBER DEFAULT NULL,
238 X_Exchange_Rate NUMBER DEFAULT NULL,
239 X_Next_Period VARCHAR2 DEFAULT NULL,
240 X_Next_Payment NUMBER DEFAULT NULL,
241 X_Increment_Percent NUMBER DEFAULT NULL,
242 X_Num_Of_Periods_Rem NUMBER DEFAULT NULL,
243 X_Special_Payment_Amount1 NUMBER DEFAULT NULL,
244 X_Special_Period_Name1 VARCHAR2 DEFAULT NULL,
245 X_Special_Payment_Amount2 NUMBER DEFAULT NULL,
246 X_Special_Period_Name2 VARCHAR2 DEFAULT NULL,
247 X_Description VARCHAR2 DEFAULT NULL,
248 X_Paid_Flag1 VARCHAR2 DEFAULT NULL,
249 X_Paid_Flag2 VARCHAR2 DEFAULT NULL,
250 X_Hold_Lookup_Code VARCHAR2 DEFAULT NULL,
251 X_Hold_Reason VARCHAR2 DEFAULT NULL,
252 X_Approved_By NUMBER DEFAULT NULL,
253 X_Expiry_Date DATE DEFAULT NULL,
254 X_Attribute_Category VARCHAR2 DEFAULT NULL,
255 X_Attribute1 VARCHAR2 DEFAULT NULL,
256 X_Attribute2 VARCHAR2 DEFAULT NULL,
257 X_Attribute3 VARCHAR2 DEFAULT NULL,
258 X_Attribute4 VARCHAR2 DEFAULT NULL,
259 X_Attribute5 VARCHAR2 DEFAULT NULL,
260 X_Exchange_Rate_Type VARCHAR2 DEFAULT NULL,
261 X_Payment_Cross_Rate NUMBER,
262 X_Exchange_Date DATE DEFAULT NULL,
263 X_Last_Update_Login NUMBER DEFAULT NULL,
264 X_Tax_Name VARCHAR2 DEFAULT NULL,
265 X_Attribute11 VARCHAR2 DEFAULT NULL,
266 X_Attribute12 VARCHAR2 DEFAULT NULL,
267 X_Attribute13 VARCHAR2 DEFAULT NULL,
268 X_Attribute14 VARCHAR2 DEFAULT NULL,
269 X_Attribute6 VARCHAR2 DEFAULT NULL,
270 X_Attribute7 VARCHAR2 DEFAULT NULL,
271 X_Attribute8 VARCHAR2 DEFAULT NULL,
272 X_Attribute9 VARCHAR2 DEFAULT NULL,
273 X_Attribute10 VARCHAR2 DEFAULT NULL,
274 X_Attribute15 VARCHAR2 DEFAULT NULL,
275 X_Exclusive_Payment_Flag VARCHAR2 DEFAULT NULL,
276 X_Awt_Group_Id NUMBER DEFAULT NULL,
277 X_Pay_Awt_Group_Id NUMBER DEFAULT NULL,--bug6639866
278 X_Org_Id NUMBER DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID,
279 X_Po_Header_Id NUMBER DEFAULT NULL,
280 X_Po_Line_Id NUMBER DEFAULT NULL,
281 X_Line_Location_Id NUMBER DEFAULT NULL,
282 X_External_Bank_Account_Id NUMBER DEFAULT NULL,
283 X_calling_sequence VARCHAR2,
284 X_Approval_Required_Flag VARCHAR2,
285 -- Removed for bug 4277744
286 -- X_USSGL_Txn_Code VARCHAR2 ,
287 X_Requester_id NUMBER DEFAULT NULL,
288 X_Po_Release_Id NUMBER DEFAULT NULL,
289 X_Item_Description VARCHAR2 DEFAULT NULL,
290 X_Manufacturer VARCHAR2 DEFAULT NULL,
291 X_Model_Number VARCHAR2 DEFAULT NULL,
292 X_Tax_Control_Amount NUMBER DEFAULT NULL,
293 X_Taxation_Country VARCHAR2 DEFAULT NULL,
294 X_Product_Fisc_Class VARCHAR2 DEFAULT NULL,
295 X_User_Defined_Fisc_Class VARCHAR2 DEFAULT NULL,
296 X_Trx_Bus_Category VARCHAR2 DEFAULT NULL,
297 X_Primary_Intended_Use VARCHAR2 DEFAULT NULL,
298 X_Legal_Entity_Id NUMBER DEFAULT NULL,
299 x_PAYMENT_METHOD_CODE varchar2 default null,
300 x_PAYMENT_REASON_CODE varchar2 default null,
301 x_remittance_message1 varchar2 default null,
302 x_remittance_message2 varchar2 default null,
303 x_remittance_message3 varchar2 default null,
304 x_bank_charge_bearer varchar2 default null,
305 x_settlement_priority varchar2 default null,
306 x_payment_reason_comments varchar2 default null,
307 x_delivery_channel_code varchar2 default null,
308 x_first_amount NUMBER, -- 2794958 (2774932)
309 X_REMIT_TO_SUPPLIER_NAME VARCHAR2 DEFAULT NULL,
310 X_REMIT_TO_SUPPLIER_ID NUMBER DEFAULT NULL,
311 X_REMIT_TO_SUPPLIER_SITE VARCHAR2 DEFAULT NULL,
312 X_REMIT_TO_SUPPLIER_SITE_ID NUMBER DEFAULT NULL,
313 X_RELATIONSHIP_ID NUMBER DEFAULT NULL
314 );
315
316 PROCEDURE Delete_Row(X_Rowid VARCHAR2,
317 X_calling_sequence VARCHAR2);
318
319 END AP_RECURRING_PAYMENTS_PKG;