[Home] [Help]
120: end map_sso_user_profiles;
121: --
122: -------------------------------------------------------------------------------
123: procedure map_entity_changes_rec(
124: p_entity_changes_rec in out nocopy fnd_oid_util.wf_entity_changes_rec_type
125: ) is
126:
127: cursor cur_entity_changes is
128: select entity_type, entity_key_value, flavor, change_date
126:
127: cursor cur_entity_changes is
128: select entity_type, entity_key_value, flavor, change_date
129: , to_char(change_date, fnd_oid_util.G_YYYYMMDDHH24MISS) change_date_in_char
130: from wf_entity_changes
131: where entity_id is null
132: and change_date <= sysdate
133: order by change_date
134: for update of entity_id;
159: p_entity_changes_rec.flavor := l_rec.flavor;
160: p_entity_changes_rec.change_date := l_rec.change_date;
161: p_entity_changes_rec.change_date_in_char := l_rec.change_date_in_char;
162:
163: select wf_entity_changes_s.nextval
164: into p_entity_changes_rec.entity_id
165: from dual;
166:
167: update wf_entity_changes
163: select wf_entity_changes_s.nextval
164: into p_entity_changes_rec.entity_id
165: from dual;
166:
167: update wf_entity_changes
168: set entity_id = p_entity_changes_rec.entity_id
169: where current of cur_entity_changes;
170:
171: close cur_entity_changes;
184:
185: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
186: then
187: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source
188: , 'No more changes in WF_ENTITY_CHANGES');
189: end if;
190: raise;
191:
192: when others then
833: --
834: -------------------------------------------------------------------------------
835: procedure map_oid_event(
836: p_ldap_key in fnd_oid_util.ldap_key_type
837: , p_entity_changes_rec in fnd_oid_util.wf_entity_changes_rec_type
838: , p_ldap_attr_list in ldap_attr_list
839: , p_event out nocopy ldap_event
840: ) is
841: