APPS.JTF_BRMPROCESS_PVT SQL Statements

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

Line: 51

  CURSOR C IS SELECT ROWID
              FROM JTF_BRM_PROCESSES
              WHERE PROCESS_ID = l_process_id;

Line: 93

    SELECT JTF_BRM_PROCESSES_S.NEXTVAL INTO l_Process_id
    FROM DUAL;

Line: 102

  INSERT INTO JTF_BRM_PROCESSES
  ( PROCESS_ID
  , RULE_ID
  , CREATED_BY
  , CREATION_DATE
  , LAST_UPDATED_BY
  , LAST_UPDATE_DATE
  , LAST_UPDATE_LOGIN
  , SEEDED_FLAG
  , LAST_BRM_CHECK_DATE
  , BRM_UOM_TYPE
  , BRM_CHECK_UOM_CODE
  , BRM_CHECK_INTERVAL
  , BRM_TOLERANCE_UOM_CODE
  , BRM_TOLERANCE_INTERVAL
  , WORKFLOW_ITEM_TYPE
  , WORKFLOW_PROCESS_NAME
  , START_DATE_ACTIVE
  , END_DATE_ACTIVE
  , 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_process_id
  , p_bpr_rec.RULE_ID
  , p_bpr_rec.CREATED_BY
  , p_bpr_rec.CREATION_DATE
  , p_bpr_rec.LAST_UPDATED_BY
  , p_bpr_rec.LAST_UPDATE_DATE
  , p_bpr_rec.LAST_UPDATE_LOGIN
  , p_bpr_rec.SEEDED_FLAG
  , p_bpr_rec.LAST_BRM_CHECK_DATE
  , p_bpr_rec.BRM_UOM_TYPE
  , p_bpr_rec.BRM_CHECK_UOM_CODE
  , p_bpr_rec.BRM_CHECK_INTERVAL
  , p_bpr_rec.BRM_TOLERANCE_UOM_CODE
  , p_bpr_rec.BRM_TOLERANCE_INTERVAL
  , p_bpr_rec.WORKFLOW_ITEM_TYPE
  , p_bpr_rec.WORKFLOW_PROCESS_NAME
  , p_bpr_rec.START_DATE_ACTIVE
  , p_bpr_rec.END_DATE_ACTIVE
  , p_bpr_rec.ATTRIBUTE1
  , p_bpr_rec.ATTRIBUTE2
  , p_bpr_rec.ATTRIBUTE3
  , p_bpr_rec.ATTRIBUTE4
  , p_bpr_rec.ATTRIBUTE5
  , p_bpr_rec.ATTRIBUTE6
  , p_bpr_rec.ATTRIBUTE7
  , p_bpr_rec.ATTRIBUTE8
  , p_bpr_rec.ATTRIBUTE9
  , p_bpr_rec.ATTRIBUTE10
  , p_bpr_rec.ATTRIBUTE11
  , p_bpr_rec.ATTRIBUTE12
  , p_bpr_rec.ATTRIBUTE13
  , p_bpr_rec.ATTRIBUTE14
  , p_bpr_rec.ATTRIBUTE15
  , p_bpr_rec.ATTRIBUTE_CATEGORY
  , p_bpr_rec.SECURITY_GROUP_ID
  , l_object_version_number
  , p_bpr_rec.APPLICATION_ID
  );

Line: 270

PROCEDURE Update_BRMProcess
( 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_bpr_rec          IN     BRM_Process_rec_type
)
IS
  l_api_name               CONSTANT VARCHAR2(30)    := 'Update_BRMProcess';

Line: 293

  SAVEPOINT Update_BRMProcess_PVT;

Line: 322

  SELECT JTF_BRM_OBJECT_VERSION_S.NEXTVAL
  INTO l_object_version_number
  FROM DUAL;

