69: , x_ic_item_cpg_row OUT NOCOPY ic_item_cpg%ROWTYPE
70: );
71:
72: PROCEDURE Get_Lot
73: ( p_item_id IN ic_lots_mst.item_id%TYPE
74: , p_lot_no IN ic_lots_mst.lot_no%TYPE
75: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE
76: , x_ic_lots_mst_row OUT NOCOPY ic_lots_mst%ROWTYPE
77: , x_ic_lots_cpg_row OUT NOCOPY ic_lots_cpg%ROWTYPE
70: );
71:
72: PROCEDURE Get_Lot
73: ( p_item_id IN ic_lots_mst.item_id%TYPE
74: , p_lot_no IN ic_lots_mst.lot_no%TYPE
75: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE
76: , x_ic_lots_mst_row OUT NOCOPY ic_lots_mst%ROWTYPE
77: , x_ic_lots_cpg_row OUT NOCOPY ic_lots_cpg%ROWTYPE
78: );
71:
72: PROCEDURE Get_Lot
73: ( p_item_id IN ic_lots_mst.item_id%TYPE
74: , p_lot_no IN ic_lots_mst.lot_no%TYPE
75: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE
76: , x_ic_lots_mst_row OUT NOCOPY ic_lots_mst%ROWTYPE
77: , x_ic_lots_cpg_row OUT NOCOPY ic_lots_cpg%ROWTYPE
78: );
79:
72: PROCEDURE Get_Lot
73: ( p_item_id IN ic_lots_mst.item_id%TYPE
74: , p_lot_no IN ic_lots_mst.lot_no%TYPE
75: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE
76: , x_ic_lots_mst_row OUT NOCOPY ic_lots_mst%ROWTYPE
77: , x_ic_lots_cpg_row OUT NOCOPY ic_lots_cpg%ROWTYPE
78: );
79:
80: PROCEDURE Get_Warehouse