Search Results get_expense_line

Overview

PO_SERVICES_PVT is a private (PVT) PL/SQL package in the APPS schema that encapsulates business logic for Oracle Purchasing service-related documents. Its responsibilities center on the handling of rate-based, expense, and contractor service lines within purchase orders and requisitions. The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling session rather than the defining schema owner. The version marker in the source header (POXVSVCS.pls 115.9, dated 2004) reflects its long-standing role in the purchasing services codebase, and it is a 12.1.1-era object that remains present in 12.2.2.

Functionally, PO_SERVICES_PVT supports the distinction between labor, expense, and rate-based service lines in Oracle Purchasing. It provides helper routines that other purchasing packages, forms, and workflows use to determine line characteristics, resolve parent/child relationships between labor and expense lines, validate ship-to organizations against jobs, and retrieve aggregated monetary amounts on a purchase order line. The package also includes mechanics for managing the linkage between purchase order service lines and their originating requisitions, including functionality related to FPS (Fixed Price Services) lines.

Key Procedures and Functions

The documented API surface comprises 14 procedures and functions:

• ALLOW_PRICE_OVERRIDE — determines whether a price override is permitted for a given purchase order line.
• GET_AP_COMPATIBILITY_FLAG — returns a flag indicating Payables compatibility, introduced under a bug fix.
• GET_CONTRACTOR_STATUS — returns the contractor status associated with a requisition line.
• GET_EXPENSE_LINE — resolves the expense line linked to a parent line, returning its identifier and line number.
• GET_JOB_LONG_DESCRIPTION — returns the long description of a job for a requisition line.
• GET_JOB_NAME — returns the job name for a given job identifier.
• GET_LABOR_REQ_LINE — resolves the parent (labor) requisition line for a supplied expense line, returning parent line identifier and number.
• IS_EXPENSE_LINE — indicates whether a requisition line is an expense line.
• IS_RATE_BASED_LINE — indicates whether a purchase order line is rate-based.
• VALIDATE_SHIP_TO_ORG — validates a ship-to organization in the context of a job.
• GET_PO_AMOUNTS — retrieves amount received and amount billed for a purchase order line.
• CHECK_PO_HAS_SVC_LINE_WITH_REQ — indicates whether a purchase order contains a service line linked to a requisition.
• IS_FPS_PO_LINE_WITH_REQ — identifies FPS purchase order lines tied to a requisition.
• IS_FPS_PO_SHIPMENT_WITH_REQ — identifies FPS purchase order shipments tied to a requisition.

Tables Accessed

Through APPS synonyms the package references PO_LINES_ALL, PO_LINE_LOCATIONS_ALL, and PO_DISTRIBUTIONS_ALL to inspect purchase order lines, shipments, and distributions for rate-based, expense, and FPS attributes and amount calculations. PO_REQUISITION_LINES_ALL supplies requisition-side data for expense and labor line resolution. PER_JOBS and HR_ALL_ORGANIZATION_UNITS support job descriptions and ship-to organization validation. MTL_PARAMETERS and FND_PRODUCT_INSTALLATIONS are referenced for inventory and installation context.

Usage Notes

As a PVT package, PO_SERVICES_PVT is not intended for direct customer invocation; it is called internally by purchasing forms, concurrent programs, and other purchasing PL/SQL packages (seven referencing packages are documented). Customizations should prefer the public PO_* APIs. Note also that the search term "system and services pvt ltd address in kolkata" is unrelated to this database object; "PVT" here denotes "private" package scope, not a company name.