eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WF_EVENT_FUNCTIONS_PKG dependencies on WF_EVENT

Line 1: package body WF_EVENT_FUNCTIONS_PKG as

1: package body WF_EVENT_FUNCTIONS_PKG as
2: /* $Header: WFEVFNCB.pls 120.6.12010000.2 2009/02/18 05:44:56 skandepu ship $ */
3:
4: ------------------------------------------------------------------------------
5: /*

Line 29: if p_event_name = 'oracle.apps.wf.event.system.create' then

25: l_parameters := t_parameters(1,2);
26:
27: dbms_lob.createtemporary(msg, FALSE, DBMS_LOB.CALL);
28:
29: if p_event_name = 'oracle.apps.wf.event.system.create' then
30: dtd := wf_systems_pkg.generate(p_event_key);
31: elsif p_event_name = 'oracle.apps.wf.event.system.delete' then
32: dtd := wf_systems_pkg.generate(p_event_key);
33: elsif p_event_name = 'oracle.apps.wf.event.system.update' then

Line 31: elsif p_event_name = 'oracle.apps.wf.event.system.delete' then

27: dbms_lob.createtemporary(msg, FALSE, DBMS_LOB.CALL);
28:
29: if p_event_name = 'oracle.apps.wf.event.system.create' then
30: dtd := wf_systems_pkg.generate(p_event_key);
31: elsif p_event_name = 'oracle.apps.wf.event.system.delete' then
32: dtd := wf_systems_pkg.generate(p_event_key);
33: elsif p_event_name = 'oracle.apps.wf.event.system.update' then
34: dtd := wf_systems_pkg.generate(p_event_key);
35: elsif p_event_name = 'oracle.apps.wf.event.agent.create' then

Line 33: elsif p_event_name = 'oracle.apps.wf.event.system.update' then

29: if p_event_name = 'oracle.apps.wf.event.system.create' then
30: dtd := wf_systems_pkg.generate(p_event_key);
31: elsif p_event_name = 'oracle.apps.wf.event.system.delete' then
32: dtd := wf_systems_pkg.generate(p_event_key);
33: elsif p_event_name = 'oracle.apps.wf.event.system.update' then
34: dtd := wf_systems_pkg.generate(p_event_key);
35: elsif p_event_name = 'oracle.apps.wf.event.agent.create' then
36: dtd := wf_agents_pkg.generate(p_event_key);
37: elsif p_event_name = 'oracle.apps.wf.event.agent.delete' then

Line 35: elsif p_event_name = 'oracle.apps.wf.event.agent.create' then

31: elsif p_event_name = 'oracle.apps.wf.event.system.delete' then
32: dtd := wf_systems_pkg.generate(p_event_key);
33: elsif p_event_name = 'oracle.apps.wf.event.system.update' then
34: dtd := wf_systems_pkg.generate(p_event_key);
35: elsif p_event_name = 'oracle.apps.wf.event.agent.create' then
36: dtd := wf_agents_pkg.generate(p_event_key);
37: elsif p_event_name = 'oracle.apps.wf.event.agent.delete' then
38: dtd := wf_agents_pkg.generate(p_event_key);
39: elsif p_event_name = 'oracle.apps.wf.event.agent.update' then

Line 37: elsif p_event_name = 'oracle.apps.wf.event.agent.delete' then

33: elsif p_event_name = 'oracle.apps.wf.event.system.update' then
34: dtd := wf_systems_pkg.generate(p_event_key);
35: elsif p_event_name = 'oracle.apps.wf.event.agent.create' then
36: dtd := wf_agents_pkg.generate(p_event_key);
37: elsif p_event_name = 'oracle.apps.wf.event.agent.delete' then
38: dtd := wf_agents_pkg.generate(p_event_key);
39: elsif p_event_name = 'oracle.apps.wf.event.agent.update' then
40: dtd := wf_agents_pkg.generate(p_event_key);
41: elsif p_event_name = 'oracle.apps.wf.event.agentgroup.create' then

Line 39: elsif p_event_name = 'oracle.apps.wf.event.agent.update' then

35: elsif p_event_name = 'oracle.apps.wf.event.agent.create' then
36: dtd := wf_agents_pkg.generate(p_event_key);
37: elsif p_event_name = 'oracle.apps.wf.event.agent.delete' then
38: dtd := wf_agents_pkg.generate(p_event_key);
39: elsif p_event_name = 'oracle.apps.wf.event.agent.update' then
40: dtd := wf_agents_pkg.generate(p_event_key);
41: elsif p_event_name = 'oracle.apps.wf.event.agentgroup.create' then
42: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
43: 2,'/');

Line 41: elsif p_event_name = 'oracle.apps.wf.event.agentgroup.create' then

37: elsif p_event_name = 'oracle.apps.wf.event.agent.delete' then
38: dtd := wf_agents_pkg.generate(p_event_key);
39: elsif p_event_name = 'oracle.apps.wf.event.agent.update' then
40: dtd := wf_agents_pkg.generate(p_event_key);
41: elsif p_event_name = 'oracle.apps.wf.event.agentgroup.create' then
42: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
43: 2,'/');
44: dtd := wf_agent_groups_pkg.generate(l_parameters(1), l_parameters(2));
45: elsif p_event_name = 'oracle.apps.wf.event.agentgroup.delete' then

Line 42: l_parameters := wf_event_functions_pkg.parameters(p_event_key,

38: dtd := wf_agents_pkg.generate(p_event_key);
39: elsif p_event_name = 'oracle.apps.wf.event.agent.update' then
40: dtd := wf_agents_pkg.generate(p_event_key);
41: elsif p_event_name = 'oracle.apps.wf.event.agentgroup.create' then
42: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
43: 2,'/');
44: dtd := wf_agent_groups_pkg.generate(l_parameters(1), l_parameters(2));
45: elsif p_event_name = 'oracle.apps.wf.event.agentgroup.delete' then
46: l_parameters := wf_event_functions_pkg.parameters(p_event_key,

Line 45: elsif p_event_name = 'oracle.apps.wf.event.agentgroup.delete' then

41: elsif p_event_name = 'oracle.apps.wf.event.agentgroup.create' then
42: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
43: 2,'/');
44: dtd := wf_agent_groups_pkg.generate(l_parameters(1), l_parameters(2));
45: elsif p_event_name = 'oracle.apps.wf.event.agentgroup.delete' then
46: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
47: 2,'/');
48: dtd := wf_agent_groups_pkg.generate(l_parameters(1), l_parameters(2));
49: elsif p_event_name = 'oracle.apps.wf.event.agentgroup.update' then

Line 46: l_parameters := wf_event_functions_pkg.parameters(p_event_key,

42: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
43: 2,'/');
44: dtd := wf_agent_groups_pkg.generate(l_parameters(1), l_parameters(2));
45: elsif p_event_name = 'oracle.apps.wf.event.agentgroup.delete' then
46: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
47: 2,'/');
48: dtd := wf_agent_groups_pkg.generate(l_parameters(1), l_parameters(2));
49: elsif p_event_name = 'oracle.apps.wf.event.agentgroup.update' then
50: l_parameters := wf_event_functions_pkg.parameters(p_event_key,

Line 49: elsif p_event_name = 'oracle.apps.wf.event.agentgroup.update' then

45: elsif p_event_name = 'oracle.apps.wf.event.agentgroup.delete' then
46: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
47: 2,'/');
48: dtd := wf_agent_groups_pkg.generate(l_parameters(1), l_parameters(2));
49: elsif p_event_name = 'oracle.apps.wf.event.agentgroup.update' then
50: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
51: 2,'/');
52: dtd := wf_agent_groups_pkg.generate1(l_parameters(1), l_parameters(2));
53: elsif p_event_name = 'oracle.apps.wf.event.event.create' then

Line 50: l_parameters := wf_event_functions_pkg.parameters(p_event_key,

46: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
47: 2,'/');
48: dtd := wf_agent_groups_pkg.generate(l_parameters(1), l_parameters(2));
49: elsif p_event_name = 'oracle.apps.wf.event.agentgroup.update' then
50: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
51: 2,'/');
52: dtd := wf_agent_groups_pkg.generate1(l_parameters(1), l_parameters(2));
53: elsif p_event_name = 'oracle.apps.wf.event.event.create' then
54: dtd := wf_events_pkg.generate(p_event_key);

Line 53: elsif p_event_name = 'oracle.apps.wf.event.event.create' then

49: elsif p_event_name = 'oracle.apps.wf.event.agentgroup.update' then
50: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
51: 2,'/');
52: dtd := wf_agent_groups_pkg.generate1(l_parameters(1), l_parameters(2));
53: elsif p_event_name = 'oracle.apps.wf.event.event.create' then
54: dtd := wf_events_pkg.generate(p_event_key);
55: elsif p_event_name = 'oracle.apps.wf.event.event.delete' then
56: dtd := wf_events_pkg.generate(p_event_key);
57: elsif p_event_name = 'oracle.apps.wf.event.event.update' then

Line 54: dtd := wf_events_pkg.generate(p_event_key);

50: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
51: 2,'/');
52: dtd := wf_agent_groups_pkg.generate1(l_parameters(1), l_parameters(2));
53: elsif p_event_name = 'oracle.apps.wf.event.event.create' then
54: dtd := wf_events_pkg.generate(p_event_key);
55: elsif p_event_name = 'oracle.apps.wf.event.event.delete' then
56: dtd := wf_events_pkg.generate(p_event_key);
57: elsif p_event_name = 'oracle.apps.wf.event.event.update' then
58: dtd := wf_events_pkg.generate(p_event_key);

Line 55: elsif p_event_name = 'oracle.apps.wf.event.event.delete' then

51: 2,'/');
52: dtd := wf_agent_groups_pkg.generate1(l_parameters(1), l_parameters(2));
53: elsif p_event_name = 'oracle.apps.wf.event.event.create' then
54: dtd := wf_events_pkg.generate(p_event_key);
55: elsif p_event_name = 'oracle.apps.wf.event.event.delete' then
56: dtd := wf_events_pkg.generate(p_event_key);
57: elsif p_event_name = 'oracle.apps.wf.event.event.update' then
58: dtd := wf_events_pkg.generate(p_event_key);
59: elsif p_event_name = 'oracle.apps.wf.event.group.create' then

Line 56: dtd := wf_events_pkg.generate(p_event_key);

52: dtd := wf_agent_groups_pkg.generate1(l_parameters(1), l_parameters(2));
53: elsif p_event_name = 'oracle.apps.wf.event.event.create' then
54: dtd := wf_events_pkg.generate(p_event_key);
55: elsif p_event_name = 'oracle.apps.wf.event.event.delete' then
56: dtd := wf_events_pkg.generate(p_event_key);
57: elsif p_event_name = 'oracle.apps.wf.event.event.update' then
58: dtd := wf_events_pkg.generate(p_event_key);
59: elsif p_event_name = 'oracle.apps.wf.event.group.create' then
60: l_parameters := wf_event_functions_pkg.parameters(p_event_key,

Line 57: elsif p_event_name = 'oracle.apps.wf.event.event.update' then

53: elsif p_event_name = 'oracle.apps.wf.event.event.create' then
54: dtd := wf_events_pkg.generate(p_event_key);
55: elsif p_event_name = 'oracle.apps.wf.event.event.delete' then
56: dtd := wf_events_pkg.generate(p_event_key);
57: elsif p_event_name = 'oracle.apps.wf.event.event.update' then
58: dtd := wf_events_pkg.generate(p_event_key);
59: elsif p_event_name = 'oracle.apps.wf.event.group.create' then
60: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
61: 2,'/');

Line 58: dtd := wf_events_pkg.generate(p_event_key);

54: dtd := wf_events_pkg.generate(p_event_key);
55: elsif p_event_name = 'oracle.apps.wf.event.event.delete' then
56: dtd := wf_events_pkg.generate(p_event_key);
57: elsif p_event_name = 'oracle.apps.wf.event.event.update' then
58: dtd := wf_events_pkg.generate(p_event_key);
59: elsif p_event_name = 'oracle.apps.wf.event.group.create' then
60: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
61: 2,'/');
62: dtd := wf_event_groups_pkg.generate(l_parameters(1), l_parameters(2));

Line 59: elsif p_event_name = 'oracle.apps.wf.event.group.create' then

55: elsif p_event_name = 'oracle.apps.wf.event.event.delete' then
56: dtd := wf_events_pkg.generate(p_event_key);
57: elsif p_event_name = 'oracle.apps.wf.event.event.update' then
58: dtd := wf_events_pkg.generate(p_event_key);
59: elsif p_event_name = 'oracle.apps.wf.event.group.create' then
60: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
61: 2,'/');
62: dtd := wf_event_groups_pkg.generate(l_parameters(1), l_parameters(2));
63: elsif p_event_name = 'oracle.apps.wf.event.group.delete' then

Line 60: l_parameters := wf_event_functions_pkg.parameters(p_event_key,

56: dtd := wf_events_pkg.generate(p_event_key);
57: elsif p_event_name = 'oracle.apps.wf.event.event.update' then
58: dtd := wf_events_pkg.generate(p_event_key);
59: elsif p_event_name = 'oracle.apps.wf.event.group.create' then
60: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
61: 2,'/');
62: dtd := wf_event_groups_pkg.generate(l_parameters(1), l_parameters(2));
63: elsif p_event_name = 'oracle.apps.wf.event.group.delete' then
64: l_parameters := wf_event_functions_pkg.parameters(p_event_key,

Line 62: dtd := wf_event_groups_pkg.generate(l_parameters(1), l_parameters(2));

58: dtd := wf_events_pkg.generate(p_event_key);
59: elsif p_event_name = 'oracle.apps.wf.event.group.create' then
60: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
61: 2,'/');
62: dtd := wf_event_groups_pkg.generate(l_parameters(1), l_parameters(2));
63: elsif p_event_name = 'oracle.apps.wf.event.group.delete' then
64: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
65: 2,'/');
66: dtd := wf_event_groups_pkg.generate(l_parameters(1), l_parameters(2));

Line 63: elsif p_event_name = 'oracle.apps.wf.event.group.delete' then

59: elsif p_event_name = 'oracle.apps.wf.event.group.create' then
60: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
61: 2,'/');
62: dtd := wf_event_groups_pkg.generate(l_parameters(1), l_parameters(2));
63: elsif p_event_name = 'oracle.apps.wf.event.group.delete' then
64: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
65: 2,'/');
66: dtd := wf_event_groups_pkg.generate(l_parameters(1), l_parameters(2));
67: elsif p_event_name = 'oracle.apps.wf.event.group.update' then

Line 64: l_parameters := wf_event_functions_pkg.parameters(p_event_key,

60: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
61: 2,'/');
62: dtd := wf_event_groups_pkg.generate(l_parameters(1), l_parameters(2));
63: elsif p_event_name = 'oracle.apps.wf.event.group.delete' then
64: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
65: 2,'/');
66: dtd := wf_event_groups_pkg.generate(l_parameters(1), l_parameters(2));
67: elsif p_event_name = 'oracle.apps.wf.event.group.update' then
68: l_parameters := wf_event_functions_pkg.parameters(p_event_key,

Line 66: dtd := wf_event_groups_pkg.generate(l_parameters(1), l_parameters(2));

62: dtd := wf_event_groups_pkg.generate(l_parameters(1), l_parameters(2));
63: elsif p_event_name = 'oracle.apps.wf.event.group.delete' then
64: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
65: 2,'/');
66: dtd := wf_event_groups_pkg.generate(l_parameters(1), l_parameters(2));
67: elsif p_event_name = 'oracle.apps.wf.event.group.update' then
68: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
69: 2,'/');
70: dtd := wf_event_groups_pkg.generate2(l_parameters(1), l_parameters(2));

Line 67: elsif p_event_name = 'oracle.apps.wf.event.group.update' then

63: elsif p_event_name = 'oracle.apps.wf.event.group.delete' then
64: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
65: 2,'/');
66: dtd := wf_event_groups_pkg.generate(l_parameters(1), l_parameters(2));
67: elsif p_event_name = 'oracle.apps.wf.event.group.update' then
68: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
69: 2,'/');
70: dtd := wf_event_groups_pkg.generate2(l_parameters(1), l_parameters(2));
71: elsif p_event_name = 'oracle.apps.wf.event.subscription.create' then

Line 68: l_parameters := wf_event_functions_pkg.parameters(p_event_key,

64: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
65: 2,'/');
66: dtd := wf_event_groups_pkg.generate(l_parameters(1), l_parameters(2));
67: elsif p_event_name = 'oracle.apps.wf.event.group.update' then
68: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
69: 2,'/');
70: dtd := wf_event_groups_pkg.generate2(l_parameters(1), l_parameters(2));
71: elsif p_event_name = 'oracle.apps.wf.event.subscription.create' then
72: dtd := wf_event_subscriptions_pkg.generate(p_event_key);

Line 70: dtd := wf_event_groups_pkg.generate2(l_parameters(1), l_parameters(2));

66: dtd := wf_event_groups_pkg.generate(l_parameters(1), l_parameters(2));
67: elsif p_event_name = 'oracle.apps.wf.event.group.update' then
68: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
69: 2,'/');
70: dtd := wf_event_groups_pkg.generate2(l_parameters(1), l_parameters(2));
71: elsif p_event_name = 'oracle.apps.wf.event.subscription.create' then
72: dtd := wf_event_subscriptions_pkg.generate(p_event_key);
73: elsif p_event_name = 'oracle.apps.wf.event.subscription.delete' then
74: dtd := wf_event_subscriptions_pkg.generate(p_event_key);

Line 71: elsif p_event_name = 'oracle.apps.wf.event.subscription.create' then

67: elsif p_event_name = 'oracle.apps.wf.event.group.update' then
68: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
69: 2,'/');
70: dtd := wf_event_groups_pkg.generate2(l_parameters(1), l_parameters(2));
71: elsif p_event_name = 'oracle.apps.wf.event.subscription.create' then
72: dtd := wf_event_subscriptions_pkg.generate(p_event_key);
73: elsif p_event_name = 'oracle.apps.wf.event.subscription.delete' then
74: dtd := wf_event_subscriptions_pkg.generate(p_event_key);
75: elsif p_event_name = 'oracle.apps.wf.event.subscription.update' then

Line 72: dtd := wf_event_subscriptions_pkg.generate(p_event_key);

68: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
69: 2,'/');
70: dtd := wf_event_groups_pkg.generate2(l_parameters(1), l_parameters(2));
71: elsif p_event_name = 'oracle.apps.wf.event.subscription.create' then
72: dtd := wf_event_subscriptions_pkg.generate(p_event_key);
73: elsif p_event_name = 'oracle.apps.wf.event.subscription.delete' then
74: dtd := wf_event_subscriptions_pkg.generate(p_event_key);
75: elsif p_event_name = 'oracle.apps.wf.event.subscription.update' then
76: dtd := wf_event_subscriptions_pkg.generate(p_event_key);

Line 73: elsif p_event_name = 'oracle.apps.wf.event.subscription.delete' then

69: 2,'/');
70: dtd := wf_event_groups_pkg.generate2(l_parameters(1), l_parameters(2));
71: elsif p_event_name = 'oracle.apps.wf.event.subscription.create' then
72: dtd := wf_event_subscriptions_pkg.generate(p_event_key);
73: elsif p_event_name = 'oracle.apps.wf.event.subscription.delete' then
74: dtd := wf_event_subscriptions_pkg.generate(p_event_key);
75: elsif p_event_name = 'oracle.apps.wf.event.subscription.update' then
76: dtd := wf_event_subscriptions_pkg.generate(p_event_key);
77: /** Start of Bug 2398759 to support Agent Groups **/

