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

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

Line: 21


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

Line: 39


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

Line: 41


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

Line: 57


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

Line: 64


    new_references.last_update_date := x_last_update_date;

Line: 65


    new_references.last_updated_by := x_last_updated_by;

Line: 66


    new_references.last_update_login := x_last_update_login;

Line: 76


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


	IF p_inserting OR p_updating THEN
		v_course_cd := new_references.course_cd;

Line: 94


	-- Validate that inserts/updates/deletes are allowed
	IF IGS_PS_VAL_CRS.CRSP_VAL_IUD_CRV_DTL(v_course_cd,
				v_version_number,
				v_message_name) = FALSE THEN
		Fnd_Message.Set_Name('IGS',v_message_name);

Line: 102


	IF p_inserting THEN
		-- Validate calendar type is not closed.
		IF IGS_PS_VAL_CO.crsp_val_co_cal_type(
			new_references.cal_type,
			v_message_name) = FALSE THEN
		Fnd_Message.Set_Name('IGS',v_message_name);

Line: 121


	IF p_inserting OR p_updating THEN
		-- Validate entry assessment scores.
		IF IGS_PS_VAL_COi.crsp_val_ent_ass_scr(
			new_references.min_entry_ass_score,
			new_references.guaranteed_entry_ass_scr,
			v_message_name) = FALSE THEN
		Fnd_Message.Set_Name('IGS',v_message_name);

Line: 134


  END BeforeRowInsertUpdateDelete1;

Line: 212


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

Line: 231


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

Line: 260


      SELECT   rowid
      FROM     IGS_PS_OFR_INST
      WHERE    course_cd = x_course_cd
      AND      version_number = x_version_number
      AND      cal_type = x_cal_type
      AND      ci_sequence_number = x_ci_sequence_number
      FOR UPDATE NOWAIT;

Line: 292


      SELECT   rowid
      FROM     IGS_PS_OFR_INST
      WHERE    cal_type = x_cal_type
      AND      ci_sequence_number = x_sequence_number
      AND      ci_start_dt = x_start_dt
      AND      ci_end_dt = x_end_dt ;

Line: 323


      SELECT   rowid
      FROM     IGS_PS_OFR_INST
      WHERE    course_cd = x_course_cd
      AND      version_number = x_version_number
      AND      cal_type = x_cal_type ;

Line: 359


    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_course_cd,
      x_version_number,
      x_cal_type,
      x_ci_sequence_number,
      x_ci_start_dt,
      x_ci_end_dt,
      x_min_entry_ass_score,
      x_guaranteed_entry_ass_scr,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );

Line: 383


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

Line: 397


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

Line: 402


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

Line: 406


    ELSIF (p_action = 'VALIDATE_INSERT') THEN
	IF  Get_PK_For_Validation (
      new_references.course_cd,
      new_references.version_number,
      new_references.cal_type,
      new_references.ci_sequence_number) THEN
	    Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

Line: 417


    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
	Check_Constraints;

Line: 419


    ELSIF (p_action = 'VALIDATE_DELETE') THEN
      Check_Child_Existance;

Line: 436


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_COURSE_CD in VARCHAR2,
  X_VERSION_NUMBER in NUMBER,
  X_CAL_TYPE in VARCHAR2,
  X_CI_SEQUENCE_NUMBER in NUMBER,
  X_CI_START_DT in DATE,
  X_CI_END_DT in DATE,
  X_MIN_ENTRY_ASS_SCORE in NUMBER,
  X_GUARANTEED_ENTRY_ASS_SCR in NUMBER,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    cursor C is select ROWID from IGS_PS_OFR_INST
      where COURSE_CD = X_COURSE_CD
      and VERSION_NUMBER = X_VERSION_NUMBER
      and CAL_TYPE = X_CAL_TYPE
      and CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER;

Line: 453


    X_LAST_UPDATE_DATE DATE;

Line: 454


    X_LAST_UPDATED_BY NUMBER;

Line: 455


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 459


    X_PROGRAM_UPDATE_DATE DATE;

Line: 461


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 463


    X_LAST_UPDATED_BY := 1;

Line: 464


    X_LAST_UPDATE_LOGIN := 0;

Line: 466


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 467


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 470


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 471


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 481


       X_PROGRAM_UPDATE_DATE := NULL;

Line: 483


	 X_PROGRAM_UPDATE_DATE := SYSDATE;

