APPS.HRDYNDBI dependencies on HR_ORG_INFORMATION_TYPES

Line 6422: l_legislation_code hr_org_information_types.legislation_code%type;

6418: (p_flexfield_name in varchar2
6419: ,p_context in varchar2)
6420: return varchar2 is
6421: --
6422: l_legislation_code hr_org_information_types.legislation_code%type;
6423: l_navigation_method hr_org_information_types.navigation_method%type;
6424: l_multi_occur_flag per_assignment_info_types.multiple_occurences_flag%type;
6425: --
6426: begin

Line 6423: l_navigation_method hr_org_information_types.navigation_method%type;

6419: ,p_context in varchar2)
6420: return varchar2 is
6421: --
6422: l_legislation_code hr_org_information_types.legislation_code%type;
6423: l_navigation_method hr_org_information_types.navigation_method%type;
6424: l_multi_occur_flag per_assignment_info_types.multiple_occurences_flag%type;
6425: --
6426: begin
6427: --

Line 6444: from hr_org_information_types

6440: select legislation_code,
6441: navigation_method
6442: into l_legislation_code,
6443: l_navigation_method
6444: from hr_org_information_types
6445: where org_information_type = p_context;
6446: --
6447: -- The database item generated can only return one row. So if the
6448: -- navigation method is not 'GS' then raise an error.

Line 6700: l_legislation_code hr_org_information_types.legislation_code%type;

6696: p_title in varchar2,
6697: p_context in varchar2
6698: ) is
6699: l_flexfield_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%type;
6700: l_legislation_code hr_org_information_types.legislation_code%type;
6701: l_context hr_org_information_types.org_information_type%type;
6702: l_navigation_method hr_org_information_types.navigation_method%type;
6703: l_multi_occur_flag per_assignment_info_types.multiple_occurences_flag%type;
6704: --

Line 6701: l_context hr_org_information_types.org_information_type%type;

6697: p_context in varchar2
6698: ) is
6699: l_flexfield_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%type;
6700: l_legislation_code hr_org_information_types.legislation_code%type;
6701: l_context hr_org_information_types.org_information_type%type;
6702: l_navigation_method hr_org_information_types.navigation_method%type;
6703: l_multi_occur_flag per_assignment_info_types.multiple_occurences_flag%type;
6704: --
6705: -- declare a cursor to determine the routes to a descriptive flexfield's

Line 6702: l_navigation_method hr_org_information_types.navigation_method%type;

6698: ) is
6699: l_flexfield_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%type;
6700: l_legislation_code hr_org_information_types.legislation_code%type;
6701: l_context hr_org_information_types.org_information_type%type;
6702: l_navigation_method hr_org_information_types.navigation_method%type;
6703: l_multi_occur_flag per_assignment_info_types.multiple_occurences_flag%type;
6704: --
6705: -- declare a cursor to determine the routes to a descriptive flexfield's
6706: -- tables and an entity name for each of these tables.

Line 6817: from hr_org_information_types

6813: select legislation_code,
6814: navigation_method
6815: into l_legislation_code,
6816: l_navigation_method
6817: from hr_org_information_types
6818: where org_information_type = p_context;
6819: --
6820: -- this check to see if the navigation_method is 'GS' is also
6821: -- performed in the concurrent program. It has been added here as