Search Results status_level




Overview
Explore in AI Chat

Overview

PA_PROJ_ROLE_TYPES_V is an APPS-owned view in the Oracle E-Business Suite Projects (PA) module, valid in releases 12.1.1 and 12.2.2. It presents the set of person-based project role types that are available for assignment to project team members and for use in project resource and role-based planning. The view is a filtered projection of the underlying translated role definition view, exposing role attributes such as job level bounds, menu assignment, schedulable and cost-query flags, freeze rules, and the DEFAULT_ACCESS_LEVEL column that determines the baseline access a person holding the role receives on project data.

Functionally, the view serves as a reporting and integration surface for project role configuration. Rather than requiring downstream reports, interfaces, or extensions to query the combined _VL and _TL tables directly, consumers can read from this view to obtain a clean, active set of assignable person roles with their default access semantics. Because it excludes system roles and restricts the party class, it is well suited to LOV-style queries, validation routines, and extracts that must reflect only user-facing project roles.

Underlying Base Objects

The view is defined over PA_PROJECT_ROLE_TYPES_VL, the multi-language base view holding project role type definitions. Its WHERE clause applies two filters: it excludes roles whose PROJECT_ROLE_ID falls within the reserved range 2 through 7, and it retains only rows where ROLE_PARTY_CLASS = 'PERSON'. This restricts output to role types applicable to individual persons rather than organization or group party classes, and removes seeded or non-assignable system roles.

Two PL/SQL packages participate in the definition and operation of this view. PA_ROLE_UTILS provides the GET_SCHEDULABLE_FLAG function, which is invoked in the SELECT list to derive the SCHEDULABLE_FLAG value from the role identifier. The documented reference to PA_ROLE_JOB_BG_UTILS indicates a supporting utility package associated with role and job-level processing. Both packages should be treated as dependencies when the view is invalidated, recompiled, or analyzed for downstream impact.

Key Columns

  • PROJECT_ROLE_ID and PROJECT_ROLE_TYPE — the unique identifier and the lookup code for the role type.
  • MEANING — the translated, user-facing name of the role, sourced from the translated view.
  • DEFAULT_ACCESS_LEVEL — the node of principal interest; it establishes the default access level granted when a person is assigned this role.
  • DEFAULT_MIN_JOB_LEVEL and DEFAULT_MAX_JOB_LEVEL — the job-level bounds applied to the role.
  • SCHEDULABLE_FLAG — derived via PA_ROLE_UTILS.GET_SCHEDULABLE_FLAG, indicating whether the role can be scheduled in resource planning.
  • QUERY_LABOR_COST_FLAG — controls whether labor cost information is visible for the role.
  • FREEZE_RULES_FLAG — reflects role-level freeze rule behavior.
  • DEFAULT_JOB_ID and MENU_ID — the default job and menu associated with the role.
  • START_DATE_ACTIVE and END_DATE_ACTIVE — date ranges governing role availability.
  • Audit columns (LAST_UPDATE_DATE, CREATED_BY, etc.) and ATTRIBUTE1–ATTRIBUTE15 — standard descriptive flexfield and audit context.

Common Use Cases and Queries

A frequent requirement is to list all active person roles together with their default access level, for example when validating role setup or driving access grants. A representative query follows:

  • SELECT PROJECT_ROLE_ID, PROJECT_ROLE_TYPE, MEANING, DEFAULT_ACCESS_LEVEL, QUERY_LABOR_COST_FLAG, SCHEDULABLE_FLAG FROM APPS.PA_PROJ_ROLE_TYPES_V WHERE SYSDATE BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, SYSDATE + 1) ORDER BY MEANING;
  • Filter for a specific access level: SELECT PROJECT_ROLE_ID, MEANING FROM APPS.PA_PROJ_ROLE_TYPES_V WHERE DEFAULT_ACCESS_LEVEL = :p_level;
  • Locate assignable roles for resource planning: SELECT PROJECT_ROLE_ID, MEANING FROM APPS.PA_PROJ_ROLE_TYPES_V WHERE SCHEDULABLE_FLAG = 'Y';

These patterns support role configuration audits, LOV population, security model reviews, and integration extracts within Oracle EBS Projects.