DBA Data[Home] [Help]

APPS.BEN_LOCATION_OBJECT dependencies on HR_LOCATIONS_ALL

Line 31: procedure set_object(p_rec in out NOCOPY hr_locations_all%rowtype) is

27: g_hash_jump number := ben_hash_utility.get_hash_jump;
28: --
29: -- Set object routines
30: --
31: procedure set_object(p_rec in out NOCOPY hr_locations_all%rowtype) is
32: --
33: l_proc varchar2(80) := g_package||'set_object';
34: l_index pls_integer;
35: l_not_hash_found boolean;

Line 81: p_rec in out nocopy hr_locations_all%rowtype) is

77: -- Set object alternate route routines
78: --
79: procedure set_loc_object
80: (p_location_id in number,
81: p_rec in out nocopy hr_locations_all%rowtype) is
82: --
83: l_proc varchar2(80) := g_package||'set_loc_object';
84: --
85: cursor c1 is

Line 87: from hr_locations_all loc

83: l_proc varchar2(80) := g_package||'set_loc_object';
84: --
85: cursor c1 is
86: select loc.*
87: from hr_locations_all loc
88: where loc.location_id = p_location_id;
89: --115.3 remove additional declaration
90: --l_rec hr_locations_all%rowtype;
91: --

Line 90: --l_rec hr_locations_all%rowtype;

86: select loc.*
87: from hr_locations_all loc
88: where loc.location_id = p_location_id;
89: --115.3 remove additional declaration
90: --l_rec hr_locations_all%rowtype;
91: --
92: begin
93: --
94: --hr_utility.set_location('Entering '||l_proc,10);

Line 123: p_rec in out nocopy hr_locations_all%rowtype) is

119: --
120: -- Get object routines
121: --
122: procedure get_object(p_location_id in number,
123: p_rec in out nocopy hr_locations_all%rowtype) is
124: --
125: l_proc varchar2(80) := g_package||'get_object';
126: l_index pls_integer;
127: --l_not_hash_found boolean;

Line 129: --l_rec hr_locations_all%rowtype;

125: l_proc varchar2(80) := g_package||'get_object';
126: l_index pls_integer;
127: --l_not_hash_found boolean;
128: l_env ben_env_object.g_global_env_rec_type;
129: --l_rec hr_locations_all%rowtype;
130: --
131: begin
132: --
133: --hr_utility.set_location('Entering '||l_proc,10);

Line 189: l_last_loc_rec hr_locations_all%rowtype;

185: end get_object;
186: --
187: procedure clear_down_cache is
188: --
189: l_last_loc_rec hr_locations_all%rowtype;
190: --
191: begin
192: --
193: g_cache_loc_rec.delete;