APPS.FEM_ADMIN_UTIL_PKG dependencies on FEM_TABLES_B

Line 1059: FROM fem_tables_b

1055: -- Interface table must be registered
1056: BEGIN
1057: SELECT interface_table_name
1058: INTO v_int_tab_name
1059: FROM fem_tables_b
1060: WHERE table_name = p_tab_name
1061: AND interface_table_name IS NOT NULL;
1062:
1063: -- Get interface table name and owner

Line 1841: v_idx_name FEM_TABLES_B.proc_key_index_name%TYPE;

1837: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1838: 'fem.plsql.fem_admin_util_pkg.validate_processing_key_idx';
1839:
1840: v_count NUMBER;
1841: v_idx_name FEM_TABLES_B.proc_key_index_name%TYPE;
1842: v_idx_owner FEM_TABLES_B.proc_key_index_owner%TYPE;
1843: v_matched VARCHAR2(1);
1844:
1845: e_no_idx EXCEPTION;

Line 1842: v_idx_owner FEM_TABLES_B.proc_key_index_owner%TYPE;

1838: 'fem.plsql.fem_admin_util_pkg.validate_processing_key_idx';
1839:
1840: v_count NUMBER;
1841: v_idx_name FEM_TABLES_B.proc_key_index_name%TYPE;
1842: v_idx_owner FEM_TABLES_B.proc_key_index_owner%TYPE;
1843: v_matched VARCHAR2(1);
1844:
1845: e_no_idx EXCEPTION;
1846: e_exit_successfully EXCEPTION;

Line 1863: FROM fem_tables_b

1859: -- First make sure the index actually exists
1860: BEGIN
1861: SELECT proc_key_index_name, proc_key_index_owner
1862: INTO v_idx_name, v_idx_owner
1863: FROM fem_tables_b
1864: WHERE table_name = p_tab_name;
1865:
1866: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1867: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 2661: fem_tables_b ftb,

2657: --need to think abt this
2658: SELECT tiig.table_name, tig.owner
2659: INTO x_tab_name,x_tab_owner
2660: FROM fem_tab_indx_info_gt tiig,
2661: fem_tables_b ftb,
2662: fem_tab_info_gt tig
2663: WHERE ftb.table_name = p_view_name
2664: AND ftb.PROC_KEY_INDEX_NAME = tiig.INDEX_NAME
2665: AND tig.table_name = tiig.table_name