APPS.FII_FINANCIAL_DIMENSION_PKG dependencies on FII_FINANCIAL_DIMENSIONS

Line 77: update FII_FINANCIAL_DIMENSIONS

73: if g_debug_flag = 'Y' then
74: fii_util.debug_line('FII_FINANCIAL_DIMENSION_PKG.update_demension(+)');
75: end if;
76:
77: update FII_FINANCIAL_DIMENSIONS
78: set system_enabled_flag = p_system_enabled_flag,
79: dbi_enabled_flag = p_dbi_enabled_flag,
80: master_value_set_id = p_master_value_set_id,
81: dbi_hier_top_node = p_dbi_hier_top_node,

Line 92: from fii_financial_dimensions_v );

88: delete from fii_dim_norm_hierarchy
89: where child_flex_value_set_id <> parent_flex_value_set_id
90: and parent_flex_value_set_id not in
91: ( select master_value_set_id
92: from fii_financial_dimensions_v );
93: */
94: DELETE /*+ index_ffs(fii_dim_norm_hierarchy) */
95: FROM fii_dim_norm_hierarchy
96: WHERE child_flex_value_set_id <> parent_flex_value_set_id

Line 108: FROM fii_financial_dimensions frd

104: DECODE(frd.dimension_short_name, 'ENI_ITEM_VBH_CAT',
105: ENI_VALUESET_CATEGORY.GET_FLEX_VALUE_SET_ID(401, 'MCAT',
106: ENI_DENORM_HRCHY.GET_CATEGORY_SET_ID),
107: frd.master_value_set_id) MASTER_VALUE_SET_ID
108: FROM fii_financial_dimensions frd
109: WHERE dimension_short_name is not null
110: )
111: WHERE MASTER_VALUE_SET_ID = parent_flex_value_set_id
112: AND MASTER_VALUE_SET_ID is not null

Line 239: from fii_financial_dimensions_v ffd,

235: null application_column_name2,
236: null flex_value_set_id2,
237: null application_column_name3,
238: null flex_value_set_id3
239: from fii_financial_dimensions_v ffd,
240: fii_dim_mapping_rules fdmr
241: where ffd.dimension_short_name = fdmr.dimension_short_name(+)
242: and fdmr.chart_of_accounts_id(+) = p_chart_of_accounts_id;
243: