APPS.IGS_EN_UNIT_SET_HIST_PKG SQL Statements

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

Line: 34

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

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

Line: 52

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

Line: 82

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

Line: 89

    new_references.last_update_date := x_last_update_date;

Line: 90

    new_references.last_updated_by := x_last_updated_by;

Line: 91

    new_references.last_update_login := x_last_update_login;

Line: 181

      SELECT   rowid
      FROM     IGS_EN_UNIT_SET_HIST_ALL
      WHERE    unit_set_cd = x_unit_set_cd
      AND      version_number = x_version_number
      AND      hist_start_dt = x_hist_start_dt
      FOR UPDATE NOWAIT;

Line: 230

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

    Set_Column_Values (
      p_action,
      x_rowid,
      x_org_id,
      x_unit_set_cd,
      x_version_number,
      x_hist_start_dt,
      x_hist_end_dt,
      x_hist_who,
      x_unit_set_status,
      x_unit_set_cat,
      x_start_dt,
      x_review_dt,
      x_expiry_dt,
      x_end_dt,
      x_title,
      x_short_title,
      x_abbreviation,
      x_responsible_org_unit_cd,
      x_responsible_ou_start_dt,
      x_ou_description,
      x_administrative_ind,
      x_authorisation_rqrd_ind,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );

Line: 266

    IF (p_action = 'INSERT') THEN

	IF Get_PK_For_Validation(
		new_references.unit_set_cd,
 		new_references.version_number,
                new_references.hist_start_dt
	                            ) THEN

 		Fnd_message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');

Line: 282

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

Line: 285

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

Line: 288

    ELSIF (p_action = 'VALIDATE_INSERT') THEN
      		IF  Get_PK_For_Validation (
			new_references.unit_set_cd,
 			new_references.version_number,
                	new_references.hist_start_dt
				 ) THEN
		          Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');

Line: 299

    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      		  Check_Constraints;

Line: 301

    ELSIF (p_action = 'VALIDATE_DELETE') THEN
                   null;

Line: 315

    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to After Insert.
      Null;

Line: 318

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

Line: 321

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

Line: 328

procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_ORG_ID in NUMBER,
  X_UNIT_SET_CD in VARCHAR2,
  X_VERSION_NUMBER in NUMBER,
  X_HIST_START_DT in DATE,
  X_HIST_END_DT in DATE,
  X_HIST_WHO in NUMBER,
  X_UNIT_SET_STATUS in VARCHAR2,
  X_UNIT_SET_CAT in VARCHAR2,
  X_START_DT in DATE,
  X_REVIEW_DT in DATE,
  X_EXPIRY_DT in DATE,
  X_END_DT in DATE,
  X_TITLE in VARCHAR2,
  X_SHORT_TITLE in VARCHAR2,
  X_ABBREVIATION in VARCHAR2,
  X_RESPONSIBLE_ORG_UNIT_CD in VARCHAR2,
  X_RESPONSIBLE_OU_START_DT in DATE,
  X_OU_DESCRIPTION in VARCHAR2,
  X_ADMINISTRATIVE_IND in VARCHAR2,
  X_AUTHORISATION_RQRD_IND in VARCHAR2,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    cursor C is select ROWID from IGS_EN_UNIT_SET_HIST_ALL
      where UNIT_SET_CD = X_UNIT_SET_CD
      and VERSION_NUMBER = X_VERSION_NUMBER
      and HIST_START_DT = X_HIST_START_DT;

Line: 356

    X_LAST_UPDATE_DATE DATE;

Line: 357

    X_LAST_UPDATED_BY NUMBER;

Line: 358

    X_LAST_UPDATE_LOGIN NUMBER;

Line: 360

  X_LAST_UPDATE_DATE := SYSDATE;

Line: 362

    X_LAST_UPDATED_BY := 1;

Line: 363

    X_LAST_UPDATE_LOGIN := 0;

