APPS.JTF_TASK_CUSTOM_COLORS_PKG SQL Statements

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

Line: 3

    procedure INSERT_ROW (
      X_ROWID in out nocopy VARCHAR2,
      X_RULE_ID in NUMBER,
      X_COLOR_DETERMINATION_PRIORITY in NUMBER,
      X_TYPE_ID in NUMBER,
      X_PRIORITY_ID in NUMBER,
      X_ASSIGNMENT_STATUS_ID in NUMBER,
      X_ESCALATED_TASK in VARCHAR2,
      X_ACTIVE_FLAG in VARCHAR2,
      X_BACKGROUND_COL_DEC in NUMBER,
      X_BACKGROUND_COL_RGB in VARCHAR2,
      X_CREATION_DATE in DATE,
      X_CREATED_BY in NUMBER,
      X_LAST_UPDATE_DATE in DATE,
      X_LAST_UPDATED_BY in NUMBER,
      X_LAST_UPDATE_LOGIN in NUMBER
    ) is
      cursor C is select ROWID from JTF_TASK_CUSTOM_COLORS
        where RULE_ID = X_RULE_ID
        ;

Line: 24

      insert into JTF_TASK_CUSTOM_COLORS (
        RULE_ID,
        OBJECT_VERSION_NUMBER,
        COLOR_DETERMINATION_PRIORITY,
        TYPE_ID,
        PRIORITY_ID,
        ASSIGNMENT_STATUS_ID,
        ESCALATED_TASK,
        BACKGROUND_COL_DEC,
        BACKGROUND_COL_RGB,
        ACTIVE_FLAG,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN
      ) values (
        X_RULE_ID,
        1,
        X_COLOR_DETERMINATION_PRIORITY,
        X_TYPE_ID,
        X_PRIORITY_ID,
        X_ASSIGNMENT_STATUS_ID,
        X_ESCALATED_TASK,
        X_BACKGROUND_COL_DEC,
        X_BACKGROUND_COL_RGB,
        X_ACTIVE_FLAG,
        X_CREATED_BY,
        X_CREATION_DATE,
        X_LAST_UPDATED_BY,
        X_LAST_UPDATE_DATE,
        X_LAST_UPDATE_LOGIN
        );

Line: 66

    end INSERT_ROW;

Line: 72

      cursor c1 is select
          OBJECT_VERSION_NUMBER
        from JTF_TASK_CUSTOM_COLORS
        where RULE_ID = X_RULE_ID
        for update of RULE_ID nowait;

Line: 108

    procedure UPDATE_ROW (
      X_RULE_ID in NUMBER,
      X_OBJECT_VERSION_NUMBER in NUMBER,
      X_COLOR_DETERMINATION_PRIORITY in NUMBER,
      X_TYPE_ID in NUMBER,
      X_PRIORITY_ID in NUMBER,
      X_ASSIGNMENT_STATUS_ID in NUMBER,
      X_ESCALATED_TASK in VARCHAR2,
      X_ACTIVE_FLAG in VARCHAR2,
      X_BACKGROUND_COL_DEC in NUMBER,
      X_BACKGROUND_COL_RGB in VARCHAR2,
      X_LAST_UPDATE_DATE in DATE,
      X_LAST_UPDATED_BY in NUMBER,
      X_LAST_UPDATE_LOGIN in NUMBER
    ) is
    begin
      update JTF_TASK_CUSTOM_COLORS set
        OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
        COLOR_DETERMINATION_PRIORITY = X_COLOR_DETERMINATION_PRIORITY,
        TYPE_ID = X_TYPE_ID,
        PRIORITY_ID = X_PRIORITY_ID,
        ASSIGNMENT_STATUS_ID = X_ASSIGNMENT_STATUS_ID,
        ESCALATED_TASK = X_ESCALATED_TASK,
        ACTIVE_FLAG = X_ACTIVE_FLAG,
        BACKGROUND_COL_DEC = X_BACKGROUND_COL_DEC,
        BACKGROUND_COL_RGB = X_BACKGROUND_COL_RGB,
        LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
        LAST_UPDATED_BY = X_LAST_UPDATED_BY,
        LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
      where RULE_ID = X_RULE_ID;

Line: 142

    end UPDATE_ROW;

Line: 144

    procedure DELETE_ROW (
      X_RULE_ID in NUMBER
    ) is
    begin
      delete from JTF_TASK_CUSTOM_COLORS
      where RULE_ID = X_RULE_ID;

Line: 155

    end DELETE_ROW;