Search Results per_job_extra_billability

Overview

PA_HR_UPDATE_API is a public PL/SQL package in the APPS schema that synchronizes Oracle Human Resources (HR) data with Oracle Projects resource and job structures. It sits at the boundary between the HRMS schema (PER_% and HR_% tables) and the Projects schema (PA_% tables), providing the procedural logic that keeps project resources, job relationships, and organizational assignments consistent with their HR source records. The package is classified as an API and is closely associated with the resource management and project parties subsystems, most notably PA_ASSIGNMENTS_PUB, PA_RESOURCE_PVT, PA_PROJECT_PARTIES_PVT, PA_R_RESOURCE_PVT, PA_JOB_UTILS, and PA_RES_MANAGEMENT_AMG_PUB.

Its principal business purpose is to propagate HR changes—new hires, transfers between organizations, job and grade changes, end-dating of assignments, and operating unit changes—into the Projects denormalized resource tables so that project reporting, resource searches, and billing continue to reflect current employee data.

Key Procedures and Functions

The package exposes 31 documented procedures and functions that can be grouped by function:

• Operating unit handling: CHECK_EXP_OU, VALIDATE_EXP_OU, DEFAULT_OU_CHANGE, UPDATE_OU_RESOURCE — validate and apply changes to the expenditure operating unit associated with a resource.
• Job classification and validation: CHECK_MASTER_JOB, CHECK_JOB_BILLABILITY, CHECK_JOB_SCHEDULABLE, CHECK_JOB_UTILIZATION, GET_JOB_GROUP_ID, GET_JOB_NAME, GET_JOB_LEVEL, PER_JOB_EXTRA_BILLABILITY, UPDATE_JOB_LEVELS, PROJ_RES_JOB_GROUP_CHANGE — determine a job's billable, schedulable, and utilization attributes and maintain job-level and job-group relationships.
• Resource and organizational maintenance: PULL_RESOURCES, MAKE_RESOURCE_INACTIVE, UPDATE_ENDDATE, UPDATE_ORG, UPDATE_OU_RESOURCE — create or update project resources, inactivate employees, and end-date or reassign organizational records.
• Lookup/utility functions: GET_ORG_NAME, GET_GRADE_NAME — return descriptive names for organizations and grades from HR reference data.

Tables Accessed

The package reads and writes across both HRMS and Projects tables:

• HRMS source tables: PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, PER_JOBS, PER_JOB_EXTRA_INFO, PER_JOB_GROUPS, PER_GRADES, PER_VALID_GRADES, HR_ALL_ORGANIZATION_UNITS, HR_ALL_ORGANIZATION_UNITS_TL, and HR_ORGANIZATION_INFORMATION — used to source employee, assignment, job, grade, and organization attributes.
• Projects target tables: PA_RESOURCES_DENORM (the denormalized resource repository), PA_ALL_ORGANIZATIONS, PA_JOB_RELATIONSHIPS, PA_CANDIDATES, and PA_IMPLEMENTATIONS_ALL — updated to reflect HR changes in the Projects data model.

Usage Notes

PA_HR_UPDATE_API is normally invoked indirectly. It is called by the resource management APIs (PA_RESOURCE_PVT, PA_ASSIGNMENTS_PUB, PA_R_PROJECT_RESOURCES_PVT, PA_RES_MANAGEMENT_AMG_PUB), by PA_JOB_UTILS, and by PA_PROJECT_PARTIES_PVT when project parties or resources are created or modified. It also underlies the view PA_C_JOBLEVEL_RES_V and the PA_HR_UPDATE_PA_ENTITIES program, indicating that HR-driven or concurrent-program-driven refreshes of project resources pass through this API.

Because it is a documented public API, custom integrations that need to propagate HR job, grade, organization, or assignment changes into Oracle Projects should call this package rather than performing direct DML against PA_RESOURCES_DENORM or PA_JOB_RELATIONSHIPS. The validation functions (CHECK_EXP_OU, VALIDATE_EXP_OU, CHECK_JOB_BILLABILITY, and similar) are suitable for pre-validation before performing updates. As with all APPS APIs, execution should occur under a properly initialized FND_GLOBAL session, typically as part of an HR update flow in EBS 12.1.1 or 12.2.2.