1 PACKAGE GCS_AGGREGATION_PKG AS
2 /* $Header: gcsaggrs.pls 120.2 2006/02/06 19:34:37 yingliu noship $ */
3 --
4 -- Package
5 -- gcs_aggregation_pkg
6 -- Purpose
7 -- Package procedures for the Aggregation Program
8 -- History
9 -- 17-FEB-04 T Cheng Created
10 --
11
12 --
13 -- PUBLIC GLOBAL VARIABLES
14 --
15
16 -- Holds fnd_global.user_id and login_id
17 g_fnd_user_id NUMBER;
18 g_fnd_login_id NUMBER;
19
20 --
21 -- PUBLIC FUNCTIONS
22 --
23
24 --
25 -- Procedure
26 -- Aggregate
27 -- Purpose
28 -- Aggregate child entities data for a consolidation entity.
29 -- Arguments
30 -- p_run_detail_id ID of the aggregation run
31 -- p_hierarchy_id ID of the hierarchy consolidation is run for
32 -- p_relationship_id ID of the relationship between the
33 -- consolidation entity and its parent
34 -- p_cons_entity_id ID of the consolidation entity
35 -- p_cal_period_id ID of the period consolidation is run for
36 -- p_period_end_date The end date of the period
37 -- p_balance_type_code Balance type code
38 -- p_stat_required Y/N, whether processing is needed for STAT
39 -- Example
40 -- GCS_AGGREGATION_PKG.Aggregate(errbuf, retcode, 111,
41 -- 100, 1, 2, 200401, <date>, 'ACTUAL', 'N');
42 -- Notes
43 --
44 PROCEDURE Aggregate(
45 p_errbuf OUT NOCOPY VARCHAR2,
46 p_retcode OUT NOCOPY VARCHAR2,
47 p_run_detail_id NUMBER,
48 p_hierarchy_id NUMBER,
49 p_relationship_id NUMBER,
50 p_cons_entity_id NUMBER,
51 p_cal_period_id NUMBER,
52 p_period_end_date DATE,
53 p_balance_type_code VARCHAR2,
54 p_stat_required VARCHAR2,
55 p_hier_dataset_code NUMBER);
56
57 END GCS_AGGREGATION_PKG;