APPS.CSI_T_TXN_OUS_GRP SQL Statements

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

Line: 167

  PROCEDURE update_txn_org_assgn_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_org_assgn_tbl      IN  csi_t_datastructures_grp.txn_org_assgn_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_Org_Assgn_Dtls';

Line: 191

    SAVEPOINT Update_Txn_Org_Assgn_Dtls;

Line: 193

    csi_t_gen_utility_pvt.add('API Being Executed     : Update Txn Org Assignments');

Line: 234

    csi_t_txn_ous_pvt.update_txn_org_assgn_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_org_assgn_tbl    => p_txn_org_assgn_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 Org Assignments');

Line: 273

      ROLLBACK TO Update_Txn_Org_Assgn_Dtls;

Line: 281

      ROLLBACK TO Update_Txn_Org_Assgn_Dtls;

Line: 290

      ROLLBACK TO Update_Txn_Org_Assgn_Dtls;

Line: 306

  END update_txn_org_assgn_dtls;

Line: 309

  PROCEDURE delete_txn_org_assgn_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_org_assgn_ids_tbl IN  csi_t_datastructures_grp.txn_org_assgn_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_org_assgn_dtls';

Line: 333

    SAVEPOINT delete_txn_org_assgn_dtls;

Line: 335

    csi_t_gen_utility_pvt.add('API Being Executed     : Delete Txn Org Assignments');

Line: 376

    csi_t_txn_ous_pvt.delete_txn_org_assgn_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_org_assgn_ids_tbl => p_txn_org_assgn_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 Org Assignments');

Line: 415

      ROLLBACK TO delete_txn_org_assgn_dtls;

Line: 423

      ROLLBACK TO delete_txn_org_assgn_dtls;

Line: 432

      ROLLBACK TO delete_txn_org_assgn_dtls;

Line: 448

  END delete_txn_org_assgn_dtls;