Results for “validate_act_resource_items”

8 results




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

Overview

AMS_ACTRESOURCE_PVT is a private PL/SQL package body in the Oracle Marketing (AMS) module of Oracle E-Business Suite, shipped under the APPS schema. It encapsulates the business logic that governs the association of resources—employees, parties, and related personnel—with marketing activities and their schedules. The package was originally created in 2000 and substantially rewritten in 2002 to shift the role-resource relationship model onto HZ_PARTIES rather than the legacy AMS_JTF_RS_EMP_V view.

The package serves as the internal engine behind the public activity-resource API surface. It enforces referential and temporal validity rules: resources may not be created, updated, or deleted against event schedules that are cancelled, completed, archived, or on hold. Subsequent history entries added validation against event start and end date-time values and against session timing, addressing defects such as Bug 2518686 and Bug 2924115.

Key Procedures and Functions

  • CREATE_ACT_RESOURCE — creates a new activity-resource association for a marketing activity or schedule.
  • UPDATE_ACT_RESOURCE — modifies an existing activity-resource record.
  • DELETE_ACT_RESOURCE — removes an activity-resource association.
  • LOCK_ACT_RESOURCE — obtains a locking handle on the resource record to serialize concurrent maintenance.
  • VALIDATE_ACT_RESOURCE — performs the primary validation of an activity-resource record.
  • VALIDATE_ACT_RESOURCE_ITEMS — validates the individual line-level items attached to the resource record.
  • VALIDATE_ACT_RSC_RECORD — the consolidated record-level validation routine, extended over time to include event and session date-time checks; conditional logic was later simplified per Bug 2924115.
  • INIT_ACT_RSC_RECORD — initializes the activity-resource record structure prior to create or update processing.
  • COMPLETE_ACT_RESOURCE_REC — finalizes the record, marking the resource association as complete.

An internal helper, Check_Resource_Booked, evaluates whether a resource is already booked, accepting a validation mode defaulted to JTF_PLSQL_API.g_create and returning a return status. Debug constants gate diagnostic output using FND_MSG_PUB message levels.

Tables Accessed

  • AMS_ACT_RESOURCES and AMS_ACT_RESOURCES_S — the base and translated/secure activity-resource tables that hold the associations created and maintained by this package.
  • AMS_AGENDAS_B — the agenda base table, consulted to relate resources to scheduled agenda items.
  • AMS_EVENT_OFFERS_ALL_B — the event offers base table, used to validate offers connected with the activity.
  • DUAL — used for lightweight PL/SQL evaluations and single-row selects.

Usage Notes

As a PVT (private) package, AMS_ACTRESOURCE_PVT is not intended for direct invocation by customer extensions. It is called by higher-level public APIs and by the Oracle Marketing forms and concurrent programs that maintain activity resources, and the metadata indicates it is referenced by two other packages. The id_in search term encountered by users most likely corresponds to identifying-key parameters on the validation and CRUD routines, which resolve the activity, resource, or role being processed.

Custom code should invoke the corresponding public API rather than this package. Where the behavior must be understood for troubleshooting—for example when a resource cannot be saved against a completed or on-hold schedule—the validation rules documented here explain the resulting error.