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

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

Line: 22


    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_PS_UNT_OFR_OPT_N
      WHERE    rowid = x_rowid;

Line: 40


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

Line: 42


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

Line: 59


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

Line: 66


    new_references.last_update_date := x_last_update_date;

Line: 67


    new_references.last_updated_by := x_last_updated_by;

Line: 68


    new_references.last_update_login := x_last_update_login;

Line: 72


  PROCEDURE BeforeRowInsertUpdateDelete1(
    p_inserting IN BOOLEAN DEFAULT FALSE,
    p_updating IN BOOLEAN DEFAULT FALSE,
    p_deleting IN BOOLEAN DEFAULT FALSE
    ) AS
	v_unit_cd			IGS_PS_UNT_OFR_OPT_N.unit_cd%TYPE;

Line: 82


	IF p_inserting THEN
		IGS_PS_GEN_006.CRSP_GET_UOO_KEY (
			new_references.unit_cd,
			new_references.version_number,
			new_references.cal_type,
			new_references.ci_sequence_number,
			new_references.location_cd,
			new_references.unit_class,
			new_references.uoo_id);

Line: 96


	ELSE -- p_inserting or p_updating
		v_unit_cd := new_references.unit_cd;

Line: 100


	-- Validate the insert/update/delete.
	IF IGS_PS_VAL_UNIT.crsp_val_iud_uv_dtl (
			v_unit_cd,
			v_version_number,
v_message_name) = FALSE THEN
		Fnd_Message.Set_Name('IGS',v_message_name);

Line: 111


  END BeforeRowInsertUpdateDelete1;

Line: 187


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

Line: 199


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

Line: 227


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

Line: 240


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

Line: 259


      SELECT   rowid
      FROM     IGS_PS_UNT_OFR_OPT_N
      WHERE    unit_cd = x_unit_cd
      AND      version_number = x_version_number
      AND      cal_type = x_cal_type
      AND      ci_sequence_number = x_ci_sequence_number
      AND      location_cd = x_location_cd
      AND      unit_class = x_unit_class
      AND      reference_number = x_reference_number
      FOR UPDATE NOWAIT;

Line: 291


      SELECT   rowid
      FROM     IGS_PS_UNT_OFR_OPT_N
      WHERE    crs_note_type = x_crs_note_type ;

Line: 317


      SELECT   rowid
      FROM     IGS_PS_UNT_OFR_OPT_N
      WHERE    reference_number = x_reference_number ;

Line: 348


      SELECT   rowid
      FROM     IGS_PS_UNT_OFR_OPT_N
      WHERE    unit_cd = x_unit_cd
      AND      version_number = x_version_number
      AND      cal_type = x_cal_type
      AND      ci_sequence_number = x_ci_sequence_number
      AND      location_cd = x_location_cd
      AND      unit_class = x_unit_class ;

Line: 379


      SELECT   rowid
      FROM     IGS_PS_UNT_OFR_OPT_N
      WHERE    uoo_id = x_uoo_id ;

Line: 414


    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_unit_cd,
      x_version_number,
      x_cal_type,
      x_ci_sequence_number,
      x_location_cd,
      x_unit_class,
      x_reference_number,
      x_uoo_id,
      x_crs_note_type,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );

Line: 439


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

Line: 455


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

Line: 460


    ELSIF (p_action = 'DELETE') THEN
      -- Call all the procedures related to Before Delete.
      BeforeRowInsertUpdateDelete1 ( p_deleting => TRUE );

Line: 463


   ELSIF (p_action = 'VALIDATE_INSERT') THEN
   IF Get_PK_For_Validation (New_References.unit_cd,
					     New_References.version_number,
					     New_References.cal_type,
					     New_References.ci_sequence_number,
					     New_References.location_cd,
					     New_References.unit_class,
					     New_References.reference_number) THEN
			Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

Line: 476


   ELSIF (p_action = 'VALIDATE_UPDATE') THEN
	   Check_Constraints;

Line: 494


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_UNIT_CD in VARCHAR2,
  X_VERSION_NUMBER in NUMBER,
  X_CI_SEQUENCE_NUMBER in NUMBER,
  X_UNIT_CLASS in VARCHAR2,
  X_REFERENCE_NUMBER in NUMBER,
  X_LOCATION_CD in VARCHAR2,
  X_CAL_TYPE in VARCHAR2,
  X_UOO_ID in out NOCOPY NUMBER,
  X_CRS_NOTE_TYPE in VARCHAR2,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    cursor C is select ROWID from IGS_PS_UNT_OFR_OPT_N
      where UNIT_CD = X_UNIT_CD
      and VERSION_NUMBER = X_VERSION_NUMBER
      and CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER
      and UNIT_CLASS = X_UNIT_CLASS
      and REFERENCE_NUMBER = X_REFERENCE_NUMBER
      and LOCATION_CD = X_LOCATION_CD
      and CAL_TYPE = X_CAL_TYPE;

Line: 515


    X_LAST_UPDATE_DATE DATE;

Line: 516


    X_LAST_UPDATED_BY NUMBER;

Line: 517


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 519


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 521


    X_LAST_UPDATED_BY := 1;

Line: 522


    X_LAST_UPDATE_LOGIN := 0;

