PACKAGE: APPS.JG_ZZ_VAT_YEARLY_EXT_PKG

Source

1 PACKAGE JG_ZZ_VAT_YEARLY_EXT_PKG
2 -- $Header: jgzzyexrs.pls 120.1 2010/08/05 14:44:22 gkumares noship $
3   --*************************************************************************
4   -- Copyright (c)  2000    Oracle                 Product Development
5   -- All rights reserved
6   --*************************************************************************
7 
8   -- HEADER
9   --   Source control header
10 
11   -- PROGRAM NAME
12   -- jgzzyexrs.pls
13 
14   -- DESCRIPTION
15   -- This script creates the package specification of JG_ZZ_VAT_YEARLY_EXT_PKG
16   -- This package AUTHID CURRENT_USER is used to report on EMEA VAT: Yearly Extract Report.
17 
18   -- USAGE
19   -- To install       sqlplus <apps_user>/<apps_pwd> @jgzzyexrs.pls
20   -- To execute       sqlplus <apps_user>/<apps_pwd> JG_ZZ_VAT_YEARLY_EXT_PKG
21 
22   -- PROGRAM LIST       DESCRIPTION
23 
24   -- DEPENDENCIES
25   -- None
26 
27   -- CALLED BY
28   -- EMEA VAT: Yearly Extract Report
29 
30   -- LAST UPDATE DATE   02-Feb-2009
31   -- Date the program has been modified for the last time
32 
33   -- HISTORY
34   -- =======
35 
36   -- VERSION DATE        AUTHOR(S)       DESCRIPTION
37   -- ------- ----------- --------------- ------------------------------------
38   -- Draft1A 20-Oct-2008 Rakesh Pulla     Initial Creation
39   --************************************************************************
40   AS
41   P_REPORTING_ENTITY_ID  NUMBER;
42   P_TAX_CALENDAR_YEAR    NUMBER;
43   P_LEVEL                VARCHAR2(30);
44   GN_RETURN_CODE         NUMBER;
45 
46   FUNCTION beforeReport RETURN BOOLEAN;
47   FUNCTION afterReport  RETURN BOOLEAN;
48 
49 END JG_ZZ_VAT_YEARLY_EXT_PKG;