Search Results create_update

Overview

CS_SRCONTACT_PKG is an Oracle EBS service module package owned by the APPS schema. It manages the association between service request contacts and the trading parties (customers) recorded against service requests. In Oracle Service, a service request may involve one or more contact points that identify which customer contacts are relevant to the incident. This package encapsulates the validation, creation, update, and audit of those contact records, which are maintained in the CS_HZ_SR_CONTACT_POINTS family of tables. It also supports the merging of service request contact data when party records are consolidated, and it writes audit rows capturing the state of contact points before and after changes. The package is classified as an OTHER API within the ETRM catalogue rather than as a fully documented public API, indicating that it is generally invoked internally by the Service Request infrastructure instead of being called directly by external integrations.

Key Procedures and Functions

• CREATE_UPDATE — Inserts or updates a service request contact point record, applying the business rules that determine whether a new association is required or an existing one should be modified.
• PROCESS — The main driver routine that orchestrates the validation and persistence of contact data, coordinating the individual helper routines within the package.
• VALIDATE_CONTACT — Verifies that the supplied contact information is valid before any database changes are committed, checking party and relationship data.
• PROCESS_G_MISS — Handles records flagged as missing or unmatched during processing, typically re-evaluating contacts that could not be resolved on a prior pass.
• POPULATE_CP_AUDIT_REC — Builds the audit record that captures the contact point values prior to modification, supporting the audit trail in CS_HZ_SR_CONTACT_PNTS_AUDIT.
• CREATE_CP_AUDIT — Writes the prepared audit row to the contact point audit table, preserving a historical view of contact point changes.

Tables Accessed

The package operates against the contact point tables CS_HZ_SR_CONTACT_POINTS and its intersection and sequence tables CS_HZ_SR_CONTACT_POINTS_S, together with the audit table CS_HZ_SR_CONTACT_PNTS_AUDIT. It reads CS_INCIDENTS_ALL_B to associate contact data with the owning service request. Party and person validation relies on HZ_PARTIES, HZ_RELATIONSHIPS, and PER_ALL_PEOPLE_F, while FND_PROFILE_OPTION_VALUES supplies profile-driven behaviour such as multi-org or security settings. DBMS_SQL, DUAL, and PLITBLM appear as utility references used for dynamic SQL and list handling. These tables are reached through APPS synonyms.

Usage Notes

CS_SRCONTACT_PKG is referenced by CS_SERVICEREQUEST_PVT, the primary service request API layer, and by CS_SR_PARTY_MERGE_PKG, which invokes it during party merge processing to reconcile contact points across merged customer records. This dependency pattern confirms that the package is a supporting component rather than an entry point: it is driven by service request creation, update, and merge flows, including the Service Request forms and any concurrent or custom code that calls CS_SERVICEREQUEST_PVT. Because the package is documented as OTHER and exposes no formally published parameters, customisations should invoke the higher-level CS_SERVICEREQUEST_PVT API rather than calling CS_SRCONTACT_PKG procedures directly, ensuring that validation and audit logic remain consistent across releases 12.1.1 and 12.2.2.