[Home] [Help]
PACKAGE: APPS.GCS_WEBADI_PKG
Source
1 PACKAGE GCS_WEBADI_PKG AUTHID CURRENT_USER AS
2 /* $Header: gcswebadis.pls 120.4 2007/09/03 07:41:08 vkosuri noship $ */
3 -- Records, Associative Arrays, and Variables to store dimension information
4 TYPE r_dimension_info IS RECORD
5 (dimension_varchar_label VARCHAR2(30),
6 b_table_name VARCHAR2(30),
7 b_t_table_name VARCHAR2(30),
8 tl_t_table_name VARCHAR2(30),
9 attr_t_table_name VARCHAR2(30),
10 hier_t_table_name VARCHAR2(30),
11 display_code VARCHAR2(30),
12 name VARCHAR2(30),
13 dimension_id fem_dimensions_b.dimension_id%TYPE,
14 obj_defn_id NUMBER(15));
15
16 TYPE t_dimension_info IS TABLE OF r_dimension_info INDEX BY VARCHAR2(30);
17
18 g_dimension_info t_dimension_info;
19
20 --
21 -- Procedure
22 -- datasub_upload
23 -- Purpose
24 -- An API to upload Data Submission header info from Web ADI
25 -- Arguments
26 -- Notes
27 --
28 -- Bug Fix : 5690166 , Added p_load_id
29 PROCEDURE datasub_upload (
30 p_load_id IN NUMBER,
31 p_load_name IN VARCHAR2,
32 p_entity_name IN VARCHAR2,
33 p_period IN VARCHAR2,
34 p_balance_type IN VARCHAR2,
35 p_load_method IN VARCHAR2,
36 p_currency_type IN VARCHAR2,
37 p_currency_code IN VARCHAR2,
38 p_amount_type IN VARCHAR2,
39 p_measure_type IN VARCHAR2,
40 p_rule_set IN VARCHAR2
41 );
42
43 --
44 -- Procedure
45 -- HRATE_Import
46 -- Purpose
47 -- An API to import historical rates from Web ADI
48 -- Arguments
49 -- Notes
50 --
51 PROCEDURE hrate_import (
52 p_hierarchy_id IN NUMBER,
53 p_entity_id IN NUMBER,
54 p_cal_period_id IN NUMBER
55 );
56
57 --
58 -- Procedure
59 -- Dim_Member_Import
60 -- Purpose
61 -- An API to import dimension members from Web ADI
62 -- Arguments
63 -- Notes
64 --
65 PROCEDURE dim_member_import (
66 x_errbuf OUT NOCOPY VARCHAR2,
67 x_retcode OUT NOCOPY VARCHAR2,
68 p_sequence_num IN NUMBER,
69 p_dimension_varchar_label IN VARCHAR2
70 );
71
72 --
73 -- Procedure
74 -- dim_hier_upload
75 -- Purpose
76 -- An API to upload dimension hierarchies header info from Web ADI
77 -- Arguments
78 -- Notes
79 --
80 PROCEDURE dim_hier_upload (
81 p_dimension_varchar_label IN VARCHAR2,
82 p_hierarchy_name IN VARCHAR2,
83 p_version_name IN VARCHAR2,
84 p_version_start_date IN VARCHAR2,
85 p_version_end_date IN VARCHAR2,
86 p_analysis_flag IN VARCHAR2,
87 p_mvs_flag IN VARCHAR2
88 );
89
90 --
91 -- Procedure
92 -- DIM_HIER_IMPORT
93 -- Purpose
94 -- An API to import dimension hierarchies from Web ADI
95 -- Arguments
96 -- Notes
97 --
98 PROCEDURE dim_hier_import (
99 x_errbuf OUT NOCOPY VARCHAR2,
100 x_retcode OUT NOCOPY VARCHAR2,
101 p_sequence_num IN NUMBER,
102 p_dimension_varchar_label IN VARCHAR2,
103 p_hierarchy_name IN VARCHAR2,
104 p_version_name IN VARCHAR2,
105 p_version_start_dt IN VARCHAR2,
106 p_version_end_dt IN VARCHAR2,
107 p_analysis_flag IN VARCHAR2,
108 p_parent_vs_display_code IN VARCHAR2,
109 p_mvs_flag IN VARCHAR2
110 );
111
112 --
113 -- Procedure
114 -- handle_interco_map_flag
115 -- Purpose
116 -- An API to set the value for the GCS_SYSTEM_OPTIONS.INTERCO_MAP_ENABLED_FLAG
117 -- Arguments
118 -- Notes
119 --
120 PROCEDURE handle_interco_map_flag;
121
122 --
123 -- FUNCTION
124 -- Execute_Event
125 -- Purpose
126 -- Execute GCS Manual Entries Dimension Config Event
127 -- Update visible dimensions in the entries spreadsheet upon user changes
128 -- Arguments
129 -- p_subscription_guid
130 -- p_event
131 -- Notes
132 --
133 FUNCTION execute_event (
134 p_subscription_guid IN RAW,
135 p_event IN OUT NOCOPY wf_event_t
136 )
137 RETURN VARCHAR2;
138 END gcs_webadi_pkg;
139