Previous | Next | Contents | Index | Glossary | Library |
To delete external withholding tax transactions from the interface table:
1. Log into SQL*PLUS to your Oracle Financials database APPS account.
SQLPLUS <APPS_USER>/<APPS_PASSWORD>
where APPS_USER is your APPS account username and APPS_PASSWORD is your APPS account password.
2. Enable messaging by entering the command:
SET SERVEROUTPUT ON
To delete all external withholding tax transactions use the API with the parameters listed below:
je_es_whtax.del_trans(
|
|
|
P_ORG_NAME
| =>
| '<Org Name>',
|
P_FIN_IND
| =>
| '<Fin Ind>');
|
execute je_es_whtax.del_trans(P_ORG_NAME =>'Spanish Operating Unit ABC', P_FIN_IND=>'X');
Note: P_ORG_NAME Parameter
In Multi-Org installations, the API must be passed the organization operating unit name. In non Multi-Org installations, this parameter must be passed the value NULL or ''.
Previous | Next | Contents | Index | Glossary | Library |