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 895: if (p_frftd_val is not null and p_frftd_val <> l_hr_api_g_number and

891: end if;
892: -- Bug: 3611160/4169180 Changes end...
893: end if;
894:
895: if (p_frftd_val is not null and p_frftd_val <> l_hr_api_g_number and
896: (p_cmcd_frftd_val is null or p_cmcd_frftd_val = l_hr_api_g_number)) or
897: (p_used_val is not null and p_used_val <> l_hr_api_g_number and
898: (p_cmcd_used_val is null or p_cmcd_used_val = l_hr_api_g_number)) or
899: (p_prvdd_val is not null and p_prvdd_val <> l_hr_api_g_number and

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

892: -- Bug: 3611160/4169180 Changes end...
893: end if;
894:
895: if (p_frftd_val is not null and p_frftd_val <> l_hr_api_g_number and
896: (p_cmcd_frftd_val is null or p_cmcd_frftd_val = l_hr_api_g_number)) or
897: (p_used_val is not null and p_used_val <> l_hr_api_g_number and
898: (p_cmcd_used_val is null or p_cmcd_used_val = l_hr_api_g_number)) or
899: (p_prvdd_val is not null and p_prvdd_val <> l_hr_api_g_number and
900: (p_cmcd_prvdd_val is null or p_cmcd_prvdd_val = l_hr_api_g_number)) or

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

893: end if;
894:
895: if (p_frftd_val is not null and p_frftd_val <> l_hr_api_g_number and
896: (p_cmcd_frftd_val is null or p_cmcd_frftd_val = l_hr_api_g_number)) or
897: (p_used_val is not null and p_used_val <> l_hr_api_g_number and
898: (p_cmcd_used_val is null or p_cmcd_used_val = l_hr_api_g_number)) or
899: (p_prvdd_val is not null and p_prvdd_val <> l_hr_api_g_number and
900: (p_cmcd_prvdd_val is null or p_cmcd_prvdd_val = l_hr_api_g_number)) or
901: (p_cash_recd_val is not null and p_cash_recd_val <> l_hr_api_g_number and

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

894:
895: if (p_frftd_val is not null and p_frftd_val <> l_hr_api_g_number and
896: (p_cmcd_frftd_val is null or p_cmcd_frftd_val = l_hr_api_g_number)) or
897: (p_used_val is not null and p_used_val <> l_hr_api_g_number and
898: (p_cmcd_used_val is null or p_cmcd_used_val = l_hr_api_g_number)) or
899: (p_prvdd_val is not null and p_prvdd_val <> l_hr_api_g_number and
900: (p_cmcd_prvdd_val is null or p_cmcd_prvdd_val = l_hr_api_g_number)) or
901: (p_cash_recd_val is not null and p_cash_recd_val <> l_hr_api_g_number and
902: (p_cmcd_cash_recd_val is null or p_cmcd_cash_recd_val = l_hr_api_g_number)) or

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

895: if (p_frftd_val is not null and p_frftd_val <> l_hr_api_g_number and
896: (p_cmcd_frftd_val is null or p_cmcd_frftd_val = l_hr_api_g_number)) or
897: (p_used_val is not null and p_used_val <> l_hr_api_g_number and
898: (p_cmcd_used_val is null or p_cmcd_used_val = l_hr_api_g_number)) or
899: (p_prvdd_val is not null and p_prvdd_val <> l_hr_api_g_number and
900: (p_cmcd_prvdd_val is null or p_cmcd_prvdd_val = l_hr_api_g_number)) or
901: (p_cash_recd_val is not null and p_cash_recd_val <> l_hr_api_g_number and
902: (p_cmcd_cash_recd_val is null or p_cmcd_cash_recd_val = l_hr_api_g_number)) or
903: (p_rld_up_val is not null and p_rld_up_val <> l_hr_api_g_number and

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

896: (p_cmcd_frftd_val is null or p_cmcd_frftd_val = l_hr_api_g_number)) or
897: (p_used_val is not null and p_used_val <> l_hr_api_g_number and
898: (p_cmcd_used_val is null or p_cmcd_used_val = l_hr_api_g_number)) or
899: (p_prvdd_val is not null and p_prvdd_val <> l_hr_api_g_number and
900: (p_cmcd_prvdd_val is null or p_cmcd_prvdd_val = l_hr_api_g_number)) or
901: (p_cash_recd_val is not null and p_cash_recd_val <> l_hr_api_g_number and
902: (p_cmcd_cash_recd_val is null or p_cmcd_cash_recd_val = l_hr_api_g_number)) or
903: (p_rld_up_val is not null and p_rld_up_val <> l_hr_api_g_number and
904: (p_cmcd_rld_up_val is null or p_cmcd_rld_up_val = l_hr_api_g_number)) then

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

897: (p_used_val is not null and p_used_val <> l_hr_api_g_number and
898: (p_cmcd_used_val is null or p_cmcd_used_val = l_hr_api_g_number)) or
899: (p_prvdd_val is not null and p_prvdd_val <> l_hr_api_g_number and
900: (p_cmcd_prvdd_val is null or p_cmcd_prvdd_val = l_hr_api_g_number)) or
901: (p_cash_recd_val is not null and p_cash_recd_val <> l_hr_api_g_number and
902: (p_cmcd_cash_recd_val is null or p_cmcd_cash_recd_val = l_hr_api_g_number)) or
903: (p_rld_up_val is not null and p_rld_up_val <> l_hr_api_g_number and
904: (p_cmcd_rld_up_val is null or p_cmcd_rld_up_val = l_hr_api_g_number)) then
905: -- get the communicated and annual values

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

898: (p_cmcd_used_val is null or p_cmcd_used_val = l_hr_api_g_number)) or
899: (p_prvdd_val is not null and p_prvdd_val <> l_hr_api_g_number and
900: (p_cmcd_prvdd_val is null or p_cmcd_prvdd_val = l_hr_api_g_number)) or
901: (p_cash_recd_val is not null and p_cash_recd_val <> l_hr_api_g_number and
902: (p_cmcd_cash_recd_val is null or p_cmcd_cash_recd_val = l_hr_api_g_number)) or
903: (p_rld_up_val is not null and p_rld_up_val <> l_hr_api_g_number and
904: (p_cmcd_rld_up_val is null or p_cmcd_rld_up_val = l_hr_api_g_number)) then
905: -- get the communicated and annual values
906: ben_update_ledgers.get_cmcd_ann_values

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

899: (p_prvdd_val is not null and p_prvdd_val <> l_hr_api_g_number and
900: (p_cmcd_prvdd_val is null or p_cmcd_prvdd_val = l_hr_api_g_number)) or
901: (p_cash_recd_val is not null and p_cash_recd_val <> l_hr_api_g_number and
902: (p_cmcd_cash_recd_val is null or p_cmcd_cash_recd_val = l_hr_api_g_number)) or
903: (p_rld_up_val is not null and p_rld_up_val <> l_hr_api_g_number and
904: (p_cmcd_rld_up_val is null or p_cmcd_rld_up_val = l_hr_api_g_number)) then
905: -- get the communicated and annual values
906: ben_update_ledgers.get_cmcd_ann_values
907: (p_bnft_prvdd_ldgr_id => p_bnft_prvdd_ldgr_id,

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

900: (p_cmcd_prvdd_val is null or p_cmcd_prvdd_val = l_hr_api_g_number)) or
901: (p_cash_recd_val is not null and p_cash_recd_val <> l_hr_api_g_number and
902: (p_cmcd_cash_recd_val is null or p_cmcd_cash_recd_val = l_hr_api_g_number)) or
903: (p_rld_up_val is not null and p_rld_up_val <> l_hr_api_g_number and
904: (p_cmcd_rld_up_val is null or p_cmcd_rld_up_val = l_hr_api_g_number)) then
905: -- get the communicated and annual values
906: ben_update_ledgers.get_cmcd_ann_values
907: (p_bnft_prvdd_ldgr_id => p_bnft_prvdd_ldgr_id,
908: p_acty_base_rt_id => p_acty_base_rt_id,

Line 1012: when hr_api.cannot_find_prog_unit then

1008: p_ann_used_val => l_ann_used_val,
1009: p_ann_cash_recd_val => l_ann_cash_recd_val
1010: );
1011: exception
1012: when hr_api.cannot_find_prog_unit then
1013: hr_api.cannot_find_prog_unit_error
1014: (p_module_name => 'UPDATE_Benefit_Prvdd_Ledger'
1015: ,p_hook_type => 'BP'
1016: );

Line 1013: hr_api.cannot_find_prog_unit_error

1009: p_ann_cash_recd_val => l_ann_cash_recd_val
1010: );
1011: exception
1012: when hr_api.cannot_find_prog_unit then
1013: hr_api.cannot_find_prog_unit_error
1014: (p_module_name => 'UPDATE_Benefit_Prvdd_Ledger'
1015: ,p_hook_type => 'BP'
1016: );
1017: --

Line 1154: when hr_api.cannot_find_prog_unit then

1150: p_ann_used_val => l_ann_used_val,
1151: p_ann_cash_recd_val => l_ann_cash_recd_val
1152: );
1153: exception
1154: when hr_api.cannot_find_prog_unit then
1155: hr_api.cannot_find_prog_unit_error
1156: (p_module_name => 'UPDATE_Benefit_Prvdd_Ledger'
1157: ,p_hook_type => 'AP'
1158: );

