APPS.JTF_BRMEXPRESSIONLINE_PVT SQL Statements

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

Line: 47

  CURSOR C IS SELECT ROWID
              FROM   JTF_BRM_EXPRESSION_LINES
              WHERE  expression_line_id = l_expression_line_id;

Line: 89

    SELECT jtf_brm_expression_lines_s.NEXTVAL
    INTO   l_expression_line_id
    FROM   DUAL;

Line: 99

  INSERT INTO JTF_BRM_EXPRESSION_LINES
  ( EXPRESSION_LINE_ID
  , RULE_ID
  , CREATED_BY
  , CREATION_DATE
  , LAST_UPDATED_BY
  , LAST_UPDATE_DATE
  , LAST_UPDATE_LOGIN
  , SORT_SEQUENCE
  , BRM_LEFT_PARENTHESIS_TYPE
  , BRM_LEFT_PARENTHESIS_CODE
  , LEFT_VALUE
  , BRM_OPERATOR_TYPE
  , BRM_OPERATOR_CODE
  , RIGHT_VALUE
  , BRM_RIGHT_PARENTHESIS_TYPE
  , BRM_RIGHT_PARENTHESIS_CODE
  , BRM_BOOLEAN_OPERATOR_TYPE
  , BRM_BOOLEAN_OPERATOR_CODE
  , 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_expression_line_id
  , p_bel_rec.RULE_ID
  , p_bel_rec.CREATED_BY
  , p_bel_rec.CREATION_DATE
  , p_bel_rec.LAST_UPDATED_BY
  , p_bel_rec.LAST_UPDATE_DATE
  , p_bel_rec.LAST_UPDATE_LOGIN
  , p_bel_rec.SORT_SEQUENCE
  , p_bel_rec.BRM_LEFT_PARENTHESIS_TYPE
  , p_bel_rec.BRM_LEFT_PARENTHESIS_CODE
  , p_bel_rec.LEFT_VALUE
  , p_bel_rec.BRM_OPERATOR_TYPE
  , p_bel_rec.BRM_OPERATOR_CODE
  , p_bel_rec.RIGHT_VALUE
  , p_bel_rec.BRM_RIGHT_PARENTHESIS_TYPE
  , p_bel_rec.BRM_RIGHT_PARENTHESIS_CODE
  , p_bel_rec.BRM_BOOLEAN_OPERATOR_TYPE
  , p_bel_rec.BRM_BOOLEAN_OPERATOR_CODE
  , p_bel_rec.ATTRIBUTE1
  , p_bel_rec.ATTRIBUTE2
  , p_bel_rec.ATTRIBUTE3
  , p_bel_rec.ATTRIBUTE4
  , p_bel_rec.ATTRIBUTE5
  , p_bel_rec.ATTRIBUTE6
  , p_bel_rec.ATTRIBUTE7
  , p_bel_rec.ATTRIBUTE8
  , p_bel_rec.ATTRIBUTE9
  , p_bel_rec.ATTRIBUTE10
  , p_bel_rec.ATTRIBUTE11
  , p_bel_rec.ATTRIBUTE12
  , p_bel_rec.ATTRIBUTE13
  , p_bel_rec.ATTRIBUTE14
  , p_bel_rec.ATTRIBUTE15
  , p_bel_rec.ATTRIBUTE_CATEGORY
  , p_bel_rec.SECURITY_GROUP_ID
  , l_object_version_number
  , p_bel_rec.APPLICATION_ID
  );

Line: 261

PROCEDURE Update_ExpressionLine
( 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_bel_rec          IN     brm_expression_line_rec_type
)
IS
  l_api_name              CONSTANT VARCHAR2(30)    := 'Update_ExpressionLine';

Line: 282

  SAVEPOINT Update_ExpressionLine_PVT;

Line: 306

  SELECT jtf_brm_expression_lines_s.NEXTVAL
  INTO   l_object_version_number
  FROM   DUAL;

