APPS.FEM_DIMENSION_UTIL_PKG dependencies on FEM_TAB_COLUMNS_B

Line 1970: FROM fem_tab_columns_b

1966: IF (p_load_status IS NULL)
1967: THEN
1968: SELECT column_name
1969: INTO v_ledger_col
1970: FROM fem_tab_columns_b
1971: WHERE table_name = p_table_name
1972: AND dimension_id =
1973: (SELECT dimension_id
1974: FROM fem_dimensions_b

Line 1979: FROM fem_tab_columns_b

1975: WHERE dimension_varchar_label = 'LEDGER');
1976:
1977: SELECT column_name
1978: INTO v_cal_per_col
1979: FROM fem_tab_columns_b
1980: WHERE table_name = p_table_name
1981: AND dimension_id =
1982: (SELECT dimension_id
1983: FROM fem_dimensions_b

Line 1988: FROM fem_tab_columns_b

1984: WHERE dimension_varchar_label = 'CAL_PERIOD');
1985:
1986: SELECT column_name
1987: INTO v_dataset_col
1988: FROM fem_tab_columns_b
1989: WHERE table_name = p_table_name
1990: AND dimension_id =
1991: (SELECT dimension_id
1992: FROM fem_dimensions_b

Line 1997: FROM fem_tab_columns_b

1993: WHERE dimension_varchar_label = 'DATASET');
1994:
1995: SELECT column_name
1996: INTO v_source_col
1997: FROM fem_tab_columns_b
1998: WHERE table_name = p_table_name
1999: AND dimension_id =
2000: (SELECT dimension_id
2001: FROM fem_dimensions_b

Line 9650: FROM fem_tab_columns_b

9646: -- Determine the dimension associated with the column
9647: BEGIN
9648: SELECT dimension_id
9649: INTO v_dim_id
9650: FROM fem_tab_columns_b
9651: WHERE table_name = Upper(p_table_name)
9652: AND column_name = Upper(p_column_name);
9653:
9654: IF v_dim_id IS NULL THEN

Line 9669: p_msg_text => 'Column is not registered in FEM_TAB_COLUMNS_B');

9665: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9666: FEM_ENGINES_PKG.TECH_MESSAGE(
9667: p_severity => FND_LOG.level_statement,
9668: p_module => C_MODULE,
9669: p_msg_text => 'Column is not registered in FEM_TAB_COLUMNS_B');
9670: END IF;
9671: RAISE e_unexp;
9672: END;
9673: