APPS.PQH_SPECIAL_ATTRIBUTES_API dependencies on PQH_SPECIAL_ATTRIBUTES

Line 1: Package Body pqh_special_attributes_api as

1: Package Body pqh_special_attributes_api as
2: /* $Header: pqsatapi.pkb 115.5 2004/04/09 11:15:18 srajakum ship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: pqsatapi.pkb 115.5 2004/04/09 11:15:18 srajakum ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' pqh_special_attributes_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_special_attribute >----------------------|
10: -- ----------------------------------------------------------------------------

Line 29: l_special_attribute_id pqh_special_attributes.special_attribute_id%TYPE;

25: ) is
26: --
27: -- Declare cursors and local variables
28: --
29: l_special_attribute_id pqh_special_attributes.special_attribute_id%TYPE;
30: l_proc varchar2(72) := g_package||'create_special_attribute';
31: l_object_version_number pqh_special_attributes.object_version_number%TYPE;
32: --
33: begin

Line 31: l_object_version_number pqh_special_attributes.object_version_number%TYPE;

27: -- Declare cursors and local variables
28: --
29: l_special_attribute_id pqh_special_attributes.special_attribute_id%TYPE;
30: l_proc varchar2(72) := g_package||'create_special_attribute';
31: l_object_version_number pqh_special_attributes.object_version_number%TYPE;
32: --
33: begin
34: --
35: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 49: pqh_special_attributes_bk1.create_special_attribute_b

45: begin
46: --
47: -- Start of API User Hook for the before hook of create_special_attribute
48: --
49: pqh_special_attributes_bk1.create_special_attribute_b
50: (
51: p_txn_category_attribute_id => p_txn_category_attribute_id
52: ,p_attribute_type_cd => p_attribute_type_cd
53: ,p_key_attribute_type => p_key_attribute_type

Line 92: pqh_special_attributes_bk1.create_special_attribute_a

88: begin
89: --
90: -- Start of API User Hook for the after hook of create_special_attribute
91: --
92: pqh_special_attributes_bk1.create_special_attribute_a
93: (
94: p_special_attribute_id => l_special_attribute_id
95: ,p_txn_category_attribute_id => p_txn_category_attribute_id
96: ,p_attribute_type_cd => p_attribute_type_cd

Line 181: l_object_version_number pqh_special_attributes.object_version_number%TYPE;

177: --
178: -- Declare cursors and local variables
179: --
180: l_proc varchar2(72) := g_package||'update_special_attribute';
181: l_object_version_number pqh_special_attributes.object_version_number%TYPE;
182: --
183: begin
184: --
185: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 201: pqh_special_attributes_bk2.update_special_attribute_b

197: begin
198: --
199: -- Start of API User Hook for the before hook of update_special_attribute
200: --
201: pqh_special_attributes_bk2.update_special_attribute_b
202: (
203: p_special_attribute_id => p_special_attribute_id
204: ,p_txn_category_attribute_id => p_txn_category_attribute_id
205: ,p_attribute_type_cd => p_attribute_type_cd

Line 245: pqh_special_attributes_bk2.update_special_attribute_a

241: begin
242: --
243: -- Start of API User Hook for the after hook of update_special_attribute
244: --
245: pqh_special_attributes_bk2.update_special_attribute_a
246: (
247: p_special_attribute_id => p_special_attribute_id
248: ,p_txn_category_attribute_id => p_txn_category_attribute_id
249: ,p_attribute_type_cd => p_attribute_type_cd

Line 322: l_object_version_number pqh_special_attributes.object_version_number%TYPE;

318: --
319: -- Declare cursors and local variables
320: --
321: l_proc varchar2(72) := g_package||'delete_special_attribute';
322: l_object_version_number pqh_special_attributes.object_version_number%TYPE;
323: --
324: begin
325: --
326: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 343: pqh_special_attributes_bk3.delete_special_attribute_b

339: begin
340: --
341: -- Start of API User Hook for the before hook of delete_special_attribute
342: --
343: pqh_special_attributes_bk3.delete_special_attribute_b
344: (
345: p_special_attribute_id => p_special_attribute_id
346: ,p_object_version_number => p_object_version_number
347: ,p_effective_date => trunc(p_effective_date)

Line 371: pqh_special_attributes_bk3.delete_special_attribute_a

367: begin
368: --
369: -- Start of API User Hook for the after hook of delete_special_attribute
370: --
371: pqh_special_attributes_bk3.delete_special_attribute_a
372: (
373: p_special_attribute_id => p_special_attribute_id
374: ,p_object_version_number => l_object_version_number
375: ,p_effective_date => trunc(p_effective_date)

Line 453: end pqh_special_attributes_api;

449: --
450: --
451:
452:
453: end pqh_special_attributes_api;