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.HR_COMPLETE_APPRAISAL_SS dependencies on PER_APPRAISALS

Line 186: (appraisal_date per_appraisals.appraisal_date%TYPE,

182: END;
183:
184:
185: PROCEDURE generate_appraisal_status
186: (appraisal_date per_appraisals.appraisal_date%TYPE,
187: appraisee_name per_all_people_f.full_name%TYPE,
188: appraisal_status hr_lookups.meaning%TYPE,
189: appraisal_type hr_lookups.meaning%TYPE,
190: result fnd_new_messages.message_text%TYPE,

Line 253: ( appr_id per_appraisals.appraisal_id%TYPE,

249:
250: END;
251:
252: PROCEDURE change_appr_status
253: ( appr_id per_appraisals.appraisal_id%TYPE,
254: item_type IN varchar2,
255: item_key IN varchar2,
256: p_log in out nocopy varchar2,
257: chg_appr_status in out nocopy varchar2 )

Line 260: cursor get_appraisal_info(appr_id per_appraisals.appraisal_id%TYPE) IS

256: p_log in out nocopy varchar2,
257: chg_appr_status in out nocopy varchar2 )
258: IS
259:
260: cursor get_appraisal_info(appr_id per_appraisals.appraisal_id%TYPE) IS
261: select appr.appraisal_id, appr.object_version_number,
262: appr.appraiser_person_id, appr.appraisee_person_id, ppf.full_name,
263: appr.appraisal_date, apprstatus.meaning appraisal_status, apprtype.meaning appraisal_type,
264: nvl(appr.provide_overall_feedback,'N') provide_overall_feedback, appr.appraisal_system_status

Line 265: from per_appraisals appr, per_all_people_f ppf, hr_lookups apprstatus,

261: select appr.appraisal_id, appr.object_version_number,
262: appr.appraiser_person_id, appr.appraisee_person_id, ppf.full_name,
263: appr.appraisal_date, apprstatus.meaning appraisal_status, apprtype.meaning appraisal_type,
264: nvl(appr.provide_overall_feedback,'N') provide_overall_feedback, appr.appraisal_system_status
265: from per_appraisals appr, per_all_people_f ppf, hr_lookups apprstatus,
266: hr_lookups apprtype
267: where appr.appraisal_id = appr_id
268: and ppf.person_id = appr.appraisee_person_id
269: and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date

Line 275: cursor get_appraisal_status(appr_id per_appraisals.appraisal_id%TYPE) IS

271: and apprstatus.lookup_code = appr.appraisal_system_status
272: and apprtype.lookup_type = 'APPRAISAL_SYS_TYPE'
273: and apprtype.lookup_code = appr.system_type;
274:
275: cursor get_appraisal_status(appr_id per_appraisals.appraisal_id%TYPE) IS
276: select hrl.meaning
277: from per_appraisals appr, hr_lookups hrl
278: where appraisal_id = appr_id
279: and hrl.lookup_type = 'APPRAISAL_SYSTEM_STATUS'

Line 277: from per_appraisals appr, hr_lookups hrl

273: and apprtype.lookup_code = appr.system_type;
274:
275: cursor get_appraisal_status(appr_id per_appraisals.appraisal_id%TYPE) IS
276: select hrl.meaning
277: from per_appraisals appr, hr_lookups hrl
278: where appraisal_id = appr_id
279: and hrl.lookup_type = 'APPRAISAL_SYSTEM_STATUS'
280: and appr.appraisal_system_status = hrl.lookup_code;
281:

Line 284: appraisal_id per_appraisals.appraisal_id%TYPE,

280: and appr.appraisal_system_status = hrl.lookup_code;
281:
282:
283: TYPE appraisal_rec is RECORD (
284: appraisal_id per_appraisals.appraisal_id%TYPE,
285: object_version_number per_appraisals.object_version_number%TYPE,
286: appraiser_person_id per_appraisals.appraiser_person_id%TYPE,
287: appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
288: full_name per_all_people_f.full_name%TYPE,

Line 285: object_version_number per_appraisals.object_version_number%TYPE,

281:
282:
283: TYPE appraisal_rec is RECORD (
284: appraisal_id per_appraisals.appraisal_id%TYPE,
285: object_version_number per_appraisals.object_version_number%TYPE,
286: appraiser_person_id per_appraisals.appraiser_person_id%TYPE,
287: appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
288: full_name per_all_people_f.full_name%TYPE,
289: appraisal_date per_appraisals.appraisal_date%TYPE,

Line 286: appraiser_person_id per_appraisals.appraiser_person_id%TYPE,

282:
283: TYPE appraisal_rec is RECORD (
284: appraisal_id per_appraisals.appraisal_id%TYPE,
285: object_version_number per_appraisals.object_version_number%TYPE,
286: appraiser_person_id per_appraisals.appraiser_person_id%TYPE,
287: appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
288: full_name per_all_people_f.full_name%TYPE,
289: appraisal_date per_appraisals.appraisal_date%TYPE,
290: apprstatus hr_lookups.meaning%TYPE,

Line 287: appraisee_person_id per_appraisals.appraisee_person_id%TYPE,

283: TYPE appraisal_rec is RECORD (
284: appraisal_id per_appraisals.appraisal_id%TYPE,
285: object_version_number per_appraisals.object_version_number%TYPE,
286: appraiser_person_id per_appraisals.appraiser_person_id%TYPE,
287: appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
288: full_name per_all_people_f.full_name%TYPE,
289: appraisal_date per_appraisals.appraisal_date%TYPE,
290: apprstatus hr_lookups.meaning%TYPE,
291: apprtype hr_lookups.meaning%TYPE,

Line 289: appraisal_date per_appraisals.appraisal_date%TYPE,

285: object_version_number per_appraisals.object_version_number%TYPE,
286: appraiser_person_id per_appraisals.appraiser_person_id%TYPE,
287: appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
288: full_name per_all_people_f.full_name%TYPE,
289: appraisal_date per_appraisals.appraisal_date%TYPE,
290: apprstatus hr_lookups.meaning%TYPE,
291: apprtype hr_lookups.meaning%TYPE,
292: provide_overall_feedback per_appraisals.provide_overall_feedback%TYPE,
293: appraisal_system_status per_appraisals.appraisal_system_status%TYPE

Line 292: provide_overall_feedback per_appraisals.provide_overall_feedback%TYPE,

288: full_name per_all_people_f.full_name%TYPE,
289: appraisal_date per_appraisals.appraisal_date%TYPE,
290: apprstatus hr_lookups.meaning%TYPE,
291: apprtype hr_lookups.meaning%TYPE,
292: provide_overall_feedback per_appraisals.provide_overall_feedback%TYPE,
293: appraisal_system_status per_appraisals.appraisal_system_status%TYPE
294: );
295:
296: appraisal_record appraisal_rec;

Line 293: appraisal_system_status per_appraisals.appraisal_system_status%TYPE

289: appraisal_date per_appraisals.appraisal_date%TYPE,
290: apprstatus hr_lookups.meaning%TYPE,
291: apprtype hr_lookups.meaning%TYPE,
292: provide_overall_feedback per_appraisals.provide_overall_feedback%TYPE,
293: appraisal_system_status per_appraisals.appraisal_system_status%TYPE
294: );
295:
296: appraisal_record appraisal_rec;
297: error_message varchar2(500) default null;

Line 439: ( appr_id per_appraisals.appraisal_id%TYPE,

435: raise ;
436: END;
437:
438: PROCEDURE apply_to_personal_profile
439: ( appr_id per_appraisals.appraisal_id%TYPE,
440: p_log in out nocopy varchar2,
441: apply_pers_profile_status in out nocopy varchar2,
442: p_new_appraisal in boolean DEFAULT true,
443: p_talent_mang_src_typ per_appraisal_templates.COMP_PROFILE_SOURCE_TYPE%TYPE)

Line 449: from per_competence_elements pce, per_appraisals pa, per_all_people_f ppf, per_competences pc,

445: cursor get_assessment_competences (appr_id IN number) is
446: select pce.competence_id, pc.name, pce.competence_element_id, pce.proficiency_level_id,
447: pce.business_group_id, pce.enterprise_id,pce.effective_date_from, pce.effective_date_to, pa.appraisal_id, pa.appraisee_person_id,
448: ppf.party_id, decode(rating.step_value, null, null, rating.step_value||' - '||rating.name) prof_level
449: from per_competence_elements pce, per_appraisals pa, per_all_people_f ppf, per_competences pc,
450: per_rating_levels rating
451: where pce.type='ASSESSMENT'
452: and pce.object_name = 'APPRAISAL_ID'
453: and pce.object_id = appr_id

Line 485: from per_appraisals appr, per_competence_elements pce

481: pce.attribute13, pce.attribute14, pce.attribute15, pce.attribute16,
482: pce.attribute17, pce.attribute18, pce.attribute19,
483: pce.attribute20, pce.object_id,
484: pce.object_name, pce.party_id
485: from per_appraisals appr, per_competence_elements pce
486: where appr.appraisal_id = appr_id
487: and appr.appraisee_person_id = pce.person_id
488: and pce.type = 'PERSONAL'
489: and trunc(sysdate) between pce.effective_date_from and

Line 933: -- change the status in per_appraisals to completed.

929: -- check for any training plan members with appraisal id
930: -- if exists then change the status of Training Plan members
931: -- to planned
932:
933: -- change the status in per_appraisals to completed.
934:
935: EXCEPTION
936: WHEN OTHERS THEN
937: error_message := error_message || sqlerrm;

Line 1059: ( appr_id IN per_appraisals.appraisal_id%TYPE,

1055: CLOSE l_lp_courses;
1056: END;
1057:
1058: PROCEDURE update_train_component_status
1059: ( appr_id IN per_appraisals.appraisal_id%TYPE,
1060: p_log in out nocopy varchar2,
1061: upd_train_comps_status in out nocopy varchar2,
1062: p_new_appraisal in boolean DEFAULT true)
1063: IS

Line 1405: PROCEDURE create_event (appr_id per_appraisals.appraisal_id%TYPE,

1401: upd_train_comps_status := 'W';
1402: END;
1403:
1404:
1405: PROCEDURE create_event (appr_id per_appraisals.appraisal_id%TYPE,
1406: p_log in out nocopy varchar2,
1407: upd_create_event_status in out nocopy varchar2,
1408: p_new_appraisal in boolean DEFAULT true)
1409: IS

Line 1425: cursor get_appr_overall_perf(appr_id per_appraisals.appraisal_id%TYPE) IS

1421: l_perf_rev_id number;
1422: l_next_rev_date_warn boolean;
1423: l_sql_err varchar2(10000);
1424:
1425: cursor get_appr_overall_perf(appr_id per_appraisals.appraisal_id%TYPE) IS
1426: select appr.appraisal_id, appr.object_version_number, appr.appraiser_person_id,
1427: appr.appraisee_person_id, appr.overall_performance_level_id, prl.step_value,
1428: (prl.step_value||' - '||prl.name) overall_rating
1429: from per_appraisals appr, per_rating_levels prl

Line 1429: from per_appraisals appr, per_rating_levels prl

1425: cursor get_appr_overall_perf(appr_id per_appraisals.appraisal_id%TYPE) IS
1426: select appr.appraisal_id, appr.object_version_number, appr.appraiser_person_id,
1427: appr.appraisee_person_id, appr.overall_performance_level_id, prl.step_value,
1428: (prl.step_value||' - '||prl.name) overall_rating
1429: from per_appraisals appr, per_rating_levels prl
1430: where appraisal_id = appr_id
1431: and appr.overall_performance_level_id = prl.rating_level_id;
1432:
1433: TYPE appraisal_record is RECORD (

Line 1434: appraisal_id per_appraisals.appraisal_id%TYPE,

1430: where appraisal_id = appr_id
1431: and appr.overall_performance_level_id = prl.rating_level_id;
1432:
1433: TYPE appraisal_record is RECORD (
1434: appraisal_id per_appraisals.appraisal_id%TYPE,
1435: object_version_number per_appraisals.object_version_number%TYPE,
1436: appraiser_person_id per_appraisals.appraiser_person_id%TYPE,
1437: appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
1438: overall_performance_level_id per_appraisals.appraisee_person_id%TYPE,

Line 1435: object_version_number per_appraisals.object_version_number%TYPE,

1431: and appr.overall_performance_level_id = prl.rating_level_id;
1432:
1433: TYPE appraisal_record is RECORD (
1434: appraisal_id per_appraisals.appraisal_id%TYPE,
1435: object_version_number per_appraisals.object_version_number%TYPE,
1436: appraiser_person_id per_appraisals.appraiser_person_id%TYPE,
1437: appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
1438: overall_performance_level_id per_appraisals.appraisee_person_id%TYPE,
1439: step_value per_rating_levels.step_value%TYPE,

Line 1436: appraiser_person_id per_appraisals.appraiser_person_id%TYPE,

1432:
1433: TYPE appraisal_record is RECORD (
1434: appraisal_id per_appraisals.appraisal_id%TYPE,
1435: object_version_number per_appraisals.object_version_number%TYPE,
1436: appraiser_person_id per_appraisals.appraiser_person_id%TYPE,
1437: appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
1438: overall_performance_level_id per_appraisals.appraisee_person_id%TYPE,
1439: step_value per_rating_levels.step_value%TYPE,
1440: overall_perf_rating varchar2(100)

Line 1437: appraisee_person_id per_appraisals.appraisee_person_id%TYPE,

1433: TYPE appraisal_record is RECORD (
1434: appraisal_id per_appraisals.appraisal_id%TYPE,
1435: object_version_number per_appraisals.object_version_number%TYPE,
1436: appraiser_person_id per_appraisals.appraiser_person_id%TYPE,
1437: appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
1438: overall_performance_level_id per_appraisals.appraisee_person_id%TYPE,
1439: step_value per_rating_levels.step_value%TYPE,
1440: overall_perf_rating varchar2(100)
1441: );

Line 1438: overall_performance_level_id per_appraisals.appraisee_person_id%TYPE,

1434: appraisal_id per_appraisals.appraisal_id%TYPE,
1435: object_version_number per_appraisals.object_version_number%TYPE,
1436: appraiser_person_id per_appraisals.appraiser_person_id%TYPE,
1437: appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
1438: overall_performance_level_id per_appraisals.appraisee_person_id%TYPE,
1439: step_value per_rating_levels.step_value%TYPE,
1440: overall_perf_rating varchar2(100)
1441: );
1442:

Line 1732: FROM per_appraisals

1728: l_curr_appr_tmplt_id per_appraisal_templates.appraisal_template_id%type;
1729:
1730: CURSOR get_plan_template_id IS
1731: SELECT plan_id, appraisal_template_id
1732: FROM per_appraisals
1733: WHERE appraisal_id = p_appraisal_id;
1734:
1735: l_appr_objs appr_obj_table;
1736:

Line 1766: appraisal_id per_appraisals.appraisal_id%type;

1762: ( item_type IN varchar2,
1763: item_key IN varchar2,
1764: p_result_out in out nocopy varchar2)
1765: IS
1766: appraisal_id per_appraisals.appraisal_id%type;
1767: l_ins_ovn number;
1768: l_ins_comp_id number;
1769: next_comp_ele_id per_competence_elements.competence_element_id%TYPE;
1770: l_person_id number;

Line 1787: from per_appraisal_templates pat ,per_appraisals pa where

1783: update_personal_profile varchar2(100) default null;
1784: l_proc varchar2(100);
1785: cursor c_appr_template_details(c_appraisal_id in number) is
1786: select available_flag ,update_personal_comp_profile,comp_profile_source_type
1787: from per_appraisal_templates pat ,per_appraisals pa where
1788: pa.appraisal_template_id = pat.appraisal_template_id
1789: and pa.appraisal_id = c_appraisal_id;
1790: BEGIN
1791: l_proc := 'HR_COMPLETE_APPRAISAL_SS.COMPLETE_APPR';

Line 1902: l_appraisal_id per_appraisals.appraisal_id%type;

1898: ( p_item_type IN varchar2,
1899: p_item_key IN varchar2,
1900: p_result_out in out nocopy varchar2)
1901: IS
1902: l_appraisal_id per_appraisals.appraisal_id%type;
1903: update_personal_profile varchar2(100) default null;
1904:
1905: CURSOR get_appraisee_access(appr_id per_appraisals.appraisal_id%TYPE) IS
1906: select appraisal_id, appraisee_access, system_type from per_appraisals where appraisal_id = appr_id;

Line 1905: CURSOR get_appraisee_access(appr_id per_appraisals.appraisal_id%TYPE) IS

1901: IS
1902: l_appraisal_id per_appraisals.appraisal_id%type;
1903: update_personal_profile varchar2(100) default null;
1904:
1905: CURSOR get_appraisee_access(appr_id per_appraisals.appraisal_id%TYPE) IS
1906: select appraisal_id, appraisee_access, system_type from per_appraisals where appraisal_id = appr_id;
1907:
1908: TYPE appraisal_access_info is RECORD (
1909: appraisal_id per_appraisals.appraisal_id%TYPE,

Line 1906: select appraisal_id, appraisee_access, system_type from per_appraisals where appraisal_id = appr_id;

1902: l_appraisal_id per_appraisals.appraisal_id%type;
1903: update_personal_profile varchar2(100) default null;
1904:
1905: CURSOR get_appraisee_access(appr_id per_appraisals.appraisal_id%TYPE) IS
1906: select appraisal_id, appraisee_access, system_type from per_appraisals where appraisal_id = appr_id;
1907:
1908: TYPE appraisal_access_info is RECORD (
1909: appraisal_id per_appraisals.appraisal_id%TYPE,
1910: appraisee_access per_appraisals.appraisee_access%TYPE,

Line 1909: appraisal_id per_appraisals.appraisal_id%TYPE,

1905: CURSOR get_appraisee_access(appr_id per_appraisals.appraisal_id%TYPE) IS
1906: select appraisal_id, appraisee_access, system_type from per_appraisals where appraisal_id = appr_id;
1907:
1908: TYPE appraisal_access_info is RECORD (
1909: appraisal_id per_appraisals.appraisal_id%TYPE,
1910: appraisee_access per_appraisals.appraisee_access%TYPE,
1911: system_type per_appraisals.system_type%TYPE
1912: );
1913:

Line 1910: appraisee_access per_appraisals.appraisee_access%TYPE,

1906: select appraisal_id, appraisee_access, system_type from per_appraisals where appraisal_id = appr_id;
1907:
1908: TYPE appraisal_access_info is RECORD (
1909: appraisal_id per_appraisals.appraisal_id%TYPE,
1910: appraisee_access per_appraisals.appraisee_access%TYPE,
1911: system_type per_appraisals.system_type%TYPE
1912: );
1913:
1914: appr_access_info appraisal_access_info;

Line 1911: system_type per_appraisals.system_type%TYPE

1907:
1908: TYPE appraisal_access_info is RECORD (
1909: appraisal_id per_appraisals.appraisal_id%TYPE,
1910: appraisee_access per_appraisals.appraisee_access%TYPE,
1911: system_type per_appraisals.system_type%TYPE
1912: );
1913:
1914: appr_access_info appraisal_access_info;
1915: