Results for “cf_bsr_codeformula”

8 results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

JA_JAINITCR_XMLP_PKG is an Oracle E-Business Suite PL/SQL package owned by APPS and defined with AUTHID CURRENT_USER. It is the database-side package body associated with the Oracle XML Publisher (BI Publisher) concurrent program JAINITCR, which produces the India Localization certificate report used for Tax Deducted at Source (TDS) reporting. The naming convention (JA prefix for the India localization, XMLP_PKG suffix for XML Publisher report packages) indicates that this package supplies report-level parameter bindings, format triggers, and computed formula columns consumed by an XML Publisher report template.

The package is declared as a collection of public package variables and functions. The variables represent report parameters (vendor, date range, certificate numbering, organization, financial year, TAN, concurrent request ID, and selected certificate metadata) and report-level computed accumulators (cess, surcharge, and higher cess amounts). Collectively, these globals allow the XML Publisher report to reference values that are computed or gathered during the concurrent program's execution.

Key Procedures and Functions

The documented callable units are 20 functions. The principal ones are:

  • CONVERT_NUMBER — Converts an integer numeral into its spelled-out string representation, typically used for printing amounts in words on the certificate.
  • CF_TDS_AMTFORMULA — Computes the TDS amount for a given TDS invoice, taking the TDS invoice identifier and the TDS invoice amount as inputs. This is the function directly relevant to the user's search term.
  • CF_3FORMULA — Derives a formatted value from a supplied TDS amount.
  • BANK_BRANCHFORMULA — Resolves and formats the bank/branch description associated with a cheque, TDS invoice, and TDS record.
  • CF_1FORMULA and CF_2FORMULA — Format triggers returning computed report values.
  • CP_1FORMULA — Returns a character value used for a column placeholder.
  • CF_VEN_PAN_NOFORMULA — Returns the vendor's Permanent Account Number (PAN).
  • CF_CHECK_DEP_DATEFORMULA — Returns the cheque deposit date for a given cheque.
  • CF_BSR_CODEFORMULA — Returns the BSR code associated with a bank account.
  • BEFOREREPORT and AFTERREPORT — Report-level before/after triggers used to initialize and finalize report data.
  • AFTERPFORM — Executed after parameter form submission to prepare report state.
  • F_SELECTED_CERT_DATE, F_SELECTED_CERT_ID, F_SELECTED_VENDOR — Return the report's selected certificate date, certificate identifier, and vendor.
  • CP_CESS_AMT_P, CP_SURCHARGE_AMT_P, CP_SH_CESS_AMT_P, CP_1_P — Return the accumulated cess, surcharge, higher cess, and column placeholder values.

Tables Accessed

The package reads from Oracle Payables and India TDS tables via APPS synonyms. AP_BANK_ACCOUNTS_ALL, AP_BANK_ACCOUNT_USES_ALL, and AP_BANK_BRANCHES supply bank account and branch information for BSR code and bank branch resolution. AP_CHECKS_ALL and AP_INVOICE_PAYMENTS_ALL provide payment and cheque details, including cheque deposit dates. JAI_AP_TDS_F16_HDRS_ALL, JAI_AP_TDS_INV_PAYMENTS, JAI_AP_TDS_PAYMENTS, and JAI_AP_TDS_VENDOR_HDRS hold the India TDS certificate, invoice payment, payment, and vendor header data. JAI_CMN_TAXES_ALL supplies India tax definitions. FND_CONCURRENT_PROGRAMS and FND_CONCURRENT_REQUESTS provide concurrent program and request context. V$DATABASE, V$PROCESS, and V$SESSION are dynamic performance views referenced for session/database context.

Usage Notes

This package is invoked indirectly through the JAINITCR XML Publisher concurrent program rather than being called directly by other application code; the metadata records zero referencing packages. The report parameters are populated at submission time, and the formula functions are called by the XML Publisher template during report generation to compute display values such as the TDS amount, vendor PAN, BSR code, cheque deposit date, and amount-in-words. Customizations or extensions that need the TDS amount calculation logic should reference CF_TDS_AMTFORMULA through the report definition rather than bypassing the package, since the underlying India TDS tables and column semantics are curated within that function.