DBA Data[Home] [Help]

APPS.OKL_PAL_PVT SQL Statements

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

Line: 30

      SELECT adj_mat_version_id
            ,object_version_number
            ,version_number
            ,adj_mat_id
            ,sts_code
            ,effective_from_date
            ,effective_to_date
            ,attribute_category
            ,attribute1
            ,attribute2
            ,attribute3
            ,attribute4
            ,attribute5
            ,attribute6
            ,attribute7
            ,attribute8
            ,attribute9
            ,attribute10
            ,attribute11
            ,attribute12
            ,attribute13
            ,attribute14
            ,attribute15
            ,created_by
            ,creation_date
            ,last_updated_by
            ,last_update_date
            ,last_update_login
      FROM   okl_fe_adj_mat_versions
      WHERE  okl_fe_adj_mat_versions.adj_mat_version_id = p_id;
Line: 94

                         ,l_pal_rec.last_updated_by
                         ,l_pal_rec.last_update_date
                         ,l_pal_rec.last_update_login ;
Line: 215

    IF (l_pal_rec.last_updated_by = okl_api.g_miss_num) THEN
      l_pal_rec.last_updated_by := NULL;
Line: 219

    IF (l_pal_rec.last_update_date = okl_api.g_miss_date) THEN
      l_pal_rec.last_update_date := NULL;
Line: 223

    IF (l_pal_rec.last_update_login = okl_api.g_miss_num) THEN
      l_pal_rec.last_update_login := NULL;
Line: 594

      SELECT        object_version_number
      FROM          okl_fe_adj_mat_versions
      WHERE         adj_mat_version_id = p_def_pal_rec.adj_mat_version_id
                AND object_version_number = p_def_pal_rec.object_version_number
      FOR UPDATE OF object_version_number NOWAIT;
Line: 601

      SELECT object_version_number
      FROM   okl_fe_adj_mat_versions
      WHERE  adj_mat_version_id = p_def_pal_rec.adj_mat_version_id;
Line: 637

                         ,g_form_record_deleted);
Line: 649

                         ,g_record_logically_deleted);
Line: 730

  PROCEDURE insert_row(p_api_version   IN            NUMBER
                      ,p_init_msg_list IN            VARCHAR2    DEFAULT okl_api.g_false
                      ,x_return_status    OUT NOCOPY VARCHAR2
                      ,x_msg_count        OUT NOCOPY NUMBER
                      ,x_msg_data         OUT NOCOPY VARCHAR2
                      ,p_pal_rec       IN            okl_pal_rec
                      ,x_pal_rec          OUT NOCOPY okl_pal_rec) IS
    l_api_version        CONSTANT NUMBER       := 1;
Line: 738

    l_api_name           CONSTANT VARCHAR2(30) := 'insert_row';
Line: 750

      l_pal_rec.last_update_date := SYSDATE;
Line: 751

      l_pal_rec.last_updated_by := fnd_global.user_id;
Line: 752

      l_pal_rec.last_update_login := fnd_global.login_id;
Line: 812

    INSERT INTO okl_fe_adj_mat_versions
               (adj_mat_version_id
               ,object_version_number
               ,version_number
               ,adj_mat_id
               ,sts_code
               ,effective_from_date
               ,effective_to_date
               ,attribute_category
               ,attribute1
               ,attribute2
               ,attribute3
               ,attribute4
               ,attribute5
               ,attribute6
               ,attribute7
               ,attribute8
               ,attribute9
               ,attribute10
               ,attribute11
               ,attribute12
               ,attribute13
               ,attribute14
               ,attribute15
               ,created_by
               ,creation_date
               ,last_updated_by
               ,last_update_date
               ,last_update_login)
    VALUES     (l_def_pal_rec.adj_mat_version_id
               ,l_def_pal_rec.object_version_number
               ,l_def_pal_rec.version_number
               ,l_def_pal_rec.adj_mat_id
               ,l_def_pal_rec.sts_code
               ,l_def_pal_rec.effective_from_date
               ,l_def_pal_rec.effective_to_date
               ,l_def_pal_rec.attribute_category
               ,l_def_pal_rec.attribute1
               ,l_def_pal_rec.attribute2
               ,l_def_pal_rec.attribute3
               ,l_def_pal_rec.attribute4
               ,l_def_pal_rec.attribute5
               ,l_def_pal_rec.attribute6
               ,l_def_pal_rec.attribute7
               ,l_def_pal_rec.attribute8
               ,l_def_pal_rec.attribute9
               ,l_def_pal_rec.attribute10
               ,l_def_pal_rec.attribute11
               ,l_def_pal_rec.attribute12
               ,l_def_pal_rec.attribute13
               ,l_def_pal_rec.attribute14
               ,l_def_pal_rec.attribute15
               ,l_def_pal_rec.created_by
               ,l_def_pal_rec.creation_date
               ,l_def_pal_rec.last_updated_by
               ,l_def_pal_rec.last_update_date
               ,l_def_pal_rec.last_update_login);
