[Home] [Help]
1139: -- and used it in each call to Tech_Message.
1140: -- 05-12-04 G Hall Bug# 3603260: Unhardcoded for INTERCOMPANY_
1141: -- DISPLAY_CODE; added FEM_DISPLAY_CODE_COL_MAP into
1142: -- BULK COLLECT join to fetch display code column names.
1143: -- 05-24-04 G Hall Changed join to fem_xdim_dimensions to outer join,
1144: -- since some processing key columns are not dimenions
1145: -- (e.g. CURRENCY_TYPE_CODE).
1146: -- 05-25-04 G Hall Added x_completion_code parameter; modified error-
1147: -- handling logic for being called by Process_Data_Slice.
1184: xd.attribute_table_name
1185: BULK COLLECT INTO pv_proc_keys
1186: FROM fem_tab_column_prop tcp,
1187: fem_tab_columns_b tc,
1188: fem_xdim_dimensions xd,
1189: fem_int_column_map cm
1190: WHERE tcp.table_name = 'FEM_BALANCES'
1191: AND tcp.column_property_code = 'PROCESSING_KEY'
1192: AND tc.table_name = 'FEM_BALANCES'
5086: -- Value Set Combination
5087: BEGIN
5088: SELECT DISTINCT 'X'
5089: INTO v_dummy_flag
5090: FROM FEM_XDIM_DIMENSIONS xdim, FEM_DIMENSIONS_B dim
5091: WHERE xdim.VALUE_SET_REQUIRED_FLAG = 'Y'
5092: AND xdim.DIMENSION_ID = dim.DIMENSION_ID
5093: AND dim.DIMENSION_VARCHAR_LABEL
5094: NOT IN ('COMPANY', 'COST_CENTER') -- Bug fix 4158130