Search Results create_interaction

Overview

CSF_IH_PUB is a public PL/SQL package in the APPS schema that serves as a thin wrapper around the Interaction History (IH) foundation APIs used across Oracle E-Business Suite. Its principal business purpose is to record an interaction — a discrete contact or touch point between a resource (agent or user) and a party, such as a customer or prospect — together with the associated activity details. In release 12.1.1 and 12.2.2 the package is maintained under the ETRM 12.2.2 object registry as an APPS-owned PUB package with a single documented program unit, CREATE_INTERACTION.

The header comment in the source ($Header: csfihpsb.pls 120.0 2005/05/24 ... appldev noship $) indicates the body is a long-standing component of the Customer Relationship Management foundation layer. Rather than implementing business logic itself, the package normalizes its inputs into the record and table types defined by JTF_IH_PUB and delegates the actual persistence work to that older PL/SQL routine. This delegation pattern preserves upward compatibility: calling applications can continue to use the CSF signature while the underlying JTF interaction engine evolves independently.

Key Procedures and Functions

• CREATE_INTERACTION — The only documented procedure in the package. It accepts an API version, standard return-status and message output parameters, an interaction identifier, handler and resource identifiers, a party identifier, action item and outcome information, a reference form name, and task and document references. Internally the procedure populates two structures: a single interaction record of type jtf_IH_PUB.interaction_rec_type and an activity table of type jtf_IH_PUB.activity_tbl_type with one element. It then issues a delegated call to jtf_ih_pub.create_interaction, passing the API version, the resource identifier as the user ID, the interaction record, and the activity table. Because the procedure is a pass-through, the effective behavior, validation, and error semantics observed by callers are those of JTF_IH_PUB.CREATE_INTERACTION.

No other procedures or functions are documented for this package in the ETRM metadata, and the package description records zero dependent packages referencing it.

Tables Accessed

The ETRM metadata for CSF_IH_PUB does not enumerate any directly referenced tables or APPS synonyms. This is consistent with its design as a delegating wrapper: all INSERT and UPDATE operations against the interaction history tables are performed inside JTF_IH_PUB.CREATE_INTERACTION, which writes to the JTF interaction and interaction-activity base tables using the interaction identifier, handler, resource, party, outcome, action item, task, and document attributes supplied by the caller. Because CSF_IH_PUB holds no cursors or DML of its own, it neither commits nor rolls back; transaction control remains the responsibility of the calling application and the delegated JTF routine.

Usage Notes

CSF_IH_PUB.CREATE_INTERACTION is typically invoked from CRM forms, Oracle TeleSales and Interaction Center flows, and custom PL/SQL that needs to log an interaction using the CSF entry point. Callers must supply a valid API version, initialize the standard output parameters, and ensure that the resource, party, and handler identifiers correspond to existing entities; the reference form and task or document identifiers are optional contextual fields. Applications that previously called JTF_IH_PUB directly may migrate to this wrapper for interface stability, but they must continue to check l_return_status and consume l_msg_count and l_msg_data for error handling. Because the wrapper offers no validation beyond delegation, release-specific behavior and any known issues in 12.1.1 or 12.2.2 should be assessed against the underlying JTF_IH_PUB API.