APPS.OE_PROCESS_OPTIONS_PVT dependencies on OE_ORDER_LINES

Line 554: FROM oe_order_lines

550: END IF;
551:
552: SELECT ordered_quantity
553: INTO p_options_tbl(I).old_ordered_quantity
554: FROM oe_order_lines
555: WHERE line_id = p_options_tbl(I).line_id;
556:
557: l_count := l_count + 1;
558: l_req_rec.param1 := p_top_model_line_id;

Line 689: all n options for 300 or so attributes in oe_order_lines.

685:
686: To aid performance, in this procedure we first default one option
687: and use the defaulted record as the base record for all other
688: options that need to be created. This saves us from defaulting
689: all n options for 300 or so attributes in oe_order_lines.
690: We set the item dependent attributes (once that are set dependent
691: on inventory_item_id in OEXUDEPB.pls) as missing on all the
692: options so that they will get defaulted individually. Please
693: note that any future additions to OEXUDEPB.pls should be

Line 846: SELECT OE_ORDER_LINES_S.NEXTVAL

842: l_class_line_rec.attribute19 := p_options_tbl(I).attribute19;
843: l_class_line_rec.attribute20 := p_options_tbl(I).attribute20;
844: l_class_line_rec.context := p_options_tbl(I).context;
845:
846: SELECT OE_ORDER_LINES_S.NEXTVAL
847: INTO l_class_line_rec.line_id
848: FROM DUAL;
849:
850: l_class_line_rec.pricing_quantity_uom

Line 1053: FROM oe_order_lines

1049: p_x_option_rec.inventory_item_id));
1050:
1051: SELECT ordered_item
1052: INTO l_dummy
1053: FROM oe_order_lines
1054: WHERE line_id = p_top_model_line_id;
1055:
1056: FND_MESSAGE.Set_Token('MODEL', nvl(l_dummy, '-'));
1057:

Line 1062: FROM oe_order_lines

1058: SELECT line_number || '.' || shipment_number || '.' ||
1059: option_number || '.' || component_number || '.' ||
1060: service_number
1061: INTO l_dummy
1062: FROM oe_order_lines
1063: WHERE line_id = p_x_option_rec.line_id;
1064:
1065: FND_MESSAGE.Set_Token('LINE_NUM', RTRIM(l_dummy, '.'));
1066: OE_Msg_Pub.Add;

Line 1558: FROM oe_order_lines

1554: attribute6, attribute7, attribute8, attribute9, attribute10,
1555: attribute11, attribute12, attribute13, attribute14, attribute15,
1556: attribute16, attribute17, attribute18, attribute19, attribute20,
1557: context
1558: FROM oe_order_lines
1559: WHERE top_model_line_id = p_top_model_line_id
1560: AND open_flag = 'Y'
1561: AND nvl(config_header_id, -1) = -1
1562: AND (item_type_code = OE_GLOBALS.G_ITEM_MODEL

Line 1608: FROM oe_order_lines

1604:
1605: IF l_frozen_model_bill = 'N' THEN
1606: SELECT inventory_item_id, component_sequence_id
1607: INTO l_top_item_id, l_top_bill_sequence_id
1608: FROM oe_order_lines
1609: WHERE line_id = p_top_model_line_id;
1610:
1611: OE_CONFIG_UTIL.Explode
1612: ( p_validation_org => OE_SYS_PARAMETERS.VALUE