APPS.PQH_DE_OPERATION_GROUPS_API dependencies on PQH_DE_OPERATION_GROUPS

Line 1: Package Body PQH_DE_OPERATION_GROUPS_API as

1: Package Body PQH_DE_OPERATION_GROUPS_API as
2: /* $Header: pqopgapi.pkb 115.1 2002/12/03 00:09:04 rpasapul noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: pqopgapi.pkb 115.1 2002/12/03 00:09:04 rpasapul noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := 'PQH_DE_OPERATION_GROUPS_API.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |--------------------------< Insert_OPERATION_GROUPS >--------------------------|
10: -- ----------------------------------------------------------------------------

Line 25: l_object_Version_Number PQH_DE_OPERATION_GROUPS.OBJECT_VERSION_NUMBER%TYPE;

21: -- Declare cursors and local variables
22: --
23:
24: l_proc varchar2(72) := g_package||'Insert_OPERATION_GROUPS';
25: l_object_Version_Number PQH_DE_OPERATION_GROUPS.OBJECT_VERSION_NUMBER%TYPE;
26: L_Effective_Date Date;
27: l_operation_GROUP_ID PQH_DE_OPERATION_GROUPS.operation_GROUP_ID%TYPE;
28:
29: begin

Line 27: l_operation_GROUP_ID PQH_DE_OPERATION_GROUPS.operation_GROUP_ID%TYPE;

23:
24: l_proc varchar2(72) := g_package||'Insert_OPERATION_GROUPS';
25: l_object_Version_Number PQH_DE_OPERATION_GROUPS.OBJECT_VERSION_NUMBER%TYPE;
26: L_Effective_Date Date;
27: l_operation_GROUP_ID PQH_DE_OPERATION_GROUPS.operation_GROUP_ID%TYPE;
28:
29: begin
30: hr_utility.set_location('Entering:'|| l_proc, 10);
31: --

Line 43: PQH_DE_OPERATION_GROUPS_BK1.Insert_OPERATION_GROUPS_b

39: --
40: -- Call Before Process User Hook
41: --
42: begin
43: PQH_DE_OPERATION_GROUPS_BK1.Insert_OPERATION_GROUPS_b
44: (p_effective_date => L_Effective_Date
45: ,p_operation_Group_CODE => p_operation_Group_CODE
46: ,P_DESCRIPTION => P_DESCRIPTION
47: ,p_operation_GROUP_ID => l_operation_GROUP_ID

Line 80: PQH_DE_OPERATION_GROUPS_BK1.Insert_OPERATION_GROUPS_a

76: --
77: begin
78:
79:
80: PQH_DE_OPERATION_GROUPS_BK1.Insert_OPERATION_GROUPS_a
81: (p_effective_date => L_Effective_Date
82: ,p_operation_Group_CODE => p_operation_Group_CODE
83: ,P_DESCRIPTION => P_DESCRIPTION
84: ,p_operation_GROUP_ID => l_operation_GROUP_ID

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

149: ,p_business_group_id in number default hr_api.g_number
150: ) is
151:
152: l_proc varchar2(72) := g_package||'Update_OPERATION_GROUPS';
153: l_object_Version_Number PQH_DE_OPERATION_GROUPS.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_OPERATION_GROUPS_BK2.Update_OPERATION_GROUPS_b

167: -- Call Before Process User Hook
168: --
169: begin
170:
171: PQH_DE_OPERATION_GROUPS_BK2.Update_OPERATION_GROUPS_b
172: (p_effective_date => L_Effective_Date
173: ,p_operation_Group_CODE => p_operation_Group_CODE
174: ,P_DESCRIPTION => P_DESCRIPTION
175: ,p_operation_GROUP_ID => p_operation_GROUP_ID

Line 204: PQH_DE_OPERATION_GROUPS_BK2.Update_OPERATION_GROUPS_a

200: --
201: begin
202:
203:
204: PQH_DE_OPERATION_GROUPS_BK2.Update_OPERATION_GROUPS_a
205: (p_effective_date => L_Effective_Date
206: ,p_operation_Group_CODE => p_operation_Group_CODE
207: ,P_DESCRIPTION => P_DESCRIPTION
208: ,p_operation_GROUP_ID => p_operation_GROUP_ID

Line 282: PQH_DE_OPERATION_GROUPS_BK3.Delete_OPERATION_GROUPS_b

278: --
279: -- Call Before Process User Hook
280: --
281: begin
282: PQH_DE_OPERATION_GROUPS_BK3.Delete_OPERATION_GROUPS_b
283: (p_operation_GROUP_ID => p_operation_GROUP_ID
284: ,p_object_version_number => p_object_version_number);
285:
286:

Line 305: PQH_DE_OPERATION_GROUPS_BK3.Delete_OPERATION_GROUPS_a

301: -- Call After Process User Hook
302: --
303: begin
304:
305: PQH_DE_OPERATION_GROUPS_BK3.Delete_OPERATION_GROUPS_a
306: (p_operation_GROUP_ID => p_operation_GROUP_ID
307: ,p_object_version_number => p_object_version_number);
308:
309: exception

Line 347: end PQH_DE_OPERATION_GROUPS_API;

343: hr_utility.set_location(' Leaving:'||l_proc, 90);
344: raise;
345: end delete_OPERATION_GROUPS;
346:
347: end PQH_DE_OPERATION_GROUPS_API;