APPS.GMI_AUTOLOT dependencies on IC_LOTS_MST

Line 76: FROM ic_lots_mst

72: RETURN NUMBER IS
73:
74: CURSOR GET_LOT_MASTER IS
75: SELECT lot_id
76: FROM ic_lots_mst
77: WHERE item_id = p_f_item_id AND
78: lot_no = p_f_lot_no AND
79: sublot_no = p_f_sublot_no;
80:

Line 83: FROM ic_lots_mst

79: sublot_no = p_f_sublot_no;
80:
81: CURSOR GET_LOT_MASTER2 IS
82: SELECT lot_id
83: FROM ic_lots_mst
84: WHERE item_id = p_f_item_id AND
85: lot_no = p_f_lot_no;
86:
87: w_lot_id number := 0;

Line 200: p_u_out_lot_no ic_lots_mst.lot_no%TYPE;

196:
197: /*=============================
198: User Routine Variables
199: =============================*/
200: p_u_out_lot_no ic_lots_mst.lot_no%TYPE;
201: p_u_sublot_no ic_lots_mst.sublot_no%TYPE;
202: p_u_return_status NUMBER;
203:
204: /*=============================

Line 201: p_u_sublot_no ic_lots_mst.sublot_no%TYPE;

197: /*=============================
198: User Routine Variables
199: =============================*/
200: p_u_out_lot_no ic_lots_mst.lot_no%TYPE;
201: p_u_sublot_no ic_lots_mst.sublot_no%TYPE;
202: p_u_return_status NUMBER;
203:
204: /*=============================
205: Exceptions

Line 393: x_found := 1; -- 1 means ic_lots_mst exists

389: ELSE
390: CLOSE GET_SUBLOT_INFO;
391: END IF;
392: p_out_lot_no := p_in_lot_no;
393: x_found := 1; -- 1 means ic_lots_mst exists
394: WHILE (x_found = 1)
395: LOOP
396: w_sub_pref_length := nvl(LENGTHB(db_sublot_prefix),0);
397: w_sub_suff_length := LENGTHB(w_next_sublot);