APPS.CS_SERVICEREQUEST_CUHK SQL Statements

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

Line: 245

	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
		); */

Line: 255

   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';

Line: 286

    l_api_name          VARCHAR2(30) := 'Update_ServiceRequest_Post';

Line: 296

     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
          );

Line: 328

      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
          );

Line: 347

     /*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
        );

Line: 385

	 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);  */

Line: 396

   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';

Line: 425

    l_api_name          VARCHAR2(30) := 'Update_ServiceRequest_Post';

Line: 433

     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
          );

Line: 464

      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
          );