Search Results pay_in_utils

Overview

APPS.PAY_IN_UTILS is a shared Oracle Payroll utility package body delivered as part of the Oracle E-Business Suite 12.1.1 and 12.2.2 code line. Despite its generic name, the package is a localized (India) payroll helper library: the header revision identifier (pyinutil.pkb) and the "IN" token in the object name indicate the India localization layer of Oracle Payroll. The package does not constitute a business API in its own right; it is an internal support library that centralizes date handling, message translation, trace/debug instrumentation, and cross-table lookups required by the India payroll calculation, element link, and statutory reporting flows.

Its practical value lies in reuse. The ETRM metadata records that the package is referenced by 53 other packages, confirming its role as a common dependency for India payroll functions, concurrent program wrappers, and validation routines. Consolidating these helpers in a single package reduces duplication of the diagnostic and error-handling patterns that appear throughout the localization code.

Key Procedures and Functions

The documented interface exposes 51 procedures and functions. Representative members include:

GET_MAX_ACT_SEQUENCE — returns the maximum action sequence recorded on PAY_ASSIGNMENT_ACTIONS for a given assignment, process (action) type, and effective month.
SET_LOCATION — the instrumentation routine that records the caller's position within a package for debugging. It is the entry point most commonly searched for, because it appears at the start and end of nearly every procedure in this and related India payroll packages. In the excerpt it is invoked with the debug flag, a descriptive location string, and a numeric offset.
TRACE — writes name/value diagnostic pairs to the debug output when tracing is enabled.
GET_PAY_MESSAGE, NULL_MESSAGE, RAISE_MESSAGE — retrieve localized message text and standardize how errors are surfaced or suppressed.
GET_RUN_TYPE_NAME, GET_EFFECTIVE_DATE, GET_ASSIGNMENT_ID, GET_PERSON_ID, NEXT_TAX_YEAR, VALIDATE_DATES — date, identity, and assignment resolution helpers.
CHK_ORG_CLASS, CHK_ELEMENT_LINK, GET_ELEMENT_LINK_ID, GET_SCL_SEGMENT_ON_DATE, GET_USER_TABLE_VALUE, GET_EE_VALUE — validation and lookup routines for organizations, element links, costing segments, and employee-level values.
NUMBER_TO_WORDS, ENCODE_HTML_STRING — formatting utilities used for payment advices/statutory forms and HTML output.

Tables Accessed

The package operates against the core payroll and HR schema via APPS synonyms, including PAY_ASSIGNMENT_ACTIONS, PAY_ACTION_INFORMATION, PAY_ELEMENT_TYPES_F, PAY_ELEMENT_LINKS_F, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, PAY_ELEMENT_CLASSIFICATIONS, PAY_ELEMENT_TEMPLATES, PAY_BALANCE_TYPES, PAY_BALANCE_FEEDS_F, PAY_FORMULA_RESULT_RULES_F, PAY_ASSIGNMENT_LINK_USAGES_F, FF_FORMULAS_F, HR_ORGANIZATION_INFORMATION, and HR_SOFT_CODING_KEYFLEX. Reads are predominantly descriptive: resolving action sequences, element-link validity, entry values, balance feeds, and organization classification data needed to drive India payroll calculations.

Usage Notes

PAY_IN_UTILS is invoked indirectly rather than from user-facing forms. India payroll fast formulas, concurrent program wrappers, and other localization packages call it during payroll runs, element link validation, and pre-payment processing. Because SET_LOCATION and TRACE depend on the HR_UTILITY debug flag (g_debug := hr_utility.debug_enabled), diagnostic output only materialises when tracing is switched on for the session. Customizations should treat the package as a private contract: signatures are not documented as a public API, and the strong coupling to the India localization schema means any direct calls from client code must be regression-tested against each patch level.

