APPS.IGS_AS_STD_EXM_INSTN_PKG SQL Statements

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

Line: 34

    x_last_update_date IN DATE DEFAULT NULL,
    x_last_updated_by IN NUMBER DEFAULT NULL,
    x_last_update_login IN NUMBER DEFAULT NULL,
    x_uoo_id IN NUMBER DEFAULT NULL,
    x_std_exm_instn_id IN NUMBER DEFAULT NULL
  ) AS

    CURSOR cur_old_ref_values IS
      SELECT   *
      FROM     IGS_AS_STD_EXM_INSTN_ALL
      WHERE    rowid = x_rowid;

Line: 54

    IF (cur_old_ref_values%NOTFOUND) AND (p_action  NOT IN ('INSERT','VALIDATE_INSERT')) THEN
      Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

Line: 87

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

Line: 94

    new_references.last_update_date := x_last_update_date;

Line: 95

    new_references.last_updated_by := x_last_updated_by;

Line: 96

    new_references.last_update_login := x_last_update_login;

Line: 106

  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: 136

  END BeforeRowInsert1;

Line: 144

  PROCEDURE AfterRowInsert2(
    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: 177

  END AfterRowInsert2;

Line: 237

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

Line: 249

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

Line: 273

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

Line: 291

      SELECT   rowid
      FROM     IGS_AS_STD_EXM_INSTN_ALL
      WHERE    std_exm_instn_id = x_std_exm_instn_id
      FOR UPDATE NOWAIT;

Line: 327

    SELECT ROWID
    FROM   IGS_AS_STD_EXM_INSTN_ALL
    WHERE  ass_id   = x_ass_id
    AND    exam_cal_type   = x_exam_cal_type
    AND    exam_ci_sequence_number = x_exam_ci_sequence_number
    AND    start_time  = x_start_time
    AND    end_time    = x_end_time
    AND    venue_cd    =x_venue_cd
    AND    person_id   =x_person_id
    AND    course_cd   = x_course_cd
    AND    creation_dt =x_creation_dt
    AND    uoo_id         =x_uoo_id
    AND    dt_alias = x_dt_alias
    AND   dai_sequence_number = x_dai_sequence_number
    AND    ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line: 369

      SELECT   rowid
      FROM     IGS_AS_STD_EXM_INSTN_ALL
      WHERE    ass_id = x_ass_id
      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
      AND      venue_cd = x_venue_cd ;

Line: 403

      SELECT   rowid
      FROM     IGS_AS_STD_EXM_INSTN_ALL
      WHERE    ese_id = x_ese_id ;

Line: 434

      SELECT   rowid
      FROM     IGS_AS_STD_EXM_INSTN_ALL
      WHERE    person_id = x_person_id
      AND      course_cd = x_course_cd
      AND      ass_id = x_ass_id
      AND      creation_dt = x_creation_dt
      AND      uoo_id = x_uoo_id;

Line: 485

    x_last_update_date IN DATE DEFAULT NULL,
    x_last_updated_by IN NUMBER DEFAULT NULL,
    x_last_update_login IN NUMBER DEFAULT NULL,
    x_uoo_id in NUMBER DEFAULT NULL,
    x_std_exm_instn_id in NUMBER DEFAULT NULL
  ) AS
  BEGIN

    Set_Column_Values (
      p_action,
      x_rowid,
      x_org_id,
      x_seat_number,
      x_timeslot,
      x_timeslot_duration,
      x_ass_id,
      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_venue_cd,
      x_person_id,
      x_course_cd,
      x_unit_cd,
      x_cal_type,
      x_ci_sequence_number,
      x_creation_dt,
      x_attendance_ind,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login,
      x_uoo_id,
      x_std_exm_instn_id
    );

Line: 525

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

Line: 540

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

       Check_Constraints;

Line: 548

	ELSIF (p_action = 'VALIDATE_INSERT') THEN
	     IF  Get_PK_For_Validation (
	       NEW_REFERENCES.std_exm_instn_id) THEN
         Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');

Line: 558

	ELSIF (p_action = 'VALIDATE_UPDATE') THEN

	      Check_Constraints;

Line: 576

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

Line: 586

procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_ORG_ID in NUMBER,
  X_ASS_ID in NUMBER,
  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_VENUE_CD in VARCHAR2,
  X_PERSON_ID in NUMBER,
  X_COURSE_CD in VARCHAR2,
  X_UNIT_CD in VARCHAR2,
  X_CAL_TYPE in VARCHAR2,
  X_CI_SEQUENCE_NUMBER in NUMBER,
  X_CREATION_DT in DATE,
  X_SEAT_NUMBER in NUMBER,
  X_TIMESLOT in DATE,
  X_TIMESLOT_DURATION in DATE,
  X_ESE_ID in NUMBER,
  X_ATTENDANCE_IND in VARCHAR2,
  X_MODE in VARCHAR2 default 'R',
  X_UOO_ID in NUMBER,
  X_STD_EXM_INSTN_ID in out NOCOPY NUMBER
  ) AS
  /*---------------------------------------------------------------------------------------
  --Change History
  --Who		when		What
  --sbaliga	12-feb-2002	Assigned igs_ge_gen_003.get_org_id to x_org_id
  --				in call to before_dml as part of SWCR006 build.
  --svanukur 29-apr-03  changed the where clause to reflect the new PK
  --                     as part of MUS build, # 2829262
  ---------------------------------------------------------------------------------------*/
    cursor C is select ROWID from IGS_AS_STD_EXM_INSTN_ALL
      where STD_EXM_INSTN_ID = X_STD_EXM_INSTN_ID;

Line: 622

    X_LAST_UPDATE_DATE DATE;

Line: 623

    X_LAST_UPDATED_BY NUMBER;

Line: 624

    X_LAST_UPDATE_LOGIN NUMBER;

Line: 626

  X_LAST_UPDATE_DATE := SYSDATE;

Line: 628

    X_LAST_UPDATED_BY := 1;

Line: 629

    X_LAST_UPDATE_LOGIN := 0;

Line: 631

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 632

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 635

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 636

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 645

SELECT IGS_AS_STD_EXM_INSTN_ALL_S.nextval
INTO X_STD_EXM_INSTN_ID
FROM DUAL;

Line: 650

  p_action=>'INSERT',
  x_rowid=>X_ROWID,
  x_org_id=>igs_ge_gen_003.get_org_id,
  x_ass_id=>X_ASS_ID,
  x_attendance_ind=>X_ATTENDANCE_IND,
  x_cal_type=>X_CAL_TYPE,
  x_ci_sequence_number=>X_CI_SEQUENCE_NUMBER,
  x_course_cd=>X_COURSE_CD,
  x_creation_dt=>X_CREATION_DT,
  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_person_id=>X_PERSON_ID,
  x_seat_number=>X_SEAT_NUMBER,
  x_start_time=>X_START_TIME,
  x_timeslot=>X_TIMESLOT,
  x_timeslot_duration=>X_TIMESLOT_DURATION,
  x_unit_cd=>X_UNIT_CD,
  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,
  x_uoo_id => X_UOO_ID,
  x_std_exm_instn_id =>X_STD_EXM_INSTN_ID
  );

Line: 684

  insert into IGS_AS_STD_EXM_INSTN_ALL (
    ORG_ID,
    SEAT_NUMBER,

    TIMESLOT,
    TIMESLOT_DURATION,
    ASS_ID,
    EXAM_CAL_TYPE,
    EXAM_CI_SEQUENCE_NUMBER,
    DT_ALIAS,
    DAI_SEQUENCE_NUMBER,
    START_TIME,
    END_TIME,
    ESE_ID,
    VENUE_CD,
    PERSON_ID,
    COURSE_CD,
    UNIT_CD,
    CAL_TYPE,
    CI_SEQUENCE_NUMBER,
    CREATION_DT,
    ATTENDANCE_IND,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    UOO_ID,
    STD_EXM_INSTN_ID
  ) values (
        new_references.ORG_ID,
    	new_references.SEAT_NUMBER,
    	new_references.TIMESLOT,
    	new_references.TIMESLOT_DURATION,
    	new_references.ASS_ID,
    	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.VENUE_CD,
    	new_references.PERSON_ID,
    	new_references.COURSE_CD,
    	new_references.UNIT_CD,
    	new_references.CAL_TYPE,
    	new_references.CI_SEQUENCE_NUMBER,
    	new_references.CREATION_DT,
    	new_references.ATTENDANCE_IND,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    new_references.uoo_id,
    new_references.STD_EXM_INSTN_ID
  );

Line: 755

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

Line: 772

end INSERT_ROW;

Line: 798

  cursor c1 is select
      SEAT_NUMBER,
      TIMESLOT,
      TIMESLOT_DURATION,
      ESE_ID,
      ATTENDANCE_IND
    from IGS_AS_STD_EXM_INSTN_ALL
    where ROWID = X_ROWID  for update  nowait;

Line: 812

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

Line: 842

procedure UPDATE_ROW (
  X_ROWID in  VARCHAR2,
  X_ASS_ID in NUMBER,
  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_VENUE_CD in VARCHAR2,
  X_PERSON_ID in NUMBER,
  X_COURSE_CD in VARCHAR2,
  X_UNIT_CD in VARCHAR2,
  X_CAL_TYPE in VARCHAR2,
  X_CI_SEQUENCE_NUMBER in NUMBER,
  X_CREATION_DT in DATE,
  X_SEAT_NUMBER in NUMBER,
    X_TIMESLOT in DATE,
  X_TIMESLOT_DURATION in DATE,
  X_ESE_ID in NUMBER,
  X_ATTENDANCE_IND in VARCHAR2,
  X_MODE in VARCHAR2 default 'R',
  X_UOO_ID in NUMBER,
  X_STD_EXM_INSTN_ID in NUMBER
  ) AS
    X_LAST_UPDATE_DATE DATE;

Line: 868

    X_LAST_UPDATED_BY NUMBER;

Line: 869

    X_LAST_UPDATE_LOGIN NUMBER;

Line: 871

  X_LAST_UPDATE_DATE := SYSDATE;

Line: 873

    X_LAST_UPDATED_BY := 1;

Line: 874

    X_LAST_UPDATE_LOGIN := 0;

Line: 876

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 877

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 880

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 881

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 890

  p_action=>'UPDATE',
  x_rowid=>X_ROWID,
  x_ass_id=>X_ASS_ID,
  x_attendance_ind=>X_ATTENDANCE_IND,
  x_cal_type=>X_CAL_TYPE,
  x_ci_sequence_number=>X_CI_SEQUENCE_NUMBER,
  x_course_cd=>X_COURSE_CD,
  x_creation_dt=>X_CREATION_DT,
  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_person_id=>X_PERSON_ID,
  x_seat_number=>X_SEAT_NUMBER,
  x_start_time=>X_START_TIME,
  x_timeslot=>X_TIMESLOT,
  x_timeslot_duration=>X_TIMESLOT_DURATION,
  x_unit_cd=>X_UNIT_CD,
  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,
  x_uoo_id => X_UOO_ID,
  x_std_exm_instn_id => X_STD_EXM_INSTN_ID
  );

Line: 922

  update IGS_AS_STD_EXM_INSTN_ALL set
    SEAT_NUMBER = 	new_references.SEAT_NUMBER,
       TIMESLOT = 	new_references.TIMESLOT,
    TIMESLOT_DURATION = 	new_references.TIMESLOT_DURATION,
    ESE_ID = 	new_references.ESE_ID,
    ATTENDANCE_IND = 	new_references.ATTENDANCE_IND,
    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: 944

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

Line: 960

end UPDATE_ROW;

Line: 988

  cursor c1 is select rowid from IGS_AS_STD_EXM_INSTN_ALL
     where std_exm_instn_id = X_STD_EXM_INSTN_ID;

Line: 998

    INSERT_ROW (
     X_ROWID,
     X_ORG_ID,
     X_ASS_ID,
     X_EXAM_CAL_TYPE,
     X_EXAM_CI_SEQUENCE_NUMBER,
     X_DT_ALIAS,
     X_DAI_SEQUENCE_NUMBER,
     X_START_TIME,
     X_END_TIME,
     X_VENUE_CD,
     X_PERSON_ID,
     X_COURSE_CD,
     X_UNIT_CD,
     X_CAL_TYPE,
     X_CI_SEQUENCE_NUMBER,
     X_CREATION_DT,
     X_SEAT_NUMBER,
     X_TIMESLOT,
     X_TIMESLOT_DURATION,
     X_ESE_ID,
     X_ATTENDANCE_IND,
     X_MODE,
     X_UOO_ID,
     X_STD_EXM_INSTN_ID);

Line: 1026

  UPDATE_ROW (
   X_ROWID,
   X_ASS_ID,
   X_EXAM_CAL_TYPE,
   X_EXAM_CI_SEQUENCE_NUMBER,
   X_DT_ALIAS,
   X_DAI_SEQUENCE_NUMBER,
   X_START_TIME,
   X_END_TIME,
   X_VENUE_CD,
   X_PERSON_ID,
   X_COURSE_CD,
   X_UNIT_CD,
   X_CAL_TYPE,
   X_CI_SEQUENCE_NUMBER,
   X_CREATION_DT,
   X_SEAT_NUMBER,
      X_TIMESLOT,
   X_TIMESLOT_DURATION,
   X_ESE_ID,
   X_ATTENDANCE_IND,
   X_MODE,
   X_UOO_ID,
   X_STD_EXM_INSTN_ID);

Line: 1052

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

Line: 1065

  delete from IGS_AS_STD_EXM_INSTN_ALL
   where ROWID = X_ROWID;

Line: 1078

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

Line: 1081

end DELETE_ROW;