DBA Data[Home] [Help]

APPS.GMIGUTL dependencies on IC_LOTS_MST

Line 73: ( p_item_id IN ic_lots_mst.item_id%TYPE

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

Line 74: , p_lot_no IN ic_lots_mst.lot_no%TYPE

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: );

Line 75: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE

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:

Line 76: , x_ic_lots_mst_row OUT NOCOPY ic_lots_mst%ROWTYPE

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