[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select hats.transaction_step_id
from hr_api_transaction_steps hats
where hats.item_type = p_item_type
and hats.item_key = p_item_key
and hats.activity_id = p_activity_id
and hats.api_name = upper(g_package || 'process_api')
order by hats.transaction_step_id;
,p_rt_update_mode out nocopy varchar2
,p_rtval_rt_strt_dt out nocopy date
,p_nip_pl_uom out nocopy varchar2) is
--
cursor c_txn_values is
select txn.name
,txn.varchar2_value
,txn.number_value
,txn.date_value
from hr_api_transaction_values txn
where txn.transaction_step_id = p_transaction_step_id
and (txn.varchar2_value is not null or
txn.number_value is not null or
txn.date_value is not null);
elsif l_txn_values.name = 'P_RT_UPDATE_MODE' then
p_rt_update_mode := l_txn_values.varchar2_value;
,p_rt_update_mode in varchar2
,p_api_error out nocopy boolean) is
--
l_return_status varchar2(30);
,p_rt_update_mode => p_rt_update_mode
,p_return_status => l_return_status);
,p_rt_update_mode in varchar2
,p_api_error out nocopy boolean) is
--
begin
--
election_information_w
(p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
,p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id
,p_effective_date => p_effective_date
,p_person_id => p_person_id
,p_enrt_bnft_id => p_enrt_bnft_id
,p_bnft_amt => p_bnft_amt
,p_enrt_rt_id => p_enrt_rt_id
,p_prtt_rt_val_id => p_prtt_rt_val_id
,p_rt_val => p_rt_val
,p_datetrack_mode => p_datetrack_mode
,p_effective_start_date => p_effective_start_date
,p_object_version_number => p_object_version_number
,p_business_group_id => p_business_group_id
,p_enrt_cvg_strt_dt => p_enrt_cvg_strt_dt
,p_enrt_cvg_thru_dt => p_enrt_cvg_thru_dt
,p_rt_strt_dt => p_rt_strt_dt
,p_rt_end_dt => p_rt_end_dt
,p_rt_strt_dt_cd => p_rt_strt_dt_cd
,p_limit_enrt_rt_id => p_limit_enrt_rt_id
,p_limit_prtt_rt_val_id => p_limit_prtt_rt_val_id
,p_limit_rt_val => p_limit_rt_val
,p_rt_update_mode => p_rt_update_mode
,p_api_error => p_api_error
);
,p_rt_update_mode in varchar2
,p_api_error out nocopy boolean) is
--
l_elig_per_elctbl_chc_id number;
l_rt_update_mode varchar2(30);
,p_rt_update_mode => l_rt_update_mode
,p_rtval_rt_strt_dt => l_rtval_rt_strt_dt
,p_nip_pl_uom => l_nip_pl_uom);
,p_rt_update_mode => l_rt_update_mode
,p_api_error => p_api_error);
,p_rt_update_mode => p_rt_update_mode
,p_api_error => p_api_error);
,p_rt_update_mode out nocopy varchar2
,p_rtval_rt_strt_dt out nocopy date
,p_nip_pl_uom out nocopy varchar2) is
--
l_transaction_step_id number := null;
,p_rt_update_mode => p_rt_update_mode
,p_rtval_rt_strt_dt => p_rtval_rt_strt_dt
,p_nip_pl_uom => p_nip_pl_uom);
procedure update_compensation
(p_item_type in varchar2
,p_item_key in varchar2
,p_actid in number
,p_login_person_id in number
,p_process_section_name in varchar2
,p_review_page_region_code in varchar2
,p_elig_per_elctbl_chc_id in number
,p_prtt_enrt_rslt_id in number
,p_person_id in number
,p_per_in_ler_id in number
,p_pgm_id in number
,p_pl_id in number
,p_effective_date in date
,p_enrt_bnft_id in number
,p_bnft_amt in number
,p_enrt_rt_id in number
,p_prtt_rt_val_id in number
,p_rt_val in number
,p_datetrack_mode in varchar2
,p_effective_start_date in date
,p_object_version_number in number
,p_business_group_id in number
,p_enrt_cvg_strt_dt in date
,p_enrt_cvg_thru_dt in date
,p_justification in varchar2
,p_pl_name in varchar2
,p_frequency_meaning in varchar2
,p_frequency_cd in varchar2
,p_entr_rt_at_enrt_flag in varchar2
,p_entr_bnft_at_enrt_flag in varchar2
,p_rt_nnmntry_uom in varchar2
,p_bnft_nnmntry_uom in varchar2
,p_rt_uom in varchar2
,p_bnft_uom in varchar2
,p_rt_mn_val in number
,p_rt_mx_val in number
,p_bnft_mn_val in number
,p_bnft_mx_val in number
,p_enrt_cvg_strt_dt_cd in varchar2
,p_acty_ref_perd_cd in varchar2
,p_currency_cd in varchar2
,p_limit_enrt_rt_id in number
,p_limit_prtt_rt_val_id in number
,p_limit_rt_val in number
,p_limit_entr_rt_at_enrt_flag in varchar2
,p_pl_typ_id in number
,p_ler_id in number
,p_limit_dsply_on_enrt_flag in varchar2
,p_currency_symbol in varchar2
,p_rt_strt_dt in date
,p_rt_end_dt in date
,p_rt_strt_dt_cd in varchar2
,p_rt_end_dt_cd in varchar2
,p_rslt_bnft_amt in number
,p_rtval_rt_end_dt in date
,p_rtval_rt_val in number
,p_rtval_limit_rt_val in number
,p_bnft_typ_meaning in varchar2
,p_ctfn_names in varchar2
,p_rt_update_mode in varchar2
,p_rtval_rt_strt_dt in date
,p_save_mode in varchar2 default null
,p_nip_pl_uom in varchar2) is
--
l_tx_name t_tx_name;
l_update_mode boolean := true;
select stp.transaction_step_id
from hr_api_transactions trn,
hr_api_transaction_steps stp,
hr_api_transaction_values vlv
where trn.selected_person_id = p_person_id
and trn.transaction_id = stp.transaction_id
and stp.api_name = upper(g_package || 'process_api')
and stp.transaction_step_id <> l_transaction_step_id
and stp.transaction_step_id = vlv.transaction_step_id
and vlv.name = 'P_ELIG_PER_ELCTBL_CHC_ID'
and vlv.number_value = p_elig_per_elctbl_chc_id;
,p_rt_update_mode => p_rt_update_mode
,p_api_error => l_api_error);
l_update_mode := false;
l_tx_name(l_count) := 'P_RT_UPDATE_MODE';
l_tx_char(l_count) := p_rt_update_mode;
if l_update_mode then
forall i in 1..l_count
update hr_api_transaction_values
set
varchar2_value = l_tx_char(i),
number_value = l_tx_num(i),
date_value = l_tx_date(i)
where transaction_step_id = l_transaction_step_id
and name = l_tx_name(i);
insert into hr_api_transaction_values
( transaction_value_id,
transaction_step_id,
datatype,
name,
varchar2_value,
number_value,
date_value,
original_varchar2_value,
original_number_value,
original_date_value)
Values
( hr_api_transaction_values_s.nextval,
l_transaction_step_id,
l_tx_type(i),
l_tx_name(i),
l_tx_char(i),
l_tx_num(i),
l_tx_date(i),
l_tx_char(i),
l_tx_num(i),
l_tx_date(i));
delete hr_api_transaction_values vlv
where vlv.transaction_step_id = l_step.transaction_step_id;
delete hr_api_transaction_steps step
where step.transaction_step_id = l_step.transaction_step_id;
end update_compensation;
l_rt_update_mode varchar2(30);
,p_rt_update_mode => l_rt_update_mode
,p_rtval_rt_strt_dt => l_rtval_rt_strt_dt
,p_nip_pl_uom => l_nip_pl_uom
);
,p_rt_update_mode => l_rt_update_mode
,p_api_error => l_api_error);
procedure update_object_version
(p_transaction_step_id in number
,p_login_person_id in number) is
begin
--
-- No Nothing.
-- Procedure created beacuse SS HR needs it.
--
null;
end update_object_version;