eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_T_TXN_SYSTEMS_PVT SQL Statements

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

Line: 42


      SELECT 'x'
      FROM   csi_t_txn_systems txn, csi_systems_vl sys
      WHERE  txn.system_name = p_system_name
      AND    txn.customer_id = p_Customer_ID
      AND   (txn.system_number IS NULL OR
             txn.system_number = p_System_number)
      OR     sys.name = p_system_name
      AND    sys.customer_id = p_Customer_ID
      AND   (sys.system_number IS NULL OR
             sys.system_number = p_System_number);

Line: 54


      SELECT 'x'
      FROM   csi_t_txn_systems txn, csi_systems_vl sys
      WHERE  txn.system_name = p_system_name
      AND    txn.customer_id = p_Customer_ID
      AND   (txn.system_number IS NULL OR
             txn.system_number = p_System_number)
      AND    txn.transaction_line_id =p_txn_line_id
      OR     sys.name = p_system_name
      AND    sys.customer_id = p_Customer_ID
      AND   (sys.system_number IS NULL OR
             sys.system_number = p_System_number);

Line: 71


      SELECT 'Y'
      INTO l_dummy
      FROM   csi_systems_vl sys
      WHERE  sys.name = p_system_name
      AND    sys.customer_id = p_Customer_ID
      AND   (sys.system_number IS NULL OR
             sys.system_number = p_System_number);

Line: 112


       SELECT 'Y'
       INTO l_dummy
       FROM   csi_t_txn_systems txn
       WHERE  txn.system_name = p_system_name
       AND    txn.customer_id = p_Customer_ID
       AND   (txn.system_number IS NULL OR
              txn.system_number = p_System_number);

Line: 120


       SELECT 'Y'
       INTO l_dummy
       FROM   csi_t_txn_systems txn
       WHERE  txn.system_name = p_system_name
       AND    txn.customer_id = p_Customer_ID
       AND    txn.transaction_line_id =p_txn_line_id
       AND   (txn.system_number IS NULL OR
              txn.system_number = p_System_number);

Line: 272


              csi_t_txn_systems_pkg.insert_row(
            px_transaction_system_id      =>  x_txn_system_id,
            p_transaction_line_id         =>  p_txn_system_rec.transaction_line_id,
            p_system_name                 =>  p_txn_system_rec.system_name,
            p_description                 =>  p_txn_system_rec.description,
            p_system_type_code            =>  p_txn_system_rec.system_type_code,
            p_system_number               =>  p_txn_system_rec.system_number,
            p_customer_id                 =>  p_txn_system_rec.customer_id,
            p_bill_to_contact_id          =>  p_txn_system_rec.bill_to_contact_id,
            p_ship_to_contact_id          =>  p_txn_system_rec.ship_to_contact_id,
            p_technical_contact_id        =>  p_txn_system_rec.technical_contact_id,
            p_service_admin_contact_id    =>  p_txn_system_rec.service_admin_contact_id,
            p_ship_to_site_use_id         =>  p_txn_system_rec.ship_to_site_use_id,
            p_bill_to_site_use_id         =>  p_txn_system_rec.bill_to_site_use_id,
            p_install_site_use_id         =>  p_txn_system_rec.install_site_use_id,
            p_coterminate_day_month       =>  p_txn_system_rec.coterminate_day_month,
            p_config_system_type          =>  p_txn_system_rec.config_system_type,
            p_start_date_active           =>  l_start_date,
            p_end_date_active             =>  p_txn_system_rec.end_date_active,
            p_context                     =>  p_txn_system_rec.context,
            p_attribute1                  =>  p_txn_system_rec.attribute1,
            p_attribute2                  =>  p_txn_system_rec.attribute2,
            p_attribute3                  =>  p_txn_system_rec.attribute3,
            p_attribute4                  =>  p_txn_system_rec.attribute4,
            p_attribute5                  =>  p_txn_system_rec.attribute5,
            p_attribute6                  =>  p_txn_system_rec.attribute6,
            p_attribute7                  =>  p_txn_system_rec.attribute7,
            p_attribute8                  =>  p_txn_system_rec.attribute8,
            p_attribute9                  =>  p_txn_system_rec.attribute9,
            p_attribute10                 =>  p_txn_system_rec.attribute10,
            p_attribute11                 =>  p_txn_system_rec.attribute11,
            p_attribute12                 =>  p_txn_system_rec.attribute12,
            p_attribute13                 =>  p_txn_system_rec.attribute13,
            p_attribute14                 =>  p_txn_system_rec.attribute14,
            p_attribute15                 =>  p_txn_system_rec.attribute15,
            p_created_by                  =>  fnd_global.user_id,
            p_creation_date               =>  SYSDATE,
            p_last_updated_by             =>  fnd_global.user_id,
            p_last_update_date            =>  SYSDATE,
            p_last_update_login           =>  fnd_global.conc_login_id,
            p_object_version_number       =>  1
            );

Line: 374


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
CURSOR  txn_sys_csr (sys_id NUMBER) IS
     SELECT customer_id
           ,object_version_number
           ,start_date_active
           ,end_date_active
     FROM   csi_t_txn_systems
     WHERE  transaction_system_id=sys_id
     FOR UPDATE NOWAIT;

Line: 394


l_api_name                CONSTANT VARCHAR2(30) := 'update_txn_system';

Line: 407


      SAVEPOINT update_txn_system_pvt;

Line: 467


               fnd_message.set_name('CSI', 'CSI_CANT_UPDATE_EXPIRED_SYS');

