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_APPRAISALS_UTIL_SS dependencies on PER_ASSESSMENT_TYPES

Line 390: select line_score_formula, line_score_formula_id from per_assessment_types, per_assessments

386:
387: function get_competence_score (p_competence_id NUMBER,
388: p_assessment_id NUMBER) return NUMBER IS
389: cursor get_line_formula is
390: select line_score_formula, line_score_formula_id from per_assessment_types, per_assessments
391: where per_assessments.assessment_id = p_assessment_id
392: and per_assessments.assessment_type_id = per_assessment_types.assessment_type_id;
393:
394: l_num_part NUMBER := 0;

Line 392: and per_assessments.assessment_type_id = per_assessment_types.assessment_type_id;

388: p_assessment_id NUMBER) return NUMBER IS
389: cursor get_line_formula is
390: select line_score_formula, line_score_formula_id from per_assessment_types, per_assessments
391: where per_assessments.assessment_id = p_assessment_id
392: and per_assessments.assessment_type_id = per_assessment_types.assessment_type_id;
393:
394: l_num_part NUMBER := 0;
395: l_line_formula per_assessment_types.line_score_formula%type;
396: l_line_formula_id per_assessment_types.line_score_formula_id%type;

Line 395: l_line_formula per_assessment_types.line_score_formula%type;

391: where per_assessments.assessment_id = p_assessment_id
392: and per_assessments.assessment_type_id = per_assessment_types.assessment_type_id;
393:
394: l_num_part NUMBER := 0;
395: l_line_formula per_assessment_types.line_score_formula%type;
396: l_line_formula_id per_assessment_types.line_score_formula_id%type;
397: l_prof_value NUMBER;
398: l_perf_value NUMBER;
399: l_weigh_value NUMBER;

Line 396: l_line_formula_id per_assessment_types.line_score_formula_id%type;

392: and per_assessments.assessment_type_id = per_assessment_types.assessment_type_id;
393:
394: l_num_part NUMBER := 0;
395: l_line_formula per_assessment_types.line_score_formula%type;
396: l_line_formula_id per_assessment_types.line_score_formula_id%type;
397: l_prof_value NUMBER;
398: l_perf_value NUMBER;
399: l_weigh_value NUMBER;
400: l_tot_prof_value NUMBER default 0;

Line 447: from per_assessment_types pat,

443: cursor get_line_formula is
444: select pat.line_score_formula,
445: pat.line_score_formula_id,
446: pas.assessment_id
447: from per_assessment_types pat,
448: per_assessments pas
449: where pas.appraisal_id = p_appraisal_id
450: and pas.assessment_type_id = pat.assessment_type_id
451: and pat.type = 'OBJECTIVE';

Line 454: l_line_formula per_assessment_types.line_score_formula%type;

450: and pas.assessment_type_id = pat.assessment_type_id
451: and pat.type = 'OBJECTIVE';
452:
453: l_num_part NUMBER := 0;
454: l_line_formula per_assessment_types.line_score_formula%type;
455: l_line_formula_id per_assessment_types.line_score_formula_id%type;
456: l_assessment_id per_assessments.assessment_id%type;
457: l_perf_value NUMBER;
458: l_tot_prof_value NUMBER default 0;

Line 455: l_line_formula_id per_assessment_types.line_score_formula_id%type;

451: and pat.type = 'OBJECTIVE';
452:
453: l_num_part NUMBER := 0;
454: l_line_formula per_assessment_types.line_score_formula%type;
455: l_line_formula_id per_assessment_types.line_score_formula_id%type;
456: l_assessment_id per_assessments.assessment_id%type;
457: l_perf_value NUMBER;
458: l_tot_prof_value NUMBER default 0;
459: l_tot_perf_value NUMBER default 0;

Line 501: select total_score_formula from per_assessment_types, per_assessments

497: end get_objective_score;
498:
499: function get_assessment_score (p_assessment_id NUMBER) return NUMBER IS
500: cursor get_score_formula is
501: select total_score_formula from per_assessment_types, per_assessments
502: where per_assessments.assessment_id = p_assessment_id
503: and per_assessments.assessment_type_id = per_assessment_types.assessment_type_id;
504: cursor get_competences is
505: select distinct pce.competence_id

Line 503: and per_assessments.assessment_type_id = per_assessment_types.assessment_type_id;

499: function get_assessment_score (p_assessment_id NUMBER) return NUMBER IS
500: cursor get_score_formula is
501: select total_score_formula from per_assessment_types, per_assessments
502: where per_assessments.assessment_id = p_assessment_id
503: and per_assessments.assessment_type_id = per_assessment_types.assessment_type_id;
504: cursor get_competences is
505: select distinct pce.competence_id
506: from per_competence_elements pce
507: where pce.assessment_id = p_assessment_id and pce.type='ASSESSMENT'

Line 518: from per_assessment_types pst,

514: and po.appraisal_id = pa.appraisal_id;
515: cursor get_asmnt_type is
516: select nvl(pst.type, 'COMPETENCE'),
517: pa.appraisal_id
518: from per_assessment_types pst,
519: per_assessments pa
520: where pa.assessment_id = p_assessment_id
521: and pst.assessment_type_id = pa.assessment_type_id;
522: l_num_part NUMBER := 0;

Line 523: l_score_formula per_assessment_types.total_score_formula%type;

519: per_assessments pa
520: where pa.assessment_id = p_assessment_id
521: and pst.assessment_type_id = pa.assessment_type_id;
522: l_num_part NUMBER := 0;
523: l_score_formula per_assessment_types.total_score_formula%type;
524: l_total_score NUMBER := 0;
525: l_competence_id NUMBER;
526: l_objective_id NUMBER;
527: l_asmnt_type per_assessment_types.type%type;

Line 527: l_asmnt_type per_assessment_types.type%type;

523: l_score_formula per_assessment_types.total_score_formula%type;
524: l_total_score NUMBER := 0;
525: l_competence_id NUMBER;
526: l_objective_id NUMBER;
527: l_asmnt_type per_assessment_types.type%type;
528: l_appraisal_id per_appraisals.appraisal_id%type;
529: begin
530: open get_score_formula;
531: fetch get_score_formula into l_score_formula;

Line 579: from per_assessment_types pst,

575: p_final_formula_id NUMBER) return NUMBER IS
576: cursor get_assessments is
577: select pa.assessment_id,
578: nvl(pst.type, 'COMPETENCE')
579: from per_assessment_types pst,
580: per_assessments pa
581: where pa.appraisal_id = p_appraisal_id
582: and pst.assessment_type_id = pa.assessment_type_id;
583: cursor chk_pce(p_assessment_id NUMBER) IS

Line 597: l_asmnt_type per_assessment_types.type%type;

593: l_dummy varchar2(1);
594: l_assessment_id per_assessments.assessment_id%type;
595: l_comp_asmt_score NUMBER;
596: l_obj_asmt_score NUMBER;
597: l_asmnt_type per_assessment_types.type%type;
598: begin
599:
600: open get_assessments;
601: loop