DBA Data[Home] [Help]

APPS.OKL_PAM_PVT SQL Statements

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

Line: 32

    DELETE FROM OKL_FE_ADJ_MAT_ALL_TL t
    WHERE       NOT EXISTS(SELECT NULL
                           FROM   OKL_FE_ADJ_MAT_ALL_B b
                           WHERE  b.adj_mat_id = t.adj_mat_id);
Line: 37

    UPDATE OKL_FE_ADJ_MAT_ALL_TL t
    SET(adj_mat_desc) = (SELECT
                                    -- LANGUAGE,

                                    -- B.LANGUAGE,

                                     b.adj_mat_desc
                              FROM   OKL_FE_ADJ_MAT_ALL_TL b
                              WHERE  b.adj_mat_id = t.adj_mat_id
                                 AND b.language = t.source_lang)
    WHERE  (t.adj_mat_id, t.language) IN(SELECT subt.adj_mat_id ,subt.language
           FROM   OKL_FE_ADJ_MAT_ALL_TL subb ,OKL_FE_ADJ_MAT_ALL_TL subt
           WHERE  subb.adj_mat_id = subt.adj_mat_id AND subb.language = subt.language AND (  -- SUBB.LANGUAGE <> SUBT.LANGUAGE OR
             subb.adj_mat_desc <> subt.adj_mat_desc OR (subb.language IS NOT NULL
       AND subt.language IS NULL)
            OR (subb.adj_mat_desc IS NULL AND subt.adj_mat_desc IS NOT NULL)));
Line: 54

    INSERT INTO OKL_FE_ADJ_MAT_ALL_TL
               (adj_mat_id
               ,language
               ,source_lang
               ,sfwt_flag
               ,adj_mat_desc)
                SELECT b.adj_mat_id
                      ,l.language_code
                      ,b.source_lang
                      ,b.sfwt_flag
                      ,b.adj_mat_desc
                FROM   OKL_FE_ADJ_MAT_ALL_TL b
                      ,fnd_languages l
                WHERE  l.installed_flag IN('I', 'B')
                   AND b.language = userenv('LANG')
                   AND NOT EXISTS(SELECT NULL
                                      FROM   OKL_FE_ADJ_MAT_ALL_TL t
                                      WHERE  t.adj_mat_id = b.adj_mat_id AND t.language = l.language_code);
Line: 84

      SELECT adj_mat_id
            ,adj_mat_name
            ,object_version_number
            ,org_id
            ,currency_code
            ,adj_mat_type_code
            ,orig_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_all_b
      WHERE  okl_fe_adj_mat_all_b.adj_mat_id = p_id;
Line: 154

                          ,l_pamb_rec.last_updated_by
                          ,l_pamb_rec.last_update_date
                          ,l_pamb_rec.last_update_login ;
Line: 179

      SELECT adj_mat_id
            ,adj_mat_desc
            ,language
            ,source_lang
            ,sfwt_flag
            ,created_by
            ,creation_date
            ,last_updated_by
            ,last_update_date
            ,last_update_login
      FROM   okl_fe_adj_mat_all_tl
      WHERE  okl_fe_adj_mat_all_tl.adj_mat_id = p_id
         AND okl_fe_adj_mat_all_tl.language = p_language;
Line: 209

                           ,l_pamtl_rec.last_updated_by
                           ,l_pamtl_rec.last_update_date
                           ,l_pamtl_rec.last_update_login ;
Line: 233

      SELECT adj_mat_id
            ,object_version_number
            ,org_id
            ,currency_code
            ,adj_mat_type_code
            ,orig_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
            ,adj_mat_name
            ,adj_mat_desc
      FROM   okl_fe_adj_mat_v
      WHERE  okl_fe_adj_mat_v.adj_mat_id = p_id;
Line: 303

                          ,l_pamv_rec.last_updated_by
                          ,l_pamv_rec.last_update_date
                          ,l_pamv_rec.last_update_login
                          ,l_pamv_rec.adj_mat_name
                          ,l_pamv_rec.adj_mat_desc ;
Line: 357

    p_to.last_updated_by := p_from.last_updated_by;
Line: 358

    p_to.last_update_date := p_from.last_update_date;
Line: 359

    p_to.last_update_login := p_from.last_update_login;
Line: 394

    p_to.last_updated_by := p_from.last_updated_by;
Line: 395

    p_to.last_update_date := p_from.last_update_date;
Line: 396

    p_to.last_update_login := p_from.last_update_login;
Line: 407

    p_to.last_updated_by := p_from.last_updated_by;
Line: 408

    p_to.last_update_date := p_from.last_update_date;
Line: 409

    p_to.last_update_login := p_from.last_update_login;
