APPS.FII_FINANCIAL_DIMENSION_PKG dependencies on FII_DIM_MAPPING_RULES

Line 144: select chart_of_accounts_id from fii_dim_mapping_rules

140: x_message_count OUT nocopy NUMBER,
141: x_error_message OUT nocopy VARCHAR2) as
142:
143: cursor dim is
144: select chart_of_accounts_id from fii_dim_mapping_rules
145: where dimension_short_name = 'ENI_ITEM_VBH_CAT';
146: n number;
147: vsid number;
148: col_name varchar2(30);

Line 166: update fii_dim_mapping_rules

162: and id_flex_code = 'GL#'
163: and id_flex_num = r.chart_of_accounts_id
164: and flex_value_set_id = ENI_VALUESET_CATEGORY.Get_Flex_Value_Set_Id('401', 'MCAT', ENI_DENORM_HRCHY.GET_CATEGORY_SET_ID);
165:
166: update fii_dim_mapping_rules
167: set MAPPING_TYPE_CODE = 'S',
168: application_column_name1 = col_name,
169: flex_value_set_id1 = vsid
170: where DIMENSION_SHORT_NAME = 'ENI_ITEM_VBH_CAT'

Line 175: update fii_dim_mapping_rules

171: and CHART_OF_ACCOUNTS_ID = r.chart_of_accounts_id;
172:
173: exception
174: when TOO_MANY_ROWS then
175: update fii_dim_mapping_rules
176: set MAPPING_TYPE_CODE = 'R',
177: application_column_name1 = null,
178: flex_value_set_id1 = null
179: where DIMENSION_SHORT_NAME = 'ENI_ITEM_VBH_CAT'

Line 183: update fii_dim_mapping_rules

179: where DIMENSION_SHORT_NAME = 'ENI_ITEM_VBH_CAT'
180: and CHART_OF_ACCOUNTS_ID = r.chart_of_accounts_id;
181:
182: when NO_DATA_FOUND then
183: update fii_dim_mapping_rules
184: set MAPPING_TYPE_CODE = 'R',
185: application_column_name1 = null,
186: flex_value_set_id1 = null
187: where DIMENSION_SHORT_NAME = 'ENI_ITEM_VBH_CAT'

Line 240: fii_dim_mapping_rules fdmr

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:
244: rule_rec fii_dim_mapping_rules%rowtype;

Line 244: rule_rec fii_dim_mapping_rules%rowtype;

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:
244: rule_rec fii_dim_mapping_rules%rowtype;
245: l_segment_attribute_type varchar2(30);
246:
247: cursor segment(p_chart_of_accounts_id number,
248: p_segment_attribute_type varchar2) is

Line 299: delete from fii_dim_mapping_rules

295: fii_util.debug_line('FII_FINANCIAL_DIMENSION_PKG.manage_dimension_map_rules(+)');
296: end if;
297:
298: if p_event = 'D' then
299: delete from fii_dim_mapping_rules
300: where chart_of_accounts_id = p_chart_of_accounts_id and
301: not exists(select 'x' from
302: fii_slg_assignments
303: where chart_of_accounts_id = p_chart_of_accounts_id);

Line 367: insert into fii_dim_mapping_rules(

363: end if;
364: end if;
365: end if;
366:
367: insert into fii_dim_mapping_rules(
368: DIMENSION_SHORT_NAME,
369: CHART_OF_ACCOUNTS_ID,
370: STATUS_CODE,
371: CREATION_DATE,