APPS.BIS_RG_SCHEDULES_PVT dependencies on WF_LOCAL_ROLES

Line 1812: delete wf_local_roles

1808: from WF_LOCAL_USER_ROLES
1809: where role_name = vRoleName;
1810:
1811: if vUserExists = 0 then
1812: delete wf_local_roles
1813: where name = gvRoleName||c1.file_id;
1814: end if;
1815: end if;
1816:

Line 2135: delete wf_local_roles

2131: where schedule_id = pScheduleId;
2132:
2133: -- Step 4 - Delete Role
2134:
2135: delete wf_local_roles
2136: where name = gvRoleName||pScheduleId;
2137:
2138: -- Step 5 - Cancel Request
2139: cancelRequest(vRequestId);

Line 2363: delete wf_local_roles

2359: delete fnd_lobs
2360: where file_id = c1.file_id;
2361:
2362: -- Step 2 - Delete Role
2363: delete wf_local_roles
2364: where name = gvRoleName||c1.file_id;
2365: end if;
2366:
2367: -- Step 3 - Delete the user preference

Line 2382: delete wf_local_roles

2378: where file_id IN (select file_id from bis_schedule_preferences where schedule_id = pScheduleId);
2379:
2380: -- Step 2 - Delete Role
2381:
2382: delete wf_local_roles
2383: where name IN (select gvRoleName||file_id from bis_schedule_preferences where schedule_id = pScheduleId);
2384:
2385: -- Step 3 - Delete all preferences for this schedule
2386: delete bis_schedule_preferences