APPS.IGI_SLS_SECURITY_PKG dependencies on IGI_SLS_GROUPS

Line 1072: FROM igi_sls_groups

1068: CURSOR c_del_group IS
1069: SELECT sls_group,
1070: sls_group_type,
1071: date_removed
1072: FROM igi_sls_groups
1073: WHERE date_removed IS NOT NULL;
1074:
1075: rt_c_del_group c_del_group%ROWTYPE;
1076:

Line 1372: write_to_log (l_state_level, 'cleanup_data', 'Cleanup_Data, Deleting ALL marked records from igi_sls_groups');

1368: write_to_log (l_state_level, 'cleanup_data', 'Cleanup_Data, Deleting ALL marked records from igi_sls_secure_tables');
1369: DELETE FROM igi_sls_secure_tables
1370: WHERE date_removed IS NOT NULL;
1371:
1372: write_to_log (l_state_level, 'cleanup_data', 'Cleanup_Data, Deleting ALL marked records from igi_sls_groups');
1373: DELETE FROM igi_sls_groups
1374: WHERE date_removed IS NOT NULL;
1375:
1376: COMMIT;

Line 1373: DELETE FROM igi_sls_groups

1369: DELETE FROM igi_sls_secure_tables
1370: WHERE date_removed IS NOT NULL;
1371:
1372: write_to_log (l_state_level, 'cleanup_data', 'Cleanup_Data, Deleting ALL marked records from igi_sls_groups');
1373: DELETE FROM igi_sls_groups
1374: WHERE date_removed IS NOT NULL;
1375:
1376: COMMIT;
1377:

Line 1409: FROM igi_sls_groups

1405: CURSOR c_all_group IS
1406: SELECT sls_group,
1407: date_removed,
1408: date_disabled
1409: FROM igi_sls_groups
1410: WHERE date_security_applied IS NULL
1411: FOR UPDATE OF date_security_applied;
1412:
1413: rt_c_all_group c_all_group%ROWTYPE;

Line 1428: write_to_log (l_state_level, 'stamp_records', 'Populate_Group_Alloc, Updating table igi_sls_groups.date_security_applied ');

1424: rt_c_all_alloc c_all_alloc%ROWTYPE;
1425:
1426: BEGIN
1427:
1428: write_to_log (l_state_level, 'stamp_records', 'Populate_Group_Alloc, Updating table igi_sls_groups.date_security_applied ');
1429: FOR rt_c_all_group IN c_all_group
1430: LOOP
1431: UPDATE igi_sls_groups
1432: SET date_security_applied = SYSDATE,

Line 1431: UPDATE igi_sls_groups

1427:
1428: write_to_log (l_state_level, 'stamp_records', 'Populate_Group_Alloc, Updating table igi_sls_groups.date_security_applied ');
1429: FOR rt_c_all_group IN c_all_group
1430: LOOP
1431: UPDATE igi_sls_groups
1432: SET date_security_applied = SYSDATE,
1433: last_update_login = to_number(fnd_profile.value('LOGIN_ID')),
1434: last_update_date = SYSDATE,
1435: last_updated_by = to_number(fnd_profile.value('USER_ID'))

Line 1445: UPDATE igi_sls_groups_audit a

1441: -- of all actions then this IF condition will have to go.
1442: IF rt_c_all_group.date_disabled IS NOT NULL
1443: OR rt_c_all_group.date_removed IS NOT NULL
1444: THEN
1445: UPDATE igi_sls_groups_audit a
1446: SET a.date_security_applied = SYSDATE
1447: WHERE date_security_applied IS NULL
1448: AND ROWID = (SELECT MAX(ROWID) b
1449: FROM igi_sls_groups_audit b

Line 1449: FROM igi_sls_groups_audit b

1445: UPDATE igi_sls_groups_audit a
1446: SET a.date_security_applied = SYSDATE
1447: WHERE date_security_applied IS NULL
1448: AND ROWID = (SELECT MAX(ROWID) b
1449: FROM igi_sls_groups_audit b
1450: WHERE a.sls_group = b.sls_group)
1451: AND sls_group = rt_c_all_group.sls_group;
1452:
1453: END IF;

Line 1514: CURSOR c_grp_alloc (p_sls_group igi_sls_groups.sls_group%TYPE) IS

1510: to_sls_security_group
1511: FROM igi_sls_consolidate_groups
1512: WHERE date_security_applied IS NULL;
1513:
1514: CURSOR c_grp_alloc (p_sls_group igi_sls_groups.sls_group%TYPE) IS
1515: SELECT sls_group,
1516: sls_group_type,
1517: sls_allocation,
1518: sls_allocation_type,

Line 1532: CURSOR c_prcgrp_alloc (p_sls_group igi_sls_groups.sls_group%TYPE) IS

1528: FROM igi_sls_allocations
1529: WHERE sls_group = p_sls_group
1530: AND date_removed IS NULL;
1531:
1532: CURSOR c_prcgrp_alloc (p_sls_group igi_sls_groups.sls_group%TYPE) IS
1533: SELECT sls_allocation
1534: FROM igi_sls_allocations
1535: WHERE sls_group = p_sls_group
1536: AND sls_allocation_type = 'T'

Line 1733: UPDATE igi_sls_groups

1729:
1730: -- Mark the group for deletion,
1731: -- The allocation and the audit table population will be done in the
1732: -- cleanup_data procedure. Hence, date_security_applied is set to null.
1733: UPDATE igi_sls_groups
1734: SET date_disabled = Nvl(date_disabled, l_sysdate),
1735: date_removed = SYSDATE,
1736: date_security_applied = NULL,
1737: last_update_login = to_number(fnd_profile.value('LOGIN_ID')),

Line 1745: INSERT INTO igi_sls_groups_audit

1741: AND date_removed IS NULL;
1742:
1743: -- Since the group is being marked for deletion, enter a record
1744: -- into the audit table.
1745: INSERT INTO igi_sls_groups_audit
1746: (sls_group,
1747: sls_group_type,
1748: description,
1749: date_enabled,

Line 1771: FROM igi_sls_groups

1767: created_by,
1768: last_update_login,
1769: last_update_date,
1770: last_updated_by
1771: FROM igi_sls_groups
1772: WHERE sls_group = rt_c_cons_recs.from_sls_security_group
1773: AND date_removed = l_sysdate;
1774:
1775: UPDATE igi_sls_consolidate_groups