Sunday, July 18, 2010

Oracle Process Manufacturing API's

Below is the collection of most widely used API's in Oracle Process Manufacturing. We will post the wrapper programs for these api's soon.


OPM Area
API Name
DESCRIPTION
Formula
GMD_FORMULA_PUB
Public Formula Header package that the user defined function calls. The business API can be used for creating, modifying, or deleting a formula header. While creating a Formula header the API also creates Detail and Effectivity associated with this header.
Formula
GMD_FORMULA_DETAIL_PUB
Public Formula Detail package that the wrapper or user defined function calls.
The business API can be used for creating, modifying, or deleting a formula detail.
Formula
GMD_FORMULA_EFFECTIVITY_PUB
Public Formula Effectivity package that the wrapper or user defined function calls. The business API can be used for Creating, Modifying, or deleting a formula effectivity.
Recipe
GMD_RECIPE_HEADER
Public Recipe API that the user
defined function calls.
Recipe
GMD_RECIPE_DETAIL
Public Recipe API that the user
defined function calls.
Recipe
GMD_RECIPE_FETCH_PUB
Public Recipe API that Recipe
Header and Recipe Detail APIs
call.
Recipe
GMD_FETCH_VALIDITY_
RULES
Public Recipe API that Recipe
Header and Recipe Detail APIs
call.
Routings
GMD_ROUTINGS_PUB
Public Routing package that the
user defined function calls. The
business API is used for creating, modifying, or deleting a routing header.
Routing Steps
GMD_ROUTING_STEPS_PUB
Public Routing package that the
user defined function calls. The
business API is used for creating
or modifying routing steps
associated to the routing header
Routing Dependency
GMD_STEP_DEPENDENCY_
PUB
Public Routing package that the
user defined function calls. The
business API is used for creating
or modifying routing step
dependency information
associated to the routing steps.
Operations
GMD_OPERATIONS_PUB
Public Operation package that
the user defined function calls.
The business API is used for
creating, modifying, or deleting
a operation header. When
creating an operation header,
the API also creates activities
and resources associated with
this header.
Operation Activities
GMD_OPERATION_
ACTIVITIES_PUB
Public Operation Activities
package that the wrapper or
user defined function calls. The
business API is used for creating, modifying, or deleting operation activities. When creating an operation activity, the API also creates operation resources associated with this operation activity.
Operation Resources
GMD_OPERATION_
RESOURCES_PUB
Public Operation Resources
package that the wrapper or
user defined function calls. The
business API is used for
creating, modifying, or deleting
operation resources.
Activities
GMD_ACTIVITY_PUB
Public Activity package that the
user defined function calls. The
business API is used for creating, modifying, or deleting activity information.
Status
GMD_STATUS_PUB
Public API that modifies the
status for routings, recipes,operations, and validity ruleS
Resources
GMP_RESOURCES_PUB
Public level package used for creating, updating, and deleting generic resources in OPM.
Resources
GMP_RESOURCE_DTL_PUB
Public level package used for creating,updating, and deleting plant resources in OPM.
Resources
GMP_RSRC_AVL_PKG
Public level package used for resource
availability calculations.
General
GMP_CALENDAR_API
Public level package used for fetching data from the OPM Shop Calendar. These APIs are used by OPM Process Execution

0 Responses to “Oracle Process Manufacturing API's”

Post a Comment

Disclaimer

The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.