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

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

Line: 16


    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_new_institution IN VARCHAR2 DEFAULT NULL
  ) AS

  /*************************************************************
  Created By :
  Date Created By :
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

  (reverse chronological order - newest change first)
  kamohan	1/21/02		removed the references to
				nominated_course_cd and
				sequence_number
  ***************************************************************/

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

Line: 49


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

Line: 51


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


      SELECT   rowid
      FROM     igs_ad_other_inst
      WHERE    other_inst_id = x_other_inst_id
      FOR UPDATE NOWAIT;

Line: 239


      SELECT   rowid
      FROM     igs_ad_other_inst
      WHERE    admission_appl_number = x_admission_appl_number
      AND      institution_code = x_institution_code
      AND      person_id = x_person_id
      AND      NVL(new_institution,'-1') = NVL(x_new_institution,'-1')
      AND      ((l_rowid is null) or (rowid <> l_rowid));

Line: 279


      SELECT   rowid
      FROM     igs_ad_other_inst
      WHERE    person_id = x_person_id
      AND      admission_appl_number = x_admission_appl_number;

Line: 317


      SELECT   rowid
      FROM     igs_ad_other_inst
      WHERE    institution_code = x_institution_cd ;

Line: 347


    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_new_institution IN VARCHAR2 DEFAULT NULL
  ) AS
  /*************************************************************
  Created By :
  Date Created By :
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

  (reverse chronological order - newest change first)
  kamohan	1/21/02		removed the references to
				nominated_course_cd and
				sequence_number
  ***************************************************************/

  BEGIN

    Set_Column_Values (
      p_action,
      x_rowid,
      x_other_inst_id,
      x_person_id,
      x_admission_appl_number,
      x_institution_code,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login,
      x_new_institution
    );

Line: 391


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

Line: 403


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

Line: 409


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

Line: 412


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

Line: 422


    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      Check_Uniqueness;

Line: 425


    ELSIF (p_action = 'VALIDATE_DELETE') THEN
      Null;

Line: 451


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

Line: 454


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

Line: 457


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

Line: 465


 procedure INSERT_ROW (
       X_ROWID in out NOCOPY VARCHAR2,
       x_OTHER_INST_ID IN OUT NOCOPY NUMBER,
       x_PERSON_ID IN NUMBER,
       x_ADMISSION_APPL_NUMBER IN NUMBER,
       x_INSTITUTION_CODE IN VARCHAR2,
       X_MODE in VARCHAR2,
       x_new_institution 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)
  ravishar      05/27/05        Security related changes
  kamohan	1/21/02		removed the references to
				nominated_course_cd and
				sequence_number
  ***************************************************************/

    cursor C is select ROWID from IGS_AD_OTHER_INST
             where OTHER_INST_ID= X_OTHER_INST_ID;

Line: 492


     X_LAST_UPDATE_DATE DATE ;

Line: 493


     X_LAST_UPDATED_BY NUMBER ;

Line: 494


     X_LAST_UPDATE_LOGIN NUMBER ;

Line: 498


     X_PROGRAM_UPDATE_DATE DATE;

Line: 500


    X_LAST_UPDATE_DATE := SYSDATE;

Line: 502


      X_LAST_UPDATED_BY := 1;

Line: 503


      X_LAST_UPDATE_LOGIN := 0;

Line: 505


      X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 506


      if X_LAST_UPDATED_BY is NULL then
        X_LAST_UPDATED_BY := -1;

Line: 509


      X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 510


      if X_LAST_UPDATE_LOGIN is NULL then
        X_LAST_UPDATE_LOGIN := -1;

Line: 520


        X_PROGRAM_UPDATE_DATE := NULL;

Line: 522


        X_PROGRAM_UPDATE_DATE := SYSDATE;

Line: 532


 		p_action=>'INSERT',
 		x_rowid=>X_ROWID,
 	       x_other_inst_id=>X_OTHER_INST_ID,
 	       x_person_id=>X_PERSON_ID,
 	       x_admission_appl_number=>X_ADMISSION_APPL_NUMBER,
 	       x_institution_code=>X_INSTITUTION_CODE,
	       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_new_institution=>x_new_institution);

Line: 548


 insert into IGS_AD_OTHER_INST (
		 OTHER_INST_ID
		,PERSON_ID
		,ADMISSION_APPL_NUMBER
		,INSTITUTION_CODE
	        ,CREATION_DATE
		,CREATED_BY
		,LAST_UPDATE_DATE
		,LAST_UPDATED_BY
		,LAST_UPDATE_LOGIN
		,REQUEST_ID
		,PROGRAM_ID
		,PROGRAM_APPLICATION_ID
		,PROGRAM_UPDATE_DATE
		,NEW_INSTITUTION
        ) values  (
	        IGS_AD_OTHER_INST_S.NEXTVAL
	        ,NEW_REFERENCES.PERSON_ID
	        ,NEW_REFERENCES.ADMISSION_APPL_NUMBER
	        ,NEW_REFERENCES.INSTITUTION_CODE
	        ,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
		,X_NEW_INSTITUTION
)RETURNING OTHER_INST_ID INTO X_OTHER_INST_ID;

