Search Results pan_update

Overview

JAI_PAN_UPDATE_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM documentation as an "OTHER" API. It belongs to the Oracle Financials for India (JAI) localization layer and supports the Indian statutory requirement to maintain a Permanent Account Number (PAN) for vendors subject to Tax Deducted at Source (TDS). The package provides the mechanism by which an existing PAN recorded against a vendor TDS header is superseded by a new PAN, while preserving an auditable trail of the change. Because PAN is the unique taxpayer identifier used for TDS reporting and certificate generation, controlled update of this attribute is essential for compliance with Indian income tax regulations.

The package is declared with AUTHID CURRENT_USER, meaning that name resolution and privilege checking are performed against the schema of the calling user rather than the definer. The header comment indicates the source file jai_pan_update_s.pls at version 120.0.12000000.1, dated 2007, establishing it as a legacy component that has remained stable across the 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

The package exposes a single documented procedure:

• PAN_UPDATE — The sole public procedure in the specification. It carries the standard Oracle concurrent program output parameters for error buffer and return status, followed by parameters identifying the vendor, the existing PAN value, the replacement PAN value, and a debug flag. Because the procedure accepts output parameters, it is structured to be registered as a concurrent program executable. Its purpose is to validate and apply a change of PAN for a given vendor, writing the updated value to the vendor TDS header and recording the prior and new values in the PAN change history tables. Any validation failure is surfaced through the error buffer and return code so that the concurrent manager or calling form can report the outcome.

Tables Accessed

The documented table references, resolved through APPS synonyms, define the data footprint of the update:

• JAI_AP_TDS_VENDOR_HDRS — The vendor-level TDS header, and the primary target of the update. It stores the current PAN for the vendor; PAN_UPDATE replaces the old value with the new value here.
• JAI_AP_TDS_PAN_CHANGES and JAI_AP_TDS_PAN_CHANGES_S — The change history and its sequence (or intersection) counterpart. These preserve the audit trail of each PAN transition, recording the prior and revised numbers so that historical TDS reporting remains reconcilable.
• JAI_AP_TDS_THHOLD_GRPS — Threshold groups used for TDS applicability at the vendor level. The procedure consults this data to ensure that the vendor's TDS configuration remains consistent after the PAN change.
• JAI_AP_TDS_THHOLD_XCEPS — Threshold exceptions defined for the vendor. These may influence whether the PAN change affects TDS calculation and reporting eligibility.

Usage Notes

JAI_PAN_UPDATE_PKG is not referenced by any other documented package, so it is an entry point rather than a shared utility. Its signature, with P_errbuf and P_return_code as the leading OUT NOCOPY parameters, is characteristic of a concurrent program body registered under the India Localization or Payables responsibility. It may also be invoked directly from an Oracle Forms-based vendor TDS maintenance screen, or from custom PL/SQL that requires a controlled, audited PAN correction. Callers must supply the correct vendor identifier together with both the current and replacement PAN values; supplying an old PAN that does not match the stored value should be treated as a validation error. The debug flag enables diagnostic output during troubleshooting. Because the package was published under a 2007 source header and remains in 12.2.2, it should be treated as stable but legacy; any customization should wrap, not modify, the delivered specification.