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 88: appraisal_template_id per_appraisal_templates.appraisal_template_id%TYPE,

84: --
85: -- Following is added with more details to be captured
86: -- done by tpapired for 115.20 version of this file
87: TYPE appraisal_templ_info IS RECORD (
88: appraisal_template_id per_appraisal_templates.appraisal_template_id%TYPE,
89: assessment_type_id per_appraisal_templates.assessment_type_id%TYPE,
90: objective_asmnt_type_id per_appraisal_templates.objective_asmnt_type_id%TYPE,
91: business_group_id per_appraisal_templates.business_group_id%TYPE,
92: show_competency_ratings per_appraisal_templates.show_competency_ratings%TYPE,

Line 89: assessment_type_id per_appraisal_templates.assessment_type_id%TYPE,

85: -- Following is added with more details to be captured
86: -- done by tpapired for 115.20 version of this file
87: TYPE appraisal_templ_info IS RECORD (
88: appraisal_template_id per_appraisal_templates.appraisal_template_id%TYPE,
89: assessment_type_id per_appraisal_templates.assessment_type_id%TYPE,
90: objective_asmnt_type_id per_appraisal_templates.objective_asmnt_type_id%TYPE,
91: business_group_id per_appraisal_templates.business_group_id%TYPE,
92: show_competency_ratings per_appraisal_templates.show_competency_ratings%TYPE,
93: show_objective_ratings per_appraisal_templates.show_objective_ratings%TYPE,

Line 90: objective_asmnt_type_id per_appraisal_templates.objective_asmnt_type_id%TYPE,

86: -- done by tpapired for 115.20 version of this file
87: TYPE appraisal_templ_info IS RECORD (
88: appraisal_template_id per_appraisal_templates.appraisal_template_id%TYPE,
89: assessment_type_id per_appraisal_templates.assessment_type_id%TYPE,
90: objective_asmnt_type_id per_appraisal_templates.objective_asmnt_type_id%TYPE,
91: business_group_id per_appraisal_templates.business_group_id%TYPE,
92: show_competency_ratings per_appraisal_templates.show_competency_ratings%TYPE,
93: show_objective_ratings per_appraisal_templates.show_objective_ratings%TYPE,
94: show_questionnaire_info per_appraisal_templates.show_questionnaire_info%TYPE,

Line 91: business_group_id per_appraisal_templates.business_group_id%TYPE,

87: TYPE appraisal_templ_info IS RECORD (
88: appraisal_template_id per_appraisal_templates.appraisal_template_id%TYPE,
89: assessment_type_id per_appraisal_templates.assessment_type_id%TYPE,
90: objective_asmnt_type_id per_appraisal_templates.objective_asmnt_type_id%TYPE,
91: business_group_id per_appraisal_templates.business_group_id%TYPE,
92: show_competency_ratings per_appraisal_templates.show_competency_ratings%TYPE,
93: show_objective_ratings per_appraisal_templates.show_objective_ratings%TYPE,
94: show_questionnaire_info per_appraisal_templates.show_questionnaire_info%TYPE,
95: show_participant_details per_appraisal_templates.show_participant_details%TYPE,

Line 92: show_competency_ratings per_appraisal_templates.show_competency_ratings%TYPE,

88: appraisal_template_id per_appraisal_templates.appraisal_template_id%TYPE,
89: assessment_type_id per_appraisal_templates.assessment_type_id%TYPE,
90: objective_asmnt_type_id per_appraisal_templates.objective_asmnt_type_id%TYPE,
91: business_group_id per_appraisal_templates.business_group_id%TYPE,
92: show_competency_ratings per_appraisal_templates.show_competency_ratings%TYPE,
93: show_objective_ratings per_appraisal_templates.show_objective_ratings%TYPE,
94: show_questionnaire_info per_appraisal_templates.show_questionnaire_info%TYPE,
95: show_participant_details per_appraisal_templates.show_participant_details%TYPE,
96: show_participant_ratings per_appraisal_templates.show_participant_ratings%TYPE,

Line 93: show_objective_ratings per_appraisal_templates.show_objective_ratings%TYPE,

89: assessment_type_id per_appraisal_templates.assessment_type_id%TYPE,
90: objective_asmnt_type_id per_appraisal_templates.objective_asmnt_type_id%TYPE,
91: business_group_id per_appraisal_templates.business_group_id%TYPE,
92: show_competency_ratings per_appraisal_templates.show_competency_ratings%TYPE,
93: show_objective_ratings per_appraisal_templates.show_objective_ratings%TYPE,
94: show_questionnaire_info per_appraisal_templates.show_questionnaire_info%TYPE,
95: show_participant_details per_appraisal_templates.show_participant_details%TYPE,
96: show_participant_ratings per_appraisal_templates.show_participant_ratings%TYPE,
97: show_participant_names per_appraisal_templates.show_participant_names%TYPE,

Line 94: show_questionnaire_info per_appraisal_templates.show_questionnaire_info%TYPE,

90: objective_asmnt_type_id per_appraisal_templates.objective_asmnt_type_id%TYPE,
91: business_group_id per_appraisal_templates.business_group_id%TYPE,
92: show_competency_ratings per_appraisal_templates.show_competency_ratings%TYPE,
93: show_objective_ratings per_appraisal_templates.show_objective_ratings%TYPE,
94: show_questionnaire_info per_appraisal_templates.show_questionnaire_info%TYPE,
95: show_participant_details per_appraisal_templates.show_participant_details%TYPE,
96: show_participant_ratings per_appraisal_templates.show_participant_ratings%TYPE,
97: show_participant_names per_appraisal_templates.show_participant_names%TYPE,
98: show_overall_ratings per_appraisal_templates.show_overall_ratings%TYPE,

Line 95: show_participant_details per_appraisal_templates.show_participant_details%TYPE,

91: business_group_id per_appraisal_templates.business_group_id%TYPE,
92: show_competency_ratings per_appraisal_templates.show_competency_ratings%TYPE,
93: show_objective_ratings per_appraisal_templates.show_objective_ratings%TYPE,
94: show_questionnaire_info per_appraisal_templates.show_questionnaire_info%TYPE,
95: show_participant_details per_appraisal_templates.show_participant_details%TYPE,
96: show_participant_ratings per_appraisal_templates.show_participant_ratings%TYPE,
97: show_participant_names per_appraisal_templates.show_participant_names%TYPE,
98: show_overall_ratings per_appraisal_templates.show_overall_ratings%TYPE,
99: disable_provide_feed per_appraisal_templates.provide_overall_feedback%TYPE,

Line 96: show_participant_ratings per_appraisal_templates.show_participant_ratings%TYPE,

92: show_competency_ratings per_appraisal_templates.show_competency_ratings%TYPE,
93: show_objective_ratings per_appraisal_templates.show_objective_ratings%TYPE,
94: show_questionnaire_info per_appraisal_templates.show_questionnaire_info%TYPE,
95: show_participant_details per_appraisal_templates.show_participant_details%TYPE,
96: show_participant_ratings per_appraisal_templates.show_participant_ratings%TYPE,
97: show_participant_names per_appraisal_templates.show_participant_names%TYPE,
98: show_overall_ratings per_appraisal_templates.show_overall_ratings%TYPE,
99: disable_provide_feed per_appraisal_templates.provide_overall_feedback%TYPE,
100: --Bug7393131

Line 97: show_participant_names per_appraisal_templates.show_participant_names%TYPE,

93: show_objective_ratings per_appraisal_templates.show_objective_ratings%TYPE,
94: show_questionnaire_info per_appraisal_templates.show_questionnaire_info%TYPE,
95: show_participant_details per_appraisal_templates.show_participant_details%TYPE,
96: show_participant_ratings per_appraisal_templates.show_participant_ratings%TYPE,
97: show_participant_names per_appraisal_templates.show_participant_names%TYPE,
98: show_overall_ratings per_appraisal_templates.show_overall_ratings%TYPE,
99: disable_provide_feed per_appraisal_templates.provide_overall_feedback%TYPE,
100: --Bug7393131
101: show_overall_comments per_appraisal_templates.show_overall_comments%TYPE

Line 98: show_overall_ratings per_appraisal_templates.show_overall_ratings%TYPE,

94: show_questionnaire_info per_appraisal_templates.show_questionnaire_info%TYPE,
95: show_participant_details per_appraisal_templates.show_participant_details%TYPE,
96: show_participant_ratings per_appraisal_templates.show_participant_ratings%TYPE,
97: show_participant_names per_appraisal_templates.show_participant_names%TYPE,
98: show_overall_ratings per_appraisal_templates.show_overall_ratings%TYPE,
99: disable_provide_feed per_appraisal_templates.provide_overall_feedback%TYPE,
100: --Bug7393131
101: show_overall_comments per_appraisal_templates.show_overall_comments%TYPE
102: );

Line 99: disable_provide_feed per_appraisal_templates.provide_overall_feedback%TYPE,

95: show_participant_details per_appraisal_templates.show_participant_details%TYPE,
96: show_participant_ratings per_appraisal_templates.show_participant_ratings%TYPE,
97: show_participant_names per_appraisal_templates.show_participant_names%TYPE,
98: show_overall_ratings per_appraisal_templates.show_overall_ratings%TYPE,
99: disable_provide_feed per_appraisal_templates.provide_overall_feedback%TYPE,
100: --Bug7393131
101: show_overall_comments per_appraisal_templates.show_overall_comments%TYPE
102: );
103:

Line 101: show_overall_comments per_appraisal_templates.show_overall_comments%TYPE

97: show_participant_names per_appraisal_templates.show_participant_names%TYPE,
98: show_overall_ratings per_appraisal_templates.show_overall_ratings%TYPE,
99: disable_provide_feed per_appraisal_templates.provide_overall_feedback%TYPE,
100: --Bug7393131
101: show_overall_comments per_appraisal_templates.show_overall_comments%TYPE
102: );
103:
104: TYPE assess_comps_info IS RECORD (
105: competence_id per_competence_elements.competence_id%TYPE,

Line 1022: p_appraisal_templ_id per_appraisal_templates.appraisal_template_id%TYPE,

1018: -- {End Of Comments}
1019: -- ----------------------------------------------------------------------------
1020: PROCEDURE create_appraisal_for_person (
1021: p_score_card_id per_personal_scorecards.scorecard_id%TYPE,
1022: p_appraisal_templ_id per_appraisal_templates.appraisal_template_id%TYPE,
1023: p_effective_date DATE,
1024: p_appraisal_start_date DATE,
1025: p_appraisal_end_date DATE,
1026: p_appraisal_status per_appraisals.status%TYPE

Line 1132: FROM per_appraisal_templates

1128: show_overall_ratings, provide_overall_feedback,
1129:
1130: -- Bug7393131
1131: show_overall_comments
1132: FROM per_appraisal_templates
1133: WHERE appraisal_template_id = p_appraisal_templ_id;
1134:
1135: CURSOR get_assess_templ_comps (
1136: p_assess_type_id per_competence_elements.assessment_type_id%TYPE

Line 1172: p_assess_templ per_appraisal_templates.assessment_type_id%TYPE

1168: AND appraise_flag = 'Y'
1169: AND appraisal_id IS NULL;
1170:
1171: CURSOR get_assess_templ_info (
1172: p_assess_templ per_appraisal_templates.assessment_type_id%TYPE
1173: )
1174: IS
1175: SELECT default_job_competencies, assessment_type_id
1176: FROM per_assessment_types