APPS.OE_UPG_SO dependencies on OE_ORDER_LINES_S

Line 1078: oe_order_lines_s.nextval

1074: g_copied_line_flag := 'N';
1075:
1076: if v_line_id = mol.line_id then
1077: select
1078: oe_order_lines_s.nextval
1079: into
1080: g_line_id
1081: from dual;
1082: g_line_id_change_flag := 'N';

Line 1467: oe_order_lines_s.nextval

1463: end;
1464:
1465: if r_lctr > 1 then
1466: select
1467: oe_order_lines_s.nextval
1468: into
1469: v_return_created_line_id
1470: from dual;
1471: end if;

Line 4143: SELECT oe_order_lines_s.nextval

4139: oe_debug_pub.add( 'CREATING A NEW MODEL LINE' ) ;
4140: END IF;
4141: l_new_line_rec := l_line_rec;
4142:
4143: SELECT oe_order_lines_s.nextval
4144: INTO l_new_line_rec.line_id
4145: FROM dual;
4146:
4147: l_new_line_rec.ato_line_id := l_new_line_rec.line_id;

Line 4179: SELECT oe_order_lines_s.nextval

4175: EXIT WHEN SERVICE_LINES%NOTFOUND;
4176:
4177: l_service_line_rec := Query_Row(l_service_line_id);
4178:
4179: SELECT oe_order_lines_s.nextval
4180: INTO l_service_line_rec.line_id
4181: FROM dual;
4182:
4183: l_service_line_rec.service_reference_line_id

Line 4197: SELECT oe_order_lines_s.nextval

4193: oe_debug_pub.add( 'CREATING A NEW OPTION LINE ' , 1 ) ;
4194: END IF;
4195: l_new_line_rec := l_line_rec;
4196:
4197: SELECT oe_order_lines_s.nextval
4198: INTO l_new_line_rec.line_id
4199: FROM dual;
4200:
4201: l_new_line_rec.ato_line_id := l_model_rec.line_id;

Line 4219: SELECT oe_order_lines_s.nextval

4215: EXIT WHEN SERVICE_LINES%NOTFOUND;
4216:
4217: l_service_line_rec := Query_Row(l_service_line_id);
4218:
4219: SELECT oe_order_lines_s.nextval
4220: INTO l_service_line_rec.line_id
4221: FROM dual;
4222:
4223: l_service_line_rec.service_reference_line_id

Line 6113: select oe_order_lines_s.nextval into l_line_id from dual;

6109: l_inventory_item_id := l_line_rec.inventory_item_id;
6110:
6111: For l_rec in C1 LOOP
6112:
6113: select oe_order_lines_s.nextval into l_line_id from dual;
6114:
6115: IF module is null then
6116: g_Last_Line_Number := g_Last_Line_Number +1;
6117: l_line_number := g_Last_Line_Number;

Line 6194: select oe_order_lines_s.nextval into l_line_id1 from dual;

6190: l_line_rec1.line_set_id := l_line_set_id;
6191:
6192: Insert_Row(l_line_rec1,p_line_id,'Y','N');
6193:
6194: select oe_order_lines_s.nextval into l_line_id1 from dual;
6195:
6196: l_line_rec1.line_id := l_line_id1;
6197: l_line_rec1.shipment_number := 2;
6198: l_line_rec1.ordered_quantity := l_rec.quantity-l_rec.received_quantity;

Line 6377: select oe_order_lines_s.nextval

6373: line_set_id = l_line_set_id
6374: where line_id = l_line_id;
6375:
6376:
6377: select oe_order_lines_s.nextval
6378: into l_line_id1
6379: from dual;
6380:
6381: l_line_rec2 := l_line_rec;