Validate AP invoices using API
Hi;
i have to validate AP Invoices using API in pl/sql.
i use this API
| nRequestId := FND_REQUEST.submit_request( | |||||
| 'SQLAP', --application => | |||||
| 'APXPRVL', -- Program or 'APPRVL' | |||||
| null,--Description => | |||||
| SYSDATE,--Start_time => | |||||
| FALSE,--Sub_request => | |||||
| '161', --fnd_profile.VALUE ('ORG_ID =>'), -- Operating Unit (optional) | |||||
| 'All', -- Match Option | |||||
| null,-- lv_tec_batch_name, -- Batch Name (required) | |||||
| v_strt_date, -- Invoice Start Date (optional) | |||||
| v_end_date, -- Invoice End Date (optional) | |||||
| null, -- Vendor ID(optional) | |||||
| null, -- Pay group(Optional) | |||||
| null, -- Invoice Id (optional) | |||||
| null, -- User Id (Optional) | |||||
| 'No', -- Trace Option (required) |
Tagged:
0