Search Results get_third_party_org_context

Overview

PAY_NO_RULES is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified as an "OTHER" API in the ETRM repository. Its header comment identifies it as pynorule.pkh, and its internal logic is organized around payroll action context handling and balance information retrieval. The package belongs to the Oracle Payroll (PAY) product family and is closely tied to the rules-based processing architecture used by payroll run types, assignment actions, and legislative rule evaluation.

The package does not expose a general-purpose business API in the conventional sense; rather, it assembles contextual information used during payroll processing. Several of its functions are explicitly named to return context values — legislative, tax unit, local unit, jurisdiction, source text, and third-party organization context — which are typically consumed by the rules engine or by payroll reports to determine how a given action, balance, or organization should be interpreted. The presence of XML-related procedures indicates the package also participates in generating or augmenting XML payloads, likely for payslip output or statutory reporting.

Key Procedures and Functions

The documented interface includes fourteen procedures and functions. GET_THIRD_PARTY_ORG_CONTEXT, the object most directly associated with the user's search term, returns the organization context for a third-party payer or organization involved in a payroll action. It is used when payroll rules or payslip layouts must reference an external organization rather than the employing legal entity.

• GET_MAIN_TAX_UNIT_ID, GET_MAIN_LOCAL_UNIT_ID, and GET_DEFAULT_JURISDICTION resolve legislative identifiers and the default taxing jurisdiction for a processing context.
• GET_SOURCE_CONTEXT, GET_SOURCE_TEXT_CONTEXT, and GET_SOURCE_TEXT2_CONTEXT return contextual text and source descriptors associated with a payroll action or balance, supporting rules evaluation and display.
• GET_PAYSLIP_SORT_ORDER1, GET_PAYSLIP_SORT_ORDER2, and GET_PAYSLIP_SORT_ORDER3 determine ordering values used when payslip line items are assembled.
• LOAD_XML and ADD_CUSTOM_XML build or extend XML documents, enabling custom content to be merged into standard payslip or reporting output.
• FLEX_SEG_ENABLED checks whether a key flexfield segment is enabled, which governs whether that segment is considered during context derivation.

Tables Accessed

The package reads predominantly from payroll and HR configuration tables. PAY_ASSIGNMENT_ACTIONS and PAY_ACTION_INFORMATION supply the action and balance context, with the source excerpt showing cursors joining these tables to obtain assignment_action_id values and action_information1 through action_information18. PAY_PAYROLL_ACTIONS and PAY_LEGISLATION_RULES provide payroll run and legislative rule context. Element and input value data is drawn from PAY_ELEMENT_TYPES_F, PAY_ELEMENT_LINKS_F, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, PAY_INPUT_VALUES_F, and PAY_INPUT_VALUES_F_TL. HR_ORGANIZATION_INFORMATION, HR_SOFT_CODING_KEYFLEX, and FND_ID_FLEX_STRUCTURES support organization and flexfield context resolution. FND_SESSIONS is used for session-level context, and DUAL supports singleton queries such as the cursor that returns the action context identifier itself.

Usage Notes

PAY_NO_RULES is not referenced by any other package in the documented metadata, indicating it is an endpoint utility rather than a shared library. It is typically invoked indirectly during payroll processing — from payroll run logic, payslip generation, or rules evaluation — rather than being called directly by end users. Custom code should treat these functions as read-only context resolvers and should not assume stable signatures across releases; the header indicates the package was last modified for the 12.0.0 code line and remains present in 12.1.1 and 12.2.2. Developers extending payroll output should prefer the documented XML procedures for customization rather than modifying internal cursors.