PACKAGE: APPS.FA_TAX_ACCT_CARD_PKG

Source

1 PACKAGE fa_tax_acct_card_pkg AUTHID CURRENT_USER AS
2 -- $Header: fastacps.pls 120.1.12010000.2 2009/07/19 08:19:31 glchen ship $
3 -- ****************************************************************************************
4 -- Copyright (c)  2000  Oracle Solution Services (India)     Product Development
5 -- All rights reserved
6 -- ****************************************************************************************
7 --
8 -- PROGRAM NAME
9 -- fastacps.pls
10 --
11 -- DESCRIPTION
12 --  This script creates the package specification of fastacps.pls
13 --  This package is used to generate Asset Tax Accounting Card - Russia.
14 --
15 -- USAGE
16 --   To install        How to Install
17 --   To execute        How to Execute
18 --
19 -- PROGRAM LIST                                 DESCRIPTION
20 --  beforereport                                      initializes the where clauses with appropriate values
21 --  get_dff_column_name                     fetches DFF column names
22 --
23 -- DEPENDENCIES
24 --   None.
25 --
26 --
27 -- LAST UPDATE DATE   26-FEB-2007
28 --   Date the program has been modified for the last time
29 --
30 -- HISTORY
31 -- =======
32 --
33 -- VERSION   DATE           AUTHOR(S)                 DESCRIPTION
34 -- ------- ----------- ------------------- ---------------------------
35 --  1.0    25-FEB-2007  Srikanth Mallikarjun Gupta     Creation
36 --****************************************************************************************
37 
38 --******************************************************
39 --Variables to Hold the Parameter Values
40 --******************************************************
41 
42 P_BOOK_NAME                VARCHAR2(15);
43 P_CATEGORY_FLEX_STRUCTURE  NUMBER;
44 P_ASSET_CATEGORY           VARCHAR2(150);
45 P_ASSET_NUMBER             VARCHAR2(150);
46 
47 
48 --*******************************************************
49 --Constants to obtain dynamic values
50 --*******************************************************
51 
52 lc_state_reg_date            VARCHAR2(40);
53 lc_years                     VARCHAR2(40);
54 lc_months                    VARCHAR2(40);
55 lc_tax_book_cost             VARCHAR2(40);
56 lc_reference                 VARCHAR2(40);
57 lc_event_date                VARCHAR2(40);
58 lc_suspense_reason           VARCHAR2(40);
59 lc_adjusting_coefficient     VARCHAR2(40);
60 lc_adj_rate_reason           VARCHAR2(40);
61 lc_base_rate                 VARCHAR2(40);
62 lc_company_name              VARCHAR2(40);
63 lc_last_deprn_period         VARCHAR2(40);
64 lc_currency_code             VARCHAR2(40);
65 lc_asset_category_where      VARCHAR2(300);
66 lc_asset_number_where        VARCHAR2(300);
67 
68 --*******************************************************
69 --Public Functions
70 --*******************************************************
71 
72 FUNCTION beforereport RETURN BOOLEAN;
73 FUNCTION get_dff_column_name(p_appln_id      in  NUMBER
74 							 ,p_dff_name     in  VARCHAR2
75 							 ,p_segment_name in  VARCHAR2
76 							) RETURN VARCHAR2;
77 
78 END fa_tax_acct_card_pkg;