eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_BENEFIT_PRVDD_LEDGER_API dependencies on HR_API

Line 290: when hr_api.cannot_find_prog_unit then

286: p_ann_used_val => l_ann_used_val,
287: p_ann_cash_recd_val => l_ann_cash_recd_val
288: );
289: exception
290: when hr_api.cannot_find_prog_unit then
291: hr_api.cannot_find_prog_unit_error
292: (
293: p_module_name => 'CREATE_Benefit_Prvdd_Ledger'
294: ,p_hook_type => 'BP'

Line 291: hr_api.cannot_find_prog_unit_error

287: p_ann_cash_recd_val => l_ann_cash_recd_val
288: );
289: exception
290: when hr_api.cannot_find_prog_unit then
291: hr_api.cannot_find_prog_unit_error
292: (
293: p_module_name => 'CREATE_Benefit_Prvdd_Ledger'
294: ,p_hook_type => 'BP'
295: );

Line 374: p_datetrack_mode => hr_api.g_update,

370: p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,
371: p_person_id => p_person_id,
372: p_per_in_ler_id => p_per_in_ler_id,
373: p_effective_date => p_effective_date,
374: p_datetrack_mode => hr_api.g_update,
375: p_acty_base_rt_id => p_acty_base_rt_id,
376: p_rlovr_amt => p_used_val,
377: p_old_rlovr_amt => 0, -- Creation so old value is 0.
378: p_business_group_id => p_business_group_id,

Line 500: when hr_api.cannot_find_prog_unit then

496: p_ann_used_val => l_ann_used_val,
497: p_ann_cash_recd_val => l_ann_cash_recd_val
498: );
499: exception
500: when hr_api.cannot_find_prog_unit then
501: hr_api.cannot_find_prog_unit_error
502: (p_module_name => 'CREATE_Benefit_Prvdd_Ledger'
503: ,p_hook_type => 'AP'
504: );

Line 501: hr_api.cannot_find_prog_unit_error

497: p_ann_cash_recd_val => l_ann_cash_recd_val
498: );
499: exception
500: when hr_api.cannot_find_prog_unit then
501: hr_api.cannot_find_prog_unit_error
502: (p_module_name => 'CREATE_Benefit_Prvdd_Ledger'
503: ,p_hook_type => 'AP'
504: );
505: --

Line 515: raise hr_api.validate_enabled;

511: --
512: -- When in validation only mode raise the Validate_Enabled exception
513: --
514: if p_validate then
515: raise hr_api.validate_enabled;
516: end if;
517: --
518: -- Set all output arguments
519: --

Line 529: when hr_api.validate_enabled then

525: hr_utility.set_location(' Leaving:'||l_proc, 70);
526: --
527: exception
528: --
529: when hr_api.validate_enabled then
530: --
531: -- As the Validate_Enabled exception has been raised
532: -- we must rollback to the savepoint
533: --

Line 697: ,p_prtt_ro_of_unusd_amt_flag in varchar2 default hr_api.g_varchar2

693: (p_validate in boolean default false
694: ,p_bnft_prvdd_ldgr_id in number
695: ,p_effective_start_date out nocopy date
696: ,p_effective_end_date out nocopy date
697: ,p_prtt_ro_of_unusd_amt_flag in varchar2 default hr_api.g_varchar2
698: ,p_frftd_val in number default hr_api.g_number
699: ,p_prvdd_val in number default hr_api.g_number
700: ,p_used_val in number default hr_api.g_number
701: ,p_bnft_prvdr_pool_id in number default hr_api.g_number

Line 698: ,p_frftd_val in number default hr_api.g_number

694: ,p_bnft_prvdd_ldgr_id in number
695: ,p_effective_start_date out nocopy date
696: ,p_effective_end_date out nocopy date
697: ,p_prtt_ro_of_unusd_amt_flag in varchar2 default hr_api.g_varchar2
698: ,p_frftd_val in number default hr_api.g_number
699: ,p_prvdd_val in number default hr_api.g_number
700: ,p_used_val in number default hr_api.g_number
701: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
702: ,p_acty_base_rt_id in number default hr_api.g_number

Line 699: ,p_prvdd_val in number default hr_api.g_number

695: ,p_effective_start_date out nocopy date
696: ,p_effective_end_date out nocopy date
697: ,p_prtt_ro_of_unusd_amt_flag in varchar2 default hr_api.g_varchar2
698: ,p_frftd_val in number default hr_api.g_number
699: ,p_prvdd_val in number default hr_api.g_number
700: ,p_used_val in number default hr_api.g_number
701: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
702: ,p_acty_base_rt_id in number default hr_api.g_number
703: ,p_per_in_ler_id in number default hr_api.g_number

Line 700: ,p_used_val in number default hr_api.g_number

696: ,p_effective_end_date out nocopy date
697: ,p_prtt_ro_of_unusd_amt_flag in varchar2 default hr_api.g_varchar2
698: ,p_frftd_val in number default hr_api.g_number
699: ,p_prvdd_val in number default hr_api.g_number
700: ,p_used_val in number default hr_api.g_number
701: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
702: ,p_acty_base_rt_id in number default hr_api.g_number
703: ,p_per_in_ler_id in number default hr_api.g_number
704: ,p_prtt_enrt_rslt_id in number default hr_api.g_number

Line 701: ,p_bnft_prvdr_pool_id in number default hr_api.g_number

697: ,p_prtt_ro_of_unusd_amt_flag in varchar2 default hr_api.g_varchar2
698: ,p_frftd_val in number default hr_api.g_number
699: ,p_prvdd_val in number default hr_api.g_number
700: ,p_used_val in number default hr_api.g_number
701: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
702: ,p_acty_base_rt_id in number default hr_api.g_number
703: ,p_per_in_ler_id in number default hr_api.g_number
704: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
705: ,p_business_group_id in number default hr_api.g_number

Line 702: ,p_acty_base_rt_id in number default hr_api.g_number

698: ,p_frftd_val in number default hr_api.g_number
699: ,p_prvdd_val in number default hr_api.g_number
700: ,p_used_val in number default hr_api.g_number
701: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
702: ,p_acty_base_rt_id in number default hr_api.g_number
703: ,p_per_in_ler_id in number default hr_api.g_number
704: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
705: ,p_business_group_id in number default hr_api.g_number
706: ,p_bpl_attribute_category in varchar2 default hr_api.g_varchar2

Line 703: ,p_per_in_ler_id in number default hr_api.g_number

699: ,p_prvdd_val in number default hr_api.g_number
700: ,p_used_val in number default hr_api.g_number
701: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
702: ,p_acty_base_rt_id in number default hr_api.g_number
703: ,p_per_in_ler_id in number default hr_api.g_number
704: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
705: ,p_business_group_id in number default hr_api.g_number
706: ,p_bpl_attribute_category in varchar2 default hr_api.g_varchar2
707: ,p_bpl_attribute1 in varchar2 default hr_api.g_varchar2

Line 704: ,p_prtt_enrt_rslt_id in number default hr_api.g_number

700: ,p_used_val in number default hr_api.g_number
701: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
702: ,p_acty_base_rt_id in number default hr_api.g_number
703: ,p_per_in_ler_id in number default hr_api.g_number
704: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
705: ,p_business_group_id in number default hr_api.g_number
706: ,p_bpl_attribute_category in varchar2 default hr_api.g_varchar2
707: ,p_bpl_attribute1 in varchar2 default hr_api.g_varchar2
708: ,p_bpl_attribute2 in varchar2 default hr_api.g_varchar2

Line 705: ,p_business_group_id in number default hr_api.g_number

701: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
702: ,p_acty_base_rt_id in number default hr_api.g_number
703: ,p_per_in_ler_id in number default hr_api.g_number
704: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
705: ,p_business_group_id in number default hr_api.g_number
706: ,p_bpl_attribute_category in varchar2 default hr_api.g_varchar2
707: ,p_bpl_attribute1 in varchar2 default hr_api.g_varchar2
708: ,p_bpl_attribute2 in varchar2 default hr_api.g_varchar2
709: ,p_bpl_attribute3 in varchar2 default hr_api.g_varchar2

Line 706: ,p_bpl_attribute_category in varchar2 default hr_api.g_varchar2

702: ,p_acty_base_rt_id in number default hr_api.g_number
703: ,p_per_in_ler_id in number default hr_api.g_number
704: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
705: ,p_business_group_id in number default hr_api.g_number
706: ,p_bpl_attribute_category in varchar2 default hr_api.g_varchar2
707: ,p_bpl_attribute1 in varchar2 default hr_api.g_varchar2
708: ,p_bpl_attribute2 in varchar2 default hr_api.g_varchar2
709: ,p_bpl_attribute3 in varchar2 default hr_api.g_varchar2
710: ,p_bpl_attribute4 in varchar2 default hr_api.g_varchar2

Line 707: ,p_bpl_attribute1 in varchar2 default hr_api.g_varchar2

703: ,p_per_in_ler_id in number default hr_api.g_number
704: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
705: ,p_business_group_id in number default hr_api.g_number
706: ,p_bpl_attribute_category in varchar2 default hr_api.g_varchar2
707: ,p_bpl_attribute1 in varchar2 default hr_api.g_varchar2
708: ,p_bpl_attribute2 in varchar2 default hr_api.g_varchar2
709: ,p_bpl_attribute3 in varchar2 default hr_api.g_varchar2
710: ,p_bpl_attribute4 in varchar2 default hr_api.g_varchar2
711: ,p_bpl_attribute5 in varchar2 default hr_api.g_varchar2

Line 708: ,p_bpl_attribute2 in varchar2 default hr_api.g_varchar2

704: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
705: ,p_business_group_id in number default hr_api.g_number
706: ,p_bpl_attribute_category in varchar2 default hr_api.g_varchar2
707: ,p_bpl_attribute1 in varchar2 default hr_api.g_varchar2
708: ,p_bpl_attribute2 in varchar2 default hr_api.g_varchar2
709: ,p_bpl_attribute3 in varchar2 default hr_api.g_varchar2
710: ,p_bpl_attribute4 in varchar2 default hr_api.g_varchar2
711: ,p_bpl_attribute5 in varchar2 default hr_api.g_varchar2
712: ,p_bpl_attribute6 in varchar2 default hr_api.g_varchar2

Line 709: ,p_bpl_attribute3 in varchar2 default hr_api.g_varchar2

705: ,p_business_group_id in number default hr_api.g_number
706: ,p_bpl_attribute_category in varchar2 default hr_api.g_varchar2
707: ,p_bpl_attribute1 in varchar2 default hr_api.g_varchar2
708: ,p_bpl_attribute2 in varchar2 default hr_api.g_varchar2
709: ,p_bpl_attribute3 in varchar2 default hr_api.g_varchar2
710: ,p_bpl_attribute4 in varchar2 default hr_api.g_varchar2
711: ,p_bpl_attribute5 in varchar2 default hr_api.g_varchar2
712: ,p_bpl_attribute6 in varchar2 default hr_api.g_varchar2
713: ,p_bpl_attribute7 in varchar2 default hr_api.g_varchar2

Line 710: ,p_bpl_attribute4 in varchar2 default hr_api.g_varchar2

706: ,p_bpl_attribute_category in varchar2 default hr_api.g_varchar2
707: ,p_bpl_attribute1 in varchar2 default hr_api.g_varchar2
708: ,p_bpl_attribute2 in varchar2 default hr_api.g_varchar2
709: ,p_bpl_attribute3 in varchar2 default hr_api.g_varchar2
710: ,p_bpl_attribute4 in varchar2 default hr_api.g_varchar2
711: ,p_bpl_attribute5 in varchar2 default hr_api.g_varchar2
712: ,p_bpl_attribute6 in varchar2 default hr_api.g_varchar2
713: ,p_bpl_attribute7 in varchar2 default hr_api.g_varchar2
714: ,p_bpl_attribute8 in varchar2 default hr_api.g_varchar2

Line 711: ,p_bpl_attribute5 in varchar2 default hr_api.g_varchar2

707: ,p_bpl_attribute1 in varchar2 default hr_api.g_varchar2
708: ,p_bpl_attribute2 in varchar2 default hr_api.g_varchar2
709: ,p_bpl_attribute3 in varchar2 default hr_api.g_varchar2
710: ,p_bpl_attribute4 in varchar2 default hr_api.g_varchar2
711: ,p_bpl_attribute5 in varchar2 default hr_api.g_varchar2
712: ,p_bpl_attribute6 in varchar2 default hr_api.g_varchar2
713: ,p_bpl_attribute7 in varchar2 default hr_api.g_varchar2
714: ,p_bpl_attribute8 in varchar2 default hr_api.g_varchar2
715: ,p_bpl_attribute9 in varchar2 default hr_api.g_varchar2

Line 712: ,p_bpl_attribute6 in varchar2 default hr_api.g_varchar2

708: ,p_bpl_attribute2 in varchar2 default hr_api.g_varchar2
709: ,p_bpl_attribute3 in varchar2 default hr_api.g_varchar2
710: ,p_bpl_attribute4 in varchar2 default hr_api.g_varchar2
711: ,p_bpl_attribute5 in varchar2 default hr_api.g_varchar2
712: ,p_bpl_attribute6 in varchar2 default hr_api.g_varchar2
713: ,p_bpl_attribute7 in varchar2 default hr_api.g_varchar2
714: ,p_bpl_attribute8 in varchar2 default hr_api.g_varchar2
715: ,p_bpl_attribute9 in varchar2 default hr_api.g_varchar2
716: ,p_bpl_attribute10 in varchar2 default hr_api.g_varchar2

Line 713: ,p_bpl_attribute7 in varchar2 default hr_api.g_varchar2

709: ,p_bpl_attribute3 in varchar2 default hr_api.g_varchar2
710: ,p_bpl_attribute4 in varchar2 default hr_api.g_varchar2
711: ,p_bpl_attribute5 in varchar2 default hr_api.g_varchar2
712: ,p_bpl_attribute6 in varchar2 default hr_api.g_varchar2
713: ,p_bpl_attribute7 in varchar2 default hr_api.g_varchar2
714: ,p_bpl_attribute8 in varchar2 default hr_api.g_varchar2
715: ,p_bpl_attribute9 in varchar2 default hr_api.g_varchar2
716: ,p_bpl_attribute10 in varchar2 default hr_api.g_varchar2
717: ,p_bpl_attribute11 in varchar2 default hr_api.g_varchar2

Line 714: ,p_bpl_attribute8 in varchar2 default hr_api.g_varchar2

710: ,p_bpl_attribute4 in varchar2 default hr_api.g_varchar2
711: ,p_bpl_attribute5 in varchar2 default hr_api.g_varchar2
712: ,p_bpl_attribute6 in varchar2 default hr_api.g_varchar2
713: ,p_bpl_attribute7 in varchar2 default hr_api.g_varchar2
714: ,p_bpl_attribute8 in varchar2 default hr_api.g_varchar2
715: ,p_bpl_attribute9 in varchar2 default hr_api.g_varchar2
716: ,p_bpl_attribute10 in varchar2 default hr_api.g_varchar2
717: ,p_bpl_attribute11 in varchar2 default hr_api.g_varchar2
718: ,p_bpl_attribute12 in varchar2 default hr_api.g_varchar2

Line 715: ,p_bpl_attribute9 in varchar2 default hr_api.g_varchar2

711: ,p_bpl_attribute5 in varchar2 default hr_api.g_varchar2
712: ,p_bpl_attribute6 in varchar2 default hr_api.g_varchar2
713: ,p_bpl_attribute7 in varchar2 default hr_api.g_varchar2
714: ,p_bpl_attribute8 in varchar2 default hr_api.g_varchar2
715: ,p_bpl_attribute9 in varchar2 default hr_api.g_varchar2
716: ,p_bpl_attribute10 in varchar2 default hr_api.g_varchar2
717: ,p_bpl_attribute11 in varchar2 default hr_api.g_varchar2
718: ,p_bpl_attribute12 in varchar2 default hr_api.g_varchar2
719: ,p_bpl_attribute13 in varchar2 default hr_api.g_varchar2

Line 716: ,p_bpl_attribute10 in varchar2 default hr_api.g_varchar2

712: ,p_bpl_attribute6 in varchar2 default hr_api.g_varchar2
713: ,p_bpl_attribute7 in varchar2 default hr_api.g_varchar2
714: ,p_bpl_attribute8 in varchar2 default hr_api.g_varchar2
715: ,p_bpl_attribute9 in varchar2 default hr_api.g_varchar2
716: ,p_bpl_attribute10 in varchar2 default hr_api.g_varchar2
717: ,p_bpl_attribute11 in varchar2 default hr_api.g_varchar2
718: ,p_bpl_attribute12 in varchar2 default hr_api.g_varchar2
719: ,p_bpl_attribute13 in varchar2 default hr_api.g_varchar2
720: ,p_bpl_attribute14 in varchar2 default hr_api.g_varchar2

Line 717: ,p_bpl_attribute11 in varchar2 default hr_api.g_varchar2

713: ,p_bpl_attribute7 in varchar2 default hr_api.g_varchar2
714: ,p_bpl_attribute8 in varchar2 default hr_api.g_varchar2
715: ,p_bpl_attribute9 in varchar2 default hr_api.g_varchar2
716: ,p_bpl_attribute10 in varchar2 default hr_api.g_varchar2
717: ,p_bpl_attribute11 in varchar2 default hr_api.g_varchar2
718: ,p_bpl_attribute12 in varchar2 default hr_api.g_varchar2
719: ,p_bpl_attribute13 in varchar2 default hr_api.g_varchar2
720: ,p_bpl_attribute14 in varchar2 default hr_api.g_varchar2
721: ,p_bpl_attribute15 in varchar2 default hr_api.g_varchar2

Line 718: ,p_bpl_attribute12 in varchar2 default hr_api.g_varchar2

714: ,p_bpl_attribute8 in varchar2 default hr_api.g_varchar2
715: ,p_bpl_attribute9 in varchar2 default hr_api.g_varchar2
716: ,p_bpl_attribute10 in varchar2 default hr_api.g_varchar2
717: ,p_bpl_attribute11 in varchar2 default hr_api.g_varchar2
718: ,p_bpl_attribute12 in varchar2 default hr_api.g_varchar2
719: ,p_bpl_attribute13 in varchar2 default hr_api.g_varchar2
720: ,p_bpl_attribute14 in varchar2 default hr_api.g_varchar2
721: ,p_bpl_attribute15 in varchar2 default hr_api.g_varchar2
722: ,p_bpl_attribute16 in varchar2 default hr_api.g_varchar2

Line 719: ,p_bpl_attribute13 in varchar2 default hr_api.g_varchar2

715: ,p_bpl_attribute9 in varchar2 default hr_api.g_varchar2
716: ,p_bpl_attribute10 in varchar2 default hr_api.g_varchar2
717: ,p_bpl_attribute11 in varchar2 default hr_api.g_varchar2
718: ,p_bpl_attribute12 in varchar2 default hr_api.g_varchar2
719: ,p_bpl_attribute13 in varchar2 default hr_api.g_varchar2
720: ,p_bpl_attribute14 in varchar2 default hr_api.g_varchar2
721: ,p_bpl_attribute15 in varchar2 default hr_api.g_varchar2
722: ,p_bpl_attribute16 in varchar2 default hr_api.g_varchar2
723: ,p_bpl_attribute17 in varchar2 default hr_api.g_varchar2

Line 720: ,p_bpl_attribute14 in varchar2 default hr_api.g_varchar2

716: ,p_bpl_attribute10 in varchar2 default hr_api.g_varchar2
717: ,p_bpl_attribute11 in varchar2 default hr_api.g_varchar2
718: ,p_bpl_attribute12 in varchar2 default hr_api.g_varchar2
719: ,p_bpl_attribute13 in varchar2 default hr_api.g_varchar2
720: ,p_bpl_attribute14 in varchar2 default hr_api.g_varchar2
721: ,p_bpl_attribute15 in varchar2 default hr_api.g_varchar2
722: ,p_bpl_attribute16 in varchar2 default hr_api.g_varchar2
723: ,p_bpl_attribute17 in varchar2 default hr_api.g_varchar2
724: ,p_bpl_attribute18 in varchar2 default hr_api.g_varchar2

Line 721: ,p_bpl_attribute15 in varchar2 default hr_api.g_varchar2

717: ,p_bpl_attribute11 in varchar2 default hr_api.g_varchar2
718: ,p_bpl_attribute12 in varchar2 default hr_api.g_varchar2
719: ,p_bpl_attribute13 in varchar2 default hr_api.g_varchar2
720: ,p_bpl_attribute14 in varchar2 default hr_api.g_varchar2
721: ,p_bpl_attribute15 in varchar2 default hr_api.g_varchar2
722: ,p_bpl_attribute16 in varchar2 default hr_api.g_varchar2
723: ,p_bpl_attribute17 in varchar2 default hr_api.g_varchar2
724: ,p_bpl_attribute18 in varchar2 default hr_api.g_varchar2
725: ,p_bpl_attribute19 in varchar2 default hr_api.g_varchar2

Line 722: ,p_bpl_attribute16 in varchar2 default hr_api.g_varchar2

718: ,p_bpl_attribute12 in varchar2 default hr_api.g_varchar2
719: ,p_bpl_attribute13 in varchar2 default hr_api.g_varchar2
720: ,p_bpl_attribute14 in varchar2 default hr_api.g_varchar2
721: ,p_bpl_attribute15 in varchar2 default hr_api.g_varchar2
722: ,p_bpl_attribute16 in varchar2 default hr_api.g_varchar2
723: ,p_bpl_attribute17 in varchar2 default hr_api.g_varchar2
724: ,p_bpl_attribute18 in varchar2 default hr_api.g_varchar2
725: ,p_bpl_attribute19 in varchar2 default hr_api.g_varchar2
726: ,p_bpl_attribute20 in varchar2 default hr_api.g_varchar2

Line 723: ,p_bpl_attribute17 in varchar2 default hr_api.g_varchar2

719: ,p_bpl_attribute13 in varchar2 default hr_api.g_varchar2
720: ,p_bpl_attribute14 in varchar2 default hr_api.g_varchar2
721: ,p_bpl_attribute15 in varchar2 default hr_api.g_varchar2
722: ,p_bpl_attribute16 in varchar2 default hr_api.g_varchar2
723: ,p_bpl_attribute17 in varchar2 default hr_api.g_varchar2
724: ,p_bpl_attribute18 in varchar2 default hr_api.g_varchar2
725: ,p_bpl_attribute19 in varchar2 default hr_api.g_varchar2
726: ,p_bpl_attribute20 in varchar2 default hr_api.g_varchar2
727: ,p_bpl_attribute21 in varchar2 default hr_api.g_varchar2

Line 724: ,p_bpl_attribute18 in varchar2 default hr_api.g_varchar2

720: ,p_bpl_attribute14 in varchar2 default hr_api.g_varchar2
721: ,p_bpl_attribute15 in varchar2 default hr_api.g_varchar2
722: ,p_bpl_attribute16 in varchar2 default hr_api.g_varchar2
723: ,p_bpl_attribute17 in varchar2 default hr_api.g_varchar2
724: ,p_bpl_attribute18 in varchar2 default hr_api.g_varchar2
725: ,p_bpl_attribute19 in varchar2 default hr_api.g_varchar2
726: ,p_bpl_attribute20 in varchar2 default hr_api.g_varchar2
727: ,p_bpl_attribute21 in varchar2 default hr_api.g_varchar2
728: ,p_bpl_attribute22 in varchar2 default hr_api.g_varchar2

Line 725: ,p_bpl_attribute19 in varchar2 default hr_api.g_varchar2

721: ,p_bpl_attribute15 in varchar2 default hr_api.g_varchar2
722: ,p_bpl_attribute16 in varchar2 default hr_api.g_varchar2
723: ,p_bpl_attribute17 in varchar2 default hr_api.g_varchar2
724: ,p_bpl_attribute18 in varchar2 default hr_api.g_varchar2
725: ,p_bpl_attribute19 in varchar2 default hr_api.g_varchar2
726: ,p_bpl_attribute20 in varchar2 default hr_api.g_varchar2
727: ,p_bpl_attribute21 in varchar2 default hr_api.g_varchar2
728: ,p_bpl_attribute22 in varchar2 default hr_api.g_varchar2
729: ,p_bpl_attribute23 in varchar2 default hr_api.g_varchar2

Line 726: ,p_bpl_attribute20 in varchar2 default hr_api.g_varchar2

722: ,p_bpl_attribute16 in varchar2 default hr_api.g_varchar2
723: ,p_bpl_attribute17 in varchar2 default hr_api.g_varchar2
724: ,p_bpl_attribute18 in varchar2 default hr_api.g_varchar2
725: ,p_bpl_attribute19 in varchar2 default hr_api.g_varchar2
726: ,p_bpl_attribute20 in varchar2 default hr_api.g_varchar2
727: ,p_bpl_attribute21 in varchar2 default hr_api.g_varchar2
728: ,p_bpl_attribute22 in varchar2 default hr_api.g_varchar2
729: ,p_bpl_attribute23 in varchar2 default hr_api.g_varchar2
730: ,p_bpl_attribute24 in varchar2 default hr_api.g_varchar2

Line 727: ,p_bpl_attribute21 in varchar2 default hr_api.g_varchar2

723: ,p_bpl_attribute17 in varchar2 default hr_api.g_varchar2
724: ,p_bpl_attribute18 in varchar2 default hr_api.g_varchar2
725: ,p_bpl_attribute19 in varchar2 default hr_api.g_varchar2
726: ,p_bpl_attribute20 in varchar2 default hr_api.g_varchar2
727: ,p_bpl_attribute21 in varchar2 default hr_api.g_varchar2
728: ,p_bpl_attribute22 in varchar2 default hr_api.g_varchar2
729: ,p_bpl_attribute23 in varchar2 default hr_api.g_varchar2
730: ,p_bpl_attribute24 in varchar2 default hr_api.g_varchar2
731: ,p_bpl_attribute25 in varchar2 default hr_api.g_varchar2

Line 728: ,p_bpl_attribute22 in varchar2 default hr_api.g_varchar2

724: ,p_bpl_attribute18 in varchar2 default hr_api.g_varchar2
725: ,p_bpl_attribute19 in varchar2 default hr_api.g_varchar2
726: ,p_bpl_attribute20 in varchar2 default hr_api.g_varchar2
727: ,p_bpl_attribute21 in varchar2 default hr_api.g_varchar2
728: ,p_bpl_attribute22 in varchar2 default hr_api.g_varchar2
729: ,p_bpl_attribute23 in varchar2 default hr_api.g_varchar2
730: ,p_bpl_attribute24 in varchar2 default hr_api.g_varchar2
731: ,p_bpl_attribute25 in varchar2 default hr_api.g_varchar2
732: ,p_bpl_attribute26 in varchar2 default hr_api.g_varchar2

Line 729: ,p_bpl_attribute23 in varchar2 default hr_api.g_varchar2

725: ,p_bpl_attribute19 in varchar2 default hr_api.g_varchar2
726: ,p_bpl_attribute20 in varchar2 default hr_api.g_varchar2
727: ,p_bpl_attribute21 in varchar2 default hr_api.g_varchar2
728: ,p_bpl_attribute22 in varchar2 default hr_api.g_varchar2
729: ,p_bpl_attribute23 in varchar2 default hr_api.g_varchar2
730: ,p_bpl_attribute24 in varchar2 default hr_api.g_varchar2
731: ,p_bpl_attribute25 in varchar2 default hr_api.g_varchar2
732: ,p_bpl_attribute26 in varchar2 default hr_api.g_varchar2
733: ,p_bpl_attribute27 in varchar2 default hr_api.g_varchar2

Line 730: ,p_bpl_attribute24 in varchar2 default hr_api.g_varchar2

726: ,p_bpl_attribute20 in varchar2 default hr_api.g_varchar2
727: ,p_bpl_attribute21 in varchar2 default hr_api.g_varchar2
728: ,p_bpl_attribute22 in varchar2 default hr_api.g_varchar2
729: ,p_bpl_attribute23 in varchar2 default hr_api.g_varchar2
730: ,p_bpl_attribute24 in varchar2 default hr_api.g_varchar2
731: ,p_bpl_attribute25 in varchar2 default hr_api.g_varchar2
732: ,p_bpl_attribute26 in varchar2 default hr_api.g_varchar2
733: ,p_bpl_attribute27 in varchar2 default hr_api.g_varchar2
734: ,p_bpl_attribute28 in varchar2 default hr_api.g_varchar2

Line 731: ,p_bpl_attribute25 in varchar2 default hr_api.g_varchar2

727: ,p_bpl_attribute21 in varchar2 default hr_api.g_varchar2
728: ,p_bpl_attribute22 in varchar2 default hr_api.g_varchar2
729: ,p_bpl_attribute23 in varchar2 default hr_api.g_varchar2
730: ,p_bpl_attribute24 in varchar2 default hr_api.g_varchar2
731: ,p_bpl_attribute25 in varchar2 default hr_api.g_varchar2
732: ,p_bpl_attribute26 in varchar2 default hr_api.g_varchar2
733: ,p_bpl_attribute27 in varchar2 default hr_api.g_varchar2
734: ,p_bpl_attribute28 in varchar2 default hr_api.g_varchar2
735: ,p_bpl_attribute29 in varchar2 default hr_api.g_varchar2

Line 732: ,p_bpl_attribute26 in varchar2 default hr_api.g_varchar2

728: ,p_bpl_attribute22 in varchar2 default hr_api.g_varchar2
729: ,p_bpl_attribute23 in varchar2 default hr_api.g_varchar2
730: ,p_bpl_attribute24 in varchar2 default hr_api.g_varchar2
731: ,p_bpl_attribute25 in varchar2 default hr_api.g_varchar2
732: ,p_bpl_attribute26 in varchar2 default hr_api.g_varchar2
733: ,p_bpl_attribute27 in varchar2 default hr_api.g_varchar2
734: ,p_bpl_attribute28 in varchar2 default hr_api.g_varchar2
735: ,p_bpl_attribute29 in varchar2 default hr_api.g_varchar2
736: ,p_bpl_attribute30 in varchar2 default hr_api.g_varchar2

Line 733: ,p_bpl_attribute27 in varchar2 default hr_api.g_varchar2

729: ,p_bpl_attribute23 in varchar2 default hr_api.g_varchar2
730: ,p_bpl_attribute24 in varchar2 default hr_api.g_varchar2
731: ,p_bpl_attribute25 in varchar2 default hr_api.g_varchar2
732: ,p_bpl_attribute26 in varchar2 default hr_api.g_varchar2
733: ,p_bpl_attribute27 in varchar2 default hr_api.g_varchar2
734: ,p_bpl_attribute28 in varchar2 default hr_api.g_varchar2
735: ,p_bpl_attribute29 in varchar2 default hr_api.g_varchar2
736: ,p_bpl_attribute30 in varchar2 default hr_api.g_varchar2
737: ,p_cash_recd_val in number default hr_api.g_number

Line 734: ,p_bpl_attribute28 in varchar2 default hr_api.g_varchar2

730: ,p_bpl_attribute24 in varchar2 default hr_api.g_varchar2
731: ,p_bpl_attribute25 in varchar2 default hr_api.g_varchar2
732: ,p_bpl_attribute26 in varchar2 default hr_api.g_varchar2
733: ,p_bpl_attribute27 in varchar2 default hr_api.g_varchar2
734: ,p_bpl_attribute28 in varchar2 default hr_api.g_varchar2
735: ,p_bpl_attribute29 in varchar2 default hr_api.g_varchar2
736: ,p_bpl_attribute30 in varchar2 default hr_api.g_varchar2
737: ,p_cash_recd_val in number default hr_api.g_number
738: ,p_rld_up_val in number default hr_api.g_number

Line 735: ,p_bpl_attribute29 in varchar2 default hr_api.g_varchar2

731: ,p_bpl_attribute25 in varchar2 default hr_api.g_varchar2
732: ,p_bpl_attribute26 in varchar2 default hr_api.g_varchar2
733: ,p_bpl_attribute27 in varchar2 default hr_api.g_varchar2
734: ,p_bpl_attribute28 in varchar2 default hr_api.g_varchar2
735: ,p_bpl_attribute29 in varchar2 default hr_api.g_varchar2
736: ,p_bpl_attribute30 in varchar2 default hr_api.g_varchar2
737: ,p_cash_recd_val in number default hr_api.g_number
738: ,p_rld_up_val in number default hr_api.g_number
739: ,p_effective_date in date

Line 736: ,p_bpl_attribute30 in varchar2 default hr_api.g_varchar2

732: ,p_bpl_attribute26 in varchar2 default hr_api.g_varchar2
733: ,p_bpl_attribute27 in varchar2 default hr_api.g_varchar2
734: ,p_bpl_attribute28 in varchar2 default hr_api.g_varchar2
735: ,p_bpl_attribute29 in varchar2 default hr_api.g_varchar2
736: ,p_bpl_attribute30 in varchar2 default hr_api.g_varchar2
737: ,p_cash_recd_val in number default hr_api.g_number
738: ,p_rld_up_val in number default hr_api.g_number
739: ,p_effective_date in date
740: ,p_datetrack_mode in varchar2

Line 737: ,p_cash_recd_val in number default hr_api.g_number

733: ,p_bpl_attribute27 in varchar2 default hr_api.g_varchar2
734: ,p_bpl_attribute28 in varchar2 default hr_api.g_varchar2
735: ,p_bpl_attribute29 in varchar2 default hr_api.g_varchar2
736: ,p_bpl_attribute30 in varchar2 default hr_api.g_varchar2
737: ,p_cash_recd_val in number default hr_api.g_number
738: ,p_rld_up_val in number default hr_api.g_number
739: ,p_effective_date in date
740: ,p_datetrack_mode in varchar2
741: ,p_process_enrt_flag in varchar2 default 'Y'

Line 738: ,p_rld_up_val in number default hr_api.g_number

734: ,p_bpl_attribute28 in varchar2 default hr_api.g_varchar2
735: ,p_bpl_attribute29 in varchar2 default hr_api.g_varchar2
736: ,p_bpl_attribute30 in varchar2 default hr_api.g_varchar2
737: ,p_cash_recd_val in number default hr_api.g_number
738: ,p_rld_up_val in number default hr_api.g_number
739: ,p_effective_date in date
740: ,p_datetrack_mode in varchar2
741: ,p_process_enrt_flag in varchar2 default 'Y'
742: ,p_from_reinstate_enrt_flag in varchar2 default 'N',

Line 743: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,

739: ,p_effective_date in date
740: ,p_datetrack_mode in varchar2
741: ,p_process_enrt_flag in varchar2 default 'Y'
742: ,p_from_reinstate_enrt_flag in varchar2 default 'N',
743: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
744: p_cmcd_frftd_val in number default hr_api.g_number,
745: p_cmcd_prvdd_val in number default hr_api.g_number,
746: p_cmcd_rld_up_val in number default hr_api.g_number,
747: p_cmcd_used_val in number default hr_api.g_number,

Line 744: p_cmcd_frftd_val in number default hr_api.g_number,

740: ,p_datetrack_mode in varchar2
741: ,p_process_enrt_flag in varchar2 default 'Y'
742: ,p_from_reinstate_enrt_flag in varchar2 default 'N',
743: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
744: p_cmcd_frftd_val in number default hr_api.g_number,
745: p_cmcd_prvdd_val in number default hr_api.g_number,
746: p_cmcd_rld_up_val in number default hr_api.g_number,
747: p_cmcd_used_val in number default hr_api.g_number,
748: p_cmcd_cash_recd_val in number default hr_api.g_number,

Line 745: p_cmcd_prvdd_val in number default hr_api.g_number,

741: ,p_process_enrt_flag in varchar2 default 'Y'
742: ,p_from_reinstate_enrt_flag in varchar2 default 'N',
743: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
744: p_cmcd_frftd_val in number default hr_api.g_number,
745: p_cmcd_prvdd_val in number default hr_api.g_number,
746: p_cmcd_rld_up_val in number default hr_api.g_number,
747: p_cmcd_used_val in number default hr_api.g_number,
748: p_cmcd_cash_recd_val in number default hr_api.g_number,
749: p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,

Line 746: p_cmcd_rld_up_val in number default hr_api.g_number,

742: ,p_from_reinstate_enrt_flag in varchar2 default 'N',
743: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
744: p_cmcd_frftd_val in number default hr_api.g_number,
745: p_cmcd_prvdd_val in number default hr_api.g_number,
746: p_cmcd_rld_up_val in number default hr_api.g_number,
747: p_cmcd_used_val in number default hr_api.g_number,
748: p_cmcd_cash_recd_val in number default hr_api.g_number,
749: p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,
750: p_ann_frftd_val in number default hr_api.g_number,

Line 747: p_cmcd_used_val in number default hr_api.g_number,

743: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
744: p_cmcd_frftd_val in number default hr_api.g_number,
745: p_cmcd_prvdd_val in number default hr_api.g_number,
746: p_cmcd_rld_up_val in number default hr_api.g_number,
747: p_cmcd_used_val in number default hr_api.g_number,
748: p_cmcd_cash_recd_val in number default hr_api.g_number,
749: p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,
750: p_ann_frftd_val in number default hr_api.g_number,
751: p_ann_prvdd_val in number default hr_api.g_number,

Line 748: p_cmcd_cash_recd_val in number default hr_api.g_number,

744: p_cmcd_frftd_val in number default hr_api.g_number,
745: p_cmcd_prvdd_val in number default hr_api.g_number,
746: p_cmcd_rld_up_val in number default hr_api.g_number,
747: p_cmcd_used_val in number default hr_api.g_number,
748: p_cmcd_cash_recd_val in number default hr_api.g_number,
749: p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,
750: p_ann_frftd_val in number default hr_api.g_number,
751: p_ann_prvdd_val in number default hr_api.g_number,
752: p_ann_rld_up_val in number default hr_api.g_number,

Line 749: p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,

745: p_cmcd_prvdd_val in number default hr_api.g_number,
746: p_cmcd_rld_up_val in number default hr_api.g_number,
747: p_cmcd_used_val in number default hr_api.g_number,
748: p_cmcd_cash_recd_val in number default hr_api.g_number,
749: p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,
750: p_ann_frftd_val in number default hr_api.g_number,
751: p_ann_prvdd_val in number default hr_api.g_number,
752: p_ann_rld_up_val in number default hr_api.g_number,
753: p_ann_used_val in number default hr_api.g_number,

Line 750: p_ann_frftd_val in number default hr_api.g_number,

746: p_cmcd_rld_up_val in number default hr_api.g_number,
747: p_cmcd_used_val in number default hr_api.g_number,
748: p_cmcd_cash_recd_val in number default hr_api.g_number,
749: p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,
750: p_ann_frftd_val in number default hr_api.g_number,
751: p_ann_prvdd_val in number default hr_api.g_number,
752: p_ann_rld_up_val in number default hr_api.g_number,
753: p_ann_used_val in number default hr_api.g_number,
754: p_ann_cash_recd_val in number default hr_api.g_number,

Line 751: p_ann_prvdd_val in number default hr_api.g_number,

747: p_cmcd_used_val in number default hr_api.g_number,
748: p_cmcd_cash_recd_val in number default hr_api.g_number,
749: p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,
750: p_ann_frftd_val in number default hr_api.g_number,
751: p_ann_prvdd_val in number default hr_api.g_number,
752: p_ann_rld_up_val in number default hr_api.g_number,
753: p_ann_used_val in number default hr_api.g_number,
754: p_ann_cash_recd_val in number default hr_api.g_number,
755: p_object_version_number in out nocopy number

Line 752: p_ann_rld_up_val in number default hr_api.g_number,

748: p_cmcd_cash_recd_val in number default hr_api.g_number,
749: p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,
750: p_ann_frftd_val in number default hr_api.g_number,
751: p_ann_prvdd_val in number default hr_api.g_number,
752: p_ann_rld_up_val in number default hr_api.g_number,
753: p_ann_used_val in number default hr_api.g_number,
754: p_ann_cash_recd_val in number default hr_api.g_number,
755: p_object_version_number in out nocopy number
756: ) is

