[Home] [Help]
119: g_parallel_jobs parallel_job_tb;
120: --
121: type new_values_r is record(
122: id number,
123: new_values dbms_sql.varchar2_table
124: );
125: type new_values_tb is table of new_values_r index by pls_integer;
126: g_values new_values_tb;
127: --
186: g_ssg session_stats_group_tb;
187: --------
188: --procedures-------------------------------------------------------
189: function in_array(
190: p_array dbms_sql.varchar2_table,
191: p_value varchar2
192: ) return boolean;
193: function in_array(
194: p_array dbms_sql.number_table,
190: p_array dbms_sql.varchar2_table,
191: p_value varchar2
192: ) return boolean;
193: function in_array(
194: p_array dbms_sql.number_table,
195: p_value number
196: ) return boolean;
197: function in_array(
198: p_array varchar2_table,
217: p_values out nocopy value_tb
218: );
219: procedure normalize_denorm_relation(p_relation in out nocopy parent_child_tb);
220: procedure make_stmt_for_aw(p_program varchar2,p_stmt in out nocopy varchar2,p_type varchar2);
221: procedure add_g_commands(p_commands in out nocopy dbms_sql.varchar2_table,p_command varchar2);
222: procedure trim_g_commands(p_commands in out nocopy dbms_sql.varchar2_table,p_trim number,p_add varchar2) ;
223: procedure exec_program_commands(p_program varchar2,p_commands dbms_sql.varchar2_table);
224: procedure dmp_g_options(p_options value_tb);
225: procedure create_temp_tables;
218: );
219: procedure normalize_denorm_relation(p_relation in out nocopy parent_child_tb);
220: procedure make_stmt_for_aw(p_program varchar2,p_stmt in out nocopy varchar2,p_type varchar2);
221: procedure add_g_commands(p_commands in out nocopy dbms_sql.varchar2_table,p_command varchar2);
222: procedure trim_g_commands(p_commands in out nocopy dbms_sql.varchar2_table,p_trim number,p_add varchar2) ;
223: procedure exec_program_commands(p_program varchar2,p_commands dbms_sql.varchar2_table);
224: procedure dmp_g_options(p_options value_tb);
225: procedure create_temp_tables;
226: procedure parse_out_agg_function(p_formula varchar2,p_noagg_formula out nocopy varchar2);
219: procedure normalize_denorm_relation(p_relation in out nocopy parent_child_tb);
220: procedure make_stmt_for_aw(p_program varchar2,p_stmt in out nocopy varchar2,p_type varchar2);
221: procedure add_g_commands(p_commands in out nocopy dbms_sql.varchar2_table,p_command varchar2);
222: procedure trim_g_commands(p_commands in out nocopy dbms_sql.varchar2_table,p_trim number,p_add varchar2) ;
223: procedure exec_program_commands(p_program varchar2,p_commands dbms_sql.varchar2_table);
224: procedure dmp_g_options(p_options value_tb);
225: procedure create_temp_tables;
226: procedure parse_out_agg_function(p_formula varchar2,p_noagg_formula out nocopy varchar2);
227: function get_max(p_array dbms_sql.number_table) return number;
223: procedure exec_program_commands(p_program varchar2,p_commands dbms_sql.varchar2_table);
224: procedure dmp_g_options(p_options value_tb);
225: procedure create_temp_tables;
226: procedure parse_out_agg_function(p_formula varchar2,p_noagg_formula out nocopy varchar2);
227: function get_max(p_array dbms_sql.number_table) return number;
228: procedure exec_aw_program_aggmap(p_name varchar2,p_commands dbms_sql.varchar2_table,p_type varchar2);
229: procedure exec_aggmap_commands(p_aggmap varchar2,p_commands dbms_sql.varchar2_table);
230: function does_table_have_data(p_table varchar2,p_where varchar2) return varchar2;
231: function is_std_aggregation_function(p_agg_formula varchar2) return varchar2;
224: procedure dmp_g_options(p_options value_tb);
225: procedure create_temp_tables;
226: procedure parse_out_agg_function(p_formula varchar2,p_noagg_formula out nocopy varchar2);
227: function get_max(p_array dbms_sql.number_table) return number;
228: procedure exec_aw_program_aggmap(p_name varchar2,p_commands dbms_sql.varchar2_table,p_type varchar2);
229: procedure exec_aggmap_commands(p_aggmap varchar2,p_commands dbms_sql.varchar2_table);
230: function does_table_have_data(p_table varchar2,p_where varchar2) return varchar2;
231: function is_std_aggregation_function(p_agg_formula varchar2) return varchar2;
232: function is_in_between(p_input number,p_left number,p_right number) return boolean ;
225: procedure create_temp_tables;
226: procedure parse_out_agg_function(p_formula varchar2,p_noagg_formula out nocopy varchar2);
227: function get_max(p_array dbms_sql.number_table) return number;
228: procedure exec_aw_program_aggmap(p_name varchar2,p_commands dbms_sql.varchar2_table,p_type varchar2);
229: procedure exec_aggmap_commands(p_aggmap varchar2,p_commands dbms_sql.varchar2_table);
230: function does_table_have_data(p_table varchar2,p_where varchar2) return varchar2;
231: function is_std_aggregation_function(p_agg_formula varchar2) return varchar2;
232: function is_in_between(p_input number,p_left number,p_right number) return boolean ;
233: function is_ascii(p_char varchar2) return boolean ;
233: function is_ascii(p_char varchar2) return boolean ;
234: function is_string_present(
235: p_string varchar2,
236: p_text varchar2,
237: p_location out nocopy dbms_sql.number_table
238: ) return boolean ;
239: procedure replace_string(
240: p_string in out nocopy varchar2,
241: p_old_text varchar2,
239: procedure replace_string(
240: p_string in out nocopy varchar2,
241: p_old_text varchar2,
242: p_new_text varchar2,
243: p_start_array dbms_sql.number_table
244: );
245: function get_adv_sum_profile return number ;
246: FUNCTION get_apps_schema_name RETURN VARCHAR2;
247: function get_table_owner(p_table varchar2) return varchar2 ;
253: procedure log_n(p_message varchar2);
254: procedure convert_varchar2_to_table(
255: p_string varchar2,
256: p_limit number,
257: p_table out nocopy dbms_sql.varchar2_table
258: );
259: procedure drop_db_object_ne(p_object varchar2,p_object_type varchar2);
260: procedure drop_db_object(p_object varchar2,p_object_type varchar2);
261: procedure execute_stmt(p_stmt varchar2);
259: procedure drop_db_object_ne(p_object varchar2,p_object_type varchar2);
260: procedure drop_db_object(p_object varchar2,p_object_type varchar2);
261: procedure execute_stmt(p_stmt varchar2);
262: procedure sleep(p_sleep_time integer,p_random_time integer);
263: procedure remove_array_element(p_array in out nocopy dbms_sql.varchar2_table,p_object varchar2);
264: procedure start_job(
265: p_job_name varchar2,
266: p_run_id number,
267: p_process varchar2,
284: function get_session_id return number;
285: procedure create_pipe(p_pipe_name varchar2);
286: procedure send_pipe_message(p_pipe_name varchar2,p_message varchar2);
287: procedure dmp_parallel_jobs;
288: function make_string_from_list(p_list dbms_sql.varchar2_table) return varchar2;
289: function make_string_from_list(p_list dbms_sql.varchar2_table,p_separator varchar2) return varchar2;
290: procedure parse_parameter_values(
291: p_string varchar2,
292: p_separator varchar2,
285: procedure create_pipe(p_pipe_name varchar2);
286: procedure send_pipe_message(p_pipe_name varchar2,p_message varchar2);
287: procedure dmp_parallel_jobs;
288: function make_string_from_list(p_list dbms_sql.varchar2_table) return varchar2;
289: function make_string_from_list(p_list dbms_sql.varchar2_table,p_separator varchar2) return varchar2;
290: procedure parse_parameter_values(
291: p_string varchar2,
292: p_separator varchar2,
293: p_values out nocopy dbms_sql.varchar2_table
289: function make_string_from_list(p_list dbms_sql.varchar2_table,p_separator varchar2) return varchar2;
290: procedure parse_parameter_values(
291: p_string varchar2,
292: p_separator varchar2,
293: p_values out nocopy dbms_sql.varchar2_table
294: );
295: function get_parameter_value(p_parameter varchar2) return varchar2;
296: procedure add_option(p_options varchar2,p_option_value varchar2,p_separator varchar2);
297: procedure execute_stmt_ne(p_stmt varchar2);
297: procedure execute_stmt_ne(p_stmt varchar2);
298: function get_hash_value(p_string varchar2,p_start number,p_end number) return varchar2 ;
299: function get_dbms_time return number;
300: function get_random_number(p_seed number) return number;
301: procedure merge_array(p_array in out nocopy dbms_sql.varchar2_table,p_values dbms_sql.varchar2_table);
302: procedure merge_value(p_array in out nocopy dbms_sql.varchar2_table,p_value varchar2);
303: procedure subtract_array(p_array in out nocopy dbms_sql.varchar2_table,p_values dbms_sql.varchar2_table);
304: procedure set_aw_trace;
305: procedure dmp_values(p_table dbms_sql.varchar2_table,p_text varchar2);
298: function get_hash_value(p_string varchar2,p_start number,p_end number) return varchar2 ;
299: function get_dbms_time return number;
300: function get_random_number(p_seed number) return number;
301: procedure merge_array(p_array in out nocopy dbms_sql.varchar2_table,p_values dbms_sql.varchar2_table);
302: procedure merge_value(p_array in out nocopy dbms_sql.varchar2_table,p_value varchar2);
303: procedure subtract_array(p_array in out nocopy dbms_sql.varchar2_table,p_values dbms_sql.varchar2_table);
304: procedure set_aw_trace;
305: procedure dmp_values(p_table dbms_sql.varchar2_table,p_text varchar2);
306: function get_sqlerror(p_sqlcode number,p_action varchar2) return sqlerror_r;
299: function get_dbms_time return number;
300: function get_random_number(p_seed number) return number;
301: procedure merge_array(p_array in out nocopy dbms_sql.varchar2_table,p_values dbms_sql.varchar2_table);
302: procedure merge_value(p_array in out nocopy dbms_sql.varchar2_table,p_value varchar2);
303: procedure subtract_array(p_array in out nocopy dbms_sql.varchar2_table,p_values dbms_sql.varchar2_table);
304: procedure set_aw_trace;
305: procedure dmp_values(p_table dbms_sql.varchar2_table,p_text varchar2);
306: function get_sqlerror(p_sqlcode number,p_action varchar2) return sqlerror_r;
307: procedure add_sqlerror(p_sqlcode number,p_action varchar2,p_message varchar2);
301: procedure merge_array(p_array in out nocopy dbms_sql.varchar2_table,p_values dbms_sql.varchar2_table);
302: procedure merge_value(p_array in out nocopy dbms_sql.varchar2_table,p_value varchar2);
303: procedure subtract_array(p_array in out nocopy dbms_sql.varchar2_table,p_values dbms_sql.varchar2_table);
304: procedure set_aw_trace;
305: procedure dmp_values(p_table dbms_sql.varchar2_table,p_text varchar2);
306: function get_sqlerror(p_sqlcode number,p_action varchar2) return sqlerror_r;
307: procedure add_sqlerror(p_sqlcode number,p_action varchar2,p_message varchar2);
308: function is_sqlerror(p_sqlcode number,p_action varchar2) return boolean;
309: procedure remove_sqlerror(p_sqlcode number,p_action varchar2);
312: procedure init_is_new_value;
313: procedure init_is_new_value(p_index number);
314: function is_new_value(p_value varchar2,p_index number) return boolean;
315: function is_new_value(p_value number,p_index number) return boolean;
316: function order_array(p_array dbms_sql.varchar2_table) return dbms_sql.varchar2_table;
317: function make_upper(p_array dbms_sql.varchar2_table) return dbms_sql.varchar2_table;
318: function is_avg_aggregation_function(p_agg_formula varchar2) return varchar2;
319: procedure get_db_lock(p_lock_name varchar2);
320: procedure release_db_lock(p_lock_name varchar2);
313: procedure init_is_new_value(p_index number);
314: function is_new_value(p_value varchar2,p_index number) return boolean;
315: function is_new_value(p_value number,p_index number) return boolean;
316: function order_array(p_array dbms_sql.varchar2_table) return dbms_sql.varchar2_table;
317: function make_upper(p_array dbms_sql.varchar2_table) return dbms_sql.varchar2_table;
318: function is_avg_aggregation_function(p_agg_formula varchar2) return varchar2;
319: procedure get_db_lock(p_lock_name varchar2);
320: procedure release_db_lock(p_lock_name varchar2);
321: function get_lock_handle(p_lock_name varchar2) return varchar2 ;
325: procedure analyze_table(p_table varchar2,p_owner varchar2);
326: procedure analyze_table(p_table varchar2,p_interval number);
327: procedure log_fnd(p_message varchar2,p_severity number);
328: procedure set_option(p_parameter varchar2,p_value varchar2);
329: function get_g_commands(p_commands dbms_sql.varchar2_table,p_index number) return varchar2;
330: procedure get_upper_trim_hier(p_parent_child parent_child_tb,p_seed varchar2,p_trim_parent_child in out nocopy parent_child_tb);
331: procedure get_lower_trim_hier(p_parent_child parent_child_tb,p_seed varchar2,p_trim_parent_child in out nocopy parent_child_tb);
332: procedure get_parent_values(p_parent_child parent_child_tb,p_child varchar2,p_parents out nocopy parent_child_tb);
333: procedure get_child_values(p_parent_child parent_child_tb,p_parent varchar2,p_children out nocopy parent_child_tb);
330: procedure get_upper_trim_hier(p_parent_child parent_child_tb,p_seed varchar2,p_trim_parent_child in out nocopy parent_child_tb);
331: procedure get_lower_trim_hier(p_parent_child parent_child_tb,p_seed varchar2,p_trim_parent_child in out nocopy parent_child_tb);
332: procedure get_parent_values(p_parent_child parent_child_tb,p_child varchar2,p_parents out nocopy parent_child_tb);
333: procedure get_child_values(p_parent_child parent_child_tb,p_parent varchar2,p_children out nocopy parent_child_tb);
334: procedure get_all_parents(p_parent_child parent_child_tb,p_child varchar2,p_parents in out nocopy dbms_sql.varchar2_table);
335: procedure get_all_children(p_parent_child parent_child_tb,p_parent varchar2,p_children in out nocopy dbms_sql.varchar2_table);
336: procedure update_property(p_string in out nocopy varchar2,p_parameter varchar2,p_value varchar2,p_separator varchar2);
337: procedure merge_property(p_property in out nocopy property_tb,p_property_name varchar2,p_property_type varchar2,p_property_value varchar2);
338: procedure remove_property(p_property in out nocopy property_tb,p_property_name varchar2);
331: procedure get_lower_trim_hier(p_parent_child parent_child_tb,p_seed varchar2,p_trim_parent_child in out nocopy parent_child_tb);
332: procedure get_parent_values(p_parent_child parent_child_tb,p_child varchar2,p_parents out nocopy parent_child_tb);
333: procedure get_child_values(p_parent_child parent_child_tb,p_parent varchar2,p_children out nocopy parent_child_tb);
334: procedure get_all_parents(p_parent_child parent_child_tb,p_child varchar2,p_parents in out nocopy dbms_sql.varchar2_table);
335: procedure get_all_children(p_parent_child parent_child_tb,p_parent varchar2,p_children in out nocopy dbms_sql.varchar2_table);
336: procedure update_property(p_string in out nocopy varchar2,p_parameter varchar2,p_value varchar2,p_separator varchar2);
337: procedure merge_property(p_property in out nocopy property_tb,p_property_name varchar2,p_property_type varchar2,p_property_value varchar2);
338: procedure remove_property(p_property in out nocopy property_tb,p_property_name varchar2);
339: function get_property(p_property property_tb,p_property_name varchar2) return property_r;
338: procedure remove_property(p_property in out nocopy property_tb,p_property_name varchar2);
339: function get_property(p_property property_tb,p_property_name varchar2) return property_r;
340: procedure merge_property(p_property in out nocopy property_tb,p_property_string varchar2,p_separator varchar2);
341: function get_property_string(p_property property_tb) return varchar2;
342: procedure merge_array(p_array in out nocopy dbms_sql.number_table,p_values dbms_sql.number_table);
343: procedure merge_value(p_array in out nocopy dbms_sql.number_table,p_value number);
344: function get_cpu_count return number;
345: procedure load_stats(p_name varchar2,p_group varchar2);
346: procedure load_session_stats(p_stats out nocopy stats_tb);
339: function get_property(p_property property_tb,p_property_name varchar2) return property_r;
340: procedure merge_property(p_property in out nocopy property_tb,p_property_string varchar2,p_separator varchar2);
341: function get_property_string(p_property property_tb) return varchar2;
342: procedure merge_array(p_array in out nocopy dbms_sql.number_table,p_values dbms_sql.number_table);
343: procedure merge_value(p_array in out nocopy dbms_sql.number_table,p_value number);
344: function get_cpu_count return number;
345: procedure load_stats(p_name varchar2,p_group varchar2);
346: procedure load_session_stats(p_stats out nocopy stats_tb);
347: procedure load_session_waits(p_wait_events out nocopy wait_event_tb);
360: function get_ssg_index(p_group varchar2) return pls_integer;
361: procedure kill_session(p_sid number,p_serial number);
362: function is_PT_aggregation_function(p_agg_formula varchar2) return varchar2 ;
363: function get_array_index(
364: p_array dbms_sql.varchar2_table,
365: p_value varchar2
366: ) return number;
367: function get_array_index(
368: p_array dbms_sql.number_table,
364: p_array dbms_sql.varchar2_table,
365: p_value varchar2
366: ) return number;
367: function get_array_index(
368: p_array dbms_sql.number_table,
369: p_value number
370: ) return number;
371: function is_CC_aggregation_function(p_agg_formula varchar2) return varchar2;
372: procedure check_jobs(p_parallel_jobs in out nocopy parallel_job_tb);