Search Results cp_hia_business_place_code_p

Overview

APPS.PAY_PAYKRHCL_XMLP_PKG is a report-generation package body associated with an Oracle Payroll legislative report for Korea (the PAYKRHCL naming component indicates Korean localization, Health Insurance-related reporting). It follows the standard Oracle Reports XML Publisher (XMLP) package pattern, in which a PL/SQL package is generated alongside an Oracle Reports definition and supplies the report's user-exit functions, formulas, and data-fetch logic. The package implements the BEFOREREPORT and AFTERREPORT trigger functions required by the Reports runtime, a set of column-level formula functions used to derive display values at runtime, and a collection of "CP_" (concurrent program or column parameter) functions that resolve the meat of the report's data. Classification in ETRM is OTHER, and the package is referenced by no other database packages, confirming that it is a leaf-level reporting artifact invoked only by the concurrent manager and the Reports engine itself. The source header identifies a version of 120.0 dated 2007/12/13, indicating a long-stable report body carried forward into 12.1.1 and 12.2.2.

Key Procedures and Functions

The trigger functions BEFOREREPORT and AFTERREPORT bracket report execution. BEFOREREPORT is substantive: it reads the concurrent request arguments from FND_CONCURRENT_REQUESTS (parsing argument1, argument2 and argument3 into the payroll action identifier, HI number, and reported date respectively), captures the concurrent request ID into P_CONC_REQUEST_ID, and then populates a series of package globals — X_HI_PREM_EE_WO_ADJ, X_EARNINGS_SUBJ_HI, X_HI_WORKING_MONTHS, and the X_KR_HIA_* family — by calling GET_USER_ENTITY_ID for each.

GET_USER_ENTITY_ID is the function the user searched for. As its call sites demonstrate, it takes the name of a user-defined FF (Fast Formula) entity and returns the entity ID for that named entity, resolving against FF_USER_ENTITIES. This is the standard mechanism by which Korean payroll reports read configurable business values held as FF user entities rather than hard-coding them.

Formula functions include CF_BUSINESS_GROUPFORMULA, CF_LEGISLATION_CODEFORMULA, CF_CURRENCY_FORMAT_MASKFORMULA, CF_SEQUENCE_COUNTERFORMULA, CF_GET_DATAFORMULA, and CP_CONCAT_BP_NAMESFORMULA. Set-up and validation functions are SET_CURRENCY_FORMAT_MASK and P_BUSINESS_GROUP_IDVALIDTRIGGE. The remaining CP_ functions — CP_HIA_BUSINESS_PLACE_CODE_P, CP_HIA_HI_NUMBER_P, CP_HIA_EMPLOYEE_NAME_P, CP_HIA_REGISTRATION_NUMBER_P, CP_HIA_QUALIFIED_DATE_P, CP_HI_PREM_EE_WO_ADJ_ASG_YTD_P, CP_EARNINGS_SUBJ_HI_ASG_YTD_P, CP_HI_WORKING_MONTHS_P, and CP_NUMBER_OF_MONTHS_PAID_P — derive the individual report columns relating to Korean health insurance: business place code, HI number, employee name, registration number, qualification date, employee premium adjustments, earnings subject to HI, working months, and number of months paid.

Tables Accessed

The package reads FF_USER_ENTITIES (via GET_USER_ENTITY_ID, to translate user entity names into IDs), FND_CONCURRENT_REQUESTS (to obtain the concurrent request ID and parse the submitted parameters), FND_CURRENCIES (for the currency format mask logic), HR_ORGANIZATION_INFORMATION (for the business group and legislation code lookups), and PAY_PAYROLL_ACTIONS (for payroll action context). All are accessed through APPS synonyms, consistent with standard EBS convention.

Usage Notes

The package is invoked indirectly: a user submits the Korean health insurance report as a concurrent program, the Reports runtime fires BEFOREREPORT, and the CP_ functions populate the report's data model, with the CF_ functions formatting individual columns. It should not be called directly from custom code, as its globals and parameter defaults assume a live concurrent request context. Customers modifying the report should note that FF user entities drive much of the output, so business values are typically changed through entity setup rather than by editing the package.