861:
862: /*
863: l_quantity po_requisition_lines_all.quantity%TYPE := null;
864: l_price_break_type varchar2(1) := null;
865: l_po_line_id po_lines_all.po_line_id%TYPE := null;
866: l_cumulative_flag boolean;
867: l_dest_org_id po_requisition_lines_all.destination_organization_id%TYPE := null;
868: l_need_by_date po_requisition_lines_all.need_by_date%TYPE := null;
869: /*
873: l_po_promised_def_prf VARCHAR2(1) := fnd_profile.value('PO_NEED_BY_PROMISE_DEFAULTING');
874: --
875:
876: l_outsourced_assembly PO_LINE_LOCATIONS_ALL.outsourced_assembly%TYPE;
877: l_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE; --Bug 4896950
878: l_matching_basis PO_LINES_ALL.matching_basis%TYPE; --Bug 4896950
879: l_unit_meas_lookup_code PO_LINES_ALL.unit_meas_lookup_code%TYPE; --Bug 4896950
880:
881: --
874: --
875:
876: l_outsourced_assembly PO_LINE_LOCATIONS_ALL.outsourced_assembly%TYPE;
877: l_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE; --Bug 4896950
878: l_matching_basis PO_LINES_ALL.matching_basis%TYPE; --Bug 4896950
879: l_unit_meas_lookup_code PO_LINES_ALL.unit_meas_lookup_code%TYPE; --Bug 4896950
880:
881: --
882: l_return_status VARCHAR2(1);
875:
876: l_outsourced_assembly PO_LINE_LOCATIONS_ALL.outsourced_assembly%TYPE;
877: l_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE; --Bug 4896950
878: l_matching_basis PO_LINES_ALL.matching_basis%TYPE; --Bug 4896950
879: l_unit_meas_lookup_code PO_LINES_ALL.unit_meas_lookup_code%TYPE; --Bug 4896950
880:
881: --
882: l_return_status VARCHAR2(1);
883: l_msg_count NUMBER;
1048: into l_price_break_type,
1049: l_value_basis,
1050: l_matching_basis,
1051: l_unit_meas_lookup_code
1052: from po_lines_all
1053: where po_line_id = l_po_line_id;
1054: EXCEPTION
1055: when others then
1056: null;