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_GROUPS_PKG dependencies on WF_EVENT

Line 1: package body WF_EVENT_GROUPS_PKG as

1: package body WF_EVENT_GROUPS_PKG as
2: /* $Header: WFEVGRPB.pls 120.4 2011/03/04 14:13:36 skandepu ship $ */
3: m_table_name varchar2(255) := 'WF_EVENT_GROUPS';
4: m_package_version varchar2(30) := '1.0';
5: -----------------------------------------------------------------------------

Line 3: m_table_name varchar2(255) := 'WF_EVENT_GROUPS';

1: package body WF_EVENT_GROUPS_PKG as
2: /* $Header: WFEVGRPB.pls 120.4 2011/03/04 14:13:36 skandepu ship $ */
3: m_table_name varchar2(255) := 'WF_EVENT_GROUPS';
4: m_package_version varchar2(30) := '1.0';
5: -----------------------------------------------------------------------------
6: procedure INSERT_ROW (
7: X_ROWID in out nocopy varchar2,

Line 12: from wf_event_groups

8: X_GROUP_GUID in raw,
9: X_MEMBER_GUID in raw
10: ) is
11: cursor C is select rowid
12: from wf_event_groups
13: where group_guid = X_GROUP_GUID
14: and member_guid = X_MEMBER_GUID;
15: begin
16: insert into wf_event_groups (

Line 16: insert into wf_event_groups (

12: from wf_event_groups
13: where group_guid = X_GROUP_GUID
14: and member_guid = X_MEMBER_GUID;
15: begin
16: insert into wf_event_groups (
17: group_guid,
18: member_guid
19: ) values (
20: X_GROUP_GUID,

Line 30: wf_event.raise('oracle.apps.wf.event.group.create',x_group_guid||'/'||x_member_guid);

26: if (c%notfound) then
27: close c;
28: raise no_data_found;
29: else
30: wf_event.raise('oracle.apps.wf.event.group.create',x_group_guid||'/'||x_member_guid);
31: end if;
32: close c;
33:
34: exception

Line 36: wf_core.context('Wf_Event_Groups_Pkg', 'Insert_Row', x_group_guid, x_member_guid);

32: close c;
33:
34: exception
35: when others then
36: wf_core.context('Wf_Event_Groups_Pkg', 'Insert_Row', x_group_guid, x_member_guid);
37: raise;
38:
39: end INSERT_ROW;
40: -----------------------------------------------------------------------------

Line 46: update wf_event_groups set

42: X_GROUP_GUID in raw,
43: X_MEMBER_GUID in raw
44: ) is
45: begin
46: update wf_event_groups set
47: group_guid = X_GROUP_GUID,
48: member_guid = X_MEMBER_GUID
49: where group_guid = X_GROUP_GUID
50: and member_guid = X_MEMBER_GUID;

Line 55: wf_event.raise('oracle.apps.wf.event.group.update',x_group_guid||'/'||x_member_guid);

51:
52: if (sql%notfound) then
53: raise no_data_found;
54: else
55: wf_event.raise('oracle.apps.wf.event.group.update',x_group_guid||'/'||x_member_guid);
56: end if;
57:
58: exception
59: when others then

Line 60: wf_core.context('Wf_Event_Groups_Pkg', 'Update_Row', x_group_guid,

56: end if;
57:
58: exception
59: when others then
60: wf_core.context('Wf_Event_Groups_Pkg', 'Update_Row', x_group_guid,
61: x_member_guid);
62: raise;
63: end UPDATE_ROW;
64: -----------------------------------------------------------------------------

Line 71: WF_EVENT_GROUPS_PKG.UPDATE_ROW (

67: X_MEMBER_GUID in raw
68: ) is
69: row_id varchar2(64);
70: begin
71: WF_EVENT_GROUPS_PKG.UPDATE_ROW (
72: X_GROUP_GUID => X_GROUP_GUID,
73: X_MEMBER_GUID => X_MEMBER_GUID
74: );
75:

Line 79: WF_EVENT_GROUPS_PKG.INSERT_ROW(

75:
76: exception
77: when no_data_found then
78: wf_core.clear;
79: WF_EVENT_GROUPS_PKG.INSERT_ROW(
80: X_ROWID => row_id,
81: X_GROUP_GUID => X_GROUP_GUID,
82: X_MEMBER_GUID => X_MEMBER_GUID
83: );

Line 85: wf_core.context('Wf_Event_Groups_Pkg', 'Load_Row', x_group_guid,

81: X_GROUP_GUID => X_GROUP_GUID,
82: X_MEMBER_GUID => X_MEMBER_GUID
83: );
84: when others then
85: wf_core.context('Wf_Event_Groups_Pkg', 'Load_Row', x_group_guid,
86: x_member_guid);
87: raise;
88: end LOAD_ROW;
89: -----------------------------------------------------------------------------

Line 96: wf_event.raise('oracle.apps.wf.event.group.delete',x_group_guid||'/'||x_member_guid);

92: X_GROUP_GUID in raw,
93: X_MEMBER_GUID in raw
94: ) is
95: begin
96: wf_event.raise('oracle.apps.wf.event.group.delete',x_group_guid||'/'||x_member_guid);
97:
98: delete from wf_event_groups
99: where group_guid = X_GROUP_GUID
100: and member_guid = X_MEMBER_GUID;

Line 98: delete from wf_event_groups

94: ) is
95: begin
96: wf_event.raise('oracle.apps.wf.event.group.delete',x_group_guid||'/'||x_member_guid);
97:
98: delete from wf_event_groups
99: where group_guid = X_GROUP_GUID
100: and member_guid = X_MEMBER_GUID;
101:
102: if (sql%notfound) then

Line 108: wf_core.context('Wf_Event_Groups_Pkg', 'Delete_Row', x_group_guid,

104: end if;
105:
106: exception
107: when others then
108: wf_core.context('Wf_Event_Groups_Pkg', 'Delete_Row', x_group_guid,
109: x_member_guid);
110: raise;
111:
112: end DELETE_ROW;

Line 128: -- from wf_event_groups

124:
125: begin
126: -- select DISPLAY_NAME, DESCRIPTION
127: -- into l_display_name, l_description
128: -- from wf_event_groups
129: -- where group_guid = x_guid
130: -- and member_guid = x_member_guid;
131:
132: l_doc := xmldom.newDOMDocument;

Line 134: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);

130: -- and member_guid = x_member_guid;
131:
132: l_doc := xmldom.newDOMDocument;
133: l_root := xmldom.makeNode(l_doc);
134: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);
135: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
136: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
137: m_package_version);
138: l_node := wf_event_xml.newtag(l_doc, l_header, 'GROUP_GUID',

Line 135: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);