Line: 420

    p_to.last_updated_by := p_from.last_updated_by;
Line: 421

    p_to.last_update_date := p_from.last_update_date;
Line: 422

    p_to.last_update_login := p_from.last_update_login;
Line: 542

    IF (l_pamv_rec.last_updated_by = okl_api.g_miss_num) THEN
      l_pamv_rec.last_updated_by := NULL;
Line: 546

    IF (l_pamv_rec.last_update_date = okl_api.g_miss_date) THEN
      l_pamv_rec.last_update_date := NULL;
Line: 550

    IF (l_pamv_rec.last_update_login = okl_api.g_miss_num) THEN
      l_pamv_rec.last_update_login := NULL;
Line: 581

      SELECT        object_version_number
      FROM          okl_fe_adj_mat_all_b
      WHERE         adj_mat_id = p_pamb_rec.adj_mat_id
                AND object_version_number = p_pamb_rec.object_version_number
      FOR UPDATE OF object_version_number NOWAIT;
Line: 588

      SELECT object_version_number
      FROM   okl_fe_adj_mat_all_b
      WHERE  adj_mat_id = p_pamb_rec.adj_mat_id;
Line: 636

                         ,g_form_record_deleted);
Line: 648

                         ,g_record_logically_deleted);
Line: 698

      SELECT     *
      FROM       okl_fe_adj_mat_all_tl
      WHERE      adj_mat_id = p_pamtl_rec.adj_mat_id
      FOR UPDATE NOWAIT;
Line: 739

                         ,g_form_record_deleted);
Line: 1213

      SELECT 'x'
      FROM   okl_fe_adj_mat_all_b
      WHERE  adj_mat_id = p_orig_adj_mat_id;
Line: 1511

  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_pamb_rec      IN            okl_pamb_rec
                      ,x_pamb_rec         OUT NOCOPY okl_pamb_rec) IS
    l_api_version        CONSTANT NUMBER       := 1;
Line: 1519

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

    INSERT INTO okl_fe_adj_mat_all_b
               (adj_mat_id
               ,adj_mat_name
               ,object_version_number
               ,org_id
               ,currency_code
               ,adj_mat_type_code
               ,orig_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_pamb_rec.adj_mat_id
               ,l_pamb_rec.adj_mat_name
               ,l_pamb_rec.object_version_number
               ,l_pamb_rec.org_id
               ,l_pamb_rec.currency_code
               ,l_pamb_rec.adj_mat_type_code
               ,l_pamb_rec.orig_adj_mat_id
               ,l_pamb_rec.sts_code
               ,l_pamb_rec.effective_from_date
               ,l_pamb_rec.effective_to_date
               ,l_pamb_rec.attribute_category
               ,l_pamb_rec.attribute1
               ,l_pamb_rec.attribute2
               ,l_pamb_rec.attribute3
               ,l_pamb_rec.attribute4
               ,l_pamb_rec.attribute5
               ,l_pamb_rec.attribute6
               ,l_pamb_rec.attribute7
               ,l_pamb_rec.attribute8
               ,l_pamb_rec.attribute9
               ,l_pamb_rec.attribute10
               ,l_pamb_rec.attribute11
               ,l_pamb_rec.attribute12
               ,l_pamb_rec.attribute13
               ,l_pamb_rec.attribute14
               ,l_pamb_rec.attribute15
               ,l_pamb_rec.created_by
               ,l_pamb_rec.creation_date
               ,l_pamb_rec.last_updated_by
               ,l_pamb_rec.last_update_date
               ,l_pamb_rec.last_update_login);
Line: 1654

  END insert_row;
Line: 1660

  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_pamtl_rec     IN            okl_pamtl_rec
                      ,x_pamtl_rec        OUT NOCOPY okl_pamtl_rec) IS
    l_api_version        CONSTANT NUMBER        := 1;
Line: 1668

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

      SELECT *
      FROM   fnd_languages
      WHERE  installed_flag IN('I', 'B');
Line: 1718

      INSERT INTO okl_fe_adj_mat_all_tl
                 (adj_mat_id
                 ,adj_mat_desc
                 ,language
                 ,source_lang
                 ,sfwt_flag
                 ,created_by
                 ,creation_date
                 ,last_updated_by
                 ,last_update_date
                 ,last_update_login)
      VALUES     (l_pamtl_rec.adj_mat_id
                 ,l_pamtl_rec.adj_mat_desc
                 ,l_pamtl_rec.language
                 ,l_pamtl_rec.source_lang
                 ,l_pamtl_rec.sfwt_flag
                 ,l_pamtl_rec.created_by
                 ,l_pamtl_rec.creation_date
                 ,l_pamtl_rec.last_updated_by
                 ,l_pamtl_rec.last_update_date
                 ,l_pamtl_rec.last_update_login);