Line: 326

  UPDATE JTF_BRM_PROCESSES
  SET RULE_ID = p_bpr_rec.RULE_ID
  ,   LAST_UPDATED_BY = p_bpr_rec.LAST_UPDATED_BY
  ,   LAST_UPDATE_DATE = p_bpr_rec.LAST_UPDATE_DATE
  ,   LAST_UPDATE_LOGIN = p_bpr_rec.LAST_UPDATE_LOGIN
  ,   SEEDED_FLAG = p_bpr_rec.SEEDED_FLAG
  ,   LAST_BRM_CHECK_DATE = p_bpr_rec.LAST_BRM_CHECK_DATE
  ,   BRM_UOM_TYPE = p_bpr_rec.BRM_UOM_TYPE
  ,   BRM_CHECK_UOM_CODE = p_bpr_rec.BRM_CHECK_UOM_CODE
  ,   BRM_CHECK_INTERVAL = p_bpr_rec.BRM_CHECK_INTERVAL
  ,   BRM_TOLERANCE_UOM_CODE = p_bpr_rec.BRM_TOLERANCE_UOM_CODE
  ,   BRM_TOLERANCE_INTERVAL = p_bpr_rec.BRM_TOLERANCE_INTERVAL
  ,   WORKFLOW_ITEM_TYPE = p_bpr_rec.WORKFLOW_ITEM_TYPE
  ,   WORKFLOW_PROCESS_NAME = p_bpr_rec.WORKFLOW_PROCESS_NAME
  ,   START_DATE_ACTIVE = p_bpr_rec.START_DATE_ACTIVE
  ,   END_DATE_ACTIVE = p_bpr_rec.END_DATE_ACTIVE
  ,   ATTRIBUTE1 = p_bpr_rec.ATTRIBUTE1
  ,   ATTRIBUTE2 = p_bpr_rec.ATTRIBUTE2
  ,   ATTRIBUTE3 = p_bpr_rec.ATTRIBUTE3
  ,   ATTRIBUTE4 = p_bpr_rec.ATTRIBUTE4
  ,   ATTRIBUTE5 = p_bpr_rec.ATTRIBUTE5
  ,   ATTRIBUTE6 = p_bpr_rec.ATTRIBUTE6
  ,   ATTRIBUTE7 = p_bpr_rec.ATTRIBUTE7
  ,   ATTRIBUTE8 = p_bpr_rec.ATTRIBUTE8
  ,   ATTRIBUTE9 = p_bpr_rec.ATTRIBUTE9
  ,   ATTRIBUTE10 = p_bpr_rec.ATTRIBUTE10
  ,   ATTRIBUTE11 = p_bpr_rec.ATTRIBUTE11
  ,   ATTRIBUTE12 = p_bpr_rec.ATTRIBUTE12
  ,   ATTRIBUTE13 = p_bpr_rec.ATTRIBUTE13
  ,   ATTRIBUTE14 = p_bpr_rec.ATTRIBUTE14
  ,   ATTRIBUTE15 = p_bpr_rec.ATTRIBUTE15
  ,   ATTRIBUTE_CATEGORY = p_bpr_rec.ATTRIBUTE_CATEGORY
  ,   SECURITY_GROUP_ID = p_bpr_rec.SECURITY_GROUP_ID
  ,   OBJECT_VERSION_NUMBER = l_object_version_number
  ,   APPLICATION_ID = p_bpr_rec.APPLICATION_ID
  WHERE PROCESS_ID = p_bpr_rec.process_id;

Line: 389

    ROLLBACK TO Update_BRMProcess_PVT;

Line: 397

    ROLLBACK TO Update_BRMProcess_PVT;

Line: 405

    ROLLBACK TO Update_BRMProcess_PVT;

Line: 416

END Update_BRMProcess;

Line: 445

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

Line: 466

    SAVEPOINT Delete_BRMProcess_PVT;

Line: 492

    DELETE FROM JTF_BRM_PROCESSES
    WHERE PROCESS_ID = p_process_id;

Line: 515

      ROLLBACK TO Delete_BRMProcess_PVT;

Line: 523

      ROLLBACK TO Delete_BRMProcess_PVT;

Line: 531

      ROLLBACK TO Delete_BRMProcess_PVT;

Line: 544

END Delete_BRMProcess;