Search Results do_reject

Overview

APPS.PAY_JP_DEF_SS is a Japanese localization seed data / utility package within the Oracle EBS Payroll (PAY) module. Its name follows the regional convention PAY_<country>_DEF_SS, where the "JP" token identifies the Japanese legislative and business rules applied to payroll action processing within Oracle Human Resources and Oracle Payroll. The package encapsulates the definition and control logic that governs how payroll action information rows created through the Oracle Payroll Web Interface are initialized, validated, finalized, rejected, returned, approved, transferred, expired, archived, and deleted.

In practice, the package functions as the server-side engine behind the Japanese payroll action lifecycle. It provides the "Do" family of entry points that a Web Interface-driven flow invokes as it moves an action information record through its status transitions, together with supporting utilities for date-track mode resolution, submission period checks, session anchoring, and SQL error retrieval. It is classified under ETRM as an OTHER API rather than a business object API, reflecting its role as internal control logic rather than a published, externally callable interface.

Key Procedures and Functions

The documented surface of the package comprises 32 procedures and functions. The principal Web Interface procedures are:

• DO_INIT — Initializes an action information record for processing, capturing the action information identifier and an in/out object version number; an overloaded form additionally returns a status value.
• DO_FINALIZE — Finalizes the action, committing the processing state for the action information record.
• DO_REJECT — Transitions the action to a rejected state.
• DO_RETURN — Returns the action, typically sending it back to a prior step or initiator for correction; this is the procedure the user's search term "do_return" references.
• DO_APPROVE — Approves the action, advancing it toward completion.
• DO_TRANSFER — Transfers the action, moving associated data from source to target structures.
• ROLLBACK_TRANSFER — Reverses a previously performed transfer.
• DO_EXPIRE — Expires the action according to date-track rules.
• ROLLBACK_EXPIRE — Reverses an expiry operation.
• DELETE_UNFINALIZED — Removes action records that were never finalized.
• ARCHIVE_DEFAULT — Archives default action information records.

Supporting functions include CHECK_SUBMISSION_PERIOD (a function and a procedure form) for validating the submission window, CHANGED for comparing two string values, and GET_SQLERRM for retrieving the SQL error message. A set of debug-only routines is present but commented out in the header, including EE_DATETRACK_UPDATE_MODE, CEI_DATETRACK_UPDATE_MODE, CEI_DATETRACK_DELETE_MODE, FULL_NAME, INSERT_SESSION, and DELETE_SESSION.

Tables Accessed

The package reads and writes through APPS synonyms against the following core tables: FND_SESSIONS (session anchoring used by the session-insert/delete debug routines), PAY_ACTION_INFORMATION (the primary action record), PAY_ASSIGNMENT_ACTIONS, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, PAY_ELEMENT_LINKS_F, PAY_INPUT_VALUES_F, PAY_LINK_INPUT_VALUES_F, and PAY_JP_SWOT_NUMBERS (the Japan-specific statutory reporting number). Person data is drawn from PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, PER_ADDRESSES, PER_CONTACT_RELATIONSHIPS, PER_CONTACT_EXTRA_INFO_F, and PER_JP_ADDRESS_LOOKUPS. Collectively these tables supply the element entry, input value, assignment, and person/address context required to process a Japanese payroll action.

Usage Notes

PAY_JP_DEF_SS is invoked from the Oracle Payroll Web Interface processing layer rather than being called directly by end users. Forms and concurrent processes that drive the Japanese action information workflow call the DO_* procedures to advance an action through its states. Because the package is classified as an internal utility, custom code should avoid calling it directly; any integration should go through the supported payroll business APIs. The object is referenced by two other packages, indicating its role as shared control logic within the Japanese payroll localization. The header revision (120.0.12000000.3, dated 2007) indicates the package shipped unchanged across the 12.1.1 and 12.2.2 releases.