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 1487: l_entity_key_value wf_entity_changes.entity_key_value%type;

1483: -------------------------------------------------------------------------------
1484: procedure process_no_success_event(p_event_status in ldap_event_status) is
1485:
1486: l_module_source varchar2(256);
1487: l_entity_key_value wf_entity_changes.entity_key_value%type;
1488: l_event_name varchar2(80);
1489: my_ent_type varchar2(50);
1490: my_parms wf_parameter_list_t;
1491:

Line 1612: p_event_id in wf_entity_changes.entity_id%type

1608: end save_to_cache;
1609: --
1610: -------------------------------------------------------------------------------
1611: procedure get_entity_key_value(
1612: p_event_id in wf_entity_changes.entity_id%type
1613: , p_entity_key_value out nocopy wf_entity_changes.entity_key_value%type
1614: ) is
1615:
1616: cursor cur_entity_changes is

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

1609: --
1610: -------------------------------------------------------------------------------
1611: procedure get_entity_key_value(
1612: p_event_id in wf_entity_changes.entity_id%type
1613: , p_entity_key_value out nocopy wf_entity_changes.entity_key_value%type
1614: ) is
1615:
1616: cursor cur_entity_changes is
1617: select entity_key_value

Line 1618: from wf_entity_changes

1614: ) is
1615:
1616: cursor cur_entity_changes is
1617: select entity_key_value
1618: from wf_entity_changes
1619: where entity_id = p_event_id;
1620:
1621: l_module_source varchar2(256);
1622:

Line 1871: p_entity_changes_rec in wf_entity_changes_rec_type)

1867: end;
1868: --
1869: -------------------------------------------------------------------------------
1870: function get_entity_changes_rec_str(
1871: p_entity_changes_rec in wf_entity_changes_rec_type)
1872: return varchar2 is
1873:
1874: l_module_source varchar2(256);
1875: l_str varchar2(4000);

Line 2198: insert into wf_entity_changes(

2194: wf_entity_mgr.put_attribute_value(wf_oid.SUBSCRIPTION_ADD, l_user_name,
2195: G_CACHE_CHANGED, G_YES);
2196: wf_entity_mgr.put_attribute_value(wf_oid.SUBSCRIPTION_ADD, l_user_name,
2197: G_ORCLGUID, p_orcl_guid);
2198: insert into wf_entity_changes(
2199: entity_type, entity_key_value, flavor, change_date)
2200: values(wf_oid.SUBSCRIPTION_ADD, upper(l_user_name), 'FND', sysdate);
2201: wf_entity_mgr.put_attribute_value(upper(wf_oid.SUBSCRIPTION_ADD), l_user_name,
2202: 'CACHE_CHANGED', 'NO');