[Home] [Help]
1060: WHERE table_name = p_tab_name
1061: AND interface_table_name IS NOT NULL;
1062:
1063: -- Get interface table name and owner
1064: FEM_Database_Util_Pkg.Get_Table_Owner (
1065: x_return_status => v_return_status,
1066: x_msg_count => v_count,
1067: x_msg_data => v_msg_data,
1068: p_syn_name => v_int_tab_name,
1073: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1074: FEM_ENGINES_PKG.TECH_MESSAGE(
1075: p_severity => FND_LOG.level_statement,
1076: p_module => C_MODULE,
1077: p_msg_text => 'Call to FEM_Database_Util_Pkg.Get_Table_Owner failed');
1078: END IF;
1079: RAISE e_unexp;
1080: ELSE
1081: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1242: END IF;
1243: ELSE -- column is for a surrogate key DIMENSION
1244: -- Get Dimension Member _B table name and owner
1245: BEGIN
1246: FEM_Database_Util_Pkg.Get_Table_Owner (
1247: x_return_status => v_return_status,
1248: x_msg_count => v_count,
1249: x_msg_data => v_msg_data,
1250: p_syn_name => v_dim_mbr_table,
1255: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1256: FEM_ENGINES_PKG.TECH_MESSAGE(
1257: p_severity => FND_LOG.level_statement,
1258: p_module => C_MODULE,
1259: p_msg_text => 'Call to FEM_Database_Util_Pkg.Get_Table_Owner failed');
1260: END IF;
1261: RAISE e_unexp;
1262: ELSE
1263: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2220: v_passed_valid_out := c_true;
2221: v_passed := c_true;
2222:
2223: -- Get table name and owner
2224: FEM_Database_Util_Pkg.Get_Table_Owner (
2225: x_return_status => v_return_status,
2226: x_msg_count => v_msg_count,
2227: x_msg_data => v_msg_data,
2228: p_syn_name => p_tab_name,
2233: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2234: FEM_ENGINES_PKG.TECH_MESSAGE(
2235: p_severity => FND_LOG.level_statement,
2236: p_module => C_MODULE,
2237: p_msg_text => 'Call to FEM_Database_Util_Pkg.Get_Table_Owner failed');
2238: END IF;
2239: RAISE e_unexp;
2240: END IF;
2241: