[Home] [Help]
3088:
3089: l_db_quantity po_lines.quantity%TYPE := null; --bug#2723479
3090:
3091: -- Bug 2735840 START
3092: l_uom_convert varchar2(2) := fnd_profile.value('PO_REQ_BPA_UOM_CONVERT');
3093: l_ga_uom PO_LINES.unit_meas_lookup_code%TYPE;
3094: l_quantity_in_ga_uom PO_LINES_INTERFACE.quantity%TYPE;
3095: l_conversion_rate number :=1;
3096: -- Bug 2735840 END
4975: END;
4976:
4977: -- Get the profile option values to determine grouping criteria
4978:
4979: l_needby_prf := fnd_profile.value('PO_NEED_BY_GROUPING');
4980: l_shipto_prf := fnd_profile.value('PO_SHIPTO_GROUPING');
4981:
4982: IF nvl(l_needby_prf,'Y') = 'Y' THEN
4983: l_need_by_date := interface.need_by_date;
4976:
4977: -- Get the profile option values to determine grouping criteria
4978:
4979: l_needby_prf := fnd_profile.value('PO_NEED_BY_GROUPING');
4980: l_shipto_prf := fnd_profile.value('PO_SHIPTO_GROUPING');
4981:
4982: IF nvl(l_needby_prf,'Y') = 'Y' THEN
4983: l_need_by_date := interface.need_by_date;
4984: END IF;
5739: x_po_uom varchar2(25):=null;
5740: x_temp_uom varchar2(25):=null;
5741: x_temp_item_id number:=null;
5742: x_closed_reason po_line_locations.closed_reason%TYPE;
5743: x_uom_convert varchar2(2) := fnd_profile.value('PO_REQ_BPA_UOM_CONVERT');
5744:
5745: --
5746: l_promised_date DATE := INTERFACE.PROMISED_DATE;
5747: l_po_promised_def_prf VARCHAR2(1) := fnd_profile.value('PO_NEED_BY_PROMISE_DEFAULTING');
5743: x_uom_convert varchar2(2) := fnd_profile.value('PO_REQ_BPA_UOM_CONVERT');
5744:
5745: --
5746: l_promised_date DATE := INTERFACE.PROMISED_DATE;
5747: l_po_promised_def_prf VARCHAR2(1) := fnd_profile.value('PO_NEED_BY_PROMISE_DEFAULTING');
5748: --
5749:
5750: l_api_name CONSTANT VARCHAR2(30) := 'create_shipment';
5751: l_progress VARCHAR2(3) := '000'; --< Bug 3210331 >
7068:
7069: x_kanban_card_id number:='';
7070: x_accrued_flag varchar2(1);
7071: x_po_uom varchar2(25):=null;
7072: x_uom_convert varchar2(2) := fnd_profile.value('PO_REQ_BPA_UOM_CONVERT');
7073: x_conversion_rate number := 1;
7074:
7075: -- Bug 7661419, No conversion for same currency.
7076: x_req_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
7132: FROM po_distributions_all --
7133: WHERE line_location_id = x_line_location_id;
7134:
7135: l_progress:='020';
7136: fnd_profile.get('PO_AUTOCREATE_DATE',x_gl_date_option);
7137:
7138: /* Bug 482648 ecso 4/30/97
7139: * Move quantity conversion from setup_interface_tables
7140: * to create_distribution for consistency
9245: x_asl_id number := null;
9246: x_vendor_product_num varchar2(240) := null;
9247: x_purchasing_uom varchar2(240) := null;
9248: x_pay_on_code varchar2(25) := null;
9249: x_uom_convert varchar2(2) := fnd_profile.value('PO_REQ_BPA_UOM_CONVERT');
9250: x_old_document_num po_headers.segment1%type:=null; -- Bug 700513, lpo, 07/15/98
9251:
9252: x_employee_id number;
9253: x_employee_name varchar2(240);
10640: END IF;
10641:
10642: -- Bug 3201308 start
10643: -- Get the profile option values to determine grouping criteria
10644: l_needby_prf := fnd_profile.value('PO_NEED_BY_GROUPING');
10645: l_shipto_prf := fnd_profile.value('PO_SHIPTO_GROUPING');
10646: l_progress := '010';
10647: -- Bug 3201308 end
10648:
10641:
10642: -- Bug 3201308 start
10643: -- Get the profile option values to determine grouping criteria
10644: l_needby_prf := fnd_profile.value('PO_NEED_BY_GROUPING');
10645: l_shipto_prf := fnd_profile.value('PO_SHIPTO_GROUPING');
10646: l_progress := '010';
10647: -- Bug 3201308 end
10648:
10649: SELECT phi.document_num,
10695: -- For Standard and Planned POs and RFQs, the line number
10696: -- will be the same as the req line number if the profile
10697: -- is set to 'Y' otherwise use sequential numbers
10698:
10699: IF (FND_PROFILE.VALUE('PO_USE_REQ_NUM_IN_AUTOCREATE') = 'Y') THEN
10700:
10701: -- use requisition numbers
10702:
10703: l_progress:='035';
10741: END LOOP;
10742:
10743: CLOSE interface_lines_temp;
10744:
10745: END IF; -- if fnd_profile.value(PO_USE_REQ_NUM...) = 'Y'
10746:
10747: ELSE
10748:
10749: -- Document is release case
10893: -- For Releases, the shipment number will be the same as
10894: -- the req line number if the profile is set, otherwise
10895: -- sequential numbers are used
10896:
10897: IF (FND_PROFILE.VALUE('PO_USE_REQ_NUM_IN_AUTOCREATE')='Y') THEN
10898:
10899: -- use requisition numbers
10900:
10901: l_progress := '100';
10930:
10931: END LOOP;
10932: CLOSE interface_lines_temp;
10933:
10934: END IF; -- if fnd_profile.value(PO_USE_REQ_NUM...) = 'Y'
10935:
10936: END IF; -- release vs. non release case
10937:
10938: ELSE
12500:
12501: /* Bug 3201308 start */
12502: /* Get the profile option values to determine grouping criteria */
12503:
12504: l_needby_prf := fnd_profile.value('PO_NEED_BY_GROUPING');
12505: l_shipto_prf := fnd_profile.value('PO_SHIPTO_GROUPING');
12506:
12507: /* Bug 3201308 end */
12508:
12501: /* Bug 3201308 start */
12502: /* Get the profile option values to determine grouping criteria */
12503:
12504: l_needby_prf := fnd_profile.value('PO_NEED_BY_GROUPING');
12505: l_shipto_prf := fnd_profile.value('PO_SHIPTO_GROUPING');
12506:
12507: /* Bug 3201308 end */
12508:
12509: /* OE drop ship requirement
14945:
14946: l_routing_name RCV_ROUTING_HEADERS.routing_name%TYPE;
14947: l_line_loc_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
14948:
14949: l_po_promised_def_prf VARCHAR2(1) := FND_PROFILE.value('PO_NEED_BY_PROMISE_DEFAULTING');
14950: l_country_of_origin_code VARCHAR2(2);
14951: l_tax_status VARCHAR2(10);
14952: l_encoded_msg VARCHAR2(2000);
14953:
15735: -- po distributions.
15736:
15737: d_progress := 20;
15738:
15739: FND_PROFILE.GET('PO_AUTOCREATE_DATE', l_gl_date_option);
15740:
15741: IF ((params.po_encumbrance_flag = 'Y')
15742: AND (l_gl_date_option <> 'REQ GL DATE')
15743: AND (params.period_name IS NULL)) THEN