Search Results supplier_site_update




Overview
Explore in AI Chat

Overview

IGI_CIS2007_UTIL_PKG is an Oracle EBS public API package owned by the APPS schema. It exists to support the United Kingdom Construction Industry Scheme (CIS) 2007 functionality integrated into Oracle Payables. Its primary responsibility is to invoke certificate insertion logic for suppliers and supplier sites when CIS processing is enabled for the trading relationship. The package acts as a bridge between the core Oracle Payables supplier and supplier site maintenance APIs and the CIS-specific tax certification data handled by the IGI (Intellectual Property Globalization / International) modules.

A critical design constraint documented in the package specification is its dependency relationship with the standard Payables APIs. The SUPPLIER_UPDATE procedure is invoked from AP_VENDORS_PKG (apvndhrb.pls), and SUPPLIER_SITE_UPDATE is invoked from AP_VENDOR_SITES_PKG (apvndsib.pls). Because of this coupling, any modification to the IGI_CIS2007_UTIL_PKG package specification will cause AP_VENDORS_PKG and AP_VENDOR_SITES_PKG to fail. This makes the package signature a hard dependency for core Payables supplier maintenance and reinforces that changes must be managed carefully during upgrades or patching.

Key Procedures and Functions

The package specification documents three public program units.

  • SUPPLIER_UPDATE — A public procedure that calls the certificate insertion logic for a supplier when CIS is enabled. It is the supplier-level counterpart to the site-level routine and is triggered during supplier maintenance through AP_VENDORS_PKG.
  • SUPPLIER_SITE_UPDATE — A public procedure that calls the certificate insertion logic for a supplier site when CIS is enabled. This is the routine most relevant to the search term "supplier_site_update." It is called from AP_VENDOR_SITES_PKG and handles certification data at the specific supplier site level.
  • GET_PAYABLES_OPTION_BASED_AWT — A function added to address CIS Bug 7218825. It derives a value based on the Payables option configuration in relation to withholding tax (AWT), accepting vendor, vendor site, tax group, and payment tax group identifiers. Bug 7218825 is referenced in conjunction with both the supplier and supplier site update procedures, reflecting the Withholding Tax enhancement introduced alongside CIS 2007 processing.

Only program unit names and purposes are documented; parameter lists are intentionally omitted here.

Tables Accessed

The package interacts with the following tables through APPS synonyms:

  • AP_SUPPLIERS — Holds supplier header information used to resolve the vendor identifier during supplier-level certification.
  • AP_SUPPLIER_SITES_ALL — Stores supplier site records; the vendor_site_id is central to the SUPPLIER_SITE_UPDATE procedure.
  • AP_AWT_GROUP_TAXES_ALL — Provides withholding tax group tax definitions for both the standard tax group and payment tax group passed into the update routines.
  • AP_SYSTEM_PARAMETERS_ALL — Supplies Payables system-level options, consulted by GET_PAYABLES_OPTION_BASED_AWT to determine option-driven withholding behavior.
  • IGI_GCC_INST_OPTIONS_ALL — Stores IGI installation options, including whether CIS processing is enabled, which governs whether certificate insertion logic executes.

Usage Notes

IGI_CIS2007_UTIL_PKG is not typically invoked directly by end users or custom code. It is called internally by Oracle Payables supplier and supplier site maintenance flows. When a user creates or updates a supplier or supplier site through the Suppliers form, AP_VENDORS_PKG or AP_VENDOR_SITES_PKG delegates to SUPPLIER_UPDATE or SUPPLIER_SITE_UPDATE respectively, provided CIS is enabled. The package is referenced by four other packages, underscoring its role as a shared utility. Because modifying the package specification breaks dependent Payables packages, customizations should avoid altering its signature and instead extend behavior cautiously, verifying compatibility across EBS 12.1.1 and 12.2.2.