Line: 491


    p_action => 'INSERT',
    x_rowid => X_ROWID,
    x_course_cd => X_COURSE_CD,
    x_version_number => X_VERSION_NUMBER,
    x_cal_type => X_CAL_TYPE,
    x_ci_sequence_number => X_CI_SEQUENCE_NUMBER,
    x_ci_start_dt => X_CI_START_DT ,
    x_ci_end_dt => X_CI_END_DT,
    x_min_entry_ass_score => X_MIN_ENTRY_ASS_SCORE ,
    x_guaranteed_entry_ass_scr => X_GUARANTEED_ENTRY_ASS_SCR ,
    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: 507


  insert into IGS_PS_OFR_INST (
    COURSE_CD,
    VERSION_NUMBER,
    CAL_TYPE,
    CI_SEQUENCE_NUMBER,
    CI_START_DT,
    CI_END_DT,
    MIN_ENTRY_ASS_SCORE,
    GUARANTEED_ENTRY_ASS_SCR,
    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.COURSE_CD,
    NEW_REFERENCES.VERSION_NUMBER,
    NEW_REFERENCES.CAL_TYPE,
    NEW_REFERENCES.CI_SEQUENCE_NUMBER,
    NEW_REFERENCES.CI_START_DT,
    NEW_REFERENCES.CI_END_DT,
    NEW_REFERENCES.MIN_ENTRY_ASS_SCORE,
    NEW_REFERENCES.GUARANTEED_ENTRY_ASS_SCR,
    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: 552


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

Line: 555


end INSERT_ROW;

Line: 568


  cursor c1 is select
      CI_START_DT,
      CI_END_DT,
      MIN_ENTRY_ASS_SCORE,
      GUARANTEED_ENTRY_ASS_SCR
    from IGS_PS_OFR_INST
    where ROWID = X_ROWID
    for update nowait;

Line: 583


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

Line: 608


procedure UPDATE_ROW (
  X_ROWID IN VARCHAR2,
  X_COURSE_CD in VARCHAR2,
  X_VERSION_NUMBER in NUMBER,
  X_CAL_TYPE in VARCHAR2,
  X_CI_SEQUENCE_NUMBER in NUMBER,
  X_CI_START_DT in DATE,
  X_CI_END_DT in DATE,
  X_MIN_ENTRY_ASS_SCORE in NUMBER,
  X_GUARANTEED_ENTRY_ASS_SCR in NUMBER,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    X_LAST_UPDATE_DATE DATE;

Line: 621


    X_LAST_UPDATED_BY NUMBER;

Line: 622


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 626


    X_PROGRAM_UPDATE_DATE DATE;

Line: 629


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 631


    X_LAST_UPDATED_BY := 1;

Line: 632


    X_LAST_UPDATE_LOGIN := 0;

Line: 634


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 635


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 638


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 639


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 648


    p_action => 'UPDATE',
    x_rowid => X_ROWID,
    x_course_cd => X_COURSE_CD,
    x_version_number => X_VERSION_NUMBER,
    x_cal_type => X_CAL_TYPE,
    x_ci_sequence_number => X_CI_SEQUENCE_NUMBER,
    x_ci_start_dt => X_CI_START_DT ,
    x_ci_end_dt => X_CI_END_DT,
    x_min_entry_ass_score => X_MIN_ENTRY_ASS_SCORE ,
    x_guaranteed_entry_ass_scr => X_GUARANTEED_ENTRY_ASS_SCR ,
    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: 672


     X_PROGRAM_UPDATE_DATE := OLD_REFERENCES.PROGRAM_UPDATE_DATE;

Line: 674


     X_PROGRAM_UPDATE_DATE := SYSDATE;

Line: 678


  update IGS_PS_OFR_INST set
    CI_START_DT = NEW_REFERENCES.CI_START_DT,
    CI_END_DT = NEW_REFERENCES.CI_END_DT,
    MIN_ENTRY_ASS_SCORE = NEW_REFERENCES.MIN_ENTRY_ASS_SCORE,
    GUARANTEED_ENTRY_ASS_SCR = NEW_REFERENCES.GUARANTEED_ENTRY_ASS_SCR,
    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: 696


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

Line: 699


end UPDATE_ROW;

Line: 713


  cursor c1 is select rowid from IGS_PS_OFR_INST
     where COURSE_CD = X_COURSE_CD
     and VERSION_NUMBER = X_VERSION_NUMBER
     and CAL_TYPE = X_CAL_TYPE
     and CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER
  ;

Line: 724


    INSERT_ROW (
     X_ROWID,
     X_COURSE_CD,
     X_VERSION_NUMBER,
     X_CAL_TYPE,
     X_CI_SEQUENCE_NUMBER,
     X_CI_START_DT,
     X_CI_END_DT,
     X_MIN_ENTRY_ASS_SCORE,
     X_GUARANTEED_ENTRY_ASS_SCR,
     X_MODE);

Line: 738


  UPDATE_ROW (
   X_ROWID,
   X_COURSE_CD,
   X_VERSION_NUMBER,
   X_CAL_TYPE,
   X_CI_SEQUENCE_NUMBER,
   X_CI_START_DT,
   X_CI_END_DT,
   X_MIN_ENTRY_ASS_SCORE,
   X_GUARANTEED_ENTRY_ASS_SCR,
   X_MODE);

Line: 751


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

Line: 759


  delete from IGS_PS_OFR_INST
  where ROWID = X_ROWID;

Line: 765


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

Line: 768


end DELETE_ROW;