DBA Data[Home] [Help]

APPS.FND_OID_UTIL dependencies on WF_EVENT

Line 104: wf_event.AddParameterToList('USER_NAME', p_username, my_parms);

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);
105: wf_util.call_me_later(
106: p_callback => 'wf_oid.future_callback',
107: p_when => my_start,
108: p_parameters => my_parms);

Line 119: wf_event.AddParameterToList('USER_NAME', p_username, my_parms);

115: --We don't propagate end-dating events to OID in this asynchronous process.
116: --This code can be uncommented when supporting logic for propagating end-dating events
117: --is implemented.
118: /*if (my_end > sysdate)
119: wf_event.AddParameterToList('USER_NAME', p_username, my_parms);
120: wf_util.call_me_later(
121: p_callback => 'wf_oid.future_callback',
122: p_when => my_end,
123: p_parameters => my_parms);

Line 683: wf_event.AddParameterToList('CHANGE_SOURCE', G_OID, my_parms);

679: -- Check whether profile is defined
680: -- We don't receive IDENTITY_ADD events when application is registered
681: if (l_profile_defined and l_allow_identity_add = 'Y') then
682: -- Raise oracle.apps.identity.add
683: wf_event.AddParameterToList('CHANGE_SOURCE', G_OID, my_parms);
684: wf_event.AddParameterToList('ORCLGUID', p_event.object_guid, my_parms);
685: wf_event.AddParameterToList('CHANGE_TYPE', G_LOAD, my_parms);
686: save_to_cache(
687: p_ldap_attr_list => l_ldap_attr_list

Line 684: wf_event.AddParameterToList('ORCLGUID', p_event.object_guid, my_parms);

680: -- We don't receive IDENTITY_ADD events when application is registered
681: if (l_profile_defined and l_allow_identity_add = 'Y') then
682: -- Raise oracle.apps.identity.add
683: wf_event.AddParameterToList('CHANGE_SOURCE', G_OID, my_parms);
684: wf_event.AddParameterToList('ORCLGUID', p_event.object_guid, my_parms);
685: wf_event.AddParameterToList('CHANGE_TYPE', G_LOAD, my_parms);
686: save_to_cache(
687: p_ldap_attr_list => l_ldap_attr_list
688: , p_entity_type => wf_oid.IDENTITY_ADD

Line 685: wf_event.AddParameterToList('CHANGE_TYPE', G_LOAD, my_parms);

681: if (l_profile_defined and l_allow_identity_add = 'Y') then
682: -- Raise oracle.apps.identity.add
683: wf_event.AddParameterToList('CHANGE_SOURCE', G_OID, my_parms);
684: wf_event.AddParameterToList('ORCLGUID', p_event.object_guid, my_parms);
685: wf_event.AddParameterToList('CHANGE_TYPE', G_LOAD, my_parms);
686: save_to_cache(
687: p_ldap_attr_list => l_ldap_attr_list
688: , p_entity_type => wf_oid.IDENTITY_ADD
689: , p_entity_key_value => l_user_name);

Line 690: wf_event.raise('oracle.apps.fnd.identity.add',

686: save_to_cache(
687: p_ldap_attr_list => l_ldap_attr_list
688: , p_entity_type => wf_oid.IDENTITY_ADD
689: , p_entity_key_value => l_user_name);
690: wf_event.raise('oracle.apps.fnd.identity.add',
691: upper(l_user_name), null, my_parms);
692: -- Raise SUBSCRIPTION_ADD
693: send_subscription_add_to_OID
694: (p_orcl_guid => p_event.object_guid);

Line 792: wf_event.raise('oracle.apps.fnd.identity.modify',

788: save_to_cache(
789: p_ldap_attr_list => l_ldap_attr_list
790: , p_entity_type => wf_oid.IDENTITY_MODIFY
791: , p_entity_key_value => l_user_name);
792: wf_event.raise('oracle.apps.fnd.identity.modify',
793: upper(l_user_name), null, null);
794:
795: end if;
796: end loop;

Line 885: wf_event.AddParameterToList('CHANGE_SOURCE', G_OID, my_parms);

881: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,'Raise identity_delete event for user: '||l_user_name);
882: end if;
883:
884: wf_entity_mgr.put_attribute_value(G_USER,l_user_name,G_CACHE_CHANGED,G_YES);
885: wf_event.AddParameterToList('CHANGE_SOURCE', G_OID, my_parms);
886: wf_event.AddParameterToList('ORCLGUID', p_event.object_guid, my_parms);
887: wf_event.AddParameterToList('CHANGE_TYPE', G_DELETE, my_parms);
888:
889: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 886: wf_event.AddParameterToList('ORCLGUID', p_event.object_guid, my_parms);

882: end if;
883:
884: wf_entity_mgr.put_attribute_value(G_USER,l_user_name,G_CACHE_CHANGED,G_YES);
885: wf_event.AddParameterToList('CHANGE_SOURCE', G_OID, my_parms);
886: wf_event.AddParameterToList('ORCLGUID', p_event.object_guid, my_parms);
887: wf_event.AddParameterToList('CHANGE_TYPE', G_DELETE, my_parms);
888:
889: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
890: then

Line 887: wf_event.AddParameterToList('CHANGE_TYPE', G_DELETE, my_parms);

883:
884: wf_entity_mgr.put_attribute_value(G_USER,l_user_name,G_CACHE_CHANGED,G_YES);
885: wf_event.AddParameterToList('CHANGE_SOURCE', G_OID, my_parms);
886: wf_event.AddParameterToList('ORCLGUID', p_event.object_guid, my_parms);
887: wf_event.AddParameterToList('CHANGE_TYPE', G_DELETE, my_parms);
888:
889: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
890: then
891: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,'added parameters');

Line 904: wf_event.raise('oracle.apps.fnd.identity.delete', upper(l_user_name), null, null);

900: then
901: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,'saved to cache...now raise event');
902: end if;
903:
904: wf_event.raise('oracle.apps.fnd.identity.delete', upper(l_user_name), null, null);
905:
906: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
907: then
908: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,'Unlink user');

Line 984: wf_event.AddParameterToList('CHANGE_SOURCE', G_OID, my_parms);

980: , p_entity_key_value => l_user_name);
981: my_ent_type := upper(wf_oid.SUBSCRIPTION_ADD);
982: wf_entity_mgr.put_attribute_value(my_ent_type, l_user_name,
983: 'CACHE_CHANGED', 'NO');
984: wf_event.AddParameterToList('CHANGE_SOURCE', G_OID, my_parms);
985: wf_event.AddParameterToList('ORCLGUID', p_event.object_guid, my_parms);
986: wf_event.AddParameterToList('CHANGE_TYPE', G_LOAD, my_parms);
987: wf_event.raise('oracle.apps.fnd.subscription.add',
988: upper(l_user_name), null, my_parms);

Line 985: wf_event.AddParameterToList('ORCLGUID', p_event.object_guid, my_parms);

981: my_ent_type := upper(wf_oid.SUBSCRIPTION_ADD);
982: wf_entity_mgr.put_attribute_value(my_ent_type, l_user_name,
983: 'CACHE_CHANGED', 'NO');
984: wf_event.AddParameterToList('CHANGE_SOURCE', G_OID, my_parms);
985: wf_event.AddParameterToList('ORCLGUID', p_event.object_guid, my_parms);
986: wf_event.AddParameterToList('CHANGE_TYPE', G_LOAD, my_parms);
987: wf_event.raise('oracle.apps.fnd.subscription.add',
988: upper(l_user_name), null, my_parms);
989:

Line 986: wf_event.AddParameterToList('CHANGE_TYPE', G_LOAD, my_parms);

982: wf_entity_mgr.put_attribute_value(my_ent_type, l_user_name,
983: 'CACHE_CHANGED', 'NO');
984: wf_event.AddParameterToList('CHANGE_SOURCE', G_OID, my_parms);
985: wf_event.AddParameterToList('ORCLGUID', p_event.object_guid, my_parms);
986: wf_event.AddParameterToList('CHANGE_TYPE', G_LOAD, my_parms);
987: wf_event.raise('oracle.apps.fnd.subscription.add',
988: upper(l_user_name), null, my_parms);
989:
990: else

Line 987: wf_event.raise('oracle.apps.fnd.subscription.add',

983: 'CACHE_CHANGED', 'NO');
984: wf_event.AddParameterToList('CHANGE_SOURCE', G_OID, my_parms);
985: wf_event.AddParameterToList('ORCLGUID', p_event.object_guid, my_parms);
986: wf_event.AddParameterToList('CHANGE_TYPE', G_LOAD, my_parms);
987: wf_event.raise('oracle.apps.fnd.subscription.add',
988: upper(l_user_name), null, my_parms);
989:
990: else
991:

Line 1501: wf_event.AddParameterToList('ORCLGUID', p_user_guid, l_parmeter_list);

1497: then
1498: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'After calling send_subscription_add_to_OID '||
1499: 'to send the subscription to OID');
1500: end if;
1501: wf_event.AddParameterToList('ORCLGUID', p_user_guid, l_parmeter_list);
1502: wf_event.AddParameterToList('USER_NAME', p_user_name, l_parmeter_list);
1503: wf_event.raise(l_event_name, p_user_name, null, l_parmeter_list);
1504:
1505: -- Create a subscription that will add the preferences responsiblity

Line 1502: wf_event.AddParameterToList('USER_NAME', p_user_name, l_parmeter_list);

1498: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'After calling send_subscription_add_to_OID '||
1499: 'to send the subscription to OID');
1500: end if;
1501: wf_event.AddParameterToList('ORCLGUID', p_user_guid, l_parmeter_list);
1502: wf_event.AddParameterToList('USER_NAME', p_user_name, l_parmeter_list);
1503: wf_event.raise(l_event_name, p_user_name, null, l_parmeter_list);
1504:
1505: -- Create a subscription that will add the preferences responsiblity
1506: -- See fnd_oid_subscriptions.assign_default_resp

Line 1503: wf_event.raise(l_event_name, p_user_name, null, l_parmeter_list);

1499: 'to send the subscription to OID');
1500: end if;
1501: wf_event.AddParameterToList('ORCLGUID', p_user_guid, l_parmeter_list);
1502: wf_event.AddParameterToList('USER_NAME', p_user_name, l_parmeter_list);
1503: wf_event.raise(l_event_name, p_user_name, null, l_parmeter_list);
1504:
1505: -- Create a subscription that will add the preferences responsiblity
1506: -- See fnd_oid_subscriptions.assign_default_resp
1507:

Line 1601: wf_event.AddParameterToList('CHANGE_SOURCE', G_OID, my_parms);

1597: end if;
1598: my_ent_type := upper(p_event_status.error_disposition);
1599: wf_entity_mgr.put_attribute_value(my_ent_type, l_entity_key_value,
1600: 'CACHE_CHANGED', 'NO');
1601: wf_event.AddParameterToList('CHANGE_SOURCE', G_OID, my_parms);
1602: wf_event.AddParameterToList('CHANGE_TYPE', G_LOAD, my_parms);
1603: wf_event.AddParameterToList('ORCLGUID', p_event_status.orclguid, my_parms);
1604: wf_event.AddParameterToList('USER_NAME', l_entity_key_value, my_parms);
1605: wf_event.AddParameterToList('ENTITY_ID', p_event_status.event_id, my_parms);

Line 1602: wf_event.AddParameterToList('CHANGE_TYPE', G_LOAD, my_parms);

1598: my_ent_type := upper(p_event_status.error_disposition);
1599: wf_entity_mgr.put_attribute_value(my_ent_type, l_entity_key_value,
1600: 'CACHE_CHANGED', 'NO');
1601: wf_event.AddParameterToList('CHANGE_SOURCE', G_OID, my_parms);
1602: wf_event.AddParameterToList('CHANGE_TYPE', G_LOAD, my_parms);
1603: wf_event.AddParameterToList('ORCLGUID', p_event_status.orclguid, my_parms);
1604: wf_event.AddParameterToList('USER_NAME', l_entity_key_value, my_parms);
1605: wf_event.AddParameterToList('ENTITY_ID', p_event_status.event_id, my_parms);
1606: wf_event.raise(l_event_name, upper(l_entity_key_value), null, my_parms);

Line 1603: wf_event.AddParameterToList('ORCLGUID', p_event_status.orclguid, my_parms);

1599: wf_entity_mgr.put_attribute_value(my_ent_type, l_entity_key_value,
1600: 'CACHE_CHANGED', 'NO');
1601: wf_event.AddParameterToList('CHANGE_SOURCE', G_OID, my_parms);
1602: wf_event.AddParameterToList('CHANGE_TYPE', G_LOAD, my_parms);
1603: wf_event.AddParameterToList('ORCLGUID', p_event_status.orclguid, my_parms);
1604: wf_event.AddParameterToList('USER_NAME', l_entity_key_value, my_parms);
1605: wf_event.AddParameterToList('ENTITY_ID', p_event_status.event_id, my_parms);
1606: wf_event.raise(l_event_name, upper(l_entity_key_value), null, my_parms);
1607:

Line 1604: wf_event.AddParameterToList('USER_NAME', l_entity_key_value, my_parms);

1600: 'CACHE_CHANGED', 'NO');
1601: wf_event.AddParameterToList('CHANGE_SOURCE', G_OID, my_parms);
1602: wf_event.AddParameterToList('CHANGE_TYPE', G_LOAD, my_parms);
1603: wf_event.AddParameterToList('ORCLGUID', p_event_status.orclguid, my_parms);
1604: wf_event.AddParameterToList('USER_NAME', l_entity_key_value, my_parms);
1605: wf_event.AddParameterToList('ENTITY_ID', p_event_status.event_id, my_parms);
1606: wf_event.raise(l_event_name, upper(l_entity_key_value), null, my_parms);
1607:
1608: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 1605: wf_event.AddParameterToList('ENTITY_ID', p_event_status.event_id, my_parms);

1601: wf_event.AddParameterToList('CHANGE_SOURCE', G_OID, my_parms);
1602: wf_event.AddParameterToList('CHANGE_TYPE', G_LOAD, my_parms);
1603: wf_event.AddParameterToList('ORCLGUID', p_event_status.orclguid, my_parms);
1604: wf_event.AddParameterToList('USER_NAME', l_entity_key_value, my_parms);
1605: wf_event.AddParameterToList('ENTITY_ID', p_event_status.event_id, my_parms);
1606: wf_event.raise(l_event_name, upper(l_entity_key_value), null, my_parms);
1607:
1608: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1609: then

Line 1606: wf_event.raise(l_event_name, upper(l_entity_key_value), null, my_parms);

1602: wf_event.AddParameterToList('CHANGE_TYPE', G_LOAD, my_parms);
1603: wf_event.AddParameterToList('ORCLGUID', p_event_status.orclguid, my_parms);
1604: wf_event.AddParameterToList('USER_NAME', l_entity_key_value, my_parms);
1605: wf_event.AddParameterToList('ENTITY_ID', p_event_status.event_id, my_parms);
1606: wf_event.raise(l_event_name, upper(l_entity_key_value), null, my_parms);
1607:
1608: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1609: then
1610: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');

Line 2429: select status into l_status from wf_event_subscriptions

2425: end if;
2426:
2427:
2428: if (p_action = 'ADD') then
2429: select status into l_status from wf_event_subscriptions
2430: where rule_function = 'fnd_oid_subscriptions.hz_identity_add';
2431: elsif (p_action = 'MODIFY') then
2432: select status into l_status from wf_event_subscriptions
2433: where rule_function = 'fnd_oid_subscriptions.hz_identity_modify';

Line 2432: select status into l_status from wf_event_subscriptions

2428: if (p_action = 'ADD') then
2429: select status into l_status from wf_event_subscriptions
2430: where rule_function = 'fnd_oid_subscriptions.hz_identity_add';
2431: elsif (p_action = 'MODIFY') then
2432: select status into l_status from wf_event_subscriptions
2433: where rule_function = 'fnd_oid_subscriptions.hz_identity_modify';
2434: elsif (p_action = 'DELETE') then
2435: select status into l_status from wf_event_subscriptions
2436: where rule_function = 'fnd_oid_subscriptions.hz_identity_delete';

Line 2435: select status into l_status from wf_event_subscriptions

2431: elsif (p_action = 'MODIFY') then
2432: select status into l_status from wf_event_subscriptions
2433: where rule_function = 'fnd_oid_subscriptions.hz_identity_modify';
2434: elsif (p_action = 'DELETE') then
2435: select status into l_status from wf_event_subscriptions
2436: where rule_function = 'fnd_oid_subscriptions.hz_identity_delete';
2437: else
2438: -- Invalid action return true by default
2439: l_status := 'ENABLED';