1: Package Body pqh_ATTRIBUTES_api as
2: /* $Header: pqattapi.pkb 115.13 2003/03/25 04:16:57 sgoyal ship $ */
3: --
4: -- Package Variables
5: --
2: /* $Header: pqattapi.pkb 115.13 2003/03/25 04:16:57 sgoyal ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' pqh_ATTRIBUTES_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_ATTRIBUTE >----------------------|
10: -- ----------------------------------------------------------------------------
28: ) is
29: --
30: -- Declare cursors and local variables
31: --
32: l_attribute_id pqh_attributes.attribute_id%TYPE;
33: l_proc varchar2(72) := g_package||'create_ATTRIBUTE';
34: l_object_version_number pqh_attributes.object_version_number%TYPE;
35: --
36: begin
30: -- Declare cursors and local variables
31: --
32: l_attribute_id pqh_attributes.attribute_id%TYPE;
33: l_proc varchar2(72) := g_package||'create_ATTRIBUTE';
34: l_object_version_number pqh_attributes.object_version_number%TYPE;
35: --
36: begin
37: --
38: hr_utility.set_location('Entering:'|| l_proc, 10);
48: begin
49: --
50: -- Start of API User Hook for the before hook of create_ATTRIBUTE
51: --
52: pqh_ATTRIBUTES_bk1.create_ATTRIBUTE_b
53: (
54: p_attribute_name => p_attribute_name
55: ,p_master_attribute_id => p_master_attribute_id
56: ,p_master_table_route_id => p_master_table_route_id
102: begin
103: --
104: -- Start of API User Hook for the after hook of create_ATTRIBUTE
105: --
106: pqh_ATTRIBUTES_bk1.create_ATTRIBUTE_a
107: (
108: p_attribute_id => l_attribute_id
109: ,p_attribute_name => p_attribute_name
110: ,p_master_attribute_id => p_master_attribute_id
196: --
197: -- Declare cursors and local variables
198: --
199: l_proc varchar2(72) := g_package||'update_ATTRIBUTE';
200: l_object_version_number pqh_attributes.object_version_number%TYPE;
201: --
202: begin
203: --
204: hr_utility.set_location('Entering:'|| l_proc, 10);
216: begin
217: --
218: -- Start of API User Hook for the before hook of update_ATTRIBUTE
219: --
220: pqh_ATTRIBUTES_bk2.update_ATTRIBUTE_b
221: (
222: p_attribute_id => p_attribute_id
223: ,p_attribute_name => p_attribute_name
224: ,p_master_attribute_id => p_master_attribute_id
271: begin
272: --
273: -- Start of API User Hook for the after hook of update_ATTRIBUTE
274: --
275: pqh_ATTRIBUTES_bk2.update_ATTRIBUTE_a
276: (
277: p_attribute_id => p_attribute_id
278: ,p_attribute_name => p_attribute_name
279: ,p_master_attribute_id => p_master_attribute_id
350: --
351: -- Declare cursors and local variables
352: --
353: l_proc varchar2(72) := g_package||'delete_ATTRIBUTE';
354: l_object_version_number pqh_attributes.object_version_number%TYPE;
355: --
356: begin
357: --
358: hr_utility.set_location('Entering:'|| l_proc, 10);
371: begin
372: --
373: -- Start of API User Hook for the before hook of delete_ATTRIBUTE
374: --
375: pqh_ATTRIBUTES_bk3.delete_ATTRIBUTE_b
376: (
377: p_attribute_id => p_attribute_id
378: ,p_object_version_number => p_object_version_number
379: ,p_effective_date => trunc(p_effective_date)
412: begin
413: --
414: -- Start of API User Hook for the after hook of delete_ATTRIBUTE
415: --
416: pqh_ATTRIBUTES_bk3.delete_ATTRIBUTE_a
417: (
418: p_attribute_id => p_attribute_id
419: ,p_object_version_number => l_object_version_number
420: ,p_effective_date => trunc(p_effective_date)
491: hr_utility.set_location(' Leaving:'||l_proc, 70);
492: --
493: end lck;
494: --
495: end pqh_ATTRIBUTES_api;