[Home] [Help]
PACKAGE: APPS.FEM_WEBADI_MEMBER_UTILS_PVT
Source
1 PACKAGE FEM_WEBADI_MEMBER_UTILS_PVT AS
2 /* $Header: FEMVADIMEMBUTILS.pls 120.0 2006/06/16 10:19:59 gdonthir noship $ */
3
4
5 --------------------------
6 -- Declare Object types --
7 --------------------------
8 --
9 -- This collection will contain 50 integer values starting from 1 to 50.
10 -- This table will be used to retrieve the available mapping sequences
11 -- for a given dimension.
12 g_sequences_tbl FND_TABLE_OF_NUMBER := FND_TABLE_OF_NUMBER
13 ( 1, 2, 3, 4, 5, 6
14 , 7, 8, 9, 10, 11, 12
15 , 13, 14, 15, 16, 17, 18
16 , 19, 20, 21, 22, 23, 24
17 , 25, 26, 27, 28, 29, 30
18 , 31, 32, 33, 34, 35, 36
19 , 37, 38, 29, 40, 41, 42
20 , 45, 46, 47, 48, 49, 50
21 ) ;
22 --
23 g_changed_intf_col_tbl FND_TABLE_OF_VARCHAR2_30 := FND_TABLE_OF_VARCHAR2_30();
24 g_changed_dt_intf_col_tbl FND_TABLE_OF_VARCHAR2_30 := FND_TABLE_OF_VARCHAR2_30();
25 --
26 ------------------------------
27 -- Declare Global variables --
28 ------------------------------
29 G_LIMIT_BULK_NUMROWS CONSTANT NUMBER := 100 ; -- Limit to hold number of rows
30 --
31 -- Global variable to prevent the execution
32 -- of Populate_Dim_Metadata_Info API everytime.
33 g_is_context_info_present BOOLEAN := FALSE ;
34 --
35 --------------------------
36 -- Declare Object types --
37 --------------------------
38 -- Define a record to hold Dimension Metadata global variables.
39 -- Bug#5331929: Increased the size of variables to match db col size.
40 TYPE g_global_val_rec_type
41 IS
42 RECORD
43 ( dimension_id NUMBER
44 , dimension_varchar_label VARCHAR2(30)
45 , intf_member_b_table_name VARCHAR2(30)
46 , intf_member_tl_table_name VARCHAR2(30)
47 , intf_attribute_table_name VARCHAR2(30)
48 , member_b_table_name VARCHAR2(30)
49 , member_display_code_col VARCHAR2(30)
50 , member_display_code VARCHAR2(150)
51 , calendar_display_code VARCHAR2(150)
52 , member_name_col VARCHAR2(30)
53 , member_name VARCHAR2(150)
54 , member_description VARCHAR2(255)
55 , hierarchy_intf_table_name VARCHAR2(30)
56 , dimension_type_code VARCHAR2(30)
57 , group_use_code VARCHAR2(30)
58 , value_set_required_flag VARCHAR2(1)
59 , value_set_display_code VARCHAR2(150)
60 , dim_grp_disp_code VARCHAR2(150)
61 , ledger_id NUMBER
62 ) ;
63
64 TYPE g_global_val_tbl_type
65 IS
66 TABLE OF g_global_val_rec_type
67 INDEX BY PLS_INTEGER ;
68
69 g_global_val_tbl g_global_val_tbl_type ;
70 --
71 --
72 PROCEDURE Populate_Mem_WebADI_Metadata
73 ( x_return_status OUT NOCOPY VARCHAR2
74 , x_msg_count OUT NOCOPY NUMBER
75 , x_msg_data OUT NOCOPY VARCHAR2
76 , p_api_version IN NUMBER
77 , p_init_msg_list IN VARCHAR2
78 , p_commit IN VARCHAR2
79 , p_dimension_varchar_label IN VARCHAR2
80 );
81
82 /*===========================================================================+
83 Procedure Name : Populate_Dim_Attribute_Maps
84 Parameters :
85 IN : p_dimension_varchar_label VARCHAR2
86 p_api_version NUMBER
87 p_init_msg_list VARCHAR2
88 p_commit VARCHAR2
89 OUT : All standard parameters.
90
91 Description : This procedure stores attributes to the
92 FEM_WebADI_attr_map table for a dimension.
93 Note that this API will be called well
94 before actual upload process to setup the
95 mappings.
96 Modification History :
97 Date Name Desc
98 ---------- --------- -------------------------------------------------------
99 09/22/2005 SHTRIPAT Created.
100 ---------- --------- -------------------------------------------------------
101 +===========================================================================*/
102 PROCEDURE Populate_Dim_Attribute_Maps
103 ( x_return_status OUT NOCOPY VARCHAR2
104 , x_msg_count OUT NOCOPY NUMBER
105 , x_msg_data OUT NOCOPY VARCHAR2
106 , p_api_version IN NUMBER
107 , p_init_msg_list IN VARCHAR2
108 , p_commit IN VARCHAR2
109 , p_dimension_varchar_label IN VARCHAR2
110 ) ;
111
112 /*===========================================================================+
113 Procedure Name : Upload_Member_Interface
114 Parameters :
115 IN : p_interface_dimension_name VARCHAR2
116 p_dimension_varchar_label VARCHAR2
117 p_ledger_id VARCHAR2
118 p_calendar_display_code VARCHAR2
119 p_member_name VARCHAR2
120 p_member_display_code VARCHAR2
121 p_member_description VARCHAR2
122 p_dimension_group_display_code VARCHAR2
123 P_ATTRIBUTE1..50 VARCHAR2
124 OUT : None
125
126 Description : This program creates members in member interface table
127 and attribute information in dimension member attribute
128 interface table.
129 Modification History :
130 Date Name Desc
131 ---------- --------- -------------------------------------------------------
132 09/23/2005 SHTRIPAT Created.
133 ---------- --------- -------------------------------------------------------
134 +===========================================================================*/
135 PROCEDURE Upload_Member_Interface
136 ( p_interface_dimension_name IN VARCHAR2
137 , p_dimension_varchar_label IN VARCHAR2
138 , p_ledger_id IN NUMBER
139 , p_calendar_display_code IN VARCHAR2
140 , p_member_name IN VARCHAR2
141 , p_member_display_code IN VARCHAR2
142 , p_member_description IN VARCHAR2
143 , p_dimension_group_display_code IN VARCHAR2
144 , P_ATTRIBUTE1 IN VARCHAR2
145 , P_ATTRIBUTE2 IN VARCHAR2
146 , P_ATTRIBUTE3 IN VARCHAR2
147 , P_ATTRIBUTE4 IN VARCHAR2
148 , P_ATTRIBUTE5 IN VARCHAR2
149 , P_ATTRIBUTE6 IN VARCHAR2
150 , P_ATTRIBUTE7 IN VARCHAR2
151 , P_ATTRIBUTE8 IN VARCHAR2
152 , P_ATTRIBUTE9 IN VARCHAR2
153 , P_ATTRIBUTE10 IN VARCHAR2
154 , P_ATTRIBUTE11 IN VARCHAR2
155 , P_ATTRIBUTE12 IN VARCHAR2
156 , P_ATTRIBUTE13 IN VARCHAR2
157 , P_ATTRIBUTE14 IN VARCHAR2
158 , P_ATTRIBUTE15 IN VARCHAR2
159 , P_ATTRIBUTE16 IN VARCHAR2
160 , P_ATTRIBUTE17 IN VARCHAR2
161 , P_ATTRIBUTE18 IN VARCHAR2
162 , P_ATTRIBUTE19 IN VARCHAR2
163 , P_ATTRIBUTE20 IN VARCHAR2
164 , P_ATTRIBUTE21 IN VARCHAR2
165 , P_ATTRIBUTE22 IN VARCHAR2
166 , P_ATTRIBUTE23 IN VARCHAR2
167 , P_ATTRIBUTE24 IN VARCHAR2
168 , P_ATTRIBUTE25 IN VARCHAR2
169 , P_ATTRIBUTE26 IN VARCHAR2
170 , P_ATTRIBUTE27 IN VARCHAR2
171 , P_ATTRIBUTE28 IN VARCHAR2
172 , P_ATTRIBUTE29 IN VARCHAR2
173 , P_ATTRIBUTE30 IN VARCHAR2
174 , P_ATTRIBUTE31 IN VARCHAR2
175 , P_ATTRIBUTE32 IN VARCHAR2
176 , P_ATTRIBUTE33 IN VARCHAR2
177 , P_ATTRIBUTE34 IN VARCHAR2
178 , P_ATTRIBUTE35 IN VARCHAR2
179 , P_ATTRIBUTE36 IN VARCHAR2
180 , P_ATTRIBUTE37 IN VARCHAR2
181 , P_ATTRIBUTE38 IN VARCHAR2
182 , P_ATTRIBUTE39 IN VARCHAR2
183 , P_ATTRIBUTE40 IN VARCHAR2
184 , P_ATTRIBUTE41 IN VARCHAR2
185 , P_ATTRIBUTE42 IN VARCHAR2
186 , P_ATTRIBUTE43 IN VARCHAR2
187 , P_ATTRIBUTE44 IN VARCHAR2
188 , P_ATTRIBUTE45 IN VARCHAR2
189 , P_ATTRIBUTE46 IN VARCHAR2
190 , P_ATTRIBUTE47 IN VARCHAR2
191 , P_ATTRIBUTE48 IN VARCHAR2
192 , P_ATTRIBUTE49 IN VARCHAR2
193 , P_ATTRIBUTE50 IN VARCHAR2
194 ) ;
195
196 /*===========================================================================+
197 Procedure Name : Populate_Mem_ADI_Metadata_CP
198 Parameters :
199 IN : p_dimension_varchar_label VARCHAR2
200 OUT : errbuf VARCHAR2
201 retcode VARCHAR2
202
203 Description : This program calls Populate_Dim_WebADI_Metadata to
204 populate dimension Metadata
205
206 Modification History :
207 Date Name Desc
208 ---------- --------- -------------------------------------------------------
209 12/01/2005 SHTRIPAT Created.
210 ---------- --------- -------------------------------------------------------
211 +===========================================================================*/
212 PROCEDURE Populate_Mem_ADI_Metadata_CP
213 ( errbuf OUT NOCOPY VARCHAR2
214 , retcode OUT NOCOPY VARCHAR2
215 , p_dimension_varchar_label IN VARCHAR2
216 ) ;
217
218
219 PROCEDURE Upload_Member_Header_Interface
220 (
221 p_dimension_varchar_label IN VARCHAR2
222 );
223
224
225 --Bug#5186753
226
227 PROCEDURE Delete_Fem_Webadi_Seed (
228 p_api_version IN NUMBER ,
229 p_init_msg_list IN VARCHAR2,
230 p_commit IN VARCHAR2,
231 x_return_status OUT NOCOPY VARCHAR2,
232 x_msg_count OUT NOCOPY NUMBER ,
233 x_msg_data OUT NOCOPY VARCHAR2
234 );
235
236
237 END FEM_WEBADI_MEMBER_UTILS_PVT ;