Search Results cf_deductions_existformula
Overview
PAY_PAYSGSOE_XMLP_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM as a supporting package (API classification OTHER). Its naming convention—XMLP within the package name—indicates that it supports an Oracle XML Publisher (BI Publisher) concurrent report, specifically a Singapore statutory earnings and deductions report (the "SGSOE" component is consistent with Singapore-specific payroll reporting). The package holds the runtime parameters, formula functions, and data-shaping logic that an XML Publisher data template or report definition depends on when producing output for a given payroll action.
The package is declared with AUTHID CURRENT_USER and exposes a substantial set of global variables that mirror the report's concurrent program parameters and derived totals. These include identifiers such as P_ASSIGNMENT_ID, P_BUSINESS_GROUP_ID, P_LOCATION_ID, P_PAYROLL_ACTION_ID, P_PAYROLL_ID, and P_CONC_REQUEST_ID, alongside descriptive fields such as P_ORGANIZATION_NAME and four sort-order parameters (P_SORT_ORDER_1 through P_SORT_ORDER_4). Currency-based accumulator variables—gross pay, net pay, statutory deductions, other earnings, non-payroll items, and CPF (Central Provident Fund) amounts for employee, employer, and total—are initialised to zero and populated during report execution to carry period-to-date and current-period balances.
Key Procedures and Functions
The package documents forty-four procedures and functions. Core report lifecycle routines include BEFOREREPORT and AFTERREPORT, which bracket execution and typically handle context initialisation and cleanup. CONSTRUCT_WHERE_CLAUSE and CONSTRUCT_ORDER_BY build the dynamic SQL fragments used to filter and sort the report's employee result set.
Formatting-related functions render numeric output according to Oracle format masks. These include CF_CURRENCY_FORMAT_MASKFORMULA, CF_PERCENT_FORMAT_MASKFORMULA, CF_HOURS_FORMAT_MASKFORMULA, CF_RATE_FORMAT_MASKFORMULA, and CF_FX_RATE_FORMAT_MASKFORMULA. The function referenced in the user's search—CF_HOURS_FORMAT_MASKFORMULA—applies the appropriate format mask to hour quantities so that displayed values follow the localisation and mask conventions expected of the report.
Calculation and lookup functions shape the payroll data. CF_GROSS_PAY_CURRFORMULA, CF_HOURLY_RATEFORMULA, CF_FX_AMOUNTFORMULA, and CF_GET_ABSENCE_DETAILSFORMULA derive monetary, rate, exchange, and absence values respectively. CF_ADDRESS_LINE1FORMULA and the helper procedures CP_ADDRESS_LINE2_P, CP_ADDRESS_LINE3_P, and CP_TOWN_P resolve address components. CF_1FORMULA acts as a general-purpose formula placeholder. Finally, CF_DEDUCTIONS_EXISTFORMULA and CF_MESSAGES_EXISTFORMULA return indicators that control conditional sections of the report output.
Tables Accessed
The package references four APPS-synonym tables. FND_CURRENCIES supplies currency definitions and precision used by the currency and exchange-rate format functions. FND_TERRITORIES_TL provides translated territory names supporting address and country rendering. PAY_ACTION_INTERLOCKS and PAY_ASSIGNMENT_ACTIONS are core payroll tables queried to identify the payroll action and assignment-level processing records that drive the report's population of employees and their earnings, deductions, and balances.
Usage Notes
PAY_PAYSGSOE_XMLP_PKG is invoked indirectly as the supporting PL/SQL library for its associated XML Publisher concurrent program. Users launch the report through the Submit Requests form in the Singapore payroll responsibility, supplying the payroll action and assignment parameters surfaced by the concurrent program. The package does not appear to be referenced by other packages, so direct invocation from custom code is unusual; any custom integration should call the underlying concurrent program rather than the package functions. Because it relies on AUTHID CURRENT_USER and APPS synonyms, calls must run in a context where the APPS schema grants are available, typically within the standard concurrent manager runtime.