API to Delete lookup type in oracle apps

API to Delete lookup type in oracle apps

In this post , we will be discuss about API to Delete lookup type in oracle apps. Oracle has provided the standard API to delete the lookup's code in oracle apps. Using this standard API , we can delete the lookup code from back end in oracle apps. This will help to mass delete the lookup codes from the oracle lookup's in oracle apps. We will share the complete PLSQL script , which will help to delete the lookup type in oracle apps. Here below is the Details About API to Delete lookup type code in oracle apps.

API to Delete lookup type in oracle apps

Important API to delete lookup type in oracle apps

fnd_lookup_values_pkg.delete_row

Detail PLSQL Script using API to Delete lookup type in oracle apps

Here below is the detail 

DECLARE

   CURSOR CUR_LOOKUP_CODE

   IS

      SELECT lookup_type, lookup_code, security_group_id,

             view_application_id

        FROM apps.fnd_lookup_values

       WHERE lookup_type = 'XX_TEST' AND lookup_code LIKE 'AB_%';

BEGIN

   FOR V_LOOKUP_CODE IN CUR_LOOKUP_CODE

   LOOP

      BEGIN

         fnd_lookup_values_pkg.delete_row

                             (x_lookup_type              => V.lookup_type,

                              x_security_group_id        => V.security_group_id,

                              x_view_application_id      => V.view_application_id,

                              x_lookup_code              => V.lookup_code

                             );

         COMMIT;

         DBMS_OUTPUT.put_line ('Lookup Code ' || i.lookup_code || ' has been deleted');

      EXCEPTION

         WHEN OTHERS

         THEN

        DBMS_OUTPUT.put_line ('Exception In Loop Error: ' || SQLERRM);

      END;

   END LOOP;

EXCEPTION

   WHEN OTHERS

   THEN

      DBMS_OUTPUT.put_line ('Main Error' || SQLERRM);

END;

API to Delete lookup type in oracle apps

API to Delete lookup type in oracle apps