eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PR_MILESTONE_HST_PKG SQL Statements

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

Line: 28


    x_last_update_date IN DATE DEFAULT NULL,
    x_last_updated_by IN NUMBER DEFAULT NULL,
    x_last_update_login IN NUMBER DEFAULT NULL,
    x_org_id IN NUMBER DEFAULT NULL
  ) AS

    CURSOR cur_old_ref_values IS
      SELECT   *
      FROM     IGS_PR_MILESTONE_HST_ALL
      WHERE    rowid = x_rowid;

Line: 47


    IF (cur_old_ref_values%NOTFOUND) AND (p_action not in ('INSERT','VALIDATE_INSERT')) THEN
      Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

Line: 74


    IF (p_action = 'UPDATE') THEN
      new_references.creation_date := old_references.creation_date;

Line: 81


    new_references.last_update_date := x_last_update_date;

Line: 82


    new_references.last_updated_by := x_last_updated_by;

Line: 83


    new_references.last_update_login := x_last_update_login;

Line: 96


      SELECT   rowid
      FROM     IGS_PR_MILESTONE_HST_ALL
      WHERE    person_id = x_person_id
      AND      ca_sequence_number = x_ca_sequence_number
      AND      sequence_number = x_sequence_number
      AND      hist_start_dt = x_hist_start_dt
      FOR UPDATE NOWAIT;

Line: 141


    x_last_update_date IN DATE DEFAULT NULL,
    x_last_updated_by IN NUMBER DEFAULT NULL,
    x_last_update_login IN NUMBER DEFAULT NULL,
    x_org_id IN NUMBER DEFAULT NULL
  ) AS
  BEGIN

    Set_Column_Values (
      p_action,
      x_rowid,
      x_person_id,
      x_ca_sequence_number,
      x_sequence_number,
      x_hist_start_dt,
      x_hist_end_dt,
      x_hist_who,
      x_milestone_type,
      x_milestone_status,
      x_due_dt,
      x_description,
      x_actual_reached_dt,
      x_preced_sequence_number,
      x_ovrd_ntfctn_imminent_days,
      x_ovrd_ntfctn_reminder_days,
      x_ovrd_ntfctn_re_reminder_days,
      x_comments,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login,
      x_org_id
    );

Line: 175


    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to Before Insert.
	IF Get_PK_For_Validation (
         new_references.person_id ,
         new_references.ca_sequence_number,
         new_references.sequence_number,
         new_references.hist_start_dt
         ) THEN
         Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');

Line: 188


    ELSIF (p_action = 'UPDATE') THEN
      -- Call all the procedures related to Before Update.
      Check_Constraints;

Line: 191


    ELSIF (p_action = 'VALIDATE_INSERT') THEN
      -- Call all the procedures related to Before Insert.
	IF Get_PK_For_Validation (
         new_references.person_id ,
         new_references.ca_sequence_number,
         new_references.sequence_number,
         new_references.hist_start_dt
         ) THEN
         Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');

Line: 204


    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      -- Call all the procedures related to Before Update.
      Check_Constraints;

Line: 211


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_PERSON_ID in NUMBER,
  X_CA_SEQUENCE_NUMBER in NUMBER,
  X_SEQUENCE_NUMBER in NUMBER,
  X_HIST_START_DT in DATE,
  X_HIST_END_DT in DATE,
  X_HIST_WHO in NUMBER,
  X_MILESTONE_TYPE in VARCHAR2,
  X_MILESTONE_STATUS in VARCHAR2,
  X_DUE_DT in DATE,
  X_DESCRIPTION in VARCHAR2,
  X_ACTUAL_REACHED_DT in DATE,
  X_PRECED_SEQUENCE_NUMBER in NUMBER,
  X_OVRD_NTFCTN_IMMINENT_DAYS in NUMBER,
  X_OVRD_NTFCTN_REMINDER_DAYS in NUMBER,
  X_OVRD_NTFCTN_RE_REMINDER_DAYS in NUMBER,
  X_COMMENTS in VARCHAR2,
  X_MODE in VARCHAR2 default 'R',
  X_ORG_ID IN NUMBER
  ) AS
    cursor C is select ROWID from IGS_PR_MILESTONE_HST_ALL
      where PERSON_ID = X_PERSON_ID
      and CA_SEQUENCE_NUMBER = X_CA_SEQUENCE_NUMBER
      and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
      and HIST_START_DT = X_HIST_START_DT;

Line: 237


    X_LAST_UPDATE_DATE DATE;

Line: 238


    X_LAST_UPDATED_BY NUMBER;

Line: 239


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 241


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 243


    X_LAST_UPDATED_BY := 1;

Line: 244


    X_LAST_UPDATE_LOGIN := 0;

