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_PERF_MGMT_PLAN_INTERNAL dependencies on HR_GENERAL

Line 6843: SELECT hr_general.decode_lookup ('HR_WPM_SCORECARD_STATUS', status_code) status, COUNT (*) COUNT

6839: PROCEDURE report_plan_summary (p_plan_id IN NUMBER, p_sc_summary IN VARCHAR2, p_appraisal_summary IN VARCHAR2)
6840: IS
6841: CURSOR csr_sc_summary (p_plan_id IN NUMBER)
6842: IS
6843: SELECT hr_general.decode_lookup ('HR_WPM_SCORECARD_STATUS', status_code) status, COUNT (*) COUNT
6844: FROM per_personal_scorecards
6845: WHERE plan_id = p_plan_id
6846: GROUP BY hr_general.decode_lookup ('HR_WPM_SCORECARD_STATUS', status_code)
6847: ORDER BY hr_general.decode_lookup ('HR_WPM_SCORECARD_STATUS', status_code);

Line 6846: GROUP BY hr_general.decode_lookup ('HR_WPM_SCORECARD_STATUS', status_code)

6842: IS
6843: SELECT hr_general.decode_lookup ('HR_WPM_SCORECARD_STATUS', status_code) status, COUNT (*) COUNT
6844: FROM per_personal_scorecards
6845: WHERE plan_id = p_plan_id
6846: GROUP BY hr_general.decode_lookup ('HR_WPM_SCORECARD_STATUS', status_code)
6847: ORDER BY hr_general.decode_lookup ('HR_WPM_SCORECARD_STATUS', status_code);
6848:
6849: --
6850: CURSOR csr_appraisal_summary (p_plan_id IN NUMBER)

Line 6847: ORDER BY hr_general.decode_lookup ('HR_WPM_SCORECARD_STATUS', status_code);

6843: SELECT hr_general.decode_lookup ('HR_WPM_SCORECARD_STATUS', status_code) status, COUNT (*) COUNT
6844: FROM per_personal_scorecards
6845: WHERE plan_id = p_plan_id
6846: GROUP BY hr_general.decode_lookup ('HR_WPM_SCORECARD_STATUS', status_code)
6847: ORDER BY hr_general.decode_lookup ('HR_WPM_SCORECARD_STATUS', status_code);
6848:
6849: --
6850: CURSOR csr_appraisal_summary (p_plan_id IN NUMBER)
6851: IS

Line 6852: SELECT hr_general.decode_lookup ('APPRAISAL_SYSTEM_STATUS', appraisal_system_status) status,

6848:
6849: --
6850: CURSOR csr_appraisal_summary (p_plan_id IN NUMBER)
6851: IS
6852: SELECT hr_general.decode_lookup ('APPRAISAL_SYSTEM_STATUS', appraisal_system_status) status,
6853: pat.NAME appraisal_template_name, pa.appraisal_period_start_date, pa.appraisal_period_end_date, COUNT (*)
6854: COUNT
6855: FROM per_appraisals pa, per_appraisal_templates pat
6856: WHERE pa.plan_id = p_plan_id AND pa.appraisal_template_id = pat.appraisal_template_id

Line 6857: GROUP BY hr_general.decode_lookup ('APPRAISAL_SYSTEM_STATUS', appraisal_system_status),

6853: pat.NAME appraisal_template_name, pa.appraisal_period_start_date, pa.appraisal_period_end_date, COUNT (*)
6854: COUNT
6855: FROM per_appraisals pa, per_appraisal_templates pat
6856: WHERE pa.plan_id = p_plan_id AND pa.appraisal_template_id = pat.appraisal_template_id
6857: GROUP BY hr_general.decode_lookup ('APPRAISAL_SYSTEM_STATUS', appraisal_system_status),
6858: pat.NAME,
6859: pa.appraisal_period_start_date,
6860: pa.appraisal_period_end_date
6861: ORDER BY hr_general.decode_lookup ('APPRAISAL_SYSTEM_STATUS', appraisal_system_status),

Line 6861: ORDER BY hr_general.decode_lookup ('APPRAISAL_SYSTEM_STATUS', appraisal_system_status),

6857: GROUP BY hr_general.decode_lookup ('APPRAISAL_SYSTEM_STATUS', appraisal_system_status),
6858: pat.NAME,
6859: pa.appraisal_period_start_date,
6860: pa.appraisal_period_end_date
6861: ORDER BY hr_general.decode_lookup ('APPRAISAL_SYSTEM_STATUS', appraisal_system_status),
6862: pat.NAME,
6863: pa.appraisal_period_start_date,
6864: pa.appraisal_period_end_date;
6865: BEGIN

