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_GR_CRMN_ROUND_PKG SQL Statements

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

Line: 19


    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,
    x_conferral_start_date   IN DATE DEFAULT NULL,
    x_conferral_end_date     IN DATE DEFAULT NULL,
    x_completion_start_date  IN DATE DEFAULT NULL,
    x_completion_end_date    IN DATE DEFAULT NULL
  ) AS

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

Line: 42


    IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
      Close cur_old_ref_values;

Line: 44


      Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

Line: 63


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

Line: 70


    new_references.last_update_date := x_last_update_date;

Line: 71


    new_references.last_updated_by := x_last_updated_by;

Line: 72


    new_references.last_update_login := x_last_update_login;

Line: 82


  PROCEDURE BeforeRowInsertUpdate1(
    p_inserting IN BOOLEAN DEFAULT FALSE,
    p_updating IN BOOLEAN DEFAULT FALSE,
    p_deleting IN BOOLEAN DEFAULT FALSE
    ) AS
  v_message_name  VARCHAR2(30);

Line: 90


  IF p_inserting THEN
    IF IGS_GR_VAL_CRD.grdp_val_ci_grad(
        new_references.grd_cal_type,
        v_message_name) = FALSE THEN
      Fnd_Message.Set_Name('IGS', v_message_name);

Line: 110


  END BeforeRowInsertUpdate1;

Line: 125


    FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');

Line: 148


    FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');

Line: 171


    FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');

Line: 295


      SELECT   rowid
      FROM     IGS_GR_CRMN_ROUND_ALL
      WHERE    grd_cal_type = x_grd_cal_type
      AND      grd_ci_sequence_number = x_grd_ci_sequence_number ;

Line: 321


      SELECT   rowid
      FROM     IGS_GR_CRMN_ROUND_ALL
      WHERE    grd_cal_type = x_cal_type
      AND      grd_ci_sequence_number = x_sequence_number ;

Line: 351


      SELECT   rowid
      FROM     IGS_GR_CRMN_ROUND_ALL
      WHERE    (end_dt_alias = x_dt_alias
      AND      end_dai_sequence_number = x_sequence_number
      AND      grd_cal_type = x_cal_type
      AND      grd_ci_sequence_number = x_ci_sequence_number)
  OR     (start_dt_alias = x_dt_alias
      AND      start_dai_sequence_number = x_sequence_number
      AND      grd_cal_type = x_cal_type
      AND      grd_ci_sequence_number = x_ci_sequence_number) ;

Line: 389


    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,
    x_conferral_start_date   IN DATE DEFAULT NULL,
    x_conferral_end_date     IN DATE DEFAULT NULL,
    x_completion_start_date  IN DATE DEFAULT NULL,
    x_completion_end_date    IN DATE DEFAULT NULL
  ) AS
  BEGIN

    Set_Column_Values (
      p_action,
      x_rowid,
      x_grd_cal_type,
      x_grd_ci_sequence_number,
      x_start_dt_alias,
      x_start_dai_sequence_number,
      x_end_dt_alias,
      x_end_dai_sequence_number,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login,
      x_org_id,
      x_conferral_start_date ,
      x_conferral_end_date   ,
      x_completion_start_date,
      x_completion_end_date  );

Line: 420


    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to Before Insert.
      BeforeRowInsertUpdate1 ( p_inserting => TRUE );

Line: 434


    ELSIF (p_action = 'UPDATE') THEN
      -- Call all the procedures related to Before Update.
      BeforeRowInsertUpdate1 ( p_updating => TRUE );

Line: 440


    ELSIF (p_action = 'DELETE') THEN
      -- Call all the procedures related to Before Delete.
      Check_Child_Existance;

Line: 443


    ELSIF (p_action = 'VALIDATE_INSERT') THEN
  IF GET_PK_FOR_VALIDATION(
    NEW_REFERENCES.grd_cal_type,
        NEW_REFERENCES.grd_ci_sequence_number
    ) THEN
    Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');

Line: 454


    ELSIF (p_action = 'VALIDATE_UPDATE') THEN

  check_constraints;