Line 753: p_ann_used_val in number default hr_api.g_number,

749: p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,
750: p_ann_frftd_val in number default hr_api.g_number,
751: p_ann_prvdd_val in number default hr_api.g_number,
752: p_ann_rld_up_val in number default hr_api.g_number,
753: p_ann_used_val in number default hr_api.g_number,
754: p_ann_cash_recd_val in number default hr_api.g_number,
755: p_object_version_number in out nocopy number
756: ) is
757: --

Line 754: p_ann_cash_recd_val in number default hr_api.g_number,

750: p_ann_frftd_val in number default hr_api.g_number,
751: p_ann_prvdd_val in number default hr_api.g_number,
752: p_ann_rld_up_val in number default hr_api.g_number,
753: p_ann_used_val in number default hr_api.g_number,
754: p_ann_cash_recd_val in number default hr_api.g_number,
755: p_object_version_number in out nocopy number
756: ) is
757: --
758: -- Declare cursors and local variables

Line 819: l_hr_api_g_number number := hr_api.g_number;

815: l_ann_used_val number := null;
816: l_ann_cash_recd_val number := null;
817: l_acty_ref_perd_cd varchar2(30) := null;
818: l_cmcd_ref_perd_cd varchar2(30) := null;
819: l_hr_api_g_number number := hr_api.g_number;
820: l_bnft_prvdd_ldgr_updated boolean := FALSE;
821:
822: begin
823: --

