APPS.WF_MAINTENANCE dependencies on FND_GRANTS

Line 225: from FND_GRANTS fg

221: l_roleInfoTAB WF_DIRECTORY.wf_local_roles_tbl_type;
222:
223: cursor cWorklistAccess is
224: select fg.rowid
225: from FND_GRANTS fg
226: where fg.GRANTEE_TYPE='USER'
227: and fg.GRANTEE_ORIG_SYSTEM in ('FND_USR', 'PER')
228: and fg.PROGRAM_NAME = 'WORKFLOW_UI'
229: and fg.PARAMETER1=PropagateChangedName.OldName;

Line 614: UPDATE fnd_grants fg

610: if (rowIdTbl.count = 0) then
611: exit;
612: end if;
613: FORALL i IN rowIdTbl.FIRST..rowIdTbl.LAST
614: UPDATE fnd_grants fg
615: SET fg.parameter1=PropagateChangedName.NewName
616: WHERE fg.ROWID=rowIdTbl(i);
617: COMMIT;
618: rowIdTbl.DELETE;

Line 1998: -- Determine the entries in FND_GRANTS associated to this role.

1994: l_wfcount_tab := null;
1995: else
1996: l_wfcount_tab.USER_NAME:=p_name;
1997:
1998: -- Determine the entries in FND_GRANTS associated to this role.
1999: select nvl(count(1), 0) into l_wfcount_tab.REC_CNT
2000: from FND_GRANTS fg
2001: where fg.GRANTEE_TYPE='USER'
2002: and fg.GRANTEE_ORIG_SYSTEM in ('FND_USR', 'PER')

Line 2000: from FND_GRANTS fg

1996: l_wfcount_tab.USER_NAME:=p_name;
1997:
1998: -- Determine the entries in FND_GRANTS associated to this role.
1999: select nvl(count(1), 0) into l_wfcount_tab.REC_CNT
2000: from FND_GRANTS fg
2001: where fg.GRANTEE_TYPE='USER'
2002: and fg.GRANTEE_ORIG_SYSTEM in ('FND_USR', 'PER')
2003: and fg.PROGRAM_NAME = 'WORKFLOW_UI'
2004: and fg.PARAMETER1=p_name;

Line 2005: l_wfcount_tab.TABLE_NAME :='FND_GRANTS';

2001: where fg.GRANTEE_TYPE='USER'
2002: and fg.GRANTEE_ORIG_SYSTEM in ('FND_USR', 'PER')
2003: and fg.PROGRAM_NAME = 'WORKFLOW_UI'
2004: and fg.PARAMETER1=p_name;
2005: l_wfcount_tab.TABLE_NAME :='FND_GRANTS';
2006: pipe ROW (l_wfcount_tab);
2007:
2008: -- Determine the workflow processes owned by this role. Can be any role.
2009: if (l_pvalue is null or l_pvalue = 'Y') then