Search Results period1_fy

Overview

APPS.FA_FASAAMTD_XMLP_PKG is the Oracle E-Business Suite PL/SQL package body that supports the "Form 4626 - AMT Detail Report" and its "Adjusted Form 4626 - AMT Detail Report" companion output. Form 4626 is the United States Internal Revenue Service form used to compute the Alternative Minimum Tax (AMT) for corporations; in Oracle Assets (FA), the Fixed Assets product family, this report provides the depreciation-derived detail needed by tax departments to reconcile book depreciation against AMT depreciation for a federal tax book. The package is classified as an OTHER API within ETRM, indicating it is not a published or callable business API but rather internal report support code generated in the Oracle Reports (XML Publisher) XMLP pattern. It supplies derived values, period context, and descriptive prompts to the report layout, and it is owned by the APPS schema, consistent with standard Oracle EBS seed data shipped under application 140 (Oracle Assets).

Key Procedures and Functions

The package exposes 17 documented procedures and functions. The report_nameformula function resolves the concurrent program name at runtime by reading the request identifier, trimming the " (XML)" suffix, and returning the display name; it also handles an adjusted-versus-unadjusted variant based on the P_ADJUSTED flag. BeforeReport and AfterReport are standard report-level hooks in which the historical SRW user-exit calls have been commented out, leaving them as no-op return-TRUE stubs.

The period and amount derivation functions form the analytical core. Period1_PCFormula reads the depreciation period row for the selected federal book and period and returns the period counter, capturing the open date, close date, and fiscal year into the Period1_POD, Period1_PCD, and Period1_FY package variables. Period1_POD_P, Period1_PCD_P, and Period1_FY_P expose those captured values as report parameters — Period1_FY_P is the value surfaced to the layout when the report needs the fiscal year of the first period. FED_START_PERIOD_PCFORMULA, AMT_START_PERIOD_PC_P, and AMT_END_PERIOD_PC_P resolve period counters for the federal start period and the AMT start and end periods respectively, while FED_END_PERIOD_PC_P handles the federal end period. The depreciation functions DIFF_DEPRNFORMULA, AMT_DEPRNFORMULA, and FED_DEPRNFORMULA compute the difference, AMT, and federal depreciation amounts presented in the report columns. Finally, RP_COMPANY_NAME_P, RP_REPORT_NAME_P, and RP_BAL_LPROMPT_P are value-holder functions for the company name, report name, and balance-line prompt placeholders.

Tables Accessed

Two tables are referenced through APPS synonyms. FA_DEPRN_PERIODS is queried by Period1_PCFormula (and the related period formulas) to retrieve period_counter, period_open_date, period_close_date, and fiscal_year for a given book_type_code and period_name. This is the authoritative source of depreciation period calendar data in Oracle Assets and drives the fiscal-year value that matches the "period1_fy" reference. FND_CONCURRENT_REQUESTS is read in report_nameformula to map the concurrent request identifier to its concurrent_program_id, which is then used against FND_CONCURRENT_PROGRAMS_VL to obtain the user-facing program name. No insert, update, or delete operations are documented.

Usage Notes

This package is invoked indirectly, as support code for the Form 4626 AMT Detail concurrent report in Oracle Assets; it is not intended for direct invocation from forms, custom concurrent programs, or client code. ETRM records zero referencing packages, confirming the XMLP package is terminal report scaffolding rather than a shared library. The functions are called by the Oracle Reports/XML Publisher definition during execution to populate lexical and bind parameters, period defaulting, and column formulas. Because report_nameformula derives its output from the concurrent request, the same package serves both the standard and adjusted variants of the report based on the P_ADJUSTED parameter, and any customization of the report name or period logic should be applied with awareness that the SRW user-exit initialization has been disabled in this version.