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

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

Line: 23


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

Line: 41


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

Line: 43


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

Line: 62


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

Line: 69


    new_references.last_update_date := x_last_update_date;

Line: 70


    new_references.last_updated_by := x_last_updated_by;

Line: 71


    new_references.last_update_login := x_last_update_login;

Line: 81


  PROCEDURE BeforeRowInsertUpdateDelete1(
    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: 88


	IF p_inserting
	THEN
		-- Validate constraint type is not closed.
		IF IGS_CA_VAL_DAIOC.calp_val_sdoct_clsd(
					new_references.s_dt_offset_constraint_type,
					v_message_name) = FALSE
		THEN
				Fnd_Message.Set_Name('IGS',v_message_name);

Line: 101


  END BeforeRowInsertUpdateDelete1;

Line: 108


  PROCEDURE AfterStmtInsertUpdate3(
    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: 116


  	IF p_inserting or p_updating THEN
  		IF IGS_CA_VAL_DAIOC.calp_val_sdoct_clash
  			             (new_references.dt_alias,
  		    	              new_references.offset_dt_alias,
  			              new_references.dai_sequence_number,
  		    	              new_references.offset_dai_sequence_number,
  			              new_references.cal_type,
  		    	              new_references.offset_cal_type,
  			              new_references.ci_sequence_number,
  		    	              new_references.offset_ci_sequence_number,
  			              new_references.s_dt_offset_constraint_type,
  			              new_references.constraint_condition,
  			              new_references.constraint_resolution,
  			              v_message_name) = FALSE THEN
				Fnd_Message.Set_Name('IGS',v_message_name);

Line: 135


  END AfterStmtInsertUpdate3;

Line: 286


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

Line: 315


      SELECT   rowid
      FROM     IGS_CA_DA_INST_OFCNT
      WHERE    cal_type = x_cal_type
      AND      ci_sequence_number = x_ci_sequence_number
      AND      dt_alias = x_dt_alias
      AND      dai_sequence_number = x_dai_sequence_number
      AND      offset_cal_type = x_offset_cal_type
      AND      offset_ci_sequence_number = x_offset_ci_sequence_number
      AND      offset_dt_alias = x_offset_dt_alias
      AND      offset_dai_sequence_number = x_offset_dai_sequence_number
      AND      s_dt_offset_constraint_type = x_s_dt_offset_constraint_type
      FOR UPDATE NOWAIT;

Line: 356


      SELECT   rowid
      FROM     IGS_CA_DA_INST_OFCNT
      WHERE    dt_alias = x_dt_alias
      AND      dai_sequence_number = x_dai_sequence_number
      AND      cal_type = x_cal_type
      AND      ci_sequence_number = x_ci_sequence_number
      AND      offset_dt_alias = x_offset_dt_alias
      AND      offset_dai_sequence_number = x_offset_dai_sequence_number
      AND      offset_cal_type = x_offset_cal_type
      AND      offset_ci_sequence_number = x_offset_ci_sequence_number ;

Line: 408


    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_dt_alias,
      x_dai_sequence_number,
      x_cal_type,
      x_ci_sequence_number,
      x_offset_dt_alias,
      x_offset_dai_sequence_number,
      x_offset_cal_type,
      x_offset_ci_sequence_number,
      x_s_dt_offset_constraint_type,
      x_constraint_condition,
      x_constraint_resolution,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );

Line: 435


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

Line: 454


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

Line: 459


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

Line: 462


    ELSIF (p_action = 'VALIDATE_INSERT') THEN
      IF Get_PK_For_Validation (
      	new_references.cal_type ,
    		new_references.ci_sequence_number ,
            new_references.dt_alias ,
    		new_references.dai_sequence_number ,
    		new_references.offset_cal_type ,
    		new_references.offset_ci_sequence_number ,
    		new_references.offset_dt_alias ,
    		new_references.offset_dai_sequence_number ,
    		new_references.s_dt_offset_constraint_type ) Then
      	Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

Line: 478


    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      Check_Constraints;

Line: 480


    ELSIF (p_action = 'VALIDATE_DELETE') THEN
      NULL;

Line: 493


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

Line: 496


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

Line: 499


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

Line: 506


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_CAL_TYPE in VARCHAR2,
  X_CI_SEQUENCE_NUMBER in NUMBER,
  X_DT_ALIAS in VARCHAR2,
  X_DAI_SEQUENCE_NUMBER in NUMBER,
  X_OFFSET_CAL_TYPE in VARCHAR2,
  X_OFFSET_CI_SEQUENCE_NUMBER in NUMBER,
  X_OFFSET_DT_ALIAS in VARCHAR2,
  X_OFFSET_DAI_SEQUENCE_NUMBER in NUMBER,
  X_S_DT_OFFSET_CONSTRAINT_TYPE in VARCHAR2,
  X_CONSTRAINT_CONDITION in VARCHAR2,
  X_CONSTRAINT_RESOLUTION in NUMBER,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    cursor C is select ROWID from IGS_CA_DA_INST_OFCNT
      where CAL_TYPE = X_CAL_TYPE
      and CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER
      and DT_ALIAS = X_DT_ALIAS
      and DAI_SEQUENCE_NUMBER = X_DAI_SEQUENCE_NUMBER
      and OFFSET_CAL_TYPE = X_OFFSET_CAL_TYPE
      and OFFSET_CI_SEQUENCE_NUMBER = X_OFFSET_CI_SEQUENCE_NUMBER
      and OFFSET_DT_ALIAS = X_OFFSET_DT_ALIAS
      and OFFSET_DAI_SEQUENCE_NUMBER = X_OFFSET_DAI_SEQUENCE_NUMBER
      and S_DT_OFFSET_CONSTRAINT_TYPE = X_S_DT_OFFSET_CONSTRAINT_TYPE;

Line: 531


    X_LAST_UPDATE_DATE DATE;

Line: 532


    X_LAST_UPDATED_BY NUMBER;

Line: 533


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 535


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 537


    X_LAST_UPDATED_BY := 1;

Line: 538


    X_LAST_UPDATE_LOGIN := 0;

Line: 540


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 541


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 544


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 545


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 554


    p_action =>'INSERT',
    x_rowid =>X_ROWID,
    x_dt_alias =>X_DT_ALIAS,
    x_dai_sequence_number =>X_DAI_SEQUENCE_NUMBER,
    x_cal_type =>X_CAL_TYPE,
    x_ci_sequence_number =>X_CI_SEQUENCE_NUMBER,
    x_offset_dt_alias =>X_OFFSET_DT_ALIAS,
    x_offset_dai_sequence_number =>X_OFFSET_DAI_SEQUENCE_NUMBER,
    x_offset_cal_type =>X_OFFSET_CAL_TYPE,
    x_offset_ci_sequence_number =>X_OFFSET_CI_SEQUENCE_NUMBER,
    x_s_dt_offset_constraint_type =>X_S_DT_OFFSET_CONSTRAINT_TYPE,
    x_constraint_condition =>X_CONSTRAINT_CONDITION,
    x_constraint_resolution =>X_CONSTRAINT_RESOLUTION,
    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: 573


  insert into IGS_CA_DA_INST_OFCNT (
    DT_ALIAS,
    DAI_SEQUENCE_NUMBER,
    CAL_TYPE,
    CI_SEQUENCE_NUMBER,
    OFFSET_DT_ALIAS,
    OFFSET_DAI_SEQUENCE_NUMBER,
    OFFSET_CAL_TYPE,
    OFFSET_CI_SEQUENCE_NUMBER,
    S_DT_OFFSET_CONSTRAINT_TYPE,
    CONSTRAINT_CONDITION,
    CONSTRAINT_RESOLUTION,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    NEW_REFERENCES.DT_ALIAS,
    NEW_REFERENCES.DAI_SEQUENCE_NUMBER,
    NEW_REFERENCES.CAL_TYPE,
    NEW_REFERENCES.CI_SEQUENCE_NUMBER,
    NEW_REFERENCES.OFFSET_DT_ALIAS,
    NEW_REFERENCES.OFFSET_DAI_SEQUENCE_NUMBER,
    NEW_REFERENCES.OFFSET_CAL_TYPE,
    NEW_REFERENCES.OFFSET_CI_SEQUENCE_NUMBER,
    NEW_REFERENCES.S_DT_OFFSET_CONSTRAINT_TYPE,
    NEW_REFERENCES.CONSTRAINT_CONDITION,
    NEW_REFERENCES.CONSTRAINT_RESOLUTION,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 617


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

Line: 620


end INSERT_ROW;

Line: 636


  cursor c1 is select
      CONSTRAINT_CONDITION,
      CONSTRAINT_RESOLUTION
    from IGS_CA_DA_INST_OFCNT
    where ROWID = X_ROWID
    for update nowait;

Line: 649


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

Line: 668


procedure UPDATE_ROW (
  X_ROWID in VARCHAR2,
  X_CAL_TYPE in VARCHAR2,
  X_CI_SEQUENCE_NUMBER in NUMBER,
  X_DT_ALIAS in VARCHAR2,
  X_DAI_SEQUENCE_NUMBER in NUMBER,
  X_OFFSET_CAL_TYPE in VARCHAR2,
  X_OFFSET_CI_SEQUENCE_NUMBER in NUMBER,
  X_OFFSET_DT_ALIAS in VARCHAR2,
  X_OFFSET_DAI_SEQUENCE_NUMBER in NUMBER,
  X_S_DT_OFFSET_CONSTRAINT_TYPE in VARCHAR2,
  X_CONSTRAINT_CONDITION in VARCHAR2,
  X_CONSTRAINT_RESOLUTION in NUMBER,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    X_LAST_UPDATE_DATE DATE;

Line: 684


    X_LAST_UPDATED_BY NUMBER;

Line: 685


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 687


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 689


    X_LAST_UPDATED_BY := 1;

Line: 690


    X_LAST_UPDATE_LOGIN := 0;

Line: 692


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 693


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 696


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 697


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 706


    p_action =>'UPDATE',
    x_rowid =>X_ROWID,
    x_dt_alias =>X_DT_ALIAS,
    x_dai_sequence_number =>X_DAI_SEQUENCE_NUMBER,
    x_cal_type =>X_CAL_TYPE,
    x_ci_sequence_number =>X_CI_SEQUENCE_NUMBER,
    x_offset_dt_alias =>X_OFFSET_DT_ALIAS,
    x_offset_dai_sequence_number =>X_OFFSET_DAI_SEQUENCE_NUMBER,
    x_offset_cal_type =>X_OFFSET_CAL_TYPE,
    x_offset_ci_sequence_number =>X_OFFSET_CI_SEQUENCE_NUMBER,
    x_s_dt_offset_constraint_type =>X_S_DT_OFFSET_CONSTRAINT_TYPE,
    x_constraint_condition =>X_CONSTRAINT_CONDITION,
    x_constraint_resolution =>X_CONSTRAINT_RESOLUTION,
    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: 725


update IGS_CA_DA_INST_OFCNT set
    CONSTRAINT_CONDITION = NEW_REFERENCES.CONSTRAINT_CONDITION,
    CONSTRAINT_RESOLUTION = NEW_REFERENCES.CONSTRAINT_RESOLUTION,
    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: 737


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

Line: 740


end UPDATE_ROW;

Line: 757


  cursor c1 is select rowid from IGS_CA_DA_INST_OFCNT
     where CAL_TYPE = X_CAL_TYPE
     and CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER
     and DT_ALIAS = X_DT_ALIAS
     and DAI_SEQUENCE_NUMBER = X_DAI_SEQUENCE_NUMBER
     and OFFSET_CAL_TYPE = X_OFFSET_CAL_TYPE
     and OFFSET_CI_SEQUENCE_NUMBER = X_OFFSET_CI_SEQUENCE_NUMBER
     and OFFSET_DT_ALIAS = X_OFFSET_DT_ALIAS
     and OFFSET_DAI_SEQUENCE_NUMBER = X_OFFSET_DAI_SEQUENCE_NUMBER
     and S_DT_OFFSET_CONSTRAINT_TYPE = X_S_DT_OFFSET_CONSTRAINT_TYPE
  ;

Line: 773


    INSERT_ROW (
     X_ROWID,
     X_CAL_TYPE,
     X_CI_SEQUENCE_NUMBER,
     X_DT_ALIAS,
     X_DAI_SEQUENCE_NUMBER,
     X_OFFSET_CAL_TYPE,
     X_OFFSET_CI_SEQUENCE_NUMBER,
     X_OFFSET_DT_ALIAS,
     X_OFFSET_DAI_SEQUENCE_NUMBER,
     X_S_DT_OFFSET_CONSTRAINT_TYPE,
     X_CONSTRAINT_CONDITION,
     X_CONSTRAINT_RESOLUTION,
     X_MODE);

Line: 790


  UPDATE_ROW (
   X_ROWID,
   X_CAL_TYPE,
   X_CI_SEQUENCE_NUMBER,
   X_DT_ALIAS,
   X_DAI_SEQUENCE_NUMBER,
   X_OFFSET_CAL_TYPE,
   X_OFFSET_CI_SEQUENCE_NUMBER,
   X_OFFSET_DT_ALIAS,
   X_OFFSET_DAI_SEQUENCE_NUMBER,
   X_S_DT_OFFSET_CONSTRAINT_TYPE,
   X_CONSTRAINT_CONDITION,
   X_CONSTRAINT_RESOLUTION,
   X_MODE);

Line: 806


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

Line: 813


  delete from IGS_CA_DA_INST_OFCNT
  where ROWID = X_ROWID;

Line: 819


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

Line: 822


end DELETE_ROW;