The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure update_dml
(p_rec in out nocopy pqh_crl_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'update_dml';
update pqh_criteria_rate_defn_tl
set
criteria_rate_defn_id = p_rec.criteria_rate_defn_id
,name = p_rec.name
,language = p_rec.language
,source_lang = p_rec.source_lang
where criteria_rate_defn_id = p_rec.criteria_rate_defn_id
and language = p_rec.language;
End update_dml;
Procedure pre_update
(p_rec in pqh_crl_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'pre_update';
End pre_update;
Procedure post_update
(p_effective_date in date
,p_rec in pqh_crl_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'post_update';
pqh_crl_rku.after_update
(p_effective_date => p_effective_date
,p_criteria_rate_defn_id
=> p_rec.criteria_rate_defn_id
,p_name
=> p_rec.name
,p_language
=> p_rec.language
,p_source_lang
=> p_rec.source_lang
,p_name_o
=> pqh_crl_shd.g_old_rec.name
,p_source_lang_o
=> pqh_crl_shd.g_old_rec.source_lang
);
End post_update;
pqh_crl_bus.update_validate
(p_effective_date
,p_rec
);
pqh_crl_upd.pre_update(p_rec);
pqh_crl_upd.update_dml(p_rec);
pqh_crl_upd.post_update
(p_effective_date
,p_rec
);
select crl.language
from pqh_criteria_rate_defn_tl crl
where crl.criteria_rate_defn_id = p_criteria_rate_defn_id
and p_language_code in (crl.language
,crl.source_lang);
l_last_updated_by pqh_criteria_rate_defn.last_updated_by%TYPE;
l_last_update_date pqh_criteria_rate_defn.last_update_date%TYPE;
l_last_update_login pqh_criteria_rate_defn.last_update_login%TYPE;
Select criteria_rate_defn_id
From pqh_criteria_rate_defn_vl
Where short_name = p_short_name;
l_last_updated_by := 1;
l_last_updated_by := 0;
l_last_update_date := sysdate;
l_last_update_login := 0;
update pqh_criteria_rate_defn_tl
set name = p_name ,
last_updated_by = l_last_updated_by,
last_update_date = l_last_update_date,
last_update_login = l_last_update_login,
source_lang = USERENV('LANG')
where USERENV('LANG') in (language,source_lang)
and criteria_rate_defn_id = l_criteria_rate_defn_id ;