[Home] [Help]
1: Package Body pqh_copy_entity_attribs_api as
2: /* $Header: pqceaapi.pkb 115.5 2003/09/28 21:34:35 scnair ship $ */
3: --
4: -- Package Variables
5: --
2: /* $Header: pqceaapi.pkb 115.5 2003/09/28 21:34:35 scnair ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' pqh_copy_entity_attribs_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_copy_entity_attrib >----------------------|
10: -- ----------------------------------------------------------------------------
53: ) is
54: --
55: -- Declare cursors and local variables
56: --
57: l_copy_entity_attrib_id pqh_copy_entity_attribs.copy_entity_attrib_id%TYPE;
58: l_proc varchar2(72) := g_package||'create_copy_entity_attrib';
59: l_object_version_number pqh_copy_entity_attribs.object_version_number%TYPE;
60: --
61: begin
55: -- Declare cursors and local variables
56: --
57: l_copy_entity_attrib_id pqh_copy_entity_attribs.copy_entity_attrib_id%TYPE;
58: l_proc varchar2(72) := g_package||'create_copy_entity_attrib';
59: l_object_version_number pqh_copy_entity_attribs.object_version_number%TYPE;
60: --
61: begin
62: --
63: hr_utility.set_location('Entering:'|| l_proc, 10);
73: begin
74: --
75: -- Start of API User Hook for the before hook of create_copy_entity_attribs
76: --
77: pqh_copy_entity_attribs_bk1.create_copy_entity_attrib_b
78: (
79: p_copy_entity_txn_id => p_copy_entity_txn_id
80: ,p_row_type_cd => p_row_type_cd
81: ,p_information_category => p_information_category
172: begin
173: --
174: -- Start of API User Hook for the after hook of create_copy_entity_attribs
175: --
176: pqh_copy_entity_attribs_bk1.create_copy_entity_attrib_a
177: (
178: p_copy_entity_attrib_id => l_copy_entity_attrib_id
179: ,p_copy_entity_txn_id => p_copy_entity_txn_id
180: ,p_row_type_cd => p_row_type_cd
317: --
318: -- Declare cursors and local variables
319: --
320: l_proc varchar2(72) := g_package||'update_copy_entity_attrib';
321: l_object_version_number pqh_copy_entity_attribs.object_version_number%TYPE;
322: --
323: begin
324: --
325: hr_utility.set_location('Entering:'|| l_proc, 10);
337: begin
338: --
339: -- Start of API User Hook for the before hook of update_copy_entity_attribs
340: --
341: pqh_copy_entity_attribs_bk2.update_copy_entity_attrib_b
342: (
343: p_copy_entity_attrib_id => p_copy_entity_attrib_id
344: ,p_copy_entity_txn_id => p_copy_entity_txn_id
345: ,p_row_type_cd => p_row_type_cd
437: begin
438: --
439: -- Start of API User Hook for the after hook of update_copy_entity_attribs
440: --
441: pqh_copy_entity_attribs_bk2.update_copy_entity_attrib_a
442: (
443: p_copy_entity_attrib_id => p_copy_entity_attrib_id
444: ,p_copy_entity_txn_id => p_copy_entity_txn_id
445: ,p_row_type_cd => p_row_type_cd
542: --
543: -- Declare cursors and local variables
544: --
545: l_proc varchar2(72) := g_package||'delete_copy_entity_attrib';
546: l_object_version_number pqh_copy_entity_attribs.object_version_number%TYPE;
547: --
548: begin
549: --
550: hr_utility.set_location('Entering:'|| l_proc, 10);
563: begin
564: --
565: -- Start of API User Hook for the before hook of delete_copy_entity_attribs
566: --
567: pqh_copy_entity_attribs_bk3.delete_copy_entity_attrib_b
568: (
569: p_copy_entity_attrib_id => p_copy_entity_attrib_id
570: ,p_object_version_number => p_object_version_number
571: ,p_effective_date => trunc(p_effective_date)
591: begin
592: --
593: -- Start of API User Hook for the after hook of delete_copy_entity_attribs
594: --
595: pqh_copy_entity_attribs_bk3.delete_copy_entity_attrib_a
596: (
597: p_copy_entity_attrib_id => p_copy_entity_attrib_id
598: ,p_object_version_number => l_object_version_number
599: ,p_effective_date => trunc(p_effective_date)
670: hr_utility.set_location(' Leaving:'||l_proc, 70);
671: --
672: end lck;
673: --
674: end pqh_copy_entity_attribs_api;