Search Results upload_worksheet_cp




Overview
Explore in AI Chat

Overview

PSB_POSITION_CONTROL_PVT is a private PL/SQL package in the APPS schema that supports the Oracle E-Business Suite Position Control functionality, part of the Human Resources and Budgeting integration (PSB module). It acts as the internal processing engine for validating, uploading, and maintaining position budget data, including FTE, costs, accounts, and attribute values. The package is classified as a PVT (private) API, meaning its procedures are not intended for direct external invocation but are called by other packages within the PSB schema. It is currently VALID in both 12.1.1 and 12.2.2 environments, and its responsibility centers on synchronizing position-level budgeting information between HRMS position/assignment data and the PSB budgeting tables.

Key Procedures and Functions

  • CONVERT_ORGANIZATION_ATTR_CP: Converts organization-level attributes into a form usable within position control budgeting, typically resolving organization hierarchy context for attribute-driven processing.
  • UPLOAD_WORKSHEET_CP: Processes uploaded budgeting worksheet data, mapping worksheet entries into the PSB position control tables.
  • UPLOAD_BUDGET_HRMS: Uploads budget amounts originating from HRMS (positions, assignments, and payroll elements) into the PSB budgeting structures.
  • MODIFY_POSITION_ACCOUNTS: Maintains the account/position set associations used to store position accounting distributions.
  • MODIFY_POSITION_COSTS: Handles changes to position cost data, including cost associated with payroll and GL flex mappings.
  • MODIFY_POSITION_FTE: Manages FTE (full-time equivalent) values for positions, supporting the time-period based FTE rules used in budgeting.
  • VALIDATE_POSITION_BUDGET: Performs validation of position budget records prior to commit or upload, enforcing consistency rules across attributes, costs, and accounts.
  • UPLOAD_ELEMENT: Uploads a single budget element (such as a payroll element or budget line component) into the PSB position control schema.
  • UPLOAD_ATTRIBUTE_VALUES: Persists position attribute values, writing to the attribute and attribute-value tables that describe positions within the budgeting model.

Tables Accessed

The package reads and writes through APPS synonyms across HRMS and PSB schemas. HRMS sources include HR_ALL_POSITIONS_F and PER_ALL_ASSIGNMENTS_F for position and assignment definitions; PAY_ALL_PAYROLLS_F, PAY_CALENDARS, PAY_PAYROLL_GL_FLEX_MAPS for payroll and GL mapping context; and PER_TIME_PERIODS, PER_TIME_PERIOD_RULES, and PER_TIME_PERIOD_TYPES for the FTE and budgeting time periods. PSB-owned tables include PSB_ACCOUNT_POSITION_SETS and its _S/_LINES variants (PSB_ACCOUNT_POSITION_SETS_S, PSB_ACCOUNT_POSITION_SET_LINES, PSB_ACCT_POSITION_SET_LINES_S) which store position-to-account set associations, and PSB_ATTRIBUTES, PSB_ATTRIBUTES_TL, and PSB_ATTRIBUTE_VALUES which hold the attribute definitions and values applied to positions.

Usage Notes

PSB_POSITION_CONTROL_PVT is referenced by several other packages, including PSB_BUDGET_REVISIONS_PVT, PSB_COPY_DATA_EXTRACT_PVT, PSB_GL_INTERFACE_PVT, and it also references itself for recursive processing. It is typically invoked indirectly through higher-level budget revision, data extract, and GL interface concurrent programs or forms rather than being called by end-user code. Because it is a private package, direct customization should be avoided; instead, integrations should target the public PSB APIs. When customizing or debugging, note that it depends on FND_API (the standard EBS API error-handling and messaging package) and STANDARD (SYS), and any change to its logic affects the PSB budget upload, revision, and GL interface flows it supports.