DBA Data[Home] [Help]

APPS.HR_FLEXFIELD_INFO dependencies on HR_FLEXFIELD_INFO

Line 1: Package Body hr_flexfield_info as

1: Package Body hr_flexfield_info as
2: /* $Header: peffinfo.pkb 120.1 2005/09/23 17:03:39 svittal noship $ */
3: --
4: -- Constants.
5: --

Line 12: g_package varchar2(33) := ' hr_flexfield_info';

8: ';
9: --
10: -- Package Variables
11: --
12: g_package varchar2(33) := ' hr_flexfield_info';
13: g_psegment_count number := 0;
14: g_app_col_placeholder VARCHAR2(200) := '&'||hr_api.g_varchar2||'.';
15: g_debug boolean := hr_utility.debug_enabled;
16: --

Line 468: hr_utility.trace(' Exception in hr_flexfield_info.substitute_profiles ' || SQLERRM );

464:
465:
466: EXCEPTION
467: WHEN OTHERS THEN
468: hr_utility.trace(' Exception in hr_flexfield_info.substitute_profiles ' || SQLERRM );
469: raise;
470:
471: end substitute_profiles;
472: --

Line 555: hr_flexfield_info.get_contexts(p_appl_short_name,

551: hr_utility.set_location('Entering:'|| l_proc, 5);
552: END IF;
553:
554: --
555: hr_flexfield_info.get_contexts(p_appl_short_name,
556: p_flexfield_name,
557: l_contexts);
558: --
559:

Line 1458: hr_utility.trace(' Exception in hr_flexfield_info.build_sql_text ' || SQLERRM );

1454: and t.table_name = p_application_table_name
1455: and a.application_short_name = p_application_short_name;
1456: EXCEPTION
1457: WHEN NO_DATA_FOUND THEN
1458: hr_utility.trace(' Exception in hr_flexfield_info.build_sql_text ' || SQLERRM );
1459: hr_utility.trace(' Table Name ' || p_application_table_name );
1460: hr_utility.trace(' Column Name ' || l_application_column_name );
1461: --
1462:

Line 1730: p_sql_text := 'FAILURE (HR_FLEXFIELD_INFO.BUILD SQL TEXT):'||c_newline||

1726: -- There is a missing value - i.e. this procedure can not complete
1727: -- its task. Reset the SQL text with this information, and exit
1728: -- the loop. This is necessary because the loop will continue
1729: -- idenfinitely if this flag is not set.
1730: p_sql_text := 'FAILURE (HR_FLEXFIELD_INFO.BUILD SQL TEXT):'||c_newline||
1731: 'There was no supplied value for the column'||
1732: l_application_column_name;
1733: l_no_replace_value:='Y';
1734: end if;

Line 1974: hr_flexfield_info.get_ak_region_code

1970: l_segments.default_type(i) := l_segment_info.default_type;
1971: l_segments.default_value(i) := l_segment_info.default_value;
1972: l_segments.number_children(i) := 0;
1973: l_segments.ak_region_code(i) :=
1974: hr_flexfield_info.get_ak_region_code
1975: (p_flex_type => 'KEY'
1976: ,p_flexfield_name => p_id_flex_code
1977: ,p_context_code => to_char(l_structure.structure_number)
1978: ,p_segment_info => l_segments

Line 1997: hr_flexfield_info.get_validation_info

1993: IF g_debug THEN
1994: hr_utility.set_location(l_proc, 50);
1995: END IF;
1996:
1997: hr_flexfield_info.get_validation_info
1998: (p_segment_info => l_segments
1999: ,p_session_date => p_session_date
2000: ,p_context_code => null
2001: ,p_flexfield_name => p_id_flex_code

Line 2038: end hr_flexfield_info;

2034: substr(p_segment, 1, 20);
2035: end if;
2036: end;
2037: --
2038: end hr_flexfield_info;