[Home] [Help]
123: ** Get next po_line_id
124: *************************************************************/
125: PROCEDURE validate_line(
126: x_action_code IN VARCHAR2,
127: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,
128: x_po_line_record IN OUT NOCOPY po_lines%ROWTYPE,
129: x_orig_po_line_id IN po_lines.po_line_id%TYPE,
130: x_wip_install_status IN VARCHAR2,
131: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
159: ic_item_cpg_rec IC_ITEM_CPG%ROWTYPE;
160: x_order_opm_um ic_item_mst.item_um%type := NULL;
161: -- end of 1548597
162:
163: x_quote_type po_headers.type_lookup_code%type;
164: x_quote_sub_type po_headers.quote_type_lookup_code%type;
165: --
166: x_secondary_unit_fsp MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
167: x_secondary_uom_fsp MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
160: x_order_opm_um ic_item_mst.item_um%type := NULL;
161: -- end of 1548597
162:
163: x_quote_type po_headers.type_lookup_code%type;
164: x_quote_sub_type po_headers.quote_type_lookup_code%type;
165: --
166: x_secondary_unit_fsp MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
167: x_secondary_uom_fsp MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
168: x_secondary_quantity_fsp po_lines.quantity%type;
306: select quote_type_lookup_code,
307: type_lookup_code
308: into x_quote_sub_type,
309: x_quote_type
310: from po_headers
311: where po_header_id = x_orig_po_header_id;
312:
313: --For Bug 13580685
314: --Allowing copy doc feature to copy the the quotation
323: IF (x_action_code in ('QUOTATION','RFQ')) THEN
324: /* It's the same for Blanket, Planned, or Standard PO */
325: SELECT quotation_class_code
326: INTO x_quotation_class_code
327: FROM po_headers
328: WHERE po_header_id = x_orig_po_header_id;
329:
330: IF (x_quotation_class_code = 'CATALOG') THEN
331: