DBA Data[Home] [Help]

APPS.FND_OID_UTIL dependencies on WF_ENTITY_CHANGES

Line 100: insert into wf_entity_changes(

96: my_userid := NULL;
97: end;
98: -- Fix bug 4245881, don't sync inactive users
99: if (my_start <= sysdate and (my_end is null or my_end > sysdate)) then
100: insert into wf_entity_changes(
101: entity_type, entity_key_value, flavor, change_date)
102: values('USER', p_username, my_flavor, sysdate);
103: elsif my_start > sysdate then
104: wf_event.AddParameterToList('USER_NAME', p_username, my_parms);

Line 1555: l_entity_key_value wf_entity_changes.entity_key_value%type;

1551: -------------------------------------------------------------------------------
1552: procedure process_no_success_event(p_event_status in ldap_event_status) is
1553:
1554: l_module_source varchar2(256);
1555: l_entity_key_value wf_entity_changes.entity_key_value%type;
1556: l_event_name varchar2(80);
1557: my_ent_type varchar2(50);
1558: my_parms wf_parameter_list_t;
1559:

Line 1680: p_event_id in wf_entity_changes.entity_id%type

1676: end save_to_cache;
1677: --
1678: -------------------------------------------------------------------------------
1679: procedure get_entity_key_value(
1680: p_event_id in wf_entity_changes.entity_id%type
1681: , p_entity_key_value out nocopy wf_entity_changes.entity_key_value%type
1682: ) is
1683:
1684: cursor cur_entity_changes is

Line 1681: , p_entity_key_value out nocopy wf_entity_changes.entity_key_value%type

1677: --
1678: -------------------------------------------------------------------------------
1679: procedure get_entity_key_value(
1680: p_event_id in wf_entity_changes.entity_id%type
1681: , p_entity_key_value out nocopy wf_entity_changes.entity_key_value%type
1682: ) is
1683:
1684: cursor cur_entity_changes is
1685: select entity_key_value

Line 1686: from wf_entity_changes

1682: ) is
1683:
1684: cursor cur_entity_changes is
1685: select entity_key_value
1686: from wf_entity_changes
1687: where entity_id = p_event_id;
1688:
1689: l_module_source varchar2(256);
1690:

Line 1939: p_entity_changes_rec in wf_entity_changes_rec_type)

1935: end;
1936: --
1937: -------------------------------------------------------------------------------
1938: function get_entity_changes_rec_str(
1939: p_entity_changes_rec in wf_entity_changes_rec_type)
1940: return varchar2 is
1941:
1942: l_module_source varchar2(256);
1943: l_str varchar2(4000);

Line 2362: insert into wf_entity_changes(

2358: wf_entity_mgr.put_attribute_value(wf_oid.SUBSCRIPTION_ADD, l_user_name,
2359: G_CACHE_CHANGED, G_YES);
2360: wf_entity_mgr.put_attribute_value(wf_oid.SUBSCRIPTION_ADD, l_user_name,
2361: G_ORCLGUID, p_orcl_guid);
2362: insert into wf_entity_changes(
2363: entity_type, entity_key_value, flavor, change_date)
2364: values(wf_oid.SUBSCRIPTION_ADD, upper(l_user_name), 'FND', sysdate);
2365: wf_entity_mgr.put_attribute_value(upper(wf_oid.SUBSCRIPTION_ADD), l_user_name,
2366: 'CACHE_CHANGED', 'NO');