APPS.FEM_TABLE_REGISTRATION_PKG dependencies on FEM_TAB_COLUMNS_B

Line 103: FROM fem_tab_columns_b ftc

99: ,p_msg_text => 'After fetching the owner, owner = ' || l_owner);
100: BEGIN
101: SELECT 1
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

Line 116: DELETE FROM fem_tab_columns_b

112: IF dummy = 1 THEN
113: /* Changes have occurred so must flag the table status to "Incomplete" */
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 )

Line 172: ,p_msg_text => 'After deleting columns in fem_tab_columns but not in dba_tab_columns');

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

Line 213: FROM fem_tab_columns_b

209: WHERE dtc.table_name = p_table_name
210: AND dtc.owner = l_owner
211: AND dtc.column_name = fcr.column_name
212: AND NOT EXISTS ( SELECT 1
213: FROM fem_tab_columns_b
214: WHERE table_name = p_table_name
215: AND column_name = fcr.column_name );
216:
217: IF p_synchronize_flag <> 'Y' THEN

Line 261: FROM fem_tab_columns_b

257: 1
258: FROM fem_tab_columns_vl ftc,
259: (
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

Line 268: FROM fem_tab_columns_b fcr

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
269: WHERE fcr.column_name = dtc.column_name
270: AND fcr.table_name = p_table_name )) dump
271: WHERE ftc.column_name = dump.column_name
272: AND ftc.table_name = dump.tname;

Line 319: FROM fem_tab_columns_b ftc

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
320: WHERE column_name = atc.column_name
321: AND table_name = p_table_name );
322:
323: IF p_synchronize_flag <> 'Y' THEN

Line 808: FROM fem_tab_columns_b

804: 0 object_version_number
805: FROM fem_tab_columns_vl ftc,
806: (
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

Line 1152: FROM fem_tab_columns_b ftc,

1148: fnd_msg_pub.initialize;
1149:
1150: SELECT COUNT(*)
1151: INTO l_count
1152: FROM fem_tab_columns_b ftc,
1153: fem_tab_columns_gt ftcg
1154: WHERE ftc.table_name = p_table_name
1155: AND ftcg.table_name = ftc.table_name
1156: AND ftc.object_version_number <> ftcg.object_version_number

Line 1550: FROM fem_tab_columns_b ftc,

1546: ,p_msg_text => 'Before insert into _B');
1547:
1548: SELECT COUNT(*)
1549: INTO l_count
1550: FROM fem_tab_columns_b ftc,
1551: fem_tab_columns_gt ftcg
1552: WHERE ftc.table_name = p_table_name
1553: AND ftcg.table_name = ftc.table_name
1554: AND ftc.object_version_number <> ftcg.object_version_number

Line 1565: MERGE INTO fem_tab_columns_b ftc

1561:
1562: RAISE l_ovm_error;
1563: END IF;
1564:
1565: MERGE INTO fem_tab_columns_b ftc
1566: USING fem_tab_columns_gt ftcg
1567: ON ( ftc.column_name = ftcg.column_name
1568: AND ftc.table_name = p_table_name )
1569: WHEN MATCHED THEN UPDATE

Line 1806: FROM fem_tab_columns_b

1802:
1803: l_valid_flag := 'N';
1804:
1805: SELECT enabled_flag INTO l_valid_flag
1806: FROM fem_tab_columns_b
1807: WHERE table_name=p_table_name
1808: AND column_name = p_column_name;
1809:
1810: RETURN l_valid_flag;