DBA Data[Home] [Help]

APPS.OKL_AVL_PVT SQL Statements

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

Line: 89

    SELECT '1'
    FROM OKL_STRM_TYPE_V
    WHERE ID = v_sty_id;
Line: 150

    SELECT '1'
    FROM OKL_TRX_TYPES_V
    WHERE ID = v_try_id;
Line: 212

    SELECT '1'
    FROM OKL_AE_TMPT_SETS_V
    WHERE ID = v_aes_id;
Line: 683

  SELECT start_date,
         end_date
  FROM 	 OKL_AE_TEMPLATES
  WHERE  try_id = p_avlv_rec.try_id
  AND 	 nvl(org_id,-99) = nvl(p_avlv_rec.org_id,-99)
  AND	 sty_id = p_avlv_rec.sty_id
  AND	 aes_id = p_avlv_rec.aes_id
  AND	 nvl(advance_arrears,'AA')  = nvl(p_avlv_rec.advance_arrears ,'AA')
  AND	 memo_yn = p_avlv_rec.memo_yn
  AND    prior_year_yn = p_avlv_rec.prior_year_yn
  AND    nvl(factoring_synd_flag,'N') = nvl(p_Avlv_rec.factoring_synd_flag,'N')
  AND    id <> p_avlv_rec.ID;
Line: 700

  SELECT '1'
  FROM OKL_AE_TEMPLATES
  WHERE name    = v_name
  AND   version = v_version
  AND aes_id = v_aes_id
  AND ID <> p_avlv_rec.ID;
Line: 783

  SELECT 	'1'
  FROM 	OKL_FORMULAE_V
  WHERE 	id = v_fma_id;
Line: 1034

    SELECT
            ID,
            NAME,
            SET_OF_BOOKS_ID,
            STY_ID,
            TRY_ID,
            AES_ID,
            SYT_CODE,
            FAC_CODE,
            FMA_ID,
            ADVANCE_ARREARS,
            POST_TO_GL,
            VERSION,
            START_DATE,
            OBJECT_VERSION_NUMBER,
            MEMO_YN,
            PRIOR_YEAR_YN,
            DESCRIPTION,
            FACTORING_SYND_FLAG,
            END_DATE,
            ACCRUAL_YN,
            ORG_ID,
            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,
 -- Added by HKPATEL for securitization changes
  	    INV_CODE
      FROM Okl_Ae_Templates
     WHERE okl_ae_templates.id  = p_id;
Line: 1127

              l_avl_rec.LAST_UPDATED_BY,
              l_avl_rec.LAST_UPDATE_DATE,
              l_avl_rec.LAST_UPDATE_LOGIN,
  -- Added by HKPATEL for securitization changes
  	      l_avl_rec.INV_CODE;
Line: 1152

    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            TRY_ID,
            AES_ID,
            STY_ID,
            FMA_ID,
            SET_OF_BOOKS_ID,
            FAC_CODE,
            SYT_CODE,
            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,
   -- Added by HKPATEL for securitization changes
   	    INV_CODE
      FROM OKL_AE_TEMPLATES
     WHERE OKL_AE_TEMPLATES.id = p_id;
Line: 1245

              l_avlv_rec.LAST_UPDATED_BY,
              l_avlv_rec.LAST_UPDATE_DATE,
              l_avlv_rec.LAST_UPDATE_LOGIN,
   -- Added by HKPATEL for securitization changes
   	      l_avlv_rec.INV_CODE;
