Results for “create_sline_asg_status_change”

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

Overview

PSP_PAYTRN is an Oracle E-Business Suite PL/SQL package body owned by APPS that supports the Payroll sub-ledger of Oracle Projects and Grants Management. Its principal business function is to convert timecard and payroll data into costed assignment transactions that can flow into project and award costing. The package imports payroll transaction records, builds working and daily rate calendars, derives prorated salary and assignment change amounts, and generates assignment sub-ledger lines (SLINEs) reflecting changes to an employee's compensation, organization, job, position, grade, or employment status.

The user search term per_time_periods_f reflects the temporal table that drives the package's dating logic. The IMPORT_PAYTRANS procedure explicitly reads PER_TIME_PERIODS to obtain the payroll start date, end date, and payroll identifier for a given time period, which the remainder of the import logic uses to determine the costing period.

Key Procedures and Functions

• IMPORT_PAYTRANS — Primary driver procedure. For a supplied period type, time period identifier, business group, and set of books, it imports payroll transaction records and derives the payroll period boundaries from PER_TIME_PERIODS.
• CREATE_WORKING_CALENDAR — Builds the calendar of working days used for proration and rate calculation.
• UPDATE_WCAL_ASG_END_DATE, UPDATE_WCAL_ASG_BEGIN_DATE, UPDATE_WCAL_ASG_STATUS — Maintain the working calendar lines when an assignment's end date, begin date, or status changes.
• CREATE_DAILY_RATE_CALENDAR — Populates the daily rate calendar used to derive daily compensation amounts.
• CALCULATE_BALANCE_AMOUNT — Computes the balance or residual amount to be costed for a period.
• CREATE_SLINE_SALARY_CHANGE — Generates an assignment sub-ledger line for a salary change.
• CREATE_SLINE_ASG_CHANGE — Generates a sub-ledger line for a general assignment change.
• CREATE_SLINE_ASG_STATUS_CHANGE — Generates a sub-ledger line when an assignment status changes.
• CREATE_SLINE_EMP_END_DATE — Generates a sub-ledger line for an employee end-date event.
• CREATE_SLINE_ORG_CHANGE, CREATE_SLINE_JOB_CHANGE, CREATE_SLINE_POSITION_CHANGE, CREATE_SLINE_GRADE_CHANGE — Generate sub-ledger lines for organization, job, position, and grade changes respectively.
• CREATE_SLINE_PPGROUP_CHANGE, CREATE_SLINE_FTE_CHANGE — Generate sub-ledger lines for payroll group and full-time-equivalent changes.
• CREATE_SLINE_BUDGET_CHANGE — Generates a sub-ledger line for a budget change.
• CHECK_ZERO_WORK_DAYS — Validates whether a period contains zero work days, guarding proration logic.
• CREATE_SLINE_TERM_EMP — Generates a sub-ledger line for terminated employees.

Tables Accessed

• PER_TIME_PERIODS, PER_ALL_ASSIGNMENTS_F — Provide payroll period dates and assignment attributes that anchor costing.
• PAY_PAYROLL_ACTIONS, PAY_ACTION_INTERLOCKS, PAY_ACTION_PARAMETER_VALUES, PAY_ASSIGNMENT_ACTIONS — Supply payroll run metadata and assignment action context.
• PAY_RUN_RESULTS, PAY_COSTS, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_TYPES_F, PAY_INPUT_VALUES_F — Source transaction and cost detail used to derive SLINE amounts.
• HR_ALL_ORGANIZATION_UNITS — Resolves organization hierarchy for org-change processing.
• GMS_AWARDS_ALL, PA_EXPENDITURE_TYPES, PA_PROJECTS_ALL — Associate awards, expenditure types, and projects with generated SLINE records.
• FND_NEW_MESSAGES — Supports concurrent program messages.

Usage Notes

The package is not referenced by any other package, indicating it functions as a top-level integration point. It is typically invoked from Oracle Projects payroll costing concurrent programs, from Grants Management award costing flows, and from Payroll-to-Projects interface jobs that pass a time period identifier and business group. Custom extensions should call IMPORT_PAYTRANS through its declared entry point rather than invoking the internal sub-ledger procedures directly, since the import procedure establishes required global state such as precision, currency codes, exchange rate type, and effective date boundaries.