APPS.WF_OID dependencies on WF_ENTITY_CHANGES

Line 148: l_entity_changes_rec fnd_oid_util.wf_entity_changes_rec_type;

144: function GetAppEvent(event out nocopy ldap_event)
145: return number is
146:
147: l_module_source varchar2(256);
148: l_entity_changes_rec fnd_oid_util.wf_entity_changes_rec_type;
149: l_ldap_key fnd_oid_util.ldap_key_type;
150: l_ldap_attr_list ldap_attr_list;
151: l_entity_id number;
152: my_temp_id number; -- for extra sub_add event --

Line 187: --Remove from wf_entity_changes to fix bug 4233358

183: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
184: 'We don''t sync users with profile APPS_SSO_LOCAL_LOGIN=LOCAL: '
185: || l_entity_changes_rec.entity_key_value);
186: end if;
187: --Remove from wf_entity_changes to fix bug 4233358
188: delete from wf_entity_changes
189: where entity_key_value = l_entity_changes_rec.entity_key_value
190: and entity_type = l_entity_changes_rec.entity_type;
191: raise fnd_oid_util.event_not_found_exp;

Line 188: delete from wf_entity_changes

184: 'We don''t sync users with profile APPS_SSO_LOCAL_LOGIN=LOCAL: '
185: || l_entity_changes_rec.entity_key_value);
186: end if;
187: --Remove from wf_entity_changes to fix bug 4233358
188: delete from wf_entity_changes
189: where entity_key_value = l_entity_changes_rec.entity_key_value
190: and entity_type = l_entity_changes_rec.entity_type;
191: raise fnd_oid_util.event_not_found_exp;
192: end if;

Line 218: delete from wf_entity_changes

214: 'We don''t modify users with profile APPS_SSO_LDAP_SYNC=N: '
215: || l_entity_changes_rec.entity_key_value);
216: end if;
217: event := l_copy_event;
218: delete from wf_entity_changes
219: where entity_key_value = l_entity_changes_rec.entity_key_value
220: and entity_type = l_entity_changes_rec.entity_type;
221: raise fnd_oid_util.event_not_found_exp;
222: end if;

Line 266: l_entity_key_value wf_entity_changes.entity_key_value%type;

262: l_module_source varchar2(256);
263: l_login_profile varchar2(30);
264: l_profile_defined boolean;
265: l_profiles fnd_oid_util.apps_sso_user_profiles_type;
266: l_entity_key_value wf_entity_changes.entity_key_value%type;
267: null_event_status_exp exception;
268:
269: begin
270: l_module_source := G_MODULE_SOURCE || 'PutAppEventStatus: ';

Line 322: delete from wf_entity_changes

318: set encrypted_user_password = fnd_oid_util.G_EXTERNAL
319: where user_name = l_entity_key_value;
320: end if;
321:
322: delete from wf_entity_changes
323: where entity_id = event_status.event_id;
324:
325: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
326: then

Line 328: , 'Deleted WF_ENTITY_CHANGES where entity_id = ' ||

324:
325: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
326: then
327: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
328: , 'Deleted WF_ENTITY_CHANGES where entity_id = ' ||
329: event_status.event_id);
330: end if;
331: else
332: -- RDESPOTO, 09/02/2004, if not success