DBA Data[Home] [Help]

APPS.HRDYNDBI dependencies on HR_ORG_INFORMATION_TYPES

Line 6412: l_legislation_code hr_org_information_types.legislation_code%type;

6408: (p_flexfield_name in varchar2
6409: ,p_context in varchar2)
6410: return varchar2 is
6411: --
6412: l_legislation_code hr_org_information_types.legislation_code%type;
6413: l_navigation_method hr_org_information_types.navigation_method%type;
6414: l_multi_occur_flag per_assignment_info_types.multiple_occurences_flag%type;
6415: --
6416: begin

Line 6413: l_navigation_method hr_org_information_types.navigation_method%type;

6409: ,p_context in varchar2)
6410: return varchar2 is
6411: --
6412: l_legislation_code hr_org_information_types.legislation_code%type;
6413: l_navigation_method hr_org_information_types.navigation_method%type;
6414: l_multi_occur_flag per_assignment_info_types.multiple_occurences_flag%type;
6415: --
6416: begin
6417: --

Line 6434: from hr_org_information_types

6430: select legislation_code,
6431: navigation_method
6432: into l_legislation_code,
6433: l_navigation_method
6434: from hr_org_information_types
6435: where org_information_type = p_context;
6436: --
6437: -- The database item generated can only return one row. So if the
6438: -- navigation method is not 'GS' then raise an error.

Line 6690: l_legislation_code hr_org_information_types.legislation_code%type;

6686: p_title in varchar2,
6687: p_context in varchar2
6688: ) is
6689: l_flexfield_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%type;
6690: l_legislation_code hr_org_information_types.legislation_code%type;
6691: l_context hr_org_information_types.org_information_type%type;
6692: l_navigation_method hr_org_information_types.navigation_method%type;
6693: l_multi_occur_flag per_assignment_info_types.multiple_occurences_flag%type;
6694: --

Line 6691: l_context hr_org_information_types.org_information_type%type;

6687: p_context in varchar2
6688: ) is
6689: l_flexfield_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%type;
6690: l_legislation_code hr_org_information_types.legislation_code%type;
6691: l_context hr_org_information_types.org_information_type%type;
6692: l_navigation_method hr_org_information_types.navigation_method%type;
6693: l_multi_occur_flag per_assignment_info_types.multiple_occurences_flag%type;
6694: --
6695: -- declare a cursor to determine the routes to a descriptive flexfield's

Line 6692: l_navigation_method hr_org_information_types.navigation_method%type;

6688: ) is
6689: l_flexfield_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%type;
6690: l_legislation_code hr_org_information_types.legislation_code%type;
6691: l_context hr_org_information_types.org_information_type%type;
6692: l_navigation_method hr_org_information_types.navigation_method%type;
6693: l_multi_occur_flag per_assignment_info_types.multiple_occurences_flag%type;
6694: --
6695: -- declare a cursor to determine the routes to a descriptive flexfield's
6696: -- tables and an entity name for each of these tables.

Line 6807: from hr_org_information_types

6803: select legislation_code,
6804: navigation_method
6805: into l_legislation_code,
6806: l_navigation_method
6807: from hr_org_information_types
6808: where org_information_type = p_context;
6809: --
6810: -- this check to see if the navigation_method is 'GS' is also
6811: -- performed in the concurrent program. It has been added here as