Search Results pqp_check_rates_table
Overview
PQP_CAR_MILEAGE_FUNCTIONS is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified as an OTHER-type API within the ETRM repository. It provides the core computational and configuration engine that supports car mileage and vehicle-related expense claims processed through Oracle Payroll and the expense claim infrastructure. The package encapsulates the business rules that determine legislated mileage rates, vehicle attributes, and prorated or capped reimbursement amounts based on the assignment, business group, and payroll action context in which a claim is submitted.
A notable internal element is the r_ses_date record type and t_ses_date collection, which store assignment identifiers alongside session start and end indexes and dates. These structures support the iterative evaluation of mileage claims across multiple periods of service, allowing the package to segment a claim into legally valid date windows. The presence of session-scoped variables such as ses_start and ses_end further reinforces the package's role in managing date-bounded rate lookups.
Key Procedures and Functions
- GET_LEGISLATION_CODE — Returns the legislation code applicable to a given business group, driving which rate tables and tax rules apply.
- PQP_GET_RANGE — Retrieves low and high threshold values for a rate band, using assignment, payroll action, claim date, and a specified table/row/column context.
- GET_CONFIG_INFO — Returns configuration metadata for a business group based on a requested information type.
- PQP_GET_ATTR_VAL — Extracts vehicle attribute values for a car type, including engine capacity, rates table, calculation method, fuel type, and error messaging.
- PQP_GET_PERIOD, PQP_GET_VEH_CC, PQP_GET_YEAR — Derive claim period, vehicle engine displacement, and the applicable rate year respectively.
- PQP_MULTIPLE_ASG — Determines whether multiple assignments affect the claim calculation.
- PQP_GET_TABLE_VALUE, PQP_CHECK_RATES_TABLE, PQP_VALIDATE_DATE — Support lookup of configured table values, validation of rate tables, and date eligibility checks.
- MAX_LIMIT_CALC, PQP_PRORATE_CALC — Perform the ceiling and proportional reduction calculations central to mileage reimbursement.
- PQP_GET_TAXNI_RATES, PQP_GET_ADDLPASG_RATE, PQP_GET_PASSENGER_RATE, GET_RATES_TABLE — Return the specific rate figures for tax/NI treatment, additional passengers, and the master rates table.
- PQP_GET_DATE_PAID, PQP_GET_ELE_ENDATE, PQP_IS_EMP_TERM — Supply payment dates, element end dates, and employee termination status, which affect claim validity.
Tables Accessed
The package reads and writes across payroll and HR reference data. PAY_USER_TABLES, PAY_USER_COLUMNS, PAY_USER_ROWS_F, and PAY_USER_COLUMN_INSTANCES_F provide the configurable user-defined rate tables that hold mileage bands and vehicle classifications. FND_TABLES and FND_LOOKUP_VALUES supply metadata and lookup definitions. Assignment and payroll context come from PER_PERIODS_OF_SERVICE, PAY_ASSIGNMENT_ACTIONS, and PAY_PAYROLL_ACTIONS. Element and result data are drawn from PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, PAY_ELEMENT_TYPES_F, PAY_ELEMENT_TYPE_EXTRA_INFO, PAY_INPUT_VALUES_F, and PAY_RUN_RESULTS.
Usage Notes
PQP_CAR_MILEAGE_FUNCTIONS is referenced by four other packages and is typically invoked from Oracle Payroll element processing and the car mileage claim forms rather than being called directly by end users. The search term "get_vehicle_type" relates to the vehicle classification logic embodied in functions such as PQP_GET_ATTR_VAL and PQP_GET_VEH_CC, which together resolve vehicle type characteristics for rate selection. Custom code should call these functions using the documented parameter signatures and treat OUT parameters such as p_error_msg as authoritative error indicators.