Search Results delete_proj_asset_line

Overview

PA_FAXFACE is an Oracle Projects package in the APPS schema that supports the interface between Oracle Projects and Oracle Assets. Its core purpose is to create, validate, reverse, and maintain capitalized asset lines generated from project expenditures and capital events. The package name and the routines it exposes indicate a role in the Project Asset generation and reversal lifecycle: transforming eligible project costs into asset lines, resolving asset categories and asset identifiers through the Oracle Assets tables, and enforcing the required descriptive flexfield segments necessary before an asset can be booked.

The source header shows the package carries a standard "who" set of global variables derived from FND_GLOBAL (user_id, login_id, program application, program and request identifiers), which are used when records are inserted or updated. Additional package-level state includes an in-service-thru-date variable and a debug mode flag. The package is documented as API classification OTHER and is referenced by four other packages, confirming its role as a shared utility within the Project Asset flows rather than a standalone module. The check_required_segment function, which is the object referenced in the user's search, is one of the validation utilities exposed by this package.

Key Procedures and Functions

• CHECK_REQUIRED_SEGMENT — accepts a structure number and returns a status indicator. It validates whether the required key flexfield segments for the given structure have been supplied, and is the routine most directly associated with pre-asset-creation validation.
• SET_IN_SERVICE_THRU_DATE / GET_IN_SERVICE_THRU_DATE — package-level accessors for the in-service-thru-date used by the Project Asset generation view so that a report parameter can be applied in the view's WHERE clause.
• INITIALIZE — performs package initialization and returns a status value.
• GET_GROUP_LEVEL_TASK_ID — resolves the group-level (top) task identifier for a given task within a project.
• GET_ASSET_CATEGORY_ID — derives the asset category for a document header, line, and distribution combination, taking the transaction source into account.
• IS_PROJECT_ELIGIBLE — evaluates whether a project and capital event qualify for capitalization.
• GET_ASSET_ID — determines the asset identifier using project, system linkage function, group-level task, asset category, and line type inputs.
• GET_ASSET_ATTRIBUTES — returns the descriptive attributes needed when the asset record is created.
• FIND_ASSETS_TO_BE_REVERSED / CHECK_ASSET_TO_BE_REVERSED / CHECK_PROJ_ASSET_LINES — identify and validate assets and project asset lines eligible for reversal.
• UPDATE_LINE_DETAILS / UPDATE_EXPENDITURE_ITEMS / UPDATE_ASSET_COST — maintain the capitalization amounts and expenditure links on existing project asset lines.
• CREATE_PROJECT_ASSET_LINES / REVERSE_ASSET_LINES — the principal transactional routines that generate asset lines and reverse previously created ones.
• GET_PROJ_ASSET_ID / DELETE_PROJ_ASSET_LINE / DELETE_PROJ_ASSET_LINE_DETAILS — retrieve and remove project asset line records and their detail rows.

Tables Accessed

The package reads and writes Oracle Assets tables including FA_ADDITIONS, FA_ASSET_INVOICES, FA_BOOKS, FA_BOOK_CONTROLS, FA_CATEGORIES, FA_DEPRN_PERIODS, and FA_MASS_ADDITIONS, which supply asset definitions, book and category setup, depreciation period information, and mass addition processing. Oracle Payables tables — AP_BATCHES, AP_BATCHES_ALL, AP_INVOICES, AP_INVOICES_ALL, AP_INVOICE_DISTRIBUTIONS, AP_INVOICE_DISTRIBUTIONS_ALL, and AP_SELF_ASSESSED_TAX_DIST_ALL — provide the invoice and distribution detail that backs the project expenditure items eligible for capitalization. Together these tables support the resolution of asset identifiers, categories, and costs, and the creation or reversal of the project asset lines that ultimately feed assets in Oracle Assets.

Usage Notes

PA_FAXFACE is typically invoked indirectly rather than through a user-facing form. It is called by the Project Asset generation and reversal concurrent programs, by the pa_cp_generate_asset_v view that relies on the in-service-thru-date parameter, and by other packages (four documented referrers) that share its asset resolution and line maintenance logic. Custom code extending Project Asset capitalization should call the documented functions for category and asset id resolution and use CHECK_REQUIRED_SEGMENT before attempting to create asset records, ensuring key flexfield segments are populated. Because the package maintains standard WHO columns from FND_GLOBAL, callers should be aware that audit columns reflect the invoking session or concurrent request context. Debug mode can be enabled via the G_debug_mode flag when diagnosing asset generation failures.