Search Results get_salesperson

Overview

CS_GET_CONTRACT_VALUES_PUB is a public PL/SQL API in the Oracle E-Business Suite Service (CS) module. It is owned by the APPS schema and classified as a PUB (public) API, meaning it is intended for external invocation by other application code, forms, and custom extensions. The package serves as a centralized access point for retrieving contract-related attributes and derived values without requiring callers to query the underlying Service Contracts tables directly. It encapsulates business logic that determines whether a contract or service line requires a purchase order, whether pre-payment is required, what billing and shipping addresses apply, which salesperson is associated, and whether an automatic renewal flag is set. The header comment identifies the source file as csctvals.pls, with an original revision dating to 1999, reflecting the package's long-standing role in the Service Contracts data model. Because it is declared AUTHID CURRENT_USER, execution privileges and any unqualified object resolution follow the calling user's schema context, a detail relevant to security and synonym configuration in 12.1.1 and 12.2.2 environments.

Key Procedures and Functions

The package exposes five documented procedures, each following the standard EBS API conventions with p_api_version, p_init_msg_list, and p_commit inputs and x_return_status, x_msg_count, and x_msg_data outputs (exact signatures vary by procedure and are not reproduced here).

• GET_PO_REQUIRED — Determines whether a purchase order is required for a given contract and service, returning the requirement indicator through an OUT parameter.
• GET_PRE_PAYMENT_REQUIRED — Establishes whether pre-payment is required for a specified contract and service line.
• GET_ADDRESS — Retrieves the applicable bill-to and ship-to address identifiers and address lines for a service, supporting downstream document generation and fulfillment.
• GET_SALESPERSON — Returns the salesperson associated with the contract or service context, addressing the common need to attribute service revenue to a sales representative. This procedure is the primary match for the "get_salesperson" search term.
• GET_AUTO_RENEWAL_FLAG — Reports whether the contract is configured for automatic renewal, supporting renewal processing and notification logic.

Tables Accessed

The ETRM metadata documents no explicit tables referenced through APPS synonyms for this package. Functionally, these procedures derive their results from the Service Contracts data model, including contract header and service line definitions, contract party and address records, and salesperson assignments held on the contract. Because no direct table references are catalogued, implementers should treat the package as an encapsulated access layer and avoid assuming a fixed table footprint; the internal queries may change across patch levels without altering the public interface.

Usage Notes

This package is typically invoked from Service Contracts forms, concurrent programs, and custom PL/SQL that needs contract-derived values rather than raw table reads. Callers should always supply a valid p_api_version, check x_return_status for FND_API.G_RET_STS_SUCCESS, and interrogate x_msg_count and x_msg_data when errors occur. The metadata records zero dependent packages, indicating the API is a leaf consumer rather than a shared utility referenced elsewhere. For salesperson lookups specifically, GET_SALESPERSON provides the supported, upgrade-safe path and should be preferred over direct queries against contract tables.