APPS.PER_ESA_INS dependencies on PER_ESTABLISHMENT_ATTENDANCES

Line 85: -- Insert the row into: per_establishment_attendances

81: p_rec.object_version_number := 1; -- Initialise the object version
82: --
83: per_esa_shd.g_api_dml := true; -- Set the api dml status
84: --
85: -- Insert the row into: per_establishment_attendances
86: --
87: insert into per_establishment_attendances
88: ( attendance_id,
89: person_id,

Line 87: insert into per_establishment_attendances

83: per_esa_shd.g_api_dml := true; -- Set the api dml status
84: --
85: -- Insert the row into: per_establishment_attendances
86: --
87: insert into per_establishment_attendances
88: ( attendance_id,
89: person_id,
90: establishment_id,
91: establishment,

Line 226: from per_establishment_attendances

222: --
223: --
224: Cursor C_Sel2 is
225: Select null
226: from per_establishment_attendances
227: where attendance_id =
228: per_esa_ins.g_attendance_id_i;
229: --
230: l_proc varchar2(72) := g_package||'pre_insert';

Line 248: fnd_message.set_name('TABLE_NAME','per_establishment_attendances');

244: --
245: -- The primary key values are already in use.
246: --
247: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
248: fnd_message.set_name('TABLE_NAME','per_establishment_attendances');
249: fnd_message.raise_error;
250: End If;
251: Close C_Sel2;
252: --

Line 355: (p_module_name => 'PER_ESTABLISHMENT_ATTENDANCES'

351: );
352: exception
353: when hr_api.cannot_find_prog_unit then
354: hr_api.cannot_find_prog_unit_error
355: (p_module_name => 'PER_ESTABLISHMENT_ATTENDANCES'
356: ,p_hook_type => 'AI'
357: );
358: end;
359: -- End of API User Hook for post_insert.