APPS.JAI_PA_SETUP_CTX_PKG SQL Statements

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

Line: 29

        x_last_update_date           VARCHAR2,
        x_force_edits                VARCHAR2 )   IS
    v_creation_date date;

Line: 34

    vf_ludate   DATE := to_date(x_last_update_date, 'DD-MM-YYYY HH:MI:SS');

Line: 51

    select creation_date, last_update_date
    from   JAI_PA_SETUP_CONTEXTS
    where context_id = x_context_id ;

Line: 56

      /* Check if the row exists in the database. If it does, retrieves the creation date for update_row. */
       OPEN cur_creation_date ;

Line: 64

     /* Removed the check for userid and added check using last_update_date
  for bug 4967445 */

       /* Update only if force_edits is 'Y' or if vf_ludate > vd_ludate */
   if ( vf_ludate > vd_ludate or X_Force_Edits = 'Y' ) then
         -- update row if present
       jai_pa_setup_ctx_pkg.Update_Row(
          X_Rowid                => v_rowid       ,
    x_context_id     => x_context_id              ,
    x_context    => x_context           ,
    x_attribute1_usage   => x_attribute1_usage          ,
    x_attribute2_usage   => x_attribute2_usage          ,
    x_attribute3_usage   => x_attribute3_usage          ,
    x_attribute4_usage   => x_attribute4_usage          ,
    x_attribute5_usage   => x_attribute5_usage          ,
    x_setup_value1_usage   => x_setup_value1_usage        ,
    x_setup_value2_usage   => x_setup_value2_usage        ,
    x_setup_value3_usage   => x_setup_value3_usage        ,
    x_setup_value4_usage   => x_setup_value4_usage        ,
    x_setup_value5_usage   => x_setup_value5_usage        ,
          x_creation_date        => v_creation_date     ,
          X_last_update_date     => vf_ludate       ,
          X_last_updated_by      => v_user_id       ,
          X_last_update_login    => 0);

Line: 91

         jai_pa_setup_ctx_pkg.Insert_Row(
        X_Rowid                => v_rowid,
  X_context_id     => x_context_id       ,
  X_context    => x_context     ,
  X_attribute1_usage   => x_attribute1_usage    ,
  X_attribute2_usage   => x_attribute2_usage    ,
  X_attribute3_usage   => x_attribute3_usage    ,
  X_attribute4_usage   => x_attribute4_usage    ,
  X_attribute5_usage   => x_attribute5_usage    ,
  X_setup_value1_usage   => x_setup_value1_usage    ,
  X_setup_value2_usage   => x_setup_value2_usage    ,
  X_setup_value3_usage   => x_setup_value3_usage    ,
  X_setup_value4_usage   => x_setup_value4_usage    ,
  X_setup_value5_usage   => x_setup_value5_usage    ,
        X_last_update_date     => vf_ludate,
        X_last_updated_by      => v_user_id,
        X_creation_date        => sysdate,
        X_created_by           => v_user_id,
        X_last_update_login    => 0) ;

Line: 118

 PROCEDURE Insert_Row(
                     X_Rowid              IN OUT NOCOPY ROWID,
         x_context_id   NUMBER       ,
         x_context      VARCHAR2,
               x_attribute1_usage   VARCHAR2,
         x_attribute2_usage   VARCHAR2,
         x_attribute3_usage   VARCHAR2,
         x_attribute4_usage   VARCHAR2,
         x_attribute5_usage   VARCHAR2,
         x_setup_value1_usage VARCHAR2,
         x_setup_value2_usage VARCHAR2,
         x_setup_value3_usage VARCHAR2,
         x_setup_value4_usage VARCHAR2,
         x_setup_value5_usage VARCHAR2,
                     X_last_update_date   DATE,
                     X_last_updated_by    NUMBER,
                     X_creation_date    DATE ,
                     X_created_by   NUMBER,
                     X_last_update_login  NUMBER) IS

  BEGIN

    INSERT INTO JAI_PA_SETUP_CONTEXTS(
      context_id    ,
      context     ,
            attribute1_usage    ,
      attribute2_usage    ,
      attribute3_usage    ,
      attribute4_usage    ,
      attribute5_usage    ,
      setup_value1_usage  ,
      setup_value2_usage  ,
      setup_value3_usage  ,
      setup_value4_usage  ,
      setup_value5_usage  ,
                  creation_date        ,
                  created_by           ,
                  last_update_date     ,
                  last_updated_by      ,
                  last_update_login
                )
    SELECT
      X_CONTEXT_ID    ,
      x_context   ,
      x_attribute1_usage  ,
      x_attribute2_usage  ,
      x_attribute3_usage  ,
      x_attribute4_usage  ,
      x_attribute5_usage  ,
      x_setup_value1_usage  ,
      x_setup_value2_usage  ,
      x_setup_value3_usage  ,
      x_setup_value4_usage  ,
      x_setup_value5_usage  ,
                  X_creation_date       ,
                        X_created_by          ,
             X_last_update_date    ,
             X_last_updated_by     ,
             X_last_update_login
    FROM  DUAL ;

Line: 179

  END Insert_Row;

Line: 181

PROCEDURE Update_Row(X_Rowid                   IN OUT NOCOPY ROWID,
                    x_context_id    NUMBER       ,
      x_context   VARCHAR2,
      x_attribute1_usage  VARCHAR2,
      x_attribute2_usage  VARCHAR2,
      x_attribute3_usage  VARCHAR2,
      x_attribute4_usage  VARCHAR2,
      x_attribute5_usage  VARCHAR2,
      x_setup_value1_usage  VARCHAR2,
      x_setup_value2_usage  VARCHAR2,
      x_setup_value3_usage  VARCHAR2,
      x_setup_value4_usage  VARCHAR2,
      x_setup_value5_usage  VARCHAR2,
                     x_creation_date           DATE,
                     X_last_update_date        DATE,
                     X_last_updated_by         NUMBER,
                     X_last_update_login       NUMBER)
 IS
  BEGIN
    UPDATE JAI_PA_SETUP_CONTEXTS
    SET
        CONTEXT           = x_context           ,
        ATTRIBUTE1_USAGE  = x_attribute1_usage          ,
  ATTRIBUTE2_USAGE  = x_attribute2_usage  ,
  ATTRIBUTE3_USAGE  = x_attribute3_usage  ,
  ATTRIBUTE4_USAGE  = x_attribute4_usage  ,
  ATTRIBUTE5_USAGE  = x_attribute5_usage  ,
  SETUP_VALUE1_USAGE  = x_setup_value1_usage,
  SETUP_VALUE2_USAGE  = x_setup_value2_usage,
  SETUP_VALUE3_USAGE  = x_setup_value3_usage,
  SETUP_VALUE4_USAGE  = x_setup_value4_usage,
  SETUP_VALUE5_USAGE  = x_setup_value5_usage,
        creation_date         = x_creation_date       ,
        last_update_date      = x_last_update_date    ,
        last_updated_by       = x_last_updated_by     ,
        last_update_login     = x_last_update_login
    WHERE
    context_id = x_context_id;

Line: 224

  END Update_Row;