APPS.WF_EVENT_GROUPS_PKG dependencies on WF_EVENT_GROUPS

Line 1: package body WF_EVENT_GROUPS_PKG as

1: package body WF_EVENT_GROUPS_PKG as
2: /* $Header: WFEVGRPB.pls 120.3 2005/10/19 05:25:49 vshanmug 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.3 2005/10/19 05:25:49 vshanmug 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 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 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 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 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 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 228: wf_event_groups_pkg.check_event(l_member_guid,x_error);

224: Wf_Core.Raise('WFSQL_INTERNAL');
225: end if;
226: end loop;
227:
228: wf_event_groups_pkg.check_event(l_member_guid,x_error);
229:
230: wf_event_groups_pkg.load_row(
231: X_GROUP_GUID => l_group_guid,
232: X_MEMBER_GUID => l_member_guid

Line 230: wf_event_groups_pkg.load_row(

226: end loop;
227:
228: wf_event_groups_pkg.check_event(l_member_guid,x_error);
229:
230: wf_event_groups_pkg.load_row(
231: X_GROUP_GUID => l_group_guid,
232: X_MEMBER_GUID => l_member_guid
233: );
234:

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

233: );
234:
235: exception
236: when others then
237: wf_core.context('Wf_Event_Groups_Pkg', 'Receive', x_message);
238: raise;
239: end RECEIVE2;
240:
241: -----------------------------------------------------------------------------

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

273:
274: null;
275: exception
276: when others then
277: wf_core.context('Wf_Event_Groups_Pkg', 'Generate2', x_group_name,
278: x_member_name);
279: raise;
280: end GENERATE2;
281:

Line 282: end WF_EVENT_GROUPS_PKG;

278: x_member_name);
279: raise;
280: end GENERATE2;
281:
282: end WF_EVENT_GROUPS_PKG;