eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGI_SLS_SECURITY_PKG dependencies on IGI_SLS_ALLOCATIONS

Line 238: FROM igi_sls_allocations

234:
235: -- Check if table is directly allocated to a Security Group
236: SELECT COUNT(*)
237: INTO l_count
238: FROM igi_sls_allocations
239: WHERE sls_allocation = p_table_name
240: AND sls_allocation_type = 'T'
241: AND sls_group_type = 'S'
242: AND date_disabled IS NULL

Line 250: FROM igi_sls_allocations a,

246: THEN
247: -- Check if table is indirectly allocated to a Security Group
248: SELECT COUNT(*)
249: INTO l_count
250: FROM igi_sls_allocations a,
251: igi_sls_allocations b
252: WHERE a.sls_group_type = 'S'
253: AND a.sls_allocation = b.sls_group
254: AND a.sls_allocation_type = 'P'

Line 251: igi_sls_allocations b

247: -- Check if table is indirectly allocated to a Security Group
248: SELECT COUNT(*)
249: INTO l_count
250: FROM igi_sls_allocations a,
251: igi_sls_allocations b
252: WHERE a.sls_group_type = 'S'
253: AND a.sls_allocation = b.sls_group
254: AND a.sls_allocation_type = 'P'
255: AND a.date_disabled IS NULL

Line 1084: FROM igi_sls_allocations a

