36: , x_ic_item_cpg OUT NOCOPY ic_item_cpg%ROWTYPE
37: );
38:
39: PROCEDURE Get_Lot
40: ( p_item_id IN ic_lots_mst.item_id%TYPE
41: , p_lot_no IN ic_lots_mst.lot_no%TYPE
42: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE
43: , x_ic_lots_mst OUT NOCOPY ic_lots_mst%ROWTYPE
44: , x_ic_lots_cpg OUT NOCOPY ic_lots_cpg%ROWTYPE
37: );
38:
39: PROCEDURE Get_Lot
40: ( p_item_id IN ic_lots_mst.item_id%TYPE
41: , p_lot_no IN ic_lots_mst.lot_no%TYPE
42: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE
43: , x_ic_lots_mst OUT NOCOPY ic_lots_mst%ROWTYPE
44: , x_ic_lots_cpg OUT NOCOPY ic_lots_cpg%ROWTYPE
45: );
38:
39: PROCEDURE Get_Lot
40: ( p_item_id IN ic_lots_mst.item_id%TYPE
41: , p_lot_no IN ic_lots_mst.lot_no%TYPE
42: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE
43: , x_ic_lots_mst OUT NOCOPY ic_lots_mst%ROWTYPE
44: , x_ic_lots_cpg OUT NOCOPY ic_lots_cpg%ROWTYPE
45: );
46:
39: PROCEDURE Get_Lot
40: ( p_item_id IN ic_lots_mst.item_id%TYPE
41: , p_lot_no IN ic_lots_mst.lot_no%TYPE
42: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE
43: , x_ic_lots_mst OUT NOCOPY ic_lots_mst%ROWTYPE
44: , x_ic_lots_cpg OUT NOCOPY ic_lots_cpg%ROWTYPE
45: );
46:
47: PROCEDURE Get_Warehouse