Search Results fnd_table_of_varchar2_30




Overview
Explore in AI Chat

Overview

ENG_CHANGE_ROLES_PUB is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Engineering (ENG) product family. Its business purpose is to support the Engineering Change Management (ECM) module by resolving and returning role-based access information associated with engineering change objects. Engineering changes in Oracle EBS are controlled entities governed by role assignments, grantees, and instance-set security. This package exposes APIs that a calling form or concurrent program can invoke to determine which users (grantees) hold change-related roles on a given entity, and to derive the set of valid instance-set identifiers applicable to a given object and grantee type.

The package header carries the RCS identifier ENGCMRLS.pls 120.0, dated 2005, indicating a stable interface that has been carried forward into the 12.1.1 and 12.2.2 releases without structural change. The naming suffix _PUB denotes that the procedures are intended as a supported public API surface rather than internal helper routines.

Key Procedures and Functions

The documented package exposes two procedures. No functions are declared, and the private helper procedures present in the body are commented out in the header and are therefore not part of the public contract.

  • Get_Change_Users — Retrieves the set of grantees associated with an engineering change entity. It accepts an API version, an entity name, up to five primary-key values identifying the target entity instance, and an optional role name filter. It returns parallel arrays describing each grantee: grantee names, grantee types, role names, role display names, and default access values. A standard x_return_status parameter reports success or failure. The output collections are strongly typed as FND_TABLE_OF_VARCHAR2_30 or FND_TABLE_OF_VARCHAR2_120, which is the direct link to the user's search term fnd_table_of_varchar2_30.
  • Get_Valid_Instance_Set_Ids — Returns a concatenated string of valid instance-set identifiers for a given object name, grantee type, and a supplied parent object SQL fragment with up to five bind variables. The object identifiers are passed in as a string, and the resolved instance-set IDs are returned through x_inst_set_ids.

Tables Accessed

The package interacts with both Engineering and Foundation tables through APPS synonyms. Engineering-side tables include ENG_CHANGE_SUBJECTS and ENG_REVISED_ITEMS, which anchor the change object and its revised item context. Security and role resolution rely on FND_GRANTS, FND_OBJECTS, FND_OBJECT_INSTANCE_SETS, FND_MENU_ENTRIES, and FND_FORM_FUNCTIONS. HZ_PARTIES supplies party (grantee) information. Dynamic SQL against the supplied parent object is handled via DBMS_SQL, and PLITBLM is referenced in conjunction with the index-by table handling used for the FND_TABLE_OF_VARCHAR2 collections.

Usage Notes

ENG_CHANGE_ROLES_PUB is typically invoked from the Engineering Change Management forms when the UI must populate grantee and role assignments, and from custom code that needs to evaluate change-object security programmatically. Because it is a _PUB package in the APPS schema, it should be called with the standard EBS API conventions: pass a valid p_api_version, enclose the call in a savepoint-safe block, and always inspect x_return_status before consuming the returned collections. The table-based OUT parameters require the caller to declare variables of the matching FND_TABLE_OF_VARCHAR2 types, which is why fnd_table_of_varchar2_30 appears in dependent code. No other documented package references this object, so it functions as a leaf-level API consumed by forms and extensions rather than by sibling packages.