APPS.ICX_RESP_EXCL_ATTR_PUB SQL Statements

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

Line: 21

   p_last_updated_by		IN	NUMBER,
   p_last_update_date		IN	DATE,
   p_last_update_login		IN	NUMBER
)
IS
   l_api_name		CONSTANT VARCHAR2(30) := 'Create_Resp_Excl_Attr';

Line: 89

      p_last_updated_by		=>	p_last_updated_by	,
      p_last_update_date	=>	p_last_update_date	,
      p_last_update_login	=>	p_last_update_login
   );

Line: 181

PROCEDURE Delete_Resp_Excl_Attr
(  p_api_version_number		IN	NUMBER,
   p_init_msg_list		IN	VARCHAR2 := FND_API.G_FALSE,
   p_simulate			IN	VARCHAR2 := FND_API.G_FALSE,
   p_commit			IN	VARCHAR2 := FND_API.G_FALSE,
   p_validation_level		IN	NUMBER   := FND_API.G_VALID_LEVEL_FULL,
   p_return_status		OUT	VARCHAR2,
   p_msg_count			OUT	NUMBER,
   p_msg_data			OUT	VARCHAR2,
--   p_msg_entity			OUT	VARCHAR2,
--   p_msg_entity_index		OUT	NUMBER,
   p_responsibility_id		IN	NUMBER,
   p_application_id		IN	NUMBER,
   p_attribute_code		IN	VARCHAR2,
   p_attribute_appl_id		IN	NUMBER
)
IS
   l_api_name		CONSTANT VARCHAR2(30) := 'Delete_Resp_Excl_Attr';

Line: 206

   SAVEPOINT Delete_Resp_Excl_Attr_PUB;

Line: 232

   ICX_Resp_Excl_Attr_PVT.Delete_Resp_Excl_Attr
   (
      p_api_version_number	=>	p_api_version_number	,
      p_init_msg_list		=>	p_init_msg_list		,
      p_simulate		=>	p_simulate		,
      p_commit			=>	p_commit		,
      p_validation_level	=>	p_validation_level	,
      p_return_status		=>	l_return_status		,
      p_msg_count		=>	p_msg_count		,
      p_msg_data		=>	p_msg_data		,
--      p_msg_entity		=>	p_msg_entity		,
--      p_msg_entity_index	=>	p_msg_entity_index	,
      p_responsibility_id	=>	p_responsibility_id     ,
      p_application_id		=>	p_application_id	,
      p_attribute_code		=>	p_attribute_code	,
      p_attribute_appl_id	=>	p_attribute_appl_id
   );

Line: 272

      ROLLBACK to Delete_Resp_Excl_Attr_PUB;

Line: 291

      Rollback to Delete_Resp_Excl_Attr_PUB;

Line: 302

      Rollback to Delete_Resp_Excl_Attr_PUB;

Line: 313

      Rollback to Delete_Resp_Excl_Attr_PUB;

Line: 332

end Delete_Resp_Excl_Attr;