Search Results insert_schedule_line_into_lkp

Overview

PA_CC_TRANSFER_PRICE is an Oracle EBS applications schema package (APPS) that provides the pricing engine for cross-charging and inter-project transfer price calculations within Oracle Projects. The package determines the monetary amount at which costs, expenditures, or burdened amounts are transferred between projects, tasks, or organizational units when cross-charge processing is performed. It is a foundational component of the Oracle Projects cross-charge framework, supplying the transfer price that drives distribution line creation and revenue or cost recognition.

In the EBS 12.1.1 and 12.2.2 releases the package is classified as VALID and is marked under the OTHER API classification, indicating it is primarily an internal engine rather than a fully supported public API. Its dependents confirm its central role: PA_ASSIGNMENTS_PVT, PA_CC_BL_PROCESS, PA_FI_AMT_CALC_PKG, and PA_INVOICE_DETAIL_PROCESS all call into this package to obtain transfer pricing and schedule line information.

Key Procedures and Functions

The documented interface exposes 21 procedures and functions. The principal entry point is GET_TRANSFER_PRICE and its companion DETERMINE_TRANSFER_PRICE, which resolve the applicable transfer price for a given transaction context. GET_INITIAL_TRANSFER_PRICE supports initial price retrieval during setup or first-time processing. GET_TRANSFER_PRICE_AMOUNT returns the resulting monetary value.

Supporting these are amount-resolution routines: GET_BASIS_AMOUNT obtains the underlying basis amount, GET_BURDEN_AMOUNT and GET_BURDENING_DETAILS retrieve burden components, and SET_BASE_AMOUNT_AND_FLAG stores the base amount with an associated indicator.

Scheduling 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 derive, cache, and describe transfer price schedule lines. Context and validation routines include SET_GLOBAL_VARIABLES, VALIDATE_ARRAY, INIT_WHO_COLS, GET_LEGAL_ENTITY, GET_BUSINESS_GROUP, GET_PROVIDER_ATTRIBUTES, and GET_RULE_ATTRIBUTES. These establish the environmental context, WHO audit columns, and rule/provider configuration used during pricing.

Tables Accessed

The package reads and writes through APPS synonyms. Core configuration is drawn from PA_IMPLEMENTATIONS and PA_IMPLEMENTATIONS_ALL. Transfer price scheduling uses PA_CC_TP_SCHEDULE_LINES and PA_CC_TP_SCHEDULE_LINE_LKP. Distribution and cost data come from PA_CC_DIST_LINES_ALL, PA_CUST_REV_DIST_LINES_ALL, PA_EXPENDITURE_ITEMS_ALL, and PA_EXPENDITURE_TYPES. Forecasting context is supplied by PA_FORECASTING_OPTIONS, PA_FORECASTING_OPTIONS_ALL, and PA_FORECAST_ITEMS. Currency conversion references FND_CURRENCIES and GL_DAILY_CONVERSION_TYPES. Assignment and organization context use PA_PROJECT_ASSIGNMENTS and HR_ORGANIZATION_INFORMATION.

Usage Notes

PA_CC_TRANSFER_PRICE is normally invoked indirectly. Cross-charge batch processing (PA_CC_BL_PROCESS), invoice detail processing (PA_INVOICE_DETAIL_PROCESS), amount calculation (PA_FI_AMT_CALC_PKG), and assignment processing (PA_ASSIGNMENTS_PVT) call it programmatically rather than through a dedicated form or concurrent program. Customizations that require transfer pricing should call the documented public entry points such as GET_TRANSFER_PRICE rather than the lower-level helpers, since the package is classified OTHER and internal signatures may change between releases.