Line 74: dtd := wf_event_subscriptions_pkg.generate(p_event_key);

70: dtd := wf_event_groups_pkg.generate2(l_parameters(1), l_parameters(2));
71: elsif p_event_name = 'oracle.apps.wf.event.subscription.create' then
72: dtd := wf_event_subscriptions_pkg.generate(p_event_key);
73: elsif p_event_name = 'oracle.apps.wf.event.subscription.delete' then
74: dtd := wf_event_subscriptions_pkg.generate(p_event_key);
75: elsif p_event_name = 'oracle.apps.wf.event.subscription.update' then
76: dtd := wf_event_subscriptions_pkg.generate(p_event_key);
77: /** Start of Bug 2398759 to support Agent Groups **/
78: elsif p_event_name = 'oracle.apps.wf.agent.group.create' then

Line 75: elsif p_event_name = 'oracle.apps.wf.event.subscription.update' then

71: elsif p_event_name = 'oracle.apps.wf.event.subscription.create' then
72: dtd := wf_event_subscriptions_pkg.generate(p_event_key);
73: elsif p_event_name = 'oracle.apps.wf.event.subscription.delete' then
74: dtd := wf_event_subscriptions_pkg.generate(p_event_key);
75: elsif p_event_name = 'oracle.apps.wf.event.subscription.update' then
76: dtd := wf_event_subscriptions_pkg.generate(p_event_key);
77: /** Start of Bug 2398759 to support Agent Groups **/
78: elsif p_event_name = 'oracle.apps.wf.agent.group.create' then
79: l_parameters := wf_event_functions_pkg.parameters(p_event_key,

Line 76: dtd := wf_event_subscriptions_pkg.generate(p_event_key);

72: dtd := wf_event_subscriptions_pkg.generate(p_event_key);
73: elsif p_event_name = 'oracle.apps.wf.event.subscription.delete' then
74: dtd := wf_event_subscriptions_pkg.generate(p_event_key);
75: elsif p_event_name = 'oracle.apps.wf.event.subscription.update' then
76: dtd := wf_event_subscriptions_pkg.generate(p_event_key);
77: /** Start of Bug 2398759 to support Agent Groups **/
78: elsif p_event_name = 'oracle.apps.wf.agent.group.create' then
79: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
80: 2,'/');