Line 901: if (p_frftd_val is not null and p_frftd_val <> l_hr_api_g_number and

897: end if;
898: -- Bug: 3611160/4169180 Changes end...
899: end if;
900:
901: if (p_frftd_val is not null and p_frftd_val <> l_hr_api_g_number and
902: (p_cmcd_frftd_val is null or p_cmcd_frftd_val = l_hr_api_g_number)) or
903: (p_used_val is not null and p_used_val <> l_hr_api_g_number and
904: (p_cmcd_used_val is null or p_cmcd_used_val = l_hr_api_g_number)) or
905: (p_prvdd_val is not null and p_prvdd_val <> l_hr_api_g_number and

Line 902: (p_cmcd_frftd_val is null or p_cmcd_frftd_val = l_hr_api_g_number)) or

898: -- Bug: 3611160/4169180 Changes end...
899: end if;
900:
901: if (p_frftd_val is not null and p_frftd_val <> l_hr_api_g_number and
902: (p_cmcd_frftd_val is null or p_cmcd_frftd_val = l_hr_api_g_number)) or
903: (p_used_val is not null and p_used_val <> l_hr_api_g_number and
904: (p_cmcd_used_val is null or p_cmcd_used_val = l_hr_api_g_number)) or
905: (p_prvdd_val is not null and p_prvdd_val <> l_hr_api_g_number and
906: (p_cmcd_prvdd_val is null or p_cmcd_prvdd_val = l_hr_api_g_number)) or

Line 903: (p_used_val is not null and p_used_val <> l_hr_api_g_number and

899: end if;
900:
901: if (p_frftd_val is not null and p_frftd_val <> l_hr_api_g_number and
902: (p_cmcd_frftd_val is null or p_cmcd_frftd_val = l_hr_api_g_number)) or
903: (p_used_val is not null and p_used_val <> l_hr_api_g_number and
904: (p_cmcd_used_val is null or p_cmcd_used_val = l_hr_api_g_number)) or
905: (p_prvdd_val is not null and p_prvdd_val <> l_hr_api_g_number and
906: (p_cmcd_prvdd_val is null or p_cmcd_prvdd_val = l_hr_api_g_number)) or
907: (p_cash_recd_val is not null and p_cash_recd_val <> l_hr_api_g_number and

Line 904: (p_cmcd_used_val is null or p_cmcd_used_val = l_hr_api_g_number)) or

900:
901: if (p_frftd_val is not null and p_frftd_val <> l_hr_api_g_number and
902: (p_cmcd_frftd_val is null or p_cmcd_frftd_val = l_hr_api_g_number)) or
903: (p_used_val is not null and p_used_val <> l_hr_api_g_number and
904: (p_cmcd_used_val is null or p_cmcd_used_val = l_hr_api_g_number)) or
905: (p_prvdd_val is not null and p_prvdd_val <> l_hr_api_g_number and
906: (p_cmcd_prvdd_val is null or p_cmcd_prvdd_val = l_hr_api_g_number)) or
907: (p_cash_recd_val is not null and p_cash_recd_val <> l_hr_api_g_number and
908: (p_cmcd_cash_recd_val is null or p_cmcd_cash_recd_val = l_hr_api_g_number)) or

Line 905: (p_prvdd_val is not null and p_prvdd_val <> l_hr_api_g_number and

901: if (p_frftd_val is not null and p_frftd_val <> l_hr_api_g_number and
902: (p_cmcd_frftd_val is null or p_cmcd_frftd_val = l_hr_api_g_number)) or
903: (p_used_val is not null and p_used_val <> l_hr_api_g_number and
904: (p_cmcd_used_val is null or p_cmcd_used_val = l_hr_api_g_number)) or
905: (p_prvdd_val is not null and p_prvdd_val <> l_hr_api_g_number and
906: (p_cmcd_prvdd_val is null or p_cmcd_prvdd_val = l_hr_api_g_number)) or
907: (p_cash_recd_val is not null and p_cash_recd_val <> l_hr_api_g_number and
908: (p_cmcd_cash_recd_val is null or p_cmcd_cash_recd_val = l_hr_api_g_number)) or
909: (p_rld_up_val is not null and p_rld_up_val <> l_hr_api_g_number and

Line 906: (p_cmcd_prvdd_val is null or p_cmcd_prvdd_val = l_hr_api_g_number)) or

902: (p_cmcd_frftd_val is null or p_cmcd_frftd_val = l_hr_api_g_number)) or
903: (p_used_val is not null and p_used_val <> l_hr_api_g_number and
904: (p_cmcd_used_val is null or p_cmcd_used_val = l_hr_api_g_number)) or
905: (p_prvdd_val is not null and p_prvdd_val <> l_hr_api_g_number and
906: (p_cmcd_prvdd_val is null or p_cmcd_prvdd_val = l_hr_api_g_number)) or
907: (p_cash_recd_val is not null and p_cash_recd_val <> l_hr_api_g_number and
908: (p_cmcd_cash_recd_val is null or p_cmcd_cash_recd_val = l_hr_api_g_number)) or
909: (p_rld_up_val is not null and p_rld_up_val <> l_hr_api_g_number and
910: (p_cmcd_rld_up_val is null or p_cmcd_rld_up_val = l_hr_api_g_number)) then

Line 907: (p_cash_recd_val is not null and p_cash_recd_val <> l_hr_api_g_number and

903: (p_used_val is not null and p_used_val <> l_hr_api_g_number and
904: (p_cmcd_used_val is null or p_cmcd_used_val = l_hr_api_g_number)) or
905: (p_prvdd_val is not null and p_prvdd_val <> l_hr_api_g_number and
906: (p_cmcd_prvdd_val is null or p_cmcd_prvdd_val = l_hr_api_g_number)) or
907: (p_cash_recd_val is not null and p_cash_recd_val <> l_hr_api_g_number and
908: (p_cmcd_cash_recd_val is null or p_cmcd_cash_recd_val = l_hr_api_g_number)) or
909: (p_rld_up_val is not null and p_rld_up_val <> l_hr_api_g_number and
910: (p_cmcd_rld_up_val is null or p_cmcd_rld_up_val = l_hr_api_g_number)) then
911: -- get the communicated and annual values

Line 908: (p_cmcd_cash_recd_val is null or p_cmcd_cash_recd_val = l_hr_api_g_number)) or

904: (p_cmcd_used_val is null or p_cmcd_used_val = l_hr_api_g_number)) or
905: (p_prvdd_val is not null and p_prvdd_val <> l_hr_api_g_number and
906: (p_cmcd_prvdd_val is null or p_cmcd_prvdd_val = l_hr_api_g_number)) or
907: (p_cash_recd_val is not null and p_cash_recd_val <> l_hr_api_g_number and
908: (p_cmcd_cash_recd_val is null or p_cmcd_cash_recd_val = l_hr_api_g_number)) or
909: (p_rld_up_val is not null and p_rld_up_val <> l_hr_api_g_number and
910: (p_cmcd_rld_up_val is null or p_cmcd_rld_up_val = l_hr_api_g_number)) then
911: -- get the communicated and annual values
912: ben_update_ledgers.get_cmcd_ann_values

Line 909: (p_rld_up_val is not null and p_rld_up_val <> l_hr_api_g_number and

905: (p_prvdd_val is not null and p_prvdd_val <> l_hr_api_g_number and
906: (p_cmcd_prvdd_val is null or p_cmcd_prvdd_val = l_hr_api_g_number)) or
907: (p_cash_recd_val is not null and p_cash_recd_val <> l_hr_api_g_number and
908: (p_cmcd_cash_recd_val is null or p_cmcd_cash_recd_val = l_hr_api_g_number)) or
909: (p_rld_up_val is not null and p_rld_up_val <> l_hr_api_g_number and
910: (p_cmcd_rld_up_val is null or p_cmcd_rld_up_val = l_hr_api_g_number)) then
911: -- get the communicated and annual values
912: ben_update_ledgers.get_cmcd_ann_values
913: (p_bnft_prvdd_ldgr_id => p_bnft_prvdd_ldgr_id,

Line 910: (p_cmcd_rld_up_val is null or p_cmcd_rld_up_val = l_hr_api_g_number)) then

906: (p_cmcd_prvdd_val is null or p_cmcd_prvdd_val = l_hr_api_g_number)) or
907: (p_cash_recd_val is not null and p_cash_recd_val <> l_hr_api_g_number and
908: (p_cmcd_cash_recd_val is null or p_cmcd_cash_recd_val = l_hr_api_g_number)) or
909: (p_rld_up_val is not null and p_rld_up_val <> l_hr_api_g_number and
910: (p_cmcd_rld_up_val is null or p_cmcd_rld_up_val = l_hr_api_g_number)) then
911: -- get the communicated and annual values
912: ben_update_ledgers.get_cmcd_ann_values
913: (p_bnft_prvdd_ldgr_id => p_bnft_prvdd_ldgr_id,
914: p_acty_base_rt_id => p_acty_base_rt_id,

Line 1018: when hr_api.cannot_find_prog_unit then

1014: p_ann_used_val => l_ann_used_val,
1015: p_ann_cash_recd_val => l_ann_cash_recd_val
1016: );
1017: exception
1018: when hr_api.cannot_find_prog_unit then
1019: hr_api.cannot_find_prog_unit_error
1020: (p_module_name => 'UPDATE_Benefit_Prvdd_Ledger'
1021: ,p_hook_type => 'BP'
1022: );

Line 1019: hr_api.cannot_find_prog_unit_error

1015: p_ann_cash_recd_val => l_ann_cash_recd_val
1016: );
1017: exception
1018: when hr_api.cannot_find_prog_unit then
1019: hr_api.cannot_find_prog_unit_error
1020: (p_module_name => 'UPDATE_Benefit_Prvdd_Ledger'
1021: ,p_hook_type => 'BP'
1022: );
1023: --

