APPS.CSI_T_TXN_SYSTEMS_GRP SQL Statements

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

Line: 170

PROCEDURE update_txn_system(
    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_system_rec             IN     csi_t_datastructures_grp.txn_system_rec,
    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_system';

Line: 191

      SAVEPOINT update_txn_system_grp;

Line: 245

    csi_t_txn_systems_pvt.update_txn_system(
        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_system_rec             => p_txn_system_rec,
        x_return_status              => x_return_status,
        x_msg_count                  => x_msg_count,
        x_msg_data                   => x_msg_data
        );

Line: 288

                ROLLBACK TO update_txn_system_grp;

Line: 296

                ROLLBACK TO update_txn_system_grp;

Line: 304

                ROLLBACK TO update_txn_system_grp;

Line: 313

END update_txn_system;

Line: 315

PROCEDURE delete_txn_system
 (
     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_system_id               IN     NUMBER,
     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_system';

Line: 337

      SAVEPOINT delete_txn_system_grp;

Line: 389

    csi_t_txn_systems_pvt.delete_txn_system(
        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_system_id              => p_txn_system_id,
        x_return_status              => x_return_status,
        x_msg_count                  => x_msg_count,
        x_msg_data                   => x_msg_data
        );

Line: 432

                ROLLBACK TO delete_txn_system_grp;

Line: 440

                ROLLBACK TO delete_txn_system_grp;

Line: 448

                ROLLBACK TO delete_txn_system_grp;

Line: 458

 END delete_txn_system;