1033: FROM OE_ORDER_LINES_ALL
1034: WHERE line_id = to_number(itemkey);
1035:
1036: IF l_ato_line_id = to_number(itemkey) AND
1037: (l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
1038: l_item_type_code = OE_GLOBALS.G_ITEM_CLASS)
1039: THEN
1040: update oe_order_lines_all
1041: set flow_status_code = 'BOOKED'
1034: WHERE line_id = to_number(itemkey);
1035:
1036: IF l_ato_line_id = to_number(itemkey) AND
1037: (l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
1038: l_item_type_code = OE_GLOBALS.G_ITEM_CLASS)
1039: THEN
1040: update oe_order_lines_all
1041: set flow_status_code = 'BOOKED'
1042: where line_id = to_number(itemkey);
1281: FROM oe_order_lines_all
1282: WHERE line_id = to_number(itemkey);
1283:
1284: IF l_ato_line_id = to_number(itemkey) AND
1285: (l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
1286: l_item_type_code = OE_GLOBALS.G_ITEM_CLASS)
1287: THEN
1288: resultout := 'COMPLETE:Y';
1289: ELSE
1282: WHERE line_id = to_number(itemkey);
1283:
1284: IF l_ato_line_id = to_number(itemkey) AND
1285: (l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
1286: l_item_type_code = OE_GLOBALS.G_ITEM_CLASS)
1287: THEN
1288: resultout := 'COMPLETE:Y';
1289: ELSE
1290: resultout := 'COMPLETE:N';