Search Results copy_negotiation




Overview
Explore in AI Chat

Overview

PON_NEGOTIATION_COPY_GRP is a group package in the Oracle E-Business Suite Sourcing module (PON) responsible for copying and duplicating sourcing documents — RFIs, RFQs, buyer auctions, and contract auctions — along with their associated lines, attributes, scoring teams, and evaluation teams. The package body carries the version banner PONGCPYB.pls 120.76.12010000.2, dated 2008/10/21, which corresponds to the 12.1.1 code level and remains the base for the 12.2.2 codeline. Its central public entry point is COPY_NEGOTIATION, which fulfills the "copy negotiation" action available to buyers when they wish to reuse an existing sourcing document as the basis for a new one.

The package coordinates a broad set of supporting activities: duplicating the negotiation header and lines, carrying forward price elements and attribute groups, detecting inactive price elements, copying scoring and evaluation team assignments, and handling exceptionally large auctions that must be processed through a concurrent program rather than synchronously on the middle tier.

Key Procedures and Functions

  • COPY_NEGOTIATION — The primary public procedure. It drives the full copy of a source negotiation into a new document, orchestrating the header, line, attribute, and team duplication steps and setting the global return status used by callers.
  • CONFORM_AMENDMENT — Produces a conformed copy of a negotiation in the context of amendment, ensuring the amended document is internally consistent with the source.
  • HAS_NEED_TO_COPY_MEMBER — Predicate function that determines whether team membership or related member data must be copied for the negotiation being duplicated.
  • PON_CONC_COPY_SUPER_LARGE_NEG — Handles copy of a "super large" auction. When the negotiation exceeds the size threshold that can be processed online, the package signals the middle tier via the g_ret_conc_req_submitted status and defers work to this concurrent entry point.
  • PON_LRG_DRAFT_TO_ORD_PF_COPY — Supports conversion/copy of large draft negotiations into the ordered (published) state, working with the PON_LARGE_NEG_PF_VALUES staging structure.
  • COPY_SCORING_TEAMS — Duplicates the scoring team definitions and scorers from the source negotiation to the target.
  • COPY_EVALUATION_TEAMS — Duplicates the evaluation team definitions and evaluators from the source negotiation to the target.
  • FED_CREATE_AMD_COPY_NEG — Federal-specific variant that creates an amendment copy of a negotiation, applying federal sourcing rules.
  • TO (helper) — An internal utility routine supporting the copy operations, including data type and value conversion between source and target records.

Tables Accessed

The package reads and writes sourcing tables through APPS synonyms. Negotiation structures include PON_AUCTION_HEADERS_ALL (document number and auction origination code are held in globals), PON_AUCTION_ATTRIBUTES, PON_ATTRIBUTE_SCORES, and PON_AUCTION_ATTR_MAPPING_B, which carry attributes, scores, and attribute mappings for the copied document. PON_LARGE_NEG_PF_VALUES stores the price factor values for large negotiations processed through the concurrent path. Supplier and party data — AP_SUPPLIERS, AP_SUPPLIER_SITES_ALL, HZ_PARTIES, and HZ_RELATIONSHIPS — support supplier assignment and invited-supplier relationships on the new document. Organization and personnel data — PER_ALL_ASSIGNMENTS_F, PER_ALL_PEOPLE_F, and PER_ALL_POSITIONS — drive buyer, scorer, and evaluator identification, while FND_USER, FND_LOOKUP_VALUES, FND_ATTACHED_DOCUMENTS, and FINANCIALS_SYSTEM_PARAMS_ALL supply user context, lookup meanings, attachments, and system parameters.

Usage Notes

PON_NEGOTIATION_COPY_GRP is invoked principally from the Sourcing buyer UI when the "Copy" or "Duplicate" action is selected on a negotiation, and from amendment flows that create a conformed copy. It is also referenced by three other packages in the Sourcing schema, indicating reuse from higher-level orchestration code. For negotiations large enough to exceed synchronous processing limits, the package returns the CONC_REQ_SUBMITTED indicator so the caller can hand off to the PON_CONC_COPY_SUPER_LARGE_NEG concurrent program and report submission status back to the user. Customizations that extend negotiation copy behavior should wrap rather than modify the packaged procedures, and should respect the documented globals (g_return_status, g_has_inactive_pe_flag) used to communicate state across sub-procedures.