APPS.CSI_T_TXN_ATTRIBS_GRP SQL Statements

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

Line: 168

  PROCEDURE update_txn_ext_attrib_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_ext_attrib_vals_tbl    IN 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_Ext_Attrib_Dtls';

Line: 191

    SAVEPOINT Update_Txn_Ext_Attrib_Dtls;

Line: 193

    csi_t_gen_utility_pvt.add('API Being Executed     : Update Txn Extended Attributes');

Line: 234

    csi_t_txn_attribs_pvt.update_txn_ext_attrib_dtls(
      p_api_version             => p_api_version,
      p_commit                  => p_commit,
      p_init_msg_list           => p_init_msg_list,
      p_validation_level        => p_validation_level,
      p_txn_ext_attrib_vals_tbl => p_txn_ext_attrib_vals_tbl,
      x_return_status           => l_return_status,
      x_msg_count               => l_msg_count,
      x_msg_data                => l_msg_data);

Line: 265

    csi_t_gen_utility_pvt.add('API Successfully Executed         : Update Txn Extended Attributes');

Line: 273

      ROLLBACK TO Update_Txn_Ext_Attrib_Dtls;

Line: 281

      ROLLBACK TO Update_Txn_Ext_Attrib_Dtls;

Line: 290

      ROLLBACK TO Update_Txn_Ext_Attrib_Dtls;

Line: 306

  END update_txn_ext_attrib_dtls;

Line: 308

  PROCEDURE delete_txn_ext_attrib_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_ext_attrib_ids_tbl  IN  csi_t_datastructures_grp.
                                      txn_ext_attrib_ids_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)  := 'delete_txn_ext_attrib_dtls';

Line: 333

    SAVEPOINT delete_txn_ext_attrib_dtls;

Line: 335

    csi_t_gen_utility_pvt.add('API Being Executed     : Delete Txn Extended Attributes');

Line: 376

    csi_t_txn_attribs_pvt.delete_txn_ext_attrib_dtls(
      p_api_version            => p_api_version,
      p_commit                 => p_commit,
      p_init_msg_list          => p_init_msg_list,
      p_validation_level       => p_validation_level,
      p_txn_ext_attrib_ids_tbl => p_txn_ext_attrib_ids_tbl,
      x_return_status          => l_return_status,
      x_msg_count              => l_msg_count,
      x_msg_data               => l_msg_data);

Line: 407

    csi_t_gen_utility_pvt.add('API Successfully Executed         : Delete Txn Extended Attributes');

Line: 415

      ROLLBACK TO delete_txn_ext_attrib_dtls;

Line: 423

      ROLLBACK TO delete_txn_ext_attrib_dtls;

Line: 432

      ROLLBACK TO delete_txn_ext_attrib_dtls;

Line: 448

  END delete_txn_ext_attrib_dtls;