Search Results pa_varchar2_80_tbl_type




Overview
Explore in AI Chat

Overview

APPS.PA_ROLE_PROFILES_PUB is a public PL/SQL package within the Oracle E-Business Suite Oracle Projects (PA) application. Its designated role is the maintenance of role profile definitions and the association of resources to those role profiles. Role profiles in Oracle Projects describe the set of roles, competencies, and staffing characteristics that apply to a resource or to a group of resources, supporting resource assignment, search, and staffing decisions across project and resource management flows. The package is classified as a public (PUB) API, indicating that it is intended for supported external invocation, including from forms, concurrent programs, and custom extension code.

The package metadata confirms a status of VALID and identifies dependencies on the types PA_NUM_TBL_TYPE and PA_VARCHAR2_80_TBL_TYPE. The latter is the collection type referenced when searching for the term "pa_varchar2_80_tbl_type." This type dependency indicates that several of the package's entry points accept or return PL/SQL collections of VARCHAR2(80) values, most likely to carry lists of role names, profile names, or similar textual identifiers in batch or multi-row operations.

Key Procedures and Functions

The documented public interface consists of four procedures:

  • ADD_DEFAULT_PROFILE — Establishes a default role profile, creating the association required when a resource or organizational context has no explicitly assigned profile and a system default must apply.
  • UPDATE_DEFAULT_PROFILE — Modifies an existing default role profile, allowing the profile definition or its associated lines to be changed without deleting and recreating the record.
  • DELETE_PROFILE — Removes a role profile and its associated definition. Deletion logic must respect referential constraints to role profile lines.
  • CREATE_PROFILE_FOR_RESOURCE — Creates a role profile specifically for an individual resource, binding the profile to a person or resource record for staffing and assignment purposes.

No parameter lists are documented in the available metadata, and none are asserted here.

Tables Accessed

The package operates against three documented tables:

  • PA_ROLE_PROFILES — The header table storing role profile definitions; read and written by all create, update, and delete operations.
  • PA_ROLE_PROFILE_LINES — The detail table holding the individual role or competency lines belonging to each profile; maintained in conjunction with the header.
  • PLITBLM — A standard Oracle Projects message/translation table used for error and message text handling during API processing.

The collection types PA_NUM_TBL_TYPE (numeric) and PA_VARCHAR2_80_TBL_TYPE (VARCHAR2(80)) are used as parameter structures for passing lists of identifiers and names into the procedures.

Usage Notes

Because PA_ROLE_PROFILES_PUB is a PUB-classified API, it should be invoked for all supported manipulation of role profiles rather than through direct DML on the underlying tables. Typical invocation paths include Oracle Projects setup and resource management forms that maintain role profile data, concurrent programs that generate or refresh default profiles across resources, and custom PL/SQL code that provisions profiles during implementation or data migration. The presence of PLITBLM references indicates that callers should expect message handling through the standard Oracle Projects message stack and should check for errors after each call. Listing the package with the APPS schema and referencing it through the standard synonyms is the recommended approach in a 12.1.1 or 12.2.2 environment.