Results for “form_id”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
HR_FORM_TEMPLATE_INFO is an OTHER-classified PL/SQL package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the Oracle HRMS (Human Resources Management System) family of template and form-personalization utilities, and it serves as a metadata resolution layer for the HR Forms and Template architecture. In EBS, HR forms such as the Employee Assignment, Personal Information, and related self-service and professional forms are not hard-coded; instead they are described declaratively through a repository of templates, canvas structures, item definitions, tab pages, windows, and stacks. HR_FORM_TEMPLATE_INFO exposes the information required to resolve a form definition to its underlying application, form identifier, and formatting rules so that downstream template-processing packages can generate, validate, or render the form correctly. The package is valid in the current ETRM snapshot and is documented with seven procedures/functions, five of which are explicitly catalogued: FORM_TEMPLATE, APPLICATION_ID, FORM_ID, DATE_FORMAT_MASK, and DATETIME_FORMAT_MASK.
Key Procedures and Functions
- FORM_TEMPLATE — The primary entry point of the package. It resolves and returns template definition information for a given HR form, acting as the accessor through which callers obtain the form template record used by the surrounding HRMS template engine.
- APPLICATION_ID — Returns the application identifier associated with a form or template context, allowing callers to key into FND_APPLICATION and related Application Object Library metadata.
- FORM_ID — Returns the FND_FORM identifier for a form, enabling linkage between HR template metadata and the standard EBS form registry.
- DATE_FORMAT_MASK — Supplies the date formatting mask used when rendering or interpreting date fields within the template, honoring the form's or user's configured display conventions.
- DATETIME_FORMAT_MASK — Provides the corresponding date-and-time formatting mask for template fields that carry combined date/time values.
The remaining two documented units are internal helpers that support the resolution logic above; their documented names are not enumerated in the ETRM excerpt. Parameter lists are deliberately not reproduced here, as the metadata does not publish them and they should be confirmed against the deployed package specification.
Tables Accessed
The package reads from five documented tables, all resolved through APPS synonyms:
- FND_APPLICATION — Provides application registration data used by APPLICATION_ID to validate and resolve the owning application of a form.
- FND_FORM — The Application Object Library form registry, used by FORM_ID to map a form name to its internal form identifier.
- FND_FORM_FUNCTIONS — Supplies form function metadata, connecting form definitions to the function-based navigation and security model.
- HR_FORM_PROPERTIES — Stores HR-specific form properties that drive template behavior and rendering characteristics.
- HR_FORM_TEMPLATES_B — The base table of HR form template definitions, the principal source of the metadata returned by FORM_TEMPLATE.
Usage Notes
HR_FORM_TEMPLATE_INFO is an internal rather than a public API. It is referenced by five other packages — HR_FORM_TEMPLATE_INFO itself (recursive internal calls), HR_TEMPLATE_CANVAS_INFO, HR_TEMPLATE_ITEM_INFO, HR_TEMPLATE_STACK_CANVAS_INFO, HR_TEMPLATE_TAB_PAGE_INFO, and HR_TEMPLATE_WINDOW_INFO — all of which form the HRMS template-inspection layer. It is therefore indirectly exercised whenever HR forms are rendered, personalized, or validated, and it should not normally be invoked directly by customers. Custom code requiring template metadata should prefer the documented HRMS template APIs. Because it depends on STANDARD and SYS facilities, it must execute in a standard APPS session. Oracle supports it only as part of the delivered HRMS template infrastructure; direct calls are unsupported and subject to change between patch levels.
-
Sign-On Audit information about when and who used which forms in an application
-
Table to store user defined search criteria for Authoring filter
-
Application forms registered with Oracle Application Object Library
-
Definition of windows for use in configurable forms
-
Definition of windows for use in configurable forms
-
APPS.JAI_AR_ST_MATCH_DTL_GRPISS_V·↳ JAI_CMN_STFORM_HDRS_ALL·↳ JAI_CMN_ST_FORMS·↳ JAI_CMN_ST_FORM_DTLS·Explore JA module →
-
Table: PON_FORMS_INSTANCES 12.2.2
Stores the relationship between the form and the negotiation/event.
-
Translations for FND_FORM
-
View: HR_FORM_DATA_GROUPS_VL 12.2.2
Translated view from HR_FORM_DATA_GROUPS_B and HR_FORM_DATA_GROUPS_TL
APPS.HR_FORM_DATA_GROUPS_VL·↳ HR_FORM_DATA_GROUPS_B·↳ HR_FORM_DATA_GROUPS_TL·Explore PER module →
-
Stores information pertaining to the ST Forms
-
Stores the information of the 57F4 Line Details.
-
View: FND_SIGNON_AUDIT_VIEW 12.2.2
APPS.FND_SIGNON_AUDIT_VIEW·↳ FND_FORM_TL·↳ FND_LOGINS·↳ FND_LOGIN_RESPONSIBILITIES·Explore FND module →
-
Stores the information of the 57F4 Line Details.
-
Table: PO_PRINT_FORM_FORMATS 12.2.2
Federal Printing Formats
-
Stores the relationships between a form, section or abstract and its components.
-
Definition of items available for configurable forms
-
View: FND_FORM_SESSIONS_V 12.1.1
APPS.FND_FORM_SESSIONS_V·↳ FND_FORM_TL·↳ FND_LOGINS·↳ FND_LOGIN_RESPONSIBILITIES·Explore FND module →
-
Table: PON_FORMS_INSTANCES 12.1.1
Stores the relationship between the form and the negotiation/event.
-
Stored the "compiled form".
-
Application forms registered with Oracle Application Object Library
-
Form data group definition for configurable forms
-
Stores information pertaining to the Sales Tax Matched Details.
-
Table to store user defined search criteria for Authoring filter
-
Table: PON_FORMS_SECTIONS_TL 12.1.1
Stores the language specific information for a form, section or abstract.
-
Form data group definition for configurable forms
-
APPS.JAI_AP_ST_MATCH_DTL_GRPRCPT_V·↳ JAI_CMN_STFORM_HDRS_ALL·↳ JAI_CMN_ST_FORMS·↳ JAI_CMN_ST_FORM_DTLS·Explore JA module →
-
View: HR_FORM_ITEMS_VL 12.2.2
Translated view from HR_FORM_ITEMS_B and HR_FORM_ITEMS_TL
APPS.HR_FORM_ITEMS_VL·↳ HR_FORM_ITEMS_B·↳ HR_FORM_ITEMS_TL·Explore PER module →
-
View: HR_FORM_WINDOWS_VL 12.1.1
Translated view of HR_FORM_WINDOWS_B and HR_FORM_WINDOWS_TL
APPS.HR_FORM_WINDOWS_VL·↳ HR_FORM_WINDOWS_B·↳ HR_FORM_WINDOWS_TL·Explore PER module →
-
Sign-On Audit information about when and who used which forms in an application
-
View: FND_FORM_VL 12.1.1
View of FND_FORM and FND_FORM_TL
APPS.FND_FORM_VL·↳ FND_FORM·↳ FND_FORM_TL·Explore FND module →
-
View: FND_FORM_VL 12.2.2
View of FND_FORM and FND_FORM_TL
APPS.FND_FORM_VL·↳ FND_FORM·↳ FND_FORM_TL·Explore FND module →
-
Stores information pertaining to the Sales Tax Matched Details.
-
PACKAGE: APPS.FND_GLOBAL 12.1.1
-
PACKAGE: APPS.FND_GLOBAL 12.2.2
-
This table stores the AR3 forms and the details. This is used in both AR and OM.
-
Stores information pertaining to the ST Forms
-
Table: PON_FORMS_SECTIONS_TL 12.2.2
Stores the language specific information for a form, section or abstract.
-
View: HR_FORM_WINDOWS_VL 12.2.2
Translated view of HR_FORM_WINDOWS_B and HR_FORM_WINDOWS_TL
APPS.HR_FORM_WINDOWS_VL·↳ HR_FORM_WINDOWS_B·↳ HR_FORM_WINDOWS_TL·Explore PER module →
-
APPS.JAI_AP_ST_MATCH_DTL_GRPRCPT_V·↳ JAI_CMN_STFORM_HDRS_ALL·↳ JAI_CMN_ST_FORMS·↳ JAI_CMN_ST_FORM_DTLS·Explore JA module →
-
APPS.JAI_AR_ST_MATCH_DTL_GRPISS_V·↳ JAI_CMN_STFORM_HDRS_ALL·↳ JAI_CMN_ST_FORMS·↳ JAI_CMN_ST_FORM_DTLS·Explore JA module →
-
Table: PON_FBO_POSTS 12.2.2
This will store history of notice posted to FedBizOpps
-
Stores the relationships between a form, section or abstract and its components.
-
Responsibilities information
-
Translations for FND_FORM