APPS.FND_OID_DIAG SQL Statements

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

Line: 57

procedure insertRow(text in varchar2);

Line: 58

procedure insertColumn(text in varchar2);

Line: 187

                   insertRow('DBMS_LDAP resolves to '||schema||'.'||'DBMS_LDAP and not to PACKAGE SYS.DBMS_LDAP');

Line: 200

                   insertRow('Package DBMS_LDAP is not accessible');

Line: 208

                   insertRow('Error '||sqlerrm||'(' || sqlcode || ') during dbms_ldap validation');

Line: 222

                   insertRow('Error '||sqlerrm||'(' || sqlcode || ') durint dbms_ldap validation');

Line: 227

	  insertRow(' SYS.DBMS_LDAP is available');

Line: 247

          insertRow('APPS_SSO is not defined ');

Line: 257

          insertRow('APPS_SSO_LDAP_SYNC is not defined ');

Line: 261

   insertRow(' APPS_SSO= '||sso);

Line: 262

   insertRow(' APPS_SSO_LDAP_SYNC= '||sync);

Line: 266

	insertRow('OiD synchronization is enabled');

Line: 269

	insertRow('OiD synchronization is NOT enabled');

Line: 293

	insertRow('AppDN is null');

Line: 299

    	insertRow(' AppDn: '||orclAppName);

Line: 303

	insertRow('Password  is null');

Line: 312

	insertRow('OiD host   is null');

Line: 318

	insertRow('OiD host: '||host);

Line: 322

	insertRow('OiD port   is null');

Line: 328

	insertRow('OiD port: '||port);

Line: 335

	insertRow('Failed to connect to OiD ');

Line: 355

  jtf_diagnostic_coreapi.insert_style_sheet;

Line: 469

  insertRow('EventStatus');

Line: 472

                       'oracle.apps.fnd.identity.delete','ENABLED',
                       'oracle.apps.fnd.identity.modify','ENABLED',
                       'oracle.apps.fnd.oidsync.error','ENABLED',
                       'oracle.apps.fnd.oidsync.resend','ENABLED',
                       'oracle.apps.fnd.ondemand.create','ENABLED',
                       'oracle.apps.fnd.subscription.add','ENABLED',
                       'oracle.apps.fnd.subscription.delete','ENABLED',
                       'oracle.apps.global.user.change','ENABLED');

Line: 485

      insertColumn(event);

Line: 488

      insertColumn(l_status||'  Incorrect ');

Line: 494

      insertColumn(l_status);

Line: 522

    select s.status, e.name
    from wf_events e, wf_event_subscriptions s
    where rule_function = sub and
    s.event_filter_guid = e.guid;

Line: 537

                  'fnd_oid_subscriptions.hz_identity_delete',
                  'fnd_oid_subscriptions.hz_identity_modify',
                  'fnd_oid_subscriptions.hz_subscription_add',
                  'fnd_oid_subscriptions.hz_subscription_delete',
                  'fnd_oid_subscriptions.identity_add',
                  'fnd_oid_subscriptions.identity_delete',
                  'fnd_oid_subscriptions.identity_modify',
                  'fnd_oid_subscriptions.on_demand_user_create',
                  'fnd_oid_subscriptions.subscription_add',
                  'fnd_oid_subscriptions.subscription_delete',
                  'fnd_user_pkg.user_change');

Line: 585

  select fnd_preference.eget('#INTERNAL','LDAP_SYNCH', 'EPWD', 'LDAP_PWD')
  into appsPwd
  from dual;

Line: 638

    insertRow(orclDefaultSubscriber);

Line: 695

    insertRow(orclAppName);

Line: 727

  insertRow(svcContainer);

Line: 768

    insertRow(appGuid);

Line: 810

    insertRow(realmGuid);

Line: 869

    insertRow('Profile Name = ' || l_base);

Line: 870

    insertRow('orclodipprofileinterfacename = ' || orclodipprofileinterfacename);

Line: 871

    insertRow('orclodipprofileinterfacetype = ' || orclodipprofileinterfacetype);

Line: 872

    insertRow('orclodipprovisioningappname = ' || orclodipprovisioningappname);

Line: 874

    insertRow('orclodipprofileschedule = ' || orclodipprofileschedule);

Line: 875

    insertRow('orclstatus = ' || orclstatus);

Line: 925

    insertRow('Provisioning profile not found for OID to Application');

Line: 963

    insertRow('Provisioning profile not found for Application to OID');

Line: 978

  dasNames := DasList('cn=OracleDASCreateUser', 'cn=OracleDASEditUser', 'cn=OracleDASCreateGroup', 'cn=OracleDASDeleteGroup','cn=OracleDASEditGroup');

Line: 982

    insertRow(dasNames(i));

Line: 1019

    insertRow(l_dn);

Line: 1056

  insertRow('DN = ' || l_base);

Line: 1060

  insertRow('orclserviceinstancelocation = ' || orclserviceinstancelocation);

Line: 1064

  insertRow('orclservicesubscriptionlocation = ' || orclservicesublocation);

Line: 1126

    insertRow(l_attrs(i));

Line: 1181

  select status into l_status
  from wf_events
  where name = eventName;

Line: 1198

  select status into l_status
  from wf_event_subscriptions
  where  source_type = 'LOCAL' and
  rule_function = subName;

Line: 1235

    insertRow(attrName || ' = ' || l_attrvalue);

Line: 1240

  insertRow(attrName);

Line: 1293

procedure insertRow(text in varchar2) is

html varchar2(4000);

Line: 1300

end insertRow;

Line: 1303

procedure insertColumn(text in varchar2) is

html varchar2(4000);

Line: 1310

end insertColumn;