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

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

Line: 41


    x_last_update_date IN DATE DEFAULT NULL,
    x_last_updated_by IN NUMBER DEFAULT NULL,
    x_last_update_login IN NUMBER DEFAULT NULL,
    x_rev_account_cd IN VARCHAR2 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)
  msrinivi        17 Jul, 2001   Added new col : rev account cd
  ***************************************************************/
    CURSOR cur_old_ref_values IS
      SELECT   *
      FROM     IGS_AD_LOCATION_ALL
      WHERE    rowid = x_rowid;

Line: 69


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

Line: 71


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

Line: 109


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

Line: 116


    new_references.last_update_date := x_last_update_date;

Line: 117


    new_references.last_updated_by := x_last_updated_by;

Line: 118


    new_references.last_update_login := x_last_update_login;

Line: 122


  PROCEDURE BeforeRowInsertUpdate1(
    p_inserting IN BOOLEAN DEFAULT FALSE,
    p_updating IN BOOLEAN DEFAULT FALSE,
    p_deleting IN BOOLEAN DEFAULT FALSE
    ) AS
  /*************************************************************
  Created By :
  Date Created By :
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What
  (reverse chronological order - newest change first)
  msrinivi        17 Jul, 2001   Added new col : rev account cd
  ***************************************************************/

	v_message_name	varchar2(30);

Line: 140


	IF p_inserting OR
			(old_references.location_type <> new_references.location_type) THEN
		IF  IGS_OR_VAL_LOC.orgp_val_loc_type (
						new_references.location_type,
						v_message_name) = FALSE THEN
			Fnd_Message.Set_Name('IGS',v_message_name);

Line: 150


	IF  p_inserting OR p_updating THEN
		IF  new_references.location_cd <> old_references.location_cd THEN
			IF  IGS_OR_VAL_LOC.assp_val_loc_ve_xist (
							new_references.location_cd,
							new_references.location_type,
							v_message_name) = FALSE THEN
			Fnd_Message.Set_Name('IGS',v_message_name);

Line: 190


  END BeforeRowInsertUpdate1;

Line: 271


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

Line: 284


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

Line: 297


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

Line: 445


      SELECT   rowid
      FROM     IGS_AD_LOCATION_ALL
      WHERE    location_cd = x_location_cd AND
               closed_ind = NVL(x_closed_ind,closed_ind);

Line: 479


      SELECT   rowid
      FROM     IGS_AD_LOCATION_ALL
      WHERE    location_type = x_location_type ;

Line: 513


      SELECT   rowid
      FROM     IGS_AD_LOCATION_ALL
      WHERE    coord_person_id = x_person_id ;

Line: 567


    x_last_update_date IN DATE DEFAULT NULL,
    x_last_updated_by IN NUMBER DEFAULT NULL,
    x_last_update_login IN NUMBER DEFAULT NULL,
    x_rev_account_cd IN VARCHAR2 DEFAULT NULL
    ) AS
  /*************************************************************
  Created By :
  Date Created By :
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What
  msrinivi        18 Jul,2001	   Added new col :rev_account_cd
  (reverse chronological order - newest change first)
  ***************************************************************/

  BEGIN

    Set_Column_Values (
      p_action,
      x_rowid,
      x_org_id,
      x_location_cd,
      x_description,
      x_location_type,
      x_closed_ind,
      x_coord_person_id,
      x_mail_dlvry_wrk_days,
      x_attribute_category,
      x_attribute1,
      x_attribute2,
      x_attribute3,
      x_attribute4,
      x_attribute5,
      x_attribute6,
      x_attribute7,
      x_attribute8,
      x_attribute9,
      x_attribute10,
      x_attribute11,
      x_attribute12,
      x_attribute13,
      x_attribute14,
      x_attribute15,
      x_attribute16,
      x_attribute17,
      x_attribute18,
      x_attribute19,
      x_attribute20,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login ,
      x_rev_account_cd
    );

Line: 624


    IF (p_action = 'INSERT') THEN
      BeforeRowInsertUpdate1 ( p_inserting => TRUE );

Line: 635


    ELSIF (p_action = 'UPDATE') THEN
      BeforeRowInsertUpdate1 ( p_updating => TRUE );

Line: 639


    ELSIF (p_action = 'DELETE') THEN
     Check_Child_Existance;

Line: 641


    ELSIF (p_action = 'VALIDATE_INSERT') THEN
	IF Get_PK_For_Validation (
		new_references.location_cd
	) THEN
		Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');

