PACKAGE: APPS.AR_DEP_BAL_RPT_PKG

Source

1 PACKAGE AR_DEP_BAL_RPT_PKG
2 -- $Header: AR_DEPBALRPT_PS.pls 120.0.12000000.1 2007/10/25 11:33:42 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_DEP_BAL_RPT_PKG
13 --
14 -- DESCRIPTION
15 --  This script creates the package specification of AR_DEP_BAL_RPT_PKG
16 --  This package is used to report on Deposit Balance Detail .
17 --
18 -- USAGE
19 --   To install       sqlplus <apps_user>/<apps_pwd> @AR_DEPBALRPT_PS.pls
20 --   To execute       sqlplus <apps_user>/<apps_pwd> AR_DEP_BAL_RPT_PKG
21 --
22 -- PROGRAM LIST       DESCRIPTION
23 --
24 -- DEPENDENCIES
25 --   None
26 --
27 -- CALLED BY
28 --   Deposit Balance Report - Japan.
29 --
30 -- LAST UPDATE DATE   27-Jul-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 27-Jul-2007 Rakesh Pulla     Initial Creation
39 -- Draft1B 13-Aug-2007 Rakesh Pulla     Incorporated the SO Review comments as per Ref # 28859
40 --************************************************************************
41 AS
42 
43 P_CUSTOMER        VARCHAR2(100);
44 P_CUSTOMER_NAME   VARCHAR2(100);
45 P_CURRENCY        VARCHAR2(30);
46 P_CUSTOMER_DUMMY  VARCHAR2(360);
47 P_PERIOD_FROM     VARCHAR2(100);
48 P_PERIOD_TO       VARCHAR2(100);
49 
50 /* Global Variables */
51 gn_ledger_id      NUMBER;
52 gn_cust_id        NUMBER;
53 gc_customer       VARCHAR2(100);
54 gc_currency       VARCHAR2(100);
55 gc_per_start_date VARCHAR2(100);
56 gc_per_end_date   VARCHAR2(100);
57 
58 FUNCTION beforeReport  RETURN BOOLEAN ;
59 FUNCTION description(p_value IN VARCHAR2, p_segment IN VARCHAR2) RETURN VARCHAR2;
60 FUNCTION commitment_balance( p_customer_trx_id      IN NUMBER) RETURN NUMBER;
61 
62 END AR_DEP_BAL_RPT_PKG;