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

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

Line: 18


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

  /*************************************************************
  Created By : skotwal
  Date Created By : 20-May-2000
  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_UNIT_GRD_SCHM
      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: 157


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

Line: 171


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

Line: 207


      SELECT   rowid
      FROM     igs_ps_unit_grd_schm
      WHERE    unit_grading_schema_id = x_unit_grading_schema_id
      FOR UPDATE NOWAIT;

Line: 246


      SELECT   rowid
      FROM     igs_ps_unit_grd_schm
      WHERE    unit_version_number = x_unit_version_number
      AND      grading_schema_code = x_grading_schema_code
      AND      grd_schm_version_number = x_grd_schm_version_number
      AND      unit_code = x_unit_code 	and      ((l_rowid is null) or (rowid <> l_rowid))

      ;

Line: 285


      SELECT   rowid
      FROM     igs_ps_unit_grd_schm
      WHERE    unit_code = x_unit_cd
      AND      unit_version_number = x_version_number ;

Line: 324


      SELECT   rowid
      FROM     igs_ps_unit_grd_schm
      WHERE    grading_schema_code = x_grading_schema_cd
      AND      grd_schm_version_number = x_version_number ;

Line: 357


    x_last_update_date IN DATE ,
    x_last_updated_by IN NUMBER ,
    x_last_update_login IN NUMBER
  ) AS
  /*************************************************************
  Created By : skotwal
  Date Created By : 20-May-2000
  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_grading_schema_id,
      x_unit_code,
      x_unit_version_number,
      x_grading_schema_code,
      x_grd_schm_version_number,
      x_default_flag,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );

Line: 390


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

Line: 402


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

Line: 407


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

Line: 410


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

Line: 420


    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      Check_Uniqueness;

Line: 423


    ELSIF (p_action = 'VALIDATE_DELETE') THEN
      Check_Child_Existance;

Line: 448


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

Line: 451


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

Line: 454


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

Line: 461


 procedure INSERT_ROW (
      X_ROWID in out NOCOPY VARCHAR2,
       x_UNIT_GRADING_SCHEMA_ID IN OUT NOCOPY NUMBER,
       x_UNIT_CODE IN VARCHAR2,
       x_UNIT_VERSION_NUMBER IN NUMBER,
       x_GRADING_SCHEMA_CODE IN VARCHAR2,
       x_GRD_SCHM_VERSION_NUMBER IN NUMBER,
       x_DEFAULT_FLAG IN VARCHAR2,
      X_MODE in VARCHAR2
  ) AS
  /*************************************************************
  Created By : skotwal
  Date Created By : 20-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_PS_UNIT_GRD_SCHM
             where                 UNIT_GRADING_SCHEMA_ID= X_UNIT_GRADING_SCHEMA_ID
;

Line: 485


     X_LAST_UPDATE_DATE DATE ;

Line: 486


     X_LAST_UPDATED_BY NUMBER ;

Line: 487


     X_LAST_UPDATE_LOGIN NUMBER ;

Line: 489


     X_LAST_UPDATE_DATE := SYSDATE;

Line: 491


        X_LAST_UPDATED_BY := 1;

Line: 492


        X_LAST_UPDATE_LOGIN := 0;

Line: 494


               X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 495


            if X_LAST_UPDATED_BY is NULL then
                X_LAST_UPDATED_BY := -1;

Line: 498


            X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 499


         if X_LAST_UPDATE_LOGIN is NULL then
            X_LAST_UPDATE_LOGIN := -1;

Line: 507


   select igs_ps_unit_grd_schm_s.nextval
   into x_unit_grading_schema_id
   from dual;

Line: 511


 		p_action=>'INSERT',
 		x_rowid=>X_ROWID,
 	       x_unit_grading_schema_id=>X_UNIT_GRADING_SCHEMA_ID,
 	       x_unit_code=>X_UNIT_CODE,
 	       x_unit_version_number=>X_UNIT_VERSION_NUMBER,
 	       x_grading_schema_code=>X_GRADING_SCHEMA_CODE,
 	       x_grd_schm_version_number=>X_GRD_SCHM_VERSION_NUMBER,
 	       x_default_flag=>NVL(X_DEFAULT_FLAG,'N' ),
	       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: 524


     insert into IGS_PS_UNIT_GRD_SCHM (
		UNIT_GRADING_SCHEMA_ID
		,UNIT_CODE
		,UNIT_VERSION_NUMBER
		,GRADING_SCHEMA_CODE
		,GRD_SCHM_VERSION_NUMBER
		,DEFAULT_FLAG
	        ,CREATION_DATE
		,CREATED_BY
		,LAST_UPDATE_DATE
		,LAST_UPDATED_BY
		,LAST_UPDATE_LOGIN
        ) values  (
	        NEW_REFERENCES.UNIT_GRADING_SCHEMA_ID
	        ,NEW_REFERENCES.UNIT_CODE
	        ,NEW_REFERENCES.UNIT_VERSION_NUMBER
	        ,NEW_REFERENCES.GRADING_SCHEMA_CODE
	        ,NEW_REFERENCES.GRD_SCHM_VERSION_NUMBER
	        ,NEW_REFERENCES.DEFAULT_FLAG
	        ,X_LAST_UPDATE_DATE
		,X_LAST_UPDATED_BY
		,X_LAST_UPDATE_DATE
		,X_LAST_UPDATED_BY
		,X_LAST_UPDATE_LOGIN
);

Line: 557


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

Line: 559


end INSERT_ROW;

Line: 579


   cursor c1 is select
      UNIT_CODE
,      UNIT_VERSION_NUMBER
,      GRADING_SCHEMA_CODE
,      GRD_SCHM_VERSION_NUMBER
,      DEFAULT_FLAG
    from IGS_PS_UNIT_GRD_SCHM
    where ROWID = X_ROWID
    for update nowait;

Line: 593


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

Line: 614


 Procedure UPDATE_ROW (
      X_ROWID in  VARCHAR2,
       x_UNIT_GRADING_SCHEMA_ID IN NUMBER,
       x_UNIT_CODE IN VARCHAR2,
       x_UNIT_VERSION_NUMBER IN NUMBER,
       x_GRADING_SCHEMA_CODE IN VARCHAR2,
       x_GRD_SCHM_VERSION_NUMBER IN NUMBER,
       x_DEFAULT_FLAG IN VARCHAR2,
      X_MODE in VARCHAR2
  ) AS
  /*************************************************************
  Created By : skotwal
  Date Created By : 20-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: 636


     X_LAST_UPDATED_BY NUMBER ;

Line: 637


     X_LAST_UPDATE_LOGIN NUMBER ;

Line: 639


     X_LAST_UPDATE_DATE := SYSDATE;

Line: 641


        X_LAST_UPDATED_BY := 1;

Line: 642


        X_LAST_UPDATE_LOGIN := 0;

Line: 644


               X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 645


            if X_LAST_UPDATED_BY is NULL then
                X_LAST_UPDATED_BY := -1;

Line: 648


            X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 649


         if X_LAST_UPDATE_LOGIN is NULL then
            X_LAST_UPDATE_LOGIN := -1;

Line: 658


 		p_action=>'UPDATE',
 		x_rowid=>X_ROWID,
 	       x_unit_grading_schema_id=>X_UNIT_GRADING_SCHEMA_ID,
 	       x_unit_code=>X_UNIT_CODE,
 	       x_unit_version_number=>X_UNIT_VERSION_NUMBER,
 	       x_grading_schema_code=>X_GRADING_SCHEMA_CODE,
 	       x_grd_schm_version_number=>X_GRD_SCHM_VERSION_NUMBER,
 	       x_default_flag=>NVL(X_DEFAULT_FLAG,'N' ),
	       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: 671


   update IGS_PS_UNIT_GRD_SCHM set
      UNIT_CODE =  NEW_REFERENCES.UNIT_CODE,
      UNIT_VERSION_NUMBER =  NEW_REFERENCES.UNIT_VERSION_NUMBER,
      GRADING_SCHEMA_CODE =  NEW_REFERENCES.GRADING_SCHEMA_CODE,
      GRD_SCHM_VERSION_NUMBER =  NEW_REFERENCES.GRD_SCHM_VERSION_NUMBER,
      DEFAULT_FLAG =  NEW_REFERENCES.DEFAULT_FLAG,
	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: 686


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

Line: 689


end UPDATE_ROW;

Line: 711


    cursor c1 is select ROWID from IGS_PS_UNIT_GRD_SCHM
             where     UNIT_GRADING_SCHEMA_ID= X_UNIT_GRADING_SCHEMA_ID
;

Line: 719


    INSERT_ROW (
      X_ROWID,
       X_UNIT_GRADING_SCHEMA_ID,
       X_UNIT_CODE,
       X_UNIT_VERSION_NUMBER,
       X_GRADING_SCHEMA_CODE,
       X_GRD_SCHM_VERSION_NUMBER,
       X_DEFAULT_FLAG,
      X_MODE );

Line: 731


UPDATE_ROW (
      X_ROWID,
       X_UNIT_GRADING_SCHEMA_ID,
       X_UNIT_CODE,
       X_UNIT_VERSION_NUMBER,
       X_GRADING_SCHEMA_CODE,
       X_GRD_SCHM_VERSION_NUMBER,
       X_DEFAULT_FLAG,
      X_MODE );

Line: 742


PROCEDURE DELETE_ROW (
  X_ROWID in VARCHAR2
) AS
  /*************************************************************
  Created By : skotwal
  Date Created By : 20-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: 761


 delete from IGS_PS_UNIT_GRD_SCHM
 where ROWID = X_ROWID;

Line: 767


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

Line: 770


END DELETE_ROW;