1 PACKAGE MTL_LOT_UOM_CONV_PVT AS
2 /* $Header: INVVLUCS.pls 120.1 2005/07/06 04:19:53 schandru noship $ */
3
4
5 G_TRUE CONSTANT NUMBER := 1;
6 G_FALSE CONSTANT NUMBER := 0;
7 -- SCHANDRU INVERES Start
8 G_ERES_ENABLED VARCHAR2(1) := NVL(fnd_profile.VALUE('EDR_ERES_ENABLED'), 'N');
9 -- SCHANDRU INVERES End
10
11
12
13 FUNCTION validate_update_type (
14 p_update_type IN VARCHAR2)
15 return NUMBER;
16
17
18 FUNCTION validate_lot_conversion_rules
19 ( p_organization_id IN NUMBER
20 , p_inventory_item_id IN NUMBER
21 , p_lot_number IN VARCHAR2
22 , p_from_uom_code IN VARCHAR2
23 , p_to_uom_code IN VARCHAR2
24 , p_quantity_updates IN NUMBER
25 , p_update_type IN VARCHAR2
26 , p_header_id IN NUMBER DEFAULT NULL
27 )
28 return NUMBER;
29
30
31 PROCEDURE process_conversion_data
32 ( p_action_type IN VARCHAR2
33 , p_update_type_indicator IN NUMBER DEFAULT 5
34 , p_reason_id IN NUMBER
35 , p_batch_id IN NUMBER
36 , p_lot_uom_conv_rec IN OUT NOCOPY mtl_lot_uom_class_conversions%ROWTYPE
37 , p_qty_update_tbl IN OUT NOCOPY mtl_lot_uom_conv_pub.quantity_update_rec_type
38 , x_return_status OUT NOCOPY VARCHAR2
39 , x_msg_count OUT NOCOPY NUMBER
40 , x_msg_data OUT NOCOPY VARCHAR2
41 , x_sequence OUT NOCOPY NUMBER
42 );
43
44 PROCEDURE copy_lot_uom_conversions
45 ( p_inventory_item_id IN NUMBER,
46 p_from_organization_id IN NUMBER,
47 p_from_lot_number IN VARCHAR2,
48 p_to_organization_id IN NUMBER,
49 p_to_lot_number IN VARCHAR2,
50 p_user_id IN NUMBER,
51 p_creation_date IN DATE,
52 p_commit IN VARCHAR2,
53 x_return_status OUT NOCOPY VARCHAR2,
54 x_msg_count OUT NOCOPY NUMBER,
55 x_msg_data OUT NOCOPY VARCHAR2
56 );
57
58
59
60
61 FUNCTION validate_onhand_equals_avail (
62 p_organization_id IN NUMBER,
63 p_inventory_item_id IN NUMBER,
64 p_lot_number IN VARCHAR2,
65 p_header_id IN NUMBER)
66 return NUMBER;
67
68 END MTL_LOT_UOM_CONV_PVT;