APPS.HR_PDT_INS dependencies on HR_PERSON_DEPLOYMENTS

Line 87: -- Insert the row into: hr_person_deployments

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

Line 89: insert into hr_person_deployments

85: --
86: --
87: -- Insert the row into: hr_person_deployments
88: --
89: insert into hr_person_deployments
90: (person_deployment_id
91: ,object_version_number
92: ,from_business_group_id
93: ,to_business_group_id

Line 289: Cursor C_Sel1 is select hr_person_deployments_s.nextval from sys.dual;

285: Procedure pre_insert
286: (p_rec in out nocopy hr_pdt_shd.g_rec_type
287: ) is
288: --
289: Cursor C_Sel1 is select hr_person_deployments_s.nextval from sys.dual;
290: --
291: Cursor C_Sel2 is
292: Select null
293: from hr_person_deployments

Line 293: from hr_person_deployments

289: Cursor C_Sel1 is select hr_person_deployments_s.nextval from sys.dual;
290: --
291: Cursor C_Sel2 is
292: Select null
293: from hr_person_deployments
294: where person_deployment_id =
295: hr_pdt_ins.g_person_deployment_id_i;
296: --
297: l_proc varchar2(72) := g_package||'pre_insert';

Line 315: fnd_message.set_token('TABLE_NAME','hr_person_deployments');

311: --
312: -- The primary key values are already in use.
313: --
314: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
315: fnd_message.set_token('TABLE_NAME','hr_person_deployments');
316: fnd_message.raise_error;
317: End If;
318: Close C_Sel2;
319: --

Line 520: (p_module_name => 'HR_PERSON_DEPLOYMENTS'

516: --
517: when hr_api.cannot_find_prog_unit then
518: --
519: hr_api.cannot_find_prog_unit_error
520: (p_module_name => 'HR_PERSON_DEPLOYMENTS'
521: ,p_hook_type => 'AI');
522: --
523: end;
524: --