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: 352

    SELECT SYSTEM_ID child_system_id
      FROM CSI_SYSTEMS_B
      WHERE PARENT_SYSTEM_ID = p_parent_system_id;           -- Bug 10631752

Line: 358

     SELECT SYSTEM_ID,
            SYSTEM_TYPE_CODE,
            SYSTEM_NUMBER,
            PARENT_SYSTEM_ID,
            START_DATE_ACTIVE,
            END_DATE_ACTIVE,
            COTERMINATE_DAY_MONTH,
            AUTOCREATED_FROM_SYSTEM_ID,
            CONFIG_SYSTEM_TYPE,
            CONTEXT,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            OBJECT_VERSION_NUMBER,
		    OPERATING_UNIT_ID
     FROM   CSI_SYSTEMS_B
     WHERE  SYSTEM_ID = p_child_sys_id;

Line: 390

      SELECT NAME,
           DESCRIPTION
        FROM   CSI_SYSTEMS_TL
        WHERE  SYSTEM_ID = p_child_sys_id;

Line: 400

      SAVEPOINT update_system_pub;

Line: 430

          CSI_gen_utility_pvt.put_line( 'update_system');

Line: 455

    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: 545

            l_child_system_rec.PROGRAM_UPDATE_DATE        	    :=	p_system_rec.PROGRAM_UPDATE_DATE        ;

Line: 630

            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                 => l_child_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: 677

                ROLLBACK TO update_system_pub;

Line: 685

                ROLLBACK TO update_system_pub;

Line: 693

                ROLLBACK TO update_system_pub;

Line: 702

END update_system;

Line: 758

          CSI_gen_utility_pvt.put_line( 'update_system');