PACKAGE: APPS.GCS_DYN_FEM_POSTING_PKG

Source

1 PACKAGE GCS_DYN_FEM_POSTING_PKG AUTHID CURRENT_USER AS
2 /* $Header: gcsdynfemps.pls 120.3 2006/02/07 01:43:23 yingliu noship $ */
3 --
4 -- Package
5 --   gcs_dyn_fem_posting_pkg
6 -- Purpose
7 --   Posting engine for GCS
8 -- History
9 --   12-OCT-03	R Goyal		Created
10 
11 --
12 
13   --
14   -- Function
15   --   Gcs_Fem_Post
16   -- Purpose
17   --   Call the appropriate procedure based on whether the mode is 'Insert', 'Merge' or 'Delta'.
18   --   This procedure is called from the Consolidation engine.
19   -- Arguments
20   --   errbuf:  Buffer to hold the error message
21   --   retcode: Return code
22   --   p_run_name : Consolidation run name
23   --   p_hierarchy_id: Hierarchy id being processed
24   --   p_balance_type_code : Actuals or Averages
25   --   p_category_code: Category ( Data Prep, Translation, Intercompany, etc)
26   --   p_cons_entity_id: Consolidation entity Id
27   --   p_child_entity_id: Child entity Id
28   --   p_cal_period_id: Period being consolidated
29   --   p_undo: Undo mode - 'Y' for running in undo mode, default is 'N'
30   --   p_run_detail_id: Run detail id for a consolidation run
31   --   p_mode : 'I', "M' or 'D' for Insert, Merge or Delta
32   --   p_entry_id : Entry_Id to be processed
33   -- Example
34   --
35   -- Notes
36   --
37 
38    PROCEDURE Gcs_Fem_Post (
39                         errbuf       OUT NOCOPY VARCHAR2,
40                         retcode      OUT NOCOPY VARCHAR2,
41                         p_run_name              VARCHAR2,
42    			p_hierarchy_id          NUMBER,
43                         p_balance_type_code     VARCHAR2,
44                         p_category_code         VARCHAR2,
45 			p_cons_entity_id        NUMBER,
46                 	p_child_entity_id       NUMBER DEFAULT NULL,
47                         p_cal_period_id         NUMBER,
48                 	p_undo                  VARCHAR2 DEFAULT 'N',
49                         p_xlate                 VARCHAR2,
50                 	p_run_detail_id         NUMBER DEFAULT NULL,
51 			p_mode			VARCHAR2,
52                         p_entry_id              NUMBER DEFAULT NULL,
53                         p_hier_dataset_code     NUMBER);
54 
55 
56   --
57   -- Procedure
58   --   Gcs_Fem_Delete
59   -- Purpose
60   --   Delete rows from FEM_BALANCES
61   -- Arguments
62   --   errbuf           Error buffer
63   --   retcode          Return code
64   --   p_hierarchy_id : Hierarchy being processed
65   --   p_balance_type_code : Actuals vs. Averages
66   --   p_cal_period_id: Period being consolidated
67   --   p_entity_type:   'E' for Elimimation and 'O' for Operating entity
68   --   p_entity_id:     Entity being processed
69   -- Example
70   --
71   -- Notes
72   --
73 
74   PROCEDURE GCS_Fem_Delete(
75 			errbuf       OUT NOCOPY VARCHAR2,
76 			retcode      OUT NOCOPY VARCHAR2,
77 			p_hierarchy_id          NUMBER,
78                         p_balance_type_code     VARCHAR2,
79 			p_cal_period_id         NUMBER,
80                         p_entity_type           VARCHAR2,
81                         p_entity_id             NUMBER,
82                         p_hier_dataset_code     NUMBER);
83 
84 
85 
86 END GCS_DYN_FEM_POSTING_PKG;