55: BEGIN
56: IF (p_line_tbl(I).operation = oe_globals.g_opr_create AND
57: p_line_tbl(I).split_from_line_id IS NOT NULL AND
58: p_line_tbl(I).source_type_code = 'EXTERNAL' ) THEN
59: UPDATE oe_drop_ship_sources
60: SET line_id = p_line_tbl(I).line_id
61: WHERE line_id = p_line_tbl(I).split_from_line_id;
62: END IF;
63: EXCEPTION WHEN NO_DATA_FOUND THEN