Delete API (Withholding Tax Open Interface)


	Previous	Next		Contents	Index	Glossary	Library

Delete API (Withholding Tax Open Interface)

One API is provided for deleting external withholding tax transactions.

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>');
For example:

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 ''.

Contents

Index

Glossary

Library

je_es_whtax.del_trans(
P_ORG_NAME	=>	'<Org Name>',
P_FIN_IND	=>	'<Fin Ind>');