APPS.OKL_PERIOD_SWEEP_PVT SQL Statements

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

Line: 18

 SELECT DISTINCT dstrs.SOURCE_ID,
                 dstrs.SOURCE_TABLE,
                 dstrs.GL_DATE
   FROM OKL_TRNS_ACC_DSTRS dstrs,XLA_EVENTS xle
  WHERE dstrs.GL_DATE BETWEEN p_gl_date_from AND p_gl_date_to
    AND dstrs.SET_OF_BOOKS_ID = p_ledger_id
    AND dstrs.ACCOUNTING_EVENT_ID =xle.EVENT_ID
    AND xle.EVENT_STATUS_CODE IN ('I','U')
  ORDER BY GL_DATE;

Line: 36

SELECT khr.contract_number,
       try.name  trx_type,
       sty.name stream_type,
       tcn.trx_number,
       tcn.date_transaction_occurred,
       tcl.line_number,
       tcl.amount line_amount
FROM okl_trx_contracts_all tcn,
     okl_txl_cntrct_lns_all tcl,
     okl_strm_type_tl sty,
     okl_trx_types_v try,
     okc_k_headers_all_b khr
WHERE tcl.id = p_source_id
AND   tcn.id = tcl.tcn_id
AND   tcl.sty_id = sty.id(+)
AND   tcn.try_id = try.id
AND   khr.id = tcn.khr_id
--added by rkuttiya for MultiGAAP Project
AND   tcn.set_of_books_id = p_ledger_id;

Line: 63

SELECT khr.contract_number,
       try.name trx_type,
       tas.trans_number,
       tas.date_trans_occurred,
       tal.line_number,
       tal.original_cost line_amount
FROM okl_trx_assets tas,
     okl_txl_assets_b tal,
     okl_trx_types_v try,
     okc_k_headers_all_b khr
WHERE tal.id = p_source_id
AND   tas.id = tal.tas_id
AND   tas.try_id = try.id
AND   khr.id = tal.dnz_khr_id;

Line: 89

     INSERT INTO OKL_G_REPORTS_GT(VALUE1_TEXT,VALUE2_TEXT,VALUE1_DATE)
     VALUES('HEADER' ,l_ledger_name, l_to_start_date);

Line: 98

           INSERT INTO
           OKL_G_REPORTS_GT(VALUE1_TEXT,
                            VALUE2_TEXT,
                            VALUE3_TEXT,
                            VALUE4_TEXT,
                            VALUE5_TEXT,
                            VALUE1_DATE,
                            VALUE1_NUM,
                            VALUE2_NUM,
                            VALUE2_DATE)
                     VALUES('LINES',
                            tcn_rec.contract_number,
                            tcn_rec.trx_type,
                            tcn_rec.stream_type,
                            tcn_rec.trx_number,
                            tcn_rec.date_transaction_occurred,
                            tcn_rec.line_number,
                            tcn_rec.line_amount,
                            acct_rec.gl_date);

Line: 128

          INSERT INTO OKL_G_REPORTS_GT(VALUE1_TEXT,
                                       VALUE2_TEXT,
                                       VALUE3_TEXT,
                                       VALUE4_TEXT,
                                       VALUE5_TEXT,
                                       VALUE1_DATE,
                                       VALUE1_NUM,
                                       VALUE2_NUM,
                                       VALUE2_DATE)
                                VALUES('LINES',
                                       tas_rec.contract_number,
                                       tas_rec.trx_type,
                                       null,
                                       tas_rec.trans_number,
                                       tas_rec.date_trans_occurred,
                                       tas_rec.line_number,
                                       tas_rec.line_amount,
                                       acct_rec.gl_date);

Line: 191

 TYPE update_event_rec IS RECORD (
      tcn_id          NUMBER,
      event_id        NUMBER,
      accrual_reversal_date DATE,
      trx_type_class VARCHAR2(30));

Line: 203

 TYPE l_tcn_tbl_type IS TABLE OF update_event_rec INDEX BY BINARY_INTEGER;

Line: 213

 SELECT dstrs.ID,dstrs.ACCOUNTING_EVENT_ID,dstrs.SOURCE_ID
   FROM OKL_TRNS_ACC_DSTRS dstrs,XLA_EVENTS xle
  WHERE dstrs.GL_DATE BETWEEN p_gl_date_from AND p_gl_date_to
    AND dstrs.SET_OF_BOOKS_ID = p_ledger_id
    AND dstrs.ACCOUNTING_EVENT_ID =xle.EVENT_ID
    AND xle.EVENT_STATUS_CODE IN ('I','U')
  ORDER BY ACCOUNTING_EVENT_ID;

Line: 223

 SELECT TCN.ID,
        TCN.ACCRUAL_REVERSAL_DATE,
        TRY.TRX_TYPE_CLASS
   FROM OKL_TXL_CNTRCT_LNS_ALL TXL ,
        OKL_TRX_CONTRACTS_ALL TCN,
        OKL_TRX_TYPES_B TRY
  WHERE TXL.ID = p_txl_id AND
        TXL.TCN_ID = TCN.ID AND
        TCN.TRY_ID = TRY.ID
        --rkuttiya added for Multi GAAP Project
        AND TCN.SET_OF_BOOKS_ID = p_ledger_id;

Line: 236

 SELECT end_date +1 accrual_reversal_date
   FROM gl_period_statuses
  WHERE application_id = 540
    AND set_of_books_id =p_ledger_id
    AND p_accrual_date BETWEEN start_date AND end_date;

Line: 244

 SELECT ledger_id
   FROM okl_representations_v
  WHERE representation_code = p_representation_code;

Line: 330

          OKL_TRNS_ACC_DSTRS_PUB.update_trns_acc_dstrs(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_tabv_tbl        => l_tabv_tbl,
                                                       x_tabv_tbl        => x_tabv_tbl);

Line: 345

          OKL_XLA_EVENTS_PVT.update_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_gl_date       =>l_to_start_date
                                         ,p_event_id      =>l_tcn_tbl(j).event_id
                                         ,p_tcn_id        =>l_tcn_tbl(j).tcn_id);

Line: 363

         Okl_Trx_Contracts_Pub.update_trx_contracts(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_tcnv_rec => l_tcnv_rec,
                                                    x_tcnv_rec => x_tcnv_rec);

Line: 434

  SELECT MIN(start_date)
  FROM gl_period_statuses
  WHERE application_id = 540
  AND ledger_id = p_ledger_id
  AND closing_status IN ('F','O')
  AND start_date > p_date
  AND adjustment_period_flag = 'N' ;

Line: 446

  SELECT ledger_id
  FROM okl_representations_v
  WHERE representation_code = p_representation_code;

Line: 452

  SELECT representation_code
  FROM okl_representations_v
  WHERE representation_type = p_representation_type;