Search Results cn_credit_types




Overview
Explore in AI Chat

Overview

CN_PMTPLAN_PUB is a public PL/SQL API package in the APPS schema that supports the Oracle E-Business Suite payment plan functionality within the Contracts (CN) module. It provides the programmatic interface for creating, maintaining, and removing payment plan records, which are business arrangements that schedule contract-related monetary obligations over defined intervals. The package belongs to the "PUB" API classification, indicating that it is intended for external invocation by forms, concurrent programs, and custom extensions rather than being restricted to internal use.

In Oracle EBS 12.1.1 and 12.2.2, payment plans are closely tied to credit types and interval types, allowing organizations to model installment structures, billing cycles, and credit terms for contracts, leases, and similar instruments. CN_PMTPLAN_PUB encapsulates the business logic governing these structures, ensuring that payment plan maintenance respects the integrity of the underlying credit and interval configuration data.

Key Procedures and Functions

The ETRM metadata documents three procedures for this package, representing the standard lifecycle operations for a payment plan:

  • CREATE_PMTPLAN — Inserts a new payment plan record, validating the associated credit type and interval type definitions before persisting the plan to the base table.
  • UPDATE_PMTPLAN — Modifies the attributes of an existing payment plan, such as interval assignments or credit type associations, while preserving referential dependencies.
  • DELETE_PMTPLAN — Removes an existing payment plan record from the repository, typically subject to eligibility checks against dependent transactions.

The package exposes six documented procedures and functions in total, encompassing these lifecycle operations and their supporting logic. Parameter lists are not documented in the ETRM excerpt and are therefore not reproduced here; developers should inspect the package specification in the database for exact signatures.

Tables Accessed

The package operates against the following tables through APPS synonyms:

  • CN_PMT_PLANS and CN_PMT_PLANS_S — The primary payment plan definition table and its sequence, holding the persistent plan records created and maintained by the API.
  • CN_CREDIT_TYPES — Lookup of credit types used to classify the financing terms associated with a payment plan. This is the table referenced by the user search term "cn_credit_types."
  • CN_INTERVAL_TYPES and CN_INTERVAL_TYPES_ALL_TL — Define the billing or payment interval patterns (and their translated names) that govern how scheduled amounts are spaced over time.
  • DUAL — Used for single-row operations such as sequence value retrieval and validation queries.

Because the package references CN_CREDIT_TYPES and the interval type tables, any change to those reference data sets directly affects payment plan validation during create and update operations.

Usage Notes

CN_PMTPLAN_PUB is typically invoked from the Contracts forms when a user defines or revises payment plan arrangements, and from concurrent programs or custom PL/SQL that must generate payment plans programmatically. The package is self-referential in the dependency report, meaning internal procedures call one another, but it is not referenced by any other documented packages, indicating that it functions as a top-level API within this area rather than as a shared utility.

Custom code should call the public procedures directly rather than performing DML against CN_PMT_PLANS, since the API enforces the business rules linking payment plans to valid credit and interval types. Developers should confirm the current specification in the APPS schema before coding calls, as the ETRM excerpt lists procedure names only and does not include argument definitions.