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 214: appraisal_date per_appraisals.appraisal_date%TYPE,

210: END IF;
211: END;
212:
213: PROCEDURE generate_appraisal_status (
214: appraisal_date per_appraisals.appraisal_date%TYPE,
215: appraisee_name per_all_people_f.full_name%TYPE,
216: appraisal_status hr_lookups.meaning%TYPE,
217: appraisal_type hr_lookups.meaning%TYPE,
218: RESULT fnd_new_messages.MESSAGE_TEXT%TYPE,

Line 306: appr_id per_appraisals.appraisal_id%TYPE,

302: || '';
303: END;
304:
305: PROCEDURE change_appr_status (
306: appr_id per_appraisals.appraisal_id%TYPE,
307: item_type IN VARCHAR2,
308: item_key IN VARCHAR2,
309: p_log IN OUT NOCOPY VARCHAR2,
310: chg_appr_status IN OUT NOCOPY VARCHAR2

Line 313: CURSOR get_appraisal_info (appr_id per_appraisals.appraisal_id%TYPE)

309: p_log IN OUT NOCOPY VARCHAR2,
310: chg_appr_status IN OUT NOCOPY VARCHAR2
311: )
312: IS
313: CURSOR get_appraisal_info (appr_id per_appraisals.appraisal_id%TYPE)
314: IS
315: SELECT appr.appraisal_id,
316: appr.object_version_number,
317: appr.appraiser_person_id,

Line 325: FROM per_appraisals appr,

321: apprstatus.meaning appraisal_status,
322: apprtype.meaning appraisal_type,
323: NVL (appr.provide_overall_feedback, 'N') provide_overall_feedback,
324: appr.appraisal_system_status
325: FROM per_appraisals appr,
326: per_all_people_f ppf,
327: hr_lookups apprstatus,
328: hr_lookups apprtype
329: WHERE appr.appraisal_id = appr_id

Line 337: CURSOR get_appraisal_status (appr_id per_appraisals.appraisal_id%TYPE)

333: AND apprstatus.lookup_code = appr.appraisal_system_status
334: AND apprtype.lookup_type = 'APPRAISAL_SYS_TYPE'
335: AND apprtype.lookup_code = appr.system_type;
336:
337: CURSOR get_appraisal_status (appr_id per_appraisals.appraisal_id%TYPE)
338: IS
339: SELECT hrl.meaning
340: FROM per_appraisals appr, hr_lookups hrl
341: WHERE appraisal_id = appr_id

Line 340: FROM per_appraisals appr, hr_lookups hrl

336:
337: CURSOR get_appraisal_status (appr_id per_appraisals.appraisal_id%TYPE)
338: IS
339: SELECT hrl.meaning
340: FROM per_appraisals appr, hr_lookups hrl
341: WHERE appraisal_id = appr_id
342: AND hrl.lookup_type = 'APPRAISAL_SYSTEM_STATUS'
343: AND appr.appraisal_system_status = hrl.lookup_code;
344:

Line 346: appraisal_id per_appraisals.appraisal_id%TYPE,

342: AND hrl.lookup_type = 'APPRAISAL_SYSTEM_STATUS'
343: AND appr.appraisal_system_status = hrl.lookup_code;
344:
345: TYPE appraisal_rec IS RECORD (
346: appraisal_id per_appraisals.appraisal_id%TYPE,
347: object_version_number per_appraisals.object_version_number%TYPE,
348: appraiser_person_id per_appraisals.appraiser_person_id%TYPE,
349: appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
350: full_name per_all_people_f.full_name%TYPE,

Line 347: object_version_number per_appraisals.object_version_number%TYPE,

343: AND appr.appraisal_system_status = hrl.lookup_code;
344:
345: TYPE appraisal_rec IS RECORD (
346: appraisal_id per_appraisals.appraisal_id%TYPE,
347: object_version_number per_appraisals.object_version_number%TYPE,
348: appraiser_person_id per_appraisals.appraiser_person_id%TYPE,
349: appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
350: full_name per_all_people_f.full_name%TYPE,
351: appraisal_date per_appraisals.appraisal_date%TYPE,

Line 348: appraiser_person_id per_appraisals.appraiser_person_id%TYPE,

344:
345: TYPE appraisal_rec IS RECORD (
346: appraisal_id per_appraisals.appraisal_id%TYPE,
347: object_version_number per_appraisals.object_version_number%TYPE,
348: appraiser_person_id per_appraisals.appraiser_person_id%TYPE,
349: appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
350: full_name per_all_people_f.full_name%TYPE,
351: appraisal_date per_appraisals.appraisal_date%TYPE,
352: apprstatus hr_lookups.meaning%TYPE,

Line 349: appraisee_person_id per_appraisals.appraisee_person_id%TYPE,

345: TYPE appraisal_rec IS RECORD (
346: appraisal_id per_appraisals.appraisal_id%TYPE,
347: object_version_number per_appraisals.object_version_number%TYPE,
348: appraiser_person_id per_appraisals.appraiser_person_id%TYPE,
349: appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
350: full_name per_all_people_f.full_name%TYPE,
351: appraisal_date per_appraisals.appraisal_date%TYPE,
352: apprstatus hr_lookups.meaning%TYPE,
353: apprtype hr_lookups.meaning%TYPE,

Line 351: appraisal_date per_appraisals.appraisal_date%TYPE,

347: object_version_number per_appraisals.object_version_number%TYPE,
348: appraiser_person_id per_appraisals.appraiser_person_id%TYPE,
349: appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
350: full_name per_all_people_f.full_name%TYPE,
351: appraisal_date per_appraisals.appraisal_date%TYPE,
352: apprstatus hr_lookups.meaning%TYPE,
353: apprtype hr_lookups.meaning%TYPE,
354: provide_overall_feedback per_appraisals.provide_overall_feedback%TYPE,
355: appraisal_system_status per_appraisals.appraisal_system_status%TYPE

Line 354: provide_overall_feedback per_appraisals.provide_overall_feedback%TYPE,

350: full_name per_all_people_f.full_name%TYPE,
351: appraisal_date per_appraisals.appraisal_date%TYPE,
352: apprstatus hr_lookups.meaning%TYPE,
353: apprtype hr_lookups.meaning%TYPE,
354: provide_overall_feedback per_appraisals.provide_overall_feedback%TYPE,
355: appraisal_system_status per_appraisals.appraisal_system_status%TYPE
356: );
357:
358: appraisal_record appraisal_rec;

Line 355: appraisal_system_status per_appraisals.appraisal_system_status%TYPE

351: appraisal_date per_appraisals.appraisal_date%TYPE,
352: apprstatus hr_lookups.meaning%TYPE,
353: apprtype hr_lookups.meaning%TYPE,
354: provide_overall_feedback per_appraisals.provide_overall_feedback%TYPE,
355: appraisal_system_status per_appraisals.appraisal_system_status%TYPE
356: );
357:
358: appraisal_record appraisal_rec;
359: error_message VARCHAR2 (500) DEFAULT NULL;

Line 537: appr_id per_appraisals.appraisal_id%TYPE,

533: RAISE;
534: END;
535:
536: PROCEDURE apply_to_personal_profile (
537: appr_id per_appraisals.appraisal_id%TYPE,
538: p_log IN OUT NOCOPY VARCHAR2,
539: apply_pers_profile_status IN OUT NOCOPY VARCHAR2,
540: p_new_appraisal IN BOOLEAN DEFAULT TRUE,
541: p_talent_mang_src_typ per_appraisal_templates.comp_profile_source_type%TYPE

Line 560: per_appraisals pa,

556: ppf.party_id,
557: DECODE (rating.step_value, NULL, NULL, rating.step_value || ' - ' || rating.NAME)
558: prof_level
559: FROM per_competence_elements pce,
560: per_appraisals pa,
561: per_all_people_f ppf,
562: per_competences pc,
563: per_rating_levels rating
564: WHERE pce.TYPE = 'ASSESSMENT'

Line 635: FROM per_appraisals appr, per_competence_elements pce

631: pce.attribute20,
632: pce.object_id,
633: pce.object_name,
634: pce.party_id
635: FROM per_appraisals appr, per_competence_elements pce
636: WHERE appr.appraisal_id = appr_id
637: AND appr.appraisee_person_id = pce.person_id
638: AND pce.TYPE = 'PERSONAL'
639: AND TRUNC (SYSDATE) BETWEEN pce.effective_date_from

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

1276: -- check for any training plan members with appraisal id
1277: -- if exists then change the status of Training Plan members
1278: -- to planned
1279:
1280: -- change the status in per_appraisals to completed.
1281: EXCEPTION
1282: WHEN OTHERS
1283: THEN
1284: error_message := error_message || SQLERRM;

Line 1465: appr_id IN per_appraisals.appraisal_id%TYPE,

1461: CLOSE l_lp_courses;
1462: END;
1463:
1464: PROCEDURE update_train_component_status (
1465: appr_id IN per_appraisals.appraisal_id%TYPE,
1466: p_log IN OUT NOCOPY VARCHAR2,
1467: upd_train_comps_status IN OUT NOCOPY VARCHAR2,
1468: p_new_appraisal IN BOOLEAN DEFAULT TRUE
1469: )

Line 1937: appr_id per_appraisals.appraisal_id%TYPE,

1933: upd_train_comps_status := 'W';
1934: END;
1935:
1936: PROCEDURE create_event (
1937: appr_id per_appraisals.appraisal_id%TYPE,
1938: p_log IN OUT NOCOPY VARCHAR2,
1939: upd_create_event_status IN OUT NOCOPY VARCHAR2,
1940: p_new_appraisal IN BOOLEAN DEFAULT TRUE
1941: )

Line 1958: CURSOR get_appr_overall_perf (appr_id per_appraisals.appraisal_id%TYPE)

1954: l_perf_rev_id NUMBER;
1955: l_next_rev_date_warn BOOLEAN;
1956: l_sql_err VARCHAR2 (10000);
1957:
1958: CURSOR get_appr_overall_perf (appr_id per_appraisals.appraisal_id%TYPE)
1959: IS
1960: SELECT appr.appraisal_id,
1961: appr.object_version_number,
1962: appr.appraiser_person_id,

Line 1967: FROM per_appraisals appr, per_rating_levels prl, hr_lookups hrl

1963: appr.appraisee_person_id,
1964: appr.overall_performance_level_id,
1965: prl.step_value,
1966: (prl.step_value || ' - ' || prl.NAME) overall_rating
1967: FROM per_appraisals appr, per_rating_levels prl, hr_lookups hrl
1968: WHERE appraisal_id = appr_id
1969: AND appr.overall_performance_level_id = prl.rating_level_id
1970: AND hrl.lookup_code = TO_CHAR (prl.step_value)
1971: AND hrl.lookup_type = 'PERFORMANCE_RATING'

Line 1976: appraisal_id per_appraisals.appraisal_id%TYPE,

1972: AND TRUNC (SYSDATE) BETWEEN NVL (start_date_active, TRUNC (SYSDATE))
1973: AND NVL (end_date_active, TRUNC (SYSDATE));
1974:
1975: TYPE appraisal_record IS RECORD (
1976: appraisal_id per_appraisals.appraisal_id%TYPE,
1977: object_version_number per_appraisals.object_version_number%TYPE,
1978: appraiser_person_id per_appraisals.appraiser_person_id%TYPE,
1979: appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
1980: overall_performance_level_id per_appraisals.appraisee_person_id%TYPE,

Line 1977: object_version_number per_appraisals.object_version_number%TYPE,

1973: AND NVL (end_date_active, TRUNC (SYSDATE));
1974:
1975: TYPE appraisal_record IS RECORD (
1976: appraisal_id per_appraisals.appraisal_id%TYPE,
1977: object_version_number per_appraisals.object_version_number%TYPE,
1978: appraiser_person_id per_appraisals.appraiser_person_id%TYPE,
1979: appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
1980: overall_performance_level_id per_appraisals.appraisee_person_id%TYPE,
1981: step_value per_rating_levels.step_value%TYPE,

Line 1978: appraiser_person_id per_appraisals.appraiser_person_id%TYPE,

1974:
1975: TYPE appraisal_record IS RECORD (
1976: appraisal_id per_appraisals.appraisal_id%TYPE,
1977: object_version_number per_appraisals.object_version_number%TYPE,
1978: appraiser_person_id per_appraisals.appraiser_person_id%TYPE,
1979: appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
1980: overall_performance_level_id per_appraisals.appraisee_person_id%TYPE,
1981: step_value per_rating_levels.step_value%TYPE,
1982: overall_perf_rating VARCHAR2 (100)

Line 1979: appraisee_person_id per_appraisals.appraisee_person_id%TYPE,

1975: TYPE appraisal_record IS RECORD (
1976: appraisal_id per_appraisals.appraisal_id%TYPE,
1977: object_version_number per_appraisals.object_version_number%TYPE,
1978: appraiser_person_id per_appraisals.appraiser_person_id%TYPE,
1979: appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
1980: overall_performance_level_id per_appraisals.appraisee_person_id%TYPE,
1981: step_value per_rating_levels.step_value%TYPE,
1982: overall_perf_rating VARCHAR2 (100)
1983: );

Line 1980: overall_performance_level_id per_appraisals.appraisee_person_id%TYPE,

1976: appraisal_id per_appraisals.appraisal_id%TYPE,
1977: object_version_number per_appraisals.object_version_number%TYPE,
1978: appraiser_person_id per_appraisals.appraiser_person_id%TYPE,
1979: appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
1980: overall_performance_level_id per_appraisals.appraisee_person_id%TYPE,
1981: step_value per_rating_levels.step_value%TYPE,
1982: overall_perf_rating VARCHAR2 (100)
1983: );
1984:

Line 2289: FROM per_appraisals

2285: CURSOR get_plan_template_id
2286: IS
2287: SELECT plan_id,
2288: appraisal_template_id
2289: FROM per_appraisals
2290: WHERE appraisal_id = p_appraisal_id;
2291:
2292: l_appr_objs appr_obj_table;
2293: BEGIN

Line 2336: FROM per_appraisals

2332: appraisal_period_start_date,
2333: appraisal_period_end_date,
2334: potential_readiness_level,
2335: retention_potential
2336: FROM per_appraisals
2337: WHERE appraisal_id = p_appraisal_id;
2338:
2339: l_person_extra_info_id NUMBER;
2340: l_ovn NUMBER;

Line 2399: FROM per_appraisals pa

2395: FROM dual
2396: WHERE EXISTS
2397: (
2398: SELECT 'x'
2399: FROM per_appraisals pa
2400: ,hr_questionnaires hq
2401: ,hr_quest_fields hqf
2402: ,per_participants pp
2403: WHERE pa.appraisal_id = c_appraisal_id

Line 2404: AND pp.participation_in_table = 'PER_APPRAISALS'

2400: ,hr_questionnaires hq
2401: ,hr_quest_fields hqf
2402: ,per_participants pp
2403: WHERE pa.appraisal_id = c_appraisal_id
2404: AND pp.participation_in_table = 'PER_APPRAISALS'
2405: AND pp.participation_in_id = pa.appraisal_id
2406: AND pp.participation_type = 'MAINAP'
2407: AND pp.questionnaire_template_id = hq.questionnaire_template_id
2408: AND nvl (hq.quest_type_code

Line 2432: FROM per_appraisals pa

2428: IS
2429: SELECT hr_general.decode_person_name (person_id) person
2430: FROM (
2431: SELECT DISTINCT(pp.person_id) person_id
2432: FROM per_appraisals pa
2433: ,hr_questionnaires hq
2434: ,hr_quest_fields hqf
2435: ,per_participants pp
2436: WHERE pa.appraisal_id = c_appraisal_id

Line 2437: AND pp.participation_in_table = 'PER_APPRAISALS'

2433: ,hr_questionnaires hq
2434: ,hr_quest_fields hqf
2435: ,per_participants pp
2436: WHERE pa.appraisal_id = c_appraisal_id
2437: AND pp.participation_in_table = 'PER_APPRAISALS'
2438: AND pp.participation_in_id = pa.appraisal_id
2439: AND pp.participation_type <> 'MAINAP'
2440: AND pp.questionnaire_template_id = hq.questionnaire_template_id
2441: AND nvl (hq.quest_type_code

Line 2467: FROM per_appraisals pa

2463: FROM dual
2464: WHERE EXISTS
2465: (
2466: SELECT 'x'
2467: FROM per_appraisals pa
2468: ,per_appraisal_templates pat
2469: ,hr_questionnaires hq
2470: ,hr_quest_fields hqf
2471: WHERE pa.appraisal_id = c_appraisal_id

Line 2590: appraisal_id per_appraisals.appraisal_id%TYPE;

2586: item_key IN VARCHAR2,
2587: p_result_out IN OUT NOCOPY VARCHAR2
2588: )
2589: IS
2590: appraisal_id per_appraisals.appraisal_id%TYPE;
2591: l_ins_ovn NUMBER;
2592: l_ins_comp_id NUMBER;
2593: next_comp_ele_id per_competence_elements.competence_element_id%TYPE;
2594: l_person_id NUMBER;

Line 2615: FROM per_appraisal_templates pat, per_appraisals pa

2611: IS
2612: SELECT available_flag,
2613: update_personal_comp_profile,
2614: comp_profile_source_type
2615: FROM per_appraisal_templates pat, per_appraisals pa
2616: WHERE pa.appraisal_template_id = pat.appraisal_template_id
2617: AND pa.appraisal_id = c_appraisal_id;
2618:
2619: --

Line 2652: FROM per_appraisals pa

2648: l_appraisal_id := appraisal_id;
2649:
2650: SELECT pa.appraisee_person_id
2651: INTO l_sel_person_id
2652: FROM per_appraisals pa
2653: WHERE pa.appraisal_id = l_appraisal_id;
2654: --10060770
2655: SELECT transaction_id
2656: INTO l_source_pk1_value

Line 2658: WHERE transaction_ref_table = 'PER_APPRAISALS' AND transaction_ref_id = l_appraisal_id

2654: --10060770
2655: SELECT transaction_id
2656: INTO l_source_pk1_value
2657: FROM hr_api_transactions
2658: WHERE transaction_ref_table = 'PER_APPRAISALS' AND transaction_ref_id = l_appraisal_id
2659: AND item_type = COMPLETE_APPR.item_type
2660: AND item_key = complete_appr.item_key;
2661:
2662: OPEN c_appr_template_details (appraisal_id);

Line 2840: l_appraisal_id per_appraisals.appraisal_id%TYPE;

2836: p_item_key IN VARCHAR2,
2837: p_result_out IN OUT NOCOPY VARCHAR2
2838: )
2839: IS
2840: l_appraisal_id per_appraisals.appraisal_id%TYPE;
2841: update_personal_profile VARCHAR2 (100) DEFAULT NULL;
2842:
2843: CURSOR get_appraisee_access (appr_id per_appraisals.appraisal_id%TYPE)
2844: IS

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

2839: IS
2840: l_appraisal_id per_appraisals.appraisal_id%TYPE;
2841: update_personal_profile VARCHAR2 (100) DEFAULT NULL;
2842:
2843: CURSOR get_appraisee_access (appr_id per_appraisals.appraisal_id%TYPE)
2844: IS
2845: SELECT appraisal_id,
2846: appraisee_access,
2847: system_type

Line 2848: FROM per_appraisals

2844: IS
2845: SELECT appraisal_id,
2846: appraisee_access,
2847: system_type
2848: FROM per_appraisals
2849: WHERE appraisal_id = appr_id;
2850:
2851: TYPE appraisal_access_info IS RECORD (
2852: appraisal_id per_appraisals.appraisal_id%TYPE,

Line 2852: appraisal_id per_appraisals.appraisal_id%TYPE,

2848: FROM per_appraisals
2849: WHERE appraisal_id = appr_id;
2850:
2851: TYPE appraisal_access_info IS RECORD (
2852: appraisal_id per_appraisals.appraisal_id%TYPE,
2853: appraisee_access per_appraisals.appraisee_access%TYPE,
2854: system_type per_appraisals.system_type%TYPE
2855: );
2856:

Line 2853: appraisee_access per_appraisals.appraisee_access%TYPE,

2849: WHERE appraisal_id = appr_id;
2850:
2851: TYPE appraisal_access_info IS RECORD (
2852: appraisal_id per_appraisals.appraisal_id%TYPE,
2853: appraisee_access per_appraisals.appraisee_access%TYPE,
2854: system_type per_appraisals.system_type%TYPE
2855: );
2856:
2857: appr_access_info appraisal_access_info;

Line 2854: system_type per_appraisals.system_type%TYPE

2850:
2851: TYPE appraisal_access_info IS RECORD (
2852: appraisal_id per_appraisals.appraisal_id%TYPE,
2853: appraisee_access per_appraisals.appraisee_access%TYPE,
2854: system_type per_appraisals.system_type%TYPE
2855: );
2856:
2857: appr_access_info appraisal_access_info;
2858: BEGIN

Line 2905: lv_provide_overall_feedback per_appraisals.provide_overall_feedback%TYPE;

2901: item_key IN VARCHAR2,
2902: p_result_out IN OUT NOCOPY VARCHAR2
2903: )
2904: IS
2905: lv_provide_overall_feedback per_appraisals.provide_overall_feedback%TYPE;
2906: l_appraisal_id per_appraisals.appraisal_id%TYPE;
2907: BEGIN
2908: l_appraisal_id :=
2909: wf_engine.getitemattrnumber (itemtype => item_type,

Line 2906: l_appraisal_id per_appraisals.appraisal_id%TYPE;

2902: p_result_out IN OUT NOCOPY VARCHAR2
2903: )
2904: IS
2905: lv_provide_overall_feedback per_appraisals.provide_overall_feedback%TYPE;
2906: l_appraisal_id per_appraisals.appraisal_id%TYPE;
2907: BEGIN
2908: l_appraisal_id :=
2909: wf_engine.getitemattrnumber (itemtype => item_type,
2910: itemkey => item_key,

Line 2917: FROM per_appraisals

2913: );
2914:
2915: SELECT provide_overall_feedback
2916: INTO lv_provide_overall_feedback
2917: FROM per_appraisals
2918: WHERE appraisal_id = l_appraisal_id;
2919:
2920: IF (lv_provide_overall_feedback = 'Y')
2921: THEN

Line 2922: UPDATE per_appraisals

2918: WHERE appraisal_id = l_appraisal_id;
2919:
2920: IF (lv_provide_overall_feedback = 'Y')
2921: THEN
2922: UPDATE per_appraisals
2923: SET provide_overall_feedback = 'N'
2924: WHERE appraisal_id = l_appraisal_id;
2925: END IF;
2926:

Line 2934: UPDATE per_appraisals

2930: );
2931:
2932: IF (lv_provide_overall_feedback = 'Y')
2933: THEN
2934: UPDATE per_appraisals
2935: SET provide_overall_feedback = 'Y'
2936: WHERE appraisal_id = l_appraisal_id;
2937: END IF;
2938: