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

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

Line: 19


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

Line: 37


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

Line: 39


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

Line: 40


      IGS_RU_GEN_006.SET_TOKEN('IGS_RU_DESCRIPTION : P_ACTION  INSERT, VALIDATE_INSERT : IGSUI03B.PLS');

Line: 54


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

Line: 61


    new_references.last_update_date := x_last_update_date;

Line: 62


    new_references.last_updated_by := x_last_updated_by;

Line: 63


    new_references.last_update_login := x_last_update_login;

Line: 73


  PROCEDURE BeforeRowInsertUpdate1(
    p_inserting IN BOOLEAN ,
    p_updating IN BOOLEAN ,
    p_deleting IN BOOLEAN
    ) as
	v_message_name	Varchar2(30);

Line: 80


	IF p_inserting OR p_updating
	THEN
		-- validate return type and IGS_RU_RULE description
		IF IGS_RU_VAL_RUD.rulp_val_rud_desc(
				old_references.sequence_number,
				old_references.s_return_type,
				old_references.rule_description,
				old_references.s_turin_function,
				new_references.s_return_type,
				new_references.rule_description,
				v_message_name) = FALSE
		THEN
		Fnd_Message.Set_Name('IGS',v_message_name);

Line: 99


  END BeforeRowInsertUpdate1;

Line: 107


  PROCEDURE AfterRowUpdate2(
    p_inserting IN BOOLEAN ,
    p_updating IN BOOLEAN ,
    p_deleting IN BOOLEAN
    ) as
  --
  -- if named IGS_RU_RULE then update IGS_RU_RULE text
  -- else retry with parent IGS_RU_RULE
  --
  PROCEDURE do_rule_text (
  	p_rule_number	NUMBER )
  as
  	v_rule_text	IGS_RU_NAMED_RULE.rule_text%TYPE;

Line: 122


  		SELECT	rule_text
  		FROM	IGS_RU_NAMED_RULE
  		WHERE	rul_sequence_number = p_rule_number )
  	LOOP
  		-- if named IGS_RU_RULE then update IGS_RU_RULE text
  		v_rule_text := IGS_RU_GEN_006.RULP_GET_RULE(p_rule_number);-- Changed IGS_RU_GEN_003 to IGS_RU_GEN_006 As part of Seed Migration Build Bug :2233951. This approach is taken to resolve the release issues .

Line: 128


  		UPDATE	IGS_RU_NAMED_RULE
  		SET	rule_text = v_rule_text
  		WHERE	rul_sequence_number = p_rule_number;

Line: 135


  		SELECT	rul_sequence_number
  		FROM	IGS_RU_ITEM
  		WHERE	rule_number = p_rule_number )
  	LOOP
  		do_rule_text(rui.rul_sequence_number);

Line: 150


  				SELECT UNIQUE
  					rul_sequence_number
	  			FROM	IGS_RU_ITEM
  				WHERE	turin_function = New_References.S_TURIN_FUNCTION )
  			LOOP
  				-- update the IGS_RU_RULE text of this named IGS_RU_RULE
	  			do_rule_text(rui.rul_sequence_number);

Line: 161


  				SELECT UNIQUE
	  				rui.rul_sequence_number
  				FROM	IGS_RU_NAMED_RULE	nr,
  					IGS_RU_ITEM	rui
  				WHERE	nr.rud_sequence_number = New_References.sequence_number
	  			AND	rui.named_rule = nr.rul_sequence_number )
  			LOOP
  				-- update the IGS_RU_RULE text of this named IGS_RU_RULE
  				do_rule_text(nr.rul_sequence_number);

Line: 174


  END AfterRowUpdate2;

Line: 237


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

Line: 250


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

Line: 297


      SELECT   rowid
      FROM     IGS_RU_DESCRIPTION
      WHERE    sequence_number = x_sequence_number
      FOR UPDATE NOWAIT;

Line: 326


      SELECT   rowid
      FROM     IGS_RU_DESCRIPTION
      WHERE    s_return_type    = x_s_return_type
       AND     rule_description  = x_rule_description
       AND     (l_rowid is null or rowid <> l_rowid)
      FOR UPDATE NOWAIT;

Line: 355


      SELECT   rowid
      FROM     IGS_RU_DESCRIPTION
      WHERE    s_return_type = x_s_return_type ;

Line: 381


      SELECT   rowid
      FROM     IGS_RU_DESCRIPTION
      WHERE    s_turin_function = x_s_turin_function ;

Line: 413


    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_sequence_number,
      x_s_return_type,
      x_rule_description,
      x_s_turin_function,
      x_parenthesis_ind,
      x_description,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );

Line: 434


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

Line: 447


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

Line: 453


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

Line: 456


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

Line: 466


 	ELSIF (p_action = 'VALIDATE_UPDATE') THEN
       check_uniqueness;

Line: 469


	ELSIF (p_action = 'VALIDATE_DELETE') THEN
      Check_Child_Existance;

Line: 483


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

Line: 490


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_SEQUENCE_NUMBER in NUMBER,
  X_S_RETURN_TYPE in VARCHAR2,
  X_RULE_DESCRIPTION in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_S_TURIN_FUNCTION in VARCHAR2,
  X_PARENTHESIS_IND in VARCHAR2,
  X_MODE in VARCHAR2
  ) as
  ------------------------------------------------------------------
  --Created by  : nsinha, Oracle India
  --Date created: 12-Mar-2001
  --
  --Purpose: INSERT_ROW
  --
  --Known limitations/enhancements and/or remarks:
  --
  --Change History:
  --Who         When            What
  --kdande      15-Mar-2002     Bug # 2233951: The cursor C is being modified and cursor
  --                            cur_max_plus_one is being created. This is to ensure that
  --                            when a user defined rule is created,
  --                            it picks up a sequence number more than 500000.
  --  rnirwani - 15-Mar-02 - 2233951 the cursor has been changed to do a select for update
 --              so that parallel processing can be prevented.
  -------------------------------------------------------------------
    l_sequence_number NUMBER;

