Results for “get_line_number”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OKE_CONTRACT_PRINTING_PKG is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Oracle Contracts (OKE/OKC) module and is responsible for assembling the data elements required to render printed contract documents and clause-article output. The package exposes a set of standalone utility functions rather than transactional APIs; its role is to resolve descriptive text, organizational context, party or contact names, article metadata, and formatted line references so that a printing or reporting layer can present a contract in a human-readable form. The package is classified under ETRM as API classification OTHER, indicating it is not a published, supported integration API but rather an internal helper used by contract authoring and printing components.

Key Procedures and Functions

• GET_ITEM_MASTER_ORG — Resolves the item master organization associated with contract line content, returning the organization identifier used to interpret inventory item references during printing.
• GET_PARTYORCONTACT_NAME — Returns the display name of a party or contact related to the contract, used to populate the customer, counterparty, or signatory fields on the printed output.
• GET_ARTICLE_INFO — Retrieves descriptive attributes for a contract article, supplying the text and metadata needed to render article-specific sections of the document.
• GET_ARTICLE_APPLICATION — Determines where and how an article applies within the contract, supporting conditional inclusion of article text in the print stream.
• CONVERT_DATE — Formats or translates a date value for presentation, ensuring date fields in the contract print in the expected display format.
• GET_LINE_NUMBER — Returns a line number reference for a contract line, supporting numbered or hierarchical line display in the printed document.

The package body additionally contains private helper logic such as get_article_subject_name and overloaded get_full_path_linenum routines that walk parent-child relationships in the key lines view to build a delimited full-path line reference. These internal functions resolve lookup meanings and recursively assemble line hierarchies.

Tables Accessed

Per documented metadata, the package references HR_ALL_ORGANIZATION_UNITS and OKC_K_HEADERS_B through APPS synonyms. HR_ALL_ORGANIZATION_UNITS supplies organization names used when resolving item master and organizational context. OKC_K_HEADERS_B, the base table for contract headers, provides the core contract identity data used by the article and line-related functions. The source excerpt additionally shows queries against FND_LOOKUPS (for OKE/OKC lookup meanings) and the contract lines views OKE_K_LINES_FULL_HV and OKE_K_LINES_FULL_V, which are read to resolve line numbers and parent-line hierarchies. All access is read-only; the package does not perform DML.

Usage Notes

Because this is an internal helper package rather than a supported API, it is not intended for direct invocation by customer integrations. It is typically called from contract printing and authoring flows within the Oracle Contracts application—most commonly behind the contract print concurrent program and contract-related forms where clause, article, and line text must be assembled for output. The metadata records zero packages referencing it, confirming its consumers are application-layer components rather than other PL/SQL packages. Custom code requiring similar contract print data should prefer supported OKC public APIs and views over calling this package directly, since its signatures are not guaranteed across patches. When troubleshooting printed contract output, version-related search terms such as c_version map to the MAJOR_VERSION filtering used internally when resolving contract line hierarchies, so discrepancies in printed line paths or missing article text should be investigated against the corresponding major version of the contract.