APPS.PN_INDEX_RENT_PUB SQL Statements

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

Line: 316

       PROCEDURE UPDATE_INDEX_RENT(
          p_api_version              IN            NUMBER
        , p_init_msg_list            IN            VARCHAR2 := fnd_api.g_false
        , p_commit                   IN            VARCHAR2 := fnd_api.g_false
        , p_validate                 IN            VARCHAR2 := fnd_api.g_false
        , p_rent_index_rec           IN OUT NOCOPY PN_INDEX_RENT_PVT.rent_index_rec
        , p_index_constraint_tbl     IN OUT NOCOPY PN_INDEX_RENT_PVT.index_constraint_tbl
        , x_return_status               OUT NOCOPY VARCHAR2
        , x_msg_count                   OUT NOCOPY NUMBER
        , x_msg_data                    OUT NOCOPY VARCHAR2
       )
       AS
          l_api_version                  CONSTANT NUMBER := 1.0;

Line: 329

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

Line: 334

          l_func_name                    CONSTANT VARCHAR2 (100) := 'PN_INDEX_RENT_PVT.UPDATE_INDEX_RENT';

Line: 338

          SAVEPOINT UPDATE_INDEX_RENT;

Line: 418

     Verifying whether the UPDATE INDEX RENT exists or not.
     ************************************************************/
      IF fnd_function.TEST (function_name                 => l_func_name)
      THEN
         l_func_exists                                  := 'Y';

Line: 434

                PN_INDEX_RENT_PVT.UPDATE_INDEX_RENT
                  (p_api_version                 => p_api_version
                 , p_init_msg_list               => p_init_msg_list
                 , p_commit                      => p_commit
                 , p_validate                    => p_validate
                 , p_rent_index_rec              => p_rent_index_rec
                 , p_index_constraint_tbl        => p_index_constraint_tbl
                 , x_return_status               => x_return_status
                 , x_msg_count                   => x_msg_count
                 , x_msg_data                    => x_msg_data
                   );

Line: 465

                 pn_index_rent_pvt.debug (   'PN_INDEX_RENT_PUB: Update_Index_Rent Exception : '
                                             || SQLERRM
                                            , 3
                                              );

Line: 469

                pn_index_rent_pvt.debug (   'PN_INDEX_RENT_PUB: Update_Index_Rent Return Status : '
                                             || x_return_status
                                            , 3
                                              );

Line: 473

                pn_index_rent_pvt.debug (   'PN_INDEX_RENT_PUB: Update_Index_Rent No of Error Messages : '
                                             || x_msg_count
                                            , 3
                                              );

Line: 485

                pn_index_rent_pvt.debug (   'PN_INDEX_RENT_PUB: Update_Index_Rent Unexpected Exception : '
                                         || SQLERRM
                                         , 3
                                            );

Line: 489

                pn_index_rent_pvt.debug (   'PN_INDEX_RENT_PUB: Update_Index_Rent Return Status : '
                                         || x_return_status
                                         , 3
                                           );

Line: 493

                pn_index_rent_pvt.debug (   'PN_INDEX_RENT_PUB: Update_Index_Rent No of Error Messages : '
                                         || x_msg_count
                                         , 3
                                           );

Line: 504

                pn_index_rent_pvt.debug (   'PN_INDEX_RENT_PUB: Update_Index_Rent Others Exception : '
                                           || SQLERRM
                                           , 3
                                            );

Line: 508

                pn_index_rent_pvt.debug (   'PN_INDEX_RENT_PUB: Update_Index_Rent Return Status : '
                                           || x_return_status
                                           , 3
                                          );

Line: 512

                pn_index_rent_pvt.debug (   'PN_INDEX_RENT_PUB: Update_Index_Rent No of Error Messages : '
                                           || x_msg_count
                                           , 3
                                          );

Line: 517

       END UPDATE_INDEX_RENT;