Line 1160: when hr_api.cannot_find_prog_unit then

1156: p_ann_used_val => l_ann_used_val,
1157: p_ann_cash_recd_val => l_ann_cash_recd_val
1158: );
1159: exception
1160: when hr_api.cannot_find_prog_unit then
1161: hr_api.cannot_find_prog_unit_error
1162: (p_module_name => 'UPDATE_Benefit_Prvdd_Ledger'
1163: ,p_hook_type => 'AP'
1164: );

Line 1161: hr_api.cannot_find_prog_unit_error

1157: p_ann_cash_recd_val => l_ann_cash_recd_val
1158: );
1159: exception
1160: when hr_api.cannot_find_prog_unit then
1161: hr_api.cannot_find_prog_unit_error
1162: (p_module_name => 'UPDATE_Benefit_Prvdd_Ledger'
1163: ,p_hook_type => 'AP'
1164: );
1165: --

Line 1177: raise hr_api.validate_enabled;

1173: --
1174: -- When in validation only mode raise the Validate_Enabled exception
1175: --
1176: if p_validate then
1177: raise hr_api.validate_enabled;
1178: end if;
1179: --
1180: -- Set all output arguments
1181: --

Line 1190: when hr_api.validate_enabled then

1186: hr_utility.set_location(' Leaving:'||l_proc, 70);
1187: --
1188: exception
1189: --
1190: when hr_api.validate_enabled then
1191: --
1192: -- As the Validate_Enabled exception has been raised
1193: -- we must rollback to the savepoint
1194: --

