APPS.RG_DSS_REQUESTS_PKG SQL Statements

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

Line: 7

      SELECT *
      FROM   rg_dss_requests
      WHERE  request_id = X_request_id
      FOR UPDATE of status_flag  NOWAIT;

Line: 17

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

Line: 31

PROCEDURE Update_Row(X_request_id                           NUMBER,
                     X_status_flag                          VARCHAR2,
                     X_file_spec                            VARCHAR2,
		     X_last_update_date			    DATE,
		     X_last_updated_by			    NUMBER,
		     X_last_update_login		    NUMBER) IS
BEGIN

  UPDATE rg_dss_requests
  SET
    request_id                               =    X_request_id,
    status_flag                              =    X_status_flag,
    file_spec                                =    X_file_spec,
    last_update_date                         =    X_Last_Update_Date,
    last_updated_by                          =    X_Last_Updated_By,
    last_update_login                        =    X_Last_Update_Login
  WHERE request_id = X_request_id;

Line: 53

END Update_Row;