Line 1155: hr_api.cannot_find_prog_unit_error

1151: p_ann_cash_recd_val => l_ann_cash_recd_val
1152: );
1153: exception
1154: when hr_api.cannot_find_prog_unit then
1155: hr_api.cannot_find_prog_unit_error
1156: (p_module_name => 'UPDATE_Benefit_Prvdd_Ledger'
1157: ,p_hook_type => 'AP'
1158: );
1159: --

Line 1171: raise hr_api.validate_enabled;

1167: --
1168: -- When in validation only mode raise the Validate_Enabled exception
1169: --
1170: if p_validate then
1171: raise hr_api.validate_enabled;
1172: end if;
1173: --
1174: -- Set all output arguments
1175: --

Line 1184: when hr_api.validate_enabled then

1180: hr_utility.set_location(' Leaving:'||l_proc, 70);
1181: --
1182: exception
1183: --
1184: when hr_api.validate_enabled then
1185: --
1186: -- As the Validate_Enabled exception has been raised
1187: -- we must rollback to the savepoint
1188: --

Line 1218: ,p_prtt_ro_of_unusd_amt_flag in varchar2 default hr_api.g_varchar2

1214: (p_validate in varchar2 default 'FALSE'
1215: ,p_bnft_prvdd_ldgr_id in number
1216: ,p_effective_start_date out nocopy date
1217: ,p_effective_end_date out nocopy date
1218: ,p_prtt_ro_of_unusd_amt_flag in varchar2 default hr_api.g_varchar2
1219: ,p_frftd_val in number default hr_api.g_number
1220: ,p_prvdd_val in number default hr_api.g_number
1221: ,p_used_val in number default hr_api.g_number
1222: ,p_bnft_prvdr_pool_id in number default hr_api.g_number

Line 1219: ,p_frftd_val in number default hr_api.g_number

1215: ,p_bnft_prvdd_ldgr_id in number
1216: ,p_effective_start_date out nocopy date
1217: ,p_effective_end_date out nocopy date
1218: ,p_prtt_ro_of_unusd_amt_flag in varchar2 default hr_api.g_varchar2
1219: ,p_frftd_val in number default hr_api.g_number
1220: ,p_prvdd_val in number default hr_api.g_number
1221: ,p_used_val in number default hr_api.g_number
1222: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1223: ,p_acty_base_rt_id in number default hr_api.g_number

Line 1220: ,p_prvdd_val in number default hr_api.g_number

1216: ,p_effective_start_date out nocopy date
1217: ,p_effective_end_date out nocopy date
1218: ,p_prtt_ro_of_unusd_amt_flag in varchar2 default hr_api.g_varchar2
1219: ,p_frftd_val in number default hr_api.g_number
1220: ,p_prvdd_val in number default hr_api.g_number
1221: ,p_used_val in number default hr_api.g_number
1222: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1223: ,p_acty_base_rt_id in number default hr_api.g_number
1224: ,p_per_in_ler_id in number default hr_api.g_number

Line 1221: ,p_used_val in number default hr_api.g_number

1217: ,p_effective_end_date out nocopy date
1218: ,p_prtt_ro_of_unusd_amt_flag in varchar2 default hr_api.g_varchar2
1219: ,p_frftd_val in number default hr_api.g_number
1220: ,p_prvdd_val in number default hr_api.g_number
1221: ,p_used_val in number default hr_api.g_number
1222: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1223: ,p_acty_base_rt_id in number default hr_api.g_number
1224: ,p_per_in_ler_id in number default hr_api.g_number
1225: ,p_prtt_enrt_rslt_id in number default hr_api.g_number

Line 1222: ,p_bnft_prvdr_pool_id in number default hr_api.g_number

1218: ,p_prtt_ro_of_unusd_amt_flag in varchar2 default hr_api.g_varchar2
1219: ,p_frftd_val in number default hr_api.g_number
1220: ,p_prvdd_val in number default hr_api.g_number
1221: ,p_used_val in number default hr_api.g_number
1222: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1223: ,p_acty_base_rt_id in number default hr_api.g_number
1224: ,p_per_in_ler_id in number default hr_api.g_number
1225: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1226: ,p_business_group_id in number default hr_api.g_number

Line 1223: ,p_acty_base_rt_id in number default hr_api.g_number

1219: ,p_frftd_val in number default hr_api.g_number
1220: ,p_prvdd_val in number default hr_api.g_number
1221: ,p_used_val in number default hr_api.g_number
1222: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1223: ,p_acty_base_rt_id in number default hr_api.g_number
1224: ,p_per_in_ler_id in number default hr_api.g_number
1225: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1226: ,p_business_group_id in number default hr_api.g_number
1227: ,p_cash_recd_val in number default hr_api.g_number

Line 1224: ,p_per_in_ler_id in number default hr_api.g_number

1220: ,p_prvdd_val in number default hr_api.g_number
1221: ,p_used_val in number default hr_api.g_number
1222: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1223: ,p_acty_base_rt_id in number default hr_api.g_number
1224: ,p_per_in_ler_id in number default hr_api.g_number
1225: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1226: ,p_business_group_id in number default hr_api.g_number
1227: ,p_cash_recd_val in number default hr_api.g_number
1228: ,p_rld_up_val in number default hr_api.g_number

Line 1225: ,p_prtt_enrt_rslt_id in number default hr_api.g_number

1221: ,p_used_val in number default hr_api.g_number
1222: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1223: ,p_acty_base_rt_id in number default hr_api.g_number
1224: ,p_per_in_ler_id in number default hr_api.g_number
1225: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1226: ,p_business_group_id in number default hr_api.g_number
1227: ,p_cash_recd_val in number default hr_api.g_number
1228: ,p_rld_up_val in number default hr_api.g_number
1229: ,p_effective_date in date

Line 1226: ,p_business_group_id in number default hr_api.g_number

1222: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1223: ,p_acty_base_rt_id in number default hr_api.g_number
1224: ,p_per_in_ler_id in number default hr_api.g_number
1225: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1226: ,p_business_group_id in number default hr_api.g_number
1227: ,p_cash_recd_val in number default hr_api.g_number
1228: ,p_rld_up_val in number default hr_api.g_number
1229: ,p_effective_date in date
1230: ,p_datetrack_mode in varchar2

Line 1227: ,p_cash_recd_val in number default hr_api.g_number

1223: ,p_acty_base_rt_id in number default hr_api.g_number
1224: ,p_per_in_ler_id in number default hr_api.g_number
1225: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1226: ,p_business_group_id in number default hr_api.g_number
1227: ,p_cash_recd_val in number default hr_api.g_number
1228: ,p_rld_up_val in number default hr_api.g_number
1229: ,p_effective_date in date
1230: ,p_datetrack_mode in varchar2
1231: ,p_process_enrt_flag in varchar2 default 'Y'

Line 1228: ,p_rld_up_val in number default hr_api.g_number

1224: ,p_per_in_ler_id in number default hr_api.g_number
1225: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1226: ,p_business_group_id in number default hr_api.g_number
1227: ,p_cash_recd_val in number default hr_api.g_number
1228: ,p_rld_up_val in number default hr_api.g_number
1229: ,p_effective_date in date
1230: ,p_datetrack_mode in varchar2
1231: ,p_process_enrt_flag in varchar2 default 'Y'
1232: ,p_from_reinstate_enrt_flag in varchar2 default 'N',

Line 1233: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,

1229: ,p_effective_date in date
1230: ,p_datetrack_mode in varchar2
1231: ,p_process_enrt_flag in varchar2 default 'Y'
1232: ,p_from_reinstate_enrt_flag in varchar2 default 'N',
1233: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
1234: p_cmcd_frftd_val in number default hr_api.g_number,
1235: p_cmcd_prvdd_val in number default hr_api.g_number,
1236: p_cmcd_rld_up_val in number default hr_api.g_number,
1237: p_cmcd_used_val in number default hr_api.g_number,

Line 1234: p_cmcd_frftd_val in number default hr_api.g_number,

1230: ,p_datetrack_mode in varchar2
1231: ,p_process_enrt_flag in varchar2 default 'Y'
1232: ,p_from_reinstate_enrt_flag in varchar2 default 'N',
1233: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
1234: p_cmcd_frftd_val in number default hr_api.g_number,
1235: p_cmcd_prvdd_val in number default hr_api.g_number,
1236: p_cmcd_rld_up_val in number default hr_api.g_number,
1237: p_cmcd_used_val in number default hr_api.g_number,
1238: p_cmcd_cash_recd_val in number default hr_api.g_number,

Line 1235: p_cmcd_prvdd_val in number default hr_api.g_number,

1231: ,p_process_enrt_flag in varchar2 default 'Y'
1232: ,p_from_reinstate_enrt_flag in varchar2 default 'N',
1233: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
1234: p_cmcd_frftd_val in number default hr_api.g_number,
1235: p_cmcd_prvdd_val in number default hr_api.g_number,
1236: p_cmcd_rld_up_val in number default hr_api.g_number,
1237: p_cmcd_used_val in number default hr_api.g_number,
1238: p_cmcd_cash_recd_val in number default hr_api.g_number,
1239: p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,

Line 1236: p_cmcd_rld_up_val in number default hr_api.g_number,

1232: ,p_from_reinstate_enrt_flag in varchar2 default 'N',
1233: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
1234: p_cmcd_frftd_val in number default hr_api.g_number,
1235: p_cmcd_prvdd_val in number default hr_api.g_number,
1236: p_cmcd_rld_up_val in number default hr_api.g_number,
1237: p_cmcd_used_val in number default hr_api.g_number,
1238: p_cmcd_cash_recd_val in number default hr_api.g_number,
1239: p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,
1240: p_ann_frftd_val in number default hr_api.g_number,

Line 1237: p_cmcd_used_val in number default hr_api.g_number,

1233: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
1234: p_cmcd_frftd_val in number default hr_api.g_number,
1235: p_cmcd_prvdd_val in number default hr_api.g_number,
1236: p_cmcd_rld_up_val in number default hr_api.g_number,
1237: p_cmcd_used_val in number default hr_api.g_number,
1238: p_cmcd_cash_recd_val in number default hr_api.g_number,
1239: p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,
1240: p_ann_frftd_val in number default hr_api.g_number,
1241: p_ann_prvdd_val in number default hr_api.g_number,

Line 1238: p_cmcd_cash_recd_val in number default hr_api.g_number,

1234: p_cmcd_frftd_val in number default hr_api.g_number,
1235: p_cmcd_prvdd_val in number default hr_api.g_number,
1236: p_cmcd_rld_up_val in number default hr_api.g_number,
1237: p_cmcd_used_val in number default hr_api.g_number,
1238: p_cmcd_cash_recd_val in number default hr_api.g_number,
1239: p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,
1240: p_ann_frftd_val in number default hr_api.g_number,
1241: p_ann_prvdd_val in number default hr_api.g_number,
1242: p_ann_rld_up_val in number default hr_api.g_number,

Line 1239: p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,

1235: p_cmcd_prvdd_val in number default hr_api.g_number,
1236: p_cmcd_rld_up_val in number default hr_api.g_number,
1237: p_cmcd_used_val in number default hr_api.g_number,
1238: p_cmcd_cash_recd_val in number default hr_api.g_number,
1239: p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,
1240: p_ann_frftd_val in number default hr_api.g_number,
1241: p_ann_prvdd_val in number default hr_api.g_number,
1242: p_ann_rld_up_val in number default hr_api.g_number,
1243: p_ann_used_val in number default hr_api.g_number,

Line 1240: p_ann_frftd_val in number default hr_api.g_number,

1236: p_cmcd_rld_up_val in number default hr_api.g_number,
1237: p_cmcd_used_val in number default hr_api.g_number,
1238: p_cmcd_cash_recd_val in number default hr_api.g_number,
1239: p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,
1240: p_ann_frftd_val in number default hr_api.g_number,
1241: p_ann_prvdd_val in number default hr_api.g_number,
1242: p_ann_rld_up_val in number default hr_api.g_number,
1243: p_ann_used_val in number default hr_api.g_number,
1244: p_ann_cash_recd_val in number default hr_api.g_number,

Line 1241: p_ann_prvdd_val in number default hr_api.g_number,

1237: p_cmcd_used_val in number default hr_api.g_number,
1238: p_cmcd_cash_recd_val in number default hr_api.g_number,
1239: p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,
1240: p_ann_frftd_val in number default hr_api.g_number,
1241: p_ann_prvdd_val in number default hr_api.g_number,
1242: p_ann_rld_up_val in number default hr_api.g_number,
1243: p_ann_used_val in number default hr_api.g_number,
1244: p_ann_cash_recd_val in number default hr_api.g_number,
1245: p_object_version_number in out nocopy number

Line 1242: p_ann_rld_up_val in number default hr_api.g_number,

1238: p_cmcd_cash_recd_val in number default hr_api.g_number,
1239: p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,
1240: p_ann_frftd_val in number default hr_api.g_number,
1241: p_ann_prvdd_val in number default hr_api.g_number,
1242: p_ann_rld_up_val in number default hr_api.g_number,
1243: p_ann_used_val in number default hr_api.g_number,
1244: p_ann_cash_recd_val in number default hr_api.g_number,
1245: p_object_version_number in out nocopy number
1246: ) is

