Search Results igi_itr_approval_pkg
Overview
IGI_ITR_APPROVAL_PKG is an APPS-owned PL/SQL package within the Oracle E-Business Suite that supports the approval processing engine for intercompany charge transactions managed by the Intercompany Transaction Reconciliation (ITR) module. In both EBS 12.1.1 and 12.2.2, the package orchestrates the routing, authorization, and disposition of charge lines as they move through a multi-tier approval hierarchy. Its documented scope covers workflow initiation, approver identity resolution, authority verification, and the recording of approval history. The package is classified as API type OTHER and is marked VALID in the ETRM repository. It is referenced by no other packages, indicating that it functions as a top-level controller invoked directly by the forms and workflow infrastructure of the ITR application rather than being a shared utility library. The package exposes twenty-nine documented procedures and functions, all of which relate to the lifecycle of an intercompany charge approval — from the moment a preparer submits a charge line to the point at which a receiver or final approver acts upon it.
Key Procedures and Functions
The documented entry points fall into several functional groups:
- Workflow and initiation: START_APPROVAL_WORKFLOW launches the approval flow for a charge line, while SUBMIT_CC_LINE and NO_SUBMIT_CC_LINE control whether a line is submitted into that flow.
- Approver resolution: GET_SOB_ATTRIBUTES and GET_CC_ATTRIBUTES retrieve set-of-books and charge center attributes used to determine routing. FIND_CC_RECEIVER, GETMANAGER, and SETPERSONAS resolve the appropriate recipient or approver identities.
- Approver identity assignment: SET_APPROVER_NAME_TO_PREP, SET_APPROVER_NAME_TO_SEC_APP, and SET_APPROVER_NAME_TO_REC populate the approver name fields for preparer, secondary approver, and receiver contexts respectively.
- Decision and status checks: DID_PREPARER_APPROVE, SECONDARY_APPROVER_SELECTED, FINAL_APPROVER, IS_RECEIVER_FINAL_APPROVER, and VERIFY_AUTHORITY determine whether required approvals have been obtained and whether the acting user holds sufficient authority.
- Approval actions: APPROVE_CC_LINE and REJECT_CC_LINE record the approve or reject outcome on a charge line.
- Auxiliary control: MAINTAIN_HISTORY writes audit records, and DOUBLE_TIMEOUT handles time-out conditions in the approval process.
Tables Accessed
Through APPS synonyms, the package reads and writes the following documented tables:
- FND_USER — resolves user identity for approver and preparer determination.
- GL_AUTHORIZATION_LIMITS — supports VERIFY_AUTHORITY by checking the monetary limits assigned to an approver.
- IGI_ITR_ACTION_HISTORY — target of MAINTAIN_HISTORY, storing the audit trail of approval actions.
- IGI_ITR_APPROVAL_SS_S — the approval single-set records driving current approval state.
- IGI_ITR_CHARGE_CENTER, IGI_ITR_CHARGE_HEADERS, IGI_ITR_CHARGE_LINES, IGI_ITR_CHARGE_RANGES, IGI_ITR_CHARGE_SERVICE, IGI_ITR_CHARGE_SETUP, and IGI_ITR_SERVICE — the ITR charge configuration and transaction tables that supply attributes, ranges, and service definitions used to route and validate approvals.
Usage Notes
IGI_ITR_APPROVAL_PKG is normally invoked indirectly through the ITR charge approval forms and the Oracle Workflow processes bound to them; end users trigger its logic by submitting, approving, or rejecting charge lines rather than calling the package directly. Because it is the sole documented reference point for its own functionality and is not referenced by other packages, customizations should treat it as the authoritative integration surface for ITR approval behavior. Custom code that needs to inject approval actions or query approval state should call the documented procedures by name, observing the authority checks they enforce. Any modification to approval routing rules is best implemented within the package body, as its procedures are not designed to be overridden externally.
-
PACKAGE: APPS.IGI_ITR_APPROVAL_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:IGI_ITR_APPROVAL_PKG, status:VALID,
-
PACKAGE: APPS.IGI_ITR_APPROVAL_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGI_ITR_APPROVAL_PKG, status:VALID,
-
PACKAGE BODY: APPS.IGI_ITR_APPROVAL_PKG
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IGI_ITR_APPROVAL_PKG, status:VALID,
-
PACKAGE BODY: APPS.IGI_ITR_APPROVAL_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGI_ITR_APPROVAL_PKG, status:VALID,
-
SYNONYM: APPS.IGI_ITR_ACTION_HISTORY
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGI_ITR_ACTION_HISTORY, status:VALID,
-
PACKAGE: APPS.IGI_ITR_ACTION_HISTORY_SS_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:IGI_ITR_ACTION_HISTORY_SS_PKG, status:VALID,
-
SYNONYM: APPS.IGI_ITR_CHARGE_CENTER
12.2.2
owner:APPS, object_type:SYNONYM, object_name:IGI_ITR_CHARGE_CENTER, status:VALID,
-
SYNONYM: APPS.IGI_ITR_SERVICE
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGI_ITR_SERVICE, status:VALID,
-
SYNONYM: APPS.IGI_ITR_CHARGE_SETUP
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGI_ITR_CHARGE_SETUP, status:VALID,
-
SYNONYM: APPS.IGI_ITR_APPROVAL_SS_S
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGI_ITR_APPROVAL_SS_S, status:VALID,
-
PACKAGE: APPS.IGIGITCH
12.2.2
owner:APPS, object_type:PACKAGE, object_name:IGIGITCH, status:VALID,
-
PACKAGE: APPS.IGIGITCH
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGIGITCH, status:VALID,
-
SYNONYM: APPS.IGI_ITR_CHARGE_SERVICE
12.2.2
owner:APPS, object_type:SYNONYM, object_name:IGI_ITR_CHARGE_SERVICE, status:VALID,
-
PACKAGE: APPS.IGI_ITR_ACTION_HISTORY_SS_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGI_ITR_ACTION_HISTORY_SS_PKG, status:VALID,
-
SYNONYM: APPS.GL_AUTHORIZATION_LIMITS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:GL_AUTHORIZATION_LIMITS, status:VALID,
-
SYNONYM: APPS.IGI_ITR_CHARGE_SETUP
12.2.2
owner:APPS, object_type:SYNONYM, object_name:IGI_ITR_CHARGE_SETUP, status:VALID,
-
SYNONYM: APPS.IGI_ITR_APPROVAL_SS_S
12.2.2
owner:APPS, object_type:SYNONYM, object_name:IGI_ITR_APPROVAL_SS_S, status:VALID,
-
SYNONYM: APPS.IGI_ITR_CHARGE_RANGES
12.2.2
owner:APPS, object_type:SYNONYM, object_name:IGI_ITR_CHARGE_RANGES, status:VALID,
-
SYNONYM: APPS.IGI_ITR_CHARGE_CENTER
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGI_ITR_CHARGE_CENTER, status:VALID,
-
PACKAGE BODY: APPS.IGI_ITR_APPROVAL_PKG
12.1.1
-
SYNONYM: APPS.IGI_ITR_ACTION_HISTORY
12.2.2
owner:APPS, object_type:SYNONYM, object_name:IGI_ITR_ACTION_HISTORY, status:VALID,
-
SYNONYM: APPS.IGI_ITR_CHARGE_SERVICE
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGI_ITR_CHARGE_SERVICE, status:VALID,
-
SYNONYM: APPS.IGI_ITR_SERVICE
12.2.2
owner:APPS, object_type:SYNONYM, object_name:IGI_ITR_SERVICE, status:VALID,
-
SYNONYM: APPS.GL_AUTHORIZATION_LIMITS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:GL_AUTHORIZATION_LIMITS, status:VALID,
-
SYNONYM: APPS.IGI_ITR_CHARGE_RANGES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGI_ITR_CHARGE_RANGES, status:VALID,
-
PACKAGE BODY: APPS.IGI_ITR_APPROVAL_PKG
12.2.2
-
SYNONYM: APPS.IGI_ITR_CHARGE_LINES
12.2.2
owner:APPS, object_type:SYNONYM, object_name:IGI_ITR_CHARGE_LINES, status:VALID,
-
SYNONYM: APPS.IGI_ITR_CHARGE_HEADERS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGI_ITR_CHARGE_HEADERS, status:VALID,
-
SYNONYM: APPS.IGI_ITR_CHARGE_LINES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGI_ITR_CHARGE_LINES, status:VALID,
-
SYNONYM: APPS.IGI_ITR_CHARGE_HEADERS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:IGI_ITR_CHARGE_HEADERS, status:VALID,
-
VIEW: APPS.GL_HR_EMPLOYEES_CURRENT_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GL_HR_EMPLOYEES_CURRENT_V, object_name:GL_HR_EMPLOYEES_CURRENT_V, status:VALID,
-
VIEW: APPS.GL_HR_EMPLOYEES_CURRENT_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GL_HR_EMPLOYEES_CURRENT_V, object_name:GL_HR_EMPLOYEES_CURRENT_V, status:VALID,
-
12.1.1 DBA Data
12.1.1
-
12.1.1 DBA Data
12.1.1
-
12.2.2 DBA Data
12.2.2
-
12.2.2 DBA Data
12.2.2
-
APPS.IGI_ITR_APPROVAL_PKG SQL Statements
12.2.2
-
APPS.IGI_ITR_APPROVAL_PKG SQL Statements
12.1.1
-
APPS.IGI_ITR_APPROVAL_PKG dependencies on IGI_ITR_APPROVAL_PKG
12.1.1
-
APPS.IGI_ITR_APPROVAL_PKG dependencies on IGI_ITR_APPROVAL_PKG
12.2.2
-
PACKAGE: APPS.IGI_ITR_APPROVAL_PKG
12.2.2
-
PACKAGE: APPS.IGI_ITR_APPROVAL_PKG
12.1.1
-
PACKAGE: APPS.WF_DIRECTORY
12.1.1
owner:APPS, object_type:PACKAGE, object_name:WF_DIRECTORY, status:VALID,
-
PACKAGE: APPS.WF_DIRECTORY
12.2.2
owner:APPS, object_type:PACKAGE, object_name:WF_DIRECTORY, status:VALID,
-
APPS.IGI_ITR_APPROVAL_PKG dependencies on WF_CORE
12.2.2
-
APPS.IGI_ITR_APPROVAL_PKG dependencies on WF_CORE
12.1.1
-
APPS.IGI_ITR_APPROVAL_PKG dependencies on FND_MESSAGE
12.2.2
-
APPS.IGI_ITR_APPROVAL_PKG dependencies on FND_MESSAGE
12.1.1
-
PACKAGE: APPS.WF_CORE
12.1.1
owner:APPS, object_type:PACKAGE, object_name:WF_CORE, status:VALID,
-
PACKAGE: APPS.WF_CORE
12.2.2
owner:APPS, object_type:PACKAGE, object_name:WF_CORE, status:VALID,