Search Results validate_line_type




Overview
Explore in AI Chat

Overview

The APPS.JL_ZZ_AP_AWT_DEFAULT_PKG package body is a Latin American localization (JL) component that implements withholding tax (AWT) defaulting logic for Oracle Payables. It belongs to the Oracle E-Business Suite country-specific extensions that support statutory withholding taxation in Latin American jurisdictions. The package carries a VALID status in the APPS schema and is classified as an OTHER API type.

The package maps an "AWT" reference — withheld amounts calculated on supplier invoices and invoice distributions — to specific withholding types, codes, and territories. It resolves supplier withholding types, comparative withholding types, external withholding utilities, and the province/zone/city attributes that drive territorial withholding determinations. The package therefore performs the calculation rules that decide which withholding applies to a supplier invoice, based on vendor attributes, geography, and invoice line characteristics. The user query "jl_zz_ap_inv_dis_wh_s" corresponds to the view/file JL_ZZ_AP_INV_DIS_WH_S, which this package references as a dependency, confirming the package's role in invoice distribution withholding defaulting logic.

Key Procedures and Functions

The package exposes twelve documented procedures and functions:

  • INSERT_AWT_DEFAULT — inserts the computed withholding default records derived from invoice and supplier information.
  • VER_TERRITORIAL_FLAG — verifies the territorial flag that governs whether territorial withholding rules apply.
  • GET_VENDOR_ID — retrieves the vendor identifier from the invoice header for withholding lookups.
  • COMPANY_AGENT — resolves the company agent information used in withholding determinations.
  • VALIDATE_LINE_TYPE — validates the invoice line type prior to defaulting withholding values.
  • PROVINCE_ZONE_CITY — derives province, zone, and city attributes (via JL_AR_AP_PROVINCES and HZ_GEOGRAPHIES) that drive territorial withholding.
  • DEL_WH_DEF — deletes existing withholding default records, typically before re-derivation.
  • SUPP_WH_DEF_LINE — defaults supplier withholding definitions at the invoice line level.
  • SUPP_WH_DEF — defaults supplier withholding definitions at the invoice level.
  • CARRY_WITHHOLDINGS_PREPAY — carries withholding amounts into prepayment processing.
  • SUPP_WH_REDEFAULT — re-applies defaulted withholding, used when invoice or supplier data changes.
  • UPD_DIST_GDF — updates descriptive flexfield attributes on invoice distributions related to withholding.

Tables Accessed

The package reads and writes against the following documented tables via APPS synonyms:

Utility dependencies include APP_EXCEPTION, FND_GLOBAL, FND_LOG, FND_MESSAGE, FND_PROFILE, and JL_ZZ_AP_EXT_AWT_UTIL, which provide error handling, environment context, profile lookup, and shared withholding utilities.

Usage Notes

The package is not referenced by any other database object, meaning it is typically invoked directly by Oracle Payables forms, concurrent programs, or customer-specific extensions during invoice entry, invoice validation, and withholding defaulting. It is appropriate to invoke it whenever supplier withholding definitions must be applied or re-derived — for example, after a supplier withholding setup change, during prepayment handling, or when invoice distribution flexfields require refresh. Re-defaulting (SUPP_WH_REDEFAULT) and deletion (DEL_WH_DEF) procedures should be executed in the documented sequence to avoid orphaned withholding records. Custom code integrating this package should respect APPS-schema security and use the labelled APIs rather than direct DML.