APPS.OKL_REVERSAL_PVT SQL Statements

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

Line: 139

  SELECT prdst.closing_status
  FROM  GL_PERIOD_STATUSES_V prdst
  WHERE prdst.ledger_id = OKL_ACCOUNTING_UTIL.get_set_of_books_id
  AND   prdst.period_name     = v_period_name
  AND   prdst.APPLICATION_ID  = l_application_id;

Line: 147

  SELECT 'x'
  FROM OKL_TRNS_ACC_DSTRS
  WHERE source_id          = p_source_id
  AND   source_table       = p_source_table
  AND   REVERSE_EVENT_FLAG = 'Y';

Line: 155

   SELECT  ID
        ,CURRENCY_CONVERSION_TYPE
        ,SET_OF_BOOKS_ID
        ,CR_DR_FLAG
        ,CODE_COMBINATION_ID
        ,ORG_ID
        ,CURRENCY_CODE
        ,AE_LINE_TYPE
        ,TEMPLATE_ID
        ,SOURCE_ID
        ,SOURCE_TABLE
        ,OBJECT_VERSION_NUMBER
        ,AMOUNT
        ,ACCOUNTED_AMOUNT
        ,GL_DATE
        ,PERCENTAGE
        ,COMMENTS
        ,POST_REQUEST_ID
        ,CURRENCY_CONVERSION_DATE
        ,CURRENCY_CONVERSION_RATE
        ,REQUEST_ID
        ,PROGRAM_APPLICATION_ID
        ,PROGRAM_ID
        ,PROGRAM_UPDATE_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
        ,AET_ID
        ,POSTED_YN
        ,AE_CREATION_ERROR
        ,GL_REVERSAL_FLAG
        ,POST_TO_GL
        ,REVERSE_EVENT_FLAG
        ,ORIGINAL_DIST_ID
  FROM OKL_TRNS_ACC_DSTRS
  WHERE source_table    = p_source_table
  AND   source_id       = p_source_id;

Line: 214

  select nvl(amount, 0)
    from okl_txl_cntrct_lns
   where id = p_source_id;

Line: 224

 SELECT rep.representation_code
   FROM okl_trx_contracts_all o,
        okl_representations_v rep
  WHERE o.set_of_books_id = rep.ledger_id
    AND o.id = p_tcn_id;

Line: 232

 SELECT account_derivation
   FROM okl_sys_acct_opts;

Line: 237

 SELECT tcn_id
   FROM okl_txl_cntrct_lns_all
  WHERE id = p_source_id;

Line: 243

 SELECT t.name
   FROM okl_trx_types_tl t, okl_trx_contracts_all tcn
  WHERE tcn.try_id = t.id
    AND tcn.id = p_tcn_id
    AND LANGUAGE = 'US';

Line: 418

	  -- END of code to be deleted once all teams uptake AE call.

      l_event_id :=
        OKL_XLA_EVENTS_PVT.create_event(p_api_version          => l_api_version
                                       ,p_init_msg_list        => l_init_msg_list
                                       ,x_return_status        => l_return_status
                                       ,x_msg_count            => l_msg_count
                                       ,x_msg_data             => l_msg_data
                                       ,p_tcn_id               => l_tcn_id
                                       ,p_gl_date              => p_acct_date
                                       ,p_action_type          => 'REVERSE'
                                       ,p_representation_code  => l_gl_short_name
                                       );

Line: 519

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRREVB.pls call OKL_TRNS_ACC_DSTRS_PUB.insert_trns_acc_dstrs ');

Line: 523

   OKL_TRNS_ACC_DSTRS_PUB.insert_trns_acc_dstrs(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_tabv_tbl         => l_dist_tbl_in,
                                                x_tabv_tbl         => l_dist_tbl_out);

Line: 532

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRREVB.pls call OKL_TRNS_ACC_DSTRS_PUB.insert_trns_acc_dstrs ');