Line: 479


                            ,p_validation_mode   => 'UPDATE'
                            ,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: 500


          p_validation_mode  => 'UPDATE',
          p_system_rec       => l_system_rec,
          x_return_status    => x_return_status,
          x_msg_count        => x_msg_count,
          x_msg_data         => x_msg_data);

Line: 536


       csi_t_txn_systems_pkg.update_row(
            p_transaction_system_id       =>  p_txn_system_rec.transaction_system_id,
            p_transaction_line_id         =>  p_txn_system_rec.transaction_line_id,
            p_system_name                 =>  p_txn_system_rec.system_name,
            p_description                 =>  p_txn_system_rec.description,
            p_system_type_code            =>  p_txn_system_rec.system_type_code,
            p_system_number               =>  p_txn_system_rec.system_number,
            p_customer_id                 =>  p_txn_system_rec.customer_id,
            p_bill_to_contact_id          =>  p_txn_system_rec.bill_to_contact_id,
            p_ship_to_contact_id          =>  p_txn_system_rec.ship_to_contact_id,
            p_technical_contact_id        =>  p_txn_system_rec.technical_contact_id,
            p_service_admin_contact_id    =>  p_txn_system_rec.service_admin_contact_id,
            p_ship_to_site_use_id         =>  p_txn_system_rec.ship_to_site_use_id,
            p_bill_to_site_use_id         =>  p_txn_system_rec.bill_to_site_use_id,
            p_install_site_use_id         =>  p_txn_system_rec.install_site_use_id,
            p_coterminate_day_month       =>  p_txn_system_rec.coterminate_day_month,
            p_config_system_type          =>  p_txn_system_rec.config_system_type,
            p_start_date_active           =>  p_txn_system_rec.start_date_active,
            p_end_date_active             =>  p_txn_system_rec.end_date_active,
            p_context                     =>  p_txn_system_rec.context,
            p_attribute1                  =>  p_txn_system_rec.attribute1,
            p_attribute2                  =>  p_txn_system_rec.attribute2,
            p_attribute3                  =>  p_txn_system_rec.attribute3,
            p_attribute4                  =>  p_txn_system_rec.attribute4,
            p_attribute5                  =>  p_txn_system_rec.attribute5,
            p_attribute6                  =>  p_txn_system_rec.attribute6,
            p_attribute7                  =>  p_txn_system_rec.attribute7,
            p_attribute8                  =>  p_txn_system_rec.attribute8,
            p_attribute9                  =>  p_txn_system_rec.attribute9,
            p_attribute10                 =>  p_txn_system_rec.attribute10,
            p_attribute11                 =>  p_txn_system_rec.attribute11,
            p_attribute12                 =>  p_txn_system_rec.attribute12,
            p_attribute13                 =>  p_txn_system_rec.attribute13,
            p_attribute14                 =>  p_txn_system_rec.attribute14,
            p_attribute15                 =>  p_txn_system_rec.attribute15,
            p_created_by                  =>  fnd_global.user_id,
            p_creation_date               =>  SYSDATE,
            p_last_updated_by             =>  fnd_global.user_id,
            p_last_update_date            =>  SYSDATE,
            p_last_update_login           =>  fnd_global.conc_login_id,
            p_object_version_number       =>  p_txn_system_rec.object_version_number
            );

Line: 597


                ROLLBACK TO update_txn_system_pvt;

Line: 605


                ROLLBACK TO update_txn_system_pvt;

Line: 613


                ROLLBACK TO update_txn_system_pvt;

Line: 623


END update_txn_system;

Line: 625


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_version_number      CONSTANT NUMBER   := 1.0;

Line: 637


l_api_name                CONSTANT VARCHAR2(30) := 'delete_txn_system';

Line: 644


      SAVEPOINT delete_txn_system_pvt;

Line: 680


                              ,p_validation_mode   => 'DELETE'
                              ,p_txn_system_rec    => l_txn_system_rec
                              ,x_return_status     => x_return_status
                              ,x_msg_count         => x_msg_count
                              ,x_msg_data          => x_msg_data
                             );

Line: 693


                        csi_t_txn_systems_pkg.Delete_Row(p_txn_system_id );

Line: 711


                ROLLBACK TO delete_txn_system_pvt;

Line: 719


                ROLLBACK TO delete_txn_system_pvt;

Line: 727


                ROLLBACK TO delete_txn_system_pvt;

Line: 736


 END delete_txn_system;

Line: 760


                SELECT  'x'
                INTO    l_dummy
                FROM    csi_t_txn_systems
                WHERE   transaction_system_id=p_txn_system_id;

Line: 773


       ELSIF p_validation_mode='UPDATE' OR  p_validation_mode='DELETE' THEN
         IF ( (p_txn_system_id IS NOT NULL) AND (p_txn_system_id<>fnd_api.g_miss_num) ) THEN
                BEGIN
                SELECT  'x'
                INTO    l_dummy
                FROM    csi_t_txn_systems
                WHERE   transaction_system_id=p_txn_system_id;

Line: 819


       IF(p_validation_mode = 'UPDATE') THEN
          IF ( (p_object_version_number IS NULL) OR (p_object_version_number = fnd_api.g_miss_num) ) THEN
             fnd_message.set_name('CSI', 'CSI_MISSING_OBJ_VER_NUM');

Line: 899


      IF ( (p_validation_mode='CREATE') OR (p_validation_mode='UPDATE') ) THEN
          IF (p_end_date = FND_API.G_MISS_DATE) THEN
                 l_end_date := NULL;