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

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

Line: 21


    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_ITEM
      WHERE    rowid = x_rowid;

Line: 39


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

Line: 41


      IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_ITEM  : P_ACTION INSERT VALIDATE_INSERT   : IGSUI07B.PLS');

Line: 58


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

Line: 65


    new_references.last_update_date := x_last_update_date;

Line: 66


    new_references.last_updated_by := x_last_updated_by;

Line: 67


    new_references.last_update_login := x_last_update_login;

Line: 127


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

Line: 141


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

Line: 155


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

Line: 169


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

Line: 183


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

Line: 197


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

Line: 212


      SELECT   rowid
      FROM     IGS_RU_ITEM
      WHERE    rul_sequence_number = x_rul_sequence_number
      AND      item = x_item
      FOR UPDATE NOWAIT;

Line: 238


      SELECT   rowid
      FROM     IGS_RU_ITEM
      WHERE    named_rule = x_rul_sequence_number ;

Line: 264


      SELECT   rowid
      FROM     IGS_RU_ITEM
      WHERE    rul_sequence_number = x_sequence_number
      OR 	   rule_number = x_sequence_number ;

Line: 291


      SELECT   rowid
      FROM     IGS_RU_ITEM
      WHERE    set_number = x_sequence_number ;

Line: 317


      SELECT   rowid
      FROM     IGS_RU_ITEM
      WHERE    derived_rule = x_rud_sequence_number ;

Line: 343


      SELECT   rowid
      FROM     IGS_RU_ITEM
      WHERE    turin_function = x_s_turin_function ;

Line: 377


    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_rul_sequence_number,
      x_item,
      x_turin_function,
      x_named_rule,
      x_rule_number,
      x_set_number,
      x_value,
      x_derived_rule,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );

Line: 400


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

Line: 413


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

Line: 417


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

Line: 427


      ELSIF (p_action = 'VALIDATE_UPDATE') THEN
       Check_Constraints;

Line: 442


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_RUL_SEQUENCE_NUMBER in NUMBER,
  X_ITEM in NUMBER,
  X_TURIN_FUNCTION in VARCHAR2,
  X_NAMED_RULE in NUMBER,
  X_RULE_NUMBER in NUMBER,
  X_SET_NUMBER in NUMBER,
  X_VALUE in VARCHAR2,
  X_DERIVED_RULE in NUMBER,
  X_MODE in VARCHAR2
  )as
    cursor C is select ROWID from IGS_RU_ITEM
      where RUL_SEQUENCE_NUMBER = X_RUL_SEQUENCE_NUMBER
      and ITEM = X_ITEM;

Line: 457


    X_LAST_UPDATE_DATE DATE;

Line: 458


    X_LAST_UPDATED_BY NUMBER;

Line: 459


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 461


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 463


    X_LAST_UPDATED_BY := 1;

Line: 464


    X_LAST_UPDATE_LOGIN := 0;

