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_ADMIN_UTIL_PKG dependencies on ALL_TAB_COLUMNS

Line 378: v_col_name ALL_TAB_COLUMNS.column_name%TYPE;

374: WHERE table_property_code = p_tab_prop_cd;
375:
376: v_sql VARCHAR2(4000);
377: v_col_list VARCHAR2(2000);
378: v_col_name ALL_TAB_COLUMNS.column_name%TYPE;
379: v_obj_name FND_LOOKUP_VALUES.meaning%TYPE;
380: v_col_prop_cd FEM_TAB_COLUMN_PROP.column_property_code%TYPE;
381: v_msg_name FND_NEW_MESSAGES.message_name%TYPE;
382: v_vsr_flag FEM_XDIM_DIMENSIONS.value_set_required_flag%TYPE;

Line 721: FROM all_tab_columns a, fem_tab_column_prop p

717: 'fem.plsql.fem_admin_util_pkg.validate_pk_cols_not_null';
718:
719: CURSOR c_null_cols (p_tab_name VARCHAR2, p_owner VARCHAR2) IS
720: SELECT a.column_name
721: FROM all_tab_columns a, fem_tab_column_prop p
722: WHERE a.table_name = p_tab_name
723: AND a.owner = p_owner
724: AND a.nullable = 'Y'
725: AND a.table_name = p.table_name

Line 970: FROM all_tab_columns