131:
132: l_doc := xmldom.newDOMDocument;
133: l_root := xmldom.makeNode(l_doc);
134: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);
135: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
136: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
137: m_package_version);
138: l_node := wf_event_xml.newtag(l_doc, l_header, 'GROUP_GUID',
139: rawtohex(x_GROUP_GUID));

Line 136: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,

132: l_doc := xmldom.newDOMDocument;
133: l_root := xmldom.makeNode(l_doc);
134: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);
135: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
136: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
137: m_package_version);
138: l_node := wf_event_xml.newtag(l_doc, l_header, 'GROUP_GUID',
139: rawtohex(x_GROUP_GUID));
140: l_node := wf_event_xml.newtag(l_doc, l_header, 'MEMBER_GUID',

Line 138: l_node := wf_event_xml.newtag(l_doc, l_header, 'GROUP_GUID',

134: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);
135: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
136: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
137: m_package_version);
138: l_node := wf_event_xml.newtag(l_doc, l_header, 'GROUP_GUID',
139: rawtohex(x_GROUP_GUID));
140: l_node := wf_event_xml.newtag(l_doc, l_header, 'MEMBER_GUID',
141: rawtohex(x_MEMBER_GUID));
142:

Line 140: l_node := wf_event_xml.newtag(l_doc, l_header, 'MEMBER_GUID',

136: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
137: m_package_version);
138: l_node := wf_event_xml.newtag(l_doc, l_header, 'GROUP_GUID',
139: rawtohex(x_GROUP_GUID));
140: l_node := wf_event_xml.newtag(l_doc, l_header, 'MEMBER_GUID',
141: rawtohex(x_MEMBER_GUID));
142:
143: xmldom.writeToBuffer(l_root, buf);
144: return buf;

