APPS.PV_REFERRAL_STATUS_MAPS_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW (
  px_referral_status_map_id	IN OUT NOCOPY NUMBER,
  px_object_version_number	IN OUT NOCOPY NUMBER,
  p_benefit_type		IN VARCHAR2,
  p_status_code			IN VARCHAR2,
  p_map_status_code		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_referral_status_maps (
    referral_status_map_id,
    object_version_number,
    benefit_type,
    status_code,
    map_status_code,
    creation_date,
    created_by,
    last_update_date,
    last_updated_by,
    last_update_login
  ) values (
    DECODE ( px_referral_status_map_id,FND_API.g_miss_num,NULL,px_referral_status_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_status_code,FND_API.g_miss_char,NULL,p_status_code),
    DECODE ( p_map_status_code,FND_API.g_miss_char,NULL,p_map_status_code),
    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: 40

end INSERT_ROW;

Line: 49

  cursor c is select
      OBJECT_VERSION_NUMBER,
      BENEFIT_TYPE,
      STATUS_CODE,
      MAP_STATUS_CODE
    from PV_REFERRAL_STATUS_MAPS
    where REFERRAL_STATUS_MAP_ID = p_REFERRAL_STATUS_MAP_ID
    for update of REFERRAL_STATUS_MAP_ID nowait;

Line: 64

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

Line: 85

procedure UPDATE_ROW (
  p_referral_status_map_id IN NUMBER,
  p_object_version_number  IN NUMBER,
  p_benefit_type	   IN VARCHAR2,
  p_status_code		   IN VARCHAR2,
  p_map_status_code	   IN VARCHAR2,
  p_last_update_date	   IN DATE,
  p_last_updated_by	   IN NUMBER,
  p_last_update_login	   IN NUMBER
) is
begin
  UPDATE pv_referral_status_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),
    status_code			= DECODE ( p_status_code,FND_API.g_miss_char,NULL,p_status_code),
    map_status_code		= DECODE ( p_map_status_code,FND_API.g_miss_char,NULL,p_map_status_code),
    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 referral_status_map_id  = p_referral_status_map_id;

Line: 111

end UPDATE_ROW;

Line: 113

procedure UPDATE_SEED_ROW (
  p_referral_status_map_id IN NUMBER,
  p_object_version_number  IN NUMBER,
  p_benefit_type	   IN VARCHAR2,
  p_status_code		   IN VARCHAR2,
  p_map_status_code	   IN VARCHAR2,
  p_last_update_date	   IN DATE,
  p_last_updated_by	   IN NUMBER,
  p_last_update_login	   IN NUMBER
) IS

  CURSOR  c_updated_by
  IS
  SELECT last_updated_by
  FROM   pv_referral_status_maps
  WHERE  referral_status_map_id = p_referral_status_map_id;

Line: 130

  l_last_updated_by NUMBER;

Line: 134

    FOR x IN c_updated_by
     LOOP
		l_last_updated_by :=  x.last_updated_by;

Line: 139

  IF ( l_last_updated_by = 1) THEN

	 UPDATE_ROW (
	  p_referral_status_map_id => p_referral_status_map_id,
	  p_object_version_number  => p_object_version_number,
	  p_benefit_type	   => p_benefit_type,
	  p_status_code		   => p_status_code,
	  p_map_status_code	   => p_map_status_code,
	  p_last_update_date	   => p_last_update_date,
	  p_last_updated_by	   => p_last_updated_by,
	  p_last_update_login	   => p_last_update_login
	  );

Line: 157

end UPDATE_SEED_ROW;

Line: 159

procedure DELETE_ROW (
  p_REFERRAL_STATUS_MAP_ID in NUMBER
) is
begin

  delete from PV_REFERRAL_STATUS_MAPS
  where REFERRAL_STATUS_MAP_ID = p_REFERRAL_STATUS_MAP_ID;

Line: 170

end DELETE_ROW;

Line: 190

  SELECT object_version_number
  FROM   pv_referral_status_maps
  WHERE  referral_status_map_id =  p_referral_status_map_id;

Line: 195

  SELECT 'x'
  FROM   pv_referral_status_maps
  WHERE  referral_status_map_id =  p_referral_status_map_id;

Line: 215

	     INSERT_ROW(
		 px_referral_status_map_id	  =>   l_referral_status_map_id,
		 px_object_version_number	  =>   l_obj_verno,
		 p_benefit_type			  =>   p_benefit_type,
		 p_status_code			  =>   p_status_code,
		 p_map_status_code		  =>   p_map_status_code,
		 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: 233

		 UPDATE_ROW (
		  p_referral_status_map_id => p_referral_status_map_id,
		  p_object_version_number  => l_obj_verno,
		  p_benefit_type	   => p_benefit_type,
		  p_status_code		   => p_status_code,
		  p_map_status_code	   => p_map_status_code,
		  p_last_update_date	   => SYSDATE,
		  p_last_updated_by	   => l_user_id,
		  p_last_update_login	   => 0);