APPS.PA_ROLE_LIST_MEMBERS_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_PROJECT_ROLE_ID NUMBER,
  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_LIST_MEMBERS_PVT.INSERT_ROW');

Line: 21

  PA_ROLE_LIST_MEMBERS_PKG.INSERT_ROW(
    P_ROWID,
    P_ROLE_LIST_ID,
    P_PROJECT_ROLE_ID,
    P_CREATION_DATE,
    P_CREATED_BY,
    P_LAST_UPDATE_DATE,
    P_LAST_UPDATED_BY,
    P_LAST_UPDATE_LOGIN);

Line: 80

procedure UPDATE_ROW (
  P_ROWID in out NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
  P_ROLE_LIST_ID NUMBER,
  P_PROJECT_ROLE_ID 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_LIST_MEMBERS_PVT.UPDATE_ROW');

Line: 97

  PA_ROLE_LIST_MEMBERS_PKG.UPDATE_ROW(
    P_ROWID,
    P_ROLE_LIST_ID,
    P_PROJECT_ROLE_ID,
    P_CREATION_DATE,
    P_CREATED_BY,
    P_LAST_UPDATE_DATE,
    P_LAST_UPDATED_BY,
    P_LAST_UPDATE_LOGIN);

Line: 124

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: 132

  PA_DEBUG.init_err_stack('PA_ROLE_LIST_MEMBERS_PVT.DELETE_ROW');

Line: 135

  PA_ROLE_LIST_MEMBERS_PKG.DELETE_ROW(P_ROWID);