1 PACKAGE AP_AUTOSELECT_PKG AUTHID CURRENT_USER AS
2 /* $Header: appbsels.pls 120.5 2011/03/31 05:01:37 ppodhiya ship $ */
3
4 FUNCTION prorated_awt_gross_amt
5 ( p_invoice_id NUMBER
6 , p_payment_num NUMBER
7 )
8 RETURN NUMBER;
9
10 PROCEDURE select_invoices (errbuf OUT NOCOPY VARCHAR2,
11 retcode OUT NOCOPY NUMBER,
12 p_checkrun_id in varchar2,
13 p_template_id in varchar2,
14 p_payment_date in varchar2,
15 p_pay_thru_date in varchar2,
16 p_pay_from_date in varchar2);
17
18 PROCEDURE remove_invoices (p_checkrun_id in number,
19 p_calling_sequence in varchar2);
20
21
22 PROCEDURE awt_special_rounding (p_checkrun_name in varchar2,
23 p_calling_sequence in varchar2); --Bug6459578
24
25
26 PROCEDURE recalculate (errbuf OUT NOCOPY VARCHAR2,
27 retcode OUT NOCOPY NUMBER,
28 p_checkrun_id in varchar2,
29 p_submit_to_iby in varchar2 default 'N');
30
31
32
33 PROCEDURE cancel_batch (errbuf OUT NOCOPY VARCHAR2,
34 retcode OUT NOCOPY NUMBER,
35 p_checkrun_id in varchar2);
36
37
38 PROCEDURE selection_criteria_report(errbuf OUT NOCOPY VARCHAR2,
39 retcode OUT NOCOPY NUMBER,
40 p_checkrun_id in varchar2);
41
42
43 FUNCTION get_prepay_with_tax(p_invoice_id in number)
44 RETURN NUMBER;
45
46 PROCEDURE mark_overpayments ( p_checkrun_id in number,
47 p_checkrun_name in varchar2,
48 p_calling_sequence in varchar2);
49
50 -- 11824219.
51 -- API invoked by IBY to verify whether a list of payable documents
52 -- can be removed or not. Invoice schedules and related interest invoice
53 -- schedules should be removed together. API checks whether the
54 -- standard/interest invoice pair go hand in hand or not, either both
55 -- removed or both retained. API returns success if the list of payables
56 -- documents can be removed.
57
58 PROCEDURE check_doc_payable_remove
59 ( p_rejected_docs_group_id IN NUMBER,
60 x_return_status OUT nocopy VARCHAR2) ;
61
62 END;
63