Search Results flm_flmrflin_xmlp_pkg

Overview

FLM_FLMRFLIN_XMLP_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema. It is a report logic package (the _XMLP_PKG suffix denotes a BI Publisher/XML Publisher concurrent program implementation) associated with the Flow Manufacturing (FLM) module. Its "RFLIN" naming indicates a report related to flow line / repetitive line information – most probably a Flow Manufacturing line or repetitive schedule report. The package is documented as VALID in the ETRM repository for release 12.2.2 and is classified as API classification OTHER, meaning it is not a public, callable business API but rather an internal implementation unit supporting a specific concurrent program. Its sole documented external reference is to the SYS.STANDARD package, and it is not referenced by any other package, confirming it is a leaf/terminal unit invoked directly by the report engine.

Key Procedures and Functions

The package exposes 132 documented procedures and functions, most of which are generated "formula" columns and report lifecycle handlers typical of Oracle Reports/XML Publisher conversion:

BEFOREREPORT, AFTERREPORT, AFTERPFORM – report lifecycle triggers used to initialise the report session, clean up after completion, and execute logic after the parameter form is processed (e.g. defaulting or derived parameter values).
WEEKLY_PLANFORMULA, WEEKLY_ACTUALFORMULA, WEEKLY_VARFORMULA, WEEKLY_LINFORMULA – formula functions that compute weekly plan, actual, variance, and line-level values for display in the report output columns.
DAY1_VAR_GROUPFORMULA through DAY7_VAR_GROUPFORMULA – per-day group formula functions that calculate daily variance aggregations for each day of the reporting week.
WEEKLY_PLAN_GROUPFORMULA, WEEKLY_ACTUAL_GROUPFORMULA, WEEKLY_VAR_GROUPFORMULA, WEEKLY_LIN_GROUPFORMULA – weekly summary aggregation formula functions for the corresponding measures.
DAY1_LIN_GROUPFORMULA, DAY2_LIN_GROUPFORMULA (and the remainder of the DAY1–DAY7 sequence) – per-day line-level group formula functions.

Collectively these functions encode the report's derived/calculated column logic; they are not intended for direct external invocation. Parameter lists are deliberately not reproduced here, as the ETRM metadata does not document them.

Tables Accessed

The package references the following APPS synonyms:

MRP_FORM_QUERY and MRP_FORM_QUERY_S – these are the standard EBS "form query" cache tables used to persist the query text and parameters generated by an Oracle Forms or concurrent program parameter window. The report logic reads the query definition/parameters from this cache, enabling dynamic, user-defined query criteria to drive the report.
DUAL – the standard single-row Oracle utility table, typically referenced for expressions that require a SELECT statement, such as evaluating PL/SQL functions or computing constants.

No business data tables such as flow line or schedule tables appear in the documented dependency list, implying that the heavy data retrieval is handled by the underlying report query rather than by SQL inside this package.

Usage Notes

This package is invoked implicitly by the XML Publisher/BI Publisher runtime when the associated Flow Manufacturing concurrent program is submitted. Developers should not call its procedures directly. Because the package is VALID and referenced by no other package, customisations should be limited to the underlying report definition or data model rather than modifying FLM_FLMRFLIN_XMLP_PKG. In both 12.1.1 and 12.2.2, its behaviour is consistent with the standard Flow Manufacturing reporting framework.

PACKAGE: APPS.FLM_FLMRFLIN_XMLP_PKG 12.2.2
owner:APPS, object_type:PACKAGE, object_name:FLM_FLMRFLIN_XMLP_PKG, status:VALID,
PACKAGE BODY: APPS.FLM_FLMRFLIN_XMLP_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:FLM_FLMRFLIN_XMLP_PKG, status:VALID,
PACKAGE BODY: APPS.FLM_FLMRFLIN_XMLP_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:FLM_FLMRFLIN_XMLP_PKG, status:VALID,
PACKAGE: APPS.FLM_FLMRFLIN_XMLP_PKG 12.1.1
owner:APPS, object_type:PACKAGE, object_name:FLM_FLMRFLIN_XMLP_PKG, status:VALID,
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
12.1.1 DBA Data 12.1.1
PACKAGE: APPS.FLM_LINEARITY_REPORT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:FLM_LINEARITY_REPORT, status:VALID,
PACKAGE: APPS.FLM_LINEARITY_REPORT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:FLM_LINEARITY_REPORT, status:VALID,
12.2.2 DBA Data 12.2.2
SYNONYM: APPS.MRP_FORM_QUERY_S 12.2.2
owner:APPS, object_type:SYNONYM, object_name:MRP_FORM_QUERY_S, status:VALID,
SYNONYM: APPS.MRP_FORM_QUERY_S 12.1.1
owner:APPS, object_type:SYNONYM, object_name:MRP_FORM_QUERY_S, status:VALID,
SYNONYM: APPS.MRP_FORM_QUERY 12.2.2
owner:APPS, object_type:SYNONYM, object_name:MRP_FORM_QUERY, status:VALID,
SYNONYM: APPS.MRP_FORM_QUERY 12.1.1
owner:APPS, object_type:SYNONYM, object_name:MRP_FORM_QUERY, status:VALID,
PACKAGE: APPS.FLM_FLMRFLIN_XMLP_PKG 12.2.2
PACKAGE: APPS.FLM_FLMRFLIN_XMLP_PKG 12.1.1
APPS.FLM_FLMRFLIN_XMLP_PKG dependencies on FLM_FLMRFLIN_XMLP_PKG 12.1.1
APPS.FLM_FLMRFLIN_XMLP_PKG dependencies on FLM_FLMRFLIN_XMLP_PKG 12.2.2
VIEW: APPS.ORG_ORGANIZATION_DEFINITIONS 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:INV.ORG_ORGANIZATION_DEFINITIONS, object_name:ORG_ORGANIZATION_DEFINITIONS, status:VALID,
VIEW: APPS.ORG_ORGANIZATION_DEFINITIONS 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:INV.ORG_ORGANIZATION_DEFINITIONS, object_name:ORG_ORGANIZATION_DEFINITIONS, status:VALID,
PACKAGE BODY: APPS.FLM_FLMRFLIN_XMLP_PKG 12.2.2
PACKAGE BODY: APPS.FLM_FLMRFLIN_XMLP_PKG 12.1.1
SYNONYM: PUBLIC.DUAL 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:DUAL, status:VALID,
SYNONYM: PUBLIC.DUAL 12.1.1
owner:PUBLIC, object_type:SYNONYM, object_name:DUAL, status:VALID,
eTRM - INV Tables and Views 12.1.1
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
12.1.1 DBA Data 12.1.1
PACKAGE: SYS.STANDARD 12.1.1
owner:SYS, object_type:PACKAGE, object_name:STANDARD, status:VALID,
eTRM - INV Tables and Views 12.1.1