Line: 1385

    IF (l_avlv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
      l_avlv_rec.last_updated_by := NULL;
Line: 1388

    IF (l_avlv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
      l_avlv_rec.last_update_date := NULL;
Line: 1391

    IF (l_avlv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
      l_avlv_rec.last_update_login := NULL;
Line: 1665

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

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

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

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

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

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

  PROCEDURE insert_row(
    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_avl_rec                      IN avl_rec_type,
    x_avl_rec                      OUT NOCOPY avl_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1888

    l_api_name                     CONSTANT VARCHAR2(30) := 'TEMPLATES_insert_row';
Line: 1928

     INSERT INTO OKL_AE_TEMPLATES(
         id,
         name,
         set_of_books_id,
         sty_id,
         try_id,
         aes_id,
         syt_code,
         fac_code,
         fma_id,
         advance_arrears,
         post_to_gl,
         version,
         start_date,
         object_version_number,
         memo_yn,
         prior_year_yn,
         description,
         factoring_synd_flag,
         end_date,
         accrual_yn,
         org_id,
         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,
   -- Added by HKPATEL for securitization changes
   	inv_code)
       VALUES (
         l_avl_rec.id,
         l_avl_rec.name,
         --l_avl_rec.set_of_books_id,
         null,
         l_avl_rec.sty_id,
         l_avl_rec.try_id,
         l_avl_rec.aes_id,
         l_avl_rec.syt_code,
         l_avl_rec.fac_code,
         l_avl_rec.fma_id,
         l_avl_rec.advance_arrears,
         --l_avl_rec.post_to_gl,
         null,
         --l_avl_rec.version,
         null,
         l_avl_rec.start_date,
         l_avl_rec.object_version_number,
         l_avl_rec.memo_yn,
         l_avl_rec.prior_year_yn,
         l_avl_rec.description,
         l_avl_rec.factoring_synd_flag,
         l_avl_rec.end_date,
         --l_avl_rec.accrual_yn,
         null,
         l_avl_rec.org_id,
         l_avl_rec.attribute_category,
         l_avl_rec.attribute1,
         l_avl_rec.attribute2,
         l_avl_rec.attribute3,
         l_avl_rec.attribute4,
         l_avl_rec.attribute5,
         l_avl_rec.attribute6,
         l_avl_rec.attribute7,
         l_avl_rec.attribute8,
         l_avl_rec.attribute9,
         l_avl_rec.attribute10,
         l_avl_rec.attribute11,
         l_avl_rec.attribute12,
         l_avl_rec.attribute13,
         l_avl_rec.attribute14,
         l_avl_rec.attribute15,
         l_avl_rec.created_by,
         l_avl_rec.creation_date,
         l_avl_rec.last_updated_by,
         l_avl_rec.last_update_date,
         l_avl_rec.last_update_login,
    -- Added by HKPATEL for securitization changes
    	l_avl_rec.inv_code);
Line: 2057

  END insert_row;
Line: 2061

  PROCEDURE insert_row(
    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

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2071

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_insert_row';
Line: 2088

      l_avlv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 2089

      l_avlv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 2090

      l_avlv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 2170

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_avl_rec,
      lx_avl_rec
    );
Line: 2218

  END insert_row;
Line: 2222

  PROCEDURE insert_row(
    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                 CONSTANT NUMBER := 1;
Line: 2232

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
Line: 2242

        insert_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          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: 2291

  END insert_row;
Line: 2309

    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_AE_TEMPLATES
     WHERE ID = p_avl_rec.id
       AND OBJECT_VERSION_NUMBER = p_avl_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 2316

    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_AE_TEMPLATES
    WHERE ID = p_avl_rec.id;
Line: 2357

      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
Line: 2366

      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
Line: 2560

  PROCEDURE update_row(
    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_avl_rec                      IN avl_rec_type,
    x_avl_rec                      OUT NOCOPY avl_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2569

    l_api_name                     CONSTANT VARCHAR2(30) := 'TEMPLATES_update_row';
Line: 2747

      IF (x_avl_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_avl_rec.last_updated_by := l_avl_rec.last_updated_by;
Line: 2751

      IF (x_avl_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_avl_rec.last_update_date := l_avl_rec.last_update_date;
Line: 2755

      IF (x_avl_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_avl_rec.last_update_login := l_avl_rec.last_update_login;
Line: 2804

    UPDATE  OKL_AE_TEMPLATES
    SET NAME = l_def_avl_rec.name,
        SET_OF_BOOKS_ID = l_def_avl_rec.set_of_books_id,
        STY_ID = l_def_avl_rec.sty_id,
        TRY_ID = l_def_avl_rec.try_id,
        AES_ID = l_def_avl_rec.aes_id,
        SYT_CODE = l_def_avl_rec.syt_code,
        FAC_CODE = l_def_avl_rec.fac_code,
        FMA_ID = l_def_avl_rec.fma_id,
        ADVANCE_ARREARS = l_def_avl_rec.advance_arrears,
        POST_TO_GL = l_def_avl_rec.post_to_gl,
        VERSION = l_def_avl_rec.version,
        START_DATE = l_def_avl_rec.start_date,
        OBJECT_VERSION_NUMBER = l_def_avl_rec.object_version_number,
        MEMO_YN = l_def_avl_rec.memo_yn,
        PRIOR_YEAR_YN = l_def_avl_rec.prior_year_yn,
        DESCRIPTION = l_def_avl_rec.description,
        FACTORING_SYND_FLAG = l_def_avl_rec.factoring_synd_flag,
        END_DATE = l_def_avl_rec.end_date,
        ACCRUAL_YN = l_def_avl_rec.accrual_yn ,
        ORG_ID = l_def_avl_rec.org_id,
        ATTRIBUTE_CATEGORY = l_def_avl_rec.attribute_category,
        ATTRIBUTE1 = l_def_avl_rec.attribute1,
        ATTRIBUTE2 = l_def_avl_rec.attribute2,
        ATTRIBUTE3 = l_def_avl_rec.attribute3,
        ATTRIBUTE4 = l_def_avl_rec.attribute4,
        ATTRIBUTE5 = l_def_avl_rec.attribute5,
        ATTRIBUTE6 = l_def_avl_rec.attribute6,
        ATTRIBUTE7 = l_def_avl_rec.attribute7,
        ATTRIBUTE8 = l_def_avl_rec.attribute8,
        ATTRIBUTE9 = l_def_avl_rec.attribute9,
        ATTRIBUTE10 = l_def_avl_rec.attribute10,
        ATTRIBUTE11 = l_def_avl_rec.attribute11,
        ATTRIBUTE12 = l_def_avl_rec.attribute12,
        ATTRIBUTE13 = l_def_avl_rec.attribute13,
        ATTRIBUTE14 = l_def_avl_rec.attribute14,
        ATTRIBUTE15 = l_def_avl_rec.attribute15,
        CREATED_BY = l_def_avl_rec.created_by,
        CREATION_DATE = l_def_avl_rec.creation_date,
        LAST_UPDATED_BY = l_def_avl_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_avl_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_avl_rec.last_update_login,
  -- Added by HKPATEL for securitization changes
  	INV_CODE = l_def_avl_rec.inv_code
    WHERE ID = l_def_avl_rec.id;
Line: 2883

  END update_row;
Line: 2887

  PROCEDURE update_row(
    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

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2897

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_update_row';
Line: 2911

      l_avlv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 2912

      l_avlv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 2913

      l_avlv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 3089

      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: 3093

      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: 3097

      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: 3190

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_avl_rec,
      lx_avl_rec
    );
Line: 3237

  END update_row;
Line: 3241

  PROCEDURE update_row(
    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                 CONSTANT NUMBER := 1;
Line: 3251

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
Line: 3261

        update_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          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: 3310

  END update_row;
Line: 3318

  PROCEDURE delete_row(
    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_avl_rec                      IN avl_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 3326

    l_api_name                     CONSTANT VARCHAR2(30) := 'TEMPLATES_delete_row';
Line: 3340

    DELETE FROM OKL_AE_TEMPLATES
     WHERE ID = l_avl_rec.id;
Line: 3375

  END delete_row;
Line: 3379

  PROCEDURE delete_row(
    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                 CONSTANT NUMBER := 1;
Line: 3388

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_delete_row';
Line: 3412

    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_avl_rec
    );
Line: 3456

  END delete_row;
Line: 3460

  PROCEDURE delete_row(
    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                 CONSTANT NUMBER := 1;
Line: 3469

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
Line: 3479

        delete_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          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));
Line: 3527

  END delete_row;