DBA Data[Home] [Help]

APPS.IGI_SLS_SECURITY_PKG dependencies on ALL_OBJECTS

Line 521: write_to_log ( l_state_level, 'create_drop_sls_objects', 'Create_Drop_SLS_Objects, All objects created successfully for '||

517: END IF;
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,

Line 717: -- All objects successfully created for the table.

713: END IF; -- (Enabled / Disabled / Re-enabled / Deleted)
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

Line 1952: all_objects b

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:
1956: IF l_count = 0