1 PACKAGE ego_ag_bulkload_pvt AUTHID CURRENT_USER AS
2 /* $Header: EGOVAGBS.pls 120.0.12010000.5 2010/04/27 06:09:35 jiabraha noship $ */
3 ----------------------
4 -- Global Constants --
5 ----------------------
6 /*Transaction Types*/
7 G_OPR_CREATE CONSTANT VARCHAR2(30) := 'CREATE';
8 G_OPR_UPDATE CONSTANT VARCHAR2(30) := 'UPDATE';
9 G_OPR_DELETE CONSTANT VARCHAR2(30) := 'DELETE';
10 G_OPR_SYNC CONSTANT VARCHAR2(30) := 'SYNC';
11
12 /*Return Statuses*/
13 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
14 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
15 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
16
17 /*Concurrent Program Parameters*/
18 G_PROG_APPL_ID CONSTANT NUMBER := FND_GLOBAL.PROG_APPL_ID;
19 G_PROGRAM_ID CONSTANT NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
20 G_REQUEST_ID CONSTANT NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
21 G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
22 G_LOGIN_ID NUMBER := FND_GLOBAL.LOGIN_ID;
23 G_SET_PROCESS_ID NUMBER;
24 G_COMMIT BOOLEAN := TRUE;
25 G_AG_COUNT NUMBER :=0;
26 G_DL_COUNT NUMBER :=0;
27 G_ATTR_COUNT NUMBER :=0;
28
29 /*Process Status variables*/
30 G_PROCESS_RECORD CONSTANT NUMBER := 1;
31 G_ERROR_RECORD CONSTANT NUMBER := 3;
32 G_SUCCESS_RECORD CONSTANT NUMBER := 7;
33
34 G_EGO_APPLICATION_ID NUMBER;
35 G_EGO_ITEMMGMT_GROUP CONSTANT VARCHAR2(30) := 'EGO_ITEMMGMT_GROUP';
36
37 /*Error handler vairables*/
38 G_MESSAGE_NAME VARCHAR2(100);
39 G_MESSAGE_TEXT VARCHAR2(2000);
40 G_BO_IDENTIFIER_AG CONSTANT VARCHAR2(30) := 'AG_BO';
41 G_ENTITY_AG CONSTANT VARCHAR2(30) := 'AG';
42 G_ENTITY_DL CONSTANT VARCHAR2(30) := 'AG_DATALEVEL';
43 G_ENTITY_ATTR CONSTANT VARCHAR2(30) := 'AG_ATTRIBUTE';
44 G_ENTITY_AG_TAB CONSTANT VARCHAR2(30) := 'EGO_ATTR_GROUPS_INTERFACE';
45 G_ENTITY_DL_TAB CONSTANT VARCHAR2(30) := 'EGO_ATTR_GROUPS_DL_INTERFACE';
46 G_ENTITY_ATTR_TAB CONSTANT VARCHAR2(30) := 'EGO_ATTR_GROUP_COLS_INTF';
47 G_TOKEN_TABLE ERROR_HANDLER.TOKEN_TBL_TYPE;
48
49 /*Flow Type variables*/
50 G_EGO_MD_API CONSTANT NUMBER := 1;
51 G_EGO_MD_INTF CONSTANT NUMBER := 2;
52 G_FLOW_TYPE NUMBER := G_EGO_MD_API;
53
54 /*Data Type variables*/
55 G_TRANS_TEXT_DATA_TYPE CONSTANT VARCHAR2(1) := 'A';
56 G_CHAR_DATA_TYPE CONSTANT VARCHAR2(1) := 'C';
57 G_NUMBER_DATA_TYPE CONSTANT VARCHAR2(1) := 'N';
58 G_DATE_DATA_TYPE CONSTANT VARCHAR2(1) := 'X';
59 G_DATE_TIME_DATA_TYPE CONSTANT VARCHAR2(1) := 'Y';
60
61 /*Display As variables*/
62 G_ATTACH_DISP_TYPE CONSTANT VARCHAR2(1) := 'A';
63 G_CHECKBOX_DISP_TYPE CONSTANT VARCHAR2(1) := 'C';
64 G_DYN_URL_DISP_TYPE CONSTANT VARCHAR2(1) := 'D';
65 G_HIDDEN_DISP_TYPE CONSTANT VARCHAR2(1) := 'H';
66 G_RADIO_DISP_TYPE CONSTANT VARCHAR2(1) := 'R';
67 G_STATIC_URL_DISP_TYPE CONSTANT VARCHAR2(1) := 'S';
68 G_TEXT_FIELD_DISP_TYPE CONSTANT VARCHAR2(1) := 'T';
69 G_TEXT_AREA_DISP_TYPE CONSTANT VARCHAR2(1) := 'L';
70
71 /*Null variables*/
72 G_NULL_NUM CONSTANT NUMBER := 9.99E125;
73 G_NULL_CHAR CONSTANT VARCHAR2(1) := Chr(0);
74 G_NULL_DATE CONSTANT DATE := To_date('1', 'j');
75
76 /*Data Level variables*/
77 G_DL_ITEM_LEVEL CONSTANT VARCHAR2(30) := 'ITEM_LEVEL';
78 G_DL_ITEM_REV_LEVEL CONSTANT VARCHAR2(30) := 'ITEM_REVISION_LEVEL';
79 G_DL_ITEM_ORG CONSTANT VARCHAR2(30) := 'ITEM_ORG';
80 G_DL_ITEM_SUP CONSTANT VARCHAR2(30) := 'ITEM_SUP';
81 G_DL_ITEM_SUP_SITE CONSTANT VARCHAR2(30) := 'ITEM_SUP_SITE';
82 G_DL_ITEM_SUP_SITE_ORG CONSTANT VARCHAR2(30) := 'ITEM_SUP_SITE_ORG';
83
84
85 /*This Procedure is used to initialize certain column values in the interface table.
86 Used in the interface flow.
87 x_return_status OUT NOCOPY parameter that returns the status
88 x_return_msg OUT NOCOPY parameter that returns the error message*/
89 PROCEDURE initialize(
90 x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
91
92 /*This procedure is used to validate the transaction type for all the interface tables.
93 Used in the interface flow.
94 x_return_status OUT NOCOPY parameter that returns the status
95 x_return_msg OUT NOCOPY parameter that returns the error message*/
96 PROCEDURE validate_transaction_type(
97 x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
98
99 /*This procedure is used for value to ID conversion for Attribute Groups.
100 Used in the interface flow.
101 x_return_status OUT NOCOPY parameter that returns the status
102 x_return_msg OUT NOCOPY parameter that returns the error message*/
103 PROCEDURE value_to_id_ag(
104 x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
105
106 /*This procedure is used for value to ID conversion for Attribute Groups
107 Data level. Used in the interface flow.
108 x_return_status OUT NOCOPY parameter that returns the status
109 x_return_msg OUT NOCOPY parameter that returns the error message*/
110 PROCEDURE value_to_id_dl(
111 x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
112
113 /*This procedure is used for value to ID conversion for Attributes.
114 Used in the interface flow.
115 x_return_status OUT NOCOPY parameter that returns the status
116 x_return_msg OUT NOCOPY parameter that returns the error message*/
117 PROCEDURE value_to_id_attr(
118 x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
119
120 /*This procedure is used construct attribute group records.
121 Used in the interface flow.
122 x_return_status OUT NOCOPY parameter that returns the status
123 x_return_msg OUT NOCOPY parameter that returns the error message*/
124 PROCEDURE construct_attr_groups(
125 x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
126
127 /*This procedure is used construct attribute group data level records.
128 Used in the interface flow.
129 x_return_status OUT NOCOPY parameter that returns the status
130 x_return_msg OUT NOCOPY parameter that returns the error message*/
131 PROCEDURE construct_ag_data_level(
132 x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
133
134 /*This procedure is used construct attributes records.
135 Used in the interface flow.
136 x_return_status OUT NOCOPY parameter that returns the status
137 x_return_msg OUT NOCOPY parameter that returns the error message*/
138 PROCEDURE construct_attribute(
139 x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
140
141 /*This procedure is used for value to ID conversion for Attribute group plsql tables.
142 Used in the API flow.
143 p_ag_tbl IN OUT NOCOPY Attribute group plsql table
144 x_return_status OUT NOCOPY parameter that returns the status
145 x_return_msg OUT NOCOPY parameter that returns the error message*/
146 PROCEDURE value_to_id_ag_tbl(
147 p_ag_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_tbl,
148 x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
149
150 /*This procedure is used for value to ID conversion for Attribute group
151 data level plsql tables. Used in the API flow.
152 p_agdl_tbl IN OUT NOCOPY Attribute group data level plsql table
153 x_return_status OUT NOCOPY parameter that returns the status
154 x_return_msg OUT NOCOPY parameter that returns the error message*/
155 PROCEDURE value_to_id_dl_tbl(
156 p_agdl_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_dl_tbl,
157 x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
158
159 /*This procedure is used for value to ID conversion for Attributes plsql tables.
160 Used in the API flow.
161 p_attr_tbl IN OUT NOCOPY Attributes plsql table
162 x_return_status OUT NOCOPY parameter that returns the status
163 x_return_msg OUT NOCOPY parameter that returns the error message*/
164 PROCEDURE value_to_id_attr_tbl(
165 p_attr_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_group_cols_tbl,
166 x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
167
168 /*This procedure is used to bulk validate attribute groups.
169 Used in the interface flow.
170 x_return_status OUT NOCOPY parameter that returns the status
171 x_return_msg OUT NOCOPY parameter that returns the error message*/
172 PROCEDURE bulk_validate_attr_groups(
173 x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
174
175 /*This procedure is used to bulk validate attributes.
176 Used in the interface flow.
177 x_return_status OUT NOCOPY parameter that returns the status
178 x_return_msg OUT NOCOPY parameter that returns the error message*/
179 PROCEDURE bulk_validate_attribute(
180 x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
181
182 /*This procedure is used to do additional validations on attribute groups.
183 Used in the API flow.
184 p_ag_tbl IN OUT NOCOPY Attribute group plsql table
185 x_return_status OUT NOCOPY parameter that returns the status
186 x_return_msg OUT NOCOPY parameter that returns the error message*/
187 PROCEDURE additional_agdl_validations(
188 p_ag_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_tbl,
189 p_agdl_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_dl_tbl,
190 x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
191
192 /*This procedure is used to do additional validations on attributes.
193 Used in the API flow.
194 p_attr_tbl IN OUT NOCOPY Attributes plsql table
195 x_return_status OUT NOCOPY parameter that returns the status
196 x_return_msg OUT NOCOPY parameter that returns the error message*/
197 PROCEDURE additional_attr_validations(
198 p_attr_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_group_cols_tbl,
199 x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
200
201 /*This procedure is used to do Common validations on attribute groups.
202 Used in the Interface and API flow.
203 p_ag_tbl IN OUT NOCOPY Attribute group plsql table
204 x_return_status OUT NOCOPY parameter that returns the status
205 x_return_msg OUT NOCOPY parameter that returns the error message*/
206 PROCEDURE common_ag_validations(
207 p_ag_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_tbl,
208 x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
209
210 /*This procedure is used to do Common validations on attribute group data level.
211 Used in the Interface and API flow.
212 p_agdl_tbl IN OUT NOCOPY Attribute group plsql table
213 x_return_status OUT NOCOPY parameter that returns the status
214 x_return_msg OUT NOCOPY parameter that returns the error message*/
215 PROCEDURE common_dl_validations(
216 p_agdl_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_dl_tbl,
217 x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
218
219 /*This procedure is used to do Common validations on attributes.
220 Used in the Interface and API flow.
221 p_attr_tbl IN OUT NOCOPY Attribute group plsql table
222 x_return_status OUT NOCOPY parameter that returns the status
223 x_return_msg OUT NOCOPY parameter that returns the error message*/
224 PROCEDURE common_attr_validations(
225 p_attr_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_group_cols_tbl,
226 x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
227
228 /*This is the main procedure called to import attribute groups, data level and attributes
229 Used in the Interface flow.
230 p_set_process_id IN Set_Process_ID
231 x_return_status OUT NOCOPY parameter that returns the status
232 x_return_msg OUT NOCOPY parameter that returns the error message*/
233 PROCEDURE import_ag_intf(
234 p_set_process_id IN VARCHAR2,
235 x_return_status OUT NOCOPY VARCHAR2,
236 x_return_msg OUT NOCOPY VARCHAR2);
237
238 /*This is the main procedure called to import attribute groups and data levels.
239 Used in the API flow.
240 p_ag_tbl IN OUT NOCOPY Attribute groups plsql table
241 p_agdl_tbl IN OUT NOCOPY Data level plsql table
242 p_commit IN Pass true to commit within the API
243 x_return_status OUT NOCOPY parameter that returns the status
244 x_return_msg OUT NOCOPY parameter that returns the error message*/
245 PROCEDURE process_attr_groups(
246 p_ag_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_tbl,
247 p_agdl_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_dl_tbl,
248 p_commit IN BOOLEAN DEFAULT true,
249 x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
250
251 /*This is the main procedure called to import attributes.
252 Used in the API flow.
253 p_attr_tbl IN OUT NOCOPY Attributes plsql table
254 p_commit IN Pass true to commit within the API
255 x_return_status OUT NOCOPY parameter that returns the status
256 x_return_msg OUT NOCOPY parameter that returns the error message*/
257 PROCEDURE process_attribute(
258 p_attr_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_group_cols_tbl,
259 p_commit IN BOOLEAN DEFAULT true,
260 x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
261
262 /*This procedure is used in the update flow to handle null values for AG
263 Used in the interface and API flow.
264 p_ag_tbl IN OUT NOCOPY Attribute groups plsql table
265 x_return_status OUT NOCOPY parameter that returns the status
266 x_return_msg OUT NOCOPY parameter that returns the error message*/
267 PROCEDURE handle_null_ag(
268 p_ag_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_tbl,
269 x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
270
271 /*This procedure is used to do final processing of the attribute group data level.
272 Used in the interface and API flow.
273 p_agdl_tbl IN OUT NOCOPY Attribute group data level plsql table
274 x_return_status OUT NOCOPY parameter that returns the status
275 x_return_msg OUT NOCOPY parameter that returns the error message*/
276 PROCEDURE handle_null_dl(
277 p_agdl_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_dl_tbl,
278 x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
279
280 /*This procedure is used to do final processing of the attributes.
281 Used in the interface and API flow.
282 p_attr_tbl IN OUT NOCOPY Attributes plsql table
283 x_return_status OUT NOCOPY parameter that returns the status
284 x_return_msg OUT NOCOPY parameter that returns the error message*/
285 PROCEDURE handle_null_attr(
286 p_attr_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_group_cols_tbl,
287 x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
288
289 /*This procedure is used to do final processing of the attribute groups.
290 Used in the interface and API flow.
291 p_ag_tbl IN OUT NOCOPY Attribute groups plsql table
292 x_return_status OUT NOCOPY parameter that returns the status
293 x_return_msg OUT NOCOPY parameter that returns the error message*/
294 PROCEDURE process_ag(
295 p_ag_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_tbl,
296 x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
297
298 /*This procedure is used to do final processing of the attribute group data level.
299 Used in the interface and API flow.
300 p_agdl_tbl IN OUT NOCOPY Attribute group data level plsql table
301 x_return_status OUT NOCOPY parameter that returns the status
302 x_return_msg OUT NOCOPY parameter that returns the error message*/
303 PROCEDURE process_dl(
304 p_agdl_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_dl_tbl,
305 x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
306
307 /*This procedure is used to do final processing of the attributes.
308 Used in the interface and API flow.
312 PROCEDURE process_attr(
309 p_attr_tbl IN OUT NOCOPY Attributes plsql table
310 x_return_status OUT NOCOPY parameter that returns the status
311 x_return_msg OUT NOCOPY parameter that returns the error message*/
313 p_attr_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_group_cols_tbl,
314 x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
315
316 /*This procedure is used to update the attribute group interface table
317 Used in the interface flow.
318 p_ag_tbl IN OUT NOCOPY Attribute group plsql table
319 x_return_status OUT NOCOPY parameter that returns the status
320 x_return_msg OUT NOCOPY parameter that returns the error message*/
321 PROCEDURE update_intf_attr_groups(
322 p_ag_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_tbl,
323 x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
324
325
326 /*This procedure is used to update the attribute group data level interface table
327 Used in the interface flow.
328 p_agdl_tbl IN OUT NOCOPY Attribute group data level plsql table
329 x_return_status OUT NOCOPY parameter that returns the status
330 x_return_msg OUT NOCOPY parameter that returns the error message*/
331 PROCEDURE update_intf_data_level(
332 p_agdl_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_dl_tbl,
333 x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
334
335 /*This procedure is used to update the attributes interface table
336 Used in the Interface flow.
337 p_attr_tbl IN OUT NOCOPY Attributes plsql table
338 x_return_status OUT NOCOPY parameter that returns the status
339 x_return_msg OUT NOCOPY parameter that returns the error message*/
340 PROCEDURE update_intf_attribute(
341 p_attr_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_group_cols_tbl,
342 x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
343
344 /*This procedure is used to delete processed records from the attribute group's interface table
345 Used in the interface flow.
346 x_set_process_id IN Set process id
347 x_return_status OUT NOCOPY parameter that returns the status
348 x_return_msg OUT NOCOPY parameter that returns the error message*/
349 PROCEDURE delete_processed_attr_groups(
350 x_set_process_id IN NUMBER,
351 x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
352
353 /*This procedure is used to delete processed records from the AG Data level's interface table
354 Used in the interface flow.
355 x_set_process_id IN Set process id
356 x_return_status OUT NOCOPY parameter that returns the status*/
357 PROCEDURE delete_processed_data_level(
358 x_set_process_id IN NUMBER,
359 x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
360
361 /*This procedure is used to delete processed records from the Attribute's interface table
362 Used in the Interface flow.
363 x_set_process_id IN Set process id
364 x_return_status OUT NOCOPY parameter that returns the status
365 x_return_msg OUT NOCOPY parameter that returns the error message*/
366 PROCEDURE delete_processed_attributes(
367 x_set_process_id IN NUMBER,
368 x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
369
370 /*This procedure is used to delete AG existing in the production table without a single DL associated
371 Used in the Interface flow and API flow.
372 x_return_status OUT NOCOPY parameter that returns the status
373 x_return_msg OUT NOCOPY parameter that returns the error message*/
374 PROCEDURE delete_ag_none_dl(
375 x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2);
376
377 /*Added for bug 9625957*/
378 ------------------------------------------------------------------------------------------
379 -- Function: To return the pending base table name for a given attribute group type
380 -- an the application id
381 -- If the table is not defined, NULL is returned
382 --
383 -- Parameters:
384 -- IN
385 -- p_attr_group_type: attribute_group_type
386 -- p_attr_group_type application_id
387 -- OUT
388 -- l_table_name : base table for attribute_changes
389 ------------------------------------------------------------------------------------------
390 FUNCTION Get_Attr_Changes_B_Table (
391 p_application_id IN NUMBER
392 ,p_attr_group_type IN VARCHAR2
393 )RETURN VARCHAR2;
394
395 ------------------------------------------------------------------------------------------
396 -- Function: To return the pending transalatable table name for a given attribute group type
397 -- an the application id
398 -- If the table is not defined, NULL is returned
399 --
400 -- Parameters:
401 -- IN
402 -- p_attr_group_type: attribute_group_type
403 -- p_attr_group_type application_id
404 -- OUT
405 -- l_table_name : translatable table for attribute_changes
406 ------------------------------------------------------------------------------------------
407 FUNCTION Get_Attr_Changes_TL_Table (
408 p_application_id IN NUMBER
409 ,p_attr_group_type IN VARCHAR2
410 )RETURN VARCHAR2;
411
412 /*This local procedure will return the table name based on the attribute group Type
413 p_application_id IN EGO Application ID
414 p_attr_group_type IN Attribute group Type*/
415 FUNCTION Get_Table_Name (
416 p_application_id IN NUMBER
417 ,p_attr_group_type IN VARCHAR2
418 )RETURN VARCHAR2;
419
420 /*This local procedure will return the TL table name based on the attribute group Type
421 p_application_id IN EGO Application ID
422 p_attr_group_type IN Attribute group Type*/
423 FUNCTION Get_TL_Table_Name (
424 p_application_id IN NUMBER
425 ,p_attr_group_type IN VARCHAR2
426 )RETURN VARCHAR2;
427 /*End of comment for bug 9625957*/
428 /*This procedure will log debug messages
429 x_msg IN Input message name*/
430 Procedure write_debug(x_msg IN VARCHAR2);
431 END ego_ag_bulkload_pvt;