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 5134: SELECT hr_general.decode_lookup('HR_WPM_SCORECARD_STATUS',status_code)

5130: PROCEDURE report_plan_summary(p_plan_id IN NUMBER
5131: ,p_sc_summary IN VARCHAR2
5132: ,p_appraisal_summary IN VARCHAR2) IS
5133: CURSOR csr_sc_summary(p_plan_id IN NUMBER) IS
5134: SELECT hr_general.decode_lookup('HR_WPM_SCORECARD_STATUS',status_code)
5135: STATUS
5136: , count(*) COUNT
5137: FROM per_personal_scorecards
5138: WHERE plan_id = p_plan_id

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

5135: STATUS
5136: , count(*) COUNT
5137: FROM per_personal_scorecards
5138: WHERE plan_id = p_plan_id
5139: GROUP BY hr_general.decode_lookup('HR_WPM_SCORECARD_STATUS',status_code)
5140: ORDER BY hr_general.decode_lookup('HR_WPM_SCORECARD_STATUS',status_code);
5141: --
5142: CURSOR csr_appraisal_summary(p_plan_id IN NUMBER) IS
5143: SELECT

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

5136: , count(*) COUNT
5137: FROM per_personal_scorecards
5138: WHERE plan_id = p_plan_id
5139: GROUP BY hr_general.decode_lookup('HR_WPM_SCORECARD_STATUS',status_code)
5140: ORDER BY hr_general.decode_lookup('HR_WPM_SCORECARD_STATUS',status_code);
5141: --
5142: CURSOR csr_appraisal_summary(p_plan_id IN NUMBER) IS
5143: SELECT
5144: hr_general.decode_lookup('APPRAISAL_SYSTEM_STATUS',appraisal_system_status)

Line 5144: hr_general.decode_lookup('APPRAISAL_SYSTEM_STATUS',appraisal_system_status)

5140: ORDER BY hr_general.decode_lookup('HR_WPM_SCORECARD_STATUS',status_code);
5141: --
5142: CURSOR csr_appraisal_summary(p_plan_id IN NUMBER) IS
5143: SELECT
5144: hr_general.decode_lookup('APPRAISAL_SYSTEM_STATUS',appraisal_system_status)
5145: STATUS
5146: ,pat.name APPRAISAL_TEMPLATE_NAME
5147: ,pa.appraisal_period_start_date
5148: ,pa.appraisal_period_end_date

Line 5155: hr_general.decode_lookup('APPRAISAL_SYSTEM_STATUS',appraisal_system_status)

5151: ,per_appraisal_templates pat
5152: WHERE pa.plan_id = p_plan_id
5153: AND pa.appraisal_template_id = pat.appraisal_template_id
5154: GROUP BY
5155: hr_general.decode_lookup('APPRAISAL_SYSTEM_STATUS',appraisal_system_status)
5156: ,pat.name
5157: ,pa.appraisal_period_start_date
5158: ,pa.appraisal_period_end_date
5159: ORDER BY

Line 5160: hr_general.decode_lookup('APPRAISAL_SYSTEM_STATUS',appraisal_system_status)

5156: ,pat.name
5157: ,pa.appraisal_period_start_date
5158: ,pa.appraisal_period_end_date
5159: ORDER BY
5160: hr_general.decode_lookup('APPRAISAL_SYSTEM_STATUS',appraisal_system_status)
5161: ,pat.name
5162: ,pa.appraisal_period_start_date
5163: ,pa.appraisal_period_end_date;
5164: BEGIN

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

5379: END IF;
5380: log_message('Details of the Plan: '||l_plan_rec.plan_name);
5381: log_message('--------------------------------------------------------------');
5382: log_message('Administrator :
5383: '||hr_general.decode_person_name(l_plan_rec.administrator_person_id));
5384: log_message('Start Date :
5385: '||TO_CHAR(l_plan_rec.start_date,'DD/MM/YYYY'));
5386: log_message('End Date :
5387: '||TO_CHAR(l_plan_rec.start_date,'DD/MM/YYYY'));

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

5385: '||TO_CHAR(l_plan_rec.start_date,'DD/MM/YYYY'));
5386: log_message('End Date :
5387: '||TO_CHAR(l_plan_rec.start_date,'DD/MM/YYYY'));
5388: log_message('Status :
5389: '||hr_general.decode_lookup('HR_WPM_PLAN_STATUS',l_plan_rec.status_code));
5390: log_message('Objective Setting Included? :
5391: '||hr_general.decode_lookup('YES_NO',l_plan_rec.include_obj_setting_flag));
5392: log_message('Appraisals Included? :
5393: '||hr_general.decode_lookup('YES_NO',l_plan_rec.include_appraisals_flag));

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

5387: '||TO_CHAR(l_plan_rec.start_date,'DD/MM/YYYY'));
5388: log_message('Status :
5389: '||hr_general.decode_lookup('HR_WPM_PLAN_STATUS',l_plan_rec.status_code));
5390: log_message('Objective Setting Included? :
5391: '||hr_general.decode_lookup('YES_NO',l_plan_rec.include_obj_setting_flag));
5392: log_message('Appraisals Included? :
5393: '||hr_general.decode_lookup('YES_NO',l_plan_rec.include_appraisals_flag));
5394: log_message('Sharing/Align Objectives Enabled?:
5395: '||hr_general.decode_lookup('YES_NO',l_plan_rec.sharing_alignment_task_flag));

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

5389: '||hr_general.decode_lookup('HR_WPM_PLAN_STATUS',l_plan_rec.status_code));
5390: log_message('Objective Setting Included? :
5391: '||hr_general.decode_lookup('YES_NO',l_plan_rec.include_obj_setting_flag));
5392: log_message('Appraisals Included? :
5393: '||hr_general.decode_lookup('YES_NO',l_plan_rec.include_appraisals_flag));
5394: log_message('Sharing/Align Objectives Enabled?:
5395: '||hr_general.decode_lookup('YES_NO',l_plan_rec.sharing_alignment_task_flag));
5396: log_message('Appraisals Included? :
5397: '||hr_general.decode_lookup('YES_NO',l_plan_rec.include_appraisals_flag));

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

5391: '||hr_general.decode_lookup('YES_NO',l_plan_rec.include_obj_setting_flag));
5392: log_message('Appraisals Included? :
5393: '||hr_general.decode_lookup('YES_NO',l_plan_rec.include_appraisals_flag));
5394: log_message('Sharing/Align Objectives Enabled?:
5395: '||hr_general.decode_lookup('YES_NO',l_plan_rec.sharing_alignment_task_flag));
5396: log_message('Appraisals Included? :
5397: '||hr_general.decode_lookup('YES_NO',l_plan_rec.include_appraisals_flag));
5398: log_message('--------------------------------------------------------------');
5399: report_plan_summary(p_plan_id=> p_plan_id

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

5393: '||hr_general.decode_lookup('YES_NO',l_plan_rec.include_appraisals_flag));
5394: log_message('Sharing/Align Objectives Enabled?:
5395: '||hr_general.decode_lookup('YES_NO',l_plan_rec.sharing_alignment_task_flag));
5396: log_message('Appraisals Included? :
5397: '||hr_general.decode_lookup('YES_NO',l_plan_rec.include_appraisals_flag));
5398: log_message('--------------------------------------------------------------');
5399: report_plan_summary(p_plan_id=> p_plan_id
5400: ,p_sc_summary =>
5401: NVL(l_plan_rec.include_obj_setting_flag,'N')