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_grants grants,
             fnd_objects obj,
             fnd_menus menus
        WHERE grants.grantee_key=cp_grantee_key
        AND  grants.grantee_type=cp_grantee_type
        AND  grants.menu_id=menus.menu_id
        AND  menus.menu_name=cp_menu_name
        AND  grants.object_id = obj.object_id
        AND obj.obj_name=cp_object_name
        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_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))));

Line: 287

    SELECT party_type
      FROM hz_parties
    WHERE party_id=cp_party_id;

Line: 305

        SELECT 'X'
        FROM fnd_grants grants,
             fnd_objects obj,
             fnd_menus menus
        WHERE grants.grantee_key=cp_grantee_key
        AND  grants.grantee_type=cp_grantee_type
        AND  grants.menu_id=menus.menu_id
        AND  menus.menu_name=cp_menu_name
        AND  grants.object_id = obj.object_id
        AND obj.obj_name=cp_object_name
        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_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))));

Line: 536

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

Line: 616

        SELECT customer_id
        FROM fnd_user
        WHERE user_id=cp_user_id;

Line: 754

          SELECT customer_id
          FROM fnd_user
          WHERE user_id=cp_user_id;

Line: 840

    SELECT party_type
      FROM hz_parties
    WHERE party_id=cp_party_id;

Line: 845

     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: 1001

        SELECT PK1_COLUMN_NAME
        FROM fnd_objects
        WHERE OBJ_NAME=cp_object_name;

Line: 1049

        SELECT customer_id
        FROM fnd_user
        WHERE user_id=cp_user_id;

Line: 1355

     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: 1382

           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: 1412

    SELECT instance_set_name
    FROM fnd_object_instance_sets
    WHERE instance_set_id=cp_instance_set_id ;

Line: 1471

        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: 1498

              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: 1589

      SELECT menu_id
      FROM fnd_menus
      WHERE menu_name =cp_role_name;

Line: 1607

        SELECT 'X'
        FROM fnd_grants grants,
             fnd_objects obj,
             fnd_menus menus
        WHERE grants.grantee_key=cp_grantee_key
        AND  grants.grantee_type=cp_grantee_type
        AND  grants.menu_id=menus.menu_id
        AND  menus.menu_name=cp_menu_name
        AND  grants.object_id = obj.object_id
        AND obj.obj_name=cp_object_name
        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_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))));

Line: 1642

    SELECT party_type
      FROM hz_parties
    WHERE party_id=cp_party_id;

Line: 1773

        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: 1797

    SELECT party_type
      FROM hz_parties
    WHERE party_id=cp_party_id;

Line: 1879

        SELECT instance_set_id
        FROM fnd_object_instance_sets
        WHERE instance_set_name = cp_instance_set_name;