DBA Data[Home] [Help]

APPS.OKL_SUBSIDY_POOL_PVT SQL Statements

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

Line: 11

   SELECT   id
           ,object_version_number
           ,sfwt_flag
           ,pool_type_code
           ,subsidy_pool_name
           ,short_description
           ,description
           ,effective_from_date
           ,effective_to_date
           ,currency_code
           ,currency_conversion_type
           ,decision_status_code
           ,subsidy_pool_id
           ,reporting_pool_limit
           ,total_budgets
           ,total_subsidy_amount
           ,decision_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_SUBSIDY_POOLS_V
   WHERE  id = cp_pool_id;
Line: 148

        Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.insert_row ');
Line: 191

   okl_sip_pvt.insert_row( l_api_version,
                           l_init_msg_list,
                           l_return_status,
                           l_msg_count,
                           l_msg_data,
                           l_sub_pool_rec,
                           x_sub_pool_rec);
Line: 212

        Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIPB.pls call okl_sip_pvt.insert_row ');
Line: 268

  PROCEDURE update_sub_pool     ( p_api_version      IN  NUMBER
                                 ,p_init_msg_list    IN  VARCHAR2
                                 ,x_return_status    OUT NOCOPY VARCHAR2
                                 ,x_msg_count        OUT NOCOPY NUMBER
                                 ,x_msg_data         OUT NOCOPY VARCHAR2
                                 ,p_sub_pool_rec     IN  subsidy_pool_rec
                                 ,x_sub_pool_rec     OUT NOCOPY subsidy_pool_rec
                                ) IS
---------------------------
-- DECLARE Local Variables
---------------------------
  L_MODULE                   CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.UPDATE_SUB_POOL';
Line: 294

  l_api_name                 CONSTANT VARCHAR2(30) := 'update_sub_pool';
Line: 302

   SELECT   effective_to_date
   FROM okl_subsidy_pools_v
   WHERE id = cp_pool_id;
Line: 308

    SELECT   'X'
    FROM   okl_subsidy_pools_v pool, okl_subsidies_b sub
    WHERE  sub.subsidy_pool_id = pool.id
    AND    pool.id = cp_pool_id
    AND  (
         NOT  ((pool.effective_from_date BETWEEN sub.effective_from_date AND NVL(sub.effective_to_date,(TO_DATE('1','j') + 5300000)))
          OR (sub.effective_from_date BETWEEN pool.effective_from_date AND cp_effective_to))
        );
Line: 319

  SELECT max(TRUNC(trx_date))
  FROM okl_trx_subsidy_pools
  WHERE subsidy_pool_id = cp_pool_id;
Line: 333

        Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');
Line: 348

   SAVEPOINT update_sub_pool_PVT;
Line: 428

   okl_sip_pvt.update_row(l_api_version,
                          l_init_msg_list,
                          l_return_status,
                          l_msg_count,
                          l_msg_data,
                          l_sub_pool_rec,
                          x_sub_pool_rec);
Line: 449

        Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');
Line: 487

END update_sub_pool;
Line: 545

        Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');
Line: 579

    okl_sip_pvt.update_row(l_api_version,
                           l_init_msg_list,
                           l_return_status,
                           l_msg_count,
                           l_msg_data,
                           l_sub_pool_rec,
                           x_sub_pool_rec);
Line: 600

        Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');
Line: 655

PROCEDURE update_total_budget ( p_api_version                  IN  NUMBER,
                                p_init_msg_list                IN  VARCHAR2,
                                x_return_status                OUT NOCOPY VARCHAR2,
                                x_msg_count                    OUT NOCOPY NUMBER,
                                x_msg_data                     OUT NOCOPY VARCHAR2,
                                p_subsidy_pool_id              IN  okl_subsidy_pools_b.id%TYPE,
                                p_total_budget_amt             IN  okl_subsidy_pools_b.total_budgets%TYPE ) IS
---------------------------
-- DECLARE Local Variables
---------------------------
  L_MODULE              CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.UPDATE_TOTAL_BUDGET';
Line: 678

  l_api_name            CONSTANT VARCHAR2(30) := 'update_total_budget';
Line: 692

        Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');
Line: 701

  SAVEPOINT update_total_budget_PVT;
Line: 725

    okl_sip_pvt.update_row(l_api_version,
                           l_init_msg_list,
                           l_return_status,
                           l_msg_count,
                           l_msg_data,
                           l_sub_pool_rec,
                           x_sub_pool_rec);
Line: 745

        Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');
Line: 782

 END update_total_budget;
Line: 800

PROCEDURE update_subsidy_amount ( p_api_version            IN  NUMBER,
                                  p_init_msg_list                IN  VARCHAR2,
                                  x_return_status                OUT NOCOPY VARCHAR2,
                                  x_msg_count                    OUT NOCOPY NUMBER,
                                  x_msg_data                     OUT NOCOPY VARCHAR2,
                                  p_subsidy_pool_id              IN  okl_subsidy_pools_b.id%TYPE,
                                  p_total_subsidy_amt            IN  okl_subsidy_pools_b.total_subsidy_amount%TYPE) IS

---------------------------
-- DECLARE Local Variables
---------------------------
  L_MODULE              CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.UPDATE_SUBSIDY_AMOUNT';
Line: 824

  l_api_name            CONSTANT VARCHAR2(30) := 'update_subsidy_amount';
Line: 838

        Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');
Line: 847

  SAVEPOINT update_subsidy_amount_PVT;
Line: 870

    okl_sip_pvt.update_row(l_api_version,
                           l_init_msg_list,
                           l_return_status,
                           l_msg_count,
                           l_msg_data,
                           l_sub_pool_rec,
                           x_sub_pool_rec);
Line: 890

        Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');
Line: 927

 END update_subsidy_amount;
Line: 985

        Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');
Line: 1018

    okl_sip_pvt.update_row(l_api_version,
                           l_init_msg_list,
                           l_return_status,
                           l_msg_count,
                           l_msg_data,
                           l_sub_pool_rec,
                           x_sub_pool_rec);
Line: 1061

        Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');