APPS.PA_ROLE_LISTS_PVT SQL Statements

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

Line: 4

procedure INSERT_ROW (
  P_ROWID in out NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
  P_ROLE_LIST_ID NUMBER,
  P_NAME VARCHAR2,
  P_START_DATE_ACTIVE DATE,
  P_END_DATE_ACTIVE DATE,
  P_DESCRIPTION VARCHAR2,
  P_ATTRIBUTE_CATEGORY VARCHAR2,
  P_ATTRIBUTE1 VARCHAR2,
  P_ATTRIBUTE2 VARCHAR2,
  P_ATTRIBUTE3 VARCHAR2,
  P_ATTRIBUTE4 VARCHAR2,
  P_ATTRIBUTE5 VARCHAR2,
  P_ATTRIBUTE6 VARCHAR2,
  P_ATTRIBUTE7 VARCHAR2,
  P_ATTRIBUTE8 VARCHAR2,
  P_ATTRIBUTE9 VARCHAR2,
  P_ATTRIBUTE10 VARCHAR2,
  P_ATTRIBUTE11 VARCHAR2,
  P_ATTRIBUTE12 VARCHAR2,
  P_ATTRIBUTE13 VARCHAR2,
  P_ATTRIBUTE14 VARCHAR2,
  P_ATTRIBUTE15 VARCHAR2,
  P_CREATION_DATE DATE,
  P_CREATED_BY NUMBER,
  P_LAST_UPDATE_DATE DATE,
  P_LAST_UPDATED_BY NUMBER,
  P_LAST_UPDATE_LOGIN NUMBER,
  X_RETURN_STATUS out NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
  X_MSG_COUNT out NOCOPY NUMBER, --File.Sql.39 bug 4440895
  X_MSG_DATA out NOCOPY VARCHAR2  --File.Sql.39 bug 4440895
) is
begin
  PA_DEBUG.init_err_stack('PA_ROLE_LISTS_PVT.INSERT_ROW');

Line: 47

    PA_ROLE_LISTS_PKG.INSERT_ROW(
      P_ROWID,
      P_ROLE_LIST_ID,
      P_NAME,
      P_START_DATE_ACTIVE,
      P_END_DATE_ACTIVE,
      P_DESCRIPTION,
      P_ATTRIBUTE_CATEGORY,
      P_ATTRIBUTE1,
      P_ATTRIBUTE2,
      P_ATTRIBUTE3,
      P_ATTRIBUTE4,
      P_ATTRIBUTE5,
      P_ATTRIBUTE6,
      P_ATTRIBUTE7,
      P_ATTRIBUTE8,
      P_ATTRIBUTE9,
      P_ATTRIBUTE10,
      P_ATTRIBUTE11,
      P_ATTRIBUTE12,
      P_ATTRIBUTE13,
      P_ATTRIBUTE14,
      P_ATTRIBUTE15,
      P_CREATION_DATE,
      P_CREATED_BY,
      P_LAST_UPDATE_DATE,
      P_LAST_UPDATED_BY,
      P_LAST_UPDATE_LOGIN);

Line: 132

procedure UPDATE_ROW (
  P_ROWID in out NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
  P_ROLE_LIST_ID NUMBER,
  P_NAME VARCHAR2,
  P_START_DATE_ACTIVE DATE,
  P_END_DATE_ACTIVE DATE,
  P_DESCRIPTION VARCHAR2,
  P_ATTRIBUTE_CATEGORY VARCHAR2,
  P_ATTRIBUTE1 VARCHAR2,
  P_ATTRIBUTE2 VARCHAR2,
  P_ATTRIBUTE3 VARCHAR2,
  P_ATTRIBUTE4 VARCHAR2,
  P_ATTRIBUTE5 VARCHAR2,
  P_ATTRIBUTE6 VARCHAR2,
  P_ATTRIBUTE7 VARCHAR2,
  P_ATTRIBUTE8 VARCHAR2,
  P_ATTRIBUTE9 VARCHAR2,
  P_ATTRIBUTE10 VARCHAR2,
  P_ATTRIBUTE11 VARCHAR2,
  P_ATTRIBUTE12 VARCHAR2,
  P_ATTRIBUTE13 VARCHAR2,
  P_ATTRIBUTE14 VARCHAR2,
  P_ATTRIBUTE15 VARCHAR2,
  P_CREATION_DATE DATE,
  P_CREATED_BY NUMBER,
  P_LAST_UPDATE_DATE DATE,
  P_LAST_UPDATED_BY NUMBER,
  P_LAST_UPDATE_LOGIN NUMBER,
  X_RETURN_STATUS out NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
  X_MSG_COUNT out NOCOPY NUMBER, --File.Sql.39 bug 4440895
  X_MSG_DATA out NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
) is
  v_name  PA_ROLE_LISTS.name%TYPE;

Line: 166

  PA_DEBUG.init_err_stack('PA_ROLE_LISTS_PVT.UPDATE_ROW');

Line: 168

  select name
  into v_name
  from pa_role_lists
  where rowid = p_rowid;

Line: 185

    PA_ROLE_LISTS_PKG.UPDATE_ROW(
      P_ROWID,
      P_ROLE_LIST_ID,
      P_NAME,
      P_START_DATE_ACTIVE,
      P_END_DATE_ACTIVE,
      P_DESCRIPTION,
      P_ATTRIBUTE_CATEGORY,
      P_ATTRIBUTE1,
      P_ATTRIBUTE2,
      P_ATTRIBUTE3,
      P_ATTRIBUTE4,
      P_ATTRIBUTE5,
      P_ATTRIBUTE6,
      P_ATTRIBUTE7,
      P_ATTRIBUTE8,
      P_ATTRIBUTE9,
      P_ATTRIBUTE10,
      P_ATTRIBUTE11,
      P_ATTRIBUTE12,
      P_ATTRIBUTE13,
      P_ATTRIBUTE14,
      P_ATTRIBUTE15,
      P_CREATION_DATE,
      P_CREATED_BY,
      P_LAST_UPDATE_DATE,
      P_LAST_UPDATED_BY,
      P_LAST_UPDATE_LOGIN);

Line: 238

procedure DELETE_ROW (
  P_ROWID VARCHAR2,
  X_RETURN_STATUS out NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
  X_MSG_COUNT out NOCOPY NUMBER, --File.Sql.39 bug 4440895
  X_MSG_DATA out NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
) is
 v_role_list_id  number;

Line: 246

  PA_DEBUG.init_err_stack('PA_ROLE_LISTS_PVT.DELETE_ROW');

Line: 248

  select role_list_id
  into v_role_list_id
  from pa_role_lists
  where rowid = P_ROWID;

Line: 253

  PA_ROLE_UTILS.CHECK_DELETE_ROLE_LIST_OK(
    v_role_list_id,
    X_RETURN_STATUS,
    X_MSG_DATA);

Line: 260

    PA_ROLE_LISTS_PKG.DELETE_ROW(P_ROWID);

Line: 262

    delete from PA_ROLE_LIST_MEMBERS
    where ROLE_LIST_ID = v_role_list_id;