Search Results get_grace_period

Overview

AP_WEB_EXPENSE_FORM is a PL/SQL package owned by the APPS schema that supports the Oracle E-Business Suite Internet Expenses (OIE) module, specifically the Oracle Application Framework (OAF) based expense report entry form commonly referred to as the "Expense Report" or Web Expenses page. The package encapsulates server-side logic that governs the behavior of the expense report entry form, providing the application tier functions needed to evaluate policy compliance, validate employee status, and control editing and submission windows tied to expense reporting periods. In Oracle EBS 12.1.1 and 12.2.2 environments, this package is classified as a non-public, internal API (API classification OTHER), meaning it is not intended as a published integration interface but rather as an internal support package for the seeded Expenses application.

The package is a VALID object in the APPS schema and sits within the dependency chain of the Internet Expenses schema objects, most notably AP_EXPENSE_REPORT_HEADERS_V, a view that exposes expense report header information used throughout the Expenses UI and reporting layers.

Key Procedures and Functions

The documented package exposes five procedures and functions. Their names indicate the following purposes:

• GET_POST_QUERY_VALUES — Returns values used after a query operation on the expense form, typically supplying derived or context-dependent data required to render the form correctly once expense report records have been retrieved.
• GET_NUM_VIOLATION_LINES — Returns the count of expense report lines that violate an active expense policy, enabling the form to indicate how many individual lines are non-compliant.
• GET_NUM_TOTAL_VIOLATIONS — Returns the aggregate number of policy violations associated with an expense report, supporting summary-level display and validation of policy adherence before submission.
• IS_EMPLOYEE_ACTIVE — Determines whether a given employee is active, used to validate that the expense report owner or related party holds a valid, active employee assignment.
• GET_GRACE_PERIOD — Retrieves the applicable grace period, typically governing how long after a period end an expense report may still be entered or modified without triggering late-submission handling.

Parameter lists are not documented and should not be assumed.

Tables Accessed

The package references the following tables through APPS synonyms:

• AP_EXPENSE_REPORT_LINES / AP_EXPENSE_REPORT_LINES_ALL — Expense report line detail, used to evaluate line-level policy compliance and count violating lines.
• AP_EXPENSE_REPORT_PARAMS — Expense report parameters that define reporting period and processing attributes relevant to grace period and validation logic.
• AP_POL_VIOLATIONS / AP_POL_VIOLATIONS_ALL — Stored policy violation records generated when expense lines breach active expense policies; these underpin the violation count functions.

Usage Notes

AP_WEB_EXPENSE_FORM is invoked indirectly by the Internet Expenses OAF pages and by dependent objects such as AP_EXPENSE_REPORT_HEADERS_V. It is referenced by one other package, and the package itself appears in the dependency listing alongside STANDARD. Because it is an internal, non-public package, it is not documented as a supported integration API and should not be called directly from custom code unless the calling logic is prepared to accommodate changes across patch levels. Customers requiring policy violation or employee status checks in custom extensions should prefer documented public APIs where available. The package is primarily relevant during expense report entry, validation, and submission, where policy compliance counts and grace period checks determine whether a report may be saved or submitted.