APPS.AMS_CAMP_SCHEDULE_PUB SQL Statements

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

Line: 45

       x_schedule_rec_pvt.last_update_date               :=  l_schedule_rec_pub.last_update_date;

Line: 46

       x_schedule_rec_pvt.last_updated_by                :=  l_schedule_rec_pub.last_updated_by ;

Line: 49

       x_schedule_rec_pvt.last_update_login              :=  l_schedule_rec_pub.last_update_login;

Line: 346

PROCEDURE Update_Camp_Schedule(
    p_api_version_number         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,
    x_return_status              OUT NOCOPY  VARCHAR2,
    x_msg_count                  OUT NOCOPY  NUMBER,
    x_msg_data                   OUT NOCOPY  VARCHAR2,

    p_schedule_rec               IN    schedule_rec_type,
    x_object_version_number      OUT NOCOPY  NUMBER
    )

 IS
L_API_NAME                  CONSTANT VARCHAR2(30) := 'Update_Camp_Schedule';

Line: 368

      SAVEPOINT UPDATE_Camp_Schedule_PUB;

Line: 390

      AMS_Camp_Schedule_CUHK.update_schedule_pre(
         l_pub_schedule_rec,
         l_return_status
      );

Line: 405

      AMS_Camp_Schedule_VUHK.update_schedule_pre(
         l_pub_schedule_rec,
         l_return_status
      );

Line: 419

    AMS_Camp_Schedule_PVT.Update_Camp_Schedule(
    p_api_version_number         => 1.0,
    p_init_msg_list              => p_init_msg_list,
    p_commit                     => p_commit,
    p_validation_level           => p_validation_level,
    x_return_status              => x_return_status,
    x_msg_count                  => x_msg_count,
    x_msg_data                   => x_msg_data,
    p_schedule_rec               => l_pvt_schedule_rec,
    x_object_version_number      => l_object_version_number );

Line: 444

      AMS_Camp_Schedule_VUHK.update_schedule_post(
         l_pub_schedule_rec,
         l_return_status
      );

Line: 459

      AMS_Camp_Schedule_CUHK.update_schedule_post(
         l_pub_schedule_rec,
         l_return_status
      );

Line: 496

     ROLLBACK TO UPDATE_Camp_Schedule_PUB;

Line: 506

     ROLLBACK TO UPDATE_Camp_Schedule_PUB;

Line: 516

     ROLLBACK TO UPDATE_Camp_Schedule_PUB;

Line: 528

End Update_Camp_Schedule;

Line: 531

PROCEDURE Delete_Camp_Schedule(
    p_api_version_number         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,
    x_return_status              OUT NOCOPY  VARCHAR2,
    x_msg_count                  OUT NOCOPY  NUMBER,
    x_msg_data                   OUT NOCOPY  VARCHAR2,
    p_schedule_id                   IN  NUMBER,
    p_object_version_number      IN   NUMBER
    )

 IS
L_API_NAME                  CONSTANT VARCHAR2(30) := 'Delete_Camp_Schedule';

Line: 553

      SAVEPOINT DELETE_Camp_Schedule_PUB;

Line: 571

      AMS_Camp_Schedule_CUHK.delete_schedule_pre(
         l_SCHEDULE_ID,
         l_object_version,
         l_return_status
      );

Line: 587

      AMS_Camp_Schedule_VUHK.delete_schedule_pre(
         l_SCHEDULE_ID,
         l_object_version,
         l_return_status
      );

Line: 601

    AMS_Camp_Schedule_PVT.Delete_Camp_Schedule(
    p_api_version_number         => 1.0,
    p_init_msg_list              => p_init_msg_list,
    p_commit                     => p_commit,
    p_validation_level           => p_validation_level,
    x_return_status              => x_return_status,
    x_msg_count                  => x_msg_count,
    x_msg_data                   => x_msg_data,
    p_schedule_id                => l_schedule_id,
    p_object_version_number      => l_object_version );

Line: 623

      AMS_Camp_Schedule_VUHK.delete_schedule_post(
         l_SCHEDULE_ID,
         l_object_version,
         l_return_status
      );

Line: 639

      AMS_Camp_Schedule_CUHK.delete_schedule_post(
         l_SCHEDULE_ID,
         l_object_version,
         l_return_status
      );

Line: 679

     ROLLBACK TO DELETE_Camp_Schedule_PUB;

Line: 689

     ROLLBACK TO DELETE_Camp_Schedule_PUB;

Line: 699

     ROLLBACK TO DELETE_Camp_Schedule_PUB;

Line: 711

End Delete_Camp_Schedule;