DBA Data[Home] [Help]

APPS.PQH_SITUATIONS_API dependencies on PQH_SITUATIONS

Line 1: Package Body pqh_situations_api as

1: Package Body pqh_situations_api as
2: /* $Header: pqlosapi.pkb 115.1 2002/12/03 00:08:02 rpasapul noship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := ' PQH_SITUATIONS_API.';

2: /* $Header: pqlosapi.pkb 115.1 2002/12/03 00:08:02 rpasapul noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' PQH_SITUATIONS_API.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |--------------------------< create_situation >--------------------------|
10: -- ----------------------------------------------------------------------------

Line 95: l_situation_id pqh_situations.situation_id%TYPE;

91: -- Declare cursors and local variables
92: --
93:
94: l_proc varchar2(72) := g_package||'CREATE_SITUATION';
95: l_situation_id pqh_situations.situation_id%TYPE;
96: l_object_version_number pqh_situations.object_version_number%TYPE;
97: --
98: begin
99: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 96: l_object_version_number pqh_situations.object_version_number%TYPE;

92: --
93:
94: l_proc varchar2(72) := g_package||'CREATE_SITUATION';
95: l_situation_id pqh_situations.situation_id%TYPE;
96: l_object_version_number pqh_situations.object_version_number%TYPE;
97: --
98: begin
99: hr_utility.set_location('Entering:'|| l_proc, 10);
100: --

Line 112: PQH_SITUATIONS_BK1.create_situation_b

108: --
109: -- Call Before Process User Hook
110: --
111: begin
112: PQH_SITUATIONS_BK1.create_situation_b
113: (p_effective_date => p_effective_date
114: ,p_situation => p_situation
115: ,p_effective_start_date => p_effective_start_date
116: ,p_business_group_id => p_business_group_id

Line 286: PQH_SITUATIONS_BK1.create_situation_a

282: --
283: -- Call After Process User Hook
284: --
285: begin
286: PQH_SITUATIONS_BK1.create_situation_a
287: (p_effective_date => p_effective_date
288: ,p_situation => p_situation
289: ,p_effective_start_date => p_effective_start_date
290: ,p_business_group_id => p_business_group_id

Line 513: PQH_SITUATIONS_BK2.update_situation_b

509: --
510: -- Call Before Process User Hook
511: --
512: begin
513: PQH_SITUATIONS_BK2.update_situation_b
514: (p_effective_date => p_effective_date
515: ,p_situation => p_situation
516: ,p_effective_start_date => p_effective_start_date
517: ,p_business_group_id => p_business_group_id

Line 689: PQH_SITUATIONS_BK2.update_situation_a

685: --
686: -- Call After Process User Hook
687: --
688: begin
689: PQH_SITUATIONS_BK2.update_situation_a
690: (p_effective_date => p_effective_date
691: ,p_situation => p_situation
692: ,p_effective_start_date => p_effective_start_date
693: ,p_business_group_id => p_business_group_id

Line 839: PQH_SITUATIONS_BK3.delete_situation_b

835: --
836: -- Call Before Process User Hook
837: --
838: begin
839: PQH_SITUATIONS_BK3.delete_situation_b
840: (p_situation_id => p_situation_id
841: ,p_object_version_number => p_object_version_number
842: );
843: exception

Line 869: PQH_SITUATIONS_BK3.delete_situation_a

865: --
866: -- Call After Process User Hook
867: --
868: begin
869: PQH_SITUATIONS_BK3.delete_situation_a
870: (p_situation_id => p_situation_id
871: ,p_object_version_number => p_object_version_number
872: );
873: exception

Line 913: end pqh_situations_api;

909: hr_utility.set_location(' Leaving:'||l_proc, 90);
910: raise;
911: end delete_situation;
912: --
913: end pqh_situations_api;