APPS.EDW_SIZE_WRAPPER dependencies on EDW_SIZE_INPUT

Line 35: from EDW_SIZE_INPUT where

31: PARAMETER_NULL EXCEPTION;
32:
33: CURSOR c_get_schema IS
34: select table_name, table_owner, table_type
35: from EDW_SIZE_INPUT where
36: table_logical_name like p_log_name || '%';
37:
38: CURSOR c_get_proc_name IS
39: select num_rows_proc_name, row_len_proc_name

Line 40: from EDW_SIZE_INPUT where table_owner = g_schema

36: table_logical_name like p_log_name || '%';
37:
38: CURSOR c_get_proc_name IS
39: select num_rows_proc_name, row_len_proc_name
40: from EDW_SIZE_INPUT where table_owner = g_schema
41: and table_name = g_table_name;
42:
43: CURSOR c_get_all_objects IS
44: select num_rows_proc_name, row_len_proc_name, table_name, table_owner,

Line 46: from EDW_SIZE_INPUT order by table_owner;

42:
43: CURSOR c_get_all_objects IS
44: select num_rows_proc_name, row_len_proc_name, table_name, table_owner,
45: table_type, table_logical_name
46: from EDW_SIZE_INPUT order by table_owner;
47:
48: /*
49: changed from all_objects to user_objects by amitgupt
50: for impact analysis changes

Line 218: g_message := 'No table is found from EDW_SIZE_INPUT. ';

214: END IF;
215:
216: EXCEPTION
217: WHEN TABLE_NOT_FOUND THEN
218: g_message := 'No table is found from EDW_SIZE_INPUT. ';
219: fnd_file.put_line(FND_FILE.LOG, g_message) ;
220: fnd_file.put_line(FND_FILE.LOG, ' ') ;
221: WHEN PROCEDURE_NOT_FOUND THEN
222: g_message := 'Procedure name ' || l_row_cnt_proc_name

Line 223: || ' not found from table EDW_SIZE_INPUT. ';

219: fnd_file.put_line(FND_FILE.LOG, g_message) ;
220: fnd_file.put_line(FND_FILE.LOG, ' ') ;
221: WHEN PROCEDURE_NOT_FOUND THEN
222: g_message := 'Procedure name ' || l_row_cnt_proc_name
223: || ' not found from table EDW_SIZE_INPUT. ';
224: fnd_file.put_line(FND_FILE.LOG, g_message) ;
225: fnd_file.put_line(FND_FILE.LOG, ' ') ;
226: WHEN PACKAGE_NOT_FOUND THEN
227: g_message := 'Package ' || l_pack_name

Line 297: from EDW_SIZE_INPUT where table_name = g_table_name

293: and owner = g_schema;
294:
295: CURSOR c_get_cons_f IS
296: select avg_row_len1, avg_row_len2, avg_row_len3, max_row_len_ss, max_row_len_m
297: from EDW_SIZE_INPUT where table_name = g_table_name
298: and table_owner = g_schema;
299:
300: CURSOR c_get_cons_m IS
301: select num_of_levels, avg_row_len1, avg_row_len2, avg_row_len3,

Line 303: from EDW_SIZE_INPUT where table_name = g_table_name

299:
300: CURSOR c_get_cons_m IS
301: select num_of_levels, avg_row_len1, avg_row_len2, avg_row_len3,
302: avg_row_len4, avg_row_len5, avg_row_len6, max_row_len_l
303: from EDW_SIZE_INPUT where table_name = g_table_name
304: and table_owner = g_schema;
305:
306:
307: BEGIN