Search Results get_tag_name

Overview

PAY_NL_NWR_XML_EXTRACT_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and declared with AUTHID CURRENT_USER. Its business function is to support Dutch (NL) statutory reporting obligations by extracting payroll data archived during a payroll run and rendering it into an XML document. The package header identifies the source file as pynlwrep.pkh, consistent with the Dutch NWR (Netherlands Wage Report / loonopgaaf) reporting area. The primary workhorse, GENERATE, is explicitly documented as interpreting archived information and printing it out to an XML file — that is, it reads records previously stored in payroll action information by a payroll action, walks the relevant assignment and organization data, and produces a structured XML payload, typically consumed downstream by a BI Publisher (XDO) template or delivered to an external Dutch tax/reporting authority format.

Key Procedures and Functions

The documented package surface comprises five callable units:

• GET_TAG_NAME — Returns the XML tag name for a given combination of context code and node. This is the routine most directly relevant to the search term "get_tag_name". It allows the extraction logic to map an internal context/node pair to the correct XML element name used in the generated output.
• YES_NO — Converts a Y/N style indicator into a representation suitable for the XML output (e.g., translating an EBS internal flag into the value the report template expects).
• GET_LE_NAME — Returns the legal employer name for a given payroll action identifier, resolving the organization responsible for the payroll run.
• LOAD_XML — Populates the XML structure for a specific node type given a context code, node, and data value. It is the low-level writer that assembles tag/value pairs.
• GENERATE — The main entry point. It interprets archived information and emits it as XML, taking the action context, NWR report type, assignment set, sort order, and template name, and returning the generated XML document as a CLOB.

Tables Accessed

The package reads predominantly from payroll and HR tables via APPS synonyms:

• PAY_ACTION_INFORMATION — the archive of information collected during the payroll action; accessed by the declared cursors (csr_message_info, csr_collective_info, csr_swmf_info) using action context type 'PA'.
• PAY_PAYROLL_ACTIONS and PAY_ASSIGNMENT_ACTIONS — to link the action context to the payroll run and the assignments processed in it.
• HR_ASSIGNMENT_SETS and HR_ASSIGNMENT_SET_AMENDMENTS — to constrain extraction to the assignment set selected at submission.
• HR_ORGANIZATION_INFORMATION — to resolve legal employer details for GET_LE_NAME.
• FND_LOOKUP_VALUES and FND_DESCR_FLEX_COL_USAGE_TL — for descriptive and lookup translation values.
• PAY_USER_TABLES, PAY_USER_ROWS_F, PAY_USER_COLUMNS, PAY_USER_COLUMN_INSTANCES_F — for user-defined table/column structures used in the extracted report.
• DBMS_LOB, DBMS_SQL, NLS_DATABASE_PARAMETERS — support objects used for CLOB handling, dynamic SQL, and locale awareness.

Usage Notes

The package is marked with an API classification of OTHER and is not referenced by any other package, indicating it is invoked directly rather than through an EBS API chain. It is typically called from a concurrent program or report submission that passes the action context, report type, assignment set, sort order, and template name, receiving the XML as a CLOB in return. The template name parameter implies integration with the XML Publisher / BI Publisher engine, where the generated XML is merged with a report template. Custom code invoking this package should supply the correct action context identifier and assignment set, and should be aware that it operates with the privileges of the calling user (AUTHID CURRENT_USER) and relies on APPS synonyms being visible in the session.