Search Results create_parameter_b




Overview
Explore in AI Chat

Overview

The APPS.FF_FUNCTION_PARAMETERS_BK1 package body is an Oracle HRMS API Hook Pre-processor generated stub within the Oracle E-Business Suite. It forms part of the FastFormula (FF) infrastructure, which underpins the configurable rules engine used throughout Oracle HRMS and related applications such as Payroll, Benefits, and Compensation. The package belongs to the FF_FUNCTION_PARAMETERS family and is classified under API type OTHER in the ETRM metadata. Its header identifier, ffffpapi.pkb, and the version stamp 120.0 confirm it was generated by Oracle's internal tooling rather than hand-coded.

The _BK1 suffix designates this as a backward-compatibility or hook placeholder variant. In the Oracle HRMS API architecture, "BK" packages are generated alongside the primary business API to provide pre-processing and post-processing hook points. At delivery, these procedures contain no functional logic—only location-tracing calls—and are intended to be customised by implementers who need to intercept API execution without modifying the base package.

Key Procedures and Functions

The package exposes two documented procedures:

  • CREATE_PARAMETER_A — The fuller variant of the parameter-creation hook. It declares a comprehensive parameter list covering the effective date, the parent function identifier, the parameter class and data type, the parameter name, optional and continuing-parameter flags, sequence number, and object version number. In the delivered code it performs no inserts or updates; it merely brackets execution with hr_utility.set_location calls to record entry and exit.
  • CREATE_PARAMETER_B — A reduced variant of the same hook, omitting the sequence number and object version number arguments. As with variant A, its body contains only the two hr_utility.set_location tracing statements.

Both procedures are declared with the IS clause and an empty executable section, which is characteristic of generated hook stubs. Neither returns a value, and neither contains exception handling, DML, or calls to other application programming interfaces.

Tables Accessed

The ETRM metadata records no table references for this package, either directly or through APPS synonyms. This is consistent with the delivered source, which contains no SQL statements at all. The underlying FF_FUNCTION_PARAMETERS table is maintained by the base (non-hook) API package, while FF_FUNCTION_PARAMETERS_BK1 serves purely as an intercept point. Should a customer implement logic in these procedures, any table access would be introduced by that customisation and would typically target FF_FUNCTION_PARAMETERS or associated audit and staging tables.

Usage Notes

This package is not invoked directly by end users. It is called by the Oracle HRMS API Hook Pre-processor framework whenever the corresponding FastFormula function-parameter creation API executes, allowing site-specific logic to be inserted at the entry and exit points of the operation. The metadata indicates the package is referenced by one other package, confirming its role as a dependent hook rather than a standalone entry point.

Typical invocation paths include Oracle Forms (particularly the FastFormula and function-definition maintenance forms), concurrent programs, and custom PL/SQL that calls the FF function-parameter APIs. Because the shipped procedures are empty, the practical value to an implementation lies in the opportunity to add validation, defaulting, or propagation logic. Changes to the body should be treated as a customisation and reapplied following patches or upgrades, since the file is regenerated by Oracle's pre-processor and the original header explicitly records upstream generation.