APPS.PER_OSE_DEL dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 16: in per_org_structure_elements.org_structure_version_id%TYPE

12: -- |---------------------------< chk_org_in_hierarchy >----------------------------|
13: -- -------------------------------------------------------------------------------
14: Procedure chk_org_in_hierarchy
15: (p_org_structure_version_id
16: in per_org_structure_elements.org_structure_version_id%TYPE
17: ,p_organization_id
18: in per_org_structure_elements.organization_id_child%TYPE
19: ,p_exists_in_hierarchy in out nocopy VARCHAR2
20: ) is

Line 18: in per_org_structure_elements.organization_id_child%TYPE

14: Procedure chk_org_in_hierarchy
15: (p_org_structure_version_id
16: in per_org_structure_elements.org_structure_version_id%TYPE
17: ,p_organization_id
18: in per_org_structure_elements.organization_id_child%TYPE
19: ,p_exists_in_hierarchy in out nocopy VARCHAR2
20: ) is
21: --
22: --

Line 35: from per_org_structure_elements ose

31: select 'Y'
32: into p_exists_in_hierarchy
33: from sys.dual
34: where exists ( select null
35: from per_org_structure_elements ose
36: where ose.org_structure_version_id = p_org_structure_version_id
37: and ose.organization_id_child = p_organization_id);
38:
39: if p_exists_in_hierarchy <> 'Y' then

Line 47: from per_org_structure_elements es1

43: select 'Y'
44: into p_exists_in_hierarchy
45: from sys.dual
46: where exists ( select null
47: from per_org_structure_elements es1
48: where es1.org_structure_version_id = p_org_structure_version_id
49: and es1.organization_id_parent = p_organization_id
50: and p_organization_id not in (select organization_id_child
51: from per_org_structure_elements es

Line 51: from per_org_structure_elements es

47: from per_org_structure_elements es1
48: where es1.org_structure_version_id = p_org_structure_version_id
49: and es1.organization_id_parent = p_organization_id
50: and p_organization_id not in (select organization_id_child
51: from per_org_structure_elements es
52: where es.org_structure_version_id = p_org_structure_version_id));
53:
54: end if;
55: --

Line 114: -- Delete the per_org_structure_elements row.

110: hr_utility.set_location('Entering:'||l_proc, 5);
111: --
112: per_ose_shd.g_api_dml := true; -- Set the api dml status
113: --
114: -- Delete the per_org_structure_elements row.
115: --
116: delete from per_org_structure_elements
117: where org_structure_element_id = p_rec.org_structure_element_id;
118: --

Line 116: delete from per_org_structure_elements

112: per_ose_shd.g_api_dml := true; -- Set the api dml status
113: --
114: -- Delete the per_org_structure_elements row.
115: --
116: delete from per_org_structure_elements
117: where org_structure_element_id = p_rec.org_structure_element_id;
118: --
119: per_ose_shd.g_api_dml := false; -- Unset the api dml status
120: --

Line 253: (p_module_name => 'PER_ORG_STRUCTURE_ELEMENTS'

249: --
250: when hr_api.cannot_find_prog_unit then
251: --
252: hr_api.cannot_find_prog_unit_error
253: (p_module_name => 'PER_ORG_STRUCTURE_ELEMENTS'
254: ,p_hook_type => 'AD');
255: --
256: end;
257: --