Line: 1774

  END insert_row;
Line: 1780

  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_pamv_rec      IN            okl_pamv_rec
                      ,x_pamv_rec         OUT NOCOPY okl_pamv_rec) IS
    l_api_version        CONSTANT NUMBER        := 1;
Line: 1788

    l_api_name           CONSTANT VARCHAR2(30)  := 'v_insert_row';
Line: 1803

      l_pamv_rec.last_update_date := SYSDATE;
Line: 1804

      l_pamv_rec.last_updated_by := fnd_global.user_id;
Line: 1805

      l_pamv_rec.last_update_login := fnd_global.login_id;
Line: 1869

    insert_row(p_api_version
              ,p_init_msg_list
              ,x_return_status
              ,x_msg_count
              ,x_msg_data
              ,l_pamb_rec
              ,lx_pamb_rec);
Line: 1884

    insert_row(p_api_version
              ,p_init_msg_list
              ,x_return_status
              ,x_msg_count
              ,x_msg_data
              ,l_pamtl_rec
              ,lx_pamtl_rec);
Line: 1932

  END insert_row;
Line: 1938

  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_pamv_tbl      IN            okl_pamv_tbl
                      ,x_pamv_tbl         OUT NOCOPY okl_pamv_tbl) IS
    l_api_version        CONSTANT NUMBER       := 1;
Line: 1946

    l_api_name           CONSTANT VARCHAR2(30) := 'v_insert_row';
Line: 1960

        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_pamv_rec      =>            p_pamv_tbl(i)
                  ,x_pamv_rec      =>            x_pamv_tbl(i));
Line: 2005

  END insert_row;
Line: 2011

  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_pamb_rec      IN            okl_pamb_rec
                      ,x_pamb_rec         OUT NOCOPY okl_pamb_rec) IS
    l_api_version        CONSTANT NUMBER       := 1;
Line: 2019

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

    UPDATE okl_fe_adj_mat_all_b
    SET    adj_mat_id = l_def_pamb_rec.adj_mat_id
          ,adj_mat_name = l_def_pamb_rec.adj_mat_name
          ,object_version_number = l_def_pamb_rec.object_version_number + 1
          ,org_id = l_def_pamb_rec.org_id
          ,currency_code = l_def_pamb_rec.currency_code
          ,adj_mat_type_code = l_def_pamb_rec.adj_mat_type_code
          ,orig_adj_mat_id = l_def_pamb_rec.orig_adj_mat_id
          ,sts_code = l_def_pamb_rec.sts_code
          ,effective_from_date = l_def_pamb_rec.effective_from_date
          ,effective_to_date = l_def_pamb_rec.effective_to_date
          ,attribute_category = l_def_pamb_rec.attribute_category
          ,attribute1 = l_def_pamb_rec.attribute1
          ,attribute2 = l_def_pamb_rec.attribute2
          ,attribute3 = l_def_pamb_rec.attribute3
          ,attribute4 = l_def_pamb_rec.attribute4
          ,attribute5 = l_def_pamb_rec.attribute5
          ,attribute6 = l_def_pamb_rec.attribute6
          ,attribute7 = l_def_pamb_rec.attribute7
          ,attribute8 = l_def_pamb_rec.attribute8
          ,attribute9 = l_def_pamb_rec.attribute9
          ,attribute10 = l_def_pamb_rec.attribute10
          ,attribute11 = l_def_pamb_rec.attribute11
          ,attribute12 = l_def_pamb_rec.attribute12
          ,attribute13 = l_def_pamb_rec.attribute13
          ,attribute14 = l_def_pamb_rec.attribute14
          ,attribute15 = l_def_pamb_rec.attribute15
          ,created_by = l_def_pamb_rec.created_by
          ,creation_date = l_def_pamb_rec.creation_date
          ,last_updated_by = l_def_pamb_rec.last_updated_by
          ,last_update_date = l_def_pamb_rec.last_update_date
          ,last_update_login = l_def_pamb_rec.last_update_login
    WHERE  adj_mat_id = l_def_pamb_rec.adj_mat_id;
Line: 2126

  END update_row;
Line: 2132

  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_pamtl_rec     IN            okl_pamtl_rec
                      ,x_pamtl_rec        OUT NOCOPY okl_pamtl_rec) IS
    l_api_version        CONSTANT NUMBER        := 1;
