DBA Data[Home] [Help]

APPS.CSI_T_TXN_PARTIES_GRP SQL Statements

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

Line: 178

               update csi_t_party_details
               set    contact_party_id    = l_contact_party_id
               where  txn_party_detail_id = px_txn_party_detail_tbl(cont_ind).txn_party_detail_id;
Line: 403

  PROCEDURE update_txn_party_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_party_detail_tbl   IN  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
    ,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_Party_Dtls';
Line: 427

    SAVEPOINT Update_Txn_Party_Dtls;
Line: 429

    csi_t_gen_utility_pvt.add('API Being Executed     : Update Txn Party And Accounts');
Line: 470

    csi_t_txn_parties_pvt.update_txn_party_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_party_detail_tbl     => p_txn_party_detail_tbl,
     px_txn_pty_acct_detail_tbl => px_txn_pty_acct_detail_tbl,
     x_return_status            => l_return_status,
     x_msg_count                => l_msg_count,
     x_msg_data                 => l_msg_data);
Line: 502

    csi_t_gen_utility_pvt.add('API Successfully Executed         : Update Txn Party And Accounts');
Line: 510

      ROLLBACK TO Update_Txn_Party_Dtls;
Line: 518

      ROLLBACK TO Update_Txn_Party_Dtls;
Line: 527

      ROLLBACK TO Update_Txn_Party_Dtls;
Line: 543

  END update_txn_party_dtls;
Line: 547

  PROCEDURE update_txn_pty_acct_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_pty_acct_detail_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_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_Party_acct_Dtls';
Line: 572

    SAVEPOINT Update_Txn_Party_acct_Dtls;
Line: 574

    csi_t_gen_utility_pvt.add('API Being Executed     : Update Txn Party Accounts');
Line: 615

    csi_t_txn_parties_pvt.update_txn_pty_acct_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_pty_acct_detail_tbl => p_txn_pty_acct_detail_tbl,
      x_return_status           => l_return_status,
      x_msg_count               => l_msg_count,
      x_msg_data                => l_msg_data);
Line: 646

    csi_t_gen_utility_pvt.add('API Successfully Executed         : Update Txn Party Accounts');
Line: 654

      ROLLBACK TO update_txn_party_acct_Dtls;
Line: 662

      ROLLBACK TO Update_Txn_Party_acct_Dtls;
Line: 671

      ROLLBACK TO Update_Txn_Party_acct_Dtls;
Line: 686

  END update_txn_pty_acct_dtls;
Line: 688

  /* deletes the party entity for the given party detail id */
  PROCEDURE delete_txn_party_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_party_ids_tbl      IN  csi_t_datastructures_grp.txn_party_ids_tbl
    ,x_txn_pty_acct_ids_tbl   OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_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_party_dtls';
Line: 712

    SAVEPOINT delete_txn_party_dtls;
Line: 714

    csi_t_gen_utility_pvt.add('API Being Executed     : Delete Txn Party and acounts');
Line: 755

    csi_t_txn_parties_pvt.delete_txn_party_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_party_ids_tbl    => p_txn_party_ids_tbl,
      x_txn_pty_acct_ids_tbl => x_txn_pty_acct_ids_tbl,
      x_return_status        => l_return_status,
      x_msg_count            => l_msg_count,
      x_msg_data             => l_msg_data);
Line: 787

    csi_t_gen_utility_pvt.add('API Successfully Executed         : Delete Txn Party and Accounts');
Line: 795

      ROLLBACK TO delete_txn_party_dtls;
Line: 803

      ROLLBACK TO delete_txn_party_dtls;
Line: 812

      ROLLBACK TO delete_txn_party_dtls;
Line: 828

  END delete_txn_party_dtls;
Line: 830

  /* deletes the party accounts entity based on the party account id */
  PROCEDURE delete_txn_pty_acct_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_pty_acct_ids_tbl IN  csi_t_datastructures_grp.txn_pty_acct_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_party_acct_dtls';
Line: 853

    SAVEPOINT delete_txn_party_acct_dtls;
Line: 855

    csi_t_gen_utility_pvt.add('API Being Executed     : delete Txn Party Accounts');
Line: 896

    csi_t_txn_parties_pvt.delete_txn_pty_acct_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_pty_acct_ids_tbl => p_txn_pty_acct_ids_tbl,
      x_return_status        => l_return_status,
      x_msg_count            => l_msg_count,
      x_msg_data             => l_msg_data);
Line: 927

    csi_t_gen_utility_pvt.add('API Successfully Executed         : Delete Txn Party Accounts');
Line: 935

      ROLLBACK TO delete_txn_party_acct_dtls;
Line: 943

      ROLLBACK TO delete_txn_party_acct_dtls;
Line: 952

      ROLLBACK TO delete_txn_party_acct_dtls;
Line: 968

  END delete_txn_pty_acct_dtls;