APPS.PER_EST_INS dependencies on PER_ESTABLISHMENTS

Line 63: -- Insert the row into: per_establishments

59: p_rec.object_version_number := 1; -- Initialise the object version
60: --
61: per_est_shd.g_api_dml := true; -- Set the api dml status
62: --
63: -- Insert the row into: per_establishments
64: --
65: insert into per_establishments
66: ( establishment_id,
67: name,

Line 65: insert into per_establishments

61: per_est_shd.g_api_dml := true; -- Set the api dml status
62: --
63: -- Insert the row into: per_establishments
64: --
65: insert into per_establishments
66: ( establishment_id,
67: name,
68: location,
69: attribute_category,

Line 228: select per_establishments_s.nextval

224: --
225: l_proc varchar2(72) := g_package||'pre_insert';
226: --
227: cursor c1 is
228: select per_establishments_s.nextval
229: from sys.dual;
230: --
231: Begin
232: hr_utility.set_location('Entering:'||l_proc, 5);

Line 335: ( P_MODULE_NAME => 'PER_ESTABLISHMENTS',

331: );
332: exception
333: when hr_api.cannot_find_prog_unit then
334: hr_api.cannot_find_prog_unit_error
335: ( P_MODULE_NAME => 'PER_ESTABLISHMENTS',
336: p_hook_type => 'AI'
337: );
338: end;
339: -- End of API User Hook for post_insert.