Line: 518


    cursor C is select ROWID from IGS_RU_DESCRIPTION
      where SEQUENCE_NUMBER = L_SEQUENCE_NUMBER;

Line: 521


      SELECT  (a.sequence_number + 1) sequence_number
      FROM     igs_ru_description a
      WHERE a.sequence_number = (SELECT MAX(b.sequence_number) FROM igs_ru_description b
      WHERE    b.sequence_number < 499999) FOR UPDATE OF a.sequence_number NOWAIT;

Line: 525


    X_LAST_UPDATE_DATE DATE;

Line: 526


    X_LAST_UPDATED_BY NUMBER;

Line: 527


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 529


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 531


    X_LAST_UPDATED_BY := 1;

Line: 532


    X_LAST_UPDATE_LOGIN := 0;

Line: 534


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 535


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 538


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 539


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 549


   p_action=>'INSERT',
   x_rowid=>X_ROWID,
   x_description=>X_DESCRIPTION,
   x_parenthesis_ind=>X_PARENTHESIS_IND,
   x_rule_description=>X_RULE_DESCRIPTION,
   x_s_return_type=>X_S_RETURN_TYPE,
   x_s_turin_function=>X_S_TURIN_FUNCTION,
   x_sequence_number=>X_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: 590


  insert into IGS_RU_DESCRIPTION (
    SEQUENCE_NUMBER,
    S_RETURN_TYPE,
    RULE_DESCRIPTION,
    DESCRIPTION,
    S_TURIN_FUNCTION,
    PARENTHESIS_IND,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    l_sequence_number,
    NEW_REFERENCES.S_RETURN_TYPE,
    NEW_REFERENCES.RULE_DESCRIPTION,
    NEW_REFERENCES.DESCRIPTION,
    NEW_REFERENCES.S_TURIN_FUNCTION,
    NEW_REFERENCES.PARENTHESIS_IND,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 625


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

Line: 628


end INSERT_ROW;

Line: 639


  cursor c1 is select
      S_RETURN_TYPE,
      RULE_DESCRIPTION,
      DESCRIPTION,
      S_TURIN_FUNCTION,
      PARENTHESIS_IND
    from IGS_RU_DESCRIPTION
    where ROWID = X_ROWID for update nowait;

Line: 654


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

Line: 684


procedure UPDATE_ROW (
  X_ROWID in VARCHAR2,
  X_SEQUENCE_NUMBER in NUMBER,
  X_S_RETURN_TYPE in VARCHAR2,
  X_RULE_DESCRIPTION in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_S_TURIN_FUNCTION in VARCHAR2,
  X_PARENTHESIS_IND in VARCHAR2,
  X_MODE in VARCHAR2
  )as
    X_LAST_UPDATE_DATE DATE;

Line: 695


    X_LAST_UPDATED_BY NUMBER;

Line: 696


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 698


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 700


    X_LAST_UPDATED_BY := 1;

Line: 701


    X_LAST_UPDATE_LOGIN := 0;

Line: 703


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 704


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 707


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 708


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 718


   p_action=>'UPDATE',
   x_rowid=>X_ROWID,
   x_description=>X_DESCRIPTION,
   x_parenthesis_ind=>X_PARENTHESIS_IND,
   x_rule_description=>X_RULE_DESCRIPTION,
   x_s_return_type=>X_S_RETURN_TYPE,
   x_s_turin_function=>X_S_TURIN_FUNCTION,
   x_sequence_number=>X_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: 733


  update IGS_RU_DESCRIPTION set
    S_RETURN_TYPE = NEW_REFERENCES.S_RETURN_TYPE,
    RULE_DESCRIPTION = NEW_REFERENCES.RULE_DESCRIPTION,
    DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
    S_TURIN_FUNCTION = NEW_REFERENCES.S_TURIN_FUNCTION,
    PARENTHESIS_IND = NEW_REFERENCES.PARENTHESIS_IND,
    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: 749


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

Line: 752


end UPDATE_ROW;

Line: 764


  cursor c1 is select rowid from IGS_RU_DESCRIPTION
     where SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
  ;

Line: 772


    INSERT_ROW (
     X_ROWID,
     X_SEQUENCE_NUMBER,
     X_S_RETURN_TYPE,
     X_RULE_DESCRIPTION,
     X_DESCRIPTION,
     X_S_TURIN_FUNCTION,
     X_PARENTHESIS_IND,
     X_MODE);

Line: 784


  UPDATE_ROW (
   X_ROWID,
   X_SEQUENCE_NUMBER,
   X_S_RETURN_TYPE,
   X_RULE_DESCRIPTION,
   X_DESCRIPTION,
   X_S_TURIN_FUNCTION,
   X_PARENTHESIS_IND,
   X_MODE);

Line: 795


procedure DELETE_ROW (
  X_ROWID in VARCHAR2
) as
begin

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

Line: 804


  delete from IGS_RU_DESCRIPTION
  where ROWID = X_ROWID;

Line: 811


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

Line: 814


end DELETE_ROW;