Line 1224: ,p_prtt_ro_of_unusd_amt_flag in varchar2 default hr_api.g_varchar2

1220: (p_validate in varchar2 default 'FALSE'
1221: ,p_bnft_prvdd_ldgr_id in number
1222: ,p_effective_start_date out nocopy date
1223: ,p_effective_end_date out nocopy date
1224: ,p_prtt_ro_of_unusd_amt_flag in varchar2 default hr_api.g_varchar2
1225: ,p_frftd_val in number default hr_api.g_number
1226: ,p_prvdd_val in number default hr_api.g_number
1227: ,p_used_val in number default hr_api.g_number
1228: ,p_bnft_prvdr_pool_id in number default hr_api.g_number

Line 1225: ,p_frftd_val in number default hr_api.g_number

1221: ,p_bnft_prvdd_ldgr_id in number
1222: ,p_effective_start_date out nocopy date
1223: ,p_effective_end_date out nocopy date
1224: ,p_prtt_ro_of_unusd_amt_flag in varchar2 default hr_api.g_varchar2
1225: ,p_frftd_val in number default hr_api.g_number
1226: ,p_prvdd_val in number default hr_api.g_number
1227: ,p_used_val in number default hr_api.g_number
1228: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1229: ,p_acty_base_rt_id in number default hr_api.g_number

Line 1226: ,p_prvdd_val in number default hr_api.g_number

1222: ,p_effective_start_date out nocopy date
1223: ,p_effective_end_date out nocopy date
1224: ,p_prtt_ro_of_unusd_amt_flag in varchar2 default hr_api.g_varchar2
1225: ,p_frftd_val in number default hr_api.g_number
1226: ,p_prvdd_val in number default hr_api.g_number
1227: ,p_used_val in number default hr_api.g_number
1228: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1229: ,p_acty_base_rt_id in number default hr_api.g_number
1230: ,p_per_in_ler_id in number default hr_api.g_number

Line 1227: ,p_used_val in number default hr_api.g_number

1223: ,p_effective_end_date out nocopy date
1224: ,p_prtt_ro_of_unusd_amt_flag in varchar2 default hr_api.g_varchar2
1225: ,p_frftd_val in number default hr_api.g_number
1226: ,p_prvdd_val in number default hr_api.g_number
1227: ,p_used_val in number default hr_api.g_number
1228: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1229: ,p_acty_base_rt_id in number default hr_api.g_number
1230: ,p_per_in_ler_id in number default hr_api.g_number
1231: ,p_prtt_enrt_rslt_id in number default hr_api.g_number

Line 1228: ,p_bnft_prvdr_pool_id in number default hr_api.g_number

1224: ,p_prtt_ro_of_unusd_amt_flag in varchar2 default hr_api.g_varchar2
1225: ,p_frftd_val in number default hr_api.g_number
1226: ,p_prvdd_val in number default hr_api.g_number
1227: ,p_used_val in number default hr_api.g_number
1228: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1229: ,p_acty_base_rt_id in number default hr_api.g_number
1230: ,p_per_in_ler_id in number default hr_api.g_number
1231: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1232: ,p_business_group_id in number default hr_api.g_number

Line 1229: ,p_acty_base_rt_id in number default hr_api.g_number

1225: ,p_frftd_val in number default hr_api.g_number
1226: ,p_prvdd_val in number default hr_api.g_number
1227: ,p_used_val in number default hr_api.g_number
1228: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1229: ,p_acty_base_rt_id in number default hr_api.g_number
1230: ,p_per_in_ler_id in number default hr_api.g_number
1231: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1232: ,p_business_group_id in number default hr_api.g_number
1233: ,p_cash_recd_val in number default hr_api.g_number

Line 1230: ,p_per_in_ler_id in number default hr_api.g_number

1226: ,p_prvdd_val in number default hr_api.g_number
1227: ,p_used_val in number default hr_api.g_number
1228: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1229: ,p_acty_base_rt_id in number default hr_api.g_number
1230: ,p_per_in_ler_id in number default hr_api.g_number
1231: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1232: ,p_business_group_id in number default hr_api.g_number
1233: ,p_cash_recd_val in number default hr_api.g_number
1234: ,p_rld_up_val in number default hr_api.g_number

Line 1231: ,p_prtt_enrt_rslt_id in number default hr_api.g_number

1227: ,p_used_val in number default hr_api.g_number
1228: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1229: ,p_acty_base_rt_id in number default hr_api.g_number
1230: ,p_per_in_ler_id in number default hr_api.g_number
1231: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1232: ,p_business_group_id in number default hr_api.g_number
1233: ,p_cash_recd_val in number default hr_api.g_number
1234: ,p_rld_up_val in number default hr_api.g_number
1235: ,p_effective_date in date

Line 1232: ,p_business_group_id in number default hr_api.g_number

1228: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1229: ,p_acty_base_rt_id in number default hr_api.g_number
1230: ,p_per_in_ler_id in number default hr_api.g_number
1231: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1232: ,p_business_group_id in number default hr_api.g_number
1233: ,p_cash_recd_val in number default hr_api.g_number
1234: ,p_rld_up_val in number default hr_api.g_number
1235: ,p_effective_date in date
1236: ,p_datetrack_mode in varchar2

Line 1233: ,p_cash_recd_val in number default hr_api.g_number

1229: ,p_acty_base_rt_id in number default hr_api.g_number
1230: ,p_per_in_ler_id in number default hr_api.g_number
1231: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1232: ,p_business_group_id in number default hr_api.g_number
1233: ,p_cash_recd_val in number default hr_api.g_number
1234: ,p_rld_up_val in number default hr_api.g_number
1235: ,p_effective_date in date
1236: ,p_datetrack_mode in varchar2
1237: ,p_process_enrt_flag in varchar2 default 'Y'

Line 1234: ,p_rld_up_val in number default hr_api.g_number

1230: ,p_per_in_ler_id in number default hr_api.g_number
1231: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1232: ,p_business_group_id in number default hr_api.g_number
1233: ,p_cash_recd_val in number default hr_api.g_number
1234: ,p_rld_up_val in number default hr_api.g_number
1235: ,p_effective_date in date
1236: ,p_datetrack_mode in varchar2
1237: ,p_process_enrt_flag in varchar2 default 'Y'
1238: ,p_from_reinstate_enrt_flag in varchar2 default 'N',

Line 1239: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,

1235: ,p_effective_date in date
1236: ,p_datetrack_mode in varchar2
1237: ,p_process_enrt_flag in varchar2 default 'Y'
1238: ,p_from_reinstate_enrt_flag in varchar2 default 'N',
1239: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
1240: p_cmcd_frftd_val in number default hr_api.g_number,
1241: p_cmcd_prvdd_val in number default hr_api.g_number,
1242: p_cmcd_rld_up_val in number default hr_api.g_number,
1243: p_cmcd_used_val in number default hr_api.g_number,

Line 1240: p_cmcd_frftd_val in number default hr_api.g_number,

1236: ,p_datetrack_mode in varchar2
1237: ,p_process_enrt_flag in varchar2 default 'Y'
1238: ,p_from_reinstate_enrt_flag in varchar2 default 'N',
1239: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
1240: p_cmcd_frftd_val in number default hr_api.g_number,
1241: p_cmcd_prvdd_val in number default hr_api.g_number,
1242: p_cmcd_rld_up_val in number default hr_api.g_number,
1243: p_cmcd_used_val in number default hr_api.g_number,
1244: p_cmcd_cash_recd_val in number default hr_api.g_number,

Line 1241: p_cmcd_prvdd_val in number default hr_api.g_number,

1237: ,p_process_enrt_flag in varchar2 default 'Y'
1238: ,p_from_reinstate_enrt_flag in varchar2 default 'N',
1239: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
1240: p_cmcd_frftd_val in number default hr_api.g_number,
1241: p_cmcd_prvdd_val in number default hr_api.g_number,
1242: p_cmcd_rld_up_val in number default hr_api.g_number,
1243: p_cmcd_used_val in number default hr_api.g_number,
1244: p_cmcd_cash_recd_val in number default hr_api.g_number,
1245: p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,

Line 1242: p_cmcd_rld_up_val in number default hr_api.g_number,

1238: ,p_from_reinstate_enrt_flag in varchar2 default 'N',
1239: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
1240: p_cmcd_frftd_val in number default hr_api.g_number,
1241: p_cmcd_prvdd_val in number default hr_api.g_number,
1242: p_cmcd_rld_up_val in number default hr_api.g_number,
1243: p_cmcd_used_val in number default hr_api.g_number,
1244: p_cmcd_cash_recd_val in number default hr_api.g_number,
1245: p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,
1246: p_ann_frftd_val in number default hr_api.g_number,

Line 1243: p_cmcd_used_val in number default hr_api.g_number,

1239: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
1240: p_cmcd_frftd_val in number default hr_api.g_number,
1241: p_cmcd_prvdd_val in number default hr_api.g_number,
1242: p_cmcd_rld_up_val in number default hr_api.g_number,
1243: p_cmcd_used_val in number default hr_api.g_number,
1244: p_cmcd_cash_recd_val in number default hr_api.g_number,
1245: p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,
1246: p_ann_frftd_val in number default hr_api.g_number,
1247: p_ann_prvdd_val in number default hr_api.g_number,

Line 1244: p_cmcd_cash_recd_val in number default hr_api.g_number,

1240: p_cmcd_frftd_val in number default hr_api.g_number,
1241: p_cmcd_prvdd_val in number default hr_api.g_number,
1242: p_cmcd_rld_up_val in number default hr_api.g_number,
1243: p_cmcd_used_val in number default hr_api.g_number,
1244: p_cmcd_cash_recd_val in number default hr_api.g_number,
1245: p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,
1246: p_ann_frftd_val in number default hr_api.g_number,
1247: p_ann_prvdd_val in number default hr_api.g_number,
1248: p_ann_rld_up_val in number default hr_api.g_number,

Line 1245: p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,

1241: p_cmcd_prvdd_val in number default hr_api.g_number,
1242: p_cmcd_rld_up_val in number default hr_api.g_number,
1243: p_cmcd_used_val in number default hr_api.g_number,
1244: p_cmcd_cash_recd_val in number default hr_api.g_number,
1245: p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,
1246: p_ann_frftd_val in number default hr_api.g_number,
1247: p_ann_prvdd_val in number default hr_api.g_number,
1248: p_ann_rld_up_val in number default hr_api.g_number,
1249: p_ann_used_val in number default hr_api.g_number,

Line 1246: p_ann_frftd_val in number default hr_api.g_number,

1242: p_cmcd_rld_up_val in number default hr_api.g_number,
1243: p_cmcd_used_val in number default hr_api.g_number,
1244: p_cmcd_cash_recd_val in number default hr_api.g_number,
1245: p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,
1246: p_ann_frftd_val in number default hr_api.g_number,
1247: p_ann_prvdd_val in number default hr_api.g_number,
1248: p_ann_rld_up_val in number default hr_api.g_number,
1249: p_ann_used_val in number default hr_api.g_number,
1250: p_ann_cash_recd_val in number default hr_api.g_number,

Line 1247: p_ann_prvdd_val in number default hr_api.g_number,

1243: p_cmcd_used_val in number default hr_api.g_number,
1244: p_cmcd_cash_recd_val in number default hr_api.g_number,
1245: p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,
1246: p_ann_frftd_val in number default hr_api.g_number,
1247: p_ann_prvdd_val in number default hr_api.g_number,
1248: p_ann_rld_up_val in number default hr_api.g_number,
1249: p_ann_used_val in number default hr_api.g_number,
1250: p_ann_cash_recd_val in number default hr_api.g_number,
1251: p_object_version_number in out nocopy number

Line 1248: p_ann_rld_up_val in number default hr_api.g_number,

1244: p_cmcd_cash_recd_val in number default hr_api.g_number,
1245: p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,
1246: p_ann_frftd_val in number default hr_api.g_number,
1247: p_ann_prvdd_val in number default hr_api.g_number,
1248: p_ann_rld_up_val in number default hr_api.g_number,
1249: p_ann_used_val in number default hr_api.g_number,
1250: p_ann_cash_recd_val in number default hr_api.g_number,
1251: p_object_version_number in out nocopy number
1252: ) is

