DBA Data[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;