966: AND uniqueness = 'UNIQUE';
967:
968: CURSOR c_int_col (p_owner VARCHAR2, p_name VARCHAR2) IS
969: SELECT column_name, data_type, data_length, data_precision
970: FROM all_tab_columns
971: WHERE owner = p_owner
972: AND table_name = p_name
973: AND nullable = 'N'
974: AND column_name IN ('CAL_PERIOD_NUMBER',

Line 985: FROM fem_tab_columns_v f, all_tab_columns a

981: to have interface col mapping. For all other cols it is
982: optional*/
983: CURSOR c_missing_int_col (p_owner VARCHAR2, p_name VARCHAR2) IS
984: SELECT f.column_name
985: FROM fem_tab_columns_v f, all_tab_columns a
986: WHERE f.table_name = p_name
987: AND f.column_name NOT IN ('CREATED_BY_REQUEST_ID',
988: 'LAST_UPDATED_BY_REQUEST_ID',
989: 'CREATED_BY_OBJECT_ID',

Line 1002: FROM fem_tab_columns_b F, all_tab_columns A

998:
999: CURSOR c_tgt_col (p_name IN VARCHAR2, p_owner IN VARCHAR2) IS
1000: SELECT F.column_name, F.interface_column_name, F.fem_data_type_code, F.dimension_id,
1001: A.data_type, A.data_length, A.data_precision, A.data_scale
1002: FROM fem_tab_columns_b F, all_tab_columns A
1003: WHERE F.table_name = p_name
1004: AND F.column_name NOT IN ('CREATED_BY_REQUEST_ID',
1005: 'LAST_UPDATED_BY_REQUEST_ID',
1006: 'CREATED_BY_OBJECT_ID',

Line 1034: v_data_type ALL_TAB_COLUMNS.data_type%TYPE;

1030: v_dim_mbr_col VARCHAR2(30);
1031: v_dim_mbr_dc_col VARCHAR2(30);
1032: v_dim_label VARCHAR2(30);
1033:
1034: v_data_type ALL_TAB_COLUMNS.data_type%TYPE;
1035: v_data_length ALL_TAB_COLUMNS.data_length%TYPE;
1036: v_data_precision ALL_TAB_COLUMNS.data_precision%TYPE;
1037: v_data_scale ALL_TAB_COLUMNS.data_scale%TYPE;
1038:

Line 1035: v_data_length ALL_TAB_COLUMNS.data_length%TYPE;

1031: v_dim_mbr_dc_col VARCHAR2(30);
1032: v_dim_label VARCHAR2(30);
1033:
1034: v_data_type ALL_TAB_COLUMNS.data_type%TYPE;
1035: v_data_length ALL_TAB_COLUMNS.data_length%TYPE;
1036: v_data_precision ALL_TAB_COLUMNS.data_precision%TYPE;
1037: v_data_scale ALL_TAB_COLUMNS.data_scale%TYPE;
1038:
1039: v_dim_dc_data_length ALL_TAB_COLUMNS.data_length%TYPE;

Line 1036: v_data_precision ALL_TAB_COLUMNS.data_precision%TYPE;

1032: v_dim_label VARCHAR2(30);
1033:
1034: v_data_type ALL_TAB_COLUMNS.data_type%TYPE;
1035: v_data_length ALL_TAB_COLUMNS.data_length%TYPE;
1036: v_data_precision ALL_TAB_COLUMNS.data_precision%TYPE;
1037: v_data_scale ALL_TAB_COLUMNS.data_scale%TYPE;
1038:
1039: v_dim_dc_data_length ALL_TAB_COLUMNS.data_length%TYPE;
1040: v_dim_dc_data_type ALL_TAB_COLUMNS.data_type%TYPE;

Line 1037: v_data_scale ALL_TAB_COLUMNS.data_scale%TYPE;

1033:
1034: v_data_type ALL_TAB_COLUMNS.data_type%TYPE;
1035: v_data_length ALL_TAB_COLUMNS.data_length%TYPE;
1036: v_data_precision ALL_TAB_COLUMNS.data_precision%TYPE;
1037: v_data_scale ALL_TAB_COLUMNS.data_scale%TYPE;
1038:
1039: v_dim_dc_data_length ALL_TAB_COLUMNS.data_length%TYPE;
1040: v_dim_dc_data_type ALL_TAB_COLUMNS.data_type%TYPE;
1041: v_mbr_b_owner ALL_TABLES.owner%TYPE;

Line 1039: v_dim_dc_data_length ALL_TAB_COLUMNS.data_length%TYPE;

1035: v_data_length ALL_TAB_COLUMNS.data_length%TYPE;
1036: v_data_precision ALL_TAB_COLUMNS.data_precision%TYPE;
1037: v_data_scale ALL_TAB_COLUMNS.data_scale%TYPE;
1038:
1039: v_dim_dc_data_length ALL_TAB_COLUMNS.data_length%TYPE;
1040: v_dim_dc_data_type ALL_TAB_COLUMNS.data_type%TYPE;
1041: v_mbr_b_owner ALL_TABLES.owner%TYPE;
1042: v_mbr_b_table_name ALL_TABLES.table_name%TYPE;
1043: BEGIN

Line 1040: v_dim_dc_data_type ALL_TAB_COLUMNS.data_type%TYPE;

1036: v_data_precision ALL_TAB_COLUMNS.data_precision%TYPE;
1037: v_data_scale ALL_TAB_COLUMNS.data_scale%TYPE;
1038:
1039: v_dim_dc_data_length ALL_TAB_COLUMNS.data_length%TYPE;
1040: v_dim_dc_data_type ALL_TAB_COLUMNS.data_type%TYPE;
1041: v_mbr_b_owner ALL_TABLES.owner%TYPE;
1042: v_mbr_b_table_name ALL_TABLES.table_name%TYPE;
1043: BEGIN
1044: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1192: FROM all_tab_columns

1188:
1189: BEGIN
1190: SELECT data_type, data_length, data_precision, data_scale
1191: INTO v_data_type, v_data_length, v_data_precision, v_data_scale
1192: FROM all_tab_columns
1193: WHERE owner = v_int_owner
1194: AND table_name = v_int_db_tab_name
1195: AND column_name = col.interface_column_name;
1196: EXCEPTION

Line 1293: FROM all_tab_columns

1289: -- we only need to get the data_type and data length, because all
1290: -- display_code columns are varchar2 by definition
1291: SELECT data_type,data_length
1292: INTO v_dim_dc_data_type,v_dim_dc_data_length
1293: FROM all_tab_columns
1294: WHERE owner = v_mbr_b_owner
1295: AND table_name = v_mbr_b_table_name
1296: AND column_name = v_dim_mbr_dc_col;
1297:

Line 1687: FROM fem_tab_columns_b t, fem_column_requiremnt_b r, all_tab_columns a,

1683: a.data_length||', '||a.data_precision||', '||a.data_scale col_data_length,
1684: r.data_length||', '||r.data_precision||', '||r.data_scale req_data_length,
1685: a.data_type col_data_type, r.data_type req_data_type,
1686: a.nullable col_nullable, tp.nullable_flag req_nullable
1687: FROM fem_tab_columns_b t, fem_column_requiremnt_b r, all_tab_columns a,
1688: fem_table_prop_col_req tp, fem_table_class_prop tc
1689: WHERE t.table_name = p_syn_name
1690: AND t.column_name = r.column_name
1691: AND a.table_name = p_db_name

Line 2842: p_db_tab_name => p_view_name,--p_db_tab_name = view_name because it will be mapped to all_tab_columns

2838: Validate_Column_Req (
2839: p_tab_name => p_view_name,
2840: p_tab_class_cd => p_tab_class_cd,
2841: p_tab_owner => l_apps,-- pass owner as 'APPS' because we will check for view columns and pass
2842: p_db_tab_name => p_view_name,--p_db_tab_name = view_name because it will be mapped to all_tab_columns
2843: x_passed_validation => v_passed_valid_out);
2844:
2845: IF v_passed_valid_out = c_false THEN
2846: v_passed := c_false;