DBA Data[Home] [Help]

APPS.PAY_PEL_INS dependencies on PAY_PEL_INS

Line 1: Package Body pay_pel_ins as

1: Package Body pay_pel_ins as
2: /* $Header: pypelrhi.pkb 120.8 2008/02/06 11:17:40 salogana noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pay_pel_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: pay_pel_ins.g_element_link_id_i := p_element_link_id;

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

Line 302: pay_pel_ins.dt_insert_dml

298: --
299: Begin
300: hr_utility.set_location('Entering:'||l_proc, 5);
301: --
302: pay_pel_ins.dt_insert_dml
303: (p_rec => p_rec
304: ,p_effective_date => p_effective_date
305: ,p_datetrack_mode => p_datetrack_mode
306: ,p_validation_start_date => p_validation_start_date

Line 366: pay_pel_ins.g_element_link_id_i;

362: Cursor C_Sel2 is
363: Select null
364: from pay_element_links_f
365: where element_link_id =
366: pay_pel_ins.g_element_link_id_i;
367: --
368: l_proc varchar2(72) := g_package||'pre_insert';
369: l_exists varchar2(1);
370: --

Line 374: If (pay_pel_ins.g_element_link_id_i is not null) Then

370: --
371: Begin
372: hr_utility.set_location('Entering:'||l_proc, 5);
373: --
374: If (pay_pel_ins.g_element_link_id_i is not null) Then
375: --
376: -- Verify registered primary key values not already in use
377: --
378: Open C_Sel2;

Line 394: pay_pel_ins.g_element_link_id_i;

390: --
391: -- Use registered key values and clear globals
392: --
393: p_rec.element_link_id :=
394: pay_pel_ins.g_element_link_id_i;
395: pay_pel_ins.g_element_link_id_i := null;
396: Else
397: --
398: -- No registerd key values, so select the next sequence number

Line 395: pay_pel_ins.g_element_link_id_i := null;

391: -- Use registered key values and clear globals
392: --
393: p_rec.element_link_id :=
394: pay_pel_ins.g_element_link_id_i;
395: pay_pel_ins.g_element_link_id_i := null;
396: Else
397: --
398: -- No registerd key values, so select the next sequence number
399: --

Line 685: pay_pel_ins.ins_lck

681: hr_utility.set_location('Entering:'||l_proc, 5);
682: --
683: -- Call the lock operation
684: --
685: pay_pel_ins.ins_lck
686: (p_effective_date => p_effective_date
687: ,p_datetrack_mode => l_datetrack_mode
688: ,p_rec => p_rec
689: ,p_validation_start_date => l_validation_start_date

Line 753: pay_pel_ins.pre_insert

749: hr_multi_message.end_validation_set;
750: --
751: -- Call the supporting pre-insert operation
752: --
753: pay_pel_ins.pre_insert
754: (p_rec => p_rec
755: ,p_effective_date => p_effective_date
756: ,p_datetrack_mode => l_datetrack_mode
757: ,p_validation_start_date => l_validation_start_date

Line 769: pay_pel_ins.insert_dml

765: elsif p_rec.costable_type in ('N','F') then
766: p_rec.transfer_to_gl_flag := nvl(p_rec.transfer_to_gl_flag,'Y');
767: end if;
768:
769: pay_pel_ins.insert_dml
770: (p_rec => p_rec
771: ,p_effective_date => p_effective_date
772: ,p_datetrack_mode => l_datetrack_mode
773: ,p_validation_start_date => l_validation_start_date

Line 779: pay_pel_ins.post_insert

775: );
776: --
777: -- Call the supporting post-insert operation
778: --
779: pay_pel_ins.post_insert
780: (p_rec => p_rec
781: ,p_effective_date => p_effective_date
782: ,p_datetrack_mode => l_datetrack_mode
783: ,p_validation_start_date => l_validation_start_date

Line 915: pay_pel_ins.ins

911: -- Having converted the arguments into the pay_pel_rec
912: -- plsql record structure we call the corresponding record
913: -- business process.
914: --
915: pay_pel_ins.ins
916: (p_effective_date
917: ,l_rec
918: );
919: --

Line 931: end pay_pel_ins;

927: --
928: hr_utility.set_location(' Leaving:'||l_proc, 10);
929: End ins;
930: --
931: end pay_pel_ins;