Results for “payment_type_code”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.OE_HEADER_PAYMENT_CL_DEP_ATTR is a dependent attribute package within the Oracle Order Management (OM) module of Oracle E-Business Suite. Its role is to manage and derive dependent attribute values for header-level payment information captured in the Order Management payment workflow. The package name incorporates the "_CL_DEP_ATTR" suffix commonly used in Oracle EBS to denote a class of dependent attribute routines that populate or validate a record's dependent fields based on the selection of a controlling (parent) value. In this case, the controlling structure is the header payment record, represented by the view OE_AK_HEADER_PAYMENTS_V, which exposes payment-related descriptive flexfield attributes.
The package is declared with AUTHID CURRENT_USER and was first shipped under the file header OEXNHPMS.pls (version 115.1, dated 2003/10/20). It is classified as an OTHER API in the ETRM documentation, indicating it is an internal supporting package rather than a public, callable business API. It is referenced by one other package, confirming its role as a utility dependency consumed by higher-level payment processing logic.
Key Procedures and Functions
All six documented procedures operate on a single IN OUT NOCOPY parameter typed against the OE_AK_HEADER_PAYMENTS_V rowtype. NOCOPY passes the record by reference for performance, and the IN OUT mode indicates these routines mutate the record in place, filling dependent attributes. Each procedure corresponds to a specific payment attribute:
- PAYMENT_LEVEL_CODE — Derives or sets the payment level code on the header payment record.
- PAYMENT_TYPE_CODE — Populates the payment type code dependent on the selected payment context.
- PAYMENT_TRX — Handles payment transaction-related attribute values on the header record.
- RECEIPT_METHOD — Resolves the receipt method associated with the payment.
- PAYMENT_COLLECTION_EVENT — Determines the payment collection event attribute.
- CHECK_NUMBER — Sets or validates the check number attribute for the payment.
Each procedure follows the same signature pattern, ensuring a consistent calling convention across all dependent attributes.
Tables Accessed
The ETRM metadata excerpt does not enumerate specific base tables accessed through APPS synonyms. The primary data structure referenced is the view OE_AK_HEADER_PAYMENTS_V, which serves as both the record type source and the working structure for these procedures. This view is part of the AK (Application Kit) descriptive flexfield infrastructure and exposes header payment fields that customer-specific and business-specific dependent attributes are computed against. Any underlying base table reads would be performed through this view rather than directly.
Usage Notes
OE_HEADER_PAYMENT_CL_DEP_ATTR is an internal dependent-attribute package. In Oracle EBS, such packages are typically invoked by the descriptive flexfield runtime or by the AK attribute framework when a controlling segment changes, at which point dependent attributes must be recalculated. Practically, this occurs when an order is entered or modified in the Order Management forms, particularly at the payment step of the order header. The procedures accept the header payment record, mutate the appropriate attribute, and return control to the caller.
Because the package is not a public API, custom code should not call it directly; instead, developers extending Oracle Order Management payment functionality should work through the supported headers and line APIs. The presence of AUTHID CURRENT_USER means it executes with the privileges of the invoking session, so it must be granted appropriately. Given its 2003 origin and 115.1 version, the package is stable and tied to the core order header payment processing flow in both 12.1.1 and 12.2.2.
-
View: ASO_I_PAYMENT_TYPES_V 12.1.1
view gives the various payment types available
APPS.ASO_I_PAYMENT_TYPES_V·↳ ASO_LOOKUPS·Explore ASO module →
-
View: ASO_I_PAYMENT_TYPES_V 12.2.2
view gives the various payment types available
APPS.ASO_I_PAYMENT_TYPES_V·↳ ASO_LOOKUPS·Explore ASO module →
-
View: SO_PAYMENT_TYPES_V 12.1.1
APPS.SO_PAYMENT_TYPES_V·↳ FND_GLOBAL·↳ SO_LOOKUPS·Explore OE module →
-
View: SO_PAYMENT_TYPES_V 12.2.2
APPS.SO_PAYMENT_TYPES_V·↳ FND_GLOBAL·↳ SO_LOOKUPS·Explore OE module →
-
View: OKX_RECEIPT_METHODS_V 12.1.1
Payment Methods for Customer Accounts
APPS.OKX_RECEIPT_METHODS_V·↳ AR_RECEIPT_METHODS·↳ RA_CUST_RECEIPT_METHODS·Explore OKX module →
-
This table stores the name and description for each payment type in different languages
-
View: OKX_RECEIPT_METHODS_V 12.2.2
Payment Methods for Customer Accounts
APPS.OKX_RECEIPT_METHODS_V·↳ AR_RECEIPT_METHODS·↳ RA_CUST_RECEIPT_METHODS·Explore OKX module →
-
APPS.PON_EMD_PAYMENT_TYPES_VL·↳ PON_EMD_PAYMENT_TYPES_ALL·↳ PON_EMD_PAYMENT_TYPES_TL·Explore PON module →
-
View: OKL_BPD_RCPT_MTHDS_UV 12.1.1
APPS.OKL_BPD_RCPT_MTHDS_UV·↳ AR_LOOKUPS·↳ AR_RECEIPT_CLASSES·↳ AR_RECEIPT_METHODS·Explore OKL module →
-
Contract Open Interface Payments Table
-
Contract Open Interface Payments Table
-
View: AST_EV_HIS_PER_V 12.2.2
APPS.AST_EV_HIS_PER_V·↳ AMS_EVENT_OFFERS_VL·↳ AMS_EVENT_REGISTRATIONS·↳ AMS_LOOKUPS·Explore AST module →
-
View: AST_EV_HIS_ORG_V 12.1.1
APPS.AST_EV_HIS_ORG_V·↳ AMS_EVENT_OFFERS_VL·↳ AMS_EVENT_REGISTRATIONS·↳ AMS_LOOKUPS·Explore AST module →
-
View: AST_EV_HIS_PER_V 12.1.1
APPS.AST_EV_HIS_PER_V·↳ AMS_EVENT_OFFERS_VL·↳ AMS_EVENT_REGISTRATIONS·↳ AMS_LOOKUPS·Explore AST module →
-
This contains the details of the payments that are defined on a negotiation for complex services.
-
This table stores the name and description for each payment type in different languages
-
This contains the details of the payments that are defined on a response with complex services. This corresponds to the PON_AUC_PAYMENTS_SHIPMENTS table which defines payments on a negotiation.
-
View: OKL_BPD_RCPT_MTHDS_UV 12.2.2
APPS.OKL_BPD_RCPT_MTHDS_UV·↳ AR_LOOKUPS·↳ AR_RECEIPT_CLASSES·↳ AR_RECEIPT_METHODS·Explore OKL module →
-
This contains the details of the payments that are defined on a response with complex services. This corresponds to the PON_AUC_PAYMENTS_SHIPMENTS table which defines payments on a negotiation.
-
This contains the details of the payments that are defined on a negotiation for complex services.
-
View: AST_EVENT_HISTORY_V 12.1.1
APPS.AST_EVENT_HISTORY_V·↳ AMS_EVENT_OFFERS_VL·↳ AMS_EVENT_REGISTRATIONS·↳ AMS_LOOKUPS·Explore AST module →
-
View: AST_EVENT_HISTORY_V 12.2.2
APPS.AST_EVENT_HISTORY_V·↳ AMS_EVENT_OFFERS_VL·↳ AMS_EVENT_REGISTRATIONS·↳ AMS_LOOKUPS·Explore AST module →
-
View: OE_PAYMENT_TYPES_VL 12.1.1
APPS.OE_PAYMENT_TYPES_VL·↳ OE_PAYMENT_TYPES·↳ OE_PAYMENT_TYPES_TL·Explore ONT module →
-
View: OE_PAYMENT_TYPES_VL 12.2.2
APPS.OE_PAYMENT_TYPES_VL·↳ OE_PAYMENT_TYPES·↳ OE_PAYMENT_TYPES_TL·Explore ONT module →
-
This table holds the mandate information for the bank accounts
-
APPS.OE_AK_HEADER_PAYMENTS_V·↳ OE_PAYMENTS·Explore ONT module →
-
View: OKX_ORDER_HEADERS_V 12.2.2
Order header information
APPS.OKX_ORDER_HEADERS_V·↳ ASO_ORDER_INT·↳ OE_ORDER_HEADERS_ALL·Explore OKX module →
-
View: AST_EV_HIS_ORG_V 12.2.2
APPS.AST_EV_HIS_ORG_V·↳ AMS_EVENT_OFFERS_VL·↳ AMS_EVENT_REGISTRATIONS·↳ AMS_LOOKUPS·Explore AST module →
-
Multiorg table to store different payment types for each Operating Unit
-
View: OEBV_ORDER_HEADERS 12.2.2
BIS View for Order Headers - required for Oracle IT
APPS.OEBV_ORDER_HEADERS·↳ OE_ORDER_HEADERS·Explore ONT module →
-
ASO_PAYMENTS holds payment related information for the quote
-
This view includes all columns from the Oracle Order Management tables and is currently used by Oracle Sales Compensation only.
APPS.ASO_I_OE_ORDER_HEADERS_V·↳ OE_ORDER_HEADERS·Explore ASO module →