Line: 246


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 247


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 250


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 251


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 261


    p_action => 'INSERT',
    x_rowid => x_rowid,
    x_person_id =>x_person_id,
    x_ca_sequence_number => x_ca_sequence_number,
    x_sequence_number => x_sequence_number,
    x_hist_start_dt => x_hist_start_dt,
    x_hist_end_dt =>x_hist_end_dt,
    x_hist_who => x_hist_who,
    x_milestone_type =>x_milestone_type,
    x_milestone_status =>x_milestone_status ,
    x_due_dt =>x_due_dt,
    x_description =>x_description,
    x_actual_reached_dt =>x_actual_reached_dt,
    x_preced_sequence_number =>x_preced_sequence_number,
    x_ovrd_ntfctn_imminent_days =>x_ovrd_ntfctn_imminent_days,
    x_ovrd_ntfctn_reminder_days =>x_ovrd_ntfctn_reminder_days,
    x_ovrd_ntfctn_re_reminder_days =>x_ovrd_ntfctn_re_reminder_days,
    x_comments => x_comments,
    x_creation_date =>x_last_update_date,
    x_created_by =>x_last_updated_by,
    x_last_update_date => x_last_update_date,
    x_last_updated_by =>x_last_updated_by,
    x_last_update_login => x_last_update_login,
    x_org_id=>igs_ge_gen_003.get_org_id
  ) ;

Line: 287


  insert into IGS_PR_MILESTONE_HST_ALL (
    PERSON_ID,
    CA_SEQUENCE_NUMBER,
    SEQUENCE_NUMBER,
    HIST_START_DT,
    HIST_END_DT,
    HIST_WHO,
    MILESTONE_TYPE,
    MILESTONE_STATUS,
    DUE_DT,
    DESCRIPTION,
    ACTUAL_REACHED_DT,
    PRECED_SEQUENCE_NUMBER,
    OVRD_NTFCTN_IMMINENT_DAYS,
    OVRD_NTFCTN_REMINDER_DAYS,
    OVRD_NTFCTN_RE_REMINDER_DAYS,
    COMMENTS,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    ORG_ID
  ) values (
    NEW_REFERENCES.PERSON_ID,
    NEW_REFERENCES.CA_SEQUENCE_NUMBER,
    NEW_REFERENCES.SEQUENCE_NUMBER,
    NEW_REFERENCES.HIST_START_DT,
    NEW_REFERENCES.HIST_END_DT,
    NEW_REFERENCES.HIST_WHO,
    NEW_REFERENCES.MILESTONE_TYPE,
    NEW_REFERENCES.MILESTONE_STATUS,
    NEW_REFERENCES.DUE_DT,
    NEW_REFERENCES.DESCRIPTION,
    NEW_REFERENCES.ACTUAL_REACHED_DT,
    NEW_REFERENCES.PRECED_SEQUENCE_NUMBER,
    NEW_REFERENCES.OVRD_NTFCTN_IMMINENT_DAYS,
    NEW_REFERENCES.OVRD_NTFCTN_REMINDER_DAYS,
    NEW_REFERENCES.OVRD_NTFCTN_RE_REMINDER_DAYS,
    NEW_REFERENCES.COMMENTS,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    NEW_REFERENCES.ORG_ID
  );

Line: 342


end INSERT_ROW;

Line: 363


  cursor c1 is select
      HIST_END_DT,
      HIST_WHO,
      MILESTONE_TYPE,
      MILESTONE_STATUS,
      DUE_DT,
      DESCRIPTION,
      ACTUAL_REACHED_DT,
      PRECED_SEQUENCE_NUMBER,
      OVRD_NTFCTN_IMMINENT_DAYS,
      OVRD_NTFCTN_REMINDER_DAYS,
      OVRD_NTFCTN_RE_REMINDER_DAYS,
      COMMENTS
    from IGS_PR_MILESTONE_HST_ALL
    where ROWID = X_ROWID  for update nowait;

Line: 384


    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 435


