DBA Data[Home] [Help]

APPS.IGS_CA_DA_INST_OFST_PKG SQL Statements

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

Line: 25

    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_OFST
      WHERE    rowid = x_rowid;
Line: 43

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

      Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
Line: 66

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

    new_references.last_update_date := x_last_update_date;
Line: 74

    new_references.last_updated_by := x_last_updated_by;
Line: 75

    new_references.last_update_login := x_last_update_login;
Line: 85

  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(80);
Line: 95

		-- Validate delete of date alias insert offset
		IF IGS_CA_VAL_DAIO.calp_val_daio_del (old_references.dt_alias,
			old_references.dai_sequence_number,
			old_references.cal_type,
			old_references.ci_sequence_number,
			old_references.offset_dt_alias,
			old_references.offset_dai_sequence_number,
			old_references.offset_cal_type,
			old_references.offset_ci_sequence_number,
			v_message_name) = FALSE
		THEN
			    Fnd_Message.Set_Name('IGS',v_message_name);
Line: 111

  END BeforeRowInsertUpdateDelete1;
Line: 118

  PROCEDURE AfterStmtInsertUpdateDelete3(
    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: 126

  	IF p_inserting THEN
  		-- Validate insert of date alias insert offset
  		IF IGS_CA_VAL_DAIO.calp_val_daio_ins (NVL (new_references.dt_alias, old_references.dt_alias),
  			NVL (new_references.dai_sequence_number, old_references.dai_sequence_number),
  			NVL (new_references.cal_type, old_references.cal_type),
  			NVL (new_references.ci_sequence_number, old_references.ci_sequence_number),
  			NVL (new_references.offset_dt_alias, old_references.offset_dt_alias),
  			NVL (new_references.offset_dai_sequence_number, old_references.offset_dai_sequence_number),
  			NVL (new_references.offset_cal_type, old_references.offset_cal_type),
  			NVL (new_references.offset_ci_sequence_number, old_references.offset_ci_sequence_number),
  			v_message_name) = FALSE
  		THEN
				Fnd_Message.Set_Name('IGS',v_message_name);
Line: 143

  END AfterStmtInsertUpdateDelete3;
Line: 255

	    Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
Line: 278

	    Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
Line: 314

      SELECT   rowid
      FROM     IGS_CA_DA_INST_OFST
      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
      FOR UPDATE NOWAIT;
Line: 349

      SELECT   rowid
      FROM     IGS_CA_DA_INST_OFST

      WHERE    (dt_alias = x_dt_alias
      AND      dai_sequence_number = x_sequence_number
      AND      cal_type = x_cal_type
      AND      ci_sequence_number = x_ci_sequence_number)
	OR	   (offset_dt_alias = x_dt_alias
      AND      offset_dai_sequence_number = x_sequence_number
      AND      offset_cal_type = x_cal_type
      AND      offset_ci_sequence_number = x_ci_sequence_number);
Line: 398

    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_offset_ci_sequence_number,
      x_day_offset,
      x_week_offset,
      x_month_offset,
      x_year_offset,
      x_ofst_override,
      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_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );
Line: 427

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

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

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

     ELSIF (p_action = 'VALIDATE_INSERT') THEN
      IF Get_PK_For_Validation (
    			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 )THEN
      	Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
Line: 469

    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      Check_Constraints;
Line: 471

    ELSIF (p_action = 'VALIDATE_DELETE') THEN
      Check_Child_Existance;
Line: 485

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

      AfterStmtInsertUpdateDelete3 ( p_inserting => TRUE );
Line: 489

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

    ELSIF (p_action = 'DELETE') THEN
      -- Call all the procedures related to After Delete.
      AfterStmtInsertUpdateDelete3 ( p_deleting => TRUE );
Line: 499

procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_DT_ALIAS in VARCHAR2,
  X_DAI_SEQUENCE_NUMBER in NUMBER,
  X_CAL_TYPE in VARCHAR2,
  X_CI_SEQUENCE_NUMBER in NUMBER,
  X_OFFSET_DT_ALIAS in VARCHAR2,
  X_OFFSET_DAI_SEQUENCE_NUMBER in NUMBER,
  X_OFFSET_CAL_TYPE in VARCHAR2,
  X_OFFSET_CI_SEQUENCE_NUMBER in NUMBER,
  X_DAY_OFFSET in NUMBER,
  X_WEEK_OFFSET in NUMBER,
  X_MONTH_OFFSET in NUMBER,
  X_YEAR_OFFSET in NUMBER,
  X_OFST_OVERRIDE in VARCHAR2,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    cursor C is select ROWID from IGS_CA_DA_INST_OFST
      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: 525

    X_LAST_UPDATE_DATE DATE;
Line: 526

    X_LAST_UPDATED_BY NUMBER;
Line: 527

    X_LAST_UPDATE_LOGIN NUMBER;
Line: 529

  X_LAST_UPDATE_DATE := SYSDATE;
Line: 531

    X_LAST_UPDATED_BY := 1;
Line: 532

    X_LAST_UPDATE_LOGIN := 0;
