APPS.HR_PDE_INS dependencies on HR_PERSON_DEPLYMT_EITS

Line 87: -- Insert the row into: hr_person_deplymt_eits

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

Line 89: insert into hr_person_deplymt_eits

85: --
86: --
87: -- Insert the row into: hr_person_deplymt_eits
88: --
89: insert into hr_person_deplymt_eits
90: (person_deplymt_eit_id
91: ,person_deployment_id
92: ,person_extra_info_id
93: ,object_version_number

Line 167: Cursor C_Sel1 is select hr_person_deplymt_eits_s.nextval from sys.dual;

163: Procedure pre_insert
164: (p_rec in out nocopy hr_pde_shd.g_rec_type
165: ) is
166: --
167: Cursor C_Sel1 is select hr_person_deplymt_eits_s.nextval from sys.dual;
168: --
169: Cursor C_Sel2 is
170: Select null
171: from hr_person_deplymt_eits

Line 171: from hr_person_deplymt_eits

167: Cursor C_Sel1 is select hr_person_deplymt_eits_s.nextval from sys.dual;
168: --
169: Cursor C_Sel2 is
170: Select null
171: from hr_person_deplymt_eits
172: where person_deplymt_eit_id =
173: hr_pde_ins.g_person_deplymt_eit_id_i;
174: --
175: l_proc varchar2(72) := g_package||'pre_insert';

Line 193: fnd_message.set_token('TABLE_NAME','hr_person_deplymt_eits');

189: --
190: -- The primary key values are already in use.
191: --
192: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
193: fnd_message.set_token('TABLE_NAME','hr_person_deplymt_eits');
194: fnd_message.raise_error;
195: End If;
196: Close C_Sel2;
197: --

Line 276: (p_module_name => 'HR_PERSON_DEPLYMT_EITS'

272: --
273: when hr_api.cannot_find_prog_unit then
274: --
275: hr_api.cannot_find_prog_unit_error
276: (p_module_name => 'HR_PERSON_DEPLYMT_EITS'
277: ,p_hook_type => 'AI');
278: --
279: end;
280: --