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_APPRAISALS

Line 48: from per_appraisals pap,

44: pap.appraisee_person_id,
45: pap.appraisal_template_id,
46: pap.system_type,
47: pap.type
48: from per_appraisals pap,
49: per_assessments pas
50: where pas.assessment_id = p_assessment_id
51: and pap.appraisal_id = pas.appraisal_id;
52:

Line 97: l_business_group_id per_appraisals.assignment_business_group_id%TYPE;

93: l_inputs ff_exec.inputs_t;
94: l_outputs ff_exec.outputs_t;
95: l_line_score NUMBER;
96:
97: l_business_group_id per_appraisals.assignment_business_group_id%TYPE;
98: l_assignment_id per_appraisals.assignment_id%TYPE;
99: l_organization_id per_appraisals.assignment_organization_id%TYPE;
100: l_person_id per_appraisals.appraisee_person_id%TYPE;
101: l_appraisal_id per_appraisals.appraisal_id%TYPE;

Line 98: l_assignment_id per_appraisals.assignment_id%TYPE;

94: l_outputs ff_exec.outputs_t;
95: l_line_score NUMBER;
96:
97: l_business_group_id per_appraisals.assignment_business_group_id%TYPE;
98: l_assignment_id per_appraisals.assignment_id%TYPE;
99: l_organization_id per_appraisals.assignment_organization_id%TYPE;
100: l_person_id per_appraisals.appraisee_person_id%TYPE;
101: l_appraisal_id per_appraisals.appraisal_id%TYPE;
102: l_appraisal_temp_id per_appraisals.appraisal_template_id%TYPE;

Line 99: l_organization_id per_appraisals.assignment_organization_id%TYPE;

95: l_line_score NUMBER;
96:
97: l_business_group_id per_appraisals.assignment_business_group_id%TYPE;
98: l_assignment_id per_appraisals.assignment_id%TYPE;
99: l_organization_id per_appraisals.assignment_organization_id%TYPE;
100: l_person_id per_appraisals.appraisee_person_id%TYPE;
101: l_appraisal_id per_appraisals.appraisal_id%TYPE;
102: l_appraisal_temp_id per_appraisals.appraisal_template_id%TYPE;
103: l_appr_system_type per_appraisals.system_type%TYPE;

Line 100: l_person_id per_appraisals.appraisee_person_id%TYPE;

96:
97: l_business_group_id per_appraisals.assignment_business_group_id%TYPE;
98: l_assignment_id per_appraisals.assignment_id%TYPE;
99: l_organization_id per_appraisals.assignment_organization_id%TYPE;
100: l_person_id per_appraisals.appraisee_person_id%TYPE;
101: l_appraisal_id per_appraisals.appraisal_id%TYPE;
102: l_appraisal_temp_id per_appraisals.appraisal_template_id%TYPE;
103: l_appr_system_type per_appraisals.system_type%TYPE;
104: l_appr_type per_appraisals.type%TYPE;

Line 101: l_appraisal_id per_appraisals.appraisal_id%TYPE;

97: l_business_group_id per_appraisals.assignment_business_group_id%TYPE;
98: l_assignment_id per_appraisals.assignment_id%TYPE;
99: l_organization_id per_appraisals.assignment_organization_id%TYPE;
100: l_person_id per_appraisals.appraisee_person_id%TYPE;
101: l_appraisal_id per_appraisals.appraisal_id%TYPE;
102: l_appraisal_temp_id per_appraisals.appraisal_template_id%TYPE;
103: l_appr_system_type per_appraisals.system_type%TYPE;
104: l_appr_type per_appraisals.type%TYPE;
105: --

Line 102: l_appraisal_temp_id per_appraisals.appraisal_template_id%TYPE;

98: l_assignment_id per_appraisals.assignment_id%TYPE;
99: l_organization_id per_appraisals.assignment_organization_id%TYPE;
100: l_person_id per_appraisals.appraisee_person_id%TYPE;
101: l_appraisal_id per_appraisals.appraisal_id%TYPE;
102: l_appraisal_temp_id per_appraisals.appraisal_template_id%TYPE;
103: l_appr_system_type per_appraisals.system_type%TYPE;
104: l_appr_type per_appraisals.type%TYPE;
105: --
106: -- Get the line FF.

Line 103: l_appr_system_type per_appraisals.system_type%TYPE;

99: l_organization_id per_appraisals.assignment_organization_id%TYPE;
100: l_person_id per_appraisals.appraisee_person_id%TYPE;
101: l_appraisal_id per_appraisals.appraisal_id%TYPE;
102: l_appraisal_temp_id per_appraisals.appraisal_template_id%TYPE;
103: l_appr_system_type per_appraisals.system_type%TYPE;
104: l_appr_type per_appraisals.type%TYPE;
105: --
106: -- Get the line FF.
107: --

Line 104: l_appr_type per_appraisals.type%TYPE;

100: l_person_id per_appraisals.appraisee_person_id%TYPE;
101: l_appraisal_id per_appraisals.appraisal_id%TYPE;
102: l_appraisal_temp_id per_appraisals.appraisal_template_id%TYPE;
103: l_appr_system_type per_appraisals.system_type%TYPE;
104: l_appr_type per_appraisals.type%TYPE;
105: --
106: -- Get the line FF.
107: --
108: CURSOR csr_get_line_ff

