Search Results c_state_name_p

Overview

APPS.PER_PERUSHIR_XMLP_PKG is a report-support package that backs the Oracle E-Business Suite HRMS "New Hires" (US) report — internally designated PERUSHIR — a BI Publisher / XML Publisher concurrent program that lists newly hired employees for a given business group, tax unit, and report date. The package is generated in the standard Oracle Reports/XML Publisher integration style: it declares the report's bind parameters and global variables as package-level data, exposes formula columns as PL/SQL functions, and implements the report trigger entry points (BEFOREREPORT, AFTERPFORM, BETWEENPAGE, AFTERREPORT). Its header, dated 2007/12/28 (120.0), reflects the R12 HRMS shared-service code line used by both 12.1.1 and 12.2.2.

Key Procedures and Functions

The package follows the naming conventions of Oracle Reports XML Publisher (XMLP) conversion, where report triggers, formula columns, and summary columns each map to a PL/SQL unit.

• BEFOREREPORT, AFTERPFORM, BETWEENPAGE, AFTERREPORT — the report lifecycle triggers; BEFOREREPORT initialises globals and context, AFTERPFORM and BETWEENPAGE handle formatting/segment logic, and AFTERREPORT performs end-of-run cleanup.
• P_UPDATE_STATUS — updates the report's run/status state; the classic XMLP pattern for flagging report completion.
• P_OUTPUT_NEW_HIRE_NULL — outputs a placeholder row when no new hires match the selection criteria, ensuring the report still renders a header and message.
• C_SALARYFORMULA — the salary formula column; this is the function most relevant to a "get_salary" search, returning the annualised salary figure for the assignment being printed.
• C_EMPLOYEE_ADDRESSFORMULA, C_TAX_UNIT_ADDRESSFORMULA, C_CONTACT_NAMEFORMULA, C_CONTACT_TITLEFORMULA, C_CONTACT_PHONEFORMULA — formula columns deriving the employee address, the tax-unit (employer) address, and the new-hire contact details shown on the report.
• G_TAX_UNIT_HEADERGROUPFILTER, G_NEW_HIRESGROUPFILTER — group filter functions that control break/header suppression and row-level selection in the report layout.
• C_BUSINESS_GROUP_NAME_P, C_REPORT_SUBTITLE_P, C_TAX_UNIT_P, C_STATE_NAME_P, C_MEDICAL_AVAIL_P, C_END_OF_TIME_P — "package getter" functions returning the values of the corresponding summary columns and globals.
• GET_BUSINESS_GROUP, GET_ORG_NAME, GET_STATE_NAME, END_OF_TIME — helper lookups resolving business group name, organisation name, state name, and the period end date used for the report's waiting/eligibility calculations.

Tables Accessed

The package reads the core HRMS person and assignment model through APPS synonyms: PER_ALL_PEOPLE_F and PER_ALL_ASSIGNMENTS_F supply the new-hire population, hire dates and salary basis used by C_SALARYFORMULA; PER_PERIODS_OF_SERVICE supplies the period-of-service start used to determine the hire date and waiting period; PER_JOBS provides job names; HR_LOCATIONS_ALL supplies employee and tax-unit addresses; and HR_SOFT_CODING_KEYFLEX resolves the accounting/flexfield segments attached to the assignment. All access is read-only in normal report execution, with P_UPDATE_STATUS handling any write.

Usage Notes

PER_PERUSHIR_XMLP_PKG is invoked exclusively by the "New Hires (US)" concurrent program, which submits the report through the XML Publisher engine; the package is never called directly by end users. Because PER_PERUSHIR accesses assignment and salary data, the concurrent program must be run with an HRMS security profile that authorises the security groups targeted by the request. The package is not referenced by any other PL/SQL object, so customisations should be applied to a copy or to the report definition rather than to the seeded package, which is subject to patching in both 12.1.1 and 12.2.2. When troubleshooting salary output, C_SALARYFORMULA is the first function to inspect, as it controls how assignment salary is derived and formatted for each reported row.