Search Results cp_effective_date_p

Overview

The APPS.BEN_BEN_US_COBNL_XMLP_PKG package is a PL/SQL wrapper generated to support an Oracle XML Publisher (BI Publisher) concurrent report within the Oracle E-Business Suite Benefits module. The naming convention indicates a Benefits (BEN) report serving a United States legislative/regulatory requirement (US), with the "COBNL" identifier aligning to a Consolidated Omnibus Budget Reconciliation Act-style notification output delivered through the XMLP reporting engine. The package was authored under the file name BEN_US_COBNLS.pls, with the header version 120.1 dated December 10, 2007, as reflected in the ETRM metadata.

The package encapsulates the report's parameter bindings, format triggers, and data-preparation logic required before and after the XML Publisher template renders its output. Its primary business purpose is to produce a formatted notification letter — typically a benefits continuation or status notice — for a given person or benefits group, using the effective date supplied by the concurrent request.

Key Procedures and Functions

The package exposes eight documented program units, most of which follow the standard Oracle Reports-to-XMLP conversion pattern.

• CP_EFFECTIVE_DATE_P — The function corresponding to the user's search term. It returns the effective date value used throughout the report, drawing on the cp_effective_date package-level variable. This is the canonical accessor for the report's effective date context.
• CP_LER_TEXT_P — Returns the "learned" text for a given legal/regulatory type and record date, populating the CP_ler_text variable that carries the statutory wording into the report output.
• CF_1FORMULA — A format formula that assembles a composed string from administrator name, location address components, city, state, ZIP, phone, and a person/covered-provider identifier. This drives the letterhead or contact block.
• CF_STANDARD_HEADERFORMULA — The standard header formula returning a numeric value that drives header selection or formatting.
• CF_CMCD_ACTY_REP_PRDFORMULA — Maps an activity reporting-period code to a display character, controlling how reporting periods appear on the output.
• UPDATE_PCD_SENT_DT — A procedure that writes a "sent date" against a covered-provider record, using the effective date to timestamp the correspondence.
• BEFOREREPORT — The pre-execution hook where parameters are validated and any required setup is performed.
• AfterReport — The post-execution hook for cleanup or final updates after the XML template has rendered.

Tables Accessed

The documented table references are BEN_PER_CM_PRVDD_F and DUAL, accessed through APPS synonyms.

• BEN_PER_CM_PRVDD_F — The Benefits person/communication-provided detail flex table. The package reads provider/communication records here to build the notification content and writes the "sent date" back via UPDATE_PCD_SENT_DT, providing an audit trail that correspondence was issued.
• DUAL — The Oracle single-row pseudo-table, used by the format formula functions (such as CF_STANDARD_HEADERFORMULA) to evaluate expressions within a SQL context.

Usage Notes

This package is not intended for direct invocation by end users. It is generated as a report-supporting package for the XML Publisher concurrent program and is typically executed when the concurrent manager runs the associated Benefits US notification report. At runtime the manager populates the public parameters — business group, person, benefits group, location, organization, program, effective date, and concurrent request ID — before BEFOREREPORT fires.

Because the package is classified as OTHER and is referenced by zero other packages, it functions as a leaf-level, report-specific artefact. Custom development should avoid calling it directly; integrations requiring effective-date logic or provider sent-date updates should use the supported Benefits APIs against BEN_PER_CM_PRVDD_F instead. The package is similar in structure across EBS 12.1.1 and 12.2.2, and no behavioural divergence is documented between those releases.