1080:
1081: CURSOR c_del_alloc IS
1082: (SELECT a.sls_group sls_group,
1083: a.sls_allocation table_name
1084: FROM igi_sls_allocations a
1085: WHERE a.sls_group_type = 'S'
1086: AND a.sls_allocation_type = 'T'
1087: AND a.date_removed IS NOT NULL
1088: UNION

Line 1091: FROM igi_sls_aLlocations a,

1087: AND a.date_removed IS NOT NULL
1088: UNION
1089: SELECT a.sls_group sls_group,
1090: d.sls_allocation table_name
1091: FROM igi_sls_aLlocations a,
1092: igi_sls_allocations d
1093: WHERE a.sls_allocation = d.sls_group
1094: AND a.sls_group_type = 'S'
1095: AND a.sls_allocation_type = 'P'

Line 1092: igi_sls_allocations d

1088: UNION
1089: SELECT a.sls_group sls_group,
1090: d.sls_allocation table_name
1091: FROM igi_sls_aLlocations a,
1092: igi_sls_allocations d
1093: WHERE a.sls_allocation = d.sls_group
1094: AND a.sls_group_type = 'S'
1095: AND a.sls_allocation_type = 'P'
1096: AND d.sls_group_type = 'P'

Line 1123: write_to_log (l_state_level, 'cleanup_data', 'Cleanup_Data, Updating deleted tables in igi_sls_allocations');

1119:
1120: BEGIN
1121:
1122: -- for every table, mark the allocations as deleted.
1123: write_to_log (l_state_level, 'cleanup_data', 'Cleanup_Data, Updating deleted tables in igi_sls_allocations');
1124: FOR rt_c_del_table IN c_del_table
1125: LOOP
1126: UPDATE igi_sls_allocations
1127: SET date_removed = rt_c_del_table.date_removed,

Line 1126: UPDATE igi_sls_allocations

1122: -- for every table, mark the allocations as deleted.
1123: write_to_log (l_state_level, 'cleanup_data', 'Cleanup_Data, Updating deleted tables in igi_sls_allocations');
1124: FOR rt_c_del_table IN c_del_table
1125: LOOP
1126: UPDATE igi_sls_allocations
1127: SET date_removed = rt_c_del_table.date_removed,
1128: date_disabled = Nvl(date_disabled, rt_c_del_table.date_removed),
1129: last_update_login = to_number(fnd_profile.value('LOGIN_ID')),
1130: last_update_date = SYSDATE,

Line 1140: INSERT INTO igi_sls_allocations_audit

1136:
1137: -- Insert into the allocations audit table, the history for the the
1138: -- record that is about to be deleted.
1139: -- Insert the record only if it has not already been done earlier.
1140: INSERT INTO igi_sls_allocations_audit
1141: (sls_group,
1142: sls_group_type,
1143: sls_allocation,
1144: sls_allocation_type,

Line 1168: FROM igi_sls_allocations a

1164: created_by,
1165: last_update_login,
1166: last_update_date,
1167: last_updated_by
1168: FROM igi_sls_allocations a
1169: WHERE a.sls_allocation = rt_c_del_table.table_name
1170: AND a.date_removed = rt_c_del_table.date_removed
1171: AND NOT EXISTS (SELECT 'X'
1172: FROM igi_sls_allocations_audit b

Line 1172: FROM igi_sls_allocations_audit b

1168: FROM igi_sls_allocations a
1169: WHERE a.sls_allocation = rt_c_del_table.table_name
1170: AND a.date_removed = rt_c_del_table.date_removed
1171: AND NOT EXISTS (SELECT 'X'
1172: FROM igi_sls_allocations_audit b
1173: WHERE a.sls_allocation = b.sls_allocation
1174: AND a.sls_group = b.sls_group
1175: AND a.date_enabled = b.date_enabled
1176: AND a.date_removed = b.date_removed);

Line 1181: write_to_log (l_state_level, 'cleanup_data', 'Cleanup_Data, Updating deleted group in igi_sls_allocations');

1177:
1178: END LOOP ; -- for each deleted table
1179:
1180: -- for every group, mark the allocations as deleted.
1181: write_to_log (l_state_level, 'cleanup_data', 'Cleanup_Data, Updating deleted group in igi_sls_allocations');
1182: FOR rt_c_del_group IN c_del_group
1183: LOOP
1184: UPDATE igi_sls_allocations
1185: SET date_removed = rt_c_del_group.date_removed,

Line 1184: UPDATE igi_sls_allocations

1180: -- for every group, mark the allocations as deleted.
1181: write_to_log (l_state_level, 'cleanup_data', 'Cleanup_Data, Updating deleted group in igi_sls_allocations');
1182: FOR rt_c_del_group IN c_del_group
1183: LOOP
1184: UPDATE igi_sls_allocations
1185: SET date_removed = rt_c_del_group.date_removed,
1186: date_disabled = Nvl(date_disabled, rt_c_del_group.date_removed),
1187: last_update_login = to_number(fnd_profile.value('LOGIN_ID')),
1188: last_update_date = SYSDATE,

Line 1197: INSERT INTO igi_sls_allocations_audit

1193:
1194: -- Insert into the allocations audit table, the history for the the
1195: -- record that is about to be deleted.
1196: -- Insert the record only if it has not already been done earlier.
1197: INSERT INTO igi_sls_allocations_audit
1198: (sls_group,
1199: sls_group_type,
1200: sls_allocation,
1201: sls_allocation_type,

Line 1225: FROM igi_sls_allocations a

1221: created_by,
1222: last_update_login,
1223: last_update_date,
1224: last_updated_by
1225: FROM igi_sls_allocations a
1226: WHERE a.sls_group = rt_c_del_group.sls_group
1227: AND a.sls_group_type = rt_c_del_group.sls_group_type
1228: AND a.date_removed = rt_c_del_group.date_removed
1229: AND NOT EXISTS (SELECT 'X'

Line 1230: FROM igi_sls_allocations_audit b

1226: WHERE a.sls_group = rt_c_del_group.sls_group
1227: AND a.sls_group_type = rt_c_del_group.sls_group_type
1228: AND a.date_removed = rt_c_del_group.date_removed
1229: AND NOT EXISTS (SELECT 'X'
1230: FROM igi_sls_allocations_audit b
1231: WHERE a.sls_allocation = b.sls_allocation
1232: AND a.sls_group = b.sls_group
1233: AND a.sls_group_type = b.sls_group_type
1234: AND a.date_enabled = b.date_enabled

Line 1239: UPDATE igi_sls_allocations

1235: AND a.date_removed = b.date_removed);
1236:
1237: IF rt_c_del_group.sls_group_type = 'P'
1238: THEN
1239: UPDATE igi_sls_allocations
1240: SET date_removed = rt_c_del_group.date_removed,
1241: date_disabled = Nvl(date_disabled, rt_c_del_group.date_removed),
1242: last_update_login = to_number(fnd_profile.value('LOGIN_ID')),
1243: last_update_date = SYSDATE,

Line 1252: INSERT INTO igi_sls_allocations_audit

1248:
1249: -- Insert into the allocations audit table, the history for the the
1250: -- record that is about to be deleted.
1251: -- Insert the record only if it has not already been done earlier.
1252: INSERT INTO igi_sls_allocations_audit
1253: (sls_group,
1254: sls_group_type,
1255: sls_allocation,
1256: sls_allocation_type,

Line 1280: FROM igi_sls_allocations a

1276: created_by,
1277: last_update_login,
1278: last_update_date,
1279: last_updated_by
1280: FROM igi_sls_allocations a
1281: WHERE a.sls_allocation = rt_c_del_group.sls_group
1282: AND a.date_removed = rt_c_del_group.date_removed
1283: AND NOT EXISTS (SELECT 'X'
1284: FROM igi_sls_allocations_audit b

Line 1284: FROM igi_sls_allocations_audit b

1280: FROM igi_sls_allocations a
1281: WHERE a.sls_allocation = rt_c_del_group.sls_group
1282: AND a.date_removed = rt_c_del_group.date_removed
1283: AND NOT EXISTS (SELECT 'X'
1284: FROM igi_sls_allocations_audit b
1285: WHERE a.sls_allocation = b.sls_allocation
1286: AND a.sls_group = b.sls_group
1287: AND a.sls_group_type = b.sls_group_type
1288: AND a.date_enabled = b.date_enabled

Line 1294: -- For every record marked for deletion in igi_sls_allocations

1290:
1291: END IF;
1292: END LOOP ; -- for each deleted group
1293:
1294: -- For every record marked for deletion in igi_sls_allocations
1295: FOR rt_c_del_alloc IN c_del_alloc
1296: LOOP
1297: OPEN c_get_sls_tabname (rt_c_del_alloc.table_name);
1298: FETCH c_get_sls_tabname INTO l_sls_table_name,

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

1360:
1361: END LOOP;
1362:
1363: -- Delete all records marked for deletion
1364: write_to_log (l_state_level, 'cleanup_data', 'Cleanup_Data, Deleting ALL marked records from igi_sls_allocations');
1365: DELETE FROM igi_sls_allocations
1366: WHERE date_removed IS NOT NULL;
1367:
1368: write_to_log (l_state_level, 'cleanup_data', 'Cleanup_Data, Deleting ALL marked records from igi_sls_secure_tables');

Line 1365: DELETE FROM igi_sls_allocations

1361: END LOOP;
1362:
1363: -- Delete all records marked for deletion
1364: write_to_log (l_state_level, 'cleanup_data', 'Cleanup_Data, Deleting ALL marked records from igi_sls_allocations');
1365: DELETE FROM igi_sls_allocations
1366: WHERE date_removed IS NOT NULL;
1367:
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

Line 1420: FROM igi_sls_allocations

1416: SELECT sls_group,
1417: sls_allocation,
1418: date_disabled,
1419: date_removed
1420: FROM igi_sls_allocations
1421: WHERE date_security_applied IS NULL
1422: FOR UPDATE OF date_security_applied;
1423:
1424: rt_c_all_alloc c_all_alloc%ROWTYPE;

Line 1456: write_to_log (l_state_level, 'stamp_records', 'Populate_Group_Alloc, Updating table igi_sls_allocations.date_security_applied ');

1452:
1453: END IF;
1454: END LOOP;
1455:
1456: write_to_log (l_state_level, 'stamp_records', 'Populate_Group_Alloc, Updating table igi_sls_allocations.date_security_applied ');
1457: FOR rt_c_all_alloc IN c_all_alloc
1458: LOOP
1459: UPDATE igi_sls_allocations
1460: SET date_security_applied = SYSDATE,

Line 1459: UPDATE igi_sls_allocations

1455:
1456: write_to_log (l_state_level, 'stamp_records', 'Populate_Group_Alloc, Updating table igi_sls_allocations.date_security_applied ');
1457: FOR rt_c_all_alloc IN c_all_alloc
1458: LOOP
1459: UPDATE igi_sls_allocations
1460: SET date_security_applied = SYSDATE,
1461: last_update_login = to_number(fnd_profile.value('LOGIN_ID')),
1462: last_update_date = SYSDATE,
1463: last_updated_by = to_number(fnd_profile.value('USER_ID'))

Line 1473: UPDATE igi_sls_allocations_audit a

1469: -- of all actions then this IF condition will have to go.
1470: IF rt_c_all_alloc.date_disabled IS NOT NULL
1471: OR rt_c_all_alloc.date_removed IS NOT NULL
1472: THEN
1473: UPDATE igi_sls_allocations_audit a
1474: SET a.date_security_applied = SYSDATE
1475: WHERE a.date_security_applied IS NULL
1476: AND ROWID = (SELECT MAX(ROWID) b
1477: FROM igi_sls_allocations_audit b

Line 1477: FROM igi_sls_allocations_audit b

1473: UPDATE igi_sls_allocations_audit a
1474: SET a.date_security_applied = SYSDATE
1475: WHERE a.date_security_applied IS NULL
1476: AND ROWID = (SELECT MAX(ROWID) b
1477: FROM igi_sls_allocations_audit b
1478: WHERE a.sls_allocation = b.sls_allocation
1479: AND a.sls_group = b.sls_group)
1480: AND sls_allocation = rt_c_all_alloc.sls_allocation
1481: AND sls_group = rt_c_all_alloc.sls_group;

Line 1528: FROM igi_sls_allocations

1524: created_by,
1525: last_update_login,
1526: last_update_date,
1527: last_updated_by
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

Line 1534: FROM igi_sls_allocations

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'
1537: AND date_removed IS NULL;
1538:

Line 1666: FROM igi_sls_allocations

1662:
1663: -- Check if the allocation already exists in the target group.
1664: SELECT COUNT(*)
1665: INTO l_alloc_count
1666: FROM igi_sls_allocations
1667: WHERE sls_allocation = rt_c_grp_alloc.sls_allocation
1668: AND sls_group = rt_c_cons_recs.to_sls_security_group
1669: AND sls_allocation_type = rt_c_grp_alloc.sls_allocation_type;
1670:

Line 1679: FROM igi_sls_allocations a,

1675: -- Mark it disabled only if it is disabled in all groups, else
1676: -- Mark it enabled.
1677: SELECT COUNT(*)
1678: INTO l_enab_rec_count
1679: FROM igi_sls_allocations a,
1680: igi_sls_consolidate_groups b
1681: WHERE a.sls_group = b.from_sls_security_group
1682: AND a.date_disabled IS NULL
1683: AND a.date_removed IS NULL

Line 1698: INSERT INTO igi_sls_allocations

1694: l_date_disabled := NULL;
1695: END IF;
1696:
1697: -- Since Allocation does not exist, insert into the table.
1698: INSERT INTO igi_sls_allocations
1699: (sls_group,
1700: sls_group_type,
1701: sls_allocation,
1702: sls_allocation_type,