APPS.XLA_UTILITY_PROFILER_PKG dependencies on XLA_UTILITY_PKG

Line 42: l_cr := dbms_profiler.start_profiler(xla_utility_pkg.g_unique_location);

38: BEGIN
39: --
40: -- To be uncommented when dbms_profiler is installed
41: --
42: l_cr := dbms_profiler.start_profiler(xla_utility_pkg.g_unique_location);
43:
44: NULL;
45:
46: END start_profiler;

Line 111: xla_utility_pkg.trace(RPAD('+',76,'-')||'+' ,-10);

107:
108: PRAGMA exception_init (l_table_not_exist , -0942);
109:
110: BEGIN
111: xla_utility_pkg.trace(RPAD('+',76,'-')||'+' ,-10);
112: xla_utility_pkg.trace('Profiler info' ,-10);
113:
114: --
115: -- Get the runid

Line 112: xla_utility_pkg.trace('Profiler info' ,-10);

108: PRAGMA exception_init (l_table_not_exist , -0942);
109:
110: BEGIN
111: xla_utility_pkg.trace(RPAD('+',76,'-')||'+' ,-10);
112: xla_utility_pkg.trace('Profiler info' ,-10);
113:
114: --
115: -- Get the runid
116: --

Line 121: || 'WHERE run_comment = '''||xla_utility_pkg.g_unique_location||'''';

117: l_statement_runid := 'SELECT runid '
118: || xla_environment_pkg.g_chr_newline
119: || 'FROM plsql_profiler_runs '
120: || xla_environment_pkg.g_chr_newline
121: || 'WHERE run_comment = '''||xla_utility_pkg.g_unique_location||'''';
122:
123: -- xla_utility_pkg.trace(l_statement_runid , 50);
124:
125: l_cr_runid := dbms_sql.open_cursor;

Line 123: -- xla_utility_pkg.trace(l_statement_runid , 50);

119: || 'FROM plsql_profiler_runs '
120: || xla_environment_pkg.g_chr_newline
121: || 'WHERE run_comment = '''||xla_utility_pkg.g_unique_location||'''';
122:
123: -- xla_utility_pkg.trace(l_statement_runid , 50);
124:
125: l_cr_runid := dbms_sql.open_cursor;
126:
127: dbms_sql.parse

Line 164: -- xla_utility_pkg.trace(l_statement_unit , 50);

160: || ' AND unit_name NOT IN (''DBMS_PROFILER'' '
161: || xla_environment_pkg.g_chr_newline
162: || ' ,'''') ';
163:
164: -- xla_utility_pkg.trace(l_statement_unit , 50);
165:
166: l_cr_unit := dbms_sql.open_cursor;
167:
168: dbms_sql.parse

Line 202: xla_utility_pkg.trace(l_unit_name ,-10);

198: dbms_sql.column_value(l_cr_unit,1,l_unit_type);
199: dbms_sql.column_value(l_cr_unit,2,l_unit_name);
200: dbms_sql.column_value(l_cr_unit,3,l_unit_number);
201:
202: xla_utility_pkg.trace(l_unit_name ,-10);
203: xla_utility_pkg.trace('' ,-10);
204:
205: l_statement_data := 'SELECT s.text '
206: || c_chr || ' ,d.total_occur '

Line 203: xla_utility_pkg.trace('' ,-10);

199: dbms_sql.column_value(l_cr_unit,2,l_unit_name);
200: dbms_sql.column_value(l_cr_unit,3,l_unit_number);
201:
202: xla_utility_pkg.trace(l_unit_name ,-10);
203: xla_utility_pkg.trace('' ,-10);
204:
205: l_statement_data := 'SELECT s.text '
206: || c_chr || ' ,d.total_occur '
207: || c_chr || ' ,d.total_time '

Line 263: xla_utility_pkg.trace ('! '

259: dbms_sql.column_value(l_cr_data, 3,l_total_time );
260: dbms_sql.column_value(l_cr_data, 4,l_min_time );
261: dbms_sql.column_value(l_cr_data, 5,l_max_time );
262:
263: xla_utility_pkg.trace ('! '
264: || SUBSTR(
265: RPAD(
266: REPLACE(l_text ,xla_environment_pkg.g_chr_newline,''),75,' '),1,75)
267: || ' '