Search Results create_fresh_period_profile

Overview

APPS.PA_FIN_PLAN_PUB is a public utility API package within Oracle Projects that supports the Financial Plan and Organization Forecast functionality. Its declared purpose is to provide utility APIs for Organization Forecast pages, and it exposes a broad set of version-management and plan-generation operations used by Oracle E-Business Suite forms, concurrent programs, and custom integrations. The package header comment identifies it as PA_FIN_PLAN_PUB, with package-level variables such as l_module_name and P_PA_DEBUG_MODE used for debug and diagnostics. Debug mode is derived from the PA_DEBUG_MODE profile option, defaulting to 'N'. The package is classified as a PUB interface, meaning it is intended to be callable from outside Oracle Projects, and it is referenced by 17 other packages, indicating its central role in the financial plan processing chain. Because it is an API package body with documented public procedures, it is eligible for supported extension and integration by customers and partners.

Key Procedures and Functions

The ETRM metadata documents 18 procedures and functions. The version lifecycle is managed by CREATE_VERSION, UPDATE_VERSION, and DELETE_VERSION, supported by DELETE_VERSION_HELPER, COPY_VERSION, BASELINE, and MARK_AS_ORIGINAL. Together, these govern creation, modification, removal, copying, baselining, and designation of financial plan versions. Submission and rework flow is handled by SUBMIT_CURRENT_WORKING, SET_CURRENT_WORKING, and REWORK_SUBMITTED, which control the transition of a version through its processing states. Organization Forecast generation is served by CREATE_VERSION_ORGFCST, CREATE_ORG_FCST_ELEMENTS, and CREATE_DEFAULT_PLAN_TXN_REC. REGENERATE supports regeneration of plan data. CREATE_FRESH_PERIOD_PROFILE addresses GL period profile setup required for financial plan processing. Supporting bulk and matrix operations include CALL_MAINTAIN_PLAN_MATRIX, INSERT_PLAN_LINES_TMP_BULK, and REFRESH_RES_LIST_ASSIGNMENT, which populate temporary plan lines and refresh resource list assignments.

Tables Accessed

The package references APPS synonyms across the Projects and General Ledger schemas. Financial plan version metadata is read from PA_BUDGET_VERSIONS and PA_BUDGET_VERSIONS_S, with plan detail in PA_BUDGET_LINES and PA_FIN_PLAN_ADJ_LINES plus its _S variant. Temporary staging is handled through PA_FIN_PLAN_LINES_TMP. Project and task context comes from PA_PROJECTS_ALL, PA_TASKS, and PA_PROJ_ELEMENT_VERSIONS. Organization Forecast options are read from PA_PROJ_FP_OPTIONS, and project agreement data from PA_AGREEMENTS_ALL. Period data flows from PA_PROJ_PERIODS_DENORM, GL_PERIODS, and GL_PERIOD_STATUSES, used to validate and align financial plan periods. Control items are sourced from PA_CONTROL_ITEMS.

Usage Notes

PA_FIN_PLAN_PUB is typically invoked from the Oracle Projects Financial Plan and Organization Forecast forms, from concurrent programs that submit or regenerate plans, and from custom code extending standard plan behavior. Since it is a PUB API, callers should use only the declared public signatures and must not depend on internal helper procedures. The PA_DEBUG_MODE profile controls diagnostic output. Because the package is referenced by 17 other packages, changes to its behavior can have cascading effects, and customizations should be validated against the baseline version supplied by Oracle.