APPS.FEM_TABLE_REGISTRATION_PKG dependencies on FEM_TAB_COLUMN_PROP

Line 130: DELETE FROM fem_tab_column_prop

126: WHERE table_name = p_table_name
127: AND column_name = l_column_tab(i);
128:
129: FOR i IN l_column_tab.FIRST..l_column_tab.LAST LOOP
130: DELETE FROM fem_tab_column_prop
131: WHERE table_name =p_table_name
132: AND column_name = l_column_tab(i)
133: RETURNING column_property_code BULK COLLECT INTO l_col_prop_code_tab ;
134: END LOOP;

Line 140: DELETE FROM fem_tab_column_prop

136: IF l_col_prop_code_tab.exists(1) THEN
137: FOR j IN l_col_prop_code_tab.FIRST .. l_col_prop_code_tab.LAST
138: LOOP
139: IF 'PROCESSING_KEY' = l_col_prop_code_tab(j) AND l_pk_col = 0 THEN
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

Line 460: DELETE FROM fem_tab_column_prop

456:
457: DELETE FROM fem_tables_vl
458: WHERE table_name = p_table_name;
459:
460: DELETE FROM fem_tab_column_prop
461: WHERE table_name = p_table_name;
462:
463: DELETE FROM fem_table_class_assignmt
464: WHERE table_name = p_table_name;

Line 1504: fem_tab_column_prop ftcp

1500:
1501: SELECT ftcb.column_name
1502: BULK COLLECT INTO l_column_tab
1503: FROM fem_tab_columns_gt ftcb,
1504: fem_tab_column_prop ftcp
1505: WHERE ftcb.table_name = p_table_name
1506: AND ftcb.table_name = ftcp.table_name
1507: AND ftcp.column_property_code = 'PROCESSING_KEY'
1508: AND ftcp.column_name = ftcb.column_name

Line 2539: FROM fem_tab_column_prop

2535: AND ftcv.enabled_flag='Y'
2536: AND (EXISTS
2537: (
2538: SELECT column_name
2539: FROM fem_tab_column_prop
2540: WHERE column_property_code='PROCESSING_KEY'
2541: AND table_name = ftcv.table_name
2542: AND column_name = ftcv.column_name)
2543: OR