Search Results check_run_flags




Overview
Explore in AI Chat

Overview

APPS.PAY_KR_WF_SUBMIT_PROGRAM_PKG is a payroll localization package that supports the Oracle E-Business Suite (EBS) Oracle Payroll workflow infrastructure for the Korean (KR) legislation. The package body is identified in ETRM as release 12.2.2 with the source header pykrwfsp.pkb 120.2, compiled under the APPS schema. Its API classification is OTHER, indicating that it is not a public, supported business API but rather an internal component invoked by the workflow engine and related payroll processes.

The package serves as a workflow program-submission handler. In Oracle Payroll workflow definitions, activities that launch concurrent programs or perform conditional transitions are driven by PL/SQL procedures executed by the Workflow engine. PAY_KR_WF_SUBMIT_PROGRAM_PKG encapsulates this logic for Korean payroll, accepting the standard workflow callback signature (item type, item key, activity id, function mode, and result output) so that the workflow engine can call it without modification.

Key Procedures and Functions

ETRM documents three procedures/functions in the package. Parameter lists are not documented in the excerpt beyond SUBMIT_PROGRAM, and are therefore not reproduced here.

  • SUBMIT_PROGRAM — The primary workflow callback. It receives the item type, item key, activity id, function mode, and an output result. It identifies the relevant payroll action via cursor csr_payroll_action_id (Bug 4859652), which queries PAY_PAYROLL_ACTIONS for a prepayments request, and constructs a run-type/period identifier through cursor csr_run_type_period_name by joining payroll, assignment, interlock, run type, and time-period data. Based on these lookups it drives the workflow transition and returns a result to the engine.
  • CHECK_RUN_FLAGS — The procedure associated with the user search term "check_run_flags". It evaluates the state of a payroll run, inspecting the run flags recorded against payroll and assignment actions to determine whether the run satisfies the conditions required for a workflow branch or subsequent submission.
  • GET_ASSIGNMENT_COUNT — Returns a count of assignments associated with the payroll action in scope. The value is typically used as a conditional input to workflow logic, for example to stop or redirect processing when no assignments qualify.

Tables Accessed

  • PAY_PAYROLL_ACTIONS — The central payroll action table. Queried to resolve the payroll_action_id, action_type (for example P, U, Q, R), action_status, business_group_id, payroll_id, and request_id, and to build the run-type/period description.
  • PAY_ASSIGNMENT_ACTIONS — Provides the assignment-level actions linked to the payroll action, used in the interlocks join and for assignment counting.
  • PAY_ACTION_INTERLOCKS — Records the locking relationship between prepayment and run assignment actions, enabling the package to trace which run actions are locked by which prepayment actions.
  • PAY_RUN_TYPES_F — Supplies the run type name joined to the run action via run_type_id.
  • PER_TIME_PERIODS — Supplies the period name used to build the human-readable run-type/period identifier.

Usage Notes

The package is invoked by the Oracle Workflow engine during Korean payroll processing rather than called directly from forms. It is referenced by no other packages according to ETRM, confirming its role as a leaf-level workflow handler. Typical invocation occurs when a workflow activity for the KR payroll process is executed and the engine passes the item type, item key, activity id, and function mode.

Because it is classified OTHER, it should not be called from custom code; any customization should instead target the workflow definition. The presence of hr_utility.debug_enabled and the g_debug constant indicates that diagnostic output can be enabled using the standard HR debug mechanism. The package was last updated with Bug 4859652, which added the prepayment payroll action lookup, and is shipped as a non-shippable (noship) localization component.