APPS.JTF_BRMPARAMETER_PVT SQL Statements

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

Line: 51

  CURSOR c IS SELECT ROWID
              FROM   JTF_BRM_PARAMETERS
              WHERE  PARAMETER_ID = l_parameter_id;

Line: 95

  INSERT INTO JTF_BRM_PARAMETERS
  ( PARAMETER_ID
  , CREATED_BY
  , CREATION_DATE
  , LAST_UPDATED_BY
  , LAST_UPDATE_DATE
  , LAST_UPDATE_LOGIN
  , BRM_UOM_TYPE
  , BRM_UOM_CODE
  , BRM_INTERVAL
  , BRM_WF_COMMAND_TYPE
  , BRM_WF_COMMAND_CODE
  , WORKFLOW_PROCESS_ID
  , WORKFLOW_ITEM_TYPE
  , WORKFLOW_PROCESS_NAME
  , 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_parameter_id
  , p_bp_rec.CREATED_BY
  , p_bp_rec.CREATION_DATE
  , p_bp_rec.LAST_UPDATED_BY
  , p_bp_rec.LAST_UPDATE_DATE
  , p_bp_rec.LAST_UPDATE_LOGIN
  , p_bp_rec.BRM_UOM_TYPE
  , p_bp_rec.BRM_UOM_CODE
  , p_bp_rec.BRM_INTERVAL
  , p_bp_rec.BRM_WF_COMMAND_TYPE
  , p_bp_rec.BRM_WF_COMMAND_CODE
  , p_bp_rec.WORKFLOW_PROCESS_ID
  , p_bp_rec.WORKFLOW_ITEM_TYPE
  , p_bp_rec.WORKFLOW_PROCESS_NAME
  , p_bp_rec.ATTRIBUTE1
  , p_bp_rec.ATTRIBUTE2
  , p_bp_rec.ATTRIBUTE3
  , p_bp_rec.ATTRIBUTE4
  , p_bp_rec.ATTRIBUTE5
  , p_bp_rec.ATTRIBUTE6
  , p_bp_rec.ATTRIBUTE7
  , p_bp_rec.ATTRIBUTE8
  , p_bp_rec.ATTRIBUTE9
  , p_bp_rec.ATTRIBUTE10
  , p_bp_rec.ATTRIBUTE11
  , p_bp_rec.ATTRIBUTE12
  , p_bp_rec.ATTRIBUTE13
  , p_bp_rec.ATTRIBUTE14
  , p_bp_rec.ATTRIBUTE15
  , p_bp_rec.ATTRIBUTE_CATEGORY
  , p_bp_rec.SECURITY_GROUP_ID
  , l_object_version_number
  , p_bp_rec.APPLICATION_ID
  );

Line: 254

PROCEDURE Update_BRMParameter
( 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_bp_rec           IN     BRM_Parameter_rec_type
)
IS
  l_api_name              CONSTANT VARCHAR2(30)    := 'Update_BRMParameter';

Line: 277

  SAVEPOINT Update_BRMParameter_PVT;

Line: 307

  SELECT JTF_BRM_OBJECT_VERSION_S.NEXTVAL
  INTO l_object_version_number
  FROM DUAL;

Line: 311

  UPDATE JTF_BRM_PARAMETERS
  SET LAST_UPDATED_BY = p_bp_rec.LAST_UPDATED_BY
  ,   LAST_UPDATE_DATE = p_bp_rec.LAST_UPDATE_DATE
  ,   LAST_UPDATE_LOGIN = p_bp_rec.LAST_UPDATE_LOGIN
  ,   BRM_UOM_TYPE = p_bp_rec.BRM_UOM_TYPE
  ,   BRM_UOM_CODE = p_bp_rec.BRM_UOM_CODE
  ,   BRM_INTERVAL = p_bp_rec.BRM_INTERVAL
  ,   BRM_WF_COMMAND_TYPE = p_bp_rec.BRM_WF_COMMAND_TYPE
  ,   BRM_WF_COMMAND_CODE = p_bp_rec.BRM_WF_COMMAND_CODE
  ,   WORKFLOW_PROCESS_ID = p_bp_rec.WORKFLOW_PROCESS_ID
  ,   WORKFLOW_ITEM_TYPE = p_bp_rec.WORKFLOW_ITEM_TYPE
  ,   WORKFLOW_PROCESS_NAME = p_bp_rec.WORKFLOW_PROCESS_NAME
  ,   ATTRIBUTE1 = p_bp_rec.ATTRIBUTE1
  ,   ATTRIBUTE2 = p_bp_rec.ATTRIBUTE2
  ,   ATTRIBUTE3 = p_bp_rec.ATTRIBUTE3
  ,   ATTRIBUTE4 = p_bp_rec.ATTRIBUTE4
  ,   ATTRIBUTE5 = p_bp_rec.ATTRIBUTE5
  ,   ATTRIBUTE6 = p_bp_rec.ATTRIBUTE6
  ,   ATTRIBUTE7 = p_bp_rec.ATTRIBUTE7
  ,   ATTRIBUTE8 = p_bp_rec.ATTRIBUTE9
  ,   ATTRIBUTE9 = p_bp_rec.ATTRIBUTE9
  ,   ATTRIBUTE10 = p_bp_rec.ATTRIBUTE10
  ,   ATTRIBUTE11 = p_bp_rec.ATTRIBUTE11
  ,   ATTRIBUTE12 = p_bp_rec.ATTRIBUTE12
  ,   ATTRIBUTE13 = p_bp_rec.ATTRIBUTE13
  ,   ATTRIBUTE14 = p_bp_rec.ATTRIBUTE14
  ,   ATTRIBUTE15 = p_bp_rec.ATTRIBUTE15
  ,   ATTRIBUTE_CATEGORY = p_bp_rec.ATTRIBUTE_CATEGORY
  ,   SECURITY_GROUP_ID = p_bp_rec.SECURITY_GROUP_ID
  ,   OBJECT_VERSION_NUMBER = l_object_version_number
  ,   APPLICATION_ID = p_bp_rec.APPLICATION_ID
  WHERE PARAMETER_ID = p_bp_rec.PARAMETER_ID;

Line: 370

    ROLLBACK TO Update_BRMParameter_PVT;

Line: 378

    ROLLBACK TO Update_BRMParameter_PVT;

Line: 386

    ROLLBACK TO Update_BRMParameter_PVT;

Line: 398

END Update_BRMParameter;

Line: 424

PROCEDURE Delete_BRMParameter
( 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_parameter_id     IN     NUMBER
)
IS
  l_api_name      CONSTANT VARCHAR2(30) := 'Delete_BRMParameter';

Line: 445

    SAVEPOINT Delete_BRMParameter_PVT;

Line: 472

    DELETE FROM JTF_BRM_PARAMETERS
    WHERE PARAMETER_ID = p_parameter_id;

Line: 492

      ROLLBACK TO Delete_BRMParameter_PVT;

Line: 500

      ROLLBACK TO Delete_BRMParameter_PVT;

Line: 508

      ROLLBACK TO Delete_BRMParameter_PVT;

Line: 520

END Delete_BRMParameter;