Line 79: l_parameters := wf_event_functions_pkg.parameters(p_event_key,

75: elsif p_event_name = 'oracle.apps.wf.event.subscription.update' then
76: dtd := wf_event_subscriptions_pkg.generate(p_event_key);
77: /** Start of Bug 2398759 to support Agent Groups **/
78: elsif p_event_name = 'oracle.apps.wf.agent.group.create' then
79: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
80: 2,'/');
81: dtd := wf_agent_groups_pkg.generate(l_parameters(1), l_parameters(2));
82: elsif p_event_name = 'oracle.apps.wf.agent.group.delete' then
83: l_parameters := wf_event_functions_pkg.parameters(p_event_key,

Line 83: l_parameters := wf_event_functions_pkg.parameters(p_event_key,

79: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
80: 2,'/');
81: dtd := wf_agent_groups_pkg.generate(l_parameters(1), l_parameters(2));
82: elsif p_event_name = 'oracle.apps.wf.agent.group.delete' then
83: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
84: 2,'/');
85: dtd := wf_agent_groups_pkg.generate(l_parameters(1), l_parameters(2));
86: elsif p_event_name = 'oracle.apps.wf.agent.group.update' then
87: l_parameters := wf_event_functions_pkg.parameters(p_event_key,

Line 87: l_parameters := wf_event_functions_pkg.parameters(p_event_key,

83: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
84: 2,'/');
85: dtd := wf_agent_groups_pkg.generate(l_parameters(1), l_parameters(2));
86: elsif p_event_name = 'oracle.apps.wf.agent.group.update' then
87: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
88: 2,'/');
89: dtd := wf_agent_groups_pkg.generate(l_parameters(1), l_parameters(2));
90: /** End of Bug 2398759 **/
91: elsif p_event_name = 'oracle.apps.wf.event.all.sync' then

