DBA Data[Home] [Help]

APPS.GHR_CCA_INS dependencies on HR_UTILITY

Line 24: hr_utility.set_location('Entering:'||l_proc, 10);

20: --
21: l_proc varchar2(72) := g_package||'set_base_key_value';
22: --
23: Begin
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: ghr_cca_ins.g_compl_appeal_id_i := p_compl_appeal_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 28: hr_utility.set_location(' Leaving:'||l_proc, 20);

24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: ghr_cca_ins.g_compl_appeal_id_i := p_compl_appeal_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --
31: --
32: -- ----------------------------------------------------------------------------

Line 82: hr_utility.set_location('Entering:'||l_proc, 5);

78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --
81: Begin
82: hr_utility.set_location('Entering:'||l_proc, 5);
83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: --
86: --

Line 162: hr_utility.set_location(' Leaving:'||l_proc, 10);

158: );
159: --
160: --
161: --
162: hr_utility.set_location(' Leaving:'||l_proc, 10);
163: Exception
164: When hr_api.check_integrity_violated Then
165: -- A check constraint has been violated
166: --

Line 237: hr_utility.set_location('Entering:'||l_proc, 5);

233: l_proc varchar2(72) := g_package||'pre_insert';
234: l_exists varchar2(1);
235: --
236: Begin
237: hr_utility.set_location('Entering:'||l_proc, 5);
238: --
239: If (ghr_cca_ins.g_compl_appeal_id_i is not null) Then
240: --
241: -- Verify registered primary key values not already in use

Line 273: hr_utility.set_location(' Leaving:'||l_proc, 10);

269: Fetch C_Sel1 Into p_rec.compl_appeal_id;
270: Close C_Sel1;
271: End If;
272: --
273: hr_utility.set_location(' Leaving:'||l_proc, 10);
274: End pre_insert;
275: --
276: -- ----------------------------------------------------------------------------
277: -- |-----------------------------< post_insert >------------------------------|

Line 316: hr_utility.set_location('Entering:'||l_proc, 5);

312: --
313: l_proc varchar2(72) := g_package||'post_insert';
314: --
315: Begin
316: hr_utility.set_location('Entering:'||l_proc, 5);
317: begin
318: --
319: ghr_cca_rki.after_insert
320: (p_effective_date => p_effective_date

Line 366: hr_utility.set_location(' Leaving:'||l_proc, 10);

362: ,p_hook_type => 'AI');
363: --
364: end;
365: --
366: hr_utility.set_location(' Leaving:'||l_proc, 10);
367: End post_insert;
368: --
369: -- ----------------------------------------------------------------------------
370: -- |---------------------------------< ins >----------------------------------|

Line 380: hr_utility.set_location('Entering:'||l_proc, 5);

376: --
377: l_proc varchar2(72) := g_package||'ins';
378: --
379: Begin
380: hr_utility.set_location('Entering:'||l_proc, 5);
381: --
382: -- Call the supporting insert validate operations
383: --
384: ghr_cca_bus.insert_validate

Line 404: hr_utility.set_location('Leaving:'||l_proc, 20);

400: (p_effective_date
401: ,p_rec
402: );
403: --
404: hr_utility.set_location('Leaving:'||l_proc, 20);
405: end ins;
406: --
407: -- ----------------------------------------------------------------------------
408: -- |---------------------------------< ins >----------------------------------|

Line 451: hr_utility.set_location('Entering:'||l_proc, 5);

447: l_rec ghr_cca_shd.g_rec_type;
448: l_proc varchar2(72) := g_package||'ins';
449: --
450: Begin
451: hr_utility.set_location('Entering:'||l_proc, 5);
452: --
453: -- Call conversion function to turn arguments into the
454: -- p_rec structure.
455: --

Line 507: hr_utility.set_location(' Leaving:'||l_proc, 10);

503: --
504: p_compl_appeal_id := l_rec.compl_appeal_id;
505: p_object_version_number := l_rec.object_version_number;
506: --
507: hr_utility.set_location(' Leaving:'||l_proc, 10);
508: End ins;
509: --
510: end ghr_cca_ins;