Search Results pa_num_tbl_type




Overview
Explore in AI Chat

Overview

APPS.PJI_FM_PLAN_MAINT_T_PVT is a private (PVT) PL/SQL package within the Oracle EBS Projects Intelligence (PJI) schema. Its business purpose is to maintain, extract, and roll up financial plan data used by Oracle Project Portfolio Management and Project Financial Management reporting. The package supports the movement of plan versions and plan amounts between staging, fact, and aggregation tables that feed the Project Financial Plan (FP) reporting model. The "_T_PVT" suffix and PVT classification indicate that the package is an internal private API intended for use by other PJI packages rather than being called directly by end users or external applications. It is a supporting component of the financial plan maintenance and accumulation framework, responsible for copying plans, extracting plan versions and amounts, reversing plan amounts, and populating the FP fact tables used in project financial reporting.

Key Procedures and Functions

The package exposes 54 documented procedures and functions. These fall into several functional groups:

Tables Accessed

The package reads and writes both PA and PJI tables through APPS synonyms. PA_PROJECTS_ALL, PA_BUDGET_VERSIONS, PA_BUDGET_LINES, PA_IMPLEMENTATIONS_ALL, PA_PROJ_FP_OPTIONS, and PA_PROJ_ELEM_VER_STRUCTURE supply project, budget, version, and FP configuration data. PA_RBS_PRJ_ASSIGNMENTS, PA_RESOURCE_ASSIGNMENTS, PA_RESOURCE_LISTS_ALL_BG, and PA_RBS_TXN_ACCUM_MAP provide resource breakdown structure definitions and assignment mappings. PJI tables PJI_AC_AGGR_PJP1_T, PJI_AC_RMAP_ACR_T, PJI_AC_XBS_ACCUM_F, PJI_FM_AGGR_DLY_RATES_T, and PJI_FM_EXTR_PLAN_LINES hold aggregated, mapped, and extracted plan data consumed by the reporting layer. The type dependency PA_NUM_TBL_TYPE is a PL/SQL collection type widely used to pass arrays of numbers between PJI packages; PA_VARCHAR2_30_TBL_TYPE provides the corresponding string collection.

Usage Notes

PJI_FM_PLAN_MAINT_T_PVT is referenced by APPS.PJI_FM_PLAN_MAINT, APPS.PJI_FM_XBS_ACCUM_MAINT, and by itself internally. It is invoked indirectly when plan maintenance and accumulation processes execute within the Projects Intelligence offering, typically through concurrent programs and scheduled processes that maintain financial plan data. Custom code should not call this PVT package directly; developers requiring similar functionality should use the public PJI_FM_PLAN_MAINT interface instead. Because the package depends on PA_NUM_TBL_TYPE and PA_VARCHAR2_30_TBL_TYPE, callers passing collection arguments must ensure the correct Project Costing collection types are used.