DBA Data[Home] [Help]

APPS.IGS_PS_USEC_WLST_PRI_PKG SQL Statements

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

Line: 16

    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

  /*************************************************************
  Created By : venagara
  Date Created By : 2000/05/12
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

  (reverse chronological order - newest change first)
  ***************************************************************/

    CURSOR cur_old_ref_values IS
      SELECT   *
      FROM     IGS_PS_USEC_WLST_PRI
      WHERE    rowid = x_rowid;
Line: 45

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

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

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

    new_references.last_update_date := x_last_update_date;
Line: 67

    new_references.last_updated_by := x_last_updated_by;
Line: 68

    new_references.last_update_login := x_last_update_login;
Line: 136

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

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

      SELECT   rowid
      FROM     igs_ps_usec_wlst_pri
      WHERE    unit_sec_waitlist_priority_id = x_unit_sec_wlst_priority_id
      FOR UPDATE NOWAIT;
Line: 227

      SELECT   rowid
      FROM     igs_ps_usec_wlst_pri
      WHERE    priority_value = x_priority_value
      AND      uoo_id = x_uoo_id
      AND      ((l_rowid is null) or (rowid <> l_rowid)) ;
Line: 263

      SELECT   rowid
      FROM     igs_ps_usec_wlst_pri
      WHERE    uoo_id = x_uoo_id;
Line: 293

    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
  /*************************************************************
  Created By : venagara
  Date Created By : 2000/05/12
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

  (reverse chronological order - newest change first)
  ***************************************************************/

  BEGIN

    Set_Column_Values (
      p_action,
      x_rowid,
      x_unit_sec_wlst_priority_id,
      x_priority_number,
      x_priority_value,
      x_uoo_id,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );
Line: 324

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

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

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

    ELSIF (p_action = 'VALIDATE_INSERT') THEN
         -- Call all the procedures related to Before Insert.
      IF Get_PK_For_Validation (
                new_references.unit_sec_waitlist_priority_id)  THEN
               Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
Line: 356

    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      Check_Uniqueness;
Line: 359

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

    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to After Insert.
      Null;
Line: 387

    ELSIF (p_action = 'UPDATE') THEN
      -- Call all the procedures related to After Update.
      Null;
Line: 390

    ELSIF (p_action = 'DELETE') THEN
      -- Call all the procedures related to After Delete.
      Null;
Line: 398

 PROCEDURE INSERT_ROW (
      X_ROWID in out NOCOPY VARCHAR2,
       x_unit_sec_wlst_priority_id IN OUT NOCOPY NUMBER,
       x_PRIORITY_NUMBER IN NUMBER,
       x_PRIORITY_VALUE IN VARCHAR2,
       x_uoo_id IN NUMBER,
      X_MODE in VARCHAR2 default 'R'
  ) AS
  /*************************************************************
  Created By : venagara
  Date Created By : 2000/05/12
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

  (reverse chronological order - newest change first)
  ***************************************************************/

    CURSOR C IS
    SELECT ROWID
    FROM igs_ps_usec_wlst_pri
    WHERE unit_sec_waitlist_priority_id = x_unit_sec_wlst_priority_id;
Line: 422

     X_LAST_UPDATE_DATE DATE ;
Line: 423

     X_LAST_UPDATED_BY NUMBER ;
Line: 424

     X_LAST_UPDATE_LOGIN NUMBER ;
Line: 426

     X_LAST_UPDATE_DATE := SYSDATE;
Line: 428

        X_LAST_UPDATED_BY := 1;
Line: 429

        X_LAST_UPDATE_LOGIN := 0;
Line: 431

               X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 432

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

            X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
Line: 436

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

   SELECT
     igs_ps_usec_wlst_pri_s.nextval
   INTO
     x_unit_sec_wlst_priority_id
   FROM dual;
Line: 449

   before_dml(p_action=>'INSERT',
               x_rowid=>x_rowid,
               x_unit_sec_wlst_priority_id=>x_unit_sec_wlst_priority_id,
               x_priority_number=>x_priority_number,
               x_priority_value=>x_priority_value,
               x_uoo_id => x_uoo_id,
               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: 460

     INSERT INTO igs_ps_usec_wlst_pri (
                unit_sec_waitlist_priority_id
                ,priority_number
                ,priority_value
                ,uoo_id
                ,creation_date
                ,created_by
                ,last_update_date
                ,last_updated_by
                ,last_update_login
        ) VALUES  (
                new_references.unit_sec_waitlist_priority_id
                ,new_references.priority_number
                ,new_references.priority_value
                ,new_references.uoo_id
                ,x_last_update_date
                ,x_last_updated_by
                ,x_last_update_date
                ,x_last_updated_by
                ,x_last_update_login
        );
Line: 489

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

END insert_row;
Line: 510

   CURSOR c1 IS SELECT
      priority_number
,      priority_value
,      uoo_id
    FROM igs_ps_usec_wlst_pri
    WHERE ROWID = x_rowid
    FOR UPDATE NOWAIT;
Line: 522

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

 PROCEDURE update_row (
      X_ROWID in  VARCHAR2,
       x_unit_sec_wlst_priority_id IN NUMBER,
       x_PRIORITY_NUMBER IN NUMBER,
       x_PRIORITY_VALUE IN VARCHAR2,
       x_uoo_id IN NUMBER,
      X_MODE in VARCHAR2 default 'R'
  ) AS
  /*************************************************************
  Created By : venagara
  Date Created By : 2000/05/12
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

  (reverse chronological order - newest change first)
  ***************************************************************/

     X_LAST_UPDATE_DATE DATE ;
Line: 562

     X_LAST_UPDATED_BY NUMBER ;
Line: 563

     X_LAST_UPDATE_LOGIN NUMBER ;
Line: 565

     X_LAST_UPDATE_DATE := SYSDATE;
Line: 567

        X_LAST_UPDATED_BY := 1;
Line: 568

        X_LAST_UPDATE_LOGIN := 0;
Line: 570

               X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 571

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

            X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
Line: 575

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

                p_action=>'UPDATE',
                x_rowid=>X_ROWID,
               x_unit_sec_wlst_priority_id=>x_unit_sec_wlst_priority_id,
               x_priority_number=>X_PRIORITY_NUMBER,
               x_priority_value=>X_PRIORITY_VALUE,
               x_uoo_id => x_uoo_id,
               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: 595

   UPDATE IGS_PS_USEC_WLST_PRI set
      uoo_id = new_references.uoo_id,
      priority_number =  new_references.priority_number,
      priority_value =  new_references.priority_value,
        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: 608

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

END update_row;
Line: 632

    CURSOR c1 is select ROWID from IGS_PS_USEC_WLST_PRI
             where     UNIT_SEC_WAITLIST_PRIORITY_ID= x_unit_sec_wlst_priority_id
;
Line: 640

    insert_row (
      X_ROWID,
       x_unit_sec_wlst_priority_id,
       X_PRIORITY_NUMBER,
       X_PRIORITY_VALUE,
       x_uoo_id,
       X_MODE );
Line: 650

update_row (
      X_ROWID,
       x_unit_sec_wlst_priority_id,
       X_PRIORITY_NUMBER,
       X_PRIORITY_VALUE,
       x_uoo_id,
      X_MODE );
Line: 659

PROCEDURE delete_row (
  X_ROWID in VARCHAR2
) AS
  /*************************************************************
  Created By : venagara
  Date Created By : 2000/05/12
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

  (reverse chronological order - newest change first)
  ***************************************************************/

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

 DELETE FROM
  igs_ps_usec_wlst_pri
 WHERE ROWID = x_rowid;
Line: 685

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

end delete_row;