APPS.EGO_SECURITY_PUB SQL Statements

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

Line: 77

    SELECT party_type
      FROM hz_parties
    WHERE party_id=cp_party_id;

Line: 95

      SELECT 'X'
      FROM fnd_objects obj,
      fnd_menus menus
      WHERE obj.obj_name= cp_object_name
      AND menus.menu_name=cp_menu_name
      and exists
        ( SELECT /*+ no_unnest */ 'x'
          FROM fnd_grants grants
          WHERE grants.grantee_key=cp_grantee_key
            AND grants.grantee_type=cp_grantee_type
            AND grants.instance_type=cp_instance_type
            AND (grants.instance_pk1_value=cp_instance_pk1_value AND cp_instance_pk1_value IS NOT NULL )
            AND ((grants.instance_pk2_value=cp_instance_pk2_value )
              OR((grants.instance_pk2_value = '*NULL*') AND (cp_instance_pk2_value IS NULL)))
            AND ((grants.instance_pk3_value=cp_instance_pk3_value )
              OR((grants.instance_pk3_value = '*NULL*') AND (cp_instance_pk3_value IS NULL)))
            AND ((grants.instance_pk4_value=cp_instance_pk4_value )
              OR((grants.instance_pk4_value = '*NULL*') AND (cp_instance_pk4_value IS NULL)))
            AND ((grants.instance_pk5_value=cp_instance_pk5_value )
              OR((grants.instance_pk5_value = '*NULL*') AND (cp_instance_pk5_value IS NULL)))
            AND ((grants.instance_set_id=cp_instance_set_id )
              OR((grants.instance_set_id IS NULL ) AND (cp_instance_set_id IS NULL)))
            AND (((grants.start_date<=cp_start_date )
            AND (( grants.end_date IS NULL) OR (cp_start_date <=grants.end_date )))
              OR ((grants.start_date >= cp_start_date )
            AND (( cp_end_date IS NULL) OR (cp_end_date >=grants.start_date))))
            and  obj.object_id=grants.object_id
            AND menus.menu_id=grants.menu_id
        UNION ALL
          SELECT  /*+ no_unnest */  'x'
          FROM fnd_grants grants
          WHERE grants.grantee_key=cp_grantee_key
            AND grants.grantee_type=cp_grantee_type
            AND grants.instance_type=cp_instance_type
            AND ( grants.instance_pk1_value = '*NULL*' AND cp_instance_pk1_value IS NULL )
            AND ((grants.instance_pk2_value=cp_instance_pk2_value )
              OR((grants.instance_pk2_value = '*NULL*') AND (cp_instance_pk2_value IS NULL)))
            AND ((grants.instance_pk3_value=cp_instance_pk3_value )
              OR((grants.instance_pk3_value = '*NULL*') AND (cp_instance_pk3_value IS NULL)))
            AND ((grants.instance_pk4_value=cp_instance_pk4_value )
              OR((grants.instance_pk4_value = '*NULL*') AND (cp_instance_pk4_value IS NULL)))
            AND ((grants.instance_pk5_value=cp_instance_pk5_value )
              OR((grants.instance_pk5_value = '*NULL*') AND (cp_instance_pk5_value IS NULL)))
            AND ((grants.instance_set_id=cp_instance_set_id )
              OR((grants.instance_set_id IS NULL ) AND (cp_instance_set_id IS NULL)))
            AND (((grants.start_date<=cp_start_date )
            AND (( grants.end_date IS NULL) OR (cp_start_date <=grants.end_date )))
              OR ((grants.start_date >= cp_start_date )
            AND (( cp_end_date IS NULL) OR (cp_end_date >=grants.start_date))))
            and  obj.object_id=grants.object_id
            AND menus.menu_id=grants.menu_id
        );

Line: 312

    SELECT party_type
      FROM hz_parties
    WHERE party_id=cp_party_id;

