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

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

Line: 20


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

  /*************************************************************
  Created By : amuthu
  Date Created On : 15-May-2000
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What
  samaresh	  28-dec-2001	  Bug Number  2158524. Two columns
				  SYSTEM_STATUS and SYSTEM_DEFAULT
				  have been added
  (reverse chronological order - newest change first)
  ***************************************************************/

    CURSOR cur_old_ref_values IS
      SELECT   *
      FROM     IGS_AD_CODE_CLASSES
      WHERE    rowid = x_rowid;

Line: 51


    IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
      Close cur_old_ref_values;

Line: 53


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

Line: 69


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

Line: 76


    new_references.last_update_date := x_last_update_date;

Line: 77


    new_references.last_updated_by := x_last_updated_by;

Line: 78


    new_references.last_update_login := x_last_update_login;

Line: 139


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

Line: 148


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

Line: 323


      SELECT   rowid
      FROM     igs_ad_code_classes
      WHERE    code_id = x_code_id AND
               closed_ind = NVL(x_closed_ind,closed_ind);

Line: 363


      SELECT   rowid
      FROM     igs_ad_code_classes
      WHERE    name = x_name  AND
               class = x_class AND
	       class_type_code = cp_class_type_code AND
               ((l_rowid is null) or (rowid <> l_rowid)) AND
               closed_ind = NVL(x_closed_ind,closed_ind);

Line: 408


      SELECT   rowid
      FROM     igs_ad_code_classes
      WHERE    code_id = x_code_id  AND
               class = x_class AND
	       class_type_code = cp_class_type_code AND
               ((l_rowid is null) or (rowid <> l_rowid)) AND
               closed_ind = NVL(x_closed_ind,closed_ind);

