1 PACKAGE GCS_AGGREGATION_DYNAMIC_PKG AUTHID CURRENT_USER AS
2 /* $Header: gcsaggds.pls 120.1 2005/10/30 05:16:58 appldev noship $ */
3 --
4 -- Package
5 -- gcs_aggregation_dynamic_pkg
6 -- Purpose
7 -- Package procedures for the Aggregation Dynamic Program
8 -- History
9 -- 17-FEB-04 T Cheng Created
10 -- Notes
11 -- The package body is created by gcs_aggregation_dyn_build_pkg.
12 --
13
14 --
15 -- PUBLIC FUNCTIONS
16 --
17
18 --
19 -- Procedure
20 -- retrieve_org_id
21 -- Purpose
22 -- For internal use in insert_full_entry_lines.
23 -- Arguments
24 -- p_entity_id ID of entity
25 -- Example
26 -- * None *
27 -- Notes
28 -- FOR INTERNAL USE IN THIS PACKAGE ONLY unless a procedure for
29 -- populating the internal structure is made available.
30 --
31 FUNCTION retrieve_org_id(p_entity_id NUMBER) RETURN NUMBER;
32
33 --
34 -- Procedure
35 -- insert_full_entry_lines
36 -- Purpose
37 -- Create entry lines with the full consolidation amounts.
38 -- Arguments
39 -- p_entry_id Entry Id for the consolidation entity's currency
40 -- p_stat_entry_id Entry Id for STAT
41 -- p_cons_entity_id ID of the consolidation entity
42 -- p_hierarchy_id ID of the hierarchy consolidation is run for
43 -- p_relationship_id ID of the relationship between the entity
44 -- and its parent
45 -- p_cal_period_id ID of the period consolidation is run for
46 -- p_period_end_date The end date of the period
47 -- p_currency_code Currency code of the consolidation entity
48 -- p_balance_type_code Balance type code
49 -- p_dataset_code Dataset of the information in the entry
50 -- Example
51 -- GCS_AGGREGATION_DYNAMIC_PKG.insert_full_entry_lines
52 -- (1001, 1002, 2, 1000, 200312, <date>, 'USD', 10001);
53 -- Notes
54 --
55 PROCEDURE insert_full_entry_lines(
56 p_entry_id NUMBER,
57 p_stat_entry_id NUMBER,
58 p_cons_entity_id NUMBER,
59 p_hierarchy_id NUMBER,
60 p_relationship_id NUMBER,
61 p_cal_period_id NUMBER,
62 p_period_end_date DATE,
63 p_currency_code VARCHAR2,
64 p_balance_type_code VARCHAR2,
65 p_dataset_code NUMBER);
66
67 END GCS_AGGREGATION_DYNAMIC_PKG;