eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_SOURCES_F_PKG dependencies on XLA_SOURCES_F_PKG

Line 1: PACKAGE BODY xla_sources_f_pkg AS

1: PACKAGE BODY xla_sources_f_pkg AS
2: /* $Header: xlathsou.pkb 120.25.12010000.1 2008/07/29 10:10:26 appldev ship $ */
3: /*======================================================================+
4: | Copyright (c) 2001-2002 Oracle Corporation |
5: | Redwood Shores, CA, USA |

Line 27: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_sources_f_pkg';

23: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
24: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
25: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
26: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
27: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_sources_f_pkg';
28: -- Global variables for debugging
29: g_log_level PLS_INTEGER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
30: g_log_enabled BOOLEAN := fnd_log.test
31: (log_level => g_log_level

Line 50: (p_location => 'xla_sources_f_pkg.trace');

46: WHEN xla_exceptions_pkg.application_exception THEN
47: RAISE;
48: WHEN OTHERS THEN
49: xla_exceptions_pkg.raise_message
50: (p_location => 'xla_sources_f_pkg.trace');
51: END trace;
52:
53: /*======================================================================+
54: | |

Line 97: xla_utility_pkg.trace('> xla_sources_f_pkg.insert_row' ,20);

93: AND source_type_code = x_source_type_code
94: ;
95:
96: BEGIN
97: xla_utility_pkg.trace('> xla_sources_f_pkg.insert_row' ,20);
98:
99: INSERT INTO xla_sources_b
100: (creation_date
101: ,created_by

Line 194: xla_utility_pkg.trace('< xla_sources_f_pkg.insert_row' ,20);

190: RAISE NO_DATA_FOUND;
191: END IF;
192: CLOSE c;
193:
194: xla_utility_pkg.trace('< xla_sources_f_pkg.insert_row' ,20);
195:
196: EXCEPTION
197: WHEN OTHERS THEN
198: xla_exceptions_pkg.raise_message

Line 199: (p_location => 'xla_sources_f_pkg.insert_row');

195:
196: EXCEPTION
197: WHEN OTHERS THEN
198: xla_exceptions_pkg.raise_message
199: (p_location => 'xla_sources_f_pkg.insert_row');
200:
201: END insert_row;
202:
203: /*======================================================================+

Line 427: xla_utility_pkg.trace('> xla_sources_f_pkg.update_row' ,20);

423:
424: IS
425:
426: BEGIN
427: xla_utility_pkg.trace('> xla_sources_f_pkg.update_row' ,20);
428: UPDATE xla_sources_b
429: SET
430: last_update_date = x_last_update_date
431: ,plsql_function_name = x_plsql_function_name

Line 473: xla_utility_pkg.trace('< xla_sources_f_pkg.update_row' ,20);

469: IF (SQL%NOTFOUND) THEN
470: RAISE NO_DATA_FOUND;
471: END IF;
472:
473: xla_utility_pkg.trace('< xla_sources_f_pkg.update_row' ,20);
474: END update_row;
475:
476: /*======================================================================+
477: | |

Line 489: xla_utility_pkg.trace('> xla_sources_f_pkg.delete_row' ,20);

485:
486: IS
487:
488: BEGIN
489: xla_utility_pkg.trace('> xla_sources_f_pkg.delete_row' ,20);
490: DELETE FROM xla_sources_tl
491: WHERE application_id = x_application_id
492: AND source_code = x_source_code
493: AND source_type_code = x_source_type_code;

Line 511: xla_utility_pkg.trace('< xla_sources_f_pkg.delete_row' ,20);

507: RAISE NO_DATA_FOUND;
508: END IF;
509:
510:
511: xla_utility_pkg.trace('< xla_sources_f_pkg.delete_row' ,20);
512: END delete_row;
513:
514: /*======================================================================+
515: | |

Line 524: xla_utility_pkg.trace('> xla_sources_f_pkg.add_language' ,20);

520:
521: IS
522:
523: BEGIN
524: xla_utility_pkg.trace('> xla_sources_f_pkg.add_language' ,20);
525:
526: DELETE FROM xla_sources_tl T
527: WHERE NOT EXISTS
528: (SELECT NULL

Line 605: xla_utility_pkg.trace('< xla_sources_f_pkg.add_language' ,20);

601: AND t.source_code = b.source_code
602: AND t.source_type_code = b.source_type_code
603: AND t.language = l.language_code);
604:
605: xla_utility_pkg.trace('< xla_sources_f_pkg.add_language' ,20);
606: END add_language;
607:
608: /*======================================================================+
609: | |

Line 713: xla_sources_f_pkg.update_row

709: AND source_type_code = p_source_type_code;
710:
711: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
712: db_ludate, null)) then
713: xla_sources_f_pkg.update_row
714: (x_application_id => l_application_id
715: ,x_source_code => p_source_code
716: ,x_source_type_code => p_source_type_code
717: ,x_plsql_function_name => p_plsql_function_name

Line 743: xla_sources_f_pkg.insert_row

739:
740: EXCEPTION
741:
742: WHEN NO_DATA_FOUND THEN
743: xla_sources_f_pkg.insert_row
744: (x_rowid => l_rowid
745: ,x_application_id => l_application_id
746: ,x_source_code => p_source_code
747: ,x_source_type_code => p_source_type_code

Line 778: (p_location => 'xla_sources_f_pkg.load_row');

774: WHEN NO_DATA_FOUND THEN
775: null;
776: WHEN OTHERS THEN
777: xla_exceptions_pkg.raise_message
778: (p_location => 'xla_sources_f_pkg.load_row');
779:
780: END load_row;
781:
782: /*======================================================================+

Line 867: end xla_sources_f_PKG;

863:
864: IF NOT g_log_enabled THEN
865: g_log_level := C_LEVEL_LOG_DISABLED;
866: END IF;
867: end xla_sources_f_PKG;