Search Results insert_changes

Overview

APPS.PO_COMPARE_REVISIONS is a PL/SQL package body in Oracle E-Business Suite Purchasing that supports the "Compare Revisions" feature, which allows users to view differences between two revisions of a document (or between versions of a related purchasing entity). The package reads archived copies of purchasing tables and current purchasing tables, determines what changed between revisions, and stores the resulting difference records in the temporary table ICX_PO_REVISIONS_TEMP, from which the comparison UI renders the results. It also provides a set of utility resolution functions used to translate stored foreign keys into meaningful display values (item numbers, hazard classes, payment terms, buyers, vendor contacts, locations, and UN numbers).

The user search term "c_item_id" relates to the item identifier column used across the comparison logic; the package resolves item identifiers through GET_ITEM_NUMBER, which maps the stored item id to a displayable item number using MTL_SYSTEM_ITEMS.

Key Procedures and Functions

• PURGE — Deletes records from ICX_PO_REVISIONS_TEMP that are older than a supplied date (defaulting to roughly two hours before the current date), commits, and handles errors. Intended to be scheduled as a concurrent program.
• GET_UN_NUMBER — Resolves a UN number identifier from PO_UN_NUMBERS into its display value; returns NULL if no value is found or an error occurs.
• GET_ITEM_NUMBER — Returns the item number corresponding to an item identifier, typically sourced from MTL_SYSTEM_ITEMS.
• GET_HAZARD_CLASS — Returns the hazard class description for a given hazard class identifier from PO_HAZARD_CLASSES.
• GET_AP_TERMS — Resolves payment terms from AP_TERMS.
• GET_BUYER — Returns the buyer name associated with a buyer identifier.
• GET_VENDOR_CONTACT — Resolves a vendor contact to a displayable name.
• GET_LOCATION — Returns a location description for a location identifier.
• GET_SOURCE_QUOTATION_HEADER and GET_SOURCE_QUOTATION_LINE — Return source quotation header and line references associated with a purchasing document.
• GET_PO_LOOKUP — Returns the meaning of a purchasing lookup code.
• INSERT_CHANGES — Inserts detected differences into ICX_PO_REVISIONS_TEMP.
• VERIFY_NO_DIFFERENCES — Determines whether any differences exist for the compared entities.
• COMPARE_HEADERS, COMPARE_RELEASES, COMPARE_LINES, COMPARE_LOCATIONS, COMPARE_DISTRIBUTIONS — Perform the actual attribute-by-attribute comparison for each level of the purchasing document hierarchy.
• GET_CHARGE_ACCOUNT — Resolves a charge account for a distribution.

Tables Accessed

The package reads archived revisions from PO_HEADERS_ARCHIVE, PO_LINES_ARCHIVE, PO_LINE_LOCATIONS_ARCHIVE, PO_RELEASES_ARCHIVE, and PO_DISTRIBUTIONS_ARCHIVE, and compares them against the corresponding current tables PO_HEADERS, PO_LINES, PO_LINES_ALL, and PO_LINE_LOCATIONS_ALL. Difference output is written to ICX_PO_REVISIONS_TEMP. Resolution functions query MTL_SYSTEM_ITEMS, PO_HAZARD_CLASSES, PO_UN_NUMBERS, AP_TERMS, and FINANCIALS_SYSTEM_PARAMETERS to translate identifiers into display values.

Usage Notes

PO_COMPARE_REVISIONS is invoked primarily through the Purchasing "Compare Revisions" user interface in Oracle EBS 12.1.1 and 12.2.2, which calls the COMPARE_* routines to populate the temporary table and then reads ICX_PO_REVISIONS_TEMP for display. The PURGE procedure is normally scheduled as a concurrent program to remove stale comparison records. The package is referenced by five other packages, and the resolution functions may also be called from custom code needing the same display translations.