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 678: wf_event.AddParameterToList('CHANGE_SOURCE', G_OID, my_parms);

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

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

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

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

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

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

681: save_to_cache(
682: p_ldap_attr_list => l_ldap_attr_list
683: , p_entity_type => wf_oid.IDENTITY_ADD
684: , p_entity_key_value => l_user_name);
685: wf_event.raise('oracle.apps.fnd.identity.add',
686: upper(l_user_name), null, my_parms);
687: -- Raise SUBSCRIPTION_ADD
688: send_subscription_add_to_OID
689: (p_orcl_guid => p_event.object_guid);

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

775: save_to_cache(
776: p_ldap_attr_list => l_ldap_attr_list
777: , p_entity_type => wf_oid.IDENTITY_MODIFY
778: , p_entity_key_value => l_user_name);
779: wf_event.raise('oracle.apps.fnd.identity.modify',
780: upper(l_user_name), null, null);
781:
782: end if;
783: end loop;

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

912: , p_entity_key_value => l_user_name);
913: my_ent_type := upper(wf_oid.SUBSCRIPTION_ADD);
914: wf_entity_mgr.put_attribute_value(my_ent_type, l_user_name,
915: 'CACHE_CHANGED', 'NO');
916: wf_event.AddParameterToList('CHANGE_SOURCE', G_OID, my_parms);
917: wf_event.AddParameterToList('ORCLGUID', p_event.object_guid, my_parms);
918: wf_event.AddParameterToList('CHANGE_TYPE', G_LOAD, my_parms);
919: wf_event.raise('oracle.apps.fnd.subscription.add',
920: upper(l_user_name), null, my_parms);

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

913: my_ent_type := upper(wf_oid.SUBSCRIPTION_ADD);
914: wf_entity_mgr.put_attribute_value(my_ent_type, l_user_name,
915: 'CACHE_CHANGED', 'NO');
916: wf_event.AddParameterToList('CHANGE_SOURCE', G_OID, my_parms);
917: wf_event.AddParameterToList('ORCLGUID', p_event.object_guid, my_parms);
918: wf_event.AddParameterToList('CHANGE_TYPE', G_LOAD, my_parms);
919: wf_event.raise('oracle.apps.fnd.subscription.add',
920: upper(l_user_name), null, my_parms);
921:

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

914: wf_entity_mgr.put_attribute_value(my_ent_type, l_user_name,
915: 'CACHE_CHANGED', 'NO');
916: wf_event.AddParameterToList('CHANGE_SOURCE', G_OID, my_parms);
917: wf_event.AddParameterToList('ORCLGUID', p_event.object_guid, my_parms);
918: wf_event.AddParameterToList('CHANGE_TYPE', G_LOAD, my_parms);
919: wf_event.raise('oracle.apps.fnd.subscription.add',
920: upper(l_user_name), null, my_parms);
921:
922: else

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

915: 'CACHE_CHANGED', 'NO');
916: wf_event.AddParameterToList('CHANGE_SOURCE', G_OID, my_parms);
917: wf_event.AddParameterToList('ORCLGUID', p_event.object_guid, my_parms);
918: wf_event.AddParameterToList('CHANGE_TYPE', G_LOAD, my_parms);
919: wf_event.raise('oracle.apps.fnd.subscription.add',
920: upper(l_user_name), null, my_parms);
921:
922: else
923:

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

1429: then
1430: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'After calling send_subscription_add_to_OID '||
1431: 'to send the subscription to OID');
1432: end if;
1433: wf_event.AddParameterToList('ORCLGUID', p_user_guid, l_parmeter_list);
1434: wf_event.AddParameterToList('USER_NAME', p_user_name, l_parmeter_list);
1435: wf_event.raise(l_event_name, p_user_name, null, l_parmeter_list);
1436:
1437: -- Create a subscription that will add the preferences responsiblity

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

1430: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'After calling send_subscription_add_to_OID '||
1431: 'to send the subscription to OID');
1432: end if;
1433: wf_event.AddParameterToList('ORCLGUID', p_user_guid, l_parmeter_list);
1434: wf_event.AddParameterToList('USER_NAME', p_user_name, l_parmeter_list);
1435: wf_event.raise(l_event_name, p_user_name, null, l_parmeter_list);
1436:
1437: -- Create a subscription that will add the preferences responsiblity
1438: -- See fnd_oid_subscriptions.assign_default_resp

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

1431: 'to send the subscription to OID');
1432: end if;
1433: wf_event.AddParameterToList('ORCLGUID', p_user_guid, l_parmeter_list);
1434: wf_event.AddParameterToList('USER_NAME', p_user_name, l_parmeter_list);
1435: wf_event.raise(l_event_name, p_user_name, null, l_parmeter_list);
1436:
1437: -- Create a subscription that will add the preferences responsiblity
1438: -- See fnd_oid_subscriptions.assign_default_resp
1439:

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

1529: end if;
1530: my_ent_type := upper(p_event_status.error_disposition);
1531: wf_entity_mgr.put_attribute_value(my_ent_type, l_entity_key_value,
1532: 'CACHE_CHANGED', 'NO');
1533: wf_event.AddParameterToList('CHANGE_SOURCE', G_OID, my_parms);
1534: wf_event.AddParameterToList('CHANGE_TYPE', G_LOAD, my_parms);
1535: wf_event.AddParameterToList('ORCLGUID', p_event_status.orclguid, my_parms);
1536: wf_event.AddParameterToList('USER_NAME', l_entity_key_value, my_parms);
1537: wf_event.AddParameterToList('ENTITY_ID', p_event_status.event_id, my_parms);

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

