APPS.AHL_LTP_SIMUL_PLAN_PUB SQL Statements

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

Line: 112

         AHL_LTP_SIMUL_PLAN_PVT.UPDATE_SIMULATION_PLAN
           (
            p_api_version             => l_api_version,
            p_init_msg_list           => p_init_msg_list,
            p_commit                  => p_commit,
            p_validation_level        => p_validation_level,
            p_module_type             => p_module_type,
            p_simulation_plan_rec     => p_x_simulation_plan_tbl(i),
            x_return_status           => l_return_status,
            x_msg_count               => l_msg_count,
            x_msg_data                => l_msg_data
          );

Line: 134

         AHL_LTP_SIMUL_PLAN_PVT.DELETE_SIMULATION_PLAN
           (
            p_api_version             => l_api_version,
            p_init_msg_list           => p_init_msg_list,
            p_commit                  => p_commit,
            p_validation_level        => p_validation_level,
            p_simulation_plan_rec     => p_x_simulation_plan_tbl(i),
            x_return_status           => l_return_status,
            x_msg_count               => l_msg_count,
            x_msg_data                => l_msg_data
          );

Line: 512

PROCEDURE Toggle_Simulation_Delete (
   p_api_version             IN      NUMBER,
   p_init_msg_list           IN      VARCHAR2  := FND_API.g_false,
   p_commit                  IN      VARCHAR2  := FND_API.g_false,
   p_validation_level        IN      NUMBER    := FND_API.g_valid_level_full,
   p_module_type             IN      VARCHAR2  := 'JSP',
   p_visit_id                      IN      NUMBER,
   p_visit_object_version_number   IN      NUMBER,
   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) := 'TOGGLE_SIMULATION_DELETE';

Line: 535

  SAVEPOINT toggle_simulation_delete;

Line: 542

       AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pub.Toggle Simulation Delete','+SMPLN+');

Line: 560

       AHL_LTP_SIMUL_PLAN_PVT.Toggle_Simulation_Delete (
               p_api_version  => p_api_version,
               p_init_msg_list => p_init_msg_list,
               p_commit        => p_commit,
               p_validation_level  => p_validation_level,
               p_module_type      => p_module_type,
               p_visit_id         => p_visit_id,
               p_visit_object_version_number  => p_visit_object_version_number,
               x_return_status        => l_return_status,
               x_msg_count            => l_msg_count,
               x_msg_data             => l_msg_data);

Line: 589

   Ahl_Debug_Pub.debug( 'End of public api Toggle Simulation Delete','+SMPLN+');

Line: 596

    ROLLBACK TO toggle_simulation_delete;

Line: 605

            AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Toggle Simulation Delete','+SMPLN+');

Line: 611

    ROLLBACK TO toggle_simulation_delete;

Line: 620

            AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Toggle Simulation Delete','+SMPLN+');

Line: 626

    ROLLBACK TO toggle_simulation_delete;

Line: 631

                            p_procedure_name  =>  'TOGGLE_SIMULATION_DELETE',
                            p_error_text      => SUBSTR(SQLERRM,1,240));

Line: 642

            AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Toggle Simulation Delete','+SMPLN+');

Line: 647

 END Toggle_Simulation_Delete;