APPS.JTF_PERZ_QUERY_PUB SQL Statements

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

Line: 581

PROCEDURE Update_Perz_Query
(	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_application_id	IN NUMBER,
	p_profile_id        IN NUMBER,

	p_query_id           IN NUMBER,
	p_query_name         IN VARCHAR2,
	p_query_type         IN VARCHAR2,
	p_query_desc		 IN VARCHAR2,
	p_query_data_source  IN VARCHAR2,

	p_query_param_tbl	 IN Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE
				 := Jtf_Perz_Query_Pub.G_MISS_QUERY_PARAMETER_TBL,
	p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE
				:= Jtf_Perz_Query_Pub.G_MISS_QUERY_ORDER_BY_TBL,
	p_query_raw_sql_rec	 IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE
			:= Jtf_Perz_Query_Pub.G_MISS_QUERY_RAW_SQL_REC,

	x_query_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

       -- ******* Local Variables ********

	l_api_version_number	NUMBER 	:= p_api_version_number;

Line: 618

      SAVEPOINT	UPDATE_JTF_PERZ_QUERY_PUB;

Line: 635

Jtf_Perz_Query_Pvt.Update_Perz_Query
( 	p_api_version_number,
  	p_init_msg_list,
	p_commit,
	p_application_id,
	p_profile_id,
	p_query_id,
	p_query_name,
	p_query_type,
	p_query_desc,
	p_query_data_source,
	p_query_param_tbl,
	p_query_order_by_tbl,
	p_query_raw_sql_rec,
	x_query_id,
	x_return_status,
	x_msg_count,
	x_msg_data
);

Line: 681

	  ROLLBACK TO UPDATE_JTF_PERZ_QUERY_PUB;

Line: 696

	  ROLLBACK TO UPDATE_JTF_PERZ_QUERY_PUB;

Line: 711

	  ROLLBACK TO UPDATE_JTF_PERZ_QUERY_PUB;

Line: 725

END Update_Perz_Query;

Line: 727

PROCEDURE Delete_Perz_Query
(	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_application_id	IN NUMBER,
	p_profile_id        IN NUMBER,
	p_query_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


       -- ******* Local Variables ********

	l_api_version_number	NUMBER 	:= p_api_version_number;

Line: 752

      SAVEPOINT	DELETE_JTF_PERZ_QUERY_PUB;

Line: 768

Jtf_Perz_Query_Pvt.Delete_Perz_Query
( 	p_api_version_number,
  	p_init_msg_list,
	p_commit,
	p_application_id,
	p_profile_id,
	p_query_id,

	x_return_status,
	x_msg_count,
	x_msg_data
);

Line: 807

	  ROLLBACK TO DELETE_JTF_PERZ_QUERY_PUB;

Line: 822

	  ROLLBACK TO DELETE_JTF_PERZ_QUERY_PUB;

Line: 837

	  ROLLBACK TO DELETE_JTF_PERZ_QUERY_PUB;

Line: 852

END Delete_Perz_Query;