1 PACKAGE GL_OPEN_BAL_REVAL_RPT_PKG AUTHID CURRENT_USER AS
2 -- $Header: glxobrvs.pls 120.0.12000000.1 2007/10/23 15:50:31 sgudupat noship $
3 --*************************************************************************
4 -- Copyright (c) 2000 Oracle Corporation
5 -- All rights reserved
6 --*************************************************************************
7 --
8 --
9 -- PROGRAM NAME
10 -- glxobrvs.pls
11 --
12 -- DESCRIPTION
13 -- This script creates the package specification of GL_OPEN_BAL_REVAL_RPT_PKG.
14 -- This package is used for builidng all the necessary PL/SQL Logic for the
15 -- report "GL Open Balances Revaluation"
16 --
17 -- USAGE
18 -- To install How to Install
19 -- To execute How to Execute
20 --
21 -- PROGRAM LIST DESCRIPTION
22 -- beforereport It is a public function used to intialize global variables
23 -- which will be used to build the quries in the Data Template Dynamically
24 -- get_reval_conversion_rate
25 -- It is a public function which takes p_code_combination_id,
26 -- p_account and p_currency as input parameters and will retun
27 -- the conversion rate used by the revaluation program in the period
28 -- period_to_param
29 -- get_data_access_set_name
30 -- It is public function which returns the data access set name
31 -- based on the value of the parameter ACCESS_SET_ID_PARAM
32 -- get_ledger_name
33 -- It is a public function which returns the ledger name
34 -- based on the value of the parameter LEDGER_ID_PARAM
35 -- DEPENDENCIES
36 --
37 -- CALLED BY
38 -- All the public functions are used in the data template GLXOBRVR.xml
39 --
40 -- LAST UPDATE DATE 14-MAY-2007
41 --
42 -- HISTORY
43 -- =======
44 --
45 -- VERSION DATE AUTHOR(S) DESCRIPTION
46 -- ------- ----------- --------------- ------------------------------------
47 -- Draft1A 26-FEB-2007 Thirupathi Rao V Draft Version
48 --Draft1B 14-May-2007 Thirupathi Rao V Changed the name of the package as per comments from GL Team
49 --************************************************************************
50 -- Parameters in Data Template
51 LEDGER_ID_PARAM NUMBER;
52 LEDGER_NAME_PARAM VARCHAR2(30);
53 ACCESS_SET_ID_PARAM NUMBER;
54 COA_ID_PARAM NUMBER;
55 PERIOD_FROM_PARAM VARCHAR2(15);
56 PERIOD_TO_PARAM VARCHAR2(15);
57 CURRENCY_PARAM VARCHAR2(15);
58 ACCT_FROM_PARAM VARCHAR2(300);
59 ACCT_TO_PARAM VARCHAR2(300);
60 -- Global Variables
61 gd_start_date DATE;
62 gd_end_date DATE;
63 gc_access_where VARCHAR2(300);
64 gc_currency_where VARCHAR2(300);
65 FUNCTION beforereport RETURN BOOLEAN;
66 FUNCTION get_reval_conversion_rate ( p_code_combination_id IN NUMBER
67 ,p_account IN VARCHAR2
68 ,p_currency IN VARCHAR2) RETURN NUMBER;
69 FUNCTION get_data_access_set_name RETURN VARCHAR2;
70 FUNCTION get_ledger_name RETURN VARCHAR2;
71 END GL_OPEN_BAL_REVAL_RPT_PKG;