eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_TRANS_CONTRACTS_PVT SQL Statements

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

Line: 6


SELECT CONTRACT_NUMBER
FROM OKC_K_HEADERS_B
WHERE ID = p_khr_id ;

Line: 20


SELECT SUM(AMOUNT) SUM_AMOUNT
FROM OKL_TXL_CNTRCT_LNS
WHERE TCN_ID = l_trx_id;

Line: 69


SELECT ID
FROM OKL_TRX_TYPES_TL
WHERE NAME = 'Miscellaneous'
AND   LANGUAGE = 'US';

Line: 78


SELECT 	currency_conversion_type, currency_conversion_rate,
	currency_conversion_date
FROM 	okl_k_headers
WHERE 	id = l_khr_id;

Line: 234


  SELECT ID
  FROM OKL_TRX_TYPES_TL
  WHERE NAME = 'Miscellaneous'
  AND   LANGUAGE = 'US';

Line: 243


  SELECT currency_conversion_type, currency_conversion_rate,
	 currency_conversion_date
  FROM 	 okl_k_headers
  WHERE  id = l_khr_id;

Line: 575


PROCEDURE update_trx_contracts( p_api_version         IN  NUMBER
                               ,p_init_msg_list       IN  VARCHAR2 DEFAULT OKC_API.G_FALSE
                               ,x_return_status       OUT NOCOPY VARCHAR2
                               ,x_msg_count           OUT NOCOPY NUMBER
                               ,x_msg_data            OUT NOCOPY VARCHAR2
                               ,p_tcnv_rec            IN  tcnv_rec_type
                               ,p_tclv_tbl            IN  tclv_tbl_type
                               ,x_tcnv_rec            OUT NOCOPY tcnv_rec_type
                               ,x_tclv_tbl            OUT NOCOPY tclv_tbl_type)
IS
l_api_version   NUMBER := 1.0;

Line: 609


   OKL_TRX_CONTRACTS_PUB.update_trx_contracts( p_api_version     => l_api_version
                                              ,p_init_msg_list   => p_init_msg_list
                                              ,x_return_status   => x_return_status
                                              ,x_msg_count       => x_msg_count
                                              ,x_msg_data        => x_msg_data
                                              ,p_tcnv_rec        => l_tcnv_rec
                                              ,p_tclv_tbl        => p_tclv_tbl
                                              ,x_tcnv_rec        => x_tcnv_rec
                                              ,x_tclv_tbl        => x_tclv_tbl );

Line: 624


PROCEDURE update_trx_contracts(p_api_version        IN  NUMBER,
                               p_init_msg_list      IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
                               x_return_status      OUT NOCOPY VARCHAR2,
                               x_msg_count          OUT NOCOPY NUMBER,
                               x_msg_data           OUT NOCOPY VARCHAR2,
                               p_tcnv_rec           IN  tcnv_rec_type,
                               x_tcnv_rec           OUT NOCOPY tcnv_rec_type)
IS

  CURSOR chk_csr(v_tcn_id NUMBER, v_source_table VARCHAR2) IS
  SELECT NVL(COUNT(*),0)
  FROM OKL_TRNS_ACC_DSTRS
  WHERE source_id IN (SELECT id FROM OKL_TXL_CNTRCT_LNS
                      WHERE TCN_ID = v_tcn_id)
  AND   source_table = v_source_table;

Line: 642


  SELECT ID
  FROM OKL_TXL_CNTRCT_LNS
  WHERE TCN_ID = v_tcn_id;

Line: 648


  SELECT tsu_code
  FROM OKL_TRX_CONTRACTS
  WHERE id = v_tcn_id;

Line: 660


  l_api_name       CONSTANT VARCHAR2(30) := 'UPDATE_TRX_CONTRACTS';

Line: 716


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

Line: 796


END UPDATE_TRX_CONTRACTS;

Line: 800


PROCEDURE update_trx_contracts(p_api_version            IN  NUMBER,
                               p_init_msg_list          IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
                               x_return_status          OUT NOCOPY VARCHAR2,
                               x_msg_count              OUT NOCOPY NUMBER,
                               x_msg_data               OUT NOCOPY VARCHAR2,
                               p_tcnv_tbl               IN  tcnv_tbl_type,
                               x_tcnv_tbl               OUT NOCOPY tcnv_tbl_type)
 IS

 l_api_version NUMBER := 1.0;

Line: 821


        update_trx_contracts(p_api_version     => l_api_version,
                             p_init_msg_list   => p_init_msg_list,
                             x_return_status   => x_return_status,
                             x_msg_count       => x_msg_count,
                             x_msg_data        => x_msg_data,
                             p_tcnv_rec        => p_tcnv_tbl(i),
                             x_tcnv_rec        => x_tcnv_tbl(i));

Line: 846


END UPDATE_TRX_CONTRACTS;

Line: 850