Line: 2140

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

    UPDATE okl_fe_adj_mat_all_tl
    SET    adj_mat_id = l_def_pamtl_rec.adj_mat_id
          ,adj_mat_desc = l_def_pamtl_rec.adj_mat_desc
          ,language = l_def_pamtl_rec.language
          ,source_lang = l_def_pamtl_rec.source_lang
          ,sfwt_flag = l_def_pamtl_rec.sfwt_flag
          ,created_by = l_def_pamtl_rec.created_by
          ,creation_date = l_def_pamtl_rec.creation_date
          ,last_updated_by = l_def_pamtl_rec.last_updated_by
          ,last_update_date = l_def_pamtl_rec.last_update_date
          ,last_update_login = l_def_pamtl_rec.last_update_login
    WHERE  adj_mat_id = l_def_pamtl_rec.adj_mat_id
       AND language = l_def_pamtl_rec.language;
Line: 2198

    UPDATE okl_fe_adj_mat_all_tl
    SET    sfwt_flag = 'Y'
    WHERE  adj_mat_id = l_def_pamtl_rec.adj_mat_id
       AND source_lang <> USERENV('LANG');
Line: 2235

  END update_row;
Line: 2241

  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_pamv_rec      IN            okl_pamv_rec
                      ,x_pamv_rec         OUT NOCOPY okl_pamv_rec) IS
    l_api_version        CONSTANT NUMBER        := 1;
Line: 2249

    l_api_name           CONSTANT VARCHAR2(30)  := 'v_insert_row';
Line: 2263

      l_pamv_rec.last_update_date := SYSDATE;
Line: 2264

      l_pamv_rec.last_updated_by := fnd_global.user_id;
Line: 2265

      l_pamv_rec.last_update_login := fnd_global.login_id;
Line: 2395

      IF (x_pamv_rec.last_updated_by IS NULL) THEN
        x_pamv_rec.last_updated_by := l_pamv_rec.last_updated_by;
Line: 2399

      IF (x_pamv_rec.last_update_date IS NULL) THEN
        x_pamv_rec.last_update_date := l_pamv_rec.last_update_date;
Line: 2403

      IF (x_pamv_rec.last_update_login IS NULL) THEN
        x_pamv_rec.last_update_login := l_pamv_rec.last_update_login;
Line: 2500

    update_row(p_api_version
              ,p_init_msg_list
              ,x_return_status
              ,x_msg_count
              ,x_msg_data
              ,l_pamb_rec
              ,lx_pamb_rec);
Line: 2515

    update_row(p_api_version
              ,p_init_msg_list
              ,x_return_status
              ,x_msg_count
              ,x_msg_data
              ,l_pamtl_rec
              ,lx_pamtl_rec);
Line: 2563

  END update_row;
Line: 2569

  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_pamv_tbl      IN            okl_pamv_tbl
                      ,x_pamv_tbl         OUT NOCOPY okl_pamv_tbl) IS
    l_api_version        CONSTANT NUMBER       := 1;
Line: 2577

    l_api_name           CONSTANT VARCHAR2(30) := 'v_update_row';
Line: 2591

        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_pamv_rec      =>            p_pamv_tbl(i)
                  ,x_pamv_rec      =>            x_pamv_tbl(i));
Line: 2636

  END update_row;
Line: 2642

  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_pamb_rec      IN            okl_pamb_rec) IS
    l_api_version        CONSTANT NUMBER       := 1;
Line: 2649

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

    DELETE FROM okl_fe_adj_mat_all_b
    WHERE       adj_mat_id = l_pamb_rec.adj_mat_id;
Line: 2699

  END delete_row;
Line: 2705

  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_pamtl_rec     IN            okl_pamtl_rec) IS
    l_api_version        CONSTANT NUMBER        := 1;
Line: 2712

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

    DELETE FROM okl_fe_adj_mat_all_tl
    WHERE       adj_mat_id = l_pamtl_rec.adj_mat_id;
Line: 2784

  END delete_row;
Line: 2790

  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_pamv_rec      IN            okl_pamv_rec) IS
    l_api_version        CONSTANT NUMBER        := 1;
Line: 2797

    l_api_name           CONSTANT VARCHAR2(30)  := 'v_delete_row';
Line: 2821

    delete_row(p_api_version
              ,p_init_msg_list
              ,x_return_status
              ,x_msg_count
              ,x_msg_data
              ,l_pamb_rec);
Line: 2833

    delete_row(p_api_version
              ,p_init_msg_list
              ,x_return_status
              ,x_msg_count
              ,x_msg_data
              ,l_pamtl_rec);
Line: 2874

  END delete_row;
Line: 2880

  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_pamv_tbl      IN            okl_pamv_tbl) IS
    l_api_version        CONSTANT NUMBER       := 1;
Line: 2887

    l_api_name           CONSTANT VARCHAR2(30) := 'v_delete_row';
Line: 2901

        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_pamv_rec      =>            p_pamv_tbl(i));
Line: 2945

  END delete_row;