APPS.PQH_DE_CASE_GROUPS_API dependencies on PQH_DE_CASE_GROUPS

Line 1: Package Body PQH_DE_CASE_GROUPS_API as

1: Package Body PQH_DE_CASE_GROUPS_API as
2: /* $Header: pqcgnapi.pkb 115.2 2002/11/27 04:43:22 rpasapul noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: pqcgnapi.pkb 115.2 2002/11/27 04:43:22 rpasapul noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := 'PQH_DE_CASE_GROUPS_API.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |--------------------------< Insert_CASE_GROUPS >--------------------------|
10: -- ----------------------------------------------------------------------------

Line 37: l_object_Version_Number PQH_DE_CASE_GROUPS.OBJECT_VERSION_NUMBER%TYPE;

33: -- Declare cursors and local variables
34: --
35:
36: l_proc varchar2(72) := g_package||'Insert_CASE_GROUPS';
37: l_object_Version_Number PQH_DE_CASE_GROUPS.OBJECT_VERSION_NUMBER%TYPE;
38: L_Effective_Date Date;
39: l_CASE_GROUP_ID PQH_DE_CASE_GROUPS.CASE_GROUP_ID%TYPE;
40:
41: begin

Line 39: l_CASE_GROUP_ID PQH_DE_CASE_GROUPS.CASE_GROUP_ID%TYPE;

35:
36: l_proc varchar2(72) := g_package||'Insert_CASE_GROUPS';
37: l_object_Version_Number PQH_DE_CASE_GROUPS.OBJECT_VERSION_NUMBER%TYPE;
38: L_Effective_Date Date;
39: l_CASE_GROUP_ID PQH_DE_CASE_GROUPS.CASE_GROUP_ID%TYPE;
40:
41: begin
42: hr_utility.set_location('Entering:'|| l_proc, 10);
43: --

Line 55: PQH_DE_CASE_GROUPS_BK1.Insert_CASE_GROUPS_b

51: --
52: -- Call Before Process User Hook
53: --
54: begin
55: PQH_DE_CASE_GROUPS_BK1.Insert_CASE_GROUPS_b
56: (p_effective_date => L_Effective_date
57: ,p_case_group_number => p_case_group_number
58: ,p_description => P_DESCRIPTION
59: ,p_advanced_pay_grade => P_advanced_pay_grade

Line 112: PQH_DE_CASE_GROUPS_BK1.Insert_CASE_GROUPS_a

108: --
109: begin
110:
111:
112: PQH_DE_CASE_GROUPS_BK1.Insert_CASE_GROUPS_a
113: (p_effective_date => L_Effective_Date
114: ,p_CASE_GROUP_NUMBER => p_CASE_GROUP_NUMBER
115: ,P_DESCRIPTION => P_DESCRIPTION
116: ,P_CASE_GROUP_ID => l_CASE_GROUP_ID

Line 207: l_object_Version_Number PQH_DE_CASE_GROUPS.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;

203: ,p_sub_csgrp_description In Varchar2 default hr_api.g_varchar2
204: ) is
205:
206: l_proc varchar2(72) := g_package||'Update_CASE_GROUPS';
207: l_object_Version_Number PQH_DE_CASE_GROUPS.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;
208: L_Effective_Date Date;
209:
210: Begin
211: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 225: PQH_DE_CASE_GROUPS_BK2.Update_CASE_GROUPS_b

221: -- Call Before Process User Hook
222: --
223: begin
224:
225: PQH_DE_CASE_GROUPS_BK2.Update_CASE_GROUPS_b
226: (p_effective_date => L_Effective_Date
227: ,p_CASE_GROUP_NUMBER => p_CASE_GROUP_NUMBER
228: ,P_DESCRIPTION => P_DESCRIPTION
229: ,P_CASE_GROUP_ID => p_CASE_GROUP_ID

Line 279: PQH_DE_CASE_GROUPS_BK2.Update_CASE_GROUPS_a

275: --
276: begin
277:
278:
279: PQH_DE_CASE_GROUPS_BK2.Update_CASE_GROUPS_a
280: (p_effective_date => L_Effective_Date
281: ,p_CASE_GROUP_NUMBER => p_CASE_GROUP_NUMBER
282: ,P_DESCRIPTION => P_DESCRIPTION
283: ,P_CASE_GROUP_ID => p_CASE_GROUP_ID

Line 367: PQH_DE_CASE_GROUPS_BK3.Delete_CASE_GROUPS_b

363: --
364: -- Call Before Process User Hook
365: --
366: begin
367: PQH_DE_CASE_GROUPS_BK3.Delete_CASE_GROUPS_b
368: (p_CASE_GROUP_Id => p_CASE_GROUP_Id
369: ,p_object_version_number => p_object_version_number);
370:
371:

Line 390: PQH_DE_CASE_GROUPS_BK3.Delete_CASE_GROUPS_a

386: -- Call After Process User Hook
387: --
388: begin
389:
390: PQH_DE_CASE_GROUPS_BK3.Delete_CASE_GROUPS_a
391: (p_CASE_GROUP_Id => p_CASE_GROUP_Id
392: ,p_object_version_number => p_object_version_number);
393:
394: exception

Line 432: end PQH_DE_CASE_GROUPS_API;

428: hr_utility.set_location(' Leaving:'||l_proc, 90);
429: raise;
430: end delete_CASE_GROUPS;
431:
432: end PQH_DE_CASE_GROUPS_API;