APPS.BEN_CLOSE_ENROLLMENT dependencies on HR_API

Line 551: and nvl(pen.enrt_cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot

547: ler_id
548: from ben_prtt_enrt_rslt_f pen
549: where pen.per_in_ler_id = p_per_in_ler_id
550: and pen.no_lngr_elig_flag = 'Y'
551: and nvl(pen.enrt_cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot
552: and pen.effective_end_date = hr_api.g_eot
553: and pen.prtt_enrt_rslt_stat_cd is null
554: and p_effective_date between pen.effective_start_date
555: and pen.effective_end_date

Line 552: and pen.effective_end_date = hr_api.g_eot

548: from ben_prtt_enrt_rslt_f pen
549: where pen.per_in_ler_id = p_per_in_ler_id
550: and pen.no_lngr_elig_flag = 'Y'
551: and nvl(pen.enrt_cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot
552: and pen.effective_end_date = hr_api.g_eot
553: and pen.prtt_enrt_rslt_stat_cd is null
554: and p_effective_date between pen.effective_start_date
555: and pen.effective_end_date
556: and pen.business_group_id = p_business_group_id;

Line 566: hr_api_transactions txn,

562: cursor c_get_pending_approvals is
563: select 'Y'
564: from wf_item_activity_statuses process ,
565: wf_process_activities activity ,
566: hr_api_transactions txn,
567: hr_api_transaction_steps step ,
568: hr_api_transaction_values vlv,
569: wf_item_attribute_values submit_attribute
570: where activity.process_name = 'ROOT'

Line 567: hr_api_transaction_steps step ,

563: select 'Y'
564: from wf_item_activity_statuses process ,
565: wf_process_activities activity ,
566: hr_api_transactions txn,
567: hr_api_transaction_steps step ,
568: hr_api_transaction_values vlv,
569: wf_item_attribute_values submit_attribute
570: where activity.process_name = 'ROOT'
571: and activity.process_item_type = activity.activity_item_type

Line 568: hr_api_transaction_values vlv,

564: from wf_item_activity_statuses process ,
565: wf_process_activities activity ,
566: hr_api_transactions txn,
567: hr_api_transaction_steps step ,
568: hr_api_transaction_values vlv,
569: wf_item_attribute_values submit_attribute
570: where activity.process_name = 'ROOT'
571: and activity.process_item_type = activity.activity_item_type
572: and activity.instance_id = process.process_activity

Line 722: hr_api.mandatory_arg_error(p_api_name => l_proc

718: hr_utility.set_location ('Entering '||l_proc,10);
719: --
720: -- Make sure all the mandatory input parameters are not null
721: --
722: hr_api.mandatory_arg_error(p_api_name => l_proc
723: ,p_argument => 'p_per_in_ler_id'
724: ,p_argument_value => p_effective_date);
725: --
726: hr_api.mandatory_arg_error(p_api_name => l_proc

Line 726: hr_api.mandatory_arg_error(p_api_name => l_proc

722: hr_api.mandatory_arg_error(p_api_name => l_proc
723: ,p_argument => 'p_per_in_ler_id'
724: ,p_argument_value => p_effective_date);
725: --
726: hr_api.mandatory_arg_error(p_api_name => l_proc
727: ,p_argument => 'p_effective_date'
728: ,p_argument_value => p_effective_date);
729: --
730: hr_api.mandatory_arg_error(p_api_name => l_proc

Line 730: hr_api.mandatory_arg_error(p_api_name => l_proc

726: hr_api.mandatory_arg_error(p_api_name => l_proc
727: ,p_argument => 'p_effective_date'
728: ,p_argument_value => p_effective_date);
729: --
730: hr_api.mandatory_arg_error(p_api_name => l_proc
731: ,p_argument => 'p_business_group_id'
732: ,p_argument_value => p_business_group_id);
733: -- Add environment init procedure
734: --

Line 1354: ,p_datetrack_mode => hr_api.g_correction);

1350: ,p_effective_date => p_effective_date
1351: ,p_business_group_id => p_business_group_id
1352: ,p_per_in_ler_stat_cd => 'PROCD'
1353: ,p_object_version_number => l_object_version_number
1354: ,p_datetrack_mode => hr_api.g_correction);
1355: end if;
1356: --
1357: -- Update person life event logging information to show event was
1358: -- closed but also created electable choices which must have been

Line 2102: hr_api.mandatory_arg_error

2098: end if;
2099: --
2100: -- Check business rules and mandatory parameters
2101: --
2102: hr_api.mandatory_arg_error
2103: (p_api_name => l_proc
2104: ,p_argument => 'p_effective_date'
2105: ,p_argument_value => l_effective_date);
2106: --