DBA Data[Home] [Help]

APPS.PO_RELGEN_PKG dependencies on PO_LINES_ALL

Line 865: l_po_line_id po_lines_all.po_line_id%TYPE := null;

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: /* */

Line 877: l_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE; --Bug 4896950

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: --

Line 878: l_matching_basis PO_LINES_ALL.matching_basis%TYPE; --Bug 4896950

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);

Line 879: l_unit_meas_lookup_code PO_LINES_ALL.unit_meas_lookup_code%TYPE; --Bug 4896950

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;

Line 1052: from po_lines_all

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;