APPS.PQH_ROLES_API dependencies on PQH_ROLES

Line 1: Package Body pqh_roles_api as

1: Package Body pqh_roles_api as
2: /* $Header: pqrlsapi.pkb 115.8 2002/12/03 20:43:04 rpasapul noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: pqrlsapi.pkb 115.8 2002/12/03 20:43:04 rpasapul noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' pqh_roles_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_role >----------------------|
10: -- ----------------------------------------------------------------------------

Line 58: l_role_id pqh_roles.role_id%TYPE;

54: ) is
55: --
56: -- Declare cursors and local variables
57: --
58: l_role_id pqh_roles.role_id%TYPE;
59: l_proc varchar2(72) := g_package||'create_role';
60: l_object_version_number pqh_roles.object_version_number%TYPE;
61: --
62: begin

Line 60: l_object_version_number pqh_roles.object_version_number%TYPE;

56: -- Declare cursors and local variables
57: --
58: l_role_id pqh_roles.role_id%TYPE;
59: l_proc varchar2(72) := g_package||'create_role';
60: l_object_version_number pqh_roles.object_version_number%TYPE;
61: --
62: begin
63: --
64: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 81: pqh_roles_bk1.create_role_b

77: --
78:
79:
80:
81: pqh_roles_bk1.create_role_b
82: (
83: p_role_name => p_role_name
84: ,p_role_type_cd => p_role_type_cd
85: ,p_enable_flag => p_enable_flag

Line 178: pqh_roles_bk1.create_role_a

174: begin
175: --
176: -- Start of API User Hook for the after hook of create_role
177: --
178: pqh_roles_bk1.create_role_a
179: (
180: p_role_id => l_role_id
181: ,p_role_name => p_role_name
182: ,p_role_type_cd => p_role_type_cd

Line 321: l_object_version_number pqh_roles.object_version_number%TYPE;

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

Line 341: pqh_roles_bk2.update_role_b

337: begin
338: --
339: -- Start of API User Hook for the before hook of update_role
340: --
341: pqh_roles_bk2.update_role_b
342: (
343: p_role_id => p_role_id
344: ,p_role_name => p_role_name
345: ,p_role_type_cd => p_role_type_cd

Line 439: pqh_roles_bk2.update_role_a

435: begin
436: --
437: -- Start of API User Hook for the after hook of update_role
438: --
439: pqh_roles_bk2.update_role_a
440: (
441: p_role_id => p_role_id
442: ,p_role_name => p_role_name
443: ,p_role_type_cd => p_role_type_cd

Line 543: l_object_version_number pqh_roles.object_version_number%TYPE;

539: --
540: -- Declare cursors and local variables
541: --
542: l_proc varchar2(72) := g_package||'delete_role';
543: l_object_version_number pqh_roles.object_version_number%TYPE;
544: --
545: begin
546: --
547: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 564: pqh_roles_bk3.delete_role_b

560: begin
561: --
562: -- Start of API User Hook for the before hook of delete_role
563: --
564: pqh_roles_bk3.delete_role_b
565: (
566: p_role_id => p_role_id
567: ,p_object_version_number => p_object_version_number
568: ,p_effective_date => trunc(p_effective_date)

Line 592: pqh_roles_bk3.delete_role_a

588: begin
589: --
590: -- Start of API User Hook for the after hook of delete_role
591: --
592: pqh_roles_bk3.delete_role_a
593: (
594: p_role_id => p_role_id
595: ,p_object_version_number => l_object_version_number
596: ,p_effective_date => trunc(p_effective_date)

Line 643: end pqh_roles_api;

639: --
640: end delete_role;
641: --
642: --
643: end pqh_roles_api;