Line: 310

  UPDATE JTF_BRM_EXPRESSION_LINES
  SET RULE_ID = p_bel_rec.RULE_ID
  ,   LAST_UPDATED_BY = p_bel_rec.LAST_UPDATED_BY
  ,   LAST_UPDATE_DATE = p_bel_rec.LAST_UPDATE_DATE
  ,   LAST_UPDATE_LOGIN = p_bel_rec.LAST_UPDATE_LOGIN
  ,   SORT_SEQUENCE = p_bel_rec.SORT_SEQUENCE
  ,   BRM_LEFT_PARENTHESIS_TYPE = p_bel_rec.BRM_LEFT_PARENTHESIS_TYPE
  ,   BRM_LEFT_PARENTHESIS_CODE = p_bel_rec.BRM_LEFT_PARENTHESIS_CODE
  ,   LEFT_VALUE = p_bel_rec.LEFT_VALUE
  ,   BRM_OPERATOR_TYPE = p_bel_rec.BRM_OPERATOR_TYPE
  ,   BRM_OPERATOR_CODE = p_bel_rec.BRM_OPERATOR_CODE
  ,   RIGHT_VALUE = p_bel_rec.RIGHT_VALUE
  ,   BRM_RIGHT_PARENTHESIS_TYPE = p_bel_rec.BRM_RIGHT_PARENTHESIS_TYPE
  ,   BRM_RIGHT_PARENTHESIS_CODE = p_bel_rec.BRM_RIGHT_PARENTHESIS_CODE
  ,   BRM_BOOLEAN_OPERATOR_TYPE = p_bel_rec.BRM_BOOLEAN_OPERATOR_TYPE
  ,   BRM_BOOLEAN_OPERATOR_CODE = p_bel_rec.BRM_BOOLEAN_OPERATOR_CODE
  ,   ATTRIBUTE1 = p_bel_rec.ATTRIBUTE1
  ,   ATTRIBUTE2 = p_bel_rec.ATTRIBUTE2
  ,   ATTRIBUTE3 = p_bel_rec.ATTRIBUTE3
  ,   ATTRIBUTE4 = p_bel_rec.ATTRIBUTE4
  ,   ATTRIBUTE5 = p_bel_rec.ATTRIBUTE5
  ,   ATTRIBUTE6 = p_bel_rec.ATTRIBUTE6
  ,   ATTRIBUTE7 = p_bel_rec.ATTRIBUTE7
  ,   ATTRIBUTE8 = p_bel_rec.ATTRIBUTE8
  ,   ATTRIBUTE9 = p_bel_rec.ATTRIBUTE9
  ,   ATTRIBUTE10 = p_bel_rec.ATTRIBUTE10
  ,   ATTRIBUTE11 = p_bel_rec.ATTRIBUTE11
  ,   ATTRIBUTE12 = p_bel_rec.ATTRIBUTE12
  ,   ATTRIBUTE13 = p_bel_rec.ATTRIBUTE13
  ,   ATTRIBUTE14 = p_bel_rec.ATTRIBUTE14
  ,   ATTRIBUTE15 = p_bel_rec.ATTRIBUTE15
  ,   ATTRIBUTE_CATEGORY = p_bel_rec.ATTRIBUTE_CATEGORY
  ,   SECURITY_GROUP_ID = p_bel_rec.SECURITY_GROUP_ID
  ,   OBJECT_VERSION_NUMBER = l_object_version_number
  ,   APPLICATION_ID = p_bel_rec.APPLICATION_ID
  WHERE EXPRESSION_LINE_ID = p_bel_rec.EXPRESSION_LINE_ID;

Line: 373

    ROLLBACK TO Update_ExpressionLine_PVT;

Line: 381

    ROLLBACK TO Update_ExpressionLine_PVT;

Line: 389

    ROLLBACK TO Update_ExpressionLine_PVT;

Line: 401

END Update_ExpressionLine;

Line: 424

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

Line: 445

  SAVEPOINT Delete_ExpressionLine_PVT;

Line: 472

  DELETE FROM JTF_BRM_EXPRESSION_LINES
  WHERE expression_line_id = p_expression_line_id;

Line: 495

      ROLLBACK TO Delete_ExpressionLine_PVT;

Line: 503

      ROLLBACK TO Delete_ExpressionLine_PVT;

Line: 511

      ROLLBACK TO Delete_ExpressionLine_PVT;

Line: 523

END Delete_ExpressionLine;