DBA Data[Home] [Help]

APPS.PAY_PPR_INS dependencies on PAY_PPR_INS

Line 1: Package Body pay_ppr_ins as

1: Package Body pay_ppr_ins as
2: /* $Header: pypprrhi.pkb 115.3 2004/02/25 21:33 adkumar noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pay_ppr_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_ppr_ins.g_status_processing_rule_id_i := p_status_processing_rule_id;

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

Line 280: pay_ppr_ins.dt_insert_dml

276: --
277: Begin
278: hr_utility.set_location('Entering:'||l_proc, 5);
279: --
280: pay_ppr_ins.dt_insert_dml
281: (p_rec => p_rec
282: ,p_effective_date => p_effective_date
283: ,p_datetrack_mode => p_datetrack_mode
284: ,p_validation_start_date => p_validation_start_date

Line 344: pay_ppr_ins.g_status_processing_rule_id_i;

340: Cursor C_Sel2 is
341: Select null
342: from pay_status_processing_rules_f
343: where status_processing_rule_id =
344: pay_ppr_ins.g_status_processing_rule_id_i;
345: --
346: l_proc varchar2(72) := g_package||'pre_insert';
347: l_exists varchar2(1);
348:

Line 353: If (pay_ppr_ins.g_status_processing_rule_id_i is not null) Then

349: --
350: Begin
351: hr_utility.set_location('Entering:'||l_proc, 5);
352: --
353: If (pay_ppr_ins.g_status_processing_rule_id_i is not null) Then
354: --
355: -- Verify registered primary key values not already in use
356: --
357: Open C_Sel2;

Line 373: pay_ppr_ins.g_status_processing_rule_id_i;

369: --
370: -- Use registered key values and clear globals
371: --
372: p_rec.status_processing_rule_id :=
373: pay_ppr_ins.g_status_processing_rule_id_i;
374: pay_ppr_ins.g_status_processing_rule_id_i := null;
375: Else
376: --
377: -- No registerd key values, so select the next sequence number

Line 374: pay_ppr_ins.g_status_processing_rule_id_i := null;

370: -- Use registered key values and clear globals
371: --
372: p_rec.status_processing_rule_id :=
373: pay_ppr_ins.g_status_processing_rule_id_i;
374: pay_ppr_ins.g_status_processing_rule_id_i := null;
375: Else
376: --
377: -- No registerd key values, so select the next sequence number
378: --

Line 582: pay_ppr_ins.ins_lck

578: hr_utility.set_location('Entering:'||l_proc, 5);
579: --
580: -- Call the lock operation
581: --
582: pay_ppr_ins.ins_lck
583: (p_effective_date => p_effective_date
584: ,p_datetrack_mode => l_datetrack_mode
585: ,p_rec => p_rec
586: ,p_validation_start_date => l_validation_start_date

Line 627: pay_ppr_ins.pre_insert

623: hr_multi_message.end_validation_set;
624: --
625: -- Call the supporting pre-insert operation
626: --
627: pay_ppr_ins.pre_insert
628: (p_rec => p_rec
629: ,p_effective_date => p_effective_date
630: ,p_datetrack_mode => l_datetrack_mode
631: ,p_validation_start_date => l_validation_start_date

Line 637: pay_ppr_ins.insert_dml

633: );
634: --
635: -- Insert the row
636: --
637: pay_ppr_ins.insert_dml
638: (p_rec => p_rec
639: ,p_effective_date => p_effective_date
640: ,p_datetrack_mode => l_datetrack_mode
641: ,p_validation_start_date => l_validation_start_date

Line 647: pay_ppr_ins.post_insert

643: );
644: --
645: -- Call the supporting post-insert operation
646: --
647: pay_ppr_ins.post_insert
648: (p_rec => p_rec
649: ,p_effective_date => p_effective_date
650: ,p_datetrack_mode => l_datetrack_mode
651: ,p_validation_start_date => l_validation_start_date

Line 713: pay_ppr_ins.ins

709: -- Having converted the arguments into the pay_ppr_rec
710: -- plsql record structure we call the corresponding record
711: -- business process.
712: --
713: pay_ppr_ins.ins
714: (p_effective_date
715: ,l_rec
716: ,l_formula_mismatch_warning
717: );

Line 731: end pay_ppr_ins;

727: --
728: hr_utility.set_location(' Leaving:'||l_proc, 10);
729: End ins;
730: --
731: end pay_ppr_ins;