APPS.JTF_BRMWFATTRVALUE_PVT SQL Statements

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

Line: 51

  CURSOR c IS SELECT ROWID
              FROM  JTF_BRM_WF_ATTR_VALUES
              WHERE WF_ATTR_VALUE_ID = l_wf_attr_value_id;

Line: 92

    SELECT jtf_brm_wf_attr_values_s.NEXTVAL INTO l_wf_attr_value_id
    FROM DUAL;

Line: 101

  INSERT INTO JTF_BRM_WF_ATTR_VALUES
  ( WF_ATTR_VALUE_ID
  , PROCESS_ID
  , WF_ITEM_TYPE
  , WF_ACTIVITY_NAME
  , WF_ACTIVITY_VERSION
  , WF_ACTIVITY_ATTRIBUTE_NAME
  , CREATED_BY
  , CREATION_DATE
  , LAST_UPDATED_BY
  , LAST_UPDATE_DATE
  , LAST_UPDATE_LOGIN
  , TEXT_VALUE
  , NUMBER_VALUE
  , DATE_VALUE
  , ATTRIBUTE1
  , ATTRIBUTE2
  , ATTRIBUTE3
  , ATTRIBUTE4
  , ATTRIBUTE5
  , ATTRIBUTE6
  , ATTRIBUTE7
  , ATTRIBUTE8
  , ATTRIBUTE9
  , ATTRIBUTE10
  , ATTRIBUTE11
  , ATTRIBUTE12
  , ATTRIBUTE13
  , ATTRIBUTE14
  , ATTRIBUTE15
  , ATTRIBUTE_CATEGORY
  , SECURITY_GROUP_ID
  , OBJECT_VERSION_NUMBER
  , APPLICATION_ID
  ) VALUES
  ( l_wf_attr_value_id
  , p_bwa_rec.PROCESS_ID
  , p_bwa_rec.WF_ITEM_TYPE
  , p_bwa_rec.WF_ACTIVITY_NAME
  , p_bwa_rec.WF_ACTIVITY_VERSION
  , p_bwa_rec.WF_ACTIVITY_ATTRIBUTE_NAME
  , p_bwa_rec.CREATED_BY
  , p_bwa_rec.CREATION_DATE
  , p_bwa_rec.LAST_UPDATED_BY
  , p_bwa_rec.LAST_UPDATE_DATE
  , p_bwa_rec.LAST_UPDATE_LOGIN
  , p_bwa_rec.TEXT_VALUE
  , p_bwa_rec.NUMBER_VALUE
  , p_bwa_rec.DATE_VALUE
  , p_bwa_rec.ATTRIBUTE1
  , p_bwa_rec.ATTRIBUTE2
  , p_bwa_rec.ATTRIBUTE3
  , p_bwa_rec.ATTRIBUTE4
  , p_bwa_rec.ATTRIBUTE5
  , p_bwa_rec.ATTRIBUTE6
  , p_bwa_rec.ATTRIBUTE7
  , p_bwa_rec.ATTRIBUTE8
  , p_bwa_rec.ATTRIBUTE9
  , p_bwa_rec.ATTRIBUTE10
  , p_bwa_rec.ATTRIBUTE11
  , p_bwa_rec.ATTRIBUTE12
  , p_bwa_rec.ATTRIBUTE13
  , p_bwa_rec.ATTRIBUTE14
  , p_bwa_rec.ATTRIBUTE15
  , p_bwa_rec.ATTRIBUTE_CATEGORY
  , p_bwa_rec.SECURITY_GROUP_ID
  , l_object_version_number
  , p_bwa_rec.APPLICATION_ID
  );

Line: 262

PROCEDURE Update_WFAttrValue
( p_api_version      IN      NUMBER
, p_init_msg_list    IN      VARCHAR2 DEFAULT fnd_api.g_false
, p_commit           IN      VARCHAR2 DEFAULT fnd_api.g_false
, p_validation_level IN      NUMBER   DEFAULT fnd_api.g_valid_level_full
, x_return_status       OUT NOCOPY  VARCHAR2
, x_msg_count           OUT NOCOPY  NUMBER
, x_msg_data            OUT NOCOPY  VARCHAR2
, p_bwa_rec          IN      brm_wf_attr_value_rec_type
)
IS
  l_api_name              CONSTANT VARCHAR2(30)    := 'Update_WFAttrValue';

Line: 285

  SAVEPOINT Update_WFAttrValue_PVT;

Line: 315

  SELECT JTF_BRM_OBJECT_VERSION_S.NEXTVAL
  INTO l_object_version_number
  FROM DUAL;