Line 1249: p_ann_used_val in number default hr_api.g_number,

1245: p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,
1246: p_ann_frftd_val in number default hr_api.g_number,
1247: p_ann_prvdd_val in number default hr_api.g_number,
1248: p_ann_rld_up_val in number default hr_api.g_number,
1249: p_ann_used_val in number default hr_api.g_number,
1250: p_ann_cash_recd_val in number default hr_api.g_number,
1251: p_object_version_number in out nocopy number
1252: ) is
1253: --

Line 1250: p_ann_cash_recd_val in number default hr_api.g_number,

1246: p_ann_frftd_val in number default hr_api.g_number,
1247: p_ann_prvdd_val in number default hr_api.g_number,
1248: p_ann_rld_up_val in number default hr_api.g_number,
1249: p_ann_used_val in number default hr_api.g_number,
1250: p_ann_cash_recd_val in number default hr_api.g_number,
1251: p_object_version_number in out nocopy number
1252: ) is
1253: --
1254: -- Declare cursors and local variables

Line 1432: when hr_api.cannot_find_prog_unit then

1428: ,p_effective_date => trunc(p_effective_date)
1429: ,p_datetrack_mode => p_datetrack_mode
1430: );
1431: exception
1432: when hr_api.cannot_find_prog_unit then
1433: hr_api.cannot_find_prog_unit_error
1434: (p_module_name => 'DELETE_Benefit_Prvdd_Ledger'
1435: ,p_hook_type => 'BP'
1436: );

