APPS.PN_SET_MILESTONES_PKG SQL Statements

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

Line: 4

procedure INSERT_ROW (
                       X_ROWID                in out NOCOPY VARCHAR2,
                       X_MILESTONES_SET_ID    in out NOCOPY NUMBER,
                       X_SET_ID               in NUMBER,
                       X_USER_ID              in NUMBER,
                       X_NOTIFICATION_DATE    in DATE,
                       X_LEAD_DAYS            in NUMBER,
                       X_ATTRIBUTE_CATEGORY   in VARCHAR2,
                       X_ATTRIBUTE1           in VARCHAR2,
                       X_ATTRIBUTE2           in VARCHAR2,
                       X_ATTRIBUTE3           in VARCHAR2,
                       X_ATTRIBUTE4           in VARCHAR2,
                       X_ATTRIBUTE5           in VARCHAR2,
                       X_ATTRIBUTE6           in VARCHAR2,
                       X_ATTRIBUTE7           in VARCHAR2,
                       X_ATTRIBUTE8           in VARCHAR2,
                       X_ATTRIBUTE9           in VARCHAR2,
                       X_ATTRIBUTE10          in VARCHAR2,
                       X_ATTRIBUTE11          in VARCHAR2,
                       X_ATTRIBUTE12          in VARCHAR2,
                       X_ATTRIBUTE13          in VARCHAR2,
                       X_ATTRIBUTE14          in VARCHAR2,
                       X_ATTRIBUTE15          in VARCHAR2,
                       X_MILESTONE_TYPE_CODE  in VARCHAR2,
                       X_FREQUENCY            in NUMBER,
                       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   PN_SET_MILESTONES
  where MILESTONES_SET_ID = X_MILESTONES_SET_ID ;

Line: 44

    select PN_SET_MILESTONES_S.nextval
    into   X_MILESTONES_SET_ID
    from   dual;

Line: 50

  insert into PN_SET_MILESTONES (
                                  MILESTONES_SET_ID,
                                  SET_ID,
                                  LAST_UPDATE_DATE,
                                  LAST_UPDATED_BY,
                                  CREATION_DATE,
                                  CREATED_BY,
                                  LAST_UPDATE_LOGIN,
                                  MILESTONE_TYPE_CODE,
                                  USER_ID,
                                  NOTIFICATION_DATE,
                                  LEAD_DAYS,
                                  FREQUENCY,
                                  ATTRIBUTE_CATEGORY,
                                  ATTRIBUTE1,
                                  ATTRIBUTE2,
                                  ATTRIBUTE3,
                                  ATTRIBUTE4,
                                  ATTRIBUTE5,
                                  ATTRIBUTE6,
                                  ATTRIBUTE7,
                                  ATTRIBUTE8,
                                  ATTRIBUTE9,
                                  ATTRIBUTE10,
                                  ATTRIBUTE11,
                                  ATTRIBUTE12,
                                  ATTRIBUTE13,
                                  ATTRIBUTE14,
                                  ATTRIBUTE15
                                )
  values                        (
                                  X_MILESTONES_SET_ID,
                                  X_SET_ID,
                                  X_LAST_UPDATE_DATE,
                                  X_LAST_UPDATED_BY,
                                  X_CREATION_DATE,
                                  X_CREATED_BY,
                                  X_LAST_UPDATE_LOGIN,
                                  X_MILESTONE_TYPE_CODE,
                                  X_USER_ID,
                                  X_NOTIFICATION_DATE,
                                  X_LEAD_DAYS,
                                  X_FREQUENCY,
                                  X_ATTRIBUTE_CATEGORY,
                                  X_ATTRIBUTE1,
                                  X_ATTRIBUTE2,
                                  X_ATTRIBUTE3,
                                  X_ATTRIBUTE4,
                                  X_ATTRIBUTE5,
                                  X_ATTRIBUTE6,
                                  X_ATTRIBUTE7,
                                  X_ATTRIBUTE8,
                                  X_ATTRIBUTE9,
                                  X_ATTRIBUTE10,
                                  X_ATTRIBUTE11,
                                  X_ATTRIBUTE12,
                                  X_ATTRIBUTE13,
                                  X_ATTRIBUTE14,
                                  X_ATTRIBUTE15
                                );

Line: 119

end INSERT_ROW;

Line: 147

  select *
  from   PN_SET_MILESTONES
  where  MILESTONES_SET_ID = X_MILESTONES_SET_ID
  for    update of MILESTONES_SET_ID nowait;

Line: 214

procedure UPDATE_ROW (
                       X_MILESTONES_SET_ID    in NUMBER,
                       X_SET_ID               in NUMBER,
                       X_USER_ID              in NUMBER,
                       X_NOTIFICATION_DATE    in DATE,
                       X_LEAD_DAYS            in NUMBER,
                       X_ATTRIBUTE_CATEGORY   in VARCHAR2,
                       X_ATTRIBUTE1           in VARCHAR2,
                       X_ATTRIBUTE2           in VARCHAR2,
                       X_ATTRIBUTE3           in VARCHAR2,
                       X_ATTRIBUTE4           in VARCHAR2,
                       X_ATTRIBUTE5           in VARCHAR2,
                       X_ATTRIBUTE6           in VARCHAR2,
                       X_ATTRIBUTE7           in VARCHAR2,
                       X_ATTRIBUTE8           in VARCHAR2,
                       X_ATTRIBUTE9           in VARCHAR2,
                       X_ATTRIBUTE10          in VARCHAR2,
                       X_ATTRIBUTE11          in VARCHAR2,
                       X_ATTRIBUTE12          in VARCHAR2,
                       X_ATTRIBUTE13          in VARCHAR2,
                       X_ATTRIBUTE14          in VARCHAR2,
                       X_ATTRIBUTE15          in VARCHAR2,
                       X_MILESTONE_TYPE_CODE  in VARCHAR2,
                       X_FREQUENCY            in NUMBER,
                       X_LAST_UPDATE_DATE     in DATE,
                       X_LAST_UPDATED_BY      in NUMBER,
                       X_LAST_UPDATE_LOGIN    in NUMBER
                     ) IS
begin

  update PN_SET_MILESTONES
  set
         USER_ID             = X_USER_ID,
         NOTIFICATION_DATE   = X_NOTIFICATION_DATE,
         LEAD_DAYS           = X_LEAD_DAYS,
         ATTRIBUTE_CATEGORY  = X_ATTRIBUTE_CATEGORY,
         ATTRIBUTE1          = X_ATTRIBUTE1,
         ATTRIBUTE2          = X_ATTRIBUTE2,
         ATTRIBUTE3          = X_ATTRIBUTE3,
         ATTRIBUTE4          = X_ATTRIBUTE4,
         ATTRIBUTE5          = X_ATTRIBUTE5,
         ATTRIBUTE6          = X_ATTRIBUTE6,
         ATTRIBUTE7          = X_ATTRIBUTE7,
         ATTRIBUTE8          = X_ATTRIBUTE8,
         ATTRIBUTE9          = X_ATTRIBUTE9,
         ATTRIBUTE10         = X_ATTRIBUTE10,
         ATTRIBUTE11         = X_ATTRIBUTE11,
         ATTRIBUTE12         = X_ATTRIBUTE12,
         ATTRIBUTE13         = X_ATTRIBUTE13,
         ATTRIBUTE14         = X_ATTRIBUTE14,
         ATTRIBUTE15         = X_ATTRIBUTE15,
         MILESTONE_TYPE_CODE = X_MILESTONE_TYPE_CODE,
         FREQUENCY           = X_FREQUENCY,
         LAST_UPDATE_DATE    = X_LAST_UPDATE_DATE,
         LAST_UPDATED_BY     = X_LAST_UPDATED_BY,
         LAST_UPDATE_LOGIN   = X_LAST_UPDATE_LOGIN
  where  MILESTONES_SET_ID   = X_MILESTONES_SET_ID;

Line: 275

end UPDATE_ROW;

Line: 277

procedure DELETE_ROW (
                       X_MILESTONES_SET_ID in NUMBER
                     ) IS
begin

  delete from PN_SET_MILESTONES
  where MILESTONES_SET_ID = X_MILESTONES_SET_ID;

Line: 289

end DELETE_ROW;