APPS.ICX_USER_SEC_ATTR_PUB SQL Statements

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

Line: 23

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

Line: 93

      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: 185

PROCEDURE Delete_User_Sec_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_web_user_id		IN	NUMBER,
   p_attribute_code		IN	VARCHAR2,
   p_attribute_appl_id		IN	NUMBER,
   p_varchar2_value             IN      VARCHAR2,
   p_date_value                 IN      DATE,
   p_number_value               IN      NUMBER

)
IS
   l_api_name		CONSTANT VARCHAR2(30) := 'Delete_User_Sec_Attr';

Line: 213

   SAVEPOINT Delete_User_Sec_Attr_PUB;

Line: 239

   ICX_User_Sec_Attr_PVT.Delete_User_Sec_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_web_user_id		=>	p_web_user_id		,
      p_attribute_code		=>	p_attribute_code	,
      p_attribute_appl_id	=>	p_attribute_appl_id     ,
      p_varchar2_value		=>	p_varchar2_value	,
      p_date_value		=>	p_date_value		,
      p_number_value		=>	p_number_value
   );

Line: 281

      ROLLBACK to Delete_User_Sec_Attr_PUB;

Line: 300

      Rollback to Delete_User_Sec_Attr_PUB;

Line: 311

      Rollback to Delete_User_Sec_Attr_PUB;

Line: 322

      Rollback to Delete_User_Sec_Attr_PUB;

Line: 341

end Delete_User_Sec_Attr;