Search Results get_job_level

Overview

PA_JOB_UTILS is an Oracle EBS Projects (PA) utility package that centralizes job-related validation, derivation, and lookup logic used throughout the Projects application. Its responsibilities span both Oracle Human Resources (PER) job definitions and Projects-specific job structures, including job groups, job relationships, and the job mappings that govern how Human Resources jobs are made available for project resource assignment. The package exists primarily as an internal support layer rather than a user-facing API; it is referenced by nine other packages across the Projects schema, which rely on it for consistent job validation and identifier resolution.

The package also honors several profile options. Debug output is conditional on the PA_DEBUG_MODE profile option, and behavior around cross-business-group access and the project resource job group is influenced by HR_CROSS_BUSINESS_GROUP and PA_PROJ_RES_JOB_GRP respectively. This design allows the same utility routines to operate consistently across multi-organization and multi-business-group deployments.

Key Procedures and Functions

• CHECK_JOBNAME_OR_ID — Resolves job identity: if a job name is supplied it is converted to the corresponding job identifier; if an identifier is supplied it is validated according to a check flag. It supports an optional job group context.
• CHECK_JOBLEVEL — Validates a job level value against the job's defined hierarchy or level attributes.
• CHECK_JOB_GROUPNAME_OR_ID — Analogous to the job name/identifier check, but for job groups: converts a group name to an identifier or validates a supplied identifier.
• VALIDATE_JOB_RELATIONSHIP — Verifies that a relationship defined between jobs (parent/child or similar) is valid.
• GET_JOB_LEVEL — The routine most commonly searched for; retrieves the job level associated with a given job, used to determine seniority or hierarchical placement.
• CHECK_MASTER_JOB — Determines whether a job is designated as a master job within the job structure.
• GET_JOB_GROUP_ID — Returns the identifier of a job group for a given context.
• PROJ_RES_JOB_GROUP_EXISTS — Tests whether a project resource job group has been configured.
• IS_PROJ_RES_JOB_GROUP — Determines whether a given job group is the designated project resource job group.
• GET_PROJ_RES_JOB_GROUP — Retrieves the project resource job group, drawing on the PA_PROJ_RES_JOB_GRP profile option.
• GET_JOB_NAME — Returns the job name for a supplied job identifier.
• GET_JOB_MAPPING — Retrieves the mapping between Human Resources jobs and Projects job structures.
• CHECK_JOB_RELATIONSHIPS — Performs bulk or set-level validation of job relationships.
• LOG_MESSAGE — Internal debug logging routine gated by PA_DEBUG_MODE and written through PA_DEBUG.

Tables Accessed

• PER_JOBS — Source of job names, identifiers, and level attributes; central to name/ID resolution and job level retrieval.
• PER_JOB_GROUPS — Stores job group definitions; used by the job group validation and retrieval routines.
• HR_ORGANIZATION_INFORMATION — Provides business group and organization-level attributes relevant to cross-business-group checks.
• PA_JOB_RELATIONSHIPS — Projects-specific table holding job-to-job relationships; read and validated by the relationship routines.
• PER_JOB_EXTRA_INFO — Stores additional descriptive attributes for jobs, including the job level characteristic used by GET_JOB_LEVEL.

Usage Notes

PA_JOB_UTILS is not an end-user API. It is invoked from Projects forms and from other PL/SQL packages wherever job identity, level, grouping, or relationships must be established or validated. Customizations and extensions that need to resolve a job name to an identifier, retrieve a job level, or confirm project resource job group configuration should call these routines rather than querying PER and PA tables directly, ensuring that profile-option logic and cross-business-group rules are respected. Because the package is referenced by nine other packages, changes to its behavior can propagate broadly; regression testing across Projects resource management and staffing flows is advised. Debug tracing can be enabled by setting the PA_DEBUG_MODE profile option to Y.