Search Results ar_ame_cm_attributes_api

Overview

The APPS.AR_AME_CM_ATTRIBUTES_API package body is a PL/SQL API that supports Oracle Receivables' integration with Oracle Approvals Management (AME). Its specific role is to supply the attribute values that AME requires when routing credit memo (and related adjustment) transactions through an approval workflow. AME evaluates a set of transaction attributes against predefined approval rules; this package extracts those attribute values from the Receivables data model and exposes them so that the Approvals Management engine can determine the correct approval path, approver, and reason for a given credit memo request.

The package is owned by the APPS schema, is documented as VALID, and is classified as an API in the ETRM metadata for EBS 12.1.1 and 12.2.2. It is not referenced by any other database object, indicating that it is invoked at runtime by workflow/AME infrastructure rather than being called by peer packages.

Key Procedures and Functions

The package exposes 28 documented procedures and functions. These are predominantly getter routines that return individual AME transaction attributes. Their purposes fall into several functional groups:

Transaction identifiers: GET_CUSTOMER_TRX_ID, GET_CUSTOMER_ID, GET_BILL_TO_USE_ID, and GET_ORIG_TRX_NUMBER retrieve the credit memo header identity and its related customer and original transaction references.
Customer and bill-to data: GET_CUSTOMER_NAME, GET_BILL_TO_CUSTOMER_NAME, and GET_BILL_TO_CUSTOMER_NUMBER return descriptive customer information used in approval routing and notification.
Collector attributes: GET_COLLECTOR_ID, GET_COLLECTOR_EMPLOYEE_ID, GET_COLLECTOR_NAME, and GET_COLLECTOR_USER_NAME return the assigned collector and associated employee/user details.
Requestor and approver data: GET_REQUESTOR_PERSON_ID, GET_NON_DEFAULT_PERSON_ID, GET_APPROVER_ID, and GET_APPROVER_USER_NAME identify the parties involved in the approval.
Approval context: GET_APPROVAL_PATH and GET_REASON_CODE return the workflow approval routing and the justification associated with the request.
Financial and classification attributes: GET_TRANSACTION_AMOUNT, GET_CURRENCY_CODE, and GET_BATCH_SOURCE_NAME return monetary and categorization values used in AME rule evaluation.

No parameter lists are documented in the supplied metadata; the functions are characterized here only by their documented purpose.

Tables Accessed

The package reads from Receivables, Trading Community, and Workflow tables through APPS synonyms:

RA_CUSTOMER_TRX, RA_CUSTOMER_TRX_LINES, RA_CUST_TRX_TYPES, RA_CM_REQUESTS: source the transaction header, lines, type, and the credit memo approval request record.
AR_COLLECTORS: provides collector identifiers and names.
HZ_CUST_ACCOUNTS, HZ_PARTIES, HZ_CUSTOMER_PROFILES: supply customer account, party, and profile information for the bill-to and requestor attributes.
WF_ITEM_ATTRIBUTE_VALUES and WF_ITEM_ATTRIBUTES: interface with the Oracle Workflow engine to store and retrieve AME transaction attribute values.
FND_APPLICATION: resolves application context.
AR_LOOKUPS: supports lookup-based value resolution.

Usage Notes

This API is invoked automatically during credit memo approval processing, when the AME engine calls the getter functions to populate transaction attributes for rule evaluation. It is not intended for direct invocation by end users or custom code, and the metadata confirms it is not referenced by any other database object. Developers troubleshooting AME approval routing for Receivables credit memos may inspect this package to understand how attribute values are derived and to confirm that the underlying transaction data is correctly populated.

