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_WPM_MASS_APR_PUSH dependencies on PER_APPRAISALS

Line 435: p_appraisal_sys_type in out nocopy per_appraisals.appraisal_system_status%TYPE

431: function get_appraisal_config_params(p_appr_initiator_code in per_appraisal_periods.initiator_code%TYPE,
432: p_function_id in out nocopy fnd_form_functions.function_id%TYPE,
433: p_function_name in out nocopy fnd_form_functions.function_name%TYPE,
434: p_func_parameters in out nocopy fnd_form_functions.parameters%TYPE,
435: p_appraisal_sys_type in out nocopy per_appraisals.appraisal_system_status%TYPE
436: )
437: return boolean
438: is
439: l_resp_id number;

Line 772: p_appraisal_status per_appraisals.status%TYPE default 'PLANNED',

768: p_appraisal_templ_id per_appraisal_templates.appraisal_template_id%TYPE,
769: p_effective_date DATE,
770: p_appraisal_start_date DATE,
771: p_appraisal_end_date DATE,
772: p_appraisal_status per_appraisals.status%TYPE default 'PLANNED',
773: p_type per_appraisals.type%TYPE default null,
774: p_appraisal_date per_appraisals.appraisal_date%TYPE,
775: -- p_appraisal_system_status per_appraisals.appraisal_system_status%TYPE,
776: p_plan_id number,

Line 773: p_type per_appraisals.type%TYPE default null,

769: p_effective_date DATE,
770: p_appraisal_start_date DATE,
771: p_appraisal_end_date DATE,
772: p_appraisal_status per_appraisals.status%TYPE default 'PLANNED',
773: p_type per_appraisals.type%TYPE default null,
774: p_appraisal_date per_appraisals.appraisal_date%TYPE,
775: -- p_appraisal_system_status per_appraisals.appraisal_system_status%TYPE,
776: p_plan_id number,
777: p_next_appraisal_date per_appraisals.next_appraisal_date%TYPE default null,

Line 774: p_appraisal_date per_appraisals.appraisal_date%TYPE,

770: p_appraisal_start_date DATE,
771: p_appraisal_end_date DATE,
772: p_appraisal_status per_appraisals.status%TYPE default 'PLANNED',
773: p_type per_appraisals.type%TYPE default null,
774: p_appraisal_date per_appraisals.appraisal_date%TYPE,
775: -- p_appraisal_system_status per_appraisals.appraisal_system_status%TYPE,
776: p_plan_id number,
777: p_next_appraisal_date per_appraisals.next_appraisal_date%TYPE default null,
778: p_status per_appraisals.status%TYPE default null,

Line 775: -- p_appraisal_system_status per_appraisals.appraisal_system_status%TYPE,

771: p_appraisal_end_date DATE,
772: p_appraisal_status per_appraisals.status%TYPE default 'PLANNED',
773: p_type per_appraisals.type%TYPE default null,
774: p_appraisal_date per_appraisals.appraisal_date%TYPE,
775: -- p_appraisal_system_status per_appraisals.appraisal_system_status%TYPE,
776: p_plan_id number,
777: p_next_appraisal_date per_appraisals.next_appraisal_date%TYPE default null,
778: p_status per_appraisals.status%TYPE default null,
779: p_comments per_appraisals.comments%TYPE default null,

Line 777: p_next_appraisal_date per_appraisals.next_appraisal_date%TYPE default null,

773: p_type per_appraisals.type%TYPE default null,
774: p_appraisal_date per_appraisals.appraisal_date%TYPE,
775: -- p_appraisal_system_status per_appraisals.appraisal_system_status%TYPE,
776: p_plan_id number,
777: p_next_appraisal_date per_appraisals.next_appraisal_date%TYPE default null,
778: p_status per_appraisals.status%TYPE default null,
779: p_comments per_appraisals.comments%TYPE default null,
780: p_appraisee_access per_appraisals.appraisee_access%TYPE default null,
781: p_appraisal_initiator per_appraisal_periods.initiator_code%TYPE,

