DBA Data[Home] [Help]

APPS.WF_EVENT_SUBSCRIPTIONS_PKG dependencies on WF_EVENTS_PKG

Line 71: l_licensed_flag := WF_EVENTS_PKG.is_product_licensed (X_OWNER_TAG);

67: validate_subscription (X_EVENT_FILTER_GUID,
68: X_CUSTOMIZATION_LEVEL,
69: X_STATUS); -- Bug 2756800
70:
71: l_licensed_flag := WF_EVENTS_PKG.is_product_licensed (X_OWNER_TAG);
72: if (X_RULE_FUNCTION is null and X_JAVA_RULE_FUNC is null) then
73: l_rule_func := 'WF_RULE.DEFAULT_RULE';
74: elsif (x_rule_function is not null) then
75: l_rule_func := x_rule_function;

Line 233: l_licensed_flag := WF_EVENTS_PKG.is_product_licensed (X_OWNER_TAG);

229: validate_subscription (X_EVENT_FILTER_GUID,
230: X_CUSTOMIZATION_LEVEL,
231: X_STATUS); -- Bug 2756800
232:
233: l_licensed_flag := WF_EVENTS_PKG.is_product_licensed (X_OWNER_TAG);
234: if (X_RULE_FUNCTION is null and X_JAVA_RULE_FUNC is null) then
235: l_rule_func := 'WF_RULE.DEFAULT_RULE';
236: elsif (x_rule_function is not null) then
237: l_rule_func := x_rule_function;

Line 277: if WF_EVENTS_PKG.g_Mode = 'FORCE' then

273: Wf_Core.Token('OWNERTAG', x_owner_tag);
274: Wf_Core.Raise('WFE_DUPLICATE_SUB');
275: end if;
276:
277: if WF_EVENTS_PKG.g_Mode = 'FORCE' then
278: update wf_event_subscriptions set
279: system_guid = X_SYSTEM_GUID,
280: source_type = X_SOURCE_TYPE,
281: source_agent_guid = X_SOURCE_AGENT_GUID,

Line 316: l_update_allowed := WF_EVENTS_PKG.is_update_allowed(X_CUSTOMIZATION_LEVEL, l_custom_level);

312:
313: else
314: -- User logged in is not seed
315: fetch_custom_level(X_GUID, l_custom_level);
316: l_update_allowed := WF_EVENTS_PKG.is_update_allowed(X_CUSTOMIZATION_LEVEL, l_custom_level);
317:
318: if l_update_allowed = 'N' then
319: -- Set up the Error Stack
320: wf_core.context('WF_EVENT_SUBSCRIPTIONS_PKG','UPDATE_ROW',

Line 328: if WF_EVENTS_PKG.g_Mode = 'UPGRADE' then

324: return;
325: end if;
326:
327: if X_CUSTOMIZATION_LEVEL = 'C'then
328: if WF_EVENTS_PKG.g_Mode = 'UPGRADE' then
329: -- Here are the updates allowed when the caller is the Loader
330: update wf_event_subscriptions set
331: system_guid = X_SYSTEM_GUID,
332: source_type = X_SOURCE_TYPE,

Line 366: if WF_EVENTS_PKG.g_Mode = 'UPGRADE' then

362: null;
363:
364: end if;
365: elsif X_CUSTOMIZATION_LEVEL = 'L' then
366: if WF_EVENTS_PKG.g_Mode = 'UPGRADE' then
367: -- Limit events can have only a status change..
368: -- When the loader is loading the events the
369: -- users changes must be preserved. Update all
370: -- fields EXCEPT the status field.

Line 418: if WF_EVENTS_PKG.g_Mode = 'CUSTOM' then

414: elsif X_CUSTOMIZATION_LEVEL = 'U' then
415: -- Here are the updates allowed for extensible and User defined events
416: -- only when the caller is the UI
417:
418: if WF_EVENTS_PKG.g_Mode = 'CUSTOM' then
419: update wf_event_subscriptions set
420: system_guid = X_SYSTEM_GUID,
421: source_type = X_SOURCE_TYPE,
422: source_agent_guid = X_SOURCE_AGENT_GUID,

Line 960: if WF_EVENTS_PKG.g_Mode <> 'UPGRADE' then

956: -- Phase must not be null
957: if L_PHASE is null then
958: -- For backward compatibility of the WFXLoad do not raise any errors when
959: -- the caller is the Loader. Throw a warning only
960: if WF_EVENTS_PKG.g_Mode <> 'UPGRADE' then
961: Wf_Core.Token('REASON','Subscription Phase cannot be null');
962: Wf_Core.Raise('WFSQL_INTERNAL');
963: else
964: wf_core.context('Wf_Events_Subscriptions_Pkg', 'Receive',

Line 978: if WF_EVENTS_PKG.g_Mode <> 'UPGRADE' then

974: or (L_OWNER_TAG is null) then
975:
976: -- For backward compatibility of the WFXLoad do not raise any errors when
977: -- the caller is the Loader. Throw a warning only
978: if WF_EVENTS_PKG.g_Mode <> 'UPGRADE' then
979: Wf_Core.Token('REASON','Subscription Owner Name and Owner Tag cannot be null');
980: Wf_Core.Raise('WFSQL_INTERNAL');
981: else
982: wf_core.context('Wf_Events_Subscriptions_Pkg', 'Receive',