Search Results get_rule_attributes

Overview

APPS.PA_CC_TRANSFER_PRICE is a PL/SQL package body in Oracle EBS Projects (PA) that supports cross-charge and transfer pricing processing. Transfer pricing determines the amount at which costs or services are transferred between provider and receiver organizations, typically within the same business group or across legal entities. The package encapsulates the logic required to calculate transfer prices for expenditure items, resolve the applicable pricing rules, and derive the base amount, burden amount, and ultimately the transfer price amount posted against a receiver organization. The header comment references "Org Forecasting," and several global variables and procedures are scoped to organizational forecasting scenarios. The package declares module-level globals for provider organization, business group, legal entity, accounting currency, default rate type, rate date code, processed-through date, and array sizing, along with WHO audit columns. It also resolves a cross-business-group profile via PA_CROSS_BUSINESS_GRP and reads the PA_DEBUG_MODE profile for diagnostics. The package is classified as OTHER and is referenced by four other packages, indicating it is a shared internal utility rather than a standalone public API.

Key Procedures and Functions

The package exposes 21 documented procedures and functions. GET_TRANSFER_PRICE is the central entry point, accepting a module name and array-based parameters for provider, receiver, expenditure, and related identifiers; it orchestrates the overall pricing flow. GET_PROVIDER_ATTRIBUTES retrieves attributes of the provider organization, while GET_BUSINESS_GROUP and GET_LEGAL_ENTITY resolve organizational and legal context. SET_GLOBAL_VARIABLES populates the package-level globals, and INIT_WHO_COLS initializes the WHO audit columns. VALIDATE_ARRAY performs array-level validation of the inbound ID tables.

Schedule-line logic is handled by GET_SCHEDULE_LINE, GET_SCHEDULE_LINE_FROM_LOOKUP, DETERMINE_SCHEDULE_LINE, INSERT_SCHEDULE_LINE_INTO_LKP, and GET_SCHEDULE_LINE_ATTRIBUTES, which together select or create transfer price schedule lines and their attributes. GET_RULE_ATTRIBUTES resolves the attributes of the pricing rule applicable to a given transfer, and is the object most relevant to the "get_rule_attributes" search. SET_BASE_AMOUNT_AND_FLAG establishes the base amount and its associated indicator. DETERMINE_TRANSFER_PRICE drives determination of the final price, supported by GET_BASIS_AMOUNT, GET_BURDEN_AMOUNT, and GET_BURDENING_DETAILS, which compute the corresponding components. GET_TRANSFER_PRICE_AMOUNT returns the computed pricing amount, and GET_INITIAL_TRANSFER_PRICE derives the starting price used as input to further determination.

Tables Accessed

The package reads and writes several core Projects tables through APPS synonyms. PA_CC_TP_SCHEDULE_LINES and PA_CC_TP_SCHEDULE_LINE_LKP store and look up transfer price schedule lines; PA_CC_DIST_LINES_ALL holds cross-charge distribution lines. PA_EXPENDITURE_ITEMS_ALL and PA_EXPENDITURE_TYPES supply the expenditure items and types being priced. PA_CUST_REV_DIST_LINES_ALL holds customer revenue distributions relevant to pricing. PA_PROJECT_ASSIGNMENTS, HR_ORGANIZATION_INFORMATION, FND_CURRENCIES, and GL_DAILY_CONVERSION_TYPES provide organizational assignment, currency, and rate-type reference data. Forecasting-related tables PA_FORECASTING_OPTIONS, PA_FORECASTING_OPTIONS_ALL, and PA_FORECAST_ITEMS support the organizational forecasting extensions noted in the header, and PA_IMPLEMENTATIONS with PA_IMPLEMENTATIONS_ALL supply implementation configuration.

Usage Notes

PA_CC_TRANSFER_PRICE is invoked internally by the Projects applications, particularly cross-charge and transfer pricing processes, and by four other packages that depend on its procedures. Calls are typically made from concurrent programs and forms that process expenditure items requiring transfer pricing, or from custom code extending cross-charge functionality. Because it is classified as OTHER rather than a standard public API, direct custom invocation should be approached cautiously, with attention to the array-based parameter conventions and the global variables initialized by SET_GLOBAL_VARIABLES. The PA_DEBUG_MODE profile enables diagnostic output during testing. Any modification should follow Oracle's support guidelines for the 12.1.1 and 12.2.2 releases.