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

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

Line: 19


    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 :rareddy
  Date Created By :
  Purpose : initilizing column values
  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_OR_ORG_NOTES
      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: 65


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

Line: 72


    new_references.last_update_date := x_last_update_date;

Line: 73


    new_references.last_updated_by := x_last_updated_by;

Line: 74


    new_references.last_update_login := x_last_update_login;

Line: 124


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

Line: 130


        FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');

Line: 137


           FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');

Line: 144


           FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');

Line: 150


           FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');

Line: 177


      SELECT   rowid
      FROM     igs_or_org_notes
      WHERE    org_structure_type = x_org_structure_type
      AND      org_note_sequence = x_org_note_sequence
      AND      org_note_type = x_org_note_type
      AND      org_structure_id = x_org_structure_id
      FOR UPDATE NOWAIT;

Line: 216


      SELECT   rowid
      FROM     igs_or_org_notes
      WHERE    org_note_type = x_org_notes_type ;

Line: 241


      SELECT   ROWID
      FROM     IGS_OR_ORG_NOTES
      WHERE    (
                 (org_structure_id = x_institution_cd) AND (org_structure_type = 'INSTITUTE')
               );

Line: 264


      SELECT   ROWID
      FROM     IGS_OR_ORG_NOTES
      WHERE    (
                 (org_structure_id = x_location_cd) AND (org_structure_type = 'LOCATION')
               );

Line: 287


      SELECT   ROWID
      FROM     IGS_OR_ORG_NOTES
      WHERE    (
                 (org_structure_id = x_org_unit_cd) AND (org_structure_type = 'ORG_UNIT')
               );

Line: 320


    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 :rareddy
  Date Created By :
  Purpose : before any DML.,
  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_org_structure_id,
      x_org_structure_type,
      x_org_note_sequence,
      x_org_note_type,
      x_start_date,
      x_end_date,
      x_note_text,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );

Line: 354


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

Line: 368


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

Line: 373


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

Line: 376


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

Line: 388


    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      Check_Constraints;

Line: 390


    ELSIF (p_action = 'VALIDATE_DELETE') THEN
      Null;

Line: 415


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

Line: 418


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

Line: 421


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

