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

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

Line: 20


    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 :
  Date Created By :
  Purpose :
  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_USEC_AS
      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: 67


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

Line: 74


    new_references.last_update_date := x_last_update_date;

Line: 75


    new_references.last_updated_by := x_last_updated_by;

Line: 76


    new_references.last_update_login := x_last_update_login;

Line: 151


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

Line: 174


      SELECT   rowid
      FROM     igs_ps_usec_as
      WHERE    unit_section_assessment_id = x_unit_section_assessment_id
      FOR UPDATE NOWAIT;

Line: 214


      SELECT   rowid
      FROM     igs_ps_usec_as
      WHERE    building_code = x_building_code
      AND      final_exam_date = x_final_exam_date
      AND      location_cd = x_location_cd
      AND      room_code = x_room_code
      AND      uoo_id = x_uoo_id 	and      ((l_rowid is null) or (rowid <> l_rowid))

      ;

Line: 253


      SELECT   rowid
      FROM     igs_ps_usec_as
      WHERE    uoo_id = x_uoo_id ;

Line: 287


    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 :
  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_unit_section_assessment_id,
      x_uoo_id,
      x_final_exam_date,
      x_exam_start_time,
      x_exam_end_time,
      x_location_cd,
      x_building_code,
      x_room_code,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );

Line: 322


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

Line: 334


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

Line: 340


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

Line: 343


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

Line: 353


    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      Check_Uniqueness;

Line: 356


    ELSIF (p_action = 'VALIDATE_DELETE') THEN
      Null;

Line: 381


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

Line: 384


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

Line: 387


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

