Total Pageviews

Tuesday, 11 July 2023

EBS : API To Delete Concurrent Program and Executable in Oracle Apps (R12)

API To Delete Concurrent Program and Executable from Backend in Oracle Apps


---API : How to Delete Concurrent Program Executable From Backend 
DECLARE
   v_executable_short_name   VARCHAR2 (200);
   v_application             VARCHAR2 (200);
BEGIN
   v_executable_short_name := 'XX_SHORTNAME'; ---Short name 
   v_application           := 'Payables';
   apps.fnd_program.delete_executable (executable_short_name      => v_executable_short_name,
                                       application                => v_application
                                      );
   COMMIT;
END;
--API : How to Delete Concurrent Program AND Executable From Backend ---
begin
fnd_program.delete_program('TECHHARDS_SHORTNAME','APPLICATION');
fnd_program.delete_executable('TECHHARDS_EXE_NAME','APPLICATION');
COMMIT;
end; 

***********************************************************************************
#Oracle Apps #EBS #Concurrent Program #Executable 

#How to Delete Concurrent Program through API
#How to Delete Concurrent Program Executable through API
# Fnd_Concurrent_Requests

No comments:

Post a Comment

FUSION: Purchasing Query

  1) ---------CPA to PO Amount---------- select poh.segment1, (select sum(nvl(cpol.quantity,1)* cpol.unit_price) from po_headers_all cpoh,po...