eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_COPYDOC_S1 dependencies on STANDARD

Line 449: -- end_date when a standard purchase order is copied from other type

445: ' online_report ID: '||x_online_report_id);
446: END IF;
447:
448: -- Bug #2015328, added decode statements to null out start_date and
449: -- end_date when a standard purchase order is copied from other type
450: -- of docs. This is because the std. purchase order should not have
451: -- the start and end date defined in terms and conditions.
452: INSERT INTO PO_HEADERS (
453: acceptance_due_date,

Line 540: -- Standard WHO column: program_application_id,

536: po_header_id,
537: price_update_tolerance,
538: printed_date,
539: print_count,
540: -- Standard WHO column: program_application_id,
541: -- Standard WHO column: program_id,
542: -- Standard WHO column: program_update_date,
543: quotation_class_code,
544: quote_type_lookup_code,

Line 541: -- Standard WHO column: program_id,

537: price_update_tolerance,
538: printed_date,
539: print_count,
540: -- Standard WHO column: program_application_id,
541: -- Standard WHO column: program_id,
542: -- Standard WHO column: program_update_date,
543: quotation_class_code,
544: quote_type_lookup_code,
545: quote_vendor_quote_number,

Line 542: -- Standard WHO column: program_update_date,

538: printed_date,
539: print_count,
540: -- Standard WHO column: program_application_id,
541: -- Standard WHO column: program_id,
542: -- Standard WHO column: program_update_date,
543: quotation_class_code,
544: quote_type_lookup_code,
545: quote_vendor_quote_number,
546: quote_warning_delay,

Line 554: -- Standard WHO column: request_id,

550: rate_type,
551: reference_num,
552: reply_date,
553: reply_method_lookup_code,
554: -- Standard WHO column: request_id,
555: revised_date,
556: revision_num,
557: rfq_close_date,
558: segment1,

Line 631: decode(x_po_header_record.type_lookup_code, 'STANDARD', to_date(NULL),

627: x_po_header_record.currency_code,
628: x_po_header_record.edi_processed_flag,
629: x_po_header_record.edi_processed_status,
630: x_po_header_record.enabled_flag,
631: decode(x_po_header_record.type_lookup_code, 'STANDARD', to_date(NULL),
632: x_po_header_record.end_date), -- Bug #2015328 BUG #5743193
633: x_po_header_record.end_date_active,
634: x_po_header_record.firm_date,
635: x_po_header_record.firm_status_lookup_code,

Line 683: -- Standard WHO column: x_po_header_record.program_application_id,

679: x_po_header_record.po_header_id,
680: x_po_header_record.price_update_tolerance,
681: x_po_header_record.printed_date,
682: x_po_header_record.print_count,
683: -- Standard WHO column: x_po_header_record.program_application_id,
684: -- Standard WHO column: x_po_header_record.program_id,
685: -- Standard WHO column: x_po_header_record.program_update_date,
686: x_po_header_record.quotation_class_code,
687: x_po_header_record.quote_type_lookup_code,

Line 684: -- Standard WHO column: x_po_header_record.program_id,

680: x_po_header_record.price_update_tolerance,
681: x_po_header_record.printed_date,
682: x_po_header_record.print_count,
683: -- Standard WHO column: x_po_header_record.program_application_id,
684: -- Standard WHO column: x_po_header_record.program_id,
685: -- Standard WHO column: x_po_header_record.program_update_date,
686: x_po_header_record.quotation_class_code,
687: x_po_header_record.quote_type_lookup_code,
688: x_po_header_record.quote_vendor_quote_number,

Line 685: -- Standard WHO column: x_po_header_record.program_update_date,

681: x_po_header_record.printed_date,
682: x_po_header_record.print_count,
683: -- Standard WHO column: x_po_header_record.program_application_id,
684: -- Standard WHO column: x_po_header_record.program_id,
685: -- Standard WHO column: x_po_header_record.program_update_date,
686: x_po_header_record.quotation_class_code,
687: x_po_header_record.quote_type_lookup_code,
688: x_po_header_record.quote_vendor_quote_number,
689: x_po_header_record.quote_warning_delay,

Line 697: -- Standard WHO column: x_po_header_record.request_id,

693: x_po_header_record.rate_type,
694: x_po_header_record.reference_num,
695: x_po_header_record.reply_date,
696: x_po_header_record.reply_method_lookup_code,
697: -- Standard WHO column: x_po_header_record.request_id,
698: x_po_header_record.revised_date,
699: x_po_header_record.revision_num,
700: x_po_header_record.rfq_close_date,
701: x_po_header_record.segment1,

Line 708: decode(x_po_header_record.type_lookup_code, 'STANDARD' , to_date(NULL),

704: x_po_header_record.segment4,
705: x_po_header_record.segment5,
706: x_po_header_record.ship_to_location_id,
707: x_po_header_record.ship_via_lookup_code,
708: decode(x_po_header_record.type_lookup_code, 'STANDARD' , to_date(NULL),
709: x_po_header_record.start_date), -- Bug #2015328 Bug #5743193
710: x_po_header_record.start_date_active,
711: x_po_header_record.status_lookup_code,
712: x_po_header_record.summary_flag,

Line 1176: --bug #2717053: changed var names/types to conform to standards

1172: ) IS
1173:
1174: l_progress VARCHAR2(4);
1175:
1176: --bug #2717053: changed var names/types to conform to standards
1177: l_vendor_site_id po_headers.vendor_site_id%TYPE := null;
1178: l_to_ship_to_location_id po_line_locations.ship_to_location_id%TYPE;
1179: l_to_ship_to_organization_id po_line_locations.ship_to_organization_id%TYPE;
1180: l_item_id po_lines.item_id%TYPE := null;

Line 1293: IF (l_quote_type_code IN ('CATALOG', 'STANDARD')) THEN

1289: When others then
1290: l_quote_type_code := NULL;
1291: End;
1292:
1293: IF (l_quote_type_code IN ('CATALOG', 'STANDARD')) THEN
1294: --note: we don't do any defaulting for Bid RFQs/Quotes.
1295: --since we can not copy a document INTO a Bid RFQ, we
1296: --dont' have to worry about consistency with Forms entry
1297:

Line 1412: IF (x_po_shipment_record.shipment_type = 'STANDARD') THEN

1408: l_progress := '090';
1409:
1410: -- CONSIGNED FPI START
1411: -- Bug Fix for #2697755: COPY PO WITH CONSIGNED SHIPMENT LINE FAILS
1412: IF (x_po_shipment_record.shipment_type = 'STANDARD') THEN
1413:
1414: IF(l_to_ship_to_organization_id IS NOT NULL AND
1415: l_item_id IS NOT NULL)
1416: THEN

Line 1469: END IF; --end if shipment_type is STANDARD

1465: l_receipt_required_flag := 'N';
1466: l_match_option := 'P';
1467: END IF;
1468: END IF;
1469: END IF; --end if shipment_type is STANDARD
1470: -- CONSIGNED FPI END
1471:
1472: END IF; --end check of shipment_type
1473: --bug #2717053: end of reorganized defaulting logic for RFQs/Quotations

Line 1490: (x_po_shipment_record.shipment_type IN ('STANDARD','PLANNED'))) THEN

1486:
1487: -- : Default null for secondary fields on complex work po
1488:
1489: IF ((NOT p_is_complex_work_po) AND
1490: (x_po_shipment_record.shipment_type IN ('STANDARD','PLANNED'))) THEN
1491: IF x_secondary_quantity IS NULL and l_item_id IS NOT NULL THEN
1492:
1493: po_uom_s.get_secondary_uom(l_item_id,
1494: l_to_ship_to_organization_id,

Line 1601: -- Standard WHO column: program_application_id

1597: po_line_id,
1598: po_release_id,
1599: price_discount,
1600: price_override,
1601: -- Standard WHO column: program_application_id
1602: -- Standard WHO column: program_id
1603: -- Standard WHO column: program_update_date
1604: promised_date,
1605: qty_rcv_exception_code,

Line 1602: -- Standard WHO column: program_id

1598: po_release_id,
1599: price_discount,
1600: price_override,
1601: -- Standard WHO column: program_application_id
1602: -- Standard WHO column: program_id
1603: -- Standard WHO column: program_update_date
1604: promised_date,
1605: qty_rcv_exception_code,
1606: qty_rcv_tolerance,

Line 1603: -- Standard WHO column: program_update_date

1599: price_discount,
1600: price_override,
1601: -- Standard WHO column: program_application_id
1602: -- Standard WHO column: program_id
1603: -- Standard WHO column: program_update_date
1604: promised_date,
1605: qty_rcv_exception_code,
1606: qty_rcv_tolerance,
1607: quantity,

Line 1618: -- Standard WHO column: request_id

1614: receipt_days_exception_code,
1615: receipt_required_flag,
1616: receive_close_tolerance,
1617: receiving_routing_id,
1618: -- Standard WHO column: request_id
1619: shipment_num,
1620: shipment_type,
1621: ship_to_location_id,
1622: ship_to_organization_id,

Line 1763: -- Standard WHO column: x_po_shipment_record.program_application_id

1759: x_po_shipment_record.po_line_id,
1760: x_po_shipment_record.po_release_id,
1761: x_po_shipment_record.price_discount,
1762: x_po_shipment_record.price_override,
1763: -- Standard WHO column: x_po_shipment_record.program_application_id
1764: -- Standard WHO column: x_po_shipment_record.program_id
1765: -- Standard WHO column: x_po_shipment_record.program_update_date
1766: x_po_shipment_record.promised_date,
1767: x_po_shipment_record.qty_rcv_exception_code,

Line 1764: -- Standard WHO column: x_po_shipment_record.program_id

1760: x_po_shipment_record.po_release_id,
1761: x_po_shipment_record.price_discount,
1762: x_po_shipment_record.price_override,
1763: -- Standard WHO column: x_po_shipment_record.program_application_id
1764: -- Standard WHO column: x_po_shipment_record.program_id
1765: -- Standard WHO column: x_po_shipment_record.program_update_date
1766: x_po_shipment_record.promised_date,
1767: x_po_shipment_record.qty_rcv_exception_code,
1768: x_po_shipment_record.qty_rcv_tolerance,

Line 1765: -- Standard WHO column: x_po_shipment_record.program_update_date

1761: x_po_shipment_record.price_discount,
1762: x_po_shipment_record.price_override,
1763: -- Standard WHO column: x_po_shipment_record.program_application_id
1764: -- Standard WHO column: x_po_shipment_record.program_id
1765: -- Standard WHO column: x_po_shipment_record.program_update_date
1766: x_po_shipment_record.promised_date,
1767: x_po_shipment_record.qty_rcv_exception_code,
1768: x_po_shipment_record.qty_rcv_tolerance,
1769: l_quantity, --bug#2717053

Line 1781: -- Standard WHO column: x_po_shipment_record.request_id

1777: --x_po_shipment_record.receipt_required_flag,
1778: l_receipt_required_flag, -- CONSIGNED FPI
1779: x_po_shipment_record.receive_close_tolerance, -- Bug 2761415
1780: x_po_shipment_record.receiving_routing_id,
1781: -- Standard WHO column: x_po_shipment_record.request_id
1782: x_po_shipment_record.shipment_num,
1783: x_po_shipment_record.shipment_type,
1784: l_to_ship_to_location_id, --bug#2717053
1785: l_to_ship_to_organization_id, --bug#2717053

Line 2000: -- Standard WHO column: program_application_id

1996: po_header_id,
1997: po_line_id,
1998: po_release_id,
1999: prevent_encumbrance_flag,
2000: -- Standard WHO column: program_application_id
2001: -- Standard WHO column: program_id
2002: -- Standard WHO column: program_update_date
2003: project_accounting_context,
2004: project_id,

Line 2001: -- Standard WHO column: program_id

1997: po_line_id,
1998: po_release_id,
1999: prevent_encumbrance_flag,
2000: -- Standard WHO column: program_application_id
2001: -- Standard WHO column: program_id
2002: -- Standard WHO column: program_update_date
2003: project_accounting_context,
2004: project_id,
2005: quantity_billed,

Line 2002: -- Standard WHO column: program_update_date

1998: po_release_id,
1999: prevent_encumbrance_flag,
2000: -- Standard WHO column: program_application_id
2001: -- Standard WHO column: program_id
2002: -- Standard WHO column: program_update_date
2003: project_accounting_context,
2004: project_id,
2005: quantity_billed,
2006: quantity_cancelled,

Line 2013: -- Standard WHO column: request_id

2009: rate,
2010: rate_date,
2011: recoverable_tax,
2012: recovery_rate,
2013: -- Standard WHO column: request_id
2014: req_distribution_id,
2015: req_header_reference_num,
2016: req_line_reference_num,
2017: set_of_books_id,

Line 2109: -- Standard WHO column: x_po_distribution_record.program_application_id

2105: x_po_distribution_record.po_header_id,
2106: x_po_distribution_record.po_line_id,
2107: x_po_distribution_record.po_release_id,
2108: x_po_distribution_record.prevent_encumbrance_flag,
2109: -- Standard WHO column: x_po_distribution_record.program_application_id
2110: -- Standard WHO column: x_po_distribution_record.program_id
2111: -- Standard WHO column: x_po_distribution_record.program_update_date
2112: x_po_distribution_record.project_accounting_context,
2113: x_po_distribution_record.project_id,

Line 2110: -- Standard WHO column: x_po_distribution_record.program_id

2106: x_po_distribution_record.po_line_id,
2107: x_po_distribution_record.po_release_id,
2108: x_po_distribution_record.prevent_encumbrance_flag,
2109: -- Standard WHO column: x_po_distribution_record.program_application_id
2110: -- Standard WHO column: x_po_distribution_record.program_id
2111: -- Standard WHO column: x_po_distribution_record.program_update_date
2112: x_po_distribution_record.project_accounting_context,
2113: x_po_distribution_record.project_id,
2114: x_po_distribution_record.quantity_billed,

Line 2111: -- Standard WHO column: x_po_distribution_record.program_update_date

2107: x_po_distribution_record.po_release_id,
2108: x_po_distribution_record.prevent_encumbrance_flag,
2109: -- Standard WHO column: x_po_distribution_record.program_application_id
2110: -- Standard WHO column: x_po_distribution_record.program_id
2111: -- Standard WHO column: x_po_distribution_record.program_update_date
2112: x_po_distribution_record.project_accounting_context,
2113: x_po_distribution_record.project_id,
2114: x_po_distribution_record.quantity_billed,
2115: x_po_distribution_record.quantity_cancelled,

Line 2122: -- Standard WHO column: x_po_distribution_record.request_id

2118: x_po_distribution_record.rate,
2119: x_po_distribution_record.rate_date,
2120: x_po_distribution_record.recoverable_tax,
2121: x_po_distribution_record.recovery_rate,
2122: -- Standard WHO column: x_po_distribution_record.request_id
2123: x_po_distribution_record.req_distribution_id,
2124: x_po_distribution_record.req_header_reference_num,
2125: x_po_distribution_record.req_line_reference_num,
2126: x_po_distribution_record.set_of_books_id,

Line 2388: ELSIF (l_po_from_document_type = 'STANDARD') THEN

2384:
2385: -- decode source document type for contracts
2386: IF (l_po_from_document_type IN ('CONTRACT', 'BLANKET')) THEN
2387: l_contracts_from_document_type := 'PA_'||l_po_from_document_type;
2388: ELSIF (l_po_from_document_type = 'STANDARD') THEN
2389: l_contracts_from_document_type := 'PO_'||l_po_from_document_type;
2390: END IF;
2391:
2392: -- x_po_header_record now contains new po header

Line 2396: ELSIF (x_po_header_record.type_lookup_code = 'STANDARD') THEN

2392: -- x_po_header_record now contains new po header
2393: -- decode target document type for contracts
2394: IF (x_po_header_record.type_lookup_code IN ( 'CONTRACT', 'BLANKET')) THEN
2395: l_contracts_to_document_type := 'PA_'|| x_po_header_record.type_lookup_code;
2396: ELSIF (x_po_header_record.type_lookup_code = 'STANDARD') THEN
2397: l_contracts_to_document_type := 'PO_'|| x_po_header_record.type_lookup_code;
2398: END IF;
2399:
2400: -- call contracts API to copy terms and deliverables

Line 2654: if x_to_doc_subtype = 'STANDARD' then

2650: -- Services FPJ Start
2651: -- After line insertion copy the price differentials related to the new line
2652: -- if any price differentials exist.
2653:
2654: if x_to_doc_subtype = 'STANDARD' then
2655: l_entity_type := 'PO LINE';
2656: else
2657: l_entity_type := 'BLANKET LINE';
2658: end if;

Line 3233: -- Standard start of API savepoint

3229: x_to_doc_subtype||' from header ID: '||x_from_po_header_id||
3230: ' to segment1: '||x_to_segment1||' agent ID: '||x_agent_id||
3231: ' sob ID: '||x_sob_id);
3232: END IF;
3233: -- Standard start of API savepoint
3234: SAVEPOINT COPY_DOCUMENT_PVT;
3235: x_to_po_header_id := NULL;
3236:
3237: x_progress := '000';

Line 3269: ((x_to_doc_subtype = 'STANDARD') OR (x_to_doc_subtype = 'CONTRACT')))

3265: IF (l_is_complex_work_po AND
3266: ( NOT(
3267: (x_action_code = 'PO')
3268: AND
3269: ((x_to_doc_subtype = 'STANDARD') OR (x_to_doc_subtype = 'CONTRACT')))
3270: ))
3271: THEN
3272: RAISE COPYDOC_FATAL;
3273: END IF;

Line 3282: IF (x_to_doc_subtype IN ('STANDARD', 'PLANNED')) THEN

3278: x_progress := '020';
3279: --
3280: -- Initialize global variable for tax. It will
3281: -- be used for insertion into header, line, shipment and distribution
3282: IF (x_to_doc_subtype IN ('STANDARD', 'PLANNED')) THEN
3283: IF (p_from_doc_type = 'QUOTATION') THEN
3284: g_tax_attribute_update_code := 'CREATE';
3285: l_calling_program :='COPY_QUOTE';
3286: ELSE