Search Results get_orgid

Overview

CS_MULTIORG_PVT is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified in ETRM as a Private (PVT) API. It belongs to the Oracle TeleService / Customer Support (CS) product family and supports multi-organization security resolution for service incidents. In Oracle EBS, "multi-org" refers to the partitioning of data by operating unit through the Multi-Org Access Control (MOAC) model. When a service request (incident) is processed, the application must determine which operating unit owns the record and which organizational profile applies, so that the correct MOAC security context is enforced and the user sees only authorized data.

The package header declares AUTHID CURRENT_USER, meaning the package executes with the privileges of the invoking user rather than as the definer. The version header indicates the file revision csxvmois.pls 120.2 2005/09/29, and each documented API carries an internal version of 1.0. The package is characterized as private, indicating that it is an internal implementation unit not intended as a public integration API; application modules consume it through other layers of the CS code base.

Key Procedures and Functions

The package exposes a single documented program unit:

• Get_OrgId — A private procedure described in the package comments as the API that "gets the MultiOrg id." It accepts the standard EBS API control parameters (p_api_version, p_init_msg_list, p_commit, p_validation_level) along with the standard output parameters (x_return_status, x_msg_count, x_msg_data). The business input is p_incident_id, which is marked Required, identifying the service incident whose organizational context is to be resolved. The procedure returns x_org_id, the resolved organization identifier, and x_profile, a profile-related identifier that accompanies the organization determination. No other procedures or functions are declared in the package specification.

Tables Accessed

The ETRM metadata records the following tables as referenced through APPS synonyms:

• CS_INCIDENTS_ALL_B — the base incident table; the driving input p_incident_id keys into this entity to locate the service request being resolved.
• CS_MULTI_ORG_RULES — the rules repository that governs how incidents map to organizations; this table supplies the logic by which the correct organization is derived.
• CS_CUSTOMER_PRODUCTS_ALL — installed base / customer product records associated with the incident, used to establish the owning organization context.
• CSI_I_ORG_ASSIGNMENTS — assignments linking items or instances to organizations, providing an additional organization-resolution path.
• HZ_CUST_ACCT_SITES_ALL — customer account site information, used to associate the incident's customer with the appropriate organizational view.
• OKC_K_HEADERS_ALL_B — contract header data, consulted where the service request relates to a contract that itself carries organizational context.

Usage Notes

Because CS_MULTIORG_PVT is designated a private API, it is not intended for direct customer extension or third-party integration. It is invoked internally by Oracle TeleService forms, concurrent programs, and the Agent/Service Request UI whenever an incident must be evaluated against multi-org security rules. The documented metadata records exactly one referencing package, confirming that the calling surface is narrow and controlled.

Custom code that must resolve the operating unit for a service incident should not call Get_OrgId directly, since private APIs may change without notice and are excluded from the public backwards-compatibility commitment. Instead, customizations should rely on the public CS APIs or the MOAC profile mechanisms that ultimately consume this package. When Get_OrgId is invoked internally, callers supply a valid p_api_version and the required p_incident_id, then inspect x_return_status along with x_msg_count and x_msg_data to determine whether the organization and profile values were successfully derived before applying MOAC context to subsequent queries.