Line 1243: p_ann_used_val in number default hr_api.g_number,

1239: p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,
1240: p_ann_frftd_val in number default hr_api.g_number,
1241: p_ann_prvdd_val in number default hr_api.g_number,
1242: p_ann_rld_up_val in number default hr_api.g_number,
1243: p_ann_used_val in number default hr_api.g_number,
1244: p_ann_cash_recd_val in number default hr_api.g_number,
1245: p_object_version_number in out nocopy number
1246: ) is
1247: --

Line 1244: p_ann_cash_recd_val in number default hr_api.g_number,

1240: p_ann_frftd_val in number default hr_api.g_number,
1241: p_ann_prvdd_val in number default hr_api.g_number,
1242: p_ann_rld_up_val in number default hr_api.g_number,
1243: p_ann_used_val in number default hr_api.g_number,
1244: p_ann_cash_recd_val in number default hr_api.g_number,
1245: p_object_version_number in out nocopy number
1246: ) is
1247: --
1248: -- Declare cursors and local variables

Line 1426: when hr_api.cannot_find_prog_unit then

1422: ,p_effective_date => trunc(p_effective_date)
1423: ,p_datetrack_mode => p_datetrack_mode
1424: );
1425: exception
1426: when hr_api.cannot_find_prog_unit then
1427: hr_api.cannot_find_prog_unit_error
1428: (p_module_name => 'DELETE_Benefit_Prvdd_Ledger'
1429: ,p_hook_type => 'BP'
1430: );

