APPS.JTF_PERZ_LF_PUB SQL Statements

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

Line: 172

PROCEDURE Update_lf_object
( 	p_api_version_number	IN	NUMBER,
	p_init_msg_list		IN	VARCHAR2 := FND_API.G_FALSE,
	p_commit		IN	VARCHAR2 := FND_API.G_FALSE,

	p_profile_id            IN	NUMBER,
	p_profile_name          IN	VARCHAR2,

	p_application_id	IN 	NUMBER,
	p_parent_id		IN 	NUMBER,
	p_object_Id		IN	NUMBER,
	p_object_name		IN 	VARCHAR2,
	p_active_flag		IN 	VARCHAR2,

	p_object_type_id	IN 	NUMBER,
	p_object_type		IN 	VARCHAR2,

	p_attrib_value_tbl	IN   	JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE
					:= JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL,

	x_object_id	 OUT NOCOPY /* file.sql.39 change */ NUMBER,
	x_return_status	 OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
	x_msg_count	 OUT NOCOPY /* file.sql.39 change */ NUMBER,
	x_msg_data	 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
)IS

       -- ******* Update_lf_object Local Variables ********
	l_api_version_number	NUMBER 	:= p_api_version_number;

Line: 200

	l_api_name 			VARCHAR2(60)  	:= 'Update Object';

Line: 208

	SAVEPOINT     UPDATE_PERZ_LF_PUB;

Line: 223

	JTF_PERZ_LF_PVT.Update_lf_object
	( 	p_api_version_number,
		p_init_msg_list,
		p_commit,
		p_profile_id,
		p_profile_name,
		p_application_id,
		p_parent_id,
		p_Object_Id,
		p_object_name,
		p_active_flag,
		p_object_type_id,
		p_object_type,
		p_attrib_value_tbl,
		x_object_id,
		x_return_status,
		x_msg_count,
		x_msg_data
	);

Line: 268

	  ROLLBACK TO UPDATE_PERZ_LF_PUB;

Line: 284

	  ROLLBACK TO UPDATE_PERZ_LF_PUB;

Line: 299

	  ROLLBACK TO UPDATE_PERZ_LF_PUB;

Line: 311

END Update_LF_Object;

Line: 391

          UPDATE JTF_PERZ_LF_OBJECT SET OBJECT_DESCRIPTION = p_object_description WHERE OBJECT_ID = x_object_id;