1 PACKAGE AP_GET_SUPPLIER_BALANCE_PKG AS
2 /* $Header: apxsobls.pls 120.3 2005/05/13 08:10:05 sguddeti noship $ */
3
4
5 Procedure AP_GET_SUPPLIER_BALANCE( p_request_id in number
6 ,p_set_of_books_id number
7 ,p_as_of_date in date
8 ,p_supplier_name_from in varchar2
9 ,p_supplier_name_to in varchar2
10 ,p_currency in varchar2
11 ,p_min_invoice_balance in number
12 ,p_min_open_balance in number
13 ,p_include_prepayments in varchar2
14 ,p_reference_number in varchar2
15 ,p_debug_flag in varchar2
16 ,p_trace_flag in varchar2
17 ) ;
18
19 FUNCTION get_paid_amount_on_ao_date -- 2901541
20 (p_invoice_id IN NUMBER,
21 p_as_of_date IN DATE) RETURN NUMBER;
22
23 FUNCTION invoice_is_open_on_ao_date
24 (p_invoice_id IN NUMBER,
25 p_as_of_date IN DATE) RETURN BOOLEAN; -- 2901541
26
27 end AP_GET_SUPPLIER_BALANCE_PKG;