1 PACKAGE AR_CUST_BAL_RPT_PKG
2 -- $Header: AR_CBSLRPTS.pls 120.0.12000000.1 2007/10/23 14:12:14 sgudupat noship $
3 --*************************************************************************
4 -- Copyright (c) 2000 Oracle Product Development
5 -- All rights reserved
6 --*************************************************************************
7 --
8 -- HEADER
9 -- Source control header
10 --
11 -- PROGRAM NAME
12 -- AR_CBSLRPTS.pls
13 --
14 -- DESCRIPTION
15 -- This script creates the package specification of AR_CUST_BAL_RPT_PKG
16 -- This package is used to report on AR Customer Balance Statement Letter Report.
17 --
18 -- USAGE
19 -- To install sqlplus <apps_user>/<apps_pwd> @AR_CBSLRPTS.pls
20 -- To execute sqlplus <apps_user>/<apps_pwd> AR_CUST_BAL_RPT_PKG
21 --
22 -- PROGRAM LIST DESCRIPTION
23 --
24 -- DEPENDENCIES
25 -- None
26 --
27 -- CALLED BY
28 -- Statement Generation Program.
29 --
30 -- LAST UPDATE DATE 24-Jun-2007
31 -- Date the program has been modified for the last time
32 --
33 -- HISTORY
34 -- =======
35 --
36 -- VERSION DATE AUTHOR(S) DESCRIPTION
37 -- ------- ----------- --------------- ------------------------------------
38 -- Draft1A 02-Feb-2007 Sajana Doma Initial Creation
39 --
40 --
41 --************************************************************************
42 AS
43
44 -- To be used in query as bind variable
45
46 P_RESP_APPLICATION_ID NUMBER;
47 P_CONC_REQUEST_ID NUMBER;
48 P_SORT VARCHAR2(500);
49 P_SORT_BY_PHONETICS VARCHAR2(1);
50 P_AS_OF_DATE DATE;
51
52 FUNCTION BeforeReport RETURN BOOLEAN;
53 FUNCTION AfterReport RETURN BOOLEAN;
54
55 END AR_CUST_BAL_RPT_PKG;