APPS.JTF_PERZ_DATA_PUB SQL Statements

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

Line: 492

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

	p_application_id	IN NUMBER,
	p_profile_id        IN NUMBER,

	p_perz_data_id            IN NUMBER,
	p_perz_data_name          IN VARCHAR2,
	p_perz_data_type			IN VARCHAR2 := NULL,
	p_perz_data_desc	IN VARCHAR2,
	p_data_attrib_tbl	IN JTF_PERZ_DATA_PUB.DATA_ATTRIB_TBL_TYPE
						:= JTF_PERZ_DATA_PUB.G_MISS_DATA_ATTRIB_TBL,

	x_perz_data_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_Perz_Data local variable for standards **********
     	l_api_name		 CONSTANT VARCHAR2(30)	:= 'Update_Perz_Data';

Line: 521

      SAVEPOINT	UPDATE_PERZ_DATA_PUB;

Line: 539

	JTF_PERZ_DATA_PVT.Update_Perz_Data(
	p_api_version_number,
  	p_init_msg_list,
	p_commit,

	p_application_id,

	p_profile_id    ,
	p_perz_data_id,
	p_perz_data_name ,
	p_perz_data_type ,
    	p_perz_data_desc,

	p_data_attrib_tbl,

	x_perz_data_id  ,
	x_return_status	,
	x_msg_count,
	x_msg_data
   	);

Line: 578

	  ROLLBACK TO UPDATE_PERZ_DATA_PUB;

Line: 587

	  ROLLBACK TO UPDATE_PERZ_DATA_PUB;

Line: 596

	  ROLLBACK TO UPDATE_PERZ_DATA_PUB;

Line: 609

END Update_Perz_Data;

Line: 613

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

	p_application_id	IN NUMBER,
	p_profile_id        IN NUMBER,
	p_perz_data_id            IN 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

	--******** Delete_Perz_Data local variable for standards **********
     	l_api_name		 CONSTANT VARCHAR2(30)	:= 'Delete_Perz_Data';

Line: 634

      SAVEPOINT	DELETE_PERZ_DATA_PUB;

Line: 652

	JTF_PERZ_DATA_PVT.Delete_Perz_Data(
	p_api_version_number,
  	p_init_msg_list,
	p_commit,

	p_application_id,

	p_profile_id    ,
	p_perz_data_id,

	x_return_status	,
	x_msg_count,
	x_msg_data
   	);

Line: 686

	  ROLLBACK TO DELETE_PERZ_DATA_PUB;

Line: 695

	  ROLLBACK TO DELETE_PERZ_DATA_PUB;

Line: 704

	  ROLLBACK TO DELETE_PERZ_DATA_PUB;

Line: 719

END Delete_Perz_Data;