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

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

Line: 32


    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_PE_ABORG_TORESCD

      WHERE    rowid = x_rowid;

Line: 68


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

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

Line: 96


    IF (p_action = 'UPDATE') THEN

      new_references.creation_date := old_references.creation_date;

Line: 110


    new_references.last_update_date := x_last_update_date;

Line: 112


    new_references.last_updated_by := x_last_updated_by;

Line: 114


    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

	v_message_name varchar2(30);

Line: 140


	IF p_inserting OR ((old_references.govt_aborig_torres_cd <> new_references.govt_aborig_torres_cd) OR

			 (old_references.closed_ind = 'Y' AND new_references.closed_ind = 'N')) THEN

		IF IGS_EN_VAL_ATC.enrp_val_atc_govt (

				new_references.govt_aborig_torres_cd,

				v_message_name) = FALSE THEN

			Fnd_Message.Set_Name('IGS', v_message_name);

Line: 157


  END BeforeRowInsertUpdate1;

Line: 223


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

Line: 242


      SELECT   rowid

      FROM     IGS_PE_ABORG_TORESCD

      WHERE    aborig_torres_cd = x_aborig_torres_cd

      FOR UPDATE NOWAIT;

Line: 279


      SELECT   rowid

      FROM     IGS_PE_ABORG_TORESCD

      WHERE    govt_aborig_torres_cd = x_govt_aborig_torres_cd  ;

Line: 339


    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_aborig_torres_cd,

      x_govt_aborig_torres_cd,

      x_description,

      x_closed_ind,

      x_notes,

      x_creation_date,

      x_created_by,

      x_last_update_date,

      x_last_updated_by,

      x_last_update_login

    );

Line: 381


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

Line: 393


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

Line: 400


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

       null; -- if procedure present

Line: 404


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

Line: 413


 ELSIF (p_action = 'VALIDATE_UPDATE') THEN

       Check_Constraints; -- if procedure present

Line: 417


ELSIF (p_action = 'VALIDATE_DELETE') THEN
      null; -- if procedure present

Line: 443


    IF (p_action = 'INSERT') THEN

      -- Call all the procedures related to After Insert.

      Null;

Line: 449


    ELSIF (p_action = 'UPDATE') THEN

      -- Call all the procedures related to After Update.

      Null;

Line: 455


    ELSIF (p_action = 'DELETE') THEN

      -- Call all the procedures related to After Delete.

      Null;

Line: 470


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_ABORIG_TORRES_CD in VARCHAR2,
  X_GOVT_ABORIG_TORRES_CD in NUMBER,
  X_DESCRIPTION in VARCHAR2,
  X_CLOSED_IND in VARCHAR2,
  X_NOTES in VARCHAR2,
  X_MODE in VARCHAR2 default 'R'
  ) as
    cursor C is select ROWID from IGS_PE_ABORG_TORESCD
      where ABORIG_TORRES_CD = X_ABORIG_TORRES_CD;

Line: 481


    X_LAST_UPDATE_DATE DATE;

Line: 482


    X_LAST_UPDATED_BY NUMBER;

Line: 483


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 485


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 487


    X_LAST_UPDATED_BY := 1;

Line: 488


    X_LAST_UPDATE_LOGIN := 0;

Line: 490


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 491


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 494


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 495


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 508


 p_action=>'INSERT',

 x_rowid=>X_ROWID,

 x_aborig_torres_cd=>X_ABORIG_TORRES_CD,

 x_closed_ind=> NVL(X_CLOSED_IND,'N'),

 x_description=>X_DESCRIPTION,

 x_govt_aborig_torres_cd=>X_GOVT_ABORIG_TORRES_CD,

 x_notes=>X_NOTES,

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


insert into IGS_PE_ABORG_TORESCD (
    ABORIG_TORRES_CD,
    GOVT_ABORIG_TORRES_CD,
    DESCRIPTION,
    CLOSED_IND,
    NOTES,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    NEW_REFERENCES.ABORIG_TORRES_CD,
    NEW_REFERENCES.GOVT_ABORIG_TORRES_CD,
    NEW_REFERENCES.DESCRIPTION,
    NEW_REFERENCES.CLOSED_IND,
    NEW_REFERENCES.NOTES,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 571


  p_action => 'INSERT',

  x_rowid => X_ROWID

  );

Line: 576


end INSERT_ROW;

Line: 587


  cursor c1 is select
      GOVT_ABORIG_TORRES_CD,
      DESCRIPTION,
      CLOSED_IND,
      NOTES
    from IGS_PE_ABORG_TORESCD
    where ROWID = X_ROWID

    for update nowait;

Line: 602


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

Line: 625


procedure UPDATE_ROW (

  X_ROWID in VARCHAR2,
  X_ABORIG_TORRES_CD in VARCHAR2,
  X_GOVT_ABORIG_TORRES_CD in NUMBER,
  X_DESCRIPTION in VARCHAR2,
  X_CLOSED_IND in VARCHAR2,
  X_NOTES in VARCHAR2,
  X_MODE in VARCHAR2 default 'R'
  ) as
    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: 662


 p_action=>'UPDATE',

 x_rowid=>X_ROWID,

 x_aborig_torres_cd=>X_ABORIG_TORRES_CD,

 x_closed_ind=>X_CLOSED_IND,

 x_description=>X_DESCRIPTION,

 x_govt_aborig_torres_cd=>X_GOVT_ABORIG_TORRES_CD,

 x_notes=>X_NOTES,

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


  update IGS_PE_ABORG_TORESCD set
    GOVT_ABORIG_TORRES_CD = NEW_REFERENCES.GOVT_ABORIG_TORRES_CD,
    DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
    CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
    NOTES = NEW_REFERENCES.NOTES,
    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: 705


  p_action => 'UPDATE',

  x_rowid => X_ROWID

  );

Line: 710


end UPDATE_ROW;

Line: 721


  cursor c1 is select rowid from IGS_PE_ABORG_TORESCD
     where ABORIG_TORRES_CD = X_ABORIG_TORRES_CD
  ;

Line: 731


    INSERT_ROW (

     X_ROWID,
     X_ABORIG_TORRES_CD,
     X_GOVT_ABORIG_TORRES_CD,
     X_DESCRIPTION,
     X_CLOSED_IND,
     X_NOTES,
     X_MODE);

Line: 743


  UPDATE_ROW (

   X_ROWID,
   X_ABORIG_TORRES_CD,
   X_GOVT_ABORIG_TORRES_CD,
   X_DESCRIPTION,
   X_CLOSED_IND,
   X_NOTES,
   X_MODE);

Line: 754


procedure DELETE_ROW (
 X_ROWID in VARCHAR2
) as
begin

 Before_DML(

  p_action => 'DELETE',

  x_rowid => X_ROWID

  );

Line: 766


  delete from IGS_PE_ABORG_TORESCD
  where ROWID = X_ROWID;

Line: 776


  p_action => 'DELETE',

  x_rowid => X_ROWID

  );

Line: 783


end DELETE_ROW;