DBA Data[Home] [Help]

APPS.GMI_ALLOCATE_INVENTORY_PVT dependencies on GMI_AUTO_ALLOCATION_BATCH

Line 100: l_batch_rec GMI_AUTO_ALLOCATION_BATCH%ROWTYPE;

96: l_order_by VARCHAR2(1000):= NULL;
97: l_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
98: l_tran_row IC_TRAN_PND%ROWTYPE;
99: l_allocation_rec GMI_AUTO_ALLOCATE_PUB.gmi_allocation_rec;
100: l_batch_rec GMI_AUTO_ALLOCATION_BATCH%ROWTYPE;
101: l_lot_indivisible NUMBER;
102: l_lot_qty NUMBER;
103: l_lots_specified NUMBER DEFAULT 1; /* 0=No lots specified, 1= 1 specified,2= Multiple specified */
104: l_overpick_enabled VARCHAR2(1);

Line 142: FROM gmi_auto_allocation_batch

138: Where line_id = p_allocation_rec.line_id;
139:
140: CURSOR Get_Batch_Rec_Cur(p_batch_id NUMBER) IS
141: SELECT *
142: FROM gmi_auto_allocation_batch
143: WHERE batch_id = p_batch_id;
144:
145: TYPE rc IS REF CURSOR;
146: ic_inventory_view_c1 rc;