[Home] [Help]
PACKAGE: APPS.FA_CIP_STAT_PKG
Source
1 PACKAGE FA_CIP_STAT_PKG AUTHID CURRENT_USER AS
2 -- $Header: FAWIPSTATPS.pls 120.1.12010000.2 2009/07/19 08:15:11 glchen ship $
3 -- ****************************************************************************************
4 -- Copyright (c) 2000 Oracle Solution Services (India) Product Development
5 -- All rights reserved
6 -- ****************************************************************************************
7 --
8 -- PROGRAM NAME
9 -- FAWIPSTATPS.pls
10 --
11 -- DESCRIPTION
12 -- This script creates the package specification of FA_CIP_STAT_PKG.
13 -- This package is used to generate FA CIP Statistics for the central Statistical Office (KSH) (Hungary).
14 -- USAGE
15 -- To install How to Install
16 -- To execute How to Execute
17 --
18 -- DEPENDENCIES
19 -- None.
20 --
21 --
22 -- LAST UPDATE DATE 26-JAN-2007
23 -- Date the program has been modified for the last time
24 --
25 -- HISTORY
26 -- =======
27 --
28 -- VERSION DATE AUTHOR(S) DESCRIPTION
29 -- ------- ----------- --------------- ------------------------------------
30 -- 1.0 26-JAN-2007 Praveen Gollu M Creation
31 --
32 --****************************************************************************************
33
34 P_BOOK VARCHAR2(15);
35 P_PERIOD1 VARCHAR2(15);
36 P_PERIOD2 VARCHAR2(15);
37 gn_accounting_flex_structure NUMBER;
38 gc_distribution_source_book VARCHAR2(15);
39 gn_precision NUMBER;
40 gc_currency_code VARCHAR2(15);
41 gd_period1_pod DATE;
42 gn_period1_pc NUMBER;
43 gd_Period2_PCD DATE;
44 gn_period2_pc NUMBER;
45
46 FUNCTION BookFormula RETURN VARCHAR2 ;
47 FUNCTION Period1Formula RETURN VARCHAR2 ;
48 FUNCTION Period2Formula RETURN VARCHAR2 ;
49 FUNCTION Accounting_Flex_Structure_p RETURN NUMBER;
50 FUNCTION DISTRIBUTION_SOURCE_BOOK_p RETURN VARCHAR2;
51 END FA_CIP_STAT_PKG;