APPS.JTF_PERZ_DDF_PVT SQL Statements

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

Line: 49

PROCEDURE insert_jtf_perz_data_default(
	x_PERZ_DDF_ID IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
        p_PROFILE_ID		IN	NUMBER,
        p_APPLICATION_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,
	p_OBJECT_VERSION_NUMBER IN	NUMBER
) IS
   CURSOR C2 IS SELECT JTF_PERZ_DATA_DEFAULT_S.nextval FROM sys.dual;

Line: 67

   INSERT INTO JTF_PERZ_DATA_DEFAULT(
           PERZ_DATA_DEFAULT_ID,
           PROFILE_ID,
           APPLICATION_ID,
           PERZ_DDF_CONTEXT,
           GUI_OBJECT_NAME,
           GUI_OBJECT_ID,
           PERZ_DDF_VALUE,
           PERZ_DDF_VALUE_TYPE,
	   OBJECT_VERSION_NUMBER,
	   CREATED_BY,
	   LAST_UPDATE_DATE,
	   LAST_UPDATED_BY,
	   LAST_UPDATE_LOGIN
          ) VALUES (
           x_PERZ_DDF_ID,
           decode( p_PROFILE_ID, FND_API.G_MISS_NUM, NULL, p_PROFILE_ID),
           decode( p_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_APPLICATION_ID),
           decode( p_PERZ_DDF_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_PERZ_DDF_CONTEXT),
           decode( p_GUI_OBJECT_NAME, FND_API.G_MISS_CHAR, NULL, p_GUI_OBJECT_NAME),
           decode( p_GUI_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_GUI_OBJECT_ID),
           decode( p_DDF_VALUE, FND_API.G_MISS_CHAR, NULL, p_DDF_VALUE),
           decode( p_DDF_VALUE_TYPE, FND_API.G_MISS_CHAR, NULL, p_DDF_VALUE_TYPE),
	   decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, 1, p_OBJECT_VERSION_NUMBER),
	   FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID
	);

Line: 93

End insert_jtf_perz_data_default;

Line: 96

PROCEDURE update_jtf_perz_data_default(
          x_PERZ_DDF_ID	 IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
          p_PROFILE_ID		IN	NUMBER,
          p_APPLICATION_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,
	p_OBJECT_VERSION_NUMBER IN	NUMBER
) IS

l_object_version_number NUMBER := p_OBJECT_VERSION_NUMBER;

Line: 110

    Update JTF_PERZ_DATA_DEFAULT
    SET
--	PROFILE_ID = decode( p_PROFILE_ID, FND_API.G_MISS_NUM, PROFILE_ID, p_PROFILE_ID),
--	APPLICATION_ID = decode( p_APPLICATION_ID, FND_API.G_MISS_NUM, APPLICATION_ID, p_APPLICATION_ID),
--	PERZ_DDF_CONTEXT = decode( p_PERZ_DDF_CONTEXT, FND_API.G_MISS_CHAR, PERZ_DDF_CONTEXT, p_PERZ_DDF_CONTEXT),
--	GUI_OBJECT_NAME = decode( p_GUI_OBJECT_NAME, FND_API.G_MISS_CHAR, GUI_OBJECT_NAME, p_GUI_OBJECT_NAME),
--	GUI_OBJECT_ID = decode( p_GUI_OBJECT_ID, FND_API.G_MISS_NUM, GUI_OBJECT_ID, p_GUI_OBJECT_ID),
	PERZ_DDF_VALUE = decode( p_DDF_VALUE, FND_API.G_MISS_CHAR, PERZ_DDF_VALUE, p_DDF_VALUE),
	PERZ_DDF_VALUE_TYPE = decode( p_DDF_VALUE_TYPE, FND_API.G_MISS_CHAR, PERZ_DDF_VALUE_TYPE, p_DDF_VALUE_TYPE),
	OBJECT_VERSION_NUMBER = decode (p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,
					OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER+1),
	LAST_UPDATE_DATE = SYSDATE,
	LAST_UPDATED_BY  = FND_GLOBAL.USER_ID,
	LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
    where PERZ_DATA_DEFAULT_ID = x_PERZ_DDF_ID
	and OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER;

Line: 130

END update_jtf_perz_data_default;

Line: 133

PROCEDURE delete_jtf_perz_data_default(
    p_PERZ_DDF_ID  IN NUMBER)
 IS
 BEGIN
   DELETE FROM JTF_PERZ_DATA_DEFAULT
    WHERE PERZ_DATA_DEFAULT_ID = p_PERZ_DDF_ID;

Line: 142

 END delete_jtf_perz_data_default;

Line: 173

	select perz_data_default_id, perz_ddf_context,
		profile_id, application_id, gui_object_name,
		gui_object_id, PERZ_ddf_value, PERZ_ddf_value_type
	from JTF_PERZ_DATA_DEFAULT
	where
		PROFILE_ID = p_PROFILE_ID
	and	APPLICATION_ID = p_APPLICATION_ID
	and	GUI_OBJECT_ID = p_GUI_OBJECT_ID
	and	PERZ_DDF_CONTEXT = p_PERZ_DDF_CONTEXT;

