APPS.EDW_SIZE_WRAPPER dependencies on EDW_SIZE_OUTPUT

Line 291: from EDW_SIZE_OUTPUT where

287: l_to_date varchar2(11);
288:
289: CURSOR c_check IS
290: select count(*)
291: from EDW_SIZE_OUTPUT where
292: table_name = g_table_name
293: and owner = g_schema;
294:
295: CURSOR c_get_cons_f IS

Line 352: insert into edw_size_output(

348: g_all_table_space := g_all_table_space + l_tbl_size_s + l_tbl_size_t;
349: END IF;
350:
351: IF l_count = 0 THEN
352: insert into edw_size_output(
353: TABLE_NAME,
354: OWNER,
355: TABLE_TYPE,
356: TABLE_LOGICAL_NAME,

Line 411: update edw_size_output set TABLE_LOGICAL_NAME = g_log_name,

407: g_message := 'Object logical name: ' || g_log_name ||
408: ', one record is inserted';
409: fnd_file.put_line(FND_FILE.LOG, g_message) ;
410: ELSE
411: update edw_size_output set TABLE_LOGICAL_NAME = g_log_name,
412: OWNER = g_schema,
413: AVG_ROW_LEN_STAGE = l_TBL_s,
414: AVG_ROW_LEN = l_TBL_t,
415: AVG_ROW_LEN_IND_S = l_IND_s,

Line 506: insert into edw_size_output(

502: g_all_table_space := g_all_table_space + l_tbl_size_s + l_tbl_size_l + l_tbl_size_t;
503: END IF;
504:
505: IF l_count = 0 THEN
506: insert into edw_size_output(
507: TABLE_NAME,
508: OWNER,
509: TABLE_TYPE,
510: TABLE_LOGICAL_NAME,

Line 571: update edw_size_output set TABLE_LOGICAL_NAME = g_log_name,

567: g_message := 'Object logical name: ' || g_log_name ||
568: ', one record is inserted';
569: fnd_file.put_line(FND_FILE.LOG, g_message) ;
570: ELSE
571: update edw_size_output set TABLE_LOGICAL_NAME = g_log_name,
572: OWNER = g_schema,
573: AVG_ROW_LEN_STAGE = l_TBL_s,
574: AVG_ROW_LEN = l_TBL_t,
575: AVG_ROW_LEN_LEVEL = l_TBL_l,

Line 674: from EDW_SIZE_OUTPUT where table_logical_name = p_log_name;

670: NO_INFORMATION EXCEPTION;
671:
672: CURSOR c_get_type IS
673: select table_name, table_type
674: from EDW_SIZE_OUTPUT where table_logical_name = p_log_name;
675:
676: CURSOR c_get_object_f IS
677: select TABLE_LOGICAL_NAME,
678: OWNER,

Line 696: from EDW_SIZE_OUTPUT where table_logical_name = p_log_name;

692: RB_SIZE ,
693: TEMP_TABLE_SIZE ,
694: TOTAL_PEM_SPACE ,
695: TOTAL_TMP_SPACE
696: from EDW_SIZE_OUTPUT where table_logical_name = p_log_name;
697:
698: CURSOR c_get_object_m IS
699: select TABLE_LOGICAL_NAME,
700: OWNER,

Line 722: from EDW_SIZE_OUTPUT where table_logical_name = p_log_name;

718: TEMP_TABLE_SIZE ,
719: TEMP_SIZE_SOURCE ,
720: TOTAL_PEM_SPACE ,
721: TOTAL_TMP_SPACE
722: from EDW_SIZE_OUTPUT where table_logical_name = p_log_name;
723:
724: CURSOR c_get_objects IS
725: select TABLE_LOGICAL_NAME,
726: TABLE_TYPE,

Line 749: from EDW_SIZE_OUTPUT order by owner;

745: TEMP_TABLE_SIZE ,
746: TEMP_SIZE_SOURCE ,
747: TOTAL_PEM_SPACE ,
748: TOTAL_TMP_SPACE
749: from EDW_SIZE_OUTPUT order by owner;
750:
751: BEGIN
752:
753: g_log_name := p_log_name;