APPS.INV_KANBAN_GRP SQL Statements

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

Line: 19

** PROCEDURE UPDATE_CARD_SUPPLY_STATUS
**
** Purpose
**    This procedure updates the supply status of the kanban card.
** Input parameters
**  p_api_version      IN  NUMBER (required)
**                API Version of this procedure
**  p_init_msg_level   IN  VARCHAR2 (optional)
**                     DEFAULT = FND_API.G_FALSE,
**  p_commit           IN  VARCHAR2 (optional)
**                     DEFAULT = FND_API.G_FALSE,
**  p_kanban_card_id   In VARCHAR2 (required)
**                     kanban card id to be updated
**  p_supply_status    IN varchar2 (required)
**                       INV_KANBAN_PVT.G_Supply_Status_New
**                       INV_KANBAN_PVT.G_Supply_Status_Full
**                       INV_KANBAN_PVT.G_Supply_Status_Empty
**                       INV_KANBAN_PVT.G_Supply_Status_InProcess
**                       INV_KANBAN_PVT.G_Supply_Status_InTransit
**  p_document_type   IN NUMBER
**                     INV_KANBAN_PVT.G_Doc_type_PO          	  1;

Line: 64

PROCEDURE UPDATE_CARD_SUPPLY_STATUS
  (x_msg_count                     OUT NOCOPY NUMBER,
   x_msg_data                      OUT NOCOPY VARCHAR2,
   x_return_status                 OUT NOCOPY VARCHAR2,
   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_kanban_card_id                IN  NUMBER,
   p_supply_status                 IN  NUMBER,
   p_document_type                 IN  NUMBER DEFAULT NULL,
   p_document_header_id            IN  NUMBER DEFAULT NULL,
   p_document_detail_id            IN  NUMBER DEFAULT NULL,
   p_replenish_quantity            IN  NUMBER DEFAULT NULL,
   p_need_by_date                  IN  DATE   DEFAULT NULL,
   p_source_wip_entity_id          IN  NUMBER DEFAULT NULL
 )
  IS

     l_api_version_number          CONSTANT NUMBER := 1.0;

Line: 83

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

Line: 105

   mydebug('Calling INV_Kanban_PVT.Update_Card_Supply_Status');

Line: 107

   INV_KANBAN_PVT.UPDATE_CARD_SUPPLY_STATUS
     (   p_api_version_number          => 1.0
	 ,   p_init_msg_list               => p_init_msg_list
	 ,   p_validation_level            => FND_API.G_VALID_LEVEL_FULL
	 ,   p_commit                      => p_commit
	 ,   x_return_status               => x_return_status
	 ,   x_msg_count                   => x_msg_count
	 ,   x_msg_data                    => x_msg_data
	 ,   p_kanban_card_id              => p_kanban_card_id
	 ,   p_supply_status               => p_supply_status
	 ,   p_document_type               => p_document_type
	 ,   p_document_header_id          => p_document_header_id
	 ,   p_document_detail_id          => p_document_detail_id
	 ,   p_replenish_quantity          => p_replenish_quantity
	 ,   p_need_by_date                => p_need_by_date
	 ,   p_source_wip_entity_id        => p_source_wip_entity_id);

Line: 151

	       ,'Update_Card_Supply_Status'
	       );

Line: 160

END UPDATE_CARD_SUPPLY_STATUS;

Line: 174

	SELECT
          pull_sequence_id , organization_id , inventory_item_id ,
          subinventory_name , locator_id , source_type , supplier_id,
          supplier_site_id, source_organization_id, source_subinventory,
	  source_locator_id, wip_line_id, kanban_size, number_of_cards,
	  release_kanban_flag
	  from
          MTL_KANBAN_PULL_SEQUENCES
	  where
          pull_sequence_id = p_pull_sequence_id;