Search Results initialize_jp




Overview

FA_ADDITION_PVT is a private (PVT) PL/SQL package in the Oracle E-Business Suite Fixed Assets (FA) module, owned by the APPS schema. It provides the internal implementation logic that supports the public asset addition APIs within the FA_ADDITION family. The package is declared with AUTHID CURRENT_USER, meaning its SQL statements execute with the privileges of the invoking user rather than the definer, which is consistent with EBS internal API design conventions.

The package header carries the version identifier $Header: FAVADDS.pls 120.5 2011/10/24 07:41:31 deemitta ship $, indicating a shipped Oracle source file distributed with the 12.1.1 and 12.2.2 releases. Its business purpose is to initialize transaction, asset, invoice, and distribution structures required for creating asset addition transactions, and to persist the resulting asset records into the Fixed Assets base tables. Because it is an internal PVT package, it is not intended for direct customer invocation; it is called by the public API layer and by one other package documented in ETRM.

Key Procedures and Functions

  • INITIALIZE — A function returning BOOLEAN that prepares the full set of API record structures prior to an asset addition. It operates on the transaction object (transaction and distribution transaction records), the asset object (header, description, type, category, hierarchy, financial, and depreciation records, plus the asset distribution table), and the invoice object. It accepts a calling function name and a log level record, and returns an overall return status. This procedure is the entry point that establishes valid defaults and context before insertion.
  • INSERT_ASSET — A function that performs the actual creation of the asset record. It consumes the transaction, description, type, category, hierarchy, financial, depreciation, distribution, and invoice structures, along with primary cost, exchange rate, MRC (Multiple Reporting Currency) set of books type code, period record, and calling function metadata. It writes the asset into the Fixed Assets tables and returns a status indicator.
  • INITIALIZE_JP — A localized initialization function, corresponding to the Japanese (JP) localization of the asset addition process. It provides the country-specific initialization behavior required for Japanese statutory accounting, mirroring the standard INITIALIZE entry point but applying JP-specific defaults and validation rules. This is the routine referenced by the user search term "initialize_jp".

Tables Accessed

The package reads and writes a broad set of Fixed Assets tables via APPS synonyms. It accesses FA_ADDITIONS_S to create and identify asset additions, and FA_BOOKS and FA_BOOK_CONTROLS for book-level asset financial data and book setup. Depreciation processing relies on FA_DEPRN_SUMMARY, FA_DEPRN_PERIODS, FA_DEPRN_BASIS_RULES, and FA_DEPRN_RULE_DETAILS. Category and default derivation use FA_CATEGORIES and FA_CATEGORY_BOOK_DEFAULTS. Calendar and period validation use FA_CALENDAR_PERIODS, FA_CALENDAR_TYPES, and FA_FISCAL_YEAR. Invoice-related processing uses FA_ASSET_INVOICES, warranty handling uses FA_ADD_WARRANTIES, and adjustments use FA_ADJUSTMENTS.

Usage Notes

FA_ADDITION_PVT is invoked indirectly through the public Fixed Assets addition APIs and is referenced by one other package per ETRM metadata. Typical call paths include the asset addition forms, the mass additions and invoice integration concurrent programs, and custom PL/SQL that calls the public API layer, which in turn delegates to this PVT package. Customers should not call FA_ADDITION_PVT directly; instead they should use the supported public API entry points, which internally route to INITIALIZE and INSERT_ASSET. The INITIALIZE_JP variant is relevant to Japanese localization requirements and should be selected automatically by the API layer based on the operating unit's localization configuration.