Line: 908

  END insert_row;
Line: 914

  PROCEDURE insert_row(p_api_version   IN            NUMBER
                      ,p_init_msg_list IN            VARCHAR2    DEFAULT okl_api.g_false
                      ,x_return_status    OUT NOCOPY VARCHAR2
                      ,x_msg_count        OUT NOCOPY NUMBER
                      ,x_msg_data         OUT NOCOPY VARCHAR2
                      ,p_pal_tbl       IN            okl_pal_tbl
                      ,x_pal_tbl          OUT NOCOPY okl_pal_tbl) IS
    l_api_version        CONSTANT NUMBER       := 1;
Line: 922

    l_api_name           CONSTANT VARCHAR2(30) := 'insert_row_tbl';
Line: 936

        insert_row(p_api_version   =>            p_api_version
                  ,p_init_msg_list =>            okl_api.g_false
                  ,x_return_status =>            x_return_status
                  ,x_msg_count     =>            x_msg_count
                  ,x_msg_data      =>            x_msg_data
                  ,p_pal_rec       =>            p_pal_tbl(i)
                  ,x_pal_rec       =>            x_pal_tbl(i));
Line: 981

  END insert_row;
Line: 990

  PROCEDURE update_row(p_api_version   IN            NUMBER
                      ,p_init_msg_list IN            VARCHAR2    DEFAULT okl_api.g_false
                      ,x_return_status    OUT NOCOPY VARCHAR2
                      ,x_msg_count        OUT NOCOPY NUMBER
                      ,x_msg_data         OUT NOCOPY VARCHAR2
                      ,p_pal_rec       IN            okl_pal_rec
                      ,x_pal_rec          OUT NOCOPY okl_pal_rec) IS
    l_api_version        CONSTANT NUMBER       := 1;
Line: 998

    l_api_name           CONSTANT VARCHAR2(30) := 'update_row';
Line: 1008

      l_pal_rec.last_update_date := SYSDATE;
Line: 1009

      l_pal_rec.last_updated_by := fnd_global.user_id;
Line: 1010

      l_pal_rec.last_update_login := fnd_global.login_id;
Line: 1132

      IF (x_pal_rec.last_updated_by IS NULL) THEN
        x_pal_rec.last_updated_by := l_pal_rec.last_updated_by;
Line: 1136

      IF (x_pal_rec.last_update_date IS NULL) THEN
        x_pal_rec.last_update_date := l_pal_rec.last_update_date;
Line: 1140

      IF (x_pal_rec.last_update_login IS NULL) THEN
        x_pal_rec.last_update_login := l_pal_rec.last_update_login;
