APPS.PER_ABC_INS dependencies on PER_ABSENCE_CASES

Line 87: -- Insert the row into: per_absence_cases

83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: per_abc_shd.g_api_dml := true; -- Set the api dml status
86: --
87: -- Insert the row into: per_absence_cases
88: --
89: insert into per_absence_cases
90: (absence_case_id
91: ,name

Line 89: insert into per_absence_cases

85: per_abc_shd.g_api_dml := true; -- Set the api dml status
86: --
87: -- Insert the row into: per_absence_cases
88: --
89: insert into per_absence_cases
90: (absence_case_id
91: ,name
92: ,person_id
93: ,incident_id

Line 299: Cursor C_Sel1 is select per_absence_cases_s.nextval from sys.dual;

295: Procedure pre_insert
296: (p_rec in out nocopy per_abc_shd.g_rec_type
297: ) is
298: --
299: Cursor C_Sel1 is select per_absence_cases_s.nextval from sys.dual;
300: --
301: Cursor C_Sel2 is
302: Select null
303: from per_absence_cases

Line 303: from per_absence_cases

299: Cursor C_Sel1 is select per_absence_cases_s.nextval from sys.dual;
300: --
301: Cursor C_Sel2 is
302: Select null
303: from per_absence_cases
304: where absence_case_id =
305: per_abc_ins.g_absence_case_id_i;
306: --
307: l_proc varchar2(72) := g_package||'pre_insert';

Line 325: fnd_message.set_token('TABLE_NAME','per_absence_cases');

321: --
322: -- The primary key values are already in use.
323: --
324: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
325: fnd_message.set_token('TABLE_NAME','per_absence_cases');
326: fnd_message.raise_error;
327: End If;
328: Close C_Sel2;
329: --

Line 540: (p_module_name => 'PER_ABSENCE_CASES'

536: --
537: when hr_api.cannot_find_prog_unit then
538: --
539: hr_api.cannot_find_prog_unit_error
540: (p_module_name => 'PER_ABSENCE_CASES'
541: ,p_hook_type => 'AI');
542: --
543: end;
544: --