1664: l_routing_name VARCHAR2 (100);
1665: g_chktype_TRACKING_QTY_IND CONSTANT MTL_SYSTEM_ITEMS_B.TRACKING_QUANTITY_IND%TYPE := 'PS';
1666: l_manual_price_change_flag po_lines_all.manual_price_change_flag%TYPE := NULL;
1667: l_from_type_lookup_code PO_HEADERS.type_lookup_code%type;
1668: l_uom_convert VARCHAR2(2) := fnd_profile.value('PO_REQ_BPA_UOM_CONVERT');
1669: l_ga_uom PO_LINES.unit_meas_lookup_code%TYPE;
1670: l_quantity_in_ga_uom PO_LINES_INTERFACE.quantity%TYPE;
1671: l_conversion_rate NUMBER :=1;
1672: l_outsourced_assembly po_line_locations_all.outsourced_assembly%type;
3227: END;
3228:
3229: -- Get the profile option values to determine grouping criteria
3230:
3231: l_needby_prf := fnd_profile.value('PO_NEED_BY_GROUPING');
3232: l_shipto_prf := fnd_profile.value('PO_SHIPTO_GROUPING');
3233:
3234: IF nvl(l_needby_prf,'Y') = 'Y' THEN
3235: l_need_by_date := p_lines.need_by_date_tbl(i);
3228:
3229: -- Get the profile option values to determine grouping criteria
3230:
3231: l_needby_prf := fnd_profile.value('PO_NEED_BY_GROUPING');
3232: l_shipto_prf := fnd_profile.value('PO_SHIPTO_GROUPING');
3233:
3234: IF nvl(l_needby_prf,'Y') = 'Y' THEN
3235: l_need_by_date := p_lines.need_by_date_tbl(i);
3236: END IF;