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 489: IF (x_po_header_record.type_lookup_code = 'STANDARD'

485: in case AME transaction type is populated in Style Headers page*/
486: -- Start : PO AME Approval workflow
487: l_ame_approval_id := null;
488: l_ame_transaction_type := NULL;
489: IF (x_po_header_record.type_lookup_code = 'STANDARD'
490: OR (x_po_header_record.type_lookup_code in ('BLANKET','CONTRACT')
491: AND nvl(x_po_header_record.global_agreement_flag,'N') = 'Y')) THEN
492: BEGIN
493: SELECT po_ame_approvals_s.NEXTVAL, ame_transaction_type

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

511: p_doc_sub_type => x_po_header_record.type_lookup_code);
512: --
513:
514: -- Bug #2015328, added decode statements to null out start_date and
515: -- end_date when a standard purchase order is copied from other type
516: -- of docs. This is because the std. purchase order should not have
517: -- the start and end date defined in terms and conditions.
518: INSERT INTO PO_HEADERS (
519: acceptance_due_date,

Line 606: -- Standard WHO column: program_application_id,

602: po_header_id,
603: price_update_tolerance,
604: printed_date,
605: print_count,
606: -- Standard WHO column: program_application_id,
607: -- Standard WHO column: program_id,
608: -- Standard WHO column: program_update_date,
609: quotation_class_code,
610: quote_type_lookup_code,

Line 607: -- Standard WHO column: program_id,

603: price_update_tolerance,
604: printed_date,
605: print_count,
606: -- Standard WHO column: program_application_id,
607: -- Standard WHO column: program_id,
608: -- Standard WHO column: program_update_date,
609: quotation_class_code,
610: quote_type_lookup_code,
611: quote_vendor_quote_number,

Line 608: -- Standard WHO column: program_update_date,

604: printed_date,
605: print_count,
606: -- Standard WHO column: program_application_id,
607: -- Standard WHO column: program_id,
608: -- Standard WHO column: program_update_date,
609: quotation_class_code,
610: quote_type_lookup_code,
611: quote_vendor_quote_number,
612: quote_warning_delay,

Line 620: -- Standard WHO column: request_id,

616: rate_type,
617: reference_num,
618: reply_date,
619: reply_method_lookup_code,
620: -- Standard WHO column: request_id,
621: revised_date,
622: revision_num,
623: rfq_close_date,
624: segment1,

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

700: x_po_header_record.currency_code,
701: x_po_header_record.edi_processed_flag,
702: x_po_header_record.edi_processed_status,
703: x_po_header_record.enabled_flag,
704: decode(x_po_header_record.type_lookup_code, 'STANDARD', to_date(NULL),
705: x_po_header_record.end_date), -- Bug #2015328 BUG #5743193
706: x_po_header_record.end_date_active,
707: x_po_header_record.firm_date,
708: x_po_header_record.firm_status_lookup_code,

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

752: x_po_header_record.po_header_id,
753: x_po_header_record.price_update_tolerance,
754: x_po_header_record.printed_date,
755: x_po_header_record.print_count,
756: -- Standard WHO column: x_po_header_record.program_application_id,
757: -- Standard WHO column: x_po_header_record.program_id,
758: -- Standard WHO column: x_po_header_record.program_update_date,
759: x_po_header_record.quotation_class_code,
760: x_po_header_record.quote_type_lookup_code,

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

753: x_po_header_record.price_update_tolerance,
754: x_po_header_record.printed_date,
755: x_po_header_record.print_count,
756: -- Standard WHO column: x_po_header_record.program_application_id,
757: -- Standard WHO column: x_po_header_record.program_id,
758: -- Standard WHO column: x_po_header_record.program_update_date,
759: x_po_header_record.quotation_class_code,
760: x_po_header_record.quote_type_lookup_code,
761: x_po_header_record.quote_vendor_quote_number,

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

754: x_po_header_record.printed_date,
755: x_po_header_record.print_count,
756: -- Standard WHO column: x_po_header_record.program_application_id,
757: -- Standard WHO column: x_po_header_record.program_id,
758: -- Standard WHO column: x_po_header_record.program_update_date,
759: x_po_header_record.quotation_class_code,
760: x_po_header_record.quote_type_lookup_code,
761: x_po_header_record.quote_vendor_quote_number,
762: x_po_header_record.quote_warning_delay,

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

766: x_po_header_record.rate_type,
767: x_po_header_record.reference_num,
768: x_po_header_record.reply_date,
769: x_po_header_record.reply_method_lookup_code,
770: -- Standard WHO column: x_po_header_record.request_id,
771: x_po_header_record.revised_date,
772: x_po_header_record.revision_num,
773: x_po_header_record.rfq_close_date,
774: x_po_header_record.segment1,

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

777: x_po_header_record.segment4,
778: x_po_header_record.segment5,
779: x_po_header_record.ship_to_location_id,
780: x_po_header_record.ship_via_lookup_code,
781: decode(x_po_header_record.type_lookup_code, 'STANDARD' , to_date(NULL),
782: x_po_header_record.start_date), -- Bug #2015328 Bug #5743193
783: x_po_header_record.start_date_active,
784: x_po_header_record.status_lookup_code,
785: x_po_header_record.summary_flag,

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

1292: ) IS
1293:
1294: l_progress VARCHAR2(4);
1295:
1296: --bug #2717053: changed var names/types to conform to standards
1297: l_vendor_site_id po_headers.vendor_site_id%TYPE := null;
1298: l_to_ship_to_location_id po_line_locations.ship_to_location_id%TYPE;
1299: l_to_ship_to_organization_id po_line_locations.ship_to_organization_id%TYPE;
1300: l_item_id po_lines.item_id%TYPE := null;

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

