APPS.IGI_SLS_SECURITY_PKG dependencies on IGI_SLS_ALLOCATIONS_AUDIT

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 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 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 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 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 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 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;