Search Results get_final_version

Overview

IGW_REPORT_PROCESSING is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema that supports the Grants and Proposal (IGW) reporting infrastructure. Its responsibilities center on assembling, retrieving, and formatting the data that appears on proposal and budget reports — most notably itemized budgets, base rates, budget justifications, question-and-answer responses, and abstract content associated with a proposal. The package maintains global (G_) variables such as G_PROPOSAL_ID, G_START_PERIOD, G_VERSION_ID, and G_PROPOSAL_FORM_NUMBER, which act as session state for the currently processed proposal and version. Simple accessor functions expose these values so that other reporting routines operate against a consistent context. The package is classified as "OTHER" within ETRM and is referenced by ten other packages, confirming its role as a shared utility for IGW report generation rather than a standalone business transaction API.

Key Procedures and Functions

The package documents twenty-three procedures and functions. Central to the user search "get_final_version" is GET_FINAL_VERSION, which resolves the operative (final) version identifier for a given proposal; other routines such as GET_PERIOD_TOTAL call it to ensure budget figures are drawn from the correct version. Accessor functions include GET_PROPOSAL_ID, GET_PERIOD_ID, GET_VERSION_ID (returning the package globals), and GET_CATEGORY (returning a budget category description based on a category code and proposal form number).

• CREATE_REPORTING_DATA — assembles the reporting data set for a proposal.
• CREATE_ITEMIZED_BUDGET — builds the itemized budget output for a report.
• CREATE_BASE_RATE — produces base-rate information used in budget reporting.
• CREATE_BUDGET_JUSTIFICATION — generates budget justification text.
• DUMP_JUSTIFICATION — outputs justification content for a report run.
• CREATE_Q_EXPLANATION — constructs explanatory text for questions.
• GET_PERIOD_TOTAL — returns period total direct cost for a category and period.
• GET_ABSTRACT — retrieves proposal abstract text.
• GET_ANSWER, GET_RESPONSE, GET_EXPLANATION — return question/response data.
• GET_SUBJECTS — returns subject information for the proposal.
• GET_PROPOSAL_ROLE, GET_JOB_NAME, GET_PHONE_NUMBER — return person, role, and contact attributes.

Tables Accessed

The package reads and writes through APPS synonyms. Budget and rate data come from IGW_REPORT_BUDGET, IGW_REPORT_BUDGET_BASE_RATE, IGW_REPORT_BUDGET_SEED, IGW_BUDGETS, IGW_BUDGET_DETAILS_CAL_AMTS, IGW_BUDGET_PERIODS, and IGW_RATE_CLASSES. Question and response content draws on IGW_ORG_QUESTIONS, IGW_ORG_TYPES, IGW_PROP_QUESTIONS, IGW_PROP_PERSON_QUESTIONS, and IGW_PROP_ABSTRACTS. Personnel information is sourced from IGW_PERSON_DEGREES, IGW_PROP_PERSON_DEGREES, and HZ_PARTIES, which supplies party/contact details for proposal personnel.

Usage Notes

IGW_REPORT_PROCESSING is invoked from IGW forms (such as the budget category hierarchy setup form), from concurrent report programs that render proposal and budget output, and from custom code that requires consistent proposal/version resolution. Because it depends on package globals, callers must ensure G_PROPOSAL_ID and related context are initialized before calling dependent functions such as GET_PERIOD_TOTAL or GET_FINAL_VERSION.