DBA Data[Home] [Help]

APPS.PER_SG_PERWSEPI dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 10: (p_flexfield_segment in fnd_descr_flex_column_usages.application_column_name%type,

6: -- Passes out the Required Flag for the Flexfield segment so the form knows
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';

Line 12: p_required_flag out nocopy fnd_descr_flex_column_usages.required_flag%type)

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';
16:

Line 14: l_flexfield_name fnd_descr_flex_column_usages.descriptive_flexfield_name%type := 'Person Developer DF';

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';
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;

Line 15: l_flexfield_context fnd_descr_flex_column_usages.descriptive_flex_context_code%type := 'SG';

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';
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:

Line 18: l_required_flag fnd_descr_flex_column_usages.required_flag%type;

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,
22: c_flexfield_context fnd_descr_flex_column_usages.descriptive_flex_context_code%type,

Line 21: (c_flexfield_name fnd_descr_flex_column_usages.descriptive_flexfield_name%type,

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,
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

Line 22: c_flexfield_context fnd_descr_flex_column_usages.descriptive_flex_context_code%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,
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,

Line 23: c_flexfield_segment fnd_descr_flex_column_usages.application_column_name%type) is

19:
20: cursor segment_info
21: (c_flexfield_name fnd_descr_flex_column_usages.descriptive_flexfield_name%type,
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

Line 27: fnd_descr_flex_column_usages fcu

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
31: and fcu.application_column_name = fct.application_column_name