Line 91: elsif p_event_name = 'oracle.apps.wf.event.all.sync' then

87: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
88: 2,'/');
89: dtd := wf_agent_groups_pkg.generate(l_parameters(1), l_parameters(2));
90: /** End of Bug 2398759 **/
91: elsif p_event_name = 'oracle.apps.wf.event.all.sync' then
92: wf_event_synchronize_pkg.CreateSyncClob(p_eventdata=>msg);
93: --dbms_lob.append(msg, wf_event_synchronize_pkg.CreateSyncClob);
94: else
95: null;

Line 92: wf_event_synchronize_pkg.CreateSyncClob(p_eventdata=>msg);

88: 2,'/');
89: dtd := wf_agent_groups_pkg.generate(l_parameters(1), l_parameters(2));
90: /** End of Bug 2398759 **/
91: elsif p_event_name = 'oracle.apps.wf.event.all.sync' then
92: wf_event_synchronize_pkg.CreateSyncClob(p_eventdata=>msg);
93: --dbms_lob.append(msg, wf_event_synchronize_pkg.CreateSyncClob);
94: else
95: null;
96: end if;

Line 93: --dbms_lob.append(msg, wf_event_synchronize_pkg.CreateSyncClob);

89: dtd := wf_agent_groups_pkg.generate(l_parameters(1), l_parameters(2));
90: /** End of Bug 2398759 **/
91: elsif p_event_name = 'oracle.apps.wf.event.all.sync' then
92: wf_event_synchronize_pkg.CreateSyncClob(p_eventdata=>msg);
93: --dbms_lob.append(msg, wf_event_synchronize_pkg.CreateSyncClob);
94: else
95: null;
96: end if;
97:

Line 106: wf_core.context('WF_EVENT_FUNCTIONS_PKG', 'GENERATE', p_event_name,

102: return (msg);
103:
104: exception
105: when others then
106: wf_core.context('WF_EVENT_FUNCTIONS_PKG', 'GENERATE', p_event_name,
107: p_event_key,
108: substr(dtd,1,100));
109: raise;
110: end;

Line 127: P_EVENT in out nocopy wf_event_t

123: end;
124: ------------------------------------------------------------------------------
125: function RECEIVE (
126: P_SUBSCRIPTION_GUID in raw,
127: P_EVENT in out nocopy wf_event_t
128: ) return varchar2 is
129: /*
130: ** RECEIVE - Wrapper around event system packages receive procedure
131: ** to make compliant with generic receive api

Line 148: if (l_eventname <> 'oracle.apps.wf.event.all.sync'

144: begin
145:
146: l_parameters := t_parameters(1,2);
147:
148: if (l_eventname <> 'oracle.apps.wf.event.all.sync'
149: and l_eventname <> 'oracle.apps.wf.event.system.signup') then
150:
151: l_length := dbms_lob.getlength(l_eventdata);
152:

Line 149: and l_eventname <> 'oracle.apps.wf.event.system.signup') then

145:
146: l_parameters := t_parameters(1,2);
147:
148: if (l_eventname <> 'oracle.apps.wf.event.all.sync'
149: and l_eventname <> 'oracle.apps.wf.event.system.signup') then
150:
151: l_length := dbms_lob.getlength(l_eventdata);
152:
153: dbms_lob.read(l_eventdata, l_length,1,x_message);

Line 155: if l_eventname = 'oracle.apps.wf.event.system.create' then

151: l_length := dbms_lob.getlength(l_eventdata);
152:
153: dbms_lob.read(l_eventdata, l_length,1,x_message);
154:
155: if l_eventname = 'oracle.apps.wf.event.system.create' then
156: wf_systems_pkg.receive(x_message);
157: elsif l_eventname = 'oracle.apps.wf.event.system.delete' then
158: wf_systems_pkg.delete_row(l_eventkey);
159: elsif l_eventname = 'oracle.apps.wf.event.system.update' then

Line 157: elsif l_eventname = 'oracle.apps.wf.event.system.delete' then

153: dbms_lob.read(l_eventdata, l_length,1,x_message);
154:
155: if l_eventname = 'oracle.apps.wf.event.system.create' then
156: wf_systems_pkg.receive(x_message);
157: elsif l_eventname = 'oracle.apps.wf.event.system.delete' then
158: wf_systems_pkg.delete_row(l_eventkey);
159: elsif l_eventname = 'oracle.apps.wf.event.system.update' then
160: wf_systems_pkg.receive(x_message);
161: elsif l_eventname = 'oracle.apps.wf.event.agent.create' then

Line 159: elsif l_eventname = 'oracle.apps.wf.event.system.update' then

155: if l_eventname = 'oracle.apps.wf.event.system.create' then
156: wf_systems_pkg.receive(x_message);
157: elsif l_eventname = 'oracle.apps.wf.event.system.delete' then
158: wf_systems_pkg.delete_row(l_eventkey);
159: elsif l_eventname = 'oracle.apps.wf.event.system.update' then
160: wf_systems_pkg.receive(x_message);
161: elsif l_eventname = 'oracle.apps.wf.event.agent.create' then
162: wf_agents_pkg.receive(x_message);
163: elsif l_eventname = 'oracle.apps.wf.event.agent.delete' then

Line 161: elsif l_eventname = 'oracle.apps.wf.event.agent.create' then

157: elsif l_eventname = 'oracle.apps.wf.event.system.delete' then
158: wf_systems_pkg.delete_row(l_eventkey);
159: elsif l_eventname = 'oracle.apps.wf.event.system.update' then
160: wf_systems_pkg.receive(x_message);
161: elsif l_eventname = 'oracle.apps.wf.event.agent.create' then
162: wf_agents_pkg.receive(x_message);
163: elsif l_eventname = 'oracle.apps.wf.event.agent.delete' then
164: wf_agents_pkg.delete_row(l_eventkey);
165: elsif l_eventname = 'oracle.apps.wf.event.agent.update' then

Line 163: elsif l_eventname = 'oracle.apps.wf.event.agent.delete' then

159: elsif l_eventname = 'oracle.apps.wf.event.system.update' then
160: wf_systems_pkg.receive(x_message);
161: elsif l_eventname = 'oracle.apps.wf.event.agent.create' then
162: wf_agents_pkg.receive(x_message);
163: elsif l_eventname = 'oracle.apps.wf.event.agent.delete' then
164: wf_agents_pkg.delete_row(l_eventkey);
165: elsif l_eventname = 'oracle.apps.wf.event.agent.update' then
166: wf_agents_pkg.receive(x_message);
167: elsif l_eventname = 'oracle.apps.wf.agent.group.create' then

Line 165: elsif l_eventname = 'oracle.apps.wf.event.agent.update' then

161: elsif l_eventname = 'oracle.apps.wf.event.agent.create' then
162: wf_agents_pkg.receive(x_message);
163: elsif l_eventname = 'oracle.apps.wf.event.agent.delete' then
164: wf_agents_pkg.delete_row(l_eventkey);
165: elsif l_eventname = 'oracle.apps.wf.event.agent.update' then
166: wf_agents_pkg.receive(x_message);
167: elsif l_eventname = 'oracle.apps.wf.agent.group.create' then
168: wf_agent_groups_pkg.receive(x_message);
169: elsif l_eventname = 'oracle.apps.wf.agent.group.delete' then

Line 170: l_parameters := wf_event_functions_pkg.parameters(l_eventkey,

166: wf_agents_pkg.receive(x_message);
167: elsif l_eventname = 'oracle.apps.wf.agent.group.create' then
168: wf_agent_groups_pkg.receive(x_message);
169: elsif l_eventname = 'oracle.apps.wf.agent.group.delete' then
170: l_parameters := wf_event_functions_pkg.parameters(l_eventkey,
171: 2,'/');
172: wf_agent_groups_pkg.delete_row(l_parameters(1), l_parameters(2));
173: elsif l_eventname = 'oracle.apps.wf.agent.group.update' then
174: wf_agent_groups_pkg.receive(x_message);

Line 175: elsif l_eventname = 'oracle.apps.wf.event.event.create' then

171: 2,'/');
172: wf_agent_groups_pkg.delete_row(l_parameters(1), l_parameters(2));
173: elsif l_eventname = 'oracle.apps.wf.agent.group.update' then
174: wf_agent_groups_pkg.receive(x_message);
175: elsif l_eventname = 'oracle.apps.wf.event.event.create' then
176: wf_events_pkg.receive(x_message);
177: elsif l_eventname = 'oracle.apps.wf.event.event.delete' then
178: wf_events_pkg.delete_row(l_eventkey);
179: elsif l_eventname = 'oracle.apps.wf.event.event.update' then

Line 176: wf_events_pkg.receive(x_message);

172: wf_agent_groups_pkg.delete_row(l_parameters(1), l_parameters(2));
173: elsif l_eventname = 'oracle.apps.wf.agent.group.update' then
174: wf_agent_groups_pkg.receive(x_message);
175: elsif l_eventname = 'oracle.apps.wf.event.event.create' then
176: wf_events_pkg.receive(x_message);
177: elsif l_eventname = 'oracle.apps.wf.event.event.delete' then
178: wf_events_pkg.delete_row(l_eventkey);
179: elsif l_eventname = 'oracle.apps.wf.event.event.update' then
180: wf_events_pkg.receive(x_message);

Line 177: elsif l_eventname = 'oracle.apps.wf.event.event.delete' then

173: elsif l_eventname = 'oracle.apps.wf.agent.group.update' then
174: wf_agent_groups_pkg.receive(x_message);
175: elsif l_eventname = 'oracle.apps.wf.event.event.create' then
176: wf_events_pkg.receive(x_message);
177: elsif l_eventname = 'oracle.apps.wf.event.event.delete' then
178: wf_events_pkg.delete_row(l_eventkey);
179: elsif l_eventname = 'oracle.apps.wf.event.event.update' then
180: wf_events_pkg.receive(x_message);
181: elsif l_eventname = 'oracle.apps.wf.event.group.create' then

Line 178: wf_events_pkg.delete_row(l_eventkey);

174: wf_agent_groups_pkg.receive(x_message);
175: elsif l_eventname = 'oracle.apps.wf.event.event.create' then
176: wf_events_pkg.receive(x_message);
177: elsif l_eventname = 'oracle.apps.wf.event.event.delete' then
178: wf_events_pkg.delete_row(l_eventkey);
179: elsif l_eventname = 'oracle.apps.wf.event.event.update' then
180: wf_events_pkg.receive(x_message);
181: elsif l_eventname = 'oracle.apps.wf.event.group.create' then
182: wf_event_groups_pkg.receive(x_message);

Line 179: elsif l_eventname = 'oracle.apps.wf.event.event.update' then

175: elsif l_eventname = 'oracle.apps.wf.event.event.create' then
176: wf_events_pkg.receive(x_message);
177: elsif l_eventname = 'oracle.apps.wf.event.event.delete' then
178: wf_events_pkg.delete_row(l_eventkey);
179: elsif l_eventname = 'oracle.apps.wf.event.event.update' then
180: wf_events_pkg.receive(x_message);
181: elsif l_eventname = 'oracle.apps.wf.event.group.create' then
182: wf_event_groups_pkg.receive(x_message);
183: elsif l_eventname = 'oracle.apps.wf.event.group.delete' then

Line 180: wf_events_pkg.receive(x_message);

176: wf_events_pkg.receive(x_message);
177: elsif l_eventname = 'oracle.apps.wf.event.event.delete' then
178: wf_events_pkg.delete_row(l_eventkey);
179: elsif l_eventname = 'oracle.apps.wf.event.event.update' then
180: wf_events_pkg.receive(x_message);
181: elsif l_eventname = 'oracle.apps.wf.event.group.create' then
182: wf_event_groups_pkg.receive(x_message);
183: elsif l_eventname = 'oracle.apps.wf.event.group.delete' then
184: l_parameters := wf_event_functions_pkg.parameters(l_eventkey,

Line 181: elsif l_eventname = 'oracle.apps.wf.event.group.create' then

177: elsif l_eventname = 'oracle.apps.wf.event.event.delete' then
178: wf_events_pkg.delete_row(l_eventkey);
179: elsif l_eventname = 'oracle.apps.wf.event.event.update' then
180: wf_events_pkg.receive(x_message);
181: elsif l_eventname = 'oracle.apps.wf.event.group.create' then
182: wf_event_groups_pkg.receive(x_message);
183: elsif l_eventname = 'oracle.apps.wf.event.group.delete' then
184: l_parameters := wf_event_functions_pkg.parameters(l_eventkey,
185: 2,'/');

Line 182: wf_event_groups_pkg.receive(x_message);

178: wf_events_pkg.delete_row(l_eventkey);
179: elsif l_eventname = 'oracle.apps.wf.event.event.update' then
180: wf_events_pkg.receive(x_message);
181: elsif l_eventname = 'oracle.apps.wf.event.group.create' then
182: wf_event_groups_pkg.receive(x_message);
183: elsif l_eventname = 'oracle.apps.wf.event.group.delete' then
184: l_parameters := wf_event_functions_pkg.parameters(l_eventkey,
185: 2,'/');
186: wf_event_groups_pkg.delete_row(l_parameters(1), l_parameters(2));

Line 183: elsif l_eventname = 'oracle.apps.wf.event.group.delete' then

179: elsif l_eventname = 'oracle.apps.wf.event.event.update' then
180: wf_events_pkg.receive(x_message);
181: elsif l_eventname = 'oracle.apps.wf.event.group.create' then
182: wf_event_groups_pkg.receive(x_message);
183: elsif l_eventname = 'oracle.apps.wf.event.group.delete' then
184: l_parameters := wf_event_functions_pkg.parameters(l_eventkey,
185: 2,'/');
186: wf_event_groups_pkg.delete_row(l_parameters(1), l_parameters(2));
187: elsif l_eventname = 'oracle.apps.wf.event.group.update' then

Line 184: l_parameters := wf_event_functions_pkg.parameters(l_eventkey,

180: wf_events_pkg.receive(x_message);
181: elsif l_eventname = 'oracle.apps.wf.event.group.create' then
182: wf_event_groups_pkg.receive(x_message);
183: elsif l_eventname = 'oracle.apps.wf.event.group.delete' then
184: l_parameters := wf_event_functions_pkg.parameters(l_eventkey,
185: 2,'/');
186: wf_event_groups_pkg.delete_row(l_parameters(1), l_parameters(2));
187: elsif l_eventname = 'oracle.apps.wf.event.group.update' then
188: wf_event_groups_pkg.receive(x_message);

Line 186: wf_event_groups_pkg.delete_row(l_parameters(1), l_parameters(2));

182: wf_event_groups_pkg.receive(x_message);
183: elsif l_eventname = 'oracle.apps.wf.event.group.delete' then
184: l_parameters := wf_event_functions_pkg.parameters(l_eventkey,
185: 2,'/');
186: wf_event_groups_pkg.delete_row(l_parameters(1), l_parameters(2));
187: elsif l_eventname = 'oracle.apps.wf.event.group.update' then
188: wf_event_groups_pkg.receive(x_message);
189: elsif l_eventname = 'oracle.apps.wf.event.subscription.create' then
190: wf_event_subscriptions_pkg.receive(x_message);

Line 187: elsif l_eventname = 'oracle.apps.wf.event.group.update' then

183: elsif l_eventname = 'oracle.apps.wf.event.group.delete' then
184: l_parameters := wf_event_functions_pkg.parameters(l_eventkey,
185: 2,'/');
186: wf_event_groups_pkg.delete_row(l_parameters(1), l_parameters(2));
187: elsif l_eventname = 'oracle.apps.wf.event.group.update' then
188: wf_event_groups_pkg.receive(x_message);
189: elsif l_eventname = 'oracle.apps.wf.event.subscription.create' then
190: wf_event_subscriptions_pkg.receive(x_message);
191: elsif l_eventname = 'oracle.apps.wf.event.subscription.delete' then

Line 188: wf_event_groups_pkg.receive(x_message);

184: l_parameters := wf_event_functions_pkg.parameters(l_eventkey,
185: 2,'/');
186: wf_event_groups_pkg.delete_row(l_parameters(1), l_parameters(2));
187: elsif l_eventname = 'oracle.apps.wf.event.group.update' then
188: wf_event_groups_pkg.receive(x_message);
189: elsif l_eventname = 'oracle.apps.wf.event.subscription.create' then
190: wf_event_subscriptions_pkg.receive(x_message);
191: elsif l_eventname = 'oracle.apps.wf.event.subscription.delete' then
192: wf_event_subscriptions_pkg.delete_row(l_eventkey);

Line 189: elsif l_eventname = 'oracle.apps.wf.event.subscription.create' then

185: 2,'/');
186: wf_event_groups_pkg.delete_row(l_parameters(1), l_parameters(2));
187: elsif l_eventname = 'oracle.apps.wf.event.group.update' then
188: wf_event_groups_pkg.receive(x_message);
189: elsif l_eventname = 'oracle.apps.wf.event.subscription.create' then
190: wf_event_subscriptions_pkg.receive(x_message);
191: elsif l_eventname = 'oracle.apps.wf.event.subscription.delete' then
192: wf_event_subscriptions_pkg.delete_row(l_eventkey);
193: elsif l_eventname = 'oracle.apps.wf.event.subscription.update' then

Line 190: wf_event_subscriptions_pkg.receive(x_message);

186: wf_event_groups_pkg.delete_row(l_parameters(1), l_parameters(2));
187: elsif l_eventname = 'oracle.apps.wf.event.group.update' then
188: wf_event_groups_pkg.receive(x_message);
189: elsif l_eventname = 'oracle.apps.wf.event.subscription.create' then
190: wf_event_subscriptions_pkg.receive(x_message);
191: elsif l_eventname = 'oracle.apps.wf.event.subscription.delete' then
192: wf_event_subscriptions_pkg.delete_row(l_eventkey);
193: elsif l_eventname = 'oracle.apps.wf.event.subscription.update' then
194: wf_event_subscriptions_pkg.receive(x_message);

Line 191: elsif l_eventname = 'oracle.apps.wf.event.subscription.delete' then

187: elsif l_eventname = 'oracle.apps.wf.event.group.update' then
188: wf_event_groups_pkg.receive(x_message);
189: elsif l_eventname = 'oracle.apps.wf.event.subscription.create' then
190: wf_event_subscriptions_pkg.receive(x_message);
191: elsif l_eventname = 'oracle.apps.wf.event.subscription.delete' then
192: wf_event_subscriptions_pkg.delete_row(l_eventkey);
193: elsif l_eventname = 'oracle.apps.wf.event.subscription.update' then
194: wf_event_subscriptions_pkg.receive(x_message);
195: else

Line 192: wf_event_subscriptions_pkg.delete_row(l_eventkey);

188: wf_event_groups_pkg.receive(x_message);
189: elsif l_eventname = 'oracle.apps.wf.event.subscription.create' then
190: wf_event_subscriptions_pkg.receive(x_message);
191: elsif l_eventname = 'oracle.apps.wf.event.subscription.delete' then
192: wf_event_subscriptions_pkg.delete_row(l_eventkey);
193: elsif l_eventname = 'oracle.apps.wf.event.subscription.update' then
194: wf_event_subscriptions_pkg.receive(x_message);
195: else
196: return('ERROR');

Line 193: elsif l_eventname = 'oracle.apps.wf.event.subscription.update' then

189: elsif l_eventname = 'oracle.apps.wf.event.subscription.create' then
190: wf_event_subscriptions_pkg.receive(x_message);
191: elsif l_eventname = 'oracle.apps.wf.event.subscription.delete' then
192: wf_event_subscriptions_pkg.delete_row(l_eventkey);
193: elsif l_eventname = 'oracle.apps.wf.event.subscription.update' then
194: wf_event_subscriptions_pkg.receive(x_message);
195: else
196: return('ERROR');
197: end if;

Line 194: wf_event_subscriptions_pkg.receive(x_message);

190: wf_event_subscriptions_pkg.receive(x_message);
191: elsif l_eventname = 'oracle.apps.wf.event.subscription.delete' then
192: wf_event_subscriptions_pkg.delete_row(l_eventkey);
193: elsif l_eventname = 'oracle.apps.wf.event.subscription.update' then
194: wf_event_subscriptions_pkg.receive(x_message);
195: else
196: return('ERROR');
197: end if;
198: elsif l_eventname = 'oracle.apps.wf.event.all.sync' then

Line 198: elsif l_eventname = 'oracle.apps.wf.event.all.sync' then

194: wf_event_subscriptions_pkg.receive(x_message);
195: else
196: return('ERROR');
197: end if;
198: elsif l_eventname = 'oracle.apps.wf.event.all.sync' then
199: wf_event_synchronize_pkg.uploadsyncclob(l_eventdata);
200: elsif l_eventname = 'oracle.apps.wf.event.system.signup' then
201: wf_event_synchronize_pkg.uploadsyncclob(l_eventdata);
202: end if;

Line 199: wf_event_synchronize_pkg.uploadsyncclob(l_eventdata);

195: else
196: return('ERROR');
197: end if;
198: elsif l_eventname = 'oracle.apps.wf.event.all.sync' then
199: wf_event_synchronize_pkg.uploadsyncclob(l_eventdata);
200: elsif l_eventname = 'oracle.apps.wf.event.system.signup' then
201: wf_event_synchronize_pkg.uploadsyncclob(l_eventdata);
202: end if;
203:

Line 200: elsif l_eventname = 'oracle.apps.wf.event.system.signup' then

196: return('ERROR');
197: end if;
198: elsif l_eventname = 'oracle.apps.wf.event.all.sync' then
199: wf_event_synchronize_pkg.uploadsyncclob(l_eventdata);
200: elsif l_eventname = 'oracle.apps.wf.event.system.signup' then
201: wf_event_synchronize_pkg.uploadsyncclob(l_eventdata);
202: end if;
203:
204: l_result := wf_rule.default_rule(p_subscription_guid, p_event);

Line 201: wf_event_synchronize_pkg.uploadsyncclob(l_eventdata);

197: end if;
198: elsif l_eventname = 'oracle.apps.wf.event.all.sync' then
199: wf_event_synchronize_pkg.uploadsyncclob(l_eventdata);
200: elsif l_eventname = 'oracle.apps.wf.event.system.signup' then
201: wf_event_synchronize_pkg.uploadsyncclob(l_eventdata);
202: end if;
203:
204: l_result := wf_rule.default_rule(p_subscription_guid, p_event);
205:

Line 210: wf_core.context('WF_EVENT_FUNCTIONS_PKG', 'RECEIVE', p_event.event_name,

206: return(l_result);
207:
208: exception
209: when others then
210: wf_core.context('WF_EVENT_FUNCTIONS_PKG', 'RECEIVE', p_event.event_name,
211: p_subscription_guid);
212: wf_event.setErrorInfo(p_event,'ERROR');
213: return('ERROR');
214: end;

Line 212: wf_event.setErrorInfo(p_event,'ERROR');

208: exception
209: when others then
210: wf_core.context('WF_EVENT_FUNCTIONS_PKG', 'RECEIVE', p_event.event_name,
211: p_subscription_guid);
212: wf_event.setErrorInfo(p_event,'ERROR');
213: return('ERROR');
214: end;
215: ------------------------------------------------------------------------------
216: procedure SEND (

Line 226: ** SEND - Packages up parameters in wf_event_t and then calls

222: P_PRIORITY in number,
223: P_SENDDATE in date
224: ) is
225: /*
226: ** SEND - Packages up parameters in wf_event_t and then calls
227: ** wf_event.send()
228: */
229:
230: l_agent_t wf_agent_t;

Line 227: ** wf_event.send()

223: P_SENDDATE in date
224: ) is
225: /*
226: ** SEND - Packages up parameters in wf_event_t and then calls
227: ** wf_event.send()
228: */
229:
230: l_agent_t wf_agent_t;
231: l_event_t wf_event_t;