Line 1427: hr_api.cannot_find_prog_unit_error

1423: ,p_datetrack_mode => p_datetrack_mode
1424: );
1425: exception
1426: when hr_api.cannot_find_prog_unit then
1427: hr_api.cannot_find_prog_unit_error
1428: (p_module_name => 'DELETE_Benefit_Prvdd_Ledger'
1429: ,p_hook_type => 'BP'
1430: );
1431: --

Line 1536: when hr_api.cannot_find_prog_unit then

1532: ,p_effective_date => trunc(p_effective_date)
1533: ,p_datetrack_mode => p_datetrack_mode
1534: );
1535: exception
1536: when hr_api.cannot_find_prog_unit then
1537: hr_api.cannot_find_prog_unit_error
1538: (p_module_name => 'DELETE_Benefit_Prvdd_Ledger'
1539: ,p_hook_type => 'AP'
1540: );

Line 1537: hr_api.cannot_find_prog_unit_error

1533: ,p_datetrack_mode => p_datetrack_mode
1534: );
1535: exception
1536: when hr_api.cannot_find_prog_unit then
1537: hr_api.cannot_find_prog_unit_error
1538: (p_module_name => 'DELETE_Benefit_Prvdd_Ledger'
1539: ,p_hook_type => 'AP'
1540: );
1541: --

Line 1551: raise hr_api.validate_enabled;

1547: --
1548: -- When in validation only mode raise the Validate_Enabled exception
1549: --
1550: if p_validate then
1551: raise hr_api.validate_enabled;
1552: end if;
1553: --
1554: hr_utility.set_location(' Leaving:'||l_proc, 70);
1555: --

Line 1558: when hr_api.validate_enabled then

1554: hr_utility.set_location(' Leaving:'||l_proc, 70);
1555: --
1556: exception
1557: --
1558: when hr_api.validate_enabled then
1559: --
1560: -- As the Validate_Enabled exception has been raised
1561: -- we must rollback to the savepoint
1562: --