Line: 445


    x_last_update_date IN DATE,
    x_last_updated_by IN NUMBER,
    x_last_update_login IN NUMBER,
    x_class_type_code  IN VARCHAR2 DEFAULT NULL
  ) AS
  /*************************************************************
  Created By : amuthu
  Date Created On : 15-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_code_id,
      x_name,
      x_description,
      x_class,
      x_closed_ind,
      x_system_status,
      x_system_default,
      x_class_type_code,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );

Line: 481


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

Line: 493


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

Line: 499


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

Line: 503


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

Line: 513


    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      Check_Uniqueness;

Line: 516


    ELSIF (p_action = 'VALIDATE_DELETE') THEN
      Check_Child_Existance;

Line: 542


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

Line: 545


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

Line: 548


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

Line: 556


 procedure INSERT_ROW (
      X_ROWID in out NOCOPY VARCHAR2,
       x_CODE_ID IN OUT NOCOPY NUMBER,
       x_NAME IN VARCHAR2,
       x_DESCRIPTION IN VARCHAR2,
       x_CLASS IN VARCHAR2,
       x_CLOSED_IND IN VARCHAR2,
       x_system_status IN VARCHAR2,
       x_system_default IN VARCHAR2,
       X_MODE in VARCHAR2,
       x_class_type_code  IN VARCHAR2 DEFAULT NULL
  ) AS
  /*************************************************************
  Created By : amuthu
  Date Created On : 15-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_AD_CODE_CLASSES
             where                 CODE_ID= X_CODE_ID
;

Line: 582


     X_LAST_UPDATE_DATE DATE ;

Line: 583


     X_LAST_UPDATED_BY NUMBER ;

Line: 584


     X_LAST_UPDATE_LOGIN NUMBER ;

Line: 586


     X_LAST_UPDATE_DATE := SYSDATE;

Line: 588


        X_LAST_UPDATED_BY := 1;

Line: 589


        X_LAST_UPDATE_LOGIN := 0;

Line: 591


               X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 592


            if X_LAST_UPDATED_BY is NULL then
                X_LAST_UPDATED_BY := -1;

Line: 595


            X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 596


         if X_LAST_UPDATE_LOGIN is NULL then
            X_LAST_UPDATE_LOGIN := -1;

Line: 607


 		p_action=>'INSERT',
 		x_rowid=>X_ROWID,
 	       x_code_id=>X_CODE_ID,
 	       x_name=>X_NAME,
 	       x_description=>X_DESCRIPTION,
 	       x_class=>X_CLASS,
 	       x_closed_ind=>X_CLOSED_IND,
               x_system_status => X_SYSTEM_STATUS,
               x_system_default => X_SYSTEM_DEFAULT,
               x_class_type_code  => x_class_type_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: 622


     insert into IGS_AD_CODE_CLASSES (
		CODE_ID
		,NAME
		,DESCRIPTION
		,CLASS
		,CLOSED_IND
		,SYSTEM_STATUS
		,SYSTEM_DEFAULT
	        ,CREATION_DATE
		,CREATED_BY
		,LAST_UPDATE_DATE
		,LAST_UPDATED_BY
		,LAST_UPDATE_LOGIN
		,class_type_code
        ) values  (
	         IGS_AD_CODE_CLASSES_S.NEXTVAL
	        ,NEW_REFERENCES.NAME
	        ,NEW_REFERENCES.DESCRIPTION
	        ,NEW_REFERENCES.CLASS
	        ,NEW_REFERENCES.CLOSED_IND
		,NEW_REFERENCES.SYSTEM_STATUS
		,NEW_REFERENCES.SYSTEM_DEFAULT
	        ,X_LAST_UPDATE_DATE
		,X_LAST_UPDATED_BY
		,X_LAST_UPDATE_DATE
		,X_LAST_UPDATED_BY
		,X_LAST_UPDATE_LOGIN
		,NEW_REFERENCES.class_type_code
)RETURNING CODE_ID INTO X_CODE_ID ;

Line: 659


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

Line: 661


end INSERT_ROW;

Line: 684


   cursor c1 is select
      NAME
,      DESCRIPTION
,      CLASS
,      CLOSED_IND
,      SYSTEM_STATUS
,      SYSTEM_DEFAULT
,      class_type_code
    from IGS_AD_CODE_CLASSES
    where ROWID = X_ROWID
    for update nowait;

Line: 700


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

Line: 729


 Procedure UPDATE_ROW (
      X_ROWID in  VARCHAR2,
       x_CODE_ID IN NUMBER,
       x_NAME IN VARCHAR2,
       x_DESCRIPTION IN VARCHAR2,
       x_CLASS IN VARCHAR2,
       x_CLOSED_IND IN VARCHAR2,
       x_SYSTEM_STATUS IN VARCHAR2,
       x_SYSTEM_DEFAULT IN VARCHAR2,
       X_MODE in VARCHAR2,
       x_class_type_code  IN VARCHAR2 DEFAULT NULL
  ) AS
  /*************************************************************
  Created By : amuthu
  Date Created On : 15-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: 753


     X_LAST_UPDATED_BY NUMBER ;

Line: 754


     X_LAST_UPDATE_LOGIN NUMBER ;

Line: 756


     X_LAST_UPDATE_DATE := SYSDATE;

Line: 758


        X_LAST_UPDATED_BY := 1;

Line: 759


        X_LAST_UPDATE_LOGIN := 0;

Line: 761


               X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 762


            if X_LAST_UPDATED_BY is NULL then
                X_LAST_UPDATED_BY := -1;

Line: 765


            X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 766


         if X_LAST_UPDATE_LOGIN is NULL then
            X_LAST_UPDATE_LOGIN := -1;

Line: 775


 		p_action=>'UPDATE',
 		x_rowid=>X_ROWID,
 	       x_code_id=>X_CODE_ID,
 	       x_name=>X_NAME,
 	       x_description=>X_DESCRIPTION,
 	       x_class=>X_CLASS,
 	       x_closed_ind=>X_CLOSED_IND,
	       x_system_status=>X_SYSTEM_STATUS,
	       x_system_default=>X_SYSTEM_DEFAULT,
               x_class_type_code  =>  x_class_type_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: 790


   update IGS_AD_CODE_CLASSES set
      NAME =  NEW_REFERENCES.NAME,
      DESCRIPTION =  NEW_REFERENCES.DESCRIPTION,
      CLASS =  NEW_REFERENCES.CLASS,
      CLOSED_IND =  NEW_REFERENCES.CLOSED_IND,
      SYSTEM_STATUS = NEW_REFERENCES.SYSTEM_STATUS,
      SYSTEM_DEFAULT = NEW_REFERENCES.SYSTEM_DEFAULT,
	LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
	LAST_UPDATED_BY = X_LAST_UPDATED_BY,
	LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
	class_type_code = x_class_type_code
	  where ROWID = X_ROWID;

Line: 807


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

Line: 810


end UPDATE_ROW;

Line: 834


    cursor c1 is select ROWID from IGS_AD_CODE_CLASSES
             where     CODE_ID= X_CODE_ID
;

Line: 842


    INSERT_ROW (
      X_ROWID,
       X_CODE_ID,
       X_NAME,
       X_DESCRIPTION,
       X_CLASS,
       X_CLOSED_IND,
       X_SYSTEM_STATUS,
       X_SYSTEM_DEFAULT,
       x_class_type_code,
      X_MODE );

Line: 856


UPDATE_ROW (
      X_ROWID,
       X_CODE_ID,
       X_NAME,
       X_DESCRIPTION,
       X_CLASS,
       X_CLOSED_IND,
       X_SYSTEM_STATUS,
       X_SYSTEM_DEFAULT,
       x_class_type_code,
      X_MODE );

Line: 868


procedure DELETE_ROW (
  X_ROWID in VARCHAR2
) AS
  /*************************************************************
  Created By : amuthu
  Date Created On : 15-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: 887


 delete from IGS_AD_CODE_CLASSES
 where ROWID = X_ROWID;

Line: 893


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

Line: 896


end DELETE_ROW;