DBA Data[Home] [Help]

APPS.PO_COPYDOC_S3 dependencies on STANDARD

Line 210: /* 1780903 : When a bid quotation is copied to a standard or planned PO

206: INTO x_orig_po_header_id
207: FROM po_lines
208: WHERE po_line_id = x_orig_po_line_id;
209:
210: /* 1780903 : When a bid quotation is copied to a standard or planned PO
211: we need to copy the quote reference to the PO . For this we copy the
212: from header and from line from the quote to the PO */
213:
214: select quote_type_lookup_code,

Line 222: and x_to_doc_subtype in ('STANDARD','PLANNED') then

218: from po_headers
219: where po_header_id = x_orig_po_header_id;
220:
221: if x_quote_type = 'QUOTATION' and x_quote_sub_type = 'BID'
222: and x_to_doc_subtype in ('STANDARD','PLANNED') then
223: x_po_line_record.from_header_id := x_orig_po_header_id;
224: x_po_line_record.from_line_id := x_orig_po_line_id;
225: end if;
226:

Line 229: /* It's the same for Blanket, Planned, or Standard PO */

225: end if;
226:
227:
228: IF (x_action_code in ('QUOTATION','RFQ')) THEN
229: /* It's the same for Blanket, Planned, or Standard PO */
230: SELECT quotation_class_code
231: INTO x_quotation_class_code
232: FROM po_headers
233: WHERE po_header_id = x_orig_po_header_id;

Line 317: IF (x_to_doc_subtype = 'STANDARD') THEN -- SERVICES FPJ

313: -- We now use the expiration date as the assignment end date for std PO's for
314: -- service lines
315: -- so if the to document is std PO we null out the value otherwise copy over.
316:
317: IF (x_to_doc_subtype = 'STANDARD') THEN -- SERVICES FPJ
318: x_po_line_record.expiration_date := NULL;
319: END IF;
320:
321: -- SERVICES FPJ Start

Line 328: IF (x_to_doc_subtype = 'STANDARD') AND

324: x_po_line_record.contractor_last_name := NULL;
325:
326: -- As start date is mandatory we need to default it with some value.
327: -- We will be defaulting sysdate.
328: IF (x_to_doc_subtype = 'STANDARD') AND
329: x_po_line_record.start_date is not null THEN
330:
331: x_po_line_record.start_date := trunc(sysdate); -- Bug 3266584
332:

Line 343: -- Standard WHO columns, not inserted

339: x_po_line_record.last_update_login := fnd_global.login_id;
340: x_po_line_record.created_by := fnd_global.user_id;
341: x_po_line_record.creation_date := SYSDATE;
342:
343: -- Standard WHO columns, not inserted
344: x_po_line_record.program_application_id := NULL;
345: x_po_line_record.program_id := NULL;
346: x_po_line_record.program_update_date := NULL;
347: x_po_line_record.request_id := NULL;

Line 370: -- For Blanket, Standard and Planned the negotiated_by_preparer_flag should be

366: x_po_line_record.cancel_flag := 'N';
367: x_po_line_record.cancel_reason := NULL;
368:
369: -- PO DBI FPJ ** Start
370: -- For Blanket, Standard and Planned the negotiated_by_preparer_flag should be
371: -- 'Y' at the time of copying quotation document.
372:
373: -- Bug 3602147: x_quote_sub_type should be either STANDARD or CATALOG
374: -- bug3610606: x_quote_sub_type can be 'BID' as well.

Line 373: -- Bug 3602147: x_quote_sub_type should be either STANDARD or CATALOG

369: -- PO DBI FPJ ** Start
370: -- For Blanket, Standard and Planned the negotiated_by_preparer_flag should be
371: -- 'Y' at the time of copying quotation document.
372:
373: -- Bug 3602147: x_quote_sub_type should be either STANDARD or CATALOG
374: -- bug3610606: x_quote_sub_type can be 'BID' as well.
375:
376: IF x_to_doc_subtype IN ('BLANKET', 'STANDARD', 'PLANNED')
377: AND x_quote_sub_type IN ('STANDARD', 'CATALOG', 'BID') THEN

Line 376: IF x_to_doc_subtype IN ('BLANKET', 'STANDARD', 'PLANNED')

372:
373: -- Bug 3602147: x_quote_sub_type should be either STANDARD or CATALOG
374: -- bug3610606: x_quote_sub_type can be 'BID' as well.
375:
376: IF x_to_doc_subtype IN ('BLANKET', 'STANDARD', 'PLANNED')
377: AND x_quote_sub_type IN ('STANDARD', 'CATALOG', 'BID') THEN
378: --AND x_quote_sub_type NOT IN ('BLANKET', 'STANDARD', 'PLANNED') THEN
379:
380: x_po_line_record.negotiated_by_preparer_flag := 'Y';

Line 377: AND x_quote_sub_type IN ('STANDARD', 'CATALOG', 'BID') THEN

373: -- Bug 3602147: x_quote_sub_type should be either STANDARD or CATALOG
374: -- bug3610606: x_quote_sub_type can be 'BID' as well.
375:
376: IF x_to_doc_subtype IN ('BLANKET', 'STANDARD', 'PLANNED')
377: AND x_quote_sub_type IN ('STANDARD', 'CATALOG', 'BID') THEN
378: --AND x_quote_sub_type NOT IN ('BLANKET', 'STANDARD', 'PLANNED') THEN
379:
380: x_po_line_record.negotiated_by_preparer_flag := 'Y';
381:

Line 378: --AND x_quote_sub_type NOT IN ('BLANKET', 'STANDARD', 'PLANNED') THEN

374: -- bug3610606: x_quote_sub_type can be 'BID' as well.
375:
376: IF x_to_doc_subtype IN ('BLANKET', 'STANDARD', 'PLANNED')
377: AND x_quote_sub_type IN ('STANDARD', 'CATALOG', 'BID') THEN
378: --AND x_quote_sub_type NOT IN ('BLANKET', 'STANDARD', 'PLANNED') THEN
379:
380: x_po_line_record.negotiated_by_preparer_flag := 'Y';
381:
382: END IF;

Line 444: (x_to_doc_subtype in ('STANDARD','PLANNED','BLANKET'))) THEN

440:
441: -- calculate secondary quantity and UOM based on FSP org
442: -- : Null out secondary qty/uom for complex work POs
443: IF ((NOT p_is_complex_work_po) AND
444: (x_to_doc_subtype in ('STANDARD','PLANNED','BLANKET'))) THEN
445: IF x_po_line_record.item_id is not null THEN
446: PO_UOM_S.get_secondary_uom( x_po_line_record.item_id,
447: x_inv_org_id,
448: X_secondary_uom_fsp,