APPS.GMD_SPEC_MATCH_MIG_GRP dependencies on IC_LOTS_MST

Line 62: l_lot_no IC_LOTS_MST.lot_no%TYPE;

58: l_item_default_grade QC_GRAD_MST.QC_GRADE%TYPE ;
59: l_check_for_given_grade VARCHAR2(1) := 'N';
60: l_check_for_null_grade VARCHAR2(1) := 'N';
61: l_check_for_default_grade VARCHAR2(1) := 'N';
62: l_lot_no IC_LOTS_MST.lot_no%TYPE;
63: l_sublot_no IC_LOTS_MST.sublot_no%TYPE;
64:
65: REQ_FIELDS_MISSING EXCEPTION;
66: INVALID_LOT EXCEPTION;

Line 63: l_sublot_no IC_LOTS_MST.sublot_no%TYPE;

59: l_check_for_given_grade VARCHAR2(1) := 'N';
60: l_check_for_null_grade VARCHAR2(1) := 'N';
61: l_check_for_default_grade VARCHAR2(1) := 'N';
62: l_lot_no IC_LOTS_MST.lot_no%TYPE;
63: l_sublot_no IC_LOTS_MST.sublot_no%TYPE;
64:
65: REQ_FIELDS_MISSING EXCEPTION;
66: INVALID_LOT EXCEPTION;
67: INVALID_ITEM EXCEPTION;

Line 148: FROM IC_LOTS_MST

144: AND p_inventory_spec_rec.lot_no IS NULL
145: AND p_inventory_spec_rec.sublot_no IS NULL THEN
146: BEGIN
147: SELECT lot_no,sublot_no INTO l_lot_no,l_sublot_no
148: FROM IC_LOTS_MST
149: WHERE lot_id = p_inventory_spec_rec.lot_id ;
150: EXCEPTION
151: WHEN OTHERS THEN
152: RAISE INVALID_LOT;

Line 1363: FROM IC_LOTS_MST

1359:
1360: IF p_lots(l_lot_counter).lot_id IS NOT NULL THEN
1361: BEGIN
1362: SELECT lot_no,sublot_no INTO l_lot_no,l_sublot_no
1363: FROM IC_LOTS_MST
1364: WHERE lot_id = p_lots(l_lot_counter).lot_id
1365: AND item_id = p_lots(l_lot_counter).item_id;
1366:
1367: EXCEPTION