Search Results gl_segment

Overview

PSP_EFF_REPORT_DETAILS_API is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified as an API within Oracle's Enterprise Tax and Reporting Management (ETRM) module. Its principal business function is to maintain the detail line records that comprise an effort report. Effort reports are used by organizations — particularly in public sector, government contracting, and grant-funded environments — to document the distribution of an employee's time across projects, awards, and activities for a given reporting period. Each effort report is represented by a header record in PSP_EFF_REPORTS and by one or more detail lines in PSP_EFF_REPORT_DETAILS. This package provides the programmatic interface for updating those detail lines, allowing effort percentages, project references, and related attributes to be modified after the report has been created. The package is fully validated (Status: VALID) and operates under the standard ETRM data model, mediating between the higher-level report creation logic and the underlying detail table.

Key Procedures and Functions

The documented public interface consists of a single procedure:

• UPDATE_EFF_REPORT_DETAILS — Updates one or more detail records associated with an effort report. This is the only documented entry point in the package and is the mechanism by which changes to effort report lines are applied through a supported API rather than by direct DML against the base table. The procedure encapsulates the update logic, ensuring that any business rules, validation, or attribute derivations applied to effort report details are honored consistently regardless of the calling context.

No other public procedures or functions are enumerated in the package metadata. Any additional internal helpers or private routines are not part of the documented API surface and should not be invoked directly.

Tables Accessed

The package reads from and writes to the following tables via APPS synonyms:

• PSP_EFF_REPORT_DETAILS — The primary target of the API. Each row represents a single effort distribution line belonging to a parent effort report. The UPDATE_EFF_REPORT_DETAILS procedure modifies records in this table.
• PSP_EFF_REPORTS — The header table for effort reports. The API references it to validate the parent report and to enforce header-to-detail integrity during updates.
• PSP_REPORT_TEMPLATES_H — Stores the report template definitions that govern how effort reports and their detail lines are structured. The API consults this table to ensure detail updates conform to the applicable template.
• PLITBLM — A standard PL/SQL table used as a bulk index-by table structure for handling collections of records in bulk operations.

Usage Notes

PSP_EFF_REPORT_DETAILS_API is an internal ETRM API rather than an end-user-facing component. It is referenced by two other packages — PSP_CREATE_EFF_REPORTS and PSP_ERD_EXT — indicating it is invoked during the effort report creation workflow and by the effort report details extension package. Custom code should call UPDATE_EFF_REPORT_DETAILS instead of performing direct DML against PSP_EFF_REPORT_DETAILS, so that the validation and template-conformance logic embedded in the API is preserved. Because ETRM functionality is delivered through concurrent programs and Oracle Forms-based pages, the API is most commonly triggered indirectly when users create or amend effort reports, or by extension packages that layer customer-specific behavior onto the standard flow. The package is valid in both Oracle EBS 12.1.1 and 12.2.2, and the underlying data model is consistent across those releases.