Line: 591


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

Line: 611


END INSERT_ROW;

Line: 634


   cursor c1 is select
      PERSON_ID
,      ADMISSION_APPL_NUMBER
,      INSTITUTION_CODE
    from IGS_AD_OTHER_INST
    where ROWID = X_ROWID
    for update nowait;

Line: 646


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

Line: 665


 Procedure UPDATE_ROW (
       X_ROWID in  VARCHAR2,
       x_OTHER_INST_ID IN NUMBER,
       x_PERSON_ID IN NUMBER,
       x_ADMISSION_APPL_NUMBER IN NUMBER,
       x_INSTITUTION_CODE IN VARCHAR2,
       X_MODE in VARCHAR2,
       X_NEW_INSTITUTION 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)
    ravishar    05/25/05        Security related changes
    kamohan	1/21/02		removed the references to
				nominated_course_cd and
				sequence_number
  ***************************************************************/

     X_LAST_UPDATE_DATE DATE ;

Line: 690


     X_LAST_UPDATED_BY NUMBER ;

Line: 691


     X_LAST_UPDATE_LOGIN NUMBER ;

Line: 695


     X_PROGRAM_UPDATE_DATE DATE;

Line: 697


    X_LAST_UPDATE_DATE := SYSDATE;

Line: 699


      X_LAST_UPDATED_BY := 1;

Line: 700


      X_LAST_UPDATE_LOGIN := 0;

Line: 702


      X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 703


      if X_LAST_UPDATED_BY is NULL then
        X_LAST_UPDATED_BY := -1;

Line: 706


      X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 707


      if X_LAST_UPDATE_LOGIN is NULL then
        X_LAST_UPDATE_LOGIN := -1;

Line: 716


 		p_action=>'UPDATE',
 		x_rowid=>X_ROWID,
 	       x_other_inst_id=>X_OTHER_INST_ID,
 	       x_person_id=>X_PERSON_ID,
 	       x_admission_appl_number=>X_ADMISSION_APPL_NUMBER,
 	       x_institution_code=>X_INSTITUTION_CODE,
	       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_new_institution=>X_NEW_INSTITUTION);

Line: 737


        X_PROGRAM_UPDATE_DATE := OLD_REFERENCES.PROGRAM_UPDATE_DATE;

Line: 739


        X_PROGRAM_UPDATE_DATE := SYSDATE;

Line: 746


 update IGS_AD_OTHER_INST set
      PERSON_ID =  NEW_REFERENCES.PERSON_ID,
      ADMISSION_APPL_NUMBER =  NEW_REFERENCES.ADMISSION_APPL_NUMBER,
      INSTITUTION_CODE =  NEW_REFERENCES.INSTITUTION_CODE,
	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,
	NEW_INSTITUTION = X_NEW_INSTITUTION
	  where ROWID = X_ROWID;

Line: 771


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

Line: 792


END UPDATE_ROW;

Line: 816


    cursor c1 is select ROWID from IGS_AD_OTHER_INST
             where     OTHER_INST_ID= X_OTHER_INST_ID;

Line: 823


    INSERT_ROW (
      X_ROWID,
       X_OTHER_INST_ID,
       X_PERSON_ID,
       X_ADMISSION_APPL_NUMBER,
       X_INSTITUTION_CODE,
      X_MODE,
      X_NEW_INSTITUTION);

Line: 834


UPDATE_ROW (
      X_ROWID,
       X_OTHER_INST_ID,
       X_PERSON_ID,
       X_ADMISSION_APPL_NUMBER,
       X_INSTITUTION_CODE,
      X_MODE,
      X_NEW_INSTITUTION);

Line: 843


procedure DELETE_ROW (
  X_ROWID in VARCHAR2,
  x_mode IN VARCHAR2
) AS
  /*************************************************************
  Created By :
  Date Created By :
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What
  ravishar        05/25/05      Security related changes
  (reverse chronological order - newest change first)
  ***************************************************************/

begin
Before_DML (
p_action => 'DELETE',
x_rowid => X_ROWID
);

Line: 866


 delete from IGS_AD_OTHER_INST
 where ROWID = X_ROWID;

Line: 879


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

Line: 900


end DELETE_ROW;