Line 231: l_event_t wf_event_t;

227: ** wf_event.send()
228: */
229:
230: l_agent_t wf_agent_t;
231: l_event_t wf_event_t;
232:
233: begin
234:
235: wf_event_t.initialize(l_event_t);

Line 235: wf_event_t.initialize(l_event_t);

231: l_event_t wf_event_t;
232:
233: begin
234:
235: wf_event_t.initialize(l_event_t);
236:
237: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
238: WF_LOG_PKG.STRING(wf_log_pkg.level_procedure,
239: 'wf.plsql.WF_EVENT_FUNCTIONS_PKG.SEND.Begin',

Line 239: 'wf.plsql.WF_EVENT_FUNCTIONS_PKG.SEND.Begin',

235: wf_event_t.initialize(l_event_t);
236:
237: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
238: WF_LOG_PKG.STRING(wf_log_pkg.level_procedure,
239: 'wf.plsql.WF_EVENT_FUNCTIONS_PKG.SEND.Begin',
240: 'Parameters:'||p_EventName||'*'|| p_EventKey||'*'||p_ToAgent||'*'||p_ToSystem);
241: end if;
242:
243: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

Line 245: 'wf.plsql.WF_EVENT_FUNCTIONS_PKG.SEND.Agent',

241: end if;
242:
243: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
244: WF_LOG_PKG.STRING(wf_log_pkg.level_statement,
245: 'wf.plsql.WF_EVENT_FUNCTIONS_PKG.SEND.Agent',
246: 'Populating Agent...');
247: end if;
248:
249: -- Populate the Agent

Line 254: 'wf.plsql.WF_EVENT_FUNCTIONS_PKG.SEND.Address',

250: l_agent_t := wf_agent_t (p_ToAgent, p_ToSystem);
251:
252: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
253: WF_LOG_PKG.STRING(wf_log_pkg.level_statement,
254: 'wf.plsql.WF_EVENT_FUNCTIONS_PKG.SEND.Address',
255: 'Populating Address...');
256: end if;
257:
258: -- Populate the Address

Line 266: 'wf.plsql.WF_EVENT_FUNCTIONS_PKG.SEND.Content',

262: pSendDate => sysdate);
263:
264: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
265: WF_LOG_PKG.STRING(wf_log_pkg.level_statement,
266: 'wf.plsql.WF_EVENT_FUNCTIONS_PKG.SEND.Content',
267: 'Populating Content');
268: end if;
269:
270: -- Populate the Content

