Results for “get_narrative_status”

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

Overview

The APPS.IGW_PROP package body is a core utility package within the Oracle E-Business Suite Grants and Proposal Management module (IGW). It provides the shared programmatic foundation that supports proposal creation, maintenance, approval routing, and organizational context resolution for the IGW schema. In Oracle EBS 12.1.1 and 12.2.2, the package is validated and serves as a common service layer consumed by a wide range of other IGW packages and objects.

Functionally, IGW_PROP supplies the reusable lookups, identity resolution, and structural manipulation routines that the proposal forms and concurrent processes depend upon. It resolves user names, principal investigator details, business group and organization hierarchy information, and signing official assignments. It also delivers the mechanism for copying an entire proposal—including its associated child records—and for inserting or deleting proposal user-role assignments. In this sense, IGW_PROP acts as the connective tissue between the user interface layer and the underlying IGW proposal tables.

Key Procedures and Functions

The ETRM metadata documents fifteen procedures and functions. Their purposes are as follows:

• GET_BUSINESS_GROUP — Returns the business group context applicable to the current proposal or user session.
• GET_SIGNING_OFFICIAL — Identifies the authorized signing official associated with a proposal or organization.
• GET_ADMIN_OFFICIAL_ID — Resolves the administrator official identifier for a given context.
• GET_USER_NAME — Retrieves the display name of a user from FND_USER or related person records.
• GET_PI_FULL_NAME — Returns the full name of the principal investigator.
• GET_PI_FORMATTED_NAME — Returns the principal investigator name in a formatted, display-ready presentation.
• GET_LOOKUP_MEANING — Resolves a lookup code to its descriptive meaning via FND_LOOKUPS.
• GET_NARRATIVE_STATUS — Determines the current status of a proposal narrative.
• GET_MAJOR_SUBDIVISION — Derives the major subdivision for an organization within the hierarchy.
• IS_PROPOSAL_SIGNING_OFFICIAL — Evaluates whether a given person is the signing official for a proposal.
• GET_TOP_PARENT_ORG_NAME — Returns the name of the top-level parent organization.
• INS_PROP_USER_ROLE — Inserts a user-role assignment record for a proposal.
• DEL_PROP_USER_ROLE — Deletes a proposal user-role assignment.
• COPY_PROPOSAL_ALL — Performs a comprehensive copy of a proposal and its dependent child data.
• SET_COMPONENT_STATUS — Updates the status of a proposal component.

Tables Accessed

The package reads from and writes to a broad set of IGW and shared EBS tables:

• IGW_PROPOSALS_ALL — The master proposal header, central to most operations.
• IGW_PROP_ABSTRACTS, IGW_PROP_NARRATIVES — Proposal textual content and status.
• IGW_PROP_CHECKLIST, IGW_PROP_SPECIAL_REVIEWS — Checklist items and review routing.
• IGW_PROP_LOCATIONS, IGW_PROP_LOCATIONS_S, IGW_PROP_PROGRAM_ADDRESSES — Location and address data.
• IGW_PROP_PERSONS, IGW_PROP_USERS, IGW_PROP_USER_ROLES — Personnel and role assignments.
• IGW_PROP_SCIENCE_CODES — Scientific classification codes.
• IGW_ORG_DETAILS, HR_ALL_ORGANIZATION_UNITS — Organizational hierarchy resolution.
• FND_USER, FND_LOOKUPS, FND_ATTACHED_DOCUMENTS, PER_ALL_PEOPLE_F — Shared EBS foundation data.

Usage Notes

IGW_PROP is invoked primarily through IGW proposal forms and by other IGW packages that require identity, hierarchy, or proposal-copy services. The documented dependency listing confirms it is referenced by several IGW_* packages and by approval-processing logic. Developers extending Grants Management should call these public routines rather than duplicating lookup or copy logic. Because the package operates on APPS synonyms and the FND API stack, it must be called within the standard EBS session context (FND_GLOBAL initialization) to ensure correct business group and user resolution.