Line 243: l_business_group_id per_appraisals.assignment_business_group_id%TYPE;

239: l_inputs ff_exec.inputs_t;
240: l_outputs ff_exec.outputs_t;
241: l_line_score NUMBER;
242:
243: l_business_group_id per_appraisals.assignment_business_group_id%TYPE;
244: l_assignment_id per_appraisals.assignment_id%TYPE;
245: l_organization_id per_appraisals.assignment_organization_id%TYPE;
246: l_person_id per_appraisals.appraisee_person_id%TYPE;
247: l_appraisal_id per_appraisals.appraisal_id%TYPE;

Line 244: l_assignment_id per_appraisals.assignment_id%TYPE;

240: l_outputs ff_exec.outputs_t;
241: l_line_score NUMBER;
242:
243: l_business_group_id per_appraisals.assignment_business_group_id%TYPE;
244: l_assignment_id per_appraisals.assignment_id%TYPE;
245: l_organization_id per_appraisals.assignment_organization_id%TYPE;
246: l_person_id per_appraisals.appraisee_person_id%TYPE;
247: l_appraisal_id per_appraisals.appraisal_id%TYPE;
248: l_appraisal_temp_id per_appraisals.appraisal_template_id%TYPE;

Line 245: l_organization_id per_appraisals.assignment_organization_id%TYPE;

241: l_line_score NUMBER;
242:
243: l_business_group_id per_appraisals.assignment_business_group_id%TYPE;
244: l_assignment_id per_appraisals.assignment_id%TYPE;
245: l_organization_id per_appraisals.assignment_organization_id%TYPE;
246: l_person_id per_appraisals.appraisee_person_id%TYPE;
247: l_appraisal_id per_appraisals.appraisal_id%TYPE;
248: l_appraisal_temp_id per_appraisals.appraisal_template_id%TYPE;
249: l_appr_system_type per_appraisals.system_type%TYPE;

Line 246: l_person_id per_appraisals.appraisee_person_id%TYPE;

242:
243: l_business_group_id per_appraisals.assignment_business_group_id%TYPE;
244: l_assignment_id per_appraisals.assignment_id%TYPE;
245: l_organization_id per_appraisals.assignment_organization_id%TYPE;
246: l_person_id per_appraisals.appraisee_person_id%TYPE;
247: l_appraisal_id per_appraisals.appraisal_id%TYPE;
248: l_appraisal_temp_id per_appraisals.appraisal_template_id%TYPE;
249: l_appr_system_type per_appraisals.system_type%TYPE;
250: l_appr_type per_appraisals.type%TYPE;

Line 247: l_appraisal_id per_appraisals.appraisal_id%TYPE;

243: l_business_group_id per_appraisals.assignment_business_group_id%TYPE;
244: l_assignment_id per_appraisals.assignment_id%TYPE;
245: l_organization_id per_appraisals.assignment_organization_id%TYPE;
246: l_person_id per_appraisals.appraisee_person_id%TYPE;
247: l_appraisal_id per_appraisals.appraisal_id%TYPE;
248: l_appraisal_temp_id per_appraisals.appraisal_template_id%TYPE;
249: l_appr_system_type per_appraisals.system_type%TYPE;
250: l_appr_type per_appraisals.type%TYPE;
251: --

Line 248: l_appraisal_temp_id per_appraisals.appraisal_template_id%TYPE;

244: l_assignment_id per_appraisals.assignment_id%TYPE;
245: l_organization_id per_appraisals.assignment_organization_id%TYPE;
246: l_person_id per_appraisals.appraisee_person_id%TYPE;
247: l_appraisal_id per_appraisals.appraisal_id%TYPE;
248: l_appraisal_temp_id per_appraisals.appraisal_template_id%TYPE;
249: l_appr_system_type per_appraisals.system_type%TYPE;
250: l_appr_type per_appraisals.type%TYPE;
251: --
252: -- Get the line FF.

Line 249: l_appr_system_type per_appraisals.system_type%TYPE;

245: l_organization_id per_appraisals.assignment_organization_id%TYPE;
246: l_person_id per_appraisals.appraisee_person_id%TYPE;
247: l_appraisal_id per_appraisals.appraisal_id%TYPE;
248: l_appraisal_temp_id per_appraisals.appraisal_template_id%TYPE;
249: l_appr_system_type per_appraisals.system_type%TYPE;
250: l_appr_type per_appraisals.type%TYPE;
251: --
252: -- Get the line FF.
253: --

Line 250: l_appr_type per_appraisals.type%TYPE;

246: l_person_id per_appraisals.appraisee_person_id%TYPE;
247: l_appraisal_id per_appraisals.appraisal_id%TYPE;
248: l_appraisal_temp_id per_appraisals.appraisal_template_id%TYPE;
249: l_appr_system_type per_appraisals.system_type%TYPE;
250: l_appr_type per_appraisals.type%TYPE;
251: --
252: -- Get the line FF.
253: --
254: CURSOR csr_get_line_ff

Line 514: l_appraisal_id per_appraisals.appraisal_id%type;

510: l_total_score NUMBER := 0;
511: l_competence_id NUMBER;
512: l_objective_id NUMBER;
513: l_asmnt_type per_assessment_types.type%type;
514: l_appraisal_id per_appraisals.appraisal_id%type;
515: begin
516: open get_score_formula;
517: fetch get_score_formula into l_score_formula;
518: close get_score_formula;