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.IGS_SC_DATA_SEC_APIS_PKG dependencies on DBMS_RLS

Line 7604: dbms_rls.drop_policy (object_schema => c_policy_rec.object_owner,

7600:
7601: FOR c_policy_rec IN c_policy LOOP
7602: -- Drop existing policies
7603:
7604: dbms_rls.drop_policy (object_schema => c_policy_rec.object_owner,
7605: object_name => p_database_object_name,
7606: policy_name => c_policy_rec.policy_name );
7607:
7608:

Line 7628: l_stmt:= 'BEGIN dbms_rls.add_policy (

7624: IF L_INSERT_FLAG IS NOT NULL THEN
7625:
7626: IF L_PAR_SECURITY IS NOT NULL THEN
7627: IF (l_db_version >= 10) THEN
7628: l_stmt:= 'BEGIN dbms_rls.add_policy (
7629: object_schema => :1,
7630: object_name => :2,
7631: policy_name => :3,
7632: function_schema => :4,

Line 7640: dbms_rls.add_policy (

7636: long_predicate => TRUE); END;';
7637: EXECUTE IMMEDIATE(l_stmt) using l_owner, p_database_object_name, p_database_object_name||'_PI',
7638: l_apps_schema,'IGS_SC_GRANTS_TBL_PVT.UPDATE_ROW','insert';
7639: ELSE
7640: dbms_rls.add_policy (
7641: object_schema => l_owner,
7642: object_name => p_database_object_name,
7643: policy_name => p_database_object_name||'_PI',
7644: function_schema => l_apps_schema,

Line 7651: l_stmt:= 'BEGIN dbms_rls.add_policy (

7647: update_check => TRUE );
7648: END IF;
7649: ELSE
7650: IF (l_db_version >= 10) THEN
7651: l_stmt:= 'BEGIN dbms_rls.add_policy (
7652: object_schema => :1,
7653: object_name => :2,
7654: policy_name => :3,
7655: function_schema => :4,

Line 7663: dbms_rls.add_policy (object_schema => l_owner,

7659: long_predicate => TRUE); END;';
7660: EXECUTE IMMEDIATE(l_stmt) using l_owner, p_database_object_name, p_database_object_name||'_PI',
7661: l_apps_schema,'IGS_SC_GRANTS_TBL_PVT.INSERT_ROW','insert';
7662: ELSE
7663: dbms_rls.add_policy (object_schema => l_owner,
7664: object_name => p_database_object_name,
7665: policy_name => p_database_object_name||'_PI',
7666: function_schema => l_apps_schema,
7667: policy_function => 'IGS_SC_GRANTS_TBL_PVT.INSERT_ROW',

Line 7675: l_stmt:= 'BEGIN dbms_rls.add_policy (

7671: END IF;
7672: END IF;
7673: IF L_UPDATE_FLAG IS NOT NULL THEN
7674: IF (l_db_version >= 10) THEN
7675: l_stmt:= 'BEGIN dbms_rls.add_policy (
7676: object_schema => :1,
7677: object_name => :2,
7678: policy_name => :3,
7679: function_schema => :4,

Line 7687: dbms_rls.add_policy (object_schema => l_owner,

7683: long_predicate => TRUE); END;';
7684: EXECUTE IMMEDIATE(l_stmt) using l_owner, p_database_object_name, p_database_object_name||'_PU',
7685: l_apps_schema,'IGS_SC_GRANTS_TBL_PVT.UPDATE_ROW','update';
7686: ELSE
7687: dbms_rls.add_policy (object_schema => l_owner,
7688: object_name => p_database_object_name,
7689: policy_name => p_database_object_name||'_PU',
7690: function_schema => l_apps_schema,
7691: policy_function => 'IGS_SC_GRANTS_TBL_PVT.UPDATE_ROW',

Line 7698: l_stmt:= 'BEGIN dbms_rls.add_policy (

7694: END IF;
7695: END IF;
7696: IF L_SELECT_FLAG IS NOT NULL THEN
7697: IF (l_db_version >= 10) THEN
7698: l_stmt:= 'BEGIN dbms_rls.add_policy (
7699: object_schema => :1,
7700: object_name => :2,
7701: policy_name => :3,
7702: function_schema => :4,

Line 7710: dbms_rls.add_policy (object_schema => l_owner,

7706: long_predicate => TRUE); END;';
7707: EXECUTE IMMEDIATE(l_stmt) using l_owner, p_database_object_name, p_database_object_name||'_PS',
7708: l_apps_schema,'IGS_SC_GRANTS_TBL_PVT.SELECT_ROW','select';
7709: ELSE
7710: dbms_rls.add_policy (object_schema => l_owner,
7711: object_name => p_database_object_name,
7712: policy_name => p_database_object_name||'_PS',
7713: function_schema => l_apps_schema,
7714: policy_function => 'IGS_SC_GRANTS_TBL_PVT.SELECT_ROW',

Line 7722: l_stmt:= 'BEGIN dbms_rls.add_policy (

7718: END IF;
7719: IF L_DELETE_FLAG IS NOT NULL THEN
7720: IF L_PAR_SECURITY IS NOT NULL THEN
7721: IF (l_db_version >= 10) THEN
7722: l_stmt:= 'BEGIN dbms_rls.add_policy (
7723: object_schema => :1,
7724: object_name => :2,
7725: policy_name => :3,
7726: function_schema => :4,

Line 7734: dbms_rls.add_policy (object_schema => l_owner,

7730: long_predicate => TRUE); END;';
7731: EXECUTE IMMEDIATE(l_stmt) using l_owner, p_database_object_name, p_database_object_name||'_PD',
7732: l_apps_schema,'IGS_SC_GRANTS_TBL_PVT.UPDATE_ROW','delete';
7733: ELSE
7734: dbms_rls.add_policy (object_schema => l_owner,
7735: object_name => p_database_object_name,
7736: policy_name => p_database_object_name||'_PD',
7737: function_schema => l_apps_schema,
7738: policy_function => 'IGS_SC_GRANTS_TBL_PVT.UPDATE_ROW',

Line 7744: l_stmt:= 'BEGIN dbms_rls.add_policy (

7740: update_check => TRUE );
7741: END IF;
7742: ELSE
7743: IF (l_db_version >= 10) THEN
7744: l_stmt:= 'BEGIN dbms_rls.add_policy (
7745: object_schema => :1,
7746: object_name => :2,
7747: policy_name => :3,
7748: function_schema => :4,

Line 7756: dbms_rls.add_policy (object_schema => l_owner,

7752: long_predicate => TRUE); END;';
7753: EXECUTE IMMEDIATE(l_stmt) using l_owner, p_database_object_name, p_database_object_name||'_PD',
7754: l_apps_schema,'IGS_SC_GRANTS_TBL_PVT.DELETE_ROW','delete';
7755: ELSE
7756: dbms_rls.add_policy (object_schema => l_owner,
7757: object_name => p_database_object_name,
7758: policy_name => p_database_object_name||'_PD',
7759: function_schema => l_apps_schema,
7760: policy_function => 'IGS_SC_GRANTS_TBL_PVT.DELETE_ROW',