DBA Data[Home] [Help]

PACKAGE: APPS.AP_GET_SUPPLIER_BALANCE_PKG

Source


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;