Scribd
Upload
308 views3 pages

Federal Tax Rule Update API Guide

The document provides instructions for updating federal tax rules using an API. It includes the API name, sample code to call the API with parameters to update a specific employee's federal tax rule, and notes to commit the changes and verify the update.

Uploaded by

ERPWebTutor
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
308 views3 pages

Federal Tax Rule Update API Guide

The document provides instructions for updating federal tax rules using an API. It includes the API name, sample code to call the API with parameters to update a specific employee's federal tax rule, and notes to commit the changes and verify the update.

Uploaded by

ERPWebTutor
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Federal Tax Rules update using API

Doc Prepared By: Date Prepared: Version: Arideep Mukherjee 20-July-2011 Initial Draft for internal Use

Here is the original information:

The following query provides the data from the table:


SELECT * FROM PAY_US_EMP_FED_TAX_RULES_F WHERE ASSIGNMENT_ID = 1973

The api to update the federal tax rule is:


pay_federal_tax_rule_api

Use the following piece of code to achieve this:

DECLARE L_EFFECTIVE_END_DATE DATE; l_effective_start_date DATE; L_OBJECT_VERSION_NUMBER NUMBER; BEGIN -- Call the procedure SELECT object_version_number,effective_start_date INTO L_OBJECT_VERSION_NUMBER, l_effective_start_date FROM PAY_US_EMP_FED_TAX_RULES_F WHERE ASSIGNMENT_ID = 1973; PAY_FEDERAL_TAX_RULE_API.UPDATE_FED_TAX_RULE(P_VALIDATE P_EFFECTIVE_DATE P_DATETRACK_UPDATE_MODE P_EMP_FED_TAX_RULE_ID P_OBJECT_VERSION_NUMBER P_SUI_STATE_CODE P_ADDITIONAL_WA_AMOUNT P_FILING_STATUS_CODE P_FIT_OVERRIDE_AMOUNT P_FIT_OVERRIDE_RATE P_WITHHOLDING_ALLOWANCES P_CUMULATIVE_TAXATION P_EIC_FILING_STATUS_CODE P_FIT_ADDITIONAL_TAX P_FIT_EXEMPT P_FUTA_TAX_EXEMPT P_MEDICARE_TAX_EXEMPT P_SS_TAX_EXEMPT P_WAGE_EXEMPT P_STATUTORY_EMPLOYEE P_W2_FILED_YEAR P_SUPP_TAX_OVERRIDE_RATE P_EXCESSIVE_WA_REJECT_DATE P_EFFECTIVE_START_DATE P_EFFECTIVE_END_DATE END; => => => => => => => => => => => => => => => => => => => => => => => => => FALSE, TO_DATE('5-jul-2011'), 'UPDATE', 1293, L_OBJECT_VERSION_NUMBER, '05', 0, 02, 0, 0, 2, 'N', '2', 0, 'N', 'N', 'N', 'N', 'N', 'N', NULL, 0, NULL, l_effective_start_date, L_EFFECTIVE_END_DATE);

Commit to save your work. Now navigate back to the employee tax info screen in Oracle.

Note the changes.

You might also like