APPS.POA_EUL_UTILS SQL Statements

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

Line: 31

          l_stmt := 'SELECT ba.ba_id,  '||
                    '       ba.ba_name '||
                    'FROM  '||g_EulOwner||'.EUL_BUSINESS_AREAS ba '||
                    'WHERE  ba.ba_name = :p_ba';

Line: 73

          l_stmt := 'SELECT ba.ba_id,  '||
                    '       ba.ba_name '||
                    'FROM  '||g_EulOwner||'.EUL4_BAS ba '||
                    'WHERE  ba.ba_name = :p_ba';

Line: 115

        'UPDATE ' || g_EulOwner || '.eul_objs obj '||
        'SET    obj.obj_hidden = 1 '||
        'WHERE  obj.obj_name = :pFolderName ' ||
        '  AND  obj.obj_type = ''SOBJ''' ||
        '  AND  EXISTS (select 1 from  ' || g_EulOwner || '.eul_ba_obj_links boj' ||
        '               where boj.BOL_BA_ID = :EulBA_ID' ||
        '                 and boj.BOL_OBJ_ID = obj.OBJ_ID)';

Line: 146

        'UPDATE ' || g_EulOwner || '.eul4_objs obj '||
        'SET    obj.obj_hidden = 1 '||
        'WHERE  obj.obj_name = :pFolderName ' ||
        '  AND  obj.obj_type = ''SOBJ''' ||
        '  AND  EXISTS (select 1 from  ' || g_EulOwner || '.eul4_ba_obj_links boj' ||
        '               where boj.BOL_BA_ID = :EulBA_ID' ||
        '                 and boj.BOL_OBJ_ID = obj.OBJ_ID)';

Line: 176

        'UPDATE ' || g_EulOwner || '.eul_expressions exp '||
        'SET    exp.it_hidden = 1 '||
        'WHERE (exp.it_ext_column like ''%USER_ATTRIBUTE%''  OR ' ||
        '       exp.it_ext_column like ''USER_FK__KEY%''     OR ' ||
        '       exp.it_ext_column like ''USER_MEASURE%'') '       ||
        '  AND  EXISTS (select 1 from  ' || g_EulOwner || '.eul_ba_obj_links boj' ||
        '               where boj.BOL_BA_ID = :EulBA_ID ' ||
        '                 and boj.BOL_OBJ_ID = exp.ite_obj_id)';

Line: 209

        'UPDATE ' || g_EulOwner || '.eul4_expressions exp '||
        'SET    exp.it_hidden = 1 '||
        'WHERE (exp.it_ext_column like ''%USER_ATTRIBUTE%''  OR ' ||
        '       exp.it_ext_column like ''USER_FK__KEY%''     OR ' ||
        '       exp.it_ext_column like ''USER_MEASURE%'') '       ||
        '  AND  EXISTS (select 1 from  ' || g_EulOwner || '.eul4_ba_obj_links boj' ||
        '               where boj.BOL_BA_ID = :EulBA_ID' ||
        '                 and boj.BOL_OBJ_ID = exp.it_obj_id)';