Line: 428


 procedure INSERT_ROW (
      X_ROWID in out NOCOPY VARCHAR2,
       x_ORG_STRUCTURE_ID IN VARCHAR2,
       x_ORG_STRUCTURE_TYPE IN VARCHAR2,
       x_ORG_NOTE_SEQUENCE IN OUT NOCOPY NUMBER,
       x_ORG_NOTE_TYPE IN VARCHAR2,
       x_START_DATE IN DATE,
       x_END_DATE IN DATE,
       x_NOTE_TEXT IN VARCHAR2,
      X_MODE in VARCHAR2 default 'R'
  ) AS
  /*************************************************************
  Created By :rareddy
  Date Created By :
  Purpose : BEFORE AND  AFTER  any INSERT
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

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

    cursor C is select ROWID from IGS_OR_ORG_NOTES
             where                 ORG_STRUCTURE_TYPE= X_ORG_STRUCTURE_TYPE
            and ORG_NOTE_SEQUENCE = X_ORG_NOTE_SEQUENCE
            and ORG_NOTE_TYPE = X_ORG_NOTE_TYPE
            and ORG_STRUCTURE_ID = X_ORG_STRUCTURE_ID
;

Line: 456


     X_LAST_UPDATE_DATE DATE ;

Line: 457


     X_LAST_UPDATED_BY NUMBER ;

Line: 458


     X_LAST_UPDATE_LOGIN NUMBER ;

Line: 460


     X_LAST_UPDATE_DATE := SYSDATE;

Line: 462


        X_LAST_UPDATED_BY := 1;

Line: 463


        X_LAST_UPDATE_LOGIN := 0;

Line: 465


               X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 466


            if X_LAST_UPDATED_BY is NULL then
                X_LAST_UPDATED_BY := -1;

Line: 469


            X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 470


         if X_LAST_UPDATE_LOGIN is NULL then
            X_LAST_UPDATE_LOGIN := -1;

Line: 478


   SELECT
        IGS_OR_ORG_NOTE_SEQUENCE_S.NEXTVAL
   INTO
        x_org_note_sequence
   FROM
        dual;

Line: 486


 		p_action=>'INSERT',
 		x_rowid=>X_ROWID,
 	       x_org_structure_id=>X_ORG_STRUCTURE_ID,
 	       x_org_structure_type=>X_ORG_STRUCTURE_TYPE,
 	       x_org_note_sequence=>X_ORG_NOTE_SEQUENCE,
 	       x_org_note_type=>X_ORG_NOTE_TYPE,
 	       x_start_date=>X_START_DATE,
 	       x_end_date=>X_END_DATE,
 	       x_note_text=>X_NOTE_TEXT,
	       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: 500


     insert into IGS_OR_ORG_NOTES (
		ORG_STRUCTURE_ID
		,ORG_STRUCTURE_TYPE
		,ORG_NOTE_SEQUENCE
		,ORG_NOTE_TYPE
		,START_DATE
		,END_DATE
		,NOTE_TEXT
	        ,CREATION_DATE
		,CREATED_BY
		,LAST_UPDATE_DATE
		,LAST_UPDATED_BY
		,LAST_UPDATE_LOGIN
        ) values  (
	        NEW_REFERENCES.ORG_STRUCTURE_ID
	        ,NEW_REFERENCES.ORG_STRUCTURE_TYPE
	        ,NEW_REFERENCES.ORG_NOTE_SEQUENCE
	        ,NEW_REFERENCES.ORG_NOTE_TYPE
	        ,NEW_REFERENCES.START_DATE
	        ,NEW_REFERENCES.END_DATE
	        ,NEW_REFERENCES.NOTE_TEXT
	        ,X_LAST_UPDATE_DATE
		,X_LAST_UPDATED_BY
		,X_LAST_UPDATE_DATE
		,X_LAST_UPDATED_BY
		,X_LAST_UPDATE_LOGIN
);

Line: 535


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

Line: 537


end INSERT_ROW;

Line: 558


   cursor c1 is select
      START_DATE
,      END_DATE
,      NOTE_TEXT
    from IGS_OR_ORG_NOTES
    where ROWID = X_ROWID
    for update nowait;

Line: 570


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

Line: 593


 Procedure UPDATE_ROW (
      X_ROWID in  VARCHAR2,
       x_ORG_STRUCTURE_ID IN VARCHAR2,
       x_ORG_STRUCTURE_TYPE IN VARCHAR2,
       x_ORG_NOTE_SEQUENCE IN NUMBER,
       x_ORG_NOTE_TYPE IN VARCHAR2,
       x_START_DATE IN DATE,
       x_END_DATE IN DATE,
       x_NOTE_TEXT IN VARCHAR2,
      X_MODE in VARCHAR2 default 'R'
  ) AS
  /*************************************************************
  Created By :rareddy
  Date Created By :
  Purpose :before and after a row update
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

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

     X_LAST_UPDATE_DATE DATE ;

Line: 616


     X_LAST_UPDATED_BY NUMBER ;

Line: 617


     X_LAST_UPDATE_LOGIN NUMBER ;

Line: 619


     X_LAST_UPDATE_DATE := SYSDATE;

Line: 621


        X_LAST_UPDATED_BY := 1;

Line: 622


        X_LAST_UPDATE_LOGIN := 0;

Line: 624


               X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 625


            if X_LAST_UPDATED_BY is NULL then
                X_LAST_UPDATED_BY := -1;

Line: 628


            X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 629


         if X_LAST_UPDATE_LOGIN is NULL then
            X_LAST_UPDATE_LOGIN := -1;

Line: 638


 		p_action=>'UPDATE',
 		x_rowid=>X_ROWID,
 	       x_org_structure_id=>X_ORG_STRUCTURE_ID,
 	       x_org_structure_type=>X_ORG_STRUCTURE_TYPE,
 	       x_org_note_sequence=>X_ORG_NOTE_SEQUENCE,
 	       x_org_note_type=>X_ORG_NOTE_TYPE,
 	       x_start_date=>X_START_DATE,
 	       x_end_date=>X_END_DATE,
 	       x_note_text=>X_NOTE_TEXT,
	       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: 652


   update IGS_OR_ORG_NOTES set
      START_DATE =  NEW_REFERENCES.START_DATE,
      END_DATE =  NEW_REFERENCES.END_DATE,
      NOTE_TEXT =  NEW_REFERENCES.NOTE_TEXT,
	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: 665


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

Line: 668


end UPDATE_ROW;

Line: 691


    cursor c1 is select ROWID from IGS_OR_ORG_NOTES
             where     ORG_STRUCTURE_TYPE= X_ORG_STRUCTURE_TYPE
            and ORG_NOTE_SEQUENCE = X_ORG_NOTE_SEQUENCE
            and ORG_NOTE_TYPE = X_ORG_NOTE_TYPE
            and ORG_STRUCTURE_ID = X_ORG_STRUCTURE_ID
;

Line: 703


    INSERT_ROW (
      X_ROWID,
       X_ORG_STRUCTURE_ID,
       X_ORG_STRUCTURE_TYPE,
       XX_ORG_NOTE_SEQUENCE,
       X_ORG_NOTE_TYPE,
       X_START_DATE,
       X_END_DATE,
       X_NOTE_TEXT,
      X_MODE );

Line: 716


UPDATE_ROW (
      X_ROWID,
       X_ORG_STRUCTURE_ID,
       X_ORG_STRUCTURE_TYPE,
       X_ORG_NOTE_SEQUENCE,
       X_ORG_NOTE_TYPE,
       X_START_DATE,
       X_END_DATE,
       X_NOTE_TEXT,
      X_MODE );

Line: 727


procedure DELETE_ROW (
  X_ROWID in VARCHAR2
) AS
  /*************************************************************
  Created By :rareddy
  Date Created By :
  Purpose : before and after a delete
  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: 746


 delete from IGS_OR_ORG_NOTES
 where ROWID = X_ROWID;

Line: 752


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

Line: 755


end DELETE_ROW;