APPS.BEN_CLOSE_ENROLLMENT dependencies on HR_API

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

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

Line 551: and pen.effective_end_date = hr_api.g_eot

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

Line 565: hr_api_transactions txn,

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

Line 566: hr_api_transaction_steps step ,

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

Line 567: hr_api_transaction_values vlv,

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

Line 700: hr_api.mandatory_arg_error(p_api_name => l_proc

696: hr_utility.set_location ('Entering '||l_proc,10);
697: --
698: -- Make sure all the mandatory input parameters are not null
699: --
700: hr_api.mandatory_arg_error(p_api_name => l_proc
701: ,p_argument => 'p_per_in_ler_id'
702: ,p_argument_value => p_effective_date);
703: --
704: hr_api.mandatory_arg_error(p_api_name => l_proc

Line 704: hr_api.mandatory_arg_error(p_api_name => l_proc

700: hr_api.mandatory_arg_error(p_api_name => l_proc
701: ,p_argument => 'p_per_in_ler_id'
702: ,p_argument_value => p_effective_date);
703: --
704: hr_api.mandatory_arg_error(p_api_name => l_proc
705: ,p_argument => 'p_effective_date'
706: ,p_argument_value => p_effective_date);
707: --
708: hr_api.mandatory_arg_error(p_api_name => l_proc

Line 708: hr_api.mandatory_arg_error(p_api_name => l_proc

704: hr_api.mandatory_arg_error(p_api_name => l_proc
705: ,p_argument => 'p_effective_date'
706: ,p_argument_value => p_effective_date);
707: --
708: hr_api.mandatory_arg_error(p_api_name => l_proc
709: ,p_argument => 'p_business_group_id'
710: ,p_argument_value => p_business_group_id);
711: -- Add environment init procedure
712: --

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

1310: ,p_effective_date => p_effective_date
1311: ,p_business_group_id => p_business_group_id
1312: ,p_per_in_ler_stat_cd => 'PROCD'
1313: ,p_object_version_number => l_object_version_number
1314: ,p_datetrack_mode => hr_api.g_correction);
1315: end if;
1316: --
1317: -- Update person life event logging information to show event was
1318: -- closed but also created electable choices which must have been

Line 2062: hr_api.mandatory_arg_error

2058: end if;
2059: --
2060: -- Check business rules and mandatory parameters
2061: --
2062: hr_api.mandatory_arg_error
2063: (p_api_name => l_proc
2064: ,p_argument => 'p_effective_date'
2065: ,p_argument_value => l_effective_date);
2066: --