DBA Data[Home] [Help]

APPS.OKL_RULE_EXTRACT_PVT dependencies on FND_FLEX_VALIDATION_TABLES

Line 194: FROM fnd_flex_validation_tables fvt

190: fvt.enabled_column_name,
191: fvt.start_date_column_name,
192: fvt.end_date_column_name,
193: fvt.additional_quickpick_columns
194: FROM fnd_flex_validation_tables fvt
195: WHERE fvt.flex_value_set_id = p_flex_value_set_id;
196: flex_query_t_rec flex_query_t_cur%rowtype;
197: l_query_string varchar2(2000) default Null;
198: l_object_code varchar2(240) default Null;

Line 380: l_additional_columns FND_FLEX_VALIDATION_TABLES.ADDITIONAL_QUICKPICK_COLUMNS%TYPE Default Null;

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';
384: l_api_version CONSTANT NUMBER := 1.0;