[Home] [Help]
102: INTO dummy
103: FROM fem_tab_columns_b ftc
104: WHERE ftc.column_name NOT IN
105: (SELECT column_name
106: FROM dba_tab_columns dtc
107: WHERE dtc.owner = l_owner
108: AND dtc.table_name=p_table_name)
109: AND ftc.table_name=p_table_name
110: AND ROWNUM = 1;
114: p_synchronize_flag := 'Y';
115:
116: DELETE FROM fem_tab_columns_b
117: WHERE column_name NOT IN ( SELECT column_name
118: FROM dba_tab_columns
119: WHERE table_name = p_table_name
120: AND owner = l_owner )
121: AND table_name = p_table_name
122: RETURNING column_name BULK COLLECT INTO l_column_tab;
168: END;
169:
170: fem_engines_pkg.tech_message (p_severity => g_log_level_1
171: ,p_module => g_block||'.synchronize'
172: ,p_msg_text => 'After deleting columns in fem_tab_columns but not in dba_tab_columns');
173:
174: BEGIN
175:
176: INSERT INTO fem_tab_columns_vl
203: SYSDATE,
204: l_user_id,
205: l_login_id,
206: 1
207: FROM dba_tab_columns dtc,
208: fem_column_requiremnt_vl fcr
209: WHERE dtc.table_name = p_table_name
210: AND dtc.owner = l_owner
211: AND dtc.column_name = fcr.column_name
260: SELECT dtc.column_name, dtc.table_name, dtc.nullable, (SELECT table_name tname
261: FROM fem_tab_columns_b
262: WHERE column_name = dtc.column_name AND rownum = 1) tname,
263: data_type
264: FROM dba_tab_columns dtc
265: WHERE dtc.table_name = p_table_name
266: AND dtc.owner = l_owner
267: AND NOT EXISTS ( SELECT 1
268: FROM fem_tab_columns_b fcr
278: END IF;
279:
280: fem_engines_pkg.tech_message (p_severity => g_log_level_1
281: ,p_module => g_block||'.synchronize'
282: ,p_msg_text => 'Populating columns with data in dba tab columns');
283:
284: INSERT INTO fem_tab_columns_vl
285: (table_name,
286: column_name,
311: SYSDATE,
312: l_user_id,
313: l_login_id,
314: 1
315: FROM dba_tab_columns atc
316: WHERE table_name = p_table_name
317: AND atc.owner = l_owner
318: AND NOT EXISTS ( SELECT 1
319: FROM fem_tab_columns_b ftc
732: 'Y' enabled_flag,
733: NVL(restricted_flag,'N') restricted_flag,
734: 'N' update_flag,
735: 0 object_version_number
736: FROM dba_tab_columns dtc,
737: fem_column_requiremnt_vl fcr
738: WHERE dtc.table_name = p_table_name
739: AND dtc.owner = p_owner
740: AND dtc.column_name = fcr.column_name;
807: SELECT dtc.column_name, dtc.table_name, (SELECT table_name tname
808: FROM fem_tab_columns_b
809: WHERE column_name = dtc.column_name AND rownum = 1) tname,
810: data_type, nullable, data_length, data_precision
811: FROM dba_tab_columns dtc
812: WHERE dtc.table_name = p_table_name
813: AND dtc.owner = p_owner
814: AND NOT EXISTS ( SELECT 1
815: FROM fem_tab_columns_gt fcr
818: AND ftc.table_name = dump.tname;
819:
820: fem_engines_pkg.tech_message (p_severity => g_log_level_1
821: ,p_module => g_block||'.populate_tab_col_gt'
822: ,p_msg_text => 'Populating columns with data in dba tab columns');
823:
824: INSERT INTO fem_tab_columns_gt
825: (table_name,
826: column_name,
865: 'Y',
866: 'N',
867: 'N' update_flag,
868: 0 object_version_number
869: FROM dba_tab_columns atc
870: WHERE table_name = p_table_name
871: AND atc.owner = p_owner
872: AND NOT EXISTS ( SELECT 1
873: FROM fem_tab_columns_gt ftc
974: 'Y' update_flag,
975: dtc.object_version_number
976: FROM fem_tab_columns_vl dtc,
977: fem_column_requiremnt_vl fcr,
978: dba_tab_columns dt
979: WHERE dtc.table_name = p_table_name
980: AND dtc.table_name = dt.table_name
981: AND dt.column_name = dtc.column_name
982: AND dtc.column_name = fcr.column_name
1041: 'N' restricted_flag,
1042: 'Y' update_flag,
1043: dtc.object_version_number
1044: FROM fem_tab_columns_vl dtc,
1045: dba_tab_columns dt
1046: WHERE dt.table_name = p_table_name
1047: AND dt.table_name = dtc.table_name
1048: AND dt.column_name = dtc.column_name
1049: AND dt.owner = l_owner
2527: gs_dim_id_tab,
2528: gs_null_flag_tab,
2529: gs_disp_name_tab
2530: FROM fem_tab_columns_vl ftcv,
2531: dba_tab_columns dtc
2532: WHERE ftcv.table_name = dtc.table_name
2533: AND ftcv.column_name = dtc.column_name
2534: AND dtc.owner = l_owner
2535: AND ftcv.enabled_flag='Y'