Line 778: p_status per_appraisals.status%TYPE default null,

774: p_appraisal_date per_appraisals.appraisal_date%TYPE,
775: -- p_appraisal_system_status per_appraisals.appraisal_system_status%TYPE,
776: p_plan_id number,
777: p_next_appraisal_date per_appraisals.next_appraisal_date%TYPE default null,
778: p_status per_appraisals.status%TYPE default null,
779: p_comments per_appraisals.comments%TYPE default null,
780: p_appraisee_access per_appraisals.appraisee_access%TYPE default null,
781: p_appraisal_initiator per_appraisal_periods.initiator_code%TYPE,
782: p_appraisal_system_type in per_appraisal_periods.appraisal_system_type%TYPE,

Line 779: p_comments per_appraisals.comments%TYPE default null,

775: -- p_appraisal_system_status per_appraisals.appraisal_system_status%TYPE,
776: p_plan_id number,
777: p_next_appraisal_date per_appraisals.next_appraisal_date%TYPE default null,
778: p_status per_appraisals.status%TYPE default null,
779: p_comments per_appraisals.comments%TYPE default null,
780: p_appraisee_access per_appraisals.appraisee_access%TYPE default null,
781: p_appraisal_initiator per_appraisal_periods.initiator_code%TYPE,
782: p_appraisal_system_type in per_appraisal_periods.appraisal_system_type%TYPE,
783: p_return_status out nocopy VARCHAR2

Line 780: p_appraisee_access per_appraisals.appraisee_access%TYPE default null,

776: p_plan_id number,
777: p_next_appraisal_date per_appraisals.next_appraisal_date%TYPE default null,
778: p_status per_appraisals.status%TYPE default null,
779: p_comments per_appraisals.comments%TYPE default null,
780: p_appraisee_access per_appraisals.appraisee_access%TYPE default null,
781: p_appraisal_initiator per_appraisal_periods.initiator_code%TYPE,
782: p_appraisal_system_type in per_appraisal_periods.appraisal_system_type%TYPE,
783: p_return_status out nocopy VARCHAR2
784: )

Line 827: cursor get_appraisal_templ_info (p_appraisal_templ_id per_appraisals.appraisal_template_id%TYPE)

823: ppf.effective_end_date
824: and pps.date_start= paf.PERIOD_OF_PLACEMENT_DATE_START
825: and pps.person_id = paf.person_id;
826:
827: cursor get_appraisal_templ_info (p_appraisal_templ_id per_appraisals.appraisal_template_id%TYPE)
828: IS
829: SELECT appraisal_template_id, assessment_type_id, objective_asmnt_type_id, business_group_id,
830: show_competency_ratings ,
831: show_objective_ratings ,

Line 873: p_appr_prd_st_dt per_appraisals.appraisal_period_start_date%TYPE,

