Search Results auto_submit_chg_lines

Overview

CS_CHG_AUTO_SUB_CON_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the API classification type OTHER. Its purpose is to support the automatic submission of charge lines within the Oracle TeleService / Service (CS) module. The package naming convention and header comments indicate it operates as a private, module-internal utility intended for use by the owning Service application rather than as a publicly callable interface. The header identifies the package as AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema rather than the definer, a design typical of internal processing packages that assume the caller already holds the necessary permissions on the underlying Service objects.

The package is principally concerned with identifying candidate charge lines eligible for autosubmission, applying submission restriction logic, updating those lines with appropriate restriction messages, and evaluating debrief status as part of the submission decision. Because the package is not referenced by any other documented packages, it functions as a self-contained unit of processing logic, most likely invoked through a concurrent program and the Service charge-line submission workflow.

Key Procedures and Functions

The package exposes five documented procedures and functions:

• AUTO_SUBMIT_CHG_LINES — Identifies charge lines that qualify for autosubmission. It is documented as a private procedure intended for use only by the owning module, and follows the standard EBS API argument conventions (API version, initialization of the message list, commit control, and return status/message outputs).
• MAIN_PROCEDURE — The entry point for the concurrent program. It accepts the standard concurrent-program out parameters ERRBUF and RETCODE, which carry the log output and completion status back to the concurrent manager.
• UPDATE_CHARGE_LINES — Updates charge lines with the appropriate restriction message when a line cannot be submitted. Its documented parameters include the incident identifier, the estimate detail identifier, the currency code, and a submit restriction message.
• SUBMIT_CHARGE_LINES — Executes the submission of charge lines selected by the auto-submission logic.
• CHECK_DEBRIEF_STATUS — Evaluates the debrief status associated with a service incident to determine whether charge lines may proceed through autosubmission. This is the object corresponding to the search term "check_debrief_status" and represents a gating check in the submission flow.

This article does not reproduce parameter lists for procedures whose signatures are not fully documented in the available metadata.

Tables Accessed

The package reads and writes several Service and reference tables through APPS synonyms:

• CSF_DEBRIEF_HEADERS — the debrief header records consulted by CHECK_DEBRIEF_STATUS.
• CS_CHG_SUB_RESTRICTIONS — restriction definitions used to determine whether a charge line may be autosubmitted and what message to apply.
• CS_ESTIMATE_DETAILS — estimate detail records that correspond to individual charge lines.
• CS_INCIDENTS_ALL_B, CS_INCIDENT_TYPES, and CS_TRANSACTION_TYPES — incident and transaction classification data that scope the autosubmission logic.
• JTF_TASK_ASSIGNMENTS and JTF_TASK_STATUSES_B — task assignment and status information used in workflow and debrief checking.
• HZ_PARTIES — party information associated with incidents and charges.
• PLITBLM — the standard EBS PL/SQL table used for message-list handling within the API framework.

Usage Notes

CS_CHG_AUTO_SUB_CON_PKG is intended for internal use by the Service (TeleService) module. In practice it is invoked through the concurrent program whose entry point is MAIN_PROCEDURE, which drives the identification and submission of charge lines and reports results via ERRBUF and RETCODE. Custom development should treat this package as private: because it is AUTHID CURRENT_USER and documented as restricted to its owning module, direct calls from third-party code are not supported and may be subject to change across EBS releases. Where customization is required, the recommended approach is to invoke the supported public APIs of the Service module rather than calling the internal procedures of this package directly. Organizations upgrading between 12.1.1 and 12.2.2 should note the package header references a 2008 source revision, indicating the logic has been stable across the 12.1.x and 12.2.x code lines.