133: (p_entity_type => 'OEOL',
134: p_entity_key => p_line_id,
135: p_SColumn_name => 'S26');
136:
137: IF l_s26= OE_WF_UPGRADE_UTIL.RES_PARTIAL THEN
138:
139: SELECT shipped_quantity
140: INTO l_shipped_quantity
141: FROM oe_order_lines_all
141: FROM oe_order_lines_all
142: WHERE line_id=p_line_id;
143:
144: IF l_shipped_quantity is null THEN
145: x_result := OE_WF_UPGRADE_UTIL.RES_INTERFACED;
146: ELSE
147: x_result := OE_WF_UPGRADE_UTIL.RES_CONFIRMED;
148: END IF;
149: ELSE
143:
144: IF l_shipped_quantity is null THEN
145: x_result := OE_WF_UPGRADE_UTIL.RES_INTERFACED;
146: ELSE
147: x_result := OE_WF_UPGRADE_UTIL.RES_CONFIRMED;
148: END IF;
149: ELSE
150: x_result := l_s26;
151: END IF;