DBA Data[Home] [Help]

APPS.PAY_OPM_INS dependencies on PAY_OPM_INS

Line 1: Package Body pay_opm_ins as

1: Package Body pay_opm_ins as
2: /* $Header: pyopmrhi.pkb 120.4 2005/11/07 01:38:13 pgongada noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pay_opm_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_opm_ins.g_org_payment_method_id_i := p_org_payment_method_id;

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

Line 321: pay_opm_ins.dt_insert_dml

317: --
318: Begin
319: hr_utility.set_location('Entering:'||l_proc, 5);
320: --
321: pay_opm_ins.dt_insert_dml
322: (p_rec => p_rec
323: ,p_effective_date => p_effective_date
324: ,p_datetrack_mode => p_datetrack_mode
325: ,p_validation_start_date => p_validation_start_date

Line 385: pay_opm_ins.g_org_payment_method_id_i;

381: Cursor C_Sel2 is
382: Select null
383: from pay_org_payment_methods_f
384: where org_payment_method_id =
385: pay_opm_ins.g_org_payment_method_id_i;
386: --
387: l_proc varchar2(72) := g_package||'pre_insert';
388: l_exists varchar2(1);
389:

Line 393: If (pay_opm_ins.g_org_payment_method_id_i is not null ) Then

389:
390: Begin
391: hr_utility.set_location('Entering:'||l_proc, 5);
392: --
393: If (pay_opm_ins.g_org_payment_method_id_i is not null ) Then
394: --
395: -- Verify registered primary key values not already in use
396: --
397: Open C_Sel2;

Line 412: p_rec.org_payment_method_id := pay_opm_ins.g_org_payment_method_id_i;

408: Close C_Sel2;
409: --
410: -- Use registered key values and clear globals
411: --
412: p_rec.org_payment_method_id := pay_opm_ins.g_org_payment_method_id_i;
413:
414: pay_opm_ins.g_org_payment_method_id_i := null;
415:
416: Else

Line 414: pay_opm_ins.g_org_payment_method_id_i := null;

410: -- Use registered key values and clear globals
411: --
412: p_rec.org_payment_method_id := pay_opm_ins.g_org_payment_method_id_i;
413:
414: pay_opm_ins.g_org_payment_method_id_i := null;
415:
416: Else
417: --
418: -- No registerd key values, so select the next sequence number

Line 717: pay_opm_ins.ins_lck

713: hr_utility.set_location('Entering:'||l_proc, 5);
714: --
715: -- Call the lock operation
716: --
717: pay_opm_ins.ins_lck
718: (p_effective_date => p_effective_date
719: ,p_datetrack_mode => l_datetrack_mode
720: ,p_rec => p_rec
721: ,p_validation_start_date => l_validation_start_date

Line 737: pay_opm_ins.pre_insert

733: );
734: --
735: -- Call the supporting pre-insert operation
736: --
737: pay_opm_ins.pre_insert
738: (p_rec => p_rec
739: ,p_effective_date => p_effective_date
740: ,p_datetrack_mode => l_datetrack_mode
741: ,p_validation_start_date => l_validation_start_date

Line 747: pay_opm_ins.insert_dml

743: );
744: --
745: -- Insert the row
746: --
747: pay_opm_ins.insert_dml
748: (p_rec => p_rec
749: ,p_effective_date => p_effective_date
750: ,p_datetrack_mode => l_datetrack_mode
751: ,p_validation_start_date => l_validation_start_date

Line 757: pay_opm_ins.post_insert

753: );
754: --
755: -- Call the supporting post-insert operation
756: --
757: pay_opm_ins.post_insert
758: (p_rec => p_rec
759: ,p_effective_date => p_effective_date
760: ,p_datetrack_mode => l_datetrack_mode
761: ,p_validation_start_date => l_validation_start_date

Line 910: pay_opm_ins.ins

906: -- Having converted the arguments into the pay_opm_rec
907: -- plsql record structure we call the corresponding record
908: -- business process.
909: --
910: pay_opm_ins.ins
911: (p_effective_date
912: ,l_rec
913: );
914: --

Line 926: end pay_opm_ins;

922: --
923: hr_utility.set_location(' Leaving:'||l_proc, 10);
924: End ins;
925: --
926: end pay_opm_ins;