APPS.IGI_SLS_SECURITY_PKG dependencies on IGI_SLS_SECURITY_GROUP_ALLOC

Line 1007: This proecdure populates the igi_sls_security_group_alloc table with the most

1003: END refresh_sls_objects;
1004:
1005:
1006: /*------------------------------------------------------------------
1007: This proecdure populates the igi_sls_security_group_alloc table with the most
1008: uptodate data
1009:
1010: Its is called from procedure IGI_SLS_SECURITY_PKG.APPLY_SECURITY only.
1011: ------------------------------------------------------------------*/

Line 1020: write_to_log (l_state_level, 'populate_group_alloc', 'Populate_Group_Alloc, Truncating table igi_sls_security_group_alloc ');

1016: l_sql_stmt VARCHAR2(500);
1017:
1018: BEGIN
1019:
1020: write_to_log (l_state_level, 'populate_group_alloc', 'Populate_Group_Alloc, Truncating table igi_sls_security_group_alloc ');
1021: l_sql_stmt := 'BEGIN igi.apps_ddl.apps_ddl('||'''TRUNCATE TABLE igi_sls_security_group_alloc'''||');END;';
1022:
1023: EXECUTE IMMEDIATE l_sql_stmt;
1024:

Line 1021: l_sql_stmt := 'BEGIN igi.apps_ddl.apps_ddl('||'''TRUNCATE TABLE igi_sls_security_group_alloc'''||');END;';

1017:
1018: BEGIN
1019:
1020: write_to_log (l_state_level, 'populate_group_alloc', 'Populate_Group_Alloc, Truncating table igi_sls_security_group_alloc ');
1021: l_sql_stmt := 'BEGIN igi.apps_ddl.apps_ddl('||'''TRUNCATE TABLE igi_sls_security_group_alloc'''||');END;';
1022:
1023: EXECUTE IMMEDIATE l_sql_stmt;
1024:
1025: write_to_log (l_state_level, 'populate_group_alloc', 'Populate_Group_Alloc, Inserting into table igi_sls_security_group_alloc ');

Line 1025: write_to_log (l_state_level, 'populate_group_alloc', 'Populate_Group_Alloc, Inserting into table igi_sls_security_group_alloc ');

1021: l_sql_stmt := 'BEGIN igi.apps_ddl.apps_ddl('||'''TRUNCATE TABLE igi_sls_security_group_alloc'''||');END;';
1022:
1023: EXECUTE IMMEDIATE l_sql_stmt;
1024:
1025: write_to_log (l_state_level, 'populate_group_alloc', 'Populate_Group_Alloc, Inserting into table igi_sls_security_group_alloc ');
1026: INSERT INTO igi_sls_security_group_alloc
1027: (SLS_SECURITY_GROUP
1028: ,TABLE_NAME
1029: )

Line 1026: INSERT INTO igi_sls_security_group_alloc

1022:
1023: EXECUTE IMMEDIATE l_sql_stmt;
1024:
1025: write_to_log (l_state_level, 'populate_group_alloc', 'Populate_Group_Alloc, Inserting into table igi_sls_security_group_alloc ');
1026: INSERT INTO igi_sls_security_group_alloc
1027: (SLS_SECURITY_GROUP
1028: ,TABLE_NAME
1029: )
1030: SELECT DISTINCT sls_group,

Line 1102: FROM igi_sls_security_group_alloc;

1098: AND (a.date_removed IS NOT NULL or d.date_removed IS NOT NULL))
1099: MINUS
1100: SELECT sls_security_group sls_group,
1101: table_name table_name
1102: FROM igi_sls_security_group_alloc;
1103:
1104: rt_c_del_alloc c_del_alloc%ROWTYPE;
1105:
1106: CURSOR c_get_sls_tabname (p_table_name VARCHAR2) IS

Line 1912: igi_sls_security_group_alloc b

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:
1916: CURSOR c_chk_tab IS

Line 1918: FROM igi_sls_security_group_alloc a

1914: AND b.sls_security_group = Nvl(p_sec_grp , b.sls_security_group);
1915:
1916: CURSOR c_chk_tab IS
1917: SELECT DISTINCT a.table_name
1918: FROM igi_sls_security_group_alloc a
1919: WHERE a.table_name in (SELECT table_name
1920: FROM igi_sls_security_group_alloc
1921: GROUP BY table_name
1922: HAVING COUNT(*) > 1)

Line 1920: FROM igi_sls_security_group_alloc

1916: CURSOR c_chk_tab IS
1917: SELECT DISTINCT a.table_name
1918: FROM igi_sls_security_group_alloc a
1919: WHERE a.table_name in (SELECT table_name
1920: FROM igi_sls_security_group_alloc
1921: GROUP BY table_name
1922: HAVING COUNT(*) > 1)
1923: AND a.sls_security_group = Nvl(p_sec_grp , a.sls_security_group);
1924: