APPS.CS_SERVICEREQUEST_PUB SQL Statements

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

Line: 200

  p_sr_record.last_update_channel        := FND_API.G_MISS_CHAR;

Line: 234

  p_sr_record.last_update_program_code   := FND_API.G_MISS_CHAR;  -- ER source

Line: 1058

  select maintenance_flag into l_maintenance_flag
   from cs_incident_types_b where incident_type_id = p_request_rec.type_id
                                  and incident_subtype=G_SR_SUBTYPE;

Line: 1282

   *  Dynamic Inserts Possible	: No				*
   *  Unique ID Column		: INVENTORY_ITEM_ID		*
   *  Structure Column		: ORGANIZATION_ID		*
   * The System Items Flexfield supports only one structure	*
   * (default value is 101). AOL stores the set number in the	*
   * structure defining column instead of the structure number,	*
   * that's why the inventory org ID must be passed.		*
   **************************************************************/
  IF ((l_service_request_rec.inventory_item_segment1 <> FND_API.G_MISS_CHAR) OR
      (l_service_request_rec.inventory_item_segment1 IS NULL)) THEN
    i := i + 1;

Line: 1772

  l_request_rec.last_update_channel         := l_service_request_rec.last_update_channel;

Line: 2148

PROCEDURE Update_ServiceRequest
(
  p_api_version            IN     NUMBER,
  p_init_msg_list          IN     VARCHAR2      := FND_API.G_FALSE,
  p_commit                 IN     VARCHAR2      := FND_API.G_FALSE,
  x_return_status          OUT    NOCOPY VARCHAR2,
  x_msg_count              OUT    NOCOPY NUMBER,
  x_msg_data               OUT    NOCOPY VARCHAR2,
  p_request_id             IN     NUMBER        := NULL,
  p_request_number         IN     VARCHAR2      := NULL,
  p_audit_comments         IN     VARCHAR2      := NULL,
  p_object_version_number  IN     NUMBER,
  p_resp_appl_id           IN     NUMBER        := NULL,
  p_resp_id                IN     NUMBER        := NULL,
  p_last_updated_by        IN     NUMBER,
  p_last_update_login      IN     NUMBER         :=NULL,
  p_last_update_date       IN     DATE,
  p_service_request_rec    IN     service_request_rec_type,
  p_notes                  IN     notes_table,
  p_contacts               IN     contacts_table,
  p_called_by_workflow     IN     VARCHAR2      := FND_API.G_FALSE,
  p_workflow_process_id    IN     NUMBER        := NULL,
  p_default_contract_sla_ind    IN      VARCHAR2 Default 'N',
  x_workflow_process_id    OUT    NOCOPY NUMBER,
  x_interaction_id         OUT    NOCOPY NUMBER
)
IS

  l_api_version	       CONSTANT	NUMBER		:= 3.0;

Line: 2178

  l_api_name	       CONSTANT	VARCHAR2(30)	:= 'Update_ServiceRequest';

Line: 2184

  l_sr_update_out_rec		sr_update_out_rec_type;

Line: 2189

  SAVEPOINT Update_ServiceRequest_PUB;

Line: 2213

  CS_ServiceRequest_PUB.Update_ServiceRequest
    ( p_api_version           => 4.0,
      p_init_msg_list	      => FND_API.G_FALSE,
      p_commit		      => p_commit,
      x_return_status	      => x_return_status,
      x_msg_count	      => x_msg_count,
      x_msg_data	      => x_msg_data,
      p_request_id	      => p_request_id,
      p_request_number	      => p_request_number,
      p_audit_comments	      => p_audit_comments,
      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_service_request_rec   => p_service_request_rec,
      p_notes                 => p_notes,
      p_contacts              => p_contacts,
      p_called_by_workflow    => p_called_by_workflow,
      p_workflow_process_id   => p_workflow_process_id,
      p_auto_assign	      => 'N',
      p_validate_sr_closure   => 'N',
      p_auto_close_child_entities => 'N',
      p_default_contract_sla_ind  => p_default_contract_sla_ind,
      x_sr_update_out_rec     => l_sr_update_out_rec
    );

Line: 2242

  x_workflow_process_id		:= l_sr_update_out_rec.workflow_process_id;

Line: 2243

  x_interaction_id		:= l_sr_update_out_rec.interaction_id;

Line: 2264

    ROLLBACK TO Update_ServiceRequest_PUB;

Line: 2271

    ROLLBACK TO Update_ServiceRequest_PUB;

Line: 2278

    ROLLBACK TO Update_ServiceRequest_PUB;

Line: 2288

END Update_ServiceRequest;

Line: 2305

PROCEDURE Update_ServiceRequest
(
  p_api_version            IN     NUMBER,
  p_init_msg_list          IN     VARCHAR2      := FND_API.G_FALSE,
  p_commit                 IN     VARCHAR2      := FND_API.G_FALSE,
  x_return_status          OUT    NOCOPY VARCHAR2,
  x_msg_count              OUT    NOCOPY NUMBER,
  x_msg_data               OUT    NOCOPY VARCHAR2,
  p_request_id             IN     NUMBER        := NULL,
  p_request_number         IN     VARCHAR2      := NULL,
  p_audit_comments         IN     VARCHAR2      := NULL,
  p_object_version_number  IN     NUMBER,
  p_resp_appl_id           IN     NUMBER        := NULL,
  p_resp_id                IN     NUMBER        := NULL,
  p_last_updated_by        IN     NUMBER,
  p_last_update_login      IN     NUMBER         :=NULL,
  p_last_update_date       IN     DATE,
  p_service_request_rec    IN     service_request_rec_type,
  p_notes                  IN     notes_table,
  p_contacts               IN     contacts_table,
  p_called_by_workflow     IN     VARCHAR2      := FND_API.G_FALSE,
  p_workflow_process_id    IN     NUMBER        := NULL,
  -- Commented out since these are now part of the out rec type --anmukher--08/08/03
  -- x_workflow_process_id    	OUT NOCOPY NUMBER,
  -- x_interaction_id         	OUT NOCOPY NUMBER,
  ----------------anmukher--------------------08/08/03
  -- Added for 11.5.10 projects
  p_auto_assign		    	IN	VARCHAR2 Default 'N',
  p_validate_sr_closure	    	IN	VARCHAR2 Default 'N',
  p_auto_close_child_entities	IN	VARCHAR2 Default 'N',
  p_default_contract_sla_ind    IN      VARCHAR2 Default 'N',
  x_sr_update_out_rec		OUT NOCOPY	sr_update_out_rec_type
)
IS

-- changed the version from 3.0 to 4.0 anmukher aug 08 2003

  l_api_version	       CONSTANT	NUMBER		:= 4.0;

Line: 2344

  l_api_name	       CONSTANT	VARCHAR2(30)	:= 'Update_ServiceRequest';

Line: 2363

  l_user_id			NUMBER		:= p_last_updated_by;

Line: 2364

  l_login_id			NUMBER		:= p_last_update_login;

Line: 2369

  l_update_desc_flex		VARCHAR2(1) := FND_API.G_FALSE;

Line: 2378

  l_sr_update_out_rec		CS_ServiceRequest_PVT.sr_update_out_rec_type;

Line: 2383

  SAVEPOINT Update_ServiceRequest_PUB;

Line: 2444

    , 'P_Last_updated_by:' || P_Last_updated_by
    );

Line: 2448

    , 'P_Last_update_login:' || P_Last_update_login
    );

Line: 2452

    , 'P_Last_update_date:' || P_Last_update_date
    );

Line: 2499

    , 'CS_SERVICEREQUEST_PUB.update_servicerequest'
    );

Line: 2679

Check to see if a value is passed for Caller_Type as it is not updateable - for BUG 2754987 .
*/
IF (l_service_request_rec.caller_type <> FND_API.G_MISS_CHAR) THEN
CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
		p_token_an	=>  l_api_name_full,
		p_token_ip	=>  'p_caller_type' );

Line: 2941

    l_update_desc_flex := FND_API.G_TRUE;

Line: 2970

    l_update_desc_flex := FND_API.G_TRUE;

Line: 3105

  l_request_rec.last_update_channel         := l_service_request_rec.last_update_channel;

Line: 3172

  l_request_rec.last_update_program_code    := l_service_request_rec.last_update_program_code;

Line: 3228

  CS_ServiceRequest_PVT.Update_ServiceRequest
    ( p_api_version           => 4.0,
      p_init_msg_list	      => FND_API.G_FALSE,
      p_commit		      => p_commit,
      p_validation_level      => FND_API.G_VALID_LEVEL_FULL,
      x_return_status	      => x_return_status,
      x_msg_count	      => x_msg_count,
      x_msg_data	      => x_msg_data,
      p_request_id	      => l_request_id,
      p_object_version_number => p_object_version_number,
      p_resp_appl_id          => p_resp_appl_id,
      p_resp_id               => l_resp_id,
      p_last_updated_by	      => l_user_id,
      p_last_update_login     => l_login_id,
      p_last_update_date      => p_last_update_date,
      p_service_request_rec   => l_request_rec,
      p_update_desc_flex      => l_update_desc_flex,
      p_notes                 => l_notes,
      p_contacts              => l_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_sr_update_out_rec.workflow_process_id,
      -- x_interaction_id	 => x_sr_update_out_rec.interaction_id
      -- Added for 11.5.10
      p_auto_assign	      => p_auto_assign,
      p_validate_sr_closure   => p_validate_sr_closure,
      p_auto_close_child_entities => p_auto_close_child_entities,
      p_default_contract_sla_ind  => p_default_contract_sla_ind,
      x_sr_update_out_rec     => l_sr_update_out_rec
    );

