Search Results has_viewopportunityaccess

Overview

AS_ACCESS_PUB_W2 is a public PL/SQL API package in the Oracle E-Business Suite Applications (APPS) schema that belongs to the Oracle Sales and Marketing foundation layer. Its purpose is to expose access-control decision logic to other modules within the EBS ecosystem, allowing callers to programmatically determine whether a given user, resource, group, or salesforce identity is permitted to view or update a particular business entity. The package is declared with AUTHID CURRENT_USER, meaning its procedures execute with the privileges of the calling schema rather than the definer, which is consistent with the standard Oracle EBS public API convention intended to honor the caller's security context.

In practical terms, the package functions as a security predicate engine for person, lead, opportunity, and organization records. Rather than requiring a consumer to independently query the underlying Territory Manager and resource-group tables, a caller invokes a single entry point that returns a boolean-style access flag through an OUT parameter. This centralizes the security rules and ensures consistent enforcement of the assignment-based and territory-based visibility model used by Oracle Sales.

Key Procedures and Functions

The package documents eight procedures, each returning an access decision for a distinct entity or context. Every procedure accepts a common set of administrative and identity parameters, together with standard FND_API messaging OUT parameters (x_return_status, x_msg_count, x_msg_data) and an entity-specific access-flag OUT parameter.

• HAS_UPDATEPERSONACCESS — Determines whether the identified person may update the referenced sales entity, returning the decision in x_update_access_flag.
• HAS_VIEWPERSONACCESS — Determines whether the identified person may view the referenced sales entity, returning the decision in x_view_access_flag.
• HAS_VIEWLEADACCESS — Evaluates view permission for a specific sales lead, keyed on p_sales_lead_id.
• HAS_VIEWOPPORTUNITYACCESS — Evaluates view permission for a sales opportunity; this is the procedure returned when a user searches for has_viewopportunityaccess, indicating it is the entry point most commonly referenced for opportunity-level security checks.
• HAS_ORGANIZATIONACCESS — Evaluates access to an organization record within the sales model.
• HAS_PERSONACCESS — General person-level access evaluation.
• HAS_LEADACCESS — General lead-level access evaluation.
• HAS_OPPORTUNITYACCESS — General opportunity-level access evaluation.

Tables Accessed

The ETRM metadata for this package does not enumerate the base tables or APPS synonyms that it references. Functionally, an access package of this type typically resolves its decisions against the sales security and territory model — resource and group assignment tables, salesforce and partner definitions, and the person/organization party model — but these dependencies are not documented here and should be confirmed by inspecting the package body or user dependencies at runtime.

Usage Notes

AS_ACCESS_PUB_W2 contains only public API procedures and is not reported as being called by any other documented package (referenced by 0 other packages in the ETRM metadata), which suggests its consumers are predominantly application forms and custom extensions rather than other PL/SQL APIs. It is typically invoked from Oracle Sales forms, from custom concurrent programs, or from extension code that must enforce the same visibility rules as the standard application. Because the package runs with AUTHID CURRENT_USER, callers must ensure that the invoking database session has the necessary grants on the underlying security objects, and callers should always inspect x_return_status before acting on the returned access flag.