Search Results delete_charges

Overview

CSF_DEBRIEF_CHARGES is a public PL/SQL package in the APPS schema that functions as a wrapper for charges within the Oracle E-Business Suite Debrief (field service) subsystem. Its header declares AUTHID CURRENT_USER, meaning that it executes with the privileges of the calling user rather than the package owner, and its stated purpose is to encapsulate the logic used to create, update, and delete charge lines associated with a debrief transaction. In the Depot Repair and TeleService flows of EBS 12.1.1 and 12.2.2, debrief captures the labor, material, and expense activity performed against a repair job; CSF_DEBRIEF_CHARGES provides the programmatic interface through which those activities are translated into billable or non-billable charge records.

Key Procedures and Functions

• CREATE_CHARGES — Inserts a new debrief charge. It accepts a broad set of attributes describing the charge context, including original source identifiers, incident, business process, line category, source code and identifiers, inventory item, revision, unit of measure, quantity, billing and transaction types, customer product, warranty-related dates and costs, currency, return reason, inventory organization, subinventory, serial number, final charge flag, and labor start/end dates. It returns the standard API status triple: return status, message count, and message data.
• UPDATE_LAB_RS_LOC — Updates the labor reservation and resource location information for a specific debrief line, keyed by debrief header and line identifiers together with a labor start date. It also returns the standard return status, message count, and message data outputs.
• UPDATE_CHARGES — The procedure typically targeted by the "update_charges" search; it modifies existing debrief charge records. Its parameter list is not reproduced in the available metadata, but it is documented as a public procedure of this package for maintaining charge data on already-created lines.
• DELETE_CHARGES — Removes debrief charge records. Like the update counterpart, it is a documented public procedure whose detailed signature is not included in the excerpt.

All procedures follow the ETRM/API convention of returning X_RETURN_STATUS, X_MSG_COUNT, and X_MSG_DATA, allowing callers to inspect outcome and error messages consistently.

Tables Accessed

The package operates against the following tables via APPS synonyms:

• CSF_DEBRIEF_HEADERS and CSF_DEBRIEF_LINES — the core debrief documents and their lines, to which charges are attached.
• CSD_REPAIRS — the depot repair order providing repair context.
• CS_ESTIMATE_DETAILS — estimate line detail used to derive or validate charge amounts.
• CS_TXN_BILLING_TYPES — billing classification of the transaction.
• JTF_TASKS_B and JTF_TASK_ASSIGNMENTS — task and assignment records linking resources to debrief work.
• JTF_RS_RESOURCE_EXTNS — resource information, relevant to labor reservation and location updates.
• HZ_LOCATIONS and HZ_PARTY_SITES — party and location data for the customer or site associated with the charge.

Usage Notes

CSF_DEBRIEF_CHARGES is invoked by the Debrief forms during charge entry and maintenance, where user actions on the Charges block invoke CREATE_CHARGES, UPDATE_CHARGES, and DELETE_CHARGES. UPDATE_LAB_RS_LOC is called when labor/resource assignment details change on a debrief line. The package is also referenced by one other package and is available for custom concurrent programs or extensions that must programmatically maintain debrief charges. Because it is a wrapper API, callers should not write directly to CSF_DEBRIEF_LINES or related tables, and should always check the returned status and message outputs.