Search Results create_from_lookup

Overview

OTAFRUDT is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It is classified as a standalone utility (API classification: OTHER) rather than a formal public API. Its business function is to seed and maintain the user-defined table framework used by Oracle HRMS and Oracle Payroll for legislative localisations — most notably the French localisation, as indicated by the package name and the seed-data comment on the CREATE_TABLE procedure. The package creates the definition records that describe user-defined tables, their columns, and their rows, and it inserts the corresponding row instance data so that payroll and HRMS legislative reports can capture customer-specific information without schema changes.

Key Procedures and Functions

• INSERT_TABLE_DATA — Inserts a single data row into the user-defined table framework. It delegates to PAY_USER_TABLES_PKG.INSERT_ROW, passing business group, legislation, application, range/match, key-unit, table-name, and row-title attributes, and returns the generated ROWID and user table identifier.
• CREATE_TABLE — Creates seed definition data for a user-defined table, checking via a cursor that the table has not already been created for the given business group before inserting.
• CREATE_COLUMN — Creates the column definition records that belong to a user-defined table, establishing the structure into which later row data is written.
• CREATE_ROW — Creates row definition records for a user-defined table (the object the user searched for). It establishes the row metadata in the PAY_USER_ROWS tables prior to any instance data being written by INSERT_TABLE_DATA.
• CREATE_FROM_LOOKUP — Seeds user-defined table structures from values held in an Oracle lookup, allowing predefined legislative content to be generated rather than entered manually.
• LOAD_ALTERNATE_LOOKUP — Loads an alternate lookup as the source for user-defined table creation, supporting localisation variants.

Tables Accessed

The package operates exclusively on the PAY_USER_* family of tables through APPS synonyms. PAY_USER_TABLES holds the top-level definition of each user-defined table and is the primary target of INSERT_TABLE_DATA and CREATE_TABLE. PAY_USER_COLUMNS and PAY_USER_COLUMN_INSTANCES_F hold column definitions and their effective-dated instances, written by CREATE_COLUMN. PAY_USER_ROWS_F and PAY_USER_ROWS_S hold row definitions and row instance data respectively, written by CREATE_ROW and INSERT_TABLE_DATA. DUAL is referenced for simple single-row queries used in validation and default value derivation. Together these tables form the repository that HRMS and Payroll forms, reports, and fast formulas read at runtime.

Usage Notes

OTAFRUDT is not referenced by any other documented package, so it is intended to be invoked directly rather than through a layered API. Typical invocation points are Oracle Forms used by localisation setup, concurrent programs that seed legislative content during implementation, and one-off installation or upgrade scripts. Because CREATE_TABLE guards against duplicate creation per business group, the package is generally safe to re-run during setup. Custom code that needs to add a user-defined table should follow the same sequence: CREATE_TABLE, then CREATE_COLUMN for each column, then CREATE_ROW for each row, and finally INSERT_TABLE_DATA to populate the instance values. The embedded hr_utility.trace calls confirm the package is instrumented for diagnostic debugging and is expected to run with HR tracing enabled when troubleshooting localisation setup issues.