Search Results igw_prop_map_stops




Overview
Explore in AI Chat

Overview

The IGW_PROP_MAP_STOPS table is a core data object within the Oracle E-Business Suite (EBS) Grants Proposal module (IGW). It functions as a junction table that defines the approval and notification workflow for grant proposals. Specifically, it stores the mapping between a proposal's approval routing map and the individual personnel designated as approvers or notification recipients at each stage, or "stop," in the approval hierarchy. This table is critical for enforcing the business rules of the proposal submission and approval process in releases 12.1.1 and 12.2.2, ensuring that the correct users are tasked with reviewing proposals and are alerted to actions required on them.

Key Information Stored

The table's structure centers on three primary columns that together form its composite primary key. The PROP_MAP_ID column is a foreign key that links the record to a specific approval map definition in the IGW_PROP_MAPS table. The STOP_ID identifies the sequential position or level within that approval map's hierarchy. The USER_NAME column stores the identifier (typically the EBS username) of the individual assigned to that specific stop. This design allows for a flexible approval structure where multiple users can be assigned to a single approval level, and a single user can be associated with multiple stops across different proposal maps.

Common Use Cases and Queries

The primary use case is the management and reporting of proposal approval workflows. System administrators or grant managers may query this table to audit approval chains, identify bottlenecks, or verify user assignments. A common reporting requirement is to list all approvers for a specific proposal. This typically involves joining through IGW_PROP_MAPS to the main proposal header table. For example, to find all users in the approval path for a proposal map named 'STANDARD_MAP', one might use a query such as:

  • SELECT stop_id, user_name FROM igw_prop_map_stops WHERE prop_map_id = (SELECT prop_map_id FROM igw_prop_maps WHERE map_name = 'STANDARD_MAP') ORDER BY stop_id;

Another frequent operation is validating user permissions by checking if a given username exists in any stop for a proposal's active approval map.

Related Objects

IGW_PROP_MAP_STOPS has a direct and essential relationship with the IGW_PROP_MAPS table, which defines the overarching approval map template. The relationship is enforced by a foreign key constraint where the PROP_MAP_ID column in IGW_PROP_MAP_STOPS references the primary key of IGW_PROP_MAPS. This table is a child of IGW_PROP_MAPS; each record in IGW_PROP_MAP_STOPS must correspond to a valid, existing approval map. While not listed in the provided metadata, this table is logically connected to the core proposal tables (such as IGW_PROPOSALS) via its parent table, IGW_PROP_MAPS, which is assigned to proposals. It is also a foundational table for the approval workflow engine within the Grants Proposal module.