eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FEM_TABLE_REGISTRATION_PKG dependencies on FEM_TAB_COLUMNS_GT

Line 668: INSERT INTO fem_tab_columns_gt

664: ,p_msg_text => 'Populating columns with data in requiremnt');
665:
666: IF p_mode = 'CREATE' THEN
667:
668: INSERT INTO fem_tab_columns_gt
669: (table_name,
670: column_name,
671: display_name,
672: description,

Line 746: INSERT INTO fem_tab_columns_gt

742: fem_engines_pkg.tech_message (p_severity => g_log_level_1
743: ,p_module => g_block||'.populate_tab_col_gt'
744: ,p_msg_text => 'Populating columns with data in tab columns');
745:
746: INSERT INTO fem_tab_columns_gt
747: (table_name,
748: column_name,
749: display_name,
750: description,

Line 815: FROM fem_tab_columns_gt fcr

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
816: WHERE fcr.column_name = dtc.column_name )) dump
817: WHERE ftc.column_name = dump.column_name
818: AND ftc.table_name = dump.tname;
819:

Line 824: INSERT INTO fem_tab_columns_gt

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,
827: display_name,
828: description,

Line 873: FROM fem_tab_columns_gt ftc

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
874: WHERE column_name = atc.column_name );
875:
876: ELSIF p_mode = 'UPDATE' THEN
877:

Line 907: INSERT INTO fem_tab_columns_gt

