DBA Data[Home] [Help]

APPS.IGS_EN_INST_WLST_OPT_PKG SQL Statements

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

Line: 17

    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

  /*************************************************************
  Created By : ahemmige
  Date Created : 20-MAY-2000
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

  (reverse chronological order - newest change first)
  ***************************************************************/

    CURSOR cur_old_ref_values IS
      SELECT   *
      FROM     IGS_EN_INST_WLST_OPT_ALL
      WHERE    rowid = x_rowid;
Line: 46

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

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

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

    new_references.last_update_date := x_last_update_date;
Line: 69

    new_references.last_updated_by := x_last_updated_by;
Line: 70

    new_references.last_update_login := x_last_update_login;
Line: 145

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

      SELECT   rowid
      FROM     IGS_EN_INST_WLST_OPT_ALL
      WHERE    inst_waitlist_id = x_inst_waitlist_id
      FOR UPDATE NOWAIT;
Line: 205

      SELECT   rowid
      FROM     IGS_EN_INST_WLST_OPT_ALL
      WHERE    cal_type = x_cal_type
      	and      ((l_rowid is null) or (rowid <> l_rowid))

      ;
Line: 242

      SELECT   rowid
      FROM     IGS_EN_INST_WLST_OPT_ALL
      WHERE    cal_type = x_cal_type ;
Line: 285

      SELECT   rowid
      FROM     igs_en_or_unit_wlst_all
      WHERE    cal_type = x_cal_type
      AND      sequence_number = x_sequence_number ;
Line: 319

    x_last_update_date IN DATE ,
    x_last_updated_by IN NUMBER ,
    x_last_update_login IN NUMBER
  ) AS
  /*************************************************************
  Created By : ahemmige
  Date Created : 20-MAY-2000
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

  (reverse chronological order - newest change first)
  ***************************************************************/

  BEGIN

    Set_Column_Values (
      p_action,
      x_rowid,
      x_org_id,
      x_inst_waitlist_id,
      x_cal_type,
      x_waitlist_alwd,
      x_smlnes_waitlist_alwd,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );
Line: 351

    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to Before Insert.
      Null;
Line: 363

    ELSIF (p_action = 'UPDATE') THEN
      -- Call all the procedures related to Before Update.
      Null;
Line: 369

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

    ELSIF (p_action = 'VALIDATE_INSERT') THEN
	 -- Call all the procedures related to Before Insert.
      IF Get_PK_For_Validation (
    		new_references.inst_waitlist_id)  THEN
	       Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
Line: 382

    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      Check_Uniqueness;
Line: 385

    ELSIF (p_action = 'VALIDATE_DELETE') THEN
      Null;
Line: 410

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

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

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

 procedure INSERT_ROW (
      X_ROWID in out NOCOPY VARCHAR2,
       X_ORG_ID in NUMBER,
       x_INST_WAITLIST_ID IN OUT NOCOPY NUMBER,
       x_CAL_TYPE IN VARCHAR2,
       x_WAITLIST_ALWD IN VARCHAR2,
       x_SMLNES_WAITLIST_ALWD IN VARCHAR2,
      X_MODE in VARCHAR2
  ) AS
  /*************************************************************
  Created By : ahemmige
  Date Created : 20-MAY-2000
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

  (reverse chronological order - newest change first)
  ***************************************************************/

    cursor C is select ROWID from IGS_EN_INST_WLST_OPT_ALL
             where                 INST_WAITLIST_ID= X_INST_WAITLIST_ID
;
Line: 446

     X_LAST_UPDATE_DATE DATE ;
Line: 447

     X_LAST_UPDATED_BY NUMBER ;
Line: 448

     X_LAST_UPDATE_LOGIN NUMBER ;
Line: 450

     X_LAST_UPDATE_DATE := SYSDATE;
Line: 452

        X_LAST_UPDATED_BY := 1;
Line: 453

        X_LAST_UPDATE_LOGIN := 0;
Line: 455

               X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 456

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

            X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
Line: 460

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

   select IGS_EN_INST_WLST_OPT_S.nextval into x_inst_waitlist_id from dual;