Line: 365

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 366

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 369

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 370

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 380

      p_action => 'INSERT' ,
      x_rowid => x_rowid ,
      x_org_id => igs_ge_gen_003.get_org_id,
      x_unit_set_cd => x_unit_set_cd ,
      x_version_number => x_version_number ,
      x_hist_start_dt => x_hist_start_dt ,
      x_hist_end_dt => x_hist_end_dt ,
      x_hist_who => x_hist_who ,
      x_unit_set_status => x_unit_set_status ,
      x_unit_set_cat => x_unit_set_cat ,
      x_start_dt => x_start_dt ,
      x_review_dt => x_review_dt ,
      x_expiry_dt => x_expiry_dt ,
      x_end_dt => x_end_dt ,
      x_title => x_title ,
      x_short_title => x_short_title ,
      x_abbreviation => x_abbreviation,
      x_responsible_org_unit_cd => x_responsible_org_unit_cd ,
      x_responsible_ou_start_dt => x_responsible_ou_start_dt ,
      x_ou_description => x_ou_description ,
      x_administrative_ind => NVL(x_administrative_ind,'N') ,
      x_authorisation_rqrd_ind => NVL(x_authorisation_rqrd_ind,'N') ,
      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: 409

  insert into IGS_EN_UNIT_SET_HIST_ALL (
    org_id,
    UNIT_SET_CD,
    VERSION_NUMBER,
    HIST_START_DT,
    HIST_END_DT,
    HIST_WHO,
    UNIT_SET_STATUS,
    UNIT_SET_CAT,
    START_DT,
    REVIEW_DT,
    EXPIRY_DT,
    END_DT,
    TITLE,
    SHORT_TITLE,
    ABBREVIATION,
    RESPONSIBLE_ORG_UNIT_CD,
    RESPONSIBLE_OU_START_DT,
    OU_DESCRIPTION,
    ADMINISTRATIVE_IND,
    AUTHORISATION_RQRD_IND,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    new_references.org_id,
    NEW_REFERENCES.UNIT_SET_CD,
    NEW_REFERENCES.VERSION_NUMBER,
    NEW_REFERENCES.HIST_START_DT,
    NEW_REFERENCES.HIST_END_DT,
    NEW_REFERENCES.HIST_WHO,
    NEW_REFERENCES.UNIT_SET_STATUS,
    NEW_REFERENCES.UNIT_SET_CAT,
    NEW_REFERENCES.START_DT,
    NEW_REFERENCES.REVIEW_DT,
    NEW_REFERENCES.EXPIRY_DT,
    NEW_REFERENCES.END_DT,
    NEW_REFERENCES.TITLE,
    NEW_REFERENCES.SHORT_TITLE,
    NEW_REFERENCES.ABBREVIATION,
    NEW_REFERENCES.RESPONSIBLE_ORG_UNIT_CD,
    NEW_REFERENCES.RESPONSIBLE_OU_START_DT,
    NEW_REFERENCES.OU_DESCRIPTION,
    NEW_REFERENCES.ADMINISTRATIVE_IND,
    NEW_REFERENCES.AUTHORISATION_RQRD_IND,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 472

    p_action => 'INSERT',
    x_rowid => X_ROWID
  );

Line: 476

end INSERT_ROW;

Line: 500

  cursor c1 is select
      HIST_END_DT,
      HIST_WHO,
      UNIT_SET_STATUS,
      UNIT_SET_CAT,
      START_DT,
      REVIEW_DT,
      EXPIRY_DT,
      END_DT,
      TITLE,
      SHORT_TITLE,
      ABBREVIATION,
      RESPONSIBLE_ORG_UNIT_CD,
      RESPONSIBLE_OU_START_DT,
      OU_DESCRIPTION,
      ADMINISTRATIVE_IND,
      AUTHORISATION_RQRD_IND
    from IGS_EN_UNIT_SET_HIST_ALL
    where ROWID = X_ROWID
    for update nowait;

Line: 526

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

Line: 584

