DBA Data[Home] [Help]

APPS.IGS_RU_NAMED_RULE_PKG SQL Statements

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

Line: 18

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

    CURSOR cur_old_ref_values IS
      SELECT   *
      FROM     IGS_RU_NAMED_RULE
      WHERE    rowid = x_rowid;
Line: 36

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

      IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_NAMED_RULE  : P_ACTION INSERT VALIDATE_INSERT   : IGSUI09B.PLS');
Line: 52

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

    new_references.last_update_date := x_last_update_date;
Line: 60

    new_references.last_updated_by := x_last_updated_by;
Line: 61

    new_references.last_update_login := x_last_update_login;
Line: 130

     Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
Line: 144

     Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
Line: 158

     Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
Line: 172

     Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
Line: 203

      SELECT   rowid
      FROM     IGS_RU_NAMED_RULE
      WHERE    rul_sequence_number = x_rul_sequence_number
      FOR UPDATE NOWAIT;
Line: 229

      SELECT   rowid
      FROM     IGS_RU_NAMED_RULE
      WHERE    rud_sequence_number = x_sequence_number ;
Line: 255

      SELECT   rowid
      FROM     IGS_RU_NAMED_RULE
      WHERE    rug_sequence_number = x_sequence_number ;
Line: 281

      SELECT   rowid
      FROM     IGS_RU_NAMED_RULE
      WHERE    rul_sequence_number = x_sequence_number
      OR       message_rule = x_sequence_number ;
Line: 313

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

    Set_Column_Values (
      p_action,
      x_rowid,
      x_rul_sequence_number,
      x_rud_sequence_number,
      x_message_rule,
      x_rug_sequence_number,
      x_rule_text,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );
Line: 333

 IF (p_action = 'INSERT') THEN
       -- Call all the procedures related to Before Insert.
      IF  Get_PK_For_Validation (
          new_references.rul_sequence_number
		) THEN
         Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
Line: 344

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

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

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

 ELSIF (p_action = 'VALIDATE_UPDATE') THEN
       Check_Constraints;
Line: 362

 ELSIF (p_action = 'VALIDATE_DELETE') THEN
      Check_Child_Existance;
Line: 377

procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_RUL_SEQUENCE_NUMBER in NUMBER,
  X_RUD_SEQUENCE_NUMBER in NUMBER,
  X_MESSAGE_RULE in NUMBER,
  X_RUG_SEQUENCE_NUMBER in NUMBER,
  X_RULE_TEXT in VARCHAR2,
  X_MODE in VARCHAR2
  ) is
    cursor C is select ROWID from IGS_RU_NAMED_RULE
      where RUL_SEQUENCE_NUMBER = X_RUL_SEQUENCE_NUMBER;
Line: 388

    X_LAST_UPDATE_DATE DATE;
Line: 389

    X_LAST_UPDATED_BY NUMBER;
Line: 390

    X_LAST_UPDATE_LOGIN NUMBER;
Line: 392

  X_LAST_UPDATE_DATE := SYSDATE;
Line: 394

    X_LAST_UPDATED_BY := 1;
Line: 395

    X_LAST_UPDATE_LOGIN := 0;
Line: 397

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 398

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;
Line: 401

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
Line: 402

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;
Line: 413

   p_action=>'INSERT',
   x_rowid=>X_ROWID,
   x_message_rule=>X_MESSAGE_RULE,
   x_rud_sequence_number=>X_RUD_SEQUENCE_NUMBER,
   x_rug_sequence_number=>X_RUG_SEQUENCE_NUMBER,
   x_rul_sequence_number=>X_RUL_SEQUENCE_NUMBER,
   x_rule_text=>X_RULE_TEXT,
   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: 427

  insert into IGS_RU_NAMED_RULE (
    RUL_SEQUENCE_NUMBER,
    RUD_SEQUENCE_NUMBER,
    MESSAGE_RULE,
    RUG_SEQUENCE_NUMBER,
    RULE_TEXT,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    NEW_REFERENCES.RUL_SEQUENCE_NUMBER,
    NEW_REFERENCES.RUD_SEQUENCE_NUMBER,
    NEW_REFERENCES.MESSAGE_RULE,
    NEW_REFERENCES.RUG_SEQUENCE_NUMBER,
    NEW_REFERENCES.RULE_TEXT,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );
