DBA Data[Home] [Help]

APPS.PQH_ROLE_EXTRA_INFO_API dependencies on PQH_ROLE_EXTRA_INFO

Line 1: Package Body pqh_role_extra_info_api as

1: Package Body pqh_role_extra_info_api as
2: /* $Header: pqreiapi.pkb 115.1 2002/12/10 11:14:04 mvankada noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: pqreiapi.pkb 115.1 2002/12/10 11:14:04 mvankada noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' pqh_role_extra_info_api.';
7: --
8: -- ---------------------------------------------------------------------------+
9: -- |----------------------< create_role_extra_info >--------------------------|
10: -- ---------------------------------------------------------------------------+

Line 85: l_object_version_number pqh_role_extra_info.object_version_number%type;

81: --
82: -- Declare cursors and local variables
83: --
84: l_proc varchar2(72) := g_package||'create_role_extra_info';
85: l_object_version_number pqh_role_extra_info.object_version_number%type;
86: l_role_extra_info_id pqh_role_extra_info.role_extra_info_id%type;
87: --
88: begin
89: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 86: l_role_extra_info_id pqh_role_extra_info.role_extra_info_id%type;

82: -- Declare cursors and local variables
83: --
84: l_proc varchar2(72) := g_package||'create_role_extra_info';
85: l_object_version_number pqh_role_extra_info.object_version_number%type;
86: l_role_extra_info_id pqh_role_extra_info.role_extra_info_id%type;
87: --
88: begin
89: hr_utility.set_location('Entering:'|| l_proc, 5);
90: --

Line 98: pqh_role_extra_info_bk1.create_role_extra_info_b

94: --
95: -- Call Before Process User Hook
96: --
97: begin
98: pqh_role_extra_info_bk1.create_role_extra_info_b
99: (
100: p_information_type => p_information_type,
101: p_role_id => p_role_id,
102: p_attribute_category => p_attribute_category,

Line 255: pqh_role_extra_info_bk1.create_role_extra_info_a

251: --
252: -- Call After Process User Hook
253: --
254: begin
255: pqh_role_extra_info_bk1.create_role_extra_info_a
256: (
257: p_role_extra_info_id => l_role_extra_info_id,
258: p_information_type => p_information_type,
259: p_role_id => p_role_id,

Line 446: l_object_version_number pqh_role_extra_info.object_version_number%TYPE;

442: --
443: -- Declare cursors and local variables
444: --
445: l_proc varchar2(72) := g_package||'update_role_extra_info';
446: l_object_version_number pqh_role_extra_info.object_version_number%TYPE;
447: --
448: begin
449: hr_utility.set_location('Entering:'|| l_proc, 5);
450: --

Line 458: pqh_role_extra_info_bk2.update_role_extra_info_b

454: --
455: -- Call Before Process User Hook
456: --
457: begin
458: pqh_role_extra_info_bk2.update_role_extra_info_b
459: (
460: p_role_extra_info_id => p_role_extra_info_id,
461: p_attribute_category => p_attribute_category,
462: p_attribute1 => p_attribute1,

Line 616: pqh_role_extra_info_bk2.update_role_extra_info_a

612: --
613: -- Call After Process User Hook
614: --
615: begin
616: pqh_role_extra_info_bk2.update_role_extra_info_a
617: (
618: p_role_extra_info_id => p_role_extra_info_id,
619: p_attribute_category => p_attribute_category,
620: p_attribute1 => p_attribute1,

Line 753: pqh_role_extra_info_bk3.delete_role_extra_info_b

749: --
750: -- Call Before Process User Hook
751: --
752: begin
753: pqh_role_extra_info_bk3.delete_role_extra_info_b
754: (
755: p_role_extra_info_id => p_role_extra_info_id,
756: p_object_version_number => p_object_version_number
757: );

Line 781: pqh_role_extra_info_bk3.delete_role_extra_info_a

777: --
778: -- Call After Process User Hook
779: --
780: begin
781: pqh_role_extra_info_bk3.delete_role_extra_info_a
782: (
783: p_role_extra_info_id => p_role_extra_info_id,
784: p_object_version_number => p_object_version_number
785: );

Line 823: end pqh_role_extra_info_api;

819: raise;
820: --
821: end delete_role_extra_info;
822: --
823: end pqh_role_extra_info_api;