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_TYPGOV_SCORMP_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
  ) AS
    CURSOR cur_old_ref_values IS
      SELECT   *
      FROM     IGS_AS_TYPGOV_SCORMP
      WHERE    rowid = x_rowid;

Line: 30


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

Line: 44


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

Line: 51


    new_references.last_update_date := x_last_update_date;

Line: 52


    new_references.last_updated_by := x_last_updated_by;

Line: 53


    new_references.last_update_login := x_last_update_login;

Line: 65


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

Line: 78


      SELECT   rowid
      FROM     IGS_AS_TYPGOV_SCORMP
      WHERE    scndry_edu_ass_type = x_scndry_edu_ass_type
      AND      result_obtained_yr = x_result_obtained_yr
      AND      institution_score = x_institution_score
      FOR UPDATE NOWAIT;

Line: 102


      SELECT   rowid
      FROM     IGS_AS_TYPGOV_SCORMP
      WHERE    scndry_edu_ass_type = x_aus_scndry_edu_ass_type ;

Line: 128


    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_scndry_edu_ass_type,
      x_result_obtained_yr,
      x_institution_score,
      x_govt_score,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );

Line: 146


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

	IF  Get_PK_For_Validation (
NEW_REFERENCES.scndry_edu_ass_type,
NEW_REFERENCES.result_obtained_yr ,
    NEW_REFERENCES.institution_score) THEN
         Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

Line: 161


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

	     Check_Constraints;

Line: 167


	ELSIF (p_action = 'VALIDATE_INSERT') THEN
	     IF  Get_PK_For_Validation (
	         NEW_REFERENCES.scndry_edu_ass_type,
NEW_REFERENCES.result_obtained_yr ,
    NEW_REFERENCES.institution_score) THEN
         Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

Line: 178


	ELSIF (p_action = 'VALIDATE_UPDATE') THEN

	      Check_Constraints;

Line: 188


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_SCNDRY_EDU_ASS_TYPE in VARCHAR2,
  X_RESULT_OBTAINED_YR in NUMBER,
  X_INSTITUTION_SCORE in NUMBER,
  X_GOVT_SCORE in NUMBER,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    cursor C is select ROWID from IGS_AS_TYPGOV_SCORMP
      where SCNDRY_EDU_ASS_TYPE = X_SCNDRY_EDU_ASS_TYPE
      and RESULT_OBTAINED_YR = X_RESULT_OBTAINED_YR
      and INSTITUTION_SCORE = X_INSTITUTION_SCORE;

Line: 200


    X_LAST_UPDATE_DATE DATE;

Line: 201


    X_LAST_UPDATED_BY NUMBER;

Line: 202


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 204


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 206


    X_LAST_UPDATED_BY := 1;

Line: 207


    X_LAST_UPDATE_LOGIN := 0;

Line: 209


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 210


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 213


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 214


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 223


 p_action=>'INSERT',
 x_rowid=>X_ROWID,
 x_govt_score=>X_GOVT_SCORE,
 x_institution_score=>X_INSTITUTION_SCORE,
 x_result_obtained_yr=>X_RESULT_OBTAINED_YR,
 x_scndry_edu_ass_type=>X_SCNDRY_EDU_ASS_TYPE,
 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: 235


  insert into IGS_AS_TYPGOV_SCORMP (
    SCNDRY_EDU_ASS_TYPE,
    RESULT_OBTAINED_YR,
    INSTITUTION_SCORE,
    GOVT_SCORE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    NEW_REFERENCES.SCNDRY_EDU_ASS_TYPE,
    NEW_REFERENCES.RESULT_OBTAINED_YR,
    NEW_REFERENCES.INSTITUTION_SCORE,
    NEW_REFERENCES.GOVT_SCORE,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 264


end INSERT_ROW;

Line: 272


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

Line: 281


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

Line: 298


procedure UPDATE_ROW (
  X_ROWID in  VARCHAR2,
  X_SCNDRY_EDU_ASS_TYPE in VARCHAR2,
  X_RESULT_OBTAINED_YR in NUMBER,
  X_INSTITUTION_SCORE in NUMBER,
  X_GOVT_SCORE in NUMBER,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    X_LAST_UPDATE_DATE DATE;

Line: 307


    X_LAST_UPDATED_BY NUMBER;

Line: 308


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 310


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 312


    X_LAST_UPDATED_BY := 1;

Line: 313


    X_LAST_UPDATE_LOGIN := 0;

Line: 315


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 316


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 319


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 320


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 329


 p_action=>'UPDATE',
 x_rowid=>X_ROWID,
 x_govt_score=>X_GOVT_SCORE,
 x_institution_score=>X_INSTITUTION_SCORE,
 x_result_obtained_yr=>X_RESULT_OBTAINED_YR,
 x_scndry_edu_ass_type=>X_SCNDRY_EDU_ASS_TYPE,
 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: 341


  update IGS_AS_TYPGOV_SCORMP set
    GOVT_SCORE = NEW_REFERENCES.GOVT_SCORE,
    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: 351


end UPDATE_ROW;

Line: 360


  cursor c1 is select rowid from IGS_AS_TYPGOV_SCORMP
     where SCNDRY_EDU_ASS_TYPE = X_SCNDRY_EDU_ASS_TYPE
     and RESULT_OBTAINED_YR = X_RESULT_OBTAINED_YR
     and INSTITUTION_SCORE = X_INSTITUTION_SCORE
  ;

Line: 370


    INSERT_ROW (
     X_ROWID,
     X_SCNDRY_EDU_ASS_TYPE,
     X_RESULT_OBTAINED_YR,
     X_INSTITUTION_SCORE,
     X_GOVT_SCORE,
     X_MODE);

Line: 380


  UPDATE_ROW (
   X_ROWID,
   X_SCNDRY_EDU_ASS_TYPE,
   X_RESULT_OBTAINED_YR,
   X_INSTITUTION_SCORE,
   X_GOVT_SCORE,
   X_MODE);

Line: 388


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

Line: 395


  delete from IGS_AS_TYPGOV_SCORMP
 where ROWID = X_ROWID;

Line: 401


end DELETE_ROW;