Search Results get_input_value_d_sequence
Overview
PAY_KR_SEP_FORM_PKG is an Oracle Payroll seed-data maintenance package in the APPS schema that supports the Korean Statutory Employee Payment (SEP / 균정산정산출) reporting feature set. It provides the server-side logic behind the Korean separation and year-end settlement forms, allowing a payroll administrator to process, validate, archive, and delete element entry rows that are created through the SEP form interface rather than through the standard element entry form. The package owns the write operations against PAY_ELEMENT_ENTRIES_F and its dependent child tables, enforcing element eligibility, input value validation and formula checks at the point of entry.
The package is classified as OTHER in the ETRM registry and is VALID at 12.1.1 and 12.2.2. It contains 28 documented procedures and functions, and it is referenced by four other database objects, indicating that it is a shared utility rather than a single-purpose form handler.
Key Procedures and Functions
The documented routines fall into four logical groups:
- Run processing: PROCESS_RUN and ARCHIVE_RUN drive the assignment of a SEP processing run to the selected population, while GET_RUN_TYPE_NAME resolves the payroll run type description for display. GET_SESSION_DATE returns the effective date used by the form session.
- DML on element entries: LOCK_ELEMENT_ENTRY, INSERT_ELEMENT_ENTRY, UPDATE_ELEMENT_ENTRY and DELETE_ELEMENT_ENTRY implement the create/update/delete lifecycle for SEP element entry rows, with row locking to prevent concurrent modification.
- Validation: CHK_ENTRY, CHK_FORMULA and VALIDATE_ENTRY_VALUE enforce element entry rules and formula-driven input value constraints before a row is committed. FIND_DT_UPD_MODES and FIND_DT_DEL_MODES determine which date-effective update or delete modes are permitted for the entry.
- Element type and input value lookup: GET_ELEMENT_TYPE_ID, GET_INPUT_VALUE_ID, GET_INPUT_VALUE_NAME, GET_INPUT_VALUE_D_SEQUENCE and GET_INPUT_VALUE_LOOKUP_TYPE resolve element types and their input values, and GET_KR_D_ADDRESS_LINE1 returns the Korean address line used on the separation statement output. ARCHIVE_RUN and DELETE_ACTION manage the retirement of processed runs.
Tables Accessed
The package operates on Payroll core tables through APPS synonyms. PAY_ELEMENT_ENTRIES_F and PAY_ELEMENT_ENTRY_VALUES_F receive the entry header and input value rows. PAY_ELEMENT_TYPES_F, PAY_ELEMENT_TYPE_RULES, PAY_ELEMENT_TYPE_USAGES_F, PAY_ELEMENT_LINKS_F and PAY_INPUT_VALUES_F / PAY_INPUT_VALUES_F_TL supply element definition, eligibility and input value metadata. Validation reads FF_FDI_USAGES_F for formula usage. Contextual data comes from HR_ASSIGNMENT_SETS, HR_ASSIGNMENT_SET_AMENDMENTS, PAY_ASSIGNMENT_ACTIONS, PAY_PAYROLL_ACTIONS and FND_SESSIONS.
Usage Notes
PAY_KR_SEP_FORM_PKG is invoked primarily from the Korean SEP forms and from the views PAY_KR_SEP_HISTORY_V, PAY_KR_SEP_MASTER_EEV_V, PAY_KR_SEP_TAX_V and PAY_KR_SEP_TAX_WO_ADDR_V, which expose processed SEP data for reporting. Because the package performs direct DML on element entry tables, custom code should not bypass its validation procedures; new entry rows should be created through INSERT_ELEMENT_ENTRY after CHK_ENTRY and VALIDATE_ENTRY_VALUE succeed. The package is only relevant where the Korean localization for Oracle Payroll is installed.