APPS.HR_EAP_INS dependencies on HR_KI_EXT_APPLICATIONS

Line 56: -- If same external_application_name already exists in hr_ki_ext_applications

52: BEGIN
53:
54:
55: --
56: -- If same external_application_name already exists in hr_ki_ext_applications
57: -- table then raise error.
58: --
59:
60: hr_eap_bus.CHK_EXTERNAL_APPLICATION_NAME

Line 97: -- insert record into hr_ki_ext_applications

93: p_fval9 => p_fval9,
94: p_appid => l_app_id);
95:
96:
97: -- insert record into hr_ki_ext_applications
98:
99: hr_eap_ins.ins
100: (
101: p_ext_application_id => l_ki_app_id

Line 183: -- Insert the row into: hr_ki_ext_applications

179: --
180: --
181: --
182: --
183: -- Insert the row into: hr_ki_ext_applications
184: --
185: insert into hr_ki_ext_applications
186: (ext_application_id
187: ,external_application_name

Line 185: insert into hr_ki_ext_applications

181: --
182: --
183: -- Insert the row into: hr_ki_ext_applications
184: --
185: insert into hr_ki_ext_applications
186: (ext_application_id
187: ,external_application_name
188: ,external_application_id
189: )

Line 261: Cursor C_Sel1 is select hr_ki_ext_applications_s.nextval from sys.dual;

257: Procedure pre_insert
258: (p_rec in out nocopy hr_eap_shd.g_rec_type
259: ) is
260: --
261: Cursor C_Sel1 is select hr_ki_ext_applications_s.nextval from sys.dual;
262: --
263: Cursor C_Sel2 is
264: Select null
265: from hr_ki_ext_applications

Line 265: from hr_ki_ext_applications

261: Cursor C_Sel1 is select hr_ki_ext_applications_s.nextval from sys.dual;
262: --
263: Cursor C_Sel2 is
264: Select null
265: from hr_ki_ext_applications
266: where ext_application_id =
267: hr_eap_ins.g_ext_application_id_i;
268: --
269: l_proc varchar2(72) := g_package||'pre_insert';

Line 287: fnd_message.set_token('TABLE_NAME','hr_ki_ext_applications');

283: --
284: -- The primary key values are already in use.
285: --
286: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
287: fnd_message.set_token('TABLE_NAME','hr_ki_ext_applications');
288: fnd_message.raise_error;
289: End If;
290: Close C_Sel2;
291: --

Line 368: (p_module_name => 'HR_KI_EXT_APPLICATIONS'

364: --
365: when hr_api.cannot_find_prog_unit then
366: --
367: hr_api.cannot_find_prog_unit_error
368: (p_module_name => 'HR_KI_EXT_APPLICATIONS'
369: ,p_hook_type => 'AI');
370: --
371: end;
372: --