APPS.AMS_DELIVKITITEM_PUB SQL Statements

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

Line: 226

PROCEDURE Update_DelivKitItem(
    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_Deliv_Kit_Item_rec                  IN  AMS_DelivKitItem_PVT.deliv_kit_item_rec_type
    )

 IS

L_API_NAME                  CONSTANT VARCHAR2(30) := 'Update_DelivKitItem';

Line: 248

       SAVEPOINT UPDATE_DelivKitItem_PUB;

Line: 275

      AMS_DelivKitItem_CUHK.update_DelivKitItem_pre(
         l_pvt_DelivKitItem_rec,
         l_return_status
      );

Line: 290

      AMS_DelivKitItem_VUHK.update_DelivKitItem_pre(
         l_pvt_DelivKitItem_rec,
         l_return_status
      );

Line: 305

   AMS_DelivKitItem_PVT.Update_Deliv_Kit_Item(
     p_api_version         => 1.0,
     p_init_msg_list              => FND_API.G_FALSE,
     p_commit                     => p_commit,
     p_validation_level           => FND_API.G_VALID_LEVEL_FULL,
     x_return_status              => x_return_status,
     x_msg_count                  => x_msg_count,
     x_msg_data                   => x_msg_data,
     p_Deliv_Kit_Item_rec                  =>  l_pvt_DelivKitItem_rec);

Line: 333

      AMS_DelivKitItem_CUHK.update_DelivKitItem_post(
         l_pvt_DelivKitItem_rec,
         l_return_status
      );

Line: 348

      AMS_DelivKitItem_VUHK.update_DelivKitItem_post(
         l_pvt_DelivKitItem_rec,
         l_return_status
      );

Line: 375

      ROLLBACK TO UPDATE_DelivKitItem_PUB;

Line: 385

      ROLLBACK TO UPDATE_DelivKitItem_PUB;

Line: 395

      ROLLBACK TO UPDATE_DelivKitItem_PUB;

Line: 408

End Update_DelivKitItem;

Line: 411

PROCEDURE Delete_DelivKitItem(
    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_deliv_kit_item_id                   IN   NUMBER,
    p_object_version_number      IN   NUMBER
    )



 IS

 L_API_NAME                  CONSTANT VARCHAR2(30) := 'Delete_DelivKitItem';

Line: 436

       SAVEPOINT DELETE_DelivKitItem_PUB;

Line: 463

      AMS_DelivKitItem_CUHK.delete_DelivKitItem_pre(
         l_deliv_kit_item_id,
		 l_object_version_number,
         l_return_status
      );

Line: 479

      AMS_DelivKitItem_VUHK.delete_DelivKitItem_pre(
         l_deliv_kit_item_id,
		 l_object_version_number,
         l_return_status
      );

Line: 496

     AMS_DelivKitItem_PVT.Delete_Deliv_Kit_Item(
     p_api_version                => 1.0,
     p_init_msg_list              => FND_API.G_FALSE,
     p_commit                     => p_commit,
     x_return_status              => x_return_status,
     x_msg_count                  => x_msg_count,
     x_msg_data                   => x_msg_data,
     p_deliv_kit_item_id          => l_deliv_kit_item_id,
     p_object_version             => l_object_version_number );

Line: 521

      AMS_DelivKitItem_CUHK.delete_DelivKitItem_post(
         l_deliv_kit_item_id,
		 l_object_version_number,
         l_return_status
      );

Line: 537

      AMS_DelivKitItem_VUHK.delete_DelivKitItem_post(
         l_deliv_kit_item_id,
	 l_object_version_number,
         l_return_status
      );

Line: 574

      ROLLBACK TO DELETE_DelivKitItem_PUB;

Line: 584

      ROLLBACK TO DELETE_DelivKitItem_PUB;

Line: 594

      ROLLBACK TO DELETE_DelivKitItem_PUB;

Line: 606

 End Delete_DelivKitItem;