PACKAGE BODY: APPS.PAY_IN_UTILS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PAY_IN_UTILS, status:VALID,
PACKAGE BODY: APPS.PAY_IN_UTILS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PAY_IN_UTILS, status:VALID,
PACKAGE: APPS.PER_IN_PERQUISITE_PKG 12.1.1
owner:APPS, object_type:PACKAGE, object_name:PER_IN_PERQUISITE_PKG, status:VALID,
PACKAGE BODY: APPS.PAY_IN_ETW_STRUCT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PAY_IN_ETW_STRUCT, status:VALID,
PACKAGE: APPS.PER_IN_EXTRA_ASG_INFO_LEG_HOOK 12.2.2
owner:APPS, object_type:PACKAGE, object_name:PER_IN_EXTRA_ASG_INFO_LEG_HOOK, status:VALID,
PACKAGE: APPS.PAY_IN_UTILS 12.1.1
owner:APPS, object_type:PACKAGE, object_name:PAY_IN_UTILS, status:VALID,
PACKAGE: APPS.PER_IN_CON_LEG_HOOK 12.2.2
owner:APPS, object_type:PACKAGE, object_name:PER_IN_CON_LEG_HOOK, status:VALID,
PACKAGE BODY: APPS.PAY_IN_ELE_EXTRA_INFO_LEG_HOOK 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PAY_IN_ELE_EXTRA_INFO_LEG_HOOK, status:VALID,
PACKAGE BODY: APPS.PAY_IN_ETW_STRUCT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PAY_IN_ETW_STRUCT, status:VALID,
PACKAGE: APPS.PER_IN_PERSON_TERM_LEG_HOOK 12.1.1
owner:APPS, object_type:PACKAGE, object_name:PER_IN_PERSON_TERM_LEG_HOOK, status:VALID,
PACKAGE: APPS.PER_IN_PERSON_LEG_HOOK 12.1.1
owner:APPS, object_type:PACKAGE, object_name:PER_IN_PERSON_LEG_HOOK, status:VALID,
PACKAGE BODY: APPS.PAY_IN_XML_UTILS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PAY_IN_XML_UTILS, status:VALID,
PACKAGE BODY: APPS.PER_IN_EXTRA_PER_INFO_LEG_HOOK 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PER_IN_EXTRA_PER_INFO_LEG_HOOK, status:VALID,
PACKAGE BODY: APPS.PER_IN_EXTRA_ASG_INFO_LEG_HOOK 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PER_IN_EXTRA_ASG_INFO_LEG_HOOK, status:VALID,
PACKAGE: APPS.PER_IN_PERSON_TERM_LEG_HOOK 12.2.2
owner:APPS, object_type:PACKAGE, object_name:PER_IN_PERSON_TERM_LEG_HOOK, status:VALID,
PACKAGE BODY: APPS.PAY_IN_EXC 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PAY_IN_EXC, status:VALID,
PACKAGE: APPS.PAY_IN_TERMINATION_PKG 12.2.2
owner:APPS, object_type:PACKAGE, object_name:PAY_IN_TERMINATION_PKG, status:VALID,
PACKAGE: APPS.PAY_IN_UTILS 12.2.2
owner:APPS, object_type:PACKAGE, object_name:PAY_IN_UTILS, status:VALID,
PACKAGE BODY: APPS.PAY_IN_PAYSLIP_UTILS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PAY_IN_PAYSLIP_UTILS, status:VALID,
PACKAGE: APPS.PER_IN_CON_LEG_HOOK 12.1.1
owner:APPS, object_type:PACKAGE, object_name:PER_IN_CON_LEG_HOOK, status:VALID,
PACKAGE: APPS.PAY_BALANCE_FEEDS_API 12.1.1
owner:APPS, object_type:PACKAGE, object_name:PAY_BALANCE_FEEDS_API, status:VALID,
PACKAGE: APPS.PER_IN_EXTRA_ASG_INFO_LEG_HOOK 12.1.1
owner:APPS, object_type:PACKAGE, object_name:PER_IN_EXTRA_ASG_INFO_LEG_HOOK, status:VALID,
PACKAGE BODY: APPS.PAY_IN_ELE_EXTRA_INFO_LEG_HOOK 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PAY_IN_ELE_EXTRA_INFO_LEG_HOOK, status:VALID,
PACKAGE BODY: APPS.PER_IN_PREV_EMPLOYER_LEG_HOOK 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PER_IN_PREV_EMPLOYER_LEG_HOOK, status:VALID,
PACKAGE: APPS.PAY_IN_PROF_TAX_PKG 12.2.2
owner:APPS, object_type:PACKAGE, object_name:PAY_IN_PROF_TAX_PKG, status:VALID,
PACKAGE BODY: APPS.HR_IN_PERSONAL_PAY_METHOD_API 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:HR_IN_PERSONAL_PAY_METHOD_API, status:VALID,
PACKAGE BODY: APPS.PAY_IN_EXC 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PAY_IN_EXC, status:VALID,
PACKAGE BODY: APPS.PER_IN_ASG_LEG_HOOK 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PER_IN_ASG_LEG_HOOK, status:VALID,
PACKAGE BODY: APPS.PAY_IN_XML_UTILS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PAY_IN_XML_UTILS, status:VALID,
PACKAGE BODY: APPS.PAY_IN_BAL_UPLOAD 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PAY_IN_BAL_UPLOAD, status:VALID,
PACKAGE: APPS.PAY_IN_TERMINATION_PKG 12.1.1
owner:APPS, object_type:PACKAGE, object_name:PAY_IN_TERMINATION_PKG, status:VALID,
PACKAGE BODY: APPS.PAY_IN_ROUTES 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PAY_IN_ROUTES, status:VALID,
PACKAGE BODY: APPS.PAY_IN_ROUTES 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PAY_IN_ROUTES, status:VALID,
PACKAGE: APPS.PER_IN_PERQUISITE_PKG 12.2.2
owner:APPS, object_type:PACKAGE, object_name:PER_IN_PERQUISITE_PKG, status:VALID,
PACKAGE BODY: APPS.PER_IN_CON_LEG_HOOK 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PER_IN_CON_LEG_HOOK, status:VALID,
PACKAGE BODY: APPS.PER_IN_ENTRY_VALUE_LEG_HOOK 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PER_IN_ENTRY_VALUE_LEG_HOOK, status:VALID,
PACKAGE BODY: APPS.PER_IN_CON_LEG_HOOK 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PER_IN_CON_LEG_HOOK, status:VALID,
PACKAGE BODY: APPS.PAY_IN_PROF_TAX_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PAY_IN_PROF_TAX_PKG, status:VALID,
PACKAGE BODY: APPS.PAY_IN_BONUS_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PAY_IN_BONUS_PKG, status:VALID,
PACKAGE: APPS.PAY_IN_FF_PKG 12.1.1
owner:APPS, object_type:PACKAGE, object_name:PAY_IN_FF_PKG, status:VALID,
PACKAGE BODY: APPS.PER_IN_DISABILITY_LEG_HOOK 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PER_IN_DISABILITY_LEG_HOOK, status:VALID,
PACKAGE: APPS.PER_IN_ORG_INFO_LEG_HOOK 12.1.1
owner:APPS, object_type:PACKAGE, object_name:PER_IN_ORG_INFO_LEG_HOOK, status:VALID,
PACKAGE BODY: APPS.PER_IN_PREV_EMPLOYER_LEG_HOOK 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PER_IN_PREV_EMPLOYER_LEG_HOOK, status:VALID,
PACKAGE BODY: APPS.PER_IN_DISABILITY_LEG_HOOK 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PER_IN_DISABILITY_LEG_HOOK, status:VALID,
PACKAGE: APPS.PAY_IN_FF_PKG 12.2.2
owner:APPS, object_type:PACKAGE, object_name:PAY_IN_FF_PKG, status:VALID,
PACKAGE BODY: APPS.PER_IN_PERSON_TERM_LEG_HOOK 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PER_IN_PERSON_TERM_LEG_HOOK, status:VALID,
PACKAGE BODY: APPS.PER_IN_ADD_LEG_HOOK 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PER_IN_ADD_LEG_HOOK, status:VALID,
PACKAGE: APPS.PER_IN_ORG_INFO_LEG_HOOK 12.2.2
owner:APPS, object_type:PACKAGE, object_name:PER_IN_ORG_INFO_LEG_HOOK, status:VALID,
PACKAGE BODY: APPS.PER_IN_ASG_LEG_HOOK 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PER_IN_ASG_LEG_HOOK, status:VALID,
PACKAGE: APPS.PAY_BALANCE_FEEDS_API 12.2.2
owner:APPS, object_type:PACKAGE, object_name:PAY_BALANCE_FEEDS_API, status:VALID,