1530: my_ent_type := upper(p_event_status.error_disposition);
1531: wf_entity_mgr.put_attribute_value(my_ent_type, l_entity_key_value,
1532: 'CACHE_CHANGED', 'NO');
1533: wf_event.AddParameterToList('CHANGE_SOURCE', G_OID, my_parms);
1534: wf_event.AddParameterToList('CHANGE_TYPE', G_LOAD, my_parms);
1535: wf_event.AddParameterToList('ORCLGUID', p_event_status.orclguid, my_parms);
1536: wf_event.AddParameterToList('USER_NAME', l_entity_key_value, my_parms);
1537: wf_event.AddParameterToList('ENTITY_ID', p_event_status.event_id, my_parms);
1538: wf_event.raise(l_event_name, upper(l_entity_key_value), null, my_parms);

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

1531: wf_entity_mgr.put_attribute_value(my_ent_type, l_entity_key_value,
1532: 'CACHE_CHANGED', 'NO');
1533: wf_event.AddParameterToList('CHANGE_SOURCE', G_OID, my_parms);
1534: wf_event.AddParameterToList('CHANGE_TYPE', G_LOAD, my_parms);
1535: wf_event.AddParameterToList('ORCLGUID', p_event_status.orclguid, my_parms);
1536: wf_event.AddParameterToList('USER_NAME', l_entity_key_value, my_parms);
1537: wf_event.AddParameterToList('ENTITY_ID', p_event_status.event_id, my_parms);
1538: wf_event.raise(l_event_name, upper(l_entity_key_value), null, my_parms);
1539:

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

1532: 'CACHE_CHANGED', 'NO');
1533: wf_event.AddParameterToList('CHANGE_SOURCE', G_OID, my_parms);
1534: wf_event.AddParameterToList('CHANGE_TYPE', G_LOAD, my_parms);
1535: wf_event.AddParameterToList('ORCLGUID', p_event_status.orclguid, my_parms);
1536: wf_event.AddParameterToList('USER_NAME', l_entity_key_value, my_parms);
1537: wf_event.AddParameterToList('ENTITY_ID', p_event_status.event_id, my_parms);
1538: wf_event.raise(l_event_name, upper(l_entity_key_value), null, my_parms);
1539:
1540: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

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

1533: wf_event.AddParameterToList('CHANGE_SOURCE', G_OID, my_parms);
1534: wf_event.AddParameterToList('CHANGE_TYPE', G_LOAD, my_parms);
1535: wf_event.AddParameterToList('ORCLGUID', p_event_status.orclguid, my_parms);
1536: wf_event.AddParameterToList('USER_NAME', l_entity_key_value, my_parms);
1537: wf_event.AddParameterToList('ENTITY_ID', p_event_status.event_id, my_parms);
1538: wf_event.raise(l_event_name, upper(l_entity_key_value), null, my_parms);
1539:
1540: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1541: then

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

1534: wf_event.AddParameterToList('CHANGE_TYPE', G_LOAD, my_parms);
1535: wf_event.AddParameterToList('ORCLGUID', p_event_status.orclguid, my_parms);
1536: wf_event.AddParameterToList('USER_NAME', l_entity_key_value, my_parms);
1537: wf_event.AddParameterToList('ENTITY_ID', p_event_status.event_id, my_parms);
1538: wf_event.raise(l_event_name, upper(l_entity_key_value), null, my_parms);
1539:
1540: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1541: then
1542: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');

Line 2265: select status into l_status from wf_event_subscriptions

2261: end if;
2262:
2263:
2264: if (p_action = 'ADD') then
2265: select status into l_status from wf_event_subscriptions
2266: where rule_function = 'fnd_oid_subscriptions.hz_identity_add';
2267: elsif (p_action = 'MODIFY') then
2268: select status into l_status from wf_event_subscriptions
2269: where rule_function = 'fnd_oid_subscriptions.hz_identity_modify';

Line 2268: select status into l_status from wf_event_subscriptions

2264: if (p_action = 'ADD') then
2265: select status into l_status from wf_event_subscriptions
2266: where rule_function = 'fnd_oid_subscriptions.hz_identity_add';
2267: elsif (p_action = 'MODIFY') then
2268: select status into l_status from wf_event_subscriptions
2269: where rule_function = 'fnd_oid_subscriptions.hz_identity_modify';
2270: elsif (p_action = 'DELETE') then
2271: select status into l_status from wf_event_subscriptions
2272: where rule_function = 'fnd_oid_subscriptions.hz_identity_delete';

Line 2271: select status into l_status from wf_event_subscriptions

2267: elsif (p_action = 'MODIFY') then
2268: select status into l_status from wf_event_subscriptions
2269: where rule_function = 'fnd_oid_subscriptions.hz_identity_modify';
2270: elsif (p_action = 'DELETE') then
2271: select status into l_status from wf_event_subscriptions
2272: where rule_function = 'fnd_oid_subscriptions.hz_identity_delete';
2273: else
2274: -- Invalid action return true by default
2275: l_status := 'ENABLED';