903: fem_engines_pkg.tech_message (p_severity => g_log_level_1
904: ,p_module => g_block||'.populate_tab_col_gt'
905: ,p_msg_text => 'Update mode: Populating columns');
906:
907: INSERT INTO fem_tab_columns_gt
908: (table_name,
909: column_name,
910: display_name,
911: description,

Line 985: INSERT INTO fem_tab_columns_gt

981: AND dt.column_name = dtc.column_name
982: AND dtc.column_name = fcr.column_name
983: AND dt.owner = l_owner;
984:
985: INSERT INTO fem_tab_columns_gt
986: (table_name,
987: column_name,
988: display_name,
989: description,

Line 1051: FROM fem_tab_columns_gt

1047: AND dt.table_name = dtc.table_name
1048: AND dt.column_name = dtc.column_name
1049: AND dt.owner = l_owner
1050: AND NOT EXISTS ( SELECT 1
1051: FROM fem_tab_columns_gt
1052: WHERE column_name = dtc.column_name );
1053:
1054: END IF;
1055:

Line 1153: fem_tab_columns_gt ftcg

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
1157: AND ftc.column_name = ftcg.column_name;

Line 1177: FROM fem_tab_columns_gt

1173: -- Get all the columns where display_name IS NULL
1174:
1175: SELECT column_name
1176: BULK COLLECT INTO l_column_tab
1177: FROM fem_tab_columns_gt
1178: WHERE display_name IS NULL;
1179:
1180: IF l_column_tab.COUNT > 0 THEN
1181: l_init := FALSE;

Line 1208: FROM fem_tab_columns_gt

1204: -- Get all the columns where description IS NULL
1205:
1206: SELECT column_name
1207: BULK COLLECT INTO l_column_tab
1208: FROM fem_tab_columns_gt
1209: WHERE description IS NULL;
1210:
1211: IF l_column_tab.COUNT > 0 THEN
1212: l_init := FALSE;

Line 1244: FROM fem_tab_columns_gt a,fem_tab_columns_gt b

1240: -- Get all the duplicate display name
1241:
1242: SELECT a.column_name,a.display_name
1243: BULK COLLECT INTO l_column_tab, l_display_tab
1244: FROM fem_tab_columns_gt a,fem_tab_columns_gt b
1245: WHERE UPPER(a.display_name)=UPPER(b.display_name)
1246: AND a.column_name <> b.column_name;
1247:
1248: IF l_column_tab.COUNT > 0 THEN

Line 1293: FROM fem_tab_columns_gt

1289: -- Get all the columns where fem_data_type_code = 'DIMENSION' AND dimension_id IS NULL
1290:
1291: SELECT column_name
1292: BULK COLLECT INTO l_column_tab
1293: FROM fem_tab_columns_gt
1294: WHERE cpm_datatype = 'DIMENSION'
1295: AND dimension_id IS NULL
1296: AND SUBSTR(COLUMN_NAME,1,8) <> 'USER_DIM';
1297:

Line 1326: FROM fem_tab_columns_gt

1322: -- Get all the columns where fem_data_type_code = ('TERM','FREQ','STATISTIC') AND uom_column_name IS NULL
1323:
1324: SELECT column_name
1325: BULK COLLECT INTO l_column_tab
1326: FROM fem_tab_columns_gt
1327: WHERE cpm_datatype IN ('TERM','FREQ','STATISTIC')
1328: AND uom_column_name IS NULL;
1329:
1330: IF l_column_tab.COUNT > 0 THEN

Line 1358: FROM fem_tab_columns_gt

1354: -- Get all the columns where fem_data_type_code <> ('TERM','FREQ','STATISTIC') AND uom_column_name IS NOT NULL
1355:
1356: SELECT column_name
1357: BULK COLLECT INTO l_column_tab
1358: FROM fem_tab_columns_gt
1359: WHERE cpm_datatype NOT IN ('TERM','FREQ','STATISTIC')
1360: AND uom_column_name IS NOT NULL;
1361:
1362: IF l_column_tab.COUNT > 0 THEN

Line 1391: FROM fem_tab_columns_gt a

1387: -- and maps to one of the columns being registered.
1388:
1389: SELECT column_name
1390: BULK COLLECT INTO l_column_tab
1391: FROM fem_tab_columns_gt a
1392: WHERE cpm_datatype IN ('TERM','FREQ','STATISTIC')
1393: AND uom_column_name IS NOT NULL
1394: AND NOT EXISTS ( SELECT column_name
1395: FROM fem_tab_columns_gt b

Line 1395: FROM fem_tab_columns_gt b

1391: FROM fem_tab_columns_gt a
1392: WHERE cpm_datatype IN ('TERM','FREQ','STATISTIC')
1393: AND uom_column_name IS NOT NULL
1394: AND NOT EXISTS ( SELECT column_name
1395: FROM fem_tab_columns_gt b
1396: WHERE a.uom_column_name = b.column_name );
1397:
1398: IF l_column_tab.COUNT > 0 THEN
1399: l_init := FALSE;

Line 1427: FROM fem_tab_columns_gt a

1423: -- and maps to one of the columns being registered, that column should be of dimension type
1424:
1425: SELECT column_name
1426: BULK COLLECT INTO l_column_tab
1427: FROM fem_tab_columns_gt a
1428: WHERE cpm_datatype IN ('TERM','FREQ','STATISTIC')
1429: AND uom_column_name IS NOT NULL
1430: AND NOT EXISTS ( SELECT column_name
1431: FROM fem_tab_columns_gt b

Line 1431: FROM fem_tab_columns_gt b

1427: FROM fem_tab_columns_gt a
1428: WHERE cpm_datatype IN ('TERM','FREQ','STATISTIC')
1429: AND uom_column_name IS NOT NULL
1430: AND NOT EXISTS ( SELECT column_name
1431: FROM fem_tab_columns_gt b
1432: WHERE a.uom_column_name = b.column_name
1433: AND b.cpm_datatype = 'DIMENSION' );
1434:
1435: IF l_column_tab.COUNT > 0 THEN

Line 1465: FROM fem_tab_columns_gt a

1461:
1462:
1463: SELECT column_name
1464: BULK COLLECT INTO l_column_tab
1465: FROM fem_tab_columns_gt a
1466: WHERE cpm_datatype IN ('TERM','FREQ','STATISTIC')
1467: AND uom_column_name IS NOT NULL
1468: AND uom_column_name in (SELECT uom_column_name
1469: FROM fem_tab_columns_gt b

Line 1469: FROM fem_tab_columns_gt b

1465: FROM fem_tab_columns_gt a
1466: WHERE cpm_datatype IN ('TERM','FREQ','STATISTIC')
1467: AND uom_column_name IS NOT NULL
1468: AND uom_column_name in (SELECT uom_column_name
1469: FROM fem_tab_columns_gt b
1470: GROUP BY uom_column_name
1471: HAVING COUNT(uom_column_name)>1);
1472:
1473: IF l_column_tab.COUNT > 0 THEN

Line 1503: FROM fem_tab_columns_gt ftcb,

1499: WHERE table_name = p_table_name;
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'

Line 1551: fem_tab_columns_gt ftcg

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
1555: AND ftc.column_name = ftcg.column_name;

Line 1566: USING fem_tab_columns_gt ftcg

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
1570: SET

Line 1617: FROM fem_tab_columns_gt tcgt,

1613: ,p_msg_text => 'Before insert into _TL');
1614:
1615: MERGE INTO fem_tab_columns_tl ftc
1616: USING (SELECT tcgt.*,fndl.language_code
1617: FROM fem_tab_columns_gt tcgt,
1618: fnd_languages fndl
1619: WHERE fndl.installed_flag IN ('I','B')) ftcg
1620: ON ( ftc.column_name = ftcg.column_name
1621: AND ftc.table_name = ftcg.table_name

Line 1755: DELETE FROM fem_tab_columns_gt;

1751: fem_engines_pkg.tech_message (p_severity => g_log_level_2
1752: ,p_module => g_block||'.dump_gt'
1753: ,p_msg_text => 'BEGIN');
1754:
1755: DELETE FROM fem_tab_columns_gt;
1756:
1757: fem_engines_pkg.tech_message (p_severity => g_log_level_2
1758: ,p_module => g_block||'.dump_gt'
1759: ,p_msg_text => 'END');