[Home] [Help]
1396: p_default_no_desc in out nocopy varchar2,
1397: p_people_group_structure in out nocopy varchar2,
1398: p_method_of_apl_gen in out nocopy varchar2) is
1399: --
1400: l_style fnd_descr_flex_contexts_vl.descriptive_flex_context_code%TYPE;
1401: --
1402: begin
1403:
1404: get_db_default_values (p_business_group_id => p_business_group_id
1484: -- cursor c3 modified - "application_id = 800" added to improve performance.
1485:
1486: cursor c3 is
1487: select descriptive_flex_context_name, descriptive_flex_context_code
1488: from fnd_descr_flex_contexts_vl
1489: where (descriptive_flex_context_code = p_legislation_code
1490: or (p_legislation_code = descriptive_flex_context_code
1491: and p_legislation_code in ('CA','US')
1492: and hr_general.chk_geocodes_installed = 'Y'))
1498: -- cursor c6 modified - "application_id = 800" added to improve performance.
1499:
1500: cursor c6 is
1501: select descriptive_flex_context_name,descriptive_flex_context_code
1502: from fnd_descr_flex_contexts_vl
1503: where substr(descriptive_flex_context_code,1,2)= p_legislation_code
1504: and descriptive_flexfield_name = 'Address Structure'
1505: and application_id = 800 -- Bug Fix 3648715
1506: and enabled_flag = 'Y';
2627: end get_territory_short_name ;
2628: --
2629: function get_style_name (p_style in varchar2)
2630: return varchar2 is
2631: l_return_value fnd_descr_flex_contexts_vl.descriptive_flex_context_name%type := null;
2632: --
2633: cursor get_style_name is
2634: select descriptive_flex_context_name
2635: from fnd_descr_flex_contexts_vl
2631: l_return_value fnd_descr_flex_contexts_vl.descriptive_flex_context_name%type := null;
2632: --
2633: cursor get_style_name is
2634: select descriptive_flex_context_name
2635: from fnd_descr_flex_contexts_vl
2636: where descriptive_flex_context_code = p_style;
2637: --
2638: begin
2639: if (p_style is not null) then