PROCEDURE update_trx_cntrct_lines(p_api_version         IN  NUMBER,
                                  p_init_msg_list       IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
                                  x_return_status       OUT NOCOPY VARCHAR2,
                                  x_msg_count           OUT NOCOPY NUMBER,
                                  x_msg_data            OUT NOCOPY VARCHAR2,
                                  p_tclv_rec            IN  tclv_rec_type,
                                  x_tclv_rec            OUT NOCOPY tclv_rec_type)
 IS

 l_api_version   NUMBER := 1.0;

Line: 875


   OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines(p_api_version      => l_api_version,
                                                 p_init_msg_list    => p_init_msg_list,
                                                 x_return_status    => x_return_status,
                                                 x_msg_count        => x_msg_count,
                                                 x_msg_data         => x_msg_data,
                                                 p_tclv_rec         => p_tclv_rec,
                                                 x_tclv_rec         => x_tclv_rec);

Line: 890


PROCEDURE update_trx_cntrct_lines(p_api_version         IN  NUMBER,
                                  p_init_msg_list       IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
                                  x_return_status       OUT NOCOPY VARCHAR2,
                                  x_msg_count           OUT NOCOPY NUMBER,
                                  x_msg_data            OUT NOCOPY VARCHAR2,
                                  p_tclv_tbl            IN  tclv_tbl_type,
                                  x_tclv_tbl            OUT NOCOPY tclv_tbl_type)
IS
l_api_version  NUMBER := 1.0;

Line: 902


 OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines(p_api_version      => l_api_version,
                                               p_init_msg_list    => p_init_msg_list,
                                               x_return_status    => x_return_status,
                                               x_msg_count        => x_msg_count,
                                               x_msg_data         => x_msg_data,
                                               p_tclv_tbl         => p_tclv_tbl,
                                               x_tclv_tbl         => x_tclv_tbl);

Line: 914


PROCEDURE delete_trx_contracts(p_api_version        IN  NUMBER,
                               p_init_msg_list      IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
                               x_return_status      OUT NOCOPY VARCHAR2,
                               x_msg_count          OUT NOCOPY NUMBER,
                               x_msg_data           OUT NOCOPY VARCHAR2,
                               p_tcnv_rec           IN  tcnv_rec_type)
IS

l_api_version NUMBER := 1.0;

Line: 925


OKL_TRX_CONTRACTS_PUB.delete_trx_contracts(p_api_version   => l_api_version,
                                             p_init_msg_list => p_init_msg_list,
                                             x_return_status => x_return_status,
                                             x_msg_count     => x_msg_count,
                                             x_msg_data      => x_msg_data,
                                             p_tcnv_rec      => p_tcnv_rec );

Line: 936


PROCEDURE delete_trx_contracts(p_api_version        IN  NUMBER,
                               p_init_msg_list      IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
                               x_return_status      OUT NOCOPY VARCHAR2,
                               x_msg_count          OUT NOCOPY NUMBER,
                               x_msg_data           OUT NOCOPY VARCHAR2,
                               p_tcnv_tbl           IN  tcnv_tbl_type)
IS

l_api_version NUMBER := 1.0;

Line: 949


  OKL_TRX_CONTRACTS_PUB.delete_trx_contracts(p_api_version   => l_api_version,
                                             p_init_msg_list => p_init_msg_list,
                                             x_return_status => x_return_status,
                                             x_msg_count     => x_msg_count,
                                             x_msg_data      => x_msg_data,
                                             p_tcnv_tbl      => p_tcnv_tbl );

Line: 960


PROCEDURE delete_trx_cntrct_lines(p_api_version         IN  NUMBER,
                                  p_init_msg_list       IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
                                  x_return_status       OUT NOCOPY VARCHAR2,
                                  x_msg_count           OUT NOCOPY NUMBER,
                                  x_msg_data            OUT NOCOPY VARCHAR2,
                                  p_tclv_rec            IN  tclv_rec_type)
IS
l_api_version  NUMBER := 1.0;

Line: 971


 OKL_TRX_CONTRACTS_PUB.delete_trx_cntrct_lines(p_api_version      => l_api_version,
                                               p_init_msg_list    => p_init_msg_list,
                                               x_return_status    => x_return_status,
                                               x_msg_count        => x_msg_count,
                                               x_msg_data         => x_msg_data,
                                               p_tclv_rec         => p_tclv_rec);

Line: 983


PROCEDURE delete_trx_cntrct_lines(p_api_version         IN  NUMBER,
                                  p_init_msg_list       IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
                                  x_return_status       OUT NOCOPY VARCHAR2,
                                  x_msg_count           OUT NOCOPY NUMBER,
                                  x_msg_data            OUT NOCOPY VARCHAR2,
                                  p_tclv_tbl            IN  tclv_tbl_type)
IS
l_api_version  NUMBER := 1.0;

Line: 994


 OKL_TRX_CONTRACTS_PUB.delete_trx_cntrct_lines(p_api_version      => l_api_version,
                                               p_init_msg_list    => p_init_msg_list,
                                               x_return_status    => x_return_status,
                                               x_msg_count        => x_msg_count,
                                               x_msg_data         => x_msg_data,
                                               p_tclv_tbl         => p_tclv_tbl );