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.CSI_T_TXN_DETAILS_GRP SQL Statements

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

Line: 125


  SELECT a.transaction_line_id,
         a.source_transaction_id
  FROM   csi_t_transaction_lines a
  WHERE  a.source_txn_header_id = c_header_id
  AND    a.transaction_line_id = DECODE(c_line_id,fnd_api.g_miss_num, a.transaction_line_id,NULL, a.transaction_line_id, c_line_id);

Line: 697


     This procedure is used to update the transaction line details.
  */
  PROCEDURE update_txn_line_dtls(
     p_api_version            IN  NUMBER
    ,p_commit                 IN  VARCHAR2 := fnd_api.g_false
    ,p_init_msg_list          IN  VARCHAR2 := fnd_api.g_false
    ,p_validation_level       IN  NUMBER   := fnd_api.g_valid_level_full
    ,p_txn_line_rec           IN  csi_t_datastructures_grp.txn_line_rec
    ,p_txn_line_detail_tbl    IN  csi_t_datastructures_grp.txn_line_detail_tbl
    ,px_txn_ii_rltns_tbl  IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
    ,px_txn_party_detail_tbl     IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
    ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
    ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
    ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
    ,x_return_status          OUT NOCOPY VARCHAR2
    ,x_msg_count              OUT NOCOPY NUMBER
    ,x_msg_data               OUT NOCOPY VARCHAR2
  )

  IS

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

Line: 729


    SAVEPOINT update_txn_line_dtls;

Line: 731


    csi_t_gen_utility_pvt.add('API Being Executed     : Update Transaction Details');

Line: 783


    csi_t_txn_line_dtls_pvt.update_txn_line_dtls(
      p_api_version              => p_api_version,
      p_commit                   => fnd_api.g_false,
      p_init_msg_list            => p_init_msg_list,
      p_validation_level         => p_validation_level,
      p_txn_line_rec             => p_txn_line_rec,
      p_txn_line_detail_tbl      => p_txn_line_detail_tbl,
      px_txn_ii_rltns_tbl        => px_txn_ii_rltns_tbl,
      px_txn_party_detail_tbl    => px_txn_party_detail_tbl,
      px_txn_pty_acct_detail_tbl => px_txn_pty_acct_detail_tbl,
      px_txn_org_assgn_tbl       => px_txn_org_assgn_tbl,
      px_txn_ext_attrib_vals_tbl => px_txn_ext_attrib_vals_tbl,
      x_return_status            => l_return_status,
      x_msg_count                => l_msg_count,
      x_msg_data                 => l_msg_data);

Line: 822


    csi_t_gen_utility_pvt.add('API Executed         : Update Transaction Details');

Line: 830


      ROLLBACK TO Update_Txn_Line_Dtls;

Line: 841


      ROLLBACK TO Update_Txn_Line_Dtls;

Line: 853


      ROLLBACK TO Update_Txn_Line_Dtls;

Line: 872


  END update_txn_line_dtls;

Line: 876


  PROCEDURE delete_transaction_dtls
  (
     p_api_version            IN  NUMBER
    ,p_commit                 IN  VARCHAR2 := fnd_api.g_false
    ,p_init_msg_list          IN  VARCHAR2 := fnd_api.g_false
    ,p_validation_level       IN  NUMBER   := fnd_api.g_valid_level_full
    ,p_transaction_line_id    IN  NUMBER
    ,p_api_caller_identity    IN  VARCHAR2
    ,x_return_status          OUT NOCOPY VARCHAR2
    ,x_msg_count              OUT NOCOPY NUMBER
    ,x_msg_data               OUT NOCOPY VARCHAR2
  )
  IS

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

Line: 902


SELECT config_session_hdr_id
FROM   csi_t_transaction_lines
WHERE  transaction_line_id = p_transaction_line_id ;

Line: 909


    SAVEPOINT Delete_Transaction_Dtls;

Line: 912


    csi_t_gen_utility_pvt.add('API Being Executed     : Delete Transaction Details');

Line: 972


    csi_t_txn_details_pvt.delete_transaction_dtls(
      p_api_version         => p_api_version,
      p_commit              => p_commit,
      p_init_msg_list       => p_init_msg_list,
      p_validation_level    => l_validation_level,
      p_transaction_line_id => p_transaction_line_id,
      p_txn_line_detail_id  => null,
      x_return_status       => l_return_status,
      x_msg_count           => l_msg_count,
      x_msg_data            => l_msg_data);

Line: 1006


    csi_t_gen_utility_pvt.add('API Executed         : Delete Transaction Details');

Line: 1014


      ROLLBACK TO Delete_Transaction_Dtls;

Line: 1024


      ROLLBACK TO Delete_Transaction_Dtls;

Line: 1035


      ROLLBACK TO Delete_Transaction_Dtls;

Line: 1053


  END delete_transaction_dtls;

Line: 1219


  PROCEDURE update_transaction_dtls(
     p_api_version              IN  NUMBER
    ,p_commit                   IN  VARCHAR2 := fnd_api.g_false
    ,p_init_msg_list            IN  VARCHAR2 := fnd_api.g_false
    ,p_validation_level         IN  NUMBER   := fnd_api.g_valid_level_full
    ,p_txn_line_rec             IN  csi_t_datastructures_grp.txn_line_rec
    ,px_txn_line_detail_tbl     IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
    ,px_txn_ii_rltns_tbl        IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
    ,px_txn_party_detail_tbl    IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
    ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
    ,px_txn_org_assgn_tbl       IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
    ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
    ,x_return_status            OUT NOCOPY VARCHAR2
    ,x_msg_count                OUT NOCOPY NUMBER
    ,x_msg_data                 OUT NOCOPY VARCHAR2
  )
  IS

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

Line: 1248


    SAVEPOINT update_transaction_dtls;

Line: 1250


    csi_t_gen_utility_pvt.add('API Being Executed     : Update Transaction Details');

Line: 1301


    csi_t_txn_details_pvt.update_transaction_dtls(
      p_api_version              => p_api_version,
      p_commit                   => fnd_api.g_false,
      p_init_msg_list            => p_init_msg_list,
      p_validation_level         => p_validation_level,
      p_txn_line_rec             => p_txn_line_rec,
      px_txn_line_detail_tbl     => px_txn_line_detail_tbl,
      px_txn_ii_rltns_tbl        => px_txn_ii_rltns_tbl,
      px_txn_party_detail_tbl    => px_txn_party_detail_tbl,
      px_txn_pty_acct_detail_tbl => px_txn_pty_acct_detail_tbl,
      px_txn_org_assgn_tbl       => px_txn_org_assgn_tbl,
      px_txn_ext_attrib_vals_tbl => px_txn_ext_attrib_vals_tbl,
      x_return_status            => l_return_status,
      x_msg_count                => l_msg_count,
      x_msg_data                 => l_msg_data);

Line: 1333


    csi_t_gen_utility_pvt.add('API Executed         : Update Transaction Details');

Line: 1341


      ROLLBACK TO update_transaction_dtls;

Line: 1352


      ROLLBACK TO update_transaction_dtls;

Line: 1364


      ROLLBACK TO update_transaction_dtls;

Line: 1383


  END update_transaction_dtls;