DBA Data[Home] [Help]

APPS.PQH_ATTRIBUTES_API dependencies on PQH_ATTRIBUTES

Line 1: Package Body pqh_ATTRIBUTES_api as

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: --

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

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: -- ----------------------------------------------------------------------------

Line 32: l_attribute_id pqh_attributes.attribute_id%TYPE;

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

Line 34: l_object_version_number pqh_attributes.object_version_number%TYPE;

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);

Line 52: pqh_ATTRIBUTES_bk1.create_ATTRIBUTE_b

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

Line 106: pqh_ATTRIBUTES_bk1.create_ATTRIBUTE_a

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

Line 200: l_object_version_number pqh_attributes.object_version_number%TYPE;

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);

Line 220: pqh_ATTRIBUTES_bk2.update_ATTRIBUTE_b

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

Line 275: pqh_ATTRIBUTES_bk2.update_ATTRIBUTE_a

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

Line 354: l_object_version_number pqh_attributes.object_version_number%TYPE;

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);

Line 375: pqh_ATTRIBUTES_bk3.delete_ATTRIBUTE_b

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)

Line 416: pqh_ATTRIBUTES_bk3.delete_ATTRIBUTE_a

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)

Line 495: end pqh_ATTRIBUTES_api;

491: hr_utility.set_location(' Leaving:'||l_proc, 70);
492: --
493: end lck;
494: --
495: end pqh_ATTRIBUTES_api;