APPS.FND_SSO_REGISTRATION SQL Statements

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

Line: 11

    identity_update varchar2(4000),
    identity_delete varchar2(4000),
    subscription_add varchar2(4000),
    subscription_delete varchar2(4000),
    subscription_update varchar2(4000) );

Line: 115

  r.identity_update :=null;

Line: 116

  r.identity_delete :=null;

Line: 118

  r.subscription_delete :=null;

Line: 119

  r.subscription_update:=null;

Line: 151

            r.identity_update := lista;

Line: 152

          elsif (op='DELETE') then
            r.identity_delete := lista;

Line: 161

              r.subscription_update := lista;

Line: 162

          elsif (op='DELETE') THEN
              r.subscription_delete := lista;

Line: 499

     WHEN fnd_ldap_wrapper.G_UPDATE THEN res:= (allowed_op.identity_update is not null ) and (allowed_op.subscription_update is not null) ;

Line: 500

     WHEN fnd_ldap_wrapper.G_MODIFY THEN res:= (allowed_op.identity_update is not null ) and (allowed_op.subscription_update is not null) ;

Line: 501

     WHEN fnd_ldap_wrapper.G_DELETE THEN res:= (allowed_op.identity_delete is not null ) and (allowed_op.subscription_delete  is not null) ;

Line: 509

               fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Valid opertaion fnd_ldap_wrapper.G_UPDATE ='||fnd_ldap_wrapper.G_UPDATE );

Line: 511

               fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Valid opertaion fnd_ldap_wrapper.G_DELETE ='||fnd_ldap_wrapper.G_DELETE );

Line: 711

          WHEN fnd_ldap_wrapper.G_UPDATE THEN l_list := l_allowed.identity_update;

Line: 712

          WHEN fnd_ldap_wrapper.G_MODIFY THEN l_list := l_allowed.identity_update;

Line: 713

          WHEN fnd_ldap_wrapper.G_DELETE THEN l_list := l_allowed.identity_delete;

Line: 720

              fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Valid direction fnd_ldap_wrapper.G_UPDATE  ='||fnd_ldap_wrapper.G_UPDATE );

Line: 722

              fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Valid direction fnd_ldap_wrapper.G_DELETE  ='||fnd_ldap_wrapper.G_DELETE );

Line: 732

          WHEN fnd_ldap_wrapper.G_UPDATE THEN l_list := l_allowed.subscription_update;

Line: 733

          WHEN fnd_ldap_wrapper.G_MODIFY THEN l_list := l_allowed.subscription_update;

Line: 734

          WHEN fnd_ldap_wrapper.G_DELETE THEN l_list := l_allowed.subscription_delete;

Line: 741

              fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Valid direction fnd_ldap_wrapper.G_UPDATE  ='||fnd_ldap_wrapper.G_UPDATE );

Line: 743

              fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Valid direction fnd_ldap_wrapper.G_DELETE  ='||fnd_ldap_wrapper.G_DELETE );

Line: 796

     SELECT USER_ID into l_user_id from FND_USER
        WHERE user_name=user_name_z;