APPS.PAY_PSD_INS dependencies on PAY_PSD_INS

Line 1: Package Body pay_psd_ins as

1: Package Body pay_psd_ins as
2: /* $Header: pypsdrhi.pkb 120.1 2005/12/08 05:08 ssekhar noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pay_psd_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_psd_ins.g_sii_details_id_i := p_sii_details_id;

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

Line 260: pay_psd_ins.dt_insert_dml

256: --
257: Begin
258: hr_utility.set_location('Entering:'||l_proc, 5);
259: --
260: pay_psd_ins.dt_insert_dml
261: (p_rec => p_rec
262: ,p_effective_date => p_effective_date
263: ,p_datetrack_mode => p_datetrack_mode
264: ,p_validation_start_date => p_validation_start_date

Line 324: pay_psd_ins.g_sii_details_id_i;

320: Cursor C_Sel2 is
321: Select null
322: from pay_pl_sii_details_f
323: where sii_details_id =
324: pay_psd_ins.g_sii_details_id_i;
325: --
326: l_proc varchar2(72) := g_package||'pre_insert';
327: l_exists varchar2(1);
328: --

Line 332: If (pay_psd_ins.g_sii_details_id_i is not null) Then

328: --
329: Begin
330: hr_utility.set_location('Entering:'||l_proc, 5);
331: --
332: If (pay_psd_ins.g_sii_details_id_i is not null) Then
333: --
334: -- Verify registered primary key values not already in use
335: --
336: Open C_Sel2;

Line 352: pay_psd_ins.g_sii_details_id_i;

348: --
349: -- Use registered key values and clear globals
350: --
351: p_rec.sii_details_id :=
352: pay_psd_ins.g_sii_details_id_i;
353: pay_psd_ins.g_sii_details_id_i := null;
354: Else
355: --
356: -- No registerd key values, so select the next sequence number

Line 353: pay_psd_ins.g_sii_details_id_i := null;

349: -- Use registered key values and clear globals
350: --
351: p_rec.sii_details_id :=
352: pay_psd_ins.g_sii_details_id_i;
353: pay_psd_ins.g_sii_details_id_i := null;
354: Else
355: --
356: -- No registerd key values, so select the next sequence number
357: --

Line 615: pay_psd_ins.ins_lck

611: hr_utility.set_location('Entering:'||l_proc, 5);
612: --
613: -- Call the lock operation
614: --
615: pay_psd_ins.ins_lck
616: (p_effective_date => p_effective_date
617: ,p_datetrack_mode => l_datetrack_mode
618: ,p_rec => p_rec
619: ,p_validation_start_date => l_validation_start_date

Line 638: pay_psd_ins.pre_insert

634: hr_multi_message.end_validation_set;
635: --
636: -- Call the supporting pre-insert operation
637: --
638: pay_psd_ins.pre_insert
639: (p_rec => p_rec
640: ,p_effective_date => p_effective_date
641: ,p_datetrack_mode => l_datetrack_mode
642: ,p_validation_start_date => l_validation_start_date

Line 648: pay_psd_ins.insert_dml

644: );
645: --
646: -- Insert the row
647: --
648: pay_psd_ins.insert_dml
649: (p_rec => p_rec
650: ,p_effective_date => p_effective_date
651: ,p_datetrack_mode => l_datetrack_mode
652: ,p_validation_start_date => l_validation_start_date

Line 658: pay_psd_ins.post_insert

654: );
655: --
656: -- Call the supporting post-insert operation
657: --
658: pay_psd_ins.post_insert
659: (p_rec => p_rec
660: ,p_effective_date => p_effective_date
661: ,p_datetrack_mode => l_datetrack_mode
662: ,p_validation_start_date => l_validation_start_date

Line 748: pay_psd_ins.ins

744: -- Having converted the arguments into the pay_psd_rec
745: -- plsql record structure we call the corresponding record
746: -- business process.
747: --
748: pay_psd_ins.ins
749: (p_effective_date
750: ,l_rec
751: );
752: --

Line 764: end pay_psd_ins;

760: --
761: hr_utility.set_location(' Leaving:'||l_proc, 10);
762: End ins;
763: --
764: end pay_psd_ins;