Results for “si_sex”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.PAY_PAYJPSQD_XMLP_PKG is an Oracle E-Business Suite PL/SQL package body associated with the Japanese payroll statutory reporting subsystem. Its documented purpose is to support the XML Publisher concurrent report titled "Notification of Qualfication Checklist" (as spelled in the source constant CP_REPORT_TITLE). This is a Japanese localization report concerning social insurance (SI) qualification notices, and the package supplies the data extraction, derived value computation, and global variable initialization required by the report's XML template.

The package body defines a BeforeReport function, which is the standard XML Publisher report trigger executed prior to the report query. Within this trigger the package captures the concurrent request identifier, resets internal counters and accumulators, resolves a magazine/output file name, and derives the Japanese era (wareki) representation of the preparation date. It also resolves several descriptive flexfield or element input value identifiers used later by the report query to fetch social insurance attributes for employees.

Key Procedures and Functions

The ETRM metadata documents zero formally registered procedures or functions for this package, and no parameter-level API contract is published. The only routine visible in the source excerpt is BeforeReport, which returns a boolean and serves as the report-level pre-query trigger. Its responsibilities are as follows:

• Assign P_CONC_REQUEST_ID from fnd_global.CONC_REQUEST_ID and initialize the package counters G_REC_COUNT, G_FD_COUNT, G_FD_SERIAL_NUMBER, G_COUNT_OF_RECORD, and G_HEADER_OUT to zero.
• Set the report title global CP_REPORT_TITLE to 'Notification of Qualfication Checklist'.
• Derive the magazine file name G_MAGFILE_NAME, either from the P_FILE_NAME parameter or generated from the concurrent request ID with a leading 'q' and zero-padded sequence.
• Call pay_jp_report_pkg.to_era to decompose P_PREPARE_DATE into era code, year, month, and day, then format the year, month, and day into zero-padded globals G_PREPARE_DATE_YEAR, G_PREPARE_DATE_MONTH, and G_PREPARE_DATE_DAY.
• Resolve the legislation code via pay_jp_balance_pkg.get_legislation_code and the element type identifiers for 'COM_SI_INFO' and 'COM_SI_MR_AT_QUALIFY_INFO' via pay_jp_balance_pkg.get_element_type_id.
• Resolve input value identifiers via pay_jp_balance_pkg.get_input_value_id for BASIC_PENSION_NUM, SI_SEX, ERN_MONEY, and ERN_KIND, storing them in globals such as G_BASIC_PENSION_NUMBER_IV_ID, G_SI_SEX_IV_ID, G_SALARY_IV_ID, and G_MATERIAL_SALARY_IV_ID.

Tables Accessed

The ETRM metadata records no direct table references through APPS synonyms. The package instead depends on the referenced product packages pay_jp_report_pkg and pay_jp_balance_pkg for data retrieval. The only direct schema reference is the implicit use of fnd_global to obtain the concurrent request identifier, and the datatype declaration referencing PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE, which indicates a logical dependency on the business group definition table. All element type and input value lookups are delegated to the Japanese payroll balance package, meaning the physical table access occurs inside those dependent APIs rather than in this unit.

Usage Notes

This package is invoked exclusively through the Oracle XML Publisher concurrent program infrastructure. In Oracle EBS 12.1.1 and 12.2.2, the concurrent manager executes the report definition whose PL/SQL trigger references PAY_PAYJPSQD_XMLP_PKG.BeforeReport; the function is called once per report run, before the main data query executes. It is not intended to be called directly from forms or custom application code, and it exposes no public API surface beyond the report trigger.

The presence of the search term "si_sex" corresponds to the SI_SEX input value lookup at line 40, which resolves the input value identifier for the social insurance sex attribute on the COM_SI_INFO element type; this value is later used by the report query to print the insured person's sex on the qualification checklist. Because the package relies on Japanese localization APIs (pay_jp_report_pkg, pay_jp_balance_pkg) and on legislation-specific element names, it is only functional in a Japanese legislation business group. Any customization should preserve the globals contract expected by the accompanying XML template, since those global variables supply values that the data template references directly.