APPS.OKL_RULE_EXTRACT_PVT dependencies on FND_FLEX_VALUE_SETS

Line 180: from FND_FLEX_VALUE_SETS fvs

176: , fvs.maximum_size
177: , fvs.validation_type
178: , fvs.flex_value_set_id
179: , fvs.flex_value_set_name
180: from FND_FLEX_VALUE_SETS fvs
181: Where fvs.FLEX_VALUE_SET_ID=p_flex_value_set_id;
182: flex_value_set_rec flex_value_set_cur%rowtype;
183: --Cursor for getting the query for table validated value sets
184: Cursor flex_query_t_cur(p_flex_value_set_id NUMBER) is

Line 379: l_value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE Default Null;

375: l_context_r fnd_dflex.context_r;
376: l_segments_r fnd_dflex.segments_dr;
377: l_rule_segment_tbl rule_segment_tbl_type;
378:
379: l_value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE Default Null;
380: l_additional_columns FND_FLEX_VALIDATION_TABLES.ADDITIONAL_QUICKPICK_COLUMNS%TYPE Default Null;
381:
382: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
383: l_api_name CONSTANT VARCHAR2(30) := 'GET_RULE_DEF';