Line 276: 'wf.plsql.WF_EVENT_FUNCTIONS_PKG.SEND.Hardwire',

272: pKey => p_EventKey,
273: pData => p_EventData);
274: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
275: WF_LOG_PKG.STRING(wf_log_pkg.level_statement,
276: 'wf.plsql.WF_EVENT_FUNCTIONS_PKG.SEND.Hardwire',
277: 'Hardwired Send');
278: end if;
279:
280: -- Release the hounds, hardwired send

Line 281: wf_event.send(l_event_t);

277: 'Hardwired Send');
278: end if;
279:
280: -- Release the hounds, hardwired send
281: wf_event.send(l_event_t);
282:
283: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
284: WF_LOG_PKG.STRING(wf_log_pkg.level_procedure,
285: 'wf.plsql.WF_EVENT_FUNCTIONS_PKG.SEND.End',

Line 285: 'wf.plsql.WF_EVENT_FUNCTIONS_PKG.SEND.End',

281: wf_event.send(l_event_t);
282:
283: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
284: WF_LOG_PKG.STRING(wf_log_pkg.level_procedure,
285: 'wf.plsql.WF_EVENT_FUNCTIONS_PKG.SEND.End',
286: 'Completed Send');
287: end if;
288:
289: exception

Line 291: wf_core.context('WF_EVENT_FUNCTIONS_PKG', 'SEND', p_EventName,

287: end if;
288:
289: exception
290: when others then
291: wf_core.context('WF_EVENT_FUNCTIONS_PKG', 'SEND', p_EventName,
292: p_EventKey,
293: 'ERROR'); raise;
294: end;
295: ------------------------------------------------------------------------------

Line 337: 'wf.plsql.WF_EVENT_FUNCTIONS_PKG.PARAMETERS.get_pos',

333: l_parameters(l_counter) := substr(p_string, l_startposition, l_amounttoread);
334:
335: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
336: wf_log_pkg.string(wf_log_pkg.level_statement,
337: 'wf.plsql.WF_EVENT_FUNCTIONS_PKG.PARAMETERS.get_pos',
338: 'String:'||p_string||' Start:'||l_startposition||
339: ' End:'||l_endposition);
340: end if;
341:

Line 344: 'wf.plsql.WF_EVENT_FUNCTIONS_PKG.PARAMETERS.get_param',

340: end if;
341:
342: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
343: wf_log_pkg.string(wf_log_pkg.level_statement,
344: 'wf.plsql.WF_EVENT_FUNCTIONS_PKG.PARAMETERS.get_param',
345: 'Parameter('||l_counter||') is '||l_parameters(l_counter));
346: end if;
347:
348: END LOOP;

Line 354: wf_core.context('WF_EVENT_FUNCTIONS_PKG', 'Parameters', substr(p_string,1,100),

350: return(l_parameters);
351:
352: exception
353: when others then
354: wf_core.context('WF_EVENT_FUNCTIONS_PKG', 'Parameters', substr(p_string,1,100),
355: p_numvalues,p_separator,
356: 'ERROR'); raise;
357: end;
358: ------------------------------------------------------------------------------

Line 361: P_EVENT in out nocopy wf_event_t

357: end;
358: ------------------------------------------------------------------------------
359: function ADDCORRELATION (
360: P_SUBSCRIPTION_GUID in raw,
361: P_EVENT in out nocopy wf_event_t
362: ) return varchar2 is
363: /*
364: ** ADDCORRELATION - This function adds a correlation id to the event object
365: */

Line 375: FROM wf_event_subscriptions

371: l_sqlstmt varchar2(240);
372:
373: CURSOR c_parameters IS
374: SELECT parameters
375: FROM wf_event_subscriptions
376: WHERE guid = p_subscription_guid;
377:
378: begin
379:

Line 387: l_function := wf_event_functions_pkg.SubscriptionParameters(l_parameters,

383: --
384: -- This is where we will do some logic to determine if there is a parameter
385: -- set which tells us which sequence to nextval to get the itemkey
386: --
387: l_function := wf_event_functions_pkg.SubscriptionParameters(l_parameters,
388: 'ITEMKEY');
389:
390: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
391: wf_log_pkg.string(wf_log_pkg.level_procedure,

Line 392: 'wf.plsql.WF_EVENT_FUNCTIONS_PKG.ADDCORRELATION.Begin',

388: 'ITEMKEY');
389:
390: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
391: wf_log_pkg.string(wf_log_pkg.level_procedure,
392: 'wf.plsql.WF_EVENT_FUNCTIONS_PKG.ADDCORRELATION.Begin',
393: 'Item Key function is '||l_function);
394: end if;
395:
396: IF l_function IS NOT NULL THEN

Line 411: 'wf.plsql.WF_EVENT_FUNCTIONS_PKG.ADDCORRELATION.Set',

407: END IF;
408:
409: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
410: wf_log_pkg.string(wf_log_pkg.level_statement,
411: 'wf.plsql.WF_EVENT_FUNCTIONS_PKG.ADDCORRELATION.Set',
412: 'Item Key is '||l_itemkey);
413: end if;
414:
415: p_event.SetCorrelationId(l_itemkey);

Line 421: wf_core.context('WF_EVENT_FUNCTIONS_PKG', 'ADDCORRELATION', p_event.event_name,

417: return ('SUCCESS');
418:
419: exception
420: when others then
421: wf_core.context('WF_EVENT_FUNCTIONS_PKG', 'ADDCORRELATION', p_event.event_name,
422: p_event.event_key,
423: 'ERROR'); raise;
424: return('ERROR');
425: end;

Line 448: FROM wf_event_subscriptions

444: --cursor to fetch subscription parameters
445:
446: CURSOR c_parameters (c_guid raw) IS
447: SELECT parameters
448: FROM wf_event_subscriptions
449: WHERE guid = c_guid;
450:
451: begin
452:

Line 482: wf_core.context('WF_EVENT_FUNCTIONS_PKG', 'SUBSCRIPTIONPARAMETERS',

478: return (l_value);
479:
480: exception
481: when others then
482: wf_core.context('WF_EVENT_FUNCTIONS_PKG', 'SUBSCRIPTIONPARAMETERS',
483: 'ERROR'); raise;
484:
485: end;
486:

Line 489: p_event in out NOCOPY wf_event_t,

485: end;
486:
487: ------------------------------------------------------------------------------
488: function SubParamInEvent(p_guid in raw,
489: p_event in out NOCOPY wf_event_t,
490: p_match in varchar2) return boolean
491:
492: is
493:

Line 523: from wf_event_subscriptions

519: l_NumSubParams := 0;
520: l_NumEvtParams := 0;
521:
522: select parameters into l_subParams
523: from wf_event_subscriptions
524: where guid = p_guid;
525:
526: -- Get a count on the subscription parameters.
527: while (eqPOS <> 0) loop

Line 578: WF_EVENT.sub_param_index.DELETE;

574:
575: --Bug 3845922
576: -- Clear cache that we uses to remove duplicate and other optimization
577: -- within the loops below.
578: WF_EVENT.sub_param_index.DELETE;
579: WF_EVENT.evt_param_index.DELETE;
580:
581: l_parameters := Parameters(l_SubParams, l_NumSubParams, ' ');
582:

Line 579: WF_EVENT.evt_param_index.DELETE;

575: --Bug 3845922
576: -- Clear cache that we uses to remove duplicate and other optimization
577: -- within the loops below.
578: WF_EVENT.sub_param_index.DELETE;
579: WF_EVENT.evt_param_index.DELETE;
580:
581: l_parameters := Parameters(l_SubParams, l_NumSubParams, ' ');
582:
583:

Line 598: if (NOT (WF_EVENT.sub_param_index.EXISTS(l_subParamsIND)) or

594: -- parameter. If so, skip to the next. If not, cache it and check
595: -- the event parameters for a match. This will eliminate processing
596: -- duplicate subscription parameters.
597:
598: if (NOT (WF_EVENT.sub_param_index.EXISTS(l_subParamsIND)) or
599: WF_EVENT.sub_param_index(l_subParamsIND) <> l_subParam) then
600:
601: -- Cache the subscription parameter since it is not in the cache.
602: wf_event.sub_param_index(l_subParamsIND) := l_subParam;

Line 599: WF_EVENT.sub_param_index(l_subParamsIND) <> l_subParam) then

595: -- the event parameters for a match. This will eliminate processing
596: -- duplicate subscription parameters.
597:
598: if (NOT (WF_EVENT.sub_param_index.EXISTS(l_subParamsIND)) or
599: WF_EVENT.sub_param_index(l_subParamsIND) <> l_subParam) then
600:
601: -- Cache the subscription parameter since it is not in the cache.
602: wf_event.sub_param_index(l_subParamsIND) := l_subParam;
603:

Line 602: wf_event.sub_param_index(l_subParamsIND) := l_subParam;

598: if (NOT (WF_EVENT.sub_param_index.EXISTS(l_subParamsIND)) or
599: WF_EVENT.sub_param_index(l_subParamsIND) <> l_subParam) then
600:
601: -- Cache the subscription parameter since it is not in the cache.
602: wf_event.sub_param_index(l_subParamsIND) := l_subParam;
603:
604: -- reset count of event parameters and found_match for next sub
605: l_NumEvtParams := p_event.parameter_list.COUNT;
606: found_match := FALSE;

Line 625: if (NOT (WF_EVENT.evt_param_index.EXISTS(l_evtParamsIND)) or

621: -- Check to see if the event parameter has already been cached.
622: -- If not, check for a match. This will eliminate already
623: -- matched event parameters.
624:
625: if (NOT (WF_EVENT.evt_param_index.EXISTS(l_evtParamsIND)) or
626: WF_EVENT.evt_param_index(l_evtParamsIND) <> l_evtParam) then
627:
628: if (l_evtParamsIND = l_subParamsIND and
629: l_subParam = l_evtParam) then -- Found match

Line 626: WF_EVENT.evt_param_index(l_evtParamsIND) <> l_evtParam) then

622: -- If not, check for a match. This will eliminate already
623: -- matched event parameters.
624:
625: if (NOT (WF_EVENT.evt_param_index.EXISTS(l_evtParamsIND)) or
626: WF_EVENT.evt_param_index(l_evtParamsIND) <> l_evtParam) then
627:
628: if (l_evtParamsIND = l_subParamsIND and
629: l_subParam = l_evtParam) then -- Found match
630:

Line 637: WF_EVENT.evt_param_index(l_evtParamsIND) := l_evtParam;

633: else
634: found_match := TRUE;
635:
636: -- Cache event parameter
637: WF_EVENT.evt_param_index(l_evtParamsIND) := l_evtParam;
638:
639: -- ALL must match so continue to next subParam
640: exit;
641: end if;

Line 669: wf_core.context('WF_EVENT_FUNCTIONS_PKG', 'SubParamInEvent',

665: end if;
666:
667: exception
668: when others then
669: wf_core.context('WF_EVENT_FUNCTIONS_PKG', 'SubParamInEvent',
670: p_event.event_name);
671: raise;
672:
673: end;

Line 701: update wf_events

697: null;
698: end;
699: end if;
700: -- Update all events and subscriptions with owner tag to product code
701: update wf_events
702: set licensed_flag = l_LicenseFlag
703: where owner_tag = p_OwnerTag;
704:
705: update wf_event_subscriptions

Line 705: update wf_event_subscriptions

701: update wf_events
702: set licensed_flag = l_LicenseFlag
703: where owner_tag = p_OwnerTag;
704:
705: update wf_event_subscriptions
706: set licensed_flag = l_LicenseFlag
707: where owner_tag = p_OwnerTag;
708:
709: end UpdateLicenseStatus;

Line 712: end WF_EVENT_FUNCTIONS_PKG;

708:
709: end UpdateLicenseStatus;
710:
711:
712: end WF_EVENT_FUNCTIONS_PKG;