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_SECURE_TABLES

Line 227: FUNCTION check_allocation_exists ( p_table_name IN igi_sls_secure_tables.table_name%TYPE)

223: This function checks if allocations exist for the table
224:
225: Its is called from procedure IGI_SLS_SECURITY_PKG.APPLY_SECURITY only.
226: ------------------------------------------------------------------*/
227: FUNCTION check_allocation_exists ( p_table_name IN igi_sls_secure_tables.table_name%TYPE)
228: RETURN BOOLEAN
229: IS
230:
231: l_count NUMBER := 0;

Line 294: on their status in the igi_sls_secure_tables.

290:
291:
292: /*------------------------------------------------------------------
293: This proecdure creates , disables, drops the sls objects depending
294: on their status in the igi_sls_secure_tables.
295:
296: Its is called from procedure IGI_SLS_SECURITY_PKG.APPLY_SECURITY only.
297: ------------------------------------------------------------------*/
298: PROCEDURE create_drop_sls_objects ( p_mls_schema_name IN VARCHAR2,

Line 314: FROM igi_sls_secure_tables

310: date_security_applied,
311: date_object_created,
312: update_allowed,
313: NVL(optimise_sql,'N') optimise_sql
314: FROM igi_sls_secure_tables
315: WHERE date_security_applied IS NULL;
316:
317: rt_c_get_sectab c_get_sectab%ROWTYPE;
318:

Line 522: rt_c_get_sectab.table_name ||' updating igi_sls_secure_tables');

518:
519: IF retcode = 0
520: THEN
521: write_to_log ( l_state_level, 'create_drop_sls_objects', 'Create_Drop_SLS_Objects, All objects created successfully for '||
522: rt_c_get_sectab.table_name ||' updating igi_sls_secure_tables');
523:
524: UPDATE igi_sls_secure_tables
525: SET date_object_created = SYSDATE,
526: last_update_login = to_number(fnd_profile.value('LOGIN_ID')),

Line 524: UPDATE igi_sls_secure_tables

520: THEN
521: write_to_log ( l_state_level, 'create_drop_sls_objects', 'Create_Drop_SLS_Objects, All objects created successfully for '||
522: rt_c_get_sectab.table_name ||' updating igi_sls_secure_tables');
523:
524: UPDATE igi_sls_secure_tables
525: SET date_object_created = SYSDATE,
526: last_update_login = to_number(fnd_profile.value('LOGIN_ID')),
527: last_update_date = SYSDATE,
528: last_updated_by = to_number(fnd_profile.value('USER_ID'))