Line: 319

  UPDATE JTF_BRM_WF_ATTR_VALUES
  SET PROCESS_ID = p_bwa_rec.PROCESS_ID
  ,   WF_ITEM_TYPE = p_bwa_rec.WF_ITEM_TYPE
  ,   WF_ACTIVITY_NAME = p_bwa_rec.WF_ACTIVITY_NAME
  ,   WF_ACTIVITY_VERSION = p_bwa_rec.WF_ACTIVITY_VERSION
  ,   WF_ACTIVITY_ATTRIBUTE_NAME = p_bwa_rec.WF_ACTIVITY_ATTRIBUTE_NAME
  ,   LAST_UPDATED_BY = p_bwa_rec.LAST_UPDATED_BY
  ,   LAST_UPDATE_DATE = p_bwa_rec.LAST_UPDATE_DATE
  ,   LAST_UPDATE_LOGIN = p_bwa_rec.LAST_UPDATE_LOGIN
  ,   TEXT_VALUE = p_bwa_rec.TEXT_VALUE
  ,   NUMBER_VALUE = p_bwa_rec.NUMBER_VALUE
  ,   DATE_VALUE = p_bwa_rec.DATE_VALUE
  ,   ATTRIBUTE1 = p_bwa_rec.ATTRIBUTE1
  ,   ATTRIBUTE2 = p_bwa_rec.ATTRIBUTE2
  ,   ATTRIBUTE3 = p_bwa_rec.ATTRIBUTE3
  ,   ATTRIBUTE4 = p_bwa_rec.ATTRIBUTE4
  ,   ATTRIBUTE5 = p_bwa_rec.ATTRIBUTE5
  ,   ATTRIBUTE6 = p_bwa_rec.ATTRIBUTE6
  ,   ATTRIBUTE7 = p_bwa_rec.ATTRIBUTE7
  ,   ATTRIBUTE8 = p_bwa_rec.ATTRIBUTE8
  ,   ATTRIBUTE9 = p_bwa_rec.ATTRIBUTE9
  ,   ATTRIBUTE10 = p_bwa_rec.ATTRIBUTE10
  ,   ATTRIBUTE11 = p_bwa_rec.ATTRIBUTE11
  ,   ATTRIBUTE12 = p_bwa_rec.ATTRIBUTE12
  ,   ATTRIBUTE13 = p_bwa_rec.ATTRIBUTE13
  ,   ATTRIBUTE14 = p_bwa_rec.ATTRIBUTE14
  ,   ATTRIBUTE15 = p_bwa_rec.ATTRIBUTE15
  ,   ATTRIBUTE_CATEGORY = p_bwa_rec.ATTRIBUTE_CATEGORY
  ,   SECURITY_GROUP_ID = p_bwa_rec.SECURITY_GROUP_ID
  ,   OBJECT_VERSION_NUMBER = l_object_version_number
  ,   APPLICATION_ID = p_bwa_rec.APPLICATION_ID
  WHERE WF_ATTR_VALUE_ID = p_bwa_rec.WF_ATTR_VALUE_ID;

Line: 378

    ROLLBACK TO Update_WFAttrValue_PVT;

Line: 386

    ROLLBACK TO Update_WFAttrValue_PVT;

Line: 394

    ROLLBACK TO Update_WFAttrValue_PVT;

Line: 406

END Update_WFAttrValue;

Line: 434

PROCEDURE Delete_WFAttrValue
( p_api_version      IN      NUMBER
, p_init_msg_list    IN      VARCHAR2 DEFAULT fnd_api.g_false
, p_commit           IN      VARCHAR2 DEFAULT fnd_api.g_false
, p_validation_level IN      NUMBER   DEFAULT fnd_api.g_valid_level_full
, x_return_status       OUT NOCOPY  VARCHAR2
, x_msg_count           OUT NOCOPY  NUMBER
, x_msg_data            OUT NOCOPY  VARCHAR2
, p_wf_attr_value_id IN      NUMBER
)
IS
  l_api_name      CONSTANT VARCHAR2(30) := 'Delete_WFAttrValue';

Line: 455

    SAVEPOINT Delete_WFAttrValue_PVT;

Line: 482

    DELETE FROM JTF_BRM_WF_ATTR_VALUES
    WHERE WF_ATTR_VALUE_ID = p_wf_attr_value_id;

Line: 505

      ROLLBACK TO Delete_WFAttrValue_PVT;

Line: 513

      ROLLBACK TO Delete_WFAttrValue_PVT;

Line: 521

      ROLLBACK TO Delete_WFAttrValue_PVT;

Line: 533

END Delete_WFAttrValue;