DBA Data[Home] [Help]

APPS.OKL_PROCESS_TMPT_SET_PVT SQL Statements

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

Line: 56

  SELECT start_date,
         end_date
  FROM OKL_AE_TMPT_SETS_V
  WHERE id = v_aes_id;
Line: 121

 SELECT start_date,
        end_date
 FROM  OKL_AE_TEMPLATES
 WHERE NAME = v_name
 AND   aes_id = v_aes_id;
Line: 198

 SELECT start_date,
        end_date
 FROM  OKL_AE_TEMPLATES
 WHERE nvl(sty_id,OKL_API.G_MISS_NUM)
                     = nvl(p_avlv_rec.sty_id,OKL_API.G_MISS_NUM) AND
       nvl(try_id,OKL_API.G_MISS_NUM)
                     = nvl(p_avlv_rec.try_id,OKL_API.G_MISS_NUM) AND
       nvl(aes_id,OKL_API.G_MISS_NUM)
                     = nvl(p_avlv_rec.aes_id,OKL_API.G_MISS_NUM) AND
       nvl(syt_code,OKL_API.G_MISS_CHAR)
                     = nvl(p_avlv_rec.syt_code,OKL_API.G_MISS_CHAR) AND
       -- Code Added by HKPATEL for Bug # 2943310
       nvl(inv_code,OKL_API.G_MISS_CHAR)
                     = nvl(p_avlv_rec.inv_code,OKL_API.G_MISS_CHAR) AND
       -- Added code ends here
       nvl(fac_code,OKL_API.G_MISS_CHAR)
                     = nvl(p_avlv_rec.fac_code,OKL_API.G_MISS_CHAR) AND
       nvl(memo_yn,OKL_API.G_MISS_CHAR)
                     = nvl(p_avlv_rec.memo_yn,OKL_API.G_MISS_CHAR) AND
       nvl(factoring_synd_flag,OKL_API.G_MISS_CHAR)
                     = nvl(p_avlv_rec.factoring_synd_flag,OKL_API.G_MISS_CHAR) ;
Line: 285

PROCEDURE UNIQUE_VALIDATION_UPDATE(p_avlv_rec     IN AVLV_REC_TYPE,
                                   x_valid_flag   OUT NOCOPY VARCHAR2)

IS

 CURSOR avl_csr IS
 SELECT start_date,
        end_date
 FROM  OKL_AE_TEMPLATES
 WHERE nvl(sty_id,OKL_API.G_MISS_NUM)
                     = nvl(p_avlv_rec.sty_id,OKL_API.G_MISS_NUM) AND
       nvl(try_id,OKL_API.G_MISS_NUM)
                     = nvl(p_avlv_rec.try_id,OKL_API.G_MISS_NUM) AND
       nvl(aes_id,OKL_API.G_MISS_NUM)
                     = nvl(p_avlv_rec.aes_id,OKL_API.G_MISS_NUM) AND
       nvl(syt_code,OKL_API.G_MISS_CHAR)
                     = nvl(p_avlv_rec.syt_code,OKL_API.G_MISS_CHAR) AND
       -- Code Added by HKPATEL for Bug # 2943310
       nvl(inv_code,OKL_API.G_MISS_CHAR)
                     = nvl(p_avlv_rec.inv_code,OKL_API.G_MISS_CHAR) AND
       -- Added code ends here
       nvl(fac_code,OKL_API.G_MISS_CHAR)
                     = nvl(p_avlv_rec.fac_code,OKL_API.G_MISS_CHAR) AND
       nvl(memo_yn,OKL_API.G_MISS_CHAR)
                     = nvl(p_avlv_rec.memo_yn,OKL_API.G_MISS_CHAR) AND
       nvl(factoring_synd_flag,OKL_API.G_MISS_CHAR)
                     = nvl(p_avlv_rec.factoring_synd_flag,OKL_API.G_MISS_CHAR) AND
       ID            <> p_avlv_rec.ID;
Line: 377

