Results for “ams_actresource_pub”
42 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.AMS_ACTRESOURCE_PUB is a public PL/SQL API package within the Oracle E-Business Suite Advanced Marketing (AMS) module. It provides a programmatic interface for managing activity resource records — the associations that link resources (such as employees, partners, or assets) to marketing activities. The package encapsulates the business logic required to create, maintain, lock, and validate these associations so that they remain consistent with the underlying AMS data model.
The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking session rather than the definer. Its header carries the source control identifier amsprscs.pls 115.3, dated December 2002, and the package was originally authored in March 2002. As a PUB-classified API, it is intended for supported external invocation by forms, concurrent programs, and custom extensions rather than for internal use only.
Key Procedures and Functions
The package exposes five documented procedures, each corresponding to a standard lifecycle operation on an activity resource record:
- CREATE_ACT_RESOURCE — Inserts a new activity resource association. It accepts the full activity resource record structure, including identifiers, status codes, date ranges, the primary flag, descriptive fields, and the DFF attribute columns.
- UPDATE_ACT_RESOURCE — Modifies an existing activity resource record. This is the procedure referenced by the search term "update_act_resource", and it is the standard supported entry point for changing an activity resource association.
- DELETE_ACT_RESOURCE — Removes an activity resource association from the system.
- LOCK_ACT_RESOURCE — Obtains a lock on an activity resource record, typically to serialize concurrent modifications before an update or delete.
- VALIDATE_ACT_RESOURCE — Performs validation of an activity resource record, enforcing the required business rules prior to committing changes.
The package also defines the record type Act_Resource_rec_type, an automatically generated structure mirroring all columns of the underlying activity resource table. It includes primary key and audit columns (row_id, activity_resource_id, last_update_date, last_updated_by, creation_date, created_by, last_update_login, object_version_number), foreign key and reference columns (act_resource_used_by_id, arc_act_resource_used_by, resource_id, role_cd), status and scheduling columns (user_status_id, system_status_code, start_date_time, end_date_time, primary_flag), a description field, and the standard DFF columns attribute_category and attribute1 through attribute15.
Tables Accessed
The package operates against the AMS activity resource base table through APPS synonyms. The record type enumerates the table's columns, and the API procedures read and write those columns directly. The primary table stores one row per resource-to-activity association, keyed by activity_resource_id and qualified by resource_id, role_cd, and the act_resource_used_by reference. Audit columns (WHO columns and object_version_number) are populated by the API to support row versioning and concurrency control, while the attribute columns support descriptive flexfield capture. The package also references standard AMS lookup and status tables indirectly through user_status_id and system_status_code.
Usage Notes
AMS_ACTRESOURCE_PUB is typically invoked from Oracle Forms within the Advanced Marketing application, from concurrent programs that bulk-maintain activity resources, and from custom PL/SQL extensions that need to modify resource associations in a supported manner. Custom code should call UPDATE_ACT_RESOURCE rather than performing direct DML, since the API enforces validation rules, maintains audit columns, increments object_version_number, and prevents orphaned or inconsistent associations. Because referenced by three other packages, it also serves as a building block for higher-level marketing APIs. The constant G_DEFAULT_NUM_REC_FETCH (30) indicates the package uses a fetch-batch convention when processing record sets. Callers should invoke LOCK_ACT_RESOURCE before UPDATE_ACT_RESOURCE or DELETE_ACT_RESOURCE in concurrent environments, and should follow the API's commit and rollback responsibility conventions.
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2