procedure UPDATE_ROW (
  X_ROWID in VARCHAR2,
  X_PERSON_ID in NUMBER,
  X_CA_SEQUENCE_NUMBER in NUMBER,
  X_SEQUENCE_NUMBER in NUMBER,
  X_HIST_START_DT in DATE,
  X_HIST_END_DT in DATE,
  X_HIST_WHO in NUMBER,
  X_MILESTONE_TYPE in VARCHAR2,
  X_MILESTONE_STATUS in VARCHAR2,
  X_DUE_DT in DATE,
  X_DESCRIPTION in VARCHAR2,
  X_ACTUAL_REACHED_DT in DATE,
  X_PRECED_SEQUENCE_NUMBER in NUMBER,
  X_OVRD_NTFCTN_IMMINENT_DAYS in NUMBER,
  X_OVRD_NTFCTN_REMINDER_DAYS in NUMBER,
  X_OVRD_NTFCTN_RE_REMINDER_DAYS in NUMBER,
  X_COMMENTS in VARCHAR2,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    X_LAST_UPDATE_DATE DATE;

Line: 456


    X_LAST_UPDATED_BY NUMBER;

Line: 457


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 459


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 461


    X_LAST_UPDATED_BY := 1;

Line: 462


    X_LAST_UPDATE_LOGIN := 0;

Line: 464


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 465


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 468


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 469


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 478


    p_action => 'UPDATE',
    x_rowid => x_rowid,
    x_person_id =>x_person_id,
    x_ca_sequence_number => x_ca_sequence_number,
    x_sequence_number => x_sequence_number,
    x_hist_start_dt => x_hist_start_dt,
    x_hist_end_dt =>x_hist_end_dt,
    x_hist_who => x_hist_who,
    x_milestone_type =>x_milestone_type,
    x_milestone_status =>x_milestone_status ,
    x_due_dt =>x_due_dt,
    x_description =>x_description,
    x_actual_reached_dt =>x_actual_reached_dt,
    x_preced_sequence_number =>x_preced_sequence_number,
    x_ovrd_ntfctn_imminent_days =>x_ovrd_ntfctn_imminent_days,
    x_ovrd_ntfctn_reminder_days =>x_ovrd_ntfctn_reminder_days,
    x_ovrd_ntfctn_re_reminder_days =>x_ovrd_ntfctn_re_reminder_days,
    x_comments => x_comments,
    x_creation_date =>x_last_update_date,
    x_created_by =>x_last_updated_by,
    x_last_update_date => x_last_update_date,
    x_last_updated_by =>x_last_updated_by,
    x_last_update_login => x_last_update_login
  ) ;

Line: 503


  update IGS_PR_MILESTONE_HST_ALL set
    HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
    HIST_WHO = NEW_REFERENCES.HIST_WHO,
    MILESTONE_TYPE = NEW_REFERENCES.MILESTONE_TYPE,
    MILESTONE_STATUS = NEW_REFERENCES.MILESTONE_STATUS,
    DUE_DT = NEW_REFERENCES.DUE_DT,
    DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
    ACTUAL_REACHED_DT = NEW_REFERENCES.ACTUAL_REACHED_DT,
    PRECED_SEQUENCE_NUMBER = NEW_REFERENCES.PRECED_SEQUENCE_NUMBER,
    OVRD_NTFCTN_IMMINENT_DAYS = NEW_REFERENCES.OVRD_NTFCTN_IMMINENT_DAYS,
    OVRD_NTFCTN_REMINDER_DAYS = NEW_REFERENCES.OVRD_NTFCTN_REMINDER_DAYS,
    OVRD_NTFCTN_RE_REMINDER_DAYS = NEW_REFERENCES.OVRD_NTFCTN_RE_REMINDER_DAYS,
    COMMENTS = NEW_REFERENCES.COMMENTS,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where  ROWID = X_ROWID;

Line: 524


end UPDATE_ROW;

Line: 547


  cursor c1 is select rowid from IGS_PR_MILESTONE_HST_ALL
     where PERSON_ID = X_PERSON_ID
     and CA_SEQUENCE_NUMBER = X_CA_SEQUENCE_NUMBER
     and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
     and HIST_START_DT = X_HIST_START_DT
  ;

Line: 558


    INSERT_ROW (
     X_ROWID,
     X_PERSON_ID,
     X_CA_SEQUENCE_NUMBER,
     X_SEQUENCE_NUMBER,
     X_HIST_START_DT,
     X_HIST_END_DT,
     X_HIST_WHO,
     X_MILESTONE_TYPE,
     X_MILESTONE_STATUS,
     X_DUE_DT,
     X_DESCRIPTION,
     X_ACTUAL_REACHED_DT,
     X_PRECED_SEQUENCE_NUMBER,
     X_OVRD_NTFCTN_IMMINENT_DAYS,
     X_OVRD_NTFCTN_REMINDER_DAYS,
     X_OVRD_NTFCTN_RE_REMINDER_DAYS,
     X_COMMENTS,
     X_MODE,
     X_ORG_ID);

Line: 581


  UPDATE_ROW (
   X_ROWID,
   X_PERSON_ID,
   X_CA_SEQUENCE_NUMBER,
   X_SEQUENCE_NUMBER,
   X_HIST_START_DT,
   X_HIST_END_DT,
   X_HIST_WHO,
   X_MILESTONE_TYPE,
   X_MILESTONE_STATUS,
   X_DUE_DT,
   X_DESCRIPTION,
   X_ACTUAL_REACHED_DT,
   X_PRECED_SEQUENCE_NUMBER,
   X_OVRD_NTFCTN_IMMINENT_DAYS,
   X_OVRD_NTFCTN_REMINDER_DAYS,
   X_OVRD_NTFCTN_RE_REMINDER_DAYS,
   X_COMMENTS,
   X_MODE
  );

Line: 603


procedure DELETE_ROW (
  X_ROWID in VARCHAR2
) as
begin
Before_DML (
    p_action => 'DELETE',
    x_rowid  => X_ROWID
  );

Line: 612


  delete from IGS_PR_MILESTONE_HST_ALL
  where ROWID = X_ROWID;

Line: 618


end DELETE_ROW;