eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_CRL_UPD dependencies on PQH_CRITERIA_RATE_DEFN

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 425: l_criteria_rate_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type;

421: p_short_name in varchar2,
422: p_name in varchar2,
423: p_owner in varchar2) is
424: --
425: l_criteria_rate_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type;
426: --
427: --
428: l_created_by pqh_criteria_rate_defn.created_by%TYPE;
429: l_last_updated_by pqh_criteria_rate_defn.last_updated_by%TYPE;

Line 428: l_created_by pqh_criteria_rate_defn.created_by%TYPE;

424: --
425: l_criteria_rate_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type;
426: --
427: --
428: l_created_by pqh_criteria_rate_defn.created_by%TYPE;
429: l_last_updated_by pqh_criteria_rate_defn.last_updated_by%TYPE;
430: l_creation_date pqh_criteria_rate_defn.creation_date%TYPE;
431: l_last_update_date pqh_criteria_rate_defn.last_update_date%TYPE;
432: l_last_update_login pqh_criteria_rate_defn.last_update_login%TYPE;

Line 429: l_last_updated_by pqh_criteria_rate_defn.last_updated_by%TYPE;

425: l_criteria_rate_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type;
426: --
427: --
428: l_created_by pqh_criteria_rate_defn.created_by%TYPE;
429: l_last_updated_by pqh_criteria_rate_defn.last_updated_by%TYPE;
430: l_creation_date pqh_criteria_rate_defn.creation_date%TYPE;
431: l_last_update_date pqh_criteria_rate_defn.last_update_date%TYPE;
432: l_last_update_login pqh_criteria_rate_defn.last_update_login%TYPE;
433: --

Line 430: l_creation_date pqh_criteria_rate_defn.creation_date%TYPE;

426: --
427: --
428: l_created_by pqh_criteria_rate_defn.created_by%TYPE;
429: l_last_updated_by pqh_criteria_rate_defn.last_updated_by%TYPE;
430: l_creation_date pqh_criteria_rate_defn.creation_date%TYPE;
431: l_last_update_date pqh_criteria_rate_defn.last_update_date%TYPE;
432: l_last_update_login pqh_criteria_rate_defn.last_update_login%TYPE;
433: --
434: --

Line 431: l_last_update_date pqh_criteria_rate_defn.last_update_date%TYPE;

427: --
428: l_created_by pqh_criteria_rate_defn.created_by%TYPE;
429: l_last_updated_by pqh_criteria_rate_defn.last_updated_by%TYPE;
430: l_creation_date pqh_criteria_rate_defn.creation_date%TYPE;
431: l_last_update_date pqh_criteria_rate_defn.last_update_date%TYPE;
432: l_last_update_login pqh_criteria_rate_defn.last_update_login%TYPE;
433: --
434: --
435: Cursor c1 is

Line 432: l_last_update_login pqh_criteria_rate_defn.last_update_login%TYPE;

428: l_created_by pqh_criteria_rate_defn.created_by%TYPE;
429: l_last_updated_by pqh_criteria_rate_defn.last_updated_by%TYPE;
430: l_creation_date pqh_criteria_rate_defn.creation_date%TYPE;
431: l_last_update_date pqh_criteria_rate_defn.last_update_date%TYPE;
432: l_last_update_login pqh_criteria_rate_defn.last_update_login%TYPE;
433: --
434: --
435: Cursor c1 is
436: Select criteria_rate_defn_id

Line 437: From pqh_criteria_rate_defn_vl

433: --
434: --
435: Cursor c1 is
436: Select criteria_rate_defn_id
437: From pqh_criteria_rate_defn_vl
438: Where short_name = p_short_name;
439: --
440: begin
441: --

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,