[Home] [Help]
433: ||' WHERE table_property_code = :1 ';
434: IF p_prop_type = 'TABLE_COLUMN' THEN
435: v_sql := v_sql||'AND column_name NOT IN '
436: ||'(SELECT column_name'
437: ||' FROM fem_tab_columns_b'
438: ||' WHERE table_name = :2'
439: ||' AND enabled_flag = ''Y'')';
440: ELSE
441: v_sql := v_sql||'AND column_name NOT IN '
480:
481: ELSIF p_col_req_type = 'ONE_ANY' THEN
482: v_sql := 'SELECT count(*)';
483: IF p_prop_type = 'TABLE_COLUMN' THEN
484: v_sql := v_sql||' FROM fem_tab_columns_b'
485: ||' WHERE table_name = :1'
486: ||' AND enabled_flag = ''Y''';
487: ELSE
488: v_sql := v_sql||' FROM fem_tab_column_prop'
516: IF v_passed_valid = c_true AND
517: p_col_req_type NOT IN ('FIXED_ANY','ONE_ANY') THEN
518:
519: v_sql := 'SELECT t.column_name, nvl(x.value_set_required_flag,''N'')'
520: ||' FROM fem_tab_columns_b t, fem_xdim_dimensions x'
521: ||' WHERE t.dimension_id = x.dimension_id(+)'
522: ||' AND t.table_name = :1'
523: ||' AND enabled_flag = ''Y'''
524: ||' AND t.column_name NOT IN '
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',
1340: -- have a direct mapping (CAL_PERIOD_ID) or no mapping at all
1341: -- (Undo WHO columns).
1342: SELECT count(*)
1343: INTO v_count
1344: FROM all_ind_columns i, fem_tab_columns_b c
1345: WHERE i.index_name = idx.index_name
1346: AND i.table_owner = v_int_owner
1347: AND i.table_name = v_int_db_tab_name
1348: AND c.table_name = p_tab_name
1378: 'CREATED_BY_OBJECT_ID',
1379: 'LAST_UPDATED_BY_OBJECT_ID')
1380: AND column_name NOT IN
1381: (SELECT c.column_name
1382: FROM all_ind_columns i, fem_tab_columns_b c
1383: WHERE i.index_name = idx.index_name
1384: AND i.table_owner = v_int_owner
1385: AND i.table_name = v_int_db_tab_name
1386: AND c.table_name = p_tab_name
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
1695: AND tp.table_property_code = tc.table_property_code
1696: AND tc.table_classification_code = p_tab_class_cd;
1697:
1698: v_passed_valid VARCHAR2(1);
1699: v_fem_data_type_name FEM_TAB_COLUMNS_B.fem_data_type_code%TYPE;
1700: BEGIN
1701:
1702: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1703: FEM_ENGINES_PKG.TECH_MESSAGE(
2026: 'fem.plsql.fem_admin_util_pkg.validate_ogl_dimcol';
2027:
2028: CURSOR c_dimcol (p_name VARCHAR2) IS
2029: SELECT column_name, dimension_id
2030: FROM fem_tab_columns_b
2031: WHERE table_name = p_name
2032: AND fem_data_type_code = 'DIMENSION'
2033: AND column_name IN ('COMPANY_COST_CENTER_ORG_ID'
2034: ,'NATURAL_ACCOUNT_ID'