Line 1433: hr_api.cannot_find_prog_unit_error

1429: ,p_datetrack_mode => p_datetrack_mode
1430: );
1431: exception
1432: when hr_api.cannot_find_prog_unit then
1433: hr_api.cannot_find_prog_unit_error
1434: (p_module_name => 'DELETE_Benefit_Prvdd_Ledger'
1435: ,p_hook_type => 'BP'
1436: );
1437: --

Line 1542: when hr_api.cannot_find_prog_unit then

1538: ,p_effective_date => trunc(p_effective_date)
1539: ,p_datetrack_mode => p_datetrack_mode
1540: );
1541: exception
1542: when hr_api.cannot_find_prog_unit then
1543: hr_api.cannot_find_prog_unit_error
1544: (p_module_name => 'DELETE_Benefit_Prvdd_Ledger'
1545: ,p_hook_type => 'AP'
1546: );

Line 1543: hr_api.cannot_find_prog_unit_error

1539: ,p_datetrack_mode => p_datetrack_mode
1540: );
1541: exception
1542: when hr_api.cannot_find_prog_unit then
1543: hr_api.cannot_find_prog_unit_error
1544: (p_module_name => 'DELETE_Benefit_Prvdd_Ledger'
1545: ,p_hook_type => 'AP'
1546: );
1547: --

Line 1557: raise hr_api.validate_enabled;

1553: --
1554: -- When in validation only mode raise the Validate_Enabled exception
1555: --
1556: if p_validate then
1557: raise hr_api.validate_enabled;
1558: end if;
1559: --
1560: hr_utility.set_location(' Leaving:'||l_proc, 70);
1561: --

Line 1564: when hr_api.validate_enabled then

1560: hr_utility.set_location(' Leaving:'||l_proc, 70);
1561: --
1562: exception
1563: --
1564: when hr_api.validate_enabled then
1565: --
1566: -- As the Validate_Enabled exception has been raised
1567: -- we must rollback to the savepoint
1568: --