APPS.PQH_DE_LEVEL_CODES_API dependencies on PQH_DE_LEVEL_CODES

Line 1: Package Body PQH_DE_LEVEL_CODES_API as

1: Package Body PQH_DE_LEVEL_CODES_API as
2: /* $Header: pqlcdapi.pkb 115.1 2002/12/03 00:07:42 rpasapul noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: pqlcdapi.pkb 115.1 2002/12/03 00:07:42 rpasapul noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := 'PQH_DE_LEVEL_CODES_API.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |--------------------------< Insert_LEVEL_CODES >--------------------------|
10: -- ----------------------------------------------------------------------------

Line 28: l_object_Version_Number PQH_DE_LEVEL_CODES.OBJECT_VERSION_NUMBER%TYPE;

24: -- Declare cursors and local variables
25: --
26:
27: l_proc varchar2(72) := g_package||'Insert_LEVEL_CODES';
28: l_object_Version_Number PQH_DE_LEVEL_CODES.OBJECT_VERSION_NUMBER%TYPE;
29: L_Effective_Date Date;
30: l_level_code_id PQH_DE_LEVEL_CODES.LEVEL_CODE_ID%TYPE;
31:
32: begin

Line 30: l_level_code_id PQH_DE_LEVEL_CODES.LEVEL_CODE_ID%TYPE;

26:
27: l_proc varchar2(72) := g_package||'Insert_LEVEL_CODES';
28: l_object_Version_Number PQH_DE_LEVEL_CODES.OBJECT_VERSION_NUMBER%TYPE;
29: L_Effective_Date Date;
30: l_level_code_id PQH_DE_LEVEL_CODES.LEVEL_CODE_ID%TYPE;
31:
32: begin
33: hr_utility.set_location('Entering:'|| l_proc, 10);
34: --

Line 46: PQH_DE_LEVEL_CODES_BK1.Insert_LEVEL_CODES_b

42: --
43: -- Call Before Process User Hook
44: --
45: begin
46: PQH_DE_LEVEL_CODES_BK1.Insert_LEVEL_CODES_b
47: (p_effective_date => L_Effective_Date
48: ,p_level_number_id => p_level_number_id
49: ,p_level_code => p_level_code
50: ,p_description => p_description

Line 81: PQH_DE_LEVEL_CODES_BK1.Insert_LEVEL_CODES_a

77: --
78: begin
79:
80:
81: PQH_DE_LEVEL_CODES_BK1.Insert_LEVEL_CODES_a
82: (p_effective_date => L_Effective_Date
83: ,p_level_number_id => p_level_number_id
84: ,p_level_code => p_level_code
85: ,p_description => p_description

Line 157: l_object_Version_Number PQH_DE_LEVEL_CODES.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;

153: ,p_gradual_value_number in number default hr_api.g_number
154: ) Is
155:
156: l_proc varchar2(72) := g_package||'Update_LEVEL_CODES';
157: l_object_Version_Number PQH_DE_LEVEL_CODES.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;
158: L_Effective_Date Date;
159:
160: Begin
161: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 176: PQH_DE_LEVEL_CODES_BK2.Update_LEVEL_CODES_b

172: --
173: begin
174:
175:
176: PQH_DE_LEVEL_CODES_BK2.Update_LEVEL_CODES_b
177: (p_effective_date => L_Effective_Date
178: ,p_level_number_id => p_level_number_id
179: ,p_level_code => p_level_code
180: ,p_description => p_description

Line 212: PQH_DE_LEVEL_CODES_BK2.Update_LEVEL_CODES_a

208: --
209: begin
210:
211:
212: PQH_DE_LEVEL_CODES_BK2.Update_LEVEL_CODES_a
213: (p_effective_date => L_Effective_Date
214: ,p_level_number_id => p_level_number_id
215: ,p_level_code => p_level_code
216: ,p_description => p_description

Line 290: PQH_DE_LEVEL_CODES_BK3.Delete_LEVEL_CODES_b

286: --
287: -- Call Before Process User Hook
288: --
289: begin
290: PQH_DE_LEVEL_CODES_BK3.Delete_LEVEL_CODES_b
291: (p_LEVEL_CODE_Id => p_LEVEL_CODE_Id
292: ,p_object_version_number => p_object_version_number);
293: exception
294: when hr_api.cannot_find_prog_unit then

Line 311: PQH_DE_LEVEL_CODES_BK3.Delete_LEVEL_CODES_a

307: -- Call After Process User Hook
308: --
309: begin
310:
311: PQH_DE_LEVEL_CODES_BK3.Delete_LEVEL_CODES_a
312: (p_LEVEL_CODE_Id => p_LEVEL_CODE_Id
313: ,p_object_version_number => p_object_version_number);
314:
315: exception

Line 353: end PQH_DE_LEVEL_CODES_API;

349: hr_utility.set_location(' Leaving:'||l_proc, 90);
350: raise;
351: end delete_LEVEL_CODES;
352:
353: end PQH_DE_LEVEL_CODES_API;