PACKAGE BODY: APPS.AR_AME_CM_ATTRIBUTES_API 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AR_AME_CM_ATTRIBUTES_API, status:VALID,
PACKAGE: APPS.AR_AME_CM_ATTRIBUTES_API 12.1.1
owner:APPS, object_type:PACKAGE, object_name:AR_AME_CM_ATTRIBUTES_API, status:VALID,
PACKAGE BODY: APPS.AR_AME_CM_ATTRIBUTES_API 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AR_AME_CM_ATTRIBUTES_API, status:VALID,
PACKAGE: APPS.AR_AME_CM_ATTRIBUTES_API 12.2.2
owner:APPS, object_type:PACKAGE, object_name:AR_AME_CM_ATTRIBUTES_API, status:VALID,
SYNONYM: APPS.RA_CM_REQUESTS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:RA_CM_REQUESTS, status:VALID,
SYNONYM: APPS.RA_CM_REQUESTS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:RA_CM_REQUESTS, status:VALID,
PACKAGE: APPS.AR_AME_CM_ATTRIBUTES_API 12.2.2
SYNONYM: APPS.AR_COLLECTORS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:AR_COLLECTORS, status:VALID,
SYNONYM: APPS.AR_COLLECTORS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:AR_COLLECTORS, status:VALID,
PACKAGE: APPS.AR_AME_CM_ATTRIBUTES_API 12.1.1
SYNONYM: APPS.WF_ITEM_ATTRIBUTES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:WF_ITEM_ATTRIBUTES, status:VALID,
SYNONYM: APPS.WF_ITEM_ATTRIBUTES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:WF_ITEM_ATTRIBUTES, status:VALID,
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
SYNONYM: APPS.WF_ITEM_ATTRIBUTE_VALUES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:WF_ITEM_ATTRIBUTE_VALUES, status:VALID,
SYNONYM: APPS.WF_ITEM_ATTRIBUTE_VALUES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:WF_ITEM_ATTRIBUTE_VALUES, status:VALID,
SYNONYM: APPS.HZ_CUSTOMER_PROFILES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:HZ_CUSTOMER_PROFILES, status:VALID,
SYNONYM: APPS.HZ_CUSTOMER_PROFILES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:HZ_CUSTOMER_PROFILES, status:VALID,
PACKAGE BODY: APPS.AR_AME_CM_ATTRIBUTES_API 12.1.1
PACKAGE BODY: APPS.AR_AME_CM_ATTRIBUTES_API 12.2.2
SYNONYM: APPS.RA_CUST_TRX_TYPES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:RA_CUST_TRX_TYPES, status:VALID,
APPS.AR_AME_CM_ATTRIBUTES_API dependencies on AR_AME_CM_ATTRIBUTES_API 12.1.1
SYNONYM: APPS.RA_CUSTOMER_TRX_LINES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:RA_CUSTOMER_TRX_LINES, status:VALID,
SYNONYM: APPS.RA_CUSTOMER_TRX_LINES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:RA_CUSTOMER_TRX_LINES, status:VALID,
APPS.AR_AME_CM_ATTRIBUTES_API dependencies on AR_AME_CM_ATTRIBUTES_API 12.2.2
SYNONYM: APPS.RA_CUST_TRX_TYPES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:RA_CUST_TRX_TYPES, status:VALID,
VIEW: APPS.AR_LOOKUPS 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AR.AR_LOOKUPS, object_name:AR_LOOKUPS, status:VALID,
VIEW: APPS.AR_LOOKUPS 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AR.AR_LOOKUPS, object_name:AR_LOOKUPS, status:VALID,
SYNONYM: APPS.RA_CUSTOMER_TRX 12.1.1
owner:APPS, object_type:SYNONYM, object_name:RA_CUSTOMER_TRX, status:VALID,
SYNONYM: APPS.RA_CUSTOMER_TRX 12.2.2
owner:APPS, object_type:SYNONYM, object_name:RA_CUSTOMER_TRX, status:VALID,
SYNONYM: APPS.FND_APPLICATION 12.1.1
owner:APPS, object_type:SYNONYM, object_name:FND_APPLICATION, status:VALID,
APPS.AR_AME_CM_ATTRIBUTES_API dependencies on FND_APPLICATION 12.1.1
APPS.AR_AME_CM_ATTRIBUTES_API dependencies on FND_APPLICATION 12.2.2
SYNONYM: APPS.HZ_CUST_ACCOUNTS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:HZ_CUST_ACCOUNTS, status:VALID,
SYNONYM: APPS.FND_APPLICATION 12.2.2
owner:APPS, object_type:SYNONYM, object_name:FND_APPLICATION, status:VALID,
SYNONYM: APPS.HZ_CUST_ACCOUNTS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:HZ_CUST_ACCOUNTS, status:VALID,
PACKAGE: APPS.WF_ENGINE 12.1.1
owner:APPS, object_type:PACKAGE, object_name:WF_ENGINE, status:VALID,
PACKAGE: APPS.WF_ENGINE 12.2.2
owner:APPS, object_type:PACKAGE, object_name:WF_ENGINE, status:VALID,
SYNONYM: APPS.HZ_PARTIES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:HZ_PARTIES, status:VALID,
SYNONYM: APPS.HZ_PARTIES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:HZ_PARTIES, status:VALID,
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
eTRM - AR Tables and Views 12.1.1
description: Territory information ,
PACKAGE: SYS.STANDARD 12.1.1
owner:SYS, object_type:PACKAGE, object_name:STANDARD, status:VALID,
eTRM - AR Tables and Views 12.1.1
description: Territory information ,