APPS.HR_CLE_INS dependencies on HR_CLE_INS

Line 1: Package Body hr_cle_ins as

1: Package Body hr_cle_ins as
2: /* $Header: hrclerhi.pkb 115.6 2002/12/03 09:27:16 hjonnala noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' hr_cle_ins.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hr_cle_ins.'; -- Global package name
9: --
10: -- The following global variables are only to be used by
11: -- the set_base_key_value and pre_insert procedures.
12: --

Line 26: hr_cle_ins.g_soc_ins_contr_lvls_id_i := p_soc_ins_contr_lvls_id;

22: --
23: Begin
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: hr_cle_ins.g_soc_ins_contr_lvls_id_i := p_soc_ins_contr_lvls_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --

Line 314: hr_cle_ins.dt_insert_dml

310: --
311: Begin
312: hr_utility.set_location('Entering:'||l_proc, 5);
313: --
314: hr_cle_ins.dt_insert_dml
315: (p_rec => p_rec
316: ,p_effective_date => p_effective_date
317: ,p_datetrack_mode => p_datetrack_mode
318: ,p_validation_start_date => p_validation_start_date

Line 378: hr_cle_ins.g_soc_ins_contr_lvls_id_i;

374: Cursor C_Sel2 is
375: Select null
376: from hr_de_soc_ins_contr_lvls_f
377: where soc_ins_contr_lvls_id =
378: hr_cle_ins.g_soc_ins_contr_lvls_id_i;
379: --
380: l_proc varchar2(72) := g_package||'pre_insert';
381: l_exists varchar2(1);
382: --

Line 386: If (hr_cle_ins.g_soc_ins_contr_lvls_id_i is not null) Then

382: --
383: Begin
384: hr_utility.set_location('Entering:'||l_proc, 5);
385: --
386: If (hr_cle_ins.g_soc_ins_contr_lvls_id_i is not null) Then
387: --
388: -- Verify registered primary key values not already in use
389: --
390: Open C_Sel2;

Line 406: hr_cle_ins.g_soc_ins_contr_lvls_id_i;

402: --
403: -- Use registered key values and clear globals
404: --
405: p_rec.soc_ins_contr_lvls_id :=
406: hr_cle_ins.g_soc_ins_contr_lvls_id_i;
407: hr_cle_ins.g_soc_ins_contr_lvls_id_i := null;
408: Else
409: --
410: -- No registerd key values, so select the next sequence number

Line 407: hr_cle_ins.g_soc_ins_contr_lvls_id_i := null;

403: -- Use registered key values and clear globals
404: --
405: p_rec.soc_ins_contr_lvls_id :=
406: hr_cle_ins.g_soc_ins_contr_lvls_id_i;
407: hr_cle_ins.g_soc_ins_contr_lvls_id_i := null;
408: Else
409: --
410: -- No registerd key values, so select the next sequence number
411: --

Line 692: hr_cle_ins.ins_lck

688: hr_utility.set_location('Entering:'||l_proc, 5);
689: --
690: -- Call the lock operation
691: --
692: hr_cle_ins.ins_lck
693: (p_effective_date => p_effective_date
694: ,p_datetrack_mode => l_datetrack_mode
695: ,p_rec => p_rec
696: ,p_validation_start_date => l_validation_start_date

Line 712: hr_cle_ins.pre_insert

708: );
709: --
710: -- Call the supporting pre-insert operation
711: --
712: hr_cle_ins.pre_insert
713: (p_rec => p_rec
714: ,p_effective_date => p_effective_date
715: ,p_datetrack_mode => l_datetrack_mode
716: ,p_validation_start_date => l_validation_start_date

Line 722: hr_cle_ins.insert_dml

718: );
719: --
720: -- Insert the row
721: --
722: hr_cle_ins.insert_dml
723: (p_rec => p_rec
724: ,p_effective_date => p_effective_date
725: ,p_datetrack_mode => l_datetrack_mode
726: ,p_validation_start_date => l_validation_start_date

Line 732: hr_cle_ins.post_insert

728: );
729: --
730: -- Call the supporting post-insert operation
731: --
732: hr_cle_ins.post_insert
733: (p_rec => p_rec
734: ,p_effective_date => p_effective_date
735: ,p_datetrack_mode => l_datetrack_mode
736: ,p_validation_start_date => l_validation_start_date

Line 875: hr_cle_ins.ins

871: -- Having converted the arguments into the hr_cle_rec
872: -- plsql record structure we call the corresponding record
873: -- business process.
874: --
875: hr_cle_ins.ins
876: (p_effective_date
877: ,l_rec
878: );
879: --

Line 891: end hr_cle_ins;

887: --
888: hr_utility.set_location(' Leaving:'||l_proc, 10);
889: End ins;
890: --
891: end hr_cle_ins;