Line: 466


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 467


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 470


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 471


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 481


   p_action=>'INSERT',
   x_rowid=>X_ROWID,
   x_derived_rule=>X_DERIVED_RULE,
   x_item=>X_ITEM,
   x_named_rule=>X_NAMED_RULE,
   x_rul_sequence_number=>X_RUL_SEQUENCE_NUMBER,
   x_rule_number=>X_RULE_NUMBER,
   x_set_number=>X_SET_NUMBER,
   x_turin_function=>X_TURIN_FUNCTION,
   x_value=>X_VALUE,
   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: 498


  insert into IGS_RU_ITEM (
    RUL_SEQUENCE_NUMBER,
    ITEM,
    TURIN_FUNCTION,
    NAMED_RULE,
    RULE_NUMBER,
    SET_NUMBER,
    VALUE,
    DERIVED_RULE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    NEW_REFERENCES.RUL_SEQUENCE_NUMBER,
    NEW_REFERENCES.ITEM,
    NEW_REFERENCES.TURIN_FUNCTION,
    NEW_REFERENCES.NAMED_RULE,
    NEW_REFERENCES.RULE_NUMBER,
    NEW_REFERENCES.SET_NUMBER,
    NEW_REFERENCES.VALUE,
    NEW_REFERENCES.DERIVED_RULE,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 537


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

Line: 540


end INSERT_ROW;

Line: 553


  cursor c1 is select
      TURIN_FUNCTION,
      NAMED_RULE,
      RULE_NUMBER,
      SET_NUMBER,
      VALUE,
      DERIVED_RULE
    from IGS_RU_ITEM
    where ROWID = X_ROWID for update nowait;

Line: 568


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

Line: 606


procedure UPDATE_ROW (
  X_ROWID in VARCHAR2,
  X_RUL_SEQUENCE_NUMBER in NUMBER,
  X_ITEM in NUMBER,
  X_TURIN_FUNCTION in VARCHAR2,
  X_NAMED_RULE in NUMBER,
  X_RULE_NUMBER in NUMBER,
  X_SET_NUMBER in NUMBER,
  X_VALUE in VARCHAR2,
  X_DERIVED_RULE in NUMBER,
  X_MODE in VARCHAR2
  )as
    X_LAST_UPDATE_DATE DATE;

Line: 619


    X_LAST_UPDATED_BY NUMBER;

Line: 620


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 622


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 624


    X_LAST_UPDATED_BY := 1;

Line: 625


    X_LAST_UPDATE_LOGIN := 0;

Line: 627


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 628


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 631


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 632


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 642


   p_action=>'UPDATE',
   x_rowid=>X_ROWID,
   x_derived_rule=>X_DERIVED_RULE,
   x_item=>X_ITEM,
   x_named_rule=>X_NAMED_RULE,
   x_rul_sequence_number=>X_RUL_SEQUENCE_NUMBER,
   x_rule_number=>X_RULE_NUMBER,
   x_set_number=>X_SET_NUMBER,
   x_turin_function=>X_TURIN_FUNCTION,
   x_value=>X_VALUE,
   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: 659


  update IGS_RU_ITEM set
    TURIN_FUNCTION = NEW_REFERENCES.TURIN_FUNCTION,
    NAMED_RULE = NEW_REFERENCES.NAMED_RULE,
    RULE_NUMBER = NEW_REFERENCES.RULE_NUMBER,
    SET_NUMBER = NEW_REFERENCES.SET_NUMBER,
    VALUE = NEW_REFERENCES.VALUE,
    DERIVED_RULE = NEW_REFERENCES.DERIVED_RULE,
    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: 676


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

Line: 679


end UPDATE_ROW;

Line: 693


  cursor c1 is select rowid from IGS_RU_ITEM
     where RUL_SEQUENCE_NUMBER = X_RUL_SEQUENCE_NUMBER
     and ITEM = X_ITEM
  ;

Line: 702


    INSERT_ROW (
     X_ROWID,
     X_RUL_SEQUENCE_NUMBER,
     X_ITEM,
     X_TURIN_FUNCTION,
     X_NAMED_RULE,
     X_RULE_NUMBER,
     X_SET_NUMBER,
     X_VALUE,
     X_DERIVED_RULE,
     X_MODE);

Line: 716


  UPDATE_ROW (
   X_ROWID,
   X_RUL_SEQUENCE_NUMBER,
   X_ITEM,
   X_TURIN_FUNCTION,
   X_NAMED_RULE,
   X_RULE_NUMBER,
   X_SET_NUMBER,
   X_VALUE,
   X_DERIVED_RULE,
   X_MODE);

Line: 729


procedure DELETE_ROW (
  X_ROWID in VARCHAR2
)as
begin

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

Line: 738


  delete from IGS_RU_ITEM
  where ROWID = X_ROWID;

Line: 745


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

Line: 748


end DELETE_ROW;

Line: 760


    x_last_update_date    IN VARCHAR2,
    x_custom_mode         IN VARCHAR2  ) IS

    f_luby    number;  -- entity owner in file

Line: 764


    f_ludate  date;    -- entity update date in file

Line: 766


    db_ludate date;    -- entity update date in db

Line: 770


    SELECT last_updated_by, last_update_date
    FROM   igs_ru_item
    WHERE  rul_sequence_number = cp_rul_sequence_number
    AND    item = cp_item
    AND    rul_sequence_number <= 500000; -- this is the addtional check put to filter out the customer defined rules, bug 2421803

Line: 783


    f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 791


	-- Delete all the old entries for the currenly processed RUL_SEQUENCE_NUMBER
	-- Added as part of bug fix 2421803, nshee
	DELETE FROM IGS_RU_ITEM
	WHERE  RUL_SEQUENCE_NUMBER = x_rul_sequence_number;

Line: 796


	INSERT INTO igs_ru_item
	(
	  RUL_SEQUENCE_NUMBER,
	  ITEM,
	  TURIN_FUNCTION,
	  NAMED_RULE,
	  RULE_NUMBER,
	  SET_NUMBER,
	  VALUE,
	  DERIVED_RULE,
	  CREATED_BY,
	  CREATION_DATE,
	  LAST_UPDATED_BY,
	  LAST_UPDATE_DATE,
	  LAST_UPDATE_LOGIN
	)
	VALUES
	(
	  x_rul_sequence_number,
	  x_item,
	  x_turin_function,
	  x_named_rule,
	  x_rule_number,
	  x_set_number,
	  x_value,
	  x_derived_rule,
	  f_luby,
	  f_ludate,
	  f_luby,
	  f_ludate,
	  0
	);

Line: 831


      INSERT INTO igs_ru_item
      (
	RUL_SEQUENCE_NUMBER,
	ITEM,
	TURIN_FUNCTION,
	NAMED_RULE,
	RULE_NUMBER,
	SET_NUMBER,
	VALUE,
	DERIVED_RULE,
	CREATED_BY,
	CREATION_DATE,
	LAST_UPDATED_BY,
	LAST_UPDATE_DATE,
	LAST_UPDATE_LOGIN
      )
      VALUES
      (
	x_rul_sequence_number,
	x_item,
	x_turin_function,
	x_named_rule,
	x_rule_number,
	x_set_number,
	x_value,
	x_derived_rule,
	f_luby,
	f_ludate,
	f_luby,
	f_ludate,
	0
      );

Line: 880


    x_last_update_date    IN VARCHAR2,
    x_custom_mode         IN VARCHAR2  ) IS

  BEGIN

	 IF (x_upload_mode = 'NLS') THEN
	   NULL; --For translated record call Table_pkg.TRANSLATE_ROW

Line: 898


	      x_last_update_date    => x_last_update_date ,
	      x_custom_mode	    => x_custom_mode );