Results for “start_workers”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PA_RP_UTIL is a PL/SQL utility package owned by the APPS schema in Oracle E-Business Suite, classified as a UTIL (utility) API within the Project Accounting (PA) module. Its naming and documented dependencies indicate that it supports the Oracle Project Resource Planning (RP) feature set — the subsystem responsible for resource assignment, staffing, and reporting workflows. The package encapsulates common helper routines that are shared across the resource planning concurrent programs, forms, and job-processing infrastructure rather than exposing a standalone business API. In ETRM it is documented as VALID and is referenced by no other packages, confirming its role as a leaf-level utility library consumed by application-layer components rather than by other PL/SQL APIs. It draws on standard SYS/SYSTEM dependencies and declares two collection types, PA_NUM_TBL_TYPE and PA_VARCHAR2_240_TBL_TYPE, which carry numeric and long-varchar arrays between its internal routines and their callers.

Key Procedures and Functions

Thirteen documented procedures and functions are exposed by the package. Their names map to distinct responsibilities within the resource planning job cycle:

• ASSIGN_JOB, START_WORKERS, CHECK_WORKERS — control the resource planning job framework, assigning work to background processes, launching parallel workers, and verifying worker status.
• SAVE_PARAMS — persists concurrent program parameter values, typically into PA_RP_CONC_PARAMS, so that resource planning runs can be re-executed consistently.
• ADD_MESSAGE — writes status or error messages through the standard message stack, supporting user-facing feedback from concurrent processing.
• GET_EMAIL_ADDRESSES — resolves recipient addresses, using FND_USER, for notification and distribution processing.
• DERIVE_CURRENCY_INFO, DERIVE_PROJ_PARAMS, DERIVE_CALENDAR_INFO — derive currency, project, and calendar context from implementation and project setup data before processing begins.
• IS_DT_TRIMMED, SAVE_TRIMMED_DT — test and persist date-trimming state, supporting date normalization across resource planning time buckets.
• GET_PERCENT_COMPLETE, GET_TASK_PROJ_NUMBER — return derived project values: percent complete and the owning project number for a task.

Tables Accessed

The package reaches the following tables through APPS synonyms:

• PA_RP_CONC_PARAMS, PA_RP_JOB_ASSIGNMENTS, PA_RP_JOB_ASSIGNMENTS_HISTORY — store concurrent parameters and job assignment/audit records.
• PA_RP_DEFINITIONS_B, PA_RP_TEMPLATE_LISTS, PA_RP_LOBS — resource planning definition, template, and large-object storage.
• PA_PROJECTS_ALL, PA_PROJ_ELEMENTS, PA_BUDGET_VERSIONS, PA_PROJ_FP_OPTIONS — core project, task, budget, and financial-plan option data used by the derive and percent-complete routines.
• PA_IMPLEMENTATIONS — organization-level Project Accounting setup.
• PA_OBJECT_DIST_LISTS, PA_DIST_LIST_ITEMS — distribution list configuration supporting email/notification routing.
• GL_PERIOD_STATUSES — period open/closed status for calendar derivation.
• FND_USER — user records for email address resolution.

Usage Notes

PA_RP_UTIL is invoked indirectly. Resource planning forms and concurrent programs call its routines to prepare parameters, resolve currency and calendar context, launch workers, and emit messages. The GET_EMAIL_ADDRESSES routine is typically reached when notification or distribution-list processing is triggered, and GET_PERCENT_COMPLETE and GET_TASK_PROJ_NUMBER support task-level reporting and display. Because the package is documented as referenced by zero other packages, it should be treated as internal implementation rather than a supported extension point; customizations should call Oracle's supported PA public APIs instead of PA_RP_UTIL directly, and any dependency on it risks invalidation during patching or upgrades between EBS 12.1.1 and 12.2.2.