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

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

Line: 18


    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 :ssuri
  Date Created By :11-MAY-2000
  Purpose :NEW TABLE
  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_PS_FACLTY_DEGRS
      WHERE    rowid = x_rowid;

Line: 47


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

Line: 49


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

Line: 63


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

Line: 70


    new_references.last_update_date := x_last_update_date;

Line: 71


    new_references.last_updated_by := x_last_updated_by;

Line: 72


    new_references.last_update_login := x_last_update_login;

Line: 153


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

Line: 164


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

Line: 175


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

Line: 198


      SELECT   rowid
      FROM     igs_ps_faclty_degrs
      WHERE    faclty_degrd_id = x_faclty_degrd_id
      FOR UPDATE NOWAIT;

Line: 237


      SELECT   rowid
      FROM     igs_ps_faclty_degrs
      WHERE    degree_cd = x_degree_cd
      AND      person_id = x_person_id
      AND      program   = x_program
      AND      ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line: 275


      SELECT   rowid
      FROM     igs_ps_faclty_degrs
      WHERE    degree_cd = x_degree_cd ;

Line: 312


      SELECT   rowid
      FROM     igs_ps_faclty_degrs
      WHERE    institution_cd = x_institution_cd ;

Line: 349


      SELECT   rowid
      FROM     igs_ps_faclty_degrs
      WHERE    person_id = x_person_id ;

Line: 381


    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 :ssuri
  Date Created By :11-MAY-2000
  Purpose :NEW TABLE
  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_faclty_degrd_id,
      x_person_id,
      x_degree_cd,
      x_program,
      x_institution_cd,
      x_degree_date,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );

Line: 414


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

Line: 426


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

Line: 432


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

Line: 435


    ELSIF (p_action = 'VALIDATE_INSERT') THEN
	 -- Call all the procedures related to Before Insert.
      IF Get_PK_For_Validation (
    		new_references.faclty_degrd_id)  THEN
	       Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

Line: 445


    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      Check_Uniqueness;

Line: 448


    ELSIF (p_action = 'VALIDATE_DELETE') THEN
      Null;

Line: 473


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

Line: 476


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

Line: 479


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

