1 PACKAGE mrp_kanban_functions_pk AUTHID CURRENT_USER AS
2 /* $Header: MRPPKANS.pls 115.8 2003/05/30 09:01:37 nrajpal ship $ */
3 PROCEDURE UPDATE_PULL_SEQUENCES
4 (x_return_status OUT NOCOPY VARCHAR2,
5 x_msg_count OUT NOCOPY NUMBER,
6 x_msg_data OUT NOCOPY VARCHAR2,
7 p_pull_sequence_id IN NUMBER,
8 p_organization_id IN NUMBER,
9 p_kanban_plan_id IN NUMBER,
10 p_inventory_item_id IN NUMBER,
11 p_subinventory_name IN VARCHAR2,
12 p_locator_id IN NUMBER,
13 p_kanban_size IN NUMBER,
14 p_number_of_cards IN NUMBER,
15 p_source_type IN NUMBER := FND_API.G_MISS_NUM,
16 p_source_organization_id IN NUMBER := FND_API.G_MISS_NUM,
17 p_source_subinventory IN VARCHAR2 := FND_API.G_MISS_CHAR,
18 p_source_locator_id IN NUMBER := FND_API.G_MISS_NUM,
19 p_line_id IN NUMBER := FND_API.G_MISS_NUM,
20 p_supplier_id IN NUMBER := FND_API.G_MISS_NUM,
21 p_supplier_site_id IN NUMBER := FND_API.G_MISS_NUM,
22 p_calculate_kanban_flag IN NUMBER := FND_API.G_MISS_NUM,
23 p_replenishment_lead_time IN NUMBER := FND_API.G_MISS_NUM,
24 p_release_kanban_flag IN NUMBER := FND_API.G_MISS_NUM,
25 p_minimum_order_quantity IN NUMBER := FND_API.G_MISS_NUM,
26 p_fixed_lot_multiplier IN NUMBER := FND_API.G_MISS_NUM,
27 p_safety_stock_days IN NUMBER := FND_API.G_MISS_NUM);
28
29 PROCEDURE DELETE_PULL_SEQUENCES
30 (x_return_status OUT NOCOPY VARCHAR2,
31 x_msg_count OUT NOCOPY NUMBER,
32 x_msg_data OUT NOCOPY VARCHAR2,
33 p_kanban_plan_id IN NUMBER);
34
35 PROCEDURE UPDATE_AND_PRINT_KANBANS (
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_count OUT NOCOPY NUMBER,
38 x_msg_data OUT NOCOPY VARCHAR2,
39 p_query_id IN NUMBER,
40 p_update_flag IN VARCHAR2 );
41
42 PROCEDURE INSERT_PULL_SEQUENCES (
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2,
46 p_plan_pull_sequence_id IN NUMBER );
47 END mrp_kanban_functions_pk;