APPS.PV_BENFT_USER_ROLE_MAPS_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW (
  px_user_role_map_id		IN OUT NOCOPY NUMBER,
  px_object_version_number	IN OUT NOCOPY NUMBER,
  p_benefit_type		in VARCHAR2,
  p_user_role_code		in VARCHAR2,
  p_external_flag		in VARCHAR2,
  p_creation_date		IN DATE,
  p_created_by			IN NUMBER,
  p_last_update_date		IN DATE,
  p_last_updated_by		IN NUMBER,
  p_last_update_login		IN NUMBER
  )
  IS
begin
  INSERT INTO pv_benft_user_role_maps (
    user_role_map_id,
    object_version_number,
    benefit_type,
    user_role_code,
    external_flag,
    creation_date,
    created_by,
    last_update_date,
    last_updated_by,
    last_update_login
  ) values (
    DECODE ( px_user_role_map_id,FND_API.g_miss_num,NULL,px_user_role_map_id),
    DECODE ( px_object_version_number,FND_API.g_miss_num,NULL,px_object_version_number),
    DECODE ( p_benefit_type,FND_API.g_miss_char,NULL,p_benefit_type),
    DECODE ( p_user_role_code,FND_API.g_miss_char,NULL,p_user_role_code),
    DECODE ( p_external_flag,FND_API.g_miss_char,NULL,p_external_flag),
    DECODE ( p_creation_date,FND_API.g_miss_date,NULL,p_creation_date),
    DECODE ( p_created_by,FND_API.g_miss_num,NULL,p_created_by),
    DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date),
    DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by),
    DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login));

Line: 39

end INSERT_ROW;

Line: 48

  CURSOR C IS SELECT
      object_version_number,
      benefit_type,
      user_role_code,
      external_flag
    FROM pv_benft_user_role_maps
    WHERE user_role_map_id = p_user_role_map_id
    FOR UPDATE OF user_role_map_id nowait;

Line: 63

    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 84

procedure UPDATE_ROW (
  p_user_role_map_id	   IN NUMBER,
  p_object_version_number  IN NUMBER,
  p_benefit_type	   IN VARCHAR2,
  p_user_role_code	   IN VARCHAR2,
  p_external_flag	   IN VARCHAR2,
  p_last_update_date	   IN DATE,
  p_last_updated_by	   IN NUMBER,
  p_last_update_login	   IN NUMBER
) is
begin
  UPDATE pv_benft_user_role_maps SET
    object_version_number	= DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1),
    benefit_type		= DECODE ( p_benefit_type,FND_API.g_miss_char,NULL,p_benefit_type),
    user_role_code		= DECODE ( p_user_role_code,FND_API.g_miss_char,NULL,p_user_role_code),
    external_flag		= DECODE ( p_external_flag,FND_API.g_miss_char,NULL,p_external_flag),
    last_update_date		= DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date),
    last_updated_by		= DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by),
    last_update_login		= DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login)
  WHERE user_role_map_id  = p_user_role_map_id;

Line: 110

end UPDATE_ROW;

Line: 113

procedure DELETE_ROW (
  p_user_role_map_id in NUMBER
) is
begin

  DELETE FROM pv_benft_user_role_maps
  WHERE user_role_map_id = p_user_role_map_id;

Line: 124

end DELETE_ROW;

Line: 144

  SELECT object_version_number
  FROM   pv_benft_user_role_maps
  WHERE  user_role_map_id =  p_user_role_map_id;

Line: 149

  SELECT 'x'
  FROM   pv_benft_user_role_maps
  WHERE  user_role_map_id =  p_user_role_map_id;

Line: 169

	     INSERT_ROW(
		 px_user_role_map_id		  =>   l_user_role_map_id,
		 px_object_version_number	  =>   l_obj_verno,
		 p_benefit_type			  =>   p_benefit_type,
		 p_user_role_code		  =>   p_user_role_code,
		 p_external_flag		  =>   p_external_flag,
		 p_creation_date		  =>   SYSDATE,
		 p_created_by			  =>   l_user_id,
		 p_last_update_date		  =>   SYSDATE,
		 p_last_updated_by		  =>   l_user_id,
		 p_last_update_login		  =>   0);

Line: 188

		 UPDATE_ROW (
		  p_user_role_map_id	   => p_user_role_map_id,
		  p_object_version_number  => l_obj_verno,
		  p_benefit_type	   => p_benefit_type,
		  p_user_role_code	   => p_user_role_code,
		  p_external_flag	   => p_external_flag,
		  p_last_update_date	   => SYSDATE,
		  p_last_updated_by	   => l_user_id,
		  p_last_update_login	   => 0);