APPS.PER_SG_PERWSEPI dependencies on FND_DESCR_FLEX_COL_USAGE_TL

Line 11: p_form_prompt out nocopy fnd_descr_flex_col_usage_tl.form_left_prompt%type,

7: -- whether or not to make the field Required or not.
8: ---------------------------------------------------------------------------
9: procedure get_segment_attributes
10: (p_flexfield_segment in fnd_descr_flex_column_usages.application_column_name%type,
11: p_form_prompt out nocopy fnd_descr_flex_col_usage_tl.form_left_prompt%type,
12: p_required_flag out nocopy fnd_descr_flex_column_usages.required_flag%type)
13: is
14: l_flexfield_name fnd_descr_flex_column_usages.descriptive_flexfield_name%type := 'Person Developer DF';
15: l_flexfield_context fnd_descr_flex_column_usages.descriptive_flex_context_code%type := 'SG';

Line 17: l_form_prompt fnd_descr_flex_col_usage_tl.form_left_prompt%type;

13: is
14: l_flexfield_name fnd_descr_flex_column_usages.descriptive_flexfield_name%type := 'Person Developer DF';
15: l_flexfield_context fnd_descr_flex_column_usages.descriptive_flex_context_code%type := 'SG';
16:
17: l_form_prompt fnd_descr_flex_col_usage_tl.form_left_prompt%type;
18: l_required_flag fnd_descr_flex_column_usages.required_flag%type;
19:
20: cursor segment_info
21: (c_flexfield_name fnd_descr_flex_column_usages.descriptive_flexfield_name%type,

Line 26: from fnd_descr_flex_col_usage_tl fct,

22: c_flexfield_context fnd_descr_flex_column_usages.descriptive_flex_context_code%type,
23: c_flexfield_segment fnd_descr_flex_column_usages.application_column_name%type) is
24: select fct.form_left_prompt,
25: fcu.required_flag
26: from fnd_descr_flex_col_usage_tl fct,
27: fnd_descr_flex_column_usages fcu
28: where fcu.application_id = fct.application_id
29: and fcu.descriptive_flexfield_name = fct.descriptive_flexfield_name
30: and fcu.descriptive_flex_context_code = fct.descriptive_flex_context_code