Search Results gmd_ebi_recipe_pub




Overview
Explore in AI Chat

Overview

GMD_EBI_RECIPE_PUB is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite, documented in ETRM for release 12.2.2 and applicable to the 12.1.1 and 12.2.2 code lines. The package belongs to the Oracle Process Manufacturing (OPM) product family, specifically the formula and recipe management area of the Process Manufacturing suite. Its stated purpose is to expose an interface that synchronizes formula header, formula detail, and routing information. The package defines and implements the procedures required to synchronize, meaning to create, update, and delete, these three logical groupings of process manufacturing master data.

The source header identifies the package as GMDEIPRS.pls, with a header version of 120.1.12020000.2 dated 2012/07/26, indicating a maintenance level aligned with the 12.2.2 codeline. The declared interface uses AUTHID CURRENT_USER, meaning the package executes with the privileges of the calling user rather than the definer, which is a relevant behavioral characteristic for invokers operating under APPS in a shared EBS environment.

Key Procedures and Functions

ETRM documents a single public procedure, SYNC_RECIPE. It carries the API name sync_recipe and a current version of 1.0. The procedure synchronizes formula header, formula details, and routing information arising from an attachment. The documented design intent is that formula and routing data created as attachments are processed through this procedure, which then delegates the physical insert, update, and delete operations to the underlying formula header and detail packages.

The documented parameter set comprises an API version, a commit flag, an input recipe table, an output recipe table, and the standard output return status, message count, and message data parameters. The input structure is gmd_ebi_recipe_tbl and the output structure is gmd_ebi_recipe_output_tbl; the message data parameter is bounded at 2000 characters. These parameters define the standard EBS API contract: callers supply the version and commit behavior, pass in the recipe payload, and inspect the returned status and message buffer to determine success or failure.

Tables Accessed

The package accesses process manufacturing and common EBS tables through APPS synonyms. Formula master and detail data reside in FM_FORM_MST_B and FM_MATL_DTL. Routing structures are represented by FM_ROUT_DEP, FM_ROUT_DTL, and GMD_ROUTINGS, consistent with the routing synchronization scope. Inventory and item context is drawn from MTL_PARAMETERS, MTL_SYSTEM_ITEMS_B, and the key flexfield view MTL_SYSTEM_ITEMS_KFV.

Attachment and document handling relies on FND_ATTACHED_DOCUMENTS, FND_ATTACHED_DOCUMENTS_S, FND_DOCUMENTS, FND_DOCUMENTS_LONG_TEXT, and FND_DOCUMENT_CATEGORIES_TL. User resolution uses FND_USER, and DUAL supports scalar evaluation. No other package in the documented set references GMD_EBI_RECIPE_PUB, so it functions as an entry point rather than an internally reused library.

Usage Notes

The package is typically invoked when recipe data reaches EBS as an attachment and must be materialized or reconciled into OPM formula and routing tables. Callers should assume standard EBS API conventions: initialize the input table, set the API version, choose commit behavior deliberately, and validate x_return_status and the message count before proceeding. Because the reason for the user query, a Cook Island Ika Mata recipe, is a culinary recipe and unrelated to this object, no domain mapping exists between the two; GMD_EBI_RECIPE_PUB pertains exclusively to process manufacturing formulas and routings, not food preparation content.