APPS.OE_PROCESS_OPTIONS_PVT dependencies on OE_ORDER_LINES

Line 553: FROM oe_order_lines

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

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

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

Line 845: SELECT OE_ORDER_LINES_S.NEXTVAL

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

Line 1052: FROM oe_order_lines

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

Line 1061: FROM oe_order_lines

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

Line 1557: FROM oe_order_lines

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

Line 1607: FROM oe_order_lines

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