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

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

Line: 17


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

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

Line: 35


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

Line: 37


      IGS_RU_GEN_006.SET_TOKEN('IGS_RU_GROUP_ITEM : P_ACTION INSERT VALIDATE_INSERT   : IGSUI05B.PLS');

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


  PROCEDURE BeforeRowInsertUpdateDelete1(
    p_inserting IN BOOLEAN ,
    p_updating IN BOOLEAN ,
    p_deleting IN BOOLEAN
    ) as
	v_message_name	VARCHAR2(30);

Line: 96


  END BeforeRowInsertUpdateDelete1;

Line: 103


  PROCEDURE AfterStmtInsertUpdateDelete2(
    p_inserting IN BOOLEAN ,
    p_updating IN BOOLEAN ,
    p_deleting IN BOOLEAN
    ) as
	v_message_name	VARCHAR2(30);

Line: 113


		v_message_name := 'IGS_GE_GROUP_INSERT_NOT_ALLOW';

Line: 122


  END AfterStmtInsertUpdateDelete2;

Line: 183


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

Line: 200


      SELECT   rowid
      FROM     IGS_RU_GROUP_ITEM
      WHERE    rug_sequence_number = x_rug_sequence_number
      AND      description_number = x_description_number
      AND      description_type = x_description_type
      FOR UPDATE NOWAIT;

Line: 228


      SELECT   rowid
      FROM     IGS_RU_GROUP_ITEM
      WHERE    rug_sequence_number = x_sequence_number ;

Line: 257


    x_last_update_date IN DATE ,
    x_last_updated_by IN NUMBER ,
    x_last_update_login IN NUMBER
  ) as
  BEGIN

    Set_Column_Values (
      p_action,
      x_rowid,
      x_rug_sequence_number,
      x_description_number,
      x_description_type,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );

Line: 276


    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to Before Insert.
      BeforeRowInsertUpdateDelete1 ( p_inserting => TRUE, p_updating => FALSE, p_deleting => FALSE );

Line: 290


    ELSIF (p_action = 'UPDATE') THEN
      -- Call all the procedures related to Before Update.
      BeforeRowInsertUpdateDelete1 (p_inserting => FALSE, p_updating => TRUE, p_deleting => FALSE);

Line: 295


    ELSIF (p_action = 'DELETE') THEN
      -- Call all the procedures related to Before Delete.
      BeforeRowInsertUpdateDelete1 ( p_inserting => FALSE, p_updating => FALSE, p_deleting => TRUE );

Line: 298


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

Line: 309


    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
       Check_Constraints;

Line: 322


    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to After Insert.
      AfterStmtInsertUpdateDelete2 ( p_inserting => TRUE, p_updating => FALSE, p_deleting => FALSE );

Line: 325


    ELSIF (p_action = 'UPDATE') THEN
      -- Call all the procedures related to After Update.
      AfterStmtInsertUpdateDelete2 ( p_inserting => FALSE, p_updating => TRUE, p_deleting => FALSE );

Line: 328


    ELSIF (p_action = 'DELETE') THEN
      -- Call all the procedures related to After Delete.
      AfterStmtInsertUpdateDelete2 ( p_inserting => FALSE, p_updating => FALSE, p_deleting => TRUE );

Line: 335


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_RUG_SEQUENCE_NUMBER in NUMBER,
  X_DESCRIPTION_NUMBER in NUMBER,
  X_DESCRIPTION_TYPE in VARCHAR2,
  X_MODE in VARCHAR2
  ) as
    cursor C is select ROWID from IGS_RU_GROUP_ITEM
      where RUG_SEQUENCE_NUMBER = X_RUG_SEQUENCE_NUMBER
      and DESCRIPTION_NUMBER = X_DESCRIPTION_NUMBER
      and DESCRIPTION_TYPE = X_DESCRIPTION_TYPE;

Line: 346


    X_LAST_UPDATE_DATE DATE;

Line: 347


    X_LAST_UPDATED_BY NUMBER;

Line: 348


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 350


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 352


    X_LAST_UPDATED_BY := 1;

Line: 353


    X_LAST_UPDATE_LOGIN := 0;

Line: 355


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 356


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 359


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 360


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 370


   p_action=>'INSERT',
   x_rowid=>X_ROWID,
   x_description_number=>X_DESCRIPTION_NUMBER,
   x_description_type=>X_DESCRIPTION_TYPE,
   x_rug_sequence_number=>X_RUG_SEQUENCE_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: 381


  insert into IGS_RU_GROUP_ITEM (
    RUG_SEQUENCE_NUMBER,
    DESCRIPTION_NUMBER,
    DESCRIPTION_TYPE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    NEW_REFERENCES.RUG_SEQUENCE_NUMBER,
    NEW_REFERENCES.DESCRIPTION_NUMBER,
    NEW_REFERENCES.DESCRIPTION_TYPE,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 410


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

Line: 413


end INSERT_ROW;

Line: 421


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

Line: 430


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

Line: 442


procedure UPDATE_ROW (
  X_ROWID  			in VARCHAR2,
  X_RUG_SEQUENCE_NUMBER in NUMBER,
  X_DESCRIPTION_NUMBER in NUMBER,
  X_DESCRIPTION_TYPE in VARCHAR2,
  X_MODE in VARCHAR2
  ) as
    X_LAST_UPDATE_DATE DATE;

Line: 450


    X_LAST_UPDATED_BY NUMBER;

Line: 451


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 453


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 455


    X_LAST_UPDATED_BY := 1;

Line: 456


    X_LAST_UPDATE_LOGIN := 0;

Line: 458


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 459


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 462


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 463


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 472


   p_action=>'UPDATE',
   x_rowid=>X_ROWID,
   x_description_number=>X_DESCRIPTION_NUMBER,
   x_description_type=>X_DESCRIPTION_TYPE,
   x_rug_sequence_number=>X_RUG_SEQUENCE_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: 484


  update IGS_RU_GROUP_ITEM set
    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: 494


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

Line: 497


end UPDATE_ROW;

Line: 499


procedure DELETE_ROW (
  X_ROWID in VARCHAR2
) as
begin

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

Line: 508


  delete from IGS_RU_GROUP_ITEM
  where ROWID = X_ROWID;

Line: 515


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

Line: 518


end DELETE_ROW;