APPS.CS_SR_MASS_UPDATE_PKG SQL Statements

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

Line: 24

  l_last_update_date            DATE := SYSDATE;

Line: 33

  l_sr_update_out_rec          CS_ServiceRequest_PVT.sr_update_out_rec_type;

Line: 43

	/*Trap the error message for SRs which are closed and have the Disallow SR Update
	  Check box as checked bug 8726256*/
	FND_MESSAGE.Set_Name('CS','CS_API_SR_ONLY_STATUS_UPDATED');

Line: 65

	 Select nvl(fnd_profile.value('CS_AUTO_ASSIGN_OWNER_FORMS'), 'N')
	 Into l_cs_auto_assignment From dual;

Line: 115

	 select fnd_global.resp_id into l_responsibility_id from dual;

Line: 132

			select OBJECT_VERSION_NUMBER
			into   l_object_version_number
			from   CS_INCIDENTS_ALL_B
			where  INCIDENT_ID = p_incident_id_arr(i);

Line: 137

		  CS_SERVICEREQUEST_PVT.UPDATE_SERVICEREQUEST(
		    p_api_version => 4.0,
		    p_init_msg_list => fnd_api.g_true,
		    p_resp_id => l_responsibility_id,
		    p_commit => fnd_api.g_true,
		    p_validation_level         => 100,
		    p_request_id => p_incident_id_arr(i),
		    p_object_version_number => l_object_version_number,
		    p_last_updated_by => p_last_updated_by,
		    p_last_update_date => l_last_update_date,
		    p_service_request_rec => l_sr_rec,
		    p_notes => l_notes_table,
		    p_contacts => l_contacts_table,
		    p_validate_sr_closure => l_validate_sr_closure,
		    p_auto_close_child_entities => l_auto_close_child_entities,
		    x_msg_count => x_msg_count,
		    p_auto_assign =>p_auto_assign,
		    x_return_status => x_return_status,
		    x_msg_data => x_msg_data,
		    x_sr_update_out_rec => l_sr_update_out_rec);

Line: 165

			/*Trap the error message for SRs which are closed and have the Disallow SR Update
			  Check box as checked bug 8726256*/
			if (l_status_msg=substr(l_data,instr(l_data,':')+1) and p_status_id is null) then
				x_return_status:='E';

Line: 192

end sr_mass_update;