Search Results okl_contract_party_pub




Overview
Explore in AI Chat

Overview

OKL_CONTRACT_PARTY_PVT is a private (PVT-classified) PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema that supports Oracle Lease and Finance Management (OKL) and its integration with Oracle Contracts (OKC). The package encapsulates the business logic required to manage party and contact associations on a contract, including the creation, maintenance, and removal of contact records and party roles tied to a contract header.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling user rather than the definer. It defines subtype aliases drawn from OKL_OKC_MIGRATION_PVT and maintains two package-level global record variables, g_ctcv_rec and g_cplv_rec, which hold the contact (CTCV) and party-role/contact-role (CPLV) structures used throughout its procedures. Because it is classified as a private API, it is intended for internal consumption by other OKL/OKC packages and by the supporting forms and APIs rather than as a public integration point.

Key Procedures and Functions

The documented interface exposes twelve procedures across the following entry points:

  • CREATE_CONTACT — Inserts a new contact association using values carried in the CTCV record (or table) structure. Two overloads are documented: one accepting a single ctcv_rec and returning the populated record, and one accepting a ctcv_tbl collection for bulk creation.
  • UPDATE_CONTACT — Modifies an existing contact association. As with create, overloaded signatures support single-record and table-based invocation.
  • DELETE_CONTACT — Removes a contact association identified by the supplied ctcv_rec. This is the procedure returned by the "delete_contact" search term.
  • CREATE_K_PARTY_ROLE — Establishes a new party role on the contract, linking a party to a specific role defined at the contract header level.
  • UPDATE_K_PARTY_ROLE — Amends an existing contract party role.
  • DELETE_K_PARTY_ROLE — Removes a party role from the contract.

All standard entry points accept p_api_version, p_init_msg_list, and return the standard x_return_status, x_msg_count, and x_msg_data OUT parameters, consistent with the OKC/OKL API convention. The delete_contact declaration accepts a single ctcv_rec input, reflecting the top-of-file declaration excerpt.

Tables Accessed

The package works against the following objects through APPS synonyms:

  • HZ_PARTIES — The Trading Community Architecture party master, used to resolve and validate the party associated with a contact or role.
  • OKC_CONTACTS — Stores individual contact records attached to the contract.
  • OKC_K_HEADERS_B — The contract header base table, providing the parent contract context.
  • OKC_K_PARTY_ROLES_B — Holds the party-role assignments for a contract.
  • OKC_RULES_B — Contract rules that may govern party and role behavior.
  • PLITBLM — A PL/SQL index-by table used in bulk DML processing for the table-based overloads.

Usage Notes

OKL_CONTRACT_PARTY_PVT is a private API and should not be called directly by external integrations. It is typically invoked from the OKL contract maintenance forms (such as the lease/contract party and contact detail blocks) and from higher-level OKL or OKC public APIs that delegate contact and party-role maintenance to this package. The metadata indicates the package is referenced by two other packages, confirming its role as an internal service layer.

The overloaded record and table signatures allow both single-row transactions from forms and set-based processing during migrations or batch operations, with PLITBLM supporting the bulk DML. When calling from custom code, the standard x_return_status, x_msg_count, and x_msg_data parameters should be checked to verify success. Appropriate FND_MESSAGE handling and rollback/savepoint management remain the caller's responsibility. Because the object is edition-sensitive and shipped with the 11i header lineage, deployments to 12.1.1 and 12.2.2 should rely on the current shipped version rather than any cached source.