APPS.GMI_OM_ALLOC_API_PUB dependencies on IC_LOTS_MST

Line 18: ,lot_id IC_LOTS_MST.LOT_ID%TYPE

14:
15: TYPE Ic_Tran_Rec_Type IS RECORD (
16: trans_id IC_TRAN_PND.TRANS_ID%TYPE
17: ,line_id IC_TRAN_PND.LINE_ID%TYPE
18: ,lot_id IC_LOTS_MST.LOT_ID%TYPE
19: ,lot_no IC_LOTS_MST.LOT_NO%TYPE
20: ,sublot_no IC_LOTS_MST.SUBLOT_NO%TYPE
21: ,location VARCHAR2(50)
22: ,trans_qty IC_TRAN_PND.TRANS_QTY%TYPE

Line 19: ,lot_no IC_LOTS_MST.LOT_NO%TYPE

15: TYPE Ic_Tran_Rec_Type IS RECORD (
16: trans_id IC_TRAN_PND.TRANS_ID%TYPE
17: ,line_id IC_TRAN_PND.LINE_ID%TYPE
18: ,lot_id IC_LOTS_MST.LOT_ID%TYPE
19: ,lot_no IC_LOTS_MST.LOT_NO%TYPE
20: ,sublot_no IC_LOTS_MST.SUBLOT_NO%TYPE
21: ,location VARCHAR2(50)
22: ,trans_qty IC_TRAN_PND.TRANS_QTY%TYPE
23: ,trans_qty2 IC_TRAN_PND.TRANS_QTY2%TYPE

Line 20: ,sublot_no IC_LOTS_MST.SUBLOT_NO%TYPE

16: trans_id IC_TRAN_PND.TRANS_ID%TYPE
17: ,line_id IC_TRAN_PND.LINE_ID%TYPE
18: ,lot_id IC_LOTS_MST.LOT_ID%TYPE
19: ,lot_no IC_LOTS_MST.LOT_NO%TYPE
20: ,sublot_no IC_LOTS_MST.SUBLOT_NO%TYPE
21: ,location VARCHAR2(50)
22: ,trans_qty IC_TRAN_PND.TRANS_QTY%TYPE
23: ,trans_qty2 IC_TRAN_PND.TRANS_QTY2%TYPE
24: ,trans_um IC_TRAN_PND.TRANS_UM%TYPE

Line 83: p_item_id IN ic_lots_mst.item_id%TYPE

79: , x_msg_count OUT NOCOPY NUMBER
80: , x_msg_data OUT NOCOPY VARCHAR2 );
81:
82: PROCEDURE Get_Lot_Details (
83: p_item_id IN ic_lots_mst.item_id%TYPE
84: , p_lot_no IN ic_lots_mst.lot_no%TYPE
85: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE
86: , p_lot_id IN ic_lots_mst.lot_id%TYPE
87: , x_ic_lots_mst OUT NOCOPY ic_lots_mst%ROWTYPE

Line 84: , p_lot_no IN ic_lots_mst.lot_no%TYPE

80: , x_msg_data OUT NOCOPY VARCHAR2 );
81:
82: PROCEDURE Get_Lot_Details (
83: p_item_id IN ic_lots_mst.item_id%TYPE
84: , p_lot_no IN ic_lots_mst.lot_no%TYPE
85: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE
86: , p_lot_id IN ic_lots_mst.lot_id%TYPE
87: , x_ic_lots_mst OUT NOCOPY ic_lots_mst%ROWTYPE
88: , x_return_status OUT NOCOPY VARCHAR2

Line 85: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE

81:
82: PROCEDURE Get_Lot_Details (
83: p_item_id IN ic_lots_mst.item_id%TYPE
84: , p_lot_no IN ic_lots_mst.lot_no%TYPE
85: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE
86: , p_lot_id IN ic_lots_mst.lot_id%TYPE
87: , x_ic_lots_mst OUT NOCOPY ic_lots_mst%ROWTYPE
88: , x_return_status OUT NOCOPY VARCHAR2
89: , x_msg_count OUT NOCOPY NUMBER

Line 86: , p_lot_id IN ic_lots_mst.lot_id%TYPE

82: PROCEDURE Get_Lot_Details (
83: p_item_id IN ic_lots_mst.item_id%TYPE
84: , p_lot_no IN ic_lots_mst.lot_no%TYPE
85: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE
86: , p_lot_id IN ic_lots_mst.lot_id%TYPE
87: , x_ic_lots_mst OUT NOCOPY ic_lots_mst%ROWTYPE
88: , x_return_status OUT NOCOPY VARCHAR2
89: , x_msg_count OUT NOCOPY NUMBER
90: , x_msg_data OUT NOCOPY VARCHAR2 );

Line 87: , x_ic_lots_mst OUT NOCOPY ic_lots_mst%ROWTYPE

83: p_item_id IN ic_lots_mst.item_id%TYPE
84: , p_lot_no IN ic_lots_mst.lot_no%TYPE
85: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE
86: , p_lot_id IN ic_lots_mst.lot_id%TYPE
87: , x_ic_lots_mst OUT NOCOPY ic_lots_mst%ROWTYPE
88: , x_return_status OUT NOCOPY VARCHAR2
89: , x_msg_count OUT NOCOPY NUMBER
90: , x_msg_data OUT NOCOPY VARCHAR2 );
91: