Search Results p_proposal_id

Overview

IGW_GR_REPORT_PROCESSING is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that belongs to the Grants Accounting / Grants Proposal (IGW) product family. Its primary business function is to supply formatted, report-ready attribute values for grants proposal and award reporting. The package centralizes the logic required to resolve person, organization, contact, budget, and distribution information into display strings that can be embedded in printed reports, letters, and correspondence generated from the Grants module. The package is classified as OTHER in the ETRM repository, indicating that it is a supporting utility package rather than a public workflow or business API. It is exposed as a package specification with a set of public functions, each returning a single formatted value.

Key Procedures and Functions

The documented interface exposes twenty-five functions that fall into three broad categories.

• Person and contact resolution: GET_LAST_FIRST_MIDDLE_NAME, GET_JOB_TITLE, GET_PERSON_ORGANIZATION, GET_PHONE_NUMBER, GET_FAX_NUMBER, GET_EMAIL_ADDRESS, and GET_PERSON_ADDRESS each return a formatted contact attribute for a given party and proposal combination, drawing on person and organization data associated with the proposal.
• Address formatting: FORMAT_ADDRESS and FORMAT_ADDRESS_MULTILINE both accept address line 1–3, town or city, up to three region values, and a postal code, and return a single formatted address string. The distinction lies in output layout: FORMAT_ADDRESS produces a conventional delimited or single-line address, while FORMAT_ADDRESS_MULTILINE returns an address arranged across multiple lines suitable for mailing labels and letter blocks. This is the function most commonly associated with the search term "format_address_multiline."
• Budget and distribution figures: GET_CATEGORY_PERIOD_AMOUNT, GET_CATEGORY_PERIOD_DESC, GET_PERIOD_DISTR_DC, GET_PERIOD_DISTR_IC, GET_TOTAL_DISTR_DC, GET_TOTAL_DISTR_IC, GET_SALARY_REQUESTED, GET_EMPLOYEE_BENEFITS, and GET_BUDGET_PERCENT_EFFORT return monetary, descriptive, distribution, and effort values for a proposal, budget category, and budget period.
• Special review checks: DOES_SPECIAL_RESEARCH and ANIMAL_APPROVAL_DATE support special review and animal protocol reporting.

Tables Accessed

The ETRM metadata for this package does not list any explicitly referenced tables through APPS synonyms. Because the functions resolve party, proposal, budget, and distribution attributes, the package implicitly reads from the underlying Grants and Oracle Trading Community Architecture (TCA) entities — including party, person, address, phone, email, proposal, budget category, budget period, and distribution tables — through their APPS synonyms. No direct DML is documented; the package behaves as a read-only reporting utility.

Usage Notes

IGW_GR_REPORT_PROCESSING is typically invoked from Oracle Reports and BI Publisher report definitions, from Grants forms that render formatted contact or budget text, and from custom PL/SQL code that builds correspondence for proposals and awards. The FORMAT_ADDRESS_MULTILINE function in particular is called when a report must emit a properly line-broken mailing address. The package is not referenced by any other package, so its consumers are external — reports, forms, and custom programs. The installation mode is read from the IGW_PROPOSAL_INSTALLATION_MODE profile option via FND_PROFILE.VALUE_WNPS at package initialization, which governs environment-specific behavior. Because there is no documented wrapper API and no inter-package dependency, modifications to the package should be treated as a direct impact on report output.