Line: 650


    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
	Check_Constraints;

Line: 652


    ELSIF (p_action = 'VALIDATE_DELETE') THEN
      Check_Child_Existance;

Line: 679


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_ORG_ID in NUMBER,
  X_LOCATION_CD in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_LOCATION_TYPE in VARCHAR2,
  X_MAIL_DLVRY_WRK_DAYS in NUMBER,
  X_COORD_PERSON_ID igs_pe_person.person_id%type,
    x_attribute_category IN VARCHAR2 DEFAULT NULL,
    x_attribute1 IN VARCHAR2 DEFAULT NULL,
    x_attribute2 IN VARCHAR2 DEFAULT NULL,
    x_attribute3 IN VARCHAR2 DEFAULT NULL,
    x_attribute4 IN VARCHAR2 DEFAULT NULL,
    x_attribute5 IN VARCHAR2 DEFAULT NULL,
    x_attribute6 IN VARCHAR2 DEFAULT NULL,
    x_attribute7 IN VARCHAR2 DEFAULT NULL,
    x_attribute8 IN VARCHAR2 DEFAULT NULL,
    x_attribute9 IN VARCHAR2 DEFAULT NULL,
    x_attribute10 IN VARCHAR2 DEFAULT NULL,
    x_attribute11 IN VARCHAR2 DEFAULT NULL,
    x_attribute12 IN VARCHAR2 DEFAULT NULL,
    x_attribute13 IN VARCHAR2 DEFAULT NULL,
    x_attribute14 IN VARCHAR2 DEFAULT NULL,
    x_attribute15 IN VARCHAR2 DEFAULT NULL,
    x_attribute16 IN VARCHAR2 DEFAULT NULL,
    x_attribute17 IN VARCHAR2 DEFAULT NULL,
    x_attribute18 IN VARCHAR2 DEFAULT NULL,
    x_attribute19 IN VARCHAR2 DEFAULT NULL,
    x_attribute20 IN VARCHAR2 DEFAULT NULL,
  X_CLOSED_IND in VARCHAR2,
  X_MODE in VARCHAR2 default 'R',
  x_rev_account_cd IN VARCHAR2 DEFAULT NULL
  ) AS
  /*************************************************************
  Created By :
  Date Created By :
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What
  msrinivi        18 Jul,2001	   Added new col :rev_account_cd
  (reverse chronological order - newest change first)
  ***************************************************************/

    cursor C is select ROWID from IGS_AD_LOCATION_ALL
      where LOCATION_CD = X_LOCATION_CD;

Line: 725


    X_LAST_UPDATE_DATE DATE;

Line: 726


    X_LAST_UPDATED_BY NUMBER;

Line: 727


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 729


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 731


    X_LAST_UPDATED_BY := 1;

Line: 732


    X_LAST_UPDATE_LOGIN := 0;

Line: 734


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 735


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 738


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 739


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 749


    p_action              => 'INSERT' ,
    x_rowid               => X_ROWID,
    x_org_id              => igs_ge_gen_003.get_org_id,
    x_location_cd         => X_LOCATION_CD,
    x_description         => X_DESCRIPTION,
    x_location_type       => X_LOCATION_TYPE,
    x_closed_ind          => NVL(X_CLOSED_IND,'N'),
    x_coord_person_id     => X_COORD_PERSON_ID,
    x_mail_dlvry_wrk_days => X_MAIL_DLVRY_WRK_DAYS,
 	       x_attribute_category=>X_ATTRIBUTE_CATEGORY,
 	       x_attribute1=>X_ATTRIBUTE1,
 	       x_attribute2=>X_ATTRIBUTE2,
 	       x_attribute3=>X_ATTRIBUTE3,
 	       x_attribute4=>X_ATTRIBUTE4,
 	       x_attribute5=>X_ATTRIBUTE5,
 	       x_attribute6=>X_ATTRIBUTE6,
 	       x_attribute7=>X_ATTRIBUTE7,
 	       x_attribute8=>X_ATTRIBUTE8,
 	       x_attribute9=>X_ATTRIBUTE9,
 	       x_attribute10=>X_ATTRIBUTE10,
 	       x_attribute11=>X_ATTRIBUTE11,
 	       x_attribute12=>X_ATTRIBUTE12,
 	       x_attribute13=>X_ATTRIBUTE13,
 	       x_attribute14=>X_ATTRIBUTE14,
 	       x_attribute15=>X_ATTRIBUTE15,
 	       x_attribute16=>X_ATTRIBUTE16,
 	       x_attribute17=>X_ATTRIBUTE17,
 	       x_attribute18=>X_ATTRIBUTE18,
 	       x_attribute19=>X_ATTRIBUTE19,
 	       x_attribute20=>X_ATTRIBUTE20,
    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,
    x_rev_account_cd    => x_rev_account_cd
  );

