APPS.EGO_OBJ_TYPE_LIFECYCLES_PUB SQL Statements

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

Line: 68

    SELECT COUNT (*) INTO l_count
    FROM
      EGO_OBJ_TYPE_LIFECYCLES
    WHERE
      OBJECT_ID = p_object_id
      AND OBJECT_CLASSIFICATION_CODE = p_object_classification_code
      AND LIFECYCLE_ID = p_lifecycle_id;

Line: 81

    INSERT INTO EGO_OBJ_TYPE_LIFECYCLES
    (
          OBJECT_ID
        , OBJECT_CLASSIFICATION_CODE
        , LIFECYCLE_ID
        , CREATED_BY
        , CREATION_DATE
        , LAST_UPDATED_BY
        , LAST_UPDATE_DATE
        , LAST_UPDATE_LOGIN
    )
    VALUES
    (
          p_object_id
        , p_object_classification_code
        , p_lifecycle_id
        , g_current_user_id
        , l_Sysdate
        , g_current_user_id
        , l_Sysdate
        , g_current_login_id
    );

Line: 180

PROCEDURE Delete_Obj_Type_Lifecycle(
          p_api_version                 IN   NUMBER
        , p_object_id                   IN   NUMBER
        , p_object_classification_code  IN   VARCHAR2
        , p_lifecycle_id                IN   NUMBER
        , p_init_msg_list               IN   VARCHAR2   := fnd_api.g_FALSE
        , p_commit                      IN   VARCHAR2   := fnd_api.g_FALSE
        , x_return_status               OUT  NOCOPY VARCHAR2
        , x_errorcode                   OUT  NOCOPY NUMBER
        , x_msg_count                   OUT  NOCOPY NUMBER
        , x_msg_data                    OUT  NOCOPY VARCHAR2
) IS

  l_api_name           CONSTANT VARCHAR2(30)   := 'Delete_Obj_Type_Lifecycle';

Line: 208

  SAVEPOINT   Delete_Obj_Type_Lifecycle_PUB;

Line: 226

  DELETE FROM EGO_OBJ_TYPE_LIFECYCLES
  WHERE
    OBJECT_ID = p_object_id
    AND OBJECT_CLASSIFICATION_CODE = p_object_classification_code
    AND LIFECYCLE_ID = p_lifecycle_id;

Line: 255

      ROLLBACK TO Delete_Obj_Type_Lifecycle_PUB;

Line: 270

END Delete_Obj_Type_Lifecycle;