Search Results extract_cb_co_plan_versions

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:

Plan copy routines: COPY_PRIMARY, COPY_PLANS, and COPY_PRIMARY_SINGLE manage the duplication of primary and secondary plan definitions and their associated amounts.
Plan version extraction: EXTRACT_FIN_PLAN_VERSIONS, EXTRACT_FIN_PLAN_VERS_BULK, and EXTRACT_CB_CO_PLAN_VERSIONS retrieve financial plan version records and cost-burden/currency plan versions for downstream processing.
Plan amount extraction: EXTRACT_PLAN_AMOUNTS_PRIRBS, EXTRACT_PLAN_AMOUNTS_SECRBS, EXTRACT_PLAN_AMTS_PRIRBS_GLC12, and EXTRACT_PLAN_AMTS_SECRBS_GLC12 extract primary and secondary resource breakdown structure plan amounts, including variants supporting GLC12 (Project Costing GL) configurations.
Amount reversal and rollup: REVERSE_PLAN_AMTS, ROLLUP_FPR_RBS, and ROLLUP_FPR_RBS_T_SLICE reverse or aggregate financial plan amounts across RBS hierarchies and time slices.
Fact table maintenance: INSERT_INTO_FP_FACT, MERGE_INTO_FP_FACT, GET_FP_ROW_IDS, UPDATE_FP_ROWS, INSERT_FP_ROWS, and DELETE_PRI_NONTIMEPH_ENTDAMTS load, reconcile, and delete rows in the financial plan fact structures, including non-time-phased entered amounts.
WBS and resource structure handling: CREATE_WBSRLP builds WBS rollup relationships used by the aggregation logic.

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.