APPS.PQH_CRL_UPD dependencies on PQH_CRITERIA_RATE_DEFN_TL

Line 66: -- Update the pqh_criteria_rate_defn_tl Row

62: --
63: --
64: --
65: --
66: -- Update the pqh_criteria_rate_defn_tl Row
67: --
68: update pqh_criteria_rate_defn_tl
69: set
70: criteria_rate_defn_id = p_rec.criteria_rate_defn_id

Line 68: update pqh_criteria_rate_defn_tl

64: --
65: --
66: -- Update the pqh_criteria_rate_defn_tl Row
67: --
68: update pqh_criteria_rate_defn_tl
69: set
70: criteria_rate_defn_id = p_rec.criteria_rate_defn_id
71: ,name = p_rec.name
72: ,language = p_rec.language

Line 210: (p_module_name => 'PQH_CRITERIA_RATE_DEFN_TL'

206: --
207: when hr_api.cannot_find_prog_unit then
208: --
209: hr_api.cannot_find_prog_unit_error
210: (p_module_name => 'PQH_CRITERIA_RATE_DEFN_TL'
211: ,p_hook_type => 'AU');
212: --
213: end;
214: --

Line 393: from pqh_criteria_rate_defn_tl crl

389: -- source_lang match the specified language.
390: --
391: cursor csr_upd_langs is
392: select crl.language
393: from pqh_criteria_rate_defn_tl crl
394: where crl.criteria_rate_defn_id = p_criteria_rate_defn_id
395: and p_language_code in (crl.language
396: ,crl.source_lang);
397: --

Line 462: update pqh_criteria_rate_defn_tl

458: l_creation_date := sysdate;
459: l_last_update_date := sysdate;
460: l_last_update_login := 0;
461: --
462: update pqh_criteria_rate_defn_tl
463: set name = p_name ,
464: last_updated_by = l_last_updated_by,
465: last_update_date = l_last_update_date,
466: last_update_login = l_last_update_login,