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

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

Line: 18


    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
    CURSOR cur_old_ref_values IS
      SELECT   *
      FROM     IGS_AS_GRD_SCH_TRN_ALL
      WHERE    rowid = x_rowid;

Line: 32


    IF (cur_old_ref_values%NOTFOUND) AND (p_action  NOT IN ('INSERT','VALIDATE_INSERT')) THEN
      Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

Line: 49


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

Line: 56


    new_references.last_update_date := x_last_update_date;

Line: 57


    new_references.last_updated_by := x_last_updated_by;

Line: 58


    new_references.last_update_login := x_last_update_login;

Line: 60


PROCEDURE BeforeRowInsertUpdate1(
    p_inserting IN BOOLEAN DEFAULT FALSE,
    p_updating IN BOOLEAN DEFAULT FALSE,
    p_deleting IN BOOLEAN DEFAULT FALSE
    ) AS
	v_message_name		VARCHAR2(30);

Line: 67


	-- Validate that inserts/updates are allowed
	IF  p_inserting OR p_updating THEN
		--
		-- Validate grade may not be translated against another grade in same ver
		IF  IGS_AS_VAL_GSGT.assp_val_gsgt_gs_gs (
						new_references.grading_schema_cd,
						new_references.version_number,
						new_references.to_grading_schema_cd,
						new_references.to_version_number,
						v_message_name) = FALSE THEN
			FND_MESSAGE.SET_NAME('IGS',v_message_name);

Line: 97


  END BeforeRowInsertUpdate1;

Line: 103


  PROCEDURE AfterRowInsertUpdate2(
    p_inserting IN BOOLEAN DEFAULT FALSE,
    p_updating IN BOOLEAN DEFAULT FALSE,
    p_deleting IN BOOLEAN DEFAULT FALSE
    ) AS
    v_message_name	VARCHAR2(30);

Line: 110


	IF  p_inserting OR p_updating THEN
      	IF IGS_AS_VAL_GSGT.assp_val_gsgt_multi (
  				new_references.grading_schema_cd,
  				new_references.version_number,
  				new_references.grade,
  				new_references.to_grading_schema_cd,
  				new_references.to_version_number,
  				new_references.to_grade,
  					v_message_name) = FALSE THEN
  		FND_MESSAGE.SET_NAME('IGS',v_message_name);

Line: 124


  END AfterRowInsertUpdate2;

Line: 143


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

Line: 159


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

Line: 173


      SELECT   rowid
      FROM     IGS_AS_GRD_SCH_TRN_ALL
      WHERE    grading_schema_cd = x_grading_schema_cd
      AND      version_number = x_version_number
      AND      grade = x_grade
      AND      to_grading_schema_cd = x_to_grading_schema_cd
      AND      to_version_number = x_to_version_number
      AND      to_grade = x_to_grade
      FOR UPDATE NOWAIT;

Line: 200


      SELECT   rowid
      FROM     IGS_AS_GRD_SCH_TRN_ALL
      WHERE    to_grading_schema_cd = x_grading_schema_cd
      AND      to_version_number = x_version_number
      AND      to_grade = x_grade  OR
                (grading_schema_cd = x_grading_schema_cd
                  AND      version_number = x_version_number
                  AND      grade = x_grade ) ;

Line: 234


    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
  BEGIN
    Set_Column_Values (
      p_action,
      x_rowid,
      x_org_id,
      x_grading_schema_cd,
      x_version_number,
      x_grade,
      x_to_grading_schema_cd,
      x_to_version_number,
      x_to_grade,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );

Line: 255


    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to Before Insert.
      BeforeRowInsertUpdate1 ( p_inserting => TRUE );

Line: 274


    ELSIF (p_action = 'UPDATE') THEN
      -- Call all the procedures related to Before Update.
      BeforeRowInsertUpdate1 ( p_updating => TRUE );

Line: 281


	ELSIF (p_action = 'VALIDATE_INSERT') THEN
	     IF  Get_PK_For_Validation (
       NEW_REFERENCES.grading_schema_cd ,
    NEW_REFERENCES.version_number ,
    NEW_REFERENCES.grade ,
    NEW_REFERENCES.to_grading_schema_cd ,
    NEW_REFERENCES.to_version_number,
    NEW_REFERENCES.to_grade) THEN
         Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');

Line: 295


	ELSIF (p_action = 'VALIDATE_UPDATE') THEN

	      Check_Constraints;

Line: 303


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_ORG_ID in NUMBER,
  X_GRADING_SCHEMA_CD in VARCHAR2,
  X_VERSION_NUMBER in NUMBER,
  X_GRADE in VARCHAR2,
  X_TO_GRADING_SCHEMA_CD in VARCHAR2,
  X_TO_VERSION_NUMBER in NUMBER,
  X_TO_GRADE in VARCHAR2,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    cursor C is select ROWID from IGS_AS_GRD_SCH_TRN_ALL
      where GRADING_SCHEMA_CD = X_GRADING_SCHEMA_CD
      and VERSION_NUMBER = X_VERSION_NUMBER
      and GRADE = X_GRADE
      and TO_GRADING_SCHEMA_CD = X_TO_GRADING_SCHEMA_CD
      and TO_VERSION_NUMBER = X_TO_VERSION_NUMBER
      and TO_GRADE = X_TO_GRADE;

Line: 321


    X_LAST_UPDATE_DATE DATE;

Line: 322


    X_LAST_UPDATED_BY NUMBER;

Line: 323


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 325


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 327


    X_LAST_UPDATED_BY := 1;

Line: 328


    X_LAST_UPDATE_LOGIN := 0;

Line: 330


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 331


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 334


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 335


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 344


  p_action=>'INSERT',
  x_rowid=>X_ROWID,
  x_org_id => igs_ge_gen_003.get_org_id,
  x_grade=>X_GRADE,
  x_grading_schema_cd=>X_GRADING_SCHEMA_CD,
  x_to_grade=>X_TO_GRADE,
  x_to_grading_schema_cd=>X_TO_GRADING_SCHEMA_CD,
  x_to_version_number=>X_TO_VERSION_NUMBER,
  x_version_number=>X_VERSION_NUMBER,
  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: 359


  insert into IGS_AS_GRD_SCH_TRN_ALL (
    ORG_ID,
    GRADING_SCHEMA_CD,
    VERSION_NUMBER,
    GRADE,
    TO_GRADING_SCHEMA_CD,
    TO_VERSION_NUMBER,
    TO_GRADE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    NEW_REFERENCES.ORG_ID,
    NEW_REFERENCES.GRADING_SCHEMA_CD,
    NEW_REFERENCES.VERSION_NUMBER,
    NEW_REFERENCES.GRADE,
    NEW_REFERENCES.TO_GRADING_SCHEMA_CD,
    NEW_REFERENCES.TO_VERSION_NUMBER,
    NEW_REFERENCES.TO_GRADE,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 394


end INSERT_ROW;

Line: 404


  cursor c1 is select
    ROWID
    from IGS_AS_GRD_SCH_TRN_ALL
    where ROWID = X_ROWID  for update  nowait;

Line: 413


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

Line: 422


procedure DELETE_ROW (
  X_ROWID in VARCHAR2) AS
begin
 Before_DML(
  p_action => 'DELETE',
  x_rowid => X_ROWID
  );

Line: 429


  delete from IGS_AS_GRD_SCH_TRN_ALL
 where ROWID = X_ROWID;

Line: 435


end DELETE_ROW;