56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: --
59: Begin
60: hr_utility.set_location('Entering:'||l_proc, 5);
61: --
62: --
63: --
64: --
86: );
87: --
88: --
89: --
90: hr_utility.set_location(' Leaving:'||l_proc, 10);
91: Exception
92: When hr_api.check_integrity_violated Then
93: -- A check constraint has been violated
94: --
153: --
154: l_proc varchar2(72) := g_package||'pre_insert';
155: --
156: Begin
157: hr_utility.set_location('Entering:'||l_proc, 5);
158: --
159: p_rec.item_property_id := p_item_property_id;
160: --
161: hr_utility.set_location(' Leaving:'||l_proc, 10);
157: hr_utility.set_location('Entering:'||l_proc, 5);
158: --
159: p_rec.item_property_id := p_item_property_id;
160: --
161: hr_utility.set_location(' Leaving:'||l_proc, 10);
162: End pre_insert;
163: --
164: -- ----------------------------------------------------------------------------
165: -- |-----------------------------< post_insert >------------------------------|
199: --
200: l_proc varchar2(72) := g_package||'post_insert';
201: --
202: Begin
203: hr_utility.set_location('Entering:'||l_proc, 5);
204: begin
205: --
206: hr_ipt_rki.after_insert
207: (p_item_property_id
231: ,p_hook_type => 'AI');
232: --
233: end;
234: --
235: hr_utility.set_location(' Leaving:'||l_proc, 10);
236: End post_insert;
237: --
238: -- ----------------------------------------------------------------------------
239: -- |---------------------------------< ins >----------------------------------|
245: --
246: l_proc varchar2(72) := g_package||'ins';
247: --
248: Begin
249: hr_utility.set_location('Entering:'||l_proc, 5);
250: --
251: -- Call the supporting insert validate operations
252: --
253: hr_ipt_bus.insert_validate
271: hr_ipt_ins.post_insert
272: (p_rec
273: );
274: --
275: hr_utility.set_location('Leaving:'||l_proc, 20);
276: end ins;
277: --
278: -- ----------------------------------------------------------------------------
279: -- |---------------------------------< ins >----------------------------------|
292: l_rec hr_ipt_shd.g_rec_type;
293: l_proc varchar2(72) := g_package||'ins';
294: --
295: Begin
296: hr_utility.set_location('Entering:'||l_proc, 5);
297: --
298: -- Call conversion function to turn arguments into the
299: -- p_rec structure.
300: --
322: -- are specified as an OUT's we must set these values.
323: --
324: --
325: --
326: hr_utility.set_location(' Leaving:'||l_proc, 10);
327: End ins;
328: --
329: -- ----------------------------------------------------------------------------
330: -- |------------------------------< ins_tl >----------------------------------|
352: --
353: l_proc varchar2(72) := g_package || 'ins_tl';
354: --
355: Begin
356: hr_utility.set_location('Entering:'||l_proc,10);
357: --
358: -- Insert a row for the base language and every installed language.
359: --
360: for l_lang in csr_ins_langs loop
369: ,p_tooltip_text => p_tooltip_text
370: );
371: end loop;
372: --
373: hr_utility.set_location('Leaving:'||l_proc,20);
374: End ins_tl;
375: --
376: end hr_ipt_ins;