Line: 1226

    UPDATE okl_fe_adj_mat_versions
    SET    adj_mat_version_id = l_def_pal_rec.adj_mat_version_id
          ,object_version_number = l_def_pal_rec.object_version_number + 1
          ,version_number = l_def_pal_rec.version_number
          ,adj_mat_id = l_def_pal_rec.adj_mat_id
          ,sts_code = l_def_pal_rec.sts_code
          ,effective_from_date = l_def_pal_rec.effective_from_date
          ,effective_to_date = l_def_pal_rec.effective_to_date
          ,attribute_category = l_def_pal_rec.attribute_category
          ,attribute1 = l_def_pal_rec.attribute1
          ,attribute2 = l_def_pal_rec.attribute2
          ,attribute3 = l_def_pal_rec.attribute3
          ,attribute4 = l_def_pal_rec.attribute4
          ,attribute5 = l_def_pal_rec.attribute5
          ,attribute6 = l_def_pal_rec.attribute6
          ,attribute7 = l_def_pal_rec.attribute7
          ,attribute8 = l_def_pal_rec.attribute8
          ,attribute9 = l_def_pal_rec.attribute9
          ,attribute10 = l_def_pal_rec.attribute10
          ,attribute11 = l_def_pal_rec.attribute11
          ,attribute12 = l_def_pal_rec.attribute12
          ,attribute13 = l_def_pal_rec.attribute13
          ,attribute14 = l_def_pal_rec.attribute14
          ,attribute15 = l_def_pal_rec.attribute15
          ,created_by = l_def_pal_rec.created_by
          ,creation_date = l_def_pal_rec.creation_date
          ,last_updated_by = l_def_pal_rec.last_updated_by
          ,last_update_date = l_def_pal_rec.last_update_date
          ,last_update_login = l_def_pal_rec.last_update_login
    WHERE  adj_mat_version_id = l_def_pal_rec.adj_mat_version_id;
Line: 1295

  END update_row;
Line: 1301

  PROCEDURE update_row(p_api_version   IN            NUMBER
                      ,p_init_msg_list IN            VARCHAR2    DEFAULT okl_api.g_false
                      ,x_return_status    OUT NOCOPY VARCHAR2
                      ,x_msg_count        OUT NOCOPY NUMBER
                      ,x_msg_data         OUT NOCOPY VARCHAR2
                      ,p_pal_tbl       IN            okl_pal_tbl
                      ,x_pal_tbl          OUT NOCOPY okl_pal_tbl) IS
    l_api_version        CONSTANT NUMBER       := 1;
Line: 1309

    l_api_name           CONSTANT VARCHAR2(30) := 'update_row_tbl';
Line: 1323

        update_row(p_api_version   =>            p_api_version
                  ,p_init_msg_list =>            okl_api.g_false
                  ,x_return_status =>            x_return_status
                  ,x_msg_count     =>            x_msg_count
                  ,x_msg_data      =>            x_msg_data
                  ,p_pal_rec       =>            p_pal_tbl(i)
                  ,x_pal_rec       =>            x_pal_tbl(i));
Line: 1368

  END update_row;
Line: 1374

  PROCEDURE delete_row(p_api_version   IN            NUMBER
                      ,p_init_msg_list IN            VARCHAR2    DEFAULT okl_api.g_false
                      ,x_return_status    OUT NOCOPY VARCHAR2
                      ,x_msg_count        OUT NOCOPY NUMBER
                      ,x_msg_data         OUT NOCOPY VARCHAR2
                      ,p_pal_rec       IN            okl_pal_rec) IS
    l_api_version        CONSTANT NUMBER       := 1;
Line: 1381

    l_api_name           CONSTANT VARCHAR2(30) := 'delete_row';
Line: 1401

    DELETE FROM okl_fe_adj_mat_versions
    WHERE       adj_mat_version_id = l_pal_rec.adj_mat_version_id;
Line: 1431

  END delete_row;
Line: 1437

  PROCEDURE delete_row(p_api_version   IN            NUMBER
                      ,p_init_msg_list IN            VARCHAR2    DEFAULT okl_api.g_false
                      ,x_return_status    OUT NOCOPY VARCHAR2
                      ,x_msg_count        OUT NOCOPY NUMBER
                      ,x_msg_data         OUT NOCOPY VARCHAR2
                      ,p_pal_tbl       IN            okl_pal_tbl) IS
    l_api_version        CONSTANT NUMBER       := 1;
Line: 1444

    l_api_name           CONSTANT VARCHAR2(30) := 'delete_row_tbl';
Line: 1458

        delete_row(p_api_version   =>            p_api_version
                  ,p_init_msg_list =>            okl_api.g_false
                  ,x_return_status =>            x_return_status
                  ,x_msg_count     =>            x_msg_count
                  ,x_msg_data      =>            x_msg_data
                  ,p_pal_rec       =>            p_pal_tbl(i));
Line: 1502

  END delete_row;