Line: 331

      SELECT 'X'
      FROM fnd_objects obj,
      fnd_menus menus
      WHERE obj.obj_name= cp_object_name
      AND menus.menu_name=cp_menu_name
      and exists
        ( SELECT /*+ no_unnest */ 'x'
          FROM fnd_grants grants
          WHERE grants.grantee_key=cp_grantee_key
            AND grants.grantee_type=cp_grantee_type
            AND grants.instance_type=cp_instance_type
            AND (grants.instance_pk1_value=cp_instance_pk1_value AND cp_instance_pk1_value IS NOT NULL )
            AND ((grants.instance_pk2_value=cp_instance_pk2_value )
              OR((grants.instance_pk2_value = '*NULL*') AND (cp_instance_pk2_value IS NULL)))
            AND ((grants.instance_pk3_value=cp_instance_pk3_value )
              OR((grants.instance_pk3_value = '*NULL*') AND (cp_instance_pk3_value IS NULL)))
            AND ((grants.instance_pk4_value=cp_instance_pk4_value )
              OR((grants.instance_pk4_value = '*NULL*') AND (cp_instance_pk4_value IS NULL)))
            AND ((grants.instance_pk5_value=cp_instance_pk5_value )
              OR((grants.instance_pk5_value = '*NULL*') AND (cp_instance_pk5_value IS NULL)))
            AND ((grants.instance_set_id=cp_instance_set_id )
              OR((grants.instance_set_id IS NULL ) AND (cp_instance_set_id IS NULL)))
            AND (((grants.start_date<=cp_start_date )
            AND (( grants.end_date IS NULL) OR (cp_start_date <=grants.end_date )))
              OR ((grants.start_date >= cp_start_date )
            AND (( cp_end_date IS NULL) OR (cp_end_date >=grants.start_date))))
            and  obj.object_id=grants.object_id
            AND menus.menu_id=grants.menu_id
        UNION ALL
          SELECT  /*+ no_unnest */  'x'
          FROM fnd_grants grants
          WHERE grants.grantee_key=cp_grantee_key
            AND grants.grantee_type=cp_grantee_type
            AND grants.instance_type=cp_instance_type
            AND ( grants.instance_pk1_value = '*NULL*' AND cp_instance_pk1_value IS NULL )
            AND ((grants.instance_pk2_value=cp_instance_pk2_value )
              OR((grants.instance_pk2_value = '*NULL*') AND (cp_instance_pk2_value IS NULL)))
            AND ((grants.instance_pk3_value=cp_instance_pk3_value )
              OR((grants.instance_pk3_value = '*NULL*') AND (cp_instance_pk3_value IS NULL)))
            AND ((grants.instance_pk4_value=cp_instance_pk4_value )
              OR((grants.instance_pk4_value = '*NULL*') AND (cp_instance_pk4_value IS NULL)))
            AND ((grants.instance_pk5_value=cp_instance_pk5_value )
              OR((grants.instance_pk5_value = '*NULL*') AND (cp_instance_pk5_value IS NULL)))
            AND ((grants.instance_set_id=cp_instance_set_id )
              OR((grants.instance_set_id IS NULL ) AND (cp_instance_set_id IS NULL)))
            AND (((grants.start_date<=cp_start_date )
            AND (( grants.end_date IS NULL) OR (cp_start_date <=grants.end_date )))
              OR ((grants.start_date >= cp_start_date )
            AND (( cp_end_date IS NULL) OR (cp_end_date >=grants.start_date))))
            and  obj.object_id=grants.object_id
            AND menus.menu_id=grants.menu_id
        );

Line: 591

     SELECT grant_guid
     FROM fnd_grants
     WHERE grant_guid=HEXTORAW(cp_grant_id);

Line: 671

        SELECT nvl(customer_id , person_party_id)		-- for bug 11776762
        FROM fnd_user
        WHERE user_id=cp_user_id;

Line: 809

          SELECT nvl(customer_id , person_party_id)	-- for bug 11776762
          FROM fnd_user
          WHERE user_id=cp_user_id;

