APPS.PV_BENFT_STATUS_MAPS_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW (
  px_benft_status_map_id	IN OUT NOCOPY NUMBER,
  px_object_version_number	IN OUT NOCOPY NUMBER,
  p_benefit_type		IN VARCHAR2,
  p_vendor_status_code		IN VARCHAR2,
  p_partner_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_BENFT_STATUS_MAPS (
    benft_status_map_id,
    object_version_number,
    benefit_type,
    vendor_status_code,
    partner_status_code,
    creation_date,
    created_by,
    last_update_date,
    last_updated_by,
    last_update_login
  ) values (
    DECODE ( px_benft_status_map_id,FND_API.g_miss_num,NULL,px_benft_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_vendor_status_code,FND_API.g_miss_char,NULL,p_vendor_status_code),
    DECODE ( p_partner_status_code,FND_API.g_miss_char,NULL,p_partner_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: 41

end INSERT_ROW;

Line: 50

  cursor c is select
      OBJECT_VERSION_NUMBER,
      BENEFIT_TYPE,
      VENDOR_STATUS_CODE,
      PARTNER_STATUS_CODE
    from PV_BENFT_STATUS_MAPS
    where BENFT_STATUS_MAP_ID = p_BENFT_STATUS_MAP_ID
    for update of BENFT_STATUS_MAP_ID nowait;

Line: 66

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

Line: 87

procedure UPDATE_ROW (
  p_benft_status_map_id    IN NUMBER,
  p_object_version_number  IN NUMBER,
  p_benefit_type	   IN VARCHAR2,
  p_vendor_status_code	   IN VARCHAR2,
  p_partner_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_benft_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),
    vendor_status_code		= DECODE ( p_vendor_status_code,FND_API.g_miss_char,NULL,p_vendor_status_code),
    partner_status_code		= DECODE ( p_partner_status_code,FND_API.g_miss_char,NULL,p_partner_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 benft_status_map_id  = p_benft_status_map_id;

Line: 112

end UPDATE_ROW;

Line: 114

procedure UPDATE_SEED_ROW (
  p_benft_status_map_id    IN NUMBER,
  p_object_version_number  IN NUMBER,
  p_benefit_type	   IN VARCHAR2,
  p_vendor_status_code	   IN VARCHAR2,
  p_partner_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_benft_status_maps
  WHERE  benft_status_map_id = p_benft_status_map_id;

Line: 131

  l_last_updated_by NUMBER;

Line: 135

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

Line: 140

  IF ( l_last_updated_by = 1) THEN

	 UPDATE_ROW (
	  p_benft_status_map_id => p_benft_status_map_id,
	  p_object_version_number  => p_object_version_number,
	  p_benefit_type	   => p_benefit_type,
	  p_vendor_status_code	   => p_vendor_status_code,
	  p_partner_status_code	   => p_partner_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: 156

END UPDATE_SEED_ROW;

Line: 157

procedure DELETE_ROW (
  p_BENFT_STATUS_MAP_ID in NUMBER
) is
begin
  delete from PV_BENFT_STATUS_MAPS
  where BENFT_STATUS_MAP_ID = p_BENFT_STATUS_MAP_ID;

Line: 167

end DELETE_ROW;

Line: 187

  SELECT object_version_number
  FROM   pv_benft_status_maps
  WHERE  benft_status_map_id =  p_benft_status_map_id;

Line: 192

  SELECT 'x'
  FROM   pv_benft_status_maps
  WHERE  benft_status_map_id =  p_benft_status_map_id;

Line: 209

	     INSERT_ROW(
		 px_benft_status_map_id		  =>   l_benft_status_map_id,
		 px_object_version_number	  =>   l_obj_verno,
		 p_benefit_type			  =>   p_benefit_type,
		 p_vendor_status_code		  =>   p_vendor_status_code,
		 p_partner_status_code		  =>   p_partner_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: 227

		 UPDATE_ROW (
		  p_benft_status_map_id    => p_benft_status_map_id,
		  p_object_version_number  => l_obj_verno,
		  p_benefit_type	   => p_benefit_type,
		  p_vendor_status_code	   => p_vendor_status_code,
		  p_partner_status_code	   => p_partner_status_code,
		  p_last_update_date	   => SYSDATE,
		  p_last_updated_by	   => l_user_id,
		  p_last_update_login	   => 0);