Line: 185

	select perz_data_default_id, perz_ddf_context,
		profile_id, application_id, gui_object_name,
		gui_object_id, PERZ_ddf_value, PERZ_ddf_value_type
	from JTF_PERZ_DATA_DEFAULT
	where
		PROFILE_ID = p_PROFILE_ID
	and	APPLICATION_ID = p_APPLICATION_ID
	and	GUI_OBJECT_ID = p_GUI_OBJECT_ID;

Line: 196

	select perz_data_default_id, perz_ddf_context,
		profile_id, application_id, gui_object_name,
		gui_object_id, PERZ_ddf_value, PERZ_ddf_value_type

	from JTF_PERZ_DATA_DEFAULT
	where
		PROFILE_ID = p_PROFILE_ID
	and	APPLICATION_ID = p_APPLICATION_ID
	and	GUI_OBJECT_NAME = p_GUI_OBJECT_NAME
	and	PERZ_DDF_CONTEXT = p_PERZ_DDF_CONTEXT;

Line: 209

	select perz_data_default_id, perz_ddf_context,
		profile_id, application_id, gui_object_name,
		gui_object_id, PERZ_ddf_value, PERZ_ddf_value_type
	from JTF_PERZ_DATA_DEFAULT
	where
		PROFILE_ID = p_PROFILE_ID
	and	APPLICATION_ID = p_APPLICATION_ID
	and	GUI_OBJECT_NAME = p_GUI_OBJECT_NAME;

Line: 406

	select PERZ_DATA_DEFAULT_ID, OBJECT_VERSION_NUMBER
	into l_perz_ddf_id, x_OBJECT_VERSION_NUMBER
	from JTF_PERZ_DATA_DEFAULT
	where PERZ_DATA_DEFAULT_ID = x_PERZ_DDF_ID;

Line: 425

		select  PERZ_DATA_DEFAULT_ID, OBJECT_VERSION_NUMBER
		into l_perz_ddf_id, x_OBJECT_VERSION_NUMBER
		from JTF_PERZ_DATA_DEFAULT
		where PROFILE_ID = p_PROFILE_ID
		and	APPLICATION_ID = p_APPLICATION_ID
		and	PERZ_DDF_CONTEXT = p_PERZ_DDF_CONTEXT
		and	GUI_OBJECT_ID = p_GUI_OBJECT_ID;

Line: 447

			select  PERZ_DATA_DEFAULT_ID, OBJECT_VERSION_NUMBER
			into l_perz_ddf_id, x_OBJECT_VERSION_NUMBER
			from JTF_PERZ_DATA_DEFAULT
			where PROFILE_ID = p_PROFILE_ID
			and	APPLICATION_ID = p_APPLICATION_ID
			and	PERZ_DDF_CONTEXT = p_PERZ_DDF_CONTEXT
			and	GUI_OBJECT_NAME = p_GUI_OBJECT_NAME;

Line: 625

   insert_jtf_perz_data_default(
          l_perz_ddf_id,
          l_profile_id,
          p_APPLICATION_ID,
          p_PERZ_DDF_CONTEXT,
          p_GUI_OBJECT_NAME,
          p_GUI_OBJECT_ID,
          p_DDF_VALUE,
          p_DDF_VALUE_TYPE,
	l_object_version_number
   );

Line: 759

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

Line: 787

     	l_api_name		CONSTANT VARCHAR2(30)	:= 'Update_data_default';

Line: 807

      SAVEPOINT	UPDATE_PERZ_DDF_PVT;

Line: 873

	update_jtf_perz_data_default(
        	l_perz_ddf_id,
		l_profile_id,
          	p_APPLICATION_ID,
          	p_PERZ_DDF_CONTEXT,
          	p_GUI_OBJECT_NAME,
          	p_GUI_OBJECT_ID,
          	p_DDF_VALUE,
          	p_DDF_VALUE_TYPE,
		l_OBJECT_VERSION_NUMBER
	);

Line: 919

	  ROLLBACK TO UPDATE_PERZ_DDF_PVT;

Line: 934

	  ROLLBACK TO UPDATE_PERZ_DDF_PVT;

Line: 949

	  ROLLBACK TO UPDATE_PERZ_DDF_PVT;

Line: 963

END update_data_default;

Line: 1197

	update_data_default
	(
		l_api_version_number,
		l_init_msg_list	,
		l_commit	,
		p_application_id,
		l_profile_id	,
		l_profile_name	,
		l_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: 1498

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

Line: 1514

     	l_api_name		CONSTANT VARCHAR2(30)	:= 'Delete_data_default';

Line: 1522

      SAVEPOINT	DELETE_PERZ_DDF_PVT;

Line: 1545

	-- Call delete_row()

	delete_jtf_perz_data_default( p_perz_ddf_id);

Line: 1577

	  ROLLBACK TO DELETE_PERZ_DDF_PVT;

Line: 1592

	  ROLLBACK TO DELETE_PERZ_DDF_PVT;

Line: 1607

	  ROLLBACK TO DELETE_PERZ_DDF_PVT;

Line: 1621

END delete_data_default;