The following lines contain the word 'select', 'insert', 'update' or 'delete':
** 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;
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;
l_api_name CONSTANT VARCHAR2(30):= 'UPDATE_CARD_SUPPLY_STATUS';
mydebug('Calling INV_Kanban_PVT.Update_Card_Supply_Status');
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);
,'Update_Card_Supply_Status'
);
END UPDATE_CARD_SUPPLY_STATUS;
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;