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 58: from per_appraisals pap,

54: pap.appraisee_person_id,
55: pap.appraisal_template_id,
56: pap.system_type,
57: pap.type
58: from per_appraisals pap,
59: per_assessments pas
60: where pas.assessment_id = p_assessment_id
61: and pap.appraisal_id = pas.appraisal_id;
62:

Line 107: l_business_group_id per_appraisals.assignment_business_group_id%TYPE;

103: l_inputs ff_exec.inputs_t;
104: l_outputs ff_exec.outputs_t;
105: l_line_score NUMBER;
106:
107: l_business_group_id per_appraisals.assignment_business_group_id%TYPE;
108: l_assignment_id per_appraisals.assignment_id%TYPE;
109: l_organization_id per_appraisals.assignment_organization_id%TYPE;
110: l_person_id per_appraisals.appraisee_person_id%TYPE;
111: l_appraisal_id per_appraisals.appraisal_id%TYPE;

Line 108: l_assignment_id per_appraisals.assignment_id%TYPE;

104: l_outputs ff_exec.outputs_t;
105: l_line_score NUMBER;
106:
107: l_business_group_id per_appraisals.assignment_business_group_id%TYPE;
108: l_assignment_id per_appraisals.assignment_id%TYPE;
109: l_organization_id per_appraisals.assignment_organization_id%TYPE;
110: l_person_id per_appraisals.appraisee_person_id%TYPE;
111: l_appraisal_id per_appraisals.appraisal_id%TYPE;
112: l_appraisal_temp_id per_appraisals.appraisal_template_id%TYPE;

Line 109: l_organization_id per_appraisals.assignment_organization_id%TYPE;

105: l_line_score NUMBER;
106:
107: l_business_group_id per_appraisals.assignment_business_group_id%TYPE;
108: l_assignment_id per_appraisals.assignment_id%TYPE;
109: l_organization_id per_appraisals.assignment_organization_id%TYPE;
110: l_person_id per_appraisals.appraisee_person_id%TYPE;
111: l_appraisal_id per_appraisals.appraisal_id%TYPE;
112: l_appraisal_temp_id per_appraisals.appraisal_template_id%TYPE;
113: l_appr_system_type per_appraisals.system_type%TYPE;

Line 110: l_person_id per_appraisals.appraisee_person_id%TYPE;

106:
107: l_business_group_id per_appraisals.assignment_business_group_id%TYPE;
108: l_assignment_id per_appraisals.assignment_id%TYPE;
109: l_organization_id per_appraisals.assignment_organization_id%TYPE;
110: l_person_id per_appraisals.appraisee_person_id%TYPE;
111: l_appraisal_id per_appraisals.appraisal_id%TYPE;
112: l_appraisal_temp_id per_appraisals.appraisal_template_id%TYPE;
113: l_appr_system_type per_appraisals.system_type%TYPE;
114: l_appr_type per_appraisals.type%TYPE;

Line 111: l_appraisal_id per_appraisals.appraisal_id%TYPE;

107: l_business_group_id per_appraisals.assignment_business_group_id%TYPE;
108: l_assignment_id per_appraisals.assignment_id%TYPE;
109: l_organization_id per_appraisals.assignment_organization_id%TYPE;
110: l_person_id per_appraisals.appraisee_person_id%TYPE;
111: l_appraisal_id per_appraisals.appraisal_id%TYPE;
112: l_appraisal_temp_id per_appraisals.appraisal_template_id%TYPE;
113: l_appr_system_type per_appraisals.system_type%TYPE;
114: l_appr_type per_appraisals.type%TYPE;
115: --

Line 112: l_appraisal_temp_id per_appraisals.appraisal_template_id%TYPE;

108: l_assignment_id per_appraisals.assignment_id%TYPE;
109: l_organization_id per_appraisals.assignment_organization_id%TYPE;
110: l_person_id per_appraisals.appraisee_person_id%TYPE;
111: l_appraisal_id per_appraisals.appraisal_id%TYPE;
112: l_appraisal_temp_id per_appraisals.appraisal_template_id%TYPE;
113: l_appr_system_type per_appraisals.system_type%TYPE;
114: l_appr_type per_appraisals.type%TYPE;
115: --
116: -- Get the line FF.

Line 113: l_appr_system_type per_appraisals.system_type%TYPE;

109: l_organization_id per_appraisals.assignment_organization_id%TYPE;
110: l_person_id per_appraisals.appraisee_person_id%TYPE;
111: l_appraisal_id per_appraisals.appraisal_id%TYPE;
112: l_appraisal_temp_id per_appraisals.appraisal_template_id%TYPE;
113: l_appr_system_type per_appraisals.system_type%TYPE;
114: l_appr_type per_appraisals.type%TYPE;
115: --
116: -- Get the line FF.
117: --

Line 114: l_appr_type per_appraisals.type%TYPE;

110: l_person_id per_appraisals.appraisee_person_id%TYPE;
111: l_appraisal_id per_appraisals.appraisal_id%TYPE;
112: l_appraisal_temp_id per_appraisals.appraisal_template_id%TYPE;
113: l_appr_system_type per_appraisals.system_type%TYPE;
114: l_appr_type per_appraisals.type%TYPE;
115: --
116: -- Get the line FF.
117: --
118: CURSOR csr_get_line_ff

Line 255: l_business_group_id per_appraisals.assignment_business_group_id%TYPE;

