APPS.OKL_SUBSIDY_POOL_WF SQL Statements

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

Line: 62

    SELECT NAME, DISPLAY_NAME
      FROM WF_USERS
     WHERE orig_system_id = p_user_id
	      AND ORIG_SYSTEM = G_WF_USER_ORIG_SYSTEM_HR;

Line: 69

    SELECT USER_NAME, DESCRIPTION
    FROM   FND_USER
    WHERE  user_id = c_user_id;

Line: 93

    SELECT okl_wf_item_s.NEXTVAL item_key
    FROM  dual;

Line: 446

  PROCEDURE update_pool_approval_status(itemtype	IN VARCHAR2
                                        ,itemkey  	IN VARCHAR2
                                        ,actid		IN NUMBER
                                        ,funcmode	IN VARCHAR2
                                        ,resultout OUT NOCOPY VARCHAR2) IS
    CURSOR c_get_bud_line_csr (cp_subsidy_pool_id okl_subsidy_pools_b.id%TYPE)IS
    SELECT id
      FROM okl_subsidy_pool_budgets_b
     WHERE subsidy_pool_id = cp_subsidy_pool_id;

Line: 465

    l_api_name CONSTANT VARCHAR2(60) DEFAULT 'update_pool_status';

Line: 466

    l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_WF.UPDATE_POOL_APPROVAL_STATUS';

Line: 475

      okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRBWFB.pls call update_pool_approval_status');

Line: 502

        okl_subsidy_pool_pvt.update_total_budget(p_api_version      => '1.0'
                                                 ,p_init_msg_list   => OKL_API.G_TRUE
                                                 ,x_return_status   => x_return_status
                                                 ,x_msg_count       => x_msg_count
                                                 ,x_msg_data        => x_msg_data
                                                 ,p_subsidy_pool_id => lv_subsidy_pool_id
                                                 ,p_total_budget_amt => lv_total_budget
                                                 );

Line: 514

                                  'okl_subsidy_pool_pvt.update_total_budget with total budget amount '||lv_total_budget||
                                  ' returned with status '||x_return_status ||' x_msg_data '||x_msg_data
                                  );

Line: 632

      okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRBWFB.pls call update_pool_approval_status');

Line: 661

  END update_pool_approval_status;

Line: 663

  PROCEDURE update_line_approval_status(itemtype	IN VARCHAR2
                                        ,itemkey  	IN VARCHAR2
                                        ,actid		IN NUMBER
                                        ,funcmode	IN VARCHAR2
                                        ,resultout OUT NOCOPY VARCHAR2) IS
    lv_budget_type_code okl_subsidy_pool_budgets_b.budget_type_code%TYPE;

Line: 670

    SELECT total_budgets
      FROM okl_subsidy_pools_b
     WHERE id = cp_subsidy_pool_id;

Line: 683

    l_api_name CONSTANT VARCHAR2(60) DEFAULT 'update_line_status';

Line: 684

    l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_WF.UPDATE_LINE_APPROVAL_STATUS';

Line: 692

      okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRBWFB.pls call update_line_approval_status');

Line: 732

          okl_subsidy_pool_pvt.update_total_budget(p_api_version      => '1.0'
                                                   ,p_init_msg_list   => OKL_API.G_TRUE
                                                   ,x_return_status   => x_return_status
                                                   ,x_msg_count       => x_msg_count
                                                   ,x_msg_data        => x_msg_data
                                                   ,p_subsidy_pool_id => lv_subsidy_pool_id
                                                   ,p_total_budget_amt => lv_total_budget
                                                   );

Line: 744

                                    'okl_subsidy_pool_pvt.update_total_budget of budget amount '||lv_total_budget||' returned with status '||x_return_status||
                                    ' x_msg_data '||x_msg_data
                                    );

Line: 782

          okl_subsidy_pool_pvt.update_total_budget(p_api_version      => '1.0'
                                                   ,p_init_msg_list   => OKL_API.G_TRUE
                                                   ,x_return_status   => x_return_status
                                                   ,x_msg_count       => x_msg_count
                                                   ,x_msg_data        => x_msg_data
                                                   ,p_subsidy_pool_id => lv_subsidy_pool_id
                                                   ,p_total_budget_amt => lv_total_budget
                                                   );

Line: 794

                                    'okl_subsidy_pool_pvt.update_total_budget budget  '||lv_total_budget||' returned with status '||x_return_status||
                                    ' x_msg_data '||x_msg_data
                                    );

Line: 847

      okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRBWFB.pls call update_line_approval_status');

Line: 875

  END update_line_approval_status;

Line: 884

    SELECT USER_NAME
    FROM   FND_USER
    WHERE  user_id = p_user_id;

Line: 1290

    SELECT pool.subsidy_pool_name
          ,pool.effective_from_date
          ,pool.effective_to_date
          ,pool.total_budgets
          ,pool.currency_code
          ,pool.short_description
          ,bud.budget_amount
      FROM okl_subsidy_pools_v pool
          ,okl_subsidy_pool_budgets_b bud
     WHERE pool.id = cp_subsidy_pool_id
       AND pool.id = bud.subsidy_pool_id;

Line: 1308

    SELECT APPLICATION_ID
    FROM   FND_APPLICATION
    WHERE  APPLICATION_SHORT_NAME = G_APP_NAME;

Line: 1314

    SELECT transaction_type_id,
           fnd_application_id
    FROM   ame_transaction_types_v
    WHERE  transaction_type_id = cp_trx_type;

Line: 1321

    SELECT id
    FROM   okl_trx_types_b
    WHERE  trx_type_class = G_TRX_TYPE_POOL_APPROVAL;

Line: 1447

      l_parameter_list.DELETE;

Line: 1500

    SELECT sub.subsidy_pool_name
          ,sub.id subsidy_pool_id
          ,sub.effective_from_date pool_start_date
          ,sub.effective_to_date
          ,sub.total_budgets
          ,bud.budget_type_code
          ,bud.effective_from_date budget_line_date
          ,bud.budget_amount
          ,sub.currency_code
      FROM okl_subsidy_pools_b sub
          ,okl_subsidy_pool_budgets_b bud
     WHERE bud.subsidy_pool_id = sub.id
       AND bud.id = cp_pool_budget_id;

Line: 1518

    SELECT APPLICATION_ID
    FROM   FND_APPLICATION
    WHERE  APPLICATION_SHORT_NAME = G_APP_NAME;

Line: 1524

    SELECT transaction_type_id,
           fnd_application_id
    FROM  ame_transaction_types_v
    WHERE transaction_type_id = cp_trx_type;

Line: 1531

    SELECT id
    FROM   okl_trx_types_b
    WHERE  trx_type_class = G_TRX_TYPE_POOL_APPROVAL;

Line: 1659

      l_parameter_list.DELETE;