170: ORDER BY abs(AID.Amount); --bug 5410819
171:
172:
173: PROCEDURE Primary_Pay_Events
174: (P_XLA_Event_Rec IN ap_accounting_pay_pkg.r_xla_event_info
175: ,P_Calling_Sequence IN VARCHAR2
176: );
177:
178: PROCEDURE Manual_Pay_Adj_Events
175: ,P_Calling_Sequence IN VARCHAR2
176: );
177:
178: PROCEDURE Manual_Pay_Adj_Events
179: (P_XLA_Event_Rec IN ap_accounting_pay_pkg.r_xla_event_info
180: ,P_Calling_Sequence IN VARCHAR2
181: );
182:
183: PROCEDURE Cancel_Primary_Pay_Events
180: ,P_Calling_Sequence IN VARCHAR2
181: );
182:
183: PROCEDURE Cancel_Primary_Pay_Events
184: (P_XLA_Event_Rec IN ap_accounting_pay_pkg.r_xla_event_info
185: ,P_Calling_Sequence IN VARCHAR2
186: );
187:
188: PROCEDURE Pay_Dist_Cascade_Adj_Events
185: ,P_Calling_Sequence IN VARCHAR2
186: );
187:
188: PROCEDURE Pay_Dist_Cascade_Adj_Events
189: (P_XLA_Event_Rec IN ap_accounting_pay_pkg.r_xla_event_info
190: ,P_Calling_Sequence IN VARCHAR2
191: );
192:
193:
191: );
192:
193:
194: PROCEDURE Pay_Dist_Proc
195: (P_XLA_Event_Rec IN ap_accounting_pay_pkg.r_xla_event_info
196: ,P_Inv_Pay_Rec IN r_inv_pay_info
197: ,P_Pay_Hist_Rec IN ap_accounting_pay_pkg.r_pay_hist_info
198: ,P_Inv_Rec IN ap_accounting_pay_pkg.r_invoices_info
199: ,P_Inv_Dist_Rec IN ap_accounting_pay_pkg.r_inv_dist_info
193:
194: PROCEDURE Pay_Dist_Proc
195: (P_XLA_Event_Rec IN ap_accounting_pay_pkg.r_xla_event_info
196: ,P_Inv_Pay_Rec IN r_inv_pay_info
197: ,P_Pay_Hist_Rec IN ap_accounting_pay_pkg.r_pay_hist_info
198: ,P_Inv_Rec IN ap_accounting_pay_pkg.r_invoices_info
199: ,P_Inv_Dist_Rec IN ap_accounting_pay_pkg.r_inv_dist_info
200: ,P_Calc_Mode IN VARCHAR2
201: ,P_Final_Payment IN BOOLEAN
194: PROCEDURE Pay_Dist_Proc
195: (P_XLA_Event_Rec IN ap_accounting_pay_pkg.r_xla_event_info
196: ,P_Inv_Pay_Rec IN r_inv_pay_info
197: ,P_Pay_Hist_Rec IN ap_accounting_pay_pkg.r_pay_hist_info
198: ,P_Inv_Rec IN ap_accounting_pay_pkg.r_invoices_info
199: ,P_Inv_Dist_Rec IN ap_accounting_pay_pkg.r_inv_dist_info
200: ,P_Calc_Mode IN VARCHAR2
201: ,P_Final_Payment IN BOOLEAN
202: ,P_Calling_Sequence IN VARCHAR2
195: (P_XLA_Event_Rec IN ap_accounting_pay_pkg.r_xla_event_info
196: ,P_Inv_Pay_Rec IN r_inv_pay_info
197: ,P_Pay_Hist_Rec IN ap_accounting_pay_pkg.r_pay_hist_info
198: ,P_Inv_Rec IN ap_accounting_pay_pkg.r_invoices_info
199: ,P_Inv_Dist_Rec IN ap_accounting_pay_pkg.r_inv_dist_info
200: ,P_Calc_Mode IN VARCHAR2
201: ,P_Final_Payment IN BOOLEAN
202: ,P_Calling_Sequence IN VARCHAR2
203: );
203: );
204:
205:
206: PROCEDURE Pay_Dist_Discount
207: (P_XLA_Event_Rec IN ap_accounting_pay_pkg.r_xla_event_info
208: ,P_Inv_Pay_Rec IN r_inv_pay_info
209: ,P_Pay_Hist_Rec IN ap_accounting_pay_pkg.r_pay_hist_info
210: ,P_Inv_Rec IN ap_accounting_pay_pkg.r_invoices_info
211: ,P_Inv_Dist_Rec IN ap_accounting_pay_pkg.r_inv_dist_info
205:
206: PROCEDURE Pay_Dist_Discount
207: (P_XLA_Event_Rec IN ap_accounting_pay_pkg.r_xla_event_info
208: ,P_Inv_Pay_Rec IN r_inv_pay_info
209: ,P_Pay_Hist_Rec IN ap_accounting_pay_pkg.r_pay_hist_info
210: ,P_Inv_Rec IN ap_accounting_pay_pkg.r_invoices_info
211: ,P_Inv_Dist_Rec IN ap_accounting_pay_pkg.r_inv_dist_info
212: ,P_Calc_Mode IN VARCHAR2
213: ,P_Disc_Pay_Amount IN OUT NOCOPY NUMBER
206: PROCEDURE Pay_Dist_Discount
207: (P_XLA_Event_Rec IN ap_accounting_pay_pkg.r_xla_event_info
208: ,P_Inv_Pay_Rec IN r_inv_pay_info
209: ,P_Pay_Hist_Rec IN ap_accounting_pay_pkg.r_pay_hist_info
210: ,P_Inv_Rec IN ap_accounting_pay_pkg.r_invoices_info
211: ,P_Inv_Dist_Rec IN ap_accounting_pay_pkg.r_inv_dist_info
212: ,P_Calc_Mode IN VARCHAR2
213: ,P_Disc_Pay_Amount IN OUT NOCOPY NUMBER
214: ,P_Disc_Dist_Amount IN OUT NOCOPY NUMBER
207: (P_XLA_Event_Rec IN ap_accounting_pay_pkg.r_xla_event_info
208: ,P_Inv_Pay_Rec IN r_inv_pay_info
209: ,P_Pay_Hist_Rec IN ap_accounting_pay_pkg.r_pay_hist_info
210: ,P_Inv_Rec IN ap_accounting_pay_pkg.r_invoices_info
211: ,P_Inv_Dist_Rec IN ap_accounting_pay_pkg.r_inv_dist_info
212: ,P_Calc_Mode IN VARCHAR2
213: ,P_Disc_Pay_Amount IN OUT NOCOPY NUMBER
214: ,P_Disc_Dist_Amount IN OUT NOCOPY NUMBER
215: ,P_Disc_Bank_Amount IN OUT NOCOPY NUMBER
216: ,P_Calling_Sequence IN VARCHAR2
217: );
218:
219: PROCEDURE Pay_Dist_ERV
220: (P_XLA_Event_Rec IN ap_accounting_pay_pkg.r_xla_event_info
221: ,P_Inv_Pay_Rec IN r_inv_pay_info
222: ,P_Pay_Hist_Rec IN ap_accounting_pay_pkg.r_pay_hist_info
223: ,P_Inv_Rec IN ap_accounting_pay_pkg.r_invoices_info
224: ,P_Inv_Dist_Rec IN ap_accounting_pay_pkg.r_inv_dist_info
218:
219: PROCEDURE Pay_Dist_ERV
220: (P_XLA_Event_Rec IN ap_accounting_pay_pkg.r_xla_event_info
221: ,P_Inv_Pay_Rec IN r_inv_pay_info
222: ,P_Pay_Hist_Rec IN ap_accounting_pay_pkg.r_pay_hist_info
223: ,P_Inv_Rec IN ap_accounting_pay_pkg.r_invoices_info
224: ,P_Inv_Dist_Rec IN ap_accounting_pay_pkg.r_inv_dist_info
225: ,P_Prorated_Amount IN NUMBER
226: ,P_Calling_Sequence IN VARCHAR2
219: PROCEDURE Pay_Dist_ERV
220: (P_XLA_Event_Rec IN ap_accounting_pay_pkg.r_xla_event_info
221: ,P_Inv_Pay_Rec IN r_inv_pay_info
222: ,P_Pay_Hist_Rec IN ap_accounting_pay_pkg.r_pay_hist_info
223: ,P_Inv_Rec IN ap_accounting_pay_pkg.r_invoices_info
224: ,P_Inv_Dist_Rec IN ap_accounting_pay_pkg.r_inv_dist_info
225: ,P_Prorated_Amount IN NUMBER
226: ,P_Calling_Sequence IN VARCHAR2
227: );
220: (P_XLA_Event_Rec IN ap_accounting_pay_pkg.r_xla_event_info
221: ,P_Inv_Pay_Rec IN r_inv_pay_info
222: ,P_Pay_Hist_Rec IN ap_accounting_pay_pkg.r_pay_hist_info
223: ,P_Inv_Rec IN ap_accounting_pay_pkg.r_invoices_info
224: ,P_Inv_Dist_Rec IN ap_accounting_pay_pkg.r_inv_dist_info
225: ,P_Prorated_Amount IN NUMBER
226: ,P_Calling_Sequence IN VARCHAR2
227: );
228:
227: );
228:
229: -- bug 5659368
230: PROCEDURE Pay_Dist_Err_Chrg
231: (p_xla_event_rec IN ap_accounting_pay_pkg.r_xla_event_info
232: ,p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
233: ,p_distribute_mode IN VARCHAR2
234: ,p_calling_sequence IN VARCHAR2
235: );
228:
229: -- bug 5659368
230: PROCEDURE Pay_Dist_Err_Chrg
231: (p_xla_event_rec IN ap_accounting_pay_pkg.r_xla_event_info
232: ,p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
233: ,p_distribute_mode IN VARCHAR2
234: ,p_calling_sequence IN VARCHAR2
235: );
236:
235: );
236:
237: -- Bug 6887295. Added parameter p_inv_dist_rec
238: PROCEDURE Pay_Dist_Reverse
239: (p_xla_event_rec IN ap_accounting_pay_pkg.r_xla_event_info
240: ,p_inv_pay_rec IN r_inv_pay_info
241: ,p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
242: ,p_reversal_inv_pmt_id IN NUMBER
243: ,p_related_event_id IN NUMBER
237: -- Bug 6887295. Added parameter p_inv_dist_rec
238: PROCEDURE Pay_Dist_Reverse
239: (p_xla_event_rec IN ap_accounting_pay_pkg.r_xla_event_info
240: ,p_inv_pay_rec IN r_inv_pay_info
241: ,p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
242: ,p_reversal_inv_pmt_id IN NUMBER
243: ,p_related_event_id IN NUMBER
244: ,p_invoice_dist_id IN NUMBER
245: ,p_inv_dist_rec IN ap_accounting_pay_pkg.r_inv_dist_info
241: ,p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
242: ,p_reversal_inv_pmt_id IN NUMBER
243: ,p_related_event_id IN NUMBER
244: ,p_invoice_dist_id IN NUMBER
245: ,p_inv_dist_rec IN ap_accounting_pay_pkg.r_inv_dist_info
246: ,p_calling_sequence IN VARCHAR2
247: );
248:
249:
252: ,P_Calling_Sequence IN VARCHAR2
253: );
254:
255: PROCEDURE Upg_Dist_Links_Insert
256: (p_xla_event_rec IN ap_accounting_pay_pkg.r_xla_event_info
257: ,p_payment_history_id IN NUMBER
258: ,p_accounting_event_id IN NUMBER
259: ,p_calling_sequence IN VARCHAR2
260: );