Line: 461


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_GRD_CAL_TYPE in VARCHAR2,
  X_GRD_CI_SEQUENCE_NUMBER in NUMBER,
  X_START_DT_ALIAS in VARCHAR2,
  X_START_DAI_SEQUENCE_NUMBER in NUMBER,
  X_END_DT_ALIAS in VARCHAR2,
  X_END_DAI_SEQUENCE_NUMBER in NUMBER,
  X_MODE in VARCHAR2 default 'R',
  X_ORG_ID                 IN NUMBER,
  X_CONFERRAL_START_DATE   IN DATE DEFAULT NULL,
  X_CONFERRAL_END_DATE     IN DATE DEFAULT NULL,
  X_COMPLETION_START_DATE  IN DATE DEFAULT NULL,
  X_COMPLETION_END_DATE    IN DATE DEFAULT NULL
  ) AS
    cursor C is select ROWID from IGS_GR_CRMN_ROUND_ALL
      where GRD_CAL_TYPE = X_GRD_CAL_TYPE
      and GRD_CI_SEQUENCE_NUMBER = X_GRD_CI_SEQUENCE_NUMBER;

Line: 479


    X_LAST_UPDATE_DATE DATE;

Line: 480


    X_LAST_UPDATED_BY NUMBER;

Line: 481


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 483


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 485


    X_LAST_UPDATED_BY := 1;

Line: 486


    X_LAST_UPDATE_LOGIN := 0;

Line: 488


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 489


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 492


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 493


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 503


     p_action => 'INSERT',
     x_rowid => X_ROWID,
     x_grd_cal_type => X_GRD_CAL_TYPE,
     x_grd_ci_sequence_number => X_GRD_CI_SEQUENCE_NUMBER,
     x_start_dt_alias => X_START_DT_ALIAS,
     x_start_dai_sequence_number => X_START_DAI_SEQUENCE_NUMBER,
     x_end_dt_alias => X_END_DT_ALIAS,
     x_end_dai_sequence_number => X_END_DAI_SEQUENCE_NUMBER,
     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,
     x_conferral_start_date  => X_CONFERRAL_START_DATE ,
     x_conferral_end_date    => X_CONFERRAL_END_DATE   ,
     x_completion_start_date => X_COMPLETION_START_DATE,
     x_completion_end_date   => X_COMPLETION_END_DATE
  );

Line: 523


  insert into IGS_GR_CRMN_ROUND_ALL (
    GRD_CAL_TYPE,
    GRD_CI_SEQUENCE_NUMBER,
    START_DT_ALIAS,
    START_DAI_SEQUENCE_NUMBER,
    END_DT_ALIAS,
    END_DAI_SEQUENCE_NUMBER,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    ORG_ID,
    CONFERRAL_START_DATE ,
    CONFERRAL_END_DATE   ,
    COMPLETION_START_DATE,
    COMPLETION_END_DATE
    ) values (
    NEW_REFERENCES.GRD_CAL_TYPE,
    NEW_REFERENCES.GRD_CI_SEQUENCE_NUMBER,
    NEW_REFERENCES.START_DT_ALIAS,
    NEW_REFERENCES.START_DAI_SEQUENCE_NUMBER,
    NEW_REFERENCES.END_DT_ALIAS,
    NEW_REFERENCES.END_DAI_SEQUENCE_NUMBER,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    NEW_REFERENCES.ORG_ID,
    NEW_REFERENCES.CONFERRAL_START_DATE ,
    NEW_REFERENCES.CONFERRAL_END_DATE   ,
    NEW_REFERENCES.COMPLETION_START_DATE,
    NEW_REFERENCES.COMPLETION_END_DATE
    );

Line: 567


end INSERT_ROW;

Line: 582


  cursor c1 is select
      START_DT_ALIAS,
      START_DAI_SEQUENCE_NUMBER,
      END_DT_ALIAS,
      END_DAI_SEQUENCE_NUMBER
    from IGS_GR_CRMN_ROUND_ALL
    where ROWID = X_ROWID for update nowait;

Line: 596


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

Line: 615


