54: --
55: l_proc varchar2(72) := g_package||'insert_dml';
56: --
57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: p_rec.object_version_number := 1; -- Initialise the object version
60: --
61: -- Insert the row into: ghr_pa_request_extra_info
62: --
184: p_rec.program_id,
185: p_rec.program_update_date
186: );
187: --
188: hr_utility.set_location(' Leaving:'||l_proc, 10);
189: Exception
190: When hr_api.check_integrity_violated Then
191: -- A check constraint has been violated
192: ghr_rei_shd.constraint_error
247: --
248: --
249: --
250: Begin
251: hr_utility.set_location('Entering:'||l_proc, 5);
252: --
253: --
254: -- Select the next sequence number
255: --
256: Open C_Sel1;
257: Fetch C_Sel1 Into p_rec.pa_request_extra_info_id;
258: Close C_Sel1;
259: --
260: hr_utility.set_location(' Leaving:'||l_proc, 10);
261: End pre_insert;
262: --
263: -- ----------------------------------------------------------------------------
264: -- |-----------------------------< post_insert >------------------------------|
296: --
297: l_proc varchar2(72) := g_package||'post_insert';
298: --
299: Begin
300: hr_utility.set_location('Entering:'||l_proc, 5);
301: --
302: -- This is a hook point and the user hook for post_insert is called here.
303: --
304: begin
370: ,p_hook_type => 'AI'
371: );
372: end;
373: -- End of API User Hook for post_insert.
374: hr_utility.set_location(' Leaving:'||l_proc, 10);
375: End post_insert;
376: --
377: -- ----------------------------------------------------------------------------
378: -- |---------------------------------< ins >----------------------------------|
385: --
386: l_proc varchar2(72) := g_package||'ins';
387: --
388: Begin
389: hr_utility.set_location('Entering:'||l_proc, 5);
390: --
391: -- Determine if the business process is to be validated.
392: --
393: If p_validate then
418: If p_validate then
419: Raise HR_Api.Validate_Enabled;
420: End If;
421: --
422: hr_utility.set_location(' Leaving:'||l_proc, 10);
423: Exception
424: When HR_Api.Validate_Enabled Then
425: --
426: -- As the Validate_Enabled exception has been raised
500: l_rec ghr_rei_shd.g_rec_type;
501: l_proc varchar2(72) := g_package||'ins';
502: --
503: Begin
504: hr_utility.set_location('Entering:'||l_proc, 5);
505: --
506: -- Call conversion function to turn arguments into the
507: -- p_rec structure.
508: --
581: --
582: p_pa_request_extra_info_id := l_rec.pa_request_extra_info_id;
583: p_object_version_number := l_rec.object_version_number;
584: --
585: hr_utility.set_location(' Leaving:'||l_proc, 10);
586: End ins;
587: --
588: end ghr_rei_ins;