[Home] [Help]
207:
208: --Bug 16559524 Start
209: x_progress := '00';
210: --Bug 16690546
211: IF x_to_doc_subtype IN ('BLANKET','STANDARD','PLANNED') AND NVL(x_po_line_record.clm_info_flag, 'N') <> 'Y' THEN
212: --Bug 16690546
213: IF PO_DEBUG.is_debug_stmt_on THEN
214: PO_DEBUG.debug_stmt
215: ('po.plsql.PO_COPYDOC_S3.validate_line',
298: INTO x_orig_po_header_id
299: FROM po_lines
300: WHERE po_line_id = x_orig_po_line_id;
301:
302: /* 1780903 : When a bid quotation is copied to a standard or planned PO
303: we need to copy the quote reference to the PO . For this we copy the
304: from header and from line from the quote to the PO */
305:
306: select quote_type_lookup_code,
312:
313: --For Bug 13580685
314: --Allowing copy doc feature to copy the the quotation
315: --to the document created.
316: if x_quote_type = 'QUOTATION' and x_quote_sub_type IN ('BID','CATALOG','STANDARD')
317: and x_to_doc_subtype in ('STANDARD','PLANNED','BLANKET') then
318: x_po_line_record.from_header_id := x_orig_po_header_id;
319: x_po_line_record.from_line_id := x_orig_po_line_id;
320: end if;
313: --For Bug 13580685
314: --Allowing copy doc feature to copy the the quotation
315: --to the document created.
316: if x_quote_type = 'QUOTATION' and x_quote_sub_type IN ('BID','CATALOG','STANDARD')
317: and x_to_doc_subtype in ('STANDARD','PLANNED','BLANKET') then
318: x_po_line_record.from_header_id := x_orig_po_header_id;
319: x_po_line_record.from_line_id := x_orig_po_line_id;
320: end if;
321:
320: end if;
321:
322:
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;
408: -- We now use the expiration date as the assignment end date for std PO's for
409: -- service lines
410: -- so if the to document is std PO we null out the value otherwise copy over.
411:
412: IF (x_to_doc_subtype = 'STANDARD') THEN -- SERVICES FPJ
413: x_po_line_record.expiration_date := NULL;
414: END IF;
415:
416: -- SERVICES FPJ Start
419: x_po_line_record.contractor_last_name := NULL;
420:
421: -- As start date is mandatory we need to default it with some value.
422: -- We will be defaulting sysdate.
423: IF (x_to_doc_subtype = 'STANDARD') AND
424: x_po_line_record.start_date is not null THEN
425:
426: x_po_line_record.start_date := trunc(sysdate); -- Bug 3266584
427:
434: x_po_line_record.last_update_login := fnd_global.login_id;
435: x_po_line_record.created_by := fnd_global.user_id;
436: x_po_line_record.creation_date := SYSDATE;
437:
438: -- Standard WHO columns, not inserted
439: x_po_line_record.program_application_id := NULL;
440: x_po_line_record.program_id := NULL;
441: x_po_line_record.program_update_date := NULL;
442: x_po_line_record.request_id := NULL;
461: x_po_line_record.cancel_flag := 'N';
462: x_po_line_record.cancel_reason := NULL;
463:
464: -- PO DBI FPJ ** Start
465: -- For Blanket, Standard and Planned the negotiated_by_preparer_flag should be
466: -- 'Y' at the time of copying quotation document.
467:
468: -- Bug 3602147: x_quote_sub_type should be either STANDARD or CATALOG
469: -- bug3610606: x_quote_sub_type can be 'BID' as well.
464: -- PO DBI FPJ ** Start
465: -- For Blanket, Standard and Planned the negotiated_by_preparer_flag should be
466: -- 'Y' at the time of copying quotation document.
467:
468: -- Bug 3602147: x_quote_sub_type should be either STANDARD or CATALOG
469: -- bug3610606: x_quote_sub_type can be 'BID' as well.
470:
471: IF x_to_doc_subtype IN ('BLANKET', 'STANDARD', 'PLANNED')
472: AND x_quote_sub_type IN ('STANDARD', 'CATALOG', 'BID') THEN
467:
468: -- Bug 3602147: x_quote_sub_type should be either STANDARD or CATALOG
469: -- bug3610606: x_quote_sub_type can be 'BID' as well.
470:
471: IF x_to_doc_subtype IN ('BLANKET', 'STANDARD', 'PLANNED')
472: AND x_quote_sub_type IN ('STANDARD', 'CATALOG', 'BID') THEN
473: --AND x_quote_sub_type NOT IN ('BLANKET', 'STANDARD', 'PLANNED') THEN
474:
475: x_po_line_record.negotiated_by_preparer_flag := 'Y';
468: -- Bug 3602147: x_quote_sub_type should be either STANDARD or CATALOG
469: -- bug3610606: x_quote_sub_type can be 'BID' as well.
470:
471: IF x_to_doc_subtype IN ('BLANKET', 'STANDARD', 'PLANNED')
472: AND x_quote_sub_type IN ('STANDARD', 'CATALOG', 'BID') THEN
473: --AND x_quote_sub_type NOT IN ('BLANKET', 'STANDARD', 'PLANNED') THEN
474:
475: x_po_line_record.negotiated_by_preparer_flag := 'Y';
476:
469: -- bug3610606: x_quote_sub_type can be 'BID' as well.
470:
471: IF x_to_doc_subtype IN ('BLANKET', 'STANDARD', 'PLANNED')
472: AND x_quote_sub_type IN ('STANDARD', 'CATALOG', 'BID') THEN
473: --AND x_quote_sub_type NOT IN ('BLANKET', 'STANDARD', 'PLANNED') THEN
474:
475: x_po_line_record.negotiated_by_preparer_flag := 'Y';
476:
477: END IF;
541:
542: -- calculate secondary quantity and UOM based on FSP org
543: --
544: IF ((NOT p_is_complex_work_po) AND
545: (x_to_doc_subtype in ('STANDARD','PLANNED','BLANKET'))) THEN
546: IF x_po_line_record.item_id is not null THEN
547: PO_UOM_S.get_secondary_uom( x_po_line_record.item_id,
548: x_inv_org_id,
549: X_secondary_uom_fsp,