DBA Data[Home] [Help]

APPS.GMD_SECURITY_POLICY SQL Statements

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

Line: 20

       SELECT responsibility_id   INTO v_resp_id
       FROM   fnd_responsibility
       WHERE  responsibility_key = 'GMD_SECURITY_PROFILE_MGR';
Line: 36

' EXISTS ( SELECT 1 '||
         ' FROM gmd_security_profiles sp '||
         ' WHERE sp.assign_method_ind = ''A'' '||
         ' AND (  ( sp.user_id =  fnd_profile.value(''GMD_DEFAULT_USER'') '||
                  ' OR  sp.user_id = fnd_global.user_id '||
                 ' ) '||
                ' OR ( EXISTS ( SELECT rg.responsibility_id '||
                              ' FROM FND_USER_RESP_GROUPS rg '||
                              ' WHERE rg.user_id = fnd_global.user_id '||
                              ' AND sp.responsibility_id = rg.responsibility_id '||
                              ' AND SYSDATE BETWEEN rg.start_date AND NVL(rg.end_date, SYSDATE) '||
                             ' ) '||
                    ' ) '||
              ' ) '||
         ' AND (  EXISTS ( SELECT NULL '||
                         ' FROM org_access a1 '||
                         ' WHERE ( ( sp.organization_id = a1.organization_id '||
                                   ' AND sp.other_organization_id IS NULL '||
                                  ' ) '||
                                  ' OR sp.other_organization_id = a1.organization_id '||
                                ' ) '||
                         ' AND NVL(a1.disable_date, SYSDATE+1) >= SYSDATE '||
                         ' AND a1.resp_application_id = fnd_global.resp_appl_id '||
                         ' AND a1.responsibility_id = fnd_global.resp_id '||
                        ' ) '||
                ' OR '||
                ' NOT EXISTS ( SELECT NULL '||
                             ' FROM org_access a2 '||
                             ' WHERE ( ( sp.organization_id = a2.organization_id '||
                                       ' AND sp.other_organization_id IS NULL '||
                                      ' ) '||
                                     ' OR sp.other_organization_id = a2.organization_id '||
                                    ' ) '||
                             ' AND NVL(a2.disable_date, SYSDATE+1) >=SYSDATE '||
                            ' ) '||
              ' ) '||
         ' AND sp.organization_id = '||obj_name||'.owner_organization_id '||
        ' ) '||
' OR EXISTS ( SELECT 1 '||
            ' FROM   gmd_formula_security fs '||
            ' WHERE ( ( fs.user_id =  fnd_profile.value(''GMD_DEFAULT_USER'') '||
                      ' OR  fs.user_id = fnd_global.user_id '||
                     ' ) '||
                    ' OR ( EXISTS ( SELECT rg.responsibility_id '||
                                  ' FROM FND_USER_RESP_GROUPS rg '||
                                  ' WHERE rg.user_id = fnd_global.user_id '||
                                  ' AND fs.responsibility_id = rg.responsibility_id '||
                                  ' AND SYSDATE BETWEEN rg.start_date '||
                                  ' AND NVL(rg.end_date, SYSDATE) '||
                                 ' ) '||
                        ' ) '||
                   ' ) '||
            ' AND   (EXISTS ( SELECT NULL '||
                            ' FROM org_access ou '||
                            ' WHERE ( ( fs.organization_id = ou.organization_id '||
                                      ' AND fs.other_organization_id IS NULL '||
                                     ' ) '||
                                     ' OR fs.other_organization_id = ou.organization_id '||
                                   ' ) '||
                            ' AND NVL(ou.disable_date, SYSDATE+1) >= SYSDATE '||
                            ' AND ou.resp_application_id = fnd_global.resp_appl_id '||
                            ' AND ou.responsibility_id = fnd_global.resp_id '||
                           ' ) '||
                   ' OR '||
                   ' NOT EXISTS ( SELECT NULL '||
                                ' FROM org_access ou1 '||
                                ' WHERE ( ( ou1.organization_id = fs.organization_id '||
                                          ' AND fs.other_organization_id IS NULL '||
                                         ' ) '||
                                         ' OR ou1.organization_id = fs.other_organization_id '||
                                       ' ) '||
                                ' AND   NVL(ou1.disable_date, SYSDATE+1) >=SYSDATE '||
                               ' ) '||
                   ' ) '||
            ' AND fs.formula_id = ' ||obj_name||'.formula_id '||
            ' ) ';
Line: 132

        ' EXISTS ( SELECT 1 '||
                 ' FROM gmd_security_profiles sp '||
                 ' WHERE sp.access_type_ind = ''U'' '||
                 ' AND ( responsibility_id IN ( SELECT rg.responsibility_id '||
                                      '         FROM FND_USER_RESP_GROUPS rg '||
                                      '         WHERE rg.user_id = fnd_global.user_id '||
                                      '         AND SYSDATE BETWEEN rg.start_date '||
                                      '         AND NVL(rg.end_date, SYSDATE) '||
                                     '         ) '||
               '         OR ( sp.user_id = fnd_profile.value_specific(''GMD_DEFAULT_USER'') '||
                    '         OR sp.user_id = fnd_global.user_id '||
                   '         ) '||
              '         ) '||
         '         AND organization_id = '||obj_name||'.owner_organization_id '||
         '         AND (other_organization_id IS NULL '||
              '         OR EXISTS ( SELECT NULL '||
                          '         FROM org_access a3 '||
                          '         WHERE a3.organization_id = sp.other_organization_id '||
                          '         AND NVL(a3.disable_date, SYSDATE+1) >= SYSDATE '||
                          '         AND a3.resp_application_id = fnd_global.resp_appl_id '||
                          '         AND a3.responsibility_id = fnd_global.resp_id '||
                         '         ) '||
              '         OR NOT EXISTS ( SELECT NULL '||
                              '         FROM org_access a4 '||
                              '         WHERE a4.organization_id = sp.other_organization_id '||
                              '         AND NVL(a4.disable_date, SYSDATE+1) >=SYSDATE '||
                             '         ) '||
              '         ) '||
        '         ) ';
Line: 176

                      ' ( SELECT 1 '||
                        ' FROM gmd_security_profiles sp '||
                        ' WHERE sp.access_type_ind = ''U'' '||
                        ' AND ( responsibility_id IN ( SELECT rg.responsibility_id '||
                                                     ' FROM FND_USER_RESP_GROUPS rg '||
                                                     ' WHERE rg.user_id = fnd_global.user_id '||
                                                     ' AND SYSDATE BETWEEN rg.start_date '||
                                                     ' AND NVL(rg.end_date, SYSDATE) '||
                                                    ' ) '||
                              ' OR ( sp.user_id = fnd_profile.value_specific(''GMD_DEFAULT_USER'') '||
                                   ' OR sp.user_id = fnd_global.user_id '||
                                  ' ) '||
                             ' ) '||
                        ' AND organization_id = '||obj_name||'.organization_id '||
                        ' AND (other_organization_id IS NULL '||
                             ' OR EXISTS ( SELECT NULL '||
                                         ' FROM org_access a3 '||
                                         ' WHERE a3.organization_id = sp.other_organization_id '||
                                         ' AND NVL(a3.disable_date, SYSDATE+1) >= SYSDATE '||
                                         ' AND a3.resp_application_id = fnd_global.resp_appl_id '||
                                         ' AND a3.responsibility_id = fnd_global.resp_id '||
                                        ' ) '||
                             ' OR NOT EXISTS ( SELECT NULL '||
                                             ' FROM org_access a4 '||
                                             ' WHERE a4.organization_id = sp.other_organization_id '||
                                             ' AND NVL(a4.disable_date, SYSDATE+1) >=SYSDATE '||
                                            ' ) '||
                             ' ) '||
                       ' ) ';
Line: 219

                           ' ( SELECT 1 '||
                             ' FROM gmd_security_profiles sp '||
                             ' WHERE sp.assign_method_ind = ''A'' '||
                             ' AND sp.access_type_ind = ''U'' '||
                             ' AND (responsibility_id IN ( SELECT rg.responsibility_id '||
                                                         ' FROM FND_USER_RESP_GROUPS rg '||
                                                         ' WHERE rg.user_id = fnd_global.user_id '||
                                                         ' AND SYSDATE BETWEEN rg.start_date AND NVL(rg.end_date, SYSDATE) '||
                                                        ' ) '||
                                  ' OR ( sp.user_id = fnd_profile.value_specific(''GMD_DEFAULT_USER'') '||
                                       ' OR sp.user_id = fnd_global.user_id '||
                                      ' ) '||
                                  ' ) '||
                             ' AND (  EXISTS ( SELECT NULL '||
                                             ' FROM org_access a1 '||
                                             ' WHERE ( ( sp.organization_id = a1.organization_id '||
                                                       ' AND sp.other_organization_id IS NULL '||
                                                      ' ) '||
                                                     ' OR sp.other_organization_id = a1.organization_id '||
                                                    ' ) '||
                                             ' AND NVL(a1.disable_date, SYSDATE+1) >= SYSDATE '||
                                             ' AND a1.resp_application_id = fnd_global.resp_appl_id '||
                                             ' AND a1.responsibility_id = fnd_global.resp_id '||
                                            ' ) '||
                                    ' OR '||
                                    ' NOT EXISTS ( SELECT NULL '||
                                                 ' FROM org_access a2 '||
                                                 ' WHERE ( ( sp.organization_id = a2.organization_id '||
                                                           ' AND sp.other_organization_id IS NULL '||
                                                          ' ) '||
                                                          ' OR sp.other_organization_id = a2.organization_id '||
                                                        ' ) '||
                                                 ' AND NVL(a2.disable_date, SYSDATE+1) >=SYSDATE '||
                                                ' ) '||
                                  ' ) '||
                             ' AND sp.organization_id = '||obj_name||'.owner_organization_id '||
                            ' ) '||
                           ' OR '||
                           ' EXISTS '||
                           ' ( SELECT 1 '||
                             ' FROM   gmd_formula_security fs '||
                             ' WHERE  fs.access_type_ind = ''U'' '||
                             ' AND    ( ( fs.user_id =  fnd_profile.value(''GMD_DEFAULT_USER'') '||
                                        ' OR  fs.user_id = fnd_global.user_id '||
                                       ' ) '||
                                      ' OR ( EXISTS ( SELECT rg.responsibility_id '||
                                                    ' FROM FND_USER_RESP_GROUPS rg '||
                                                    ' WHERE rg.user_id = fnd_global.user_id '||
                                                    ' AND fs.responsibility_id = rg.responsibility_id '||
                                                    ' AND SYSDATE BETWEEN rg.start_date AND NVL(rg.end_date, SYSDATE) '||
                                                   ' ) '||
                                          ' ) '||
                                     ' ) '||
                             ' AND    ( EXISTS ( SELECT NULL '||
                                               ' FROM org_access ou '||
                                               ' WHERE ( ( fs.organization_id = ou.organization_id '||
                                                         ' AND fs.other_organization_id IS NULL '||
                                                        ' ) '||
                                                       ' OR fs.other_organization_id = ou.organization_id '||
                                                      ' ) '||
                                               ' AND NVL(ou.disable_date, SYSDATE+1) >= SYSDATE '||
                                               ' AND ou.resp_application_id = fnd_global.resp_appl_id '||
                                               ' AND ou.responsibility_id = fnd_global.resp_id '||
                                              ' ) '||
                                      ' OR '||
                                      ' NOT EXISTS ( SELECT NULL '||
                                                   ' FROM org_access ou1 '||
                                                   ' WHERE ( ( ou1.organization_id = fs.organization_id '||
                                                             ' AND fs.other_organization_id IS NULL '||
                                                            ' ) '||
                                                           ' OR ou1.organization_id = fs.other_organization_id '||
                                                          ' ) '||
                                                   ' AND   NVL(ou1.disable_date, SYSDATE+1) >=SYSDATE '||
                                                  ' ) '||
                                     ' ) '||
                             ' AND fs.formula_id = '||obj_name||'.formula_id '||
                            ' ) ';
Line: 316

            f_predicate :=  ' EXISTS ( SELECT 1 '||
                                     ' FROM fm_form_mst_b fm WHERE fm.formula_id = ' ||obj_name||'.formula_id )';
Line: 339

           f_predicate := ' EXISTS (SELECT 1 FROM gmd_recipes_b WHERE recipe_id = '||obj_name||'.recipe_id)';