procedure UPDATE_ROW (
  X_ROWID IN VARCHAR2,
  X_UNIT_SET_CD in VARCHAR2,
  X_VERSION_NUMBER in NUMBER,
  X_HIST_START_DT in DATE,
  X_HIST_END_DT in DATE,
  X_HIST_WHO in NUMBER,
  X_UNIT_SET_STATUS in VARCHAR2,
  X_UNIT_SET_CAT in VARCHAR2,
  X_START_DT in DATE,
  X_REVIEW_DT in DATE,
  X_EXPIRY_DT in DATE,
  X_END_DT in DATE,
  X_TITLE in VARCHAR2,
  X_SHORT_TITLE in VARCHAR2,
  X_ABBREVIATION in VARCHAR2,
  X_RESPONSIBLE_ORG_UNIT_CD in VARCHAR2,
  X_RESPONSIBLE_OU_START_DT in DATE,
  X_OU_DESCRIPTION in VARCHAR2,
  X_ADMINISTRATIVE_IND in VARCHAR2,
  X_AUTHORISATION_RQRD_IND in VARCHAR2,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    X_LAST_UPDATE_DATE DATE;

Line: 608

    X_LAST_UPDATED_BY NUMBER;

Line: 609

    X_LAST_UPDATE_LOGIN NUMBER;

Line: 611

  X_LAST_UPDATE_DATE := SYSDATE;

Line: 613

    X_LAST_UPDATED_BY := 1;

Line: 614

    X_LAST_UPDATE_LOGIN := 0;

Line: 616

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 617

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 620

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 621

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 631

      p_action => 'UPDATE' ,
      x_rowid => x_rowid ,
      x_unit_set_cd => x_unit_set_cd ,
      x_version_number => x_version_number ,
      x_hist_start_dt => x_hist_start_dt ,
      x_hist_end_dt => x_hist_end_dt ,
      x_hist_who => x_hist_who ,
      x_unit_set_status => x_unit_set_status ,
      x_unit_set_cat => x_unit_set_cat ,
      x_start_dt => x_start_dt ,
      x_review_dt => x_review_dt ,
      x_expiry_dt => x_expiry_dt ,
      x_end_dt => x_end_dt ,
      x_title => x_title ,
      x_short_title => x_short_title ,
      x_abbreviation => x_short_title ,
      x_responsible_org_unit_cd => x_responsible_org_unit_cd ,
      x_responsible_ou_start_dt => x_responsible_ou_start_dt ,
      x_ou_description => x_ou_description ,
      x_administrative_ind => x_administrative_ind ,
      x_authorisation_rqrd_ind => x_authorisation_rqrd_ind ,
      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: 661

  update IGS_EN_UNIT_SET_HIST_ALL set
    HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
    HIST_WHO = NEW_REFERENCES.HIST_WHO,
    UNIT_SET_STATUS = NEW_REFERENCES.UNIT_SET_STATUS,
    UNIT_SET_CAT = NEW_REFERENCES.UNIT_SET_CAT,
    START_DT = NEW_REFERENCES.START_DT,
    REVIEW_DT = NEW_REFERENCES.REVIEW_DT,
    EXPIRY_DT = NEW_REFERENCES.EXPIRY_DT,
    END_DT = NEW_REFERENCES.END_DT,
    TITLE = NEW_REFERENCES.TITLE,
    SHORT_TITLE = NEW_REFERENCES.SHORT_TITLE,
    ABBREVIATION = NEW_REFERENCES.ABBREVIATION,
    RESPONSIBLE_ORG_UNIT_CD = NEW_REFERENCES.RESPONSIBLE_ORG_UNIT_CD,
    RESPONSIBLE_OU_START_DT = NEW_REFERENCES.RESPONSIBLE_OU_START_DT,
    OU_DESCRIPTION = NEW_REFERENCES.OU_DESCRIPTION,
    ADMINISTRATIVE_IND = NEW_REFERENCES.ADMINISTRATIVE_IND,
    AUTHORISATION_RQRD_IND = NEW_REFERENCES.AUTHORISATION_RQRD_IND,
    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: 688

    p_action => 'UPDATE',
    x_rowid => X_ROWID
  );

Line: 692

end UPDATE_ROW;

Line: 718

  cursor c1 is select rowid from IGS_EN_UNIT_SET_HIST_ALL
     where UNIT_SET_CD = X_UNIT_SET_CD
     and VERSION_NUMBER = X_VERSION_NUMBER
     and HIST_START_DT = X_HIST_START_DT
  ;

Line: 729

    INSERT_ROW (
     X_ROWID,
      x_org_id,
     X_UNIT_SET_CD,
     X_VERSION_NUMBER,
     X_HIST_START_DT,
     X_HIST_END_DT,
     X_HIST_WHO,
     X_UNIT_SET_STATUS,
     X_UNIT_SET_CAT,
     X_START_DT,
     X_REVIEW_DT,
     X_EXPIRY_DT,
     X_END_DT,
     X_TITLE,
     X_SHORT_TITLE,
     X_ABBREVIATION,
     X_RESPONSIBLE_ORG_UNIT_CD,
     X_RESPONSIBLE_OU_START_DT,
     X_OU_DESCRIPTION,
     X_ADMINISTRATIVE_IND,
     X_AUTHORISATION_RQRD_IND,
     X_MODE);

Line: 755

  UPDATE_ROW (
   X_ROWID,
   X_UNIT_SET_CD,
   X_VERSION_NUMBER,
   X_HIST_START_DT,
   X_HIST_END_DT,
   X_HIST_WHO,
   X_UNIT_SET_STATUS,
   X_UNIT_SET_CAT,
   X_START_DT,
   X_REVIEW_DT,
   X_EXPIRY_DT,
   X_END_DT,
   X_TITLE,
   X_SHORT_TITLE,
   X_ABBREVIATION,
   X_RESPONSIBLE_ORG_UNIT_CD,
   X_RESPONSIBLE_OU_START_DT,
   X_OU_DESCRIPTION,
   X_ADMINISTRATIVE_IND,
   X_AUTHORISATION_RQRD_IND,
   X_MODE);

Line: 779

procedure DELETE_ROW (
  X_ROWID IN VARCHAR2
) AS
begin

  Before_DML(
    p_action => 'DELETE',
    x_rowid => X_ROWID
  );

Line: 789

  delete from IGS_EN_UNIT_SET_HIST_ALL
  where ROWID = X_ROWID;

Line: 795

    p_action => 'DELETE',
    x_rowid => X_ROWID
  );

Line: 800

end DELETE_ROW;