APPS.JTF_PERZ_DDF_PUB SQL Statements

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

Line: 497

PROCEDURE update_data_default
(
	p_api_version_number	IN NUMBER,
	p_init_msg_list		IN VARCHAR2,
	p_commit		IN VARCHAR,

	p_application_id	IN NUMBER,

	p_profile_id		IN NUMBER,
	p_profile_name		IN VARCHAR2,

	p_perz_ddf_id		IN NUMBER,
	p_perz_ddf_context	IN VARCHAR2,

	p_gui_object_name	IN VARCHAR2,
	p_gui_object_id		IN NUMBER,
	p_ddf_value		IN VARCHAR2,
	p_ddf_value_type	IN VARCHAR2,

	x_perz_ddf_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
      -- ******* save_data_default Local Variables ********
--	Following variables are needed to adhere to standards
	l_api_version_number	NUMBER 	:= p_api_version_number;

Line: 535

      SAVEPOINT	UPDATE_PERZ_DDF_PUB;

Line: 556

JTF_PERZ_DDF_PVT.update_data_default
(
	p_api_version_number	,
	p_init_msg_list		,
	p_commit		,

	p_application_id	,

	p_profile_id		,
	p_profile_name		,

	p_perz_ddf_id		,
	p_perz_ddf_context	,

	p_gui_object_name	,
	p_gui_object_id		,
	p_ddf_value		,
	p_ddf_value_type	,

	x_perz_ddf_id	   	,

	x_return_status		,
	x_msg_count		,
	x_msg_data
);

Line: 608

	  ROLLBACK TO UPDATE_PERZ_DDF_PUB;

Line: 623

	  ROLLBACK TO UPDATE_PERZ_DDF_PUB;

Line: 638

	  ROLLBACK TO UPDATE_PERZ_DDF_PUB;

Line: 652

END update_data_default;

Line: 656

PROCEDURE delete_data_default
(	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_ddf_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
      -- ******* save_data_default Local Variables ********
--	Following variables are needed to adhere to standards
	l_api_version_number	NUMBER 	:= p_api_version_number;

Line: 682

      SAVEPOINT	UPDATE_PERZ_DDF_PUB;

Line: 703

JTF_PERZ_DDF_PVT.delete_data_default
(	p_api_version_number	,
  	p_init_msg_list		,
	p_commit		,

	p_application_id	,
	p_profile_id        	,
	p_perz_ddf_id           ,

	x_return_status		,
	x_msg_count		,
	x_msg_data
);

Line: 742

	  ROLLBACK TO DELETE_PERZ_DDF_PUB;

Line: 757

	  ROLLBACK TO DELETE_PERZ_DDF_PUB;

Line: 772

	  ROLLBACK TO DELETE_PERZ_DDF_PUB;

Line: 785

END delete_data_default;