Line: 3261

  x_sr_update_out_rec.interaction_id		:= l_sr_update_out_rec.interaction_id;

Line: 3262

  x_sr_update_out_rec.workflow_process_id	:= l_sr_update_out_rec.workflow_process_id;

Line: 3263

  x_sr_update_out_rec.individual_owner		:= l_sr_update_out_rec.individual_owner;

Line: 3264

  x_sr_update_out_rec.group_owner		:= l_sr_update_out_rec.group_owner;

Line: 3265

  x_sr_update_out_rec.individual_type		:= l_sr_update_out_rec.individual_type;

Line: 3266

  x_sr_update_out_rec.resolved_on_date		:= l_sr_update_out_rec.resolved_on_date;

Line: 3267

  x_sr_update_out_rec.responded_on_date		:= l_sr_update_out_rec.responded_on_date;

Line: 3268

  x_sr_update_out_rec.status_id                 := l_sr_update_out_rec.status_id;

Line: 3269

  x_sr_update_out_rec.close_date                := l_sr_update_out_rec.close_date;

Line: 3290

    ROLLBACK TO Update_ServiceRequest_PUB;

Line: 3297

    ROLLBACK TO Update_ServiceRequest_PUB;

Line: 3304

    ROLLBACK TO Update_ServiceRequest_PUB;

Line: 3314

END Update_ServiceRequest;

Line: 3320

PROCEDURE Update_Status
( p_api_version		IN	NUMBER,
  p_init_msg_list	IN	VARCHAR2 := FND_API.G_FALSE,
  p_commit		IN	VARCHAR2 := FND_API.G_FALSE,
  x_return_status	OUT	NOCOPY VARCHAR2,
  x_msg_count		OUT	NOCOPY NUMBER,
  x_msg_data		OUT	NOCOPY VARCHAR2,
  p_resp_appl_id	IN	NUMBER   := NULL,
  p_resp_id		IN	NUMBER   := NULL,
  p_user_id		IN	NUMBER   := NULL,
  p_login_id		IN	NUMBER   := FND_API.G_MISS_NUM,
  p_request_id		IN	NUMBER   := NULL,
  p_request_number	IN	VARCHAR2 := NULL,
  p_object_version_number IN NUMBER,
  p_status_id		IN	NUMBER   := NULL,
  p_status		IN	VARCHAR2 := NULL,
  p_closed_date		IN	DATE     := FND_API.G_MISS_DATE,
  p_audit_comments	IN	VARCHAR2 := NULL,
  p_called_by_workflow	IN	VARCHAR2 := FND_API.G_FALSE,
  p_workflow_process_id	IN	NUMBER   := NULL,
  p_comments		IN	VARCHAR2 := NULL,
  p_public_comment_flag	IN	VARCHAR2 := FND_API.G_FALSE,
  -- for bug 3326813
  p_validate_sr_closure           IN          VARCHAR2 Default 'N',
  p_auto_close_child_entities     IN          VARCHAR2 Default 'N',
  x_interaction_id	OUT	NOCOPY NUMBER
)
IS
  l_api_name	       CONSTANT	VARCHAR2(30)	:= 'Update_Status';

Line: 3369

    SAVEPOINT Update_Status_PUB;

Line: 3550

    CS_ServiceRequest_PVT.Update_Status (
          p_api_version                =>  2.0,
          p_init_msg_list              =>  FND_API.G_FALSE,
          p_commit                     =>  FND_API.G_FALSE,
          p_resp_id                    => p_resp_id,
          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                 =>  l_request_id,
          p_object_version_number      => p_object_version_number,
          p_status_id                  =>  l_status_id,
          p_closed_date                =>  p_closed_date,
          p_last_updated_by            =>  l_user_id,
          p_last_update_login          =>  l_login_id,
          p_last_update_date           =>  sysdate,
          p_audit_comments             =>  p_audit_comments,
          p_called_by_workflow         =>  p_called_by_workflow,
          p_comments                   =>  p_comments,
          p_public_comment_flag        =>  l_public_comment_flag,
          x_interaction_id             =>  x_interaction_id,
	  -- for bug 3326813
	  p_validate_sr_closure        =>  p_validate_sr_closure,
          p_auto_close_child_entities  =>  p_auto_close_child_entities);

