Results for “per_employees”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.AP_WEB_DB_SCHLINE_PKG is a PL/SQL package in the Oracle E-Business Suite Payables (AP) module that supports the Oracle Internet Expenses application. It provides the database access layer for retrieving and validating expense schedule line information associated with expense report headers and policy schedule definitions. In Oracle EBS 12.1.1 and 12.2.2, the package is registered in the APPS schema with a status of VALID and is classified as an OTHER API, indicating it is an internal supporting component rather than a published public API.

The package is part of the Internet Expenses workflow integration stack. It is referenced directly by AP_WEB_EXPENSE_WF, the workflow package that drives the Expense Report approval and processing flows. This relationship confirms the package's role in supplying schedule and policy-related data during expense report validation and routing. The package depends on the Oracle policy schedule model, which evaluates expense lines against policy schedules, periods, and options defined at the operating unit level.

Key Procedures and Functions

ETRM documents four procedures and functions within AP_WEB_DB_SCHLINE_PKG. Parameter lists are not published in the metadata, so only their purpose is described.

• GETSCHEDULELINESCURSOR — Returns a cursor (REF CURSOR) that selects the schedule lines applicable to a given expense context. This is typically used to populate the schedule line blocks rendered in the Internet Expenses self-service pages or to drive downstream workflow logic that evaluates expense lines.
• GETSCHHEADERINFO — Retrieves header-level information for a policy schedule. This provides the identifying and descriptive attributes of the schedule header needed by the calling form or workflow process before individual lines are evaluated.
• GETROLEID — Resolves and returns the role identifier relevant to the current user and expense context. In Internet Expenses this supports assignment-based routing and workflow notification targeting, drawing on human resources assignment data.
• GETREQUIREDOPTIONCODE — Determines the required option code applicable to a schedule or expense scenario. This is used to enforce policy schedule options that must be satisfied for a given configuration.

Tables Accessed

The package reads from the policy schedule tables and related HR assignment data through APPS synonyms:

• AP_POL_HEADERS — Stores policy schedule header definitions; supplies the schedule identity and header attributes returned by GETSCHHEADERINFO.
• AP_POL_LINES — Stores individual schedule lines; the primary source for GETSCHEDULELINESCURSOR.
• AP_POL_SCHEDULE_PERIODS — Defines the periods over which schedule lines apply, enabling time-bounded evaluation of expense lines.
• AP_POL_SCHEDULE_OPTIONS — Holds option definitions used to derive required option codes.
• PER_ALL_ASSIGNMENTS_F — The HR assignment table, used in conjunction with GETROLEID to resolve role and assignment context.

Usage Notes

AP_WEB_DB_SCHLINE_PKG is an internal database package and is not intended for direct invocation by customers. It is called from AP_WEB_EXPENSE_WF and from the Internet Expenses OAF/Forms layer when expense schedules and policy schedule lines are queried, validated, or displayed. The package should be treated as a dependent of the Expense workflow and schedule configuration features.

Because it appears in the dependency chain of AP_WEB_EXPENSE_WF, package recompilation or invalidation can affect Expense Report workflows. Administrators troubleshooting expense schedule behavior or workflow errors should verify that AP_WEB_DB_SCHLINE_PKG remains VALID in the APPS schema and that its dependent policy schedule tables are accessible. Custom extensions should not call this package directly; instead, use supported Internet Expenses APIs and views.