1: Package Body hr_de_organization_links_api as
2: /* $Header: hrordapi.pkb 115.4 2002/12/16 10:38:03 hjonnala noship $ */
3: --
4: -- Package Variables
5: --
2: /* $Header: hrordapi.pkb 115.4 2002/12/16 10:38:03 hjonnala noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' hr_de_organization_links_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |-----------------------------< create_link >------------------------------|
10: -- ----------------------------------------------------------------------------
90: --
91: -- Declare local variables
92: --
93: l_proc varchar2(72) := g_package||'create_link';
94: l_business_group_id hr_de_organization_links.business_group_id%TYPE;
95: l_organization_link_id hr_de_organization_links.organization_link_id%TYPE;
96: l_object_version_number hr_de_organization_links.object_version_number%TYPE;
97: begin
98: hr_utility.set_location('Entering:'|| l_proc, 10);
91: -- Declare local variables
92: --
93: l_proc varchar2(72) := g_package||'create_link';
94: l_business_group_id hr_de_organization_links.business_group_id%TYPE;
95: l_organization_link_id hr_de_organization_links.organization_link_id%TYPE;
96: l_object_version_number hr_de_organization_links.object_version_number%TYPE;
97: begin
98: hr_utility.set_location('Entering:'|| l_proc, 10);
99: --
92: --
93: l_proc varchar2(72) := g_package||'create_link';
94: l_business_group_id hr_de_organization_links.business_group_id%TYPE;
95: l_organization_link_id hr_de_organization_links.organization_link_id%TYPE;
96: l_object_version_number hr_de_organization_links.object_version_number%TYPE;
97: begin
98: hr_utility.set_location('Entering:'|| l_proc, 10);
99: --
100: -- Issue a savepoint
116: --
117: -- Call Before Process User Hook
118: --
119: begin
120: hr_de_organization_links_bk1.create_link_b
121: (p_effective_date => trunc(p_effective_date)
122: ,p_parent_organization_id => p_parent_organization_id
123: ,p_child_organization_id => p_child_organization_id
124: ,p_business_group_id => l_business_group_id
268: --
269: -- Call After Process User Hook
270: --
271: begin
272: hr_de_organization_links_bk1.create_link_a
273: (p_effective_date => trunc(p_effective_date)
274: ,p_parent_organization_id => p_parent_organization_id
275: ,p_child_organization_id => p_child_organization_id
276: ,p_business_group_id => l_business_group_id
462: --
463: -- Declare local variables
464: --
465: l_proc varchar2(72) := g_package||'update_link';
466: l_object_version_number hr_de_organization_links.object_version_number%TYPE := p_object_version_number;
467: l_temp_ovn number := p_object_version_number;
468: begin
469: hr_utility.set_location('Entering:'|| l_proc, 10);
470: --
474: --
475: -- Call Before Process User Hook
476: --
477: begin
478: hr_de_organization_links_bk2.update_link_b
479: (p_effective_date => trunc(p_effective_date)
480: ,p_organization_link_id => p_organization_link_id
481: ,p_org_link_information_categor => p_org_link_information_categor
482: ,p_org_link_information1 => p_org_link_information1
620: --
621: -- Call After Process User Hook
622: --
623: begin
624: hr_de_organization_links_bk2.update_link_a
625: (p_effective_date => trunc(p_effective_date)
626: ,p_organization_link_id => p_organization_link_id
627: ,p_org_link_information_categor => p_org_link_information_categor
628: ,p_org_link_information1 => p_org_link_information1
753: --
754: -- Call Before Process User Hook
755: --
756: begin
757: hr_de_organization_links_bk3.delete_link_b
758: (p_organization_link_id => p_organization_link_id
759: ,p_object_version_number => p_object_version_number);
760: exception
761: when hr_api.cannot_find_prog_unit then
771: (p_organization_link_id => p_organization_link_id
772: ,p_object_version_number => p_object_version_number);
773: --
774: begin
775: hr_de_organization_links_bk3.delete_link_a
776: (p_organization_link_id => p_organization_link_id
777: ,p_object_version_number => p_object_version_number);
778: exception
779: when hr_api.cannot_find_prog_unit then
835: --
836: hr_utility.set_location(' Leaving:'||l_proc, 70);
837: end lck;
838: --
839: end hr_de_organization_links_api;