Line: 787


  insert into IGS_AD_LOCATION_ALL (
    LOCATION_CD,
    DESCRIPTION,
    LOCATION_TYPE,
    MAIL_DLVRY_WRK_DAYS,
    COORD_PERSON_ID,
    CLOSED_IND
		,ATTRIBUTE_CATEGORY
		,ATTRIBUTE1
		,ATTRIBUTE2
		,ATTRIBUTE3
		,ATTRIBUTE4
		,ATTRIBUTE5
		,ATTRIBUTE6
		,ATTRIBUTE7
		,ATTRIBUTE8
		,ATTRIBUTE9
		,ATTRIBUTE10
		,ATTRIBUTE11
		,ATTRIBUTE12
		,ATTRIBUTE13
		,ATTRIBUTE14
		,ATTRIBUTE15
		,ATTRIBUTE16
		,ATTRIBUTE17
		,ATTRIBUTE18
		,ATTRIBUTE19
		,ATTRIBUTE20,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    ORG_ID,
    rev_account_cd
  ) values (
    NEW_REFERENCES.LOCATION_CD,
    NEW_REFERENCES.DESCRIPTION,
    NEW_REFERENCES.LOCATION_TYPE,
    NEW_REFERENCES.MAIL_DLVRY_WRK_DAYS,
    NEW_REFERENCES.COORD_PERSON_ID,
    NEW_REFERENCES.CLOSED_IND
	        ,NEW_REFERENCES.ATTRIBUTE_CATEGORY
	        ,NEW_REFERENCES.ATTRIBUTE1
	        ,NEW_REFERENCES.ATTRIBUTE2
	        ,NEW_REFERENCES.ATTRIBUTE3
	        ,NEW_REFERENCES.ATTRIBUTE4
	        ,NEW_REFERENCES.ATTRIBUTE5
	        ,NEW_REFERENCES.ATTRIBUTE6
	        ,NEW_REFERENCES.ATTRIBUTE7
	        ,NEW_REFERENCES.ATTRIBUTE8
	        ,NEW_REFERENCES.ATTRIBUTE9
	        ,NEW_REFERENCES.ATTRIBUTE10
	        ,NEW_REFERENCES.ATTRIBUTE11
	        ,NEW_REFERENCES.ATTRIBUTE12
	        ,NEW_REFERENCES.ATTRIBUTE13
	        ,NEW_REFERENCES.ATTRIBUTE14
	        ,NEW_REFERENCES.ATTRIBUTE15
	        ,NEW_REFERENCES.ATTRIBUTE16
	        ,NEW_REFERENCES.ATTRIBUTE17
	        ,NEW_REFERENCES.ATTRIBUTE18
	        ,NEW_REFERENCES.ATTRIBUTE19
	        ,NEW_REFERENCES.ATTRIBUTE20,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    NEW_REFERENCES.ORG_ID,
    new_references.rev_account_cd
  );

Line: 867


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

Line: 870


end INSERT_ROW;

Line: 913


  cursor c1 is select
      DESCRIPTION,
      LOCATION_TYPE,
      MAIL_DLVRY_WRK_DAYS,
      COORD_PERSON_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      CLOSED_IND
,     rev_account_cd
    from IGS_AD_LOCATION_ALL
    WHERE  ROWID = X_ROWID  for update nowait ;

Line: 950


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

Line: 1042