Line: 395


 procedure INSERT_ROW (
      X_ROWID in out NOCOPY VARCHAR2,
       x_UNIT_SECTION_ASSESSMENT_ID IN OUT NOCOPY NUMBER,
       x_UOO_ID IN NUMBER,
       x_FINAL_EXAM_DATE IN DATE,
       x_EXAM_START_TIME IN DATE,
       x_EXAM_END_TIME IN DATE,
       x_LOCATION_CD IN VARCHAR2,
       x_BUILDING_CODE IN NUMBER,
       x_ROOM_CODE IN NUMBER,
      X_MODE in VARCHAR2 default 'R'
  ) AS
  /*************************************************************
  Created By :
  Date Created By :
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

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

    cursor C is select ROWID from IGS_PS_USEC_AS
             where                 UNIT_SECTION_ASSESSMENT_ID= X_UNIT_SECTION_ASSESSMENT_ID
;

Line: 421


     X_LAST_UPDATE_DATE DATE ;

Line: 422


     X_LAST_UPDATED_BY NUMBER ;

Line: 423


     X_LAST_UPDATE_LOGIN NUMBER ;

Line: 425


     X_LAST_UPDATE_DATE := SYSDATE;

Line: 427


        X_LAST_UPDATED_BY := 1;

Line: 428


        X_LAST_UPDATE_LOGIN := 0;

Line: 430


               X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 431


            if X_LAST_UPDATED_BY is NULL then
                X_LAST_UPDATED_BY := -1;

Line: 434


            X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 435


         if X_LAST_UPDATE_LOGIN is NULL then
            X_LAST_UPDATE_LOGIN := -1;

Line: 443


   SELECT IGS_PS_USEC_AS_S.nextval
   INTO   x_unit_section_assessment_id
   FROM dual;

Line: 447


 		p_action=>'INSERT',
 		x_rowid=>X_ROWID,
 	       x_unit_section_assessment_id=>X_UNIT_SECTION_ASSESSMENT_ID,
 	       x_uoo_id=>X_UOO_ID,
 	       x_final_exam_date=>X_FINAL_EXAM_DATE,
 	       x_exam_start_time=>X_EXAM_START_TIME,
 	       x_exam_end_time=>X_EXAM_END_TIME,
 	       x_location_cd=>X_LOCATION_CD,
 	       x_building_code=>X_BUILDING_CODE,
 	       x_room_code=>X_ROOM_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);

Line: 462


     insert into IGS_PS_USEC_AS (
		UNIT_SECTION_ASSESSMENT_ID
		,UOO_ID
		,FINAL_EXAM_DATE
		,EXAM_START_TIME
		,EXAM_END_TIME
		,LOCATION_CD
		,BUILDING_CODE
		,ROOM_CODE
	        ,CREATION_DATE
		,CREATED_BY
		,LAST_UPDATE_DATE
		,LAST_UPDATED_BY
		,LAST_UPDATE_LOGIN
        ) values  (
	        NEW_REFERENCES.UNIT_SECTION_ASSESSMENT_ID
	        ,NEW_REFERENCES.UOO_ID
	        ,NEW_REFERENCES.FINAL_EXAM_DATE
	        ,NEW_REFERENCES.EXAM_START_TIME
	        ,NEW_REFERENCES.EXAM_END_TIME
	        ,NEW_REFERENCES.LOCATION_CD
	        ,NEW_REFERENCES.BUILDING_CODE
	        ,NEW_REFERENCES.ROOM_CODE
	        ,X_LAST_UPDATE_DATE
		,X_LAST_UPDATED_BY
		,X_LAST_UPDATE_DATE
		,X_LAST_UPDATED_BY
		,X_LAST_UPDATE_LOGIN
);

Line: 499


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

Line: 501


end INSERT_ROW;

Line: 523


   cursor c1 is select
      UOO_ID
,      FINAL_EXAM_DATE
,      EXAM_START_TIME
,      EXAM_END_TIME
,      LOCATION_CD
,      BUILDING_CODE
,      ROOM_CODE
    from IGS_PS_USEC_AS
    where ROWID = X_ROWID
    for update nowait;

Line: 539


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

Line: 570


 Procedure UPDATE_ROW (
      X_ROWID in  VARCHAR2,
       x_UNIT_SECTION_ASSESSMENT_ID IN NUMBER,
       x_UOO_ID IN NUMBER,
       x_FINAL_EXAM_DATE IN DATE,
       x_EXAM_START_TIME IN DATE,
       x_EXAM_END_TIME IN DATE,
       x_LOCATION_CD IN VARCHAR2,
       x_BUILDING_CODE IN NUMBER,
       x_ROOM_CODE IN NUMBER,
      X_MODE in VARCHAR2 default 'R'
  ) AS
  /*************************************************************
  Created By :
  Date Created By :
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

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

     X_LAST_UPDATE_DATE DATE ;

Line: 594


     X_LAST_UPDATED_BY NUMBER ;

Line: 595


     X_LAST_UPDATE_LOGIN NUMBER ;

Line: 597


     X_LAST_UPDATE_DATE := SYSDATE;

Line: 599


        X_LAST_UPDATED_BY := 1;

Line: 600


        X_LAST_UPDATE_LOGIN := 0;

Line: 602


               X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 603


            if X_LAST_UPDATED_BY is NULL then
                X_LAST_UPDATED_BY := -1;

Line: 606


            X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 607


         if X_LAST_UPDATE_LOGIN is NULL then
            X_LAST_UPDATE_LOGIN := -1;

Line: 616


 		p_action=>'UPDATE',
 		x_rowid=>X_ROWID,
 	       x_unit_section_assessment_id=>X_UNIT_SECTION_ASSESSMENT_ID,
 	       x_uoo_id=>X_UOO_ID,
 	       x_final_exam_date=>X_FINAL_EXAM_DATE,
 	       x_exam_start_time=>X_EXAM_START_TIME,
 	       x_exam_end_time=>X_EXAM_END_TIME,
 	       x_location_cd=>X_LOCATION_CD,
 	       x_building_code=>X_BUILDING_CODE,
 	       x_room_code=>X_ROOM_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);

Line: 631


   update IGS_PS_USEC_AS set
      UOO_ID =  NEW_REFERENCES.UOO_ID,
      FINAL_EXAM_DATE =  NEW_REFERENCES.FINAL_EXAM_DATE,
      EXAM_START_TIME =  NEW_REFERENCES.EXAM_START_TIME,
      EXAM_END_TIME =  NEW_REFERENCES.EXAM_END_TIME,
      LOCATION_CD =  NEW_REFERENCES.LOCATION_CD,
      BUILDING_CODE =  NEW_REFERENCES.BUILDING_CODE,
      ROOM_CODE =  NEW_REFERENCES.ROOM_CODE,
	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: 648


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

Line: 651


end UPDATE_ROW;

Line: 675


    cursor c1 is select ROWID from IGS_PS_USEC_AS
             where     UNIT_SECTION_ASSESSMENT_ID= X_UNIT_SECTION_ASSESSMENT_ID
;

Line: 683


    INSERT_ROW (
      X_ROWID,
       X_UNIT_SECTION_ASSESSMENT_ID,
       X_UOO_ID,
       X_FINAL_EXAM_DATE,
       X_EXAM_START_TIME,
       X_EXAM_END_TIME,
       X_LOCATION_CD,
       X_BUILDING_CODE,
       X_ROOM_CODE,
      X_MODE );

Line: 697


UPDATE_ROW (
      X_ROWID,
       X_UNIT_SECTION_ASSESSMENT_ID,
       X_UOO_ID,
       X_FINAL_EXAM_DATE,
       X_EXAM_START_TIME,
       X_EXAM_END_TIME,
       X_LOCATION_CD,
       X_BUILDING_CODE,
       X_ROOM_CODE,
      X_MODE );

Line: 709


procedure DELETE_ROW (
  X_ROWID 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
Before_DML (
p_action => 'DELETE',
x_rowid => X_ROWID
);

Line: 728


 delete from IGS_PS_USEC_AS
 where ROWID = X_ROWID;

Line: 734


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

Line: 737


end DELETE_ROW;