Search Results get_doc_details

Overview

JA_CN_PS_HRMS_EXPORT_PKG is a PL/SQL package owned by APPS in the Oracle E-Business Suite, created by Wuhua Liu on 13-AUG-2010 (header JACNPHRS.pls, version 120.0). Its stated purpose, per the package header, is "to export department records, employee records and Employee Category for public sector" within the Oracle HRMS and China localization (JA_CN) context. The package is declared AUTHID CURRENT_USER and uses a module prefix constant GV_MODULE_PREFIX set to 'JA_CN_PS_HRMS_EXPORT_PKG', a common convention for standardizing error messages and debug output across its procedures. It is classified as an "OTHER" API in ETRM rather than a fully supported public API, meaning it is primarily consumed internally by the localization solution rather than by external integrators. Its design reference is the technical design document TDD_1213_FIN_GL_P_CNAOV2_SI.doc, indicating the package was built to satisfy a China public-sector HRMS extraction or interface requirement.

Key Procedures and Functions

The package header documents eight callable units. The three documented procedures in ETRM metadata are:

• ADD_DEPARTMENT_RECORDS – Exports department records. According to the header comments, it accepts a legal entity identifier, a ledger identifier, and an accounting year as inbound parameters, and is the entry point for creating or staging organization/department data derived from HR organization structures.
• ADD_EMPLOYEE_RECORDS – Exports employee records, extracting person-level data for the same legal entity, ledger and accounting year context.
• ADD_EMPLOYEE_CATEGORY – Exports employee category data, which in the China public-sector localization typically relates to cadre, technical post or similar classification attributes held on person analyses or extra information.

Additional helper functions declared in the package header, though not enumerated in the ETRM procedure list, include GET_LOOKUP_MEANING, GET_DOC_DETAILS, GET_PARENT_ORG_ID, GET_CADRE_JOB_DETAILS and GET_TECH_POST_DETAILS. These are utility functions that resolve lookup meanings, document details, organization hierarchy parents, and cadre/technical post attributes respectively, supporting the three main export procedures.

Tables Accessed

Through APPS synonyms, the package reads data from a broad set of HRMS and General Ledger tables:

• HR organization data: HR_ALL_ORGANIZATION_UNITS_TL, HR_ORGANIZATION_INFORMATION, HR_SOFT_CODING_KEYFLEX, PER_ORGANIZATION_STRUCTURES, PER_ORG_STRUCTURE_ELEMENTS, PER_ORG_STRUCTURE_VERSIONS – used to build the department hierarchy and derive parent organization relationships.
• Employee data: PER_ALL_PEOPLE_F, PER_PERIODS_OF_SERVICE, PER_PEOPLE_EXTRA_INFO – used to extract employee records and their service history.
• Classification data: PER_ANALYSIS_CRITERIA, PER_PERSON_ANALYSES – used for employee category, cadre and technical post determinations.
• Ledger and period context: GL_LEDGERS and GL_PERIODS – used to map the legal entity, ledger and accounting year parameters.
• Lookups: FND_LOOKUP_VALUES – used by the GET_LOOKUP_MEANING helper to translate lookup codes into descriptive meanings.

Usage Notes

JA_CN_PS_HRMS_EXPORT_PKG is referenced by one other package in ETRM, confirming it functions as a subordinate extraction layer invoked by a higher-level China public-sector process. It is typically called from concurrent program logic or custom PL/SQL rather than directly from an Oracle Forms screen, since its procedures operate on legal entity, ledger and accounting year parameters that are naturally supplied by a batch interface. Because the package is classified as OTHER and AUTHID CURRENT_USER, customers should treat it as an internal localization component: invoking it directly is possible but unsupported, and any dependency on its signature should be validated against the specific patch level of the JA_CN localization in EBS 12.1.1 or 12.2.2.