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(10),
    subscription_delete varchar2(10),
    subscription_update varchar2(10) );

Line: 111

  r.  identity_update :=null;

Line: 112

  r.  identity_delete :=null;

Line: 114

  r.  subscription_delete :=null;

Line: 115

  r.  subscription_update:=null;

Line: 145

          elsif(op='MODIFY') then r.identity_update:=lista;

Line: 146

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

Line: 151

          elsif(op='MODIFY') THEN r.subscription_update:=lista;

Line: 152

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

Line: 325

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

Line: 326

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

Line: 327

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

Line: 336

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

Line: 338

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

Line: 487

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

Line: 488

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

Line: 489

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

Line: 496

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

Line: 498

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

Line: 508

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

Line: 509

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

Line: 510

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

Line: 517

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

Line: 519

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