The following lines contain the word 'select', 'insert', 'update' or 'delete':
,p_update_appraisal in varchar2 default null
,p_provide_overall_feedback in varchar2 default null
,p_appraisee_comments in varchar2 default null
,p_offline_status in varchar2 default null
,p_retention_potential in varchar2 default null
,p_show_participant_comments in varchar2 default null -- 8651478 bug fix
) is
--
-- Variables for API Boolean parameters
l_validate boolean;
,p_update_appraisal => p_update_appraisal
,p_provide_overall_feedback => p_provide_overall_feedback
,p_appraisee_comments => p_appraisee_comments
,p_offline_status => p_offline_status
,p_retention_potential => p_retention_potential
,p_show_participant_comments => p_show_participant_comments -- 8651478 bug fix
);
PROCEDURE delete_appraisal
(p_validate in number default hr_api.g_false_num
,p_appraisal_id in number
,p_object_version_number in number
,p_return_status out nocopy varchar2
) is
--
-- Variables for API Boolean parameters
l_validate boolean;
l_proc varchar2(72) := g_package ||'delete_appraisal';
select appraisal_system_status
from per_appraisals
where appraisal_id= p_appraisal_id ;
savepoint delete_appraisal_swi;
hr_appraisals_api.delete_appraisal
(p_validate => l_validate
,p_appraisal_id => p_appraisal_id
,p_object_version_number => p_object_version_number
);
update_appraisal
(
p_validate => p_validate
,p_effective_date => sysdate
,p_appraisal_id => p_appraisal_id
,p_object_version_number => l_ovn
,p_appraisal_system_status => 'DELETED'
,p_return_status => p_return_status
);
rollback to delete_appraisal_swi;
rollback to delete_appraisal_swi;
end delete_appraisal;
PROCEDURE update_appraisal
(p_validate in number default hr_api.g_false_num
,p_effective_date in date
,p_appraisal_id in number
,p_object_version_number in out nocopy number
,p_appraiser_person_id in number default hr_api.g_number
,p_appraisal_date in date default hr_api.g_date
,p_appraisal_period_end_date in date default hr_api.g_date
,p_appraisal_period_start_date in date default hr_api.g_date
,p_type in varchar2 default hr_api.g_varchar2
,p_next_appraisal_date in date default hr_api.g_date
,p_status in varchar2 default hr_api.g_varchar2
,p_comments in varchar2 default hr_api.g_varchar2
,p_overall_performance_level_id in number default hr_api.g_number
,p_open in varchar2 default hr_api.g_varchar2
,p_attribute_category in varchar2 default hr_api.g_varchar2
,p_attribute1 in varchar2 default hr_api.g_varchar2
,p_attribute2 in varchar2 default hr_api.g_varchar2
,p_attribute3 in varchar2 default hr_api.g_varchar2
,p_attribute4 in varchar2 default hr_api.g_varchar2
,p_attribute5 in varchar2 default hr_api.g_varchar2
,p_attribute6 in varchar2 default hr_api.g_varchar2
,p_attribute7 in varchar2 default hr_api.g_varchar2
,p_attribute8 in varchar2 default hr_api.g_varchar2
,p_attribute9 in varchar2 default hr_api.g_varchar2
,p_attribute10 in varchar2 default hr_api.g_varchar2
,p_attribute11 in varchar2 default hr_api.g_varchar2
,p_attribute12 in varchar2 default hr_api.g_varchar2
,p_attribute13 in varchar2 default hr_api.g_varchar2
,p_attribute14 in varchar2 default hr_api.g_varchar2
,p_attribute15 in varchar2 default hr_api.g_varchar2
,p_attribute16 in varchar2 default hr_api.g_varchar2
,p_attribute17 in varchar2 default hr_api.g_varchar2
,p_attribute18 in varchar2 default hr_api.g_varchar2
,p_attribute19 in varchar2 default hr_api.g_varchar2
,p_attribute20 in varchar2 default hr_api.g_varchar2
,p_system_type in varchar2 default hr_api.g_varchar2
,p_system_params in varchar2 default hr_api.g_varchar2
,p_appraisee_access in varchar2 default hr_api.g_varchar2
,p_main_appraiser_id in number default hr_api.g_number
,p_assignment_id in number default hr_api.g_number
,p_assignment_start_date in date default hr_api.g_date
,p_asg_business_group_id in number default hr_api.g_number
,p_assignment_organization_id in number default hr_api.g_number
,p_assignment_job_id in number default hr_api.g_number
,p_assignment_position_id in number default hr_api.g_number
,p_assignment_grade_id in number default hr_api.g_number
,p_return_status out nocopy varchar2
,p_appraisal_system_status in varchar2 default hr_api.g_varchar2
,p_potential_readiness_level in varchar2 default hr_api.g_varchar2
,p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2
,p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2
,p_potential_details in varchar2 default hr_api.g_varchar2
,p_event_id in number default hr_api.g_number
,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
,p_show_participant_details in varchar2 default hr_api.g_varchar2
,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
,p_show_participant_names in varchar2 default hr_api.g_varchar2
,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
,p_show_overall_comments in varchar2 default hr_api.g_varchar2
,p_update_appraisal in varchar2 default hr_api.g_varchar2
,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
,p_appraisee_comments in varchar2 default hr_api.g_varchar2
,p_offline_status in varchar2 default hr_api.g_varchar2
,p_retention_potential in varchar2 default hr_api.g_varchar2
,p_show_participant_comments in varchar2 default hr_api.g_varchar2 -- 8651478 bug fix
) is
--
-- Variables for API Boolean parameters
l_validate boolean;
l_proc varchar2(72) := g_package ||'update_appraisal';
savepoint update_appraisal_swi;
hr_appraisals_api.update_appraisal
(p_validate => l_validate
,p_effective_date => p_effective_date
,p_appraisal_id => p_appraisal_id
,p_object_version_number => p_object_version_number
,p_appraiser_person_id => p_appraiser_person_id
,p_appraisal_date => p_appraisal_date
,p_appraisal_period_end_date => p_appraisal_period_end_date
,p_appraisal_period_start_date => p_appraisal_period_start_date
,p_type => p_type
,p_next_appraisal_date => p_next_appraisal_date
,p_status => p_status
,p_comments => p_comments
,p_overall_performance_level_id => p_overall_performance_level_id
,p_open => p_open
,p_attribute_category => p_attribute_category
,p_attribute1 => p_attribute1
,p_attribute2 => p_attribute2
,p_attribute3 => p_attribute3
,p_attribute4 => p_attribute4
,p_attribute5 => p_attribute5
,p_attribute6 => p_attribute6
,p_attribute7 => p_attribute7
,p_attribute8 => p_attribute8
,p_attribute9 => p_attribute9
,p_attribute10 => p_attribute10
,p_attribute11 => p_attribute11
,p_attribute12 => p_attribute12
,p_attribute13 => p_attribute13
,p_attribute14 => p_attribute14
,p_attribute15 => p_attribute15
,p_attribute16 => p_attribute16
,p_attribute17 => p_attribute17
,p_attribute18 => p_attribute18
,p_attribute19 => p_attribute19
,p_attribute20 => p_attribute20
,p_system_type => p_system_type
,p_system_params => p_system_params
,p_appraisee_access => p_appraisee_access
,p_main_appraiser_id => p_main_appraiser_id
,p_assignment_id => p_assignment_id
,p_assignment_start_date => p_assignment_start_date
,p_asg_business_group_id => p_asg_business_group_id
,p_assignment_organization_id => p_assignment_organization_id
,p_assignment_job_id => p_assignment_job_id
,p_assignment_position_id => p_assignment_position_id
,p_assignment_grade_id => p_assignment_grade_id
,p_appraisal_system_status => p_appraisal_system_status
,p_potential_readiness_level => p_potential_readiness_level
,p_potential_short_term_workopp => p_potential_short_term_workopp
,p_potential_long_term_workopp => p_potential_long_term_workopp
,p_potential_details => p_potential_details
,p_event_id => p_event_id
,p_show_competency_ratings => p_show_competency_ratings
,p_show_objective_ratings => p_show_objective_ratings
,p_show_questionnaire_info => p_show_questionnaire_info
,p_show_participant_details => p_show_participant_details
,p_show_participant_ratings => p_show_participant_ratings
,p_show_participant_names => p_show_participant_names
,p_show_overall_ratings => p_show_overall_ratings
,p_show_overall_comments => p_show_overall_comments
,p_update_appraisal => p_update_appraisal
,p_provide_overall_feedback => p_provide_overall_feedback
,p_appraisee_comments => p_appraisee_comments
,p_offline_status => p_offline_status
,p_retention_potential => p_retention_potential
,p_show_participant_comments => p_show_participant_comments -- 8651478 bug fix
);
rollback to update_appraisal_swi;
rollback to update_appraisal_swi;
end update_appraisal;
,p_group_date => hr_transaction_swi.getDateValue(l_CommitNode,'GroupDate',null)
,p_group_initiator_id => hr_transaction_swi.getNumberValue(l_CommitNode,'GroupInitiatorId',null)
,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
,p_overall_performance_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OverallPerformanceLevelId',null)
,p_open => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Open',null)
,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
,p_system_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SystemType',null)
,p_system_params => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SystemParams',null)
,p_appraisee_access => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseeAccess',null)
,p_main_appraiser_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MainAppraiserId',null)
,p_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentId',null)
,p_assignment_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'AssignmentStartDate',null)
,p_asg_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AsgBusinessGroupId',null)
,p_assignment_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentOrganizationId',null)
,p_assignment_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentJobId',null)
,p_assignment_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentPositionId',null)
,p_assignment_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentGradeId',null)
,p_appraisal_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraisalId',null)
,p_object_version_number => l_object_version_number
,p_return_status => l_return_status
,p_appraisal_system_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraisalSystemStatus',null)
,p_potential_readiness_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialReadinessLevel',null)
,p_potential_short_term_workopp => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialShortTermWorkopp',null)
,p_potential_long_term_workopp => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialLongTermWorkopp',null)
,p_potential_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialDetails',null)
,p_event_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EventId',null)
,p_show_competency_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowCompetencyRatings',null)
,p_show_objective_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowObjectiveRatings',null)
,p_show_questionnaire_info => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowQuestionnaireInfo',null)
,p_show_participant_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantDetails',null)
,p_show_participant_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantRatings',null)
,p_show_participant_names => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantNames',null)
,p_show_overall_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowOverallRatings',null)
,p_show_overall_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowOverallComments',null)
,p_update_appraisal => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UpdateAppraisal',null)
,p_provide_overall_feedback => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProvideOverallFeedback',null)
,p_appraisee_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseeComments',null)
,p_retention_potential => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RetentionPotential',null)
,p_show_participant_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantComments',null) -- 8651478 bug fix
);
update_appraisal
( p_validate => p_validate
,p_effective_date => p_effective_date
,p_appraisal_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraisalId')
,p_object_version_number => l_object_version_number
,p_appraiser_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraiserPersonId')
,p_appraisal_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalDate')
,p_appraisal_period_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalPeriodEndDate')
,p_appraisal_period_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalPeriodStartDate')
,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type')
,p_next_appraisal_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextAppraisalDate')
,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status')
,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
,p_overall_performance_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OverallPerformanceLevelId')
,p_open => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Open')
,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
,p_system_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SystemType')
,p_system_params => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SystemParams')
,p_appraisee_access => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseeAccess')
,p_main_appraiser_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MainAppraiserId')
,p_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentId')
,p_assignment_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'AssignmentStartDate')
,p_asg_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AsgBusinessGroupId')
,p_assignment_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentOrganizationId')
,p_assignment_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentJobId')
,p_assignment_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentPositionId')
,p_assignment_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentGradeId')
,p_return_status => l_return_status
,p_appraisal_system_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraisalSystemStatus')
,p_potential_readiness_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialReadinessLevel')
,p_potential_short_term_workopp => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialShortTermWorkopp')
,p_potential_long_term_workopp => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialLongTermWorkopp')
,p_potential_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialDetails')
,p_event_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EventId')
,p_show_competency_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowCompetencyRatings')
,p_show_objective_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowObjectiveRatings')
,p_show_questionnaire_info => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowQuestionnaireInfo')
,p_show_participant_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantDetails')
,p_show_participant_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantRatings')
,p_show_participant_names => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantNames')
,p_show_overall_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowOverallRatings')
,p_show_overall_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowOverallComments')
,p_update_appraisal => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UpdateAppraisal')
,p_provide_overall_feedback => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProvideOverallFeedback')
,p_appraisee_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseeComments')
,p_retention_potential => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RetentionPotential')
,p_show_participant_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantComments') -- 8651478 bug fix
);
delete_appraisal
( p_validate => p_validate
,p_appraisal_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraisalId')
,p_object_version_number => l_object_version_number
,p_return_status => l_return_status
);