APPS.OKL_SUBSIDY_POOL_BUDGET_PVT SQL Statements

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

Line: 108

        Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIBB.pls call okl_sib_pvt.insert_row');

Line: 132

   okl_sib_pvt.insert_row(l_api_version,
                            l_init_msg_list,
                            l_return_status,
                            l_msg_count,
                            l_msg_data,
                            l_budget_line_tbl,
                            x_budget_line_tbl);

Line: 153

        Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIBB.pls call okl_sib_pvt.insert_row ');

Line: 210

  PROCEDURE update_budget_line  ( 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_budget_line_tbl  IN  budget_line_tbl
                                 ,x_budget_line_tbl  OUT NOCOPY budget_line_tbl
                                ) IS

---------------------------
-- DECLARE Local Variables
---------------------------
  L_MODULE              CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_BUDGET_PVT.UPDATE_BUDGET_LINE';

Line: 249

         Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIBB.pls call okl_sib_pvt.update_row ');

Line: 258

   SAVEPOINT update_budget_line_PVT;

Line: 274

   okl_sib_pvt.update_row  (l_api_version,
                            l_init_msg_list,
                            l_return_status,
                            l_msg_count,
                            l_msg_data,
                            l_budget_line_tbl,
                            x_budget_line_tbl);

Line: 295

        Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIBB.pls call okl_sib_pvt.update_row ');

Line: 333

END update_budget_line;

Line: 384

   SELECT   id
           ,object_version_number
           ,sfwt_flag
           ,note
           ,budget_type_code
           ,effective_from_date
           ,decision_status_code
           ,budget_amount
           ,subsidy_pool_id
           ,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_POOL_BUDGETS_V
   WHERE  id = cp_sub_pool_budget_id;

Line: 426

           Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIBB.pls call okl_sib_pvt.update_row ');

Line: 462

       okl_sib_pvt.update_row(l_api_version,
                              l_init_msg_list,
                              l_return_status,
                              l_msg_count,
                              l_msg_data,
                              l_budget_line_rec,
                              x_budget_line_rec);

Line: 508

        Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIBB.pls call okl_sib_pvt.update_row ');