The following lines contain the word 'select', 'insert', 'update' or 'delete':
update service request */
/*
PROCEDURE Update_ServiceRequest_Pre
( p_request_id IN NUMBER,
p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
x_return_status OUT NOCOPY VARCHAR2
); */
PROCEDURE Update_ServiceRequest_Pre
( p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
p_commit IN VARCHAR2 ,
p_validation_level IN NUMBER ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_request_id IN NUMBER,
p_object_version_number IN NUMBER,
p_resp_appl_id IN NUMBER ,
p_resp_id IN NUMBER ,
p_last_updated_by IN NUMBER,
p_last_update_login IN NUMBER ,
p_last_update_date IN DATE,
p_invocation_mode IN VARCHAR2 := 'NORMAL',
p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
p_update_desc_flex IN VARCHAR2 ,
p_notes IN CS_ServiceRequest_PVT.notes_table,
p_contacts IN CS_ServiceRequest_PVT.contacts_table,
p_audit_comments IN VARCHAR2 ,
p_called_by_workflow IN VARCHAR2 ,
p_workflow_process_id IN NUMBER ,
x_workflow_process_id OUT NOCOPY NUMBER,
x_interaction_id OUT NOCOPY NUMBER
) IS
l_action_type VARCHAR2(15) := 'UPDATE';
l_api_name VARCHAR2(30) := 'Update_ServiceRequest_Post';
IBU_SR_CUHK.Update_ServiceRequest_Pre(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
p_validation_level => fnd_api.g_valid_level_full,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_request_id => p_request_id,
p_object_version_number => p_object_version_number,
p_resp_appl_id => p_resp_appl_id,
p_resp_id => p_resp_id,
p_last_updated_by => p_last_updated_by,
p_last_update_login => p_last_update_login,
p_last_update_date => p_last_update_date,
p_invocation_mode => p_invocation_mode,
p_service_request_rec => p_service_request_rec,
p_update_desc_flex => p_update_desc_flex,
p_notes => p_notes,
p_contacts => p_contacts,
p_audit_comments => p_audit_comments,
p_called_by_workflow => p_called_by_workflow,
p_workflow_process_id => p_workflow_process_id,
x_workflow_process_id => x_workflow_process_id,
x_interaction_id => x_interaction_id
);
CS_GIT_USERHOOK_PKG.GIT_Update_ServiceRequest_Pre(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
p_validation_level => FND_API.G_VALID_LEVEL_FULL,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_sr_rec => p_service_request_rec,
p_incident_id => p_request_id,
p_invocation_mode => p_invocation_mode
);
/*CS_OSS_USERHOOK_PKG.OSS_Update_ServiceRequest_Pre(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
p_validation_level => FND_API.G_VALID_LEVEL_FULL,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_service_request_rec => p_service_request_rec
);
update service request */
/*
PROCEDURE Update_ServiceRequest_Post
( p_request_id IN NUMBER,
p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
x_return_status OUT NOCOPY VARCHAR2); */
PROCEDURE Update_ServiceRequest_Post
( p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
p_commit IN VARCHAR2 ,
p_validation_level IN NUMBER ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_request_id IN NUMBER,
p_object_version_number IN NUMBER,
p_resp_appl_id IN NUMBER ,
p_resp_id IN NUMBER ,
p_last_updated_by IN NUMBER,
p_last_update_login IN NUMBER ,
p_last_update_date IN DATE,
p_invocation_mode IN VARCHAR2 := 'NORMAL',
p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
p_update_desc_flex IN VARCHAR2 ,
p_notes IN CS_ServiceRequest_PVT.notes_table,
p_contacts IN CS_ServiceRequest_PVT.contacts_table,
p_audit_comments IN VARCHAR2 ,
p_called_by_workflow IN VARCHAR2 ,
p_workflow_process_id IN NUMBER ,
x_workflow_process_id OUT NOCOPY NUMBER,
x_interaction_id OUT NOCOPY NUMBER
) IS
l_action_type VARCHAR2(15) := 'UPDATE';
l_api_name VARCHAR2(30) := 'Update_ServiceRequest_Post';
IBU_SR_CUHK.Update_ServiceRequest_Post(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
p_validation_level => fnd_api.g_valid_level_full,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_request_id => p_request_id,
p_object_version_number => p_object_version_number,
p_resp_appl_id => p_resp_appl_id,
p_resp_id => p_resp_id,
p_last_updated_by => p_last_updated_by,
p_last_update_login => p_last_update_login,
p_last_update_date => p_last_update_date,
p_invocation_mode => p_invocation_mode,
p_service_request_rec => p_service_request_rec,
p_update_desc_flex => p_update_desc_flex,
p_notes => p_notes,
p_contacts => p_contacts,
p_audit_comments => p_audit_comments,
p_called_by_workflow => p_called_by_workflow,
p_workflow_process_id => p_workflow_process_id,
x_workflow_process_id => x_workflow_process_id,
x_interaction_id => x_interaction_id
);
CS_GIT_USERHOOK_PKG.GIT_Update_ServiceRequest_Post(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
p_validation_level => FND_API.G_VALID_LEVEL_FULL,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_sr_rec => p_service_request_rec,
p_incident_id => p_request_id,
p_invocation_mode => p_invocation_mode
);