Results for “get_session_process_id”
16 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
FUN_RULE_UTILITY_PKG is an Oracle EBS Application Object Library package owned by the APPS schema and classified as an "OTHER" API. It resides in the Oracle Subledger Accounting / Financials rule framework and provides a shared library of utility routines that support rule generation and rule maintenance activities. The package is defined with AUTHID CURRENT_USER, meaning its database calls execute with the privileges of the invoking session rather than the definer, which is consistent with its role as a low-level helper that queries session and application metadata. The script header (FUNXTMRULGENUTS.pls, version 120.1) dates the source to 2006, with authorship attributed to Amulya Mishra. In both 12.1.1 and 12.2.2, the package retains this utility role, and the ETRM metadata documents roughly twenty-four procedures and functions. Ten other packages reference it, indicating that it is a dependency of the broader rule-engine codebase rather than an end-user-facing API. The user's search term, get_session_process_id, corresponds to the function that returns the operating-system process identifier of the current database session.
Key Procedures and Functions
The documented entry points fall into three functional groups.
- Session identification:
GET_SESSION_PROCESS_IDreturns the OS process ID of the current session as a VARCHAR2. It is declared withPRAGMA RESTRICT_REFERENCES (…, WNDS, WNPS, RNPS), signalling that it writes neither database state nor package state and reads no package state — a purity guarantee that allows it to be called from SQL contexts. Internally the value is derived from the V$SESSION and V$PROCESS dynamic performance views referenced by the package. - Standard WHO columns: A family of functions —
CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,REQUEST_ID,PROGRAM_ID,PROGRAM_APPLICATION_ID,APPLICATION_ID,PROGRAM_UPDATE_DATE, andUSER_ID— each returns the corresponding audit or runtime attribute of the current session, enabling callers to populate the standard "WHO" columns consistently. - Schema, lookup, and rule helpers:
GET_SCHEMANAMEresolves an application short name to its database schema name;GET_APPSSCHEMANAMEreturns the APPS schema name;GET_LOOKUPMEANINGretrieves a lookup meaning given a lookup table (defaulting to AR_LOOKUPS), lookup type, and lookup code;GET_MAX_SEQcomputes a maximum sequence value; andGETAPPLICATIONID,GETAPPLICATIONSHORTNAME, andGETVALUESETDATATYPEsupply application and value-set metadata. ACREATE_DUPLICATE_RULEprocedure exists to replicate a rule definition, with its body documented only in outline.
Tables Accessed
The package works against a mix of application tables and engine internals.
- FUN_RULE_DETAILS, FUN_RULE_OBJECTS_B — the natural-language rule definition and rule object tables that the duplicate-rule and sequence helpers operate upon.
- FND_APPLICATION, FND_LANGUAGES, FND_LOOKUP_VALUES — AOL reference data used to resolve schema names, application identifiers, and lookup meanings.
- HZ_RELATIONSHIP_TYPES and SO_LOOKUPS — Trading Community and Order Management lookup sources consulted by the lookup-meaning helper.
- V$SESSION and V$PROCESS — dynamic performance views used by GET_SESSION_PROCESS_ID to identify the calling session's server process.
- PLITBLM, DBMS_SQL, DBMS_UTILITY, UTL_FILE — supporting built-ins and packages rather than tables, used for dynamic SQL, parsing of delimited strings, and file operations within the utility routines.
Usage Notes
FUN_RULE_UTILITY_PKG is a back-end utility and is not normally invoked directly by end users. Its most common consumer is the rule generation engine and the forms, concurrent programs, and custom extensions that create or duplicate financial rules, all of which need a reliable way to stamp audit columns, resolve schema and application metadata, or obtain a session's process ID for logging and troubleshooting. Because of the declared purity of GET_SESSION_PROCESS_ID, PL/SQL developers may safely call it from SQL statements and from restricted contexts, which is useful when diagnostics must capture the OS process behind a session. The package is available in both 12.1.1 and 12.2.2; the 12.2 online-patching model does not alter its signature, though the underlying V$SESSION and V$PROCESS columns it depends on remain subject to the standard DBA grants required for APPS.