Line: 3593

      ROLLBACK TO Update_Status_PUB;

Line: 3599

      ROLLBACK TO Update_Status_PUB;

Line: 3605

      ROLLBACK TO Update_Status_PUB;

Line: 3614

END Update_Status;

Line: 3620

PROCEDURE Update_Severity
( p_api_version		IN	NUMBER,
  p_init_msg_list	IN	VARCHAR2 := FND_API.G_FALSE,
  p_commit		IN	VARCHAR2 := FND_API.G_FALSE,
  x_return_status	OUT	NOCOPY VARCHAR2,
  x_msg_count		OUT	NOCOPY NUMBER,
  x_msg_data		OUT	NOCOPY VARCHAR2,
  p_resp_appl_id	IN	NUMBER   := NULL,
  p_resp_id		IN	NUMBER   := NULL,
  p_user_id		IN	NUMBER   := NULL,
  p_login_id		IN	NUMBER   := FND_API.G_MISS_NUM,
  p_request_id		IN	NUMBER   := NULL,
  p_request_number	IN	VARCHAR2 := NULL,
  p_object_version_number IN NUMBER,
  p_severity_id		IN	NUMBER   := NULL,
  p_severity		IN	VARCHAR2 := NULL,
  p_audit_comments	IN	VARCHAR2 := NULL,
  p_comments		IN	VARCHAR2 := NULL,
  p_public_comment_flag	IN	VARCHAR2 := FND_API.G_FALSE,
  x_interaction_id		OUT	NOCOPY NUMBER
)
IS

BEGIN
   NULL;

Line: 3645

END Update_Severity;

Line: 3652

PROCEDURE Update_Urgency
( p_api_version		IN	NUMBER,
  p_init_msg_list	IN	VARCHAR2 := FND_API.G_FALSE,
  p_commit		IN	VARCHAR2 := FND_API.G_FALSE,
  x_return_status	OUT	NOCOPY VARCHAR2,
  x_msg_count		OUT	NOCOPY NUMBER,
  x_msg_data		OUT	NOCOPY VARCHAR2,
  p_resp_appl_id	IN	NUMBER   := NULL,
  p_resp_id		IN	NUMBER   := NULL,
  p_user_id		IN	NUMBER   := NULL,
  p_login_id		IN	NUMBER   := FND_API.G_MISS_NUM,
  p_request_id		IN	NUMBER   := NULL,
  p_request_number	IN	VARCHAR2 := NULL,
  p_object_version_number IN NUMBER,
  p_urgency_id		IN	NUMBER   := FND_API.G_MISS_NUM,
  p_urgency		IN	VARCHAR2 := FND_API.G_MISS_CHAR,
  p_audit_comments	IN	VARCHAR2 := NULL,
  p_comments		IN	VARCHAR2 := NULL,
  p_public_comment_flag	IN	VARCHAR2 := FND_API.G_FALSE,
  x_interaction_id  	OUT  NOCOPY NUMBER
)
IS
  BEGIN
      NULL;

Line: 3676

  END Update_Urgency;

Line: 3682

PROCEDURE Update_Owner
( p_api_version		IN	NUMBER,
  p_init_msg_list	IN	VARCHAR2 := FND_API.G_FALSE,
  p_commit		IN	VARCHAR2 := FND_API.G_FALSE,
  x_return_status	OUT	NOCOPY VARCHAR2,
  x_msg_count		OUT	NOCOPY NUMBER,
  x_msg_data		OUT	NOCOPY VARCHAR2,
  p_resp_appl_id	IN	NUMBER   := NULL,
  p_resp_id		IN	NUMBER   := NULL,
  p_user_id		IN	NUMBER   := NULL,
  p_login_id		IN	NUMBER   := FND_API.G_MISS_NUM,
  p_request_id		IN	NUMBER   := NULL,
  p_request_number	IN	VARCHAR2 := NULL,
  p_object_version_number IN NUMBER,
  p_owner_id		IN	NUMBER,
  p_owner_group_id  	IN   	NUMBER,
  p_resource_type	IN	VARCHAR2,
  p_audit_comments	IN	VARCHAR2 := NULL,
  p_called_by_workflow	IN	VARCHAR2 := FND_API.G_FALSE,
  p_workflow_process_id	IN	NUMBER   := NULL,
  p_comments		IN	VARCHAR2 := NULL,
  p_public_comment_flag	IN	VARCHAR2 := FND_API.G_FALSE,
  x_interaction_id	OUT	NOCOPY NUMBER
)
IS
  l_api_name	       CONSTANT	VARCHAR2(30)	:= 'Update_Owner';

