APPS.IGS_AS_EXMVNU_SESAVL_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_AS_EXMVNU_SESAVL_ALL
      WHERE    rowid = x_rowid;

Line: 40

    IF (cur_old_ref_values%NOTFOUND) AND (p_action  NOT IN ('INSERT','VALIDATE_INSERT')) THEN
      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: 80

  PROCEDURE BeforeRowInsert1(
    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: 96

	-- Validate that inserts are allowed
	IF  p_inserting THEN
		-- 
		-- Cannot create against closed IGS_GR_VENUE
		IF  igs_gr_val_gc.assp_val_ve_closed (
						new_references.venue_cd,
						v_message_name) = FALSE THEN
			FND_MESSAGE.SET_NAME('IGS',v_message_name);

Line: 120

  END BeforeRowInsert1;

Line: 131

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

Line: 158

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

Line: 169

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

Line: 188

      SELECT   rowid
      FROM     IGS_AS_EXMVNU_SESAVL_ALL
      WHERE    venue_cd = x_venue_cd
      AND      exam_cal_type = x_exam_cal_type
      AND      exam_ci_sequence_number = x_exam_ci_sequence_number
      AND      dt_alias = x_dt_alias
      AND      dai_sequence_number = x_dai_sequence_number
      AND      start_time = x_start_time
      AND      end_time = x_end_time
      FOR UPDATE NOWAIT;

Line: 219

      SELECT   rowid
      FROM     IGS_AS_EXMVNU_SESAVL_ALL
      WHERE    ese_id = x_ese_id ;

Line: 251

      SELECT   rowid
      FROM     IGS_AS_EXMVNU_SESAVL_ALL
      WHERE    exam_cal_type = x_exam_cal_type
      AND      exam_ci_sequence_number = x_exam_ci_sequence_number
      AND      dt_alias = x_dt_alias
      AND      dai_sequence_number = x_dai_sequence_number
      AND      start_time = x_start_time
      AND      end_time = x_end_time ;

Line: 283

      SELECT   rowid
      FROM     IGS_AS_EXMVNU_SESAVL_ALL
      WHERE    venue_cd = x_venue_cd ;

Line: 320

    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_venue_cd,
      x_exam_cal_type,
      x_exam_ci_sequence_number,
      x_dt_alias,
      x_dai_sequence_number,
      x_start_time,
      x_end_time,
      x_ese_id,
      x_comments,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );

Line: 346

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

Line: 365

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

           Check_Constraints;

Line: 372

	ELSIF (p_action = 'VALIDATE_INSERT') THEN
	     IF  Get_PK_For_Validation ( NEW_REFERENCES.venue_cd,
     NEW_REFERENCES.exam_cal_type ,
    NEW_REFERENCES.exam_ci_sequence_number ,
    NEW_REFERENCES.dt_alias ,
    NEW_REFERENCES.dai_sequence_number ,
    NEW_REFERENCES.start_time ,
    NEW_REFERENCES.end_time) THEN
         Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');

Line: 386

	ELSIF (p_action = 'VALIDATE_UPDATE') THEN

	      Check_Constraints;

Line: 397

procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_ORG_ID in NUMBER,
  X_VENUE_CD in VARCHAR2,
  X_EXAM_CAL_TYPE in VARCHAR2,
  X_EXAM_CI_SEQUENCE_NUMBER in NUMBER,
  X_DT_ALIAS in VARCHAR2,
  X_DAI_SEQUENCE_NUMBER in NUMBER,
  X_START_TIME in DATE,
  X_END_TIME in DATE,
  X_ESE_ID in NUMBER,
  X_COMMENTS in VARCHAR2,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    cursor C is select ROWID from IGS_AS_EXMVNU_SESAVL_ALL
      where VENUE_CD = X_VENUE_CD
      and EXAM_CAL_TYPE = X_EXAM_CAL_TYPE
      and EXAM_CI_SEQUENCE_NUMBER = X_EXAM_CI_SEQUENCE_NUMBER
      and DT_ALIAS = X_DT_ALIAS
      and DAI_SEQUENCE_NUMBER = X_DAI_SEQUENCE_NUMBER
      and START_TIME = X_START_TIME
      and END_TIME = X_END_TIME;

Line: 419

    X_LAST_UPDATE_DATE DATE;

Line: 420

    X_LAST_UPDATED_BY NUMBER;

Line: 421

    X_LAST_UPDATE_LOGIN NUMBER;

Line: 425

    X_PROGRAM_UPDATE_DATE DATE;

Line: 427

  X_LAST_UPDATE_DATE := SYSDATE;

Line: 429

    X_LAST_UPDATED_BY := 1;

Line: 430

    X_LAST_UPDATE_LOGIN := 0;

Line: 432

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 433

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 436

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 437

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 447

     X_PROGRAM_UPDATE_DATE := NULL;

Line: 449

     X_PROGRAM_UPDATE_DATE := SYSDATE;

