Search Results chk_company_code




Overview
Explore in AI Chat

Overview

XTR_FPS1_P is a treasury and financial product calculation package in the Oracle E-Business Suite Treasury (ETRM) module. Its name derives from its role as a Financial Product Services utility library — a consolidated, reusable set of pricing, tax, brokerage, credit-check, and validation routines invoked across the Treasury deal lifecycle. The package header declares AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema rather than the owner (APPS), so it operates against whatever synonyms and grants the invoker holds. The header carries a version marker reflecting maintenance under the Treasury source tree.

In the EBS 12.1.1 and 12.2.2 releases, Treasury deals span money market instruments, foreign exchange, bonds, and options. XTR_FPS1_P centralises the arithmetic and reference-data validation logic these instrument types require, so that interest accruals, tax withholding, brokerage charges, option revaluation, and counterparty/client eligibility are computed consistently regardless of the entry point.

Key Procedures and Functions

  • ADVICE_LETTERS — Resolves the counterparty and client advice letter references used when generating deal confirmations; returns the advice identifiers for the counterparty and client as output parameters.
  • CAL_BOND_PRICE — Computes bond pricing outputs (cum, ex, and volatility-adjusted prices) from coupon, yield, and settlement timing inputs.
  • CALC_OPTION_PRICE — Values an option position, returning a revaluation amount from expiry, volatility, market, strike, spot, and reference-amount inputs, distinguishing put and call.
  • CALC_TAX_BROKERAGE — Derives applicable tax and brokerage rates and outputs the resulting tax and brokerage amounts, including the home-currency equivalents (the _hce outputs), together with an error code and level indicator.
  • CALC_TAX_AMOUNT — Calculates the principal and income tax amounts for a deal based on tax references, currency, and the year basis convention.
  • GET_TAX_SETTLE_METHOD — Retrieves the configured settlement method governing how computed tax is applied.
  • GET_TAX_ROUND_FACTOR — Returns the rounding factor used to round tax amounts per setup.
  • CHK_CCY_CODE — Validates a currency code against the master currency list.
  • CHK_CLIENT_CODE — Validates a client code; this is the routine associated with the "chk_client_code" search term and is used to confirm a client reference before a deal is booked or processed.
  • CHK_COMPANY_CODE — Validates the company (legal entity) code, including authority restrictions.
  • CHK_CPARTY_ACCOUNT — Verifies a counterparty bank account.
  • CHK_CPARTY_CODE — Validates the counterparty code.
  • CHK_CPARTY_LIMIT — Tests the counterparty against configured credit limits.
  • CHK_DEALER_CODE — Validates the dealer code.
  • CHK_DEAL_STATUS — Validates the deal status.

Tables Accessed

The package reads and writes Treasury setup and transactional tables through APPS synonyms: FND_CURRENCIES and XTR_MASTER_CURRENCIES (currency validation), XTR_PRODUCT_TYPES (instrument classification), XTR_DEALER_CODES (dealer validation), XTR_BANK_ACCOUNTS and XTR_CPARTY_ACCOUNT validation, XTR_COMPANY_AUTHORITIES (legal-entity validation), XTR_COUNTERPARTY_LIMITS (credit limit checks), XTR_TAX_BROKERAGE_SETUP and XTR_TAX_BROKERAGE_RATES (rate derivation), XTR_TAX_DEDUCTION_CALCS (tax computation), XTR_DEDUCTION_CALCS and XTR_CUM_DIST_CALCS (interest accrual and cumulative distribution calculations).

Usage Notes

XTR_FPS1_P is invoked primarily by Treasury forms during deal entry and validation (for example, the currency, client, counterparty, dealer, and company code checks fired on field validation), and by concurrent programs and batch revaluation jobs. Six other Treasury packages call it for shared pricing and tax arithmetic, making it a low-level dependency rather than an end-user API. Customers extending Treasury should call the CHK_* routines and CALC_*/CAL_* utilities rather than duplicating their logic. Because the package is AUTHID CURRENT_USER, callers must have the requisite EXECUTE grants and object privileges.