1 PACKAGE GCS_DATA_PREP_PKG AUTHID CURRENT_USER AS
2 /* $Header: gcsdps.pls 120.2 2006/02/04 02:02:44 yingliu noship $ */
3 --
4 -- Package
5 -- GCS_DATA_PREP_PKG
6 -- Purpose
7 -- Package procedures for the Data Preparation Program
8 -- History
9 -- 08-Dec-03 Ying Liu Created
10 --
11
12 --
13 -- Procedure
14 -- GCS_MAIN_DATA_PREP
15 -- Purpose
16 -- This procedure will be called via the SRS submission performed by the Consolidation Engine. It will then call the appropriate routines to complete the data preparation process.
17 -- Arguments
18 -- x_errbuf Error Buffer used for SRS
19 -- x_retcode Return Code used for SRS
20 -- p_hierarchy_id Consolidation Hierarchy Identifier
21 -- p_entity_id Internal/External Entity Identifier
22 -- p_target_cal_period_id Target Calendar Period Identifier
23 -- p_execution_mode 'FULL', 'INCREMENTAL' Load
24 -- p_stat_entry_id Entry Identifier for lines with Currency Code STAT
25 -- p_entry_id Entry Identifier for other lines
26 -- p_proportional_entry_id Entry Identifier for proportional consolidation lines
27 -- if = -1, full consolidation
28 -- p_cons_rel_id Consolidation Relationships Identifier
29 -- Used for proportional consolidation
30 -- if = -1, full consolidation
31 -- p_balance_type_code Balance Type Code: ACTUAL or ADB
32 -- Notes
33 --
34 PROCEDURE gcs_main_data_prep (
35 x_errbuf OUT NOCOPY VARCHAR2,
36 x_retcode OUT NOCOPY VARCHAR2,
37 p_hierarchy_id IN NUMBER,
38 p_entity_id IN NUMBER,
39 p_target_cal_period_id IN NUMBER,
40 p_run_detail_id IN NUMBER,
41 p_cons_rel_id IN NUMBER,
42 p_balance_type_code IN VARCHAR2,
43 p_source_dataset_code IN NUMBER
44 );
45
46 --
47 -- Procedure
48 -- gcs_incremental_data_prep
49 -- Purpose
50 -- This procedure will be called via the SRS submission performed by the Consolidation Engine. It will then call the appropriate routines to complete the data preparation process.
51 -- Arguments
52 -- x_errbuf Error Buffer used for SRS
53 -- x_retcode Return Code used for SRS
54 -- p_ledger_id Ledger Identifier
55 -- p_currency_code Currency Code
56 -- p_target_cal_period_id Target Calendar Period Identifier
57 -- p_object_id Object Identifier
58 -- p_dataset_code Dataset Code
59 -- p_request_id Request Identifier
60 -- Notes
61 --
62 PROCEDURE gcs_incremental_data_prep (
63 x_errbuf OUT NOCOPY VARCHAR2,
64 x_retcode OUT NOCOPY VARCHAR2,
65 x_entry_id OUT NOCOPY NUMBER,
66 x_stat_entry_id OUT NOCOPY NUMBER,
67 x_prop_entry_id OUT NOCOPY NUMBER,
68 x_stat_prop_entry_id OUT NOCOPY NUMBER,
69 p_source_cal_period_id IN NUMBER,
70 p_balance_type_code IN VARCHAR2,
71 p_ledger_id IN NUMBER,
72 p_currency_code IN VARCHAR2,
73 p_source_dataset_code IN NUMBER,
74 p_run_name IN VARCHAR2,
75 p_cons_relationship_id IN NUMBER,
76 p_currency_type_code IN VARCHAR2
77 );
78
79 -- PROCEDURE
80 -- CREATE_PROCESS
81 -- Purpose
82 -- Create PROCESS_DATA procedure using ad_ddl. Returns
83 -- Arguments
84 -- x_retcode
85 -- x_errbuf
86 --
87 PROCEDURE create_process (
88 x_errbuf OUT NOCOPY VARCHAR2,
89 x_retcode OUT NOCOPY VARCHAR2
90 );
91
92 END gcs_data_prep_pkg;
93