869: select DEFAULT_JOB_COMPETENCIES, ASSESSMENT_TYPE_ID from per_assessment_types
870: where ASSESSMENT_TYPE_ID = p_assess_templ;
871:
872: cursor find_appraisal(p_plan_id per_perf_mgmt_plans.plan_id%TYPE,
873: p_appr_prd_st_dt per_appraisals.appraisal_period_start_date%TYPE,
874: p_appr_prd_ed_dt per_appraisals.appraisal_period_end_date%TYPE,
875: p_appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
876: -- p_appraiser_person_id per_appraisals.appraiser_person_id%TYPE,
877: -- p_main_appraiser_id per_appraisals.main_appraiser_id%TYPE,

Line 874: p_appr_prd_ed_dt per_appraisals.appraisal_period_end_date%TYPE,

870: where ASSESSMENT_TYPE_ID = p_assess_templ;
871:
872: cursor find_appraisal(p_plan_id per_perf_mgmt_plans.plan_id%TYPE,
873: p_appr_prd_st_dt per_appraisals.appraisal_period_start_date%TYPE,
874: p_appr_prd_ed_dt per_appraisals.appraisal_period_end_date%TYPE,
875: p_appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
876: -- p_appraiser_person_id per_appraisals.appraiser_person_id%TYPE,
877: -- p_main_appraiser_id per_appraisals.main_appraiser_id%TYPE,
878: p_appr_templ_id per_appraisals.appraisal_template_id%TYPE

Line 875: p_appraisee_person_id per_appraisals.appraisee_person_id%TYPE,

871:
872: cursor find_appraisal(p_plan_id per_perf_mgmt_plans.plan_id%TYPE,
873: p_appr_prd_st_dt per_appraisals.appraisal_period_start_date%TYPE,
874: p_appr_prd_ed_dt per_appraisals.appraisal_period_end_date%TYPE,
875: p_appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
876: -- p_appraiser_person_id per_appraisals.appraiser_person_id%TYPE,
877: -- p_main_appraiser_id per_appraisals.main_appraiser_id%TYPE,
878: p_appr_templ_id per_appraisals.appraisal_template_id%TYPE
879: )

Line 876: -- p_appraiser_person_id per_appraisals.appraiser_person_id%TYPE,

872: cursor find_appraisal(p_plan_id per_perf_mgmt_plans.plan_id%TYPE,
873: p_appr_prd_st_dt per_appraisals.appraisal_period_start_date%TYPE,
874: p_appr_prd_ed_dt per_appraisals.appraisal_period_end_date%TYPE,
875: p_appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
876: -- p_appraiser_person_id per_appraisals.appraiser_person_id%TYPE,
877: -- p_main_appraiser_id per_appraisals.main_appraiser_id%TYPE,
878: p_appr_templ_id per_appraisals.appraisal_template_id%TYPE
879: )
880: is

Line 877: -- p_main_appraiser_id per_appraisals.main_appraiser_id%TYPE,

873: p_appr_prd_st_dt per_appraisals.appraisal_period_start_date%TYPE,
874: p_appr_prd_ed_dt per_appraisals.appraisal_period_end_date%TYPE,
875: p_appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
876: -- p_appraiser_person_id per_appraisals.appraiser_person_id%TYPE,
877: -- p_main_appraiser_id per_appraisals.main_appraiser_id%TYPE,
878: p_appr_templ_id per_appraisals.appraisal_template_id%TYPE
879: )
880: is
881: select appraisal_id,appraisal_system_status from per_appraisals

Line 878: p_appr_templ_id per_appraisals.appraisal_template_id%TYPE

874: p_appr_prd_ed_dt per_appraisals.appraisal_period_end_date%TYPE,
875: p_appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
876: -- p_appraiser_person_id per_appraisals.appraiser_person_id%TYPE,
877: -- p_main_appraiser_id per_appraisals.main_appraiser_id%TYPE,
878: p_appr_templ_id per_appraisals.appraisal_template_id%TYPE
879: )
880: is
881: select appraisal_id,appraisal_system_status from per_appraisals
882: where plan_id = p_plan_id

Line 881: select appraisal_id,appraisal_system_status from per_appraisals

877: -- p_main_appraiser_id per_appraisals.main_appraiser_id%TYPE,
878: p_appr_templ_id per_appraisals.appraisal_template_id%TYPE
879: )
880: is
881: select appraisal_id,appraisal_system_status from per_appraisals
882: where plan_id = p_plan_id
883: and appraisal_period_start_date = p_appr_prd_st_dt --5194541 to_date(p_appr_prd_st_dt,'RRRR-MM-DD')
884: and appraisal_period_end_date = p_appr_prd_ed_dt --5194541 to_date(p_appr_prd_ed_dt,'RRRR-MM-DD')
885: and appraisee_person_id = p_appraisee_person_id

Line 896: l_appraisal_ovn per_appraisals.object_version_number%TYPE;