Line: 534

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 535

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;
Line: 538

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
Line: 539

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;
Line: 548

    p_action =>'INSERT',
    x_rowid =>X_ROWID,
    x_offset_ci_sequence_number =>X_OFFSET_CI_SEQUENCE_NUMBER,
    x_day_offset =>X_DAY_OFFSET,
    x_week_offset =>X_WEEK_OFFSET,
    x_month_offset =>X_MONTH_OFFSET,
    x_year_offset =>X_YEAR_OFFSET,
    x_ofst_override =>X_OFST_OVERRIDE,
    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_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: 569

  insert into IGS_CA_DA_INST_OFST (
    DT_ALIAS,
    DAI_SEQUENCE_NUMBER,
    CAL_TYPE,
    CI_SEQUENCE_NUMBER,
    OFFSET_DT_ALIAS,
    OFFSET_DAI_SEQUENCE_NUMBER,
    OFFSET_CAL_TYPE,
    OFFSET_CI_SEQUENCE_NUMBER,
    DAY_OFFSET,
    WEEK_OFFSET,
    MONTH_OFFSET,
    YEAR_OFFSET,
    OFST_OVERRIDE,
    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.DAY_OFFSET,
    NEW_REFERENCES.WEEK_OFFSET,
    NEW_REFERENCES.MONTH_OFFSET,
    NEW_REFERENCES.YEAR_OFFSET,
    NEW_REFERENCES.OFST_OVERRIDE,
    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: 621

end INSERT_ROW;
Line: 639

  cursor c1 is select
      DAY_OFFSET,
      WEEK_OFFSET,
      MONTH_OFFSET,
      YEAR_OFFSET,
      OFST_OVERRIDE
    from IGS_CA_DA_INST_OFST
    where ROWID = X_ROWID
    for update nowait;
Line: 655

    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
Line: 687

procedure UPDATE_ROW (
  X_ROWID in VARCHAR2,
  X_DT_ALIAS in VARCHAR2,
  X_DAI_SEQUENCE_NUMBER in NUMBER,
  X_CAL_TYPE in VARCHAR2,
  X_CI_SEQUENCE_NUMBER in NUMBER,
  X_OFFSET_DT_ALIAS in VARCHAR2,
  X_OFFSET_DAI_SEQUENCE_NUMBER in NUMBER,
  X_OFFSET_CAL_TYPE in VARCHAR2,
  X_OFFSET_CI_SEQUENCE_NUMBER in NUMBER,
  X_DAY_OFFSET in NUMBER,
  X_WEEK_OFFSET in NUMBER,
  X_MONTH_OFFSET in NUMBER,
  X_YEAR_OFFSET in NUMBER,
  X_OFST_OVERRIDE in VARCHAR2,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    X_LAST_UPDATE_DATE DATE;
Line: 705

    X_LAST_UPDATED_BY NUMBER;
Line: 706

    X_LAST_UPDATE_LOGIN NUMBER;
Line: 708

  X_LAST_UPDATE_DATE := SYSDATE;
Line: 710

    X_LAST_UPDATED_BY := 1;
Line: 711

    X_LAST_UPDATE_LOGIN := 0;
Line: 713

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 714

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;
Line: 717

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
Line: 718

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;
Line: 727

    p_action =>'UPDATE',
    x_rowid =>X_ROWID,
    x_offset_ci_sequence_number =>X_OFFSET_CI_SEQUENCE_NUMBER,
    x_day_offset =>X_DAY_OFFSET,
    x_week_offset =>X_WEEK_OFFSET,
    x_month_offset =>X_MONTH_OFFSET,
    x_year_offset =>X_YEAR_OFFSET,
    x_ofst_override =>X_OFST_OVERRIDE,
    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_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: 748

  update IGS_CA_DA_INST_OFST set
    DAY_OFFSET = NEW_REFERENCES.DAY_OFFSET,
    WEEK_OFFSET = NEW_REFERENCES.WEEK_OFFSET,
    MONTH_OFFSET = NEW_REFERENCES.MONTH_OFFSET,
    YEAR_OFFSET = NEW_REFERENCES.YEAR_OFFSET,
    OFST_OVERRIDE = NEW_REFERENCES.OFST_OVERRIDE,
    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: 763

    p_action =>'UPDATE',
    x_rowid =>X_ROWID
  );
Line: 766

end UPDATE_ROW;
Line: 785

  cursor c1 is select rowid from IGS_CA_DA_INST_OFST
     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: 800

    INSERT_ROW (
     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_DAY_OFFSET,
     X_WEEK_OFFSET,
     X_MONTH_OFFSET,
     X_YEAR_OFFSET,
     X_OFST_OVERRIDE,
     X_MODE);
Line: 819

  UPDATE_ROW (
   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_DAY_OFFSET,
   X_WEEK_OFFSET,
   X_MONTH_OFFSET,
   X_YEAR_OFFSET,
   X_OFST_OVERRIDE,
   X_MODE);
Line: 837

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

  delete from IGS_CA_DA_INST_OFST
  where ROWID = X_ROWID;
Line: 851

    p_action =>'DELETE',
    x_rowid =>X_ROWID
  );
Line: 854

end DELETE_ROW;