Adhoc Roles in Oracle Workflow
Before reading this article, read about Roles in Workflow if you are not aware of what a role is about. A role can be created… Read More »Adhoc Roles in Oracle Workflow
creating adhoc role
PL/SQL Script to Create Adhoc Role
DECLARE ln_role_count NUMBER; lc_role_name apps.wf_roles.NAME%TYPE := ‘XX_TEST_ROLE’; lc_role_display_name apps.wf_roles.description%TYPE := ‘XX Test Role’; BEGIN —————————— –Checking if Adhoc Role Exits —————————— SELECT COUNT (1) INTO… Read More »PL/SQL Script to Create Adhoc Role