APPS.ICX_USER_PROFILE_PVT SQL Statements

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

Line: 20

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

Line: 65

             fnd_message.set_name('FND','SQL-NO INSERT');

Line: 77

             fnd_message.set_name('FND','SQL-NO INSERT');

Line: 89

             fnd_message.set_name('FND','SQL-NO INSERT');

Line: 101

             fnd_message.set_name('FND','SQL-NO INSERT');

Line: 174

PROCEDURE Update_Profile
(  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	NOCOPY VARCHAR2,
   p_msg_count			OUT	NOCOPY NUMBER,
   p_msg_data			OUT	NOCOPY VARCHAR2,
   p_user_id			IN	NUMBER,
   p_days_needed_by		IN	NUMBER   := FND_API.G_MISS_NUM,
   p_req_default_template	IN	VARCHAR2 := FND_API.G_MISS_CHAR,
   p_req_override_loc_flag	IN	VARCHAR2 := FND_API.G_MISS_CHAR,
   p_req_override_req_code	IN	VARCHAR2 := FND_API.G_MISS_CHAR,
   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) := 'Update_Profile';

Line: 202

   SAVEPOINT Update_Profile_PVT;

Line: 239

             fnd_message.set_name('FND','SQL-NO INSERT');

Line: 256

             fnd_message.set_name('FND','SQL-NO INSERT');

Line: 273

             fnd_message.set_name('FND','SQL-NO INSERT');

Line: 290

             fnd_message.set_name('FND','SQL-NO INSERT');

Line: 301

      ROLLBACK to Update_Profile_PVT;

Line: 320

      Rollback to Update_Profile_PVT;

Line: 331

      Rollback to Update_Profile_PVT;

Line: 342

      Rollback to Update_Profile_PVT;

Line: 361

end Update_Profile;

Line: 365

PROCEDURE Delete_Profile
(  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	nocopy VARCHAR2,
   p_msg_count			OUT	nocopy NUMBER,
   p_msg_data			OUT	nocopy VARCHAR2,
   p_user_id			IN	NUMBER
)
IS
l_api_name		CONSTANT VARCHAR2(30) := 'Delete_Profile';

Line: 384

e_cannot_delete			 EXCEPTION;

Line: 391

   SAVEPOINT Delete_Profile_PVT;

Line: 424

             fnd_message.set_name('FND','SQL-NO INSERT');

Line: 436

             fnd_message.set_name('FND','SQL-NO INSERT');

Line: 448

             fnd_message.set_name('FND','SQL-NO INSERT');

Line: 460

             fnd_message.set_name('FND','SQL-NO INSERT');

Line: 470

      ROLLBACK to Delete_Profile_PVT;

Line: 487

   WHEN NO_DATA_FOUND or e_cannot_delete THEN

      Rollback to Delete_Profile_PVT;

Line: 492

      fnd_message.set_name('FND','SQL-NO DELETE');

Line: 505

      Rollback to Delete_Profile_PVT;

Line: 516

      Rollback to Delete_Profile_PVT;

Line: 527

      Rollback to Delete_Profile_PVT;

Line: 546

end Delete_Profile;