APPS.CSI_SYSTEMS_PUB SQL Statements

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

Line: 328

PROCEDURE update_system(
    p_api_version                IN     NUMBER,
    p_commit                     IN     VARCHAR2,
    p_init_msg_list              IN     VARCHAR2,
    p_validation_level           IN     NUMBER,
    p_system_rec                 IN     csi_datastructures_pub.system_rec,
    p_txn_rec                    IN OUT NOCOPY csi_datastructures_pub.transaction_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_system';

Line: 350

      SAVEPOINT update_system_pub;

Line: 380

          CSI_gen_utility_pvt.put_line( 'update_system');

Line: 405

    csi_systems_pvt.update_system(
        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_system_rec                 => p_system_rec,
        p_txn_rec                    => p_txn_rec,
        x_return_status              => x_return_status,
        x_msg_count                  => x_msg_count,
        x_msg_data                   => x_msg_data
        );

Line: 451

                ROLLBACK TO update_system_pub;

Line: 459

                ROLLBACK TO update_system_pub;

Line: 467

                ROLLBACK TO update_system_pub;

Line: 476

END update_system;

Line: 532

          CSI_gen_utility_pvt.put_line( 'update_system');