Search Results populate_prof_mat_req




Overview
Explore in AI Chat

Overview

APPS.AHL_RA_NR_PROFILE_PVT is a private PL/SQL package within the Oracle Enterprise Asset Management (eAM) and Complex Maintenance, Repair, and Overhaul (CMRO) module of Oracle E-Business Suite. It supports the Nonroutine Resource Authorization (RA) profile functionality, which governs how nonroutine maintenance work — tasks that are not captured on a standard preventive maintenance schedule — is profiled, estimated, and authorized. The package is declared with AUTHID CURRENT_USER, meaning its database object privileges and synonym resolution are evaluated against the calling schema rather than the APPS schema. The header comment references the source file AHLVNRPS.pls, version 120.0.12020000.2, dated 2012/12/07, indicating a maintenance release consistent with the 12.2.2 code line.

The package's central role is to assemble and process the header and detail structures representing a nonroutine profile. The type declarations nr_prof_header_rec_type and nr_prof_est_rec_type model the profile header and its associated resource and material estimates respectively, including inventory item identification, unit of measure, CMRO resource attributes, analysis and required quantities, fleet and operating organization context, and a DML_OPERATION flag that indicates whether a given row is to be inserted, updated, or deleted.

Key Procedures and Functions

The package exposes six documented programs, each concerned with a distinct stage of the nonroutine profiling workflow:

  • POPULATE_PROF_RES_REQ — Populates the resource requirement lines of a nonroutine profile, using the resource-oriented record structure populated from CMRO resource attributes.
  • POPULATE_PROF_MAT_REQ — Populates the material requirement lines of a nonroutine profile, working with inventory item and unit-of-measure data.
  • PROCESS_NR_PROFILE — The primary driving routine that processes a nonroutine profile, iterating over header and detail records and applying the indicated DML operations.
  • ADD_DETAILS_TO_PROF — Adds detail rows to an existing nonroutine profile header.
  • GET_RESOURCE_TYPE — Returns the resource type for a given resource. The package-level constant G_RESOURCE (value 'R') corresponds to this classification.
  • GET_ITEM_TYPE — Returns the type classification for a given item. The companion constant G_ITEM (value 'I') corresponds to this classification.

The two constants G_RESOURCE and G_ITEM act as the discriminator values that distinguish resource-type lines from item-type lines throughout the profiling logic, and this distinction is what the user search term "g_resource" refers to.

Tables Accessed

The package operates against the core nonroutine profile and CMRO tables: AHL_NR_PROFILE_HEADERS and its _S security synonym counterpart, AHL_NR_PROFILE_DETAILS and AHL_NR_PROFILE_DETAIL_S, plus AHL_RESOURCES for resource definition data. Maintenance context is drawn from AHL_MR_HEADERS_B and AHL_FLEET_HEADERS_B for fleet association, and from AHL_SIMULATION_PLANS_B, AHL_UE_SIMULATIONS, and AHL_UNIT_EFFECTIVITIES_B for unit effectiveness and simulation relationships. Inventory items are resolved through MTL_SYSTEM_ITEMS_KFV and their descriptions via PLITBLM. Organizational context is supplied by HR_ALL_ORGANIZATION_UNITS and operating organization identifiers held on the profile records. These references are made through APPS synonyms.

Usage Notes

As a PVT (private) package, AHL_RA_NR_PROFILE_PVT is not a public API intended for direct customer invocation. It is referenced by four other packages and is invoked internally by the nonroutine resource authorization forms in the eAM/CMRO application when a user saves, submits, or processes a nonroutine profile. Custom code and extensions should avoid calling this package directly, since private packages are subject to change without notice between patch levels. Developers integrating with nonroutine profiling should instead use the supported public APIs and base views on the AHL_NR_PROFILE_HEADERS and AHL_NR_PROFILE_DETAILS tables for read access.