APPS.FII_FINANCIAL_DIMENSION_PKG dependencies on ENI_VALUESET_CATEGORY

Line 14: and flex_value_set_id = ENI_VALUESET_CATEGORY.Get_Flex_Value_Set_Id('401', 'MCAT', ENI_DENORM_HRCHY.GET_CATEGORY_SET_ID);

10: from fnd_id_flex_segments
11: where application_id = 101
12: and id_flex_code = 'GL#'
13: and id_flex_num = p_coa_id
14: and flex_value_set_id = ENI_VALUESET_CATEGORY.Get_Flex_Value_Set_Id('401', 'MCAT', ENI_DENORM_HRCHY.GET_CATEGORY_SET_ID);
15: l_num number;
16: l_r varchar2(1);
17: begin
18: open numSeg;

Line 40: and flex_value_set_id = ENI_VALUESET_CATEGORY.Get_Flex_Value_Set_Id('401', 'MCAT', ENI_DENORM_HRCHY.GET_CATEGORY_SET_ID)

36: from fnd_id_flex_segments
37: where application_id = 101
38: and id_flex_code = 'GL#'
39: and id_flex_num = p_coa_id
40: and flex_value_set_id = ENI_VALUESET_CATEGORY.Get_Flex_Value_Set_Id('401', 'MCAT', ENI_DENORM_HRCHY.GET_CATEGORY_SET_ID)
41: and ROWNUM = 1;
42: exception
43: when NO_DATA_FOUND then
44: l_num := 0;

Line 105: ENI_VALUESET_CATEGORY.GET_FLEX_VALUE_SET_ID(401, 'MCAT',

101: FROM
102: (
103: SELECT /*+ NO_MERGE */
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

Line 164: and flex_value_set_id = ENI_VALUESET_CATEGORY.Get_Flex_Value_Set_Id('401', 'MCAT', ENI_DENORM_HRCHY.GET_CATEGORY_SET_ID);

160: from fnd_id_flex_segments
161: where application_id = 101
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,

Line 278: and flex_value_set_id = ENI_VALUESET_CATEGORY.Get_Flex_Value_Set_Id('401', 'MCAT', ENI_DENORM_HRCHY.GET_CATEGORY_SET_ID);

274: from fnd_id_flex_segments
275: where application_id = 101
276: and id_flex_code = 'GL#'
277: and id_flex_num = p_chart_of_accounts_id
278: and flex_value_set_id = ENI_VALUESET_CATEGORY.Get_Flex_Value_Set_Id('401', 'MCAT', ENI_DENORM_HRCHY.GET_CATEGORY_SET_ID);
279:
280: l_x varchar2(1);
281: l_p varchar2(1);
282: l_col_name varchar2(30);