APPS.PQH_ATTRIBUTE_RANGES_API dependencies on PQH_ATTRIBUTE_RANGES

Line 1: Package Body pqh_ATTRIBUTE_RANGES_api as

1: Package Body pqh_ATTRIBUTE_RANGES_api as
2: /* $Header: pqrngapi.pkb 115.8 2002/12/06 18:08:24 rpasapul noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: pqrngapi.pkb 115.8 2002/12/06 18:08:24 rpasapul noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' pqh_ATTRIBUTE_RANGES_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_ATTRIBUTE_RANGE >----------------------|
10: -- ----------------------------------------------------------------------------

Line 36: l_attribute_range_id pqh_attribute_ranges.attribute_range_id%TYPE;

32: ) is
33: --
34: -- Declare cursors and local variables
35: --
36: l_attribute_range_id pqh_attribute_ranges.attribute_range_id%TYPE;
37: l_proc varchar2(72) := g_package||'create_ATTRIBUTE_RANGE';
38: l_object_version_number pqh_attribute_ranges.object_version_number%TYPE;
39: --
40: begin

Line 38: l_object_version_number pqh_attribute_ranges.object_version_number%TYPE;

34: -- Declare cursors and local variables
35: --
36: l_attribute_range_id pqh_attribute_ranges.attribute_range_id%TYPE;
37: l_proc varchar2(72) := g_package||'create_ATTRIBUTE_RANGE';
38: l_object_version_number pqh_attribute_ranges.object_version_number%TYPE;
39: --
40: begin
41: --
42: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 56: pqh_ATTRIBUTE_RANGES_bk1.create_ATTRIBUTE_RANGE_b

52: begin
53: --
54: -- Start of API User Hook for the before hook of create_ATTRIBUTE_RANGE
55: --
56: pqh_ATTRIBUTE_RANGES_bk1.create_ATTRIBUTE_RANGE_b
57: (
58: p_approver_flag => p_approver_flag
59: ,p_enable_flag => p_enable_flag
60: ,p_delete_flag => p_delete_flag

Line 113: pqh_ATTRIBUTE_RANGES_bk1.create_ATTRIBUTE_RANGE_a

109: begin
110: --
111: -- Start of API User Hook for the after hook of create_ATTRIBUTE_RANGE
112: --
113: pqh_ATTRIBUTE_RANGES_bk1.create_ATTRIBUTE_RANGE_a
114: (
115: p_attribute_range_id => l_attribute_range_id
116: ,p_approver_flag => p_approver_flag
117: ,p_enable_flag => p_enable_flag

Line 216: l_object_version_number pqh_attribute_ranges.object_version_number%TYPE;

212: --
213: -- Declare cursors and local variables
214: --
215: l_proc varchar2(72) := g_package||'update_ATTRIBUTE_RANGE';
216: l_object_version_number pqh_attribute_ranges.object_version_number%TYPE;
217: --
218: begin
219: --
220: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 236: pqh_ATTRIBUTE_RANGES_bk2.update_ATTRIBUTE_RANGE_b

232: begin
233: --
234: -- Start of API User Hook for the before hook of update_ATTRIBUTE_RANGE
235: --
236: pqh_ATTRIBUTE_RANGES_bk2.update_ATTRIBUTE_RANGE_b
237: (
238: p_attribute_range_id => p_attribute_range_id
239: ,p_approver_flag => p_approver_flag
240: ,p_enable_flag => p_enable_flag

Line 294: pqh_ATTRIBUTE_RANGES_bk2.update_ATTRIBUTE_RANGE_a

290: begin
291: --
292: -- Start of API User Hook for the after hook of update_ATTRIBUTE_RANGE
293: --
294: pqh_ATTRIBUTE_RANGES_bk2.update_ATTRIBUTE_RANGE_a
295: (
296: p_attribute_range_id => p_attribute_range_id
297: ,p_approver_flag => p_approver_flag
298: ,p_enable_flag => p_enable_flag

Line 378: l_object_version_number pqh_attribute_ranges.object_version_number%TYPE;

374: --
375: -- Declare cursors and local variables
376: --
377: l_proc varchar2(72) := g_package||'delete_ATTRIBUTE_RANGE';
378: l_object_version_number pqh_attribute_ranges.object_version_number%TYPE;
379: --
380: begin
381: --
382: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 399: pqh_ATTRIBUTE_RANGES_bk3.delete_ATTRIBUTE_RANGE_b

395: begin
396: --
397: -- Start of API User Hook for the before hook of delete_ATTRIBUTE_RANGE
398: --
399: pqh_ATTRIBUTE_RANGES_bk3.delete_ATTRIBUTE_RANGE_b
400: (
401: p_attribute_range_id => p_attribute_range_id
402: ,p_object_version_number => p_object_version_number
403: ,p_effective_date => trunc(p_effective_date)

Line 427: pqh_ATTRIBUTE_RANGES_bk3.delete_ATTRIBUTE_RANGE_a

423: begin
424: --
425: -- Start of API User Hook for the after hook of delete_ATTRIBUTE_RANGE
426: --
427: pqh_ATTRIBUTE_RANGES_bk3.delete_ATTRIBUTE_RANGE_a
428: (
429: p_attribute_range_id => p_attribute_range_id
430: ,p_object_version_number => l_object_version_number
431: ,p_effective_date => trunc(p_effective_date)

Line 506: end pqh_ATTRIBUTE_RANGES_api;

502: hr_utility.set_location(' Leaving:'||l_proc, 70);
503: --
504: end lck;
505: --
506: end pqh_ATTRIBUTE_RANGES_api;