Line: 895

    SELECT party_type
      FROM hz_parties
    WHERE party_id=cp_party_id;

Line: 900

     select function_name
      from fnd_form_functions privs,
         fnd_objects obj
      where obj.obj_name=cp_object_name
      AND obj.object_id=privs.object_id;

Line: 1056

        SELECT PK1_COLUMN_NAME
        FROM fnd_objects
        WHERE OBJ_NAME=cp_object_name;

Line: 1104

        SELECT nvl(customer_id , person_party_id)		-- for bug 11776762
        FROM fnd_user
        WHERE user_id=cp_user_id;

Line: 1410

     SELECT g1.grant_guid
     FROM fnd_grants g1, fnd_grants g2
     WHERE g1.grant_guid=HEXTORAW(cp_grant_id)
      AND g2.grant_guid<>HEXTORAW(cp_grant_id)
      AND g1.object_id=g2.object_id
      AND g1.menu_id=g2.menu_id
      AND g1.instance_type=g2.instance_type
      -- 3729803
      -- query must take care of instance sets as well
      AND NVL(g1.instance_set_id,-1) = NVL(g2.instance_set_id,-1)
      AND g1.instance_pk1_value=g2.instance_pk1_value
      AND g1.grantee_type=g2.grantee_type
      AND g1.grantee_key=g2.grantee_key
      AND (
            ((g2.start_date<=cp_start_date )
            AND (( g2.end_date IS NULL) OR (cp_start_date<=g2.end_date )))
        OR ((g2.start_date >= cp_start_date )
            AND (( cp_end_date IS NULL)  OR (cp_end_date>=g2.start_date)))
      );

Line: 1437

           fnd_grants_pkg.update_grant (
              p_api_version => p_api_version,
              p_grant_guid  => HEXTORAW(p_grant_guid),
              p_start_date  => p_start_date,
              p_end_date    => p_end_date,
              x_success     => x_return_status
           );

Line: 1467

    SELECT instance_set_name
    FROM fnd_object_instance_sets
    WHERE instance_set_id=cp_instance_set_id ;

Line: 1526

        SELECT DISTINCT obj.pk1_column_name, obj.database_object_name, sets.predicate
          FROM fnd_objects obj,
          fnd_object_instance_sets sets
        WHERE obj.obj_name = cp_object_name
        AND   obj.object_id = sets.object_id
        AND   sets.instance_set_id = cp_instance_set_id;

Line: 1553

              l_dynamic_sql :=  ' SELECT ''X'' FROM sys.dual WHERE EXISTS ' ||
                                 '( SELECT ' || l_db_pk_column || ' FROM ' || l_db_object_name ||
                                 ' WHERE ' || l_db_pk_column || ' = ' || p_instance_id ||
                                 ' AND ' || l_set_predicate || ')';

Line: 1644

      SELECT menu_id
      FROM fnd_menus
      WHERE menu_name =cp_role_name;

