Search Results p_filename

Overview

APPS.HR_TIPS_DML is a low-level data manipulation package body within the Oracle E-Business Suite Human Resources (Oracle HRMS) module. Its business function is to populate and maintain the HR_TIPS table, which stores the context-sensitive "Tips" text displayed to end users in Oracle Forms-based HRMS windows. Each tip is keyed by a combination of form filename, screen (block) name, field name, language code, and optionally a business group, allowing the application to present a field-level help string appropriate to the current form context and session language. By centralizing insert, update, and existence-checking logic in a single package body, HR_TIPS_DML ensures that tip records are created idempotently and that case-insensitive, whitespace-tolerant matching on screen, field, and language is applied consistently across all callers.

Key Procedures and Functions

• ADDTIP — Adds a single tip record to the HR_TIPS table. It accepts identifying attributes for the tip (filename, screen, field, language, and an optional business group) together with the tip text and a mode flag. The procedure first queries HR_TIPS to determine whether a matching tip already exists, using case-insensitive comparison of screen, field, and language and a null-safe comparison of business group. Behaviour then depends on the mode: for an "UPDATE" mode request, an existing row is updated with the new text and, if no row exists, a new row is inserted; for "NOUPDATE" and "DELETE" modes, no update occurs and a row is inserted only when no matching tip is present. New rows are assigned a primary key from the HR_TIPS_S sequence, the filename, screen, field, and language are normalized to upper case, and the enabled flag is set to 'Y'.
• CLEARTIPS — Removes tip records selectively based on a supplied filename (and additional selection criteria). This procedure supports maintenance and purge activities, allowing tips associated with a given form to be deleted without disturbing tips belonging to other forms.

Tables Accessed

• HR_TIPS — The primary table read and written by this package. It holds the tip text and its identifying context (filename, screen, field, language code, business group, and enabled flag). The package queries it to test for existing rows and performs INSERT and UPDATE operations against it.
• HR_TIPS_S — The sequence used to generate unique TIP_ID values for newly inserted rows.

Usage Notes

Because HR_TIPS_DML is a private data-access layer rather than a public business API, it is not typically invoked directly from forms or concurrent programs in delivered code. Instead it is called by higher-level tip maintenance routines — the seeding or upgrade logic that loads the tip text delivered with Oracle HRMS, and any custom loader that registers field-level tips for a customer-specific form. The p_filename parameter, of interest to the searching user, is the key that ties a tip to a particular Oracle Forms module; it is stored in upper case and is used by CLEARTIPS to scope deletions to a single form. When extending or scripting against this package, developers should note that matching on screen, field, and language is case-insensitive, that business group comparisons treat NULL as zero, and that ADDTIP's mode flag governs whether existing text is refreshed or left untouched. Direct DML against HR_TIPS outside this package risks bypassing these normalization and de-duplication rules.