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_APPRAISAL_TEMPLATES

Line 76: appraisal_template_id per_appraisal_templates.appraisal_template_id%TYPE,

72: --
73: -- Following is added with more details to be captured
74: -- done by tpapired for 115.20 version of this file
75: TYPE appraisal_templ_info is RECORD (
76: appraisal_template_id per_appraisal_templates.appraisal_template_id%TYPE,
77: assessment_type_id per_appraisal_templates.assessment_type_id%TYPE,
78: objective_asmnt_type_id per_appraisal_templates.objective_asmnt_type_id%TYPE,
79: business_group_id per_appraisal_templates.business_group_id%TYPE,
80: show_competency_ratings per_appraisal_templates.show_competency_ratings%TYPE,

Line 77: assessment_type_id per_appraisal_templates.assessment_type_id%TYPE,

73: -- Following is added with more details to be captured
74: -- done by tpapired for 115.20 version of this file
75: TYPE appraisal_templ_info is RECORD (
76: appraisal_template_id per_appraisal_templates.appraisal_template_id%TYPE,
77: assessment_type_id per_appraisal_templates.assessment_type_id%TYPE,
78: objective_asmnt_type_id per_appraisal_templates.objective_asmnt_type_id%TYPE,
79: business_group_id per_appraisal_templates.business_group_id%TYPE,
80: show_competency_ratings per_appraisal_templates.show_competency_ratings%TYPE,
81: show_objective_ratings per_appraisal_templates.show_objective_ratings%TYPE,

Line 78: objective_asmnt_type_id per_appraisal_templates.objective_asmnt_type_id%TYPE,

74: -- done by tpapired for 115.20 version of this file
75: TYPE appraisal_templ_info is RECORD (
76: appraisal_template_id per_appraisal_templates.appraisal_template_id%TYPE,
77: assessment_type_id per_appraisal_templates.assessment_type_id%TYPE,
78: objective_asmnt_type_id per_appraisal_templates.objective_asmnt_type_id%TYPE,
79: business_group_id per_appraisal_templates.business_group_id%TYPE,
80: show_competency_ratings per_appraisal_templates.show_competency_ratings%TYPE,
81: show_objective_ratings per_appraisal_templates.show_objective_ratings%TYPE,
82: show_questionnaire_info per_appraisal_templates.show_questionnaire_info%TYPE,

Line 79: business_group_id per_appraisal_templates.business_group_id%TYPE,

75: TYPE appraisal_templ_info is RECORD (
76: appraisal_template_id per_appraisal_templates.appraisal_template_id%TYPE,
77: assessment_type_id per_appraisal_templates.assessment_type_id%TYPE,
78: objective_asmnt_type_id per_appraisal_templates.objective_asmnt_type_id%TYPE,
79: business_group_id per_appraisal_templates.business_group_id%TYPE,
80: show_competency_ratings per_appraisal_templates.show_competency_ratings%TYPE,
81: show_objective_ratings per_appraisal_templates.show_objective_ratings%TYPE,
82: show_questionnaire_info per_appraisal_templates.show_questionnaire_info%TYPE,
83: show_participant_details per_appraisal_templates.show_participant_details%TYPE,

Line 80: show_competency_ratings per_appraisal_templates.show_competency_ratings%TYPE,

76: appraisal_template_id per_appraisal_templates.appraisal_template_id%TYPE,
77: assessment_type_id per_appraisal_templates.assessment_type_id%TYPE,
78: objective_asmnt_type_id per_appraisal_templates.objective_asmnt_type_id%TYPE,
79: business_group_id per_appraisal_templates.business_group_id%TYPE,
80: show_competency_ratings per_appraisal_templates.show_competency_ratings%TYPE,
81: show_objective_ratings per_appraisal_templates.show_objective_ratings%TYPE,
82: show_questionnaire_info per_appraisal_templates.show_questionnaire_info%TYPE,
83: show_participant_details per_appraisal_templates.show_participant_details%TYPE,
84: show_participant_ratings per_appraisal_templates.show_participant_ratings%TYPE,

Line 81: show_objective_ratings per_appraisal_templates.show_objective_ratings%TYPE,

77: assessment_type_id per_appraisal_templates.assessment_type_id%TYPE,
78: objective_asmnt_type_id per_appraisal_templates.objective_asmnt_type_id%TYPE,
79: business_group_id per_appraisal_templates.business_group_id%TYPE,
80: show_competency_ratings per_appraisal_templates.show_competency_ratings%TYPE,
81: show_objective_ratings per_appraisal_templates.show_objective_ratings%TYPE,
82: show_questionnaire_info per_appraisal_templates.show_questionnaire_info%TYPE,
83: show_participant_details per_appraisal_templates.show_participant_details%TYPE,
84: show_participant_ratings per_appraisal_templates.show_participant_ratings%TYPE,
85: show_participant_names per_appraisal_templates.show_participant_names%TYPE,

Line 82: show_questionnaire_info per_appraisal_templates.show_questionnaire_info%TYPE,

78: objective_asmnt_type_id per_appraisal_templates.objective_asmnt_type_id%TYPE,
79: business_group_id per_appraisal_templates.business_group_id%TYPE,
80: show_competency_ratings per_appraisal_templates.show_competency_ratings%TYPE,
81: show_objective_ratings per_appraisal_templates.show_objective_ratings%TYPE,
82: show_questionnaire_info per_appraisal_templates.show_questionnaire_info%TYPE,
83: show_participant_details per_appraisal_templates.show_participant_details%TYPE,
84: show_participant_ratings per_appraisal_templates.show_participant_ratings%TYPE,
85: show_participant_names per_appraisal_templates.show_participant_names%TYPE,
86: show_overall_ratings per_appraisal_templates.show_overall_ratings%TYPE,

Line 83: show_participant_details per_appraisal_templates.show_participant_details%TYPE,

79: business_group_id per_appraisal_templates.business_group_id%TYPE,
80: show_competency_ratings per_appraisal_templates.show_competency_ratings%TYPE,
81: show_objective_ratings per_appraisal_templates.show_objective_ratings%TYPE,
82: show_questionnaire_info per_appraisal_templates.show_questionnaire_info%TYPE,
83: show_participant_details per_appraisal_templates.show_participant_details%TYPE,
84: show_participant_ratings per_appraisal_templates.show_participant_ratings%TYPE,
85: show_participant_names per_appraisal_templates.show_participant_names%TYPE,
86: show_overall_ratings per_appraisal_templates.show_overall_ratings%TYPE,
87: disable_provide_feed per_appraisal_templates.provide_overall_feedback%TYPE, --Bug7393131

Line 84: show_participant_ratings per_appraisal_templates.show_participant_ratings%TYPE,

80: show_competency_ratings per_appraisal_templates.show_competency_ratings%TYPE,
81: show_objective_ratings per_appraisal_templates.show_objective_ratings%TYPE,
82: show_questionnaire_info per_appraisal_templates.show_questionnaire_info%TYPE,
83: show_participant_details per_appraisal_templates.show_participant_details%TYPE,
84: show_participant_ratings per_appraisal_templates.show_participant_ratings%TYPE,
85: show_participant_names per_appraisal_templates.show_participant_names%TYPE,
86: show_overall_ratings per_appraisal_templates.show_overall_ratings%TYPE,
87: disable_provide_feed per_appraisal_templates.provide_overall_feedback%TYPE, --Bug7393131
88: show_overall_comments per_appraisal_templates.show_overall_comments%TYPE

Line 85: show_participant_names per_appraisal_templates.show_participant_names%TYPE,

81: show_objective_ratings per_appraisal_templates.show_objective_ratings%TYPE,
82: show_questionnaire_info per_appraisal_templates.show_questionnaire_info%TYPE,
83: show_participant_details per_appraisal_templates.show_participant_details%TYPE,
84: show_participant_ratings per_appraisal_templates.show_participant_ratings%TYPE,
85: show_participant_names per_appraisal_templates.show_participant_names%TYPE,
86: show_overall_ratings per_appraisal_templates.show_overall_ratings%TYPE,
87: disable_provide_feed per_appraisal_templates.provide_overall_feedback%TYPE, --Bug7393131
88: show_overall_comments per_appraisal_templates.show_overall_comments%TYPE
89: );

Line 86: show_overall_ratings per_appraisal_templates.show_overall_ratings%TYPE,

82: show_questionnaire_info per_appraisal_templates.show_questionnaire_info%TYPE,
83: show_participant_details per_appraisal_templates.show_participant_details%TYPE,
84: show_participant_ratings per_appraisal_templates.show_participant_ratings%TYPE,
85: show_participant_names per_appraisal_templates.show_participant_names%TYPE,
86: show_overall_ratings per_appraisal_templates.show_overall_ratings%TYPE,
87: disable_provide_feed per_appraisal_templates.provide_overall_feedback%TYPE, --Bug7393131
88: show_overall_comments per_appraisal_templates.show_overall_comments%TYPE
89: );
90:

Line 87: disable_provide_feed per_appraisal_templates.provide_overall_feedback%TYPE, --Bug7393131

83: show_participant_details per_appraisal_templates.show_participant_details%TYPE,
84: show_participant_ratings per_appraisal_templates.show_participant_ratings%TYPE,
85: show_participant_names per_appraisal_templates.show_participant_names%TYPE,
86: show_overall_ratings per_appraisal_templates.show_overall_ratings%TYPE,
87: disable_provide_feed per_appraisal_templates.provide_overall_feedback%TYPE, --Bug7393131
88: show_overall_comments per_appraisal_templates.show_overall_comments%TYPE
89: );
90:
91: TYPE assess_comps_info is RECORD (

Line 88: show_overall_comments per_appraisal_templates.show_overall_comments%TYPE

84: show_participant_ratings per_appraisal_templates.show_participant_ratings%TYPE,
85: show_participant_names per_appraisal_templates.show_participant_names%TYPE,
86: show_overall_ratings per_appraisal_templates.show_overall_ratings%TYPE,
87: disable_provide_feed per_appraisal_templates.provide_overall_feedback%TYPE, --Bug7393131
88: show_overall_comments per_appraisal_templates.show_overall_comments%TYPE
89: );
90:
91: TYPE assess_comps_info is RECORD (
92: competence_id per_competence_elements.competence_id%TYPE,

Line 768: p_appraisal_templ_id per_appraisal_templates.appraisal_template_id%TYPE,

764: -- {End Of Comments}
765: -- ----------------------------------------------------------------------------
766: PROCEDURE create_appraisal_for_person
767: ( p_score_card_id per_personal_scorecards.scorecard_id%TYPE,
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',

Line 839: FROM per_appraisal_templates

835: show_participant_names ,
836: show_overall_ratings ,
837: provide_overall_feedback, -- Bug7393131
838: show_overall_comments
839: FROM per_appraisal_templates
840: WHERE appraisal_template_id = p_appraisal_templ_id;
841:
842:
843: cursor get_assess_templ_comps(p_assess_type_id per_competence_elements.assessment_type_id%TYPE)

Line 867: cursor get_assess_templ_info (p_assess_templ per_appraisal_templates.assessment_type_id%TYPE)

863: select objective_id, scorecard_id, object_version_number, name from per_objectives
864: where scorecard_id = p_scorecard_id
865: and APPRAISE_FLAG = 'Y';
866:
867: cursor get_assess_templ_info (p_assess_templ per_appraisal_templates.assessment_type_id%TYPE)
868: IS
869: select DEFAULT_JOB_COMPETENCIES, ASSESSMENT_TYPE_ID from per_assessment_types
870: where ASSESSMENT_TYPE_ID = p_assess_templ;
871: