DBA Data[Home] [Help]

APPS.HR_INT_INS dependencies on HR_KI_INTEGRATIONS

Line 87: -- Insert the row into: hr_ki_integrations

83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: --
86: --
87: -- Insert the row into: hr_ki_integrations
88: --
89: insert into hr_ki_integrations
90: (integration_id
91: ,integration_key

Line 89: insert into hr_ki_integrations

85: --
86: --
87: -- Insert the row into: hr_ki_integrations
88: --
89: insert into hr_ki_integrations
90: (integration_id
91: ,integration_key
92: ,party_type
93: ,party_name

Line 239: Cursor C_Sel1 is select hr_ki_integrations_s.nextval from sys.dual;

235: Procedure pre_insert
236: (p_rec in out nocopy hr_int_shd.g_rec_type
237: ) is
238: --
239: Cursor C_Sel1 is select hr_ki_integrations_s.nextval from sys.dual;
240: --
241: Cursor C_Sel2 is
242: Select null
243: from hr_ki_integrations

Line 243: from hr_ki_integrations

239: Cursor C_Sel1 is select hr_ki_integrations_s.nextval from sys.dual;
240: --
241: Cursor C_Sel2 is
242: Select null
243: from hr_ki_integrations
244: where integration_id =
245: hr_int_ins.g_integration_id_i;
246: --
247: l_proc varchar2(72) := g_package||'pre_insert';

Line 265: fnd_message.set_token('TABLE_NAME','hr_ki_integrations');

261: --
262: -- The primary key values are already in use.
263: --
264: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
265: fnd_message.set_token('TABLE_NAME','hr_ki_integrations');
266: fnd_message.raise_error;
267: End If;
268: Close C_Sel2;
269: --

Line 420: (p_module_name => 'HR_KI_INTEGRATIONS'

416: --
417: when hr_api.cannot_find_prog_unit then
418: --
419: hr_api.cannot_find_prog_unit_error
420: (p_module_name => 'HR_KI_INTEGRATIONS'
421: ,p_hook_type => 'AI');
422: --
423: end;
424: --