Line 718: write_to_log (l_state_level, 'create_drop_sls_objects', 'Create_Drop_SLS_Objects, Updating igi_sls_secure_tables.date_security_applied '||

714:
715: IF retcode = 0
716: THEN
717: -- All objects successfully created for the table.
718: write_to_log (l_state_level, 'create_drop_sls_objects', 'Create_Drop_SLS_Objects, Updating igi_sls_secure_tables.date_security_applied '||
719: ' for '|| rt_c_get_sectab.sls_table_name);
720:
721: UPDATE igi_sls_secure_tables
722: SET date_security_applied = l_date_security_applied,

Line 721: UPDATE igi_sls_secure_tables

717: -- All objects successfully created for the table.
718: write_to_log (l_state_level, 'create_drop_sls_objects', 'Create_Drop_SLS_Objects, Updating igi_sls_secure_tables.date_security_applied '||
719: ' for '|| rt_c_get_sectab.sls_table_name);
720:
721: UPDATE igi_sls_secure_tables
722: SET date_security_applied = l_date_security_applied,
723: last_update_login = to_number(fnd_profile.value('LOGIN_ID')),
724: last_update_date = SYSDATE,
725: last_updated_by = to_number(fnd_profile.value('USER_ID'))

Line 736: UPDATE igi_sls_secure_tables_audit a

732: -- of all actions then this IF condition will have to go.
733: IF rt_c_get_sectab.date_disabled IS NOT NULL
734: OR rt_c_get_sectab.date_removed IS NOT NULL
735: THEN
736: UPDATE igi_sls_secure_tables_audit a
737: SET a.date_security_applied = SYSDATE
738: WHERE a.date_security_applied IS NULL
739: AND ROWID = (SELECT MAX(ROWID) b
740: FROM igi_sls_secure_tables_audit b

Line 740: FROM igi_sls_secure_tables_audit b

736: UPDATE igi_sls_secure_tables_audit a
737: SET a.date_security_applied = SYSDATE
738: WHERE a.date_security_applied IS NULL
739: AND ROWID = (SELECT MAX(ROWID) b
740: FROM igi_sls_secure_tables_audit b
741: WHERE a.table_name = b.table_name
742: AND a.owner = b.owner)
743: AND table_name = rt_c_get_sectab.table_name
744: AND owner = rt_c_get_sectab.owner;

Line 750: END LOOP; -- For each record in igi_sls_secure_tables (c_get_sectab)

746: END IF;
747:
748: END IF;
749:
750: END LOOP; -- For each record in igi_sls_secure_tables (c_get_sectab)
751:
752: COMMIT;
753:
754: EXCEPTION

Line 769: for only the enabled tables in the igi_sls_secure_tables

765: END create_drop_sls_objects;
766:
767: /*------------------------------------------------------------------
768: This proecdure re-compiles i.e refreshes the triggers and procedures
769: for only the enabled tables in the igi_sls_secure_tables
770:
771: Its is called from procedure IGI_SLS_SECURITY_PKG.APPLY_SECURITY only.
772: ------------------------------------------------------------------*/
773: PROCEDURE refresh_sls_objects ( p_mls_schema_name IN VARCHAR2,

Line 790: FROM igi_sls_secure_tables

786: date_removed,
787: date_security_applied,
788: update_allowed,
789: Nvl(optimise_sql,'N') optimise_sql
790: FROM igi_sls_secure_tables
791: WHERE date_removed IS NULL
792: AND date_object_created IS NOT NULL;
793:
794: l_policy_type VARCHAR2(50);

Line 1063: FROM igi_sls_secure_tables

1059:
1060: CURSOR c_del_table IS
1061: SELECT table_name,
1062: date_removed
1063: FROM igi_sls_secure_tables
1064: WHERE date_removed IS NOT NULL;
1065:
1066: rt_c_del_table c_del_table%ROWTYPE;
1067:

Line 1111: FROM igi_sls_secure_tables

1107: SELECT sls_table_name,
1108: date_removed,
1109: table_name,
1110: NVL(optimise_sql,'N') optimise_sql
1111: FROM igi_sls_secure_tables
1112: WHERE table_name = p_table_name;
1113:
1114: l_sls_table_name igi_sls_secure_tables.sls_table_name%TYPE;
1115: l_date_removed igi_sls_secure_tables.date_removed%TYPE;

Line 1114: l_sls_table_name igi_sls_secure_tables.sls_table_name%TYPE;

1110: NVL(optimise_sql,'N') optimise_sql
1111: FROM igi_sls_secure_tables
1112: WHERE table_name = p_table_name;
1113:
1114: l_sls_table_name igi_sls_secure_tables.sls_table_name%TYPE;
1115: l_date_removed igi_sls_secure_tables.date_removed%TYPE;
1116: l_table_name igi_sls_secure_tables.table_name%TYPE;
1117: l_optimise_sql igi_sls_secure_tables.OPTIMISE_SQL%TYPE;
1118: l_sql_stmt VARCHAR2(1000);

Line 1115: l_date_removed igi_sls_secure_tables.date_removed%TYPE;

1111: FROM igi_sls_secure_tables
1112: WHERE table_name = p_table_name;
1113:
1114: l_sls_table_name igi_sls_secure_tables.sls_table_name%TYPE;
1115: l_date_removed igi_sls_secure_tables.date_removed%TYPE;
1116: l_table_name igi_sls_secure_tables.table_name%TYPE;
1117: l_optimise_sql igi_sls_secure_tables.OPTIMISE_SQL%TYPE;
1118: l_sql_stmt VARCHAR2(1000);
1119:

Line 1116: l_table_name igi_sls_secure_tables.table_name%TYPE;

1112: WHERE table_name = p_table_name;
1113:
1114: l_sls_table_name igi_sls_secure_tables.sls_table_name%TYPE;
1115: l_date_removed igi_sls_secure_tables.date_removed%TYPE;
1116: l_table_name igi_sls_secure_tables.table_name%TYPE;
1117: l_optimise_sql igi_sls_secure_tables.OPTIMISE_SQL%TYPE;
1118: l_sql_stmt VARCHAR2(1000);
1119:
1120: BEGIN

Line 1117: l_optimise_sql igi_sls_secure_tables.OPTIMISE_SQL%TYPE;

1113:
1114: l_sls_table_name igi_sls_secure_tables.sls_table_name%TYPE;
1115: l_date_removed igi_sls_secure_tables.date_removed%TYPE;
1116: l_table_name igi_sls_secure_tables.table_name%TYPE;
1117: l_optimise_sql igi_sls_secure_tables.OPTIMISE_SQL%TYPE;
1118: l_sql_stmt VARCHAR2(1000);
1119:
1120: BEGIN
1121:

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

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

Line 1369: DELETE FROM igi_sls_secure_tables

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

Line 1539: CURSOR c_sls_tname (p_table_name igi_sls_secure_tables.table_name%TYPE) IS

1535: WHERE sls_group = p_sls_group
1536: AND sls_allocation_type = 'T'
1537: AND date_removed IS NULL;
1538:
1539: CURSOR c_sls_tname (p_table_name igi_sls_secure_tables.table_name%TYPE) IS
1540: SELECT sls_table_name,
1541: -- Bug 5144650 .. Start
1542: NVL(optimise_sql,'N') optimise_sql
1543: -- Bug 5144650 .. End

Line 1544: FROM igi_sls_secure_tables

1540: SELECT sls_table_name,
1541: -- Bug 5144650 .. Start
1542: NVL(optimise_sql,'N') optimise_sql
1543: -- Bug 5144650 .. End
1544: FROM igi_sls_secure_tables
1545: WHERE table_name = p_table_name;
1546:
1547: l_sls_tabname igi_sls_secure_tables.sls_table_name%TYPE;
1548: l_sql_stmt VARCHAR2(1000);

Line 1547: l_sls_tabname igi_sls_secure_tables.sls_table_name%TYPE;

1543: -- Bug 5144650 .. End
1544: FROM igi_sls_secure_tables
1545: WHERE table_name = p_table_name;
1546:
1547: l_sls_tabname igi_sls_secure_tables.sls_table_name%TYPE;
1548: l_sql_stmt VARCHAR2(1000);
1549: l_alloc_count NUMBER;
1550: l_text VARCHAR2(500);
1551: l_enab_rec_count NUMBER;

Line 1556: l_optimise_sql igi_sls_secure_tables.optimise_sql%TYPE;

1552: l_date_disabled DATE;
1553: l_sysdate DATE := SYSDATE;
1554:
1555: -- Bug 5144650 .. Start
1556: l_optimise_sql igi_sls_secure_tables.optimise_sql%TYPE;
1557: -- Bug 5144650 .. End
1558: no_table_exists EXCEPTION;
1559: PRAGMA EXCEPTION_INIT (no_table_exists, -00942);
1560:

Line 1911: FROM igi_sls_secure_tables a,

1907: b.table_name,
1908: b.sls_security_group,
1909: a.owner,
1910: Nvl(a.optimise_sql,'N') optimise_sql
1911: FROM igi_sls_secure_tables a,
1912: igi_sls_security_group_alloc b
1913: WHERE a.table_name = b.table_name
1914: AND b.sls_security_group = Nvl(p_sec_grp , b.sls_security_group);
1915:

Line 1951: FROM igi_sls_secure_tables a,

1947:
1948: -- Check if Security has been applied
1949: SELECT COUNT(*)
1950: INTO l_count
1951: FROM igi_sls_secure_tables a,
1952: all_objects b
1953: WHERE a.sls_table_name = b.object_name
1954: AND b.owner = l_schema; -- Bug 3431843 hkaniven
1955: