APPS.HR_HIERARCHY_ELEMENT_API dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 35: per_org_structure_elements.org_structure_element_id%TYPE;

31: --
32: -- Declare cursors and local variables
33: --
34: l_org_structure_element_id
35: per_org_structure_elements.org_structure_element_id%TYPE;
36: l_object_version_number
37: per_org_structure_elements.object_version_number%TYPE;
38: l_exists_in_hierarchy varchar2(1);
39: l_view_all_orgs varchar2(3);

Line 37: per_org_structure_elements.object_version_number%TYPE;

33: --
34: l_org_structure_element_id
35: per_org_structure_elements.org_structure_element_id%TYPE;
36: l_object_version_number
37: per_org_structure_elements.object_version_number%TYPE;
38: l_exists_in_hierarchy varchar2(1);
39: l_view_all_orgs varchar2(3);
40: l_effective_date date;
41: l_date_from date;

Line 48: from per_org_structure_elements

44: l_proc varchar2(72) := g_package||'create_hierarchy_element';
45: --
46: cursor get_old_element is select org_structure_element_id,
47: object_version_number
48: from per_org_structure_elements
49: where organization_id_child = p_Organization_Id_Child
50: and org_structure_version_id = p_org_structure_version_id;
51:
52: --Bug fix 2879820 starts here

Line 115: per_org_structure_elements_pkg.check_org_active

111: close c_date_from;
112: end if;
113: --Bug fix 2879820 ends here
114: --
115: per_org_structure_elements_pkg.check_org_active
116: (p_org_id_parent => p_Organization_Id_Parent
117: ,p_date_from => l_date_from --Bug 2879820
118: ,p_end_of_time => hr_api.g_eot --Bug 2879820
119: ,p_warning_raised => l_warning_raised

Line 179: per_org_structure_elements_pkg.maintain_org_lists(p_Business_Group_Id

175: close c_org_flag;
176: end if;
177:
178: if l_view_all_orgs = 'N' then
179: per_org_structure_elements_pkg.maintain_org_lists(p_Business_Group_Id
180: ,l_security_profile_id
181: ,p_Organization_Id_Parent
182: );
183: end if;

Line 330: l_object_version_number per_org_structure_elements

326: -- Declare cursors and local variables
327: --
328: l_effective_date date;
329: l_proc varchar2(72) := g_package||'update_hierarchy_element';
330: l_object_version_number per_org_structure_elements
331: .object_version_number%TYPE;
332: l_ovn per_org_structure_elements .object_version_number%TYPE := p_object_version_number;
333: begin
334: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 332: l_ovn per_org_structure_elements .object_version_number%TYPE := p_object_version_number;

328: l_effective_date date;
329: l_proc varchar2(72) := g_package||'update_hierarchy_element';
330: l_object_version_number per_org_structure_elements
331: .object_version_number%TYPE;
332: l_ovn per_org_structure_elements .object_version_number%TYPE := p_object_version_number;
333: begin
334: hr_utility.set_location('Entering:'|| l_proc, 10);
335: --
336: l_object_version_number := p_object_version_number;