PROCEDURE UPDATE_ROW (
  X_ROWID  in VARCHAR2,
  X_LOCATION_CD in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_LOCATION_TYPE in VARCHAR2,
  X_MAIL_DLVRY_WRK_DAYS in NUMBER,
  X_COORD_PERSON_ID in igs_pe_person.person_id%type,
  X_CLOSED_IND in VARCHAR2,
    x_attribute_category IN VARCHAR2 DEFAULT NULL,
    x_attribute1 IN VARCHAR2 DEFAULT NULL,
    x_attribute2 IN VARCHAR2 DEFAULT NULL,
    x_attribute3 IN VARCHAR2 DEFAULT NULL,
    x_attribute4 IN VARCHAR2 DEFAULT NULL,
    x_attribute5 IN VARCHAR2 DEFAULT NULL,
    x_attribute6 IN VARCHAR2 DEFAULT NULL,
    x_attribute7 IN VARCHAR2 DEFAULT NULL,
    x_attribute8 IN VARCHAR2 DEFAULT NULL,
    x_attribute9 IN VARCHAR2 DEFAULT NULL,
    x_attribute10 IN VARCHAR2 DEFAULT NULL,
    x_attribute11 IN VARCHAR2 DEFAULT NULL,
    x_attribute12 IN VARCHAR2 DEFAULT NULL,
    x_attribute13 IN VARCHAR2 DEFAULT NULL,
    x_attribute14 IN VARCHAR2 DEFAULT NULL,
    x_attribute15 IN VARCHAR2 DEFAULT NULL,
    x_attribute16 IN VARCHAR2 DEFAULT NULL,
    x_attribute17 IN VARCHAR2 DEFAULT NULL,
    x_attribute18 IN VARCHAR2 DEFAULT NULL,
    x_attribute19 IN VARCHAR2 DEFAULT NULL,
    x_attribute20 IN VARCHAR2 DEFAULT NULL,
  X_MODE in VARCHAR2 default 'R',
  x_rev_account_cd IN VARCHAR2 DEFAULT NULL
  ) AS
  /*************************************************************
  Created By :
  Date Created By :
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What
  msrinivi        18 Jul,2001	   Added new col :rev_account_cd
  (reverse chronological order - newest change first)
  ***************************************************************/

    X_LAST_UPDATE_DATE DATE;

Line: 1086


    X_LAST_UPDATED_BY NUMBER;

Line: 1087


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 1089


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 1091


    X_LAST_UPDATED_BY := 1;

Line: 1092


    X_LAST_UPDATE_LOGIN := 0;

Line: 1094


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1095


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 1098


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 1099


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 1108


    p_action              => 'UPDATE' ,
    x_rowid               => X_ROWID,
    x_location_cd         => X_LOCATION_CD,
    x_description         => X_DESCRIPTION,
    x_location_type       => X_LOCATION_TYPE,
    x_closed_ind          => X_CLOSED_IND,
    x_coord_person_id     => X_COORD_PERSON_ID,
    x_mail_dlvry_wrk_days => X_MAIL_DLVRY_WRK_DAYS,
 	       x_attribute_category=>X_ATTRIBUTE_CATEGORY,
 	       x_attribute1=>X_ATTRIBUTE1,
 	       x_attribute2=>X_ATTRIBUTE2,
 	       x_attribute3=>X_ATTRIBUTE3,
 	       x_attribute4=>X_ATTRIBUTE4,
 	       x_attribute5=>X_ATTRIBUTE5,
 	       x_attribute6=>X_ATTRIBUTE6,
 	       x_attribute7=>X_ATTRIBUTE7,
 	       x_attribute8=>X_ATTRIBUTE8,
 	       x_attribute9=>X_ATTRIBUTE9,
 	       x_attribute10=>X_ATTRIBUTE10,
 	       x_attribute11=>X_ATTRIBUTE11,
 	       x_attribute12=>X_ATTRIBUTE12,
 	       x_attribute13=>X_ATTRIBUTE13,
 	       x_attribute14=>X_ATTRIBUTE14,
 	       x_attribute15=>X_ATTRIBUTE15,
 	       x_attribute16=>X_ATTRIBUTE16,
 	       x_attribute17=>X_ATTRIBUTE17,
 	       x_attribute18=>X_ATTRIBUTE18,
 	       x_attribute19=>X_ATTRIBUTE19,
 	       x_attribute20=>X_ATTRIBUTE20,
    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,
    x_rev_account_cd     => x_rev_account_cd
  );

