Results for “apply_oh_setup_rates”

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

Overview

IGW_BUDGETS_V is an Oracle E-Business Suite view owned by the APPS schema within the IGW (Grants Proposal) application module. The ETRM metadata for this object carries the description "10SC Only," indicating that the view is relevant to the ten-character (10SC) configuration of the Grants Proposal module rather than the alternate multi-organization variant. Because Grants Proposal supports both pre-award budgeting activities (proposal development, cost estimation, and approval) and integration into downstream award and financial processes, this view supplies a denormalized, security-filtered read layer over the core budget tables.

The view consolidates descriptive information from the base budget entity with human-readable rate class descriptions, lookup meanings for the budget type code, and runtime security predicates. Rather than exposing raw column values alone, IGW_BUDGETS_V translates coded identifiers (OH_RATE_CLASS_ID, BUDGET_TYPE_CODE) into meaningful text and embeds row-level security checks for create and modify privileges. This makes it the preferred access point for reports, concurrent programs, and integrations that must both display and enforce security on budget data.

Underlying Base Objects

The view is defined over three documented objects:

• IGW_BUDGETS PB — the primary table supplying all budget-level attributes, including proposal and version identifiers, cost components, flags, and DFF attributes.
• IGW_RATE_CLASSES PRC — joined on PB.OH_RATE_CLASS_ID = PRC.RATE_CLASS_ID to retrieve the OH_RATE_CLASS description.
• IGW_LOOKUPS_V IL — joined on PB.BUDGET_TYPE_CODE = IL.LOOKUP_CODE with IL.LOOKUP_TYPE = 'IGW_BUDGET_TYPES', supplying the translated budget type meaning.

Two security functions are invoked inline: IGW_SECURITY.ALLOW_CREATE('BUDGET', PROPOSAL_ID, FND_GLOBAL.USER_ID) and IGW_SECURITY.ALLOW_MODIFY('BUDGET', PROPOSAL_ID, FND_GLOBAL.USER_ID). These evaluate the current FND user against the proposal to expose create/modify authority. As a view, IGW_BUDGETS_V maintains no storage of its own; it inherits the underlying tables' DML-restricting behavior and depends on those tables' validity.

Key Columns

• ROW_ID — pseudo-column from IGW_BUDGETS.ROWID, used for direct row addressing.
• PROPOSAL_ID, VERSION_ID — identify the proposal and specific budget version.
• START_DATE, END_DATE — budget period boundaries.
• TOTAL_COST, TOTAL_DIRECT_COST, TOTAL_INDIRECT_COST — aggregate cost figures.
• COST_SHARING_AMOUNT, UNDERRECOVERY_AMOUNT, RESIDUAL_FUNDS, TOTAL_COST_LIMIT — financial adjustment and ceiling amounts.
• APPLY_INFLATION_SETUP_RATES, APPLY_EB_SETUP_RATES, APPLY_OH_SETUP_RATES — flags governing which setup rates are applied when the budget is generated.
• ENTER_BUDGET_AT_PERIOD_LEVEL, FINAL_VERSION_FLAG — behavioral and status indicators.
• OH_RATE_CLASS, BUDGET_TYPE — decoded descriptive text from the joined tables.
• ALLOW_CREATE / ALLOW_MODIFY — security-derived values from IGW_SECURITY.
• ATTRIBUTE_CATEGORY, ATTRIBUTE1–15 — descriptive flexfield columns.
• Creation/update audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical consumers query this view to display budget summaries in Grants Proposal forms and reports, to enforce security during programmatic access, and to feed interfaces that require decoded budget type and rate class values.

SELECT proposal_id, version_id, total_cost, budget_type,
       apply_inflation_setup_rates, apply_eb_setup_rates, apply_oh_setup_rates
FROM   igw_budgets_v
WHERE  proposal_id = :p_proposal_id
AND    final_version_flag = 'Y';

SELECT b.proposal_id, b.version_id, b.budget_type,
       b.oh_rate_class, b.total_cost
FROM   igw_budgets_v b
WHERE  b.apply_inflation_setup_rates = 'Y'
AND    b.allow_modify = 'Y';

The APPLY_INFLATION_SETUP_RATES column is directly relevant to rate-generation logic, allowing report authors to identify budgets configured to apply inflation setup rates rather than escalation or overhead rates.