Search Results g_proposal_form_number
Overview
IGW_REPORT_PROCESSING is an APPS-owned PL/SQL package within the Oracle E-Business Suite Grants Management (IGW) schema. Its status is documented as VALID in the ETRM metadata for EBS 12.1.1 and 12.2.2. The package serves as a central processing and data-access layer for grant proposal reports and organizational/proposal budget reporting. It combines procedural business logic — assembling reporting data, calculating budget figures and justifications, resolving version and period context — with a family of getter functions that expose proposal, question, and respondent attributes to dependent views and packages. The package is classified as OTHER in the API classification scheme, indicating it is an internal, non-public API primarily intended for use by IGW application components rather than external integrations.
Key Procedures and Functions
The ETRM metadata records 23 documented procedures and functions that fall into several functional groupings.
- Reporting and budget construction: CREATE_REPORTING_DATA assembles the core reporting record set. CREATE_ITEMIZED_BUDGET, CREATE_BASE_RATE, and CREATE_BUDGET_JUSTIFICATION build budget line detail, base-rate data, and narrative justification content respectively. DUMP_JUSTIFICATION outputs or purges justification data, and CREATE_Q_EXPLANATION constructs question explanation text.
- Version, period, and proposal resolution: GET_FINAL_VERSION, GET_VERSION_ID, GET_PERIOD_ID, GET_PERIOD_TOTAL, and GET_PROPOSAL_ID resolve the correct version, period, and proposal context, including aggregate period totals.
- Attribute getters: GET_PROPOSAL_ROLE, GET_CATEGORY, GET_ABSTRACT, GET_ANSWER, GET_RESPONSE, GET_EXPLANATION, GET_SUBJECTS, GET_JOB_NAME, and GET_PHONE_NUMBER return individual proposal, respondent, question, and contact attributes.
No parameter lists are documented in the ETRM extract; the procedure and function names above are reproduced exactly as recorded.
Tables Accessed
The package reads and writes IGW tables through APPS synonyms. Proposal and respondent content is drawn from IGW_PROP_ABSTRACTS, IGW_PROP_QUESTIONS, IGW_PROP_PERSON_QUESTIONS, IGW_PROP_PERSON_DEGREES, and IGW_PERSON_DEGREES. Organizational question and type definitions come from IGW_ORG_QUESTIONS and IGW_ORG_TYPES. Budget processing uses IGW_BUDGETS, IGW_BUDGET_PERIODS, IGW_BUDGET_DETAILS_CAL_AMTS, IGW_RATE_CLASSES, and the reporting-specific tables IGW_REPORT_BUDGET, IGW_REPORT_BUDGET_BASE_RATE, and IGW_REPORT_BUDGET_SEED. Party identity data, such as names and contact attributes used by the getter functions, is sourced from HZ_PARTIES.
Usage Notes
IGW_REPORT_PROCESSING is an internal dependency of the IGW reporting presentation layer. It is referenced by the views IGW_ADMIN_OFFICIAL_V, IGW_ORGANIZATION_TYPES_V, IGW_PI_V, IGW_PRPO_HEADERS_V, IGW_PRPO_PROP_PERSONS_V, IGW_PRPO_SUBJECT_INFO_V, IGW_REPORT_BUDGET_V, IGW_REPORT_BUDGET_PERSONNEL_V, and IGW_SIGNING_OFFICIAL_V, and by the IGW_EDI_PROCESSING package, with 10 dependent packages reported in total. These dependencies confirm that the package is invoked during grant report rendering, proposal printing, and electronic data interchange processing rather than through direct end-user submission. Because the metadata classifies the package as OTHER and it is not a documented public API, customizations should avoid calling it directly where a supported API exists; direct invocation risks breakage on patching. Its only documented external dependencies are SYS.STANDARD, reinforcing that it is a self-contained PL/SQL unit in the APPS schema.