DBA Data[Home] [Help]

APPS.XLA_EVENT_SOURCES_F_PKG dependencies on XLA_EVENT_SOURCES

Line 1: PACKAGE BODY xla_event_sources_f_pkg AS

1: PACKAGE BODY xla_event_sources_f_pkg AS
2: /* $Header: xlatbssa.pkb 120.12 2005/04/28 18:45:44 masada ship $ */
3: /*======================================================================+
4: | Copyright (c) 2001-2002 Oracle Corporation |
5: | Redwood Shores, CA, USA |

Line 9: | xla_event_sources |

5: | Redwood Shores, CA, USA |
6: | All rights reserved. |
7: +=======================================================================+
8: | PACKAGE NAME |
9: | xla_event_sources |
10: | |
11: | DESCRIPTION |
12: | Forms PL/SQL Wrapper for xla_event_sources |
13: | |

Line 12: | Forms PL/SQL Wrapper for xla_event_sources |

8: | PACKAGE NAME |
9: | xla_event_sources |
10: | |
11: | DESCRIPTION |
12: | Forms PL/SQL Wrapper for xla_event_sources |
13: | |
14: | HISTORY |
15: | 05/22/01 Dimple Shah Created |
16: | 05/20/04 W.Shen change for accounting attribute |

Line 18: | to the xla_event_sources table |

14: | HISTORY |
15: | 05/22/01 Dimple Shah Created |
16: | 05/20/04 W.Shen change for accounting attribute |
17: | enhancement project. reflect the change|
18: | to the xla_event_sources table |
19: | |
20: +======================================================================*/
21:
22: --=============================================================================

Line 33: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_event_sources_f_pkg';

29: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
30: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
31:
32: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
33: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_event_sources_f_pkg';
34:
35: g_debug_flag VARCHAR2(1) :=
36: NVL(fnd_profile.value('XLA_DEBUG_TRACE'),'N');
37:

Line 61: (p_location => 'xla_event_sources_f_pkg.trace');

57: RAISE;
58:
59: WHEN OTHERS THEN
60: xla_exceptions_pkg.raise_message
61: (p_location => 'xla_event_sources_f_pkg.trace');
62: END trace;
63:
64:
65:

Line 91: FROM xla_event_sources

87: IS
88:
89: CURSOR c IS
90: SELECT rowid
91: FROM xla_event_sources
92: WHERE application_id = x_application_id
93: AND entity_code = x_entity_code
94: AND event_class_code = x_event_class_code
95: AND source_application_id = x_source_application_id

Line 114: INSERT INTO xla_event_sources

110: p_level => C_LEVEL_PROCEDURE);
111: END IF;
112:
113:
114: INSERT INTO xla_event_sources
115: (creation_date
116: ,created_by
117: ,application_id
118: ,entity_code

Line 188: FROM xla_event_sources

184: ,source_type_code
185: ,source_code
186: ,level_code
187: ,active_flag
188: FROM xla_event_sources
189: WHERE application_id = x_application_id
190: AND entity_code = x_entity_code
191: AND event_class_code = x_event_class_code
192: AND source_application_id = x_source_application_id

Line 280: UPDATE xla_event_sources

276: p_module => l_log_module,
277: p_level => C_LEVEL_PROCEDURE);
278: END IF;
279:
280: UPDATE xla_event_sources
281: SET
282: last_update_date = x_last_update_date
283: ,level_code = x_level_code
284: ,active_flag = x_active_flag

Line 334: DELETE FROM xla_event_sources

330: p_module => l_log_module,
331: p_level => C_LEVEL_PROCEDURE);
332: END IF;
333:
334: DELETE FROM xla_event_sources
335: WHERE application_id = x_application_id
336: AND entity_code = x_entity_code
337: AND event_class_code = x_event_class_code
338: AND source_application_id = x_source_application_id

Line 417: FROM xla_event_sources

413: BEGIN
414:
415: SELECT last_updated_by, last_update_date
416: INTO db_luby, db_ludate
417: FROM xla_event_sources
418: WHERE application_id = l_application_id
419: AND entity_code = p_entity_code
420: AND event_class_code = p_event_class_code
421: AND source_application_id= l_source_app_id

Line 426: xla_event_sources_f_pkg.update_row

422: AND source_type_code = p_source_type_code
423: AND source_code = p_source_code;
424:
425: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, NULL)) THEN
426: xla_event_sources_f_pkg.update_row
427: (x_rowid => l_rowid
428: ,x_application_id => l_application_id
429: ,x_entity_code => p_entity_code
430: ,x_event_class_code => p_event_class_code

Line 444: xla_event_sources_f_pkg.insert_row

440: END IF;
441:
442: EXCEPTION
443: WHEN NO_DATA_FOUND THEN
444: xla_event_sources_f_pkg.insert_row
445: (x_rowid => l_rowid
446: ,x_application_id => l_application_id
447: ,x_entity_code => p_entity_code
448: ,x_event_class_code => p_event_class_code

Line 473: (p_location => 'xla_event_sources_f_pkg.load_row');

469: WHEN NO_DATA_FOUND THEN
470: null;
471: WHEN OTHERS THEN
472: xla_exceptions_pkg.raise_message
473: (p_location => 'xla_event_sources_f_pkg.load_row');
474:
475: END load_row;
476:
477: --=============================================================================

Line 493: end xla_event_sources_f_PKG;

489: IF NOT g_log_enabled THEN
490: g_log_level := C_LEVEL_LOG_DISABLED;
491: END IF;
492:
493: end xla_event_sources_f_PKG;