Search Results reset_line_num

Overview

ASO_LINE_NUM_INT is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, classified under the Order-to-Cash / Sales domain that centers on Oracle Quoting (ASO). Within the ASO module, quote lines require a stable, user-facing line numbering scheme that remains consistent regardless of how the underlying rows are stored, sorted, or re-sequenced in the base tables. The ASO_LINE_NUM_INT package encapsulates the internal logic that derives, assigns, and resets these user-interface line numbers for quote lines. In ETRM documentation it is classified as an "OTHER" API, meaning it is not a public, committed interface but rather an internal utility package intended for use by other ASO components rather than by external integrations. Its status is VALID in both Oracle EBS 12.1.1 and 12.2.2, confirming it remains an active part of the quoting code line. The package depends on ASO_QUOTE_LINES_ALL and the ASO_PVT_QUOTE_LINES_BALI_V view for its data, and it calls supporting infrastructure such as FND_API, FND_PROFILE, and ASO_DEBUG_PUB for error handling, profile option retrieval, and debugging output.

Key Procedures and Functions

The package exposes four documented procedures and functions, each addressing a specific aspect of line-number management:

• ASO_UI_LINE_NUMBER — Assigns or derives the line number that is presented to the user in the Quoting user interface. It forms the core routine for translating stored quote line data into the sequence shown on the form.
• ASO_QUOTE_LINE_NUMBER — Handles the line-number logic specific to quote lines, providing the numbering convention used when quote lines are created, copied, or reorganized.
• GET_UI_LINE_NUMBER — A retrieval routine that returns the current UI line number for a given quote line, allowing callers to obtain the display number without recalculating or mutating the underlying data.
• RESET_LINE_NUM — Resets or re-initializes line numbering, typically invoked when lines are deleted, re-sequenced, or when a quote is renumbered as a whole.

The ETRM metadata does not publish parameter lists for these routines, so their signatures should be confirmed against the deployed package specification before any direct invocation.

Tables Accessed

The package operates against two documented data objects, both reached through APPS synonyms:

• ASO_QUOTE_LINES_ALL — The base table storing quote line records. ASO_LINE_NUM_INT reads from and potentially updates line-number related attributes here, since this table is the authoritative source for quote line data.
• PLITBLM — A PL/SQL internal table type used within the package for in-memory collections, supporting the set-based processing of line numbers.

The dependency listing additionally shows references to the view ASO_PVT_QUOTE_LINES_BALI_V, which supplies a pre-joined or balance-oriented projection of quote line data. FND_API is used for the standard EBS API error-handling pattern, FND_PROFILE for profile option lookups, and ASO_DEBUG_PUB for diagnostic logging.

Usage Notes

ASO_LINE_NUM_INT is not referenced by any database object according to the ETRM dependency data, and it is not itself a published API. Its callers are therefore expected to be other ASO packages — the metadata notes that it is referenced by nine other packages within the application. In practice it is invoked indirectly whenever the Oracle Quoting forms, quote copy/versioning logic, or order-capture flows need to display or recalculate line numbers. Because it is an internal ("OTHER") API, customizations should avoid calling it directly; developers requiring line-number behavior should use the documented, supported ASO public APIs and treat ASO_LINE_NUM_INT as an implementation detail subject to change across patches and releases.