APPS.OE_UPG_SO_NEW dependencies on OE_ORDER_LINES_S

Line 1385: oe_order_lines_s.nextval

1381: g_copied_line_flag := 'N';
1382:
1383: if v_line_id = mol.line_id then
1384: select
1385: oe_order_lines_s.nextval
1386: into
1387: g_line_id
1388: from dual;
1389: g_line_id_change_flag := 'N';

Line 1916: oe_order_lines_s.nextval

1912: end;
1913:
1914: if r_lctr > 1 then
1915: select
1916: oe_order_lines_s.nextval
1917: into
1918: v_return_created_line_id
1919: from dual;
1920: end if;

Line 6323: SELECT oe_order_lines_s.nextval

6319: END IF;
6320:
6321: l_new_line_rec := l_line_rec;
6322:
6323: SELECT oe_order_lines_s.nextval
6324: INTO l_new_line_rec.line_id
6325: FROM dual;
6326:
6327: l_new_line_rec.ato_line_id := l_new_line_rec.line_id;

Line 6385: SELECT oe_order_lines_s.nextval

6381: EXIT WHEN SERVICE_LINES%NOTFOUND;
6382:
6383: l_service_line_rec := Query_Row(l_service_line_id);
6384: Query_And_Set_Price_Attribs(l_service_line_rec.line_id,l_service_line_rec.header_id);
6385: SELECT oe_order_lines_s.nextval
6386: INTO l_service_line_rec.line_id
6387: FROM dual;
6388:
6389: l_service_line_rec.service_reference_line_id

Line 6405: SELECT oe_order_lines_s.nextval

6401: oe_debug_pub.add( 'CREATING A NEW OPTION LINE ' , 1 ) ;
6402: END IF;
6403: l_new_line_rec := l_line_rec;
6404:
6405: SELECT oe_order_lines_s.nextval
6406: INTO l_new_line_rec.line_id
6407: FROM dual;
6408:
6409: l_new_line_rec.ato_line_id := l_model_rec.line_id;

Line 6451: SELECT oe_order_lines_s.nextval

6447: EXIT WHEN SERVICE_LINES%NOTFOUND;
6448:
6449: l_service_line_rec := Query_Row(l_service_line_id);
6450: Query_And_Set_Price_Attribs(l_service_line_rec.line_id,l_service_line_rec.header_id);
6451: SELECT oe_order_lines_s.nextval
6452: INTO l_service_line_rec.line_id
6453: FROM dual;
6454:
6455: l_service_line_rec.service_reference_line_id

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

8401: l_inventory_item_id := l_line_rec.inventory_item_id;
8402:
8403: For l_rec in C1 LOOP
8404:
8405: select oe_order_lines_s.nextval into l_line_id from dual;
8406:
8407: IF module is null then
8408: g_Last_Line_Number := g_Last_Line_Number +1;
8409: l_line_number := g_Last_Line_Number;

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

8487: l_line_rec1.line_set_id := l_line_set_id;
8488:
8489: Insert_Row(l_line_rec1,p_line_id,'Y','N');
8490:
8491: select oe_order_lines_s.nextval into l_line_id1 from dual;
8492:
8493: l_line_rec1.line_id := l_line_id1;
8494: l_line_rec1.shipment_number := 2;
8495: l_line_rec1.ordered_quantity := l_rec.quantity-l_rec.received_quantity;