1: Package Body pqh_copy_entity_functions_api as
2: /* $Header: pqcefapi.pkb 115.4 2002/12/05 19:30:55 rpasapul ship $ */
3: --
4: -- Package Variables
5: --
2: /* $Header: pqcefapi.pkb 115.4 2002/12/05 19:30:55 rpasapul ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' pqh_copy_entity_functions_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_copy_entity_function >----------------------|
10: -- ----------------------------------------------------------------------------
23: ) is
24: --
25: -- Declare cursors and local variables
26: --
27: l_copy_entity_function_id pqh_copy_entity_functions.copy_entity_function_id%TYPE;
28: l_proc varchar2(72) := g_package||'create_copy_entity_function';
29: l_object_version_number pqh_copy_entity_functions.object_version_number%TYPE;
30: --
31: begin
25: -- Declare cursors and local variables
26: --
27: l_copy_entity_function_id pqh_copy_entity_functions.copy_entity_function_id%TYPE;
28: l_proc varchar2(72) := g_package||'create_copy_entity_function';
29: l_object_version_number pqh_copy_entity_functions.object_version_number%TYPE;
30: --
31: begin
32: --
33: hr_utility.set_location('Entering:'|| l_proc, 10);
43: begin
44: --
45: -- Start of API User Hook for the before hook of create_copy_entity_function
46: --
47: pqh_copy_entity_functions_bk1.create_copy_entity_function_b
48: (
49: p_table_route_id => p_table_route_id
50: ,p_function_type_cd => p_function_type_cd
51: ,p_pre_copy_function_name => p_pre_copy_function_name
82: begin
83: --
84: -- Start of API User Hook for the after hook of create_copy_entity_function
85: --
86: pqh_copy_entity_functions_bk1.create_copy_entity_function_a
87: (
88: p_copy_entity_function_id => l_copy_entity_function_id
89: ,p_table_route_id => p_table_route_id
90: ,p_function_type_cd => p_function_type_cd
167: --
168: -- Declare cursors and local variables
169: --
170: l_proc varchar2(72) := g_package||'update_copy_entity_function';
171: l_object_version_number pqh_copy_entity_functions.object_version_number%TYPE;
172: --
173: begin
174: --
175: hr_utility.set_location('Entering:'|| l_proc, 10);
187: begin
188: --
189: -- Start of API User Hook for the before hook of update_copy_entity_function
190: --
191: pqh_copy_entity_functions_bk2.update_copy_entity_function_b
192: (
193: p_copy_entity_function_id => p_copy_entity_function_id
194: ,p_table_route_id => p_table_route_id
195: ,p_function_type_cd => p_function_type_cd
227: begin
228: --
229: -- Start of API User Hook for the after hook of update_copy_entity_function
230: --
231: pqh_copy_entity_functions_bk2.update_copy_entity_function_a
232: (
233: p_copy_entity_function_id => p_copy_entity_function_id
234: ,p_table_route_id => p_table_route_id
235: ,p_function_type_cd => p_function_type_cd
302: --
303: -- Declare cursors and local variables
304: --
305: l_proc varchar2(72) := g_package||'delete_copy_entity_function';
306: l_object_version_number pqh_copy_entity_functions.object_version_number%TYPE;
307: --
308: begin
309: --
310: hr_utility.set_location('Entering:'|| l_proc, 10);
323: begin
324: --
325: -- Start of API User Hook for the before hook of delete_copy_entity_function
326: --
327: pqh_copy_entity_functions_bk3.delete_copy_entity_function_b
328: (
329: p_copy_entity_function_id => p_copy_entity_function_id
330: ,p_object_version_number => p_object_version_number
331: ,p_effective_date => trunc(p_effective_date)
351: begin
352: --
353: -- Start of API User Hook for the after hook of delete_copy_entity_function
354: --
355: pqh_copy_entity_functions_bk3.delete_copy_entity_function_a
356: (
357: p_copy_entity_function_id => p_copy_entity_function_id
358: ,p_object_version_number => l_object_version_number
359: ,p_effective_date => trunc(p_effective_date)
439:
440:
441:
442:
443: end pqh_copy_entity_functions_api;