APPS.CSI_PRICING_ATTRIBS_PUB SQL Statements

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

Line: 33

    l_select_stmt             VARCHAR2(20000) := 'SELECT * FROM csi_i_pricing_attribs  ';

Line: 110

       l_select_stmt := l_select_stmt || ' where '||l_where_clause;

Line: 116

       dbms_sql.parse(l_cur_get_pri, l_select_stmt , dbms_sql.native);

Line: 405

/* procedure name: update_pricing_attribs               */
/* description :  Updates the existing pricing          */
/*                attributes for an item instance       */
/*                                                      */
/*------------------------------------------------------*/


PROCEDURE update_pricing_attribs
 (    p_api_version             IN     NUMBER
     ,p_commit                  IN     VARCHAR2
     ,p_init_msg_list           IN     VARCHAR2
     ,p_validation_level        IN     NUMBER
     ,p_pricing_attribs_tbl     IN     csi_datastructures_pub.pricing_attribs_tbl
     ,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_PRICING_ATTRIBS';

Line: 435

    SAVEPOINT    update_pricing_attribs;

Line: 468

        csi_gen_utility_pvt.put_line( 'update_pricing_attribs');

Line: 495

              csi_pricing_attribs_pvt.update_pricing_attribs
              ( 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_pricing_attribs_rec  => p_pricing_attribs_tbl(tab_row)
               ,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: 516

                     csi_gen_utility_pvt.put_line( ' Failed Pub:update_pricing_attribs..');

Line: 552

        ROLLBACK TO update_pricing_attribs;

Line: 560

        ROLLBACK TO update_pricing_attribs;

Line: 568

        ROLLBACK TO  update_pricing_attribs;

Line: 585

END update_pricing_attribs;