Line 149: wf_core.context('Wf_Event_Groups_Pkg', 'Generate', x_group_guid,

145:
146: null;
147: exception
148: when others then
149: wf_core.context('Wf_Event_Groups_Pkg', 'Generate', x_group_guid,
150: x_member_guid);
151: raise;
152: end GENERATE;
153: -----------------------------------------------------------------------------

Line 159: from WF_EVENTS

155: X_ERROR out nocopy varchar2)is
156: event_count number;
157: begin
158: Select 1 into event_count
159: from WF_EVENTS
160: where guid=X_MEMBER_GUID;
161: exception
162: when no_data_found then
163: x_error:='NON_EXIST_EVENT:'||X_MEMBER_GUID;

Line 165: wf_core.context('Wf_Event_Groups_Pkg', 'Check_Event', x_member_guid);

161: exception
162: when no_data_found then
163: x_error:='NON_EXIST_EVENT:'||X_MEMBER_GUID;
164: when others then
165: wf_core.context('Wf_Event_Groups_Pkg', 'Check_Event', x_member_guid);
166: raise;
167: end CHECK_EVENT;
168: -----------------------------------------------------------------------------
169: procedure RECEIVE2 (

Line 188: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetGUID(l_message); -- update #NEW

184: l_event_name varchar2(255);
185:
186: begin
187: l_message := x_message;
188: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetGUID(l_message); -- update #NEW
189: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSYSTEMGUID(l_message); -- update #LOCAL
190: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSID(l_message); -- update #SID
191:
192: l_node_list := wf_event_xml.findTable(l_message, m_table_name);

Line 189: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSYSTEMGUID(l_message); -- update #LOCAL

185:
186: begin
187: l_message := x_message;
188: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetGUID(l_message); -- update #NEW
189: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSYSTEMGUID(l_message); -- update #LOCAL
190: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSID(l_message); -- update #SID
191:
192: l_node_list := wf_event_xml.findTable(l_message, m_table_name);
193: l_length := xmldom.getLength(l_node_list);

Line 190: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSID(l_message); -- update #SID

186: begin
187: l_message := x_message;
188: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetGUID(l_message); -- update #NEW
189: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSYSTEMGUID(l_message); -- update #LOCAL
190: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSID(l_message); -- update #SID
191:
192: l_node_list := wf_event_xml.findTable(l_message, m_table_name);
193: l_length := xmldom.getLength(l_node_list);
194:

Line 192: l_node_list := wf_event_xml.findTable(l_message, m_table_name);

188: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetGUID(l_message); -- update #NEW
189: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSYSTEMGUID(l_message); -- update #LOCAL
190: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSID(l_message); -- update #SID
191:
192: l_node_list := wf_event_xml.findTable(l_message, m_table_name);
193: l_length := xmldom.getLength(l_node_list);
194:
195: -- loop through elements that we received.
196: for i in 0..l_length-1 loop

Line 212: -- Bug 10394616: Throwing WF error 'WF_EVENTGROUP_NOTEXISTS' instead of

208: elsif(l_node_name = 'MEMBER_GUID') then
209: l_member_guid := l_value;
210: elsif(l_node_name = 'GROUP_NAME') then
211:
212: -- Bug 10394616: Throwing WF error 'WF_EVENTGROUP_NOTEXISTS' instead of
213: -- NO_DATA_FOUND error as it will be easy to understand the error for the user
214: begin
215: select guid
216: into l_group_guid

Line 217: from wf_events

213: -- NO_DATA_FOUND error as it will be easy to understand the error for the user
214: begin
215: select guid
216: into l_group_guid
217: from wf_events
218: where name = l_value
219: and type = 'GROUP';
220: exception
221: when NO_DATA_FOUND then

Line 244: Wf_Core.Raise('WF_EVENTGROUP_NOTEXISTS');

240: end if;
241:
242: Wf_Core.Token('GROUP', l_value);
243: Wf_Core.Token('EVENT', l_event_name);
244: Wf_Core.Raise('WF_EVENTGROUP_NOTEXISTS');
245: end;
246: elsif(l_node_name = 'MEMBER_NAME') then
247: select guid
248: into l_member_guid

Line 249: from wf_events

245: end;
246: elsif(l_node_name = 'MEMBER_NAME') then
247: select guid
248: into l_member_guid
249: from wf_events
250: where name = l_value;
251:
252: l_event_name := l_value;
253: elsif(l_node_name = wf_event_xml.versionTagName) then

Line 253: elsif(l_node_name = wf_event_xml.versionTagName) then

249: from wf_events
250: where name = l_value;
251:
252: l_event_name := l_value;
253: elsif(l_node_name = wf_event_xml.versionTagName) then
254: l_version := l_value;
255: else
256: Wf_Core.Token('REASON', 'Invalid column name found:' ||
257: l_node_name || ' with value:'||l_value);

Line 262: wf_event_groups_pkg.check_event(l_member_guid,x_error);

258: Wf_Core.Raise('WFSQL_INTERNAL');
259: end if;
260: end loop;
261:
262: wf_event_groups_pkg.check_event(l_member_guid,x_error);
263:
264: wf_event_groups_pkg.load_row(
265: X_GROUP_GUID => l_group_guid,
266: X_MEMBER_GUID => l_member_guid

Line 264: wf_event_groups_pkg.load_row(

260: end loop;
261:
262: wf_event_groups_pkg.check_event(l_member_guid,x_error);
263:
264: wf_event_groups_pkg.load_row(
265: X_GROUP_GUID => l_group_guid,
266: X_MEMBER_GUID => l_member_guid
267: );
268:

Line 271: wf_core.context('Wf_Event_Groups_Pkg', 'Receive', x_message);

267: );
268:
269: exception
270: when others then
271: wf_core.context('Wf_Event_Groups_Pkg', 'Receive', x_message);
272: raise;
273: end RECEIVE2;
274:
275: -----------------------------------------------------------------------------

Line 298: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);

294: begin
295:
296: l_doc := xmldom.newDOMDocument;
297: l_root := xmldom.makeNode(l_doc);
298: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);
299: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
300: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
301: m_package_version);
302: l_node := wf_event_xml.newtag(l_doc, l_header, 'GROUP_NAME', x_group_name);

