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

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

Line: 16


    x_last_update_date IN DATE ,
    x_last_updated_by IN NUMBER,
    x_last_update_login IN NUMBER ,
    x_acad_honor_type IN VARCHAR2
  ) AS

  /*************************************************************
  Created By :samaresh
  Date Created By :15-May-2000
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

  (reverse chronological order - newest change first)
  kamohan	1/21/02		Removed references of nominated_course_Cd
				and sequence_number
  ***************************************************************/

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

Line: 48


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

Line: 50


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


      SELECT   rowid
      FROM     igs_pe_acad_honors
      WHERE    acad_honor_type = x_acad_honor_type
      AND      nvl(honor_date,sysdate) = nvl(x_honor_date,sysdate)
      AND      person_id = x_person_id
      AND      ((l_rowid is null) or (rowid <> l_rowid));

Line: 180


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

Line: 205


      SELECT   rowid
      FROM     igs_pe_acad_honors
      WHERE    acad_honor_id = x_acad_honor_id
      FOR UPDATE NOWAIT;

Line: 235


    x_last_update_date IN DATE,
    x_last_updated_by IN NUMBER ,
    x_last_update_login IN NUMBER ,
    x_acad_honor_type IN VARCHAR2
  ) AS
  /*************************************************************
  Created By :
  Date Created By :
  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_acad_honor_id,
      x_person_id,
      x_comments,
      x_honor_date,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login,
      x_acad_honor_type
    );

Line: 268


    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to Before Insert.
     IF Get_Pk_For_Validation(
	new_references.acad_honor_id)  THEN
       Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

Line: 279


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

Line: 284


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

Line: 287


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

Line: 297


    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      Check_Uniqueness;

Line: 300


    ELSIF (p_action = 'VALIDATE_DELETE') THEN
      Null;

Line: 325


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

Line: 328


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

Line: 331


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

Line: 339


 procedure INSERT_ROW (
      X_ROWID in out NOCOPY VARCHAR2,
       x_ACAD_HONOR_ID IN OUT NOCOPY NUMBER,
       x_PERSON_ID IN NUMBER,
       x_COMMENTS IN VARCHAR2,
       x_HONOR_DATE IN DATE,
      X_MODE in VARCHAR2  ,
      X_ACAD_HONOR_TYPE IN VARCHAR2
  ) AS
  /*************************************************************
  Created By :samaresh
  Date Created By :15-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_pe_acad_honors
           where     ACAD_HONOR_ID= X_ACAD_HONOR_ID;

Line: 362


     X_LAST_UPDATE_DATE DATE ;

Line: 363


     X_LAST_UPDATED_BY NUMBER ;

Line: 364


     X_LAST_UPDATE_LOGIN NUMBER ;

Line: 369


     X_PROGRAM_UPDATE_DATE DATE;

Line: 371


    X_LAST_UPDATE_DATE := SYSDATE;

Line: 373


      X_LAST_UPDATED_BY := 1;

Line: 374


      X_LAST_UPDATE_LOGIN := 0;

Line: 376


      X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 377


      if X_LAST_UPDATED_BY is NULL then
        X_LAST_UPDATED_BY := -1;

Line: 380


      X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 381


      if X_LAST_UPDATE_LOGIN is NULL then
        X_LAST_UPDATE_LOGIN := -1;

Line: 391


        X_PROGRAM_UPDATE_DATE := NULL;

Line: 393


        X_PROGRAM_UPDATE_DATE := SYSDATE;

Line: 403


   SELECT igs_pe_acad_honors_s.nextval
   INTO X_ACAD_HONOR_ID
   FROM dual;

Line: 408


 		p_action=>'INSERT',
 		x_rowid=>X_ROWID,
 	       x_acad_honor_id=>X_ACAD_HONOR_ID,
 	       x_person_id=>X_PERSON_ID,
 	       x_comments=>X_COMMENTS,
 	       x_honor_date=>X_HONOR_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,
	       x_acad_honor_type=>X_ACAD_HONOR_TYPE);

Line: 426


 insert into igs_pe_acad_honors (
		ACAD_HONOR_ID
		,PERSON_ID
		,COMMENTS
		,HONOR_DATE
	        ,CREATION_DATE
		,CREATED_BY
		,LAST_UPDATE_DATE
		,LAST_UPDATED_BY
		,LAST_UPDATE_LOGIN
		,REQUEST_ID
		,PROGRAM_ID
		,PROGRAM_APPLICATION_ID
		,PROGRAM_UPDATE_DATE
		,ACAD_HONOR_TYPE
        ) values  (
	        NEW_REFERENCES.ACAD_HONOR_ID
	        ,NEW_REFERENCES.PERSON_ID
	        ,NEW_REFERENCES.COMMENTS
	        ,NEW_REFERENCES.HONOR_DATE
		,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
		,NEW_REFERENCES.ACAD_HONOR_TYPE
);

Line: 470


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

Line: 485


end INSERT_ROW;

Line: 506


   cursor c1 is select
      PERSON_ID
,      ACAD_HONOR_TYPE --changed type_id to cd
,      COMMENTS
,      HONOR_DATE
    from igs_pe_acad_honors
    where ROWID = X_ROWID
    for update nowait;

Line: 519


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

Line: 543


 Procedure UPDATE_ROW (
      X_ROWID in  VARCHAR2,
       x_ACAD_HONOR_ID IN NUMBER,
       x_PERSON_ID IN NUMBER,
       x_COMMENTS IN VARCHAR2,
       x_HONOR_DATE IN DATE,
      X_MODE in VARCHAR2 ,
      x_ACAD_HONOR_TYPE IN VARCHAR2
  ) AS
  /*************************************************************
  Created By :samaresh
  Date Created By :15-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: 564


     X_LAST_UPDATED_BY NUMBER ;

Line: 565


     X_LAST_UPDATE_LOGIN NUMBER ;

Line: 569


     X_PROGRAM_UPDATE_DATE DATE;

Line: 571


    X_LAST_UPDATE_DATE := SYSDATE;

Line: 573


      X_LAST_UPDATED_BY := 1;

Line: 574


      X_LAST_UPDATE_LOGIN := 0;

Line: 576


      X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 577


      if X_LAST_UPDATED_BY is NULL then
        X_LAST_UPDATED_BY := -1;

Line: 580


      X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 581


      if X_LAST_UPDATE_LOGIN is NULL then
        X_LAST_UPDATE_LOGIN := -1;

Line: 590


 		p_action=>'UPDATE',
 		x_rowid=>X_ROWID,
 	       x_acad_honor_id=>X_ACAD_HONOR_ID,
 	       x_person_id=>X_PERSON_ID,
 	       x_comments=>X_COMMENTS,
 	       x_honor_date=>X_HONOR_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,
	       x_acad_honor_type=>x_ACAD_HONOR_TYPE);

Line: 611


        X_PROGRAM_UPDATE_DATE := OLD_REFERENCES.PROGRAM_UPDATE_DATE;

Line: 613


        X_PROGRAM_UPDATE_DATE := SYSDATE;

Line: 620


 update igs_pe_acad_honors set
      PERSON_ID =  NEW_REFERENCES.PERSON_ID,
      ACAD_HONOR_TYPE =  NEW_REFERENCES.ACAD_HONOR_TYPE,--CHANGED HERE
      COMMENTS =  NEW_REFERENCES.COMMENTS,
      HONOR_DATE =  NEW_REFERENCES.HONOR_DATE,
	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 = PROGRAM_APPLICATION_ID,
	PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE
    where ROWID = X_ROWID;

Line: 645


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

Line: 661


end UPDATE_ROW;

Line: 682


    cursor c1 is select ROWID from igs_pe_acad_honors
          where     ACAD_HONOR_ID= X_ACAD_HONOR_ID;

Line: 689


    INSERT_ROW (
       X_ROWID,
       X_ACAD_HONOR_ID,
       X_PERSON_ID,
       X_COMMENTS,
       X_HONOR_DATE,
       X_MODE,
       x_ACAD_HONOR_TYPE);

Line: 700


UPDATE_ROW (
       X_ROWID,
       X_ACAD_HONOR_ID,
       X_PERSON_ID,
       X_COMMENTS,
       X_HONOR_DATE,
       X_MODE,
       x_ACAD_HONOR_TYPE);

Line: 710


procedure DELETE_ROW (
  X_ROWID in VARCHAR2,
  x_mode IN VARCHAR2
  ) AS
  /*************************************************************
  Created By :samaresh
  Date Created By :15-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: 733


 delete from igs_pe_acad_honors
 where ROWID = X_ROWID;

Line: 746


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

Line: 749


end DELETE_ROW;