892: l_scorecard_info scorecard_info;
893: NO_SCORE_CARD_WITH_THIS_ID EXCEPTION;
894: l_assignment_info assignment_info;
895: NO_ASSIGNMENT_WITH_THIS_ID EXCEPTION;
896: l_appraisal_ovn per_appraisals.object_version_number%TYPE;
897: l_apprl_return_status VARCHAR2(10) default null;
898: l_assess_comp_return_status VARCHAR2(10) default null;
899: l_assess_obj_return_status VARCHAR2(10) default null;
900: l_apprl_id per_appraisals.appraisal_id%TYPE default null;

Line 900: l_apprl_id per_appraisals.appraisal_id%TYPE default null;

896: l_appraisal_ovn per_appraisals.object_version_number%TYPE;
897: l_apprl_return_status VARCHAR2(10) default null;
898: l_assess_comp_return_status VARCHAR2(10) default null;
899: l_assess_obj_return_status VARCHAR2(10) default null;
900: l_apprl_id per_appraisals.appraisal_id%TYPE default null;
901: l_apprl_templ_info appraisal_templ_info;
902: NO_APPRL_TEMPL_WITH_THIS_ID EXCEPTION;
903: l_assessment_comp_id per_assessments.assessment_id%TYPE;
904: l_assessment_obj_id per_assessments.assessment_id%TYPE;

Line 935: l_found_appraisal_id per_appraisals.appraisal_id%TYPE;

931: l_def_job_comps sel_comp_tab;
932: APPRAISAL_SETUP_ISSUE EXCEPTION;
933: l_appraiser_id per_people_f.person_id%TYPE;
934: l_main_appraiser_id per_people_f.person_id%TYPE;
935: l_found_appraisal_id per_appraisals.appraisal_id%TYPE;
936: l_found_appraisal boolean;
937:
938:
939: -- Declare local variables

Line 950: l_appraisal_period_start_date per_appraisals.appraisal_period_start_date%TYPE;

946: l_found_comp boolean;
947: --
948: l_templ_def_job_comps per_assessment_types.default_job_competencies%TYPE;
949: l_assess_type_id per_assessment_types.assessment_type_id%TYPE;
950: l_appraisal_period_start_date per_appraisals.appraisal_period_start_date%TYPE;
951: l_appraisal_date per_appraisals.appraisal_date%TYPE;
952: Begin
953: --
954: IF g_dbg THEN op('Entering:'|| l_proc, g_REGULAR_LOG, 10); END IF;

Line 951: l_appraisal_date per_appraisals.appraisal_date%TYPE;

947: --
948: l_templ_def_job_comps per_assessment_types.default_job_competencies%TYPE;
949: l_assess_type_id per_assessment_types.assessment_type_id%TYPE;
950: l_appraisal_period_start_date per_appraisals.appraisal_period_start_date%TYPE;
951: l_appraisal_date per_appraisals.appraisal_date%TYPE;
952: Begin
953: --
954: IF g_dbg THEN op('Entering:'|| l_proc, g_REGULAR_LOG, 10); END IF;
955: IF g_dbg THEN op('Processing Appraisal for scorecard '|| p_score_card_id, g_DEBUG_LOG, 10); END IF;

Line 1556: CURSOR csr_plan_appraisals(plan_id per_appraisals.plan_id%TYPE) IS

1552: select objective_id, object_version_number
1553: from per_objectives
1554: where scorecard_id = p_scorecard_id;
1555: */
1556: CURSOR csr_plan_appraisals(plan_id per_appraisals.plan_id%TYPE) IS
1557: select appraisal_id, object_version_number from per_appraisals
1558: where plan_id = plan_id;
1559:
1560: --

Line 1557: select appraisal_id, object_version_number from per_appraisals

1553: from per_objectives
1554: where scorecard_id = p_scorecard_id;
1555: */
1556: CURSOR csr_plan_appraisals(plan_id per_appraisals.plan_id%TYPE) IS
1557: select appraisal_id, object_version_number from per_appraisals
1558: where plan_id = plan_id;
1559:
1560: --
1561: -- Scorecard cursor