APPS.PQH_DE_RESULT_SETS_API dependencies on PQH_DE_RESULT_SETS

Line 1: Package Body PQH_DE_RESULT_SETS_API as

1: Package Body PQH_DE_RESULT_SETS_API as
2: /* $Header: pqrssapi.pkb 115.1 2002/12/03 20:43:18 rpasapul noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: pqrssapi.pkb 115.1 2002/12/03 20:43:18 rpasapul noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := 'PQH_DE_RESULT_SETS_API.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |--------------------------< Insert_RESULT_SETS >--------------------------|
10: -- ----------------------------------------------------------------------------

Line 26: l_object_Version_Number PQH_DE_RESULT_SETS.OBJECT_VERSION_NUMBER%TYPE;

22: -- Declare cursors and local variables
23: --
24:
25: l_proc varchar2(72) := g_package||'Insert_RESULT_SETS';
26: l_object_Version_Number PQH_DE_RESULT_SETS.OBJECT_VERSION_NUMBER%TYPE;
27: L_Effective_Date Date;
28: l_RESULT_SET_ID PQH_DE_RESULT_SETS.RESULT_SET_ID%TYPE;
29:
30: begin

Line 28: l_RESULT_SET_ID PQH_DE_RESULT_SETS.RESULT_SET_ID%TYPE;

24:
25: l_proc varchar2(72) := g_package||'Insert_RESULT_SETS';
26: l_object_Version_Number PQH_DE_RESULT_SETS.OBJECT_VERSION_NUMBER%TYPE;
27: L_Effective_Date Date;
28: l_RESULT_SET_ID PQH_DE_RESULT_SETS.RESULT_SET_ID%TYPE;
29:
30: begin
31: hr_utility.set_location('Entering:'|| l_proc, 10);
32: --

Line 46: PQH_DE_RESULT_SETS_BK1.Insert_RESULT_SETS_b

42: --
43: -- Call Before Process User Hook
44: --
45: begin
46: PQH_DE_RESULT_SETS_BK1.Insert_RESULT_SETS_b
47: (p_effective_date => L_Effective_Date
48: ,p_gradual_value_number_from => p_gradual_value_number_from
49: ,p_gradual_value_number_to => p_gradual_value_number_to
50: ,P_grade_id => P_grade_id );

Line 81: PQH_DE_RESULT_SETS_BK1.Insert_RESULT_SETS_a

77: --
78: begin
79:
80:
81: PQH_DE_RESULT_SETS_BK1.Insert_RESULT_SETS_a
82: (p_effective_date => l_Effective_date
83: ,p_gradual_value_number_from => p_gradual_value_number_from
84: ,p_gradual_value_number_to => p_gradual_value_number_to
85: ,p_grade_id => p_grade_id

Line 153: l_object_Version_Number PQH_DE_RESULT_SETS.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;

149: ,p_grade_id in number default hr_api.g_number
150: ) is
151:
152: l_proc varchar2(72) := g_package||'Update_RESULT_SETS';
153: l_object_Version_Number PQH_DE_RESULT_SETS.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;
154: L_Effective_Date Date;
155:
156: Begin
157: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 171: PQH_DE_RESULT_SETS_BK2.Update_RESULT_SETS_b

167: -- Call Before Process User Hook
168: --
169: begin
170:
171: PQH_DE_RESULT_SETS_BK2.Update_RESULT_SETS_b
172: (p_effective_date => L_Effective_Date
173: ,p_gradual_value_number_from => p_gradual_value_number_from
174: ,p_gradual_value_number_to => p_gradual_value_number_to
175: ,P_grade_id => P_grade_id

Line 203: PQH_DE_RESULT_SETS_BK2.Update_RESULT_SETS_a

199: --
200: begin
201:
202:
203: PQH_DE_RESULT_SETS_BK2.Update_RESULT_SETS_a
204: (p_effective_date => L_Effective_Date
205: ,p_gradual_value_number_from => p_gradual_value_number_from
206: ,p_gradual_value_number_to => p_gradual_value_number_to
207: ,P_grade_id => P_grade_id

Line 281: PQH_DE_RESULT_SETS_BK3.Delete_RESULT_SETS_b

277: --
278: -- Call Before Process User Hook
279: --
280: begin
281: PQH_DE_RESULT_SETS_BK3.Delete_RESULT_SETS_b
282: (p_RESULT_SET_Id => p_RESULT_SET_Id
283: ,p_object_version_number => p_object_version_number);
284: exception
285: when hr_api.cannot_find_prog_unit then

Line 302: PQH_DE_RESULT_SETS_BK3.Delete_RESULT_SETS_a

298: -- Call After Process User Hook
299: --
300: begin
301:
302: PQH_DE_RESULT_SETS_BK3.Delete_RESULT_SETS_a
303: (p_RESULT_SET_Id => p_RESULT_SET_Id
304: ,p_object_version_number => p_object_version_number);
305:
306: exception

Line 344: end PQH_DE_RESULT_SETS_API;

340: hr_utility.set_location(' Leaving:'||l_proc, 90);
341: raise;
342: end delete_RESULT_SETS;
343:
344: end PQH_DE_RESULT_SETS_API;