1 PACKAGE GCS_DP_DYNAMIC_PKG AUTHID CURRENT_USER AS
2 /* $Header: gcsdpdyns.pls 120.2 2006/02/04 02:02:33 yingliu noship $ */
3 --
4 -- Package
5 -- GCS_DP_DYNAMIC_PKG
6 -- Purpose
7 -- Package procedures for the Data Preparation Engine Program
8 -- History
9 -- 08-Dec-03 Ying Liu Created
10 --
11 -- Definition of Global Data Types and Variables
12 gcs_dp_proc_data_error EXCEPTION;
13
14 --
15 -- Procedure
16 -- PROCESS_DATA
17 -- Purpose
18 -- This procedure will process all the data collected by the dynamic sql statement and insert the data into GCS_ENTRY_LINES/HEADERS
19 -- Notes
20 --
21 PROCEDURE process_data (
22 p_source_currency_code IN VARCHAR2,
23 p_target_cal_period_id IN NUMBER,
24 p_max_period IN NUMBER,
25 p_currency_type_code IN VARCHAR2,
26 p_hierarchy_id IN NUMBER,
27 p_entity_id IN NUMBER,
28 p_source_ledger_id IN NUMBER,
29 p_year_end_values_match IN VARCHAR2,
30 p_cal_period_record IN gcs_utility_pkg.r_cal_period_info,
31 p_balance_type_code IN VARCHAR2,
32 p_owner_percentage IN NUMBER,
33 p_run_detail_id IN NUMBER,
34 p_source_dataset_code IN NUMBER,
35 errbuf OUT NOCOPY VARCHAR2,
36 retcode OUT NOCOPY VARCHAR2
37 );
38
39 --
40 -- Procedure
41 -- process_inc_data
42 -- Purpose
43 -- This procedure will process incremental data
44 -- Notes
45 --
46 PROCEDURE process_inc_data (
47 p_source_currency_code IN VARCHAR2,
48 p_target_cal_period_id IN NUMBER,
49 p_currency_type_code IN VARCHAR2,
50 p_hierarchy_id IN NUMBER,
51 p_entity_id IN NUMBER,
52 p_source_ledger_id IN NUMBER,
53 p_balance_type_code IN VARCHAR2,
54 p_owner_percentage IN NUMBER,
55 p_run_name IN VARCHAR2,
56 p_source_dataset_code IN NUMBER,
57 x_entry_id OUT NOCOPY NUMBER,
58 x_stat_entry_id OUT NOCOPY NUMBER,
59 x_prop_entry_id OUT NOCOPY NUMBER,
60 x_stat_prop_entry_id OUT NOCOPY NUMBER,
61 errbuf OUT NOCOPY VARCHAR2,
62 retcode OUT NOCOPY VARCHAR2
63 );
64 END gcs_dp_dynamic_pkg;
65