Search Results jtf_fm_ocm_rend_req_w
Overview
The APPS.JTF_FM_OCM_REND_REQ_W package body supports the Oracle E-Business Suite fulfillment management infrastructure, specifically the processing of rendition requests originating from Order Capture and Order Management flows. In Oracle EBS 12.1.1 and 12.2.2, the JTF_FM_% namespace belongs to the CRM Foundation / TeleSales fulfillment module that brokers fulfillment requests between order capture applications and downstream fulfillment systems. The "_W" suffix conventionally identifies a wrapper package that adapts the core rendition request API (JTF_FM_OCM_REND_REQ) to a published, invocable interface accessible to external callers, concurrent programs, or the Order Management integration layer.
The package is classified under ETRM as an "OTHER" API type and is reported as VALID in the APPS schema. Its core business responsibility is the creation and submission of fulfillment rendition requests, which represent the instructions that a rendition/fulfillment engine requires in order to produce a deliverable or provisioning action for an order line.
Key Procedures and Functions
The ETRM metadata documents a single public program unit within this package body:
- CREATE_FULFILLMENT_RENDITION — The principal entry point of the wrapper. It creates a fulfillment rendition record/request for a given fulfillment context. The procedure is the externally visible operation that client code invokes; internally it delegates to the core rendition request logic and to the fulfillment publication layer. No parameter list is documented in the ETRM metadata, so its signature is not reproduced here.
The wrapper's dependency list indicates that the actual work is distributed across the underlying JTF_FM_OCM_REND_REQ package, the generic rendition and fulfillment publication packages (JTF_FULFILLMENT_PUB, JTF_FULFILLMENT_PUB_W), and the request grouping layer (JTF_FM_REQUEST_GRP, JTF_FM_REQUEST_GRP_W). The wrapper therefore serves primarily as an interface and orchestration layer rather than as the locus of business logic.
Tables Accessed
The package operates primarily through PL/SQL APIs rather than direct table DML. The referenced dependency ASO_ORDER_INT is the Order Capture open interface table, consistent with the OCM (Order Capture Management) designation in the package name. This suggests the rendition creation path may consume or reconcile order interface data before generating a fulfillment rendition. The package also depends on the collection types JTF_NUMBER_TABLE, JTF_VARCHAR2_TABLE_100, and JTF_VARCHAR2_TABLE_1000, which are used to pass multi-row identifiers and attribute strings into the fulfillment APIs. No direct base-table references are documented in the ETRM metadata; persistence is handled by the called sub-packages.
Usage Notes
This package is typically invoked programmatically rather than through a user-facing form. Appropriate invocation scenarios include:
- Custom PL/SQL that requires programmatic creation of a fulfillment rendition outside the standard Order Management UI flow.
- Integration code that bridges Order Capture interface records (ASO_ORDER_INT) into the fulfillment engine.
- Concurrent or batch processing that must generate renditions in bulk, using the JTF_*_TABLE collection types as array-style inputs.
Because the ETRM record notes that JTF_FM_OCM_REND_REQ_W is not referenced by any other database object and defines no custom recursive references beyond the standard API stack, it should be regarded as a leaf-level entry point. Callers should invoke CREATE_FULFILLMENT_RENDITION through the supported API rather than issuing direct DML against fulfillment tables, and should rely on FND_API error handling (a declared dependency) to interpret returned status codes. As with all APPS-schema fulfillment APIs, changes to the underlying JTF_FULFILLMENT_PUB stack across releases should be reviewed before upgrading customizations that call this wrapper.
-
PACKAGE BODY: APPS.JTF_FM_OCM_REND_REQ_W
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:JTF_FM_OCM_REND_REQ_W, status:VALID,
-
PACKAGE: APPS.JTF_FM_OCM_REND_REQ_W
12.2.2
owner:APPS, object_type:PACKAGE, object_name:JTF_FM_OCM_REND_REQ_W, status:VALID,
-
PACKAGE: APPS.JTF_FM_OCM_REND_REQ_W
12.1.1
owner:APPS, object_type:PACKAGE, object_name:JTF_FM_OCM_REND_REQ_W, status:VALID,
-
PACKAGE BODY: APPS.JTF_FM_OCM_REND_REQ_W
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JTF_FM_OCM_REND_REQ_W, status:VALID,
-
PACKAGE: APPS.JTF_FM_OCM_REND_REQ
12.1.1
owner:APPS, object_type:PACKAGE, object_name:JTF_FM_OCM_REND_REQ, status:VALID,
-
PACKAGE: APPS.JTF_FM_OCM_REND_REQ_W
12.1.1
-
PACKAGE: APPS.JTF_FM_OCM_REND_REQ_W
12.2.2
-
PACKAGE: APPS.JTF_FULFILLMENT_PUB_W
12.2.2
owner:APPS, object_type:PACKAGE, object_name:JTF_FULFILLMENT_PUB_W, status:VALID,
-
PACKAGE: APPS.JTF_FM_REQUEST_GRP_W
12.1.1
owner:APPS, object_type:PACKAGE, object_name:JTF_FM_REQUEST_GRP_W, status:VALID,
-
PACKAGE: APPS.JTF_FM_OCM_REND_REQ
12.2.2
owner:APPS, object_type:PACKAGE, object_name:JTF_FM_OCM_REND_REQ, status:VALID,
-
PACKAGE: APPS.JTF_FULFILLMENT_PUB_W
12.1.1
owner:APPS, object_type:PACKAGE, object_name:JTF_FULFILLMENT_PUB_W, status:VALID,
-
PACKAGE: APPS.JTF_FM_REQUEST_GRP_W
12.2.2
owner:APPS, object_type:PACKAGE, object_name:JTF_FM_REQUEST_GRP_W, status:VALID,
-
PACKAGE: APPS.JTF_FULFILLMENT_PUB
12.2.2
owner:APPS, object_type:PACKAGE, object_name:JTF_FULFILLMENT_PUB, status:VALID,
-
PACKAGE: APPS.JTF_FULFILLMENT_PUB
12.1.1
owner:APPS, object_type:PACKAGE, object_name:JTF_FULFILLMENT_PUB, status:VALID,
-
TYPE: APPS.JTF_VARCHAR2_TABLE_1000
12.2.2
owner:APPS, object_type:TYPE, object_name:JTF_VARCHAR2_TABLE_1000, status:VALID,
-
PACKAGE: APPS.JTF_FM_OCM_REQUEST_GRP
12.1.1
owner:APPS, object_type:PACKAGE, object_name:JTF_FM_OCM_REQUEST_GRP, status:VALID,
-
PACKAGE: APPS.JTF_FM_OCM_REQUEST_GRP
12.2.2
owner:APPS, object_type:PACKAGE, object_name:JTF_FM_OCM_REQUEST_GRP, status:VALID,
-
TYPE: APPS.JTF_VARCHAR2_TABLE_1000
12.1.1
owner:APPS, object_type:TYPE, object_name:JTF_VARCHAR2_TABLE_1000, status:VALID,
-
PACKAGE: APPS.ASO_ORDER_INT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:ASO_ORDER_INT, status:VALID,
-
PACKAGE: APPS.ASO_ORDER_INT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:ASO_ORDER_INT, status:VALID,
-
PACKAGE BODY: APPS.JTF_FM_OCM_REND_REQ_W
12.1.1
-
PACKAGE BODY: APPS.JTF_FM_OCM_REND_REQ_W
12.2.2
-
12.1.1 DBA Data
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
-
APPS.JTF_FM_OCM_REND_REQ_W dependencies on JTF_FM_OCM_REND_REQ_W
12.2.2
-
APPS.JTF_FM_OCM_REND_REQ_W dependencies on JTF_FM_OCM_REND_REQ_W
12.1.1
-
APPS.JTF_FM_OCM_REND_REQ_W dependencies on JTF_FM_OCM_REND_REQ
12.1.1
-
APPS.JTF_FM_OCM_REND_REQ_W dependencies on JTF_FM_OCM_REND_REQ
12.2.2
-
APPS.JTF_FM_OCM_REND_REQ_W dependencies on FND_API
12.1.1
-
APPS.JTF_FM_OCM_REND_REQ_W dependencies on FND_API
12.2.2
-
TYPE: APPS.JTF_VARCHAR2_TABLE_100
12.1.1
owner:APPS, object_type:TYPE, object_name:JTF_VARCHAR2_TABLE_100, status:VALID,
-
TYPE: APPS.JTF_VARCHAR2_TABLE_100
12.2.2
owner:APPS, object_type:TYPE, object_name:JTF_VARCHAR2_TABLE_100, status:VALID,
-
TYPE: APPS.JTF_NUMBER_TABLE
12.1.1
owner:APPS, object_type:TYPE, object_name:JTF_NUMBER_TABLE, status:VALID,
-
TYPE: APPS.JTF_NUMBER_TABLE
12.2.2
owner:APPS, object_type:TYPE, object_name:JTF_NUMBER_TABLE, status:VALID,
-
PACKAGE: APPS.FND_API
12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_API, status:VALID,
-
PACKAGE: APPS.FND_API
12.1.1
owner:APPS, object_type:PACKAGE, object_name:FND_API, status:VALID,
-
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,