Line: 470

 		p_action=>'INSERT',
 		x_rowid=>X_ROWID,
               x_org_id => igs_ge_gen_003.get_org_id,
 	       x_inst_waitlist_id=>X_INST_WAITLIST_ID,
 	       x_cal_type=>X_CAL_TYPE,
 	       x_waitlist_alwd=>X_WAITLIST_ALWD,
 	       x_smlnes_waitlist_alwd=>X_SMLNES_WAITLIST_ALWD,
	       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: 482

     insert into IGS_EN_INST_WLST_OPT_ALL (
		org_id
		,INST_WAITLIST_ID
		,CAL_TYPE
		,WAITLIST_ALWD
		,SMLNES_WAITLIST_ALWD
	        ,CREATION_DATE
		,CREATED_BY
		,LAST_UPDATE_DATE
		,LAST_UPDATED_BY
		,LAST_UPDATE_LOGIN
        ) values  (
                NEW_REFERENCES.ORG_ID
	        ,NEW_REFERENCES.INST_WAITLIST_ID
	        ,NEW_REFERENCES.CAL_TYPE
	        ,NEW_REFERENCES.WAITLIST_ALWD
	        ,NEW_REFERENCES.SMLNES_WAITLIST_ALWD
	        ,X_LAST_UPDATE_DATE
		,X_LAST_UPDATED_BY
		,X_LAST_UPDATE_DATE
		,X_LAST_UPDATED_BY
		,X_LAST_UPDATE_LOGIN
);
Line: 513

		p_action => 'INSERT' ,
		x_rowid => X_ROWID );
Line: 515

end INSERT_ROW;
Line: 534

   cursor c1 is select
          CAL_TYPE,

      WAITLIST_ALWD
,      SMLNES_WAITLIST_ALWD
    from IGS_EN_INST_WLST_OPT_ALL
    where ROWID = X_ROWID
    for update nowait;
Line: 547

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

 Procedure UPDATE_ROW (
      X_ROWID in  VARCHAR2,
       x_INST_WAITLIST_ID IN NUMBER,
       x_CAL_TYPE IN VARCHAR2,
        x_WAITLIST_ALWD IN VARCHAR2,
       x_SMLNES_WAITLIST_ALWD IN VARCHAR2,
      X_MODE in VARCHAR2
  ) AS
  /*************************************************************
  Created By : ahemmige
  Date Created : 20-MAY-2000
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

  (reverse chronological order - newest change first)
  ***************************************************************/

     X_LAST_UPDATE_DATE DATE ;
Line: 587

     X_LAST_UPDATED_BY NUMBER ;
Line: 588

     X_LAST_UPDATE_LOGIN NUMBER ;
Line: 590

     X_LAST_UPDATE_DATE := SYSDATE;
Line: 592

        X_LAST_UPDATED_BY := 1;
Line: 593

        X_LAST_UPDATE_LOGIN := 0;
Line: 595

               X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 596

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

            X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
Line: 600

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

 		p_action=>'UPDATE',
 		x_rowid=>X_ROWID,
 	       x_inst_waitlist_id=>X_INST_WAITLIST_ID,
 	       x_cal_type=>X_CAL_TYPE,
 	       x_waitlist_alwd=>X_WAITLIST_ALWD,
 	       x_smlnes_waitlist_alwd=>X_SMLNES_WAITLIST_ALWD,
	       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: 620

   update IGS_EN_INST_WLST_OPT_ALL set
      CAL_TYPE =  NEW_REFERENCES.CAL_TYPE,
       WAITLIST_ALWD =  NEW_REFERENCES.WAITLIST_ALWD,
      SMLNES_WAITLIST_ALWD =  NEW_REFERENCES.SMLNES_WAITLIST_ALWD,
	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: 633

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

end UPDATE_ROW;
Line: 657

    cursor c1 is select ROWID from IGS_EN_INST_WLST_OPT_ALL
             where     INST_WAITLIST_ID= X_INST_WAITLIST_ID
;
Line: 665

    INSERT_ROW (
      X_ROWID,
       x_org_id,
       X_INST_WAITLIST_ID,
       X_CAL_TYPE,
       X_WAITLIST_ALWD,
       X_SMLNES_WAITLIST_ALWD,
      X_MODE );
Line: 676

UPDATE_ROW (
      X_ROWID,
       X_INST_WAITLIST_ID,
       X_CAL_TYPE,
       X_WAITLIST_ALWD,
       X_SMLNES_WAITLIST_ALWD,
      X_MODE );
Line: 684

procedure DELETE_ROW (
  X_ROWID in VARCHAR2
) AS
  /*************************************************************
  Created By : ahemmige
  Date Created : 20-MAY-2000
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

  (reverse chronological order - newest change first)
  ***************************************************************/

begin
Before_DML (
p_action => 'DELETE',
x_rowid => X_ROWID
);
Line: 703

 delete from IGS_EN_INST_WLST_OPT_ALL
 where ROWID = X_ROWID;
Line: 709

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

end DELETE_ROW;