APPS.FEM_ADMIN_UTIL_PKG dependencies on FEM_TAB_COLUMN_PROP

Line 380: v_col_prop_cd FEM_TAB_COLUMN_PROP.column_property_code%TYPE;

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;
383: v_count NUMBER;
384: v_vsr_count NUMBER;

Line 443: ||' FROM fem_tab_column_prop'

439: ||' AND enabled_flag = ''Y'')';
440: ELSE
441: v_sql := v_sql||'AND column_name NOT IN '
442: ||'(SELECT column_name'
443: ||' FROM fem_tab_column_prop'
444: ||' WHERE table_name = :2'
445: ||' AND column_property_code = '''||v_col_prop_cd||''')';
446: END IF; -- p_prop_type
447:

Line 488: v_sql := v_sql||' FROM fem_tab_column_prop'

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'
489: ||' WHERE table_name = :1'
490: ||' AND column_property_code = '''||v_col_prop_cd||'''';
491: END IF; -- p_prop_type
492:

Line 531: ||' FROM fem_tab_column_prop'

527: ||' WHERE table_property_code = :2) ';
528: IF p_prop_type <> 'TABLE_COLUMN' THEN
529: v_sql := v_sql||'AND t.column_name IN '
530: ||'(SELECT column_name'
531: ||' FROM fem_tab_column_prop'
532: ||' WHERE table_name = '''||p_tab_name||''''
533: ||' AND column_property_code = '''||v_col_prop_cd||''')';
534: END IF;
535: IF p_col_req_type = 'FIXED_AND_ONE_NUMBER' THEN

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 1021: v_col_prop FEM_TAB_COLUMN_PROP.column_property_code%TYPE;

1017: v_return_status VARCHAR2(1);
1018: v_int_tab_name ALL_TABLES.table_name%TYPE;
1019: v_int_db_tab_name ALL_TABLES.table_name%TYPE;
1020: v_int_owner ALL_TABLES.owner%TYPE;
1021: v_col_prop FEM_TAB_COLUMN_PROP.column_property_code%TYPE;
1022: v_matched VARCHAR2(1);
1023: v_msg_data VARCHAR2(2000);
1024: v_col_list VARCHAR2(4000);
1025:

Line 1355: FROM fem_tab_column_prop

1351: 'CALP_DIM_GRP_DISPLAY_CODE',
1352: 'CAL_PERIOD_END_DATE')
1353: AND c.column_name NOT IN
1354: (SELECT column_name
1355: FROM fem_tab_column_prop
1356: WHERE table_name = p_tab_name
1357: AND column_property_code = v_col_prop
1358: AND column_name NOT IN ('CAL_PERIOD_ID',
1359: 'CREATED_BY_REQUEST_ID',

Line 1372: FROM fem_tab_column_prop

1368: -- Then see if any columns are in the proc key but not in the index
1369: IF v_matched = c_true THEN
1370: SELECT count(*)
1371: INTO v_count
1372: FROM fem_tab_column_prop
1373: WHERE table_name = p_tab_name
1374: AND column_property_code = v_col_prop
1375: AND column_name NOT IN ('CAL_PERIOD_ID',
1376: 'CREATED_BY_REQUEST_ID',

Line 1403: FROM fem_tab_column_prop

1399: -- matching unique index.
1400: IF v_matched = c_true THEN
1401: SELECT count(*)
1402: INTO v_count
1403: FROM fem_tab_column_prop
1404: WHERE table_name = p_tab_name
1405: AND column_property_code = v_col_prop
1406: AND column_name = 'CAL_PERIOD_ID';
1407:

Line 1824: (as stored in the FEM_TAB_COLUMN_PROP metadata table)

1820: ***************************************************************************
1821: ***************************************************************************
1822:
1823: This procedure validates that the set of processing key columns
1824: (as stored in the FEM_TAB_COLUMN_PROP metadata table)
1825: match the set of unique index columns designated as the processing key index.
1826:
1827: **************************************************************************/
1828:

Line 1876: FROM fem_tab_column_prop

1872:
1873: IF v_idx_name IS NULL AND v_idx_owner IS NULL THEN
1874: SELECT count(*)
1875: INTO v_count
1876: FROM fem_tab_column_prop
1877: WHERE table_name = p_tab_name
1878: AND column_property_code = 'PROCESSING_KEY';
1879:
1880: -- Only error if no index is specified but proc key metadata is populated

Line 1918: FROM fem_tab_column_prop

1914: AND table_owner = p_tab_owner
1915: AND table_name = p_db_tab_name
1916: AND column_name NOT IN
1917: (SELECT column_name
1918: FROM fem_tab_column_prop
1919: WHERE table_name = p_tab_name
1920: AND column_property_code = 'PROCESSING_KEY');
1921:
1922: IF v_count = 0 THEN

Line 1929: FROM fem_tab_column_prop

1925:
1926: IF v_matched = c_true THEN
1927: SELECT count(*)
1928: INTO v_count
1929: FROM fem_tab_column_prop
1930: WHERE table_name = p_tab_name
1931: AND column_property_code = 'PROCESSING_KEY'
1932: AND column_name NOT IN
1933: (SELECT column_name