Line 299: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);

295:
296: l_doc := xmldom.newDOMDocument;
297: l_root := xmldom.makeNode(l_doc);
298: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);
299: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
300: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
301: m_package_version);
302: l_node := wf_event_xml.newtag(l_doc, l_header, 'GROUP_NAME', x_group_name);
303: l_node := wf_event_xml.newtag(l_doc, l_header, 'MEMBER_NAME', x_member_name);

Line 300: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,

296: l_doc := xmldom.newDOMDocument;
297: l_root := xmldom.makeNode(l_doc);
298: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);
299: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
300: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
301: m_package_version);
302: l_node := wf_event_xml.newtag(l_doc, l_header, 'GROUP_NAME', x_group_name);
303: l_node := wf_event_xml.newtag(l_doc, l_header, 'MEMBER_NAME', x_member_name);
304:

Line 302: l_node := wf_event_xml.newtag(l_doc, l_header, 'GROUP_NAME', x_group_name);

298: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);
299: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
300: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
301: m_package_version);
302: l_node := wf_event_xml.newtag(l_doc, l_header, 'GROUP_NAME', x_group_name);
303: l_node := wf_event_xml.newtag(l_doc, l_header, 'MEMBER_NAME', x_member_name);
304:
305: xmldom.writeToBuffer(l_root, buf);
306: return buf;

Line 303: l_node := wf_event_xml.newtag(l_doc, l_header, 'MEMBER_NAME', x_member_name);

299: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
300: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
301: m_package_version);
302: l_node := wf_event_xml.newtag(l_doc, l_header, 'GROUP_NAME', x_group_name);
303: l_node := wf_event_xml.newtag(l_doc, l_header, 'MEMBER_NAME', x_member_name);
304:
305: xmldom.writeToBuffer(l_root, buf);
306: return buf;
307:

Line 311: wf_core.context('Wf_Event_Groups_Pkg', 'Generate2', x_group_name,

307:
308: null;
309: exception
310: when others then
311: wf_core.context('Wf_Event_Groups_Pkg', 'Generate2', x_group_name,
312: x_member_name);
313: raise;
314: end GENERATE2;
315:

Line 316: end WF_EVENT_GROUPS_PKG;

312: x_member_name);
313: raise;
314: end GENERATE2;
315:
316: end WF_EVENT_GROUPS_PKG;