1418: When others then
1419: l_quote_type_code := NULL;
1420: End;
1421:
1422: IF (l_quote_type_code IN ('CATALOG', 'STANDARD')) THEN
1423: --note: we don't do any defaulting for Bid RFQs/Quotes.
1424: --since we can not copy a document INTO a Bid RFQ, we
1425: --dont' have to worry about consistency with Forms entry
1426:

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

1537: l_progress := '090';
1538:
1539: -- CONSIGNED FPI START
1540: -- Bug Fix for #2697755: COPY PO WITH CONSIGNED SHIPMENT LINE FAILS
1541: IF (x_po_shipment_record.shipment_type = 'STANDARD') THEN
1542:
1543: IF(l_to_ship_to_organization_id IS NOT NULL AND
1544: l_item_id IS NOT NULL)
1545: THEN

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

1594: l_receipt_required_flag := 'N';
1595: l_match_option := 'P';
1596: END IF;
1597: END IF;
1598: END IF; --end if shipment_type is STANDARD
1599: -- CONSIGNED FPI END
1600:
1601: END IF; --end check of shipment_type
1602: --bug #2717053: end of reorganized defaulting logic for RFQs/Quotations

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

1615:
1616: -- : Default null for secondary fields on complex work po
1617:
1618: IF ((NOT p_is_complex_work_po) AND
1619: (x_po_shipment_record.shipment_type IN ('STANDARD','PLANNED'))) THEN
1620: IF x_secondary_quantity IS NULL and l_item_id IS NOT NULL THEN
1621:
1622: po_uom_s.get_secondary_uom(l_item_id,
1623: l_to_ship_to_organization_id,

Line 1730: -- Standard WHO column: program_application_id

1726: po_line_id,
1727: po_release_id,
1728: price_discount,
1729: price_override,
1730: -- Standard WHO column: program_application_id
1731: -- Standard WHO column: program_id
1732: -- Standard WHO column: program_update_date
1733: promised_date,
1734: qty_rcv_exception_code,

Line 1731: -- Standard WHO column: program_id

1727: po_release_id,
1728: price_discount,
1729: price_override,
1730: -- Standard WHO column: program_application_id
1731: -- Standard WHO column: program_id
1732: -- Standard WHO column: program_update_date
1733: promised_date,
1734: qty_rcv_exception_code,
1735: qty_rcv_tolerance,

Line 1732: -- Standard WHO column: program_update_date

1728: price_discount,
1729: price_override,
1730: -- Standard WHO column: program_application_id
1731: -- Standard WHO column: program_id
1732: -- Standard WHO column: program_update_date
1733: promised_date,
1734: qty_rcv_exception_code,
1735: qty_rcv_tolerance,
1736: quantity,

Line 1747: -- Standard WHO column: request_id

1743: receipt_days_exception_code,
1744: receipt_required_flag,
1745: receive_close_tolerance,
1746: receiving_routing_id,
1747: -- Standard WHO column: request_id
1748: shipment_num,
1749: shipment_type,
1750: ship_to_location_id,
1751: ship_to_organization_id,

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

1899: x_po_shipment_record.po_line_id,
1900: x_po_shipment_record.po_release_id,
1901: x_po_shipment_record.price_discount,
1902: x_po_shipment_record.price_override,
1903: -- Standard WHO column: x_po_shipment_record.program_application_id
1904: -- Standard WHO column: x_po_shipment_record.program_id
1905: -- Standard WHO column: x_po_shipment_record.program_update_date
1906: decode(l_clm_delivery_event_code, --
1907: null, x_po_shipment_record.promised_date,

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

1900: x_po_shipment_record.po_release_id,
1901: x_po_shipment_record.price_discount,
1902: x_po_shipment_record.price_override,
1903: -- Standard WHO column: x_po_shipment_record.program_application_id
1904: -- Standard WHO column: x_po_shipment_record.program_id
1905: -- Standard WHO column: x_po_shipment_record.program_update_date
1906: decode(l_clm_delivery_event_code, --
1907: null, x_po_shipment_record.promised_date,
1908: null),

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

1901: x_po_shipment_record.price_discount,
1902: x_po_shipment_record.price_override,
1903: -- Standard WHO column: x_po_shipment_record.program_application_id
1904: -- Standard WHO column: x_po_shipment_record.program_id
1905: -- Standard WHO column: x_po_shipment_record.program_update_date
1906: decode(l_clm_delivery_event_code, --
1907: null, x_po_shipment_record.promised_date,
1908: null),
1909: x_po_shipment_record.qty_rcv_exception_code,

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

1919: --x_po_shipment_record.receipt_required_flag,
1920: l_receipt_required_flag, -- CONSIGNED FPI
1921: x_po_shipment_record.receive_close_tolerance, -- Bug 2761415
1922: x_po_shipment_record.receiving_routing_id,
1923: -- Standard WHO column: x_po_shipment_record.request_id
1924: x_po_shipment_record.shipment_num,
1925: x_po_shipment_record.shipment_type,
1926: l_to_ship_to_location_id, --bug#2717053
1927: l_to_ship_to_organization_id, --bug#2717053

Line 2148: -- Standard WHO column: program_application_id

2144: po_header_id,
2145: po_line_id,
2146: po_release_id,
2147: prevent_encumbrance_flag,
2148: -- Standard WHO column: program_application_id
2149: -- Standard WHO column: program_id
2150: -- Standard WHO column: program_update_date
2151: project_accounting_context,
2152: project_id,

Line 2149: -- Standard WHO column: program_id

2145: po_line_id,
2146: po_release_id,
2147: prevent_encumbrance_flag,
2148: -- Standard WHO column: program_application_id
2149: -- Standard WHO column: program_id
2150: -- Standard WHO column: program_update_date
2151: project_accounting_context,
2152: project_id,
2153: quantity_billed,

Line 2150: -- Standard WHO column: program_update_date

2146: po_release_id,
2147: prevent_encumbrance_flag,
2148: -- Standard WHO column: program_application_id
2149: -- Standard WHO column: program_id
2150: -- Standard WHO column: program_update_date
2151: project_accounting_context,
2152: project_id,
2153: quantity_billed,
2154: quantity_cancelled,

Line 2161: -- Standard WHO column: request_id

2157: rate,
2158: rate_date,
2159: recoverable_tax,
2160: recovery_rate,
2161: -- Standard WHO column: request_id
2162: req_distribution_id,
2163: req_header_reference_num,
2164: req_line_reference_num,
2165: set_of_books_id,

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

2261: x_po_distribution_record.po_header_id,
2262: x_po_distribution_record.po_line_id,
2263: x_po_distribution_record.po_release_id,
2264: x_po_distribution_record.prevent_encumbrance_flag,
2265: -- Standard WHO column: x_po_distribution_record.program_application_id
2266: -- Standard WHO column: x_po_distribution_record.program_id
2267: -- Standard WHO column: x_po_distribution_record.program_update_date
2268: x_po_distribution_record.project_accounting_context,
2269: x_po_distribution_record.project_id,

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

2262: x_po_distribution_record.po_line_id,
2263: x_po_distribution_record.po_release_id,
2264: x_po_distribution_record.prevent_encumbrance_flag,
2265: -- Standard WHO column: x_po_distribution_record.program_application_id
2266: -- Standard WHO column: x_po_distribution_record.program_id
2267: -- Standard WHO column: x_po_distribution_record.program_update_date
2268: x_po_distribution_record.project_accounting_context,
2269: x_po_distribution_record.project_id,
2270: x_po_distribution_record.quantity_billed,

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

2263: x_po_distribution_record.po_release_id,
2264: x_po_distribution_record.prevent_encumbrance_flag,
2265: -- Standard WHO column: x_po_distribution_record.program_application_id
2266: -- Standard WHO column: x_po_distribution_record.program_id
2267: -- Standard WHO column: x_po_distribution_record.program_update_date
2268: x_po_distribution_record.project_accounting_context,
2269: x_po_distribution_record.project_id,
2270: x_po_distribution_record.quantity_billed,
2271: x_po_distribution_record.quantity_cancelled,

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

2274: x_po_distribution_record.rate,
2275: x_po_distribution_record.rate_date,
2276: x_po_distribution_record.recoverable_tax,
2277: x_po_distribution_record.recovery_rate,
2278: -- Standard WHO column: x_po_distribution_record.request_id
2279: x_po_distribution_record.req_distribution_id,
2280: x_po_distribution_record.req_header_reference_num,
2281: x_po_distribution_record.req_line_reference_num,
2282: x_po_distribution_record.set_of_books_id,

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

2554:
2555: -- decode source document type for contracts
2556: IF (l_po_from_document_type IN ('CONTRACT', 'BLANKET')) THEN
2557: l_contracts_from_document_type := 'PA_'||l_po_from_document_type;
2558: ELSIF (l_po_from_document_type = 'STANDARD') THEN
2559: l_contracts_from_document_type := 'PO_'||l_po_from_document_type;
2560: END IF;
2561:
2562: -- x_po_header_record now contains new po header

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

2562: -- x_po_header_record now contains new po header
2563: -- decode target document type for contracts
2564: IF (x_po_header_record.type_lookup_code IN ( 'CONTRACT', 'BLANKET')) THEN
2565: l_contracts_to_document_type := 'PA_'|| x_po_header_record.type_lookup_code;
2566: ELSIF (x_po_header_record.type_lookup_code = 'STANDARD') THEN
2567: l_contracts_to_document_type := 'PO_'|| x_po_header_record.type_lookup_code;
2568: END IF;
2569:
2570: -- call contracts API to copy terms and deliverables

Line 2979: if x_to_doc_subtype = 'STANDARD' then

2975: -- Services FPJ Start
2976: -- After line insertion copy the price differentials related to the new line
2977: -- if any price differentials exist.
2978:
2979: if x_to_doc_subtype = 'STANDARD' then
2980: l_entity_type := 'PO LINE';
2981: else
2982: l_entity_type := 'BLANKET LINE';
2983: end if;

Line 3586: -- Standard start of API savepoint

3582: x_to_doc_subtype||' from header ID: '||x_from_po_header_id||
3583: ' to segment1: '||x_to_segment1||' agent ID: '||x_agent_id||
3584: ' sob ID: '||x_sob_id);
3585: END IF;
3586: -- Standard start of API savepoint
3587: SAVEPOINT COPY_DOCUMENT_PVT;
3588: x_to_po_header_id := NULL;
3589:
3590: x_progress := '000';

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

3618: IF (l_is_complex_work_po AND
3619: ( NOT(
3620: (x_action_code = 'PO')
3621: AND
3622: ((x_to_doc_subtype = 'STANDARD') OR (x_to_doc_subtype = 'CONTRACT')))
3623: ))
3624: THEN
3625: RAISE COPYDOC_FATAL;
3626: END IF;

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

3631: x_progress := '020';
3632: --
3633: -- Initialize global variable for tax. It will
3634: -- be used for insertion into header, line, shipment and distribution
3635: IF (x_to_doc_subtype IN ('STANDARD', 'PLANNED')) THEN
3636: IF (p_from_doc_type = 'QUOTATION') THEN
3637: g_tax_attribute_update_code := 'CREATE';
3638: l_calling_program :='COPY_QUOTE';
3639: ELSE

Line 3942: IF(x_internal_return_code = 0 AND (x_orig_quotation_class_code = 'BID' OR (x_action_code='PO' AND (x_to_doc_subtype = 'STANDARD' OR x_to_doc_subtype = 'PLANNED') AND NOT l_is_complex_work_po))) THEN

3938: END IF;
3939: --< Shared Proc FPJ End >
3940:
3941: -- Modified the condition for Bug 9783916 ,now this block is for BID, Std PO and Planned PO
3942: IF(x_internal_return_code = 0 AND (x_orig_quotation_class_code = 'BID' OR (x_action_code='PO' AND (x_to_doc_subtype = 'STANDARD' OR x_to_doc_subtype = 'PLANNED') AND NOT l_is_complex_work_po))) THEN
3943: x_line_quantity := x_line_quantity + nvl(x_po_shipment_record.quantity, 0);
3944: END IF;
3945:
3946: --Bug 12547526

Line 3955: IF( l_is_complex_finance_po LIKE 'Y' AND x_po_shipment_record.shipment_type LIKE 'STANDARD') THEN

3951: FROM po_doc_style_headers
3952: WHERE style_id = (SELECT style_id FROM po_headers_all WHERE po_header_id = x_from_po_header_id);
3953:
3954:
3955: IF( l_is_complex_finance_po LIKE 'Y' AND x_po_shipment_record.shipment_type LIKE 'STANDARD') THEN
3956:
3957: x_line_quantity := x_line_quantity + Nvl(x_po_shipment_record.quantity,0); --Add the shipment quantities of STANDARD type for Complex Services (Finance) PO.
3958:
3959: ELSIF l_is_complex_finance_po LIKE 'N' THEN

Line 3957: x_line_quantity := x_line_quantity + Nvl(x_po_shipment_record.quantity,0); --Add the shipment quantities of STANDARD type for Complex Services (Finance) PO.

3953:
3954:
3955: IF( l_is_complex_finance_po LIKE 'Y' AND x_po_shipment_record.shipment_type LIKE 'STANDARD') THEN
3956:
3957: x_line_quantity := x_line_quantity + Nvl(x_po_shipment_record.quantity,0); --Add the shipment quantities of STANDARD type for Complex Services (Finance) PO.
3958:
3959: ELSIF l_is_complex_finance_po LIKE 'N' THEN
3960:
3961: x_line_quantity := Nvl(x_po_shipment_record.quantity,0); -- Copy any one of the shipment quantities for Complex Services (Actuals) PO.

Line 4047: IF (x_orig_quotation_class_code = 'BID' OR (x_action_code='PO' AND (x_to_doc_subtype = 'STANDARD' OR x_to_doc_subtype = 'PLANNED'))) THEN

4043: CLOSE po_shipment_cursor;
4044:
4045: /* got total quantity from all shipments under the line */
4046: -- Modified the condition for Bug 9783916 ,now this block is for BID, Std PO and Planned PO
4047: IF (x_orig_quotation_class_code = 'BID' OR (x_action_code='PO' AND (x_to_doc_subtype = 'STANDARD' OR x_to_doc_subtype = 'PLANNED'))) THEN
4048: x_progress := '090';
4049:
4050: UPDATE PO_LINES
4051: SET quantity = x_line_quantity

Line 4695: clm_standard_form = x_po_header_record.clm_standard_form,

4691: clm_issuing_office = x_po_header_record.clm_issuing_office,
4692: clm_cotr_office = x_po_header_record.clm_cotr_office,
4693: clm_cotr_contact = x_po_header_record.clm_cotr_contact,
4694: clm_priority_code = x_po_header_record.clm_priority_code,
4695: clm_standard_form = x_po_header_record.clm_standard_form,
4696: clm_document_format = x_po_header_record.clm_document_format,
4697: clm_award_type = x_po_header_record.clm_award_type,
4698: clm_contract_officer = x_po_header_record.clm_contract_officer
4699: WHERE PO_HEADER_ID = p_to_pk_value;