APPS.FEM_TABLE_REGISTRATION_PKG dependencies on FEM_TABLES_B

Line 144: UPDATE fem_tables_b

140: DELETE FROM fem_tab_column_prop
141: WHERE table_name = p_table_name
142: AND column_property_code = 'PROCESSING_KEY';
143:
144: UPDATE fem_tables_b
145: SET proc_key_index_name = NULL
146: WHERE table_name = p_table_name;
147:
148: raise_proc_key_update_event(p_table_name,

Line 1498: FROM fem_tables_b ftb

1494:
1495: IF p_mode = 'UPDATE' THEN
1496: SELECT proc_key_index_name
1497: INTO l_index_name
1498: FROM fem_tables_b ftb
1499: WHERE table_name = p_table_name;
1500:
1501: SELECT ftcb.column_name
1502: BULK COLLECT INTO l_column_tab

Line 1783: FROM fem_tables_b

1779: BEGIN
1780: l_valid_flag := 'N';
1781:
1782: SELECT enabled_flag INTO l_valid_flag
1783: FROM fem_tables_b
1784: WHERE table_name=p_table_name;
1785:
1786: RETURN l_valid_flag;
1787:

Line 2242: SELECT di_view_name INTO x_di_view_name FROM fem_tables_b

2238: FUNCTION get_di_view_details(p_table_name IN VARCHAR2) RETURN VARCHAR2
2239: AS
2240: x_di_view_name varchar2(30);
2241: BEGIN
2242: SELECT di_view_name INTO x_di_view_name FROM fem_tables_b
2243: WHERE table_name = p_table_name
2244: AND EXISTS (SELECT 1 FROM user_objects WHERE object_name = di_view_name
2245: AND status = 'VALID');
2246:

Line 2491: UPDATE fem_tables_b set di_view_name = NULL where table_name=p_tab_name;

2487:
2488:
2489: BEGIN
2490:
2491: UPDATE fem_tables_b set di_view_name = NULL where table_name=p_tab_name;
2492:
2493: COMMIT; --Set di view name to null in begining
2494:
2495:

Line 2699: UPDATE fem_tables_b set di_view_name = l_view_name where table_name=p_tab_name;

2695: ,p_module => G_BLOCK||'.'||l_api_name
2696: ,p_msg_text => 'END'
2697: );
2698:
2699: UPDATE fem_tables_b set di_view_name = l_view_name where table_name=p_tab_name;
2700:
2701: retcode:=0; --Set the status to success
2702: COMMIT;
2703: