Search Results check_budget_type

Overview

APPS.PJI_SETUP_PKG is a PL/SQL package body that supports the setup and maintenance of Oracle Projects Intelligence (PJI), the reporting and summarization layer within Oracle E-Business Suite. The package encapsulates the validation and persistence logic required to configure PJI system settings, materialized-view/backlog summarization buckets, and system-level defaults used by project analytics. It is an internal (OTHER-classified, non-public API) package, meaning it is not part of a certified public interface and is invoked primarily by the PJI administrative forms, concurrent programs, and internal PJI code rather than by external integrations. The source header indicates the package has been under change control since 2005 (file PJIUT04B.pls), and it remains deployed in both 12.1.1 and 12.2.2. Its central responsibility is to ensure that the configuration records written to the PJI_SYSTEM_SETTINGS table are internally consistent and reference valid organization structures and valid budget types before they are committed.

Key Procedures and Functions

The package exposes twelve documented program units. They fall into three functional clusters: system-settings maintenance, summarization-bucket maintenance, and reference-data validation.

• PJI_SYS_SETTINGS_UPDATE_ROW — Validates and updates the PJI_SYSTEM_SETTINGS table. It accepts the full set of PJI configuration parameters, including organization structure and version, default period type, as-of date and cycle for each PJI reporting area (PRJPIP, PRJBAB, RESUTL, RESAVL, RESPLN, PRJHLT, PRJACT, PRJPRF, PRJCST), the PA and GL period flags, numeric thresholds (conversion ratio days, book-to-bill days, DSO days, dormant backlog days), and the cost/revenue budget type and conversion rule settings. This is the primary write path for PJI setup.
• PJI_MT_BSR_INSERT_ROW — Inserts a budget-versus-summary (BSR) summarization record, supporting the PJI materialized-view bucket infrastructure.
• PJI_MT_PIP_UPDATE_ROW — Updates the period-in-process (PIP) summarization configuration rows.
• PJI_MT_DLS_UPDATE_ROW — Updates detail-line-summary (DLS) configuration rows.
• PJI_MT_RES_AVL_DUR_UPDATE_ROW — Updates the resource-availability-duration summarization settings.
• PJI_MT_AVL_UPDATE_ROW — Updates availability summarization settings.
• PJI_VALIDATE_BUCKET_RANGES — Validates the ranges defined for PJI summarization buckets, preventing overlapping or invalid bucket boundaries in PJI_MT_BUCKETS.
• PJI_INSERT_EVENTS_LOG — Writes diagnostic or audit entries to the PJI events log, providing a trace of setup activity.
• CHECK_ORG_STRUCTURE — Verifies that the organization structure supplied to the settings process exists and is valid, querying PER_ORGANIZATION_STRUCTURES.
• CHECK_ORG_STRUCTURE_VERSION — Verifies that the specified version of the organization structure is valid and effective, querying PER_ORG_STRUCTURE_VERSIONS.
• CHECK_BUDGET_TYPE — Validates a supplied budget type against PA_BUDGET_TYPES. This is the validation invoked when the cost or revenue budget type parameters are passed to PJI_SYS_SETTINGS_UPDATE_ROW, and it is the routine most commonly referenced by administrators investigating budget-type configuration errors.
• DERIVE_SUMMARIZATION_FLAGS — Derives the appropriate summarization flag values from the settings supplied, determining which PJI summarization processes are enabled.

Tables Accessed

• PJI_SYSTEM_SETTINGS — The principal table read and written by the package; stores the global PJI configuration for the installation.
• PJI_MT_BUCKETS — Holds the summarization bucket definitions validated by PJI_VALIDATE_BUCKET_RANGES.
• PA_BUDGET_TYPES — Reference table queried by CHECK_BUDGET_TYPE to confirm that a cost or revenue budget type is defined and valid.
• PER_ORGANIZATION_STRUCTURES — Queried by CHECK_ORG_STRUCTURE to confirm the organization structure exists.
• PER_ORG_STRUCTURE_VERSIONS — Queried by CHECK_ORG_STRUCTURE_VERSION to confirm the structure version exists and is valid.
• DUAL — Used for single-row validation and derivation queries.

Usage Notes

PJI_SETUP_PKG is invoked from the PJI setup user interface (the Projects Intelligence system settings and bucket maintenance forms) and from PJI administrative concurrent programs that initialize or refresh summarization configuration. Because the package is classified as OTHER and is not a certified public API, custom code should not call it directly; extensions should instead use supported public APIs or direct, carefully governed DML against PJI_SYSTEM_SETTINGS. The metadata records zero other packages referencing this package, confirming its role as an internal implementation dependency of the PJI application layer rather than a shared service. When diagnosing budget-type errors, CHECK_BUDGET_TYPE against PA_BUDGET_TYPES is the relevant validation point: an invalid or inactive budget type supplied to PJI_SYS_SETTINGS_UPDATE_ROW will cause the update to fail before any configuration is written. In 12.1.1 and 12.2.2 the behavior is consistent, as the package is not among those substantially reworked between those releases.