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_APPRAISAL_TEMPLATES_BK1 SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 43


,P_UPDATE_PERSONAL_COMP_PROFILE in VARCHAR2
,P_COMP_PROFILE_SOURCE_TYPE in VARCHAR2
,P_SHOW_COMPETENCY_RATINGS in VARCHAR2
,P_SHOW_OBJECTIVE_RATINGS in VARCHAR2
,P_SHOW_OVERALL_RATINGS in VARCHAR2
,P_SHOW_OVERALL_COMMENTS in VARCHAR2
,P_PROVIDE_OVERALL_FEEDBACK in VARCHAR2
,P_SHOW_PARTICIPANT_DETAILS in VARCHAR2
,P_ALLOW_ADD_PARTICIPANT in VARCHAR2
,P_SHOW_ADDITIONAL_DETAILS in VARCHAR2
,P_SHOW_PARTICIPANT_NAMES in VARCHAR2
,P_SHOW_PARTICIPANT_RATINGS in VARCHAR2
,P_AVAILABLE_FLAG in VARCHAR2
,P_SHOW_QUESTIONNAIRE_INFO in VARCHAR2
,P_MA_OFF_TEMPLATE_CODE in VARCHAR2
,P_APPRAISEE_OFF_TEMPLATE_CODE in VARCHAR2
,P_OTHER_PART_OFF_TEMPLATE_CODE in VARCHAR2
,P_PART_APP_OFF_TEMPLATE_CODE in VARCHAR2
,P_PART_REV_OFF_TEMPLATE_CODE in VARCHAR2
,P_SHOW_PARTICIPANT_COMMENTS in VARCHAR2
,P_SHOW_TERM_EMPLOYEE in VARCHAR2
,P_SHOW_TERM_CONTIGENT in VARCHAR2
,P_DISP_TERM_EMP_PERIOD_FROM in NUMBER
,P_SHOW_FUTURE_TERM_EMPLOYEE in VARCHAR2
)is
begin
hr_utility.set_location('Entering: HR_APPRAISAL_TEMPLATES_BK1.CREATE_APPRAISAL_TEMPLATE_A', 10);

Line: 108


,P_UPDATE_PERSONAL_COMP_PROFILE in VARCHAR2
,P_COMP_PROFILE_SOURCE_TYPE in VARCHAR2
,P_SHOW_COMPETENCY_RATINGS in VARCHAR2
,P_SHOW_OBJECTIVE_RATINGS in VARCHAR2
,P_SHOW_OVERALL_RATINGS in VARCHAR2
,P_SHOW_OVERALL_COMMENTS in VARCHAR2
,P_PROVIDE_OVERALL_FEEDBACK in VARCHAR2
,P_SHOW_PARTICIPANT_DETAILS in VARCHAR2
,P_ALLOW_ADD_PARTICIPANT in VARCHAR2
,P_SHOW_ADDITIONAL_DETAILS in VARCHAR2
,P_SHOW_PARTICIPANT_NAMES in VARCHAR2
,P_SHOW_PARTICIPANT_RATINGS in VARCHAR2
,P_AVAILABLE_FLAG in VARCHAR2
,P_SHOW_QUESTIONNAIRE_INFO in VARCHAR2
,P_MA_OFF_TEMPLATE_CODE in VARCHAR2
,P_APPRAISEE_OFF_TEMPLATE_CODE in VARCHAR2
,P_OTHER_PART_OFF_TEMPLATE_CODE in VARCHAR2
,P_PART_APP_OFF_TEMPLATE_CODE in VARCHAR2
,P_PART_REV_OFF_TEMPLATE_CODE in VARCHAR2
,P_SHOW_PARTICIPANT_COMMENTS in VARCHAR2
,P_SHOW_TERM_EMPLOYEE in VARCHAR2
,P_SHOW_TERM_CONTIGENT in VARCHAR2
,P_DISP_TERM_EMP_PERIOD_FROM in NUMBER
,P_SHOW_FUTURE_TERM_EMPLOYEE in VARCHAR2
)is
begin
hr_utility.set_location('Entering: HR_APPRAISAL_TEMPLATES_BK1.CREATE_APPRAISAL_TEMPLATE_B', 10);