procedure UPDATE_ROW (
  X_ROWID in VARCHAR2,
  X_GRD_CAL_TYPE in VARCHAR2,
  X_GRD_CI_SEQUENCE_NUMBER in NUMBER,
  X_START_DT_ALIAS in VARCHAR2,
  X_START_DAI_SEQUENCE_NUMBER in NUMBER,
  X_END_DT_ALIAS in VARCHAR2,
  X_END_DAI_SEQUENCE_NUMBER in NUMBER,
  X_MODE                   IN VARCHAR2 default 'R',
  X_CONFERRAL_START_DATE   IN DATE DEFAULT NULL,
  X_CONFERRAL_END_DATE     IN DATE DEFAULT NULL,
  X_COMPLETION_START_DATE  IN DATE DEFAULT NULL,
  X_COMPLETION_END_DATE    IN DATE DEFAULT NULL
  ) AS
  X_LAST_UPDATE_DATE DATE;

Line: 630


  X_LAST_UPDATED_BY NUMBER;

Line: 631


  X_LAST_UPDATE_LOGIN NUMBER;

Line: 633


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 635


    X_LAST_UPDATED_BY := 1;

Line: 636


    X_LAST_UPDATE_LOGIN := 0;

Line: 638


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 639


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 642


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 643


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 653


     p_action => 'UPDATE',
     x_rowid => X_ROWID,
     x_grd_cal_type => X_GRD_CAL_TYPE,
     x_grd_ci_sequence_number => X_GRD_CI_SEQUENCE_NUMBER,
     x_start_dt_alias => X_START_DT_ALIAS,
     x_start_dai_sequence_number => X_START_DAI_SEQUENCE_NUMBER,
     x_end_dt_alias => X_END_DT_ALIAS,
     x_end_dai_sequence_number => X_END_DAI_SEQUENCE_NUMBER,
     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_conferral_start_date  => X_CONFERRAL_START_DATE ,
     x_conferral_end_date    => X_CONFERRAL_END_DATE   ,
     x_completion_start_date => X_COMPLETION_START_DATE,
     x_completion_end_date   => X_COMPLETION_END_DATE
  );

Line: 671


  update IGS_GR_CRMN_ROUND_ALL set
    START_DT_ALIAS = NEW_REFERENCES.START_DT_ALIAS,
    START_DAI_SEQUENCE_NUMBER = NEW_REFERENCES.START_DAI_SEQUENCE_NUMBER,
    END_DT_ALIAS = NEW_REFERENCES.END_DT_ALIAS,
    END_DAI_SEQUENCE_NUMBER = NEW_REFERENCES.END_DAI_SEQUENCE_NUMBER,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    CONFERRAL_START_DATE = X_CONFERRAL_START_DATE ,
    CONFERRAL_END_DATE   = X_CONFERRAL_END_DATE   ,
    COMPLETION_START_DATE= X_COMPLETION_START_DATE,
    COMPLETION_END_DATE  = X_COMPLETION_END_DATE
  where ROWID = X_ROWID
  ;

Line: 689


end UPDATE_ROW;

Line: 706


  cursor c1 is select rowid from IGS_GR_CRMN_ROUND_ALL
     where GRD_CAL_TYPE = X_GRD_CAL_TYPE
     and GRD_CI_SEQUENCE_NUMBER = X_GRD_CI_SEQUENCE_NUMBER
  ;

Line: 716


    INSERT_ROW (
     X_ROWID,
     X_GRD_CAL_TYPE,
     X_GRD_CI_SEQUENCE_NUMBER,
     X_START_DT_ALIAS,
     X_START_DAI_SEQUENCE_NUMBER,
     X_END_DT_ALIAS,
     X_END_DAI_SEQUENCE_NUMBER,
     X_MODE,
     x_org_id,
     X_CONFERRAL_START_DATE ,
     X_CONFERRAL_END_DATE   ,
     X_COMPLETION_START_DATE,
     X_COMPLETION_END_DATE
     );

Line: 734


  UPDATE_ROW (
   X_ROWID,
   X_GRD_CAL_TYPE,
   X_GRD_CI_SEQUENCE_NUMBER,
   X_START_DT_ALIAS,
   X_START_DAI_SEQUENCE_NUMBER,
   X_END_DT_ALIAS,
   X_END_DAI_SEQUENCE_NUMBER,
   X_MODE,
   X_CONFERRAL_START_DATE ,
   X_CONFERRAL_END_DATE   ,
   X_COMPLETION_START_DATE,
   X_COMPLETION_END_DATE
);