The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure insertRow(text in varchar2);
procedure insertColumn(text in varchar2);
insertRow('DBMS_LDAP resolves to '||schema||'.'||'DBMS_LDAP and not to PACKAGE SYS.DBMS_LDAP');
insertRow('Package DBMS_LDAP is not accessible');
insertRow('Error '||sqlerrm||'(' || sqlcode || ') during dbms_ldap validation');
insertRow('Error '||sqlerrm||'(' || sqlcode || ') durint dbms_ldap validation');
insertRow(' SYS.DBMS_LDAP is available');
insertRow('APPS_SSO is not defined ');
insertRow('APPS_SSO_LDAP_SYNC is not defined ');
insertRow(' APPS_SSO= '||sso);
insertRow(' APPS_SSO_LDAP_SYNC= '||sync);
insertRow('OiD synchronization is enabled');
insertRow('OiD synchronization is NOT enabled');
insertRow('AppDN is null');
insertRow(' AppDn: '||orclAppName);
insertRow('Password is null');
insertRow('OiD host is null');
insertRow('OiD host: '||host);
insertRow('OiD port is null');
insertRow('OiD port: '||port);
insertRow('Failed to connect to OiD ');
jtf_diagnostic_coreapi.insert_style_sheet;
insertRow('Event Status ');
'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');
insertColumn(event);
insertColumn(l_status||' Incorrect ');
insertColumn(l_status);
select s.status, e.name
from wf_events e, wf_event_subscriptions s
where rule_function = sub and
s.event_filter_guid = e.guid;
'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');
select fnd_preference.eget('#INTERNAL','LDAP_SYNCH', 'EPWD', 'LDAP_PWD')
into appsPwd
from dual;
insertRow(orclDefaultSubscriber);
insertRow(orclAppName);
insertRow(svcContainer);
insertRow(appGuid);
insertRow(realmGuid);
insertRow('Profile Name = ' || l_base);
insertRow('orclodipprofileinterfacename = ' || orclodipprofileinterfacename);
insertRow('orclodipprofileinterfacetype = ' || orclodipprofileinterfacetype);
insertRow('orclodipprovisioningappname = ' || orclodipprovisioningappname);
insertRow('orclodipprofileschedule = ' || orclodipprofileschedule);
insertRow('orclstatus = ' || orclstatus);
insertRow('Provisioning profile not found for OID to Application');
insertRow('Provisioning profile not found for Application to OID');
dasNames := DasList('cn=OracleDASCreateUser', 'cn=OracleDASEditUser', 'cn=OracleDASCreateGroup', 'cn=OracleDASDeleteGroup','cn=OracleDASEditGroup');
insertRow(dasNames(i));
insertRow(l_dn);
insertRow('DN = ' || l_base);
insertRow('orclserviceinstancelocation = ' || orclserviceinstancelocation);
insertRow('orclservicesubscriptionlocation = ' || orclservicesublocation);
insertRow(l_attrs(i));
select status into l_status
from wf_events
where name = eventName;
select status into l_status
from wf_event_subscriptions
where source_type = 'LOCAL' and
rule_function = subName;
insertRow(attrName || ' = ' || l_attrvalue);
insertRow(attrName);
procedure insertRow(text in varchar2) is
html varchar2(4000);
end insertRow;
procedure insertColumn(text in varchar2) is
html varchar2(4000);
end insertColumn;