APPS.BIS_INDICATOR_RESPS_PKG SQL Statements

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

Line: 27

  PROCEDURE Update_Row(
       x_indicator_resp_id   		in      number
      ,x_target_level_id		in	  number
      ,x_responsibility_id		in	  number
      ,x_last_updated_by 	    	in      number
      ,x_last_update_date        	in      date
      ,x_last_update_login       	in      number
  );

Line: 45

, p_last_updated_by             IN      NUMBER
, p_owner			IN 	VARCHAR
, x_return_status		OUT NOCOPY 	VARCHAR
, x_return_msg			OUT NOCOPY  	VARCHAR
) IS

  l_responsibility_id 	NUMBER;

Line: 63

  l_last_updated_by     NUMBER;

Line: 92

    SELECT BIS_INDICATOR_RESPS_S.nextval
    INTO l_indicator_resp_id
    FROM DUAL;

Line: 109

    IF (p_last_updated_by IS NULL) THEN
      l_last_updated_by := l_user_id;

Line: 112

      l_last_updated_by := p_last_updated_by;

Line: 128

      Insert_Row
      (
       x_rowid			=> l_row_id
      ,x_indicator_resp_id	=> l_indicator_resp_id
      ,x_target_level_id	=> l_target_level_id
      ,x_responsibility_id	=> l_responsibility_id
      ,x_created_by       	=> l_created_by
      ,x_creation_date        	=> sysdate
      ,x_last_updated_by 	=> l_last_updated_by
      ,x_last_update_date       => sysdate
      ,x_last_update_login      => l_login_id
      );

Line: 147

      Update_Row(
       x_indicator_resp_id   	=> l_target_level_id
      ,x_target_level_id	=> l_target_level_id
      ,x_responsibility_id	=> l_responsibility_id
      ,x_last_updated_by 	=> l_last_updated_by
      ,x_last_update_date       => sysdate
      ,x_last_update_login      => l_login_id
      );

Line: 207

  SELECT count(1)
  INTO l_count
  FROM bis_indicator_resps
  WHERE target_level_id = p_target_level_id
    AND responsibility_id = p_responsibility_id;	  -- BIS_UTILITIES_PUB.put_line(p_text => ' l_count = ' || l_count ) ;

Line: 245

  SELECT responsibility_id
  INTO l_responsibility_id
  FROM fnd_responsibility
  WHERE responsibility_key = p_responsibility_key ;

Line: 302

  SELECT target_level_id
  INTO l_target_level_id
  FROM bis_target_levels
  WHERE short_name = p_target_level_short_name ;

Line: 344

  PROCEDURE Insert_Row(
      x_rowid    				in out NOCOPY  varchar2
      ,x_indicator_resp_id   		in out NOCOPY  number
      ,x_target_level_id		in	  number
      ,x_responsibility_id		in	  number
      ,x_created_by       	 	in      number
      ,x_creation_date       		in      date
      ,x_last_updated_by 	    	in      number
      ,x_last_update_date        	in      date
      ,x_last_update_login       	in      number
  )
  IS

      CURSOR CROWID IS SELECT rowid FROM bis_indicator_resps
                       WHERE indicator_resp_id = x_indicator_resp_id;

Line: 360

      CURSOR CID IS SELECT bis_indicator_resps_s.nextval
                    FROM sys.dual;

Line: 372

      INSERT INTO bis_indicator_resps (
         indicator_resp_id
         ,target_level_id
         ,responsibility_id
         ,created_by
         ,creation_date
         ,last_updated_by
         ,last_update_date
         ,last_update_login
      )
      Values
      (
         x_indicator_resp_id
         ,x_target_level_id
         ,x_responsibility_id
         ,x_created_by
         ,x_creation_date
         ,x_last_updated_by
         ,x_last_update_date
         ,x_last_update_login
      );

Line: 402

  END Insert_Row;

Line: 414

      ,x_last_updated_by 	    	in      number
      ,x_last_update_date        	in      date
      ,x_last_update_login       	in      number
  )
  IS

      CURSOR C IS
         SELECT *
         FROM bis_indicator_resps
         WHERE rowid = x_rowid
         FOR UPDATE OF indicator_resp_id NOWAIT;

Line: 432

         FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

Line: 442

           AND (Recinfo.last_updated_by   	 = x_last_updated_by)
           AND (Recinfo.last_update_date   	 = x_last_update_date)
           AND (    (Recinfo.last_update_login = x_last_update_login)
                 OR (    (recinfo.last_update_login IS NULL)
                      AND(x_last_update_login IS NULL)))
         ) then
         return;

Line: 457

  PROCEDURE Update_Row(
      x_rowid    				in      varchar2
      ,x_indicator_resp_id   		in      number
      ,x_target_level_id		in	  number
      ,x_responsibility_id		in	  number
      ,x_created_by       	 	in      number
      ,x_creation_date       		in      date
      ,x_last_updated_by 	    	in      number
      ,x_last_update_date        	in      date
      ,x_last_update_login       	in      number
  )
  IS

      l_temp_msg		VARCHAR2(100);

Line: 474

      UPDATE bis_indicator_resps
      SET
         target_level_id	 = x_target_level_id
         ,responsibility_id	 = x_responsibility_id
         ,last_updated_by    	 = x_last_updated_by
         ,last_update_date     = x_last_update_date
         ,last_update_login     = x_last_update_login
      WHERE rowid = x_rowid;

Line: 486

  END Update_Row;

Line: 490

  PROCEDURE Update_Row(
       x_indicator_resp_id   		in      number
      ,x_target_level_id		in	  number
      ,x_responsibility_id		in	  number
      ,x_last_updated_by 	    	in      number
      ,x_last_update_date        	in      date
      ,x_last_update_login       	in      number
  )
  IS

      l_temp_msg		VARCHAR2(100);

Line: 504

      UPDATE bis_indicator_resps
      SET
          last_updated_by    	 = x_last_updated_by
         ,last_update_date       = x_last_update_date
         ,last_update_login      = x_last_update_login
      WHERE
         target_level_id	 = x_target_level_id
         AND responsibility_id	 = x_responsibility_id  ;

Line: 517

  END Update_Row;

Line: 521

  PROCEDURE Delete_Row(
      x_rowid    				in      varchar2
  )
  IS
  BEGIN
      DELETE FROM bis_indicator_resps
      WHERE  rowid = x_rowid;

Line: 532

  END Delete_Row;

Line: 542

      SELECT COUNT(1)
      FROM  bis_indicator_resps
      WHERE target_level_id = x_target_level_id
      AND   responsibility_id = x_responsibility_id
      AND   ((x_rowid is null) OR (rowid <> x_rowid));