Line: 3727

    SAVEPOINT Update_Owner_PUB;

Line: 3880

    CS_ServiceRequest_PVT.Update_Owner (
		p_api_version		  =>  2.0,
		p_init_msg_list		=>  FND_API.G_FALSE,
		p_commit		=>  FND_API.G_FALSE,
		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  	        =>  l_request_id,
		p_object_version_number  => p_object_version_number,
		p_resp_id		=>  l_resp_id,
		p_resp_appl_id		=>  l_resp_appl_id,
		p_owner_id		=>  p_owner_id,
		p_owner_group_id    =>  p_owner_group_id,
		p_resource_type     =>  p_resource_type,
		p_last_updated_by	=>  l_user_id,
		p_last_update_login	=>  l_login_id,
		p_last_update_date	=>  sysdate,
		p_audit_comments	=>  p_audit_comments,
		p_called_by_workflow	=>  p_called_by_workflow,
		p_comments		=>  p_comments,
		p_public_comment_flag	=>  l_public_comment_flag,
		x_interaction_id		=>  x_interaction_id );

Line: 3922

      ROLLBACK TO Update_Owner_PUB;

Line: 3928

      ROLLBACK TO Update_Owner_PUB;

Line: 3934

      ROLLBACK TO Update_Owner_PUB;

Line: 3943

END Update_Owner;

Line: 3950

PROCEDURE Update_Problem_Code
( p_api_version		IN	NUMBER,
  p_init_msg_list	IN	VARCHAR2 := FND_API.G_FALSE,
  p_commit		IN	VARCHAR2 := FND_API.G_FALSE,
  x_return_status	OUT	NOCOPY VARCHAR2,
  x_msg_count		OUT	NOCOPY NUMBER,
  x_msg_data		OUT	NOCOPY VARCHAR2,
  p_resp_appl_id	IN	NUMBER   := NULL,
  p_resp_id		IN	NUMBER   := NULL,
  p_user_id		IN	NUMBER   := NULL,
  p_login_id		IN	NUMBER   := FND_API.G_MISS_NUM,
  p_request_id		IN	NUMBER   := NULL,
  p_request_number	IN	VARCHAR2 := NULL,
  p_object_version_number IN NUMBER,
  p_problem_code	IN	VARCHAR2,
  p_comments		IN	VARCHAR2 := NULL,
  p_public_comment_flag	IN	VARCHAR2 := FND_API.G_FALSE,
  x_interaction_id	OUT	NOCOPY NUMBER
)
IS
  BEGIN
    NULL;

Line: 3972

  END Update_Problem_Code;

Line: 4075

   This Procedure is called during create and update of the SR.
   Create
   		  If the Id = G_MISS_NUM
		  	 Name = Valid value -> Id for the name is saved.
			 Name = Invalid value -> Raise Error.
			 Name = NULL -> Id is set to NULL.
			 Name = G_MISS_CHAR -> Id is set to Default value.
		  If the Id = NULL
		  	 Name is ignored ,Id is set to NULL.
		  If the Id = Value
		  	 Name is ignored ,Id is validated.
   Update
   		  If the Id = G_MISS_NUM
		  	 Name = Valid value -> Id for the name is saved.
			 Name = Invalid value -> Raise Error.
			 Name = NULL -> Id is set to NULL.
			 Name = G_MISS_CHAR -> No change is made.
		  If the Id = NULL
		  	 Name is ignored ,Id is set to NULL.
		  If the Id = Value
		  	 Name is ignored ,Id is validated and Updated.
*/
-- -------------------------------------------------------------------

PROCEDURE Convert_Request_Val_To_ID
( p_api_name			IN	VARCHAR2,
  p_org_id			IN	NUMBER		:= NULL,
  p_request_conv_rec		IN OUT	NOCOPY Request_Conversion_Rec_Type,
  p_return_status		OUT	NOCOPY VARCHAR2
)
IS
  l_return_status	VARCHAR2(1);

Line: 5801

    , 'last_update_channel        	:' || p_service_request_rec.last_update_channel
    );

Line: 5925

    , 'last_update_program_code   	:' || p_service_request_rec.last_update_program_code
    );