END UNIQUE_VALIDATION_UPDATE;
Line: 384

    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            TRY_ID,
            AES_ID,
            STY_ID,
            FMA_ID,
            SET_OF_BOOKS_ID,
            FAC_CODE,
            SYT_CODE,
            -- Added by HKPATEL for Bug# 2943310
            INV_CODE,
            -- Added code ends here
            POST_TO_GL,
            ADVANCE_ARREARS,
            MEMO_YN,
            PRIOR_YEAR_YN,
            NAME,
            DESCRIPTION,
            VERSION,
            FACTORING_SYND_FLAG,
            START_DATE,
            END_DATE,
            ACCRUAL_YN,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            ORG_ID,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM OKL_AE_TEMPLATES
     WHERE OKL_AE_TEMPLATES.id = p_id;
Line: 484

              l_avlv_rec.LAST_UPDATED_BY,
              l_avlv_rec.LAST_UPDATE_DATE,
              l_avlv_rec.LAST_UPDATE_LOGIN;
Line: 635

   IF (x_avlv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
        x_avlv_rec.last_updated_by := l_avlv_rec.last_updated_by;
Line: 638

   IF (x_avlv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
        x_avlv_rec.last_update_date := l_avlv_rec.last_update_date;
Line: 641

   IF (x_avlv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
        x_avlv_rec.last_update_login := l_avlv_rec.last_update_login;
Line: 654

    SELECT  ID,
            OBJECT_VERSION_NUMBER,
            AVL_ID,
            CRD_CODE,
            CODE_COMBINATION_ID,
            AE_LINE_TYPE,
            SEQUENCE_NUMBER,
            DESCRIPTION,
            PERCENTAGE,
            ACCOUNT_BUILDER_YN,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            ORG_ID,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM OKL_AE_TMPT_LNES
    WHERE OKL_AE_TMPT_LNES.id = p_id;
Line: 724

              l_atlv_rec.LAST_UPDATED_BY,
              l_atlv_rec.LAST_UPDATE_DATE,
             l_atlv_rec.LAST_UPDATE_LOGIN;
Line: 862

      IF (x_atlv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_atlv_rec.last_updated_by := l_atlv_rec.last_updated_by;
Line: 866

      IF (x_atlv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_atlv_rec.last_update_date := l_atlv_rec.last_update_date;
Line: 870

      IF (x_atlv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_atlv_rec.last_update_login := l_atlv_rec.last_update_login;
Line: 887

   SELECT nvl(max(version),0)
   FROM OKL_AE_TEMPLATES
   WHERE name = v_name;
Line: 892

   SELECT  SEQUENCE_NUMBER,
           CODE_COMBINATION_ID,
           AE_LINE_TYPE,
           CRD_CODE,
           OBJECT_VERSION_NUMBER,
           ACCOUNT_BUILDER_YN,
           DESCRIPTION,
           PERCENTAGE,
           ATTRIBUTE_CATEGORY,
           ATTRIBUTE1,
           ATTRIBUTE2,
           ATTRIBUTE3,
           ATTRIBUTE4,
           ATTRIBUTE5,
           ATTRIBUTE6,
           ATTRIBUTE7,
           ATTRIBUTE8,
           ATTRIBUTE9,
           ATTRIBUTE10,
           ATTRIBUTE11,
           ATTRIBUTE12,
           ATTRIBUTE13,
           ATTRIBUTE14,
           ATTRIBUTE15
    FROM OKL_AE_TMPT_LNES
    WHERE avl_id = v_avl_id;
Line: 1041

   SELECT nvl(max(version),0)
   FROM OKL_AE_TEMPLATES
   WHERE name = v_name;
Line: 1046

   SELECT AVL_ID
   FROM OKL_AE_TMPT_LNES
   WHERE ID = v_id;
Line: 1211

PROCEDURE update_tmpt_set(p_api_version                  IN  NUMBER
                         ,p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE
                         ,x_return_status                OUT NOCOPY VARCHAR2
                         ,x_msg_count                    OUT NOCOPY NUMBER
                         ,x_msg_data                     OUT NOCOPY VARCHAR2
                         ,p_aesv_rec                     IN  aesv_rec_type
                         ,p_avlv_tbl                     IN  avlv_tbl_type
                         ,p_atlv_tbl                     IN atlv_tbl_type
                         ,x_aesv_rec                     OUT NOCOPY aesv_rec_type
                         ,x_avlv_tbl                     OUT NOCOPY avlv_tbl_type
                         ,x_atlv_tbl                     OUT NOCOPY atlv_tbl_type )

IS

l_api_version   NUMBER := 1.0;
Line: 1242

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.update_tmpt_set ');
Line: 1245

OKL_TMPT_SET_PUB.update_tmpt_set(
                p_api_version     => l_api_version,
                p_init_msg_list   => p_init_msg_list,
                x_return_status   => x_return_Status,
                x_msg_count       => x_msg_count,
                x_msg_data        => x_msg_data,
                p_aesv_rec        => p_aesv_rec,
                p_avlv_tbl        => p_avlv_tbl,
                p_atlv_tbl        => p_atlv_tbl,
                x_aesv_rec        => x_aesv_rec,
                x_avlv_tbl        => x_avlv_tbl,
                x_atlv_tbl        => x_atlv_tbl);
Line: 1259

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.update_tmpt_set ');
Line: 1280

END update_tmpt_set;
Line: 1358

  SELECT ID
  FROM OKL_AE_TMPT_SETS_V
  WHERE name = v_name;
Line: 1493

PROCEDURE update_tmpt_set(p_api_version                  IN  NUMBER,
                          p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
                          x_return_status                OUT NOCOPY VARCHAR2,
                          x_msg_count                    OUT NOCOPY NUMBER,
                          x_msg_data                     OUT NOCOPY VARCHAR2,
                          p_aesv_tbl                     IN  aesv_tbl_type,
                          x_aesv_tbl                     OUT NOCOPY aesv_tbl_type)
IS

 l_api_version  NUMBER := 1.0;
Line: 1517

           update_tmpt_set(p_api_version     => l_api_version,
                           p_init_msg_list   => p_init_msg_list,
                           x_return_status   => l_return_Status,
                           x_msg_count       => x_msg_count,
                           x_msg_data        => x_msg_data,
                           p_aesv_rec        => p_aesv_tbl(i),
                           x_aesv_rec        => x_aesv_tbl(i) );
Line: 1542

END update_tmpt_set;
Line: 1546

PROCEDURE update_tmpt_set(p_api_version                  IN  NUMBER,
                          p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
                          x_return_status                OUT NOCOPY VARCHAR2,
                          x_msg_count                    OUT NOCOPY NUMBER,
                          x_msg_data                     OUT NOCOPY VARCHAR2,
                          p_aesv_rec                     IN  aesv_rec_type,
                          x_aesv_rec                     OUT NOCOPY aesv_rec_type)

IS

  l_api_version        NUMBER := 1.0;
Line: 1557

  l_api_name           VARCHAR2(30) := 'UPDATE_TMPT_SET';
Line: 1603

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.update_tmpt_set ');
Line: 1606

    OKL_TMPT_SET_PUB.update_tmpt_set(p_api_version     => l_api_version,
                                     p_init_msg_list   => p_init_msg_list,
                                     x_return_status   => x_return_Status,
                                     x_msg_count       => x_msg_count,
                                     x_msg_data        => x_msg_data,
                                     p_aesv_rec        => p_aesv_rec,
                                     x_aesv_rec        => x_aesv_rec);
Line: 1615

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.update_tmpt_set ');
Line: 1654

END update_tmpt_set;
Line: 1659

PROCEDURE delete_tmpt_set(
     p_api_version                  IN  NUMBER,
     p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
     x_return_status                OUT NOCOPY VARCHAR2,
     x_msg_count                    OUT NOCOPY NUMBER,
     x_msg_data                     OUT NOCOPY VARCHAR2,
     p_aesv_tbl                     IN  aesv_tbl_type)

IS

l_api_version NUMBER := 1.0;
Line: 1679

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.delete_tmpt_set ');
Line: 1682

  OKL_TMPT_SET_PUB.delete_tmpt_set(
        p_api_version     => l_api_version,
        p_init_msg_list   => p_init_msg_list,
        x_return_status   => x_return_Status,
        x_msg_count       => x_msg_count,
        x_msg_data        => x_msg_data,
        p_aesv_tbl        => p_aesv_tbl);
Line: 1691

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.delete_tmpt_set ');
Line: 1696

END delete_tmpt_set;
Line: 1699

PROCEDURE delete_tmpt_set(
     p_api_version                  IN  NUMBER,
     p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
     x_return_status                OUT NOCOPY VARCHAR2,
     x_msg_count                    OUT NOCOPY NUMBER,
     x_msg_data                     OUT NOCOPY VARCHAR2,
     p_aesv_rec                     IN aesv_rec_type)

IS

l_api_version NUMBER := 1.0;
Line: 1719

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.delete_tmpt_set ');
Line: 1722

  OKL_TMPT_SET_PUB.delete_tmpt_set(
                p_api_version     => l_api_version,
                p_init_msg_list   => p_init_msg_list,
                x_return_status   => x_return_Status,
                x_msg_count       => x_msg_count,
                x_msg_data        => x_msg_data,
                p_aesv_rec        => p_aesv_rec);
Line: 1731

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.delete_tmpt_set ');
Line: 1736

END delete_tmpt_set;
Line: 1760

  SELECT nvl(max(version),0)
  FROM OKL_AE_TEMPLATES
  WHERE NAME   = v_name AND
        AES_ID = v_aes_id ;
Line: 1935

PROCEDURE update_template(p_api_version                  IN  NUMBER,
                          p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
                          x_return_status                OUT NOCOPY VARCHAR2,
                          x_msg_count                    OUT NOCOPY NUMBER,
                          x_msg_data                     OUT NOCOPY VARCHAR2,
                          p_avlv_rec                     IN  avlv_rec_type,
                          x_avlv_rec                     OUT NOCOPY avlv_rec_type)

IS

 CURSOR avl_csr(v_id NUMBER) IS
   SELECT ID,
          STY_ID,
          TRY_ID,
          AES_ID ,
          FMA_ID,
          OBJECT_VERSION_NUMBER,
          NAME ,
          SYT_CODE,
          -- Added by HKPATEL for Bug# 2943310
          INV_CODE,
          -- Added code ends here
          FAC_CODE,
          ADVANCE_ARREARS,
          POST_TO_GL,
          VERSION,
          START_DATE,
          MEMO_YN ,
          PRIOR_YEAR_YN,
          DESCRIPTION,
          FACTORING_SYND_FLAG,
          END_DATE ,
          ACCRUAL_YN,
          ATTRIBUTE_CATEGORY,
          ATTRIBUTE1,
          ATTRIBUTE2,
          ATTRIBUTE3,
          ATTRIBUTE4,
          ATTRIBUTE5,
          ATTRIBUTE6,
          ATTRIBUTE7,
          ATTRIBUTE8,
          ATTRIBUTE9,
          ATTRIBUTE10,
          ATTRIBUTE11,
          ATTRIBUTE12,
          ATTRIBUTE13,
          ATTRIBUTE14,
          ATTRIBUTE15
    FROM OKL_AE_TEMPLATES
    WHERE ID = v_id;
Line: 1988

 SELECT ID
 FROM OKL_TRNS_ACC_DSTRS
 WHERE template_id = v_avl_id;
Line: 1994

 l_api_name             VARCHAR2(30) := 'UPDATE_TEMPLATE';
Line: 2022

   UNIQUE_VALIDATION_UPDATE(p_avlv_rec      => p_avlv_rec,
                            x_valid_flag    => l_valid_flag);
Line: 2117

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.update_template ');
Line: 2120

      OKL_TMPT_SET_PUB.update_template(p_api_version     => l_api_version,
                                       p_init_msg_list   => p_init_msg_list,
                                       x_return_status   => x_return_Status,
                                       x_msg_count       => x_msg_count,
                                       x_msg_data        => x_msg_data,
                                       p_avlv_rec        => p_avlv_rec,
                                       x_avlv_rec        => x_avlv_rec);
Line: 2129

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.update_template ');
Line: 2168

END update_template;
Line: 2173

 PROCEDURE update_template(
     p_api_version                  IN  NUMBER,
     p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
     x_return_status                OUT NOCOPY VARCHAR2,
     x_msg_count                    OUT NOCOPY NUMBER,
     x_msg_data                     OUT NOCOPY VARCHAR2,
     p_avlv_tbl                     IN  avlv_tbl_type,
     x_avlv_tbl                     OUT NOCOPY avlv_tbl_type)

 IS

  l_api_version         NUMBER := 1.0;
Line: 2192

     update_template(p_api_version     => l_api_version,
                     p_init_msg_list   => p_init_msg_list,
                     x_return_status   => x_return_Status,
                     x_msg_count       => x_msg_count,
                     x_msg_data        => x_msg_data,
                     p_avlv_rec        => p_avlv_tbl(i),
                     x_avlv_rec        => x_avlv_tbl(i));
Line: 2210

 END update_template;
Line: 2214

 PROCEDURE delete_template(
     p_api_version                  IN  NUMBER,
     p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
     x_return_status                OUT NOCOPY VARCHAR2,
     x_msg_count                    OUT NOCOPY NUMBER,
     x_msg_data                     OUT NOCOPY VARCHAR2,
     p_avlv_tbl                     IN  avlv_tbl_type)

  IS
     l_api_version NUMBER := 1.0;
Line: 2233

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.delete_template ');
Line: 2236

    OKL_TMPT_SET_PUB.delete_template(
                p_api_version     => l_api_version,
                p_init_msg_list   => p_init_msg_list,
                x_return_status   => x_return_Status,
                x_msg_count       => x_msg_count,
                x_msg_data        => x_msg_data,
                p_avlv_tbl        => p_avlv_tbl);
Line: 2245

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.delete_template ');
Line: 2250

 END delete_template;
Line: 2253

 PROCEDURE delete_template(
     p_api_version                  IN  NUMBER,
     p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
     x_return_status                OUT NOCOPY VARCHAR2,
     x_msg_count                    OUT NOCOPY NUMBER,
     x_msg_data                     OUT NOCOPY VARCHAR2,
     p_avlv_rec                     IN  avlv_rec_type)

 IS
  l_api_version NUMBER := 1.0;
Line: 2272

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.delete_template ');
Line: 2275

   OKL_TMPT_SET_PUB.delete_template(
                p_api_version     => l_api_version,
                p_init_msg_list   => p_init_msg_list,
                x_return_status   => x_return_Status,
                x_msg_count       => x_msg_count,
                x_msg_data        => x_msg_data,
                p_avlv_rec        => p_avlv_rec);
Line: 2284

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.delete_template ');
Line: 2289

END delete_template;
Line: 2495

PROCEDURE update_tmpt_lines(p_api_version                  IN  NUMBER,
                            p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
                            x_return_status                OUT NOCOPY VARCHAR2,
                            x_msg_count                    OUT NOCOPY NUMBER,
                            x_msg_data                     OUT NOCOPY VARCHAR2,
                            p_atlv_tbl                     IN  atlv_tbl_type,
                            x_atlv_tbl                     OUT NOCOPY atlv_tbl_type)

 IS
 l_api_version          NUMBER := 1.0;
Line: 2518

  SELECT ID ,
         SEQUENCE_NUMBER ,
         AVL_ID ,
         CODE_COMBINATION_ID ,
         AE_LINE_TYPE ,
         CRD_CODE ,
         ACCOUNT_BUILDER_YN ,
         DESCRIPTION,
         PERCENTAGE ,
         ATTRIBUTE_CATEGORY,
         ATTRIBUTE1,
         ATTRIBUTE2 ,
         ATTRIBUTE3 ,
         ATTRIBUTE4 ,
         ATTRIBUTE5 ,
         ATTRIBUTE6 ,
         ATTRIBUTE7 ,
         ATTRIBUTE8 ,
         ATTRIBUTE9 ,
         ATTRIBUTE10 ,
         ATTRIBUTE11 ,
         ATTRIBUTE12 ,
         ATTRIBUTE13 ,
         ATTRIBUTE14 ,
         ATTRIBUTE15
  FROM OKL_AE_TMPT_LNES
  WHERE ID = v_atl_id;
Line: 2547

  SELECT ID,
         start_date,
         end_date
  FROM OKL_AE_TEMPLATES
  WHERE ID = (SELECT avl_id FROM OKL_AE_TMPT_LNES
              WHERE ID = v_atl_id);
Line: 2559

  SELECT ID
  FROM OKL_TRNS_ACC_DSTRS
  WHERE template_id = v_avl_id;
Line: 2602

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.update_tmpt_lines ');
Line: 2605

     OKL_TMPT_SET_PUB.update_tmpt_lines(p_api_version     => l_api_version,
                                        p_init_msg_list   => p_init_msg_list,
                                        x_return_status   => x_return_Status,
                                        x_msg_count       => x_msg_count,
                                        x_msg_data        => x_msg_data,
                                        p_atlv_tbl        => p_atlv_tbl,
                                        x_atlv_tbl        => x_atlv_tbl);
Line: 2614

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.update_tmpt_lines ');
Line: 2632

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.update_tmpt_lines ');
Line: 2635

          OKL_TMPT_SET_PUB.update_tmpt_lines(p_api_version     => l_api_version,
                                             p_init_msg_list   => p_init_msg_list,
                                             x_return_status   => x_return_Status,
                                             x_msg_count       => x_msg_count,
                                             x_msg_data        => x_msg_data,
                                             p_atlv_tbl        => p_atlv_tbl,
                                             x_atlv_tbl        => x_atlv_tbl);
Line: 2644

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.update_tmpt_lines ');
Line: 2664

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.update_template ');
Line: 2667

              OKL_TMPT_SET_PUB.update_template(p_api_version     => l_api_version,
                                               p_init_msg_list   => p_init_msg_list,
                                               x_return_status   => x_return_Status,
                                               x_msg_count       => x_msg_count,
                                               x_msg_data        => x_msg_data,
                                               p_avlv_rec        => l_avlv_rec,
                                               x_avlv_rec        => x_avlv_rec);
Line: 2676

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.update_template ');
Line: 2690

END update_tmpt_lines;
Line: 2694

PROCEDURE update_tmpt_lines(p_api_version           IN  NUMBER,
                            p_init_msg_list         IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
                            x_return_status         OUT NOCOPY VARCHAR2,
                            x_msg_count             OUT NOCOPY NUMBER,
                            x_msg_data              OUT NOCOPY VARCHAR2,
                            p_atlv_rec              IN  atlv_rec_type,
                            x_atlv_rec              OUT NOCOPY atlv_rec_type)

  IS
     l_api_version      NUMBER := 1.0;
Line: 2704

     l_api_name    VARCHAR2(30) := 'UPDATE_TMPT_LINES';
Line: 2798

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.update_tmpt_lines ');
Line: 2801

     OKL_TMPT_SET_PUB.update_tmpt_lines(p_api_version     => l_api_version,
                                        p_init_msg_list   => p_init_msg_list,
                                        x_return_status   => x_return_Status,
                                        x_msg_count       => x_msg_count,
                                        x_msg_data        => x_msg_data,
                                        p_atlv_rec        => l_atlv_rec,
                                        x_atlv_rec        => x_atlv_rec);
Line: 2810

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.update_tmpt_lines ');
Line: 2852

END UPDATE_TMPT_LINES;
Line: 2856

PROCEDURE delete_tmpt_lines(p_api_version                  IN  NUMBER,
                            p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
                            x_return_status                OUT NOCOPY VARCHAR2,
                            x_msg_count                    OUT NOCOPY NUMBER,
                            x_msg_data                     OUT NOCOPY VARCHAR2,
                            p_atlv_tbl                     IN  atlv_tbl_type)

IS

  l_api_version NUMBER := 1.0;
Line: 2877

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.delete_tmpt_lines ');
Line: 2880

   OKL_TMPT_SET_PUB.delete_tmpt_lines(p_api_version     => l_api_version,
                                      p_init_msg_list   => p_init_msg_list,
                                      x_return_status   => x_return_Status,
                                      x_msg_count       => x_msg_count,
                                      x_msg_data        => x_msg_data,
                                      p_atlv_tbl        => p_atlv_tbl);
Line: 2888

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.delete_tmpt_lines ');
Line: 2893

END delete_tmpt_lines;
Line: 2898

PROCEDURE delete_tmpt_lines(p_api_version                  IN  NUMBER,
                            p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
                            x_return_status                OUT NOCOPY VARCHAR2,
                            x_msg_count                    OUT NOCOPY NUMBER,
                            x_msg_data                     OUT NOCOPY VARCHAR2,
                            p_atlv_rec                     IN  atlv_rec_type)

IS

l_api_version NUMBER := 1.0;
Line: 2917

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.delete_tmpt_lines ');
Line: 2920

  OKL_TMPT_SET_PUB.delete_tmpt_lines(p_api_version     => l_api_version,
                                     p_init_msg_list   => p_init_msg_list,
                                     x_return_status   => x_return_Status,
                                     x_msg_count       => x_msg_count,
                                     x_msg_data        => x_msg_data,
                                     p_atlv_rec        => p_atlv_rec);
Line: 2928

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTMSB.pls call OKL_TMPT_SET_PUB.delete_tmpt_lines ');
Line: 2933

END delete_tmpt_lines;
Line: 2975

select ACCOUNT_DERIVATION   from
okl_sys_acct_opts ;
Line: 2979

SELECT   id
        ,try_id
        ,sty_id
        ,fma_id
        ,fac_code
        ,syt_code
        -- Added by HKPATEL for bug 2943310
        ,inv_code
        -- Added code ends here
        ,post_to_gl
        ,advance_arrears
        ,memo_yn
        ,prior_year_yn
        ,name
        ,description
        ,version
        ,factoring_synd_flag
        ,start_date
        ,end_date
        ,accrual_yn
        ,attribute_category
        ,attribute1
        ,attribute2
        ,attribute3
        ,attribute4
        ,attribute5
        ,attribute6
        ,attribute7
        ,attribute8
        ,attribute9
        ,attribute10
        ,attribute11
        ,attribute12
        ,attribute13
        ,attribute14
        ,attribute15
FROM okl_ae_templates
WHERE aes_id = v_aes_id;
Line: 3020

SELECT  id
       ,sequence_number
       ,avl_id
       ,code_combination_id
       ,ae_line_type
       ,crd_code
       ,account_builder_yn
       ,description
       ,percentage
       ,attribute_category
       ,attribute1
       ,attribute2
       ,attribute3
       ,attribute4
       ,attribute5
       ,attribute6
       ,attribute7
       ,attribute8
       ,attribute9
       ,attribute10
       ,attribute11
       ,attribute12
       ,attribute13
       ,attribute14
       ,attribute15
FROM okl_ae_tmpt_lnes
WHERE avl_id = v_avl_id;
Line: 3135

            l_atlv_tbl_in.DELETE;
Line: 3246

 SELECT  code_combination_id,
         ae_line_type,
         crd_code,
         account_builder_yn,
         description,
         percentage,
         attribute_category,
         attribute1,
         attribute2,
         attribute3,
         attribute4,
         attribute5,
         attribute6,
         attribute7,
         attribute8,
         attribute9,
         attribute10,
         attribute11,
         attribute12,
         attribute13,
         attribute14,
         attribute15
  FROM OKL_AE_TMPT_LNES
  WHERE avl_id = p_source_tmpl_id;
Line: 3387

  SELECT '1'
  FROM OKL_ST_GEN_TMPT_SETS
  WHERE OKL_ST_GEN_TMPT_SETS.ID  = l_gts_id;