Results for “pa_startup”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PA_STARTUP is an initialization package in the Oracle Projects (PA) module of Oracle E-Business Suite, shipped under the APPS schema. Its role is to establish the session-level context in which Project Accounting APIs and forms operate. Rather than performing business transactions itself, the package exposes global variables and a single initialization routine that set calling context, security-checking behaviour, and ID validation policy for subsequent API calls made during the same database session.
The package is declared with AUTHID CURRENT_USER, meaning that any dynamic SQL or privilege resolution executed within it is performed under the privileges of the invoking user rather than the definer. This is consistent with its design as a lightweight context-setting utility that does not itself touch application data. The header identifies a legacy origin dating to the 11i code line (version 115.7, last shipped 2002), and the package remains a foundational dependency in the Applications Technology stack through EBS 12.1.1 and 12.2.2, where it is referenced by 27 other packages.
Key Procedures and Functions
- INITIALIZE — The sole documented procedure. It is intended to be called as part of session or process initialization. Its input parameters correspond directly to the package-level global variables, allowing the caller to set the calling application, calling module, ID validation flag, project role security flag, and resource security flag in one call. The documented note states that the calling application parameter is always required. Critically, INITIALIZE does not initialize or set the error stack, which distinguishes it from the standard FND_API initialization pattern; callers that require error-stack handling must manage that separately.
The global variables governed by the procedure are:
- G_Calling_Application — Valid values are SELF_SERVICE, FORMS, REPORTS, and PLSQL. Downstream APIs use this to alter behaviour based on the invocation channel.
- G_Calling_Module — A free-text identifier of the calling module.
- G_Check_ID_Flag — Governs whether IDs supplied for Value-ID conversion are validated (Y) or bypassed (N). Defaults to Y.
- G_Check_Role_Security_Flag — Controls whether project role security is enforced. Defaults to Y.
- G_Check_Resource_Security_Flag — Controls whether resource security is enforced. Defaults to Y.
Tables Accessed
No tables are documented as being referenced by PA_STARTUP through APPS synonyms. This is consistent with the package's purpose: it initializes in-memory session state only. The security flags it sets influence table access performed later by other Project Accounting APIs, but PA_STARTUP itself neither reads nor writes application data.
Usage Notes
PA_STARTUP is invoked at the beginning of a session or process, before any Project Accounting API that depends on calling-context or security flags. Typical invocation points include Oracle Forms entry points within the Projects responsibility, Self Service flows, Oracle Reports programs, and custom PL/SQL that calls PA APIs directly. The calling application value should reflect the actual channel so that downstream logic branches correctly.
Because the package is referenced by 27 other packages, changes to its global variable defaults or to INITIALIZE behaviour carry broad impact. Custom code should call INITIALIZE rather than assigning the global variables directly, and should explicitly set the error stack if error handling is required, since INITIALIZE does not manage it. The package is classified as OTHER in the ETRM API registry, indicating it is an internal infrastructure component rather than a published business API; it is nonetheless safe for custom code to call for session setup.
-
PACKAGE: APPS.PA_STARTUP 12.1.1
-
PACKAGE: APPS.PA_STARTUP 12.2.2