DBA Data[Home] [Help]

APPS.FND_OID_SUBSCRIPTIONS dependencies on WF_OID

Line 56: if (p_event_type = wf_oid.IDENTITY_MODIFY) then

52: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
53: then
54: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
55: end if;
56: if (p_event_type = wf_oid.IDENTITY_MODIFY) then
57: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
58: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'IDENTITY_MODIFY '
59: || 'event is handled by fnd_user_pkg.user_change().');
60: end if;

Line 67: if (p_event_type = wf_oid.SUBSCRIPTION_DELETE) then

63: --Check whether this guid already exists. Don't raise alerts because we receive echo
64: --from OID for each user that is created.
65: l_apps_userguid_key := fnd_oid_util.get_fnd_user(p_user_guid => p_user_guid);
66: -- Disable user in FND when user unsubscribed from the application in OID
67: if (p_event_type = wf_oid.SUBSCRIPTION_DELETE) then
68: update fnd_user set end_date= sysdate
69: where user_name = l_apps_userguid_key.user_name;
70: end if;
71: if (l_apps_userguid_key.user_id is not null) then

Line 326: l_event_name := WF_OID.IDENTITY_ADD;

322: 'EBIZ is NOW capable of understanding IDENTITY_ADD');
323: end if;
324: --RDESPOTO, Add IDENTITY_ADD, 11/09/2004
325: l_event_key := p_event.GetEventKey;
326: l_event_name := WF_OID.IDENTITY_ADD;
327:
328: l_change_source := p_event.GetValueForParameter(
329: fnd_oid_util.G_CHANGE_SOURCE);
330:

Line 350: , p_event_type => wf_oid.IDENTITY_ADD

346: end if;
347: -- Maintain IDENTITY_ADD event type to pick up email and fax correctly
348: fnd_create_update(
349: p_wf_event => p_event
350: , p_event_type => wf_oid.IDENTITY_ADD
351: , p_user_name => l_event_key
352: , p_user_guid => l_orcl_guid
353: , x_user_id => l_user_id
354: );

Line 390: , p_event_type => WF_OID.IDENTITY_MODIFY

386: l_orcl_guid := p_event.GetValueForParameter(
387: fnd_oid_util.G_ORCLGUID);
388: fnd_create_update(
389: p_wf_event => p_event
390: , p_event_type => WF_OID.IDENTITY_MODIFY
391: , p_user_name => p_event.GetEventKey()
392: , p_user_guid => l_orcl_guid
393: , x_user_id => l_user_id
394: );

Line 481: l_event_name := WF_OID.SUBSCRIPTION_ADD;

477: then
478: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
479: end if;
480: l_event_key := p_event.GetEventKey;
481: l_event_name := WF_OID.SUBSCRIPTION_ADD;
482:
483: l_change_source := p_event.GetValueForParameter(
484: fnd_oid_util.G_CHANGE_SOURCE);
485:

Line 504: , p_event_type => wf_oid.SUBSCRIPTION_ADD

500: || l_orcl_guid || ', user_name is ' || l_event_key);
501: end if;
502: fnd_create_update(
503: p_wf_event => p_event
504: , p_event_type => wf_oid.SUBSCRIPTION_ADD
505: , p_user_name => l_event_key
506: , p_user_guid => l_orcl_guid
507: , x_user_id => l_user_id
508: );

Line 563: l_event_name := WF_OID.SUBSCRIPTION_DELETE;

559: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
560: end if;
561:
562: l_event_key := p_event.GetEventKey;
563: l_event_name := WF_OID.SUBSCRIPTION_DELETE;
564: l_change_source := p_event.GetValueForParameter(
565: fnd_oid_util.G_CHANGE_SOURCE);
566:
567: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 582: wf_oid.SUBSCRIPTION_DELETE, l_event_key, l_change_source, sysdate);

578: then
579: insert into wf_entity_changes(
580: entity_type, entity_key_value, flavor, change_date)
581: values(
582: wf_oid.SUBSCRIPTION_DELETE, l_event_key, l_change_source, sysdate);
583:
584: else
585: --Rada, 01/31/2005
586: l_orcl_guid := p_event.GetValueForParameter(

Line 602: , p_event_type => wf_oid.SUBSCRIPTION_DELETE

598: , p_end_date => fnd_oid_util.G_NULL
599: , x_user_id => l_user_id);*/
600: fnd_create_update(
601: p_wf_event => p_event
602: , p_event_type => wf_oid.SUBSCRIPTION_DELETE
603: , p_user_name => l_event_key
604: , p_user_guid => l_orcl_guid
605: , x_user_id => l_user_id
606: );

Line 986: , p_event_type => wf_oid.IDENTITY_ADD

982: --Change_source has to be OID
983: if (l_change_source = fnd_oid_util.G_OID) then
984: hz_create_update(
985: p_wf_event => p_event
986: , p_event_type => wf_oid.IDENTITY_ADD
987: , p_return_status => l_return_status);
988: --RDESPOTO, End IDENTITY_ADD
989: end if;
990:

Line 1023: , p_event_type => wf_oid.IDENTITY_MODIFY

1019: end if;
1020:
1021: hz_create_update(
1022: p_wf_event => p_event
1023: , p_event_type => wf_oid.IDENTITY_MODIFY
1024: , p_return_status => l_return_status);
1025:
1026: if (l_return_status <> fnd_api.G_RET_STS_SUCCESS)
1027: then

Line 1106: , p_event_type => wf_oid.SUBSCRIPTION_ADD

1102: end if;
1103:
1104: hz_create_update(
1105: p_wf_event => p_event
1106: , p_event_type => wf_oid.SUBSCRIPTION_ADD
1107: , p_return_status => l_return_status);
1108:
1109: if (l_return_status <> fnd_api.G_RET_STS_SUCCESS)
1110: then

Line 1378: l_event_name := WF_OID.SUBSCRIPTION_ADD;

1374: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1375: end if;
1376:
1377: l_event_key := p_event.GetEventKey;
1378: l_event_name := WF_OID.SUBSCRIPTION_ADD;
1379: l_change_source := p_event.GetValueForParameter(
1380: fnd_oid_util.G_CHANGE_SOURCE);
1381:
1382: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)