Search Results get_fp_options_to_be_copied

Overview

APPS.PA_FP_COPY_FROM_PKG is a VALID PL/SQL package in the Oracle E-Business Suite (12.1.1 / 12.2.2) Applications schema, associated with the Oracle Projects financial planning module. Its principal business function is to copy financial plan structures and their associated data from a source project (or source financial plan) into a target project or plan. The package supports copying financial plans, budget versions, budget lines, resource assignments, and period profiles, and it also manages the locking and setup operations required when a financial plan is copied or when actual amounts are used to shift period profiles. It is classified as OTHER in the API classification, indicating it is an internal supporting package rather than a public, standalone API. It operates within the same schema and is referenced by ten other packages, reflecting its role as a reusable copy utility for financial planning objects.

Key Procedures and Functions

The documented package contains sixteen procedures and functions. Their purposes are:

• COPY_PLAN — Copies an entire financial plan from a source to a target context.
• COPY_BUDGET_VERSION — Copies a specified budget version.
• COPY_RESOURCE_ASSIGNMENTS — Copies resource assignment records associated with the plan.
• COPY_BUDGET_LINES — Copies budget line detail records.
• COPY_PERIODS_DENORM — Copies and populates the denormalized period data for the plan.
• COPY_FINPLANS_FROM_PROJECT — Copies financial plans from a source project.
• GET_FP_OPTIONS_TO_BE_COPIED — Retrieves the financial plan options that should be copied.
• COPY_BUDGETS_FROM_PROJECT — Copies budgets originating from the source project.
• COPY_CURRENT_PERIOD_PROFILES — Copies the current period profile records.
• GET_CREATE_SHIFTED_PD_PROFILE — Determines or creates a shifted period profile.
• COPY_WP_BUDGET_VERSIONS — Copies budget versions in the workplan/planning context.
• CREATE_RES_TASK_MAPS — Creates resource-to-task mapping records.
• ACQUIRE_LOCKS_FOR_COPY_ACTUAL — Acquires locks required before copying actual amounts.
• COPY_BUDGET_LINES_APPR_REV — Copies approved/revisioned budget lines.
• UPDATE_PLAN_SETUP_FOR_WP_COPY — Updates plan setup data for workplan copying.

Tables Accessed

The package reads and writes financial planning and project data through APPS synonyms, including PA_BUDGET_VERSIONS and PA_BUDGET_LINES / PA_BUDGET_LINES_S (budget version and line definitions), PA_FIN_PLAN_AMOUNT_SETS (plan amount sets), PA_PROJ_FP_OPTIONS (financial plan options), PA_PROJ_PERIOD_PROFILES and PA_PROJ_ELEMENT_VERSIONS (period profiles and element versions), PA_RESOURCE_ASSIGNMENTS (assignment data), PA_TXN_ACCUM (transaction accumulations), and the project tables PA_PROJECTS and PA_PROJECTS_ALL. It also references PA_PERIODS, GL_PERIODS, GL_PERIOD_STATUSES, and FND_USER. These tables support copying and validating plan structures, budget amounts, periods, and ownership data.

Usage Notes

The package is invoked indirectly through higher-level financial planning packages, notably PA_FIN_PLAN_PUB and the FP public/private packages (PA_FP_EDIT_LINE_PKG, PA_FP_ELEMENTS_PUB, PA_FP_GEN_BUDGET_AMT_PUB, PA_FP_GEN_FCST_PG_PKG, PA_FP_PLANNING_TRANSACTION_PUB, PA_PROJECT_CORE1, PA_PROJECT_STRUCTURE_PVT1, PA_PROJ_TASK_STRUC_PUB). It is typically called when a user copies a financial plan, budget, or resource assignment between projects through Oracle Projects forms or concurrent programs. Custom code should invoke the documented public wrappers rather than calling PA_FP_COPY_FROM_PKG directly, since it is an internal copy utility.