APPS.HR_FLEXFIELD_INFO dependencies on FND_FLEX_VALUE_SETS

Line 157: l_flex_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;

153: l_length_rep_string NUMBER;
154: l_replace_string VARCHAR2(2000);
155: l_segment_or_vs VARCHAR2(2000);
156: l_placeholder_identifier VARCHAR2(10) := ':$FLEX$.';
157: l_flex_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;
158: l_token_value VARCHAR2(2000) := '';
159: l_cr_check NUMBER;
160: l_cr_char NUMBER;
161: l_proc varchar2(72);

Line 251: from fnd_flex_value_sets

247:
248: --
249: if (p_segment_info.value_set(i) > 0) then
250: select flex_value_set_name into l_flex_value_set_name
251: from fnd_flex_value_sets
252: where flex_value_set_id = p_segment_info.value_set(i);
253: if (l_flex_value_set_name = l_segment_or_vs) then
254: l_token_value := g_app_col_placeholder||p_segment_info.
255: application_column_name(i)||' ';

Line 602: cursor c_parent_set(p_value_set_id in fnd_flex_value_sets.flex_value_set_id%TYPE)

598: (p_segment_info IN OUT NOCOPY hr_segments_info,
599: p_segment_number IN NUMBER)
600: RETURN VARCHAR2 is
601:
602: cursor c_parent_set(p_value_set_id in fnd_flex_value_sets.flex_value_set_id%TYPE)
603: is
604: select parent_flex_value_set_id
605: from fnd_flex_value_sets
606: where flex_value_set_id = p_value_set_id;

Line 605: from fnd_flex_value_sets

601:
602: cursor c_parent_set(p_value_set_id in fnd_flex_value_sets.flex_value_set_id%TYPE)
603: is
604: select parent_flex_value_set_id
605: from fnd_flex_value_sets
606: where flex_value_set_id = p_value_set_id;
607:
608: l_application_column_name fnd_columns.column_name%TYPE;
609: l_dep_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;

Line 609: l_dep_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;

605: from fnd_flex_value_sets
606: where flex_value_set_id = p_value_set_id;
607:
608: l_application_column_name fnd_columns.column_name%TYPE;
609: l_dep_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
610: l_indep_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
611: l_count number := 1;
612:
613: BEGIN

Line 610: l_indep_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;

606: where flex_value_set_id = p_value_set_id;
607:
608: l_application_column_name fnd_columns.column_name%TYPE;
609: l_dep_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
610: l_indep_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
611: l_count number := 1;
612:
613: BEGIN
614:

Line 678: l_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;

674: -- Declare local variables
675: --
676: l_valueset_r fnd_vset.valueset_r;
677: l_valueset_dr fnd_vset.valueset_dr;
678: l_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
679: l_proc varchar2(72);
680: l_order_by_start NUMBER;
681: l_from_start NUMBER;
682: l_additional_and_clause VARCHAR2(2000);