Line: 524


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 525


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 528


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 529


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 539


  p_action => 'INSERT',
  x_rowid => X_ROWID,
  x_unit_cd => X_UNIT_CD,
  x_version_number => X_VERSION_NUMBER,
  x_cal_type => X_CAL_TYPE,
  x_ci_sequence_number => X_CI_SEQUENCE_NUMBER,
  x_location_cd => X_LOCATION_CD,
  x_unit_class => X_UNIT_CLASS,
  x_reference_number => X_REFERENCE_NUMBER,
  x_uoo_id => X_UOO_ID,
  x_crs_note_type => X_CRS_NOTE_TYPE,
  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: 557


  insert into IGS_PS_UNT_OFR_OPT_N (
    UNIT_CD,
    VERSION_NUMBER,
    CAL_TYPE,
    CI_SEQUENCE_NUMBER,
    LOCATION_CD,
    UNIT_CLASS,
    REFERENCE_NUMBER,
    UOO_ID,
    CRS_NOTE_TYPE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    NEW_REFERENCES.UNIT_CD,
    NEW_REFERENCES.VERSION_NUMBER,
    NEW_REFERENCES.CAL_TYPE,
    NEW_REFERENCES.CI_SEQUENCE_NUMBER,
    NEW_REFERENCES.LOCATION_CD,
    NEW_REFERENCES.UNIT_CLASS,
    NEW_REFERENCES.REFERENCE_NUMBER,
    NEW_REFERENCES.UOO_ID,
    NEW_REFERENCES.CRS_NOTE_TYPE,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 597


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

Line: 602


end INSERT_ROW;

Line: 616


  cursor c1 is select
      UOO_ID,
      CRS_NOTE_TYPE
    from IGS_PS_UNT_OFR_OPT_N
    where ROWID = X_ROWID for update nowait;

Line: 628


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

Line: 647


procedure UPDATE_ROW (
  X_ROWID in VARCHAR2,
  X_UNIT_CD in VARCHAR2,
  X_VERSION_NUMBER in NUMBER,
  X_CI_SEQUENCE_NUMBER in NUMBER,
  X_UNIT_CLASS in VARCHAR2,
  X_REFERENCE_NUMBER in NUMBER,
  X_LOCATION_CD in VARCHAR2,
  X_CAL_TYPE in VARCHAR2,
  X_UOO_ID in NUMBER,
  X_CRS_NOTE_TYPE in VARCHAR2,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    X_LAST_UPDATE_DATE DATE;

Line: 661


    X_LAST_UPDATED_BY NUMBER;

Line: 662


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 664


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 666


    X_LAST_UPDATED_BY := 1;

Line: 667


    X_LAST_UPDATE_LOGIN := 0;

Line: 669


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 670


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 673


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 674


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 684


  p_action => 'UPDATE',
  x_rowid => X_ROWID,
  x_unit_cd => X_UNIT_CD,
  x_version_number => X_VERSION_NUMBER,
  x_cal_type => X_CAL_TYPE,
  x_ci_sequence_number => X_CI_SEQUENCE_NUMBER,
  x_location_cd => X_LOCATION_CD,
  x_unit_class => X_UNIT_CLASS,
  x_reference_number => X_REFERENCE_NUMBER,
  x_uoo_id => X_UOO_ID,
  x_crs_note_type => X_CRS_NOTE_TYPE,
  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: 702


  update IGS_PS_UNT_OFR_OPT_N set
    UOO_ID = NEW_REFERENCES.UOO_ID,
    CRS_NOTE_TYPE = NEW_REFERENCES.CRS_NOTE_TYPE,
    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: 714


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

Line: 718


end UPDATE_ROW;

Line: 733


  cursor c1 is select rowid from IGS_PS_UNT_OFR_OPT_N
     where UNIT_CD = X_UNIT_CD
     and VERSION_NUMBER = X_VERSION_NUMBER
     and CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER
     and UNIT_CLASS = X_UNIT_CLASS
     and REFERENCE_NUMBER = X_REFERENCE_NUMBER
     and LOCATION_CD = X_LOCATION_CD
     and CAL_TYPE = X_CAL_TYPE
  ;

Line: 747


    INSERT_ROW (
     X_ROWID,
     X_UNIT_CD,
     X_VERSION_NUMBER,
     X_CI_SEQUENCE_NUMBER,
     X_UNIT_CLASS,
     X_REFERENCE_NUMBER,
     X_LOCATION_CD,
     X_CAL_TYPE,
     X_UOO_ID,
     X_CRS_NOTE_TYPE,
     X_MODE);

Line: 762


  UPDATE_ROW (
   X_ROWID,
   X_UNIT_CD,
   X_VERSION_NUMBER,
   X_CI_SEQUENCE_NUMBER,
   X_UNIT_CLASS,
   X_REFERENCE_NUMBER,
   X_LOCATION_CD,
   X_CAL_TYPE,
   X_UOO_ID,
   X_CRS_NOTE_TYPE,
   X_MODE);

Line: 776


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

Line: 785


  delete from IGS_PS_UNT_OFR_OPT_N
  where ROWID = X_ROWID;

Line: 791


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

Line: 795


end DELETE_ROW;