APPS.CSI_T_TXN_RLTNSHPS_GRP SQL Statements

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

Line: 176

  PROCEDURE update_txn_ii_rltns_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_ii_rltns_tbl       IN  csi_t_datastructures_grp.txn_ii_rltns_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_ii_rltns_dtls';

Line: 199

    SAVEPOINT update_txn_ii_rltns_dtls;

Line: 201

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

Line: 242

    csi_t_txn_rltnshps_pvt.update_txn_ii_rltns_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_ii_rltns_tbl => p_txn_ii_rltns_tbl,
      x_return_status    => l_return_status,
      x_msg_count        => l_msg_count,
      x_msg_data         => l_msg_data);

Line: 272

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

Line: 280

      ROLLBACK TO update_txn_ii_rltns_dtls;

Line: 288

      ROLLBACK TO update_txn_ii_rltns_dtls;

Line: 297

      ROLLBACK TO update_txn_ii_rltns_dtls;

Line: 313

  END update_txn_ii_rltns_dtls;

Line: 317

  PROCEDURE delete_txn_ii_rltns_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_ii_rltns_ids_tbl   IN  csi_t_datastructures_grp.txn_ii_rltns_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_ii_rltns_dtls';

Line: 340

    SAVEPOINT Delete_Inst_Reltship_Dtls;

Line: 342

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

Line: 383

    csi_t_txn_rltnshps_pvt.delete_txn_ii_rltns_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_ii_rltns_ids_tbl => p_txn_ii_rltns_ids_tbl,
      x_return_status        => l_return_status,
      x_msg_count            => l_msg_count,
      x_msg_data             => l_msg_data);

Line: 414

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

Line: 422

      ROLLBACK TO Delete_Inst_Reltship_Dtls;

Line: 430

      ROLLBACK TO Delete_Inst_Reltship_Dtls;

Line: 439

      ROLLBACK TO Delete_Inst_Reltship_Dtls;

Line: 455

  END delete_txn_ii_rltns_dtls;