Line: 1144


  update IGS_AD_LOCATION_ALL set
    DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
    LOCATION_TYPE = NEW_REFERENCES.LOCATION_TYPE,
    MAIL_DLVRY_WRK_DAYS = NEW_REFERENCES.MAIL_DLVRY_WRK_DAYS,
    COORD_PERSON_ID = NEW_REFERENCES.COORD_PERSON_ID,
      ATTRIBUTE_CATEGORY =  NEW_REFERENCES.ATTRIBUTE_CATEGORY,
      ATTRIBUTE1 =  NEW_REFERENCES.ATTRIBUTE1,
      ATTRIBUTE2 =  NEW_REFERENCES.ATTRIBUTE2,
      ATTRIBUTE3 =  NEW_REFERENCES.ATTRIBUTE3,
      ATTRIBUTE4 =  NEW_REFERENCES.ATTRIBUTE4,
      ATTRIBUTE5 =  NEW_REFERENCES.ATTRIBUTE5,
      ATTRIBUTE6 =  NEW_REFERENCES.ATTRIBUTE6,
      ATTRIBUTE7 =  NEW_REFERENCES.ATTRIBUTE7,
      ATTRIBUTE8 =  NEW_REFERENCES.ATTRIBUTE8,
      ATTRIBUTE9 =  NEW_REFERENCES.ATTRIBUTE9,
      ATTRIBUTE10 =  NEW_REFERENCES.ATTRIBUTE10,
      ATTRIBUTE11 =  NEW_REFERENCES.ATTRIBUTE11,
      ATTRIBUTE12 =  NEW_REFERENCES.ATTRIBUTE12,
      ATTRIBUTE13 =  NEW_REFERENCES.ATTRIBUTE13,
      ATTRIBUTE14 =  NEW_REFERENCES.ATTRIBUTE14,
      ATTRIBUTE15 =  NEW_REFERENCES.ATTRIBUTE15,
      ATTRIBUTE16 =  NEW_REFERENCES.ATTRIBUTE16,
      ATTRIBUTE17 =  NEW_REFERENCES.ATTRIBUTE17,
      ATTRIBUTE18 =  NEW_REFERENCES.ATTRIBUTE18,
      ATTRIBUTE19 =  NEW_REFERENCES.ATTRIBUTE19,
      ATTRIBUTE20 =  NEW_REFERENCES.ATTRIBUTE20,
    CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    rev_account_cd = new_references.rev_account_cd
  WHERE ROWID = X_ROWID  ;

Line: 1180


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

Line: 1183


end UPDATE_ROW;

Line: 1229


  cursor c1 is select rowid from IGS_AD_LOCATION_ALL
     where LOCATION_CD = X_LOCATION_CD   ;

Line: 1236


    INSERT_ROW (
     X_ROWID,
     X_ORG_ID,
     X_LOCATION_CD,
     X_DESCRIPTION,
     X_LOCATION_TYPE,
     X_MAIL_DLVRY_WRK_DAYS,
       X_ATTRIBUTE_CATEGORY,
       X_ATTRIBUTE1,
       X_ATTRIBUTE2,
       X_ATTRIBUTE3,
       X_ATTRIBUTE4,
       X_ATTRIBUTE5,
       X_ATTRIBUTE6,
       X_ATTRIBUTE7,
       X_ATTRIBUTE8,
       X_ATTRIBUTE9,
       X_ATTRIBUTE10,
       X_ATTRIBUTE11,
       X_ATTRIBUTE12,
       X_ATTRIBUTE13,
       X_ATTRIBUTE14,
       X_ATTRIBUTE15,
       X_ATTRIBUTE16,
       X_ATTRIBUTE17,
       X_ATTRIBUTE18,
       X_ATTRIBUTE19,
       X_ATTRIBUTE20,
     X_COORD_PERSON_ID,
     X_CLOSED_IND,
     X_MODE,
     x_rev_account_cd);

Line: 1271


  UPDATE_ROW (
   X_ROWID ,
   X_LOCATION_CD,
   X_DESCRIPTION,
   X_LOCATION_TYPE,
   X_MAIL_DLVRY_WRK_DAYS,
       X_ATTRIBUTE_CATEGORY,
       X_ATTRIBUTE1,
       X_ATTRIBUTE2,
       X_ATTRIBUTE3,
       X_ATTRIBUTE4,
       X_ATTRIBUTE5,
       X_ATTRIBUTE6,
       X_ATTRIBUTE7,
       X_ATTRIBUTE8,
       X_ATTRIBUTE9,
       X_ATTRIBUTE10,
       X_ATTRIBUTE11,
       X_ATTRIBUTE12,
       X_ATTRIBUTE13,
       X_ATTRIBUTE14,
       X_ATTRIBUTE15,
       X_ATTRIBUTE16,
       X_ATTRIBUTE17,
       X_ATTRIBUTE18,
       X_ATTRIBUTE19,
       X_ATTRIBUTE20,
   X_COORD_PERSON_ID,
   X_CLOSED_IND,
   X_MODE,
   x_rev_account_cd);

Line: 1304


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: 1322


  delete from IGS_AD_LOCATION_ALL
  where ROWID = X_ROWID;

Line: 1328


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

Line: 1331


end DELETE_ROW;