Search Results get_previous_period_info

Overview

APPS.POA_BIS_ALERTS is a PL/SQL package in Oracle E-Business Suite that supports the Procurement "Balance Scorecard" (formerly Balanced Scorecard/POA, Purchasing Open Alerts) analytical infrastructure. Its principal business purpose is to resolve the purchasing plan context — such as the applicable GL period, period set, currency, organization, and target values — and to evaluate performance against plan targets, then emit alerts through the BIS exception workflow. The package is defined with AUTHID CURRENT_USER, meaning it executes under the privileges of the invoking schema, and it is classified as a general (OTHER) API rather than a formal public interface. The header carries a legacy revision tag ($Header: poaalrts.pls 115.4), confirming this is a long-standing, lightly versioned component. In EBS 12.1.1 and 12.2.2 the package remains an internal support routine for scorecard period resolution and target comparison logic rather than a documented end-user API.

Key Procedures and Functions

The metadata documents 23 procedures and functions. The most relevant to period and target resolution include:

• GET_CURRENT_PERIOD_INFO — returns the start date, end date, period name, period set name, currency, and period type for the current open period relevant to a given organization. This is the routine that the searched term "get_current_period_info" refers to.
• GET_PERIOD_INFO — generalized variant that accepts a flag indicating whether the current period or another reference period is required, returning the same six period attributes.
• GET_PREVIOUS_PERIOD_INFO — returns the corresponding set of period attributes for the prior period, used for period-over-period comparisons.
• GET_GL_INFO — derives the period set name, currency, and period type for an organization without returning date boundaries.
• GET_TARGET_VALUE — retrieves a target value for a given target level, plan, time period, and organization, returning a BIS_TARGET_PUB target record.
• GET_TARGET_ORGS — returns the collection of target organizations for a plan and target level.
• GET_VALUE / SET_VALUE — read and write entries in the internal label/value table type defined in the package (POA_Label_Value_Tbl).
• GET_ACTUAL and the GET_ACTUAL_* variants — retrieve actual amounts from the scorecard summary tables (POACTLKG and POASPSAL) at the ALL, operating unit (OU), and organization levels.
• GET_REPORT_PARAM — resolves report-level parameters.
• GET_ORG_NAME — returns the organization name for a given organization identifier.
• COMPARE_TARGETS — evaluates actual performance against target values.
• PROCESS_ALERT_CURRENT_PERIOD / PROCESS_ALERT_PREVIOUS_PERIOD — generate alerts for the current and previous periods respectively.
• INSERT_ROW — inserts a row into the package's internal structure or alert staging.

Tables Accessed

• GL_PERIODS — the primary source for period names, start/end dates, and period types used by GET_CURRENT_PERIOD_INFO, GET_PERIOD_INFO, and GET_PREVIOUS_PERIOD_INFO.
• GL_DAILY_RATES — provides currency conversion rates for multi-currency target and actual comparisons.
• HR_ORGANIZATION_INFORMATION — supplies organization classification and period-set/ledger context associated with p_org_id.
• POA_BIS_SAVINGS — stores procurement savings/scorecard actuals consumed by the GET_ACTUAL routines.
• BIS_EXCPT_WF_S — the BIS exception workflow staging table into which alerts generated by PROCESS_ALERT_* are written.
• DUAL — used for constant and pseudo-column retrieval.
• PLITBLM — supports PL/SQL index-by table operations associated with the POA_Label_Value_Tbl type.

Usage Notes

POA_BIS_ALERTS is not referenced by any other documented package, indicating it is invoked directly by Oracle Forms (Purchasing/Oracle Procurement scorecard and period setup screens), concurrent programs that run scorecard alert processing, or custom extensions that need to resolve the active purchasing period. Practitioners seeking "get_current_period_info" should call GET_CURRENT_PERIOD_INFO as APPS.POA_BIS_ALERTS.GET_CURRENT_PERIOD_INFO, passing p_org_id and receiving the six OUT NOCOPY parameters (start date, end date, period name, period set name, currency, period type). Because the package uses AUTHID CURRENT_USER, the caller must hold appropriate execute privileges and, for cross-schema usage, the correct responsibility/ledger context. The GET_ACTUAL_* variants map directly to the historical POACTLKG and POASPSAL summary views, so report designers should select the variant matching their reporting level (ALL, OU, or ORG). All GET_ACTUAL_* routines and the period-info procedures are read-only; alert emission is performed only through PROCESS_ALERT_CURRENT_PERIOD and PROCESS_ALERT_PREVIOUS_PERIOD, which write to BIS_EXCPT_WF_S.