DBA Data[Home] [Help]

APPS.PN_VAR_RENT_PUB SQL Statements

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

Line: 657

   PROCEDURE update_var_rent (
      p_api_version              IN       NUMBER
    , p_init_msg_list            IN       VARCHAR2 DEFAULT fnd_api.g_false
    , p_commit                   IN       VARCHAR2 DEFAULT fnd_api.g_false
    , p_validate_flag            IN       VARCHAR2 DEFAULT 'Y'
    , p_upd_var_rent_rec         IN OUT NOCOPY pn_varen_pvt.upd_var_rent_rec_type
    , p_var_rent_lines_tbl       IN OUT NOCOPY pn_varen_pvt.variable_rent_lines_tbl_type
    , p_breakpoint_header_tbl    IN OUT NOCOPY pn_varen_pvt.breakpoint_header_tbl_type
    , p_breakpoint_details_tbl   IN OUT NOCOPY pn_varen_pvt.breakpoint_details_tbl_type
    , p_constraints_tbl          IN OUT NOCOPY pn_varen_pvt.constraints_tbl_type
    , p_allow_abat_tbl           IN OUT NOCOPY pn_varen_pvt.allow_abat_tbl_type
    , p_undo_periods             IN       VARCHAR2 DEFAULT 'N'
    , p_undo_breakpoints         IN       VARCHAR2 DEFAULT 'N'
    , p_undo_constraints         IN       VARCHAR2 DEFAULT 'N'
    , 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_Var_Rent';
Line: 683

      SAVEPOINT update_var_rent;
Line: 733

                                  || 'Start of Update Variable Rent package'
                                , 3
                                 );
Line: 738

         pn_varen_pvt.update_var_rent (p_api_version                 => 1.0
                                     , p_init_msg_list               => fnd_api.g_false
                                     , p_commit                      => fnd_api.g_false
                                     , p_validate_flag               => p_validate_flag
                                     , p_upd_var_rent_rec            => p_upd_var_rent_rec
                                     , p_var_rent_lines_tbl          => p_var_rent_lines_tbl
                                     , p_breakpoint_header_tbl       => p_breakpoint_header_tbl
                                     , p_breakpoint_details_tbl      => p_breakpoint_details_tbl
                                     , p_constraints_tbl             => p_constraints_tbl
                                     , p_allow_abat_tbl              => p_allow_abat_tbl
                                     , p_undo_periods                => p_undo_periods
                                     , p_undo_breakpoints            => p_undo_breakpoints
                                     , p_undo_constraints            => p_undo_constraints
                                     , x_return_status               => x_return_status
                                     , x_msg_count                   => x_msg_count
                                     , x_msg_data                    => x_msg_data
                                      );
Line: 849

   END update_var_rent;