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.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 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 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 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;