Search Results get_instance_details

Overview

APPS.AHL_PRD_NONROUTINE_PUB is a public PL/SQL package body within the Oracle E-Business Suite Product Development (AHL) application module. Its primary business function is to support the creation and processing of non-routine service requests and associated maintenance activities that fall outside standard, pre-defined service workflows. In the context of Oracle EBS 12.1.1 and 12.2.2, this package serves as the public API layer through which external callers—including BPEL-based business process flows, service request interfaces, and other application modules—initiate the generation of non-routine work orders, tasks, and related maintenance records.

The package encapsulates orchestration logic that resolves the invoking user and role context, prepares internal input and output record structures, and delegates the persistence of non-routine service request data to the corresponding private package, AHL_PRD_NONROUTINE_PVT. It also provides logging and diagnostic capabilities through FND_LOG, and initializes Multi-Org and application security context via FND_GLOBAL and MO_GLOBAL.

Key Procedures and Functions

The ETRM metadata documents a single public procedure for this package:

• CREATE_NON_ROUTINE — The principal public entry point for creating a non-routine service request. It accepts the non-routine input record and returns the resulting non-routine output record, coordinating user/role initialization and invoking the underlying private APIs to persist work order, visit, task, and incident data.

In addition to the documented procedure, the package body defines several internal helper procedures and functions that support CREATE_NON_ROUTINE. These include init_user_and_role, which resolves a user name to a user identifier and derives the responsibility from the AHL_BPEL_USER_ROLE profile option, initializing the application session with FND_GLOBAL.apps_initialize. Other helpers—POPULATE_CREATE_SR_INPUT_REC, POPULATE_CREATE_SR_OUTPUT_REC, and POPULATE_CREATE_MTRL_INPUT_REC—transform public record structures into the internal record types required by AHL_PRD_NONROUTINE_PVT. These are not part of the documented public contract but are integral to the procedure's operation.

Tables Accessed

The package and its supporting routines interact with the following documented tables and views, accessed through APPS synonyms:

• AHL_VISITS_B and AHL_VISIT_TASKS_B — store the visit and visit task definitions generated for non-routine service activities.
• AHL_WORKORDERS — holds the work order records created as part of the non-routine maintenance process.
• AHL_UNIT_CONFIG_HEADERS — provides unit configuration data that links service activities to specific maintainable units.
• CSI_ITEM_INSTANCES and MTL_SYSTEM_ITEMS_KFV — supply item instance and item master information required to identify the assets and parts involved.
• CS_INCIDENTS_ALL_B and CS_INCIDENT_STATUSES_B — capture the service request (incident) header and its status transitions.
• FND_LOOKUP_VALUES, FND_USER (via the cursor), and FND_RESPONSIBILITY_VL — provide lookup codes and user/role resolution data.
• WIP_SCHED_RELATIONSHIPS, DUAL, and PLITBLM — support scheduling relationships and PL/SQL table-based processing.

Usage Notes

AHL_PRD_NONROUTINE_PUB is typically invoked from BPEL-based business process workflows and service request processing logic, where the AHL_BPEL_USER_ROLE profile option determines the responsibility under which the API executes. It is also callable from custom PL/SQL code that needs to programmatically create non-routine service requests and their associated visits, tasks, and work orders. Because the package initializes application and Multi-Org context internally, callers should be aware of session state implications when invoking it from within an existing EBS session. The metadata records zero dependent packages referencing this public API, indicating it is primarily a top-level integration entry point rather than a dependency of other shipped packages.