PACKAGE: APPS.FA_DEP_SUMM_TAX_REG_PKG

Source

1 PACKAGE FA_DEP_SUMM_TAX_REG_PKG AUTHID CURRENT_USER
2 -- $Header: FADSTRPS.pls 120.1.12010000.1 2008/07/28 13:11:43 appldev ship $
3 -- ****************************************************************************************
4 -- Copyright (c)  2000  Oracle Solution Services (India)     Product Development
5 -- All rights reserved
6 -- ****************************************************************************************
7 --
8 -- PROGRAM NAME
9 --  FADSTRPS.pls
10 --
11 -- DESCRIPTION
12 --  This script creates the package specification of FA_DEP_SUMM_TAX_REG_PKG.
13 --  This package is used to generate Depreciation Summary Tax Register for Russia.
14 --
15 -- USAGE
16 --   To install        How to Install
17 --   To execute        How to Execute
18 --
19 -- PROGRAM           DESCRIPTION
20 -- beforereport      Used to assign values for the variables used
21 --                   for dynamic query.
22 -- currency_code     Used to obtain the Currency Code
23 -- company_code      Used to obtain the Company Code
24 --
25 -- DEPENDENCIES
26 --   None.
27 --
28 -- CALLED BY
29 --   DataTemplate Extract in Depreciation Summary Tax Register (Russia).
30 --
31 --
32 -- LAST UPDATE DATE   04-JAN-2007
33 --   Date the program has been modified for the last time
34 --
35 -- HISTORY
36 -- =======
37 --
38 -- VERSION   DATE           AUTHOR(S)          DESCRIPTION
39 -- -------   -----------    ---------------    ------------------------------------
40 -- 1.00      24-JAN-2007    Sandeep Kumar G.   Creation
41 --
42 -- ****************************************************************************************
43 AS
44 
45 /*=========================================
46 Variables to Hold the Parameter Values
47 =========================================*/
48 
49 P_BOOK          fa_books.book_type_code%TYPE;
50 P_PERIOD1       fa_deprn_periods.period_name%TYPE;
51 
52 /*=========================================
53 Lexical Variables to obtain dynamic values
54 =========================================*/
55 
56 gc_major_category       VARCHAR2(50);
57 gc_minor_category       VARCHAR2(50);
58 gn_maj_cat_value_set_id NUMBER;
59 gn_period_counter       NUMBER;
60 gc_pcd                  VARCHAR2(50);
61 gc_fiscal_year          VARCHAR2(50);
62 gc_cal_pcd              VARCHAR2(50);
63 gc_fiscal_start_date    VARCHAR2(50);
64 
65 gc_company_name         VARCHAR2(50);
66 gc_currency_code        VARCHAR2(50);
67 
68 /*=========================================
69 Public Functions
70 =========================================*/
71 
72 FUNCTION company_name  RETURN VARCHAR2;
73 FUNCTION currency_code RETURN VARCHAR2;
74 FUNCTION beforereport  RETURN BOOLEAN;
75 
76 
77 END FA_DEP_SUMM_TAX_REG_PKG;