Line: 1663

      SELECT 'X'
      FROM fnd_objects obj,
      fnd_menus menus
      WHERE obj.obj_name= cp_object_name
      AND menus.menu_name=cp_menu_name
      and exists
        ( SELECT /*+ no_unnest */ 'x'
          FROM fnd_grants grants
          WHERE grants.grantee_key=cp_grantee_key
            AND grants.grantee_type=cp_grantee_type
            AND grants.instance_type=cp_instance_type
            AND (grants.instance_pk1_value=cp_instance_pk1_value AND cp_instance_pk1_value IS NOT NULL )
            AND ((grants.instance_pk2_value=cp_instance_pk2_value )
              OR((grants.instance_pk2_value = '*NULL*') AND (cp_instance_pk2_value IS NULL)))
            AND ((grants.instance_pk3_value=cp_instance_pk3_value )
              OR((grants.instance_pk3_value = '*NULL*') AND (cp_instance_pk3_value IS NULL)))
            AND ((grants.instance_pk4_value=cp_instance_pk4_value )
              OR((grants.instance_pk4_value = '*NULL*') AND (cp_instance_pk4_value IS NULL)))
            AND ((grants.instance_pk5_value=cp_instance_pk5_value )
              OR((grants.instance_pk5_value = '*NULL*') AND (cp_instance_pk5_value IS NULL)))
            AND ((grants.instance_set_id=cp_instance_set_id )
              OR((grants.instance_set_id IS NULL ) AND (cp_instance_set_id IS NULL)))
            AND (((grants.start_date<=cp_start_date )
            AND (( grants.end_date IS NULL) OR (cp_start_date <=grants.end_date )))
              OR ((grants.start_date >= cp_start_date )
            AND (( cp_end_date IS NULL) OR (cp_end_date >=grants.start_date))))
            and  obj.object_id=grants.object_id
            AND menus.menu_id=grants.menu_id
        UNION ALL
          SELECT  /*+ no_unnest */  'x'
          FROM fnd_grants grants
          WHERE grants.grantee_key=cp_grantee_key
            AND grants.grantee_type=cp_grantee_type
            AND grants.instance_type=cp_instance_type
            AND ( grants.instance_pk1_value = '*NULL*' AND cp_instance_pk1_value IS NULL )
            AND ((grants.instance_pk2_value=cp_instance_pk2_value )
              OR((grants.instance_pk2_value = '*NULL*') AND (cp_instance_pk2_value IS NULL)))
            AND ((grants.instance_pk3_value=cp_instance_pk3_value )
              OR((grants.instance_pk3_value = '*NULL*') AND (cp_instance_pk3_value IS NULL)))
            AND ((grants.instance_pk4_value=cp_instance_pk4_value )
              OR((grants.instance_pk4_value = '*NULL*') AND (cp_instance_pk4_value IS NULL)))
            AND ((grants.instance_pk5_value=cp_instance_pk5_value )
              OR((grants.instance_pk5_value = '*NULL*') AND (cp_instance_pk5_value IS NULL)))
            AND ((grants.instance_set_id=cp_instance_set_id )
              OR((grants.instance_set_id IS NULL ) AND (cp_instance_set_id IS NULL)))
            AND (((grants.start_date<=cp_start_date )
            AND (( grants.end_date IS NULL) OR (cp_start_date <=grants.end_date )))
              OR ((grants.start_date >= cp_start_date )
            AND (( cp_end_date IS NULL) OR (cp_end_date >=grants.start_date))))
            and  obj.object_id=grants.object_id
            AND menus.menu_id=grants.menu_id
        );

Line: 1728

    SELECT party_type
      FROM hz_parties
    WHERE party_id=cp_party_id;

Line: 1859

        SELECT 'X'
        FROM fnd_grants grants
        WHERE grants.grantee_key=cp_grantee_key
        AND  grants.grantee_type=cp_grantee_type
        AND  grants.menu_id=cp_menu_id
        AND  grants.object_id = cp_object_id
        AND grants.instance_type=cp_instance_type
        AND ((grants.instance_pk1_value=cp_instance_pk1_value )
            OR((grants.instance_pk1_value = '*NULL*') AND (cp_instance_pk1_value IS NULL)))
        AND ((grants.instance_set_id=cp_instance_set_id )
            OR((grants.instance_set_id IS NULL ) AND (cp_instance_set_id IS NULL)))
        AND (((grants.start_date<=cp_start_date )
            AND (( grants.end_date IS NULL) OR (cp_start_date <=grants.end_date )))
        OR ((grants.start_date >= cp_start_date )
            AND (( cp_end_date IS NULL)  OR (cp_end_date >=grants.start_date))));

Line: 1883

    SELECT party_type
      FROM hz_parties
    WHERE party_id=cp_party_id;

Line: 1965

        SELECT instance_set_id
        FROM fnd_object_instance_sets
        WHERE instance_set_name = cp_instance_set_name;