251: l_inputs ff_exec.inputs_t;
252: l_outputs ff_exec.outputs_t;
253: l_line_score NUMBER;
254:
255: l_business_group_id per_appraisals.assignment_business_group_id%TYPE;
256: l_assignment_id per_appraisals.assignment_id%TYPE;
257: l_organization_id per_appraisals.assignment_organization_id%TYPE;
258: l_person_id per_appraisals.appraisee_person_id%TYPE;
259: l_appraisal_id per_appraisals.appraisal_id%TYPE;

Line 256: l_assignment_id per_appraisals.assignment_id%TYPE;

252: l_outputs ff_exec.outputs_t;
253: l_line_score NUMBER;
254:
255: l_business_group_id per_appraisals.assignment_business_group_id%TYPE;
256: l_assignment_id per_appraisals.assignment_id%TYPE;
257: l_organization_id per_appraisals.assignment_organization_id%TYPE;
258: l_person_id per_appraisals.appraisee_person_id%TYPE;
259: l_appraisal_id per_appraisals.appraisal_id%TYPE;
260: l_appraisal_temp_id per_appraisals.appraisal_template_id%TYPE;

Line 257: l_organization_id per_appraisals.assignment_organization_id%TYPE;

253: l_line_score NUMBER;
254:
255: l_business_group_id per_appraisals.assignment_business_group_id%TYPE;
256: l_assignment_id per_appraisals.assignment_id%TYPE;
257: l_organization_id per_appraisals.assignment_organization_id%TYPE;
258: l_person_id per_appraisals.appraisee_person_id%TYPE;
259: l_appraisal_id per_appraisals.appraisal_id%TYPE;
260: l_appraisal_temp_id per_appraisals.appraisal_template_id%TYPE;
261: l_appr_system_type per_appraisals.system_type%TYPE;

Line 258: l_person_id per_appraisals.appraisee_person_id%TYPE;

254:
255: l_business_group_id per_appraisals.assignment_business_group_id%TYPE;
256: l_assignment_id per_appraisals.assignment_id%TYPE;
257: l_organization_id per_appraisals.assignment_organization_id%TYPE;
258: l_person_id per_appraisals.appraisee_person_id%TYPE;
259: l_appraisal_id per_appraisals.appraisal_id%TYPE;
260: l_appraisal_temp_id per_appraisals.appraisal_template_id%TYPE;
261: l_appr_system_type per_appraisals.system_type%TYPE;
262: l_appr_type per_appraisals.type%TYPE;

Line 259: l_appraisal_id per_appraisals.appraisal_id%TYPE;

255: l_business_group_id per_appraisals.assignment_business_group_id%TYPE;
256: l_assignment_id per_appraisals.assignment_id%TYPE;
257: l_organization_id per_appraisals.assignment_organization_id%TYPE;
258: l_person_id per_appraisals.appraisee_person_id%TYPE;
259: l_appraisal_id per_appraisals.appraisal_id%TYPE;
260: l_appraisal_temp_id per_appraisals.appraisal_template_id%TYPE;
261: l_appr_system_type per_appraisals.system_type%TYPE;
262: l_appr_type per_appraisals.type%TYPE;
263: --

Line 260: l_appraisal_temp_id per_appraisals.appraisal_template_id%TYPE;

256: l_assignment_id per_appraisals.assignment_id%TYPE;
257: l_organization_id per_appraisals.assignment_organization_id%TYPE;
258: l_person_id per_appraisals.appraisee_person_id%TYPE;
259: l_appraisal_id per_appraisals.appraisal_id%TYPE;
260: l_appraisal_temp_id per_appraisals.appraisal_template_id%TYPE;
261: l_appr_system_type per_appraisals.system_type%TYPE;
262: l_appr_type per_appraisals.type%TYPE;
263: --
264: -- Get the line FF.

Line 261: l_appr_system_type per_appraisals.system_type%TYPE;

257: l_organization_id per_appraisals.assignment_organization_id%TYPE;
258: l_person_id per_appraisals.appraisee_person_id%TYPE;
259: l_appraisal_id per_appraisals.appraisal_id%TYPE;
260: l_appraisal_temp_id per_appraisals.appraisal_template_id%TYPE;
261: l_appr_system_type per_appraisals.system_type%TYPE;
262: l_appr_type per_appraisals.type%TYPE;
263: --
264: -- Get the line FF.
265: --

Line 262: l_appr_type per_appraisals.type%TYPE;

258: l_person_id per_appraisals.appraisee_person_id%TYPE;
259: l_appraisal_id per_appraisals.appraisal_id%TYPE;
260: l_appraisal_temp_id per_appraisals.appraisal_template_id%TYPE;
261: l_appr_system_type per_appraisals.system_type%TYPE;
262: l_appr_type per_appraisals.type%TYPE;
263: --
264: -- Get the line FF.
265: --
266: CURSOR csr_get_line_ff

Line 528: l_appraisal_id per_appraisals.appraisal_id%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;
532: close get_score_formula;

Line 882: select substr(system_params,instr(system_params,'pItemKey=')+9) into l_itemkey from per_appraisals where appraisal_id=p_appraisal_id;

878: function get_item_key(p_appraisal_id VARCHAR2) return varchar2 is
879: l_itemkey varchar2(1000);
880: begin
881:
882: select substr(system_params,instr(system_params,'pItemKey=')+9) into l_itemkey from per_appraisals where appraisal_id=p_appraisal_id;
883: return l_itemkey;
884:
885: Exception
886: when others then