APPS.FND_ACCESS_CONTROL_UTIL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 23

    SELECT name
    INTO   l_return
    FROM   hr_all_organization_units_tl
    WHERE  organization_id = p_org_id
    AND    language = userenv('LANG');

Line: 73

    SELECT  'TRUE'
    FROM    sys.dual
    WHERE   EXISTS
      (SELECT  1
       FROM    sys.dba_policies
       WHERE   object_owner = UPPER(xp_object_schema)
       AND     object_name  = UPPER(xp_object_name)
       AND     policy_name  = UPPER(xp_policy_name)
      );

Line: 120

, p_statement_types     IN VARCHAR2 := 'SELECT, INSERT, UPDATE, DELETE'
, p_update_check        IN BOOLEAN  := FALSE
, p_enable              IN BOOLEAN  := TRUE
)
IS
BEGIN

  ADD_POLICY(
    p_object_schema       => p_object_schema,
    p_object_name         => p_object_name,
    p_policy_name         => p_policy_name,
    p_function_schema     => p_function_schema,
    p_policy_function     => p_policy_function,
    p_statement_types     => p_statement_types,
    p_update_check        => p_update_check,
    p_enable              => p_enable,
    p_static_policy       => FALSE
  );

Line: 206

, p_statement_types     IN VARCHAR2 := 'SELECT, INSERT, UPDATE, DELETE'
, p_update_check        IN BOOLEAN  := FALSE
, p_enable              IN BOOLEAN  := TRUE
, p_static_policy       IN BOOLEAN
, p_policy_type         IN BINARY_INTEGER
)
IS

BEGIN

  IF policy_exists(  p_object_schema
                   , p_object_name
                   , p_policy_name ) = 'TRUE'
  THEN
    DBMS_RLS.DROP_POLICY(
      p_object_schema
    , p_object_name
    , p_policy_name
    );

Line: 234

		update_check    => p_update_check,
		enable          => p_enable,
		static_policy   => p_static_policy,
		policy_type	=> p_policy_type
		);