Line: 486


 procedure INSERT_ROW (
      X_ROWID in out NOCOPY VARCHAR2,
       x_FACLTY_DEGRD_ID IN OUT NOCOPY NUMBER,
       x_PERSON_ID IN NUMBER,
       x_DEGREE_CD IN VARCHAR2,
       x_PROGRAM IN VARCHAR2,
       x_INSTITUTION_CD IN VARCHAR2,
       x_DEGREE_DATE IN DATE,
      X_MODE in VARCHAR2 default 'R'
  ) AS

  /*************************************************************
  Created By :ssuri
  Date Created By :11-MAY-2000
  Purpose :NEW TABLE
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

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

    cursor C is select ROWID from IGS_PS_FACLTY_DEGRS
             where                 FACLTY_DEGRD_ID= X_FACLTY_DEGRD_ID
;

Line: 511


     X_LAST_UPDATE_DATE DATE ;

Line: 512


     X_LAST_UPDATED_BY NUMBER ;

Line: 513


     X_LAST_UPDATE_LOGIN NUMBER ;

Line: 515


     X_LAST_UPDATE_DATE := SYSDATE;

Line: 517


        X_LAST_UPDATED_BY := 1;

Line: 518


        X_LAST_UPDATE_LOGIN := 0;

Line: 520


               X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 521


            if X_LAST_UPDATED_BY is NULL then
                X_LAST_UPDATED_BY := -1;

Line: 524


            X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 525


         if X_LAST_UPDATE_LOGIN is NULL then
            X_LAST_UPDATE_LOGIN := -1;

Line: 533


       SELECT IGS_PS_FACLTY_DEGRD_ID_S.nextval INTO x_FACLTY_DEGRD_ID FROM dual;

Line: 535


 		p_action=>'INSERT',
 		x_rowid=>X_ROWID,
 	       x_faclty_degrd_id=>X_FACLTY_DEGRD_ID,
 	       x_person_id=>X_PERSON_ID,
 	       x_degree_cd=>X_DEGREE_CD,
 	       x_program=>X_PROGRAM,
 	       x_institution_cd=>X_INSTITUTION_CD,
 	       x_degree_date=>X_DEGREE_DATE,
	       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: 551


 insert into IGS_PS_FACLTY_DEGRS (
		FACLTY_DEGRD_ID
		,PERSON_ID
		,DEGREE_CD
		,PROGRAM
		,INSTITUTION_CD
		,DEGREE_DATE
	        ,CREATION_DATE
		,CREATED_BY
		,LAST_UPDATE_DATE
		,LAST_UPDATED_BY
		,LAST_UPDATE_LOGIN
        ) values  (
	        NEW_REFERENCES.FACLTY_DEGRD_ID
	        ,NEW_REFERENCES.PERSON_ID
	        ,NEW_REFERENCES.DEGREE_CD
	        ,NEW_REFERENCES.PROGRAM
	        ,NEW_REFERENCES.INSTITUTION_CD
	        ,NEW_REFERENCES.DEGREE_DATE
	        ,X_LAST_UPDATE_DATE
		,X_LAST_UPDATED_BY
		,X_LAST_UPDATE_DATE
		,X_LAST_UPDATED_BY
		,X_LAST_UPDATE_LOGIN
);

Line: 588


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

Line: 603


end INSERT_ROW;

Line: 623


   cursor c1 is select
      PERSON_ID
,      DEGREE_CD
,      PROGRAM
,      INSTITUTION_CD
,      DEGREE_DATE
    from IGS_PS_FACLTY_DEGRS
    where ROWID = X_ROWID
    for update nowait;

Line: 637


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

Line: 658


 Procedure UPDATE_ROW (
      X_ROWID in  VARCHAR2,
       x_FACLTY_DEGRD_ID IN NUMBER,
       x_PERSON_ID IN NUMBER,
       x_DEGREE_CD IN VARCHAR2,
       x_PROGRAM IN VARCHAR2,
       x_INSTITUTION_CD IN VARCHAR2,
       x_DEGREE_DATE IN DATE,
      X_MODE in VARCHAR2 default 'R'
  ) AS
  /*************************************************************
  Created By :ssuri
  Date Created By :11-MAY-2000
  Purpose :NEW TABLE
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

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

     X_LAST_UPDATE_DATE DATE ;

Line: 680


     X_LAST_UPDATED_BY NUMBER ;

Line: 681


     X_LAST_UPDATE_LOGIN NUMBER ;

Line: 683


     X_LAST_UPDATE_DATE := SYSDATE;

Line: 685


        X_LAST_UPDATED_BY := 1;

Line: 686


        X_LAST_UPDATE_LOGIN := 0;

Line: 688


               X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 689


            if X_LAST_UPDATED_BY is NULL then
                X_LAST_UPDATED_BY := -1;

Line: 692


            X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 693


         if X_LAST_UPDATE_LOGIN is NULL then
            X_LAST_UPDATE_LOGIN := -1;

Line: 702


 		p_action=>'UPDATE',
 		x_rowid=>X_ROWID,
 	       x_faclty_degrd_id=>X_FACLTY_DEGRD_ID,
 	       x_person_id=>X_PERSON_ID,
 	       x_degree_cd=>X_DEGREE_CD,
 	       x_program=>X_PROGRAM,
 	       x_institution_cd=>X_INSTITUTION_CD,
 	       x_degree_date=>X_DEGREE_DATE,
	       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: 718


 update IGS_PS_FACLTY_DEGRS set
      PERSON_ID =  NEW_REFERENCES.PERSON_ID,
      DEGREE_CD =  NEW_REFERENCES.DEGREE_CD,
      PROGRAM =  NEW_REFERENCES.PROGRAM,
      INSTITUTION_CD =  NEW_REFERENCES.INSTITUTION_CD,
      DEGREE_DATE =  NEW_REFERENCES.DEGREE_DATE,
	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: 740


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

Line: 756


end UPDATE_ROW;

Line: 778


    cursor c1 is select ROWID from IGS_PS_FACLTY_DEGRS
             where     FACLTY_DEGRD_ID= X_FACLTY_DEGRD_ID
;

Line: 786


    INSERT_ROW (
      X_ROWID,
       X_FACLTY_DEGRD_ID,
       X_PERSON_ID,
       X_DEGREE_CD,
       X_PROGRAM,
       X_INSTITUTION_CD,
       X_DEGREE_DATE,
      X_MODE );

Line: 798


UPDATE_ROW (
      X_ROWID,
       X_FACLTY_DEGRD_ID,
       X_PERSON_ID,
       X_DEGREE_CD,
       X_PROGRAM,
       X_INSTITUTION_CD,
       X_DEGREE_DATE,
      X_MODE );

Line: 808


procedure DELETE_ROW (
  X_ROWID in VARCHAR2,
  x_mode IN VARCHAR2
) AS
  /*************************************************************
  Created By :ssuri
  Date Created By :11-MAY-2000
  Purpose :NEW TABLE
  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: 831


 delete from IGS_PS_FACLTY_DEGRS
 where ROWID = X_ROWID;

Line: 844


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

Line: 847


end DELETE_ROW;