[Home] [Help]
2751:
2752: l_db_quantity po_lines.quantity%TYPE := null; --bug#2723479
2753:
2754: -- Bug 2735840 START
2755: l_uom_convert varchar2(2) := fnd_profile.value('PO_REQ_BPA_UOM_CONVERT');
2756: l_ga_uom PO_LINES.unit_meas_lookup_code%TYPE;
2757: l_quantity_in_ga_uom PO_LINES_INTERFACE.quantity%TYPE;
2758: l_conversion_rate number :=1;
2759: -- Bug 2735840 END
4546: END;
4547:
4548: -- Get the profile option values to determine grouping criteria
4549:
4550: l_needby_prf := fnd_profile.value('PO_NEED_BY_GROUPING');
4551: l_shipto_prf := fnd_profile.value('PO_SHIPTO_GROUPING');
4552:
4553: IF nvl(l_needby_prf,'Y') = 'Y' THEN
4554: l_need_by_date := interface.need_by_date;
4547:
4548: -- Get the profile option values to determine grouping criteria
4549:
4550: l_needby_prf := fnd_profile.value('PO_NEED_BY_GROUPING');
4551: l_shipto_prf := fnd_profile.value('PO_SHIPTO_GROUPING');
4552:
4553: IF nvl(l_needby_prf,'Y') = 'Y' THEN
4554: l_need_by_date := interface.need_by_date;
4555: END IF;
5276: x_po_uom varchar2(25):=null;
5277: x_temp_uom varchar2(25):=null;
5278: x_temp_item_id number:=null;
5279: x_closed_reason po_line_locations.closed_reason%TYPE;
5280: x_uom_convert varchar2(2) := fnd_profile.value('PO_REQ_BPA_UOM_CONVERT');
5281:
5282: --
5283: l_promised_date DATE := INTERFACE.PROMISED_DATE;
5284: l_po_promised_def_prf VARCHAR2(1) := fnd_profile.value('PO_NEED_BY_PROMISE_DEFAULTING');
5280: x_uom_convert varchar2(2) := fnd_profile.value('PO_REQ_BPA_UOM_CONVERT');
5281:
5282: --
5283: l_promised_date DATE := INTERFACE.PROMISED_DATE;
5284: l_po_promised_def_prf VARCHAR2(1) := fnd_profile.value('PO_NEED_BY_PROMISE_DEFAULTING');
5285: --
5286:
5287: l_api_name CONSTANT VARCHAR2(30) := 'create_shipment';
5288: l_progress VARCHAR2(3) := '000'; --< Bug 3210331 >
6490:
6491: x_kanban_card_id number:='';
6492: x_accrued_flag varchar2(1);
6493: x_po_uom varchar2(25):=null;
6494: x_uom_convert varchar2(2) := fnd_profile.value('PO_REQ_BPA_UOM_CONVERT');
6495: x_conversion_rate number := 1;
6496:
6497: -- Bug 7661419, No conversion for same currency.
6498: x_req_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
6554: FROM po_distributions_all --
6555: WHERE line_location_id = x_line_location_id;
6556:
6557: l_progress:='020';
6558: fnd_profile.get('PO_AUTOCREATE_DATE',x_gl_date_option);
6559:
6560: /* Bug 482648 ecso 4/30/97
6561: * Move quantity conversion from setup_interface_tables
6562: * to create_distribution for consistency
8627: x_asl_id number := null;
8628: x_vendor_product_num varchar2(240) := null;
8629: x_purchasing_uom varchar2(240) := null;
8630: x_pay_on_code varchar2(25) := null;
8631: x_uom_convert varchar2(2) := fnd_profile.value('PO_REQ_BPA_UOM_CONVERT');
8632: x_old_document_num po_headers.segment1%type:=null; -- Bug 700513, lpo, 07/15/98
8633:
8634: x_employee_id number;
8635: x_employee_name varchar2(240);
10009: END IF;
10010:
10011: -- Bug 3201308 start
10012: -- Get the profile option values to determine grouping criteria
10013: l_needby_prf := fnd_profile.value('PO_NEED_BY_GROUPING');
10014: l_shipto_prf := fnd_profile.value('PO_SHIPTO_GROUPING');
10015: l_progress := '010';
10016: -- Bug 3201308 end
10017:
10010:
10011: -- Bug 3201308 start
10012: -- Get the profile option values to determine grouping criteria
10013: l_needby_prf := fnd_profile.value('PO_NEED_BY_GROUPING');
10014: l_shipto_prf := fnd_profile.value('PO_SHIPTO_GROUPING');
10015: l_progress := '010';
10016: -- Bug 3201308 end
10017:
10018: SELECT phi.document_num,
10064: -- For Standard and Planned POs and RFQs, the line number
10065: -- will be the same as the req line number if the profile
10066: -- is set to 'Y' otherwise use sequential numbers
10067:
10068: IF (FND_PROFILE.VALUE('PO_USE_REQ_NUM_IN_AUTOCREATE') = 'Y') THEN
10069:
10070: -- use requisition numbers
10071:
10072: l_progress:='035';
10110: END LOOP;
10111:
10112: CLOSE interface_lines_temp;
10113:
10114: END IF; -- if fnd_profile.value(PO_USE_REQ_NUM...) = 'Y'
10115:
10116: ELSE
10117:
10118: -- Document is release case
10262: -- For Releases, the shipment number will be the same as
10263: -- the req line number if the profile is set, otherwise
10264: -- sequential numbers are used
10265:
10266: IF (FND_PROFILE.VALUE('PO_USE_REQ_NUM_IN_AUTOCREATE')='Y') THEN
10267:
10268: -- use requisition numbers
10269:
10270: l_progress := '100';
10299:
10300: END LOOP;
10301: CLOSE interface_lines_temp;
10302:
10303: END IF; -- if fnd_profile.value(PO_USE_REQ_NUM...) = 'Y'
10304:
10305: END IF; -- release vs. non release case
10306:
10307: ELSE
11789:
11790: /* Bug 3201308 start */
11791: /* Get the profile option values to determine grouping criteria */
11792:
11793: l_needby_prf := fnd_profile.value('PO_NEED_BY_GROUPING');
11794: l_shipto_prf := fnd_profile.value('PO_SHIPTO_GROUPING');
11795:
11796: /* Bug 3201308 end */
11797:
11790: /* Bug 3201308 start */
11791: /* Get the profile option values to determine grouping criteria */
11792:
11793: l_needby_prf := fnd_profile.value('PO_NEED_BY_GROUPING');
11794: l_shipto_prf := fnd_profile.value('PO_SHIPTO_GROUPING');
11795:
11796: /* Bug 3201308 end */
11797:
11798: /* OE drop ship requirement
14039:
14040: l_routing_name RCV_ROUTING_HEADERS.routing_name%TYPE;
14041: l_line_loc_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
14042:
14043: l_po_promised_def_prf VARCHAR2(1) := FND_PROFILE.value('PO_NEED_BY_PROMISE_DEFAULTING');
14044: l_country_of_origin_code VARCHAR2(2);
14045: l_tax_status VARCHAR2(10);
14046: l_encoded_msg VARCHAR2(2000);
14047:
14826: -- po distributions.
14827:
14828: d_progress := 20;
14829:
14830: FND_PROFILE.GET('PO_AUTOCREATE_DATE', l_gl_date_option);
14831:
14832: IF ((params.po_encumbrance_flag = 'Y')
14833: AND (l_gl_date_option <> 'REQ GL DATE')
14834: AND (params.period_name IS NULL)) THEN