Line: 460

    p_action => 'INSERT',
    x_rowid => X_ROWID);
Line: 463

end INSERT_ROW;
Line: 473

  cursor c1 is select
      RUD_SEQUENCE_NUMBER,
      MESSAGE_RULE,
      RUG_SEQUENCE_NUMBER,
      RULE_TEXT
    from IGS_RU_NAMED_RULE
    where ROWID = X_ROWID for update nowait;
Line: 486

    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
Line: 514

procedure UPDATE_ROW (
  X_ROWID in VARCHAR2,
  X_RUL_SEQUENCE_NUMBER in NUMBER,
  X_RUD_SEQUENCE_NUMBER in NUMBER,
  X_MESSAGE_RULE in NUMBER,
  X_RUG_SEQUENCE_NUMBER in NUMBER,
  X_RULE_TEXT in VARCHAR2,
  X_MODE in VARCHAR2
  ) is
    X_LAST_UPDATE_DATE DATE;
Line: 524

    X_LAST_UPDATED_BY NUMBER;
Line: 525

    X_LAST_UPDATE_LOGIN NUMBER;
Line: 527

  X_LAST_UPDATE_DATE := SYSDATE;
Line: 529

    X_LAST_UPDATED_BY := 1;
Line: 530

    X_LAST_UPDATE_LOGIN := 0;
Line: 532

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 533

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;
Line: 536

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
Line: 537

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;
Line: 548

   p_action=>'UPDATE',
   x_rowid=>X_ROWID,
   x_message_rule=>X_MESSAGE_RULE,
   x_rud_sequence_number=>X_RUD_SEQUENCE_NUMBER,
   x_rug_sequence_number=>X_RUG_SEQUENCE_NUMBER,
   x_rul_sequence_number=>X_RUL_SEQUENCE_NUMBER,
   x_rule_text=>X_RULE_TEXT,
   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: 562

  update IGS_RU_NAMED_RULE set
    RUD_SEQUENCE_NUMBER = NEW_REFERENCES.RUD_SEQUENCE_NUMBER,
    MESSAGE_RULE = NEW_REFERENCES.MESSAGE_RULE,
    RUG_SEQUENCE_NUMBER = NEW_REFERENCES.RUG_SEQUENCE_NUMBER,
    RULE_TEXT = NEW_REFERENCES.RULE_TEXT,
    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: 578

    p_action => 'UPDATE',
    x_rowid => X_ROWID);
Line: 581

end UPDATE_ROW;
Line: 592

  cursor c1 is select rowid from IGS_RU_NAMED_RULE
     where RUL_SEQUENCE_NUMBER = X_RUL_SEQUENCE_NUMBER
  ;
Line: 600

    INSERT_ROW (
     X_ROWID,
     X_RUL_SEQUENCE_NUMBER,
     X_RUD_SEQUENCE_NUMBER,
     X_MESSAGE_RULE,
     X_RUG_SEQUENCE_NUMBER,
     X_RULE_TEXT,
     X_MODE);
Line: 611

  UPDATE_ROW (
   X_ROWID,
   X_RUL_SEQUENCE_NUMBER,
   X_RUD_SEQUENCE_NUMBER,
   X_MESSAGE_RULE,
   X_RUG_SEQUENCE_NUMBER,
   X_RULE_TEXT,
   X_MODE);
Line: 621

procedure DELETE_ROW (
  X_ROWID in VARCHAR2
) is
begin

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

  delete from IGS_RU_NAMED_RULE
  where ROWID = X_ROWID;
Line: 637

    p_action => 'DELETE',
    x_rowid => X_ROWID);
Line: 640

end DELETE_ROW;