DBA Data[Home] [Help]

APPS.FEM_ADMIN_UTIL_PKG dependencies on ALL_TABLES

Line 1018: v_int_tab_name ALL_TABLES.table_name%TYPE;

1014:
1015: v_count NUMBER;
1016: v_passed_valid VARCHAR2(1);
1017: v_return_status VARCHAR2(1);
1018: v_int_tab_name ALL_TABLES.table_name%TYPE;
1019: v_int_db_tab_name ALL_TABLES.table_name%TYPE;
1020: v_int_owner ALL_TABLES.owner%TYPE;
1021: v_col_prop FEM_TAB_COLUMN_PROP.column_property_code%TYPE;
1022: v_matched VARCHAR2(1);

Line 1019: v_int_db_tab_name ALL_TABLES.table_name%TYPE;

1015: v_count NUMBER;
1016: v_passed_valid VARCHAR2(1);
1017: v_return_status VARCHAR2(1);
1018: v_int_tab_name ALL_TABLES.table_name%TYPE;
1019: v_int_db_tab_name ALL_TABLES.table_name%TYPE;
1020: v_int_owner ALL_TABLES.owner%TYPE;
1021: v_col_prop FEM_TAB_COLUMN_PROP.column_property_code%TYPE;
1022: v_matched VARCHAR2(1);
1023: v_msg_data VARCHAR2(2000);

Line 1020: v_int_owner ALL_TABLES.owner%TYPE;

1016: v_passed_valid VARCHAR2(1);
1017: v_return_status VARCHAR2(1);
1018: v_int_tab_name ALL_TABLES.table_name%TYPE;
1019: v_int_db_tab_name ALL_TABLES.table_name%TYPE;
1020: v_int_owner ALL_TABLES.owner%TYPE;
1021: v_col_prop FEM_TAB_COLUMN_PROP.column_property_code%TYPE;
1022: v_matched VARCHAR2(1);
1023: v_msg_data VARCHAR2(2000);
1024: v_col_list VARCHAR2(4000);

Line 1041: v_mbr_b_owner ALL_TABLES.owner%TYPE;

1037: v_data_scale ALL_TAB_COLUMNS.data_scale%TYPE;
1038:
1039: v_dim_dc_data_length ALL_TAB_COLUMNS.data_length%TYPE;
1040: v_dim_dc_data_type ALL_TAB_COLUMNS.data_type%TYPE;
1041: v_mbr_b_owner ALL_TABLES.owner%TYPE;
1042: v_mbr_b_table_name ALL_TABLES.table_name%TYPE;
1043: BEGIN
1044: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1045: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 1042: v_mbr_b_table_name ALL_TABLES.table_name%TYPE;

1038:
1039: v_dim_dc_data_length ALL_TAB_COLUMNS.data_length%TYPE;
1040: v_dim_dc_data_type ALL_TAB_COLUMNS.data_type%TYPE;
1041: v_mbr_b_owner ALL_TABLES.owner%TYPE;
1042: v_mbr_b_table_name ALL_TABLES.table_name%TYPE;
1043: BEGIN
1044: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1045: FEM_ENGINES_PKG.TECH_MESSAGE(
1046: p_severity => FND_LOG.level_procedure,

Line 2208: v_db_tab_name ALL_TABLES.table_name%TYPE;

2204: v_passed VARCHAR2(1);
2205: v_msg_count NUMBER;
2206: v_msg_data VARCHAR2(2000);
2207:
2208: v_db_tab_name ALL_TABLES.table_name%TYPE;
2209: v_tab_owner ALL_TABLES.owner%TYPE;
2210: v_procedure FEM_TABLE_PROP_STP.stored_procedure_name%TYPE;
2211: BEGIN
2212: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 2209: v_tab_owner ALL_TABLES.owner%TYPE;

2205: v_msg_count NUMBER;
2206: v_msg_data VARCHAR2(2000);
2207:
2208: v_db_tab_name ALL_TABLES.table_name%TYPE;
2209: v_tab_owner ALL_TABLES.owner%TYPE;
2210: v_procedure FEM_TABLE_PROP_STP.stored_procedure_name%TYPE;
2211: BEGIN
2212: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2213: FEM_ENGINES_PKG.TECH_MESSAGE(