Line 7153: ' || hr_general.decode_person_name (l_plan_rec.administrator_person_id));

7149:
7150: log_message ('Details of the Plan: ' || l_plan_rec.plan_name);
7151: log_message ('--------------------------------------------------------------');
7152: log_message ('Administrator :
7153: ' || hr_general.decode_person_name (l_plan_rec.administrator_person_id));
7154: log_message ('Start Date :
7155: ' || TO_CHAR (l_plan_rec.start_date, 'DD/MM/YYYY'));
7156: log_message ('End Date :
7157: ' || TO_CHAR (l_plan_rec.start_date, 'DD/MM/YYYY'));

Line 7160: || hr_general.decode_lookup ('HR_WPM_PLAN_STATUS', l_plan_rec.status_code)

7156: log_message ('End Date :
7157: ' || TO_CHAR (l_plan_rec.start_date, 'DD/MM/YYYY'));
7158: log_message ( 'Status :
7159: '
7160: || hr_general.decode_lookup ('HR_WPM_PLAN_STATUS', l_plan_rec.status_code)
7161: );
7162: log_message ( 'Objective Setting Included? :
7163: '
7164: || hr_general.decode_lookup ('YES_NO', l_plan_rec.include_obj_setting_flag)

Line 7164: || hr_general.decode_lookup ('YES_NO', l_plan_rec.include_obj_setting_flag)

7160: || hr_general.decode_lookup ('HR_WPM_PLAN_STATUS', l_plan_rec.status_code)
7161: );
7162: log_message ( 'Objective Setting Included? :
7163: '
7164: || hr_general.decode_lookup ('YES_NO', l_plan_rec.include_obj_setting_flag)
7165: );
7166: log_message ( 'Appraisals Included? :
7167: '
7168: || hr_general.decode_lookup ('YES_NO', l_plan_rec.include_appraisals_flag)

Line 7168: || hr_general.decode_lookup ('YES_NO', l_plan_rec.include_appraisals_flag)

7164: || hr_general.decode_lookup ('YES_NO', l_plan_rec.include_obj_setting_flag)
7165: );
7166: log_message ( 'Appraisals Included? :
7167: '
7168: || hr_general.decode_lookup ('YES_NO', l_plan_rec.include_appraisals_flag)
7169: );
7170: log_message ( 'Sharing/Align Objectives Enabled?:
7171: '
7172: || hr_general.decode_lookup ('YES_NO', l_plan_rec.sharing_alignment_task_flag)

Line 7172: || hr_general.decode_lookup ('YES_NO', l_plan_rec.sharing_alignment_task_flag)

7168: || hr_general.decode_lookup ('YES_NO', l_plan_rec.include_appraisals_flag)
7169: );
7170: log_message ( 'Sharing/Align Objectives Enabled?:
7171: '
7172: || hr_general.decode_lookup ('YES_NO', l_plan_rec.sharing_alignment_task_flag)
7173: );
7174: log_message ( 'Appraisals Included? :
7175: '
7176: || hr_general.decode_lookup ('YES_NO', l_plan_rec.include_appraisals_flag)

Line 7176: || hr_general.decode_lookup ('YES_NO', l_plan_rec.include_appraisals_flag)

7172: || hr_general.decode_lookup ('YES_NO', l_plan_rec.sharing_alignment_task_flag)
7173: );
7174: log_message ( 'Appraisals Included? :
7175: '
7176: || hr_general.decode_lookup ('YES_NO', l_plan_rec.include_appraisals_flag)
7177: );
7178: log_message ('--------------------------------------------------------------');
7179: report_plan_summary (p_plan_id => p_plan_id,
7180: p_sc_summary => NVL (l_plan_rec.include_obj_setting_flag, 'N'),

Line 8409: pps.object_version_number, hr_general.decode_person_name (pps.person_id) worker_name

8405: CURSOR csr_current_population (p_plan_id IN NUMBER, p_effective_date IN DATE)
8406: IS
8407: SELECT pps.scorecard_id, pps.person_id, pps.assignment_id, NVL (pps.supervisor_id, paf.supervisor_id) supervisor_id,
8408: NVL (pps.supervisor_assignment_id, paf.supervisor_assignment_id) supervisor_assignment_id,
8409: pps.object_version_number, hr_general.decode_person_name (pps.person_id) worker_name
8410: FROM per_personal_scorecards pps, per_assignments_f paf
8411: WHERE pps.plan_id = p_plan_id
8412: AND pps.assignment_id = paf.assignment_id
8413: AND p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date;