Search Results igi_cis2007_util_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGI_CIS2007_UTIL_PKG package body is a utility package within the Oracle E-Business Suite application schema that supports the United Kingdom Construction Industry Scheme (CIS) 2007 tax regime. Its principal business function is to provide shared helper logic that other CIS-related packages invoke when processing supplier records, supplier sites, and the calculation of withholding tax (Withholding/Construction Industry Deduction) applicable to subcontractor payments. The package encapsulates the rules that tie an AP supplier or supplier site to the CIS deductions applicable under the 2007 legislation, including the selection of the correct tax treatment based on effective dates and installation-level options.

The package body is documented as VALID within the APPS schema and is classified as an "OTHER" API rather than a standard public interface. It is a dependency of four other database objects and is not referenced by upstream callers in the documented dependency graph, confirming its role as a supporting utility module rather than a top-level entry point.

Key Procedures and Functions

The metadata documents three procedures or functions within the package body:

  • SUPPLIER_UPDATE — Handles updates to supplier-level CIS attributes. It is invoked when supplier records governed by the CIS 2007 regime require amendment, ensuring that tax status, deduction treatment, and related supplier data remain consistent with the current rules.
  • SUPPLIER_SITE_UPDATE — Performs the analogous function at the supplier site level. Because CIS treatment can vary by site, this routine synchronises site-level attributes with the applicable deduction scheme and effective-dated tax configuration.
  • GET_PAYABLES_OPTION_BASED_AWT — Returns the withholding (AWT — Automatic Withholding Tax) determination based on Payables installation options. It resolves whether and how withholding should be applied for a given supplier or site by reading system-level option settings, providing the calling process with the correct deduction basis.

These three units form the core public surface of the package. Additional private helper logic exists within the body but is not part of the documented interface.

Tables Accessed

The package reads and writes against several Payables and CIS-specific tables, accessed through APPS synonyms:

Additional dependencies include IGI_GEN (shared globalisation utilities) and MO_GLOBAL (multi-org access control), indicating that the package operates within a multi-organisation security context and reuses common globalisation routines.

Usage Notes

This package is typically invoked indirectly. Because it is referenced by four other packages and exposes only internal-style utility routines, it is not intended for direct invocation by end users. Instead, it is called by higher-level CIS processing packages during supplier maintenance, invoice validation, and payment processing, where the deduction treatment of a subcontractor must be determined. In practice, users trigger the logic through the Payables Supplier Entry forms, supplier site maintenance, or concurrent processes that apply CIS deductions to payments. Custom extensions should treat the documented procedures as the supported interface and avoid modifying the package body, since Oracle may replace it during patching. Implementers integrating CIS 2007 logic for EBS 12.1.1 or 12.2.2 should reference this package for the correct resolution of Payables option based withholding and supplier/site CIS attributes.