Search Results get_ppr_pmtcount

Overview

The APPS.IBY_FD_EXTRACT_GEN_PVT package is a private (PVT-classified) PL/SQL package within the Oracle Payments (IBY) module of Oracle E-Business Suite. Its principal business function is the generation of payment extract documents — structured output such as XML files — that are produced from payment instructions, payment formats, and related funding data. The package is the core engine invoked during the "extract" phase of the payment lifecycle, when Oracle Payments transforms processed payments into a formatted document deliverable, typically for transmission to a bank or payment system.

The package is declared AUTHID CURRENT_USER, meaning its SQL executes with the privileges of the invoking user rather than the package owner. It carries internal constants such as G_DEBUG_MODULE for logging, and bind-variable parameter names (G_VP_SYS_KEY, G_VP_INSTR_ID, G_VP_FV_ECS_SEQ, G_VP_FMT_TYPE) that drive the XML views used to assemble extract content. Because the package is classified PVT, it is not a supported public API; it is intended for internal consumption by Oracle Payments concurrent programs and format definitions.

Key Procedures and Functions

The package exposes 64 documented procedures and functions. The extract-generation procedures include:

• CREATE_EXTRACT_1_0 — overloaded procedures that build the extract document (returned as a CLOB) for a given payment instruction and format type. Variants serve payment formats, auxiliary formats, and separate remittance advice, with the latter accepting delivery method and payment ID parameters.
• CREATE_POS_PAY_EXTRACT_1_0 / CREATE_POS_PAY_EXTRACT_2_0 — generate positive pay extract output, filtering by payment profile and a date range.
• CREATE_PPR_EXTRACT_1_0 — generates extract output related to the payment process request context.

A second group of functions supports data enrichment of the extract by resolving and aggregating party, bank, and regulatory detail:

• GET_PAYER, GET_PAYERBANKACCOUNT, GET_PAYER_DENORM, GET_PAYERBANKACCOUNT_DENORM, GET_PAYERINS_DENORM, GET_PAYERBANKACCOUNTINS_DENORM — retrieve payer and payer bank account information in normalized and denormalized forms.
• GET_PAYEECONTACT, GET_PAYERCONTACT, GET_PAYEE_LEGALREGISTRATION, GET_PAYEE_TAXREGISTRATION, GET_FP_TAXREGISTRATION — resolve contact, legal registration, and tax registration data for payees, payers, and first parties.
• FORMAT_HR_ADDRESS, FORMAT_HZ_ADDRESS — normalize address data sourced from HR and Trading Community (HZ) models.
• GET_PMT_DOCPAYABLECOUNT, GET_INS_PAYERINSTRAGG, GET_INS_FVFIELDSAGG — aggregate counts and instruction-level or formula-validation field data used by the extract views.

Tables Accessed

The package reads and writes data primarily through APPS synonyms covering the payments, payables, and banking data model. Key tables include:

• IBY_DOCS_PAYABLE_ALL, IBY_PAYMENTS_ALL — core payments and documents payable records that form the basis of the extract.
• AP_INVOICES_ALL, AP_INVOICE_LINES_ALL, AP_CHECKS_ALL, AP_CARDS_ALL, AP_CREDIT_CARD_TRXNS_ALL, AP_EXPENSE_REPORT_HEADERS_ALL, AP_EXPENSE_REPORT_LINES_ALL — invoice, payment, and expense detail used for payee/payer enrichment.
• CE_BANK_ACCOUNTS — bank account data for payer and payee bank information.
• FV_SUMMARY_CONSOLIDATE, FV_TP_TS_AMT_DATA — federal (FV) summary and Treasury-disbursed amount data used for ECS-style extracts.
• HR_LOCATIONS_ALL and FND_LANGUAGES — address and language reference data for formatting output.

Usage Notes

This is an internal (private) package and is not intended for direct customer invocation. It is normally driven by Oracle Payments concurrent programs and the payment format/extract framework, which pass the payment instruction ID, format type, save flag, and a decryption system key (iby_security_pkg.des3_key_type). The system key indicates that the package participates in decryption of registered instrument data during extract assembly. Because the package is referenced by 49 other packages, it sits on a central code path for payment document generation across payment formats, positive pay, and remittance advice. The user query "get_doc_docerragg" does not correspond to a documented procedure in this package; no procedure by that name appears in the ETRM metadata, so it likely reflects an internal view or helper referenced in older releases rather than a callable member of IBY_FD_EXTRACT_GEN_PVT.