Line: 457

  p_action=>'INSERT',
  x_rowid=>X_ROWID,
  x_org_id => igs_ge_gen_003.get_org_id,
  x_comments=>X_COMMENTS,
  x_dai_sequence_number=>X_DAI_SEQUENCE_NUMBER,
  x_dt_alias=>X_DT_ALIAS,
  x_end_time=>X_END_TIME,
  x_ese_id=>X_ESE_ID,
  x_exam_cal_type=>X_EXAM_CAL_TYPE,
  x_exam_ci_sequence_number=>X_EXAM_CI_SEQUENCE_NUMBER,
  x_start_time=>X_START_TIME,
  x_venue_cd=>X_VENUE_CD,
  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: 475

  insert into IGS_AS_EXMVNU_SESAVL_ALL (
        ORG_ID,
    VENUE_CD,
    EXAM_CAL_TYPE,
    EXAM_CI_SEQUENCE_NUMBER,
    DT_ALIAS,
    DAI_SEQUENCE_NUMBER,
    START_TIME,
    END_TIME,
    ESE_ID,
    COMMENTS,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    REQUEST_ID,
    PROGRAM_ID,
    PROGRAM_APPLICATION_ID,
    PROGRAM_UPDATE_DATE
  ) values (
       NEW_REFERENCES.ORG_ID,
    new_references.VENUE_CD,
    new_references.EXAM_CAL_TYPE,
    new_references.EXAM_CI_SEQUENCE_NUMBER,
    new_references.DT_ALIAS,
    new_references.DAI_SEQUENCE_NUMBER,
    new_references.START_TIME,
    new_references.END_TIME,
    new_references.ESE_ID,
    new_references.COMMENTS,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_REQUEST_ID,
    X_PROGRAM_ID,
    X_PROGRAM_APPLICATION_ID,
    X_PROGRAM_UPDATE_DATE
  );

Line: 525

end INSERT_ROW;

Line: 539

  cursor c1 is select
      ESE_ID,
      COMMENTS
    from IGS_AS_EXMVNU_SESAVL_all
    where ROWID = X_ROWID
    for update nowait;

Line: 551

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

Line: 573

procedure UPDATE_ROW (
  X_ROWID in  VARCHAR2,
  X_VENUE_CD in VARCHAR2,
  X_EXAM_CAL_TYPE in VARCHAR2,
  X_EXAM_CI_SEQUENCE_NUMBER in NUMBER,
  X_DT_ALIAS in VARCHAR2,
  X_DAI_SEQUENCE_NUMBER in NUMBER,
  X_START_TIME in DATE,
  X_END_TIME in DATE,
  X_ESE_ID in NUMBER,
  X_COMMENTS in VARCHAR2,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    X_LAST_UPDATE_DATE DATE;

Line: 587

    X_LAST_UPDATED_BY NUMBER;

Line: 588

    X_LAST_UPDATE_LOGIN NUMBER;

Line: 592

    X_PROGRAM_UPDATE_DATE DATE;

Line: 594

  X_LAST_UPDATE_DATE := SYSDATE;

Line: 596

    X_LAST_UPDATED_BY := 1;

Line: 597

    X_LAST_UPDATE_LOGIN := 0;

Line: 599

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 600

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 603

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 604

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 613

  p_action=>'UPDATE',
  x_rowid=>X_ROWID,
  x_comments=>X_COMMENTS,
  x_dai_sequence_number=>X_DAI_SEQUENCE_NUMBER,
  x_dt_alias=>X_DT_ALIAS,
  x_end_time=>X_END_TIME,
  x_ese_id=>X_ESE_ID,
  x_exam_cal_type=>X_EXAM_CAL_TYPE,
  x_exam_ci_sequence_number=>X_EXAM_CI_SEQUENCE_NUMBER,
  x_start_time=>X_START_TIME,
  x_venue_cd=>X_VENUE_CD,
  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: 639

     X_PROGRAM_UPDATE_DATE := OLD_REFERENCES.PROGRAM_UPDATE_DATE;

Line: 641

     X_PROGRAM_UPDATE_DATE := SYSDATE;

Line: 645

  update IGS_AS_EXMVNU_SESAVL_ALL set
    ESE_ID = new_references.ESE_ID,
    COMMENTS = new_references.COMMENTS,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    REQUEST_ID = X_REQUEST_ID,
    PROGRAM_ID = X_PROGRAM_ID,
    PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID,
    PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE
  where ROWID= X_ROWID
  ;

Line: 662

end UPDATE_ROW;

Line: 678

  cursor c1 is select rowid from IGS_AS_EXMVNU_SESAVL_ALL
     where VENUE_CD = X_VENUE_CD
     and EXAM_CAL_TYPE = X_EXAM_CAL_TYPE
     and EXAM_CI_SEQUENCE_NUMBER = X_EXAM_CI_SEQUENCE_NUMBER
     and DT_ALIAS = X_DT_ALIAS
     and DAI_SEQUENCE_NUMBER = X_DAI_SEQUENCE_NUMBER
     and START_TIME = X_START_TIME
     and END_TIME = X_END_TIME
  ;

Line: 693

    INSERT_ROW (
     X_ROWID,
     X_ORG_ID,
     X_VENUE_CD,
     X_EXAM_CAL_TYPE,
     X_EXAM_CI_SEQUENCE_NUMBER,
     X_DT_ALIAS,
     X_DAI_SEQUENCE_NUMBER,
     X_START_TIME,
     X_END_TIME,
     X_ESE_ID,
     X_COMMENTS,
     X_MODE);

Line: 709

  UPDATE_ROW (
   X_ROWID ,
   X_VENUE_CD,
   X_EXAM_CAL_TYPE,
   X_EXAM_CI_SEQUENCE_NUMBER,
   X_DT_ALIAS,
   X_DAI_SEQUENCE_NUMBER,
   X_START_TIME,
   X_END_TIME,
   X_ESE_ID,
   X_COMMENTS,
   X_MODE);

Line: 723

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

Line: 731

  delete from IGS_AS_EXMVNU_SESAVL_ALL
  where ROWID = X_ROWID;

Line: 737

end DELETE_ROW;