APPS.HR_DM_DELETE dependencies on FND_SECURITY_GROUPS

Line 113: -- * FND_SECURITY_GROUPS

109: -- Description: For the business group being deleted, the following
110: -- items are removed via FND APIs:
111: --
112: -- * Local lookups
113: -- * FND_SECURITY_GROUPS
114: -- * FND_USER_RESP_GROUPS
115: --
116: -- Input Parameters
117: -- p_business_group_id - business_group_id to delete

Line 168: fnd_security_groups s

164: FROM fnd_user_resp_groups rg,
165: fnd_user u,
166: fnd_application a,
167: fnd_responsibility r,
168: fnd_security_groups s
169: WHERE rg.user_id = u.user_id
170: AND rg.responsibility_application_id = a.application_id
171: AND rg.responsibility_id = r.responsibility_id
172: AND rg.security_group_id = s.security_group_id

Line 260: -- delete FND_SECURITY_GROUPS

256: END LOOP;
257: CLOSE csr_usrresgrp;
258:
259:
260: -- delete FND_SECURITY_GROUPS
261: fnd_security_groups_pkg.delete_row(l_security_group_id);
262:
263:
264: END IF;

Line 261: fnd_security_groups_pkg.delete_row(l_security_group_id);

257: CLOSE csr_usrresgrp;
258:
259:
260: -- delete FND_SECURITY_GROUPS
261: fnd_security_groups_pkg.delete_row(l_security_group_id);
262:
263:
264: END IF;
265: