1 PACKAGE BODY MRP_PUB_KANBAN_QTY_CALC AS
2 /* $Header: MRPPKQCB.pls 120.2 2011/02/04 07:37:39 sisankar ship $ */
3
4 l_api_version constant number := 1.0;
5
6 PROCEDURE Calculate_Kanban_Quantity (
7 p_version_number IN NUMBER,
8 p_pull_sequence_id IN NUMBER,
9 p_average_demand IN NUMBER,
10 p_allocation_percent IN NUMBER,
11 p_minimum_order_quantity IN NUMBER,
12 p_fixed_lot_multiplier IN NUMBER,
13 p_safety_stock_days IN NUMBER,
14 p_replenishment_lead_time IN NUMBER,
15 p_kanban_flag IN NUMBER,
16 p_kanban_size IN OUT NOCOPY NUMBER,
17 p_kanban_number IN OUT NOCOPY NUMBER,
18 p_return_status OUT NOCOPY VARCHAR2 ) IS
19 BEGIN
20
21 null;
22 p_return_status := 'S';
23
24 Exception
25 WHEN OTHERS THEN
26 p_return_status := 'E';
27
28 END Calculate_Kanban_Quantity;
29
30 END MRP_PUB_KANBAN_QTY_CALC;