Search Results igi_itr_prep_apprv_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGI_ITR_PREP_APPRV_PKG package is part of the Oracle E-Business Suite international trade management / ETRM (Enterprise Trade Management) functionality, specifically the IGI_ITR (International Trade – Intercompany Transaction / Trade Review) module. Its business purpose is to enforce the preparer-level approval authorization rules that govern trade or charge transactions. Before a charge line can be approved by the individual who prepared it, the system must determine whether that preparer holds sufficient signing authority. The package centralizes this determination so that ETRM forms and workflow processes can consistently validate approval rights against the preparer's configured authorization limits and the applicable organization/accounting setup.

The package is owned by APPS and is classified in the ETRM documentation as an OTHER API — meaning it is not a public, formally supported integration API, but an internal utility used by ETRM application code. It exposes a single documented procedure and is not referenced by any other documented package, indicating it is consumed directly by forms or workflow rather than through a package-to-package chain.

Key Procedures and Functions

The package documents one procedure:

  • CAN_PREPARER_APPROVE — Determines whether the preparer identified for a given charge line is authorized to approve that line. It accepts the charge (or charge setup) context, the preparer's user identifier, and the set of books, and returns an output flag indicating the approval outcome. The returned value is used by the calling form or process to allow, block, or route the approval action. A public diagnostic variable, diagn_msg_flag, controls whether diagnostic messages are emitted during execution, which aids troubleshooting in development and support scenarios.

No parameter lists are reproduced here; callers should reference the package specification for the exact signature when integrating. The procedure is the sole documented entry point and encapsulates the entire preparer-approval business rule.

Tables Accessed

The package reads (and in the normal course of an authorization check does not modify) the following tables through APPS synonyms:

  • FND_USER — to resolve the preparer's FND user account and confirm it is valid and active.
  • FND_PROFILE_OPTION_VALUES — to retrieve profile option settings that influence approval behavior, such as whether preparer approval is permitted at all.
  • GL_AUTHORIZATION_LIMITS — to compare the preparer's configured signing authority (authorization limits) against the transaction amount, which is the core of the approval decision.
  • IGI_ITR_CHARGE_LINES — to obtain the charge line details and amount being evaluated for approval.
  • IGI_ITR_CHARGE_SETUP — to obtain the charge setup/definition context that frames the line being approved.

Together these reads supply the transaction facts and the authorization rules needed to answer the yes/no approval question.

Usage Notes

IGI_ITR_PREP_APPRV_PKG.CAN_PREPARER_APPROVE is typically invoked from the ETRM charge line entry/approval form and from related workflow or approval processing whenever the system must decide if the preparer may approve a charge line. Because it is classified as OTHER and is not a published API, it should be treated as internal application logic: custom code may call it, but doing so is not a supported integration surface, and the signature may change between releases. Developers integrating with ETRM approval functionality should prefer supported APIs where available and, when referencing this procedure, rely on the package specification for the authoritative parameter list. Diagnostic output can be enabled through diagn_msg_flag to assist in diagnosing unexpected approval results.